Bug #116699 Windows TypeError("can only concatenate str (not "NoneType") to str")
Submitted: 18 Nov 2024 19:35 Modified: 10 Jan 11:14
Reporter: Raajiv Gupta Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S3 (Non-critical)
Version:8.0.40 OS:Windows (Windows 11)
Assigned to: MySQL Verification Team CPU Architecture:x86

[18 Nov 2024 19:35] Raajiv Gupta
Description:
I am trying to migrate from MYSQL version 5.7.44-48 to Azure MYSQL I keep getting this error during Reverse Engineer Source below

Reverse engineering stored procedures from aims_prod
- Retrieving stored procedure aims_prod.activity_action_delete...
- Reverse engineering aims_prod.activity_action_delete...

Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 198, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 184, in task_reveng
    self.main.plan.migrationSource.reverseEngineer()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 365, in reverseEngineer
    self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: TypeError("can only concatenate str (not "NoneType") to str"): error calling Python module function DbMySQLRE.reverseEngineer
ERROR: Reverse engineer selected schemas: TypeError("can only concatenate str (not "NoneType") to str"): error calling Python module function DbMySQLRE.reverseEngineer
Failed

How to repeat:
Every time you running migration wizard it gets stuck at this stage
[10 Dec 2024 11:14] MySQL Verification Team
HI Mr. Gupta,

Thank you for your bug report.

However, we do not see from any of the informations that you have provided, what is the version of MySQL server that is running on Azure.

You can only upgrade MySQL step by step and in this order 5.7 -> 8.0 -> 8.4 -> 9.1.

If you have not followed that path, then errors are expected.
[11 Jan 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".