Hi Red1,
Thanks for your help.
I follow your instruction, and now can basically locate the issue. I noticed that there are 2 pack-ins, one for 3.1.0, the other one is 1.0.0 (this is the one I imported from repo project), 1.0.0 happens first, I found nothing, then uninstall it, using your 3.1.0 jar to install, found still fail. The failure message is like some update on the database table, the key already exists. How can I remove the 2 packs in my system? I doesn't allow me to delete.
-------------------------------
11:44:00.931===========> DB.executeUpdate: INSERT INTO AD_Field (AD_Field_ID,Name,AD_Tab_ID,AD_Column_ID,IsDisplayed,DisplayLength,SeqNo,IsSameLine,IsHeading,IsFieldOnly,IsEncrypted,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,IsReadOnly,IsCentrallyMaintained,AD_FieldGroup_ID,EntityType,AD_Field_UU,IsDisplayedGrid,SeqNoGrid,XPosition,ColumnSpan,NumLines,IsQuickEntry,IsDefaultFocus,IsAdvancedField) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [SvrProcess_19c10142-bf53-4a99-ac31-41bd81d65460] [44]
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists.; State=23505; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:441)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
at com.sun.proxy.$Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.DB.executeUpdate(DB.java:1038)
at org.compiere.util.DB.executeUpdate(DB.java:1007)
at org.compiere.model.PO.doInsert(PO.java:2974)
at org.compiere.model.PO.saveNew(PO.java:2778)
at org.compiere.model.PO.save(PO.java:2128)
at org.compiere.model.PO.save(PO.java:2332)
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:82)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
-------------------------------
11:44:01.026===========> DB.saveError: SaveErrorNotUnique - ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists. [44]
-------------------------------
11:44:01.033-----------> MField.doInsert: [SvrProcess_19c10142-bf53-4a99-ac31-41bd81d65460]Not inserted - AD_Field [44]
11:44:01.073===========> MField.saveError: SaveErrorNotUnique - ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists. [44]
-------------------------------
11:44:01.095===========> PackIn.importXML: importXML: [44]
org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:44:01.118===========> PackIn.importXML: importXML: [44]
java.lang.RuntimeException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:185)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)
at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1054)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
caused by: org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:44:01.152===========> PackInProcess.doIt: importXML: [44]
java.lang.RuntimeException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:185)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)
at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1054)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
caused by: org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:44:01.196===========> PackInProcess.process: Failed to save field definition Not send to POS [44]
org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:46:21.405===========> Trx.commit: POdel_bf9d42e9-cc53-402b-ab94-6fade37253c8 [119]
org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000003) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848)
at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)
at org.compiere.util.Trx.commit(Trx.java:357)
at org.compiere.model.PO.delete(PO.java:3401)
at org.compiere.model.GridTable.dataDelete(GridTable.java:2692)
at org.compiere.model.GridTab.dataDelete(GridTab.java:1207)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:2400)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:1)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:385)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:1)
at org.adempiere.webui.component.Messagebox.onPageDetached(Messagebox.java:349)
at org.zkoss.zk.ui.AbstractComponent.setPage0(AbstractComponent.java:477)
at org.zkoss.zk.ui.AbstractComponent.setPageBefore(AbstractComponent.java:396)
at org.zkoss.zk.ui.AbstractComponent.setPage(AbstractComponent.java:361)
at org.zkoss.zk.ui.AbstractComponent.detach(AbstractComponent.java:1681)
at org.adempiere.webui.component.Messagebox.onEvent(Messagebox.java:340)
at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2773)
-------------------------------
11:46:21.422===========> X_AD_Package_Imp_Proc.saveError: DeleteErrorDependent - ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000003) is still referenced from table "ad_package_imp". [119]
-------------------------------
11:46:21.423-----------> GridTable.saveWarning: DeleteErrorDependent - ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000003) is still referenced from table "ad_package_imp". [119]
11:46:21.461===========> Trx.commit: POdel_464d9b72-d414-42e7-b062-03d6ded2dd9e [119]
org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848)
at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)
at org.compiere.util.Trx.commit(Trx.java:357)
at org.compiere.model.PO.delete(PO.java:3401)
at org.compiere.model.GridTable.dataDelete(GridTable.java:2692)
at org.compiere.model.GridTab.dataDelete(GridTab.java:1207)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:2400)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:1)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:385)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:1)
at org.adempiere.webui.component.Messagebox.onPageDetached(Messagebox.java:349)
at org.zkoss.zk.ui.AbstractComponent.setPage0(AbstractComponent.java:477)
at org.zkoss.zk.ui.AbstractComponent.setPageBefore(AbstractComponent.java:396)
at org.zkoss.zk.ui.AbstractComponent.setPage(AbstractComponent.java:361)
at org.zkoss.zk.ui.AbstractComponent.detach(AbstractComponent.java:1681)
at org.adempiere.webui.component.Messagebox.onEvent(Messagebox.java:340)
at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2773)
-------------------------------
11:46:21.470===========> X_AD_Package_Imp_Proc.saveError: DeleteErrorDependent - ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp". [119]
-------------------------------
11:46:21.471-----------> GridTable.saveWarning: DeleteErrorDependent - ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp". [119]
11:46:30.143===========> Trx.commit: POdel_b67cfe35-2c2a-4776-925e-994f53eff2c3 [33]
org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp".; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:824)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:848)
at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1007)
at org.compiere.util.Trx.commit(Trx.java:357)
at org.compiere.model.PO.delete(PO.java:3401)
at org.compiere.model.GridTable.dataDelete(GridTable.java:2692)
at org.compiere.model.GridTab.dataDelete(GridTab.java:1207)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:2400)
at org.adempiere.webui.adwindow.AbstractADWindowContent$36.onCallback(AbstractADWindowContent.java:1)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:385)
at org.adempiere.webui.window.FDialog$3.onCallback(FDialog.java:1)
at org.adempiere.webui.component.Messagebox.onPageDetached(Messagebox.java:349)
at org.zkoss.zk.ui.AbstractComponent.setPage0(AbstractComponent.java:477)
at org.zkoss.zk.ui.AbstractComponent.setPageBefore(AbstractComponent.java:396)
at org.zkoss.zk.ui.AbstractComponent.setPage(AbstractComponent.java:361)
at org.zkoss.zk.ui.AbstractComponent.detach(AbstractComponent.java:1681)
at org.adempiere.webui.component.Messagebox.onEvent(Messagebox.java:340)
at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2773)
-------------------------------
11:46:30.161===========> X_AD_Package_Imp_Proc.saveError: DeleteErrorDependent - ERROR: update or delete on table "ad_package_imp_proc" violates foreign key constraint "adpackageimpproc_adpackageimp" on table "ad_package_imp"
Detail: Key (ad_package_imp_proc_id)=(1000002) is still referenced from table "ad_package_imp". [33]
-------------------------------
11:48:17.351 PackInHandler.processElement: Processed: AD_Field - table [52]
11:48:17.352 PackInHandler.processElement: Processed: AD_Field_Trl - translation [52]
11:48:17.354 PackInHandler.processElement: Processed: AD_Field - table [52]
11:48:17.355 PackInHandler.processElement: Processed: AD_Field_Trl - translation [52]
11:48:17.355 PackInHandler.processElement: Processed: AD_Field - table [52]
11:48:17.356 PackInHandler.processElement: Processed: AD_Field_Trl - translation [52]
11:48:17.357 PackInHandler.processElement: Processed: AD_Field - table [52]
11:48:17.357 FieldGroupElementHandler.startElement: AD_FieldGroup POS [52]
11:48:17.359 PackInHandler.processElement: Processed: AD_FieldGroup_Trl - translation [52]
11:48:17.360 PackInHandler.processElement: Processed: AD_FieldGroup - table [52]
11:48:17.425===========> DB.executeUpdate: INSERT INTO AD_Field (AD_Field_ID,Name,AD_Tab_ID,AD_Column_ID,IsDisplayed,DisplayLength,SeqNo,IsSameLine,IsHeading,IsFieldOnly,IsEncrypted,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,IsReadOnly,IsCentrallyMaintained,AD_FieldGroup_ID,EntityType,AD_Field_UU,IsDisplayedGrid,SeqNoGrid,XPosition,ColumnSpan,NumLines,IsQuickEntry,IsDefaultFocus,IsAdvancedField) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [SvrProcess_e3481643-d5e5-4099-9d4a-797b3d655e28] [52]
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists.; State=23505; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:441)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
at com.sun.proxy.$Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.DB.executeUpdate(DB.java:1038)
at org.compiere.util.DB.executeUpdate(DB.java:1007)
at org.compiere.model.PO.doInsert(PO.java:2974)
at org.compiere.model.PO.saveNew(PO.java:2778)
at org.compiere.model.PO.save(PO.java:2128)
at org.compiere.model.PO.save(PO.java:2332)
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:82)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
-------------------------------
11:48:17.456===========> DB.saveError: SaveErrorNotUnique - ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists. [52]
-------------------------------
11:48:17.457-----------> MField.doInsert: [SvrProcess_e3481643-d5e5-4099-9d4a-797b3d655e28]Not inserted - AD_Field [52]
11:48:17.461===========> MField.saveError: SaveErrorNotUnique - ERROR: duplicate key value violates unique constraint "ad_field_column"
Detail: Key (ad_tab_id, ad_column_id)=(177, 1000048) already exists. [52]
-------------------------------
11:48:17.562===========> PackIn.importXML: importXML: [52]
org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:48:17.577===========> PackIn.importXML: importXML: [52]
java.lang.RuntimeException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:185)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)
at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1054)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
caused by: org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:48:17.612===========> PackInProcess.doIt: importXML: [52]
java.lang.RuntimeException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:185)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)
at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1054)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
caused by: org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
-------------------------------
11:48:17.635===========> PackInProcess.process: Failed to save field definition Not send to POS [52]
org.adempiere.pipo2.exception.POSaveFailedException: Failed to save field definition Not send to POS
at org.adempiere.pipo2.handler.FieldElementHandler.startElement(FieldElementHandler.java:89)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:253)
at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:333)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1783)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2970)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:642)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:326)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:172)
at org.adempiere.pipo2.PackIn.importXML(PackIn.java:135)
at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:142)
at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
Thanks,
Jianfeng
在 2016年4月22日星期五 UTC+8上午1:52:05,Jianfeng Wang写道: