Hi Jacopo
I have created a sales order and scheduled a sales shipment for that order after approval of order requirement created under Order Manager -->Requirements and Shipment Plan created under Manufacturing --> Shipment Plan which is absolutely fine, but on click , Shipment Id throws exception. After that I did Bom simulation and exploded the BOM for product id basket ball (finished good whose sale order for qty= 6000.). Now the raw material required to produce was not sufficient in inventory then I then check the requirements through Order Manager, if requirements would have automatically created to purchase the raw material required to produce the basket ball. but I didn't find any requirement. Then I run MRP for facility(having common facility for raw material and finished good). It was pending. but when i again refresh the page it failed and throw following exception at ofbiz log [java] 2009-09-10 12:53:50,153 (http-0.0.0.0-8443-2) [ ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] [java] 2009-09-10 12:53:50,231 (http-0.0.0.0-8443-2) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 requests, 13 views in file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB-INF/common-controller.xml [java] 2009-09-10 12:53:50,237 (http-0.0.0.0-8443-2) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.027s, 148 requests, 69 views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml [java] 2009-09-10 12:53:50,547 (http-0.0.0.0-8443-2) [ RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 [java] 2009-09-10 12:53:50,593 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 3 screens in 0.04s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/MrpScreens.xml [java] 2009-09-10 12:53:50,789 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.035s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/CommonScreens.xml [java] 2009-09-10 12:53:50,822 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/CommonScreens.xml [java] 2009-09-10 12:53:50,930 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 22 screens in 0.027s from: file:/home/Preeti/ofbiz-release9.04/framework/common/widget/CommonScreens.xml [java] 2009-09-10 12:53:51,132 (http-0.0.0.0-8443-2) [ ServiceDispatcher.java:584:INFO ] Sync service [manufacturing/getVisualThemeResources] finished in [195] milliseconds [java] 2009-09-10 12:53:51,565 (http-0.0.0.0-8443-2) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:53:51,568 (http-0.0.0.0-8443-2) [ ModelForm.java:1368:INFO ] preparePager: Found rows = 4 [java] 2009-09-10 12:53:51,641 (http-0.0.0.0-8443-2) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:53:51,643 (http-0.0.0.0-8443-2) [ ModelForm.java:1368:INFO ] preparePager: Found rows = -1 [java] 2009-09-10 12:53:51,996 (http-0.0.0.0-8443-2) [ ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request Done- total:1.842,since last([FindInventoryEve...):1.842]] [java] 2009-09-10 12:55:01,463 (http-0.0.0.0-8443-1) [ ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] [java] 2009-09-10 12:55:01,516 (http-0.0.0.0-8443-1) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 requests, 13 views in file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB-INF/common-controller.xml [java] 2009-09-10 12:55:01,523 (http-0.0.0.0-8443-1) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.022s, 148 requests, 69 views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml [java] 2009-09-10 12:55:01,529 (http-0.0.0.0-8443-1) [ RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 [java] 2009-09-10 12:55:01,564 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 3 screens in 0.029s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/MrpScreens.xml [java] 2009-09-10 12:55:01,755 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/CommonScreens.xml [java] 2009-09-10 12:55:01,806 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.041s from: file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/CommonScreens.xml [java] 2009-09-10 12:55:01,915 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 22 screens in 0.067s from: file:/home/Preeti/ofbiz-release9.04/framework/common/widget/CommonScreens.xml [java] 2009-09-10 12:55:01,977 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:584:INFO ] Sync service [manufacturing/getVisualThemeResources] finished in [55] milliseconds [java] 2009-09-10 12:55:02,329 (http-0.0.0.0-8443-1) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:55:02,332 (http-0.0.0.0-8443-1) [ ModelForm.java:1368:INFO ] preparePager: Found rows = 4 [java] 2009-09-10 12:55:02,400 (http-0.0.0.0-8443-1) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:55:02,402 (http-0.0.0.0-8443-1) [ ModelForm.java:1368:INFO ] preparePager: Found rows = -1 [java] 2009-09-10 12:55:02,904 (http-0.0.0.0-8443-1) [ ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request Done- total:1.44,since last([FindInventoryEve...):1.44]] Thanks Preeti Verma Jacopo Cappellato-4 wrote: > > If it fails, then the data that you see in the screen doesn't belong > to this run, but to the last successful one. > I'd suggest to look at the OFBiz log and see what is the error thrown > there when the MRP fails... if you can send the relevant portion of it > I may have a look at it > > Jacopo > > > On Sep 8, 2009, at 9:33 AM, Pal InfoCom Technologies wrote: > >> >> Hi Jacopo >> >> In MRP Log, application automatically assigns the Job Id , Job name. >> but >> after we refresh that page it fails that mrp by dsiplaying its >> Status Id as >> "failed" >> >> but if i want to see the Inventory events it displays the follwing >> data : >> >> Type >> >> Desc Date >> Qty. Total >> >> [RubberBasket] Raw material ] Facility: 10030 >> 4550 >> Minimum Stock: 5507 >> Reorder Quantity: 1000 >> Days To Ship: >> >> >> Manufacturing Order requirement >> 10147-10148 2009-08-18 16:23:26. -30 4520 >> >> >> where rubber basket is the raw material for finished good - basket >> ball, >> minimum stock , reorder qty. are the values set through Product--> >> Facility >> tab. Unable to understand how is it taking the Manufactuing Order >> requirement values. >> >> Also please help that how will requirements be created under Order >> Module >> --> Requirements for raw material when it will reach its minimum >> stock. >> >> We are using current version of Ofbiz - 9.04 >> >> Looking for your advise >> >> Thanks and regards, >>> Preeti Verma >>> >>> Configurator cum Business Analyst : OFBiz Projects , >>> Pal InfoCom Technologies, >>> Mohali - India >>> >> >> >> >> Jacopo Cappellato-4 wrote: >>> >>> Hi Ajay, >>> >>> On Sep 8, 2009, at 6:17 AM, Pal InfoCom Technologies wrote: >>> >>>> >>>> Hello All, >>>> >>>> We are facing a problem in creating requirements for raw material. >>>> We >>>> have set the Requirement Method Enum Id as 'Requirement for order >>>> when ATP >>>> Reaches Minimum Stock for Product Facility' >>> >>> the above is not required when you use MRP >>> >>>> and set the Minimum Stock and >>>> Reorder Quantity and Days to Ship through Product---->Facilities >>>> tab. Now >>>> after running MRP through Manufacturing Inventory Event is planned. >>>> but we >>>> didn't find any entry for Requirements in Order---> Requirements >>>> tab. >>>> >>> >>> What is the content of the MRP log screen? Do you have inventory on >>> hand for that product? What OFBiz version are you using? >>> >>> Cheers, >>> >>> Jacopo >>> >>>> >>>> Please suggest any solution to this problem. >>>> >>>> -- >>>> Thanks and regards, >>>> Ajay Sodhi >>>> >>>> Software Engineer, >>>> Pal InfoCom Technologies, >>>> Mohali - India >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/Problem-in-MRP-tp25339749p25339749.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>> >>> >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/Problem-in-MRP-tp25339749p25341165.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://www.nabble.com/Problem-in-MRP-tp25339749p25379365.html Sent from the OFBiz - User mailing list archive at Nabble.com.