baszek
Enthusiast
Enthusiast

Migration from Windows Vcenter 6.0u3j to VCSA6.7 u3f fails - db timeout ?

Jump to solution

Hi all,

I am trying to migrate windows vcenter 6.0u3j to vcsa 6.7 u3f. Migration process fails at 41% due to connection to DB timout.

DB is external: MS SQL, but installed on the same server as VC.

Do I have to use the same account that was used to install Vcenter for migration ? (I was using different one but with Admin rights).
I have found similar post saying that it might be SSO or Administrator password with special character like  "." or "@"

Below you can find my logs - thx in advance for help.

UpgradeRunner

2020-04-15T10:37:21.160Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T10:37:20.609Z INFO vcdb.const No password available - MSSQL Win Auth
2020-04-15T10:37:21.161Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T10:37:20.609Z INFO vcdb.const DB password retrieved: ****
2020-04-15T10:37:21.161Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T10:37:20.617Z INFO vcdb.const Disabling jobs...
2020-04-15T10:37:21.161Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T10:37:20.618Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:37:21.162Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T10:37:20.619Z INFO win_executor Running command ['C:\\Program Files\\VMware\\vCenter Server\\python\\python.exe', 'C:\\mig9241.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\ms2pg\\jobs_util.py', '--action', 'd', '-dsn', 'vcenterDB', '-u', 'domainName\\administrator', '-p',CENSORED, '-r', 'mssql'] as user administrator@domainName
2020-04-15T10:37:22.170Z INFO upgrade.states.component_states vcdb:Export: didn't have progress. Next report will come after 60 seconds
2020-04-15T10:38:22.528Z INFO upgrade.states.component_states vcdb:Export: didn't have progress. Next report will come after 60 seconds
2020-04-15T10:39:22.920Z INFO upgrade.states.component_states vcdb:Export: didn't have progress. Next report will come after 60 seconds
2020-04-15T10:40:23.386Z INFO upgrade.states.component_states vcdb:Export: didn't have progress. Next report will come after 60 seconds

...

..

2020-04-15T11:21:20.730Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T11:21:19.726Z WARNING status_reporting_sdk.filelock Got permission error: [Error 5] Access is denied: u'C:\\Users\\userName\\AppData\\Local\\VMware\\Migration-Assistant\\export\\system-data\\cis_upgrade_data.sfe.upgradeLock'

CollectRequirements_com.vmware.vcdb_2020_04_15_10_54

2020-04-15T10:24:24.270Z INFO featureState_utils Found FSS 'DeferHistoryImport' with value 'True'

2020-04-15T10:24:24.322Z ERROR transport.local NOT FOUND: Cannot read registry. Error: [Error 2] The system cannot find the file specified
2020-04-15T10:24:24.326Z INFO __main__ Context file C:\migE8D9.tmp\PFiles\VMware\CIS\cis_upgrade_runner\upgrade_working_directory\system-data\upgrade-com.vmware.vcdb-upgradeContext does not exist. Use default context
2020-04-15T10:24:24.326Z INFO extensions Found upgrade phase <module 'vcdb' from 'C:\migE8D9.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\__init__.pyc'>:CollectRequirements'
2020-04-15T10:24:24.328Z INFO extensions Executing upgrade phase '<module 'vcdb' from 'C:\migE8D9.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\__init__.pyc'>:CollectRequirements' with context {u'resourceDir': u'C:\\migE8D9.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\upgrade_working_directory', u'destinationVcVersion': u'6.7', u'sourceSsoPassword': 'CENSORED', u'vcSvcDomain': u'domainName', u'devMode': False, u'locale': u'en', u'destinationPlatform': u'Linux', u'vcSvcPassword': 'CENSORED', u'vcSvcUsername': u'administrator', u'systemExportDir': u'C:\\migE8D9.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\upgrade_working_directory\\system-data', u'sourcePlatform': u'Windows', 'logDir': u'C:\\Users\\userName~1\\AppData\\Local\\Temp\\vcsMigration', u'sourceVcVersion': u'6.0', u'sourceSsoVersion': u'6.0', u'vcdb.migrateSet': u'all', u'destinationSsoVersion': u'6.7', u'sourceSsoUsername': None}.

