Failed when installing org.libero.mfg62

[naw]

Dear Community

i just installed fresh copy of daily idempiere v6.2 build 98

and then i try to install libero plugin

https://bitbucket.org/pshepetko/org.libero.mfg62/downloads/

and then i get the error message:

Failed to save AD_TableIndex pp_product_bom_uu_idx

anybody know, why is this?

Thanks

[naw]

Dear idempiere Community

When we use idempiere v6.2 build #90 @ July 27, 2019

All run well

When we try to install Libero mfg 6.2 and WMS from Mr. Red1

Thanks

[Peter Shepetko]

Hello Naw!

This error exist in last builds because was

CREATE UNIQUE INDEX ad_tableindex_name

  ON ad_tableindex

  USING btree

  (upper(name::text) COLLATE pg_catalog."default");

and 2Pack can't create new record with the same name.

2Pack  create new record when didn't find  record with same pp_product_bom_uu_idx in the table. It is a bad way because we have duplicates of index for one table.

Maybe as solution  I need to support 2pack with current *uu_idx for each build. I don't know as often developers of core can updating *uu_idx for this table (and others too). But it's can block 2pack(

Best regards,

Peter

вторник, 20 августа 2019 г., 10:15:45 UTC+2 пользователь naw написал:

[Peter Shepetko]

maybe this build was without  INDEX ad_tableindex_name still ...

вторник, 20 августа 2019 г., 10:18:42 UTC+2 пользователь naw написал:

[naw]

Dear Mr. Peter & idempiere Community

Thanks for the response

So, what we have to do?

and do we miss any step?

Thanks

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/42859477-3c8d-41a7-bc77-eac0efed68e9%40googlegroups.com.

[Peter Shepetko]

If you installed plugin... You can use it)

среда, 21 августа 2019 г. пользователь naw <yuana...@gmail.com> написал:

Dear Mr. Peter & idempiere Community

Thanks for the response

So, what we have to do?

and do we miss any step?

Thanks

On Wed, Aug 21, 2019 at 5:13 AM Peter Shepetko <pshe...@gmail.com> wrote:

maybe this build was without  INDEX ad_tableindex_name still ...

вторник, 20 августа 2019 г., 10:18:42 UTC+2 пользователь naw написал:

Dear idempiere Community

When we use idempiere v6.2 build #90 @ July 27, 2019

All run well

When we try to install Libero mfg 6.2 and WMS from Mr. Red1

Thanks

On Tue, Aug 20, 2019 at 3:15 PM naw <yuana...@gmail.com> wrote:

Dear Community

i just installed fresh copy of daily idempiere v6.2 build 98

and then i try to install libero plugin

https://bitbucket.org/pshepetko/org.libero.mfg62/downloads/

and then i get the error message:

Failed to save AD_TableIndex pp_product_bom_uu_idx

anybody know, why is this?

Thanks

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.

To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/42859477-3c8d-41a7-bc77-eac0efed68e9%40googlegroups.com.

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/BUsyjcKPrao/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAL6%3D3N6M__AFnWnZHt3kfR6mBNcWv6TPnoRPb0PjZ%2BuF6f9WKw%40mail.gmail.com.

[Carlos Antonio Ruiz Gomez]

Hi Peter, I tested the plugin and you're right - after the validation of unique index name this 2pack will fail.

I checked the file 2Pack_1.0.0.zip in the plugin and almost all dictionary indexes were duplicated, so I deleted all duplicates and now the plugin install without problems.

If the 2pack throws errors it will stop the application, and it will not proceed to apply the 1.0.1 - so I think without this fix the plugin will not work.

Attached you can find the patch with the 2pack fixed, I also changed the MANIFEST to avoid problems exporting from eclipse 201809, and when starting the plugin was complaining about selenium, so I deleted that dependency.

I'll be glad if you consider integrating this patch into your repository  :-)

Regards,

Carlos Ruiz

El 21/08/19 a las 0:59, Peter Shepetko escribió:

[Peter Shepetko]

Hi Carlos,
I used 2Packs which RED1 created .
I thank  for your help and accepted the patch and published plugin  .

Best regards,

Peter

ср, 21 авг. 2019 г. в 12:07, Carlos Antonio Ruiz Gomez <car...@gmail.com>:

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/BUsyjcKPrao/unsubscribe.

To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/536c5961-c69c-fa9d-7dfc-9073aadd2de8%40gmail.com.

[naw]

ThankYou Mr. Carlos & Mr. Peter

I will test it as soon as possible and will let you know

Thanks 🙏

You received this message because you are subscribed to the Google Groups "iDempiere" group.

To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2BOJ0m%2BsgA5NRM%3DDVpqf19CtE%3Dz3606dGW4oPF3WPHtVLg8zzA%40mail.gmail.com.

