We are trying to do a validation between DRM export and the DRM backend tables data. We are trying to match the count,parent-child relationships and hierarchies. We have a build a query for to fetch the results from tables by joining the multiple tables in the schema required for different columns. But, we are facing the mismatch count between the export and query. There are couple of reasons for this:
- We are getting the orphan nodes from the table which are not present in the hierarchy in application. and when we check the inactive column in node tables it doesn't have any record with inactive data.
- Nodes present in export but not in query : Reason - Hierarchy ids are not mapped to these nodes in query
- Also one more reason is Nodes appearing multiple times in export with different hierarchies: In the export, certain nodes appear multiple times, each associated with a different hierarchy. However, in the query, only one instance of the node is retrieved, presumably because only one of its mappings is associated with the active hierarchy within the specified version.
- one with different parents in both hierarchies
- one with only one parent in both hierarchies
Note: We have used the same version filter in the application which we used to export and in the query as well. Also we have used the hierarchy name and hierarchy group name filters as well to match the count. But we couldn't do that.
Can anyone please help us on this?