............................................................................
...........................................................................
...........................................................................

2020-04-15T08:55:02.696Z INFO vcdb.const VCDB: external
2020-04-15T08:55:02.696Z INFO vcdb.const DB type: embedded
2020-04-15T08:55:02.701Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T08:55:02.701Z INFO vcdb.const Validating source embedded schema...
2020-04-15T08:55:02.710Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T08:55:02.713Z INFO win_executor Running command ['C:\\migF673.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\dbupgrade\\dbcupgrade', '-u', 'YWRtaW5pc3RyYXRvclx2ZXJrYXVm', '-p',CENSORED, '-b', '600', '-v', u'C:\\Users\\userName~1\\AppData\\Local\\Temp\\vcsMigration\\vcdb_warning.log', '-t', 'mssql', '-d', 'dmNlbnRlckRC', '-y', '-e', '-m'] as user administrator@domainName
2020-04-15T08:55:43.332Z ERROR vcdb.const Error while validating source vCenter Server database: ERROR: duplicate-names:

2020-04-15T08:55:43.334Z INFO vcdb.const Source embedded schema validation completed.
2020-04-15T08:55:43.335Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T08:55:43.338Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T08:55:43.338Z INFO win_executor Running command ['C:\\Program Files\\VMware\\vCenter Server\\python\\python.exe', 'C:\\migF673.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\ms2pg\\estimateMSSQL.py', '--dsn', u'vcenterDB', '-u', u'administrator\\domainName', '-p',CENSORED, '-f', u'C:\\Users\\userName~1\\AppData\\Local\\Temp\\vcsMigration\\DB_results.out', '-e', 'False', '-t', 'False'] as user administrator@domainName
2020-04-15T08:55:44.355Z INFO vcdb.const total_core_size: 1903 MB, export time: 285 sec, SQLite size: 1046 MB, importTime: 1098 sec
2020-04-15T08:55:44.355Z INFO vcdb.const total_set_size: 8661 MB, export time: 1192 sec, SQLite size: 2848 MB, importTime: 3949 sec
2020-04-15T08:55:44.355Z INFO vcdb.const total_et_size: 8266 MB, export time: 1157 sec, SQLite size: 2727 MB, importTime: 3437 sec
2020-04-15T08:55:44.355Z INFO vcdb.const Estimates completed.
2020-04-15T08:55:44.359Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T08:55:44.359Z INFO vcdb.const Pass MSSQL Win Auth(vcdbWinAuth): True

Export_com.vmware.vcdb_2020_04_15_12_30

