Explanation of the error "[DataDirect][ODBC 20101 driver]251" mean in TIBCO ActiveMatrix® Adapter for Database 5.5.0?

Explanation of the error "[DataDirect][ODBC 20101 driver]251" mean in TIBCO ActiveMatrix® Adapter for Database 5.5.0?

book

Article ID: KB0090182

calendar_today

Updated On:

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

Description

Resolution:
Description:
============
When ADB 5.5.0 applications are started the following error is seen:
---------------------------------------------------------------------------
2010 Jan 21 11:46:14:376 GMT +1 ActiveDatabaseAdapterConfiguration.KenanEvents-ActiveDatabaseAdapterConfiguration Error [Database] AEADB-930002
        Publication error. Publication service ADBPublisher with publication subject accenture.KenanADB encountered database error:

DBError: 5
ErrorCode: 102
ServerCode: 0
Message: [DataDirect][ODBC 20101 driver]251

while trying to create publish event with schema P_A2S_ACTION_DISPATCH. Database is tibcoOracle. The database command is SELECT * FROM P_A2S_ACTION_DISPATCH WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE.

2010 Jan 21 11:46:19:380 GMT +1 ActiveDatabaseAdapterConfiguration.KenanEvents-ActiveDatabaseAdapterConfiguration Info [Adapter] AEADB-700094
        Polling timer fired.
---------------------------------------------------------------------------
        
Environment:
==========
All unix/linux platforms that support ADB5.5
Oracle database
ADB5.5

Resolution:
=========
Driver error code 251 corresponds to 'Optional Feature not implemented'.

To correct this issue, change the value of the property "EnableTimestampWithTimeZone" and “EnableNcharSupport” from 0 to 1 in the odbc.ini file for the DSN [tibcoOracle].

Check whether you are using any unsupported datatypes.
Refer to the user guide -> Chapter 8(Advanced Features) -> Data types for the supported datatypes.

Issue/Introduction

Explanation of the error "[DataDirect][ODBC 20101 driver]251" mean in TIBCO ActiveMatrix® Adapter for Database 5.5.0?