BI Publisher (MOSC)

MOSC Banner

Excel Template generates output but bursting fails when its large volume of data

edited Aug 18, 2017 5:03AM in BI Publisher (MOSC) 17 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center