关于导入2pack packages问题

xiaoxuesu_2008

这些天一直在研究2pack。这个功能还真好，给开发者和客户带来了很多方便。使用此功能，可以把adempiere里的数据、功能打包，然后导入到指定服务器上，既不影响开发者开发新的功能，又不耽误客户正常使用。
今天，使用“PackIn” window以导入2pack时，出现了这样两个错误：Invalid PO Info-POInfo[null, AD_Table_ID=50004]和GenericPO。谁能帮我解决下，不胜感激。

newhappy

请把log贴出来

xiaoxuesu_2008

ERROR [STDERR] ===========> DB.executeUpdate: INSERT INTO AD_Package_Imp_Detail (AD_Client_ID,AD_Org_ID,AD_Original_ID,AD_Package_Imp_Detail_ID,AD_Package_Imp_ID,AD_Table_ID,"action",Created,CreatedBy,IsActive,Name,Success,TableName,Type,Updated,UpdatedBy) VALUES (0,0,1000002,1001889,1000013,53048,'New',TO_TIMESTAMP('2009-07-17','YYYY-MM-DD'),100,'Y','ASP_Field','Failure','ASP_Field','Data',TO_TIMESTAMP('2009-07-17','YYYY-MM-DD'),100) [SvrProcess_cece16bc-b41d-4ad3-8a00-f6ac5bb268a4] [15]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
        at $Proxy67.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdate(DB.java:1008)
        at org.compiere.util.DB.executeUpdate(DB.java:871)
        at org.compiere.util.DB.executeUpdate(DB.java:858)
        at org.compiere.model.PO.saveNew(PO.java:2596)
        at org.compiere.model.PO.save(PO.java:1992)
        at org.compiere.model.PO.save(PO.java:2138)
        at org.adempiere.pipo.AbstractElementHandler.record_log(AbstractElementHandler.java:113)
        at org.adempiere.pipo.handler.DataElementHandler$DataRowElementHandler.endElement(DataElementHandler.java:225)
        at org.adempiere.pipo.handler.DataElementHandler.endElement(DataElementHandler.java:94)
14:22:40,769 ERROR [STDERR] ===========> DB.executeUpdate: INSERT INTO AD_Package_Imp_Detail (AD_Client_ID,AD_Org_ID,AD_Original_ID,AD_Package_Imp_Detail_ID,AD_Package_Imp_ID,AD_Table_ID,"action",Created,CreatedBy,IsActive,Name,Success,TableName,Type,Updated,UpdatedBy) VALUES (0,0,1000002,1001889,1000013,53048,'New',TO_TIMESTAMP('2009-07-17','YYYY-MM-DD'),100,'Y','ASP_Field','Failure','ASP_Field','Data',TO_TIMESTAMP('2009-07-17','YYYY-MM-DD'),100) [SvrProcess_cece16bc-b41d-4ad3-8a00-f6ac5bb268a4] [15]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
        at $Proxy67.executeUpdate(Unknown Source)
        at org.compiere.util.DB.executeUpdate(DB.java:1008)
        at org.compiere.util.DB.executeUpdate(DB.java:871)
        at org.compiere.util.DB.executeUpdate(DB.java:858)
        at org.compiere.model.PO.saveNew(PO.java:2596)
        at org.compiere.model.PO.save(PO.java:1992)
        at org.compiere.model.PO.save(PO.java:2138)
        at org.adempiere.pipo.AbstractElementHandler.record_log(AbstractElementHandler.java:113)
        at org.adempiere.pipo.handler.DataElementHandler$DataRowElementHandler.endElement(DataElementHandler.java:225)
        at org.adempiere.pipo.handler.DataElementHandler.endElement(DataElementHandler.java:94)
