AnsweredAssumed Answered

Data in inv_hierarchies table

Question asked by bfarquhar on Oct 12, 2012
Latest reply on Oct 26, 2012 by another_martink
I'm getting some unexpected results from the inv_hierarchies table. I'm hoping someone here can shed some light on it for me. I was assuming that in this table every investment would at a minimum have a record where the parent-id is null and the child_id is itself. This would represent the top of the heirarchy or a standalone investment. [color=#ff0101] Is this a true statement ? Can anyone confirm this for me ? [color]

We have found some child_ids where there is no such record (parent is null and child is self) exists and it is causing a portlet to error out. It has happened to both Project and Program records. [color=#ff0101] I want to determin if we have bad data in the table or.... if the data is good, can somone explain the scenario where not having the record in the table is valid....[color] I would then need to fix my portlet.

Thanks,
Ben

Outcomes