VMware Cloud Community
LK3035
Contributor
Contributor

Upgrade to VCSA 6.5 from Windows Fails with Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

Hi, in the last step I choose Migrate Configuration, it seems it is working but suddenly we have this error:

  File "C:\mig3938.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\ms2pg\ms2sqlite.py", line 243, in fetchItems

    rows = cursor.fetchmany(chunkSize)

pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

2017-09-20T09:11:41.355Z ERROR vcdb.const Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

2017-09-20T09:11:41.355Z ERROR __main__ Upgrade Phase 'vcdb:Export' failed. Exception: Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

We have windows 2012 R2 with VC 6.0.0, 3018524 with a SQL in the same server with SQL 2012 11.0.5058.0

Anyone has any idea about it?

Thanks in advance

Reply
0 Kudos
2 Replies
parmarr
VMware Employee
VMware Employee

Hello,

Please see the KB below for more details regarding the error and hope it helps:

Windows vCenter Server migration to vCenter Server Appliance fails on database export (2148052) | VM...

Sincerely, Rahul Parmar VMware Support Moderator
Reply
0 Kudos
LK3035
Contributor
Contributor

Hi, in vcdb_export.out there is no errors, only in the Export_com.vmware.vcdb.log with this error

pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

2017-09-29T07:02:37.301Z ERROR vcdb.const Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

2017-09-29T07:02:37.302Z ERROR __main__ Upgrade Phase 'vcdb:Export' failed. Exception: Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

Traceback (most recent call last):

  File "C:\mig9FB0.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\componentPhaseLauncher.py", line 438, in main

    executionResult = systemExtension(exeContext)

  File "C:\mig9FB0.tmp\PFiles\VMware\CIS\cis_upgrade_runner\libs\sdk\extensions.py", line 94, in __call__

    result = self.extension(*args)

  File "C:\mig9FB0.tmp\PFiles\VMware\CIS\cis_upgrade_runner\libs\sdk\extensions.py", line 110, in _func

    return func(*args)

  File "C:\mig9FB0.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:\mig9FB0.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:\mig9FB0.tmp\PFiles\VMware\CIS\cis_upgrade_runner\payload\component-scripts\vcdb\vcdb_export_windows_functions.py", line 599, in do_windows_export_external_db

    raise PermanentError(cause=error, resolution=suggAction)

PermanentError: Error while exporting core data: pyodbc.Error: ('07006', '[07006] [Microsoft][SQL Server Native Client 11.0]Restricted data type attribute violation (0) (SQLGetData)')

Reply
0 Kudos