Resolution:
Description:
============
Adapter publisher failed to update ADB_L_DELIVERY_STATUS and kept publishing the same records over and over again or a subscriber did not update the records in the destination table.

Environment:
===========
All platform
ADB Adapter 6.0 hotfix2 (build 6.0.0.11), wired protocol for Oracle, Driver info: TIBORA32 05.30.0193 (B0121, U0085)
Oracle only

Symptoms:
========
1). Publisher failed to update ADB_L_DELIVERY_STATUS and kept publishing the same records over and over again.

2). Subscriber didn't update the records in the destination table but confirmed a message.

3). ODBC trace reported connection error, but adapter didn't show.

Cause:
=====
With the ODBC driver bundled in ADB Adapter 6.0 hotfix2, the wired protocol for Oracle did not detect a connection error when performing an update operation.

DataDirect confirmed this is a defect in the ODBC driver when there was a connection issue (network down, or exceed idle limit).

Resolution:
=========

1). Use a non-wired protocol or native driver. Refer to SOL1-AV6KXG for how to configure TIBCO ActiveMatrix® Adapter for Database to use non-wired driver on UNIX for Oracle database.

2). Revert to a previous version, i.e., ADB6.0 hotfix1.