AnsweredAssumed Answered

Editing roles locks database to 100% CPU usage

Question asked by Miikka Petäjäjärvi on May 11, 2020
Latest reply on May 29, 2020 by Ian Staines

We have the issue that when committing changes to technical roles, the database CPU gets locked to 100% usage and it takes several minutes, between 5-20min, for it to complete the background task of creating the change request. For example adding entitlements, members or just inserting a description and then committing the role.

 

The SQL command it gets stuck at starts with:

INSERT ALL
INTO GTT_ROLES_CR_ITEMS

 

 

Anyone else encountered this problem?

Outcomes