Scenarios in which ADB_L_DELIVERY_STATUS = 'F' or 'S' come in TIBCO ActiveMatrix BusinessWorks Plug-in for Database

Scenarios in which ADB_L_DELIVERY_STATUS = 'F' or 'S' come in TIBCO ActiveMatrix BusinessWorks Plug-in for Database

book

Article ID: KB0076222

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 8.x

Description

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.

Issue/Introduction

Scenarios in which ADB_L_DELIVERY_STATUS = 'F' or 'S' come in TIBCO ActiveMatrix BusinessWorks Plug-in for Database

Environment

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version:8.x OS: All Supported Operating Systems