MySQL Forums
Forum List  »  PostgreSQL

Error occured when "reverse engineer selected schemata" for PostgreSQL 9.2.2
Posted by: Xi Bai
Date: January 27, 2013 07:43PM

Hi,

When I tried migrating data stored on PostgreSQL with the version 9.2.2 to MySQL, I got the following error at the step of "Reverse engineer selected schemata" for both 5.2.45 and 5.2.44 on Mac OS 10.6.8:

Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=LocalPostgreSQLDB...
Connected
Connect to source DBMS done
Reverse engineer selected schemata....
Reverse engineering public from cssmetaselector
- Reverse engineering catalog information
- Preparing...
- Gathered stats for public
Reverse engineering tables from public
- Retrieving table public.static...
Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_postgresql_re_grt.py", line 335, in reverseEngineer
return PostgresqlReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 257, in reverseEngineer
cls.reverseEngineerTables(connection, schema)
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 393, in reverseEngineerTables
cls.reverseEngineerTableIndices(connection, table)
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_postgresql_re_grt.py", line 114, in reverseEngineerTableIndices
index_rows = cls.execute_query(connection, all_indices_query).fetchall()
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/db_generic_re_grt.py", line 56, in execute_query
return cls.get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.Error: ('ODBC data type 1111 is not supported. Cannot read column indkey.', 'HY000')

Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 191, in thread_work
self.func()
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/migration_schema_selection.py", line 160, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "/Applications/MySQLWorkbench.app/Contents/PlugIns/migration.py", line 332, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: Error("('ODBC data type 1111 is not supported. Cannot read column indkey.', 'HY000')"): error calling Python module function DbPostgresqlRE.reverseEngineer
ERROR: Reverse engineer selected schemata: Error("('ODBC data type 1111 is not supported. Cannot read column indkey.', 'HY000')"): error calling Python module function DbPostgresqlRE.reverseEngineer
Failed

The error above does not give my any clue. It'll be most appreciated if someone can help me with this.

All the best

Xi



Edited 2 time(s). Last edit at 01/27/2013 07:51PM by Xi Bai.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error occured when "reverse engineer selected schemata" for PostgreSQL 9.2.2
2013
January 27, 2013 07:43PM


Sorry, you can't reply to this topic. It has been closed.

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.