Grouper Users - Open Discussion List

[Shilen Patel <>]

What columns do you have in your grouper_fields and grouper_fields_legacy tables right now?  Do you have a backup of your database before doing any of the upgrade steps that you can use to revert back to?

Thanks!

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 12:32 PM
To: "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

I just used  -registry –check every time.  Once script terminated because it couldn’t write to /tmp.  So I cleaned up ddl and other log files and regenerated script.   Unfortunately I just have the last script that I ran.

Thanks,

Rahul

From: Shilen Patel <>
Date: Wednesday, November 26, 2014 at 12:14 PM
To: Rahul Doshi <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

Did you run the upgrader or –registry –check before this?  In the attached sql file, I don’t see the upgrade having happened there.  That file suggests the db was already at 2.2.1.

Thanks!

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 12:05 PM
To: Shilen Patel <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

I generated the script running –registry –check –deep.  

Thanks,

Rahul

From: Shilen Patel <>
Date: Wednesday, November 26, 2014 at 11:36 AM
To: Rahul Doshi <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

How did you do the upgrade?  The new upgrader or manually running –registry –check?  Either way, do you mind sending me the sql file?

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 11:02 AM
To: "" <>
Subject: [grouper-users] grouper post upgrade script error

Hello,

When I ran  ./bin/gsh.sh misc/postGrouper2_2Upgrade.gsh after upgrading grouper from 2.1.4 to 2.2.1 I received error below. Is it a bug in the post upgrade script?

Thanks,

Rahul

Searching for legacy attributes

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``new MigrateLegacyAttributes().saveUpdates(true).fullMigration();'' : Method Invocation fullMigration

// See error log for full stacktrace

// caused by: java.lang.RuntimeException:

// Problem with query in listSelect: select grouptype_uuid, name from grouper_fields_legacy where type='attribute',

Problem in HibernateSession: HibernateSession (72849cc9): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (101e0247)

// caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:

// Unknown column 'grouptype_uuid' in 'field list'