org.springframework.orm.hibernate.HibernateQueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser; nested exception is net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser

Atlassian JIRA | Samuel Patrice Rompas [Atlassian] | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    *Steps to replicate* # Add an Active Directory as Confluence User Directory # Enable Incremental Synchronisation # Wait for Incremental Synchronisation to fail *Observed behaviour* Error shown in the log: {noformat} 2015-02-26 10:54:24,942 ERROR [scheduler_Worker-8] [atlassian.crowd.directory.DbCachingRemoteDirectory] synchroniseCache Incremental synchronisation for directory [ 294914 ] was unexpectedly interrupted, falling back to a full synchronisation org.springframework.orm.hibernate.HibernateQueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser; nested exception is net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:581) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindAllUsersWithExternalId(HibernateUserDao.java:590) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.getAllExternalIds(HibernateUserDao.java:538) at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.getAllExternalIds(CachedCrowdUserDao.java:392) at sun.reflect.GeneratedMethodAccessor1568.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy42.getAllExternalIds(Unknown Source) at com.atlassian.crowd.directory.AbstractInternalDirectory.getAllUserExternalIds(AbstractInternalDirectory.java:671) at com.atlassian.crowd.directory.DbCachingRemoteChangeOperations.getAllUserGuids(DbCachingRemoteChangeOperations.java:1513) at sun.reflect.GeneratedMethodAccessor1567.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.atlassian.crowd.directory.$Proxy2662.getAllUserGuids(Unknown Source) at com.atlassian.crowd.directory.DirectoryCacheImplUsingChangeOperations.getAllUserGuids(DirectoryCacheImplUsingChangeOperations.java:220) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.validateAndReturnGuidsToAddAndDelete(UsnChangedCacheRefresher.java:277) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChangesGuid(UsnChangedCacheRefresher.java:313) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChanges(UsnChangedCacheRefresher.java:374) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseChanges(UsnChangedCacheRefresher.java:117) at com.atlassian.crowd.directory.DbCachingRemoteDirectory.synchroniseCache(DbCachingRemoteDirectory.java:1095) at com.atlassian.crowd.manager.directory.DirectorySynchroniserImpl.synchronise(DirectorySynchroniserImpl.java:76) at com.atlassian.crowd.directory.DbCachingDirectoryPoller.pollChanges(DbCachingDirectoryPoller.java:50) at com.atlassian.crowd.manager.directory.monitor.poller.DirectoryPollerJobRunner.runJob(DirectoryPollerJobRunner.java:93) at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:135) at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:101) at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:80) at com.atlassian.scheduler.quartz1.Quartz1Job.execute(Quartz1Job.java:32) at org.quartz.core.JobRunShell.run(JobRunShell.java:223) at com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:22) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) Caused by: net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:50) at net.sf.hibernate.expression.AbstractCriterion.getColumns(AbstractCriterion.java:42) at net.sf.hibernate.expression.NotNullExpression.toSqlString(NotNullExpression.java:26) at net.sf.hibernate.loader.CriteriaLoader.<init>(CriteriaLoader.java:64) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3676) at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao$6.doInHibernate(HibernateUserDao.java:595) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 42 more {noformat} Despite this error, the FULL Sync is working correctly.

    Atlassian JIRA | 2 years ago | Samuel Patrice Rompas [Atlassian]
    org.springframework.orm.hibernate.HibernateQueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser; nested exception is net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser
  2. 0

    *Steps to replicate* # Add an Active Directory as Confluence User Directory # Enable Incremental Synchronisation # Wait for Incremental Synchronisation to fail *Observed behaviour* Error shown in the log: {noformat} 2015-02-26 10:54:24,942 ERROR [scheduler_Worker-8] [atlassian.crowd.directory.DbCachingRemoteDirectory] synchroniseCache Incremental synchronisation for directory [ 294914 ] was unexpectedly interrupted, falling back to a full synchronisation org.springframework.orm.hibernate.HibernateQueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser; nested exception is net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:581) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindAllUsersWithExternalId(HibernateUserDao.java:590) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.getAllExternalIds(HibernateUserDao.java:538) at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.getAllExternalIds(CachedCrowdUserDao.java:392) at sun.reflect.GeneratedMethodAccessor1568.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy42.getAllExternalIds(Unknown Source) at com.atlassian.crowd.directory.AbstractInternalDirectory.getAllUserExternalIds(AbstractInternalDirectory.java:671) at com.atlassian.crowd.directory.DbCachingRemoteChangeOperations.getAllUserGuids(DbCachingRemoteChangeOperations.java:1513) at sun.reflect.GeneratedMethodAccessor1567.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.atlassian.crowd.directory.$Proxy2662.getAllUserGuids(Unknown Source) at com.atlassian.crowd.directory.DirectoryCacheImplUsingChangeOperations.getAllUserGuids(DirectoryCacheImplUsingChangeOperations.java:220) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.validateAndReturnGuidsToAddAndDelete(UsnChangedCacheRefresher.java:277) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChangesGuid(UsnChangedCacheRefresher.java:313) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChanges(UsnChangedCacheRefresher.java:374) at com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseChanges(UsnChangedCacheRefresher.java:117) at com.atlassian.crowd.directory.DbCachingRemoteDirectory.synchroniseCache(DbCachingRemoteDirectory.java:1095) at com.atlassian.crowd.manager.directory.DirectorySynchroniserImpl.synchronise(DirectorySynchroniserImpl.java:76) at com.atlassian.crowd.directory.DbCachingDirectoryPoller.pollChanges(DbCachingDirectoryPoller.java:50) at com.atlassian.crowd.manager.directory.monitor.poller.DirectoryPollerJobRunner.runJob(DirectoryPollerJobRunner.java:93) at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:135) at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:101) at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:80) at com.atlassian.scheduler.quartz1.Quartz1Job.execute(Quartz1Job.java:32) at org.quartz.core.JobRunShell.run(JobRunShell.java:223) at com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:22) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) Caused by: net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:50) at net.sf.hibernate.expression.AbstractCriterion.getColumns(AbstractCriterion.java:42) at net.sf.hibernate.expression.NotNullExpression.toSqlString(NotNullExpression.java:26) at net.sf.hibernate.loader.CriteriaLoader.<init>(CriteriaLoader.java:64) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3676) at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238) at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao$6.doInHibernate(HibernateUserDao.java:595) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 42 more {noformat} Despite this error, the FULL Sync is working correctly.

    Atlassian JIRA | 2 years ago | Samuel Patrice Rompas [Atlassian]
    org.springframework.orm.hibernate.HibernateQueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser; nested exception is net.sf.hibernate.QueryException: could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser
  3. 0

    Hibernate Community • View topic - Criteria API .addOrder(...) problem.

    hibernate.org | 10 months ago
    net.sf.hibernate.QueryException: could not resolve property: kid.name of: package.Parent
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. net.sf.hibernate.QueryException

      could not resolve property: directory.externalId of: com.atlassian.crowd.model.user.InternalUser

      at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns()
    2. net.sf.hibernate
      CriteriaImpl.list
      1. net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:50)
      2. net.sf.hibernate.expression.AbstractCriterion.getColumns(AbstractCriterion.java:42)
      3. net.sf.hibernate.expression.NotNullExpression.toSqlString(NotNullExpression.java:26)
      4. net.sf.hibernate.loader.CriteriaLoader.<init>(CriteriaLoader.java:64)
      5. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3676)
      6. net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
      6 frames
    3. com.atlassian.crowd
      HibernateUserDao$6.doInHibernate
      1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao$6.doInHibernate(HibernateUserDao.java:595)
      1 frame
    4. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
      2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
      2 frames
    5. com.atlassian.crowd
      HibernateUserDao.getAllExternalIds
      1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindAllUsersWithExternalId(HibernateUserDao.java:590)
      2. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.getAllExternalIds(HibernateUserDao.java:538)
      2 frames
    6. com.atlassian.confluence
      CachedCrowdUserDao.getAllExternalIds
      1. com.atlassian.confluence.user.crowd.CachedCrowdUserDao.getAllExternalIds(CachedCrowdUserDao.java:392)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1568.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    11. com.sun.proxy
      $Proxy42.getAllExternalIds
      1. com.sun.proxy.$Proxy42.getAllExternalIds(Unknown Source)
      1 frame
    12. com.atlassian.crowd
      DbCachingRemoteChangeOperations.getAllUserGuids
      1. com.atlassian.crowd.directory.AbstractInternalDirectory.getAllUserExternalIds(AbstractInternalDirectory.java:671)
      2. com.atlassian.crowd.directory.DbCachingRemoteChangeOperations.getAllUserGuids(DbCachingRemoteChangeOperations.java:1513)
      2 frames
    13. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1567.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames
    14. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    15. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    16. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    17. com.atlassian.crowd
      DirectoryPollerJobRunner.runJob
      1. com.atlassian.crowd.directory.$Proxy2662.getAllUserGuids(Unknown Source)
      2. com.atlassian.crowd.directory.DirectoryCacheImplUsingChangeOperations.getAllUserGuids(DirectoryCacheImplUsingChangeOperations.java:220)
      3. com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.validateAndReturnGuidsToAddAndDelete(UsnChangedCacheRefresher.java:277)
      4. com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChangesGuid(UsnChangedCacheRefresher.java:313)
      5. com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseUserChanges(UsnChangedCacheRefresher.java:374)
      6. com.atlassian.crowd.directory.ldap.cache.UsnChangedCacheRefresher.synchroniseChanges(UsnChangedCacheRefresher.java:117)
      7. com.atlassian.crowd.directory.DbCachingRemoteDirectory.synchroniseCache(DbCachingRemoteDirectory.java:1095)
      8. com.atlassian.crowd.manager.directory.DirectorySynchroniserImpl.synchronise(DirectorySynchroniserImpl.java:76)
      9. com.atlassian.crowd.directory.DbCachingDirectoryPoller.pollChanges(DbCachingDirectoryPoller.java:50)
      10. com.atlassian.crowd.manager.directory.monitor.poller.DirectoryPollerJobRunner.runJob(DirectoryPollerJobRunner.java:93)
      10 frames
    18. com.atlassian.scheduler
      Quartz1Job.execute
      1. com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:135)
      2. com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:101)
      3. com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:80)
      4. com.atlassian.scheduler.quartz1.Quartz1Job.execute(Quartz1Job.java:32)
      4 frames
    19. quartz
      JobRunShell.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:223)
      1 frame
    20. com.atlassian.confluence
      ConfluenceQuartzThreadPool$1.run
      1. com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:22)
      1 frame
    21. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
      1 frame