SAP HANA Smart Data Access - realtime replication

[Former Member]

Hello,

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,

Marc

[Former Member]

I am getting an error like below

SDI2/DataSourceTemplatetable.hdbflowgraph": validation error: ContainerNode: target schema cannot be empty. I am using IDES system as my source. The adapter is MSQQLog Reader adapter?

I was getting error for Realtime. I even unchecked that. Still getting this error.  The Container target schems is not empty per my understanding. What I could be missing?

[werner_daehn]

For realtime replication to work you need the realtime environment being setup and a realtime adapter being used.

So yes, Data Provisioning Server and the SQL Server Adapter of the Data Provisioning Agent has to be used.

The old SDA (ODBC) adapters do not support realtime.

[ugandhar_nandam1]

Hi Werner.

I was trying to execute Flow Graph with real time enabled and facing the below error,

Please help me with this.

Regards,

Ugandhar

[werner_daehn]

What is your source? A virtual table of type .....? Did you install that adapter or was it installed (ODBC) already?

[ugandhar_nandam1]

I'm using MS SQL Server database as source and also installed adapter.

[Former Member]

Hello Ugandhar ,

I am facing the same issue when execute procedure of Flow Graph with real time , did you find the solution to this issue ?

[Former Member]

Hi .. I am facing the exact issue in replication...did you find any solution..

[werner_daehn]

Any additional information to be found in the adapter log? It seems the Adapter got contacted, it wants to add the realtime subscription in the database but fails to do so. Maybe permissions, maybe a mandatory step not performed yet.

Hence the question if the adapter log has more information.

[ugandhar_nandam1]

Werner,

I'm trying to execute flowgraph procedure which is realtime enabled and below is the error displayed for Data Provisioning using MSSQLLogReaderAdapter.

I have already executed the script mssql_server_init.sql but could not understand how to initialize the specific database used for creation of remote source.

Please help me on this.

Regards,

Ugandhar