Migration from Windows Vcenter 6.5U2 to VCSA6.7 fails

[TomasAZ01]

Hi!

I am trying to migrate our Windows based Vcenter 6.5U2 to VCSA6.7 but it fails with the following error messages. Searching others with similar issues it often deals with lookups and reverse lookups on the vcenter server name but i have checked this and it works as it should.
Running it again it always fails on 41% with the "A problem occured while - Exporting VMware vCenter Server Database data...".

Help is appreciated.

[andiwe79]

What size is the DB? Did you try configuration only when migrating, if not try exclude the events and performance data.

Maybe you need to shrink before. VMware Knowledge Base

Best regards

[asajm]

Hi TomasAZ01

Please attach logs to this thread

[TomasAZ01]

Attached logs to this message.

[TomasAZ01]

I tried configuration only.

6,8 GB.

[johncol · Accepted solution]

I had a quick look here -

2019-04-17T07:27:28.3Z INFO vcdb.const total_core_size: 2439 MB, export time: 365 sec, SQLite size: 1341 MB, importTime: 1408 sec

2019-04-17T07:27:28.3Z INFO vcdb.const total_set_size: 1388 MB, export time: 126 sec, SQLite size: 428 MB, importTime: 1751 sec

2019-04-17T07:27:28.3Z INFO vcdb.const total_et_size: 55  MB, export time: 7 sec, SQLite size: 18 MB, importTime: 21 sec

2019-04-17T07:27:28.3Z INFO vcdb.const Estimates completed.

2019-04-17T07:27:28.9Z INFO vcdb.const MSSQL with Windows Authentication.

2019-04-17T07:27:28.9Z INFO vcdb.const Pass MSSQL Win Auth(vcdbWinAuth): True

authentication is winauth (integrated auth), it tries to read an entry, as follows, in the registry

2019-04-17T07:21:03.387Z INFO upgrade.states.component_states vcdb:CollectRequirements: 2019-04-17T07:21:03.171Z ERROR transport.local NOT FOUND: Cannot read registry. Error: [Error 2] The system cannot find the file specified

2019-04-17T07:27:14.326Z INFO vcdb.const Configuring log folder paths in C:\Users\ADMINI~1.LS\AppData\Local\Temp\vcsMigration

2019-04-17T07:27:14.326Z INFO vcdb.const Python 2

2019-04-17T07:27:14.326Z INFO vcdb.const Retrieving DB type...

2019-04-17T07:27:14.335Z INFO vcdb.const Retrived DB type: mssql

2019-04-17T07:27:14.339Z INFO vcdb.const Getting vCenter Server DSN...

2019-04-17T07:27:14.342Z INFO vcdb.const vCenter Server uses DSN: vmwareodbc64bit

2019-04-17T07:27:14.345Z INFO vcdb.const DB user retrieved: jarvc01

2019-04-17T07:27:14.351Z INFO vcdb.const MSSQL with Windows Authentication.

I am wondering is there something funky with that user,/password ( does it has non ascii special characters etc )  whats in the vcdb properties file, its in C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx - you can redact the fqdn etc etc

[TomasAZ01]

Thanks a  lot, it helped to change the db password, it was a . in the password which the migrate assistant couldn´t handle.

[johncol]

Good to hear