Error 25502: An SQL data change is not permitted for a read-only connection, user or database

Products

• Vantage Storage Resource Manager

Issue/Introduction

From Vantage web client, try to add host definition and received the error message ""Error 25502: An SQL data change is not permitted for a read-only connection, user or database." The following is the screenshot.

Also the Vantage web client's started task VANWEBUI log has the following messages.

Booting Derby (version The Apache Software Foundation - Apache Derby - ii.jj.kk.ll - (nnnnnn)) instance 601a400f-019c-3657-5b7e-00001
 9c145a0
 on database directory /xxx/yyy/webclientdb/DefinitionDb in READ ONLY mode with class loader java.net.URLClassLoader@2
 527d43d.

Resolution

Check the owner of the Vantage web client folders runtime and webclientdb is same as the started task VANWEBUI user id. If it is not same then change the owner using the following commands.

Commands to fix the owner (group is correct): 

- stop VANWEBUI started task

in OMVS run: (may require superuser account)

chown -R owneid /home-directory-where-webclientdb-folder resides. 

(For example, if vantagegmi is home folder and has the runtime and webclientdb folders and owner id is VANWEBUI then the command should be like 
chown -R VANWEBUI /xxxx/vantagegmi  ) Here xxxx is the folder path. 

- start VANWEBUI started task again.