Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4


Chronological Thread 
  • From: "Crawford, Jeffrey" <>
  • To: Shilen Patel <>, "Redman, Chad" <>, "Hyzer, Chris" <>
  • Cc: " Mailing List" <>
  • Subject: Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4
  • Date: Mon, 26 Nov 2018 15:59:57 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:5jgVOBQfDJXY6bePpW3CeQhpntpsv+yvbD5Q0YIujvd0So/mwa67ZROOt8tkgFKBZ4jH8fUM07OQ7/iwHzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9xIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KpwVhTmlDkIOCI48GHPi8x/kqRboA66pxdix4LYeZyZOOZicq/Ye94RWGhPUdtLVyFZAo2ycZYBD/YPM+hboYnypVoOogexCgS3Huzj1jpIi2Xq0aEm0eksFxzN0gw6H9IJtXTZtNv5ObkIUe+vwqjIwzLDb+lL1jvl9YPGdg4uof+CXbJqb8XQyUcjHB7Cg1WStYPlJSma1+oDs2ic9epvSPmii287qw1rvzig2sMshZPTio0L11/E6Dx0zYAoLtO2T057ZMSrEJpWtyyCN4t2Xt8iQ3lzuCojxLAJo4a0czAQx5Qk3RHTcfmHc5OQ7RLsVOaePzZ4iXxkdb6nnxay60+gyuryVsms11ZKryxFksXWun8R0BzT786KQeZ+8Ee5wTuDyRrc5v1ZLU0xiKbXNoMtz7s+lpccrUjPAir7mEvog6KZeUgp/+2l5ub7brjpvpOQKY55hh38P6krlMyzHfk0PhQLUmSF5+ux1bju8E3jT7hPj/A6jrXVvZLfKMsAvKG2HQFV34M45Bu8Ezir1dAVkWcaIF9FYB6HgZbmNlLSLP39CPq/jVShnTlvyv3DILHtHI/CImbGnbj6Yblw5UBcxQ89zdBR+55ZCLcMK+/pVEDrrtzXFBo5PhS0w+n5DNV90ZsTV3qTD6GeLK/er0aE6P83LeWRfYMVvy3yJOY/6/7pkH85hUQSfa603ZsRdX+0BOxmI1+eYXrwnNgODXsKvgs5TOzsklGCViNTZ2q2X6I74TE7C5iqApvERoComLCB3SG7EYNKZm1eFFyDC2vke5iBVvsRdS6eP8pskjILWLS9V4Ms0B+uuxH1xrdoK+fZ/y8VuY7s2dRt4u3cjxAy9Th6D8SH1GGNSnl5nmEUSD8sxq9+r0J9ylCZ0adlmPFYFMBT6+lUUggmMZ7T1fZ2BM7vVQLcZtuJUkqpQs26ATEtSdI829AOY1x6G9W/lhDMwTCqD6YIl7yQGpM06Lnc0mP1J8Z80HbGyLIhg0c8TstOM22mmrBw9xLVB4HXj0WVibymeroB0y7Qpy+/yj+1vEBcXQg4aazZUHRXMlDWrND04GvOUryjT7krL10FgYS4J6dPY9utxX5GTfupcIDVY2u9rH29CROBwJuRaoGsdmkAimGVQmgVgQ0JuT6tNRI/HW3p92fVDC18GEjHYljnt/RmpXW9CEI40lfZQVdm0u//0QQcmvKbUf9XlpAJtik7piQ+VAK/1MjfFNSHvQZJfbkafNg56RFK2X+P5F81BYCpM6033g1WSA9wpU67kkwvUt8aw8E3sHMnyhZzIquE0VRHMimVxo30JqaJdjvp5B76banQ1xmey9uQ9qoVoNUA41T49EDMdAI59ml/ldxc0n+S/JLPWQgZS5vuXEEt+zB7u/fHaS00oY7YyC4kPA==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Morning Shilen,

 

