Hi All,
We are getting intermittent ODBC error code "-1" in response from servers, When some IIB services interaction with database. However for same inputs sometime services working fine, sometime services responding like "ODBC error code "-1"".
BIP2934E: Error detected whilst executing the function or procedure ''cDatabaseRead''.
The integration node detected an error whilst executing the function or procedure ''cDatabaseRead''. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error. : /build/slot3/S1000_P/src/DataFlowEngine/ImbRdl/ImbRdlRoutine.cpp: 1425: SqlRoutine::invoke: :
BIP2488E: ('LIB_Core.cDatabaseRead', '6.2') Error detected whilst executing the SQL statement ''SET DB_OUT_PARAMS.{RESULT_BRANCH_NAME}[] = DEFAULTPASSTHRU(SQL_STATEMENT, DB_IN_PARAMS.*:*[]);''.
The integration node detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error. : /build/slot3/S1000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 767: SqlStatementGroup::execute: :
BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager ''/opt/IBM/iib-10.0.0.13/ie02/lib/libodbcinterface.so''.
The 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.
Use 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. : /build/slot3/S1000_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp: 3814: ImbOdbcStatement::checkRcInner: :
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '1'; Error Text ''Unfortunatley couldn't get this paramater's info''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '1' SQL Error Text ''Unfortunatley couldn't get this paramater's info''
This 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. : /build/slot3/S1000_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp: 4035: ImbOdbcStatement::checkRcInner: :
Please suggest.
Thanks,
Akshay
------------------------------
Akshay Sabale
------------------------------