Mismatch in Object Count - Asset Reindexing versus Total Objects
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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 totalcount 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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- 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.
Was this helpful?