Okay I reread your last message and missed that you gave me the columns and tables to check. I’ve come back with two in the grouper_pit_group_set that don’t match up with what’s in grouper_pit_stems. I guess my question is if it’s safe to remove the items in grouper_pit_group_set that don’t match. Or if that is just a signal for a larger problem that needs investigation.

 

Thanks

Jeffrey

 

From: <> on behalf of "Crawford, Jeffrey" <>
Date: Wednesday, November 21, 2018 at 1:21 PM
To: Shilen Patel <>, "Redman, Chad" <>, "Hyzer, Chris" <>
Cc: " Mailing List" <>
Subject: Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

Humm, I’m wondering if the same problem might be present in our production side. I’m not usually in the database (Other than the audit table) Is there an easy way to check for the issue? That way I can run the same query in production.

 

Thanks

Jeffrey C.

 

From: Shilen Patel <>
Date: Wednesday, November 21, 2018 at 2:52 AM
To: "Crawford, Jeffrey" <>, "Redman, Chad" <>, "Hyzer, Chris" <>
Cc: " Mailing List" <>
Subject: Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

Not necessarily.  The upgrade sql script basically has the following steps:

 

  1. Drop all views
  2. Drop all foreign constraints
  3. Upgrade the ddl
  4. Set the new ddl version in the database
  5. Add the foreign constraints
  6. Add the views

 

Your original error (ORA-02298: cannot validate (IAMUCLA_GROUPER_D.FK_PIT_GS_OWNER_STEM_ID) - parent keys not found) probably happened during step 5 above. 

 

You can now either run all the sql statements in the original sql script that didn’t run.  Or do a “gsh -registry -deep” to get a new sql file with the missing ddl.

 

But before you do that, the original issue needs to be resolved.  It seems like your point in time data is corrupt.  If this is a dev environment and you don’t necessarily care about it, then you can truncate those tables.  Otherwise, you’ll need to see why you have rows in grouper_pit_group_set with an owner_stem_id that’s not in grouper_pit_stems.  

 

Alternatively, you could add the views back (from the sql script) which may be enough for you to start gsh at least.  Then you can also run the pit sync script.

 

Thanks!

 

- Shilen

 

 

From: "Crawford, Jeffrey" <>
Date: Tuesday, November 20, 2018 at 5:44 PM
To: "Redman, Chad" <>, "Hyzer, Chris" <>, " Mailing List" <>, Shilen Patel <>
Subject: Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

But wouldn't running gsh -registry -check correct that?


From: Shilen Patel <>
Sent: Tuesday, November 20, 2018 2:18:47 PM
To: Redman, Chad; Crawford, Jeffrey; Hyzer, Chris; Mailing List
Subject: Re: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

I'm guessing since the upgrade failed (the first error that was given), the views weren't added back (which usually happens at the end of the upgrade).  So all these other errors may be a side effect. 

 

- Shilen 

 

 

 

Sent from my Verizon, Samsung Galaxy smartphone

 

 

-------- Original message --------

From: "Redman, Chad" <>

Date: 11/20/18 5:13 PM (GMT-05:00)

To: "Crawford, Jeffrey" <>, "Hyzer, Chris" <>, " Mailing List" <>

Subject: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

Syntax was almost right. Try this without the "as".

 

select ms.*, m.* from grouper_memberships_all_v ms, grouper_members m

  where ms.owner_attr_def_id   = '80075426c19b41758c65e6a6e74c6a9a'

    and ms.member_id  = '496458b5c1ca4757ab70541f15d3ec34'

    and ms.member_id = m.id  and ms.immediate_mship_enabled = 'T';

 

 

From: [mailto:] On Behalf Of Redman, Chad
Sent: Tuesday, November 20, 2018 5:09 PM
To: Crawford, Jeffrey <>; Hyzer, Chris <>; Mailing List <>
Subject: [grouper-users] RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

If it helps, this is the query the error translates to. Does this work from SQL? Logged in as iamucla_grouper_d?

 

/* edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO#findAllByGroupOwnerAndMember */

 

