While trying to import the user from LDAP in vCD, it is getting error: No row with the given identifier exists: [com.vmware.vcloud.common.model.IntegratedUserModel########-####-####-####-########]

Products

• VMware Cloud Director

Issue/Introduction

1. 1. Importing user(s) from LDAP getting errored out without creating any task in VMware Cloud Director.
      vCD Provider Portal >> Administration >> Users >> Import User >> Search and select the user >> Import
   2. Below is the screenshot of the error:
      
   3. In vcloud-container-debug.log file, you may see below entries:
      

      ERROR    | pool-jetty-2113747        | DefaultExceptionMapper         | Internal server exception | requestId=<request-id>,request=POST https://<vCD-FQDN>/cloudapi/1.0.0/users,requestTime=##############,remoteAddress=###.###.###.###:####,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 ...,accept=application/json;version 40.0.0-alpha org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.vmware.vcloud.common.model.IntegratedUserModel########-####-####-#####-#########]
              at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:409)
              at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:171)
              at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)
              at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)
              at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)
      ..
      ..
      ..
      at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:242)
              at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
              at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
              at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:479)
      ..
      ..
      ..
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
      ..
      ..
      ..
      at jdk.internal.reflect.GeneratedMethodAccessor51092.invoke(Unknown Source)
              at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.base/java.lang.reflect.Method.invoke(Method.java:566)
              at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179)
              at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
              at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201)
      ..
      ..

    

Environment

VMware Cloud Director 10.6.x

Cause

The database contained an orphaned row linking an active group to a legacy user ID that no longer exists in another table. When importing new members into this group, Hibernate scanned the group's membership tree and crashed with an ObjectNotFoundException upon hitting this missing user reference due to a historic transaction anomaly (e.g., cell timeout).

Resolution

This will need the modification in the VMware Cloud Director DB, so please make sure to take the  backup of the VMware Cloud Director Database: Backup and Restore of VMware Cloud Director Appliance
Please open a case with Broadcom Support to do the modification in VCD Database. For more information, see Creating and managing Broadcom support cases