Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033158Retail ModulesWeb POSpublic2016-06-06 14:232016-08-29 09:34
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR16Q4 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033158: Duplicate query done by accident in OrderLoader.createShipmentLines
DescriptionAt the very end of the createShipmentLines method is a block having:

            ShipmentInOutLine objShipmentInOutLine = usedBins.get(queryLoc.list().get(0).getId());
            if (objShipmentInOutLine != null) {

5 lines later the same query is executed again:
                  jsonorder, lineNo, pendingQty, queryLoc.list().get(0), oldAttributeSetValues, i);

That .list().get(0) could easily be saved and reused instead of forcing to re-run the sql by calling .list() twice.
Steps To ReproduceSQL trace of the 2 selects:
236872 [Import Entry - 1] INFO org.openbravo.base.PoolInterceptor - executeQuery --- SQL:
select locator0_.M_Locator_ID as M1_343_, locator0_.AD_Client_ID as AD2_343_, locator0_.AD_Org_ID as AD3_343_, locator0_.IsActive as IsActive343_, locator0_.Created as Created343_, locator0_.CreatedBy as CreatedBy343_, locator0_.Updated as Updated343_, locator0_.UpdatedBy as UpdatedBy343_, locator0_.Value as Value343_, locator0_.M_Warehouse_ID as M10_343_, locator0_.PriorityNo as PriorityNo343_, locator0_.IsDefault as IsDefault343_, locator0_.X as X343_, locator0_.Y as Y343_, locator0_.Z as Z343_, locator0_.Barcode as Barcode343_ from M_Locator locator0_ where locator0_.M_Warehouse_ID=? and (locator0_.AD_Org_ID in ('F7451B70690F49A9B2B794940E96B27C' , '94382578EF984D9BABF8E7F020ECB97E' , 'CE9A5BAF6184489583B0052A59DABE97' , '5415A4B757714297B9FCE468E909B5FF' , '52F6F406D53F440C9D30CE8D9F967C9F' , '43A105696A7D43EE961480E06922FB8B' , '1DC727D81A574A2DB584BB97E1303BA9' , '6DD587985B9B43F29C4E3E384E81971E' , 'FACA4BA90F8D468A99BFFD136EB629E8' , 'A468810A56B446C29E99E70137E16C3E' , 'AC359E50DFB145DEAC409F0403B58900' , 'CAA8EE7F15B7464293066FC63140FAF3' , '71887561B53142059F5724C0BDA1092E' , '84CA2DFE8886469AA5B8979A4B16BD20' , '6FEAD4158C594DF1A9357F9DDC8A5430' , '174157C012334EC5BE1A842F8DD5CF26' , '4A0DF0998C544FD1A764F57732F6D0BD' , '354F8E8386C545C4953D1B693B793776' , 'E7E0C0B6024D4116AC8DE8804B900271' , '8969054CA3B84C238B13AD871D282537' , 'B2D64FCEF6454EFFB1B0B92DA92865DC' , '1FBA6FBCB6DD4D7CB73280F34925D96C' , '0D47DD56EFB74402BB46E77D9BC82C29' , '4B37B012D0444766A06659A46F8A40CD' , 'D4A8C0BA015D40239EA2E0EBE343AAAE' , 'A3ACD712EAB343E89231D575FF256E9F' , '6C681F5974F1441BAA769C7D658C9846' , 'BEEE4D0875B74DC9AC26F1859AC70AB7' , '637D9319FBD64FE08B8D2999D8A14D85' , 'B0EDFD5606094E558B070A31464DC822' , '8993110DBC2143D8963549AE94E54A97' , '0' , '91A670A1DE5D4FAE8AECFFFE0E26490E' , 'FBB103B21AB64D67A674D81A5CA49872' , 'E61D29817B8F4272B6C114B00AA50C9B' , '669B03C55E26448E95A4748F3B184A24' , 'EFF3BEB2BD7446968FF8DF2EDC866BB5' , '61FBF25043074E3AB6F35FE0EDED4ECA' , '99B0E87344A6493A97080492A877DC6F' , '5A7EA173636840DD870AD0BA77201855' , '784C3FBC5F3A437D9DA9058D23C510C4' , '7895E4AC63624F4C997422882BC93EFD' , '6299C18801B84559ABEDBCD700B400B5' , '0C405E37F0E84589A85BCA3106F145F1' , 'F885C9C28130468AB1B9EB674DA55751' , '50E48A8190AF43458E684418A3357D58' , '167F4EFBD4624C7E82AC2838F265955F' , 'B2EA329169B0461D928B705B8CF3F740' , '08A69FF3AAA04D1EBC633CC0CA4F4436' , 'DCEAA922F5CE4235BEA5130CB6619CBF' , '1A4471C8EB3B4B17A5FB2D164B253920' , 'AC51AFCE07FE4581A9AD96A6755D0964' , '74D79BBA35A54773A62CDC4776B829B6' , '4FF0F96370F84DE28D531D8AF1B564BB' , '3958C338A3814E0B82F49D31A311D0E4' , '525E97CC8A7E482E8C90A9B383F70269' , 'DF8D62F087A44B94AE8875670C2C64AD' , '6DA33A8010ED44B8980DED9E36640616' , '7BE074956A59421F9CDCC96E7D05C863' , 'AF7B706B023A4983B779F4F15C3E7774' , '1024715DCB5948129790CF35D5A0072C' , '38226C5344A449AB8BE4B6B94388D5AE' , 'B1C85C2ED3C4488B8F07350551B27526' , 'C1D839CCDBE44A12AA0C0C52CB58B679' , 'C7F9AC3631E549EC8D0BA2F6BE400325' , '0760F16CBEFA45D2841B12450FAC42D4' , '38F18A5DE8A648809DD1E1D36A0C6BBD' , '1C935880EFF64008BD6467FE1FF58AD4' , '9A1AE81E157E4678A50D88D083D50E94' , '83863205FB0B483C8A8FAFBC59BB9C48' , '93FDFEDA4E074238BAF5608CB81404AF' , '7A1E39F5AC3046949D2914406CF386B5' , 'C2977532D3DB46309F1CC55514E66FDE' , '73D5CB0368FC4D6CA519260D9930C2F2' , '5CA97509D17D41C8BEBF7BE59B55A018' , 'C98655EA6B51411B8554D080322BFAD3' , '1928F6608C9045B0A88924EF02529C17' , '240D151DD6E54208A957C90B984766D3' , 'B858D5066B924A89B23C0447CE0759C4' , '338BE34065FE4573A9CE6F899913CD25' , 'CE47348DCC814F16B167D0A79272D8E0' , 'DE2CCD27DED242FB86B841729010434C' , 'E8B908ED5A4E468E9F73C5E2AD5A1E50' , '6B10F7305E254811B98AE5A90B77DDBF' , '6AD0AD7E93E5442F8E6B9D460D8E50EF' , '2E0A9B61357D43F89D8A89C72FBC70A0' , 'BBA7B7F240F445E0BA78D68A20D86995' , '730C0B85AD724A45BC88057E2FDB8EB1' , 'FDA2FE967DA14BFB8D7CEF49253F9A0C' , '048539E4F1C942649ABE0A01F957D53B' , '24C12BBFBDF44ACFAC5EB0807B0FF481' , '157B8C74FE8F4E4990BE08524325B5BB' , '980D5D38041143B9B56AD60C3FBAFF8E' , '9302E53359764BADBD9D71F011CE90CA' , '47DC8DB26488482C9782E81A5BD0A5CB' , '9F1933F423DB4E58A7053C1C18B9A398' , '7EB996CD402A4FD1B602D7AF089B1B7A' , '701EA4F52CBA4053AFCD55BAA914F884' , '1597B5574D714960A430B7A8487A5E4D' , 'C58DBBAA894D4C14995F5137D136507C' , '9E2EE3A7463C406F8C3C9FD3ED7CFB00' , 'D6B650EDEC8249B3AD362660F5A46214' , 'C09BAA7FDD9C4DFE9407404086E0232E' , 'F5B95F8103734B0C92E51B81E1C5A163' , '51C85E088D6946F3B99454B1CB7EE625' , 'B7444624A0A24FA7A9995AE3461876CB' , '12DF234F83B94B3EB401792DA1D4E46C' , 'F791FBE8ECDC40A4B90BD5EF86D9CD2A' , '5AB17733F76A4F8CBC25D2A72F58DC41' , 'B05DCF5695FD4F34AD1E2CBD2A68E0C9' , 'BB1C47DCF63149BF914E3091AE4777E9' , 'AC2529A2BF934F089669A7A23ED0A08A' , '7D167D2A05804CF588A3CFF055235609' , 'D975456F44E145CAB5AAD162523FFECE' , '073988092B7B4927B03B0C5706BDE8BB' , '72941C05D8604C6387DFBF768438D295' , 'E3C5A73A65C54148999556B59C0F44C1' , '9B7D4BE39240459AA8133D18824D0157' , '12BF55EA80B542F3AC59F33BC32EE34F' , 'B2EEAB1CE07D49FA80B9EA7D23AEBA76' , 'E8D587C97F4A44E4AF28456842ABF382' , 'E8A4E9FB38534FF2AA6D20D17C346419' , '2393ED384F9A4BFCB6D5CAA97A20FAD4' , 'E04B77DC3E394988B5B05B4C367DA4B5' , 'BC0F028F533B4F268A8135F17EB0CE30' , 'A3DFF8459AEB422BB6E983B2AC31CDA7' , 'DC4E95A5290F41878959AA40ACD37717' , '9F1003FCF9B146DEAD78BE873D3E2B0A' , '8667A53E486745F798E69D4600ED100C' , '570DC76A15BF4055A68CF060E7901685' , 'B22620E4B88C4716BDD0BE42FDFBEB83' , '2406AED2C58D4A5699DA62D26658BC6E' , '2A7CE45682494CA3AAC8C448BA96FD36' , 'A9ED8426970F478A8869986CBEE702FB' , '54991A6D5A784013B011C919208046E3' , 'D0177510CFEF4355B93C89F22EC59AB5' , '82B878A78D75460BABAACC388476EEB3' , '436BEB3D2B014CC59D557E26AFF8E419' , 'C1CBA93998E64144BC71FF58D3D9322D' , '6EF6818C4F384815A46B240CE9008BEC' , 'CF944E29E9E94FF2A0238A5EF27D80FC' , 'E20264615F294B6184739F0F28055DBF' , '3261A88339CD4CCA8C05107443AF1128' , 'F4A063FCA2E04CFDA564E4085DD23BDC' , '9838CCFDAC57419FA1C0D90703EA8F4A' , 'F3ABAD82C72D4C83A1A9B00CB65EAA23' , '2B54FEF139F94C6787094574B5E4C216' , '6DEFE9C4864145868C2E9FAAA5909983' , 'AF235D374D0F4C96A15F2DA6077766BF' , '6C49C6DB01BD4CFBB839A28230764A44' , 'E5240695C0E94A7E87A9B857CD650BAB' , 'C6F72E46B5D141C78474D178B9A3F9D8' , '7234540C502349C9A40112243B8C688B' , '7A7CA2D99D4446F29F9CBD1E9BBA1C35' , '7186156E473E4B9AB2F1CF8B88106146' , '09EFA5309AC74A309FA46D3B9EAF057C' , '587EF97450784DE087989686CBE51D40' , '9A9C2D9F4B01440D9EE14219BD04C24A' , '5AC4E37CB3F14DE3BAEEAED6DBDDFF26' , '81F70B65DB014FB1BFF4089D3E543740' , '08210831F94F4A99AF9E6A511AC1E8DF' , '6829B2C4C6CC4CD2863CAF9498AB499C' , '88E2EEA28CFF474EA278DCA8FA2B7DC1' , 'B30B8100589748CFB76BB06D66910515' , '7F527352A2534EFEB5AE73CEE66C1349' , 'D5737A004D214181A71267B4FD8EDF62' , '587E1E4A33F74F68AE165FF4D7E3B67C' , '521E421D818D4B59B398DDE7E836F4EE' , 'CA6371FE1E69448A89B98574FDD52960' , 'EEB74504E265429BAF10F972F2B11124' , '20FE6B957AA0408BA7FCC19E17D957CF' , '82666000B730421B98612D4344A1D628' , '478973BF4FF9478FA305BAC91081CB3F' , '5B7E244DEAFF4FF5B3689FAA20EE883D' , '965E534F68DF46A982FCA7D0153430E6' , '4E39B8550BDF4FBEA5EC3256250362C5' , '0E67F44CC43C45A7AAEF4F0170206F90' , '733006F35D2F4C56BECAD534688AE47A' , '3032DBA644F341C9813ABE910A05C5B7' , '5A531966519C4FA7AC4BD3511E4B09B7' , 'CCDEB1F8BB8C4E2091F371AEA975E30A' , 'D142D6D1ABAD47D49D9E764889E61F21' , 'E4CBBE24C0534B0C9CA28CCEA91CF522' , '905D34D5A4FD41C7AEAC8EBEC3EA6CC7' , 'A16A7DB0132B42A2B3882F4C845C9AD1' , '4D8F03578BB6492A85F90776F90109DA' , '5FA1C96660A549DEA3AF081D69E73CCB' , '3B3CEF60C1F143F092119ECA9BAB0E2E' , 'A3C50B722145464688A4507422A2F886' , 'F221C2F65AD84EB0A6D3B85772B82EB4' , '9AF439764D344CFF85497A713F288125' , '5E7499EB05E543DD9BA7662262EB37B7' , '408F791C21D44C78B1F9AEC4C2880234' , 'E9710D9DF58142CA82C084F63A37682A' , '1CEB3C8229DB45B6AE1B89214EC0EEE8' , 'F634F381864843FA852E9DE3EC696126' , 'CA2784F6B85F4D49A32D68ADA7B1D1C7' , 'F82DACB52D6C400B8AB2F5AC44F5FBFB' , '5B1EB0F2B94E4729BDE2505FC7B9100E' , '780227E5250B41DD93C682DBDFD13C57' , '940ECC09D2D24AF5AC708FC633EF6BA6' , '81E3886A3D0144B2BD4EEB669C711504' , '07A0A1B5808D41299CBF11B64D47EE32' , 'BFBE16565AB0494C88BA0D11A4AF1F88' , '620244EF03ED42CB832671D6EDF40956' , 'D611C392A3434305AFBB47D1512AAA59' , 'DEC4DA1DC5374972891916FE40F61648' , '22C5D4FFB67E414EBCE8DA02CE579612' , 'BB8F0D1946474DE6A9EEA1F436C4452F' , '906700E60E6945DFB403E2D6D97AB3DC' , '54CE6D5B7909421AA9C3A9DB5F799C43' , 'AEECF1BD486C44E4BC261589AC38BFA5' , '95981B6913D84EDAB1D94EFFBFB0CBC5' , '4BC8451292664B618D7B5DD56B89734D' , '9285CC974A984BBD882FF396979AABD3' , '9D5AA88F15EE40CEA0AE8944B2989506' , 'E5CC53F9EE314E5AAFCD412574D09A2E' , '4342ECF47A6045E1A0C12078E37B61F4' , 'D50A18A0C00E47328000A8DB3958E6F0' , 'ABCED49B96F14FD6B3856A816BE1A756' , 'ECE03BABC74D4E418D1B5DE916F9C530' , 'B095EDCD43504236BC013D3798C04FD1' , 'D1DDA78EB3364D25ABC5A53ECA53555E' , '8D0BD91C1FA6442DADBBBDB41F1C2936' , 'ADB4A5D1D36E42E49297AE3917BDA187' , '751C26037E9448B99E5032C2E3C88F41' , '3B6AE7BB65F34F66B989411FC2F0055B' , 'EB68AC15A8B84E5D9E89305CF16177F3' , 'A50517AA32994D3CAE7A5AE5E35A3406' , '3A02FFAE48E142DA9A411F8E30F0A8F8' , 'F3206843CF284581AADE146E067FE50D' , '776966F23C384C8C90D45771EB797BE1' , 'E428FBC1E6FC4FE98F04EEB440BC33F2' , '77CC193361D547DCBBC5BDD3F4645BE9' , '819FBD0F523F4763936610F0257ECA38' , 'CC35701B75F8475D8ECD7136D173E077' , '9C92726846404FF7A11631446F074132' , '88EC10BA08E24093AED85EB300D3ADDF' , '2582441C64384056823538726B5E5FAB' , 'FA5B04011F2C401E8AE1E88AAF494B49' , '7A569819B4B94975B6303BF479232398' , '53716DA84625417BB8D40DCF0F4AC640' , '8878376030D04E22B21E1B3CAEA85949' , 'D25DD7D200514E3CB49D6F57F2D722CA' , '514B2DA524B946DFA3AE9C1225F7DCB6' , '739BBB8D20784F498ACE97EC0A6972D6' , 'BAFB4AD71D9A4E6281DFB90C1A621B5D' , 'EC1D951ECF5246BA864A64B7255BDA5F' , 'B2C9A179733D4A468A4242873029B00E' , '2779C98C2E1A4C47833E912B38A528AA' , 'F5A2FFE45FF24C1FA6F2D675B631352F' , 'FF2C689A5F634A09BFCCD82826296191' , 'AD8E86543C9148BAB954739D97E29ECF' , 'ABCC171E0BAF49AABDC149DA455A34D5' , '320096A972D5403DBB593BE1668857EA' , '07D373EA01064815B0F0F4E066DB7DA7' , 'DFEB3AE28E684CA7B6BCCB2D7FB7623F' , '9DDEE504A05948588C24D670A896F071' , 'FB81477BE8574CB48E36D34DBC0066D2' , '64F0648166054F49B4B272CB63243AE6' , 'DB84831BDE61409BBC2D013F794C73A9' , '7CF41127D47B47D698DB5BCA86F0B2C9' , '3AD78108E6694F40994982E46E9CA400' , '2D6EF34D9453423391EC35BDB4E3C8E1' , '0F3345F3D38F41F683461A2C58050658' , 'BCDD1E90D9CB4B2CB158C09FD20DA823' , '72240D2EB5A5494EA432444F1166B4C2' , 'FF12C37545EE490D9841F5E20F185F0B' , '07883AE145EC49E09F40027A4A5448BC' , '4DE90353322F476FAFB4615EE0E62354' , '4B0AB71D756F4F36906A420B472CD900' , '11A1B8F73BAB45D692DB3E71D266B4AB' , '9B7057B8F9F94C42B58811BCBA83D974' , '3EFCDD8AE7E74BDCA2B78C69B34ADBAA' , '773957E45AF64A91B27AF2302F7B911A' , 'BD3C47EC0E034EFBBE824034C2B225FB' , 'C17DDF41942849B083E7D83CAB953AC7' , '551C234B43E44329A1EE4A31908EE120' , 'A64520E2A0BB4C71B000C691AF4BDE47' , 'C4D8C9E6A6434FBEB357B9773272E3DF' , 'A237DB7C2BCE4669AB0BF565B9877E48' , '9D5CF616962647AC96210880A4D4F0EE' , '24424835882049AC90B017A93D3427B9' , 'F0FFCB264CDB48218D0C810D0ACCA887' , '573C95ED0FBB469AA0DC2B559C2FBF1E' , '7D54E11E001E4B048647332BADBDC0C9' , '1CD3D3504A4F4348AC3D509297E8E8FB' , '2472EFBFF60944ECB1C1412E17F098F9' , '3DC0BE5CCDD74406954A40575C8397D7' , '402365919EA147BC8896EA84EEF316CA' , 'F7D0C5455B1B472BA13A52D6C0CC67C7' , '725FF3D78006498087476EDD2D0774C0' , '18E3ACFCB71247589CBB3D26FDA56913' , '970CCED57EDC49CC92FE9C22A4218D5A' , 'AF322DF57AEA4E4DA6DF03E876F988E5' , 'C80FEF28CBEC4E9CBD4174D5560B2561' , '007631AC24F542E595FBC98D5DC32498' , '878CBB17CD094FB4A44F6304F99462EB' , '1BA369944720403E815BFD931D76CB2B' , '19403221B96D470CADE052A62D3C57B3' , '8B9D3E06997B47F49C49F5CB6F40DF59' , '7168A6EEBD8644688C20DC6A459AF262' , '909BE3F0E76D4BEC8B2A40F7F72E9F97' , 'CB12003393CF40CFB938725CBB0FF182' , '05B757772A5B4F3394F734B27328A4F1' , 'A53CA01D5A394BC3AFD5D0BE9FD4687F' , 'CE3E6CFE8B674541A94F6AABF2AC86C4' , 'D5F4C67FF4A946069C3BFEA34B169F5F' , '5339B4C139D2427793B7C1BD1768BE3A' , 'BDDAE469B4244649B36B6504835F1BD7')) and (locator0_.AD_Client_ID in ('B8D74EB90D8A422F900F442C2D721C2E' , '0')) and locator0_.IsActive='Y' order by locator0_.PriorityNo, locator0_.M_Locator_ID limit ?
  t:1
     $1: EB95AA8B504B4FA388AAD5FF4DB962A1
     $2: 1
