Hierarchy Denorm Stalls Without Notice and Prodika Common Event Log Reports Error, "H-Denorm ERROR: (Request=5e85xxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) children should have an ancestor node at Xeno.Prodika.Common.Assert.True(Boolean value, String msg)"

(Doc ID 1927360.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Agile PLM for Process Feature Pack - Version 3.1 and later
Information in this document applies to any platform.


The Hierarchy Denorm service stalls without reporting errors. It still processes PKIDs and requests but not writing any rows to the GSM & SCRM denormalized tables. Out of the box configuration for the Denorm service is used with the additional logging enabled. This only occurs in the load balanced environment, but the service is only running from 1 node on each environment at a time.


Hierarchy Denorm service should complete successfully.


Errors found in the Prodika Common event log:

H-Denorm ERROR: (Request=5e85xxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)children should have an ancestor node at Xeno.Prodika.Common.Assert.True(Boolean value, String msg) at Xeno.Data.Impl.HierarchyDenormResultSet.AddChildren(Int32 parentPKID, IHierarchyDenormResultSet children, IHierarchyDenormResult childrenAncestorOverride) at Xeno.Data.Impl.HierarchyDenormResultSetDiff.Save() at Oracle.PLM4P.SolutionPack.HierarchyDenorm.ProcessorService.DenormRequestQueueSink.Receive(Object[] targetObject)


1. Install Hierarchy Denorm service
2. Start the service in the background of the load balanced environment


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms