RE: Problem in approving internal requests thru order manager after MRP run

[Sharan-F <sh...@gmail.com>]

Hi Ejaz

For  info - What OFBiz tries to do when you approve the Internal Requirement
is to create a Production Run.

I did run a test through 12.04 and got an error too so took a copy of the
log (see below).  I’m not sure if this is the exact same issue you
encountered. 

The first thing to point out is that I’m running OFBiz using a server based
in New Zealand and I’m in Europe so there is a time difference of 11 hours
as they are ahead of me.

Going through that 5 Step Manufacturing scenario – when I created the BOM
for the wood, nails and varnish all the default dates and timestamps are
taken from the NZ server by default (so in my case this was  06.43am on 29th
March 2013) although in Europe it was  only 16.43 on* 28th March 2013.*

I ran MRP ran but when I tried to approve the Internal Requirement in Order
Manager for the table (as you did) – I got the error message because it says
that no production run is required as at 17.29 on 28th March. I think this
is because the BOM isnt active until 29th March 2013 at 06.43am.

It seems that in some cases the default date used by OFBiz is the system
date and other times it is the user’s local date and time. 

Please check to see if this could be the source of your error.  If so then I
think you’ll be able to correct it by  

•	Updating the start dates and times for the BOM (don’t forget to do the
table product linked the BOM and routing too)
•	By waiting until the BOM is active and re-running MRP

Hope this helps.

Thanks
Sharan

See below for an extract of the log file.

2013-03-29 06:53:54,136 (http-bio-0.0.0.0-8443-exec-28) [
ServiceEcaRule.java:157:INFO ] Running Service ECA Service:
createProductionRunFromRequirement, triggered by rule on Service:
updateRequirement 
2013-03-29 06:53:54,190 (http-bio-0.0.0.0-8443-exec-28) [
ServiceDispatcher.java:525:ERROR] Error in *Service
[createProductionRunsForProductBom]: No production run is required for
product with id 10003 in date 2013-03-28 17:29:59.995; please verify the
validity dates of the bill of materials and routing. *
2013-03-29 06:53:54,199 (http-bio-0.0.0.0-8443-exec-28) [
TransactionUtil.java:379:WARN ] ---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening: Exception: java.lang.Exception
Message: Error in Service [createProductionRunsForProductBom]: No production
run is required for product with id 10003 in date 2013-03-28 17:29:59.995;
please verify the validity dates of the bill of materials and routing. ----
stack trace ---------------------------------------------------------------
java.lang.Exception: Error in Service [createProductionRunsForProductBom]:
No production run is required for product with id 10003 in date 2013-03-28
17:29:59.995; please verify the validity dates of the bill of materials and
routing.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:379)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:320)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:529)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:225)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163)
org.ofbiz.manufacturing.jobshopmgt.ProductionRunServices.createProductionRunFromRequirement(ProductionRunServices.java:2243




--
View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-in-approving-internal-requests-thru-order-manager-after-MRP-run-tp4639893p4640485.html
Sent from the OFBiz - User mailing list archive at Nabble.com.