VERIFIED SOLUTION i
X

Linux: Cannot receive email notifications from Spectrum- Geotax Datafiles expiry notificaiton

Issue

ERROR [JobStoreTX] MisfireHandler: Error handling misfires: Couldn't store trigger 'Spectrum Trigger.39ed6b5f-d84a-4385-9947-c22762dfb8d9' for 'Spectrum Job.39ed6b5f-d84a-4385-9947-c22762dfb8d9' job:An SQL data change is not permitted for a read-only connection, user or database.
org.quartz.JobPersistenceException: Couldn't store trigger 'Spectrum Trigger.39ed6b5f-d84a-4385-9947-c22762dfb8d9' for 'Spectrum Job.39ed6b5f-d84a-4385-9947-c22762dfb8d9' job:An SQL data change is not permitted for a read-only connection, user or database. [See nested exception: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.]

Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
 
Caused by: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database.
 
 

Cause

There are not enough permissions for the Spectrum Server to process the notifications properly.

Resolution

UPDATED: March 28, 2017


Run the following code in order to mediate the repeating errors. Shut down the server to recursively change the permissions to the database directories then start up.
 
server.stop
chown -R user:group /INSTALL DIRECTORY/server     
chmod -R 775 /INSTALL DIRECTORY/server
. ./setup
server.start

If the issue is unresolved after following these steps, contact technical support for further assistance.

Environment Details

Product Feature: Management Console

Operating System: Linux

 

Downloads

  • No Downloads