GRC controls are created with empty values for "Number" field - Support and Troubleshooting

GRC controls are created with empty values for "Number" field Issue  Symptoms GRC controls are created with empty values for "Number" field.

Investigation The NumberManager.getNext() function is called internally as part insertion of each record on a table where auto numbering is enabled.

This function gets the last used counter value from sys_number_counter for the table and tries to increment the value by 1. It will update the counter to new value only if the counter's value in db is same as the value it had fetched(this means nobody has created a new record in between). If this condition is not satisfied it retries for a max of 10 times(global property: glide.number.retries) and gives up. While giving up it puts the number value as empty string.

This can occur while we have multiple simultaneous policy statement -> profile type associations done in parallel and the generate_items event is being processed.

Cause This has been identified as a known issue, handled under PRB1292474 .

Workaround Please find below the workaround which will fix this issue:

Import the attached xml files into the instance.

sys_script_95cbe6c9db0fdf008608742eaf96196c.xml - Before insert business rule on the record, backfill the number if its missing sys_script_66cdaec9db0fdf008608742eaf96194a.xml - On display business rule of the record, backfill the number if its missing In order to repair the impacted records, run the script from the attached file "backfillNumber.txt" in the background script (global) to backfill all missing numbers of the sn_compliance_control.

Kindly test the workaround in one of the sub production instances first before implementing the same in production.

Additional Information Customer can also Enforce Unique Numbering to workaround this issue.