BODS Job is failing with ACCESS_VOILATION error
The BODS Job is failing at one dataflow with access voilation error. The error message is
System exception <ACCESS_VOILATION> occured. Process dump is written to <D:\Program Files\Business Objects\Business Objects Data Services\log\BODI_FULL20110615454445_6900.dmp.
0001B:00B2139B, MSDB:printBinOpExpr()+0219Bytes x:\scr\dbspec\mssql.cpp line 1403
The dataflow where it is failing, we are joining 3 tables and then performing a table comparison before dumping the data into the target. When we enable RUN AS SEPERATE PROCESS in the table comparison, the job doesn't fail but hangs up there.
Kindly suggest a suitable answer in order to come out of this problem.