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 ONE Support launchpad (Login required).

Search for additional results

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