2pack: when packin a big 2pack can get maximum open cursors exceeded by too much statement/recordset is open

Description

14:45:36.115===========> PackIn.importXML: importXML: [100]
org.adempiere.exceptions.AdempiereException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

at org.adempiere.pipo2.PackInHandler.processDeferFKElements(PackInHandler.java:443)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:303)
at java.xml/com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:610)
at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1718)
at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2883)
at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605)
at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:534)
at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:888)
at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:824)
at java.xml/com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at java.xml/com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1216)
at java.xml/com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:635)
at java.xml/com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:324)
at java.xml/javax.xml.parsers.SAXParser.parse(SAXParser.java:197)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:173)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:136)
at org.adempiere.pipo.srv.PipoDictionaryService.merge(PipoDictionaryService.java:106)
at org.adempiere.plugin.utils.AbstractActivator.merge(AbstractActivator.java:82)
at org.adempiere.plugin.utils.Incremental2PackActivator.packIn(Incremental2PackActivator.java:227)
at org.adempiere.plugin.utils.Incremental2PackActivator.packIn(Incremental2PackActivator.java:184)
at org.adempiere.plugin.utils.Incremental2PackActivator.installPackage(Incremental2PackActivator.java:91)

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Hiep Lq

Labels

None

Tested By

None

Priority

Major
Configure