#idempiere IRC log for Thursday, 2015-10-01

*** xapiens has quit IRC01:18
*** xapiens has joined #idempiere02:34
*** silphium has joined #idempiere03:52
*** tsvikruha has joined #idempiere04:41
*** tsvikruha1 has joined #idempiere04:49
*** tsvikruha has quit IRC04:53
*** xapiens has quit IRC05:13
*** nmicoud has joined #idempiere05:14
Not-6e26[IDEMPIERE] tsvikruha updated IDEMPIERE-286406:35
Not-6e26[IDEMPIERE] And what If we just remove deleting of temporary AttachmentFileSystem and OS would become only responsible for deleting files? Because these files are dropped automatically by OS, we don't need to care about it. So if we don't create temp files in other directories, everything should be fine, or am I wrong? Only use case which comes to my mind is what if more processes will try to create temp file with06:35
Not-6e26same name and try to work with it? Is this even possible?06:35
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-286406:35
*** KermitTheFragger has joined #idempiere06:42
*** tsvikruha1 has quit IRC06:54
*** tsvikruha has joined #idempiere07:05
*** nmicoud_ has joined #idempiere07:34
*** nmicoud has quit IRC07:35
*** tsvikruha has quit IRC07:35
*** tsvikruha has joined #idempiere07:44
*** tsvikruha has quit IRC07:55
*** tsvikruha has joined #idempiere07:56
*** a42niem has joined #idempiere08:23
*** mbozem has joined #idempiere08:42
*** mbozem has quit IRC09:22
Not-6e26[IDEMPIERE] ngordon7000 created IDEMPIERE-2872 Info Window: Allow multi-select behaviour to be configurable without using code09:22
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287209:22
Not-6e26[IDEMPIERE] ngordon7000 updated IDEMPIERE-2872 Attachment set to "Selection_052.png"09:23
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287209:23
Not-6e26[IDEMPIERE] ngordon7000 updated IDEMPIERE-2872 Attachment set to "Selection_054.png"09:26
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287209:26
*** tsvikruha has quit IRC10:37
*** mbozem has joined #idempiere10:44
*** CarlosRuiz has joined #idempiere11:40
*** ChanServ sets mode: +o CarlosRuiz11:40
*** natozaba has joined #idempiere12:02
*** natozaba has quit IRC12:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-286412:08
Not-6e26[IDEMPIERE] Yes [~tsvikruha], your solution is ok too, confirmed that's the behavior of AttachmentDBSystem. Also saw that finishing the OSGi JVM is not deleting the temp files, so maybe is good to do the cleanup at least on the AlertProcessor and Scheduler. Regards, Carlos Ruiz12:08
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-286412:08
*** a42niem has quit IRC12:19
*** JFK has joined #idempiere12:48
JFKhi?12:48
*** David________ has joined #idempiere12:55
*** JFK has quit IRC12:57
*** David________ has quit IRC12:57
*** druiz has joined #idempiere13:22
*** mbozem has quit IRC13:36
Not-6e26[iDempiere] CarlosRuiz_globalqss pushed 1 commit to development [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/14:41
Not-6e26[iDempiere] druiz_bxservice 1c906c4 - IDEMPIERE-2871 Import CSV process not returning log file when run via web services14:41
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2871 status set to "Resolved" -resolution set to "Fixed"14:41
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287114:41
Not-6e26[iDempiere] jenkins built #1742 completed (success) http://ci.idempiere.org/job/iDempiere/1742/14:52
*** jbwiv has joined #idempiere14:54
*** mbozem has joined #idempiere14:59
*** druiz has quit IRC15:03
jbwivCarlosRuiz: you around? I'm finally working on the Vagrant config for idempiere again and have a question15:12
jbwivi'm running the build now but it will take a few more minutes before I have the error I'm getting15:12
*** KermitTheFragger has quit IRC15:21
CarlosRuizHi jbwiv15:22
*** david________ has joined #idempiere15:22
jbwivhello15:22
david________hi all need help?15:22
jbwivsorry, still waiting on the hg clone15:22
david________where i can find information about this erp?15:23
jbwivessentially, I get to the end of the build and it complains of a lack of a compatible java 1.6 runtime15:23
jbwivCarlosRuiz: even though I have openjdk-6 installed15:23
jbwivthe clone is taking forever though15:23
jbwiveven local15:24
jbwivcloning a local repo15:24
CarlosRuizit depends on the version you're compiling15:24
CarlosRuiz2.1 requires java615:24
jbwivCarlosRuiz: release-2.115:24
CarlosRuizbut 3 requires java715:24
*** david________ has quit IRC15:24
jbwivCarlosRuiz: which is considered stable?15:24
CarlosRuizah - was answering to david and he left15:24
CarlosRuiz2.115:24
jbwivlol....yeah, he didn't seem to want to wait very long15:25
jbwivCarlosRuiz: I installed openjdk-6-jre and openjdk-6-jdk and i still get the error15:25
jbwivif this clone would hurry and finish I could give it to you. one sec15:25
jbwivCarlosRuiz: ok, clone finished. should be just one more minute if you're still around15:31
jbwivor not. something else is broken now :(15:44
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-2811 Attachment set to "primary key steps 02.sql"15:58
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281115:58
*** nmicoud_ has quit IRC16:09
jbwivCarlosRuiz: I'm getting errors now like "==> default: !MESSAGE org.eclipse.swt.win32.win32.x86:osgi.bundle(&(target.arch=x86)(target.os=win32)(target.ws=win32)): No provider was found that could resolve the request". do you know what would cause this?16:27
jbwivCarlosRuiz: actually, I think that was an error that could be ignored16:30
jbwivhowever, this is the 1.6 error I was talking about "==> default: Warning: file /opt/idempiere-source/org.adempiere.ui.zk: Build path specifies execution environment JavaSE-1.6. There are no JREs installed in the workspace that are strictly compatible with this environment. "16:30
jbwivCarlosRuiz: so does this mean I *have* to use Oracle's jdk?16:31
jbwivbecause I end up getting no zip file at the and of all the steps in "Building_iDempiere_without_Eclipse"16:33
jbwivChuckBoecking: would you happen to know?16:33
jbwiv(btw, I'm a paying member of your class ;)16:34
ChuckBoeckingLet me get caught up...16:34
jbwivChuckBoecking: I'm trying to create a Vagrantfile so that one can simply use this recipe to create an idempiere server vm with Vagrant16:35
jbwivin one simple step16:35
jbwivhowever, I'm getting to the end of the process, but the zip isn't created16:35
jbwivI'll pastebin the final step output in a one moment16:36
ChuckBoeckingthe vagrant image will have iDempiere materialized in eclipse?16:37
jbwivChuckBoecking: here's the pastebin16:38
jbwivChuckBoecking: I'm actually following the instructions for building without eclipse16:39
jbwivFound here: http://wiki.idempiere.org/en/Building_iDempiere_without_Eclipse16:39
jbwivsince Vagrant operates in a headless mode16:39
ChuckBoeckingwhy build? Why not just pull from a jenkins server where the binaries are already created?16:39
jbwivChuckBoecking: just thought it would be "purer" this way16:40
jbwivI might switch to pulling the jenkins binaries16:40
jbwivthat said it'd be nice to have the vm with source and build environment16:40
ChuckBoeckinghere are my thoughts: (1) the build process introduces time/delay, (2) it adds a level of complexity. Most of the time iDempiere will build without issue; however, not always.16:41
jbwivChuckBoecking: right. however, I'd really like to get at least *one* successful build ;-)16:41
jbwivI'm buildling on the release-2.1 branch16:41
ChuckBoeckingThe reason i created my jenkins servers is so that I could always have access to build.16:42
jbwivas I understand it, that should be stable16:42
ChuckBoeckingI would ask Carlos for access to the community jenkins server and look at his build steps. Jenkins builds iDempiere headlessly.16:42
jbwivChuckBoecking: right. I guess my thoughts are if I do this right, as long as the hg repo exists (or you have it locally) you can materialize the erp16:42
jbwivCarlosRuiz: could you allow this?16:42
ChuckBoeckingThis will provide you with a step by step account of how he builds iDempiere.16:43
jbwivChuckBoecking: good idea. as far as I can tell I'm following the wiki docs to a tee16:43
ChuckBoeckingIt will also show you the script to create an updated DB seed file.16:43
ChuckBoeckingAs it is, the seed in the repo is 12 months old16:43
jbwivand I don't see any errors in my build output, just those 1.6 warnings16:45
CarlosRuizjbwiv, looks like warnings16:45
jbwivCarlosRuiz: right, yet no zip file is produced in /tmp/buckminster16:45
CarlosRuizr u compiling in linux - because the "no provider"  is for a win file16:46
jbwivCarlosRuiz: yes, I'm compiling on debian 816:46
jbwivCarlosRuiz: following these instructions: http://wiki.idempiere.org/en/Building_iDempiere_without_Eclipse16:46
CarlosRuizlong time I don't try that16:47
jbwivCarlosRuiz: could you share your jenkins build process?16:47
jbwivCarlosRuiz: I really think having a Vagrant file available would be a win for the community16:48
CarlosRuizhow does that work?16:49
jbwivCarlosRuiz: the Vagrantfile is a recipe file16:49
CarlosRuiza user has a vagrant file - and when "executes" it - then all the steps are executed like a script?16:49
CarlosRuizso - it will do the "hg clone" (very probable to fail)16:49
CarlosRuizand then configure eclipse?16:49
jbwivwith one command "vagrant up" it will automatically download a debian image, install all the dependencies, and build a working Idempiere vm16:49
jbwivyes, they're executed in sequence like a script16:50
jbwivi'll share what i have so far16:50
CarlosRuizjbwiv, I like what you're doing as a research16:50
CarlosRuizbut I doubt it will be useful in the end16:50
CarlosRuizbecause the "hg clone" is very prone to fail16:50
CarlosRuizand the buckminster / director / etc - also16:51
jbwivhere's what I have: http://pastebin.com/mQeEXFrn16:51
jbwivCarlosRuiz: yes, I'm using a local hg repo16:51
jbwivbecause I was facing failures from bitbicket16:51
jbwivbitbucket16:51
jbwivbut I was able to download it once16:52
CarlosRuiznot that I want to discourage you - but it will be a stopper16:52
jbwivlook towards the bottom of that file for the steps16:52
jbwivCarlosRuiz: provided a user of the script first downloads the hg repo and runs hg serve locally, it will work16:52
jbwivso I'm not too concerned about that16:52
jbwivwe use a lot of Vagrant here to provision to both virtualbox (for dev) and kvm (for prod)16:53
jbwivif I can just get working build steps16:53
jbwivbut ChuckBoecking suggested the Jenkins steps you use would be more appopriate, plus it would give me insight regarding how to get to an updated schema16:54
jbwivdb seed16:54
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-2811 Attachment set to "IDEMPIERE-2811-Each-Record-Primary-Key.patch"16:54
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281116:54
jbwivCarlosRuiz: does that make sense? any chance you would share your jenkins build steps?16:56
CarlosRuizI can create a user for you in jenkins16:57
jbwivCarlosRuiz: that would be great, thank you16:57
CarlosRuiz:-) asking you your data in a private window here16:58
jbwivah sorry, k16:58
CarlosRuizChuckBoecking, thanks a lot for the wiki pages - great117:01
CarlosRuizgreat!17:01
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2175 status set to "Closed"17:03
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-217517:03
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2745 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274517:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2756 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-275617:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1966 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-196617:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2671 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-267117:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2774 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277417:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2765 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-276517:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1379 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-137917:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2768 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-276817:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2568 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-256817:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2778 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277817:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2764 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-276417:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1618 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-161817:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2790 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-279017:04
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2771 status set to "Closed"17:04
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277117:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2748 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274817:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2675 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-267517:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2779 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277917:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2766 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-276617:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2757 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-275717:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2786 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278617:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2461 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-246117:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2776 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277617:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2773 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277317:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2780 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278017:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2762 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-276217:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2752 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-275217:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2672 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-267217:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2775 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277517:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2789 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278917:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2787 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278717:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2781 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278117:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2296 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-229617:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2783 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278317:05
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1459 status set to "Closed"17:05
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-145917:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2557 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-255717:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2488 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-248817:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2479 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-247917:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2314 status set to "Closed"17:06
jbwivCarlosRuiz: so the appropriate steps are in iDempiere2.1Daily?17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-231417:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-979 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-97917:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2747 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274717:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2230 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-223017:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2751 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-275117:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2508 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-250817:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2742 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274217:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2770 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-277017:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2731 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-273117:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2470 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-247017:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2367 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-236717:06
ChuckBoeckingMy pleasure!!17:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2788 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-278817:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2749 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274917:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2746 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-274617:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2138 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-213817:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2797 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-279717:06
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2792 status set to "Closed"17:06
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-279217:07
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1338 status set to "Closed"17:07
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-133817:07
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2658 status set to "Closed"17:07
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-265817:07
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2755 status set to "Closed"17:07
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-275517:07
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1969 status set to "Closed"17:07
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-196917:07
*** mbozem has quit IRC17:09
ChuckBoeckingMy Pleasure!!17:12
jbwivChuckBoecking: CarlosRuiz: does this mean anything to either of you? http://pastebin.com/cz5jzqc217:14
CarlosRuizthis page can be clarifying17:14
CarlosRuizhttp://wiki.idempiere.org/en/Continuous_Integration17:14
jbwivCarlosRuiz: ok, i'll read that. also, it looks like two scripts are used to seed the db: /bin/bash /home/carlos/iDempiereSeed21Pg.sh and /bin/bash /home/carlos/iDempiereSeed21Or.sh (in the case of oracle). are these accessible anywhere?17:15
jbwivCarlosRuiz: yeah, even following the jenkins steps, I can't get past: http://pastebin.com/cz5jzqc217:18
jbwivafter that I just get erros like No component named org.adempiere.server:eclipse.feature is known to Buckminster17:18
CarlosRuiztry this please17:20
CarlosRuizhttp://ci.idempiere.org/job/iDempiere2.1Daily/ws/iDempiereSeed21Pg.sh17:20
jbwivCarlosRuiz: not eclipse, but buckminster17:20
jbwivwoops, sorry, was responding to a question in the history17:21
CarlosRuizyes - just copied the files there - also the Or17:22
jbwivok, thanks17:22
jbwivI have to figure out this first: http://pastebin.com/cz5jzqc217:22
jbwivCarlosRuiz: any idea how to fix this error?17:49
jbwivI'm on the release-2.1 branch. is that correct?17:49
jbwivI'm using the exact commands from jenkins17:49
*** mbozem has joined #idempiere17:58
*** nmicoud has joined #idempiere17:59
CarlosRuizsorry jbwiv - no idea about that error18:05
jbwivCarlosRuiz: ok, thanks. I'm out of time this week but will resume my attempt next week18:06
jbwivI appreciate your help18:06
*** mbozem has quit IRC18:23
*** nmicoud has left #idempiere18:31
*** xapiens has joined #idempiere19:43
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-281120:08
Not-6e26[IDEMPIERE] This Section exists in the attache "primary key steps 01.sql" attachment 1. SQL - Drop current compound primary key 2. SQL - create new column NOT!! as primary key (example: M_ProductPrice_ID) 3. SQL - create sequence 4. SQL - update new column with sequence 5. SQL - make column the primary key execute attached SQL This section will be captured in a Log Migration Script 1. Enter Dictionary Maintenance20:08
Not-6e26username and password 2. Turn on Dictionary Maintenance and Log Migration Script 3. Find M_ProductPrice 4. Enable Change Log 5. Create M_ProductPrice_ID System Element ##. set Entity Type = Dictionary 6. Create M_ProductPrice_ID ##. make mandatory ##. do not allow copy 7. Find out every tab where table used (use AD_Client_ID -> Used in Field sub-tab) 8. Add key to every WT&F using the Create Fields process setting20:08
Not-6e26the Created Since date to yesterday To run migration script in a test environment: psql -U adempiere -d idempiere -f /tmp/mig....postgres.sql Test to make sure all worked as expected - set GWAdmin role to isChangeLog = y and change a product->price Create new patch in code. * regenerate model for M_ProductPrice * Update MProductPrice.java to remove "multi-key" exception Attach patch to ticket Test cases: * make sure20:08
Not-6e26new record get created and updated values * make sure updated records get correct details (updated and updatedby) * make sure records that existed before this change act correctly. * create a run Price Schema pass to make sure all works as expected20:08
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281120:08
ChuckBoeckingHi CarlosRuiz20:23
ChuckBoeckingYou hava a moment?20:23
ChuckBoeckingI am testing the Primary Key ticket - https://idempiere.atlassian.net/browse/IDEMPIERE-281120:26
ChuckBoeckingOne of the things I found is that there are processes that create M_ProductPrice records directly from SQL (insert into M_ProductPrice ....)20:27
ChuckBoeckingDoes there exist a WAC (World According to Carlos) example where primary key values are created at the database/SQL level for a key that is maintained in the AD_Sequence?20:28
ChuckBoeckingIf no, I will need to refactor the process to create the records through the model. Do you agree with this statement?20:30
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-281120:32
Not-6e26[IDEMPIERE] This Section exists in the attache "primary key steps 01.sql" attachment 1. SQL - Drop current compound primary key 2. SQL - create new column NOT!! as primary key (example: M_ProductPrice_ID) 3. SQL - create sequence 4. SQL - update new column with sequence 5. SQL - make column the primary key execute attached SQL This section will be captured in a Log Migration Script 1. Enter Dictionary Maintenance20:32
Not-6e26username and password 2. Turn on Dictionary Maintenance and Log Migration Script 3. Find M_ProductPrice 4. Enable Change Log 5. Create M_ProductPrice_ID System Element ##. set Entity Type = Dictionary 6. Create M_ProductPrice_ID ##. make mandatory ##. do not allow copy 7. Find out every tab where table used (use AD_Client_ID -> Used in Field sub-tab) 8. Add key to every WT&F using the Create Fields process setting20:32
Not-6e26the Created Since date to yesterday To run migration script in a test environment: psql -U adempiere -d idempiere -f /tmp/mig....postgres.sql Test to make sure all worked as expected - set GWAdmin role to isChangeLog = y and change a product->price Create new patch in code. * regenerate model for M_ProductPrice * Update MProductPrice.java to remove "multi-key" exception Attach patch to ticket Test cases: * make sure20:32
Not-6e26new record get created and updated values * make sure updated records get correct details (updated and updatedby) * make sure records that existed before this change act correctly. * create a run Price Schema pass to make sure all works as expected * upgrade an existing system that is configured to use native sequences20:32
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281120:32
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-2811 Attachment set to "None"20:35
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281120:35
Not-6e26[IDEMPIERE] cboecking updated IDEMPIERE-2811 Attachment set to "IDEMPIERE-2811-Each-Record-Primary-Key.patch"20:36
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-281120:36
CarlosRuizHi ChuckBoecking20:37
CarlosRuizah - there is just one process M_PriceList_Create20:38
CarlosRuizthat class deserves a refactoring  :-)20:39
CarlosRuizhistory of that class is that it didn't exist in compiere times20:39
CarlosRuizJorg Janke just provided a PL/SQL procedure20:40
ChuckBoeckingDo you see looping on a collection and creating the new records via the model?20:41
ChuckBoeckingDo you envision looping on a collection and creating the new records via the model?20:41
CarlosRuizmy wife (you see her name on top of the class) migrated that PL/SQL to java20:41
CarlosRuizbut just plainly - not converting to compiere way20:41
CarlosRuizthat's why you basically see SQL statements being executed20:42
ChuckBoeckingwhat is the WAC for this situation?20:42
CarlosRuizit would be good to refactor that class to make it correct java and usage of PO - but don't know if anyone dare to do that task20:42
ChuckBoeckingbetter question: where is the WAC?20:42
CarlosRuizin the meantime20:42
CarlosRuizyou can use nextidfunc to generate the sequence20:42
CarlosRuizin other words20:42
CarlosRuizquick and straight solution -> use nextidfunc20:43
CarlosRuizproper longer term solution -> refactor that class to use correct model way20:43
CarlosRuizin your ticket I think easier is to implement the first20:44
CarlosRuizand open a second ticket if you want to try the second20:44
ChuckBoeckingperfect - never knew the nextid functions existed. Good to know.20:44
ChuckBoeckingconfirmed on all points20:45
CarlosRuizI created the nextidfunc to ease migrations - and scripting inserts from foreign sources20:45
CarlosRuizin core is not used - just found one class using it20:46
*** mhernandezve has joined #idempiere21:47
*** ChuckBoecking has quit IRC22:02
Not-6e26[IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-2873 Import CSV getting wrong tab from another window23:56
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287323:56
Not-6e26[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2873 Attachment set to "capture-for-jira-screenshot-20151001-185116-422.png"23:56
Not-6e26[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-287323:56

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