3491293 - "Unable to connect to data source" and "Error in validating connection definition and credentials on fields: [serviceRootURI]" when creating SAC connection using Cloud Connector Mapping

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

When creating a new import connection to S/4HANA or another connection type that uses Cloud Connector Mappings, the error message is shown:

• 'Unable to connect to data source. Check the connection details and user credentials, and then try again'

Inside the HAR file, the following error message is visible:

• "Error in validating connection definition and credentials on fields: [serviceRootURI] (If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)"

• SAP Analytics Cloud

1. Go to SAC connections and attempt to create one that required Cloud Connector component
   • Example: Import Connection to S/4HANA on prem:
2. Fill in the connection fields;
3. Click Create button;
4. Error message appears:
   'Unable to connect to data source. Check the connection details and user credentials, and then try again'. 
   • HAR file will show message ""Error in validating connection definition and credentials on fields: [serviceRootURI]..."

The connection may be happening because your CC mapping has an incorrect character "_".

The following screenshot shows examples of Incorrect and Correct Host Mappings at Cloud Connector.

NOTE: Following KBA from Cloud Connector team (BC-MID-SCC) describes what is expected to describe your hostname and allowed characters to delimit components of domain names. 

• 0003280813 - Error while adding host in Cloud Connector - "Invalid or missing input"

After creating a new mapping and changing "_" or ".", the connection should work fine (if other configuration is already in place).

Ensure your Cloud Connector version up to date accordingly to below KBA.

• 3302250 - Cloud Connector support strategy

Cloud Connector, _, invalid character, SAC, connection, hostname, virtual host, serviceRootURI , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-LDC , SAC Live Data Connection , Problem