MySQL Forums
Forum List  »  Microsoft Access

SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer Failed
Posted by: Deepak Tiwari
Date: December 05, 2019 03:46AM

Hello All,

I am Trying to migrate on Sql Server which is running in windows to Linux and getting error as below. Anyone please help me out.

- Retrieving table ahrs.email...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 266, in reverseEngineer
result = execute_query(connection, "SHOW CREATE TABLE `%s`.`%s`" % (escape_sql_identifier(schema_name), escape_sql_identifier(table_name)))
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 43, in execute_query
return get_connection(connection_object).executeQuery(query)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_utils.py", line 364, in executeQuery
raise QueryError("Error executing '%s'\n%s"%(query, error), code, error)
workbench.db_utils.QueryError: Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 183, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 364, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: QueryError("Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer
ERROR: Reverse engineer selected schemas: QueryError("Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer Failed
1420
December 05, 2019 03:46AM


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.