Notes: Current Windows vCenter 6.0 DB connection (using external SQL-01) failed due to the db connection account (vcenter-sql). The password needs to be reset or move the vcenter db connection to use the shdba2. I will open an emergency maintenance on 9/17 to update the vcenter db account and vcenter upgrade if there’s time.
Upgrade not completed....Worked w/ VMware support to troubleshoot the export vcdb issue. I've upload the bundle log and they will examine the issue. The vcenter 6.0 windows VM are still in production. I will wait for VMware support response and will check if there's a resolution.
I've tried to search for the vcenter-sql (account details) for the vcdb. It seems when this vcenter windows VM was built and connected to sql-01-nyc (external db), this is the account that has been used for DSN. I'm unable to locate the password for this account so I can do a connection test from vcenter 6.0 windows VM to sql-01.
VMware Support Request # 20155074909
===================================================
Trimmed error logs
===================================================
020-09-12T01:44:46.229Z INFO vcdb.const VCDB: external 2020-09-12T01:44:46.230Z INFO vcdb.const Database is external. Migrate to VCSA 6.5.
2020-09-12T01:44:46.256Z INFO vcdb.const User option to migrate tables: core 2020-09-12T01:44:46.256Z INFO vcdb.const Make sure services are in correct state...
2020-09-12T01:44:46.256Z INFO vcdb.const Services statuses updated where necessary.
2020-09-12T01:44:46.263Z INFO vcdb.const Retrieving DB type...
2020-09-12T01:44:46.267Z INFO vcdb.const Retrieved DB type: mssql 2020-09-12T01:44:46.276Z INFO vcdb.const Getting vCenter Server DSN...
2020-09-12T01:44:46.279Z INFO vcdb.const vCenter Server uses DSN: vCenter 2020-09-12T01:44:46.279Z INFO vcdb.const Retrieving DB user...
2020-09-12T01:44:46.282Z INFO vcdb.const DB user retrieved: vcenter-sql 2020-09-12T01:44:46.290Z INFO vcdb.const Retrieving DB password...
2020-09-12T01:44:46.368Z INFO vcdb.const DB password retrieved: **** 2020-09-12T01:44:46.377Z INFO vcdb.const Getting Database name...
2020-09-12T01:44:46.381Z INFO vcdb.const DB name retrieved: vcenter-01-nyc01 2020-09-12T01:44:46.388Z INFO vcdb.const Getting Database Server name...
2020-09-12T01:44:46.398Z INFO vcdb.const DB port retrieved:
2020-09-12T01:44:46.398Z INFO vcdb.const DB Instance retrieved:
2020-09-12T01:44:46.398Z INFO vcdb.const DB ServerName retrieved: SQL-01A 2020-09-12T01:44:46.405Z INFO vcdb.const Calculating export times...
2020-09-12T01:44:46.582Z ERROR __main__ Upgrade Phase 'vcdb:Export' failed. Exception: local variable 'timeImpSet' referenced before assignment Traceback (most recent call last):
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\componentPhaseLauncher.py", line 438, in main
executionResult = systemExtension(exeContext)
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\libs\sdk\extensions.py", line 94, in __call__
result = self.extension(*args)
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\libs\sdk\extensions.py", line 110, in _func
return func(*args)
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\__init__.py", line 37, in do_source_export
do_windows_export(context)
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\vcdb_export_windows_functions.py", line 773, in do_windows_export
do_windows_export_external_db(context,sourceVer)
File "C:\migE3BE.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\vcdb_export_windows_functions.py", line 489, in do_windows_export_external_db
timeImpSet = timeImpSet + (dbSizeStat/100)*7
UnboundLocalError: local variable 'timeImpSet' referenced before assignment
(END)