CMDB Health Dashboard, under compliance shows " No Data Job Completed, however there were no CIs"

suuriyas · a week ago

HI Community,

In CMDB Health Dashboard, under compliance it is showing as like this "

No data available

Job Completed, however there were no CIs available to evaluate"

what does it means? where i need to check this and for other 2 completeness and correctness data is getting displayed but for this alone it is showing as no CI's .

On what basis it is showing as no data where/how can i check that

Thanks in Advance

SIVASANKARIS · Tuesday

Hi @suuriyas,

Since you’ve confirmed that the configurations (Template, Filter, and Audit) exist but manual runs aren't generating Audit Results, the issue isn't a lack of rules—it’s an execution failure.

Based on the fact that your "Last/Next run" dates are in the past even after a manual run, here are the three things you have to check:

1. The Certification Audit is "Locked" or in the wrong State

If a Certification Audit is already in a state of "In Progress" (perhaps from a failed job or a stuck process during the clone), it will not trigger a new run.

Check: Open the specific Certification Audit record.
Fix: Check the State field. If it's stuck in "In Progress" or "Work in Progress," try resetting it to "New" or "Draft" and then click Run Audit again.

2. Scheduled Job Queue (sys_trigger)

If the "Last run" date isn't updating, the background job that processes the audit might be stuck in the system scheduler.

Check: Navigate to sys_trigger.list and search for Name contains "Certification Audit" or the name of your specific audit.
Action: Look for the Next Action date. If it is in the past, the job is "queued" but the system isn't picking it up. You may need to delete that specific trigger record and then click "Run Audit" on your template to force the system to recreate a fresh trigger.

3. Domain Separation or User Criteria (If applicable)

Since this happened after a clone to Prod, check the "Run As" field on the Audit record.

The Issue: If the Audit is set to run as a specific user who doesn't have access to the CIs in Prod (due to Domain Separation or ACLs), the audit will find 0 records.
Fix: Ensure the Run As user is active and has the certification_admin or admin role.

4. The "Certification Schedule" vs. "Audit"

Check if you are running the Audit or the Certification Schedule.

In the Certification Audit record, check the "Certification Filter" again. Click the "Preview" button on that filter record.
Crucial Step: If "Preview" shows CIs, but the Audit Result doesn't, it confirms the Audit Script is failing. Check System Logs > Errors immediately after clicking "Run Audit" to see if there is a Null Pointer Exception or a Script Include error.

If this is useful, please mark it as helpful and accept my solution ...

View solution in original post

suuriyas · Tuesday

HI @SIVASANKARIS ,

Thanks for the quick response.

I checked all 4 and here are my results:

1 and 2 did not satisfy, in certification audit i don't see any state field and in sys trigger table i opened the specific audit record and checked in that the next run is showing on feb 1st 2026 (future ) as it is monthly run.

for 3rd point yes "Run As" field of audit record is showing as an inactive user in prod but in dev also that's the case but it worked there when i click on run audit. by changing run as to system admin and then manually running it will work?

4th point, in certification audit i have a related link "preview audit results" when i click that it show some annotations like "XXX will pass this audit" but in audit result it is empty.

Audit record:

i get this error but not sure because of this Invalid query string received:null: java.lang.NullPointerException:

and source is com.glide.ui.ServletErrorListener

SIVASANKARIS · Tuesday

Hi @suuriyas,

Thank you for the detailed update. Based on your findings, we have identified two major things that are likely causing the audit to fail silently:

1. The "Run As" User Issue (Point #3)

Even if it worked in DEV with an inactive user, Production environments often have stricter security constraints or different system property settings regarding impersonation. * The Fix: Change the Run As field on the Certification Audit record to an Active Admin user (or yourself for testing).

2. The NullPointerException (Point #4)

The error java.lang.NullPointerException in the ServletErrorListener usually triggers when a script expects an object or a value that isn't there. In this context, it is likely trying to pull a user profile or a system property that is missing in PROD but existed in DEV.

Next Steps to Fix & Test:

Update the "Run As": Set it to an active admin.
Clear the "Next Run" if needed: In the sys_trigger record you found (the one scheduled for Feb 1st), change the Next Action time to a time 2 minutes in the past. This forces the scheduler to pick it up immediately.
Check for "Certification Instances": After you click "Run Audit" manually, look at the Certification Instances related list at the bottom of the Audit record.
- If a new Instance is created but has 0 tasks, the issue is the Filter.
- If no Instance is created at all, the Audit Script/Job is crashing (which explains the NullPointerException).

Verification via "cert_instance" Table

Check the backend table cert_instance.list. Look for any records created in the last 10 minutes. If you see one with State = Failed or Error, open it to see the specific system message.

Give it a try by using this and let me know whether it works or not