Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to solve com.siperian.mrm.cleanse.api.CleanseException: -99: SIP-16165

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 2.34k
    Comment on it

    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)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: