[ https://issues.apache.org/jira/browse/OOZIE-2143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325132#comment-14325132 ]
Bowen Zhang commented on OOZIE-2143: ------------------------------------ We encountered this defect 6 months ago. The workaround we had is to manually insert data into the second sid in oracle. Did you have the same problem? What is the problem you encountered? > Making two Oozie schemas in an Oracle Database does not behave correctly > ------------------------------------------------------------------------ > > Key: OOZIE-2143 > URL: https://issues.apache.org/jira/browse/OOZIE-2143 > Project: Oozie > Issue Type: Bug > Reporter: Robert Kanter > > If you have an Oracle Database and try to create a second Oozie schema in it > (for a second separate Oozie server), it will not work correctly unless you > have some very specific permissions set. This is due to a bug in OpenJPA's > mapping tool, which has been open for many years with little-to-no activity. -- This message was sent by Atlassian JIRA (v6.3.4#6332)