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