select ms.*, m.* from grouper_memberships_all_v as ms, grouper_members as m

  where ms.owner_attr_def_id   = '80075426c19b41758c65e6a6e74c6a9a'

    and ms.member_id  = '496458b5c1ca4757ab70541f15d3ec34'

    and ms.member_id = m.id  and ms.immediate_mship_enabled = 'T';

 

 

From: [] On Behalf Of Crawford, Jeffrey
Sent: Tuesday, November 20, 2018 2:41 PM
To: Hyzer, Chris <>; Mailing List <>
Subject: [grouper-users] Re: Trouble upgrading Grouper DB from 2.1 to 2.4

 

Maybe it’s just easier to post the errors I got:

 

 ./bin/gsh.sh

Using GROUPER_HOME: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF

Using GROUPER_CONF: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/classes

Using JAVA: /usr/java/jdk1.8.0_191-amd64/bin/java

using MEMORY: 64m-750m

log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.DailyRollingFileAppender.

Grouper starting up: version: 2.4.0, build date: 2018/08/23 07:48:38, env: <no label configured>

grouperPatchStatus read from: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/grouperPatchStatus.properties

api patches installed:        0, 1, 2, 3, 4, 5, 6, 7, 8, 9

ui patches installed:         0, 1, 2, 3, 4

grouper.properties read from: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/classes/grouper.properties

Grouper current directory is: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF

log4j.properties read from:   /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/classes/log4j.properties

Grouper is logging to file:   /opt/grouper-2.4.0/apache-tomcat-8.5.12/logs/grouperUi/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties

grouper.hibernate.properties: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/classes/grouper.hibernate.properties

grouper.hibernate.properties:

subject.properties read from: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/classes/subject.properties

sources configured in:        subject.properties

subject.properties ldap source id:   ldap: personLdap

subject.properties groupersource id: g:gsa

subject.properties groupersource id: grouperEntities

Grouper warning: cannot find group from config: deprovisioning admin group can deprovision from all groups/objects in Grouper even if the user is not a Grouper overall SysAdmin: etc:deprovisioning:deprovisioningAdmins

Grouper error: etc:deprovisioning:deprovisioningAdmins, edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (741741d0): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (45a1d057),

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select ms, m from MembershipEntry as ms, Member as m where       ms.ownerGroupId   = :owner            and  ms.memberUuid  = :member           and ms.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'8a101d8652034ff886576fd141f0cb70'Bind var[1]: 'Param (class java.lang.String): 'member'->'496458b5c1ca4757ab70541f15d3ec34', ,

Problem in HibernateSession: HibernateSession (1d98daa0): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (45a1d057),

Problem saving group: etc:deprovisioning:deprovisioningAdmins, thread: 2d6e8792

       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:589)

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

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:407)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:458)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByGroupOwnerAndMember(Hib3MembershipDAO.java:1805)

       at edu.internet2.middleware.grouper.privs.GrouperNonDbAccessAdapter.getPrivs(GrouperNonDbAccessAdapter.java:248)

       at edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:139)

       at edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:127)

       at edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:109)

       at edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:101)

       at edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:160)

       at edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:345)

       at edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:150)

       at edu.internet2.middleware.grouper.Group.hasRead(Group.java:4525)

       at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:642)

       at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)

       at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:444)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

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

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

       at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:435)

       at edu.internet2.middleware.grouper.Group.saveGroup(Group.java:366)

       at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroup(GrouperCheckConfig.java:221)

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

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

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

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

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

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)

       at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)

       at org.hibernate.loader.Loader.doQuery(Loader.java:919)

       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)

       at org.hibernate.loader.Loader.doList(Loader.java:2617)

       at org.hibernate.loader.Loader.doList(Loader.java:2600)

       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)

       at org.hibernate.loader.Loader.list(Loader.java:2424)

       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)

       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)

       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)

       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)

       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)

       at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:380)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:417)

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

       ... 28 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)

       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)

       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)

       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:239)

       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1246)

       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500)

       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717)

       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4401)

       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4482)

       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6272)

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)

       ... 45 more

 

