Skip to Content
avatar image
Former Member

Replication of DB from SQL server to Hana using MSSQLLOGREADER Adapter

Hi ,

I am trying to connect DB from SQL server in my system with Hana using MssqlLogReaderAdapter.

I am able to register my data provisioning agent and also getting the agent in the source location in HANA.

The MssqlLogReaderAdaper is also getting registered.

I have followed this document to setup my SQL Server http://help.sap.com/download/multimedia/hana_options_eim/SAP_HANA_EIM_Administration_Guide_en.pdf

When I am trying to create a New Remote Source. I fill all the details. But when I am trying to execute I am getting the following error :

Remote source updated

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: exception 151044: Agent "new_animesh_agent" is not available.

I am not sure what could be the reason for this error, as my agent is already available.

I have attached the screenshot of the configuration and the error.

Need Immediate help. If anyone could help me with this.

Thanks in advance.

Thanks & Regards,

Animesh Ghosh

logReader.png (33.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 19, 2016 at 09:58 AM

    Hello Animesh,

    I guess you already got help via an SAP Support Ticket and you propably solved the issue already (after looking into the agent log file), right?

    If not, could you please provide the agent log file (dpagent root folder/LogReader/<instance_name>/log/) first to enable us to see if it is a connectivity or other issue?

    Best regards,

    Tobias

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2016 at 11:55 AM

    Have you been able to resolve this?

    Add comment
    10|10000 characters needed characters exceeded