[ 
https://issues.apache.org/jira/browse/OFBIZ-12187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869090#comment-17869090
 ] 

Jacques Le Roux commented on OFBIZ-12187:
-----------------------------------------

I noticed something that could be related to OFBIZ-12187. that has no impact on 
the MRP run but is not totally clean.

Normally when a PersistedServiceJob is run you get something like

{noformat}
2024-07-22 19:02:52,378 |OFBiz-JobQueue-1     |PersistedServiceJob           
|I| Job  [Send Email] Id [16405] 
-- Next runtime: Mon Jul 22 19:17:52 CEST 2024
2024-07-22 19:02:52,378 |OFBiz-JobQueue-0     |PersistedServiceJob           
|I| Job  [Send Email] Id [16404] 
-- Next runtime: Mon Jul 22 19:17:52 CEST 2024
{noformat}

So you have somethink like this:
bq. Next runtime: Mon Jul 22 19:17:52 CEST 2024

But when you run a MPR you get:
{noformat}
2024-07-22 19:11:50,312 |jsse-nio-8443-exec-3 |ControlServlet                
|T| 
[[[runMrpGo(Domain:https://localhost)] Request Done- total:0.398,since 
last([runMrpGo(Domain:...):0.398]]
2024-07-22 19:11:52,481 |OFBiz-JobQueue-0     |PersistedServiceJob           
|I| Job  [1721668310012] Id [16532] 
-- Next runtime: Thu Jan 01 00:59:59 CET 1970
2024-07-22 19:11:52,514 |OFBiz-JobQueue-0     |MrpServices                   
|I| executeMrp called
{noformat}

Note the
bq. -- Next runtime: Thu Jan 01 00:59:59 CET 1970

It has no impact on the MRP run beause there is no next job run. It's an only 
one job run. But that's a wrong information in log.

I'll see if we can make a workaround that by checking if we have a "Sales 
Forecast option", not a big deal anyway.





> Error while running MRP
> -----------------------
>
>                 Key: OFBIZ-12187
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-12187
>             Project: OFBiz
>          Issue Type: Bug
>          Components: manufacturing
>    Affects Versions: Trunk
>            Reporter: Nameet Jain
>            Assignee: Jacques Le Roux
>            Priority: Major
>             Fix For: 17.12.06, 18.12.01
>
>         Attachments: OFBIZ-12187.patch
>
>
> I tried running MRP for Sales Forecast option and it returned the following 
> error.
> {code:java}
> Error running the initMrpEvents service: Service [initMrpEvents] target threw 
> an unexpected exception (java.sql.Timestamp cannot be cast to 
> java.sql.Date){code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to