Skip to Content.
Sympa Menu

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

Subject: Grouper Users - Open Discussion List

List archive

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


Chronological Thread 
  • From: Gasperowicz Jérémy <>
  • To:
  • Subject: Re: [grouper-users] Error on job: CHANGE_LOG_changeLogTempToChangeLog
  • Date: Wed, 31 Oct 2012 14:57:20 +0100
I've only one Grouper Loader process running but it already happened to me in having to.

I've done the following :
$GROUPER_HOME/bin/gsh
%1 new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()
and it returned :
Searching for point in time fields that should be inactive
Found 0 active point in time fields that should be inactive
java.lang.Long: 0
And finally I've got the same error
Thanks for your help

Le 31/10/2012 14:26, Gagné Sébastien a écrit : 
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 :  [] 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

Archive powered by MHonArc 2.6.16.

Top of Page