020-04-15T10:37:20.586Z INFO vcdb.const VCDB: external
2020-04-15T10:37:20.588Z INFO vcdb.const Database is external. Migrate to VCSA 6.6.
2020-04-15T10:37:20.588Z INFO vcdb.const Retrieving DB type...
2020-04-15T10:37:20.589Z INFO vcdb.const Retrieved DB type: mssql
2020-04-15T10:37:20.596Z INFO vcdb.const Getting vCenter Server DSN...
2020-04-15T10:37:20.598Z INFO vcdb.const vCenter Server uses DSN: vcenterDB
2020-04-15T10:37:20.598Z INFO vcdb.const Retrieving DB user...
2020-04-15T10:37:20.601Z INFO vcdb.const DB user retrieved: domainName\administrator
2020-04-15T10:37:20.608Z INFO vcdb.const Retrieving DB password...
2020-04-15T10:37:20.609Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:37:20.609Z INFO vcdb.const No password available - MSSQL Win Auth
2020-04-15T10:37:20.609Z INFO vcdb.const DB password retrieved: ****
2020-04-15T10:37:20.617Z INFO vcdb.const Disabling jobs...
2020-04-15T10:37:20.618Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:37:20.619Z INFO win_executor Running command ['C:\\Program Files\\VMware\\vCenter Server\\python\\python.exe', 'C:\\mig9241.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\ms2pg\\jobs_util.py', '--action', 'd', '-dsn', 'vcenterDB', '-u', 'domainName\\administrator', '-p',CENSORED, '-r', 'mssql'] as user administrator@domainName
2020-04-15T11:10:52.724Z INFO vcdb.const Ask customer to wait for jobs to complete.
2020-04-15T11:21:19.726Z WARNING status_reporting_sdk.filelock Got permission error: [Error 5] Access is denied: u'C:\\Users\\userName\\AppData\\Local\\VMware\\Migration-Assistant\\export\\system-data\\cis_upgrade_data.sfe.upgradeLock'
2020-04-15T11:44:05.803Z INFO vcdb.const Got answer: 0
2020-04-15T11:44:05.803Z INFO win_executor Running command ['C:\\Program Files\\VMware\\vCenter Server\\python\\python.exe', 'C:\\mig9241.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\ms2pg\\jobs_util.py', '--action', 'd', '-dsn', 'vcenterDB', '-u', domainName\\administrator', '-p',CENSORED, '-r', 'mssql'] as user administrator@domainName
2020-04-15T12:17:36.569Z INFO vcdb.const Ask customer to wait for jobs to complete.
2020-04-15T12:21:31.658Z WARNING status_reporting_sdk.filelock Got permission error: [Error 5] Access is denied: u'C:\\Users\\userName\\AppData\\Local\\VMware\\Migration-Assistant\\export\\system-data\\cis_upgrade_data.sfe.upgradeLock'
2020-04-15T12:25:46.234Z INFO vcdb.const Got answer: 1

CollectRequirements_com.vmware.vcdb_2020_04_15_12_24

2020-04-15T10:24:24.503Z INFO vcdb.const Validating source embedded schema...
2020-04-15T10:24:24.509Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:24:24.513Z INFO win_executor Running command ['C:\\migE8D9.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\dbupgrade\\dbcupgrade', '-u', 'YWRtaW5pc3RyYXRvclx2ZXJrYXVm', '-p',CENSORED, '-b', '600', '-v', u'C:\\Users\\userName~1\\AppData\\Local\\Temp\\vcsMigration\\vcdb_warning.log', '-t', 'mssql', '-d', 'dmNlbnRlckRC', '-y', '-e', '-m'] as user administrator@domainName
2020-04-15T10:24:42.119Z INFO vcdb.const Source embedded schema validation completed.
2020-04-15T10:24:42.121Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:24:42.124Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:24:42.124Z INFO win_executor Running command ['C:\\Program Files\\VMware\\vCenter Server\\python\\python.exe', 'C:\\migE8D9.tmp\\PFiles\\VMware\\CIS\\cis_upgrade_runner\\payload\\component-scripts\\vcdb\\ms2pg\\estimateMSSQL.py', '--dsn', u'vcenterDB', '-u', u'administrator\\domainName', '-p',CENSORED, '-f', u'C:\\Users\\userName~1\\AppData\\Local\\Temp\\vcsMigration\\DB_results.out', '-e', 'False', '-t', 'False'] as user administrator@domainName
2020-04-15T10:24:42.640Z INFO vcdb.const total_core_size: 1903 MB, export time: 285 sec, SQLite size: 1046 MB, importTime: 1098 sec
2020-04-15T10:24:42.640Z INFO vcdb.const total_set_size: 8662 MB, export time: 1192 sec, SQLite size: 2848 MB, importTime: 3949 sec
2020-04-15T10:24:42.640Z INFO vcdb.const total_et_size: 8266 MB, export time: 1157 sec, SQLite size: 2727 MB, importTime: 3437 sec
2020-04-15T10:24:42.640Z INFO vcdb.const Estimates completed.
2020-04-15T10:24:42.642Z INFO vcdb.const MSSQL with Windows Authentication.
2020-04-15T10:24:42.642Z INFO vcdb.const Pass MSSQL Win Auth(vcdbWinAuth): True
2020-04-15T10:24:42.663Z INFO extensions The component script returned '{'requirementMismatchSpecs': [], 'dstPortSpecs': [], 'coreRequirement': {'exportEstimationTime': 5, 'importEstimationTime': 19, 'requiredSrcDiskSpace': 1.2, 'requiredDstDiskSpace': {'/storage/db': 3.0}}, 'installArguments': {'db.type': 'embedded'}, 'userOptionSpecs': [{'optionId': 'vcdb.migrateSet', 'answerSpecs': [{'requirementMismatchSpecs': [], 'answerId': 'all', 'optionRequirement': {'exportEstimationTime': 20, 'importEstimationTime': 66, 'requiredSrcDiskSpace': 3.1, 'requiredDstDiskSpace': {'/storage/seat': 13.0}}}, {'requirementMismatchSpecs': [], 'answerId': 'core_events_tasks', 'optionRequirement': {'exportEstimationTime': 20, 'importEstimationTime': 58, 'requiredSrcDiskSpace': 3.0, 'requiredDstDiskSpace': {'/storage/seat': 13.0}}}, {'requirementMismatchSpecs': [], 'answerId': 'core', 'optionRequirement': {'exportEstimationTime': 0, 'importEstimationTime': 0, 'requiredSrcDiskSpace': 0.0, 'requiredDstDiskSpace': {}}}, {'requirementMismatchSpecs': [], 'answerId': 'transfer_stats_events_tasks_after_upgrade', 'optionRequirement': {'exportEstimationTime': 20, 'importEstimationTime': 0, 'requiredSrcDiskSpace': 3.1, 'requiredDstDiskSpace': {'/storage/seat': 13.0}}}, {'requirementMismatchSpecs': [], 'answerId': 'transfer_events_tasks_after_upgrade', 'optionRequirement': {'exportEstimationTime': 20, 'importEstimationTime': 0, 'requiredSrcDiskSpace': 3.0, 'requiredDstDiskSpace': {'/storage/seat': 13.0}}}]}], 'srcPorts': [], 'extraArguments': {'src.db.type': 'external'}}'

0 Kudos
1 Solution

Accepted Solutions
baszek
Enthusiast
Enthusiast

ODBC was ok.

there was also error in a log:

2020-04-15T12:25:47.224Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T12:25:46.855Z ERROR __main__ Upgrade Phase 'vcdb:Export' failed. Exception: Failed to disable all jobs in timely manner.

so it appeared that someone played a little with MS DB = VC user had no permissions to MSDB, also SQL agent was set to manuall and stopped -- so vmware migration tool could not run any jobs..

Problem solved - all is fine for now 🙂

View solution in original post

0 Kudos
5 Replies
Nawals
Expert
Expert

Can you please let me know how you are migrating the windows to VCSA? Also, hope you already migrated the PSC? have you check the ODBC connection is fine on VC?

NKS Please Mark Helpful/correct if my answer resolve your query.
0 Kudos
baszek
Enthusiast
Enthusiast

how I am migrating - according to Walkthrough: Windows vCenter Server 6.5 Embedded Migration to VCSA 6.7 | vSphere Upgrade | VMware vS...

"hope you already migrated the PSC" - my PSC is not external - so as far as I know I don't have to update PSC before migration from windows to VCSA. I have only updated VC for windows to 6.0u3j before going to 6.7u3f VCSA - appliance.

ODBC - I will odbc connections once again tomorrow when I will test migration again.

0 Kudos
Nawals
Expert
Expert

Fine. If youbare using embedded PSC. Check the ODBC connection

NKS Please Mark Helpful/correct if my answer resolve your query.
0 Kudos
baszek
Enthusiast
Enthusiast

ODBC was ok.

there was also error in a log:

2020-04-15T12:25:47.224Z INFO upgrade.states.component_states vcdb:Export: 2020-04-15T12:25:46.855Z ERROR __main__ Upgrade Phase 'vcdb:Export' failed. Exception: Failed to disable all jobs in timely manner.

so it appeared that someone played a little with MS DB = VC user had no permissions to MSDB, also SQL agent was set to manuall and stopped -- so vmware migration tool could not run any jobs..

Problem solved - all is fine for now 🙂

0 Kudos
Nawals
Expert
Expert

Great. thanks for the update.

NKS Please Mark Helpful/correct if my answer resolve your query.
0 Kudos