Symptom
The error message displayed is: "execution aborted by timeout, Code: 613, SQL State: HY000" while previewing an Analytic Model:
The query executed with errors. {"code":"inaTimeout","details":{"stack":"See correlation id xxxx-xxxx-xxxx","message":"execution aborted by timeout, Code: 613, SQL State: HY000","code":613,"sqlState":"HY000","name":"HanaError","originalMessage":"execution aborted by timeout"}}
Environment
SAP Datasphere
Reproducing the Issue
- Preview an analytic model
- The system will then display a timeout error.
Cause
This is expected behavior
Resolution
A three minutes timeout was introduced in Analytic Model. This is documented in the help porta at https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/e5fbe9e2cb93484dab8b1963145e565f.html
For technical reasons, there is a timeout after three minutes when opening the data preview or when executing a query against an analytic model in SAP Analytics Cloud.
You can do the same steps in SAC or reduce the amount of data to get preview in less than 3min.
See Also
Refer to the following link for more details: [SAP Datasphere Documentation](https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/e5fbe9e2cb93484dab8b1963145e565f.html)
Keywords
SAP Datasphere, Analytic Model, Timeout Error, Hierarchy Model Level Filter, SAP Analytics Cloud, Data Preview, Query Execution. , KBA , DS-MD-AM , Analytic Model , Problem