SAP Knowledge Base Article - Public

2742935 - UploadFile exception when saving an AO workbook to BI Platform

Symptom

When saving an AO workbook to BI Platform, below error occurs:

The maximum number of bytes per upload file is 10485760. Contact your System Administrator to change this. (WBP 42057):
UploadFile exception (Error: WBP 99999)

Error.png

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

 Save a AO workbook to BI Platform

Cause

By default, the maximum number of bytes per upload file for the Web Server is 10485760 ( 10 MB ). If the workbook contains large images, or saved with a large data set, the file size of the workbook can potentially be larger than 10 MB, and therefore fails to save on the SAP BI Server, because of the default post size limit defined on the Web Server.

Resolution

By default, the Web Application Server for SAP BusinessObjects Business Intelligence Platform is Tomcat.
In order to be able to save larger workbooks to the SAP BI Server, increase the limit on Tomcat for the option maximumUploadFileSize, by following the steps below:

  1. On the SAP BusinessObjects Business Intelligence Platform 4.x server, navigate to following folder:
    C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterpise XI 4.0\warfiles\webapps\dswsbobje\WEB-INF\classes
  2. Open in a Text Editor the following file: dsws.properties
    ( You may want to make a backup copy of the file: dsws.properties, before making any changes. )
  3. Search for the option: maximumUploadFileSize
  4. Change the value from 10485760 to the desired maximum size. For example,
    maximumUploadFileSize = 20485760
  5. Save the dsws.properties file.
  6. Redeploy the dswsbobje web application using wdeploy. Eg:
    wdeploy <webappserver> -DAPP=dswsbobje deploy
    For more info, refer to SAP KBA 1608960 - Deploy BI4.x war files using the wdeploy command [How-To] [video] 

NOTE : it is important to determine which exact URL is used for BI Platform login in AFO, so that the changes are done in a correct webapp server.

Keywords

AO, Analysis for Excel, Analysis for Office, A4O, Saving error, Upload File exception, 145c-96d8-91, 42056, 3701-ae04-a8 , KBA , BI-RA-AO-XLA , Excel Addin , BI-BIP , Business intelligence platform , Problem

Product

SAP Analysis for Microsoft Office all versions