Symptom
- In SAC, when creating a import data connection to SAP ERP system, after clicking create an error occurs:
"Please check the system number and try again" - Selected "Server Type" option as "Application Server"
- HAR logs may show a HTTP 500 response
- Response message displays "error_invalid_system_num"
- SAC Cloud agent logs (catalina.out) showed the following error message:
10-Jun-2024 12:59:29.006 SEVERE [http-nio-8080-exec-12] com.sap.fpa.cloud.rest.cs.service.ValidateLogonService.null CID[12172214-1112-4898-b447-532276407290] Initialization of destination CS_DEST-<YOUR SAP ERP SYSTEM HOSTNAME>--01-200-EN-SYS_MWFSMSAC-194516679-4d219d77-f96e-490f-9cb8-824aa914d398 failed: Connect to SAP gateway failed
connection parameters: TYPE=A DESTINATION=CS_DEST-<YOUR SAP ERP SYSTEM HOSTNAME>--01-200-EN-SYS_MWFSMSAC-194516679-4d219d77-f96e-490f-9cb8-824aa914d398 ASHOST=<YOUR APPLICATION SERVER HOSTNAME> SYSNR=01 PCS=1LOCATION CPIC (TCP/IP) on local host with Unicode
at com.sap.connectivity.cs.java.drivers.DDKExceptionImpl.convertToCSException(DDKExceptionImpl.java:157)
ERROR partner '<YOUR SAP ERP HOSTNAME>:<PORT>' not reached
TIME Mon Jun 10 12:59:28 2024
RELEASE 753
COMPONENT NI (network interface)
VERSION 40
RC -10
MODULE D:/depot/bas/753_REL/src/base/ni/nixxi.cpp
LINE 3458
DETAIL NiPConnect2: 172.30.28.186:3301
SYSTEM CALL connect
ERRNO 10061
ERRNO TEXT WSAECONNREFUSED: Connection refused
COUNTER 2
at com.sap.connectivity.cs.java.JAVAGenericJob.<init>(JAVAGenericJob.java:75)
at com.sap.connectivity.cs.java.JAVAJob.<init>(JAVAJob.java:32)
at com.sap.connectivity.cs.java.JAVAOpenJob.<init>(JAVAOpenJob.java:39)
at com.sap.connectivity.cs.java.OpenJob.<init>(OpenJob.java:66)
at com.sap.connectivity.cs.java.ConnectionServer.getJob(ConnectionServer.java:430)
at com.sap.connectivity.cs.core.ConnectionServer.CreateJob(ConnectionServer.java:74)
at com.sap.connectivity.cs.core.ConnectionServer.CreateJob(ConnectionServer.java:121)
at com.sap.connectivity.cs.core.ConnectionManager.TestConnection(ConnectionManager.java:155)
at com.sap.connectivity.cs.api.trace.ConnectionManagerLogger.TestConnection(ConnectionManagerLogger.java:596)
at com.sap.fpa.cloud.rest.cs.service.ValidateLogonService.execute(ValidateLogonService.java:45)
at com.sap.fpa.cloud.rest.RestCS.csRequest(RestCS.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.handleRequest(EpmDispatcherServlet.java:259)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:137)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doAndLog(EpmDispatcherServlet.java:94)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:596)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.sap.connectivity.cs.java.drivers.DDKExceptionImpl: Initialization of destination CS_DEST-<YOUR APPLICATION SERVER HOSTNAME>--01-200-EN-SYS_MWFSMSAC-194516679-4d219d77-f96e-490f-9cb8-824aa914d398 failed: Connect to SAP gateway failed
connection parameters: TYPE=A DESTINATION=CS_DEST-<YOUR APPLICATION SERVER HOSTNAME>--01-200-EN-SYS_MWFSMSAC-194516679-4d219d77-f96e-490f-9cb8-824aa914d398 ASHOST=<YOUR APPLICATION SERVER HOSTNAME> SYSNR=01 PCS=1
Environment
SAP Analytics Cloud (Enterprise)
FPA Version: 2024.8.10
CF tenant
Reproducing the Issue
- Go to SAC tenant
- Go to Connections page
- Create a new import connection for SAP ERP
- Fill in the required system details
- Click "Create" to create the connection
- Observe an error popup:
"Please check the system number and try again"
Cause
Network firewall inbetween the SAC Agent and SAP ERP system was blocking the SAC Agent from connecting to the SAP ERP system
Resolution
Adding/removing a firewall rule to allow SAC Agent to connect to the SAP ERP system on the specified "HOSTNAME:PORT" resolved the issue
See Also
Import Data Connection to an SAP ERP System
Firewall considerations for SAP Cloud Agent and Cloud Connector
Keywords
KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem