Skip to Content
0

SAP HANA SDI - CDC add subscription failed: Agent has shutdown

Dec 22, 2016 at 01:10 PM

796

avatar image
Former Member

Hi,

I'm trying to replicate a table from my SAP IDES instance (MSSQL Server Database) to my HCP Account (not trial). I have already installed the agent and followed the MS SQL Server Log Reader Adapter configuration described in SDI Administration Guide.

The initial load is working fine and I can see the table data in my HANA instance. But when I try to run with Realtime option, I get the following error message:

InternalError: dberror($.hdb.Connection.executeProcedure):

256 - SQL error, server error code: 256. sql processing error: "SDI_USER"."vaees.vaeesSRM.data::VSIDES_2_HCP.START_REPLICATION": line 42 col 4 (at pos 1809):

[256] (range 3) sql processing error exception: sql processing error: QUEUE: vaees.vaeesSRM.data::VSIDES_2_HCP.SUB_VT_ecc_T001W: Failed to add subscription for remote subscription vaees.vaeesSRM.data::VSIDES_2_HCP.SUB_VT_ecc_T001W[id = 1235522] in remote source VSIDES[id = 1235326].

Error: exception 151050: CDC add subscription failed: Agent has shutdown.

This is the same error message I get if I try to manually run the SQL command:

ALTER REMOTE SUBSCRIPTION "vaees.vaeesSRM.data::VSIDES_2_HCP.SUB_VT_ecc_T001W" QUEUE

Any idea how to have this problem fixed?

Regards,

Gustavo

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member May 27, 2017 at 12:33 AM
0

Hi all,

in case anyone faces this same issue, it was being cause by memory issue in the server where the DP Agente was installed.

Note 2399187 explains how to fix it.

Regards,

Gustavo

Share
10 |10000 characters needed characters left characters exceeded