Spotfire Automation Services Job on server fails to save the analysis(which has custom queries) to Spotfire Library.
When you try to run an Automation Services Job on server, it may fail to save the analysis file containing custom queries to Spotfire Library with the following error messages in logs.
DEBUG 2020-03-26T14:58:33,098-0500 [automationservices@SPOTFIRESYSTEM, #102, #42545] ws.library.LibraryManagerImpl: Unauthorized attempt to add trust for a custom query with hash 5846E413D6ED52ECF6EB0281AD85D56E09C8CF52 by user automationservices@SPOTFIRESYSTEM[ba65162e-4958-4fa8-a744-87e003770944] DEBUG 2020-03-26T14:58:33,145-0500 [automationservices@SPOTFIRESYSTEM, #102, #42545] ws.library.LibraryService: An exception occurred in method 'saveItem'. com.spotfire.ws.library.StorageException: INSUFFICIENT_ACCESS INFO 2020-03-26T14:58:33,486-0500 [automation-services-job-24bd078b-9571-4881-ab93-4c0dc7f16f04] scheduler.service.AutomationServicesEventProcessor: job: 24bd078b-9571-4881-ab93-4c0dc7f16f04 status updated to: FAILED, message: Task 2 'Save Analysis to Library' failed with: Spotfire.Dxp.Framework.Library.LibraryException: You do not have sufficient privileges for this action. ---> Spotfire.Dxp.Services.Library.LibraryServiceException: You do not have sufficient privileges for this action.
To resolve, ensure that "automationservices@SPOTFIRESYSTEM" user account is part of Custom Query Author group in Spotfire.
Note: To execute jobs on the server, you must be part of the group Automation Services Users. Doc: Custom Queries