MySQL Bugs: #36797: Error on Reverse ingeeniering

Bug #36797	Error on Reverse ingeeniering
Submitted:	19 May 2008 10:34	Modified:	17 Nov 2008 14:10
Reporter:	Joel Carluec	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	1.1.12	OS:	Windows (Windows2000)
Assigned to:		CPU Architecture:	Any
Tags:	error reverse ingeeniering

Description:
Hello, I got a problem on reverse ingeeniering an Oracle Database to MySql :

Fetch all views of the schema HR.
SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c, ALL_OBJECTS a WHERE v.OWNER=? AND   c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V' AND   a.OWNER=v.OWNER AND a.OBJECT_NAME=v.VIEW_NAME AND   a.OBJECT_TYPE='VIEW' AND a.STATUS='VALID' ORDER BY v.OWNER, v.VIEW_NAME
The schema could not be reverse engineered (error: 0).
ReverseEngineeringOracle.reverseEngineer :Il n'y a plus de données à lire dans le socket
Details: 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:885)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:994)
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:951)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:435)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500)
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerViews(ReverseEngineeringOracle.java:896)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(ReverseEngineeringOracle.java:129)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

Thanks to help me, its a critical error, i can't transfert database.

How to repeat:
Launch SQL Migration Toolkit;
Select source as Oracle Database
Select target as MySQL
Select shema selection
Launch reverse engeeniering

Thank you for a problem report. What exact version of Oracle server and JDBC driver you had used?

Here my versions :

Oracle version : 8.7.1.4.0.
JDBC Driver version : I don't know version; here is the link where i downloaded it : http://www710.univ-lyon1.fr/~ecoquery/files/oracle-jdbc/ojdbc14.jar

NB : Problem is the same with option SID or SERVICE (It's Thin ODBC)

Thank you for the additional information (I am not sure if Oracle 8.1.7.4 is formally supported and if I'll be able to find it somewhere).

What exact version of Migration Toolkit you had used?

My version of MySQL Migration Toolkit is 1.1.12

Please, try to repeat with a newer version, from GUI Tools 5.0-r13, and inform about the results.

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