向HANA系统注册期间的DP代理问题

2020-08-20 10:16发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


尊敬的专家,

我们正在尝试通过部署在外部Windows Server主机上的DP代理配置HANA系统HAH和HANA系统EHQ上ECC之间的SDI远程数据源连接。


我们正在遵循SAP指南:URL上提供了" SAP HANA智能数据集成和SAP HANA智能数据质量2.0 SP02-安装和配置指南":


https://help.sap。 com/doc/dd356918159e4ba1a32927b0b917b78c/2.0_SPS02/zh-CN/SAP_HANA_EIM_Installation_and_Configuration_Guide_en.pdf

我们在此处提供所需的信息:

我们有:

SAP HANA:内部安装2.0 SPS02 rev24

Data Provisioning Agent部署在外部Windows服务器上:

版本和补丁程序级别:2.4.1.2
操作系统:Windows Server 2012 R2


网络信息:
DP代理和SAP HANA之间是否存在代理和防火墙? :我们不知道,但是我们打开了DP代理服务器和HANA HAH服务器之间的所有必需的TCP端口。是否使用SSL? :否
测试并确认DP Agent和HANA之间的连接是否稳定:成功完成

简而言之,我们在DP Agent上遇到的错误(增加了详细记录级别):

2020-03-20 15:15:29,573 [INFO] DPFramework | AgentJDBCUtil。 []-使用以下JDBC连接属性连接到HANA服务器:
2020-03-20 15:15:29,573 [INFO] DPFramework | AgentJDBCUtil.printJdbcConnectionProps []-连接URL = jdbc:

sap://: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 []-密码= ******
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 []-crypto = 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; 列: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; 列: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_located:RoutingHeaders:{RequestReceived << = 127.0.0.1:63151(63151)}
2020-03-20 15:15:29,747 [TRACE] DPFramework | AgentJDBCUtil.executePrepareStatement []-从PUBLIC.AGENTS中执行:: SELECT AGENT_NAME,而AGENT_NAME =?
2020-03-20 15:15:29,793 [ERROR] DPFramework | WorkerThread.processRequest []-com.sap.hana.dp.adapter.sdk.AdapterException:代理DP_AGENT尚未注册上下文:com.sap.hana.dp.adapter.sdk.AdapterException:代理DP_AGENT尚未注册
在com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.processIsAgentRegistered(AdminRequestHandler.java:1280)中
在com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.handleRequest(AdminRequestHandler.java:162)
在com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:177)上
在com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2021)中

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

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

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

有人遇到类似问题或有任何暗示吗?

感谢支持,

最诚挚的问候,

Marco Pattaro

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


尊敬的专家,

我们正在尝试通过部署在外部Windows Server主机上的DP代理配置HANA系统HAH和HANA系统EHQ上ECC之间的SDI远程数据源连接。


我们正在遵循SAP指南:URL上提供了" SAP HANA智能数据集成和SAP HANA智能数据质量2.0 SP02-安装和配置指南":


https://help.sap。 com/doc/dd356918159e4ba1a32927b0b917b78c/2.0_SPS02/zh-CN/SAP_HANA_EIM_Installation_and_Configuration_Guide_en.pdf

我们在此处提供所需的信息:

我们有:

SAP HANA:内部安装2.0 SPS02 rev24

Data Provisioning Agent部署在外部Windows服务器上:

版本和补丁程序级别:2.4.1.2
操作系统:Windows Server 2012 R2


网络信息:
DP代理和SAP HANA之间是否存在代理和防火墙? :我们不知道,但是我们打开了DP代理服务器和HANA HAH服务器之间的所有必需的TCP端口。是否使用SSL? :否
测试并确认DP Agent和HANA之间的连接是否稳定:成功完成

简而言之,我们在DP Agent上遇到的错误(增加了详细记录级别):

2020-03-20 15:15:29,573 [INFO] DPFramework | AgentJDBCUtil。 []-使用以下JDBC连接属性连接到HANA服务器:
2020-03-20 15:15:29,573 [INFO] DPFramework | AgentJDBCUtil.printJdbcConnectionProps []-连接URL = jdbc:

sap://: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 []-密码= ******
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 []-crypto = 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; 列: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; 列: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_located:RoutingHeaders:{RequestReceived << = 127.0.0.1:63151(63151)}
2020-03-20 15:15:29,747 [TRACE] DPFramework | AgentJDBCUtil.executePrepareStatement []-从PUBLIC.AGENTS中执行:: SELECT AGENT_NAME,而AGENT_NAME =?
2020-03-20 15:15:29,793 [ERROR] DPFramework | WorkerThread.processRequest []-com.sap.hana.dp.adapter.sdk.AdapterException:代理DP_AGENT尚未注册上下文:com.sap.hana.dp.adapter.sdk.AdapterException:代理DP_AGENT尚未注册
在com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.processIsAgentRegistered(AdminRequestHandler.java:1280)中
在com.sap.hana.dp.adapter.framework.core.AdminRequestHandler.handleRequest(AdminRequestHandler.java:162)
在com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:177)上
在com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2021)中

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

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

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

有人遇到类似问题或有任何暗示吗?

感谢支持,

最诚挚的问候,

Marco Pattaro

付费偷看设置
发送
1条回答
天桥码农
1楼-- · 2020-08-20 10:51

我知道您已经就此问题打开了一个事件,因此请继续进行事件处理。

一周热门 更多>