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: ")RROR] the parameter "IMAG_PACKAGE" set in the file "/opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/MyDS.properties" is invalid ("IM

 

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

Additional Information

Check https://knowledge.broadcom.com/external/article?articleId=122263 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

https://docops.ca.com/ca-identity-suite/14-1/EN/configuring/configuring-ca-identity-suite-virtual-appliance