*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
