While running match you encounter following error:
com.siperian.common.SipRuntimeException: SIP-09069: Failed to execute java null
        Failed to execute java null
        at com.siperian.common.SipRuntimeException.createNotExternalized(SipRuntimeException.java:74)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.processException(ReposTableObject.java:2216)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.run(ReposTableObject.java:2241)
Caused by: com.siperian.mrm.cleanse.api.CleanseException: -99: SIP-16165: Error trying to executeUpdate. SQL is CREATE TABLE T$MMA_BO_LEG_BLTO_CST_PRSPCT NOLOGGING  TABLESPACE CMX_TEMP PARALLEL (DEGREE 1) AS  select    ROWID_OBJECT, ROWID_OBJECT_MATCHED, ORIG_ROWID_OBJECT_MATCHED, MATCH_REVERSE_IND, ROWID_MATCH_RULE, AUTOMERGE_IND  from T$MFL_BO_LEG_BLTO_CST_PRSPCT m  where AUTOMERGE_IND = 0  and not exists  (      select 1 from T$MFL_BO_LEG_BLTO_CST_PRSPCT m2      where m2.ROWID_OBJECT = m.ROWID_OBJECT_MATCHED      and m2.ROWID_OBJECT_MATCHED = m.ROWID_OBJECT      and m2.ROWID_OBJECT > m.ROWID_OBJECT      and m2.AUTOMERGE_IND = 0  ) , error is ORA-00955: name is already used by an existing object
        CREATE TABLE T$MMA_BO_LEG_BLTO_CST_PRSPCT NOLOGGING  TABLESPACE CMX_TEMP PARALLEL (DEGREE 1) AS  select    ROWID_OBJECT, ROWID_OBJECT_MATCHED, ORIG_ROWID_OBJECT_MATCHED, MATCH_REVERSE_IND, ROWID_MATCH_RULE, AUTOMERGE_IND  from T$MFL_BO_LEG_BLTO_CST_PRSPCT m  where AUTOMERGE_IND = 0  and not exists  (      select 1 from T$MFL_BO_LEG_BLTO_CST_PRSPCT m2      where m2.ROWID_OBJECT = m.ROWID_OBJECT_MATCHED      and m2.ROWID_OBJECT_MATCHED = m.ROWID_OBJECT      and m2.ROWID_OBJECT > m.ROWID_OBJECT      and m2.AUTOMERGE_IND = 0  ) ;     ORA-00955: name is already used by an existing object
;
        at com.delos.cmx.server.interact.caller.InteractCleanseClient.processCallReturn(InteractCleanseClient.java:926)
        at com.delos.cmx.server.interact.caller.InteractCleanseClient.executeCall(InteractCleanseClient.java:914)
        at com.delos.cmx.server.interact.caller.InteractCleanseClient.executeCall(InteractCleanseClient.java:908)
        at com.delos.cmx.server.interact.caller.InteractCleanseClient.executeMatch(InteractCleanseClient.java:257)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.executeJavaMatch(ReposTableObject.java:716)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.executeReal(ReposTableObject.java:2116)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.access$200(ReposTableObject.java:97)
        at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.run(ReposTa....
You can fix this by running following SQL command:
drop table T$MMA_BO_LEG_BLTO_CST_PRSPCT;
on the SQL Developer for the ORS on which you are working. Please note table name would be different for you so change and drop. Again Run the Match it should go smooth.
                       
                    
0 Comment(s)