The GL rapid mart during initial load fails while flattening the gl account hierarchy with a circular reference error.
Is there a way to load the data into datamart by skipping the error rows?
Thanks!
adbas (BOB member since 2010-01-12)
An hierarchy where the parent has a child who’s child is the parent of this parent is a hard error. You can remove that workflow from the parent workflow so it does not get loaded until you figured out what’s wrong with your source data though.
Werner Daehn 
(BOB member since 2004-12-17)
Thanks Werner!
To find the root cause of the issue… I have created a dataflow with this hierarchy flattening and running this job separately… with “Donot abort on cyclic errors”…
The job is running for last 2 hrs and it is flattening around 180K rows… I understand hierarchy flattening is memory consuming …but is more than 2 hrs normal?
adbas (BOB member since 2010-01-12)