CA Identity Manager: The IAM Framework Failed to start due to database errors
Article ID: 97615
CA Identity ManagerCA Identity GovernanceCA Identity Portal
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.
Release: Component: IDMGR
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.
Provide full administrator rights to your database service account so that the account can recreate your missing table.