Why is my BODS job with XML target never completes

[Former Member]

I have a BODS job that has an XML target.  It runs continually without stopping.  In the trace log it shows the job a still running.  It stops at the point where memory is being allocated instead of pageable cache.  When I look at the file system where the xml target is being generated it builds the target then deletes it and then recreates it every two minutes.  This goes on indefinitely.

Can anyone help?  Is this due to a limitation on the size of an XML output?

[Former Member]

Probably it might be creating a cartesian product which is the reason your job is never ending. Look for it at the monitor log. If the case is so, think of using a Row generation transform .

[pan_cheng]

Hi,

It might be creating Cartesian product. In schema out make each node as current and see from where you are selecting the data for that node. In target If you had selected delete and recreate file option then it will delete the file and create again.

Thanks,

[titto_antony]

Is there any loop in you wrok flow that is getting executed infinitely . Also check for any cross product happening inside the schema of the xml structure...