Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Update Grouper DB Schema

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Update Grouper DB Schema

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Akki Kumar <>
  • Cc: "" <>, "Stephen A Sazama" <>, "Black, Carey M." <>
  • Subject: [grouper-users] RE: Update Grouper DB Schema
  • Date: Fri, 16 Jun 2017 14:43:26 +0000
  • Accept-language: en-US
  • Authentication-results:; dkim=none (message not signed) header.d=none;; dmarc=none action=none;
  • Ironport-phdr: 9a23:y/Ot3hZszqJybYBHkHSUgsL/LSx+4OfEezUN459isYplN5qZrsi/bnLW6fgltlLVR4KTs6sC0LuJ9f+xEjNQqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjSwbLdwIRmsrwjcssYajIlhJ60s1hbHv3xEdvhMy2h1P1yThRH85smx/J5n7Stdvu8q+tBDX6vnYak2VKRUAzs6PW874s3rrgTDQhCU5nQASGUWkwFHDBbD4RrnQ5r+qCr6tu562CmHIc37SK0/VDq+46t3ThLjlTwKPCAl/m7JlsNwjbpboBO/qBx5347Ue5yeOP5ncq/AYd8WWW9NU8BMXCJDH4y8dZMCAeofM+hFs4nzqVgArRW8CgmtGOzgxSRFiWXq0aEmyektDR3K0Q4mEtkTsHrUttL1NKIKXOy7zqfJzTTCYO1M2Tvl9YPFbBAhoeuNXbJrf8ba1E4iFwbZgVWQqY3kPi2a1v4Wvmia9OpvSfiji3M/qw5vpDivwN0ghZfUiYII013J8zhyzogyJd29UkF7YNikHYNftyGdMIt2TcciTH9ytCkmzb0GvIa3fCkMyJQ72RHfcfqHfJaU4h79TuqePyp3hG9jdbmihBiy6VCtxvPhWsS1ylpHoDRJnsPRun0OyxDf8MiKR/Vl8ku81zuDyxrf5+VZLUwui6bXNposzqQtmpcRsEnOGDL9ll/sg6+MbEok//Cl6+T5bbXioZ+RL5d6hx35PKgylMGzGPk1PQoQU2SC/uSzz6Ps8Vf+QLVXkv05ia7ZsI3cJcsGvKK5GxVV0oE/6xmhEzimzNUYnX4BLF5ffxKHkpTpO1XJIPD/DvezmUijkDBux/zeP73hBIvCLmTbnbv/YLpw6lRQxQQtwdxF+p5ZCa0NLOjzV0L/rNDYCwU2Mw2ww+bpEtV90YYeVHqKAqCFMKPTsV6J6fw1I+SXZY8VoyryJ+I45/72k3A5n1kdcbO30pQKdXC0Bu5mLFmBYXrwntcBFn8HvgUkTOztlV2CSSBcZ2yrU6Ih/TE0FpimDZzYS4CpgbyBxzu7HoZIamxcC1CMF2voeJueW/cKdi2SPtFtniYaWre8Vo9ynS2p4Sb5yLsvDffR8zdQ4Zvm3cp04eLKiBwp6T1zCd/Fiz6lQGR9n2dOTDgzivNRu0t4nx2jwLp1mbgQPtxJ5ugDGlM/Pp7N3eFgI9HpUUTcZtqPThCrTsjwUmJ5dc4439JbOxU1IN6llB2WmnPyW7I=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

If you download 2.3, and put your config files in there and run: gsh -registry -check


From: Akki Kumar [mailto:]
Sent: Friday, June 16, 2017 10:13 AM
To: Hyzer, Chris <>
Cc: ; Stephen A Sazama <>; Black, Carey M. <>
Subject: Re: Update Grouper DB Schema


Hi Chris,


I tried to upgrade DB schema (using UI option) and it threw below error (attached to link). 




  • Is there a way to only upgrade DB schema and skip all patches? (API, UI & WS are upgraded & patches are already applied)
  • Does DB schema update check for the SQL Script? If so, where would I find 2.3.0 SQL Script?
  • In order to upgrade DB schema, do I need to run GSH from Grouper 2.2.2 API? (I tried running GSH from 2.3.0 API and it failed because 2.2.2 DB Schema is different than 2.3.0 Schema)


@Carey, Grouper API, UI & WS are already updated and DB Schema update is the only part of the puzzle that needs to be solved. Truly appreciate your time for the suggestions, Carey! :)  Also, just a heads up, make sure you give around one month of time for the upgrade. (If, each component - API, UI & WS are deployed on different servers)





On Thu, Jun 15, 2017 at 4:36 PM, Black, Carey M. <> wrote:



I think you also need to upgrade all of the components.


The first one will change the DB.

                Which may (or could) cause older components/parts some “problems” until they are upgraded.

                I don’t _know_ that you will have issues, but I would find it hard to believe that everything would work “as expected” in a mixed version grouper universe. ( but maybe)

                I think it all depends on the details of the DB structure changes and the expectations of each grouper component.



I think the “best” (better safe than sorry approach) process would be to:

                Down everything. (All UI’s, WS, PSP’s, loaders, etc..)

                                Take your backups. (ß always a good idea. J )

                Upgrade the “most important things” (a API, UI and Loader, maybe WS if you require that too) then bring them up.

                Then upgrade anything else (load balanced redundant servers?) and bring those back up too.


This might be of some help too:



                And if you have not found this page, about patching, it is a good idea (IMHO too)



However, I have yet to do an “upgrade” with this app. ( So “your mileage may vary”. )

Good luck.



Carey Matthew


From: [mailto:] On Behalf Of Hyzer, Chris
Sent: Thursday, June 15, 2017 3:18 PM
To: Akki Kumar <>
Cc: ; Stephen A Sazama <>
Subject: [grouper-users] RE: Update Grouper DB Schema


Whatever system you are setup in… J


If you have a webapp pointing to the schema, select ui or ws (whichever it is).  If you have an api pointing to it, pick api…





From: Akki Kumar []
Sent: Thursday, June 15, 2017 3:16 PM
To: Hyzer, Chris <>
Cc: ; Stephen A Sazama <>
Subject: Re: Update Grouper DB Schema


Hi Chris,


Thank you for the prompt reply. When I select "update", the only option there are apiuiwspspng, or psp. No option for the DB schema update, which option should I select? (I tried api and that didn't update the schema)


Enter in a Grouper temp directory to download tarballs (note: better if no spaces or special chars) [/grouperInstaller_DB/tarballs]:

What do you want to upgrade?  api, ui, ws, pspng, or psp? [API]: 


Thank you,



On Thu, Jun 15, 2017 at 3:02 PM, Hyzer, Chris <> wrote:

In the installer, instead of picking “install”, pick “update”.  Does it work?  It should update the schema.  Send me the output, logs and SQL script so I can take a look





From: Akki Kumar [mailto:]
Sent: Thursday, June 15, 2017 2:36 PM
To: Hyzer, Chris <>
Cc: ; Stephen A Sazama <>
Subject: Update Grouper DB Schema


Hi Chris,


I am upgrading Grouper DB Schema from v2.2.2 to v2.3.0. I tried running the Grouper 2.3.0 installer, but it ends up initializing DB completely instead of updating schema. Is there a way to update just Grouper schema (keeping data intact) from v2.2.2 to v2.3.0?


Thank you,






Archive powered by MHonArc 2.6.19.

Top of Page