[naw]

Dear Mr. Peter Shepetko & Mr. Carlos Ruiz & Community

we have just try

And This Time No Failed Message again About duplicates

Thanks Mr. Peter Shepetko & Mr. Carlos Ruiz & Community

[Peter Shepetko]

Hi Naw,

Thanks for your feedback!

Regards,

Peter

чт, 22 авг. 2019 г. в 08:09, naw <yuana...@gmail.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAL6%3D3N6zQV%3DX5rFoAyhcArRWNejuqY%2Byj%3DRL7xRkfZNj5wg4-g%40mail.gmail.com.

[naw]

Dear Mr. Peter Shepetko & Mr. Carlos Ruiz & Community

i'm sorry Mr. Peter Shepetko & Mr. Carlos Ruiz

From my previous email

i start idempiere using systemd "systemctl start idempiere-server.service"

and i do not see any message

But when itry to create new instance idempiere and i start my idempiere using "./idempiere-server.sh" and try install Libero MFG 6.2 Plug-in Again

it give me a message like this

08:14:26.031-----------> Incremental2PackActivator.packIn: Installing org.libero.mfg62 /META-INF/2Pack_1.0.0.zip ... [139]

08:14:55.192-----------> Incremental2PackActivator.packIn: Installing org.libero.mfg62 /META-INF/2Pack_1.0.0.zip ... [115]

08:15:05.911===========> SQLStatementElementHandler.startElement: SQLStatement [115]

org.postgresql.util.PSQLException: ERROR: column "qtyrequiered" of relation "pp_order_bomline" does not exist; State=42703; ErrorCode=0

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)

    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)

    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)

    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)

    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)

    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384)

    at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)

    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.base/java.lang.reflect.Method.invoke(Method.java:566)

    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:130)

    at com.sun.proxy.$Proxy9.executeUpdate(Unknown Source)

    at org.adempiere.pipo2.handler.SQLStatementElementHandler.startElement(SQLStatementElementHandler.java:67)

    at org.adempiere.pipo2.PackInHandler.processElement(PackInHandler.java:237)

    at org.adempiere.pipo2.PackInHandler.endElement(PackInHandler.java:325)

    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)

08:15:10.962-----------> Incremental2PackActivator.packIn: org.libero.mfg62 /META-INF/2Pack_1.0.0.zip installed [115]

08:15:10.962-----------> Incremental2PackActivator.packIn: Installing org.libero.mfg62 /META-INF/2Pack_1.0.1.zip ... [115]

08:15:11.006-----------> Incremental2PackActivator.packIn: org.libero.mfg62 /META-INF/2Pack_1.0.1.zip installed [115]

Do i miss something Mr. ?

Thanks Mr. Peter Shepetko & Mr. Carlos Ruiz & Community

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2BOJ0m%2B%2BOZfVz11tBZpr_0mv5jfp4NcHg01WzRqU5%3DdKXOzNfQ%40mail.gmail.com.

[Carlos Antonio Ruiz Gomez]

Although the error seems harmful, it doesn't sound right that the 2Pack_1.0.0.zip is executed more than one time, there are mechanism to prevent a successfully applied ticket to run twice.

Regards,

Carlos Ruiz

El 22/08/19 a las 10:21, naw escribió:

[naw]

Dear Mr. Carlos

Thanks Mr. Carlos for quick response 🙏

So what we have todo to dismiss that message 

Thanks Mr. Carlos

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/0027facf-0dc0-0bd8-4de0-695176d5a6c9%40gmail.com.

[Heng Sin Low]

I think that's probably due to the change of the plugin name and hence the system doesn't know that the old 2pack file have already been imported before.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/0027facf-0dc0-0bd8-4de0-695176d5a6c9%40gmail.com.

[Heng Sin Low]

and it is bad practice to change plugin name just for a new release version, you already have the bundle version field for that!

[Peter Shepetko]

Hi Everyone!

I agree wit bad practice  but Naw installed one version 6.2.

Field name qtyrequiered is wrong because must be qtyrequired and 2pack have line for delete this field

<SQLStatement>ALTER TABLE adempiere.PP_Order_BOMLine DROP COLUMN QtyRequiered CASCADE;</SQLStatement>

Maybe 2Pack  had error.

I will check it again.

Regards,

Peter

чт, 22 авг. 2019 г. в 11:38, Heng Sin Low <hen...@gmail.com>:

You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/BUsyjcKPrao/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAC%3D6jXEiNLpUrLMSGsJUK%2BvqGAU4Zxdb8kRsLc4VtuPW3NNkaw%40mail.gmail.com.

[naw]

Dear Mr. Peter Shepetko & Community

Thanks Mr. Peter ... 🙏

i will try and Test this plugin with fresh install of idempiere v6.2 after any update occured on https://bitbucket.org/pshepetko/org.libero.mfg62/downloads/

