App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
 View Only
Expand all | Collapse all

[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint

  • 1.  [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint

    Posted Tue May 14, 2019 04:08 PM
    Hi All,

    Post Migration IIB v10 to App Connect Enterprise v11.0.0.4  ( OS Windows), Database ORACLE 18c

    Event log throws below error

    Event generated by user code. Additional information : ''ERROR: Database insert failed on table ESB_EXCEPTION_HISTORY.'' ''CallingMessageFlowName: ESB_CORE_EXCEPTION_HANDLER'' ''Internal Correlation ID: xxxxxx'' ''SQLCODE: -1'' ''SQLSTATE: 23000'' ''SQLERRORTEXT: [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (xxxxxx.EXCEPTION_HISTORY_PK) violated'' ''SQLNATIVEERROR: 1'' 'ESB_CORE_EXCEPTION_HANDLER.processDiagnosticMessage'

    Did I missed any thing..


    ------------------------------
    AnandKumar Billakanti
    ------------------------------


  • 2.  RE: [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint

    Posted Tue May 14, 2019 04:17 PM
    hi
     
    looks like you are trying to insert the same record in table which is already inserted... with primary key
     
    unique constraint (xxxxxx.EXCEPTION_HISTORY_PK) violated''
     
     
     
    Thanks
     
    Satendra
     






Global message icon