SAP Knowledge Base Article - Public

3599318 - OData Import Job Failure in SAC While Consuming Datasphere

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

    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)."

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

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

Product

SAP Analytics Cloud 1.0