SAP Knowledge Base Article - Public

3310687 - Scheduled Job fails with error "The job failed due to an unexpected internal server error" in SAP Analytics Cloud

Symptom

Scheduled job from S/4HANA, it fails with:

    • The job failed due to an unexpected internal server error. Please contact your system administrator.

    It also fails when manually refreshed.

    Environment

    SAP Analytics Cloud 2022.21.17 

    Reproducing the Issue

    1. Log in to SAC tenant 
    2. Open the affected Model 
    3. Go to Data Management Tab
    4. Select the affected job and note the error on the Data Timeline tab
      The job failed due to an unexpected internal server error. Please contact your system administrator.
    5. Try refreshing the job manually 
    6. Note the error message: 
      Couldn't refresh the data.

    Cause

    • This issue is specific to New Model type only.
    • In the New Model type SAC uses the provided OData service metadata precision and scale values to define the DB columns on SAC side. In the Classic Model, SAC ignores them and convert the number to strings.
    • This means that one of the columns you are trying to load into SAC has a precision set, but one or more values are violating the limit and causing an JDBC error which is expected.
      • For example: the "problematic" <PropertyExample> property has precision set to 23 and scale set to 14.
      • Precision is the total number of digits in the number including decimals. This means that the number of digits on the left side of decimal point is 9, and number of digits on the right side of decimal point is 14. (23 total digits).
    • This is why some values which are greater than 9 digits on the left side of decimal point are causing this error.

    Resolution

    This should be resolved on the OData service side by editing the Precision and Scale of the affected property to allow for more digits on the left side.

    • For example, for <OtherPropertyExample>, the Precision is 24 and Scale is 3. This allows for 21 digit long numbers.

    See Also

    Keywords

    SAC, SAP Analytics Cloud, Model, Job, Fails, Failed, Refresh, Scheduled, "unexpected internal server error", "Couldn't refresh the data", Error, New Model, Scale, Property, Number, Digit, Values.  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

    Product

    SAP Analytics Cloud 1.0