Technote (troubleshooting)
Problem(Abstract)
How do I fix the error "DDL is not permitted for a read-only connection" when trying to create a charting portlet?
Symptom
Following error when trying to create a charting portlet
2) The $TIP_HOME/profiles.TIPProfile/logs/server1/SystemOut.log shows following error
[1/29/13 5:41:18:739 EST] 00000024 rest E com.ibm.tivoli.rest.RestProvidersURI getDatasourceWidgetDefinition unexpected exception:
com.ibm.tivoli.rest.widget.WidgetRegistryException: (ATKRST100E) ATKRST100E An unexpected error occured. The error message is as follows: 'DDL is not permitted for a read-only connection, user or database.'.: nested exception is:
java.sql.SQLException: DDL is not permitted for a read-only connection, user or database.
Cause
This happens if the server is started as another user (root) and then try to start it as the user that has installed TIP.
This is because some permissions on derby DB files would be changed and the non-root user would not have permission to overwrite that file at the time of startup.
Resolving the problem
1) Navigate to <TIPHOME>
2) Find all files that are not owned by TIP install user by running
find . ! -user {TCR install userid} -print
3) Once the files are found, run "chown" command to change the ownership of the files to install user.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.