Re: Sale order creation without error

Jacques Le Roux Mon, 26 May 2025 07:31:04 -0700

Balamurugan,

First you need to give us more information, for instance, at least:


1.

   Did you change anything on your laptop or/and your cloud, or are you using 
OFBiz as it came to you?

2. What did you follow to install OFBiz?
3.

   How do you create your sale order?

4.

   Which steps are you using to create it?

5.

   Which parameters are you typing in the forms used to create your sale order?

Without those we can' help you

Jacques

Le 26/05/2025 à 15:01, Balamurugan B a écrit :

*Hi Jacques Le Roux *

if i run the application in my laptop sale order working fine ,when it goes
on cloud server that error will raised ,How will solved this problem?



On Mon, 26 May 2025 at 14:55, Jacques Le Roux<[email protected]>
wrote:

Hi Balamurugan,

You need to give us more details. I reckon you are trying to create a sale
order from the ordermgr application using the POS Channel (ie not from the
Webpos application).
But I'm unsure because the FactServices.groovy is only part of the BI
component.

Please give us the exact steps and parameters you are using as a whole. I
mean not only those when creating the order but possible other
modifications/creations you made before. For instance I see

[account,IEIPL Store(java.lang.String)] that does not exist in OFBiz OOTB
[origCurrencyDimId,_NF_(java.lang.String)] seems weird

Before can you try to reproduce the same at
https://demo-stable.ofbiz.apache.org/ordermgr/control/orderentry
(credential : admin/ofbiz)That's the
24.09 demo.
That would may be easier to understand the problem.

HTH

Jacques

Le 26/05/2025 à 09:35, Balamurugan B a écrit :

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

Re: Sale order creation without error

Reply via email to