Automation task "execute on server" fails with ERROR: Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query.
Article ID: KB0081342
Updated On:
| Products | Versions |
|---|---|
| Spotfire Automation Services | 7.5 and later |
Description
> Automation task "execute on server" may fail with below error:
-----------------------------------------------------------------------------
Import failed ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> System.NullReferenceException: Object reference not set to an instance of an object.
-----------------------------------------------------------------------------
> The Automation services log file also shows the above information.
> Whereas the Spotfire Server log (Server.log > located in "<install directory>\tss\7.5\tomcat\logs") shows:
--------------------------------------------------------------------------------------------------------------------------------------------
WARN 2016-12-22T09:31:21,341+0000 [unknown, #98763, #769944] server.security.AuthenticationManager: Denying authentication request performed without the required CSRF token
ERROR 2016-12-22T09:35:52,328+0000 [automationservices@SPOTFIRESYSTEM, #98540, #770479] api.common.InformationModelServiceCommon: The automationservices principal has insufficient privileges.
com.spotfire.ws.api.common.InformationModelWebServiceException: The automationservices principal has insufficient privileges.
--------------------------------------------------------------------------------------------------------------------------------------------
Environment
Resolution
Prerequisites:
In the Administration Manager in Spotfire Analyst, assigned licenses required by the Automation Services jobs to the automationservices@SPOTFIRESYSTEM user, which is the account used to execute the jobs on the service instance.
Issue/Introduction
Additional Information
Feedback
