Grouper Users - Open Discussion List

[Chris Hyzer <>]

count the number of tables and views from the original working schema, and the new schema (esp that start with "GROUPER").  Is it equal?

 

I think your exception indicated that grouper_memberships_all_v isnt found in the new schema.  Is it there?  Can you select from it?  Its valid?

 

Thanks,

Chris

 

 

From: Jeff McCullough [mailto:]
Sent: Thursday, January 15, 2015 7:31 PM
To: Chris Hyzer
Cc:
Subject: Re: [grouper-users] DB error?

 

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,