grouper-users - [grouper-users] RE: Grouper database schema DDL requires updates

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper database schema DDL requires updates

From: "Doppala, Karthik" <>
To: Chris Hyzer <>
Cc: "" <>
Subject: [grouper-users] RE: Grouper database schema DDL requires updates
Date: Fri, 25 Apr 2014 19:14:50 +0000
Accept-language: en-US

Thanks Chris, that helped we copied the schema without any data so obviously it couldn’t find the version at start up. Just curious, what is GroupOrg? I see that the first two rows are created when we setup the registry.

From: Chris Hyzer [mailto:]
Sent: Friday, April 25, 2014 11:01 AM
To: Doppala, Karthik
Cc:
Subject: RE: Grouper database schema DDL requires updates

What does your grouper_ddl table have in it?

The Grouper entry should be 26 I believe… if that matches what Grouper expects then it should not bomb on startup… (if you are sure all the db objects are up to date)

Chris

From: Doppala, Karthik []
Sent: Friday, April 25, 2014 1:53 PM
To: Chris Hyzer
Cc:
Subject: Grouper database schema DDL requires updates

Hi,

We are currently upgrading to 2.1.5 and as part of the upgrade we made some modifications to our grouper database schema including changing data type to nvachar and removing few indexes. This was based on some analysis we did on our SQL Server database. I am unable to get the loader running as Grouper throws an error requiring a DDL update. The first time I started gsh yesterday against the new db schema I got the same error, I ran the “gsh –registry -check” couple of times without updating the schema and gsh did work. I was even able to set up the loader from UI but when I came in today to run the loader I get the same error I previously got. I am not sure what might have corrupted the schema, has anyone encountered a similar thing before? I would appreciate your response.

Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 26

Grouper ddl object type 'Subject' has dbVersion: 0 and java version: 1

Grouper database schema DDL requires updates

(should run script manually and carefully, in sections, verify data before drop statements, backup/export important data before starting, follow change log on confluence, dont run exact same script in multiple envs - generate a new one for each env),

script file is:

/usr/local/gmt-util/ddlScripts/grouperDdl_20140425_10_19_43_200.sql

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:129)

at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:393)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:553)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:323)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:346)

at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:312)

at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:429)

at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:379)

at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:397)

at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:475)

at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:435)

at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:132)

at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:90)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:144)

at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:214)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:144)

at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)

... 2 more

Caused by: java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,