Grouper Users - Open Discussion List

[Chris Hyzer <>]

Can you do the DDL from 1.5.1 to 2.1.3, or do you need to go to 1.6.3 and export/import?  I would recommend going to 2.1.3… and not export/import.  Anyways, can you send me the /opt/grouper/api/logs/grouper_error.log  ?

 

Thanks,

Chris

 

 

From: Kevin O'Rourke [mailto:]
Sent: Friday, April 19, 2013 2:02 PM
To: Chris Hyzer
Cc: ; Identity Management
Subject: Re: [grouper-users] problem/question with upgrade from 1.5.1 to 2.1.3

 

Sorry I wasn't clear ....
#1. I am upgrading from 1.5.1 to 1.6.3 so that I can export from 1.6.3 and import into 2.1.3

 

#2. There doesn't seem to be a property with that name in any of the properties files. There is even one with the string fragment 'nest':

# pwd

/var/home/kor/grouper/grouper.apiBinary-1.6.3/conf
# grep -i nested *
# grep -i nest *

#3. Have done, but I'm not really sure which properties might influence this

 

#4. I might have learned the hard way ...

 

On Fri, Apr 19, 2013 at 11:37 AM, Chris Hyzer <> wrote:

First of all, you shouldn’t export and import the data, but rather just upgrade the DDL.   ./gsh.sh -registry -check      is the call to upgrade the DDL

 

2^nd, what is this setting set to?   In the grouper.properties

 

ddlutils.use.nestedTransactions

 

It needs to be “true”

 

3^rd, maybe compare your grouper.properties with the grouper.example.properties and look for other differencs that could be the problem.

 

4^th, yes, it is good you are doing this in a test env J

 

Thanks,

Chris

 

 

From: [mailto:] On Behalf Of Kevin O'Rourke
Sent: Friday, April 19, 2013 11:11 AM
To:
Cc: Identity Management
Subject: [grouper-users] problem/question with upgrade from 1.5.1 to 2.1.3

 

I have a dev instance of 2.1.3 running. I'd like to migrate data from a 1.5.1 test instance (copied from production).

I understand that I need to upgrade the api from 1.5.1 to 1.6.3 in order to export the data in a format that can be imported into 2.1.3.

I've configured 1.6.3 to the best of my (admittedly limited) ability. But cannot get the 'export the registry' step to complete. Any ideas would be appreciated. Here's the output:

 ./gsh.sh -registry -check
Using GROUPER_HOME: /opt/grouper/api
Using GROUPER_CONF: /opt/grouper/api/conf
Using JAVA: /opt/java6/bin/java
using MEMORY: 64m-512m
Grouper starting up: version: 1.6.3, build date: 2011/01/03 01:44:08, env: test
grouper.properties read from: /etc/opt/grouper/api/conf/grouper.properties
Grouper current directory is: /opt/grouper/api/bin
log4j.properties read from:   /etc/opt/grouper/api/conf/log4j.properties
Grouper is logging to file:   /opt/grouper/api/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
grouper.hibernate.properties: /etc/opt/grouper/api/conf/grouper.hibernate.properties
grouper.hibernate.properties: grouper@jdbc:oracle:thin:@//dmp1-scan.oit.umn.edu:1521/hoteltst.oit
sources.xml read from:        /etc/opt/grouper/api/conf/sources.xml
sources.xml jndi source id:   umnldap: cn=Grouper,ou=Application Services,o=University of Minnesota,c=US@ldaps://lde-d.tc.umn.edu
sources.xml groupersource id: g:gsa
(note, might need to type in your response multiple times (Java stdin is flaky))
(note, you can whitelist or blacklist db urls and users in the grouper.properties)
Are you sure you want to schemaexport all tables (dropThenCreate=F,writeAndRunScript=F) in db user 'grouper', db url 'jdbc:oracle:thin:@//dmp1-scan.oit.umn.edu:1521/hoteltst.oit'? (y|n):
y
Continuing...
Grouper ddl object type 'Grouper' has dbVersion: 22 and java version: 23
java.lang.RuntimeException: Problem rolling back savepoint
        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:393)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:510)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.findDbMetadataBean(GrouperDdlUtils.java:2371)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:447)
        at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:188)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:128)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: java.sql.SQLException: ORA-01086: savepoint 'ORACLE_SVPT_2' never established in this session or is invalid

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1126)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1909)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1878)
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4097)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:829)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
        at $Proxy0.rollback(Unknown Source)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:391)
        ... 11 more
Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:198)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:128)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:188)
        ... 2 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Problem rolling back savepoint
        at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:178)
        ... 7 more
Caused by: java.lang.RuntimeException: Problem rolling back savepoint
        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:393)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:510)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.findDbMetadataBean(GrouperDdlUtils.java:2371)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:447)
        at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        ... 7 more
Caused by: java.sql.SQLException: ORA-01086: savepoint 'ORACLE_SVPT_2' never established in this session or is invalid

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1126)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1909)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1878)
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4097)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:829)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
        at $Proxy0.rollback(Unknown Source)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:391)
        ... 11 more