Unable to configure an external datasource in CA Identity Suite Virtual Appliance (vApp)

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

While trying to configure an external database access for the Identity Suite virtual appliance, we have created a MyDS.properties file.

When using the command "addJBossDatasource MyDS.properties", we get the following error: "ERROR] the parameter "IMAG_PACKAGE" set in the file "/opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/MyDS.properties" is invalid 

 

IMAG_PACKAGE=IM
DB_TYPE=MSSQL
DATASOURCE_NAME=-TESTIAM-IDM
DB_URL=jdbc:sqlserver://<host>:<port>
DB_USER=<username>
DB_PASSWORD=<password>

Environment

CA Identity Suite, Virtual Appliance Version 14.x

Cause

The error is usually related to white spaces in the custom file used.

Resolution

1. Check for any white spaces which could be causing the file not be read properly

2. Try creating a new file and see whether problem persists.

3. Run the following command

dos2unix /opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/MyDS.properties

before trying to use addJBossDatasource again

In some environments the Wildfly Application must be reloaded for the datasource to be loaded into memory for useage. 

See KB 39417 Add users to wildfly management console to configure datasources/drivers for IDM for details on adding a user to Wildfly

Then once logged into the Wildfly Console on port 9990 issue the 'reload' command.

Additional Information

Check KB 122263 IMAG_PACKAGE set in the file is invalid if above didn't work.

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-suite/14-5/virtual-appliance/configuring-virtual-appliance.html