Comments inline.
On Sun, 07 Apr 2013 21:41:57 +0530, Sharan-F <
[hidden email]> 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/
Locked
