Skip to Content
author's profile photo Former Member
0
Former Member

Real time data replication by using HANA EIM (Smart Data Integration)

Posted on May 27, 2015 at 01:18 PM 1.1k Views

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Richard LeBlanc
    Richard LeBlanc
    Posted on May 27, 2015 at 04:06 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2015 at 05:53 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2015 at 05:58 AM
    0

    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
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 31, 2015 at 02:04 PM

      Hi Jamie,

      Turns out we're still on 102.00 so next step is to get onto 102.03. We did some successful real time replication today but apply failed with an index out of bounds error which we're hoping will be fixed in 102.03. We're holding on SPS11 for now pending the results of 102.03.

      Will watch out for the data mismatches, thanks for the tip.

      Will update where we get to on here,

      Have a great New Year,

      Cheers,

      Jeff

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.