SAP Knowledge Base Article - Public

3581901 - "Server Error: Failed to fetch restrictions" occurs on Review Import after setting up import job in SAP Analytics Cloud

Symptom

  • After uploading data into a new model, the mapping of dimension and measure are successfully, but when try to fetch the restrictions in Review Import, the error message "Server Error: Failed to fetch restrictions" occurs
  • In HAR file, shows the below error log: 
    ERROR: Unable to update source table validation columns (Error Code: 3015)   

Environment

  • SAP Analytics Cloud, Enterprise Edition 2025.1.6 

Reproducing the Issue

  1. Log on to SAC Analytics Cloud.
  2. Click on the Data Management in the workspace.
  3. Try to create a job, or select one exiting job and then click on Set Up Import.
  4. Perform some transformations and mapping.
  5. Continue to click on Next till to Review Import stage.
  6. Switch to Dimension Restriction tab.
    => The error message ."Server Error: Failed to fetch restrictions" occurs.

Cause

When perform some transformations and mapping, wrongly map a "Date" column to Version, the Version member id should be a "String" column, in the format like "public.xxx".

Resolution

When perform mapping, changed the Version column type from “Date” to “String” and the issue has been resolved.

See Also

Keywords

SAC, SAC Analytics Cloud, model, review import, set up import, unpivot, dimension properties, transpose columns, restrictions  , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem

Product

SAP Analytics Cloud 1.0