Problem to export BO report to Excel 2007, boxi return error ERR_WIS_30272

Document ID : KB000046976
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:
We have problem to export WebI report to Excel 2007.
Error message :
ERR_WIS_30272

Steps to Reproduce:
A big report returning 100000 rows
schedule the report, choose destination to excel 2007


Environment: 
- windows 2008r2 and windows 2012
- boxi 3.1 SP7
 

Cause:
The default config of WebIntelligenceProcessingServer is not adapted to big report
A temporary file (*.xml) is generated in the following directory when viewing the document. The error occurs if the temporary file size is bigger than Maximum Character Stream Size (BO XI R2: Maximum Character File Size) of Web Intelligence Processing Server (BO XI R2: Web Intelligence Report Server).

Resolution:
The Web Intelligence Processing Server (BO XI R2: Web Intelligence Report Server) configuration parameter
Maximum Character Stream Size (MB) (BO XI R2: Maximum Character File Size) is too small for the output.
Increase this value in the Central Management Console (CMC).