*** hieplq has joined #idempiere | 00:14 | |
*** a42niem_ has quit IRC | 00:51 | |
*** a42niem has quit IRC | 00:51 | |
*** hieplq has quit IRC | 02:03 | |
*** norbertbede has joined #idempiere | 04:35 | |
Not-2487 | [IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-2370 SaaS Generate on menu option | 04:49 |
---|---|---|
Not-2487 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2370 | 04: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 option | 04: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-2370 | 04:50 |
*** CarlosRuiz has quit IRC | 04:54 | |
*** norbertbede has quit IRC | 04:54 | |
*** norbertbede has joined #idempiere | 05:40 | |
*** mbilalilyas has joined #idempiere | 06:28 | |
mbilalilyas | hello 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_selection | 06:31 |
*** norbertbede has quit IRC | 06:38 | |
Not-2487 | [IDEMPIERE] deepak updated IDEMPIERE-644 | 06: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-644 | 06:45 |
Not-2487 | [IDEMPIERE] deepak updated IDEMPIERE-644 | 06: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_process | 06:48 |
Not-2487 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-644 | 06:48 |
*** norbertbede has joined #idempiere | 06:52 | |
*** mbilalilyas has quit IRC | 07:05 | |
*** hieplq has joined #idempiere | 07:34 | |
*** a42niem has joined #idempiere | 08:17 | |
*** norbertbede has quit IRC | 08:42 | |
*** red1 has joined #idempiere | 08:46 | |
*** ChanServ sets mode: +o red1 | 08: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 page | 09:19 |
Not-2487 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2367 | 09: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-2367 | 09: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 window | 09:22 |
Not-2487 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2230 | 09:22 |
*** Not-2487 has quit IRC | 09:26 | |
*** norbertbede has joined #idempiere | 09:31 | |
*** KermitTheFragger has joined #idempiere | 09:35 | |
*** TurkerTunali has joined #idempiere | 09:43 | |
*** hieplq has quit IRC | 09:46 | |
*** norbertbede has quit IRC | 10:08 | |
TurkerTunali | hello | 10:26 |
TurkerTunali | hello red1 | 10:26 |
TurkerTunali | I am reviewing your wonderful jasper reports | 10:26 |
TurkerTunali | thank you for the reports | 10:26 |
red1 | Thanks | 10:27 |
red1 | Is it useful? | 10:27 |
TurkerTunali | definitely | 10:27 |
TurkerTunali | I may use it as a starting point for my reports | 10:27 |
TurkerTunali | or I may use it as it is | 10:27 |
red1 | If you have good reports do share them too | 10:28 |
TurkerTunali | unfortunately I couldn't install it on our idempiere 2.0 instance. I think it needs 2.1 | 10:28 |
red1 | Next step is to make them hyperlink to online page | 10:28 |
TurkerTunali | I am planning to create some reports for invoices and orders today. I will share if it is useful. | 10:29 |
TurkerTunali | How can I share my reports? Should I use wiki.idempiere.org? | 10:29 |
red1 | Did I upload them during 2.1? | 10:30 |
red1 | You can send to me to test and I will publish for you | 10:30 |
TurkerTunali | most probably you use it under 2.1 | 10:31 |
TurkerTunali | I get "Missing Constraint: Require-Bundle: org.adempiere.plugin.utils; bundle-version="2.1.0" error | 10:31 |
red1 | And give credits if it's nice | 10:31 |
TurkerTunali | I have 2.0.0 for that plugin | 10:31 |
TurkerTunali | bundle | 10:31 |
red1 | Ash you can since that in the MF file | 10:31 |
red1 | You can edit | 10:32 |
TurkerTunali | I've thought that too, but then how can I compile a jar file those files? | 10:32 |
TurkerTunali | I have a long way for that, I will start from simple things :) | 10:34 |
TurkerTunali | I want to ask you another question regarding to Libero, if you are free for a minute? | 10:34 |
*** Not-93d5 has joined #idempiere | 10:36 | |
Not-93d5 | [IDEMPIERE] tbayen updated IDEMPIERE-644 | 10: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 and | 10:36 |
Not-93d5 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-644 | 10:36 |
TurkerTunali | @tbayen your opinon on IDEMPIERE-644 is the best one | 10:39 |
TurkerTunali | it should not exceed 5 minutes | 10:39 |
tbayen | Thanks. :-) | 10:40 |
tbayen | But I do not deserve credits for that. It it obvious. The credits are for the one who implements it without breaking anything. 8-o | 10:41 |
TurkerTunali | :) | 10:41 |
TurkerTunali | yep | 10:41 |
red1 | Go ahead TurkerTunali | 10:43 |
TurkerTunali | we want to use libero with in web interface on idempiere. I think there are some plugins for that | 10:44 |
TurkerTunali | are these useful? | 10:44 |
TurkerTunali | are these works as expected? | 10:46 |
TurkerTunali | I mean this plugin https://bitbucket.org/pshepetko/org.idempiere.liberomfg | 10:48 |
TurkerTunali | we are studying libero on Chucks erp-academy website | 10:48 |
*** norbertbede has joined #idempiere | 10:51 | |
*** red1 has quit IRC | 10:53 | |
*** red1 has joined #idempiere | 10:53 | |
*** ChanServ sets mode: +o red1 | 10:53 | |
*** tbayen has quit IRC | 10:55 | |
red1 | Mfg is never complete | 10:58 |
TurkerTunali | can we discuss about which features are complete and which ones have some problems? | 11:13 |
*** norbertbede has quit IRC | 11:14 | |
*** fares has joined #idempiere | 11:30 | |
fares | hi 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 |
fares | what is the problem | 11:33 |
*** norbertbede has joined #idempiere | 11:36 | |
*** hieplq has joined #idempiere | 11:49 | |
fares | hi 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 |
fares | what is the problem | 12:00 |
TurkerTunali | @fares do you use Chuck's install script or another one? | 12:04 |
TurkerTunali | I use Chuck's script on fresh ubuntu server, it works great | 12:04 |
fares | yes | 12:17 |
fares | i use it | 12:17 |
fares | @TurkerTunali | 12: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 IRC | 12:37 | |
fares | sudo 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.txt | 12:40 |
fares | http://www.chuckboecking.com/blog/bid/296393/iDempiere-Open-Source-ERP-Linux-Installation-Really-Easy | 12:40 |
fares | @TurkerTunali | 12:40 |
TurkerTunali | do you have ubuntu folder | 12:50 |
TurkerTunali | on home directory | 12:50 |
TurkerTunali | or what is the current login name? @fares | 12:51 |
*** Deepak has joined #idempiere | 12:51 | |
TurkerTunali | you stated "my current login name is ubuntu and I have ubuntu folder on my home directory" with that script | 12:51 |
TurkerTunali | you should change -u option if you are using a different login name other than ubuntu | 12:52 |
*** smartjsp has joined #idempiere | 12:52 | |
*** norbertbede has joined #idempiere | 12:53 | |
fares | i using fares | 12:53 |
TurkerTunali | so you have a different user | 12:55 |
TurkerTunali | you may use -u fares | 12:55 |
TurkerTunali | instead of -u ubuntu | 12:55 |
TurkerTunali | and you should also specify password I think, you should check paramters | 12:55 |
TurkerTunali | on that page | 12:55 |
fares | @TurkerTunali thank u i will do | 12:56 |
*** CarlosRuiz has joined #idempiere | 13:00 | |
*** ChanServ sets mode: +o CarlosRuiz | 13:00 | |
CarlosRuiz | Good Morning | 13:01 |
TurkerTunali | good morning | 13:14 |
TurkerTunali | is there anyone who user SmartPOS? | 13:14 |
CarlosRuiz | well - smartjsp is the author | 13:19 |
CarlosRuiz | I'm reviewing https://idempiere.atlassian.net/browse/IDEMPIERE-644 | 13:19 |
smartjsp | Hi Turker .. | 13:19 |
smartjsp | You can ask your smartpos questions within the sourceforge forums, http://sourceforge.net/p/smart-pos/discussion/?source=navbar | 13:21 |
smartjsp | Good Morning everyone and Merry Christmas ... | 13:23 |
smartjsp | Question 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 |
smartjsp | our 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 generate | 13:33 |
Deepak | carlos, Sorry was away | 13:34 |
Deepak | I reopend IDEMPIERE-644 | 13:34 |
Deepak | As the solution accepted was not good, We should have to come with better approach to manage active connections | 13:35 |
Deepak | 2 hours is quite big if Trx are not handled properly in some code and 2 hours is quite small for long running processes | 13:36 |
Deepak | smartjsp, 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 script | 13:38 |
*** ocurieles_DCS has joined #idempiere | 13:38 | |
Deepak | If you are writting module, you need to do 2pack and you can use iDempiere activator to auto apply 2packs on deploying plugins | 13:38 |
ocurieles_DCS | HI boys | 13:39 |
smartjsp | thanks 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 |
Deepak | smarjsp, One esiest way to 2pack any data is export button on windows | 13:42 |
Deepak | It can export current window data as per filter condition in 2pack | 13:43 |
Deepak | Carlos, ut? | 13:44 |
*** ocurieles_DCS has quit IRC | 13:44 | |
smartjsp | perfect .. thanks Deepak... | 13:45 |
*** tomassvikruha has joined #idempiere | 13:48 | |
CarlosRuiz | yes Deepak - making some changes to troubleshoot IDEMPIERE-644 | 13:49 |
CarlosRuiz | Deepak, 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 minute | 13:54 |
CarlosRuiz | results are very bad :-( | 13:54 |
CarlosRuiz | the trx was closed by the TrxMonitor without any UI feedback | 13:54 |
CarlosRuiz | the pending records were committed | 13:55 |
CarlosRuiz | and now the process is in a loop writing in the log | 13:55 |
*** hieplq has quit IRC | 13:55 | |
CarlosRuiz | "Transaction closed or never opened" | 13:55 |
CarlosRuiz | more weird - the process insert with DB.executeUpdateEx - but exception is not raised | 13:57 |
Deepak | Carlos, Exactly that what I pointed | 14:07 |
Deepak | While opening this issue | 14:07 |
Deepak | It makes DB in consistant | 14:08 |
Deepak | I am researching how we can make it to update m_startTime whenever connection is used, So we can set small time out like 10 minutes | 14:08 |
Deepak | And it do not recover transactions untill it is in use | 14:09 |
CarlosRuiz | agree with you about setting priority to Critical - if it can cause data corruption | 14:11 |
CarlosRuiz | firstly we need to solve that - it must rollback - I'm checking with a new Trx.rollbackAndClose() ... looking for the results | 14:11 |
Deepak | I am thinking that we should update M_start time on getConnection() | 14:12 |
Deepak | So it is always latestly used | 14:13 |
CarlosRuiz | also - we must check the behavior if the process is ran in background | 14:13 |
Deepak | but my worry is some code use like conn = trx.getConnection(); like 2pack code | 14:13 |
Deepak | carlos, Trx.rollbackAndClose() will not make DB inconsistent, but some of process never able to finish | 14:16 |
Deepak | So that is another issue we may have | 14:16 |
CarlosRuiz | yes - but that's a different issue - the Critical thing is the data inconsistency | 14:17 |
CarlosRuiz | for the process not finishing there are workarounds | 14:17 |
Deepak | Also Carlos, we need to throw exception or log sever level so user notice what is going wrong | 14:20 |
CarlosRuiz | note 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 best | 14:20 |
Deepak | I am not agree with time out per process thought | 14:20 |
Deepak | But those are Hengsin's view | 14:21 |
Deepak | If we are not handling trx properly, it may cause trx pool to consumed withing 30 minutes, then no way to wait for 2 hours | 14:21 |
Deepak | Only what is good parameter to consider expire is based on last access time | 14:22 |
Deepak | And short timeout line 5-10 minutes | 14:22 |
CarlosRuiz | also - wondering what happen when a db trx is running and the UI session timeout? | 14:24 |
Deepak | One of dev in our team has that observation with Adempiere or compiere, but my observation with iDempiere says process keep running in background | 14:28 |
Deepak | We 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 stops | 14:29 |
Deepak | Yes, but there will be exception at end of finishing of process when process dialog try to unlock | 14:30 |
Deepak | Carlos, 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 called | 14:33 |
Deepak | Changing timeout to be small like 10 minutes | 14:33 |
CarlosRuiz | I'm not sure - maybe is not good - in such case you can have processes running for 100 hours | 14:33 |
Deepak | Managing process is different then Trx | 14:34 |
Deepak | In case of process, we may have to add process management to kill wrong running process in safe manner | 14:35 |
CarlosRuiz | if you need such long running process - then you can apply the workaround to that specific process | 14:35 |
CarlosRuiz | I think the default timeout must be restrictive - and you make it permissive with workarounds - not making the default permissive | 14:36 |
CarlosRuiz | just found that closing the transaction raises a fireAfterCloseEvent - calling the TrxEventListener - but SvrProcess is not listening to that | 14:37 |
CarlosRuiz | so - I implemented rollback - but it doesn't work well - as the rollback happens - and the process keeps running in "autocommit" mode | 14:37 |
CarlosRuiz | BTW guys - I started logging IRC all day and publishing it here | 14:38 |
CarlosRuiz | http://www.globalqss.com/idempiere/irclog/ | 14:38 |
CarlosRuiz | so :-) be careful with what you say - don't put passwords or sensitive information here | 14:39 |
Deepak | Then all process need to change to listen to trx timeout and need to take need full action | 14:39 |
CarlosRuiz | and if you write mail addresses here - then you could expect some spam | 14:39 |
CarlosRuiz | yes Deepak - I think SvrProcess must do that | 14:40 |
Deepak | Carlos, Are you going to commit that? | 14:53 |
CarlosRuiz | no - testing here - I'll add a patch with comments | 14:53 |
CarlosRuiz | I'm going out soon for christmas - so, at least I'll put a WIP patch | 14:54 |
*** tomassvikruha has quit IRC | 14:55 | |
red1 | Merry Christmas CarlosRuiz | 14:56 |
red1 | And everyone else | 14:57 |
CarlosRuiz | same for you red1 - and merry christmas to all you guys | 14:57 |
Deepak | Marry Christmas to all | 14:57 |
norbertbede | same from slovakia :) | 14:58 |
Not-93d5 | [IDEMPIERE] norbert.bede updated IDEMPIERE-644 | 15:00 |
Not-93d5 | [IDEMPIERE] Please consider the next idea, when fixing this issue: https://idempiere.atlassian.net/browse/IDEMPIERE-1975 | 15:00 |
Not-93d5 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-644 | 15:00 |
*** Deepak has quit IRC | 15:01 | |
*** Deepak has joined #idempiere | 15:01 | |
Not-93d5 | [IDEMPIERE] deepak updated IDEMPIERE-1975 | 15: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-1975 | 15:06 |
*** hieplq has joined #idempiere | 15:13 | |
*** norbertbede1 has joined #idempiere | 15:18 | |
*** norbertbede has quit IRC | 15:19 | |
*** Deepak has quit IRC | 15:20 | |
*** norbertbede has joined #idempiere | 15:21 | |
*** norbertbede1 has quit IRC | 15: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 2 | 15:27 |
Not-93d5 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-644 | 15:27 |
edilsondneto | Marry Christmas to all | 15:27 |
CarlosRuiz | ready - patches posted in JIRA - thanks guys - merry christmas - I'm going out - c u then | 15:28 |
*** CarlosRuiz has quit IRC | 15:28 | |
*** edilsondneto has quit IRC | 15:28 | |
*** banym has quit IRC | 15:31 | |
*** smartjsp has quit IRC | 15:39 | |
*** TurkerTunali has left #idempiere | 15:43 | |
*** norbertbede has quit IRC | 16:01 | |
*** KermitTheFragger has quit IRC | 16:08 | |
hieplq | I hear about how to control model at plug-in in. I read book from @red and I thinking. Deco pattern is suitable. any ideas | 16:25 |
hieplq | only smart change at general model, but make plug-in easy controls model object | 16:28 |
*** hieplq has quit IRC | 17:52 | |
*** felipedex has joined #idempiere | 18:01 | |
*** fares has quit IRC | 19:15 | |
*** fares has joined #idempiere | 19:41 | |
fares | hello all | 19:41 |
fares | where can i found the arabic lang files | 19:42 |
fares | how can i make new lang files in idempiere | 19:44 |
a42niem | in system client enable the desired language and use language export | 19:52 |
a42niem | and have a look into the wiki :) | 19:52 |
a42niem | posde: frohes fest! | 19:53 |
fares | i want to translate it to arabic is there any tool using for read the xml files for insert the translate | 19:57 |
fares | @a42niem what you mean ( posde: frohes fest!) | 20:04 |
posde | a42niem, danke | 20:07 |
posde | a42niem, gleichfalls. Ich hoffe, der Weihnachtsmann war fleißig | 20:07 |
*** fares has quit IRC | 20:51 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!