Grouper Users - Open Discussion List

[Gasperowicz Jérémy <>]

Hi,

I'm getting an error when I run the loader job and I don't know where 
may be the source of problem, why i'm having multiple result
Here is the error :

2012-10-30 16:03:50,058: [DefaultQuartzScheduler_Worker-6] ERROR 
GrouperLoaderJob.runJob(406) -  - Error on job: 
CHANGE_LOG_changeLogTempToChangeLog
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Exception in uniqueResult: (class 
edu.internet2.middleware.grouper.pit.PITMembership), ByHqlStatic, query: 
'select pitMembership from PITMembership as pitMembership where 
pitMembership.sourceId = :id and activeDb = 'T'', cacheable: true, 
cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.FindBySourceIdActive, 
tx type: null, tx type: nullBind var[0]: 'Param (class 
java.lang.String): 'id'->'fb686e35f40547948dbc3a860885bde2', ,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:495)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:581)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:323)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.findBySourceIdActive(Hib3PITMembershipDAO.java:70)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMembershipDelete(ChangeLogTempToEntity.java:744)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$1800(ChangeLogTempToEntity.java:59)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:137)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:91)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:550)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:398)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:300)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.hibernate.NonUniqueResultException: query did not return 
a unique result: 2
    at 
org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
    at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
    at 
edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:257)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:332)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    ... 12 more
2012-10-30 16:03:50,062: [DefaultQuartzScheduler_Worker-6] ERROR 
GrouperLoaderJob.execute(303) -  - Error running up job
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Exception in uniqueResult: (class 
edu.internet2.middleware.grouper.pit.PITMembership), ByHqlStatic, query: 
'select pitMembership from PITMembership as pitMembership where 
pitMembership.sourceId = :id and activeDb = 'T'', cacheable: true, 
cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.FindBySourceIdActive, 
tx type: null, tx type: nullBind var[0]: 'Param (class 
java.lang.String): 'id'->'fb686e35f40547948dbc3a860885bde2', ,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:495)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:581)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:323)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.findBySourceIdActive(Hib3PITMembershipDAO.java:70)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMembershipDelete(ChangeLogTempToEntity.java:744)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$1800(ChangeLogTempToEntity.java:59)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:137)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:91)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:550)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:398)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:300)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.hibernate.NonUniqueResultException: query did not return 
a unique result: 2
    at 
org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
    at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
    at 
edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:257)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:332)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    ... 12 more

Any ideas ? misconfiguration ?

Jérémy