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
2nd, what is this setting set to? In the grouper.properties
ddlutils.use.nestedTransactions
It needs to be “true”
3rd, maybe compare your grouper.properties with the grouper.example.properties and look for other differencs that could be the problem.
4th, 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
