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
- Log on to SAC Analytics Cloud.
- Click on the Data Management in the workspace.
- Try to create a job, or select one exiting job and then click on Set Up Import.
- Perform some transformations and mapping.
- Continue to click on Next till to Review Import stage.
- 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
-
- 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 case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in 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 Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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