Symptom
Using File Server import data connection in SAP Analytics Cloud (SAC), import jobs started to reject all the rows via message: "Invalid measure values".
Recreating the jobs based on the same mapping will solve the issue. However, the initial jobs still seem to be corrupted, even though, there doesn't seem to be any format change on the data source side.
Environment
- SAP Analytics Cloud (Enterprise) 2024.8.16
Reproducing the Issue
- Run the existing import job in SAC (either manually or scheduled).
- Notice that all rows are rejected via "Invalid measure values".
- Recreate the same job in the model and see that it works fine.
Cause
In case of the import job of the rejected rows, the format is set to a period "." for columns of decimal data type.
In case of the newly created import job that works as desired, the format is set to a comma "," for columns of decimal data type.
The format of decimal data type was changed from "." to "," on the data source side, causing all the rows to be rejected of the initial import job.
Resolution
To fix the issue of rejected rows, the format for columns of decimal data type should be set to "." instead on the data source side.
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 a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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
Invalid measure values, reject, rejected rows, all rows are failing, failed import, import error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem