SAP Knowledge Base Article - Public

2980362 - Error when trying to establish import data connection to ERP system from SAP Analytics Cloud (SAC)

Symptom

  • When trying to create an ERP connection, the following error appears: "Unable to connect to xxx. Ensure that the connection details are correct
  • Network trace shows errorDetails: [{messageId: "ERROR_INVALID_CONNECTION_INFO",…}]
  • Tomcat log shows:  Caused by: com.sap.connectivity.foundation.impl.ConnectionError: org.xml.sax.SAXParseException; lineNumber: 7; columnNumber: 75; The entity name must immediately follow the '&' in the entity reference.
    06-Oct-2020 13:06:48.689 SEVERE [http-nio-8080-exec-9] com.sap.fpa.logging.CoreLogger.log ERROR_INVALID_CONNECTION_INFO

Environment

  • SAP Analytics Cloud (Enterprise)
  • Import Data Connection to an SAP ERP system

Reproducing the Issue

  1. Create an import connection from SAC using the SAP ERP option.
  2. Connection cannot be established and it fails with the error message.

Cause

The SAP ERP user's password contains special characters.

Resolution

Remove special characters from password.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, right, role, bw , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0