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)
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:
- 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 - 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. ) - Search for the option: maximumUploadFileSize
- Change the value from 10485760 to the desired maximum size. For example,
maximumUploadFileSize = 20485760 - Save the dsws.properties file.
- 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