CA Identity Manager: The IAM Framework Failed to start due to database errors

Products

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

Issue/Introduction

The symptom of this issue is that when you attempt to access the CA IAM Management console it doesn't load and shows "The IAM Framework failed to start" 

In the logs you'll see the following error: 
ERROR [ims.tmt.CreateDatabaseSchema] (MSC service thread 1-8) Error in creating Task Persistence database schema.: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "DATABASE TABLE NAME" because it does not exist or you do not have permissions. 

Environment

Release:
Component: IDMGR

Cause

When a database table is missing your application server will recreate it as part of the CA IAM startup sequence. However, if you see this error it means that the user connecting to your database does not have full administrator rights and therefore cannot rebuild the missing table. 

Resolution

Provide full administrator rights to your database service account so that the account can recreate your missing table.