Unable to logon to VantageDB

book

Article ID: 110038

calendar_today

Updated On:

Products

CA Vantage Storage Resource Manager

Issue/Introduction



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?
 

Environment

Release: SMV3EN00200-14.0-Graphical Management Interface
Component:

Resolution

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: