WPDS error during restart: there is already an object named...

Products

• CA Identity Manager

Issue/Introduction

Following error occur while starting IDM

Creating Workpoint sqlserver database for the WPDS DSN
ERROR [com.workpoint.server.recordset.SmartStatement] (Timer-3) SQLException caught com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WP_ACT' in the database.

Environment

Identity Manager 14.4 

MSSQL 2019

Cause

WPDS tables already exist on the database 

Resolution

update the <app server home>/iam_im.ear/config/workpoint –server.properties file as follows:

workpoint.db.provider=<oracle/sqlserver(based on DB type)>

workpoint.db.name=<DB name for MSSQL, or service name for oracle>