JDBC Insert Notification Not working in IT Env

JDBC adapter - 6.0.3 / Sybase

When i ported my package from DEV to IT, adapter notification is not working saying Buffer table does not exists.

WMBbafl22q not found. ( Buffer Table )

Should I copy the buffer table and trigger in DEV DB to QA DB

What is the best practice ?

Please help

Error

[SCC.0121.0035E] resource delisted with TMFAIL flag, transaction marked for rollback. xid = cpstst07/1092359641064 rxid = [FormatId=45744, GlobalId=cpstst07/1092359641064, BranchQual=1] Stack trace data … 22a785f0eccb11d88c69fbe97f22ef18 NULL 22a785f0eccb11d88c69fbe97f22ef18

HR_Employee.Adapters:NotificationHREmployee [ART.116.3001] Adapter Runtime (Notification): Notification error during execution of
HR_Employee.Adapters:NotificationHREmployee. Error: [ADA.1.316] Cannot execute the SQL statement “SELECT t1.SPEED_ID,t1.SPEED_SEQ,t1.EMPLID,t1.BADGE_NBR,t1.USERID,t1.FIRST_NAME,t1.MIDDLE_NAME,t1.LAST_NAME,t1.BIRTH_DT,t1.NATIONAL_ID,t1.EMPL_STATUS,t1.HIRE_DT,t1.TERMINATION_DT,t1.DEPTID,t1.WORK_EMAIL_NOTES,t1.HOURLY_RT,t1.SPE_PAY_FREQUENCY,t1.BENEFIT_GROUP,t1.HOME_ADDRESS1,t1.HOME_ADDRESS2,t1.HOME_ADDRESS3,t1.HOME_ADDRESS4,t1.HOME_CITY,t1.HOME_STATE,t1.HOME_POSTAL_CODE,t1.HOME_COUNTRY,t1.GENDER,t1.EMER_CONTACT_NAME,t1.EMER_CNTCT_PHONE,t1.OCCUPATION_CODE,t1.SPE_COMPANY_CODE,t1.COMP_FREQUENCY,t1.EFFDT,t1.REHIRE_DT,t1.SERVICE_DATE,t1.SPE_BUS_PARTNER,t1.SPE_ACCOUNT,t1.BUSINESS_UNIT,t1.SPE_TERRITORY_ID,t1.SPE_PRODUCT_EPISOD,t1.INTFC_DTTM,t1.INTFC_STATUS,t1.INTFC_MSG,t1.wm_rowid,t1.wm_sendTime FROM WMBbafl22q t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. " (42000/208) WMBbafl22q not found. Specify owner.objectname or use s Stack trace data … 22a785f0eccb11d88c69fbe97f22ef18 NULL 22a785f0eccb11d88c69fbe97f22ef18
2004-08-12 18:50:21 PDT

HR_Employee.Adapters:NotificationHREmployee [ADA.1.316] Cannot execute the SQL statement “SELECT t1.SPEED_ID,t1.SPEED_SEQ,t1.EMPLID,t1.BADGE_NBR,t1.USERID,t1.FIRST_NAME,t1.MIDDLE_NAME,t1.LAST_NAME,t1.BIRTH_DT,t1.NATIONAL_ID,t1.EMPL_STATUS,t1.HIRE_DT,t1.TERMINATION_DT,t1.DEPTID,t1.WORK_EMAIL_NOTES,t1.HOURLY_RT,t1.SPE_PAY_FREQUENCY,t1.BENEFIT_GROUP,t1.HOME_ADDRESS1,t1.HOME_ADDRESS2,t1.HOME_ADDRESS3,t1.HOME_ADDRESS4,t1.HOME_CITY,t1.HOME_STATE,t1.HOME_POSTAL_CODE,t1.HOME_COUNTRY,t1.GENDER,t1.EMER_CONTACT_NAME,t1.EMER_CNTCT_PHONE,t1.OCCUPATION_CODE,t1.SPE_COMPANY_CODE,t1.COMP_FREQUENCY,t1.EFFDT,t1.REHIRE_DT,t1.SERVICE_DATE,t1.SPE_BUS_PARTNER,t1.SPE_ACCOUNT,t1.BUSINESS_UNIT,t1.SPE_TERRITORY_ID,t1.SPE_PRODUCT_EPISOD,t1.INTFC_DTTM,t1.INTFC_STATUS,t1.INTFC_MSG,t1.wm_rowid,t1.wm_sendTime FROM WMBbafl22q t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. " (42000/208) WMBbafl22q not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). " WMBbafl22q not found. Specify owner.objectname or use sp_help to Stack trace data … 22a785f0eccb11d88c69fbe97f22ef18 NULL 22a785f0eccb11d88c69fbe97f22ef18
2004-08-12 18:50:21 PDT

HR_Employee.Adapters:NotificationHREmployee WMBbafl22q not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Stack trace data … 22a785f0eccb11d88c69fbe97f22ef18 NULL 22a785f0eccb11d88c69fbe97f22ef18

Thx

Geo

GeoPaul,
Check to see if this helps you.

Recommendations for the JDBC Adapter notifications migration

Here is the Description of the Article:
It is typical to have identical production and testing environments. There are some cases when migration of the JDBC Adapter notifications between environments can cause a problem.

And GeoPaul,
It is good idea to have Notification in “disabled” state during migration.

  • Saurabh.