Boxi 3.1 SP 6 FP 1 after upgrade problems

[Former Member]

Hi all

I recently upgraded a customers web servers from Boxi 3.1 SP 3 to SP 6 fp 1.  (12.3.0.601 to 12.6.1.1691).

Since upgrade there have been intermittent problems with the Web Intelligence.

For example they cannot open reports in PDF format or Excel 2007 (interactive works though).

The errors they are getting are:

1.  An internal error occurred while calling 'get blob' API.  (error: ERR_WIS_30270)  (error:INF)

2.  Maximum binary output size limit reached.  Contact your business objects administrator.

Now I have a feeling the properties the Web Intelligence processing server have been reset back to default after upgrade.  Comparing this Boxi service to another Boxi service still on SP 3 by the same customer I can see that:

Maximum Binary stream size value is set a lot higher and Maximum character stream size value is a lot higher on the SP 3 service.

Unfortunately the snapshots of the 6.1 service have been deleted so I cant check what the initial Intelligence properties were set too before the upgrade.

I would like match the values of the 3.1 service to see if it fixes the problem however the customer want me to be sure this would not harm the service hence I am posting on here for confirmation that changing these values could fix the above errors.

Would appreciate any feedback.

Kind Regards

Jim

[former_member136842 · Accepted solution]

Hi,

setting these values to high could result in an unstable System.

Anyhow you should increase these values.

The following Notes should convince your Customer to do so:

http://service.sap.com/sap/support/notes/1272559

http://service.sap.com/sap/support/notes/1383664

http://service.sap.com/sap/support/notes/1370045

Regards

-Seb.

[Former Member · Accepted solution]

Thanks for the feedback Sebastian

We altered the Binary stream size to 200mb and thats seems have resolved the Maximum binary output size limit reached error.

However we are still getting An internal error occurred while calling 'get blob' API.  (error: ERR_WIS_30270)  (error:INF) when users are in PDF mode.  Seems to be intermittant aswell.

I am going try increasing the charcter Stream size from 5mb up to 50mb and maximum connections up to 75 from 50.

[former_member136842 · Accepted solution]

Hi,

these are powerfull metrics.

Maybe you should think about creating multiple WIPS.

Better would be a re- assessment of your Reports. It sounds like they are very huge and pull a lot of Data. Is this really neccesary?!

Regards

-Seb.