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