Identity Portal remains as "starting" while deploying the IMAG Virtual Appliance using an external Oracle DB.
search cancel

Identity Portal remains as "starting" while deploying the IMAG Virtual Appliance using an external Oracle DB.

book

Article ID: 5744

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

When deploying the Virtual Appliance using an external Oracle database. The only item that does not finish to deploy is Identity Portal. 

Checking the Identity Portal logs the following error appears: 

java.sql.SQLSyntaxErrorException: ORA-02267: column type incompatible with referenced column type 

 

The DB user configured has the DBA role and all the required permissions. 

 

Environment

IMAG Virtual Appliance r14.0 with patches VA-14.0.0-PRE-CP and CP-IP-140000-0001

Cause

The cause is worng permissions provided to teh Database user.

The permissions should be RESOURCE and CONNECT only and not any other permission.

Adding more permissions will cause the deployment to fail.

This is specified in the documentation (in teh Virtual Appliance Web UI -> help -> Prerequisites for configuring the vApp with an external database), and also on the same page where you configure the database credentials during setup)

Oracle:  

------- 

a. Create an Identity Portal database. 

b. Create a user with CONNECT and RESOURCE privileges on the Identity Portal database. 

 

Resolution

Change the database user permissions to include only RESOURCE and CONNECT.

Additional Information

https://docops.ca.com/ca-identity-suite/14-0/EN/installing/installing-ca-identity-portal/ca-identity-portal-installation-process/installing-a-database#InstallingaDatabase-OracleDatabase