Mismatch in Object Count: Asset Reindexing versus Total Objects

   

Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.

Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

During an Asset reindex process, there is a discrepancy observed between the total count of objects being indexed as shown in the Windows modal and the count displayed in the Schema view. 

In this example, the Asset index shows approximately 400,000 more objects than what is displayed in the Asset Schema view.

Re-index Assets Asset Schema view





Environment

Assets Management Data Center

Diagnosis

A discrepancy is observed between the total count of objects being indexed as shown in the Windows modal and the count displayed in the Schema view. The queries provided below can be utilized to ascertain the number of units contained within Assets.
The total count should match the units displayed on the indexing modal.

Queries for PostgreSQL
-- Total of Objects
select count (*) from "AO_8542F1_IFJ_OBJ" 

-- Total of Object Schemas
select count (*) from "AO_8542F1_IFJ_OBJ_SCHEMA" 

-- Total of Object Types
select count (*) from "AO_8542F1_IFJ_OBJ_TYPE"

-- Total of Object Types atributes 
select count (*) from "AO_8542F1_IFJ_OBJ_TYPE_ATTR"

-- Total of object ticket connections
select count (*) from "AO_8542F1_IFJ_OBJ_JIRAISSUE"

Cause

The reindex window also accounts represent the sum of Objects, ObjectSchemas, ObjectType, ObjectTypeAttributes, and ObjectTicketConnection which is why the number of objects displayed is expected to be higher.



Last modified on Dec 10, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.