Referenced/Contained Concepts not loaded correctly when restarting a TIBCO BusinessEvents application - childs and parent concepts loaded correctly but for some Concepts referenced childs are not loaded.
book
Article ID: KB0088063
calendar_today
Updated On:
Products
Versions
TIBCO BusinessEvents Enterprise Edition
-
Not Applicable
-
Description
Resolution: Description: =========== Referenced/Contained Concepts not loaded correctly when restarting a TIBCO BusinessEvents application - childs and parent concepts loaded correctly but for some Concepts referenced childs are not loaded.
Environment: =========== TIBCO BusinessEvents 4.x/5.x All Operating Systems
Symptoms: ========= Serialized parent concept has no childs for the referenced/contained Concept array property. There are no errors in the log (preload works for all entities).
Cause: ====== Referenced table includes some wrong records (child concept deleted already). By default (TIBCO BusinessEvents (BE) 4.x only) TIBCO BusinessEvents will not load remaining records when some broken references exist in the referenced tables.
Resolution: =========== Add the property below to skip broken references and proceed to load the data.
be.backingstore.unmodified.skip=true
NOTE: TIBCO BusinessEvents is not the root cause of the initial data integrity problem, it could be caused by missing locking or database deadlocks. To avoid database deadlocks disable property enableParallelOps for the InferenceAgent. (Agent.<agent-classname>.enableParallelOps=false).
To find broken references use the SQL below (delete the corrupted records):
<parent> ... parent concept name <propertyForChilds> ... property name for reference concepts
contained Concept arrays: select pid$ from D_<parent>_<propertyForChilds> where pid$ not in (select id from objecttable);
referenced Concept arrays: select pid$ from D_<parent>_ rrf$ where pid$ not in (select id from objecttable);
Issue/Introduction
Referenced/Contained Concepts not loaded correctly when restarting a TIBCO BusinessEvents application - childs and parent concepts loaded correctly but for some Concepts referenced childs are not loaded.