3599318 - OData Import Job Failure in SAC While Consuming Datasphere

•  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.

SAC Analytics Cloud 2025.1.10

1. 1. Log into SAC;
   2. Go to Modeler > Create a new model using the Datasphere connection;
   3. Create a new query selecting all measures and dimensions;
   4. The error is displayed: "Couldn't retrieve data from XXX"
      1. 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)."

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. 

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.

• 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!

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