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
- Log in to SAC tenant
- Open the affected Model
- Go to Data Management Tab
- 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. - Try refreshing the job manually
- 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
- 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 Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.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, 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