Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Grouper 2.2 and legacy attribute migration

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Grouper 2.2 and legacy attribute migration

Chronological Thread 
  • From: Rahul Doshi <>
  • To: Shilen Patel <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] Grouper 2.2 and legacy attribute migration
  • Date: Fri, 22 Aug 2014 18:11:42 +0000
  • Accept-language: en-US

Sorry email accidentally got sent before I could finish typing. Here is
the output of step 6 ./gsh -registry -check

Are you sure you want to schemaexport all tables
(dropThenCreate=F,writeAndRunScript=F) in db user 'grouper', db url
'jdbc:mysql://xxxxxxxx/grouper'? (y|n):
NOTE: database table/object structure (ddl) is up to date

I reran the sql file generated earlier and got error below. I did a grep
of grouper_attributes_v on the SQL file and saw a drop view of
grouper_attributes_v but no create. Could that be causing of the other
views not getting created?

Error running script:
8_158.sql, com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
table 'grouper_attributes_v'
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.lang.reflect.Method.invoke(
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
table 'grouper_attributes_v'
at com.mysql.jdbc.SQLError.createSQLException(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.sendCommand(
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
at com.mysql.jdbc.Connection.execSQL(
at com.mysql.jdbc.Connection.execSQL(
at com.mysql.jdbc.Statement.execute(
... 10 more


On 8/22/14, 2:06 PM, "Rahul Doshi"

>Ok, so I tried step 6 again and got
>On 8/22/14, 2:01 PM, "Shilen Patel"
> wrote:
>>OK if one of the sql statements in the file failed during step 7, that
>>should have been printed out. And if one statement fails, it does not
>>process anything after that, so it is also possible that there was a
>>failure before the create views. Do you happen to still have the output
>>of step 7? Did it include the line "Script was executed successfully"?
>>You could try rerunning steps 6 and 7 again.
>>-- Shilen
>>On 8/22/14 1:51 PM, "Rahul Doshi"
>> wrote:
>>>I just did a grep on the sql file. Drop and create view statements are
>>>there in the sql file. So it looks like create view fails for some
>>>in our environment. No errors are logged in the grouper_error.log file
>>>gsh loads up just fine after the upgrade.
>>>On 8/22/14, 1:41 PM, "Shilen Patel"
>>> wrote:
>>>>Did the sql script include the statements to create the views? The sql
>>>>script should have started off by dropping all the views, then dropping
>>>>constraints, then actually doing that part of the upgrade, then adding
>>>>back the constraints, and finally adding back the views. This is the
>>>>script referenced in steps 6 and 7 of the upgrade instructions.
>>>>-- Shilen
>>>>On 8/22/14 1:27 PM, "Rahul Doshi"
>>>> wrote:
>>>>>Hi Shilen,
>>>>>When I upgraded our production database running grouper 2.1.4 in the
>>>>>environment to grouper 2.2.0 even thought upgrade script completed
>>>>>successfully none of the views starting with grouper_attr_asn_* and
>>>>>grouper_aval_asn_* got created. I also ran postGrouper2_2Upgrade.gsh
>>>>>part of upgrade. Is it some kind of bug in the upgrade script?
>>>>>On 8/22/14, 9:35 AM, "Shilen Patel"
>>>>> wrote:
>>>>>>The upgrade should have migrated the legacy attributes to the
>>>>>>framework and they should still be visible in the admin UI (not the
>>>>>>Did you run the postGrouper2_2Upgrade.gsh script as part of the
>>>>>>If so, do you have the output from that? If you query the view
>>>>>>GROUPER_AVAL_ASN_ASN_GROUP_V, do you see your legacy attributes
>>>>>>-- Shilen
>>>>>>On 8/22/14 8:53 AM, "GOOD Richard"
>>>>>> wrote:
>>>>>>>Hi all,
>>>>>>>we've just started the process of upgrading our old Grouper 1.5.3
>>>>>>>instances to Grouper 2.2.
>>>>>>>Have managed (I think) to do an upgrade straight from 1.5.3 to 2.2
>>>>>>>DEV system.
>>>>>>>We're also using Java 1.8 and Tomcat 8 and so far all seems to be
>>>>>>>(after a few tweaks which from the mailing list also have to be done
>>>>>>>Tomcat 7). We're in the process of setting up PSP to provision Open
>>>>>>>so once we have all the upgrade done and dusted I'll post back to
>>>>>>>list with any observations and tweaks we had to make to get things
>>>>>>>I have a question though regarding the migration of old types. We
>>>>>>>custom group type which we stored a gid value in, and a grouper hook
>>>>>>>which adds the custom group and then sets the gid value.
>>>>>>>Post upgrade, I can see all the values in the
>>>>>>>However I'm not entirely sure what to do at this point. Do I need to
>>>>>>>create a new attribute, assign to all groups and port the legacy
>>>>>>>over? Or should I be able to query the legacy attributes still? They
>>>>>>>don't show up in the UI, and I don't appear to be able to get at
>>>>>>>using Grouper Shell, but it's entirely likely that I'm missing
>>>>>>>I had a look at
>>>>>>>which pointed me to the right place in the database so I can see I
>>>>>>>haven't lost anything.
>>>>>>>Any pointers gratefully received!
>>>>>>>Richard Good
>>>>>>>Senior Analyst/Team Leader
>>>>>>>IS Applications Development ISG team
>>>>>>>Tel: (0131) 650 6628
>>>>>>>The University of Edinburgh is a charitable body, registered in
>>>>>>>Scotland, with registration number SC005336.

Archive powered by MHonArc 2.6.16.

Top of Page