Skip navigation
VMware

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
1,068 Views 10 Replies Last post: Aug 11, 2011 11:07 PM by gparker RSS
hbowlin Novice 19 posts since
Apr 26, 2006
Currently Being Moderated

Aug 19, 2010 8:39 AM

Error when running vSphere v4.1 Data Migration Script

 

I am trying to migrate my vCenter and database to vSphere v4.1, but when running the backup.bat script, I am getting the following error.

 

 

   

 

 

   Error when running vSphere v4.1 Data Migration Script  Msg 8114, Level 16, State 1, Server VCENTER\SQLEXP_VIM, Line 1

 

Error converting data type bigint to int.

 

Msg 3013, Level 16, State 1, Server VCENTER\SQLEXP_VIM, Line 1

 

RESTORE FILELIST is terminating abnormally.

 

 

  Error when running vSphere v4.1 Data Migration Script  Error: vCenter Server DB backup failed

  Error when running vSphere v4.1 Data Migration Script  Exiting...

 

 

 

 

 

Any ideas?

 

 

GReddy5 Lurker 1 posts since
Aug 16, 2010
Currently Being Moderated
1. Aug 19, 2010 11:41 AM in response to: hbowlin
Re: Error when running vSphere v4.1 Data Migration Script

Did you remember to stop the vCenter server service? Also if you are using windows 2008, make sure to run the command prompt "administrator" if you aren't log on as the local administrator.

hooch1964 Novice 19 posts since
May 6, 2010
Currently Being Moderated
3. Oct 5, 2010 3:42 AM in response to: hbowlin
Re: Error when running vSphere v4.1 Data Migration Script

Did you find a resolution to this issue?  I have exactly the same scenario here.

PhilMarsden Novice 19 posts since
Jan 15, 2008
Currently Being Moderated
4. Oct 6, 2010 10:18 AM in response to: hooch1964
Re: Error when running vSphere v4.1 Data Migration Script

I'm also having same problem - anyone got any ideas?

hooch1964 Novice 19 posts since
May 6, 2010
Currently Being Moderated
5. Oct 7, 2010 1:52 AM in response to: PhilMarsden
Re: Error when running vSphere v4.1 Data Migration Script

We eventually raised a support call on this.  The support guy said it was a known issue and that they are working to resolve it.  He did not have any details on the possible cause of the issue, but we have a hunch (our hunch, not VMware) that that it may be something to do with the database having been upgraded to 4.0 from the original 3.5 installation.

 

Although no fix was offered, we didn't need it - the data migration method was not applicable to our upgrade (vCenter 4.0, 32-bit on a physical server backed by SQL 2005 Express -> vCenter 4.1, 64-bit on a virtual server backed by SQL 2008 Standard).  We had to migrate the databases manually before running the 4.1 installer and pointing DSN to the new database.  We also had to manually copy the certificates from the old to the new server.

 

Although this does not answer the original problem, there is a way around it.

spaceboy20111… Lurker 1 posts since
Feb 12, 2011
Currently Being Moderated
6. Feb 12, 2011 5:07 PM in response to: PhilMarsden
Re: Error when running vSphere v4.1 Data Migration Script

Looks like VMWare guys think our databases are max int bytes long (2GB), so the db upgrade helper script vpx/db/dbrestore.sql defines the temporary table with

BackupSizeInBytes int null

I've changed it to bigint

BackupSizeInBytes bigint null

and my upgrade went a few steps further

 

Just wonder why this isn't fixed in VMware-VIMSetup-all-4.1.0-345042

dornfm94 Novice 10 posts since
Oct 29, 2009
Currently Being Moderated
7. Apr 1, 2011 1:59 PM in response to: hooch1964
Re: Error when running vSphere v4.1 Data Migration Script

hooch1964,

I actually have to perform the exact same upgrade.

(vCenter 4.0, 32-bit on a physical server backed by SQL 2005 Express -> vCenter 4.1, 64-bit on a virtual server backed by SQL 2008 Standard).

 

Could you possibly e-mail me your complete list of steps that worked for you?  dornfm94 -at- hotmail -dot- com.

 

Thank you,

Matt

moise7864 Lurker 1 posts since
Jul 16, 2007
Currently Being Moderated
8. Jun 1, 2011 3:03 AM in response to: spaceboy20111…
Re: Error when running vSphere v4.1 Data Migration Script

spaceboy wrote:

 

Looks like VMWare guys think our databases are max int bytes long (2GB), so the db upgrade helper script vpx/db/dbrestore.sql defines the temporary table with

BackupSizeInBytes int null

I've changed it to bigint

BackupSizeInBytes bigint null

and my upgrade went a few steps further

 

Just wonder why this isn't fixed in VMware-VIMSetup-all-4.1.0-345042

 

 

The above solution worked great for us.

 

1. Restoring a DB backup on the old host via SQLExpress tools (there is one in datamigration/data/vc/vc_source_orig_db if you forgot to make one).

2. Modify the dbrestore.sql as mentionned above.

3. Try the procedure again and everything should be fine.

 

Thanks!

PhilMarsden Novice 19 posts since
Jan 15, 2008
Currently Being Moderated
9. Jun 1, 2011 3:12 AM in response to: moise7864
Re: Error when running vSphere v4.1 Data Migration Script

Hi, I am out of the office, returning on Monday 6th June and will answer your query on my return.

gparker Enthusiast 99 posts since
May 26, 2007
Currently Being Moderated
10. Aug 11, 2011 11:07 PM in response to: moise7864
Re: Error when running vSphere v4.1 Data Migration Script

Hi all,

 

I just ran into exactly the same issue and found this discussion and followed moise7864's solution and it worked! :-)

 

I think that the moral to the story is that even though you might be running SQL-Express, you should still try doing some sort of DB maintanence plan and if your VCDB grows to > 2GB, migrate it to full-blown SQL Server.

 

George.

Bookmarked By (0)

Share This Page

Communities