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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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 | 8 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