Replication of DB from SQL server to Hana using MSSQLLOGREADER Adapter

[former_member198968]

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

[Former Member]

Have you been able to resolve this?

[Former Member]

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