Scheduling WebI report in excel format issue

Problem Summary

   Error: The report failed while scheduling in Excel format in BO Xi 4.0.

Details

  In BO Xi 3.1, the scheduled report was successfully run, when the output format was Excel. The report when manually refreshed ran successfully in 3.1 and 4.0 environments. The report when scheduled in 4.0 ran successfully when the output format was Web Intelligence. The schedule parameters were the same in 3.1 and 4.0 environments.

Cause

  Initially
obtained the ‘system cannot find the path specified’ error because the special character ‘/’ is not allowed in the report name if scheduled. After resolving this issue obtained ‘Maximum character output size limit reached. Contact your BusinessObjects administrator’ error because ‘maximum character stream size’
(Web Intelligence processing service property) was less than required (was only 5 MB).

Resolution

1. Go to 4.0 Development CMC
2. Under servres Open the Web
   Intelligence Services.
3. Open the Web Intelligence Processing
   Service properties.
4. Change the Maximum character output
   size to 25 MB.
5. Restart the Web Intelligence
   Processing Server.
6. Schedule the report in BO Xi 4.0
   and output format set to Excel.
7. Repeat the same steps in BO Xi 4.0
   SIT, UAT and production