Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

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