I am trying to set up real-time replication task to replicate VBRK table from SAP ECC using ECC adaptor. I followed the steps outlined by HANA Academy in this video.
https://www.youtube.com/watch?v=eCgSB0y7_hI&list=PLkzo92owKnVwQ_preA3cxlQjn_v3W0Eh5&index=6
When I call procedure for this replication, I get the following error.
Could not execute 'call "SAPD02"."TEST_SDI.SDQ_SDI::REAL_TIME_REP_SP"' in 10:12.921 minutes .
[129]: transaction rolled back by an internal error: [129] "SAPD02"."TEST_SDI.SDQ_SDI::REAL_TIME_REP_SP": line 5 col 1 (at pos 115): [129] (range 3): transaction rolled back by an internal error: sql processing error: QUEUE: TEST_SDI.SDQ_SDI::REAL_TIME_REP_RS: Failed to add subscription for remote subscription TEST_SDI.SDQ_SDI::REAL_TIME_REP_RS.Error: exception 151050: CDC add subscription failed: Request timed out.
: line 1 col 1 (at pos 0)
Any ideas on what I may be doing wrong?
Hi Abhi,
It could be many things, let's try and figure what the problem is.
Did you configure the underlying database as defined in the HANA EIM Administration Guide?
If so, can you have a look at the following logs to see if there are any errors and post some info about it?
dp agent - /usr/sap/dataprovagent/logs/framework.log
replication admin logs - /usr/sap/dataprovagent/LogReader/admin_logs/adminxyz.log
replication instance log - /usr/sap/dataprovagent/LogReader/<instance_name>/log/<instance_name>.log
Best Regards,
Richard
Hi,
I was wondering if a resolution to this has been found as I am experiencing the same (or a similar issue). As a summary, we are running HANA SPS10 and my remote source is SQL Server 2012. I have created a flowgraph model and can successfully execute a non-realtime flowgraph. Presumably this confirms that all the necessary prereqs (particularly on the remote database) are in place. When I select the "Realtime" option on the canvas and the data source node, I receive the following error:
SAP DBTech JDBC: [256]: sql processing error: "HANA_UK"."afm_project::REALTIME_SP": line 6 col 1 (at pos 187): [256] (range 3) sql processing error exception: sql processing error: QUEUE: afm_project::REALTIME_RS: Failed to add subscription for remote subscription afm_project::REALTIME_RS.Error: exception 151050: CDC add subscription failed: NullPointerException while processing request "CDC Request for MssqlLogReaderAdapter for request type CDC_ADD_SUBSCRIPTION"
Any advice would be greatly received.
Thanks
Hi Abhishek,
We had the same error on a OracleLogReaderAdapter after we had recreated the remote source. Basically, I dropped the agent and re-added it.
If you have done this (or you need to do this), you will need to complete the following steps:
Unregister the agent. This will cause a cascade delete of the remote source and all virtual tables created.
Stop the Agent service.
In the <agent install folder> (dataprovagent), under the LogReader directory, delete the complete directory relating to the remote source attached to the agent. For example, if the remote source was attached to an instance name 'abcd' so I deleted the whole directory named 'abcd'.
In the same LogReader directory, in the scripts directory is a *_logreader_script pertaining to your database type.
Then go through the steps to create the register the agent, register the adapter and create the remote source again.
I know it sounds painful, but it was the only way we could get it to work again.
It may pay to try the same thing for other CDC adapter types.
Hope this helps.
Jamie
Add a comment