Couldnt startup grouper: Problem in HibernateSession: HibernateSession (7ce29a2d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (243bf087),

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select ms, m from MembershipEntry as ms, Member as m where       ms.ownerAttrDefId   = :owner            and  ms.memberUuid  = :member           and ms.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'80075426c19b41758c65e6a6e74c6a9a'Bind var[1]: 'Param (class java.lang.String): 'member'->'496458b5c1ca4757ab70541f15d3ec34', ,

Problem in HibernateSession: HibernateSession (634ca3e7): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (243bf087)

edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (7ce29a2d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (243bf087),

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select ms, m from MembershipEntry as ms, Member as m where       ms.ownerAttrDefId   = :owner            and  ms.memberUuid  = :member           and ms.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'80075426c19b41758c65e6a6e74c6a9a'Bind var[1]: 'Param (class java.lang.String): 'member'->'496458b5c1ca4757ab70541f15d3ec34', ,

Problem in HibernateSession: HibernateSession (634ca3e7): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (243bf087)

       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:589)

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

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:407)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:458)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByAttrDefOwnerAndMember(Hib3MembershipDAO.java:2542)

       at edu.internet2.middleware.grouper.privs.GrouperNonDbAttrDefAdapter.getPrivs(GrouperNonDbAttrDefAdapter.java:194)

       at edu.internet2.middleware.grouper.privs.AttributeDefWrapper.getPrivileges(AttributeDefWrapper.java:122)

       at edu.internet2.middleware.grouper.privs.GrouperAllAttrDefResolver.getPrivileges(GrouperAllAttrDefResolver.java:99)

       at edu.internet2.middleware.grouper.privs.GrouperSystemAttrDefResolver.getPrivileges(GrouperSystemAttrDefResolver.java:101)

       at edu.internet2.middleware.grouper.privs.CachingAttrDefResolver.getPrivileges(CachingAttrDefResolver.java:133)

       at edu.internet2.middleware.grouper.privs.CachingAttrDefResolver.hasPrivilege(CachingAttrDefResolver.java:201)

       at edu.internet2.middleware.grouper.privs.WheelAttrDefResolver.hasPrivilege(WheelAttrDefResolver.java:341)

       at edu.internet2.middleware.grouper.privs.ValidatingAttrDefResolver.hasPrivilege(ValidatingAttrDefResolver.java:127)

       at edu.internet2.middleware.grouper.attr.AttributeDefPrivilegeDelegate.hasAttrAdmin(AttributeDefPrivilegeDelegate.java:87)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave$1$1.callback(AttributeDefSave.java:738)

       at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave$1.callback(AttributeDefSave.java:495)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

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

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave.save(AttributeDefSave.java:488)

       at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkAttributes(GrouperCheckConfig.java:2080)

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

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

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

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

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)

       at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)

       at org.hibernate.loader.Loader.doQuery(Loader.java:919)

       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)

       at org.hibernate.loader.Loader.doList(Loader.java:2617)

       at org.hibernate.loader.Loader.doList(Loader.java:2600)

       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)

       at org.hibernate.loader.Loader.list(Loader.java:2424)

       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)

       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)

       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)

       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)

       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)

       at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:380)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:417)

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

       ... 26 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)

       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)

       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)

       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:239)

       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1246)

       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500)

       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717)

       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4401)

       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4482)

       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6272)

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)

       ... 43 more

