#idempiere IRC log for Thursday, 2015-02-26

*** hieplq has joined #idempiere01:31
*** is-mw2 has quit IRC02:04
*** is-mw has joined #idempiere02:05
*** CarlosRuiz has quit IRC02:19
*** hieplq2 has quit IRC03:06
*** shmutalov has quit IRC06:07
*** norbertbede has joined #idempiere07:19
*** norbertbede has quit IRC07:33
*** norbertbede has joined #idempiere07:47
JanThielemanngood morning @ all07:50
*** nmicoud has joined #idempiere07:51
*** a42niem has joined #idempiere08:09
*** is-mw has quit IRC08:41
*** is-mw has joined #idempiere09:00
*** shmutalov has joined #idempiere09:10
shmutalov)09:11
JanThielemanntoday i learned when i can use MyClass.this effectively09:14
JanThielemannsometimes i feel realy stupid because of not knowing thinks like this years before09:17
JanThielemannWhen the server is started, a new session with ad_user_id 0 is created09:44
nmicoudhi jan, related to a scheduler ?10:16
*** KermitTheFragger has joined #idempiere10:24
*** norbertbede has quit IRC11:28
*** norbertbede has joined #idempiere11:28
*** norbertbede has quit IRC11:35
*** hieplq has quit IRC12:53
*** CarlosRuiz has joined #idempiere13:45
*** ChanServ sets mode: +o CarlosRuiz13:45
*** norbertbede has joined #idempiere13:51
*** Adam_ has joined #idempiere13:51
Adam_hi13:51
Adam_I've got a question about idempiere -> is there a simple way to change primary key column length? For now all of them are numeric(10,0). Is there a simple way to change them to numeric(18,0)?13:53
JanThielemannwhy would you do that?13:53
Adam_Beacouse I have to13:53
JanThielemann:D13:53
Adam_:)13:53
JanThielemannso... why do you have to change the lenght?13:54
JanThielemanni don't think that you want to spend some hours just for fun13:54
Adam_No, it's no fun at all :D Let's say the reason is not relevant, but there is no other way I can do something than changing the length od those columns.13:55
Adam_Is there a way to do so?13:56
JanThielemannyes but you will not like it :)13:56
Adam_SQL?13:57
JanThielemannyes13:57
JanThielemannand make sure you don't forget any of the 840 tables13:57
JanThielemannany you may have to drop and recreate some views during the process :)13:57
CarlosRuizI think you're restricted by the int type in all java code - max int is 214748364713:57
Adam_actually I've tried that -> I have pretty nice ALTER statement to change all the columns I want, but there is a problem with views13:58
Adam_There is BitInteger in Java ;)13:59
Adam_BigInteger13:59
CarlosRuizyou would need to change all idempiere code to manage this new type for the ids13:59
Adam_You're saying that iDempiere want't handle well that kind of ID?14:00
Adam_damn14:00
CarlosRuizI'm saying the effort can be huge - so - back to the JanThielemann question - review the need - probably there is another easier way to achieve it14:00
JanThielemannidempiere uses int for id columns14:00
Adam_OK, so that out of the table than14:01
CarlosRuizwe have also thought about the possibility of dropping all the IDs and use the UUIDs instead - but again, the effort seems big14:02
Adam_My need in synchronization with POS software on mobile devices. I'm using SymmetricDS to synchronize some tables from iDempiere. The problem is that for orders I need to synchronize c_order and c_orderline which links to c_order and I need to find a way of synchronizing PK,FK without conflicts.14:03
Adam_UUID would be great ;)14:04
Adam_SymmetricDS is a database synchronization software.14:04
*** norbertbede has quit IRC14:05
CarlosRuizmaybe you can use the UUID for synchronization - consider UUID as an alternate primary key14:06
*** norbertbede has joined #idempiere14:06
Adam_For synchronization to POS I could use that, but there will be problem with synchronization back if I would like to create order records on POS (which will be without IDs)14:07
Adam_Main problem is that POS needs to create order records14:08
Adam_with orderlist14:08
Adam_And to synchronize it back to iDempiere I need to have c_order_id in c_order and c_orderline already set14:09
Adam_My idea was to concatenate it from some POS_ID + POS_SEQUENCE on POS so they would be unique, but length of 10 would be to short14:10
*** hieplq has joined #idempiere14:38
Adam_thx for help and goodbye :)14:45
*** Adam_ has quit IRC14:45
*** allgood has joined #idempiere15:18
*** allgood has left #idempiere15:19
norbertbedehi. all15:31
norbertbedeCarlosRuiz could you please commit this https://idempiere.atlassian.net/browse/IDEMPIERE-246915:32
norbertbedeits fixed by hiep we are deployed, and looks 99% ok15:32
norbertbedebut sometimes issueas appear. but i mean for further investigation we need to get in core. pls15:32
CarlosRuizdone15:36
norbertbedethanks well15:37
nmicoudhi CarlosRuiz : on your last comment on https://idempiere.atlassian.net/browse/IDEMPIERE-868, you refer to a patch. Which one ?16:05
*** ocurieles has joined #idempiere16:05
CarlosRuizpatch_868_MColumn.patch16:07
nmicoudok16:08
nmicoudlooking at "my" MColumn class, there are comment about IDEMPIERE 868 and 965. Need to check to see what i really used (all modifications were done in 2013). Will give feedback asap16:11
CarlosRuizyou know I don't use oracle - so don't know if that problem arises and which length of table is required then - another restriction imposed by that  :-)16:12
nmicoud:)16:12
nmicoudmy class seems a little bit different. Will upload a patch on the ticket. And ask for other Oracle users to check16:13
CarlosRuizoracle looks like windows 95 with such restriction  :-)16:13
nmicoudsomething like that :D16:14
CarlosRuizor DOS  :-)16:14
nmicoud:)16:14
CarlosRuizI remember when you just had 8 characters to name your files in a diskette16:14
nmicoudyes - it was 20 years ago :d16:15
CarlosRuiznmicoud, are you still using swing?16:34
nmicoudonly in System (i'm the only one)16:34
nmicoudcustomers only use web16:34
CarlosRuizok - just checking that are a lot of swing related tickets - and if there is no interest maybe is better to close them and label as potential idea16:35
CarlosRuizI'm today triaging old tickets16:35
nmicoudi think you can16:35
nmicoudAFAIK, only tbayen and me were using it16:36
CarlosRuizwhy don't you use web for System?   :-)16:36
CarlosRuizI'm now so used to all the new features of webui - that I see the swing client as boring16:37
nmicoudweb is slower16:38
CarlosRuizI don't feel that - maybe as I don't use swing I just got used to the speed of web16:38
nmicoudi think16:39
nmicoudsometimes i use both at same time, and web is soooo sloooow16:39
norbertbedenmicoud if you will use webui for system i will help test you :) more people more experience :)16:55
norbertbedewe drop swing in our strategy16:55
nmicoudone time, i try to create a whole thing in web : table/window/process/... and i was mad. I think i do things 2 or 3 x fast in swing16:57
norbertbedethen we must make better zk ;)16:57
nmicoud:D16:57
hieplq@nmicoud, you use a high speed program but let your user a verry lower speed program, how to you can understand his unhappy :D17:01
nmicoud:)  thay don't know the "power" of swing17:02
CarlosRuizI don't think swing is that fast - really - we could try to measure how much time you spend creating a table in swing and I in zk17:02
norbertbedeCarlosRuiz i mean its not only about time but comfort17:03
norbertbedee.g. window/tabs navigation17:03
CarlosRuizsame here - I feel more comfortable with zk - a lot more17:03
norbertbedei prefer zk8 well17:04
norbertbedehops zk7 ;)17:04
norbertbedeits about requirements too :)17:05
norbertbedeapropo, we have lot zk7 tickets ready to commit (A)17:05
CarlosRuizalso - I just use local network for development - all my production and test servers are in the cloud - so swing is not an option there17:05
CarlosRuizyes - I have a big backlog on zk7 tickets17:06
nmicoudproduction is in our cloud, so i can use swing, and i can garanty that it is faster than zk. A good example is to create an element and translate it immediately.17:07
nmicoudbut gtg now, will come back later17:07
CarlosRuizwe can measure how much time you spent creating the element and translating vs me in zk  :-)17:09
CarlosRuizlet's do a race  :-)17:09
norbertbedeanyway synch transl. is quite slow well17:12
CarlosRuizhow slow?17:13
norbertbedetake in aws 5min on 8GB ram java instance + RDS 8GB PGSQL17:14
norbertbedei know not too much resource but averagy of CPU is approx 25% only some processes are sloq17:15
norbertbedew17:15
norbertbedeinstance has SSD disks17:15
norbertbedeboth17:15
CarlosRuizI noticed that when using the new postgres17:15
CarlosRuizis about memory17:15
CarlosRuizpostgresql memory17:15
norbertbedeyou mean doesnt fulfill minimum ? t waht you mean17:16
CarlosRuizI noticed this17:17
CarlosRuizin postgresql 8.4 the sync trl was very fast17:18
CarlosRuizseconds17:18
norbertbedei see17:18
CarlosRuiznow - when using postgresql 9.X default configuration17:18
CarlosRuizit takes too much time17:18
CarlosRuizand lot of CPU17:18
CarlosRuizthere is one of the queries that postgresql cannot resolve properly17:18
CarlosRuizI change postgresql.conf to increase some memory17:18
CarlosRuizmaybe shared_buffers or something like that17:19
CarlosRuizfor production systems I use pgtune to help with that17:19
CarlosRuizand then the sync trl again takes seconds17:19
norbertbedehm interesting17:19
norbertbedeim using pgbadger for analyse logs17:19
norbertbedeindexes etc17:19
norbertbedethinking about pgtune usable for RDS17:20
norbertbedebut i mean not because RDS is service17:20
norbertbedenot linus17:20
norbertbedelinux17:20
norbertbedefound something here: http://www.davidmkerr.com/2013/11/tune-your-postgres-rds-instance-via.html17:20
norbertbedeok.thanks for tip going to test :)17:21
CarlosRuizthat looks good - as in RDS you don't have access to the postgresql.conf17:21
norbertbedeyou have parameter groups - its same like postgressql.conf17:22
norbertbedejust create some parameter groups17:22
norbertbedeand you can switch on purpose17:23
norbertbedee.g. 1 group = testing, 2nd production etc17:23
*** hieplq has quit IRC17:28
*** KermitTheFragger has quit IRC17:36
norbertbedeCarlosRuiz. Synch Translation after some tweaks  took 6 sec instead 5min :-O18:02
norbertbedethanks18:02
norbertbedei followed http://www.davidmkerr.com/2013/11/tune-your-postgres-rds-instance-via.html18:03
CarlosRuizseems like a flaw in the default postgres config18:03
*** norbertbede has quit IRC18:46
*** ocurieles has quit IRC19:10
*** nmicoud has quit IRC19:25
*** norbertbede has joined #idempiere20:03
*** ocurieles has joined #idempiere20:30
*** ocurieles has quit IRC21:53
*** ocurieles has joined #idempiere21:54
*** ocurieles has quit IRC21:58
*** ocurieles has joined #idempiere22:37
*** norbertbede has quit IRC23:15
*** norbertbede has joined #idempiere23:15
*** a42niem has quit IRC23:31
*** ocurieles has quit IRC23:55
*** ocurieles has joined #idempiere23:55

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