Unable to truncate transaction logs.

Availability for the Always-On Enterprise

Re: Unable to truncate transaction logs.

Veeam Logoby rkovhaev » Fri Mar 24, 2017 6:19 pm

phil.p wrote:Turns out the OLE DB Provider doesn't support TLS1.1 or 1.2
Code = 0x80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

hopefully Veeam will move to a newer provider with support for TLS1.2 in the future.

In version 9.5 we already implemented logic that uses native sql client provider and tls 1.2 works.
There is a reg key for that new logic - feel free to contact support.
rkovhaev
Veeam Software
 
Posts: 35
Liked: 12 times
Joined: Mon May 17, 2010 6:49 pm
Location: hockey night in canada
Full Name: Rustam

[MERGED] Case # 02125618 Unable to truncate Microsoft SQL Se

Veeam Logoby anil.kukkunuru » Wed Apr 12, 2017 6:37 pm

Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: . See guest helper log.
Sometimes the backups fails, and sometime it comes with a warning. Can you guys help me to figure out the possible solution to resolve this warning. :roll: :?:

Thanks
anil.kukkunuru
Novice
 
Posts: 5
Liked: never
Joined: Wed Mar 29, 2017 12:59 pm
Full Name: Anil Kukkunuru

Re: Case # 02125618 Unable to truncate Microsoft SQL Server

Veeam Logoby Mike Resseler » Thu Apr 13, 2017 5:13 am

Hi Anil,

Welcome to the forums!

Unfortunately, with this type of warning we can start guessing and give you some things you need to check but it might be difficult to find the root cause without all the logs needed. Since you have a case ID, please keep working with our support engineers and let us know the results after the investigation.

From what I see above, my gut feeling tells me you should look at the SQL server itself and look at events over there. It seems that SQL server sometimes has issues truncating (that is what we do, we instruct SQL server to truncate) which could be for various reasons. So starting your investigation over there would be my first thing.

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 4265
Liked: 477 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Unable to truncate transaction logs.

Veeam Logoby anil.kukkunuru » Thu Apr 13, 2017 1:06 pm

Hi Mike,
Thank you for the update, we truncated the logs on SQL server and still we got the same error.
Yesterday, the job failed with the below errors
4/12/2017 7:35:17 PM :: Failed to prepare guest for hot backup. Error: VSSControl: Failed to prepare guest for freeze, wait timeout 1800 sec
4/12/2017 8:06:58 PM :: Error: VSSControl: Failed to prepare guest for freeze, wait timeout 1800 sec
4/12/2017 8:06:58 PM :: Processing finished with errors at 4/12/2017 8:06:58 PM
anil.kukkunuru
Novice
 
Posts: 5
Liked: never
Joined: Wed Mar 29, 2017 12:59 pm
Full Name: Anil Kukkunuru

Re: Unable to truncate transaction logs.

Veeam Logoby foggy » Thu Apr 13, 2017 2:36 pm

This one is not related to logs truncation, but a general VSS issue. Please investigate with support.
foggy
Veeam Software
 
Posts: 16283
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] Back-up job Warning

Veeam Logoby flaviu.gherman » Thu Jun 08, 2017 8:22 am

hello,
this is my warning on my back-up job details

" Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: . See guest helper log."

can anyone give me some ideas to resolve the warning ?

THX!
flaviu.gherman
Lurker
 
Posts: 1
Liked: never
Joined: Thu Jun 08, 2017 7:02 am
Full Name: Gherman Flaviu Mihai

Re: Back-up job Warning

Veeam Logoby CarlMcDade » Thu Jun 08, 2017 10:19 am

Normally this kind of error is permission based. Make sure the account used to truncate the logs has the correct permissions

if you raise a ticket with Veeam support, and export the job logs, they should be able to give you an answer very quick

Cheers
mail@carlmcdade.com
http://twitter.com/CarlMcDade
http://www.carlmcdade.com
CarlMcDade
Service Provider
 
Posts: 60
Liked: 20 times
Joined: Mon Jul 08, 2013 1:47 pm
Location: Leeds, UK
Full Name: Carl McDade

Re: Unable to truncate transaction logs.

Veeam Logoby foggy » Thu Jun 08, 2017 10:52 am

Hi Gherman, you can also review this thread for other possible reasons of this issue.
foggy
Veeam Software
 
Posts: 16283
Liked: 1302 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Unable to truncate transaction logs.

Veeam Logoby Matt@ManSol » Tue Jan 23, 2018 12:52 am

We are also seeing this error throughout our environment. Sometimes the job completes successfully, and sometimes with the warning:

"Failed to truncate Microsoft SQL Server transaction logs. Details: Failed to call RPC function 'Vss.TruncateSqlLogs': Error code: 0x800401fd. Failed to invoke func [TruncateSqlLogs]: Object is not connected to server."

We opened a support case, but the result was not conclusive. It was thought that the issue was caused by Antivirus blocking something. However this doesn't make sense, since the job completes successfully as well. You would think that if the AV was causing the problem that it would occur every time the job is run?

We also noted that the windows service "VeeamVssSupport" exists and is running from folder C:\Windows\VeeamVSSSupport. Volume Shadow Copy service is running.

The logs seem to indicate that the job is completing successfully, but for some reason the job is unable to perform the 'cleanup' of the service and folders which are normally removed when the job completes.
Matt@ManSol
Novice
 
Posts: 3
Liked: never
Joined: Wed May 24, 2017 5:27 am

Re: Unable to truncate transaction logs.

Veeam Logoby Radioman01 » Mon Feb 05, 2018 6:49 pm

In version 9.5 we already implemented logic that uses native sql client provider and tls 1.2 works.
There is a reg key for that new logic - feel free to contact support.


Can you please send me the registry entry? I am running into this issue in our environment.

Thanks!
Radioman01
Lurker
 
Posts: 2
Liked: never
Joined: Mon Feb 05, 2018 6:46 pm

Re: Unable to truncate transaction logs.

Veeam Logoby Mike Resseler » Tue Feb 06, 2018 6:06 am

Hi Radioman01,

First: Welcome to the forums
Second: Are you suffering the above issue from Matt? (This is a rather long thread so ;-)). If so, please contact support as said above. They will be able to help you out (after looking if it is indeed the same issue)

Thanks
Mike
Mike Resseler
Veeam Software
 
Posts: 4265
Liked: 477 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Unable to truncate transaction logs.

Veeam Logoby Radioman01 » Tue Feb 06, 2018 2:57 pm

I am having the exact same issue has "phil.p". I have TLS 1.0 and 1.1 disabled, only enabling TLS 1.2 for testing PCI compliance. When I do that, the SQL databases show the " [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error." error in the Veeam Agent log and truncation fails. We are testing this in a development environment to evaluate Veeam to replace our existing system so we do not have a support contract. Is there a way to open a ticket without one?
Radioman01
Lurker
 
Posts: 2
Liked: never
Joined: Mon Feb 05, 2018 6:46 pm

Re: Unable to truncate transaction logs.

Veeam Logoby Mike Resseler » Wed Feb 07, 2018 6:12 am

Yes. Even within evaluation you can open a support ticket.

Are you working together with a Veeam representative during the evaluation? Otherwise you can ask him/ her for assistance also if needed
Mike Resseler
Veeam Software
 
Posts: 4265
Liked: 477 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Previous

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 33 guests