"WorkPoint database version" Errors are preventing startup

Products

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

Issue/Introduction

When trying to boot up your Identity Manager server, the following error appears in the application server log: 

Error message = WorkItemPvt.query() returned com.workpoint.common.exception.WorkflowException. Error message = The WorkPoint database version should be '[version #]' for the WPDS DSN but is found to be not present in the WP_INI table for SECTION_NAME=Database and KEY_NAME=version. This may mean you are running against an incompatible or outdated WorkPoint database version. Please upgrade the WorkPoint database manually, or set the auto.db.create.or.upgrade property to true in the workpoint-server.properties file and restart the server.

Environment

Release:
Component: SIGMA

Resolution

If this is occurring after an UPGRADE of Governance:

In the workpoint-server.properties file there is a setting called:
auto.db.create.or.upgrade

Set this property to true and restart the server. This allows the WP DB to upgrade itself.

The workpoint-server.properties for Identity Manager is located in a directory similar to:
\CA\Identity Manager\IAM Suite\Identity Manager\tools\Workpoint\conf\

For IM version 14.4, the workpoint-server.properties file is located in the below directory:

/opt/CA/wildfly-idm/standalone/deployments/iam_im.ear/config

The workpoint-server.properties for Identity Governance file is located in a directory similar to:
RCM_HOME\Server\eurekify-jboss\Workpoint

If this is occurring during a FRESH INSTALL of Governance:

Have the DBA drop all tables from the Workpoint database 'WPDS' 
Then attempt to start Governance.