java.lang.Exception
    at org.openbravo.base.PoolInterceptor$PSInvokationHandler.invoke(PoolInterceptor.java:99)
    at com.sun.proxy.$Proxy23.executeQuery(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    at org.hibernate.loader.Loader.doQuery(Loader.java:802)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.doList(Loader.java:2533)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.openbravo.dal.service.OBQuery.list(OBQuery.java:118)
    at org.openbravo.retail.posterminal.OrderLoader.createShipmentLines(OrderLoader.java:1223)
    at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:377)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:235)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:192)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:98)
    at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:41)
    at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:59)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:370)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:292)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
236873 [Import Entry - 1] INFO org.openbravo.base.PoolInterceptor - executeQuery --- SQL:
select locator0_.M_Locator_ID as M1_343_, locator0_.AD_Client_ID as AD2_343_, locator0_.AD_Org_ID as AD3_343_, locator0_.IsActive as IsActive343_, locator0_.Created as Created343_, locator0_.CreatedBy as CreatedBy343_, locator0_.Updated as Updated343_, locator0_.UpdatedBy as UpdatedBy343_, locator0_.Value as Value343_, locator0_.M_Warehouse_ID as M10_343_, locator0_.PriorityNo as PriorityNo343_, locator0_.IsDefault as IsDefault343_, locator0_.X as X343_, locator0_.Y as Y343_, locator0_.Z as Z343_, locator0_.Barcode as Barcode343_ from M_Locator locator0_ where locator0_.M_Warehouse_ID=? and (locator0_.AD_Org_ID in ('F7451B70690F49A9B2B794940E96B27C' , '94382578EF984D9BABF8E7F020ECB97E' , 'CE9A5BAF6184489583B0052A59DABE97' , '5415A4B757714297B9FCE468E909B5FF' , '52F6F406D53F440C9D30CE8D9F967C9F' , '43A105696A7D43EE961480E06922FB8B' , '1DC727D81A574A2DB584BB97E1303BA9' , '6DD587985B9B43F29C4E3E384E81971E' , 'FACA4BA90F8D468A99BFFD136EB629E8' , 'A468810A56B446C29E99E70137E16C3E' , 'AC359E50DFB145DEAC409F0403B58900' , 'CAA8EE7F15B7464293066FC63140FAF3' , '71887561B53142059F5724C0BDA1092E' , '84CA2DFE8886469AA5B8979A4B16BD20' , '6FEAD4158C594DF1A9357F9DDC8A5430' , '174157C012334EC5BE1A842F8DD5CF26' , '4A0DF0998C544FD1A764F57732F6D0BD' , '354F8E8386C545C4953D1B693B793776' , 'E7E0C0B6024D4116AC8DE8804B900271' , '8969054CA3B84C238B13AD871D282537' , 'B2D64FCEF6454EFFB1B0B92DA92865DC' , '1FBA6FBCB6DD4D7CB73280F34925D96C' , '0D47DD56EFB74402BB46E77D9BC82C29' , '4B37B012D0444766A06659A46F8A40CD' , 'D4A8C0BA015D40239EA2E0EBE343AAAE' , 'A3ACD712EAB343E89231D575FF256E9F' , '6C681F5974F1441BAA769C7D658C9846' , 'BEEE4D0875B74DC9AC26F1859AC70AB7' , '637D9319FBD64FE08B8D2999D8A14D85' , 'B0EDFD5606094E558B070A31464DC822' , '8993110DBC2143D8963549AE94E54A97' , '0' , '91A670A1DE5D4FAE8AECFFFE0E26490E' , 'FBB103B21AB64D67A674D81A5CA49872' , 'E61D29817B8F4272B6C114B00AA50C9B' , '669B03C55E26448E95A4748F3B184A24' , 'EFF3BEB2BD7446968FF8DF2EDC866BB5' , '61FBF25043074E3AB6F35FE0EDED4ECA' , '99B0E87344A6493A97080492A877DC6F' , '5A7EA173636840DD870AD0BA77201855' , '784C3FBC5F3A437D9DA9058D23C510C4' , '7895E4AC63624F4C997422882BC93EFD' , '6299C18801B84559ABEDBCD700B400B5' , '0C405E37F0E84589A85BCA3106F145F1' , 'F885C9C28130468AB1B9EB674DA55751' , '50E48A8190AF43458E684418A3357D58' , '167F4EFBD4624C7E82AC2838F265955F' , 'B2EA329169B0461D928B705B8CF3F740' , '08A69FF3AAA04D1EBC633CC0CA4F4436' , 'DCEAA922F5CE4235BEA5130CB6619CBF' , '1A4471C8EB3B4B17A5FB2D164B253920' , 'AC51AFCE07FE4581A9AD96A6755D0964' , '74D79BBA35A54773A62CDC4776B829B6' , '4FF0F96370F84DE28D531D8AF1B564BB' , '3958C338A3814E0B82F49D31A311D0E4' , '525E97CC8A7E482E8C90A9B383F70269' , 'DF8D62F087A44B94AE8875670C2C64AD' , '6DA33A8010ED44B8980DED9E36640616' , '7BE074956A59421F9CDCC96E7D05C863' , 'AF7B706B023A4983B779F4F15C3E7774' , '1024715DCB5948129790CF35D5A0072C' , '38226C5344A449AB8BE4B6B94388D5AE' , 'B1C85C2ED3C4488B8F07350551B27526' , 'C1D839CCDBE44A12AA0C0C52CB58B679' , 'C7F9AC3631E549EC8D0BA2F6BE400325' , '0760F16CBEFA45D2841B12450FAC42D4' , '38F18A5DE8A648809DD1E1D36A0C6BBD' , '1C935880EFF64008BD6467FE1FF58AD4' , '9A1AE81E157E4678A50D88D083D50E94' , '83863205FB0B483C8A8FAFBC59BB9C48' , '93FDFEDA4E074238BAF5608CB81404AF' , '7A1E39F5AC3046949D2914406CF386B5' , 'C2977532D3DB46309F1CC55514E66FDE' , '73D5CB0368FC4D6CA519260D9930C2F2' , '5CA97509D17D41C8BEBF7BE59B55A018' , 'C98655EA6B51411B8554D080322BFAD3' , '1928F6608C9045B0A88924EF02529C17' , '240D151DD6E54208A957C90B984766D3' , 'B858D5066B924A89B23C0447CE0759C4' , '338BE34065FE4573A9CE6F899913CD25' , 'CE47348DCC814F16B167D0A79272D8E0' , 'DE2CCD27DED242FB86B841729010434C' , 'E8B908ED5A4E468E9F73C5E2AD5A1E50' , '6B10F7305E254811B98AE5A90B77DDBF' , '6AD0AD7E93E5442F8E6B9D460D8E50EF' , '2E0A9B61357D43F89D8A89C72FBC70A0' , 'BBA7B7F240F445E0BA78D68A20D86995' , '730C0B85AD724A45BC88057E2FDB8EB1' , 'FDA2FE967DA14BFB8D7CEF49253F9A0C' , '048539E4F1C942649ABE0A01F957D53B' , '24C12BBFBDF44ACFAC5EB0807B0FF481' , '157B8C74FE8F4E4990BE08524325B5BB' , '980D5D38041143B9B56AD60C3FBAFF8E' , '9302E53359764BADBD9D71F011CE90CA' , '47DC8DB26488482C9782E81A5BD0A5CB' , '9F1933F423DB4E58A7053C1C18B9A398' , '7EB996CD402A4FD1B602D7AF089B1B7A' , '701EA4F52CBA4053AFCD55BAA914F884' , '1597B5574D714960A430B7A8487A5E4D' , 'C58DBBAA894D4C14995F5137D136507C' , '9E2EE3A7463C406F8C3C9FD3ED7CFB00' , 'D6B650EDEC8249B3AD362660F5A46214' , 'C09BAA7FDD9C4DFE9407404086E0232E' , 'F5B95F8103734B0C92E51B81E1C5A163' , '51C85E088D6946F3B99454B1CB7EE625' , 'B7444624A0A24FA7A9995AE3461876CB' , '12DF234F83B94B3EB401792DA1D4E46C' , 'F791FBE8ECDC40A4B90BD5EF86D9CD2A' , '5AB17733F76A4F8CBC25D2A72F58DC41' , 'B05DCF5695FD4F34AD1E2CBD2A68E0C9' , 'BB1C47DCF63149BF914E3091AE4777E9' , 'AC2529A2BF934F089669A7A23ED0A08A' , '7D167D2A05804CF588A3CFF055235609' , 'D975456F44E145CAB5AAD162523FFECE' , '073988092B7B4927B03B0C5706BDE8BB' , '72941C05D8604C6387DFBF768438D295' , 'E3C5A73A65C54148999556B59C0F44C1' , '9B7D4BE39240459AA8133D18824D0157' , '12BF55EA80B542F3AC59F33BC32EE34F' , 'B2EEAB1CE07D49FA80B9EA7D23AEBA76' , 'E8D587C97F4A44E4AF28456842ABF382' , 'E8A4E9FB38534FF2AA6D20D17C346419' , '2393ED384F9A4BFCB6D5CAA97A20FAD4' , 'E04B77DC3E394988B5B05B4C367DA4B5' , 'BC0F028F533B4F268A8135F17EB0CE30' , 'A3DFF8459AEB422BB6E983B2AC31CDA7' , 'DC4E95A5290F41878959AA40ACD37717' , '9F1003FCF9B146DEAD78BE873D3E2B0A' , '8667A53E486745F798E69D4600ED100C' , '570DC76A15BF4055A68CF060E7901685' , 'B22620E4B88C4716BDD0BE42FDFBEB83' , '2406AED2C58D4A5699DA62D26658BC6E' , '2A7CE45682494CA3AAC8C448BA96FD36' , 'A9ED8426970F478A8869986CBEE702FB' , '54991A6D5A784013B011C919208046E3' , 'D0177510CFEF4355B93C89F22EC59AB5' , '82B878A78D75460BABAACC388476EEB3' , '436BEB3D2B014CC59D557E26AFF8E419' , 'C1CBA93998E64144BC71FF58D3D9322D' , '6EF6818C4F384815A46B240CE9008BEC' , 'CF944E29E9E94FF2A0238A5EF27D80FC' , 'E20264615F294B6184739F0F28055DBF' , '3261A88339CD4CCA8C05107443AF1128' , 'F4A063FCA2E04CFDA564E4085DD23BDC' , '9838CCFDAC57419FA1C0D90703EA8F4A' , 'F3ABAD82C72D4C83A1A9B00CB65EAA23' , '2B54FEF139F94C6787094574B5E4C216' , '6DEFE9C4864145868C2E9FAAA5909983' , 'AF235D374D0F4C96A15F2DA6077766BF' , '6C49C6DB01BD4CFBB839A28230764A44' , 'E5240695C0E94A7E87A9B857CD650BAB' , 'C6F72E46B5D141C78474D178B9A3F9D8' , '7234540C502349C9A40112243B8C688B' , '7A7CA2D99D4446F29F9CBD1E9BBA1C35' , '7186156E473E4B9AB2F1CF8B88106146' , '09EFA5309AC74A309FA46D3B9EAF057C' , '587EF97450784DE087989686CBE51D40' , '9A9C2D9F4B01440D9EE14219BD04C24A' , '5AC4E37CB3F14DE3BAEEAED6DBDDFF26' , '81F70B65DB014FB1BFF4089D3E543740' , '08210831F94F4A99AF9E6A511AC1E8DF' , '6829B2C4C6CC4CD2863CAF9498AB499C' , '88E2EEA28CFF474EA278DCA8FA2B7DC1' , 'B30B8100589748CFB76BB06D66910515' , '7F527352A2534EFEB5AE73CEE66C1349' , 'D5737A004D214181A71267B4FD8EDF62' , '587E1E4A33F74F68AE165FF4D7E3B67C' , '521E421D818D4B59B398DDE7E836F4EE' , 'CA6371FE1E69448A89B98574FDD52960' , 'EEB74504E265429BAF10F972F2B11124' , '20FE6B957AA0408BA7FCC19E17D957CF' , '82666000B730421B98612D4344A1D628' , '478973BF4FF9478FA305BAC91081CB3F' , '5B7E244DEAFF4FF5B3689FAA20EE883D' , '965E534F68DF46A982FCA7D0153430E6' , '4E39B8550BDF4FBEA5EC3256250362C5' , '0E67F44CC43C45A7AAEF4F0170206F90' , '733006F35D2F4C56BECAD534688AE47A' , '3032DBA644F341C9813ABE910A05C5B7' , '5A531966519C4FA7AC4BD3511E4B09B7' , 'CCDEB1F8BB8C4E2091F371AEA975E30A' , 'D142D6D1ABAD47D49D9E764889E61F21' , 'E4CBBE24C0534B0C9CA28CCEA91CF522' , '905D34D5A4FD41C7AEAC8EBEC3EA6CC7' , 'A16A7DB0132B42A2B3882F4C845C9AD1' , '4D8F03578BB6492A85F90776F90109DA' , '5FA1C96660A549DEA3AF081D69E73CCB' , '3B3CEF60C1F143F092119ECA9BAB0E2E' , 'A3C50B722145464688A4507422A2F886' , 'F221C2F65AD84EB0A6D3B85772B82EB4' , '9AF439764D344CFF85497A713F288125' , '5E7499EB05E543DD9BA7662262EB37B7' , '408F791C21D44C78B1F9AEC4C2880234' , 'E9710D9DF58142CA82C084F63A37682A' , '1CEB3C8229DB45B6AE1B89214EC0EEE8' , 'F634F381864843FA852E9DE3EC696126' , 'CA2784F6B85F4D49A32D68ADA7B1D1C7' , 'F82DACB52D6C400B8AB2F5AC44F5FBFB' , '5B1EB0F2B94E4729BDE2505FC7B9100E' , '780227E5250B41DD93C682DBDFD13C57' , '940ECC09D2D24AF5AC708FC633EF6BA6' , '81E3886A3D0144B2BD4EEB669C711504' , '07A0A1B5808D41299CBF11B64D47EE32' , 'BFBE16565AB0494C88BA0D11A4AF1F88' , '620244EF03ED42CB832671D6EDF40956' , 'D611C392A3434305AFBB47D1512AAA59' , 'DEC4DA1DC5374972891916FE40F61648' , '22C5D4FFB67E414EBCE8DA02CE579612' , 'BB8F0D1946474DE6A9EEA1F436C4452F' , '906700E60E6945DFB403E2D6D97AB3DC' , '54CE6D5B7909421AA9C3A9DB5F799C43' , 'AEECF1BD486C44E4BC261589AC38BFA5' , '95981B6913D84EDAB1D94EFFBFB0CBC5' , '4BC8451292664B618D7B5DD56B89734D' , '9285CC974A984BBD882FF396979AABD3' , '9D5AA88F15EE40CEA0AE8944B2989506' , 'E5CC53F9EE314E5AAFCD412574D09A2E' , '4342ECF47A6045E1A0C12078E37B61F4' , 'D50A18A0C00E47328000A8DB3958E6F0' , 'ABCED49B96F14FD6B3856A816BE1A756' , 'ECE03BABC74D4E418D1B5DE916F9C530' , 'B095EDCD43504236BC013D3798C04FD1' , 'D1DDA78EB3364D25ABC5A53ECA53555E' , '8D0BD91C1FA6442DADBBBDB41F1C2936' , 'ADB4A5D1D36E42E49297AE3917BDA187' , '751C26037E9448B99E5032C2E3C88F41' , '3B6AE7BB65F34F66B989411FC2F0055B' , 'EB68AC15A8B84E5D9E89305CF16177F3' , 'A50517AA32994D3CAE7A5AE5E35A3406' , '3A02FFAE48E142DA9A411F8E30F0A8F8' , 'F3206843CF284581AADE146E067FE50D' , '776966F23C384C8C90D45771EB797BE1' , 'E428FBC1E6FC4FE98F04EEB440BC33F2' , '77CC193361D547DCBBC5BDD3F4645BE9' , '819FBD0F523F4763936610F0257ECA38' , 'CC35701B75F8475D8ECD7136D173E077' , '9C92726846404FF7A11631446F074132' , '88EC10BA08E24093AED85EB300D3ADDF' , '2582441C64384056823538726B5E5FAB' , 'FA5B04011F2C401E8AE1E88AAF494B49' , '7A569819B4B94975B6303BF479232398' , '53716DA84625417BB8D40DCF0F4AC640' , '8878376030D04E22B21E1B3CAEA85949' , 'D25DD7D200514E3CB49D6F57F2D722CA' , '514B2DA524B946DFA3AE9C1225F7DCB6' , '739BBB8D20784F498ACE97EC0A6972D6' , 'BAFB4AD71D9A4E6281DFB90C1A621B5D' , 'EC1D951ECF5246BA864A64B7255BDA5F' , 'B2C9A179733D4A468A4242873029B00E' , '2779C98C2E1A4C47833E912B38A528AA' , 'F5A2FFE45FF24C1FA6F2D675B631352F' , 'FF2C689A5F634A09BFCCD82826296191' , 'AD8E86543C9148BAB954739D97E29ECF' , 'ABCC171E0BAF49AABDC149DA455A34D5' , '320096A972D5403DBB593BE1668857EA' , '07D373EA01064815B0F0F4E066DB7DA7' , 'DFEB3AE28E684CA7B6BCCB2D7FB7623F' , '9DDEE504A05948588C24D670A896F071' , 'FB81477BE8574CB48E36D34DBC0066D2' , '64F0648166054F49B4B272CB63243AE6' , 'DB84831BDE61409BBC2D013F794C73A9' , '7CF41127D47B47D698DB5BCA86F0B2C9' , '3AD78108E6694F40994982E46E9CA400' , '2D6EF34D9453423391EC35BDB4E3C8E1' , '0F3345F3D38F41F683461A2C58050658' , 'BCDD1E90D9CB4B2CB158C09FD20DA823' , '72240D2EB5A5494EA432444F1166B4C2' , 'FF12C37545EE490D9841F5E20F185F0B' , '07883AE145EC49E09F40027A4A5448BC' , '4DE90353322F476FAFB4615EE0E62354' , '4B0AB71D756F4F36906A420B472CD900' , '11A1B8F73BAB45D692DB3E71D266B4AB' , '9B7057B8F9F94C42B58811BCBA83D974' , '3EFCDD8AE7E74BDCA2B78C69B34ADBAA' , '773957E45AF64A91B27AF2302F7B911A' , 'BD3C47EC0E034EFBBE824034C2B225FB' , 'C17DDF41942849B083E7D83CAB953AC7' , '551C234B43E44329A1EE4A31908EE120' , 'A64520E2A0BB4C71B000C691AF4BDE47' , 'C4D8C9E6A6434FBEB357B9773272E3DF' , 'A237DB7C2BCE4669AB0BF565B9877E48' , '9D5CF616962647AC96210880A4D4F0EE' , '24424835882049AC90B017A93D3427B9' , 'F0FFCB264CDB48218D0C810D0ACCA887' , '573C95ED0FBB469AA0DC2B559C2FBF1E' , '7D54E11E001E4B048647332BADBDC0C9' , '1CD3D3504A4F4348AC3D509297E8E8FB' , '2472EFBFF60944ECB1C1412E17F098F9' , '3DC0BE5CCDD74406954A40575C8397D7' , '402365919EA147BC8896EA84EEF316CA' , 'F7D0C5455B1B472BA13A52D6C0CC67C7' , '725FF3D78006498087476EDD2D0774C0' , '18E3ACFCB71247589CBB3D26FDA56913' , '970CCED57EDC49CC92FE9C22A4218D5A' , 'AF322DF57AEA4E4DA6DF03E876F988E5' , 'C80FEF28CBEC4E9CBD4174D5560B2561' , '007631AC24F542E595FBC98D5DC32498' , '878CBB17CD094FB4A44F6304F99462EB' , '1BA369944720403E815BFD931D76CB2B' , '19403221B96D470CADE052A62D3C57B3' , '8B9D3E06997B47F49C49F5CB6F40DF59' , '7168A6EEBD8644688C20DC6A459AF262' , '909BE3F0E76D4BEC8B2A40F7F72E9F97' , 'CB12003393CF40CFB938725CBB0FF182' , '05B757772A5B4F3394F734B27328A4F1' , 'A53CA01D5A394BC3AFD5D0BE9FD4687F' , 'CE3E6CFE8B674541A94F6AABF2AC86C4' , 'D5F4C67FF4A946069C3BFEA34B169F5F' , '5339B4C139D2427793B7C1BD1768BE3A' , 'BDDAE469B4244649B36B6504835F1BD7')) and (locator0_.AD_Client_ID in ('B8D74EB90D8A422F900F442C2D721C2E' , '0')) and locator0_.IsActive='Y' order by locator0_.PriorityNo, locator0_.M_Locator_ID limit ?
  t:1
     $1: EB95AA8B504B4FA388AAD5FF4DB962A1
     $2: 1
