Skip to Content
0
Former Member
Mar 16, 2016 at 08:24 AM

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

517 Views

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