Skip to Content
Former Member
Mar 24, 2015 at 03:07 PM

SAP HANA Smart Data Access - realtime replication



I tried to setup a realtime data replication like in the video: SAP HANA Academy - Smart Data Integration/Quality : SAP ECC Replication [SPS09] - YouTube

I have connected an Micrsosoft SQL Server as Remote Resouce with the Smart Data Access and added a virtual table for replication.

Now I would like to create a Flowgraph Model for realtime data replication.

I have selected Flowgraph for Activation as Task Plan and selected the virtual table as data source. The target is a Data Sink (template table).

I have selected realtime behaviour in the containerNode as well as in the data source. The activation of the flowgraph model was successful.

If I try to call the created procedure to start the task plan I get to error:

Could not execute 'call "MSSQL"."MSSQL::realtime_SP"' in 262 ms 426 µs .

[129]: transaction rolled back by an internal error: [129] "MSSQL"."MSSQL::realtime_SP": line 5 col 1 (at pos 98): [129] (range 3): transaction rolled back by an internal error: sql processing error: QUEUE: MSSQL::realtime_RS: Failed to add subscription for remote subscription MSSQL::realtime_RS.Error: exception 151050: CDC add subscription failed: Unable to obtain agent name where remote source id = 153481

Is it possible to solve this issue?

Or is a running SAP Hana Data Provisioning Agent necessary for the realtime replication?

Best regards,