SAP Knowledge Base Article - Public

3351705 - "rejected by workload class configuration" error occurs in SAP Datasphere

Symptom

Symptom 1:

The following error occurs when running Data Flow: 

"General error; 616 rejected by workload class configuration"

"HanaError: rejected by workload class configuration, Code: 616, SQL State: HY000"

Symptom 2:

View persistency failed with below error message:

"errorMessage":"rejected by workload class configuration, Code: 616, SQL State: HY000"

Environment

SAP Datasphere

Reproducing the Issue

For Symptom 1:

  1. Go to Data Flow monitor screen.
  2. Execute the Data Flow.

For Symptom 2:

  1. Go to View persistency monitor screen.
  2. Execute the view persistency.

Cause

The HANA Cloud Database of SAP Datasphere is configured to start queuing or rejecting according to admission control parameters.

  • ADMISSION CONTROL QUEUE CPU THRESHOLD is 90%
  • ADMISSION CONTROL REJECT CPU THRESHOLD is 99%

A statement which exceeds a reject threshold is rejected with the SQL error 616: 'rejected by workload class configuration'. A statement which exceeds a queue threshold is queued for up to 10 minutes, after this time the statement is rejected with the SQL error 616: 'queue wait timeout exceeded'. For more information, see Properties for Workload Classes and Mappings in the SAP HANA Cloud, SAP HANA Database Administration Guide

Resolution

If there are too many statements are rejected, please check below

  1. Identify if there are tasks which consume a high load of CPU run at the same time and check if it can be avoided.
  2. Identify if there are spaces which consume a large amount of CPU time.
  3. Go to the Workload Configuration area of each identified space, select the configuration Custom and decrease the total statement thread limit. Some statements will take longer to run but will not be rejected.

For detail information, please see Set a Priority and Statement Limits for a Space | SAP Help Portal.

If the above points have been checked and error persists, please raise a case to SAP for further analysis.

See Also

KBA 2222250 - FAQ: SAP HANA Workload Management 

Keywords

error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;616, data extraction, overloaded system, Admission control, space, workload, dwc, Datasphere, DS, M_ADMISSION_CONTROL_EVENTS , KBA , DS-DI , Data Integration/Data Builder , Problem

Product

SAP Datasphere all versions