Symptom
- OData connection between Datasphere and SAP Analytics Cloud (SAC) failed during the execution of an import job.
- The job fails with the error message: "Couldn't retrieve data from XXX.
Environment
SAC Analytics Cloud 2025.1.10
Reproducing the Issue
-
- Log into SAC;
- Go to Modeler > Create a new model using the Datasphere connection;
- Create a new query selecting all measures and dimensions;
- The error is displayed: "Couldn't retrieve data from XXX"
- From HAR: "status": {
"state": "FAILED",
"details": {
"errorCode": "INTERNAL_ERROR",
"rawError": "com.sap.db.jdbc.exceptions.SQLDataExceptionSapDB: Numeric overflow: -1095.42 (the target precision is: 3)."
- From HAR: "status": {
Cause
The issue is that both measures were defined with a total precision of 5 digits (including 2 decimal places). This means they can only accept values from roughly -999.99 to +999.99.
When you attempt to store -1095.42, it exceeds the permitted range for a DECIMAL(5,2), hence the numeric overflow error.
Resolution
Increase the precision of these properties (e.g. Precision="10" Scale="2" or something suitable for your expected amounts) so the value -1095.42 (and anything larger in absolute value) can be stored without error.
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!
Keywords
SAC, Analytics, Model, OData, precision, scale, Datasphere, view, metadata, error, plugin error, numeric overflow, target , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem