Grouper Users - Open Discussion List

[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.
>
>Thanks!
>
>-- 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
>>reason
>>in our environment. No errors are logged in the grouper_error.log file
>>and
>>gsh loads up just fine after the upgrade.
>>
>>
>>Thanks,
>>Rahul
>>
>>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
>>>sql
>>>script referenced in steps 6 and 7 of the upgrade instructions.
>>>
>>>Thanks!
>>>
>>>-- 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
>>>>dev
>>>>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
>>>>as
>>>>part of upgrade.  Is it some kind of bug in the upgrade script?
>>>>
>>>>Thanks,
>>>>Rahul
>>>>
>>>>On 8/22/14, 9:35 AM, "Shilen Patel" 
>>>><>
>>>> wrote:
>>>>
>>>>>The upgrade should have migrated the legacy attributes to the
>>>>>attribute
>>>>>framework and they should still be visible in the admin UI (not the
>>>>>new
>>>>>UI).
>>>>>
>>>>>Did you run the postGrouper2_2Upgrade.gsh script as part of the
>>>>>upgrade?
>>>>>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 there?
>>>>>
>>>>>Thanks!
>>>>>
>>>>>-- 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 on
>>>>>>our
>>>>>>DEV system. 
>>>>>>
>>>>>>We're also using Java 1.8 and Tomcat 8 and so far all seems to be
>>>>>>well
>>>>>>(after a few tweaks which from the mailing list also have to be done
>>>>>>for
>>>>>>Tomcat 7). We're in the process of setting up PSP to provision Open
>>>>>>LDAP,
>>>>>>so once we have all the upgrade done and dusted I'll post back to the
>>>>>>list with any observations and tweaks we had to make to get things to
>>>>>>work.
>>>>>>
>>>>>>I have a question though regarding the migration of old types. We had
>>>>>>a
>>>>>>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
>>>>>>grouper_attributes_legacy
>>>>>>table.
>>>>>>
>>>>>>However I'm not entirely sure what to do at this point. Do I need to
>>>>>>now
>>>>>>create a new attribute, assign to all groups and port the legacy
>>>>>>values
>>>>>>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 them
>>>>>>using Grouper Shell, but it's entirely likely that I'm missing
>>>>>>something.
>>>>>>
>>>>>>I had a look at
>>>>>>https://spaces.internet2.edu/display/Grouper/Legacy+attribute+migrati
>>>>>>o
>>>>>>n
>>>>>>which pointed me to the right place in the database so I can see I
>>>>>>haven't lost anything.
>>>>>>
>>>>>>Any pointers gratefully received!
>>>>>>
>>>>>>Cheers,
>>>>>>
>>>>>>Richard
>>>>>>
>>>>>>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.
>>>>>>
>>>>>
>>>>
>>>
>>
>