Skip to Content

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
To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply