SDI HANA Adapter: Alter remote subscription *** QUEUE returns error

[Former Member]

Hi All,

We have two HANA DB: SDB as target and HD0 as the remote source. We tried to use HanaAdapter to replicate data from HD0 to SDB.

But when we tried to execute ALTER REMOTE SUBSCRIPTION "ADAPTER_TEST"."ADAPTER_TEST::HD0_HANA_SAPCH.SUB_VT_PRODUCT" RESET an exception returned.

The Framework.trc shows:

2016-03-16 14:01:39,158 [ERROR] com.sap.hana.dp.cdcadaptercommons.triggerbased.TriggerBasedReplicationAdmin.subscribe[184]    - Error occurred in the middle of subscribing table [HADP_MARKERS]

2016-03-16 14:01:39,229 [ERROR] com.sap.hana.dp.cdcadaptercommons.triggerbased.TriggerBasedReplicationAdmin.initialize[97]    - Error occurred in the middle of replication environment initialization. Drop those system objects that were already created during initialization.

2016-03-16 14:01:39,307 [ERROR] com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest[245]    - Exception while processing requrest "CDC Request for HanaAdapter for request type CDC_ADD_SUBSCRIPTION"

2016-03-16 14:01:39,307 [ERROR] com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest[246]    - Failed to create triggers for [HADP_MARKERS]. Context: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [328] (at 287): invalid name of function or procedure: CURRENT_UPDATE_TRANSACTION: line 6 col 12 (at pos 287)

                                at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)

                                at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:176)

..........

Anybody knows how to fix this problem? Thank you very much!

Regards,

Carina

[Former Member]

Hi Carina,

have you already found a solution to your problem? I have the exact same problem.

Thanks,

Annika