SAP Knowledge Base Article - Public

3483792 - Creating a Import data connection to SAP ERP in SAC results in error: "Please check the system number and try again"

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=1

    LOCATION    CPIC (TCP/IP) on local host with Unicode
    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.drivers.DDKExceptionImpl.convertToCSException(DDKExceptionImpl.java:157)
            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

  1. Go to SAC tenant
  2. Go to Connections page
  3. Create a new import connection for SAP ERP
  4. Fill in the required system details
  5. Click "Create" to create the connection
  6. 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

Product

SAP Analytics Cloud all versions