Skip to Content.
Sympa Menu

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

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog


Chronological Thread 
  • From: Gasperowicz Jérémy <>
  • To: ,
  • Subject: [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog
  • Date: Wed, 31 Oct 2012 11:39:51 +0100

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



Archive powered by MHonArc 2.6.16.

Top of Page