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

Document ID : KB000097615
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
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. 
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.