Thanks & Regards Mr. Peter Shepetko & Community

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2BOJ0mKwZi43ho4n8FoSKmHbVgUnxGBAe4E_c7t5ZCmPUZutBg%40mail.gmail.com.

[Peter Shepetko]

Hi Naw,

I checked this version plugin (after Carlos path) and didn't have this bug with  field name qtyrequiered.

Regards,

Peter

чт, 22 авг. 2019 г. в 14:58, Peter Shepetko <pshe...@gmail.com>:

[naw]

Dear Mr. Peter Shepetko & Mr. Carlos & Mr. Heng Sin & iDempiere Community

Great Mr. Peter Shepetko....🙏

Now do not  show any error/failed message

MayBe i miss any step before this...

Thanks Mr. Shepetko...🙏

Thnaks Mr. Peter Shepetko & Mr. Carlos & Mr. Heng Sin & iDempiere Community

MESSAGE ON SERVER CONSOLE:

--------------------------------------------------

Overwrite bundleresource://95.fwk603443293:1/metainfo/zk/lang-addon.xml

with jar:file:/opt/idempiere-server/jettyhome/work/jetty-idempiere-8443-org.adempiere.ui.zk_6.2.0.201908230446.jar-_webui-any-/webapp/WEB-INF/lib/ckez.jar!/metainfo/zk/lang-addon.xml [17]

08:19:01.441-----------> DefaultAnnotationProcessor.warn: Unable to detect annotations. Application may fail to deploy. [17]

