I installed the Vantage Storage Point Web Client and the logon to the VantageDB fails with:
RPC: Method Failed: runDbUpgrade on: Tue Aug 07 11:46:31 GMT+100 2018
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25503]; error code [30000];
--- The error occurred in /resources/vantage/gmi/db/versionDb.xml.
--- The error occurred while applying a parameter map.
--- Check the createDbVersionTable-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: DDL is not permitted for a read-only connection, user or database.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in /resources/vantage/gmi/db/versionDb.xml.
--- The error occurred while applying a parameter map.
--- Check the createDbVersionTable-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: DDL is not permitted for a read-only connection, user or database.
What could be the reason for this?
Vantage Storage Point Web Client
The Vantage Storage Point Web Client Started Task or Batch User must have WRITE access to the Vantage DB directories. If the User has READ access only, logon fails with:
--- Cause: java.sql.SQLException: DDL is not permitted for a read-only connection, user or database.
The WEBZFSM installation job from the CCTUSAMP library already sets Permission bits to 775 for the runtime and webclientdb directories using:
chmod -R 775 /u/users/cai/vantagegmi/webclientdb
chmod -R 775 /u/users/cai/vantagegmi/runtime
Which means the Owner and Group have READ/WRITE/EXECUTE permissions.
Use the chown or chgrp command to change the Owner or Group accordingly.
For example, to make user VANWEBUI the Owner use:
chown -R VANWEBUI /u/users/cai/vantagegmi/webclientdb
chown -R VANWEBUI /u/users/cai/vantagegmi/runtime
The Group and Owner can already be set correctly during installation in the following installation script prompt:
===============================================================================
Change group and owner dialog
-----------------------------
Select whether owner and group for all installed files should be changed
or use your current id and primary group.
Type 'quit' to exit the installer.
Type 'back' to return to the previous screen.
1- Change owner and group for installed files
2- DO NOT change owner and group for installed files
ENTER THE NUMBER OF THE DESIRED CHOICE: