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)