Replication of DB from SQL server to Hana using MSSQLLOGREADER Adapter
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: : 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,