[ 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)