CMDB Dashboard Compliance Audit - Task not getting creation for failed audit. - Support and Troubleshooting

CMDB Dashboard Compliance Audit - Task not getting creation for failed audit. Issue An audit for a CI class is set for populating the audit scores on CMDB dashboard but we could not see any tasks being created. OOTB, when an Audit is failed, it should create a task for the failed audit. Below is the expected outcome of Audit .

Cause It was a working set up but after a recent clone, the system stopped creating tasks for Audit. On checking the system logs, we can see below error reported while executing the Audit Scheduled Job. Error FAILED TRYING TO EXECUTE ON CONNECTION glide.18 (connpid=74334): com.glide.db.BatchStatement$StatementContainer@17d0b1d,com.glide.db.BatchStatement$StatementContainer@1832703 java.sql.BatchUpdateException: (conn=74334) Duplicate entry 'TASK0591107' for key 'task_U1' : java.sql.SQLException: java.sql.BatchUpdateException: (conn=74334) Duplicate entry 'TASK0591107' for key 'task_U1': com.glide.db.StatementBatcher.getSQLException(StatementBatcher.java:547) com.glide.db.StatementBatcher.commitBatch(StatementBatcher.java:502) com.glide.db.StatementBatcher.commitAllOrNothing(StatementBatcher.java:377) com.glide.db.DBCompositeAction.executeAsBatch(DBCompositeAction.java:193) com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:136) The system is trying to create the task in the backend but due to the limitation on available numbers on TASK was failing. Resolution In order to fix this issue, below steps can be followed.

Go to System Definition > Number Maintenance Click New. Table: Follow On Task Prefix: FNTASK (OR some unique string that they want for this numbering) Number: 10,000 Number of Digits: 7

After following the above steps, the system will not throw any error, and the audit result will successfully create task. Please refer to " Record Numbering " document for more details. Related Links In case any recent clone is performed and the audit is not working then it is advised to try creating a fresh Audit Certification Filter and Audit Certification Template . Most of the time, it starts working once a new filter and template is created. These steps help to narrow down the problem statement.