Unable to logon to VantageDB

Document ID : KB000110038
Last Modified Date : 08/08/2018
Show Technical Document Details
Question:
I installed the Vantage Web Client and logon to 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?
 
Answer:
The Vantage 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.
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


 
Additional Information:
The Group and Owner can already be set correctly during installation in the

===============================================================================
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: