The ADB_TIMESTAMP published by TIBCO ActiveMatrix Adapter for Database 7.1.0 is misleading when using an Oracle Thin Driver.

The ADB_TIMESTAMP published by TIBCO ActiveMatrix Adapter for Database 7.1.0 is misleading when using an Oracle Thin Driver.

book

Article ID: KB0092985

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Description:
When Configuring TIBCO ActiveMatrix Adapter for Database 7.1.0 with Oracle Thin Driver, the ADB_TIMESTAMP column in messages published by TIBCO ActiveMatrix Adapter for Database 7.1.0 publication service is misleading.
Symptoms:
In the published message body:
*******************************************************************************************
2016 May 09 14:58:44:117 GMT +0800 oracle_native Debug [Publication] AEADB-323001 
Publication Service ADBPublisher thread oracle_native.ADBPublisher.DATAHANDLER.1
Publishing Message Info : 
  - class=P_A2_TMP2, values=[ADB_AGENT_ID=[oracle_native], ADB_OPCODE=[1], ADB_REF_OBJECT=[], ADB_SEQUENCE=[15], ADB_SET_SEQUENCE=[], ADB_SUBJECT=[], ADB_TIMESTAMP=[oracle.sql.TIMESTAMPTZ@7cba00ee], ADB_TRACKINGID=[], ADB_UPDATE_ALL=[], COL1=[1], COL2=[1]].
tracking=#-phAXrgMZ2yJ3-eVbAQcfOP-bMw#
*******************************************************************************************

ADB_TIMESTAMP with value [oracle.sql.TIMESTAMPTZ@7cba00ee] is misleading.

The expected result should be:
*********************************************************************************************
2016 May 09 15:12:41:066 GMT +0800 oracle_native Debug [Publication] AEADB-323001 
Publication Service ADBPublisher thread oracle_native.ADBPublisher.DATAHANDLER.1
Publishing Message Info : 
  - class=P_A2_TMP2, values=[ADB_AGENT_ID=[oracle_native], ADB_OPCODE=[1], ADB_REF_OBJECT=[], ADB_SEQUENCE=[16], ADB_SET_SEQUENCE=[], ADB_SUBJECT=[], ADB_TIMESTAMP=[2016-05-09T15:12:33.027000 +08:00], ADB_TRACKINGID=[], ADB_UPDATE_ALL=[], COL1=[2], COL2=[2]].
tracking=#mpV-SDMzZ3lOO--VM0QcfzLEbMw#
*********************************************************************************************


Cause:
TIBCO ActiveMatrix Adapter for Database 7.1.0 does not officially support the Oracle Thin Driver.

Issue/Introduction

The ADB_TIMESTAMP published by TIBCO ActiveMatrix Adapter for Database 7.1.0 is misleading when using an Oracle Thin Driver.

Environment

Product: TIBCO Adapter for ActiveDatabase Version: 7.1.0 OS: All Supported Operating Systems --------------------

Resolution

Use the TIBCO Database Drivers Supplement 2.0.0 - 2.0.1 instead of the Oracle Thin Driver.
Powered by Wolken Software