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

Symptom 1:

The following error occurs when running Data Flow or Replication Flow where target is a local table on SAP Datasphere: 

"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"

Complete Error example:

Failed to write data to target due to database error. SAP DBTech JDBC: [616]: rejected by workload class configuration. This error can occur for any replication object when the workload class CPU or memory threshold limit of the HANA database is exceeded, or when the SQL statement has been waiting in the queue for more than 10 minutes. Please check HANA workload management settings to increase the workload thread limit and/or memory limit and/or priority. A possible solution could be, for example, adding more vCPU or memory capacity. Alternatively, you could consider pausing a few replication flows or their objects (considering their business importance) to reduce concurrency, until the HANA SQL error 616 disappears.

SAP Datasphere

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.

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. 

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.

KBA 2222250 - FAQ: SAP HANA Workload Management 

616, "HANA SQL error 616", "General error;616", "workload class configuration", data extraction, overloaded system, Admission control, space, workload, dwc, Datasphere, DS, M_ADMISSION_CONTROL_EVENTS , KBA , DS-DI , Data Integration/Data Builder , Problem