Spotfire node manager with automation services: "Open Analysis from Library" fails with error "Failed to open data source. ---> System.UnauthorizedAccessException: Cannot access file"

Automation task "Open Analysis from Library" fails with error "Failed to open data source. --- System.UnauthorizedAccessException: Cannot access file"

This article will help you resolve the error, "Open Analysis from Library" fails with error "Failed to open data source. ---> System.UnauthorizedAccessException: Cannot access file" when running an automation task.

1. Create a shared folder within your network. This can be on a file server as well.
2. Confirm that the Node Manager service and Spotfire Server services are running using the same custom Windows account.

3. Provide read/write access to this Windows user on the shared folder.

4. Place Excel, txt files, etc. with which you plan to create reports in this network shared folder.

5. Created a report keeping the above files as a data source and publish them to the library.

6. Login to the Spotfire Server and export the Automation server configuration. Follow the steps below.

-------------------------------------------------------------------------------

- run the export config command at command prompt. <server install dir>\tomcat\spotfire-bin-> config export-service-config --deployment-are="Production" --force --capability=AUTOMATION_SERVICES

- Provide the config Tool Password when prompted.

- Browse to the location <server install dir>\tomcat\spotfire-bin\config\root\ and edit "Spotfire.Dxp.Worker.Host.exe.config"

-Add the file share to the "AllowedFilePaths"

Sample: \\fileshare01\spotfire (Here "fileshare01" is the file share location and "spotfire" is a folder that is created to place the source files)

- Save the config file and import it as follows. <server install dir>\tomcat\spotfire-bin->config import-service-config --config-name="AllowLinked01"

- Provide the config Tool Password when prompted.

- Login to the Spotfire Admin console > Open "Nodes and Services".

- Click on Automation Service > Click "Edit"on the right hand top corner.

- Select the new configuration and update.

-----------------------------------------------------------------