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.
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
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
Hi TomasAZ01
Please attach logs to this thread
I tried configuration only.
6,8 GB.
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
Thanks a lot, it helped to change the db password, it was a . in the password which the migrate assistant couldn´t handle.
Good to hear