TomasAZ01
Contributor
Contributor

Migration from Windows Vcenter 6.5U2 to VCSA6.7 fails

Jump to solution

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.

1.png

2.png

0 Kudos
1 Solution

Accepted Solutions
johncol
VMware Employee
VMware Employee

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

View solution in original post

0 Kudos
7 Replies
andiwe79
Enthusiast
Enthusiast

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

0 Kudos
asajm
Expert
Expert

Hi TomasAZ01

Please attach logs to this thread

If you think your queries have been answered
Marking this response as "Solution " or "Kudo"
ASAJM
0 Kudos
TomasAZ01
Contributor
Contributor

Attached logs to this message.

0 Kudos
TomasAZ01
Contributor
Contributor

I tried configuration only.

6,8 GB.

0 Kudos
johncol
VMware Employee
VMware Employee

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

View solution in original post

0 Kudos
TomasAZ01
Contributor
Contributor

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

0 Kudos
johncol
VMware Employee
VMware Employee

Good to hear Smiley Happy

0 Kudos