MySQL Bugs: #13339: The schema could not be reverse engineered (error: 10008)

Bug #13339	The schema could not be reverse engineered (error: 10008)
Submitted:	20 Sep 2005 6:44	Modified:	21 Oct 2005 18:17
Reporter:	Damien Ingle	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.0.18 rc	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
Migrating Informix database to MySQL gets error in the Reverse Engineering Process.  The schema could not be reverse engineered (error: 10008)

Occurs after fetching primary and foreign keys for tables.  The following is the tail of the log:

Fetch all views of the given schemata.
Fetch all stored procedures of the given schemata.
Initializing JDBC driver ... 
Driver class Generic Jdbc
Opening connection ... 
Connection jdbc:informix-sqli://hostname:port/dbname:INFORMIXSERVER=servername;user=username;password=******
Initializing JDBC driver ... 
Driver class Generic Jdbc
Opening connection ... 
Connection jdbc:informix-sqli://hostname:port/dbname:INFORMIXSERVER=servername;user=username;password=******
The schema could not be reverse engineered (error: 10008).

(Hostname, port, servername, username and password above changed to protect)

How to repeat:
Run migration for Informix database to MySQL using Informix JDBC driver

Hi!

Can you please give us the schema & table definition of your database so that we can try and reproduce this bug ?

Thanks!

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".

Yo tengo el mismo problema, estoy tratando de migrar datos desde Oracle a MySQL. Las últimas líneas que me aparecen son:

Stored procedures fetched.
Fetch the number sequences of the schema ADMINISTRACION.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 179 sequence(s) of the schema ADMINISTRACION.
SELECT SEQUENCE_NAME, MIN_VALUE,  MAX_VALUE, INCREMENT_BY, CYCLE_FLAG, ORDER_FLAG,  CACHE_SIZE, LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?

¿Tienen alguna solución para este problema?

Atte.
Arturo

Hola,

Con respecto a mi problema, creo que también tiene que ver el tamaño de la base de datos. Pues he intentado migrar un esquema con alrededor de 300 tables, 500 procedimientos almacenado y como 75 secuencias. El problema es cuendo llega a las secuencias.

Con base de datos pequeñas, no hay ningún problema, no importa si tiene tables, secuencias, procedimientos almacenados, vista, secuencias, etc.

¿Help me, please?

Atte. Arturo