Web Player unable to access data linked to an AccessDB source on the shared drive.

Web Player unable to access data linked to an AccessDB source on the shared drive.

book

Article ID: KB0082425

calendar_today

Updated On:

Products Versions
Spotfire Server All Supported Versions

Description

When Spotfire is configured for Kerberos authentication (Delegation enabled), Web Player may fail to access the data linked to an AccessDB source on the shared drive and you may see the following error in Web Player worker logs.

--------------------------
Spotfire.Dxp.Data.Exceptions.ImportException: Unable to import Access database. Message returned: 'Unspecified error'. ---> System.Data.OleDb.OleDbException: Unspecified error
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)

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

Environment

All Supported Environments

Resolution

On the Node Manager machine, try giving write access for Web Player users to the temp folder that belongs to the service account which is running Node Manager.

Example path:
   C:\Users\[Service Account that is running Node Manager]\AppData\Local\Temp

Note: AppData may be a hidden folder.

The reasoning behind this solution is that OLE DB creates temporary files and folders when accessing AccessDB files, so having write permission in the service account's temp folder will help.


 

Issue/Introduction

Web Player unable to access data linked to an AccessDB source on the shared drive.