Resolve error "WARN [JDBCExceptionReporter] SQL Error: 30000, SQLState: 25505" in Spectrum

Product Feature: Spectrum Server

Operating System: AIX

Issue

User receives the following errors:

WARN  [JDBCExceptionReporter] SQL Error: 30000, SQLState: 25505

ERROR [JDBCExceptionReporter] A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.

 

Cause

Spectrum doesn't have enough permissions to write to the derby database.

The Spectrum server was previously started by a root user and after the Spectrum server is shut down and started up by a different user with non root permissions, Spectrum will no longer have permissions to write to the database.

Resolution

UPDATED: October 20, 2017
The user will be required to perform one of the following:

1.) Shut down the Spectrum server and change the ownership of the Spectrum install directory to a non-root user.

2.) Shut down Spectrum and restart as root.


Spectrum will then have permissions to write to the database.