IBM Support

Derby DB is in read-only mode

Troubleshooting


Problem

Portal administrator or user can not make any changes on the portal that will effect the DB. This includes search service changes, page creation, portlet deployment, etc.

Symptom

This will show in the DB:


Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 34 more
Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source)
at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getUpdateResultSet(Unknown Source)
at org.apache.derby.exe.ac80220011x0127xf869xde55xffffac0020e012d.fillResultSet(Unknown Source)
at org.apache.derby.exe.ac80220011x0127xf869xde55xffffac0020e012d.execute(Unknown Source)
at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 28 more

Cause

The user that had started Portal did not have write access to the Derby file structure, or an object within the file structure. To resolve you can either use the Root user, or double check permissions within the Derby file structure to ensure your user can access everything.

Resolving The Problem

Stop the portal server, and restart this as an operating system root user.

[{"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.1","Edition":"","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
03 December 2021

UID

swg21428150