My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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

Symptoms

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.


EXPECTED BEHAVIOR

Hierarchy Denorm service should complete successfully.

ERROR

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)



STEPS TO REPRODUCE

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


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.