Table is empty but list view record count says there are 22 records

[haldroid]

The Business Service [cmdb_ci_service] table in our dev instance has been showing a row count 22 higher than the number of records viewable in the table for at least a week. While preparing for a change, I deleted all the records in the table, using Tables and Columns > (select Business Service [cmdb_ci_service]) > Delete all records. List view now displays an empty list as expected, but the row count at upper right still displays a count of 22. Scripting a query of count.getAggregate('COUNT') also returns 22. Any idea what is going on?

[Mark Stanger]

Probably an issue with the 'cmdb_ci' table and the extension table being out of sync. This will need to be addressed at a database level by ServiceNow support.

[haldroid]

I wonder if it has to do with the system automatically generating CIs for Change Management, Incident Management, and Problem Management business services. These three records re-appear in the Business Service table if they are deleted individually or if all records are deleted.

[Raja45]

Hi Team,

Please let me know, if we have solution for this issue ?