grouper-users - Re: [grouper-users] grouper PSP errors

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] grouper PSP errors

From: Rahul Doshi <>
To: Gagné Sébastien <>
Cc: "" <>
Subject: Re: [grouper-users] grouper PSP errors
Date: Mon, 18 Mar 2013 19:52:29 +0000
Accept-language: en-US
Authentication-results: sfpop-ironport05.merit.edu; dkim=neutral (message not signed) header.i=none

Hi Sébastien,

Thanks for the suggestions. I was able to fix the problem by following steps suggested by Shilen.

Rahul

From: Gagné Sébastien <>
Date: Monday, March 18, 2013 3:47 PM
To: Rahul Doshi <>, Shilen Patel <>
Cc: "" <>
Subject: RE: [grouper-users] grouper PSP errors

Have you tried turning it off and on ? (“it” being the Daemon)

If it didn’t work a quick(and drastic) solution would be :

- Shutdown your Grouper Loader

- Flush either GROUPER_CHANGE_LOG or GROUPER_CHANGELOG_TEMP table

This depends on what data you want to keep. If the PSP provisioning completed all the current changelog I would flush the CHANGE_LOG table so the new temp changelog can be brought in.

There might be better solutions and this depends if it’s in production or not.

PS. Even if you have multiple servers running Grouper, only one of them must have the Daemon running.

De : [] De la part de Rahul Doshi
Envoyé : 18 mars 2013 14:09
À : Shilen Patel
Cc :
Objet : Re: [grouper-users] grouper PSP errors

Yes, we are still having the problem. I just went back in the logs to find the first occurrence of the problem so that it might help to know better what triggered the issue. Current errors are below.

2013-03-18 14:05:50,061: [DefaultQuartzScheduler_Worker-5] 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.PITMember), ByHqlStatic, query: 'select pitMember from PITMember as pitMember where pitMember.sourceId = :id and activeDb = 'T'', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMemberDAO.FindBySourceIdActive, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'id'->'07058251fa4b46cba6cab0ecbe9a6d0d', ,

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.Hib3PITMemberDAO.findBySourceIdActive(Hib3PITMemberDAO.java:70)

at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMembershipAdd(ChangeLogTempToEntity.java:708)

at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$1700(ChangeLogTempToEntity.java:59)

at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:135)

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: 3

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

2013-03-18 14:05:50,066: [DefaultQuartzScheduler_Worker-5] ERROR GrouperLoaderJob.execute(303) - - Error running up job