Promote fails...

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

Promote fails...

Postby 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
rarogerson
 
Posts: 4
Joined: Fri Aug 30, 2013 4:03 pm

Re: Promote fails...

Postby 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
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 172
Joined: Tue Jul 17, 2012 2:12 pm

Re: Promote fails...

Postby 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
rarogerson
 
Posts: 4
Joined: Fri Aug 30, 2013 4:03 pm

Re: Promote fails...

Postby 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
Support_Chris
 
Posts: 6
Joined: Thu Oct 24, 2013 10:23 am


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 2 guests