Grouper Users - Open Discussion List

[Gagné Sébastien <>]

It seems you have some problem with the data in your Database. Do you have 
more than one Grouper Loader process running ?

It seems to be related to PIT, you can try to execute the following :

$GROUPER_HOME/bin/gsh
%1 new 
edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()


-----Message d'origine-----
De : 

 
[mailto:]
 De la part de Gasperowicz Jérémy
Envoyé : 31 octobre 2012 06:40
À : 
;
 

Objet : [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog

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