Grouper Users - Open Discussion List

["Black, Carey M." <>]

Andre,

 

I would generally expect an upgrade from 2.4.0 to 2.5.38 to “just work”.
                However: https://spaces.at.internet2.edu/display/Grouper/v2.5+Release+Notes#v2.5ReleaseNotes-Upgradefromv2.4tov2.5
                                You may need to read/do the “Database upgrade.” Section. Maybe….

Does the JDBC user have full/all privileges to all objects in the grouper DB? ( Maybe something is a missing/wrong there?)
   Can you confirm that the JDBC user is the DB owner and the owner of the grouper_groups_v view object?

And I am not a “oracle DB user” ( in a while )  So this may be off base on this one…( I did not go find docs to check… )
Is the JDBC connection string correct?
                “jdbc:oracle:thin:@groupdev.dev.idm.aws.ucsc.edu:1521:groupdev”
                Should there be a user name before the “@” in that string?

 

-- 

Carey Matthew

 

From: <> on behalf of Andre Daniels <>
Reply-To: "" <>
Date: Tuesday, January 12, 2021 at 12:23 AM
To: Grouper-Users <>
Subject: [grouper-users] Problems with 2.5 level 1 database upgrade

 

Hello,

 

I am trying to work through the level 1 manually guide and I get errors when the ddl to update the db runs. Here is my stack trace:

 

tomee;console;;;Grouper ddl object type 'Grouper' has dbVersion: 31 (2.4.0) and java version: 35 (2.5.38)
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,223: [localhost-startStop-1] WARN  GrouperDdlEngine.updateDdlIfNeededWithStaticSql(752) -  - Grouper ddl object type 'Subject' has dbVersion: 1 (1.4.0) and java version: 1 (1.4.0)
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,284: [localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - connecting to jdbc:oracle:thin:@groupdev.dev.idm.aws.ucsc.edu:1521:groupdev
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,285: [localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - Loading oracle.jdbc.driver.OracleDriver using system loader.
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,852: [localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - Executing resource: /opt/grouper/grouperWebapp/WEB-INF/ddlScripts/grouperDdl_20210112_05_08_47_225.sql
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,860: [localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:    DROP VIEW grouper_groups_v
grouper-ui;grouper_error.log;;;2021-01-12 05:08:47,934: [localhost-startStop-1] ERROR GrouperAntProject.log(123) -  - Failed to execute:    DROP VIEW grouper_groups_v
tomee;console;;;Couldnt startup grouper: Error running script

 

...tomee;console;;;        at java.lang.Thread.run(Thread.java:748)

tomee;console;;;Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
tomee;console;;;
tomee;console;;;        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:691)
tomee;console;;;        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.runScriptFileIfShouldReturnString(GrouperDdlUtils.java:878)
tomee;console;;;        ... 22 more
tomee;console;;;Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
tomee;console;;;

-- 

 

I just chose the latest release 2.5.39 for my image. Do I maybe just need to go back a few versions to get the 2.4 to 2.5 database upgrade?

 

Thanks,

Andre

 

 

Andre Daniels 

Sr. Developer/Security Analyst

University of California Santa Cruz

(831) 459-1980