2pack import problem in new build version

[Andrea Bellotto]

Hi everyone,

I encountered a problem installing (or updating) the 2pack with the latest updated build. It seems that the problem is in the "SQL Statement" type, if the SQL from some problem then the pack in hangs.

AD Example: if in a pack out record use:

        CREATE or REPLACE VIEW lit_m_inout_transaction_v AS ........

the 2pack works, if instead I write

       CREATE VIEW lit_m_inout_transaction_v AS ........

the 2pack gives me the following error:

 Fill mandatory fields: : Record ID - Record_ID is mandatory.

org.adempiere.exceptions.AdempiereException: Fill mandatory fields: : Record ID - Record_ID is mandatory.

        at org.compiere.model.PO.saveEx(PO.java:2256)

        at org.adempiere.pipo2.PackIn.importXML(PackIn.java:175)

        at org.adempiere.pipo2.PackIn.importXML(PackIn.java:136)

        at org.adempiere.pipo2.PackInProcess.doIt(PackInProcess.java:143)

        at org.compiere.process.SvrProcess.process(SvrProcess.java:201)

        at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:147)

        at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)

        at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:467)

        at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:235)

        at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)

        at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1103)

        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:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at java.lang.Thread.run(Thread.java:748)

I found the same problem in the test.

http://test.idempiere.org/webui/index.zul?Action=Zoom&AD_Table_ID=50008&Record_ID=1000000

Did you add sql check or anything else?

Thanks in advance

Andrea

[Andrea Bellotto]

I tried to install the pack-in in the new version 6.1 and gives me the same problem (this works only the first time, if I raise the 2pack I get the error posted in the previous message)

[Carlos Antonio Ruiz Gomez]

Hi Andrea, the test server is refreshed frequently, can you please upload a failing 2pack here?

El 5/11/18 a las 12:20, Andrea Bellotto escribió:

[Andrea Bellotto]

Hi Carlos, 
this is the link:
http://test.idempiere.org/webui/index.zul?Action=Zoom&AD_Table_ID=50008&Record_ID=1000000

thank you so much

Andrea

[Carlos Antonio Ruiz Gomez]

Ready Andrea, fixed here:

https://bitbucket.org/idempiere/idempiere/commits/61662ce

But, as you mentioned before, I think is safer to use SQLMandatory and CREATE OR REPLACE.

Regards,

Carlos Ruiz

El 5/11/18 a las 13:52, Andrea Bellotto escribió:

[Andrea Bellotto]

Thank you very much Carlos for your kind support

Regards,

Andrea Bellotto