MySQL Forums
Forum List  »  Microsoft Access

Reverse engineer: Error calling Python function DbSQLAnywhereRE.reverseEngineer
Posted by: Gabriel Vilella
Date: December 09, 2015 08:42AM

I am migrating from Sybase SQL Anywhere 9.0 to MySQL 5.6.17 on my local computer (WAMP). I can connect to both DBs however the migration wizard fails at the Reverse Engineer stage presenting the following error:

Starting...
Connect to source DBMS...
- Connecting...
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering DBA, SYS, dbo, rs_systabgroup from sianbima43
- Reverse engineering catalog information
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_re_grt.py", line 470, in reverseEngineer
return SQLAnywhereReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_re_grt.py", line 169, in reverseEngineer
catalog = super(SQLAnywhereReverseEngineering, cls).reverseEngineer(connection, '', schemata_list, context)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_re_grt.py", line 237, in reverseEngineer
catalog = cls.reverseEngineerCatalog(connection, catalog_name)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_re_grt.py", line 388, in reverseEngineerCatalog
cls.reverseEngineerUserDatatypes(connection, catalog)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_re_grt.py", line 41, in wrapped_method
res = method(cls, connection, *args)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlanywhere_re_grt.py", line 194, in reverseEngineerUserDatatypes
for type_name, sql_definition, parent_type in cls.execute_query(connection, query):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_re_grt.py", line 76, in execute_query
return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42S22', "[42S22] [Sybase][ODBC Driver][Adaptive Server Anywhere]N\xe3o \xe9 poss\xedvel encontrar a coluna 'base_type_str' (-143) (SQLExecDirectW)")

Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_selection.py", line 175, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", line 369, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: ProgrammingError("('42S22', "[42S22] [Sybase][ODBC Driver][Adaptive Server Anywhere]N\xe3o \xe9 poss\xedvel encontrar a coluna 'base_type_str' (-143) (SQLExecDirectW)")"): error calling Python module function DbSQLAnywhereRE.reverseEngineer
ERROR: Reverse engineer selected schemas: ProgrammingError("('42S22', "[42S22] [Sybase][ODBC Driver][Adaptive Server Anywhere]N\xe3o \xe9 poss\xedvel encontrar a coluna 'base_type_str' (-143) (SQLExecDirectW)")"): error calling Python module function DbSQLAnywhereRE.reverseEngineer
Failed

Any clue how to solve this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Reverse engineer: Error calling Python function DbSQLAnywhereRE.reverseEngineer
1724
December 09, 2015 08:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.