Identity Manager - Migration failed: [facility=4 severity=2 reason=0 status=38 message=No items found]

book

Article ID: 223128

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Suite

Issue/Introduction

After migrating Identity Manager to a different environment the below error is being thrown upon start up:

2021-08-05 21:18:12,303 ERROR [ims.tmt.util] (ServerService Thread Pool -- 138) Migration failed: [facility=4 severity=2 reason=0 status=38 message=No items found]
 at com.netegrity.llsdk6.imsimpl.directory.jndi.JNDIBase.findObjectByAttribute(JNDIBase.java:1182) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.directory.jndi.JNDIBase._findObjectByFriendlyName(JNDIBase.java:1129) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.directory.jndi.JNDIBase.findObjectByFriendlyName(JNDIBase.java:1064) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.directory.jndi.JNDIBase.getObject(JNDIBase.java:557) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.directory.jndi.JNDIDirectoryProvider.getObject(JNDIDirectoryProvider.java:402) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.provider.UserProviderImpl.findUser(UserProviderImpl.java:239) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.provider.UserProviderImpl.findUser(UserProviderImpl.java:215) [imsapi6.jar:]
 at com.netegrity.llsdk6.imsimpl.ImsEnvironmentImpl.getPublicUser(ImsEnvironmentImpl.java:695) [imsapi6.jar:]
 at com.netegrity.ims.util.MultipleEarMigrationHelper.migrateRealms(MultipleEarMigrationHelper.java:156) [ims.jar:]
 at com.netegrity.ims.util.MultipleEarMigrationHelper.migrateEnvs(MultipleEarMigrationHelper.java:128) [ims.jar:]
 at com.netegrity.ims.util.MultipleEarMigrationHelper.doMigratin(MultipleEarMigrationHelper.java:77) [ims.jar:]
 at com.netegrity.ims.bootstrap.Main.start(Main.java:338) [ims.jar:]
 at com.netegrity.webapp.SystemInitializer.contextInitialized(SystemInitializer.java:44) [user_console.jar:]
 at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:216) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:185) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
 at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:250) [undertow-servlet-2.0.15.Final.jar:2.0.15.Final]
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)
 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_201]
 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_201]
 at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
 at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
 at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_201]
 at org.jboss.threads.JBossThread.run(JBossThread.java:485)

Cause

There are two causes of this error.

1) If there was any inflight workflow prior to the migration

2) If any users were misplaced or deleted post migration

Example Error:

USER with unique name uid=imadmin,ou=people,ou=broadcom does not exist

Environment

Release : 14.3

Component :

Resolution

To confirm you do not have any in flight workflow, please run the below command:

SELECT tasksessionid FROM tasksession12_5 WHERE environmentid = oid AND ((((state = ''4'') OR (state = ''2048'') OR (state = ''4096'') OR (state = ''8192'')) AND last_access_time < CUTOFF_TIME))

If you have any pending workflow then you can run the below script to clean up old workflow. Your environment oid is discovered within the IDM Management Console under environments.

Sample SQL Cleanup Script:
DECLARE
 TASK_ID VARCHAR2(200);
BEGIN
FOR I IN
(select *
from tasksession12_5 
WHERE 
environmentid = oid AND ((((state = ''4'') OR (state = ''2048'') OR (state = ''4096'') OR (state = ''8192'')) AND last_access_time < CUTOFF_TIME))
)
LOOP
 TASK_ID := I.tasksessionid;

  GARBAGECOLLECTBYTASKID(
    TASK_ID => TASK_ID);
END LOOP;
END;

For the second error:

You will need to recreate all missing users.