14:22:40,778 ERROR [STDERR] ===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [15]
14:22:40,786 ERROR [STDERR] ===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [15]
14:22:40,787 ERROR [STDERR] -----------> X_AD_Package_Imp_Detail.saveNew: [SvrProcess_cece16bc-b41d-4ad3-8a00-f6ac5bb268a4]Not inserted - AD_Package_Imp_Detail [15]
14:22:40,787 ERROR [STDERR] -----------> X_AD_Package_Imp_Detail.saveNew: [SvrProcess_cece16bc-b41d-4ad3-8a00-f6ac5bb268a4]Not inserted - AD_Package_Imp_Detail [15]
14:22:40,789 ERROR [STDERR] ===========> PackIn.importXML: importXML: [15]
org.adempiere.pipo.exception.POSaveFailedException: GenericPO
        at org.adempiere.pipo.handler.DataElementHandler$DataRowElementHandler.endElement(DataElementHandler.java:226)
        at org.adempiere.pipo.handler.DataElementHandler.endElement(DataElementHandler.java:94)
        at org.adempiere.pipo.PackInHandler.endElement(PackInHandler.java:741)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.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 javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:331)
        at org.adempiere.pipo.PackIn.importXML(PackIn.java:138)
        at org.adempiere.pipo.PackIn.doIt(PackIn.java:200)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:147)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:105)
        at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:123)
        at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:650)
        at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:395)
        at org.compiere.apps.ProcessCtl.process(ProcessCtl.java:211)
14:22:40,868 ERROR [STDERR] -----------> MIssue.set_Value: SourceClassName - Value too long - truncated to length=60 [15]
14:22:40,868 ERROR [STDERR] -----------> MIssue.set_Value: SourceClassName - Value too long - truncated to length=60 [15]
14:22:40,919 ERROR [STDERR] ===========> PackIn.importXML: importXML: [15]
org.adempiere.pipo.exception.POSaveFailedException: GenericPO
        at org.adempiere.pipo.handler.DataElementHandler$DataRowElementHandler.endElement(DataElementHandler.java:226)
        at org.adempiere.pipo.handler.DataElementHandler.endElement(DataElementHandler.java:94)
        at org.adempiere.pipo.PackInHandler.endElement(PackInHandler.java:741)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.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 javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:331)
        at org.adempiere.pipo.PackIn.importXML(PackIn.java:138)
        at org.adempiere.pipo.PackIn.doIt(PackIn.java:200)
        at org.compiere.process.SvrProcess.process(SvrProcess.java:147)
        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:105)
        at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:123)
        at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:650)
        at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:395)
        at org.compiere.apps.ProcessCtl.process(ProcessCtl.java:211)
