Symptom
When using SAP Datasphere or consuming models (via SAP Analytics Cloud, Analysis for Office...), error is raised:
The database is busy and your request has been denied. Please try again later. (999616)
Environment
SAP Datasphere
Reproducing the Issue
Intermittent issue.
Cause
To prevent overloading the SAP Datasphere's HANA Cloud Database, Wave 2023.12 introduced a Rejection Threshold with value of 99%.
That means incoming statements will be rejected once a CPU utilization of 99% was reached.
Resolution
Follow SAP Help Set a Priority and Statement Limits for a Space
- Decrease the total statement thread limit for the spaces which consume a large amount of CPU time.
- Avoid that tasks which consume a high load of CPU run at the same time.
See Also
SAP Help Monitoring SAP Datasphere
SAP Help Create a Database Analysis User to Debug Database Issues
Keywords
sac, afo, M_WORKLOAD_CLASS_STATISTICS, Admission Control Rejection Threshold , KBA , DS-SM , Space Management , DS-DI , Data Integration/Data Builder , DS-MD , Modeling (Data Builder) , Known Error