ODBC connection is throwing "optional feature not implemented" error
470196Nov 17 2008 — edited Nov 18 2008Hi Everyone,
I have been trying to get my TIBCO Active DataBase (ADB) adapter to connect properly to my Oracle XE database. I have tried various drivers (Oracle 10g, 11g and TIBCO/DataDirect 5.3) drivers. After some effort it is now connecting but when it runs the required select query it throws an error. WHat it should do is read a record from the P_TIBCOSRC table and publish that. But when it tries to read it fails. This is the log fromthe component:
*********************************************************
** TIBCO Adapter for ActiveDatabase Agent, 5.4.0.10
** TIBCO Adapter SDK, 5.5.0.12
**
** Copyright TIBCO Software, Inc., 1999-2008.
** All rights reserved.
*********************************************************
Instance ID: ADBTest
Config Name: ADBTest
Main thread (name: ADBTest)
**********************************************************
Application: ADBTest
RepoURL: D:\TIBCO\work\AT_adadb_20184.dat
ConfigURL: /tibco/private/adapter/ADBTest
Version: 5.4.0.10
Information: TIBCO Adapter for ActiveDatabase Agent
----------------------------------------------------------
Developed with TIBCO Adapter SDK 5.5.0.12
Copyright TIBCO Software Inc., 1998-2005.
All rights reserved.
**********************************************************
+2008 Nov 14 10:18:41:375 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700059+
Starting thread (name: ADBTest.COMM.INTERFACE.1 , id: 5296)
+2008 Nov 14 10:18:42:375 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700059+
Starting thread (name: ADBTest.DB.INTERFACE.1 , id: 5256)
+2008 Nov 14 10:18:42:375 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700059+
Starting thread (name: ADBTest.PUB.MANAGER.1 , id: 5252)
+2008 Nov 14 10:18:42:375 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700029+
Publication: (TIBCOSRC / P_TIBCOSRC / TIBCO_TEST_PUB / rv / aeRvMsg / Certified / 1 / POLL )
+2008 Nov 14 10:18:42:843 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700012+
Publication Cold start completed.
+2008 Nov 14 10:18:43:375 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700029+
Agent settings:
ADB 5.4.0.10
SDK 5.5.0.12
TIBRV 8.1.1
TIBRVCM 8.1.1
DB Driver: SQORA32.DLL, 11.01.0006
DSN: TIBCO
adb.verbose: on
adb.debug: 2
adb.PollingInterval: 5000
adb.PollingBatchSize: 0
adb.batchPubStatusUpdates: off
adb.pubBatchConfirmSize: 0
adb.pubBatchConfirmTimeout: 10000
adb.publishChildData: on
adb.useExceptTable: on
adb.rvMaxQueueSize: 0
adb.subBulkInsertSize: 1
adb.subBatchCommitSize: 0
adb.subBatchCommitTimeout: 10000
adb.encoding: ASCII
adb.perfMon: off
adb.RetryTotal: 3
adb.disconn.code: 3111;3112;3113;3114
adb.SleepBetweenRetries: 10000
adb.setEmptyStringNullForRvMsg: off
adb.useSqlColumns: off
adb.terminateOnPubFail: off
adb.rvAdvisoryNoLog: off
adb.setClientInfo: on
+2008 Nov 14 10:18:47:843 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700094+
Polling timer fired.
+2008 Nov 14 10:18:47:984 GMT 1 ADBTest.ADBTest Info Adapter AEADB-700001+
Publisher: SQL: SELECT * FROM P_TIBCOSRC WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE
+2008 Nov 14 10:18:49:078 GMT 1 ADBTest.ADBTest Error Database AEADB-100004+
DBError: Database driver code: HYC00
Database server code: 3
Database driver message: OracleODBCOraOptional feature not implemented.
+2008 Nov 14 10:18:49:078 GMT 1 ADBTest.ADBTest Error Database AEADB-930002+
Publication error. Publication service ADBPublisher with publication subject TIBCO_TEST_PUB encountered database error:
DBError: 5
ErrorCode: HYC00
ServerCode: 3
Message: OracleODBCOraOptional feature not implemented.
while trying to create publish event with schema P_TIBCOSRC. Database is TIBCO. The database command is SELECT * FROM P_TIBCOSRC WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE.
Stopping ADBTest...
I created a ODBC trace for this and that says the following:
AT_adadb_20184 1dec-21c4 ENTER SQLPrepare
HSTMT 011C3268
UCHAR * 0x0140FFA0 -3 "SELECT * FROM P_TIBCOSRC WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE\ 0"
SDWORD -3
AT_adadb_20184 1dec-21c4 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 011C3268
UCHAR * 0x0140FFA0 -3 "SELECT * FROM P_TIBCOSRC WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE\ 0"
SDWORD -3
AT_adadb_20184 1dec-21c4 ENTER SQLExecute
HSTMT 011C3268
AT_adadb_20184 1dec-21c4 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 011C3268
DIAG HYC00 OracleODBCOraOptional feature not implemented. (3)
AT_adadb_20184 1dec-21c4 ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 011C3268
SQLSMALLINT 1
SQLWCHAR * 0x09F8AF70 (NYI)
SQLINTEGER * 0x01B57CA0
SQLWCHAR * 0x011C3758 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x09F8AFBA
AT_adadb_20184 1dec-21c4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 011C3268
SQLSMALLINT 1
SQLWCHAR * 0x09F8AF70 (NYI)
SQLINTEGER * 0x01B57CA0 (3)
SQLWCHAR * 0x011C3758 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x09F8AFBA (52)
AT_adadb_20184 1dec-21c4 ENTER SQLCancel
HSTMT 011C3268
AT_adadb_20184 1dec-21c4 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 011C3268
This is all using the 11g ODBC driver (but I get similar logs using the DataDirect driver).
I have no idea what else I can do. I have tried the component with other ODBC connections (to MS Access) and that worked without problem so I think it has something to do with the Oracle ODBC connection. Does anyone have an idea what the issue might be?
Edited by: Deddiekoel on Nov 17, 2008 9:25 AM
Edited by: Deddiekoel on Nov 17, 2008 9:27 AM