Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 8.x |
Scenarios in which ADB_L_DELIVERY_STATUS = 'F' or 'S' come in TIBCO ActiveMatrix BusinessWorks Plug-in for Database i) The delivery status will be updated to 'F' in the below scenarios: - when no corresponding record is found in the source table for publish by reference - when the DBSqlException occurrs (except for DBSqlException caused due to broken network)
This error means that a fetch has been attempted from a cursor which is no longer valid. Below is the example:
>>>>
com.tibco.adapter.adb.database.DBSQLException:
java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01002: fetch out of sequence
at com.tibco.adapter.adb.database.DBUtil.generateDBSQLException(Unknown Source)
at com.tibco.adapter.adb.database.DBResultSet.next(Unknown Source)
at com.tibco.adapter.adb.service.ADBPublicationDataHandler.pollingMessage(Unknown Source)
at com.tibco.adapter.adb.service.ADBPublicationDataHandler.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)
<<<<
ii) The delivery status will be updated to 'S' as a load balancing marker when the Load balancing feature is enabled.