Could not open analysis on TIBCO Spotfire Web Player with error 'Some part of the data table "myDataTable" could not be loaded. A data source may be missing or has been changed.'
Article ID: KB0072253
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.5 and higher |
Description
If you have a data table that is linked to a local data file (e.g. Excel, text file) and your data table is linked to source with "Always new data", and the data source is accessible on TIBCO Spotfire installed client machine but not from the Node Manager machine (where the Web Player is run), then when trying to open this analysis file from the TIBCO Spotfire Web player, you will get a "Missing Data" error like seen here:
This happens because the Web Player fetches data from the Node Manager machine where the Web Player instance is running, not the local machine where the web browser is running (and from where the TIBCO Spotfire Analyst client may have been used). When the data table is saved as linked with "Always new data", the Web Player will try to access the data source each time you try to open the analysis file. This would result in the error above.
This happens because the Web Player fetches data from the Node Manager machine where the Web Player instance is running, not the local machine where the web browser is running (and from where the TIBCO Spotfire Analyst client may have been used). When the data table is saved as linked with "Always new data", the Web Player will try to access the data source each time you try to open the analysis file. This would result in the error above.
Issue/Introduction
Could not open analysis on TIBCO Spotfire Web Player with error 'Some part of the data table "myDataTable" could not be loaded. A data source may be missing or has been changed.'
Resolution
Option 1:
You can embed the particular data table so that it will never reference the source file again (unless explicitly done by the user)
When saving the file, you can set review the "Data Loading Settings" and save the particular data table to "Stored Data" or "New data when possible" instead of "Always new data". The "New data when possible" option allows you to get new data when possible, but to store data for those users that lack access to the original source (in this case the Web Player client users) or for use when offline.
Option 3:
If you are not using a cloud-based instance of Spotfire, you can make the file path accessible from the Node Manager machine(s). This can be done by replacing the data table (File > Replace Data Table) and loading the data file via a path accessible from both the installed client machine and the Node Manager machine (e.g. a network share), like \\myshare\myfolder\myfile.txt. Then grant permission of the network share to the correct user(s), following the instructions in the KB article below: For this to work, that exact file path (as seen in the Edit > Data Table Properties > Select your data table > Source Information tab) must be accessible from the Node Manager machine (via File Explorer) for the required users depending on the authentication method (Node Manager service account or end user, per the above KB article.)
To get more details on the particular data source having issues, see the Web Player instance logs ( Spotfire.Dxp.Worker.Host and Spotfire.Dxp.Worker.Host.Debug).
You can embed the particular data table so that it will never reference the source file again (unless explicitly done by the user)
- Edit > Data Table Properties > Select your data table > General tab > Store data: "Embedded in analysis"
When saving the file, you can set review the "Data Loading Settings" and save the particular data table to "Stored Data" or "New data when possible" instead of "Always new data". The "New data when possible" option allows you to get new data when possible, but to store data for those users that lack access to the original source (in this case the Web Player client users) or for use when offline.
Option 3:
If you are not using a cloud-based instance of Spotfire, you can make the file path accessible from the Node Manager machine(s). This can be done by replacing the data table (File > Replace Data Table) and loading the data file via a path accessible from both the installed client machine and the Node Manager machine (e.g. a network share), like \\myshare\myfolder\myfile.txt. Then grant permission of the network share to the correct user(s), following the instructions in the KB article below: For this to work, that exact file path (as seen in the Edit > Data Table Properties > Select your data table > Source Information tab) must be accessible from the Node Manager machine (via File Explorer) for the required users depending on the authentication method (Node Manager service account or end user, per the above KB article.)
To get more details on the particular data source having issues, see the Web Player instance logs ( Spotfire.Dxp.Worker.Host and Spotfire.Dxp.Worker.Host.Debug).
Additional Information
Doc: TIBCO Spotfire Analyst Web Help > Embedded or Linked Data?:
B: 000029204 How to open analysis files on the Web Player when they contain linked data located on a network share
Doc: Spotfire.Dxp.Worker.Host and Spotfire.Dxp.Worker.Host.Debug
Feedback
Yes
No
Powered by
