SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer Failed

[Deepak Tiwari]

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