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


 

Automation task "execute on server" may fail with the following 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.

All supported Windows operating systems.

The automation services user "automationservices@SPOTFIRESYSTEM" needs to be a part of the "Library Administrator group". Adding this user to this group should resolve the problem.

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.

https://docs.tibco.com/pub/spotfire_server/7.7.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-14533D5E-426E-4837-A80A-16E75D185FD7.html