1. If the workspace uses a Statistica spreadsheet node as input data source, the input spreadsheet needs to have option "Embed Document on Save" ticked in order to run in Offload task with option "This task does not require a data source".
If "Embed Document on Save" is not ticked, the input spreadsheet is likely linked to a local file path in the client machine.
When the workspace is submitted to run in the Server, the server is unable to find such file path in the server.
2. In the situations of large spreadsheet data, the input spreadsheet node might be too large to be embedded with the workspace.
It gives error "The spreadsheet is too large to embed" when clicking on "Embed Document on Save" node parameter.
It is by design that large spreadsheets cannot be embedded in workspaces because there is a limit in windows to how big so called "storage files" can be.
3. In the case of large Spreadsheet data, Alternatively, you may upload this large Spreadsheet to Enterprise as a general document object, or put it in an Enterprise Data Configuration.
In the workspace, instead of using a large Spreadsheet data node, Load the data source from Enterprise objects, and it will work in Server Offload with option "This task does not require a data source".
a) To upload a Statistica Spreadsheet to Enterprise as a General document object, you can Open the Spreadsheet in Statistica application, go to menu "Enterprise > Save to Enterprise or Add to Enterprise > Create new object".
Here is an article with instructions for your reference:
https://support.tibco.com/s/article/How-to-add-scripts-spreadsheets-as-general-documents Just take note that, this might also have some size limit on the spreadsheet to be uploaded to Enterprise.
If you receive the size error with this method, please use method below which will work well for large data.
b) To put a Statistica spreadsheet in an Enterprise Data Configuration, so that the Server engine can retrieve the large Spreadsheet data, you would need to
- first transfer the large Spreadsheet to the Server local directory
- then create a Database Connection with "Statistica OLEDB Provider" provider to this Statistica spreadsheet location in the server
- and then create a Data Configuration to retrieve the spreadsheet data from the Database connection created.
Here is the article with instructions for your reference:
https://support.tibco.com/s/article/How-to-create-data-configurations-for-Statistica-spreadsheets