SAP Knowledge Base Article - Preview

3071191 - Replication Task Error PostgreSQL Remote Source - ALTER_REMOTE_SUBSCRIPTION_QUEUE


DPAgent HANA was configured with SAP HANA Provisioning Agent Configuration and postgreSQL connector.

RemoteSource was created correctly, so read/write of the tables in the remote source with the SYSTEM HANA user and then create a ReplicationTask.
Deploy the replication task without errors, but when launch the task the following error appears:

[16:13:28] InternalError: dberror($.hdb.Connection.executeProcedure): 686 - SQL error, server error code: 686. start task error: "TGK_0123"."SDA_SDI::ReplicationTask_Sample.START_REPLICATION": line 27 col 7 (at pos 1076): [140038] Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "TGK_0123"."SUB_ReplicationTask_Analytics_public_dati_saldi_lordi_sample" QUEUE'. ,exception 71000256: QUEUE: SUB_ReplicationTask_Analytics_public_dati_saldi_lordi_sample: Failed to add subscription for remotesubscription SUB_ReplicationTask_Analytics_public_dati_saldi_lordi_sample[id = 1487244] in remote source ANALYTICS[id = 1477870]. Error: exception 151050: CDC add subscription failed: CDC open() error: Error creating bean with name 'PostgreSQLLogReaderAdapter' defined in file [C:usrsapdataprovagentLogReaderconfigpostgresql.xml]: Unsatisfied dependency expressed through constructor parameter 4;nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'LogReader' defined in file [C:usrsapdataprovagentLogReaderconfigpostgresql.xml]:Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'OperationProcessor'defined in file [C:usrsapdataprovagentLogReaderconfigpostgresql.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed toinstantiate []: Constructor threw exception; nested exception is java.lang.RuntimeException: SQLScript/Executor/Evaluator/SeEvaluatorImpl.cpp:747





SAP HANA, platform edition 2.0


KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.