Maximum binary output size limit reached (ERR_WIS_30271)

[Former Member]

During testing BO XI 3.1, I found the error message " Maximum binary output size limit reached (ERR_WIS_30271)." Pls advise

[former_member193430]

this is a very useful information, my question is when we are exporting the webi to excel format the excel file it creates becomes too big and if i go to the excel and save as excel worksheet the size reduces to half, is there a way we can reduce the size of the excel exported file to minimum at the time of export.

Thanks.

Toor.

[Former Member]

Hi Toor,

From my experience, the only way to decrease what is exported in Excel from Webi is to tweak the report in a way that it does not have to create a lot of blank columns or rows etc. Try to figure out what it is that Excel does not like. For instance it could be columns not lined up, too wide, etc.

Thanks

[Former Member]

Hi Toor,

If the report is fetching more than 1lak Records.

when we are exporting file to excel there is some limitations

example :

Excel 97 : there is limitation of around 64000

Excel 2003 : allows more than 1 million records .

Thanks,

Raghunath

[Former Member]

Hi Nion,

Below are the possible causes to get this error message:

1] When a large Web Intelligence report is exported to CSV format, we get error: Max Binary file size limit exceeded. The document is too large to be processed by the server. Error WIS 30271

Cause

This error message appears because BusinessObjects Enterprise allows documents to be saved with the limit specified for Web Intelligence Report server settings in the Central Management Console(CMC).

To resolve the error follow the below steps:

- Login to Central Management Console (CMC) using BusinessObjects Enterprise "Administrator".

- Navigate to "Home >> Servers".

- Click on "Web Intelligence Report Server" to open its properties.

- Increase the "Maximum Binary File Size"(Default value=50 MBytes; Maximum value = 65535 MBytes).

- Click on "Apply" and then on "Update".

- Allow the Web Intelligence server to restart.

-

---

2] In Web Intelligence, when attempting to save a report to Excel or Portable Document Format (PDF), the following error message appears:

"Max binary file size limit exceeded. The document is too large to be processed by the server. Contact your database administrator. (Error: WIS 30271)".

Cause:

This error message appears because Business Objects Enterprise allows documents to be saved up to the limit set for Web Intelligence Report Server in the Central Management Console (CMC). The default file size limit is 50 megabytes for binary file types like PDF and Excel.

To resolve this error message, you will need to increase the Max Binary file size value.

1. Open the CMC.

2. Browse to Servers

3. Click on your Web Intelligence Report Server.

4. On the Properties page, increase the Maximum Binary File Size.

5. Apply the setting and allow the Web Intelligence Report Server to restart.

Increasing these values too high could impact Web Intelligence performance when users attempt to save excessively large files.

Hope this helps.

Please revert in case of any further queries.

Regards,

Deepti Bajpai