You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jl...@apache.org on 2021/02/23 12:03:27 UTC

[ofbiz-framework] branch release18.12 updated: Fixed: Error while running MRP (OFBIZ-12187)

This is an automated email from the ASF dual-hosted git repository.

jleroux pushed a commit to branch release18.12
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git


The following commit(s) were added to refs/heads/release18.12 by this push:
     new 8a287a3  Fixed: Error while running MRP (OFBIZ-12187)
8a287a3 is described below

commit 8a287a306a933e00085f983b6248f7a670c2afac
Author: Jacques Le Roux <ja...@les7arts.com>
AuthorDate: Tue Feb 23 12:59:46 2021 +0100

    Fixed: Error while running MRP (OFBIZ-12187)
    
    I tried running MRP for Sales Forecast option and it returned the following error.
    
    Error running the initMrpEvents service: Service [initMrpEvents] target threw
    an unexpected exception (java.sql.Timestamp cannot be cast to java.sql.Date)
    
    Thanks: Nameet Jain
    
    Conflict handled by hand
---
 .../src/main/java/org/apache/ofbiz/manufacturing/mrp/MrpServices.java  | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/applications/manufacturing/src/main/java/org/apache/ofbiz/manufacturing/mrp/MrpServices.java b/applications/manufacturing/src/main/java/org/apache/ofbiz/manufacturing/mrp/MrpServices.java
index ec453f9..faf0d8e 100644
--- a/applications/manufacturing/src/main/java/org/apache/ofbiz/manufacturing/mrp/MrpServices.java
+++ b/applications/manufacturing/src/main/java/org/apache/ofbiz/manufacturing/mrp/MrpServices.java
@@ -472,7 +472,8 @@ public class MrpServices {
                             continue;
                         }
                         eventQuantityTmp = eventQuantityTmp.negate();
-                        parameters = UtilMisc.toMap("mrpId", mrpId, "productId", productId, "eventDate", customTimePeriod.getDate("fromDate"), "mrpEventTypeId", "SALES_FORECAST");
+                        parameters = UtilMisc.toMap("mrpId", mrpId, "productId", productId, "eventDate", customTimePeriod.getTimestamp("fromDate"),
+                                "mrpEventTypeId", "SALES_FORECAST");
                         try {
                             InventoryEventPlannedServices.createOrUpdateMrpEvent(parameters, eventQuantityTmp, null, sfd.getString("salesForecastDetailId"), false, delegator);
                         } catch (GenericEntityException e) {