Grouper Users - Open Discussion List

[Andre Daniels <>]

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