The target server said - An SQL data change is not permitted for a read-only connection, user or database..
What is this error and where do I look to fix it?
An SQL data change is not permitted for a read-only connection, user or database..This seems to indicate that you're using an externally defined DB (MSSQL, MySQL, Oracle, DB2, etc) instead of the internal Derby DB that is utilized when the Product is shipped and that the permissions to connect to that DB are of a Read-Only nature.
You will need to look into the permissions granted to the UserID/Password assigned for access to the external Database connection. The UserID for that connection needs to have Read/Write access to the GADDATA Schema and have permissions to update those tables, including when new projects are moved.
Please give us a call at the Support Desk if you have further questions or need us to do a WebEx and take a look.
Lead Solutions Consultant
One note, I am in Toronto, Canada so I'm only available until 5:00 pm (EST) or I am available first thing in the morning.
Our support staff worked with David Lasiter today. The issue stemmed from the catalina.out file being too large for the iSeries to process. Once the file was renamed and a fresh catalina.out file was created, the error "An SQL data change is not permitted for a read-only connection, user or database.." was no longer appearing.
Technical Support Manager
w. GoAnywhere.com | HelpSystems.com