Bug #62671 Reverse Engineering Error in Migration Toolkit process
Submitted: 10 Oct 2011 17:03 Modified: 24 Oct 2011 20:43
Reporter: huber gilt Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:1.1.17 OS:Windows (Windows XP SP3)
Assigned to: CPU Architecture:Any

[10 Oct 2011 17:03] huber gilt
Description:
I'm using the MySQL Mygration Toolkit for migrate data from oracle 8.1.6 server in unix to mysql server in linux so I have an error in the Reverse Engineering  with views and store procedures fetching processes and I send you the message logs.

Fetching FK information.
SELECT t.TABLE_NAME, t.TRIGGER_NAME, t.TRIGGER_TYPE, t.TRIGGERING_EVENT, t.BASE_OBJECT_TYPE, t.COLUMN_NAME, t.REFERENCING_NAMES, t.WHEN_CLAUSE, t.STATUS, t.DESCRIPTION, t.ACTION_TYPE, t.TRIGGER_BODY FROM ALL_TRIGGERS t, ALL_TABLES ta WHERE t.TABLE_OWNER=? AND ta.OWNER=t.OWNER AND t.TABLE_NAME=ta.TABLE_NAME ORDER BY t.TABLE_NAME
Fetch all views of the schema SUTRON_ENBM.
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
ERROR: Index: 0, Size: 0
Views fetched.
Fetch count of stored procedures of the schema SUTRON_ENBM.
SELECT COUNT(*) AS NUM FROM ALL_PROCEDURES p, ALL_OBJECTS a WHERE p.OWNER=? AND   a.OWNER=p.OWNER AND a.OBJECT_NAME=p.OBJECT_NAME AND   (a.OBJECT_TYPE='PROCEDURE' OR a.OBJECT_TYPE='FUNCTION') AND a.STATUS='VALID' ORDER BY p.OBJECT_NAME
Stored procedures cannot be fetched.
ORA-00942: table or view does not exist

Fetch the number sequences of the schema SUTRON_ENBM.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES s, ALL_OBJECTS a WHERE s.SEQUENCE_OWNER=? AND   a.OWNER=s.SEQUENCE_OWNER AND a.OBJECT_NAME=s.SEQUENCE_NAME AND   a.OBJECT_TYPE='SEQUENCE' AND a.STATUS='VALID'
Fetch 0 sequence(s) of the schema SUTRON_ENBM.
SELECT s.SEQUENCE_NAME, s.MIN_VALUE,  s.MAX_VALUE, s.INCREMENT_BY, s.CYCLE_FLAG, s.ORDER_FLAG,  s.CACHE_SIZE, s.LAST_NUMBER FROM ALL_SEQUENCES s, ALL_OBJECTS a WHERE s.SEQUENCE_OWNER=? AND   a.OWNER=s.SEQUENCE_OWNER AND a.OBJECT_NAME=s.SEQUENCE_NAME AND   a.OBJECT_TYPE='SEQUENCE' AND a.STATUS='VALID' ORDER BY s.SEQUENCE_NAME
The schema could not be reverse engineered (error: 10008).
ReverseEngineeringOracle.reverseEngineer :

How to repeat:
Start MySQL Migration Toolkit then select oracle datababase for source then select mysql database for target and then in the object selection part the reversing engineering process fail.

Suggested fix:
Maybe need to configure the process of migration to exclude the migration of views and store procedures.
[10 Oct 2011 18:31] Valeriy Kravchuk
Migration Toolkit is unsupported for a long time already.

Hint: please, check if the ALL_PROCEDURES view is available in Oracle 8.1.6 at all. I do not see it here:

http://www.oracle86.com/817/server.817/a76961/toc.htm

at least. Looks like you should hack Java code for Oracle to support 8.1.x properly.
[10 Oct 2011 19:24] huber gilt
Hi Valeriy,

You are right there isn't an ALL_PROCEDURES view available in Oracle 8.1.6 and please How can I hank the java code for skip the store procedures migration process.

Best regards,
Huber
[24 Oct 2011 20:43] huber gilt
hello Valeriy,

I download the source gui-tools from:

http://dev.mysql.com/downloads/gui-tools/5.0.html

And I couldn't find this library:

import com.mysql.grt.db.*;

Could you give me some advice or send me the link to download that library.

Best regads,
Huber