Skip to Content
0

MSSQL Log Reader Adapter registration failed in dp agent host

Feb 05 at 12:30 PM

141

avatar image
Former Member

Hello Experts,

I'm facing an issue while implementing HANA SDI. Request you to please help in it.

I've installed DP agent on a Linux Redhat 7.4 host and able to connect it with the Hana DB and register flat file adapter. However, I'm facing issue while MSSQL adapters.

I raised this issue to SAP and they reverted back saying that HANA SDI is not compatible with Linux Redhat 7.4 version. Is it true that Hana SDI 2.0 sps02 is not compatible with Redhat 7.4?

Regards,

Amit Bharti

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 05 at 12:38 PM
0

I'm getting this error while registering MSSQL adapters.

*****************************************************************************************

Failed to register adapter. Context: Executing SQL statement "create adapter "MssqlECCAdapter" at location agent "dpagent_ussdsbxsadp01"" failed with SAP DBTech JDBC: [403]: internal error: Cannot get adapter capabilities: exception 151044: Agent "dpagent_ussdsbxsadp01" is not available. 2018-02-05 04:37:04,044 [ERROR] SocketConnector.read - Executing SQL statement "create adapter "MssqlECCAdapter" at location agent "dpagent_ussdsbxsadp01"" failed with SAP DBTech JDBC: [403]: internal error: Cannot get adapter capabilities: exception 151044: Agent "dpagent_ussdsbxsadp01" is not available. 2018-02-05 04:37:04,044 [ERROR] AgentConnection.submitRequest - Request Failed for ADMIN_REGISTER_ADAPTER Context: Executing SQL statement "create adapter "MssqlECCAdapter" at location agent "dpagent_ussdsbxsadp01"" failed with SAP DBTech JDBC: [403]: internal error: Cannot get adapter capabilities: exception 151044: Agent "dpagent_ussdsbxsadp01" is not available.

******************************************************************************************

Regards,

Amit Bharti

Share
10 |10000 characters needed characters left characters exceeded
Jeff Kresse
Feb 12 at 11:12 PM
0

Hi Amit,

I haven't found anything to suggest RHEL 7.4 is not supported. This looks like a problem with the DP Agent disconnecting. Can you check the agent monitoring view and see the last connection time for dpagent_ussdsbxsadp01?

SELECT TOP 1000 * FROM "SYS"."M_AGENTS"
---OR---
http://<HANA host>:<web server port>/sap/hana/im/dp/monitor/index.html?view=DPAgentMonitor<br>

Make sure the dpagent is connected to HANA, there could be firewall, proxy, SSL complications getting in the way. Is your HANA in the cloud, or do you have a physical HANA machine in your company's landscape?

What happens if you go to the DPAgentMonitor web page, select the agent, and click "Update Adapters"?

Best regards,

Jeff K

Share
10 |10000 characters needed characters left characters exceeded