Bug #102093 Error in the Reverse Engineer Source step in the Access Migration process
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
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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