640 results for 'BSC=REL012150'

FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@4b5f70fc"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- Java stack trace (for programmers): ---- freemarker.core._TemplateModelException: [... Exception message was already printed; see it above ...] at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:289) at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:261) at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:65) at freemarker.core.MethodCall._eval(MethodCall.java:65) at freemarker.core.Expression.eval(Expression.java:81) at freemarker.core.DollarVariable.calculateInterpolatedStringOrMarkup(DollarVariable.java:96) at freemarker.core.DollarVariable.accept(DollarVariable.java:59) at freemarker.core.Environment.visit(Environment.java:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: java.lang.IllegalArgumentException: Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.service.GenericServiceException: Outgoing result (in runSync : calculateProductPrice) does not match expected requirements (The following required parameter is missing: [OUT] [calculateProductPrice.basePrice]The following required parameter is missing: [OUT] [calculateProductPrice.currencyUsed]The following required parameter is missing: [OUT] [calculateProductPrice.isSale]The following required parameter is missing: [OUT] [calculateProductPrice.orderItemPriceInfos]The following required parameter is missing: [OUT] [calculateProductPrice.price]The following required parameter is missing: [OUT] [calculateProductPrice.validPriceFound]) (Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.service.GenericServiceException: Outgoing result (in runSync : calculateProductPrice) does not match expected requirements (The following required parameter is missing: [OUT] [calculateProductPrice.basePrice]The following required parameter is missing: [OUT] [calculateProductPrice.currencyUsed]The following required parameter is missing: [OUT] [calculateProductPrice.isSale]The following required parameter is missing: [OUT] [calculateProductPrice.orderItemPriceInfos]The following required parameter is missing: [OUT] [calculateProductPrice.price]The following required parameter is missing: [OUT] [calculateProductPrice.validPriceFound])) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:1458) at freemarker.ext.beans.ReflectionCallableMemberDescriptor.invokeMethod(ReflectionCallableMemberDescriptor.java:56) at freemarker.ext.beans.MemberAndArguments.invokeMethod(MemberAndArguments.java:51) at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:61) ... 71 more Caused by: java.lang.IllegalArgumentException: Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.service.GenericServiceException: Outgoing result (in runSync : calculateProductPrice) does not match expected requirements (The following required parameter is missing: [OUT] [calculateProductPrice.basePrice]The following required parameter is missing: [OUT] [calculateProductPrice.currencyUsed]The following required parameter is missing: [OUT] [calculateProductPrice.isSale]The following required parameter is missing: [OUT] [calculateProductPrice.orderItemPriceInfos]The following required parameter is missing: [OUT] [calculateProductPrice.price]The following required parameter is missing: [OUT] [calculateProductPrice.validPriceFound]) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:348) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.service.GenericServiceException: Outgoing result (in runSync : calculateProductPrice) does not match expected requirements (The following required parameter is missing: [OUT] [calculateProductPrice.basePrice]The following required parameter is missing: [OUT] [calculateProductPrice.currencyUsed]The following required parameter is missing: [OUT] [calculateProductPrice.isSale]The following required parameter is missing: [OUT] [calculateProductPrice.orderItemPriceInfos]The following required parameter is missing: [OUT] [calculateProductPrice.price]The following required parameter is missing: [OUT] [calculateProductPrice.validPriceFound]) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:487) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at org.apache.ofbiz.service.engine.GroovyBaseScript.runService(GroovyBaseScript.groovy:39) at org.apache.ofbiz.service.engine.GroovyBaseScript$runService$3.callCurrent(Unknown Source) at ProductSummary.run(ProductSummary.groovy:127) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) ... 85 more Caused by: org.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [OUT] [calculateProductPrice.basePrice]The following required parameter is missing: [OUT] [calculateProductPrice.currencyUsed]The following required parameter is missing: [OUT] [calculateProductPrice.isSale]The following required parameter is missing: [OUT] [calculateProductPrice.orderItemPriceInfos]The following required parameter is missing: [OUT] [calculateProductPrice.price]The following required parameter is missing: [OUT] [calculateProductPrice.validPriceFound] at org.apache.ofbiz.service.ModelService.validate(ModelService.java:636) at org.apache.ofbiz.service.ModelService.validate(ModelService.java:578) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:485) ... 93 more
OFBiz Message

:ERROR MESSAGE:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#keywordsearch]: org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductPrice]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".)). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".)) (Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".))) (Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductPrice]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".)). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".)) (Error while inserting: [GenericEntity:ProductPrice][createdByUserLogin,system(java.lang.String)][createdDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][createdTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2025-04-08 04:07:08.368(java.sql.Timestamp)][lastModifiedByUserLogin,system(java.lang.String)][lastModifiedDate,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedStamp,2025-04-08 04:07:08.375(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-08 04:07:07.733(java.sql.Timestamp)][price,13.75(java.math.BigDecimal)][productId,9798218389550(java.lang.String)][productPricePurposeId,PURCHASE(java.lang.String)][productPriceTypeId,DEFAULT_PRICE(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX, TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "product_price" violates foreign key constraint "prod_price_prod" Detail: Key (product_id)=(9798218389550) is not present in table "product".))))