Hi Jacques Le Roux ,
i have change the new version and try to create a sale order but i get this
error
|E| Failure in create operation for entity [SalesOrderItemFact]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.)). Rolling back transaction.
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |ServiceDispatcher
|T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'order
/ loadSalesOrderItemFact'
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |ServiceDispatcher
|T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'order
/ loadSalesOrderFact'
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |ServiceDispatcher
|T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'order
/ changeOrderItemStatus'
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2025-05-26 13:01:59,840 |jsse-nio-8443-exec-3 |OrderChangeHelper
|E| Service invocation error, status changes were not updated for order
#10010
org.apache.ofbiz.service.GenericServiceException: Error running Groovy
method [loadSalesOrderFact] in Groovy file
[component://bi/groovyScripts/FactServices.groovy]:
(org.apache.ofbiz.service.GenericServiceException: Error running Groovy
method [loadSalesOrderItemFact] in Groovy file
[component://bi/groovyScripts/FactServices.groovy]:
(org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.)) (Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.)))))
at
org.apache.ofbiz.service.engine.GroovyEngine.runSync(GroovyEngine.java:138)
~[main/:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:429)
~[main/:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
~[main/:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93)
~[main/:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:158)
~[main/:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:162)
~[main/:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:196)
~[main/:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:533)
~[main/:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:244)
~[main/:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93)
~[main/:?]
at
org.apache.ofbiz.order.order.OrderChangeHelper.orderStatusChanges(OrderChangeHelper.java:154)
~[main/:?]
at
org.apache.ofbiz.order.order.OrderChangeHelper.approveOrder(OrderChangeHelper.java:73)
[main/:?]
at
org.apache.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:1326)
[main/:?]
at
org.apache.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:1091)
[main/:?]
at
org.apache.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:620)
[main/:?]
at
org.apache.ofbiz.order.shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java:584)
[main/:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method) ~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:85)
[main/:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1080)
[main/:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:678)
[main/:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:864)
[main/:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:864)
[main/:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231)
[main/:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96)
[main/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
[tomcat-servlet-api-9.0.104.jar:4.0.FR]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
[tomcat-servlet-api-9.0.104.jar:4.0.FR]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
[tomcat-embed-websocket-9.0.82.jar:9.0.82]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:188)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:236)
[main/:?]
at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:53)
[tomcat-servlet-api-9.0.104.jar:4.0.FR]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:70)
[log4j-web-2.24.2.jar:2.24.2]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:656)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
[tomcat-catalina-9.0.104.jar:9.0.104]
at
org.apache.coyote.http2.StreamProcessor.service(StreamProcessor.java:464)
[tomcat-coyote-9.0.104.jar:9.0.104]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
[tomcat-coyote-9.0.104.jar:9.0.104]
at
org.apache.coyote.http2.StreamProcessor.process(StreamProcessor.java:102)
[tomcat-coyote-9.0.104.jar:9.0.104]
at
org.apache.coyote.http2.StreamRunnable.run(StreamRunnable.java:35)
[tomcat-coyote-9.0.104.jar:9.0.104]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
[tomcat-util-9.0.104.jar:9.0.104]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
[tomcat-util-9.0.104.jar:9.0.104]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
[tomcat-util-9.0.104.jar:9.0.104]
at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
Caused by: org.codehaus.groovy.runtime.InvokerInvocationException:
org.apache.ofbiz.service.GenericServiceException: Error running Groovy
method [loadSalesOrderItemFact] in Groovy file
[component://bi/groovyScripts/FactServices.groovy]:
(org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.)) (Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.))))
at
org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:113)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1254)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1030)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:814)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.GroovyObject.invokeMethod(GroovyObject.java:39)
~[groovy-3.0.21.jar:3.0.21]
at groovy.lang.Script.invokeMethod(Script.java:96)
~[groovy-3.0.21.jar:3.0.21]
at
org.apache.ofbiz.service.engine.GroovyEngine.runSync(GroovyEngine.java:110)
~[main/:?]
... 62 more
Caused by: org.apache.ofbiz.service.GenericServiceException: Error running
Groovy method [loadSalesOrderItemFact] in Groovy file
[component://bi/groovyScripts/FactServices.groovy]:
(org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.)) (Error while inserting:
[GenericEntity:SalesOrderItemFact][account,IEIPL
Store(java.lang.String)][billToCustomerDimId,_NA_(java.lang.String)][brand,POS
Channel(java.lang.String)][createdStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][createdTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][lastUpdatedStamp,2025-05-26
13:01:59.825(java.sql.Timestamp)][lastUpdatedTxStamp,2025-05-26
13:01:59.145(java.sql.Timestamp)][orderDateDimId,_NF_(java.lang.String)][orderId,10010(java.lang.String)][orderItemSeqId,00001(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][pod,Engish(java.lang.String)][productDimId,_NF_(java.lang.String)][productStoreId,10000(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ITEM_APPROVED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.SALES_ORDER_ITEM_FACT (ORDER_ID, ORDER_ITEM_SEQ_ID,
ORDER_DATE_DIM_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, PRODUCT_CATEGORY_ID, PRODUCT_STORE_ID,
SALES_CHANNEL_ENUM_ID, STATUS_ID, BRAND, POD, ACCOUNT, QUANTITY,
EXT_GROSS_AMOUNT, EXT_GROSS_COST, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT,
EXT_SHIPPING_AMOUNT, EXT_TAX_AMOUNT, G_S, G_M_S, G_M_P, G_S_S, G_S_C,
G_S_P, G_P, COUNT_ORDER, PRODUCT_PROMO_CODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (INSERT on table 'SALES_ORDER_ITEM_FACT' caused a violation of
foreign key constraint 'SOIF_ORDERDATE' for key (_NF_). The statement has
been rolled back.))))
i am getting the same error in 22 version also, please give the solution
for this
On Sun, 25 May 2025 at 13:17, Jacques Le Roux <[email protected]>
wrote:
> Hi Balamurugan,
>
> You missed to send the error message. Moreover you should not use OFBiz
> 22.01. This version has abandoned, without any release, in profit of 24.09.
> You can download the 1st release of 24.09 at
> https://ofbiz.apache.org/download.html
>
> Jacques
>
> Le 24/05/2025 à 21:21, Balamurugan B a écrit :
> > I am using ofbiz version 22 , try to create a sale order at final step
> > press the create order button it will return error please order cannot be
> > change, see the above error message, how to solve this problem