java.lang.Exception
    at org.openbravo.base.PoolInterceptor$PSInvokationHandler.invoke(PoolInterceptor.java:99)
    at com.sun.proxy.$Proxy23.executeQuery(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    at org.hibernate.loader.Loader.doQuery(Loader.java:802)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.doList(Loader.java:2533)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.openbravo.dal.service.OBQuery.list(OBQuery.java:118)
    at org.openbravo.retail.posterminal.OrderLoader.createShipmentLines(OrderLoader.java:1230)
    at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:377)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:235)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:192)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:98)
    at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:41)
    at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:59)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:370)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:292)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to feature request 0033767 closed platform Openbravo ERP Add code to auto-detect 'accidental double query' on same OBQuery or OBCriteria object 
related to defect 0033788 closed Sandrahuguet Retail Modules OrderLoader.createShipmentLines query to m_locator could be optimized away 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-06 14:23shuehnerNew Issue
2016-06-06 14:23shuehnerAssigned To => Retail
2016-06-06 14:23shuehnerTriggers an Emergency Pack => No
2016-06-06 14:23shuehnerTag Attached: Performance
2016-06-06 14:25shuehnerNote Added: 0087032
2016-08-24 10:51shuehnerRelationship addedrelated to 0033788
2016-08-24 10:51shuehnerNote Deleted: 0087032
2016-08-24 11:00shuehnerNote Added: 0089334
2016-08-24 11:01hgbotCheckin
2016-08-24 11:01hgbotNote Added: 0089335
2016-08-24 11:01hgbotStatusnew => resolved
2016-08-24 11:01hgbotResolutionopen => fixed
2016-08-24 11:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5dea1f5af9e03017da675e7a4d8058af3022ec24 [^]
2016-08-24 11:02shuehnerReview Assigned To => mtaal
2016-08-24 15:01shuehnerRelationship addedrelated to 0033767
2016-08-24 15:01shuehnerAssigned ToRetail => shuehner
2016-08-29 09:34mtaalNote Added: 0089481
2016-08-29 09:34mtaalStatusresolved => closed
2016-08-29 09:34mtaalFixed in Version => RR16Q4

Notes
(0089334)
shuehner   
2016-08-24 11:00   
Also auto-detected by debugging code in: https://issues.openbravo.com/view.php?id=33767 [^]
(0089335)
hgbot   
2016-08-24 11:01   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5dea1f5af9e03017da675e7a4d8058af3022ec24
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Aug 24 10:53:30 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5dea1f5af9e03017da675e7a4d8058af3022ec24 [^]

Fixed 33158. Remove accidental double query to m_locator.

Don't call .list() two times on same instance as that leads to double sql query

As the query already had a setMaxResult(1) we can simplify it to use .uniqueResult()
and avoid the list().get(0) making it a bit easier to read also.

---
M src/org/openbravo/retail/posterminal/OrderLoader.java
---
(0089481)
mtaal   
2016-08-29 09:34   
Reviewed and closed