Description:
I'm migrating local Postgres (11.0) to MySQL using SQL Workbench. During the step 'Reverse Engineer Source' I got the error below.
Starting...
Connect to source DBMS...
- Connecting...
Connecting to postgresql@DRIVER=PostgreSQL Unicode(x64);SERVER=127.0.0.1;PORT=5432...
Opening ODBC connection to DRIVER=PostgreSQL Unicode(x64);SERVER=127.0.0.1;PORT=5432;DATABASE=SFPL;UID=postgres;UseDeclareFetch=1;...
Connected
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering public from SFPL
- Reverse engineering catalog information
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_postgresql_re_grt.py", line 356, in reverseEngineer
return PostgresqlReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 241, in reverseEngineer
catalog = cls.reverseEngineerCatalog(connection, catalog_name)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 401, in reverseEngineerCatalog
cls.reverseEngineerSequences(connection, schema)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_postgresql_re_grt.py", line 80, in reverseEngineerSequences
min_value, max_value, start_value, increment_by, last_value, is_cycled, ncache = cls.execute_query(connection, seq_details_query % (schema.name, seq_name)).fetchone()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 80, in execute_query
return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)')
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: ProgrammingError("('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer
ERROR: Reverse engineer selected schemas: ProgrammingError("('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer
Failed
I have verified the "db_postgresql_re_grt.pyc" file and the column "is_cycled" exists. Gone through various links but can't find any related error or solution. Appreciate your help in resolving the issue.
How to repeat:
Start MySQL Workbench Migration >> supply all credentials for local PostgreSQL server as source >> supply all credentials for local MySQL server as target >> Test Both Connections >> Select Schema Database to migrate >> And after clicking next to 'Reverse Engineer Source' the database, it FAILED.
Description: I'm migrating local Postgres (11.0) to MySQL using SQL Workbench. During the step 'Reverse Engineer Source' I got the error below. Starting... Connect to source DBMS... - Connecting... Connecting to postgresql@DRIVER=PostgreSQL Unicode(x64);SERVER=127.0.0.1;PORT=5432... Opening ODBC connection to DRIVER=PostgreSQL Unicode(x64);SERVER=127.0.0.1;PORT=5432;DATABASE=SFPL;UID=postgres;UseDeclareFetch=1;... Connected Connect to source DBMS done Reverse engineer selected schemas.... Reverse engineering public from SFPL - Reverse engineering catalog information Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_postgresql_re_grt.py", line 356, in reverseEngineer return PostgresqlReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 241, in reverseEngineer catalog = cls.reverseEngineerCatalog(connection, catalog_name) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 401, in reverseEngineerCatalog cls.reverseEngineerSequences(connection, schema) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_postgresql_re_grt.py", line 80, in reverseEngineerSequences min_value, max_value, start_value, increment_by, last_value, is_cycled, ncache = cls.execute_query(connection, seq_details_query % (schema.name, seq_name)).fetchone() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_generic_re_grt.py", line 80, in execute_query return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs) pyodbc.ProgrammingError: ('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)') 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: ProgrammingError("('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer ERROR: Reverse engineer selected schemas: ProgrammingError("('42703', '[42703] ERROR: column "is_cycled" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer Failed I have verified the "db_postgresql_re_grt.pyc" file and the column "is_cycled" exists. Gone through various links but can't find any related error or solution. Appreciate your help in resolving the issue. How to repeat: Start MySQL Workbench Migration >> supply all credentials for local PostgreSQL server as source >> supply all credentials for local MySQL server as target >> Test Both Connections >> Select Schema Database to migrate >> And after clicking next to 'Reverse Engineer Source' the database, it FAILED.