Missing right parenthesis during IDM startup

Products

• CA Identity Suite

Issue/Introduction

Getting the following error during IDM start up

 ERROR [com.workpoint.server.DbVerifier] (Timer-3) An exception occurred when attempting to auto-create the Workpoint database. java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

ERROR [com.workpoint.server.recordset.SmartStatement] (Timer-4) SQLException caught java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Environment

Release : Identity Manager 14.4

Cause

Workpoint pointing to wrong database type

Resolution

Modify the Workpoint-server.properties 

Change attribute workpoint.db.provider = oracle