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

• 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

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

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

The SAP ERP user's password contains special characters.

Remove special characters from password.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

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