SAP Knowledge Base Article - Public

3375120 - Error "The database is busy and your request has been denied" in SAP Datasphere usage and consumption

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

  1. Decrease the total statement thread limit for the spaces which consume a large amount of CPU time.
  2. 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

Product

SAP Datasphere all versions