Automation Services job fails to "Open Analysis from Library" when report accesses data in a shared folder - "unknown user name or bad password".

Automation Services job fails to "Open Analysis from Library" when report accesses data in a shared folder - "unknown user name or bad password".

When executing an Automation job with the task to "Open Analysis from Library", the job fails and you get the following error, "unknown user name or bad password". This AS job may have been successful in the past but now does not work. If you execute the job locally, it will be OK. If you execute the job over the server, you will see the issue. The analysis file will import data from a linked source on a shared folder in a network.

Symptoms:

2016-01-14 08:56:06,775 INFO  [24440,1] Spotfire.Dxp.Framework.ApplicationModel.SubprocessService: Subprocess is available.
2016-01-14 08:56:08,460 ERROR [24440,1] Spotfire.Dxp.Automation.ASAutomationWorker.ASAutomationWorker: Task 2 Open Analysis from Library failed\nSpotfire.Dxp.Framework.Library.LibraryException: Import failed ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> System.IO.IOException: Logon failure: unknown user name or bad password.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   at Spotfire.Dxp.Data.Import.FileDataSource.OpenFileStream(String file)
   at Spotfire.Dxp.Data.Import.TextFileDataSource.CreateDataRowReader(IServiceProvider serviceProvider)
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
   ...

This is usually related to access to a shared folder/file that the Spotfire analysis uses as a data source (visible via Edit > Data Table Properties > Source Information tab). The Automation Services account does not have access to the shared folder where the files (Excel, text, etc.) reside. 

The Automation Services account referenced here is the application pool identity of the TIBCO Spotfire Automation Services application. Provide the Automation Services account (as defined in IIS per the location below) with read access to the shared folder and files.

Internet Information Services (IIS) > Connections pane > Click on Application Pools under the server > TIBCO Spotfire Automation Services X.X.X Pool > Advanced Settings > Process Model > Identity

Check in Windows "File Explorer" to see if that account has access to the shared folder

For 7.5 and higher:

The Node Manager service account should have access to the shared folder (unless the TIBCO Spotfire Server is configured with Kerberos authentication with delegation). Refer the KB articles in the Reference section for details on the required configurations.
 

• https://support.tibco.com/s/article/How-to-configure-access-to-local-and-shared-network-directories-for-the-TIBCO-Spotfire-Web-Player

• https://support.tibco.com/s/article/How-to-open-analysis-files-on-the-Web-Player-when-they-contain-linked-data-located-on-a-network-share