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.

 View Only

  • 1.  Database error

    Posted Thu March 28, 2024 05:55 AM

    Dear,

    We have a flow where we have three database stored procedure calls. Two of them are GET and third one is Update.

    when we try to update details in final SP we get Database transaction issue as shown below. We are using ACE V 11.7. Can anyone assist please.

    Error Captured in IS logs is as below:

    {"type":"ace_message","ibm_product":"IBM App Connect Enterprise","ibm_recordtype":"log","host":" ","module":"integration_server.","ibm_serverName":"","ibm_processName":"IntegrationServer","ibm_processId":"1167","ibm_threadId":"1523","ibm_datetime":"2024-03-27T11:35:22.604116","loglevel":"ERROR","message":"2695E: Thread number '1523' with name '' failed to commit a resource of type 'ODBC'. Other resources have been committed. ","ibm_message_detail":"2695E: Thread number '1523' with name '' failed to commit a resource of type 'ODBC'. Other resources have been committed. \nWhen committing a transaction a locally coordinated resource has failed to commit. The transaction state for this resource might not be consistent with the other resources in the transaction. Commits have been issued on other resources involved in this transaction. \nExamine the transactional state of the failed resource and manually resolve the transaction. Review previous messages to find out why the error occurred. ","ibm_messageId":"2695E","ibm_sequence":"1711539322604_0000000000001"}


    {"type":"ace_message","ibm_product":"IBM App Connect Enterprise","ibm_recordtype":"log","host":" ","module":"integration_server.","ibm_serverName":"","ibm_processName":"IntegrationServer","ibm_processId":"1167","ibm_threadId":"1523","ibm_datetime":"2024-03-27T11:35:22.604312","loglevel":"ERROR","message":"2321E: Database error: ODBC return code '-1' using ODBC driver manager '\/opt\/ibm\/ace-11\/ie02\/lib\/libodbcinterface.so'. ","ibm_message_detail":"2321E: Database error: ODBC return code '-1' using ODBC driver manager '\/opt\/ibm\/ace-11\/ie02\/lib\/libodbcinterface.so'. \nThe integration node encountered an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database concerning this error. \nUse the following messages to determine the cause of the error. Typical problems are an incorrect datasource or table names. Correct either the database or integration node configuration. ","ibm_messageId":"2321E","ibm_sequence":"1711539322604_0000000000002"}


    {"type":"ace_message","ibm_product":"IBM App Connect Enterprise","ibm_recordtype":"log","host":" ","module":"integration_server.","ibm_serverName":"","ibm_processName":"IntegrationServer","ibm_processId":"1167","ibm_threadId":"1523","ibm_datetime":"2024-03-27T11:35:22.604370","loglevel":"ERROR","message":"2322E: Database error: SQL State '60'; Native Error Code '3971'; Error Text '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The server failed to resume the transaction. Desc:55300000003.'. ","ibm_message_detail":"2322E: Database error: SQL State '60'; Native Error Code '3971'; Error Text '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The server failed to resume the transaction. Desc:55300000003.'. \nThe error has the following diagnostic information:     SQL State             '60'     SQL Native Error Code '3971'     SQL Error Text        '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The server failed to resume the transaction. Desc:55300000003.' \nThis message may be accompanied by other messages describing the effect on the integration node itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database. ","ibm_messageId":"2322E","ibm_sequence":"1711539322604_0000000000003"}


    {"type":"ace_message","ibm_product":"IBM App Connect Enterprise","ibm_recordtype":"log","host":" ","module":"integration_server.","ibm_serverName":"","ibm_processName":"IntegrationServer","ibm_processId":"1167","ibm_threadId":"1523","ibm_datetime":"2024-03-27T11:35:22.604542","loglevel":"ERROR","message":"2322E: Database error: SQL State '2'; Native Error Code '3926'; Error Text '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The transaction active in this session has been committed or aborted by another session.'. ","ibm_message_detail":"2322E: Database error: SQL State '2'; Native Error Code '3926'; Error Text '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The transaction active in this session has been committed or aborted by another session.'. \nThe error has the following diagnostic information:     SQL State             '2'     SQL Native Error Code '3926'     SQL Error Text        '[unixODBC][IBM][ODBC 20101 driver][Microsoft SQL Server]The transaction active in this session has been committed or aborted by another session.' \nThis message may be accompanied by other messages describing the effect on the integration node itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database. ","ibm_messageId":"2322E","ibm_sequence":"1711539322604_0000000000003"}



    ------------------------------
    Mohd Ahmed Siddiqui
    Senior Integration Developer
    Saudi Arabia
    +966-532461642
    ------------------------------


  • 2.  RE: Database error

    Posted Mon April 01, 2024 01:40 AM

    Hi Mohd Ahmed, 

    Please be sure that there is no commit on the used SP. 



    ------------------------------
    Burak Görener
    ist
    +90262646 50 11
    ------------------------------

    Original Message


Related Content