DP Agent issue during registration to HANA system

[former_member611060]

Dear Experts,

we are trying to configure SDI Remote Data Source Connection between HANA system HAH and ECC on HANA system EHQ through DP Agent deployed on external Windows Server host.

We are following SAP guide: "SAP HANA Smart Data Integration and SAP HANA Smart Data Quality 2.0 SP02 - Installation and Configuration Guide" available at URL:

https://help.sap.com/doc/dd356918159e4ba1a32927b0b917b78c/2.0_SPS02/en-US/SAP_HANA_EIM_Installation_...

We provide here the requested info :

We have:

SAP HANA : 2.0 SPS02 rev24 on premise

Data Provisioning Agent deployed on external Windows server:

Version and patch level: 2.4.1.2
Operating System: Windows Server 2012 R2

Network information:
Is there a Proxy and Firewall between DP Agent and SAP HANA? : We don't know, however we opened all needed TCP ports between DP Agent server and HANA HAH server
Is SSL used? : No
Test and confirm that connectiviy between DP Agent and HANA is stable : successfully done

Briefly, the error we get on DP Agent (increasing the verbosity log level):

2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.<init> [] - Connecting to HANA server with these JDBC connection properties:
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - Connection URL = jdbc:

sap://<HANA_db_host>:30015

2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - user=SYSTEM
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - password=******
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - hostNameInCertificate=*
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - sessionVariable:APPLICATION=SAP_SDI_HDI
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - communicationTimeout=120000
2020-03-20 15:15:29,573 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - encrypt=true
2020-03-20 15:15:29,574 [INFO ] DPFramework | AgentJDBCUtil.printJdbcConnectionProps [] - validateCertificate=false
2020-03-20 15:15:29,746 [TRACE] DPFramework | MemoryBoundedQueue.adjustUsage [] - WTRQ(249): 544, [Pool: max=2gb,cur=544b,peak=989.45kb,tot=26.12mb; Queue: cur=1(544b),peak=1(207.74kb),tot=54(2.58mb)]
2020-03-20 15:15:29,746 [TRACE] DPFramework | MemoryBoundedQueue.adjustUsage [] - WTRQ(249): -544, [Pool: max=2gb,cur=0b,peak=989.45kb,tot=26.12mb; Queue: cur=0(0b),peak=1(207.74kb),tot=54(2.58mb)]
2020-03-20 15:15:29,747 [DEBUG] DPFramework | ResponseQueuePool.handleObject [] - WTRQ(249) -> 127.0.0.1:63151: 144:68:SUCCESS_MSG:SDA:1:DP_AGENT::::0:0:ADMIN_SET_CONFIG_PROPERTIES:RoutingHeaders :{WorkerThread>>=ResponseQ, ResponseHandlerThread=WriteTo@63151}
2020-03-20 15:15:29,747 [DEBUG] DPFramework | SocketConnector.write [] - >>144:68:SUCCESS_MSG:SDA:1:DP_AGENT::::0:0:ADMIN_SET_CONFIG_PROPERTIES:RoutingHeaders :{WorkerThread>>=ResponseQ, ResponseHandlerThread=WriteTo@63151}
2020-03-20 15:15:29,747 [DEBUG] DPFramework | SocketConnector.read [] - <<68:68:ADMIN_IS_AGENT_REGISTERED:SDA:1:DP_AGENT::::0:0:ADMIN_IS_AGENT_REGISTERED:RoutingHeaders :{RequestReceived<<=127.0.0.1:63151(63151)}
2020-03-20 15:15:29,747 [TRACE] DPFramework | AgentJDBCUtil.executePrepareStatement [] - Executing::SELECT AGENT_NAME from PUBLIC.AGENTS WHERE AGENT_NAME=?
2020-03-20 15:15:29,793 [ERROR] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: Agent DP_AGENT is not yet registered Context: com.sap.hana.dp.adapter.sdk.AdapterException: Agent DP_AGENT is not yet registered

at com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.processIsAgentRegistered(AdminRequestHandler.java:1280)

at com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.handleRequest(AdminRequestHandler.java:162)

at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:177)

at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2021)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:836)

Anybody faced similar issue or has some hint ?

Thanks for support,

best regards,

Marco Pattaro

[cardealt]

Hello, I have been this same problem. What the solution, do you may share with me please?