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.
Was this topic helpful?
Document Information
More support for:
WebSphere Portal
Software version:
6.1
Operating system(s):
AIX, Linux, Solaris, Windows
Document number:
405099
Modified date:
03 December 2021
UID
swg21428150