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.

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.&ltagent-classname>.enableParallelOps=false).

To find broken references use the SQL below (delete the corrupted records):

&ltparent>         ... parent concept name
&ltpropertyForChilds>    ... property name for reference concepts

contained Concept arrays:
select pid$ from D_&ltparent>_&ltpropertyForChilds> where pid$ not in (select id from objecttable);

referenced Concept arrays:
select pid$ from D_&ltparent>_ 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.