Bug #88253 Postgres To MySQL migration reverse engineer source failed
Submitted: 27 Oct 2017 16:23 Modified: 24 Jul 2018 13:26
Reporter: Prain Liu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:6.3.9 OS:MacOS (10.12.6)
Assigned to: CPU Architecture:Any

[27 Oct 2017 16:23] Prain Liu
Description:
I'm migrating local Postgres (10.0) to MySQL (5.7.13
). During the step 'Reverse Engineer Source' I got the error below.

Starting...
Connect to source DBMS...
- Connecting...
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering public from db_sentry
- Reverse engineering catalog information
Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/db_postgresql_re_grt.py", line 352, in reverseEngineer
    return PostgresqlReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/db_generic_re_grt.py", line 237, in reverseEngineer
    catalog = cls.reverseEngineerCatalog(connection, catalog_name)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/db_generic_re_grt.py", line 397, in reverseEngineerCatalog
    cls.reverseEngineerSequences(connection, schema)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/db_postgresql_re_grt.py", line 76, 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 "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/db_generic_re_grt.py", line 76, in execute_query
    return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42703', '[42703] ERROR: column "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')

Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 192, in thread_work
    self.func()
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/migration_schema_selection.py", line 175, in task_reveng
    self.main.plan.migrationSource.reverseEngineer()
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/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("('42703', '[42703] ERROR: column "min_value" 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 "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer
Failed

What's wrong about this? How can I do for this error? 
Any assistance is greatly appreciated.

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.
[24 Jun 2018 13:26] MySQL Verification Team
Please try development release version 8.0.11 rc. Thanks.
[18 Jul 2018 17:48] David Wheatley
It still does not work for me on SQL Workbench 8.0.11.
[18 Jul 2018 17:49] David Wheatley
I meant SQL Server Version 8.0.11 and SQL Workbench version 6.3.10
[25 Jul 2018 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".