| Bug #106596 | Workbench 8 Windows 11 Migration MSSQL > MySQL failure | ||
|---|---|---|---|
| Submitted: | 28 Feb 2022 12:02 | Modified: | 4 Mar 2022 13:56 |
| Reporter: | Tym Huckin | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
| Version: | OS: | Windows (11) | |
| Assigned to: | CPU Architecture: | Any | |
[28 Feb 2022 12:02]
Tym Huckin
[1 Mar 2022 14:04]
Tym Huckin
Tried it again today, and I only got the following single error:
Starting...
Migrate Selected Objects....
- Migrating...
- Migrating schema Lailoken...
- Migrating schema contents for schema Lailoken
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 197, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_object_migration.py", line 117, in task_migrate
self.main.plan.migrate()
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 510, in migrate
self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed
[2 Mar 2022 6:43]
MySQL Verification Team
Hello Tym Huckin, Thank you for the bug report. I tried to reproduce your issue on Windows 10 with MySQL Workbench 8.0.28 and migrated database objects from mssql to mysql but I am not seeing any issues at my end. Could you please provide create table sql statement for SQL Server which fails to be migrated? Regards, Ashwini Patil
[3 Mar 2022 17:02]
Tym Huckin
There are 6,468 tables in the MS SQL Server database... surely you don't want all of them! :-)
[4 Mar 2022 13:56]
MySQL Verification Team
Hello, I've tried to reproduce your issue again but I am not seeing any issues at my end. You could share some sample table structure that is causing the issue. Thanks. Regards, Ashwini Patil
[10 Jun 2022 11:23]
MARCUS MENDES
Hi, I have the same error on Windows 10, it's look like a incompatibility with python version's and modules installed on the machine. Googling about this specific error, I found it: https://forum.omz-software.com/topic/5469/attributeerror-module-string-has-no-attribute-ma... `I am trying to use the maketrans method, and I can’t seem to get it to work in 3.6. I copied the code exactly from this link: https://forum.omz-software.com/topic/3062/string-maketrans-method-not-working. If I run the code in 2.7, it works fine. If I run it in 3.6, after updating the print command for 3.6 (encapsulating what follows ‘print’ within parentheses), I get the attribute error within the subject line. Any guidance for me?` As an answer, another guy says:`it should be str, not string.` ::::::::::::::::: In my case, when I tried to execute an migration (SQL Server Express > MySQL 8 - via ODBC) the error message shows it: ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'") ::::: Full migration log message: Starting... Migrate Selected Objects.... 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_object_migration.py", line 117, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 510, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog) SystemError: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog ERROR: Migrate Selected Objects: AttributeError("module 'string' has no attribute 'maketrans'"): error calling Python module function DbMssqlMigration.migrateCatalog Failed
