Bug #102093 Error in the Reverse Engineer Source step in the Access Migration process
Submitted: 30 Dec 2020 12:28 Modified: 30 Dec 2020 12:37
Reporter: Erik Johson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Dec 2020 12:28] Erik Johson
Description:
Receive the below error when during Access migration process:

Starting...
Connect to source DBMS...
- Connecting...
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering JEFFERY v20201217 MySQL M1 from def
- Reverse engineering catalog information
- Preparing...
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 755, in reverseEngineer
    return MsAccessReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 269, in reverseEngineer
    routine_count_per_schema[schema_name] = len(cls.getProcedureNames(connection, catalog_name, schema_name)) + len(cls.getFunctionNames(connection, catalog_name, schema_name)) if get_routines else 0
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 231, in getProcedureNames
    cls.get_connection(connection).cursor().procedures() ))
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")

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("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
ERROR: Reverse engineer selected schemas: ProgrammingError("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
Failed

How to repeat:
Running migration process.

Suggested fix:
Unknown
[30 Dec 2020 12:37] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=87647.