Comprehensive data protection for all workloads
Post Reply
mrt
Enthusiast
Posts: 53
Liked: 2 times
Joined: Feb 10, 2011 7:27 pm
Contact:

Enterprise Manager 6.5 upgrade problems

Post by mrt »

support case 00154535

During the upgrade from 6.1 to 6.5 an error was encountered:

Code: Select all

Error 27506.Error executing SQL script ReportingDBupdate.sql. Line 2695. Query timeout expired (0)
Has anyone seen this before? EM is now uninstalled and if i restart the installer, it asks for a key which tells me a new installation is being performed, not an upgrade, so i stopped it.

When creating the ticket, i wasn't given the option to file it under Enterprise Manager; maybe someone can move it to a queue that is more appropriate. Thanks
Gostev
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by Gostev »

Thanks for including support case ID for future reference. This issue has not been reported before, so I have no idea what this might be caused by... but, since you are saying EM is already uninstalled - why not just perform a new install?
jlsung
Influencer
Posts: 21
Liked: never
Joined: Sep 15, 2011 1:41 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by jlsung »

Same issue. Some solutions ?
mrt
Enthusiast
Posts: 53
Liked: 2 times
Joined: Feb 10, 2011 7:27 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by mrt »

jlsung wrote:Same issue. Some solutions ?
i went ahead with the reinstall and it seems to have worked. no data was lost. support said they are looking into why it happens.
homerjnick
Expert
Posts: 212
Liked: 35 times
Joined: Feb 20, 2012 4:13 pm
Full Name: Nick Mahlitz
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by homerjnick »

I had this exact same issue...uninstalling and reinstalling did nothing as it is failing at the upgrade SQL database section and no matter whether you are installing or upgrading it still detects an existing database and fails to upgrade it.

What I had to do, at supports request, was rename the SQL database and recreate it during the Enterprise Manager install...

I was told that they are researching why it doesn't upgrade...
jlsung
Influencer
Posts: 21
Liked: never
Joined: Sep 15, 2011 1:41 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by jlsung »

I 've made a new installation with the old database to keep data but the error occurs again. :(
homerjnick wrote:I had this exact same issue...uninstalling and reinstalling did nothing as it is failing at the upgrade SQL database section and no matter whether you are installing or upgrading it still detects an existing database and fails to upgrade it.

What I had to do, at supports request, was rename the SQL database and recreate it during the Enterprise Manager install...

I was told that they are researching why it doesn't upgrade...
Ok, I'll try
homerjnick
Expert
Posts: 212
Liked: 35 times
Joined: Feb 20, 2012 4:13 pm
Full Name: Nick Mahlitz
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by homerjnick »

Hang on...you need to read this: http://www.veeam.com/KB1109
Cokovic
Veteran
Posts: 295
Liked: 59 times
Joined: Sep 06, 2011 8:45 am
Full Name: Haris Cokovic
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by Cokovic »

Is this a local or a remote database?

If it's a remote database did you check the appropriate rights on it? In my case every upgrade error that occured during the sql update were security related when using a remote db.
homerjnick
Expert
Posts: 212
Liked: 35 times
Joined: Feb 20, 2012 4:13 pm
Full Name: Nick Mahlitz
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by homerjnick »

Local or Remote doesn't matter in as much as it is rights that are important as you correctly state...what you do need is db_owner permission set against the account you are using for Enterprise Manager database...
jlsung
Influencer
Posts: 21
Liked: never
Joined: Sep 15, 2011 1:41 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by jlsung »

There is no folder "Veeam Backup Reporting" in HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\
I have renamed database but I still have an error. I'll open a case
babarc
Influencer
Posts: 11
Liked: never
Joined: Dec 07, 2011 4:41 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by babarc »

Hello, I have the same issue..... any news?
Thanks
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by Vitaliy S. »

Hello Paolo,

I cannot locate jlsung ticket number in our support tracking system, but based on the OPs case and similar issues reported to our support team, the solution was either to re-install EM or use the KB article mentioned above. Anyway, it's better to check the current state of this issue with our support team directly.

Thank you!
babarc
Influencer
Posts: 11
Liked: never
Joined: Dec 07, 2011 4:41 pm
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by babarc »

I read the KB but there is not key with this name, and in the KB i see that it is valid only for version 5
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by foggy »

I assume you just need to create this key manually, but still better check with support.
aschwalbe
Lurker
Posts: 1
Liked: 1 time
Joined: Jan 25, 2013 7:37 pm
Full Name: Andrew Schwalbe
Contact:

Re: Enterprise Manager 6.5 upgrade problems

Post by aschwalbe » 1 person likes this post

I had the same problem except my error was on Line 2641. This was followed by another error in a window titled "VmaRegisterWMISvc" with the error stating "The system cannnot find the file specified." I also noticed that after this error occured, although my VeeamBackupReporting database was still present, the shortcut to Enterprise Manager on the desktop was gone, as were all the registery settings related to VeeamBackupReporting. I tried manually adding the registry setting and running the install, same problem. Furthermore, it seemed to be completely removed as the installer now asked me for my license key file (the first time I attempted the upgrade, it was auto detected that the software was already installed). It was also gone from add/remove programs.

My ultimate workaround was to detach the VeeamBackupReporting database from SQL and rename the MDF and LDF files - only for keeping a backup - I will probably delete the files in a week or two. I then ran the installer again and allowed it to create a brand new database. Once installed, I just had to add my backup server again and a few other minor configurations and now I'm back in business. Biggest downside is I lost any historical data that was in the old database, but I'm ok with this.
Post Reply

Who is online

Users browsing this forum: Google [Bot], Semrush [Bot] and 150 guests