Error in creating Task Persistence database schema.: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "px_policy" because it does not exist or you do not have permissions

Products

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

Issue/Introduction

Attempting to start an IM node which has been down, the following error is observed in the log, node startup fails.

Task Persistence and Object Store are separate. PX_POLICY table exits in the Object Store.

2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) CA IAM Framework Server
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) Copyright 2000 - 2013 CA. All Rights Reserved
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) ################################################
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) # IAM Framework 400.3.0.0.421
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) ################################################
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) ################################################
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) # CA Identity Manager 14.3.0.0.416
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) ################################################
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) ---- CA IAM FW Startup Sequence Initiated. ----
2020-12-18 14:29:57,313 INFO [ims.Main] (MSC service thread 1-8) * Startup Step 1 : Attempting to start ServiceLocator. 
2020-12-18 14:29:57,641 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 "px_policy" because it does not exist or you do not have permissions.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) [sqljdbc.jar:]
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:685) [sqljdbc.jar:]
 at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
 at com.netegrity.ims.util.DBImportSchema.importSchema(DBImportSchema.java:197) [ims.jar:]
 at com.netegrity.ims.util.DBImportSchema.importSchema(DBImportSchema.java:235) [ims.jar:]
 at com.netegrity.ims.util.DBImportSchema.importSchema(DBImportSchema.java:239) [ims.jar:]
 at com.netegrity.ims.bootstrap.SetupDatabase.upgradeSchema(SetupDatabase.java:508) [ims.jar:]
 at com.netegrity.ims.bootstrap.SetupDatabase.createSchema(SetupDatabase.java:276) [ims.jar:]
 at com.netegrity.ims.bootstrap.SetupDatabase.createSchema(SetupDatabase.java:74) [ims.jar:]
 at com.netegrity.ims.bootstrap.Main.start(Main.java:151) [ims.jar:]
 at com.netegrity.webapp.SystemInitializer.contextInitialized(SystemInitializer.java:44) [user_console.jar:]
 at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
 at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:193) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)
 at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)
 at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_181]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_181]
 at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_181]

2020-12-18 14:29:57,656 ERROR [ims.Main] (MSC service thread 1-8) The IAM FW Startup was not successful

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Cause

Incorrect DB queries in the upgrade scripts attempting to update px_policy in the TP DB

Resolution

Create a px_policy table in the Task Persistence table to allow the startup to proceed.