Tibco Active Database Adapter Error [Database] AEADB-100004
Full error from console window shown below:
2011 Aug 17 12:40:41:817 GMT -4 ActiveDatabaseAdapterConfiguration.ActiveDatabaseAdapterConfiguration Info [Adapter] AEADB-700001
Publisher: SQL: SELECT * FROM CEG_SS_PERSONS WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE
2011 Aug 17 12:40:41:879 GMT -4 ActiveDatabaseAdapterConfiguration.ActiveDatabaseAdapterConfiguration Error [Database] AEADB-100004
DBError: Database driver code: HYC00
Database server code: 0
Database driver message: [tibcosoftwareinc][ODBC Oracle Wire Protocol driver]Optional feature not implemented.
2011 Aug 17 12:40:41:973 GMT -4 ActiveDatabaseAdapterConfiguration.ActiveDatabaseAdapterConfiguration Error [Database] AEADB-930002
Publication error. Publication service SsPersons with publication subject CEG.US.CNG.SSDS.PERSON.INTERNAL.CCNPP encountered database error:
DBError: 5
ErrorCode: HYC00
ServerCode: 0
Message: [tibcosoftwareinc][ODBC Oracle Wire Protocol driver]Optional feature not implemented.
while trying to create publish event with schema CEG_SS_PERSONS. Database is CONN_SSDST. The database command is SELECT * FROM CEG_SS_PERSONS WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE.
The tibco table was created as:
desc ceg_tibco_ssper
Name Null Type
--------------------- -------- ---------------------------
PERSON_GEN_NBR NOT NULL NUMBER(10)
ID_TYPE NOT NULL VARCHAR2(1)
PERSON_ID NOT NULL VARCHAR2(12)
NAME_LAST NOT NULL VARCHAR2(30)
NAME_MIDDLE VARCHAR2(30)
NAME_FIRST NOT NULL VARCHAR2(30)
ADB_SUBJECT VARCHAR2(255)
ADB_SEQUENCE NOT NULL NUMBER(38)
ADB_SET_SEQUENCE NUMBER(38)
ADB_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE
ADB_OPCODE NOT NULL NUMBER(38)
ADB_UPDATE_ALL NUMBER(38)
ADB_REF_OBJECT VARCHAR2(64)
ADB_L_DELIVERY_STATUS CHAR(1)
ADB_L_CMSEQUENCE NUMBER(38)
ADB_TRACKINGID VARCHAR2(40)
Needed to run
ALTER TABLE ceg_tibco_ssper
MODIFY (adb_timestamp date))
/