Offloading Statistica workspace task to Server gives error "An input is unavailable"

Offloading Statistica workspace task to Server gives error "An input is unavailable"

book

Article ID: KB0073391

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.3 and later

Description

User receives error "An input is unavailable" when offloading Statistica workspace task to Server, from Statistica menu "Server > Offload".
The Statistica workspace is simple with a Statistica spreadsheet node as input data for downstream analysis.
The Server Offload task has input option "This task does not require a data source" ticked. 

User-added image

Environment

Windows

Resolution

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".
User-added image

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. 

User-added image

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".
User-added image

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

Issue/Introduction

Offloading Statistica workspace task to Server gives error "An input is unavailable"