Skip to Content
avatar image
Former Member

MSSQL Log Reader Adapter registration failed in dp agent host

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 11:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded