Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration from Sybase to Oracle using SQL Developer (ORA-01403 ORA-06512 ORA-06510)

kalibrainAug 6 2014 — edited Aug 6 2014

I am in the process of migrating our Sybase database to Oracle using SQL Developer tool. Till to the last step, I believe I did everything correct. Once migration processes start, I keep getting the same error. MIGRLOG table doesn't give much information to solve the problem for me, or I don't quite understand what it is saying. Anyway here is the log. I deleted duplicate rows for you to read easily. As of I understand from it, migration programs need to catch some failures. I don't know what to fix or change, there is also nothing I can find somewhere else. Any help would be appreciated.

<?xml version='1.0'  encoding='Cp1252' ?>

<RESULTS>

  <ROW>

  <COLUMN NAME="LOGTEXT"><![CDATA[ProcessFkConstraints: Unable process referenced constraint details [ORA-01403: no data found : ORA-06512: at "MIGREP.SYB12ALLPLATFORM", line 1293]  svrid:dbid:objid:v_refRow.ref_table_id_gen_fk:v_colOrder:v_keys(v_colOrder): 617151:617401:651201::1:1]]></COLUMN>

  <COLUMN NAME="PHASE"><![CDATA[Capture]]></COLUMN>

  <COLUMN NAME="ID"><![CDATA[1053101]]></COLUMN>

  <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="LOG_DATE"><![CDATA[06-AUG-14 12.04.11.000000000 PM]]></COLUMN>

  <COLUMN NAME="SEVERITY"><![CDATA[2]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>

  <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[617151]]></COLUMN>

  </ROW>

  <ROW>

  <COLUMN NAME="LOGTEXT"><![CDATA[Capture Enterprise Capture Capture failed.  Refer to MIGRLOG table in the repository for details]]></COLUMN>

  <COLUMN NAME="PHASE"><![CDATA[]]></COLUMN>

  <COLUMN NAME="ID"><![CDATA[1234101]]></COLUMN>

  <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="LOG_DATE"><![CDATA[06-AUG-14 12.04.15.104000000 PM]]></COLUMN>

  <COLUMN NAME="SEVERITY"><![CDATA[1000]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>

  <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[]]></COLUMN>

  </ROW>

  <ROW>

  <COLUMN NAME="LOGTEXT"><![CDATA[Error:ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "MIGREP.SYB12ALLPLATFORM", line 2339 ORA-06512: at line 1 : FAILED : Database Migration : FAILED]]></COLUMN>

  <COLUMN NAME="PHASE"><![CDATA[]]></COLUMN>

  <COLUMN NAME="ID"><![CDATA[1234151]]></COLUMN>

  <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="LOG_DATE"><![CDATA[06-AUG-14 12.04.15.110000000 PM]]></COLUMN>

  <COLUMN NAME="SEVERITY"><![CDATA[900]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>

  <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>

  <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[]]></COLUMN>

  </ROW>

</RESULTS>

Thanks,

Kali.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Aug 6 2014
0 comments
504 views