08:19:02.055-----------> config.warn: No Client EndPointIdentificationAlgorithm configured for SslContextFactory@349855ef[provider=Conscrypt,keyStore=file:///opt/idempiere-server/jettyhome/etc/keystore,trustStore=file:///opt/idempiere-server/jettyhome/etc/keystore] [17]

*** 2019-08-23 08:19:29.767 idempiere Log (ConsoleHandler) ***

08:19:29.767-----------> Doc_InOut.createFacts: No Costs for Plum Tree [99]

08:19:30.203-----------> Doc_InOut.createFacts: No Costs for Plum Tree [99]

08:19:30.414-----------> Doc_InOut.createFacts: Resubmit - No Costs for Plum Tree (required order line) [99]

08:19:30.537-----------> FactLine.updateReverseLine: Not Found (try later) ,C_AcctSchema_ID=101, AD_Table_ID=319,Record_ID=102,Line_ID=102, Account_ID=587 [99]

08:19:31.223-----------> Doc_InOut.createFacts: No Costs for Plum Tree [99]

08:19:31.325-----------> Doc_InOut.createFacts: Resubmit - No Costs for Oak Tree (required order line) [99]

08:19:31.429-----------> FactLine.updateReverseLine: Not Found (try later) ,C_AcctSchema_ID=101, AD_Table_ID=319,Record_ID=104,Line_ID=106, Account_ID=587 [99]

08:19:33.921-----------> Doc_Order.isConvertible: NOT from C_Currency_ID=102 to 100 - MOrder[108-60000,IsSOTrx=true,C_DocType_ID=133, GrandTotal=228.85] [99]

08:19:34.036-----------> Doc_Invoice.isConvertible: NOT from C_Currency_ID=102 to 100 - MInvoice[109-100000,GrandTotal=228.85 (#1)] [99]

08:19:34.120-----------> Fact.isSegmentBalanced: (OO) NO - Fact[X_M_Movement[100],AcctSchema[101-GardenWorld US/A/US Dollar],PostType=A], Balance=-247.00 [99]

++++++++++++++++++++++++++++++++++++++++++

08:22:46.915-----------> Incremental2PackActivator.packIn: Installing org.libero.mfg62 /META-INF/2Pack_1.0.0.zip ... [118]

08:23:14.407-----------> Incremental2PackActivator.packIn: org.libero.mfg62 /META-INF/2Pack_1.0.0.zip installed [118]

08:23:14.408-----------> Incremental2PackActivator.packIn: Installing org.libero.mfg62 /META-INF/2Pack_1.0.1.zip ... [118]

08:23:14.480-----------> Incremental2PackActivator.packIn: org.libero.mfg62 /META-INF/2Pack_1.0.1.zip installed [118]

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2BOJ0mLLF6zGV7qSDTEDZhdi4K-r8QeqLP9Q-V%3D-VAR%3Dr91-EA%40mail.gmail.com.

[Mahendar Reddy]

Hi peter,

this link is not working to find updated repo

Regards,

Mahendhar

[Mahendar Reddy]

Im still facing this issue in idempiere 10, can anyone knows it

ERROR: column "qtyrequiered" does not exist

I am using org.idempiere.mfg_10.0.0.202308120109.jar in idempiere 10

Regards,

Mahendhar

[Peter Shepetko]

Hi,

you can download plugin from here

Regards,

Peter

пн, 15 июл. 2024 г. в 10:53, 'Mahendar Reddy' via iDempiere <idem...@googlegroups.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/f6547471-e3d9-49b0-8231-5c91e4d256c1n%40googlegroups.com.

--

Best regards,

Petro Shepetko

email: pshe...@gmail.com

www: https://pshepetko.github.io/myportfolio

phone/telegram/viber/watsapp:+380965550585

[Peter Shepetko]

Hi,

Field name qtyrequiered is wrong because must be qtyrequired 

This bug was fixed in prevision version of plugin.

Regards,

Peter

пн, 15 июл. 2024 г. в 10:56, 'Mahendar Reddy' via iDempiere <idem...@googlegroups.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/65fca488-0239-47a7-8e30-ca9bffb64d40n%40googlegroups.com.

[Mahendar Reddy]

Thanks peter It is working,

Where I can find code instead of Jar file which is suitable for idempiere 10.

Regards,

Mahendhar

[Peter Shepetko]

Hi Mahendhar,

The source code you can see on this repository too.

вт, 16 июл. 2024 г. в 14:27, 'Mahendar Reddy' via iDempiere <idem...@googlegroups.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/73dee55c-d2e7-49a3-9f3b-87ac4f95c560n%40googlegroups.com.

[Mahendar Reddy]

Hi peter,

When I am using code from this repo in idempiere 10 in eclipse, I am getting compilation problems.

attached screenshot

[Mahendar Reddy]

Hi peter, 

this caused error for me.

private int deleteCostDetail(IDocumentLine model, MAcctSchema as ,int M_CostElement_ID,
int M_AttributeSetInstance_ID)
{
// Delete Unprocessed zero Differences
String sql = "DELETE  " + MCostDetail.Table_Name
+ " WHERE Processed='N' AND COALESCE(DeltaAmt,0)=0 AND COALESCE(DeltaQty,0)=0"
+ " AND "+model.get_TableName()+"_ID=?"
+ " AND "+MCostDetail.COLUMNNAME_C_AcctSchema_ID+"=?"
+ " AND "+MCostDetail.COLUMNNAME_M_AttributeSetInstance_ID+"=?"
// + " AND "+MCostDetail.COLUMNNAME_M_CostType_ID+"=?"
+ " AND "+MCostDetail.COLUMNNAME_M_CostElement_ID+"=?";
Object[] parameters = new Object[]{ model.get_ID(),
as.getC_AcctSchema_ID(),
M_AttributeSetInstance_ID,
//as.getM_CostType_ID(),
M_CostElement_ID};

int no =DB.executeUpdateEx(sql,parameters, model.get_TrxName());
if (no != 0)
log.config("Deleted #" + no);
return no;
}

After Delete there is no FROM, it causing error.

Thanks,

Mahendhar

[Kanat Mergenbayev]

Hello everyone,

I'm in the process of installing Libero Manufacturing on iDempiere 8.2 and ran into several issues. Initially, I fixed problems related to the QtyRequiered column by dropping it from the affected tables and recreating it with the correct name QtyRequired. That part is now resolved.

However, during the PackIn step I am getting unresolved dictionary elements related to MRP menu entries and windows. The errors look like the following:

17:37:05.569 PipoDictionaryService.merge: dict file->/tmp/2Pack_1.0.0/dict/PackOut.xml [126]

17:37:18.779-----------> PackInHandler.dumpUnresolvedElements:
AD_Menu [...] Name=MRP Info (ZK) ... AD_InfoWindow_ID=7d84229d-cf1f-479d-92c4-5226916b2b49
unresolved [AD_InfoWindow_ID] [126]

17:37:18.779-----------> PackInHandler.dumpUnresolvedElements:
AD_Menu [...] Name=MRP Window ... AD_Window_ID=a4f048c0-a5a8-415e-9875-2c8a774d77b4
unresolved [AD_Window_ID] [126]

17:37:18.779-----------> PackInHandler.dumpUnresolvedElements:
AD_Package_Exp_Detail [...] AD_Process_ID=7ff51105-8e1b-4b16-b4fa-5e51719db045
unresolved [AD_Process_ID] [126]

It looks like the PackOut references Info Windows, Windows, and Processes with specific UUIDs, but those objects do not exist in the target system and are not included in the XML.

Has anyone experienced these specific unresolved UUID issues when installing Manufacturing/MRP on version 8.2?
Are these windows or info windows supposed to be part of the standard Libero package, or are they missing from the PackOut distribution?

Any guidance or updated packout files would be greatly appreciated.

Thank you!

четверг, 18 июля 2024 г. в 14:57:59 UTC+5, mahe...@pipra.solutions: