App Connect

 View Only
  • 1.  ODBC connection issue in ACE v11 FP17

    Posted Tue April 26, 2022 05:30 PM
    I recently installed ACE v11 FP17 in both window and linux server and now facing a ODBC connection issue.  The connection works in the previous FP10 and FP15.   

    Please see the error below, the Oracle server is v19. 

    mqsicvp BRKACSBX -n ESBAUDIT
    BIP8299I: User 'esb_auditdei' from security resource name 'ESBAUDIT' will be use d for the connection to datasource 'ESBAUDIT'.
    BIP8290I: Verification passed for the ODBC environment.

    BIP2393E: Database error: ODBC return code '-1' from data source ''ESBAUDIT'' us ing ODBC driver manager ''/opt/IBM/ace-11.0.0.17/ie02/lib/libodbcinterface.so''.
    The integration node received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
    Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or th e integration node configuration. Use the mqsicvp command to test connectivity t o this database.
    BIP2322E: Database error: SQL State ''HY000''; Native Error Code '-5'; Error Tex t ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''.
    The error has the following diagnostic information: SQL State '' HY000'' SQL Native Error Code '-5' SQL Error Text ''[unixODBC][IB M][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''
    This message may be accompanied by other messages describing the effect on the i ntegration node itself. Use the reason identified in this message with the accom panying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.
    BIP2322E: Database error: SQL State ''08001''; Native Error Code '-5'; Error Tex t ''[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''.
    The error has the following diagnostic information: SQL State '' 08001'' SQL Native Error Code '-5' SQL Error Text ''[unixODBC][IB M][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''
    This message may be accompanied by other messages describing the effect on the i ntegration node itself. Use the reason identified in this message with the accom panying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.

    Wondering if anybody happens to see this issue, and how am I supposed to fix it, from the AppConnect client side or the Oracle server side.  

    Thanks,
    andy





    ------------------------------
    Andy Mao
    ------------------------------


  • 2.  RE: ODBC connection issue in ACE v11 FP17

    Posted Wed April 27, 2022 02:24 AM
    Hello Andy,

    I have found this link that might be useful for your case (even if it is IIB V10):
    https://www.ibm.com/support/pages/apar/IT28567

    ------------------------------
    Pierre Richelle
    IBM Hybrid Cloud Integration Specialists
    IBM
    +32474681892
    ------------------------------



  • 3.  RE: ODBC connection issue in ACE v11 FP17

    Posted Wed April 27, 2022 11:32 AM
    Thanks Pierre.

    I was testing the connection using mqsicvp command after right Node is restarted.  I don't think it falls into the log idle period scenario.  And other ODBC connections works just this one I mentioned.  Just wonder if anything may have to be reconfigured at the Oracle server side?  And also what was changed in FP 17 in terms of the Oracle ODBC driver? Why it worked in FP 15 but not FP 17?

    ------------------------------
    Andy Mao
    ------------------------------