BODS Error:System Exception occurred.

ERROR:

System Exception <ACCESS_VIOLATION> occurred. 

Process dump is written to <E:\Program Files\Business Objects\BusinessObjects Data Services\log\BODI_MINI20110308180104_3684.DMP> and <E:\Program Files\Business Objects\BusinessObjects Data Services\log\BODI_FULL20110308180104_3684.DMP> 

Process dump is written to <E:\Program Files\Business Objects\BusinessObjects Data Services\log\BODI_MINI20110308180104_3684.DMP> and <E:\Program Files\Business Objects\BusinessObjects Data Services\log\BODI_FULL20110308180104_3684.DMP> 

Call stack: 

001B:00BD0340, TrCallStatement::isCaseXform , x:\inc\ptree\dataflowstm.h, line 0497 

001B:00F2CFBA, OptNode::InsertQueueCache()+0826 byte(s), x:\src\optimizer\optsplit.cpp, line 9007+0019 byte(s) 

001B:FFFFFFFF, _unguarded_readlc_active()+-2009025873 byte(s) 

001B:00680063, Ordinal4627()+0039 byte(s) 

001B:00627FDC, Ordinal1089()+60974 byte(s)

Registers: 

EAX=035350A0 EBX=034826A0 ECX=042ECE68 EDX=00000000 ESI=042DDD30 

EDI=034826A0 EBP=FFFFFFFF ESP=002132AC EIP=00BD0340 FLG=00210286 

CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000 

Exception code: C0000005 ACCESS_VIOLATION 

Fault address: 00BD0340 01:0048A340 E:\Program Files\Business Objects\BusinessObjects Data Services\bin\acta.dll 

========================================================== 

Please collect the following and send to Customer Support: 

1. Log files(error_*, monitor_*, trace_*) associated with this failed job.

2. Exported Atl file of this failed job. 

3. DDL statements of tables referenced in this failed job. 

4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when the job failed.

5. Core dump, if any, generated from this failed job. ========================================================== 

(12.2) 03-08-11 18:01:10 (E) (8112:6632) RUN-050316: |Session XXXXX |Function FC_FAILED_JOB raise_exception_ext 

Steps of action to handle this:
1. Tried copying the dmp files but erred as the file was in use by some process.
2. Restarted the BODS services. This killed the background process accessing the *.DMP files.
3. Reran the job and it completed successfully.

When is *.DMP file created?
BODS cannot process beyond 2GB data. If the size crosses 2GB, BODS creates a *.DMP file.

1. Check the dataflow properties and change the pageable memory settings to In memory setting.
2. Also check the where clause in the dataflow causing this error, which might be causing cartesian product.