When creating a new analysis in Spotfire Business Author, while attempting to open a large file (such as an .xslx or .dxp file), the following error message appears:
===========
Error message: 
Add data
One or more files could not be opened
The file is larger than 1024 MB

Example screenshot:

When attempting to create a new analysis in Business Author (web client), you get an error message like the following when adding data: "One or more files could not be opened. The file is larger than 1024 MB".

All

This error occurs because the Spotfire Web Player has a default file size limit of 1024 MB (1GB) for files uploaded to the service, configurable up to a maximum of 2047 MB.

To resolve this, you can increase the file size limit up to 2047 MB, just below the 2GB maximum in the Spotfire.Dxp.Worker.Web.config file.

To modify the Spotfire.Dxp.Worker.Web.config file, follow these steps:

1) On the computer running Spotfire Server, open the command line as an administrator. Change the directory to the location of the config.bat file (config.sh on Linux). 
The default location is <server installation directory>/tomcat/spotfire-bin.

2) Use the following command to export the configuration file:
   config export-service-config --capability=Web Player --deployment-area=Production
   
3) Edit the exported configuration file - ‘Spotfire.Dxp.Worker.Web.config' in a text editor

4) Increase the file size limit by modifying the "maxReceivedMessageSizeMb" setting.

5) Use the following command to import the modified configuration file:
   config import-service-config --config-name=<new-config-name>
   
6) From the Spotfire Server Admin UI Nodes and Services page specify the configuration to use, and then start the service.

1. Open a web browser and log in to the administration console for Spotfire Server.        
2. Navigate to Nodes & Services.
3. Under Network Components, select Nodes, then select the specific service.
4. Click Edit to open the Edit Service dialog box.
5. In the Configuration drop-down list, select the configuration name to apply, and click Save.

If you need to open files larger than the max limit, you should use the installed client (Analyst) which has no such limitation:

1. Open the large data file using Spotfire Analyst.
2. Save the analysis to the library.
3. Open the analysis in the Web Player.

• Doc : Web Player service configurations (Spotfire.Dxp.Worker.Web.config file)
  • https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/spotfire.dxp.worker.web.config_file.html
• Doc : Manually editing the service configuration files
  • https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/manually_editing_the_service_configuration_files.html