Grouper Users - Open Discussion List

[Jeff McCullough <>]

I was going to try the gsh command you list, but found that just starting up gsh to run 

loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog”)

caused the same error I sent previously.

Jeff

On Jan 15, 2015, at 5:28 AM, Chris Hyzer <> wrote:

Hopefully there is more in the logs, can you send the whole log file (sanitized if need be?)  you can just send to me if you dont want to send to the list

 

Was there an error when you initted the DB?

 

What does gsh -registry -deep give?

 

Thanks,

Chris

 

From:  [] On Behalf Of Jeff McCullough
Sent: Wednesday, January 14, 2015 8:58 PM
To: 
Subject: [grouper-users] DB error?

 

We created a new schema in our Oracle DB for grouper related tables. I’m seeing the following error when using the new schema when the loader starts up. I’m assuming it is the GROUPER_MEMBERSHIPS table. Is there anything beyond write access that might be an issue.

 

Thanks,

Jeff

 

edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in uniqueResult: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select distinct ms, m from MembershipEntry as ms, Member as m, Field as field where       ms.ownerAttrDefId  = :owner            and  ms.memberUuid = :member           and  ms.fieldId = :fuuid and  ms.memberUuid = m.uuid  and  ms.type   = 'immediate' ', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'7165a18dab6d48f38e185a134537e18d', Bind var[1]: 'Param (class java.lang.String): 'member'->'dd9bcd0edc51479889fbd47d630c2ca0'Bind var[2]: 'Param (class java.lang.String): 'fuuid'->'cbc7637eefff44d8b7354582e34cfe5e', ,

Exception in save: edu.internet2.middleware.grouper.Membership,,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in save: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,