Skip to Content

Increasing Maximum Character Stream Size...

I have one user that is trying to run a WebI report that returns a lot of data and she is getting the following error...

Maximum character output size limit reached. Contact your BusinessObjects administrator. (Error: ERR_WIS_30272)

This same user had this issue a few months ago and at that time I increased the Maximum Character Stream Size within the WebIntelligenceProcessingServer properties from 5 MB to 50 MB. So I guess I need to increase it further.

On page 983 of the The Business Intelligence Platform Administrator Guide it says the maximum value for this is 65535 MB. I realize I probably shouldn't go to the max, but what is reasonable? Also, the default is 5 MB and the default of the Binary Stream Maximum Size is 50 MB. Should these values be kept in proportion?

We are on 4.1 SP01 Patch 2.

Thanks,

Noel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 08:48 PM

    Hi Noel,

    The sizes completely depend on how much your server available memory is and how big a data set user wants to see in run time.

    I recently increased these parameter in our server for a similar issue and we have set it with

    Max char stream size : 40 Mb

    Max Binary stream Size : 150Mb

    This configuration is working for us for fairly large data set however we had a large physical memory availability in our server (128 Gb)..

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 12:08 PM

    Hi Noel,

    Maximum Character Stream Size, Maximum Binary Stream Size are one of the two important parameters which you should always keep an eye on.

    We do not have the standard/resonable value for them instead adjustable. Please note webI is a adhoc reporting tool and not pixel perfect standard reporting tool with millions of rows.

    Our approach on setting these two parameters will be proactive rather than reactive. We will keep on monitoring report schedules and their associated instances twice a month for size of the instances using custom SDK code. Based on results of my code we will keep adjusting the maximum size.

    This is because of the fact that reports that takes more time to refresh and bigger in size will be always scheduled. For Adhoc reports we will go for extensive performance testing based on our benchmark thresholds. If it exceeds the threshold we will always recommend the users to schedule the report instead of refresh them on demand.

    Regards

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 01:50 PM

    Hi Noel,

    this is set by default to a value that should not create performance problems.

    If one tries to process a massive Excel spreadsheet and broadcast it through the network you may end having either high load on the processing server, or in the web application server, or through the network. In the worst of the hypothesis, in more than one or in all three components.

    Therefore if you have plenty of resources and network bandwidth you may wish to increase that value, otherwise you should be aware of the risks you run into when you set a higher threshold.

    Thanks

    Simone

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.