Promote fails...

[rarogerson]

When I try to promote a project from our DEV to PROD systems I receive the error.

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?

Thanks,

Rob

[Support_Rick]

Robert,

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.

Thanks!

[rarogerson]

Hello Rick. Could you set up a Webex to take a look when you have a chance. I passed the problem by David Lasiter but he didn't know what the problem was either.

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.

Thanks,

Rob

[Support_Chris]

Hi Rob,
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.

Thanks,
Chris