#idempiere IRC log for Wednesday, 2014-12-24

*** hieplq has joined #idempiere00:14
*** a42niem_ has quit IRC00:51
*** a42niem has quit IRC00:51
*** hieplq has quit IRC02:03
*** norbertbede has joined #idempiere04:35
Not-2487[IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-2370 SaaS Generate on menu option04:49
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-237004:49
Not-2487[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-2.1 [+2/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/04:50
Not-2487[iDempiere] globalqss a6c3b42 - IDEMPIERE-2370 SaaS Generate on menu option04:50
Not-2487[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2370 status set to "Resolved" -resolution set to "Fixed"04:50
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-237004:50
*** CarlosRuiz has quit IRC04:54
*** norbertbede has quit IRC04:54
*** norbertbede has joined #idempiere05:40
*** mbilalilyas has joined #idempiere06:28
mbilalilyashello guys kindly tell me that i want the enablecheckmark property on the checkbox of idempiere window as given in that link how can i achieve it http://www.zkoss.org/zkdemo/listbox/multiple_selection06:31
*** norbertbede has quit IRC06:38
Not-2487[IDEMPIERE] deepak updated IDEMPIERE-64406:45
Not-2487[IDEMPIERE] Carlos, Cause is line 654 in Trx.java. look at below snippet if (since > trxs[i].getTimeout() * 1000) { trxs[i].log.log(Level.WARNING, "Transaction timeout. Name="+trxs[i].getTrxName() + ", timeout(sec)="+(since / 1000)); trxs[i].close(); } trx is getting closed after 2 hours of creation of transaction even though trx is actively in use.06:45
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-64406:45
Not-2487[IDEMPIERE] deepak updated IDEMPIERE-64406:48
Not-2487[IDEMPIERE] Below is hengsin's suggestions. Recording on ticket for the timeout ticket - 1) commit upon timeout is a bug, should rollback instead. 2) hard to calculate a good timeout - guess easier to just add trx timeout column to ad_process06:48
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-64406:48
*** norbertbede has joined #idempiere06:52
*** mbilalilyas has quit IRC07:05
*** hieplq has joined #idempiere07:34
*** a42niem has joined #idempiere08:17
*** norbertbede has quit IRC08:42
*** red1 has joined #idempiere08:46
*** ChanServ sets mode: +o red108:46
Not-2487[IDEMPIERE] hieplq updated IDEMPIERE-2367 issuetype set to "Improvement" -labels set to "+Patch" -Version set to "iDempiere HEAD" -Attachment set to "IDEMPIERE-2367.patch"09:19
Not-2487[IDEMPIERE] [~carlosruiz_globalqss] please help me review it. at moment, has two cache. 1. load all record to cache when num of record < 1000 i remove this cache 2. always preload data (at least 4 page before and after current page) i make it Configurable with default is 2 page09:19
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-236709:19
Not-2487[IDEMPIERE] hieplq updated IDEMPIERE-2367 status set to "Peer Review Queue"09:19
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-236709:19
Not-2487[IDEMPIERE] hieplq updated IDEMPIERE-2230 status set to "Open"09:22
Not-2487[IDEMPIERE] 1. miss save selection in muilt page to t_selection for process. 2. miss set selection to environment to set to detail tab when close info window09:22
Not-2487[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-223009:22
*** Not-2487 has quit IRC09:26
*** norbertbede has joined #idempiere09:31
*** KermitTheFragger has joined #idempiere09:35
*** TurkerTunali has joined #idempiere09:43
*** hieplq has quit IRC09:46
*** norbertbede has quit IRC10:08
TurkerTunalihello10:26
TurkerTunalihello red110:26
TurkerTunaliI am reviewing your wonderful jasper reports10:26
TurkerTunalithank you for the reports10:26
red1Thanks10:27
red1Is it useful?10:27
TurkerTunalidefinitely10:27
TurkerTunaliI may use it as a starting point for my reports10:27
TurkerTunalior I may use it as it is10:27
red1If you have good reports do share them too10:28
TurkerTunaliunfortunately I couldn't install it on our idempiere 2.0 instance. I think it needs 2.110:28
red1Next step is to make them hyperlink to online page10:28
TurkerTunaliI am planning to create some reports for invoices and orders today. I will share if it is useful.10:29
TurkerTunaliHow can I share my reports? Should I use wiki.idempiere.org?10:29
red1Did I upload them during 2.1?10:30
red1You can send to me to test and I will publish for you10:30
TurkerTunalimost probably you use it under 2.110:31
TurkerTunaliI get "Missing Constraint: Require-Bundle: org.adempiere.plugin.utils; bundle-version="2.1.0" error10:31
red1And give credits if it's nice10:31
TurkerTunaliI have 2.0.0 for that plugin10:31
TurkerTunalibundle10:31
red1Ash you can since that in the MF file10:31
red1You can edit10:32
TurkerTunaliI've thought that too, but then how can I compile a jar file those files?10:32
TurkerTunaliI have a long way for that, I will start from simple things :)10:34
TurkerTunaliI want to ask you another question regarding to Libero, if you are free for a minute?10:34
*** Not-93d5 has joined #idempiere10:36
Not-93d5[IDEMPIERE] tbayen updated IDEMPIERE-64410:36
Not-93d5[IDEMPIERE] I would say that in the very most cases a database transaction should not run for so long. That eats up database resources and makes iDempiere noticable slower for other users. Apart from the technical facts I think that a user does not expect that just pressing a button (without a special warning or such) runs for longer than some minutes. Perhaps with the exception of looping through many records - but then he expects a progress bar and10:36
Not-93d5[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-64410:36
TurkerTunali@tbayen your opinon on IDEMPIERE-644 is the best one10:39
TurkerTunaliit should not exceed 5 minutes10:39
tbayenThanks. :-)10:40
tbayenBut I do not deserve credits for that. It it obvious. The credits are for the one who implements it without breaking anything. 8-o10:41
TurkerTunali:)10:41
TurkerTunaliyep10:41
red1Go ahead TurkerTunali10:43
TurkerTunaliwe want to use libero with in web interface on idempiere. I think there are some plugins for that10:44
TurkerTunaliare these useful?10:44
TurkerTunaliare these works as expected?10:46
TurkerTunaliI mean this plugin https://bitbucket.org/pshepetko/org.idempiere.liberomfg10:48
TurkerTunaliwe are studying libero on Chucks erp-academy website10:48
*** norbertbede has joined #idempiere10:51
*** red1 has quit IRC10:53
*** red1 has joined #idempiere10:53
*** ChanServ sets mode: +o red110:53
*** tbayen has quit IRC10:55
red1Mfg is never complete10:58
TurkerTunalican we discuss about which features are complete and which ones have some problems?11:13
*** norbertbede has quit IRC11:14
*** fares has joined #idempiere11:30
fareshi all   when i  using the easy install script i face aproblem  the  idempiere_install_script_master_linux.sh not working   this  is the output   HERE: User's home directory does not exist. Exiting! Will some day use /tmp/idempiere-installation-details/ instead!11:33
fareswhat  is the problem11:33
*** norbertbede has joined #idempiere11:36
*** hieplq has joined #idempiere11:49
fareshi all   when i  using the easy install script i face aproblem  the  idempiere_install_script_master_linux.sh not working   this  is the output   HERE: User's home directory does not exist. Exiting! Will some day use /tmp/idempiere-installation-details/ instead!12:00
fareswhat  is the problem12:00
TurkerTunali@fares do you use Chuck's install script or another one?12:04
TurkerTunaliI use Chuck's script on fresh ubuntu server, it works great12:04
faresyes12:17
faresi use it12:17
fares@TurkerTunali12:24
TurkerTunali@fares can you give exact location of the script which you are trying?12:30
TurkerTunali@red1 we have over 3 years of experience with manufacturing but with different ERP solutions.12:35
*** norbertbede has quit IRC12:37
faressudo apt-get -y update; sudo apt-get -y install mercurial; hg clone https://bitbucket.org/cboecking/idempiere-installation-script; chmod 766 idempiere-installation-script/*.sh; ./idempiere-installation-script/idempiere_install_script_master_linux.sh -B -u ubuntu -P Silly -l &>output.txt12:40
fareshttp://www.chuckboecking.com/blog/bid/296393/iDempiere-Open-Source-ERP-Linux-Installation-Really-Easy12:40
fares@TurkerTunali12:40
TurkerTunalido you have ubuntu folder12:50
TurkerTunalion home directory12:50
TurkerTunalior what is the current login name? @fares12:51
*** Deepak has joined #idempiere12:51
TurkerTunaliyou stated "my current login name is ubuntu and I have ubuntu folder on my home directory"  with that script12:51
TurkerTunaliyou should change -u option if you are using a different login name other than ubuntu12:52
*** smartjsp has joined #idempiere12:52
*** norbertbede has joined #idempiere12:53
faresi  using fares12:53
TurkerTunaliso you have a different user12:55
TurkerTunaliyou may use -u fares12:55
TurkerTunaliinstead of -u ubuntu12:55
TurkerTunaliand you should also specify password I think, you should check paramters12:55
TurkerTunalion that page12:55
fares@TurkerTunali   thank u     i will  do12:56
*** CarlosRuiz has joined #idempiere13:00
*** ChanServ sets mode: +o CarlosRuiz13:00
CarlosRuizGood Morning13:01
TurkerTunaligood morning13:14
TurkerTunaliis there anyone who user SmartPOS?13:14
CarlosRuizwell - smartjsp is the author13:19
CarlosRuizI'm reviewing https://idempiere.atlassian.net/browse/IDEMPIERE-64413:19
smartjspHi Turker ..13:19
smartjspYou can ask your smartpos questions within the sourceforge forums,  http://sourceforge.net/p/smart-pos/discussion/?source=navbar13:21
smartjspGood Morning everyone and Merry Christmas ...13:23
smartjspQuestion about how to propagate Idempiere AD changes (such as: messages, sysconfigs, menus, references and so on) from one instance (dev for example) to other one (prod)  ,,,is there any way to generate migration scripts (sql) for those changes ?.... currently we have them identified with an specific entity type  ...and currently we perform those changes manually... any suggestions ?13:29
smartjspour new SmartPOS 3.0 (OSGi plugin) requires a lot of AD changes (meesages, menus, references and so on) ... and in order to decouple the OSGi plugin as much as possible from an specific database, we want to include those AD changes , perhaps using apackin or sql scripts so the end users can get those new AD changes and SQL customizations within their Idempiere during the OSGi install ... then we are looking for a way to generate13:33
Deepakcarlos, Sorry was away13:34
DeepakI reopend IDEMPIERE-64413:34
DeepakAs the solution accepted was not good, We should have to come with better approach to manage active connections13:35
Deepak2 hours is quite big if Trx are not handled properly in some code and 2 hours is quite small for long running processes13:36
Deepaksmartjsp, Please note that iDempiere supports both migration scripts and 2pack, If your changes are going to be part of iDempiere core, it should be migrations script13:38
*** ocurieles_DCS has joined #idempiere13:38
DeepakIf you are writting module, you need to do 2pack and you can use iDempiere activator to auto apply 2packs on deploying plugins13:38
ocurieles_DCSHI boys13:39
smartjspthanks Deepak ..  in that case how can we generate the 2pack from the current non-standard AD objects ?  do we have any way to generate the xml files from specific entity types ?   we have seen packout option for menus, windows and tables for example, but not for messages, references for instance ? any suggestions ?13:41
Deepaksmarjsp, One esiest way to 2pack any data is export button on windows13:42
DeepakIt can export current window data as per filter condition in 2pack13:43
DeepakCarlos, ut?13:44
*** ocurieles_DCS has quit IRC13:44
smartjspperfect .. thanks Deepak...13:45
*** tomassvikruha has joined #idempiere13:48
CarlosRuizyes Deepak - making some changes to troubleshoot IDEMPIERE-64413:49
CarlosRuizDeepak, I made some changes to verify the behavior - make a process infinitely insert into t_selection table - set the trx timeout to 2 min and set the monitor timeout to verify every minute13:54
CarlosRuizresults are very bad  :-(13:54
CarlosRuizthe trx was closed by the TrxMonitor without any UI feedback13:54
CarlosRuizthe pending records were committed13:55
CarlosRuizand now the process is in a loop writing in the log13:55
*** hieplq has quit IRC13:55
CarlosRuiz"Transaction closed or never opened"13:55
CarlosRuizmore weird - the process insert with DB.executeUpdateEx - but exception is not raised13:57
DeepakCarlos, Exactly that what I pointed14:07
DeepakWhile opening this issue14:07
DeepakIt makes DB in consistant14:08
DeepakI am researching how we can make it to update m_startTime whenever connection is used, So we can set small time out like 10 minutes14:08
DeepakAnd it do not recover transactions untill it is in use14:09
CarlosRuizagree with you about setting priority to Critical - if it can cause data corruption14:11
CarlosRuizfirstly we need to solve that - it must rollback - I'm checking with a new Trx.rollbackAndClose() ... looking for the results14:11
DeepakI am thinking that we should update M_start time on getConnection()14:12
DeepakSo it is always latestly used14:13
CarlosRuizalso - we must check the behavior if the process is ran in background14:13
Deepakbut my worry is some code use like conn = trx.getConnection(); like 2pack code14:13
Deepakcarlos, Trx.rollbackAndClose() will not make DB inconsistent, but some of process never able to finish14:16
DeepakSo that is another issue we may have14:16
CarlosRuizyes - but that's a different issue - the Critical thing is the data inconsistency14:17
CarlosRuizfor the process not finishing there are workarounds14:17
DeepakAlso Carlos, we need to throw exception or log sever level so user notice what is going wrong14:20
CarlosRuiznote also the same process can run in 1 minute in a tenant - and 2 hours in a different tenant - because of data volume - so setting a timeout per process maybe is not the best14:20
DeepakI am not agree with time out per process thought14:20
DeepakBut those are Hengsin's view14:21
DeepakIf we are not handling trx properly, it may cause trx pool to consumed withing 30 minutes, then no way to wait for 2 hours14:21
DeepakOnly what is good parameter to consider expire is based on last access time14:22
DeepakAnd short timeout line 5-10 minutes14:22
CarlosRuizalso - wondering what happen when a db trx is running and the UI session timeout?14:24
DeepakOne of dev in our team has that observation with Adempiere or compiere, but my observation with iDempiere says process keep running in background14:28
DeepakWe are getting this issue after 2 hours when running import inventory while we have 1 hour session time out, that is enough to say that UI timeout is not causing process to stops14:29
DeepakYes, but there will be exception at end of finishing of process when process dialog try to unlock14:30
DeepakCarlos, would you like this concept? despite fix you are making for roleback and close, Lets try to reset m_starttime whenever getConnection, commit, rollback methods on Trx getting called14:33
DeepakChanging timeout to be small like 10 minutes14:33
CarlosRuizI'm not sure - maybe is not good - in such case you can have processes running for 100 hours14:33
DeepakManaging process is different then Trx14:34
DeepakIn case of process, we may have to add process management to kill wrong running process in safe manner14:35
CarlosRuizif you need such long running process - then you can apply the workaround to that specific process14:35
CarlosRuizI think the default timeout must be restrictive - and you make it permissive with workarounds - not making the default permissive14:36
CarlosRuizjust found that closing the transaction raises a fireAfterCloseEvent - calling the TrxEventListener - but SvrProcess is not listening to that14:37
CarlosRuizso - I implemented rollback - but it doesn't work well - as the rollback happens - and the process keeps running in "autocommit" mode14:37
CarlosRuizBTW guys - I started logging IRC all day and publishing it here14:38
CarlosRuizhttp://www.globalqss.com/idempiere/irclog/14:38
CarlosRuizso :-)  be careful with what you say  - don't put passwords or sensitive information here14:39
DeepakThen all process need to change to listen to trx timeout and need to take need full action14:39
CarlosRuizand if you write mail addresses here - then you could expect some spam14:39
CarlosRuizyes Deepak - I think SvrProcess must do that14:40
DeepakCarlos, Are you going to commit that?14:53
CarlosRuizno - testing here - I'll add a patch with comments14:53
CarlosRuizI'm going out soon for christmas - so, at least I'll put a WIP patch14:54
*** tomassvikruha has quit IRC14:55
red1Merry Christmas CarlosRuiz14:56
red1And everyone else14:57
CarlosRuizsame for you red1 - and merry christmas to all you guys14:57
DeepakMarry Christmas to all14:57
norbertbedesame from slovakia :)14:58
Not-93d5[IDEMPIERE] norbert.bede updated IDEMPIERE-64415:00
Not-93d5[IDEMPIERE] Please consider the next idea, when fixing this issue: https://idempiere.atlassian.net/browse/IDEMPIERE-197515:00
Not-93d5[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-64415:00
*** Deepak has quit IRC15:01
*** Deepak has joined #idempiere15:01
Not-93d5[IDEMPIERE] deepak updated IDEMPIERE-197515:06
Not-93d5[IDEMPIERE] Norbets, Adding this support needs huge re-factoring as all process need to support same.15:06
Not-93d5[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-197515:06
*** hieplq has joined #idempiere15:13
*** norbertbede1 has joined #idempiere15:18
*** norbertbede has quit IRC15:19
*** Deepak has quit IRC15:20
*** norbertbede has joined #idempiere15:21
*** norbertbede1 has quit IRC15:24
Not-93d5[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-644 Attachment set to "IDEMPIERE-644_ToTest.patch"15:27
Not-93d5[IDEMPIERE] Hi, I'm attaching two patches. IDEMPIERE-644_v1.patch * Rollback and close the transaction when there is a commit * DB.verifyTrx was changed to raise an exception if a transaction is not found (previously it just logged a message saying that works as autocommit) - this can have collateral consequences on wrongly written processes - but I think is a must to guarantee data consistency IDEMPIERE-644_ToTest.patch * Changes the trx timeout to 215:27
Not-93d5[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-64415:27
edilsondnetoMarry Christmas to all15:27
CarlosRuizready - patches posted in JIRA - thanks guys - merry christmas - I'm going out - c u then15:28
*** CarlosRuiz has quit IRC15:28
*** edilsondneto has quit IRC15:28
*** banym has quit IRC15:31
*** smartjsp has quit IRC15:39
*** TurkerTunali has left #idempiere15:43
*** norbertbede has quit IRC16:01
*** KermitTheFragger has quit IRC16:08
hieplqI hear about how to control model at plug-in in. I read book from @red and I thinking. Deco pattern is suitable. any ideas16:25
hieplqonly smart change at general model, but make plug-in easy controls model object16:28
*** hieplq has quit IRC17:52
*** felipedex has joined #idempiere18:01
*** fares has quit IRC19:15
*** fares has joined #idempiere19:41
fareshello  all19:41
fareswhere  can i found  the  arabic  lang  files19:42
fareshow   can i  make  new  lang  files in idempiere19:44
a42niemin system client enable the desired language and use language export19:52
a42niemand have a look into the wiki :)19:52
a42niemposde: frohes fest!19:53
faresi want  to translate it  to arabic   is  there  any  tool  using  for   read  the  xml files   for  insert  the  translate19:57
fares @a42niem     what you mean   ( posde: frohes fest!)20:04
posdea42niem, danke20:07
posdea42niem, gleichfalls. Ich hoffe, der Weihnachtsmann war fleißig20:07
*** fares has quit IRC20:51

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