Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DDDA9DED6 for ; Fri, 10 Aug 2012 21:57:53 +0000 (UTC) Received: (qmail 10774 invoked by uid 500); 10 Aug 2012 21:57:53 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 10683 invoked by uid 500); 10 Aug 2012 21:57:53 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 10675 invoked by uid 99); 10 Aug 2012 21:57:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 21:57:53 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [93.17.128.121] (HELO smtp25.services.sfr.fr) (93.17.128.121) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 21:57:46 +0000 Received: from filter.sfr.fr (localhost [127.0.0.1]) by msfrf2517.sfr.fr (SMTP Server) with ESMTP id 5BC3D70000A0 for ; Fri, 10 Aug 2012 23:57:22 +0200 (CEST) Received: from inspiron530 (35.4.14.81.rev.sfr.net [81.14.4.35]) by msfrf2517.sfr.fr (SMTP Server) with SMTP id 22EBB700009A for ; Fri, 10 Aug 2012 23:57:22 +0200 (CEST) X-SFR-UUID: 20120810215722143.22EBB700009A@msfrf2517.sfr.fr Message-ID: <71E3390EBE1A45A5B5DC5810E8A954CA@inspiron530> From: "Jacques Le Roux" To: References: <50243F56.2000901@gmx.net> <50253354.3070304@gmx.net> <5025382D.8060300@gmx.net> <50253B8D.5050800@gmx.net> Subject: Re: Inventory QOH/ATP always 0 Date: Fri, 10 Aug 2012 23:57:08 +0200 Organization: Les Arts Informatiques MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=response Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-Virus-Checked: Checked by ClamAV on apache.org Not sure about it, but could related to MySQL 5.5 see http://markmail.org/message/r27vavebgy3rnp2s http://markmail.org/message/4be7wsehyxpddnrv You can find more using http://ofbiz.markmail.org/search/?q=MySQL+milliseconds Jacques From: "Leonard Lin" >I changed my 10.04.02 version to back to derby > > and see there the inventory shows up correctly. > > I'm using MySQL 5.5 on Windows with latest java connector 5.1.21.jar > > are there any known configuration issues with MySQL that may lead to this problem? > > On 8/10/2012 09:34, Leonard Lin wrote: >> I have hardcoded the line like this: >> >> >> no change after restart, >> flushed cache. >> >> Is it maybe a db thing? >> I use on the 10.04.02 version mysql >> for the trunk I use derby. >> >> On 8/10/2012 09:20, Mike wrote: >>> Just curious. Have you tried the 10.04.02 version with just "cache=false"? >>> >>> On Fri, Aug 10, 2012 at 9:14 AM, Leonard Lin wrote: >>> >>>> Hi, >>>> >>>> Sorry I forgot to mention that I'm using 10.04.02. >>>> It looks kind of similar to: >>>> http://markmail.org/message/**lnyki6w2vmrmhgup >>>> http://markmail.org/message/**ldbyr5sm5jpthcea >>>> >>>> I compared the patch from that mentioned thread to the 10.04.02, as far as >>>> I can tell, the changes are included in 10.04.02 >>>> >>>> I downloaded ofbiz-trunk-2012-08-09-**v1371163 and checked there. >>>> The inventory shows up there correctly and inventory bookings work as >>>> expected. >>>> >>>> I compared the InventoryServices.xml >>>> >>>> Trunk Version: >>>> >>> value="true" type="Boolean"> >>>> >>>> >>> list="inventoryItems" use-cache="true"/> >>>> >>>> >>> map="lookupFieldMap" list="inventoryItems" use-iterator="true" >>>> use-cache="false"/> >>>> >>>> >>>> >>>> >>>> >>> value="INV_NS_RETURNED"/> >>>> >>>> 10.04.02 version has: >>>> >>> list="inventoryItems" use-iterator="true" use-cache="${parameters.** >>>> useCache}"/> >>>> >>>> I applied the differences to my 10.04.02 installation, restarted. >>>> but still same results. >>>> >>>> Can someone give me any recommendation? >>>> I assume it is an known issue? >>>> Should I just go with the trunk version? >>>> >>>> >>>> Thanks in advance for any advice >>>> >>>> Leonard >>>> >>>> >>>> >>>> On 8/9/2012 15:53, Leonard Lin wrote: >>>> >>>>> Hi, >>>>> >>>>> I've been using the "Getting Started With Apache OFBiz Manufacturing & >>>>> MRP In 5 Easy Steps" >>>>> guide. After running MRP, Unfortunately I can't get the Inventory to work. >>>>> >>>>> When I go to: >>>>> Facility Manager->Facilities->(Select my Facility)->Inventory->Click on >>>>> "Find" >>>>> it always shows for all products QoH = 0 and ATP = 0. >>>>> >>>>> I tried "physical inventory", "receive inventory" through purchase orders >>>>> as well as"receive inventory" without purchase order. >>>>> - I do see Inventory Items created >>>>> - I see in Inventory Items Detail: >>>>> Quantity on Hand Diff: 150 (the right amount) >>>>> Available To Promise Diff: 150 >>>>> >>>>> But the Inventory Tab and the "Inventory Item Totals" Tab always remains >>>>> QoH=(Empty), ATP=(Empty) >>>>> >>>>> Subsequently my production job doesn't run. >>>>> >>>>> Could someone help me telling me what I'm do wrong? >>>>> >>>>> Thanks in advance for any help >>>>> >>>>> Best >>>>> Leonard >>>>> >>>>> >>>> -- >>>> >>>> Leonard Lin >>>> Email: leonard.lin@gmx.net >>>> >>>> 1136 N Larrabee Street, Apt 425 >>>> West Hollywood, CA 90069 >>>> Phone: +1 (213) 249 3260 >>>> >>>> Am Pfisterhölzli 2 >>>> CH - 8606 Greifensee >>>> Switzerland >>>> Phone: +41 (0)79 416 01 07 >>>> >>>> >> > > -- > > Leonard Lin > Email: leonard.lin@gmx.net > > 1136 N Larrabee Street, Apt 425 > West Hollywood, CA 90069 > Phone: +1 (213) 249 3260 > > Am Pfisterhölzli 2 > CH - 8606 Greifensee > Switzerland > Phone: +41 (0)79 416 01 07 >