SQL error after vApp installation: bad SQL grammar [SELECT DBMaxFieldLength FROM SAGE_VERSION]

Products

• CA Identity Suite

Issue/Introduction

Customer is seeing the below error after vApp installation is done and while starting the application (IG logs).

Caused by: Error : 904, Position : 7, Sql = SELECT DBMaxFieldLength FROM SAGE_VERSION, OriginalSql = SELECT DBMaxFieldLength FROM SAGE_VERSION, Error Msg = ORA-00904: "DBMAXFIELDLENGTH": invalid identifier

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:636)
        ... 103 more

16:25:13,238 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "eurekify.war")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.deployment.unit.\"eurekify.war\".undertow-deployment" => "java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sageDal' defined in class path resource [META-INF/managerContext.xml]: Cannot resolve reference to bean 'sageDalBase' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sageDalBase' defined in class path resource [META-INF/managerContext.xml]: Cannot create inner bean 'com.eurekify.dal.SageDalImpl#340f61eb' of type [com.eurekify.dal.SageDalImpl] while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.eurekify.dal.SageDalImpl#340f61eb' defined in class path resource [META-INF/managerContext.xml]: Cannot resolve reference to bean 'sageJdbcDal' while setting bean property 'jdbcDal'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sageJdbcDal' defined in class path resource [META-INF/managerContext.xml]: Cannot resolve reference to bean 'sageJdbcDalTarget' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sageJdbcDalTarget' defined in class path resource [META-INF/dataAccessContext-Oracle.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanInitializationException: Initialization of DAO failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT DBMaxFieldLength FROM SAGE_VERSION]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: \"DBMAXFIELDLENGTH\": invalid identifier

.

Environment

vApp 14.5.

Cause

Database was not initialized.

Resolution

Run command "populateIgDatabase". After the command runs successfully you will be able to access IG.