SAP Knowledge Base Article - Public

3283906 - Error "Import Connection Name failed to refresh because the schema of data source has been changed" is occurring while importing a public dimension in SAC tenant after repointing its connection to a different DB

Symptom

  • Import job fails with following error: "Import Connection Name failed to refresh because the schema of data source has been changed" for an exported public dimension and its associated connection via Content Network or File System from a tenant A to a tenant B. 
  • Behavior only occurring after repointing the dimension's connection to a different DB

Environment

  • SAP Analytics Cloud
  • Imported Model based on MS SQL connection.

Reproducing the Issue

  1. Logon to SAC tenant A
  2. Export a specific public dimension with the associated connection via content network or file system 
  3. Logon to SAC tenant B
  4. Import the exported package
  5. Change the connection's credentials to point to another DB
  6. Launch the existing import job
    >>Error "Import Connection Name failed to refresh because the schema of data source has been changed" displays

Cause

  • It is impossible in current product to update the new databased name modified in connection dialog into metadata of existing jobs as current SAC doesn't provide such feature.

Resolution

The function to update medatada in import job after changing setting in connection is considered as enhancement request, if you would like this function, it is suggested to raise an enhancement request follow below KBA.

2424376 - How do you create an enhancement request for SAP Analytics Cloud?

See Also

Keywords

SAC, sql, microsoft, metdata, change , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions