Skip to content

Instantly share code, notes, and snippets.

@donhuvy
Created Aug 24, 2021
Embed
What would you like to do?
--- 2021-08-23 14:03:49.498 [eper-172ca72b-1] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service update#moqui.server.Visit
org.moqui.entity.EntityException: Error updating Visit [visitId:100101]
at org.moqui.impl.entity.EntityValueBase.update(EntityValueBase.java:1623) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.updateEntity(EntityAutoServiceRunner.groovy:519) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:601) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiSessionListener.closeVisit(MoquiSessionListener.groovy:88) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiSessionListener.sessionDestroyed(MoquiSessionListener.groovy:55) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_281]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_281]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_281]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.moqui.entity.EntityException: Tried to update a value that does not exist [[moqui.server.Visit: [visitId:100101, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, thruDate:2021-08-23 00:03:49.497, lastUpdatedStamp:2021-08-23 00:03:49.497]]]. SQL used was UPDATE public.VISIT SET THRU_DATE=?, LAST_UPDATED_STAMP=? WHERE VISIT_ID=?, parameters were [thruDate:2021-08-23 00:03:49.497, lastUpdatedStamp:2021-08-23 00:03:49.497, visitId:100101]
at org.moqui.impl.entity.EntityValueImpl.updateExtended(EntityValueImpl.java:148) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.update(EntityValueBase.java:1610) ~[moqui_temp9222902704866209267WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
... 13 more
--- 2021-08-23 14:03:49.501 [eper-172ca72b-1] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error updating Visit [visitId:100101]
--- 2021-08-23 14:03:49.503 [eper-172ca72b-1] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Tried to update a value that does not exist [[moqui.server.Visit: [visitId:100101, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, null:null, thruDate:2021-08-23 00:03:49.497, lastUpdatedStamp:2021-08-23 00:03:49.497]]]. SQL used was UPDATE public.VISIT SET THRU_DATE=?, LAST_UPDATED_STAMP=? WHERE VISIT_ID=?, parameters were [thruDate:2021-08-23 00:03:49.497, lastUpdatedStamp:2021-08-23 00:03:49.497, visitId:100101]
--- 2021-08-23 15:37:56.912 [p2024415090-308] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Effective Date is not set
--- 2021-08-23 16:00:54.969 [ MoquiWorker-5] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
From address is empty for EmailTemplate SCREEN_RENDER
--- 2021-08-23 16:34:03.764 [tp2024415090-65] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100000]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:34:03.783 [tp2024415090-65] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100000]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:34:03.783 [tp2024415090-65] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:34:22.270 [tp2024415090-65] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100001]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:34:22.281 [tp2024415090-65] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100001]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:34:22.281 [tp2024415090-65] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:34:49.288 [tp2024415090-76] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100002]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:34:49.299 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100002]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:34:49.299 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:35:36.762 [tp2024415090-64] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100003]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:35:36.775 [tp2024415090-64] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100003]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:35:36.775 [tp2024415090-64] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:36:10.583 [tp2024415090-76] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100004]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:36:10.595 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100004]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:36:10.595 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:37:42.322 [tp2024415090-76] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100005]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:37:42.334 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100005]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:37:42.334 [tp2024415090-76] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:38:31.145 [tp2024415090-64] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100006]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp8016658476497969411WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3985698498849536693execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp565499505971085750execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp3599150561769904118WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp1143784600044567034execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp7679208067396266725execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp6013485295780967805execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp6575079931241760030WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp8054650046793517879WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:38:31.154 [tp2024415090-64] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100006]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:38:31.154 [tp2024415090-64] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 16:46:53.150 [tp1021436681-60] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100000]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp1695779618022980894execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp5868915581839227989execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 16:46:53.160 [tp1021436681-60] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100000]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 16:46:53.160 [tp1021436681-60] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 17:20:43.059 [p1021436681-166] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100001]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp1695779618022980894execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp5868915581839227989execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 17:20:43.064 [p1021436681-166] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100001]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 17:20:43.064 [p1021436681-166] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 17:27:14.382 [p1021436681-178] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100002]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp1695779618022980894execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp5868915581839227989execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 17:27:14.390 [p1021436681-178] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100002]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 17:27:14.390 [p1021436681-178] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 17:28:05.687 [tp1021436681-73] ERROR org.moqui.impl.service.ServiceCallSyncImpl [] []
Error running service create#mantle.account.payment.Payment
org.moqui.impl.entity.EntitySqlException: Error creating Payment [paymentId:100003]: tried to delete record that other records refer to or record specified does not exist [23503]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1466) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.19.jar:42.2.19]
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_281]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_281]
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:441) ~[postgresql-42.2.19.jar:42.2.19]
at com.sun.proxy.$Proxy24.executeUpdate(Unknown Source) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[?:?]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:113) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityQueryBuilder.executeUpdate(EntityQueryBuilder.java:174) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueImpl.createExtended(EntityValueImpl.java:98) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.basicCreate(EntityValueBase.java:1494) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.entity.EntityValueBase.create(EntityValueBase.java:1455) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createRecursive(EntityAutoServiceRunner.groovy:214) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.EntityAutoServiceRunner.createEntity(EntityAutoServiceRunner.groovy:193) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.runImplicitEntityAuto(ServiceCallSyncImpl.java:599) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:215) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:115) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119) ~[moqui_temp1394729711779765980WEB-INF_lib_groovy-2.5.14.jar.:2.5.14]
at mantle_account_PaymentServices_create_InvoicePayment.run(mantle_account_PaymentServices_create_InvoicePayment:57) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.runner.InlineServiceRunner.runService(InlineServiceRunner.java:59) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.callSingle(ServiceCallSyncImpl.java:322) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.service.ServiceCallSyncImpl.call(ServiceCallSyncImpl.java:125) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.service.ServiceCallSync$call$0.call(Unknown Source) ~[?:?]
at component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call.run(component___SimpleScreens_screen_SimpleScreens_Accounting_Invoice_EditInvoice_xml_transition_recordPayment_service_call:7) ~[?:?]
at org.moqui.impl.actions.XmlAction.run(XmlAction.java:67) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenDefinition$TransitionItem.run(ScreenDefinition.groovy:839) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:748) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.recursiveRunTransition(ScreenRenderImpl.groovy:744) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.internalRender(ScreenRenderImpl.groovy:454) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.screen.ScreenRenderImpl.render(ScreenRenderImpl.groovy:170) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.moqui.impl.webapp.MoquiServlet.service(MoquiServlet.groovy:167) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[moqui_temp3022150928400632730execlib_javax.servlet-api-3.1.0.jar.:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[moqui_temp1695779618022980894execlib_websocket-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.moqui.impl.webapp.ElasticRequestLogFilter.doFilter(ElasticRequestLogFilter.groovy:110) ~[moqui_temp1437855332674900532WEB-INF_lib_moqui-framework-3.0.0-rc8.jar.:3.0.0-rc8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[moqui_temp5868915581839227989execlib_jetty-security-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[moqui_temp1982115041094843113execlib_jetty-servlet-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [moqui_temp4217311469137512187execlib_jetty-server-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [moqui_temp4685906608825463406WEB-INF_lib_jetty-io-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [moqui_temp2431027749353414433WEB-INF_lib_jetty-util-9.4.43.v20210629.jar.:9.4.43.v20210629]
... 1 more
--- 2021-08-23 17:28:05.694 [tp1021436681-73] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Error creating Payment [paymentId:100003]: tried to delete record that other records refer to or record specified does not exist [23503]
--- 2021-08-23 17:28:05.694 [tp1021436681-73] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
ERROR: insert or update on table "payment" violates foreign key constraint "paymentvisit"
Detail: Key (visit_id)=(100000) is not present in table "visit".
--- 2021-08-23 17:56:35.119 [tp2024415090-71] ERROR org.moqui.impl.context.MessageFacadeImpl [] []
Invoice not found with ID 100000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment