Promote fails...

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts Page 1 of 1

rarogerson

Posts: 10
Joined: Fri Aug 30, 2013 4:03 pm

Post by rarogerson » Tue Apr 15, 2014 3:49 pm
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

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Tue Apr 15, 2014 4:32 pm
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!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

rarogerson

Posts: 10
Joined: Fri Aug 30, 2013 4:03 pm

Post by rarogerson » Wed Apr 16, 2014 1:48 pm
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

Support Specialist
Posts: 7
Joined: Thu Oct 24, 2013 10:23 am

Post by Support_Chris » Thu Apr 17, 2014 1:17 pm
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
Chris Spargen
Technical Support Manager

e. [email protected]
p. 1-800-949-4696
w. GoAnywhere.com | HelpSystems.com
4 posts Page 1 of 1