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:
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?