Symantec Identity Manager - Unable to cancel tasks - workpoint database version error

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

The workpoint database version should be 3.5.2 for the WPDS DSN but is found to not be 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 : 14.X

Component : IdentityMinder(Identity Manager)

Cause

In the screenshot below the KEY_NAME = "Version" in the error message, it states that the "version" is not present. Oracle is case sensitive when executing SQL commands.

Resolution

Navigate to the WP_INI table and modify "Version" to "version" cycle the application. This should allow the tasks to be cancelled successfully now.