Comments inline.
On Sun, 07 Apr 2013 21:41:57 +0530, Sharan-F <[email protected]> wrote:
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.
When someone uses a datetime picker, he might select the time according to
his local clock. However server's clock might differ, one can check the
server time in the bottom right corner. If he does not select any time at
all, it is considered as 0:00
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.
--
Using Opera's revolutionary email client: http://www.opera.com/mail/
