Excel Template generates output but bursting fails when its large volume of data
Hello,
I'm facing issue with bursting excel template - when report output is 2MB.
1. Excel Template created & generates output for apprx 40krows (2MB)E.
2. But bursting fails
3. When looked at Diagnostics->view xml -> this is not generating complete xml data file, but report out is generated in excel with full data.
I tried limiting rownum<=100 records in my query & this generated xml data file , excel out put & bursting also worked.
BIPublisher Analyzer log file:
Processing signature: BIPXDO_OPP_HEAP_CHECK
Error at step 60 in run_sig_sql running: select SERVICE_HANDLE, DEVELOPER_PARAMETERS,
substr(developer_parameters,
instr(developer_parameters,'-mx') + 3,