Discussions specific to the VMware vSphere hypervisor
Post Reply
gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » Mar 15, 2018 9:49 am

Hi All,

Hope you are doing well..!!
Today we got new error for SQL TLOG Backup on one of the server.
Error is: "Sequence contains no elements"
"Transaction logs for the following databases were not backed up: master;model;msdb;dbm;informatica961_prod_audit;informatica961_prod_domain;informatica961_prod_hts;informatica961_prod_mmbg;informatica961_prod_mrs;informatica961_prod_rdl;informatica961_prod_rep1;informatica961_prod_rep2"

Please help me if any one has idea about this error.


Thanks,
Vijay G

gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » Mar 15, 2018 9:51 am

Please help

nielsengelen
Veeam Software
Posts: 2705
Liked: 566 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by nielsengelen » Mar 15, 2018 9:55 am

Did the backups work fine before on these databases? If it worked fine I would advise to open a support call to see why this happened.
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be

gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » Apr 05, 2018 1:21 pm 2 people like this post

Yeah. it was resolved.
There was a bug with 9.5 version update 3.
We have installed hotfox on this version. after that issue was fixed.

Thanks,
Vijay G

btanguay
Influencer
Posts: 18
Liked: 2 times
Joined: Nov 28, 2014 6:58 pm
Full Name: Benoit Tanguay
Location: Boucherville, QC, Canada
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by btanguay » Apr 30, 2018 1:35 pm

Can you provide the hotfix number and/or your support call number for reference?
I'm having the same issue just after upgrading to update 3.
Benoit.

veremin
Product Manager
Posts: 17017
Liked: 1462 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by veremin » May 01, 2018 2:04 pm

Shared the case ID via PM. Check your inbox. Thanks.

spawnxx
Lurker
Posts: 1
Liked: never
Joined: May 03, 2018 12:43 pm
Full Name: Pascal
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by spawnxx » May 03, 2018 7:05 pm

Hi, I have the exact same problem. Everything was working properly for the last few weeks. What is the solution for this please?

hongt2k
Lurker
Posts: 2
Liked: never
Joined: May 09, 2018 7:35 pm
Full Name: Tony
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by hongt2k » May 09, 2018 7:38 pm

What is the hotfix for this issue? I am experiencing the same problem.

foggy
Veeam Software
Posts: 18383
Liked: 1580 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by foggy » May 10, 2018 2:12 pm

Guys, please contact technical support directly to verify the issue and get the hotfix. Thanks.

gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » May 28, 2018 2:31 am 1 person likes this post

thong@qcc.cuny.edu wrote:Thank you for contacting Veeam Support.
As we discussed on the phone, the behaviour is a known issue according to the information you have provided.

Please download the hotfix from the link as below,
https://storage.veeam.com/Fix_126232_aae5af2cc4.zip

and follow the direction as below, (Do NOT skip any steps as it may need to go back to the original dll some cases)

1. Stop Veeam service
Get-Service veeam* | Stop-Service

2. Rename the original Veeam.Backup.Core.dll in C:\Program Files\Veeam\Backup & Replication\Backup
Rename-Item -Path "C:\Program Files\Veeam\Backup and Replication\Backup\Veeam.Backup.Core.dll" -NewName "Veeam.Backup.Core.dll_orig"

3. Replace Veeam.Backup.Core.dll from the fix;

4. Start Veeam service
Get-Service veeam* | Start-Service

Please let us know how you go.

MrMegaVadim
Novice
Posts: 6
Liked: 2 times
Joined: Jun 27, 2016 1:48 pm
Full Name: Vadim
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by MrMegaVadim » Jun 28, 2018 6:07 pm

AMASING SOLUTION

WORKED LIKE A CHARM AS IT IS !!!

channdeep
Lurker
Posts: 2
Liked: 2 times
Joined: Feb 17, 2018 7:40 pm
Full Name: Channdeep Singh
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by channdeep » Nov 30, 2018 9:08 am 1 person likes this post

TLOG backups worked for me also after installing this hotfix. Thanks a lot.

Armonea
Lurker
Posts: 2
Liked: never
Joined: Aug 10, 2017 1:01 pm
Full Name: Armonea Support
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by Armonea » Oct 22, 2019 9:28 am

Applying this fix caused the service start to fail.
Did not work anymore => no fix for me...

wishr
Veeam Software
Posts: 1260
Liked: 122 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by wishr » Oct 22, 2019 10:46 am

Hi Armonia,

In this case, please raise a support case and work with our engineers directly to get it fully resolved.

Thanks

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 35 guests