#idempiere IRC log for Wednesday, 2017-09-13

*** mbozem has quit IRC01:04
*** mbozem has joined #idempiere01:05
*** mbozem2 has joined #idempiere01:30
*** mbozem has quit IRC01:31
Not-bfd4[iDempiere4.1Daily] jenkins built #109 completed (success) http://ci.idempiere.org/job/iDempiere4.1Daily/109/04:49
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-347906:08
Not-bfd4[IDEMPIERE] This should be added to core but must not be google implementation specific. There should be an interface to plugin different 2fa provider. Also, we can implement a default 2fa implementation in core that simply send a time limited, random tag/token to the login email account.06:08
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-347906:08
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-340606:20
Not-bfd4[IDEMPIERE] I think it should be Order by QtyOnHand Desc instead. Filter out record with QtyOnHand = 0 could break use cases that need to update existing ASI with onhand = 0.06:20
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-340606:20
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-345606:29
Not-bfd4[IDEMPIERE] I guess this can be make configurable with a new tenant level flag, for e.g ALLOW_REACTIVATE_CLOSE_PERIOD_ORDER. Should default to Y to maintain backward compatibility.06:29
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-345606:29
Not-bfd4[IDEMPIERE] hengsin created IDEMPIERE-3483 Issue to Project from Material Receipt => Error: Posts Unit Cost instead of Extended Cost06:45
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348306:45
*** nmicoud has joined #idempiere06:45
Not-bfd4[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/06:49
Not-bfd4[iDempiere] hengsin cc21c47 - IDEMPIERE-3483 Issue to Project from Material Receipt => Error: Posts Unit Cost instead of Extended Cost06:49
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-3483 status set to "Resolved" -assignee set to "Chuck Boecking" -Fix Version set to "4.1" -resolution set to "Fixed"06:50
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348306:50
Not-bfd4[IDEMPIERE] hengsin created IDEMPIERE-3484 ProjectIssue should create M_CostDetail record06:52
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348406:52
Not-bfd4[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/06:57
Not-bfd4[iDempiere] hengsin 45aad54 - IDEMPIERE-3484 ProjectIssue should create M_CostDetail record06:57
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-3484 status set to "Resolved" -assignee set to "Chuck Boecking" -Fix Version set to "4.1" -resolution set to "Fixed"06:57
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348406:57
Not-bfd4[IDEMPIERE] nmicoud updated IDEMPIERE-3478 status set to "Peer Review Queue"06:57
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-347806:57
Not-bfd4[IDEMPIERE] nmicoud updated IDEMPIERE-3478 assignee set to "Carlos Ruiz"06:57
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-347806:58
Not-bfd4[IDEMPIERE] nmicoud updated IDEMPIERE-3478 labels set to "+Patch"06:58
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-347806:58
Not-bfd4[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/07:01
Not-bfd4[iDempiere] hengsin a8634ef - IDEMPIERE-3361 Cost details inherit amt/qty from wrong history cost element07:01
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-3361 status set to "Resolved" -assignee set to "Norbert Bede" -Fix Version set to "4.1" -resolution set to "Fixed"07:03
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-336107:03
*** a42niem has joined #idempiere07:06
Not-bfd4[iDempiere4.1] jenkins built #185 completed (success) http://ci.idempiere.org/job/iDempiere4.1/185/07:15
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-3061 status set to "Resolved" -assignee set to "Daniel Haag" -resolution set to "Won't Fix"07:27
Not-bfd4[IDEMPIERE] The patch is outdated. Please reopen with a new patch and test case if the problem is still there in current 4.1 code.07:27
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-306107:27
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-2953 priority set to "Major"07:28
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-295307:28
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-295307:29
Not-bfd4[IDEMPIERE] This probably wouldn't be fixed in short to mid term. Workaround is to use Average PO Costing with Batch Level Costing.07:29
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-295307:29
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-2603 status set to "Resolved" -resolution set to "Cannot Reproduce"07:47
Not-bfd4[IDEMPIERE] Not reproduceable with current 4.1 code. Please reopen with test case if you can reproduce it.07:47
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-260307:47
*** CarlosRuiz has joined #idempiere07:56
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-2659 status set to "Closed" -resolution set to "Fixed"08:07
Not-bfd4[IDEMPIERE] This should have been fixed in current 4.1 code. Please reopen if that's not the case.08:07
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-265908:07
Not-bfd4[IDEMPIERE] hengsin created IDEMPIERE-3485 Report/Process: Unique constraint exception after save parameter08:17
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348508:17
*** a42niem has quit IRC08:27
Not-bfd4[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/08:35
Not-bfd4[iDempiere] hengsin 62c83bf - IDEMPIERE-3485 Report/Process: Unique constraint exception after save parameter08:35
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-3485 status set to "Resolved" -Fix Version set to "4.1" -resolution set to "Fixed"08:36
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348508:36
Not-bfd4[iDempiere4.1] jenkins built #186 completed (success) http://ci.idempiere.org/job/iDempiere4.1/186/08:42
*** marcofontell has joined #idempiere12:03
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-348012:30
Not-bfd4[IDEMPIERE] 2Pack also got issue with huge record. i try to use 2Pack for about 500.000 product price it take long time (about 7h) and end with exception transaction timeout i think overload stay at get ID of table and save change log12:30
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348012:30
*** marcofontell has quit IRC12:32
*** victorgomez has joined #idempiere12:42
Not-bfd4[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-348012:43
Not-bfd4[IDEMPIERE] [~hieplq], 2pack is designed to do all the work within a single transaction, so loading 500.000 records with 2pack can lead to a big long trx - I think is not the intention of 2pack to load such big data. About CSV import - it can work within a single transaction or transaction per line depending on the configuration of the CSV file - for better results in a big load case like you try the transaction must12:43
Not-bfd4be per line. I think CSV import is slow and memory-hungry because it was designed to emulate a user typing in the window, so, it uses all the UI-related structures. That has a big advantage and is that callouts are executed as if the user is typing in the window, but cannot give the same speed and memory than a direct-model importer (not using the UI). We have annotated that as a "known-issue" for CSV importer and12:43
Not-bfd4recommendation is to split the file in manageable sizes. Or, for big data, use the old importers when available, in the case of product price import there is an old non-UI importer that can be used. But, of course, any improvement in memory/speed for the CSV importer that doesn't break the UI-emulation functionality is welcome.12:43
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348012:43
victorgomezhi all12:51
victorgomezhave anybody here faced a GenerateDocumentNoTimeOut problem when running InvoiceGen process in a large database  (postgresql) ?12:52
victorgomezexplaining better, when a user is generating invoices other users inputing manual invoices get locket with GenerateDocumentNoTimeOut12:53
victorgomezas i understand is in due of a ad_sequence lock12:53
*** marcofontell has joined #idempiere13:07
CarlosRuizyes victorgomez - the InvoiceGen run in a single transaction13:16
CarlosRuizand in some big load environments can cause that13:16
CarlosRuizdo you know how to open a ticket on JIRA?13:17
victorgomezthank you for your feedback CarlosRuiz...13:18
victorgomezyes, i know... should i do it?13:18
victorgomezjust two more related itens, my ad_changelog table have 39.436.973 records... it's a good pratice clear old records there? and also i was looking into pool.properties file (PostgreSQL folder in server home) if there's something to change there that can avoid the timeout, but i think that the answer is "no"13:22
*** marcofontell has quit IRC13:26
CarlosRuizyes - that can be an improvement - to process a transaction per invoice13:35
CarlosRuizfor pool.properties you can check the options that c3p0 library provides - but I think it's not related to timeouts13:35
CarlosRuizabout cleaning ad_changelog - yes - you can clear it if you don't need it - is audit information - there is a Housekeeping feature where you can save it to XML - or move records to a historic table - and also schedule it to do it periodically13:36
victorgomezoh, alright.... i'll do that...13:50
victorgomezand also check the housekeeping feature!! thank you!!13:50
Not-bfd4[iDempiere] hengsin pushed 1 commit to release-4.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/13:51
Not-bfd4[iDempiere] hengsin 5aa871f - IDEMPIERE-3485 Report/Process: Unique constraint exception after save parameter13:51
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-348014:20
Not-bfd4[IDEMPIERE] thanks [~carlosruiz_globalqss] for comment. finally i import by sql with id = current + row_number() after that update seq, very fast, about 3 minute. about long time transaction, i read discuss here IDEMPIERE-644 and agree with it. about tab csv import. it can slow but shouldn't take a lot of memory not yet take time to discover, but i guess by it keep one install of window to import data, so end up it14:20
Not-bfd4like you load 500.000 record on this window. so it should refresh window instance after like 100 master record (that should on parameter).14:20
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348014:20
Not-bfd4[IDEMPIERE] hieplq created IDEMPIERE-3486 info business partner hard code to set isCustomer, isVendor, so break "Value Preference " and avoid customize14:22
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348614:22
Not-bfd4[iDempiere4.1] jenkins built #187 completed (failure) http://ci.idempiere.org/job/iDempiere4.1/187/14:25
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-3486 labels set to "+Patch"14:29
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348614:29
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-3486 Attachment set to "IDEMPIERE-3486.patch"14:30
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348614:30
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-3486 status set to "Peer Review Queue"14:30
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348614:30
*** victorgomez has quit IRC14:40
Not-bfd4[IDEMPIERE] hieplq created IDEMPIERE-3487 price list version on product info show ever PLV from inactive price list14:42
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348714:42
Not-bfd4[IDEMPIERE] hieplq updated IDEMPIERE-348714:47
Not-bfd4[IDEMPIERE] PLV also should fill out by price list when open on window like sales order, purchase,...14:47
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-348714:47
*** nmicoud has quit IRC15:21
*** Slug_ has joined #idempiere15:26
Not-bfd4[IDEMPIERE] hengsin updated IDEMPIERE-341316:29
Not-bfd4[IDEMPIERE] JSON is supported by both PostgreSQL and Oracle so that could be a viable alternative here16:29
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-341316:29
*** mbozem2 has quit IRC18:09
*** CarlosRuiz has left #idempiere18:41
Not-bfd4[IDEMPIERE] norbert.bede updated IDEMPIERE-341321:34
Not-bfd4[IDEMPIERE] +1 for json solution. generally json fieldtype is really missing in idempiere. (another ticket)21:34
Not-bfd4[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-341321:34

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!