grouper import xml fails on attribute owner stem id

From: Jeffrey Crawford
Sent: Thursday, March 12, 2015 1:26 PM
To: Chris Hyzer
Subject: Re: [grouper-users] Re: Switching databases, getting error on import

Just checking in, did you get the report from March 5th?
Thanks

Jeffrey

Both pilots and IT professionals require training and currency before charging into clouds!
---------------------------------------

On Sat, Mar 7, 2015 at 9:55 AM, Jeffrey Crawford wrote:
I attached it as a zip file, an you just verify you got it?

Jeffrey E. Crawford
ITS Application Administrator (IdM)

Both pilots and IT professionals require training and currency before charging into clouds!
---------------------------------------

On Sat, Mar 7, 2015 at 9:31 AM, Chris Hyzer wrote:
Great thanks
-------- Original message --------
From: Jeffrey Crawford
Date:03/05/2015 4:01 PM (GMT-05:00)
To: Chris Hyzer
Subject: Re: [grouper-users] Re: Switching databases, getting error on import

Hi Chris,
I'm going to go ahead and send this to only you for now, let me know if you would like me to post it in the mailing list too.

Jeffrey

Both pilots and IT professionals require training and currency before charging into clouds!
---------------------------------------

On Thu, Mar 5, 2015 at 12:31 PM, Jeffrey Crawford wrote:
I have the report and it's a bit long, do you want me to send it to only you, or should I attach it in the mailing list?

Jeffrey

Both pilots and IT professionals require training and currency before charging into clouds!
---------------------------------------

On Mon, Mar 2, 2015 at 11:10 AM, Chris Hyzer wrote:
Can you send the entire log file from the import?

Thanks,
Chris

From: grouper-users-request grouper-users-request On Behalf Of Jeffrey Crawford
Sent: Monday, March 02, 2015 12:51 PM
To: Gouper Users List
Subject: [grouper-users] Re: Switching databases, getting error on import

Going to try and bump this. I'm still not able to export from postgresql and import into oracle. I may be doing something wrong but it's not obvious to me.

Jeffrey E. Crawford
ITS Application Administrator (IdM)

Both pilots and IT professionals require training and currency before charging into clouds!
---------------------------------------

On Thu, Feb 12, 2015 at 12:05 PM, Jeffrey Crawford wrote:
I'm trying to use oracle instead of postgresql for future discovery, I was able to export the data from postgresql using xmlexport, however using xmlimport is giving me an error message:
Caused by: org.dom4j.DocumentException: Can't find stem by uuid: '0c405ab3328e475f80e3447cac7c3d0a' Nested exception: Can't find stem by uuid: '0c405ab3328e475f80e3447cac7c3d0a'
it gets about 17% of the way through, I've executed the following to reset the oracle database and load the data but I'm not getting any further:
sh gsh -registry -drop -runscript -noprompt

sh gsh -xmlimport ~/migrate.xml -recordReport -noprompt

Jeffrey
---------------------------------------

2015-03-05 11:40:35,696: [main] ERROR XmlExportAttributeAssign$2.onEnd(620) - - Problem importing attributeActionAssign:
<XmlExportAttributeAssign>
<attributeAssignActionId>d89ee47795764b779c9d609e3e24965a</attributeAssignActionId>
<attributeAssignDelegatable>FALSE</attributeAssignDelegatable>
<attributeAssignType>stem</attributeAssignType>
<attributeDefNameId>62e87f2e885247729acffc16f854d79f</attributeDefNameId>
<contextId>761dfb37160a40609b04365e5a781ed6</contextId>
<createTime>2014/12/04 15:05:14.528</createTime>
<disallowed>F</disallowed>
<enabled>T</enabled>
<hibernateVersionNumber>0</hibernateVersionNumber>
<modifierTime>2014/12/04 15:05:14.528</modifierTime>
<ownerStemId>1a12da700ecb4718bf44f63cb4b579ca</ownerStemId>
<uuid>0c405ab3328e475f80e3447cac7c3d0a</uuid>
</XmlExportAttributeAssign>
edu.internet2.middleware.grouper.exception.StemNotFoundException: Can't find stem by uuid: '0c405ab3328e475f80e3447cac7c3d0a'
at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.findByUuid(Hib3StemDAO.java:1851)
at edu.internet2.middleware.grouper.StemFinder.findByUuid(StemFinder.java:317)
at edu.internet2.middleware.grouper.StemFinder.findByUuid(StemFinder.java:292)
at edu.internet2.middleware.grouper.attr.assign.AttributeAssign.xmlSaveBusinessProperties(AttributeAssign.java:1649)
at edu.internet2.middleware.grouper.attr.assign.AttributeAssign.xmlSaveBusinessProperties(AttributeAssign.java:102)
at edu.internet2.middleware.grouper.xml.export.XmlExportUtils.syncImportableMultiple(XmlExportUtils.java:781)
at edu.internet2.middleware.grouper.xml.export.XmlExportAttributeAssign$2.onEnd(XmlExportAttributeAssign.java:616)
at org.dom4j.io.DispatchHandler.onEnd(DispatchHandler.java:202)
at org.dom4j.io.SAXContentHandler.endElement(SAXContentHandler.java:268)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at edu.internet2.middleware.grouper.xml.importXml.XmlImportMain$3.callback(XmlImportMain.java:537)
at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:668)
at edu.internet2.middleware.grouper.xml.importXml.XmlImportMain.processXmlSecondPass(XmlImportMain.java:495)
at edu.internet2.middleware.grouper.xml.importXml.XmlImportMain.processXml(XmlImportMain.java:249)
at edu.internet2.middleware.grouper.xml.importXml.XmlImportMain.processXml(XmlImportMain.java:203)
at edu.internet2.middleware.grouper.xml.importXml.XmlImportGsh.main(XmlImportGsh.java:130)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)
at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:144)
at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)