Exception in thread "main" edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (7ce29a2d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (243bf087),

Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select ms, m from MembershipEntry as ms, Member as m where       ms.ownerAttrDefId   = :owner            and  ms.memberUuid  = :member           and ms.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'80075426c19b41758c65e6a6e74c6a9a'Bind var[1]: 'Param (class java.lang.String): 'member'->'496458b5c1ca4757ab70541f15d3ec34', ,

Problem in HibernateSession: HibernateSession (634ca3e7): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (243bf087)

       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:589)

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

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:407)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:458)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByAttrDefOwnerAndMember(Hib3MembershipDAO.java:2542)

       at edu.internet2.middleware.grouper.privs.GrouperNonDbAttrDefAdapter.getPrivs(GrouperNonDbAttrDefAdapter.java:194)

       at edu.internet2.middleware.grouper.privs.AttributeDefWrapper.getPrivileges(AttributeDefWrapper.java:122)

       at edu.internet2.middleware.grouper.privs.GrouperAllAttrDefResolver.getPrivileges(GrouperAllAttrDefResolver.java:99)

       at edu.internet2.middleware.grouper.privs.GrouperSystemAttrDefResolver.getPrivileges(GrouperSystemAttrDefResolver.java:101)

       at edu.internet2.middleware.grouper.privs.CachingAttrDefResolver.getPrivileges(CachingAttrDefResolver.java:133)

       at edu.internet2.middleware.grouper.privs.CachingAttrDefResolver.hasPrivilege(CachingAttrDefResolver.java:201)

       at edu.internet2.middleware.grouper.privs.WheelAttrDefResolver.hasPrivilege(WheelAttrDefResolver.java:341)

       at edu.internet2.middleware.grouper.privs.ValidatingAttrDefResolver.hasPrivilege(ValidatingAttrDefResolver.java:127)

       at edu.internet2.middleware.grouper.attr.AttributeDefPrivilegeDelegate.hasAttrAdmin(AttributeDefPrivilegeDelegate.java:87)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave$1$1.callback(AttributeDefSave.java:738)

       at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave$1.callback(AttributeDefSave.java:495)

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)

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

       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)

       at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)

       at edu.internet2.middleware.grouper.attr.AttributeDefSave.save(AttributeDefSave.java:488)

       at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkAttributes(GrouperCheckConfig.java:2080)

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

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

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

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

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)

       at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)

       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)

       at org.hibernate.loader.Loader.doQuery(Loader.java:919)

       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)

       at org.hibernate.loader.Loader.doList(Loader.java:2617)

       at org.hibernate.loader.Loader.doList(Loader.java:2600)

       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)

       at org.hibernate.loader.Loader.list(Loader.java:2424)

       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)

       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)

       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)

       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)

       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)

       at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:380)

       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:417)

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

       ... 26 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)

       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)

       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)

       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:239)

       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1246)

       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1500)

       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1717)

       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4401)

       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4482)

       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6272)

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)

       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)

       ... 43 more

 

 

From: "Hyzer, Chris" <>
Date: Tuesday, November 20, 2018 at 11:09 AM
To: "Crawford, Jeffrey" <>, "" <>
Subject: RE: Trouble upgrading Grouper DB from 2.1 to 2.4

 

When you say “got some errors”, do your database objects have errors?

 

 

From: <> On Behalf Of Crawford, Jeffrey
Sent: Tuesday, November 20, 2018 1:56 PM
To: Mailing List <>
Subject: [grouper-users] Trouble upgrading Grouper DB from 2.1 to 2.4

 

I’ve run the gsh.sh -registry -check, then run the SQL file, got some errors but the next time I run gsh.sh -registry -check It says the DB is fine, however trying to start the gsh prompt yealds errors about views not existing and not being able to create the “etc:deprovisioning:deprovisioningAdmins

“ group.

 

This was the error I got when running the script:

 

Error running script: /opt/grouper-2.4.0/grouper.ui-2.4.0/dist/grouper/WEB-INF/ddlScripts/grouperDdl_20181120_10_28_37_190.sql, java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (IAMUCLA_GROUPER_D.FK_PIT_GS_OWNER_STEM_ID) - parent keys not found

 

       at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:691)

       at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:1029)

       at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:858)

       at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:142)

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

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

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

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

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

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

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

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (IAMUCLA_GROUPER_D.FK_PIT_GS_OWNER_STEM_ID) - parent keys not found

 

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)

       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)

       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)

       at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:199)

       at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1418)

       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1764)

       at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2821)

       at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2747)

       at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:1203)

       at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:786)

       at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:756)

       at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1058)

       at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:988)

       at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:672)

       ... 10 more

 

 

Any Ideas

 

Thanks

Jeffrey Crawford




Archive powered by MHonArc 2.6.19.

Top of Page