Grouper Users - Open Discussion List

["Kevin O'Rourke" <>]

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