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".

book

Article ID: KB0082497

calendar_today

Updated On:

Products Versions
Spotfire Automation Services All Versions

Description

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:
The Automation Services job for opening an analysis will fail. You will see the following in the Automation Services logs.
  
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()
   ...

Issue/Introduction

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

Resolution

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. 

For 7.0 and lower :

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.
 

Additional Information

KB: 000029119 How to configure access to local and shared network directories for the TIBCO Spotfire Web Player
KB: 000029204 How to open analysis files on the Web Player when they contain linked data located on a network share
Powered by Wolken Software