cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to generate complete report

former_member211289
Participant
0 Kudos

Hi All,

We have a report which is taking time to get exported.

We have been facing issues that if the session times out while exporting the report then the report generated is not complete and it fetches data until the session gets logged out.

I tried it 3-4 times, sometimes the data generated is around 200 mb or sometimes it is 150 mb depending on the time the session logged out.

Please look into this issue and find us a way so that complete report can be exported and it doesn't stops in between.

Kindly help me asap.

Thanks

Ram

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ramanaidu,

Increase the 'Maximum Character Stream Size (MB)' and 'Binary Stream Maximum Size (MB)' parameters in the properties of Webi Processing Servers and check the behavior.

200 MB is a fairly large size of the exported document. You can try and export it from Webi Rich Client to rule out the Application Server timeout.

Regards,

Adil

Answers (2)

Answers (2)

vijaymuniraj
Active Participant
0 Kudos

200 mb? What is total number of pages available in your report?

amitrathi239
Active Contributor
0 Kudos

check previous report instance in history if report ran successfully earlier.what was the size and how much time report took?

what is your backend database?

copy the Sql of webi report and run directly on database to see the timing & number of records count.

former_member211289
Participant
0 Kudos

Amit,

Issue with exporting the report only,while exporting report it is taking a lot of time to get exported and  if session time out ,report exported with partial data.

Moreover ,report is running fine and problem with exporting the report only

Kindly let me know ,Do we need to change any parameters ?

amitrathi239
Active Contributor
0 Kudos

in which format are you exporting and which location?