sententia
Home    Blog

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))
/