SAP Knowledge Base Article - Public

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

Symptom

  • Create a ERP connection but they are getting error "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) 2020.20.3

Reproducing the Issue

  1. Create an import connection from SAC using the SAP ERP option.
  2. Error shows.

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