14:22:40,924 ERROR [STDERR] -----------> PackIn.process: GenericPO [15]
14:22:40,924 ERROR [STDERR] -----------> PackIn.process: GenericPO [15]
14:22:59,765 ERROR [STDERR] javax.jms.JMSException: Could not connect to broker URL: tcp://www.example.com:61616. Reason: java.net.SocketTimeoutException: connect timed out
14:22:59,766 ERROR [STDERR]     at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:35)
14:22:59,767 ERROR [STDERR]     at org.apache.activemq.ActiveMQConnectionFactory.createActiveMQConnection(ActiveMQConnectionFactory.java:276)
14:22:59,768 ERROR [STDERR]     at org.apache.activemq.ActiveMQConnectionFactory.createConnection(ActiveMQConnectionFactory.java:175)
14:22:59,768 ERROR [STDERR]     at org.adempiere.server.rpl.imp.TopicListener.run(TopicListener.java:195)
14:22:59,769 ERROR [STDERR]     at org.adempiere.server.rpl.imp.TopicImportProcessor.process(TopicImportProcessor.java:116)
14:22:59,769 ERROR [STDERR]     at org.compiere.server.ReplicationProcessor.doWork(ReplicationProcessor.java:114)
14:22:59,771 ERROR [STDERR]     at org.compiere.server.AdempiereServer.run(AdempiereServer.java:229)
14:22:59,771 ERROR [STDERR] Caused by: java.net.SocketTimeoutException: connect timed out
14:22:59,772 ERROR [STDERR]     at java.net.PlainSocketImpl.socketConnect(Native Method)
14:22:59,772 ERROR [STDERR]     at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
14:22:59,773 ERROR [STDERR]     at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
14:22:59,773 ERROR [STDERR]     at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
14:22:59,773 ERROR [STDERR]     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
14:22:59,774 ERROR [STDERR]     at java.net.Socket.connect(Socket.java:519)
14:22:59,774 ERROR [STDERR]     at org.apache.activemq.transport.tcp.TcpTransport.connect(TcpTransport.java:400)
14:22:59,775 ERROR [STDERR]     at org.apache.activemq.transport.tcp.TcpTransport.doStart(TcpTransport.java:366)
14:22:59,775 ERROR [STDERR]     at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:48)
14:22:59,775 ERROR [STDERR]     at org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:56)
14:22:59,776 ERROR [STDERR]     at org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:56)
14:22:59,776 ERROR [STDERR]     at org.apache.activemq.transport.WireFormatNegotiator.start(WireFormatNegotiator.java:63)
14:22:59,776 ERROR [STDERR]     at org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:56)
14:22:59,777 ERROR [STDERR]     at org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:56)
14:22:59,777 ERROR [STDERR]     at org.apache.activemq.ActiveMQConnectionFactory.createActiveMQConnection(ActiveMQConnectionFactory.java:256)
14:22:59,778 ERROR [STDERR]     ... 5 more
14:22:59,778 ERROR [STDERR] ===========> ReplicationProcessor.doWork: Could not connect to broker URL: tcp://www.example.com:61616. Reason: java.net.SocketTimeoutException: connect timed out [13]
14:22:59,870 ERROR [STDERR] ===========> ReplicationProcessor.doWork: Could not connect to broker URL: tcp://www.example.com:61616. Reason: java.net.SocketTimeoutException: connect timed out [13]
14:22:59,902 ERROR [STDERR] java.lang.NullPointerException
14:22:59,903 ERROR [STDERR]     at org.adempiere.server.rpl.imp.TopicListener.stop(TopicListener.java:316)
14:22:59,903 ERROR [STDERR]     at org.adempiere.server.rpl.imp.TopicImportProcessor.stop(TopicImportProcessor.java:123)
14:22:59,904 ERROR [STDERR]     at org.compiere.server.ReplicationProcessor.doWork(ReplicationProcessor.java:128)
14:22:59,904 ERROR [STDERR]     at org.compiere.server.AdempiereServer.run(AdempiereServer.java:229)
^C14:23:15,767 INFO  [Server] Runtime shutdown hook called, forceHalt: true
14:23:15,767 INFO  [Server] JBoss SHUTDOWN: Undeploying all packages
14:23:15,768 INFO  [TomcatDeployer] undeploy, ctxPath=/webui, warUrl=.../tmp/deploy/tmp7658845051943293272webui-exp.war/
14:23:15,774 INFO  [StandardWrapper] Waiting for 1 instance(s) to be deallocated
14:23:15,793 INFO  [STDOUT]

xiaoxuesu_2008

2# newhappy
我贴的log可能不是很明白。我具体给你描述下吧：
导出2pack文件后，会生成.xml文件。导入2pack文件时，系统会将.xml写入到sql中。
例如：我们先导入asp_window, 再导入asp_tab. 因为asp_tab与asp_window有关联，关联字段为：asp_window_id.
当我导入asp_window时，成功。随后导入asp_tab时，却报错：GenericPO.
后来查找了原因，原来是导入asp_tab时，数据库会自动生成asp_window_id的值，而且是按顺序生成（从1000148到1000203）。因为asp_tab.asp_window_id与asp_window.asp_window_id的值不对应，所以就关联不起来，导致系统报错。
既然查找到了原因，于是，我删除了asp_tab的所有记录，重新导入值，可是系统又重新为asp_window_id分配id（从1000204到1000259）。
晕了，不知所措。
我的想法是：能不能重新为asp_window_id分配与.xml文件相同的asp_window_id? 或者如何写sql，能够避免使用动态id来解决这样的问题？
帮帮我吧，我真的不知道如何是好！

xiaoxuesu_2008

问题基本解决。

xiaoxuesu_2008

导入模板已成功，有问题可以咨询我！