Internal Exception: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint ; SYS_CT_10109 table: FLOWUI_FILTER_CONFIGURATION column: CONFIGURATION_ID
Error Code: -10
Call: INSERT INTO FLOWUI_FILTER_CONFIGURATION (ID, COMPONENT_ID, CONFIGURATION_ID, DEFAULT_FOR_ALL, NAME, ROOT_CONDITION, SYS_TENANT_ID, USERNAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [01a0c41e-2230-73dc-bcef-1a9906383681, [jt_User.list]genericFilter, null, false, null, {
"@class" : "io.jmix.flowui.entity.filter.GroupFilterCondition",
"componentId" : null,
"enabled" : true,
"label" : null,
"localizedLabel" : "",
"operation" : "AND",
"operationTextVisible" : false,
"ownFilterConditions" : [ {
"@class" : "io.jmix.flowui.entity.filter.PropertyFilterCondition",
"componentId" : "propertyFilter_active",
"enabled" : true,
"label" : null,
"localizedLabel" : "Active",
"operation" : "EQUAL",
"operationEditable" : true,
"operationTextVisible" : true,
"parameterName" : "activeykwHMXEE",
"property" : "active",
"required" : false,
"styleName" : null,
"valueComponent" : {
"componentId" : "propertyFilter_active_valueComponent",
"componentName" : "io.jmix.flowui.component.select.JmixSelect",
"defaultValue" : null,
"styleName" : null
},
"visible" : true
} ],
"styleName" : "jmix-group-filter",
"visible" : true
}, null, test]
Query: InsertObjectQuery(io.jmix.flowuidata.entity.FilterConfiguration-01a0c41e-2230-73dc-bcef-1a9906383681 [new,managed])
2026-09-21T16:18:28.471+03:00 ERROR 40624 --- [io-8080-exec-10] i.j.f.e.DefaultUiExceptionHandler : Unhandled exception
jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0-1-jmix.v202605261051-e0fe8f1a176757fc63a9d1bb332ba974e10a6da0): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint ; SYS_CT_10109 table: FLOWUI_FILTER_CONFIGURATION column: CONFIGURATION_ID
Error Code: -10
Call: INSERT INTO FLOWUI_FILTER_CONFIGURATION (ID, COMPONENT_ID, CONFIGURATION_ID, DEFAULT_FOR_ALL, NAME, ROOT_CONDITION, SYS_TENANT_ID, USERNAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [01a0c41e-2230-73dc-bcef-1a9906383681, [jt_User.list]genericFilter, null, false, null, {
"@class" : "io.jmix.flowui.entity.filter.GroupFilterCondition",
"componentId" : null,
"enabled" : true,
"label" : null,
"localizedLabel" : "",
"operation" : "AND",
"operationTextVisible" : false,
"ownFilterConditions" : [ {
"@class" : "io.jmix.flowui.entity.filter.PropertyFilterCondition",
"componentId" : "propertyFilter_active",
"enabled" : true,
"label" : null,
"localizedLabel" : "Active",
"operation" : "EQUAL",
"operationEditable" : true,
"operationTextVisible" : true,
"parameterName" : "activeykwHMXEE",
"property" : "active",
"required" : false,
"styleName" : null,
"valueComponent" : {
"componentId" : "propertyFilter_active_valueComponent",
"componentName" : "io.jmix.flowui.component.select.JmixSelect",
"defaultValue" : null,
"styleName" : null
},
"visible" : true
} ],
"styleName" : "jmix-group-filter",
"visible" : true
}, null, test]
Query: InsertObjectQuery(io.jmix.flowuidata.entity.FilterConfiguration-01a0c41e-2230-73dc-bcef-1a9906383681 [new,managed])
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:1014) ~[org.eclipse.persistence.jpa-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261052]
at io.jmix.eclipselink.impl.JpaDataStore.beforeSaveTransactionCommit(JpaDataStore.java:544) ~[jmix-eclipselink-3.0.0.jar:na]
at io.jmix.core.datastore.AbstractDataStore.save(AbstractDataStore.java:231) ~[jmix-core-3.0.0.jar:na]
at io.jmix.eclipselink.impl.JpaDataStore.save(JpaDataStore.java:244) ~[jmix-eclipselink-3.0.0.jar:na]
at io.jmix.core.impl.UnconstrainedDataManagerImpl.lambda$saveContextToStore$7(UnconstrainedDataManagerImpl.java:293) ~[jmix-core-3.0.0.jar:na]
at io.micrometer.observation.Observation.observe(Observation.java:634) ~[micrometer-observation-1.16.5.jar:1.16.5]
at io.jmix.core.impl.UnconstrainedDataManagerImpl.saveContextToStore(UnconstrainedDataManagerImpl.java:293) ~[jmix-core-3.0.0.jar:na]
at io.jmix.core.impl.UnconstrainedDataManagerImpl.save(UnconstrainedDataManagerImpl.java:249) ~[jmix-core-3.0.0.jar:na]
at io.jmix.core.impl.UnconstrainedDataManagerImpl.save(UnconstrainedDataManagerImpl.java:167) ~[jmix-core-3.0.0.jar:na]
at io.jmix.flowuidata.genericfilter.DatabaseFilterConfigurationPersistence.save(DatabaseFilterConfigurationPersistence.java:75) ~[jmix-flowui-data-3.0.0.jar:na]
at io.jmix.flowui.component.genericfilter.GenericFilterSupport.saveConfigurationModel(GenericFilterSupport.java:294) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.component.genericfilter.GenericFilterSupport.saveCurrentFilterConfiguration(GenericFilterSupport.java:124) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.action.genericfilter.GenericFilterEditAction.onDetailViewAfterSave(GenericFilterEditAction.java:168) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.action.genericfilter.GenericFilterEditAction.lambda$execute$0(GenericFilterEditAction.java:136) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.core.common.event.EventHub.publish(EventHub.java:172) ~[jmix-core-3.0.0.jar:na]
at io.jmix.flowui.view.AbstractDialogWindow.publish(AbstractDialogWindow.java:219) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.DialogWindow.fireViewAfterCloseEvent(DialogWindow.java:84) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.DialogWindow.onViewAfterClosed(DialogWindow.java:79) ~[jmix-flowui-3.0.0.jar:na]
at com.vaadin.flow.component.ComponentEventBus.fireEventForListener(ComponentEventBus.java:242) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.component.ComponentEventBus.fireEvent(ComponentEventBus.java:231) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.component.Component.fireEvent(Component.java:412) ~[flow-server-25.1.7.jar:25.1.7]
at io.jmix.flowui.view.View.lambda$close$8(View.java:342) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.observation.UiObservationSupport.lambda$observeViewLifecycle$2(UiObservationSupport.java:206) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.monitoring.LegacyUiTimerSupport.recordViewTimer(LegacyUiTimerSupport.java:97) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.observation.UiObservationSupport.lambda$observeViewLifecycle$3(UiObservationSupport.java:217) ~[jmix-flowui-3.0.0.jar:na]
at io.micrometer.observation.Observation.observe(Observation.java:634) ~[micrometer-observation-1.16.5.jar:1.16.5]
at io.jmix.flowui.observation.UiObservationSupport.observeViewLifecycle(UiObservationSupport.java:216) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.observation.UiObservationSupport.observeViewLifecycle(UiObservationSupport.java:205) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.View.close(View.java:341) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.View.close(View.java:317) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.StandardDetailView.lambda$closeWithSave$6(StandardDetailView.java:348) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.util.SuccessOperationResult.compose(SuccessOperationResult.java:38) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.view.StandardDetailView.closeWithSave(StandardDetailView.java:348) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.action.view.DetailSaveCloseAction.execute(DetailSaveCloseAction.java:84) ~[jmix-flowui-3.0.0.jar:na]
at io.micrometer.observation.Observation.observe(Observation.java:569) ~[micrometer-observation-1.16.5.jar:1.16.5]
at io.jmix.flowui.action.view.ViewAction.actionPerform(ViewAction.java:72) ~[jmix-flowui-3.0.0.jar:na]
at io.jmix.flowui.kit.component.button.JmixButtonActionSupport.onButtonClick(JmixButtonActionSupport.java:176) ~[jmix-flowui-kit-3.0.0.jar:na]
at com.vaadin.flow.component.ComponentEventBus.fireEventForListener(ComponentEventBus.java:242) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.component.ComponentEventBus.handleDomEvent(ComponentEventBus.java:494) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.component.ComponentEventBus.lambda$addDomTrigger$dd1b7957$1(ComponentEventBus.java:301) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.internal.nodefeature.ElementListenerMap.lambda$fireEvent$2(ElementListenerMap.java:501) ~[flow-server-25.1.7.jar:25.1.7]
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596) ~[na:na]
at com.vaadin.flow.internal.nodefeature.ElementListenerMap.fireEvent(ElementListenerMap.java:501) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.rpc.EventRpcHandler.handleNode(EventRpcHandler.java:62) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.rpc.AbstractRpcInvocationHandler.handle(AbstractRpcInvocationHandler.java:80) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.ServerRpcHandler.handleInvocationData(ServerRpcHandler.java:619) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.ServerRpcHandler.lambda$handleInvocations$6(ServerRpcHandler.java:600) ~[flow-server-25.1.7.jar:25.1.7]
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596) ~[na:na]
at com.vaadin.flow.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:600) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:424) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:137) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:63) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.VaadinService.handleRequest(VaadinService.java:1835) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.server.VaadinServlet.service(VaadinServlet.java:402) ~[flow-server-25.1.7.jar:25.1.7]
at com.vaadin.flow.spring.SpringServlet.service(SpringServlet.java:106) ~[vaadin-spring-25.1.7.jar:na]
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:723) ~[jakarta.servlet-api-6.1.0.jar:6.1.0]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:513) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:333) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:262) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.springframework.web.servlet.mvc.ServletForwardingController.handleRequestInternal(ServletForwardingController.java:139) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:49) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:866) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1000) ~[spring-webmvc-7.0.7.jar:7.0.7]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:903) ~[spring-webmvc-7.0.7.jar:7.0.7]
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:653) ~[jakarta.servlet-api-6.1.0.jar:6.1.0]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:874) ~[spring-webmvc-7.0.7.jar:7.0.7]
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:723) ~[jakarta.servlet-api-6.1.0.jar:6.1.0]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-11.0.22.jar:11.0.22]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:108) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.web.FilterChainProxy.lambda$doFilterInternal$3(FilterChainProxy.java:235) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:376) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.access.intercept.AuthorizationFilter.doFilter(AuthorizationFilter.java:101) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:126) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:120) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:132) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:86) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:100) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:115) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:106) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:181) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:153) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:131) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:245) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:239) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:96) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:118) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.context.SecurityContextHolderFilter.doFilter(SecurityContextHolderFilter.java:82) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.context.SecurityContextHolderFilter.doFilter(SecurityContextHolderFilter.java:69) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:62) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:385) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:237) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:195) ~[spring-security-web-7.0.5.jar:7.0.5]
at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:113) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.ServletRequestPathFilter.doFilter(ServletRequestPathFilter.java:52) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:113) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:74) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration$CompositeFilterChainProxy.doFilter(WebSecurityConfiguration.java:317) ~[spring-security-config-7.0.5.jar:7.0.5]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at io.jmix.core.impl.metadata.MetadataGenerationFilter.doFilterInternal(MetadataGenerationFilter.java:45) ~[jmix-core-3.0.0.jar:na]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at io.jmix.core.impl.logging.LogMdcFilter.doFilterInternal(LogMdcFilter.java:49) ~[jmix-core-3.0.0.jar:na]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:199) ~[spring-web-7.0.7.jar:7.0.7]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-7.0.7.jar:7.0.7]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:397) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:1272) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) ~[tomcat-embed-core-11.0.22.jar:11.0.22]
at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0-1-jmix.v202605261051-e0fe8f1a176757fc63a9d1bb332ba974e10a6da0): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint ; SYS_CT_10109 table: FLOWUI_FILTER_CONFIGURATION column: CONFIGURATION_ID
Error Code: -10
Call: INSERT INTO FLOWUI_FILTER_CONFIGURATION (ID, COMPONENT_ID, CONFIGURATION_ID, DEFAULT_FOR_ALL, NAME, ROOT_CONDITION, SYS_TENANT_ID, USERNAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [01a0c41e-2230-73dc-bcef-1a9906383681, [jt_User.list]genericFilter, null, false, null, {
"@class" : "io.jmix.flowui.entity.filter.GroupFilterCondition",
"componentId" : null,
"enabled" : true,
"label" : null,
"localizedLabel" : "",
"operation" : "AND",
"operationTextVisible" : false,
"ownFilterConditions" : [ {
"@class" : "io.jmix.flowui.entity.filter.PropertyFilterCondition",
"componentId" : "propertyFilter_active",
"enabled" : true,
"label" : null,
"localizedLabel" : "Active",
"operation" : "EQUAL",
"operationEditable" : true,
"operationTextVisible" : true,
"parameterName" : "activeykwHMXEE",
"property" : "active",
"required" : false,
"styleName" : null,
"valueComponent" : {
"componentId" : "propertyFilter_active_valueComponent",
"componentName" : "io.jmix.flowui.component.select.JmixSelect",
"defaultValue" : null,
"styleName" : null
},
"visible" : true
} ],
"styleName" : "jmix-group-filter",
"visible" : true
}, null, test]
Query: InsertObjectQuery(io.jmix.flowuidata.entity.FilterConfiguration-01a0c41e-2230-73dc-bcef-1a9906383681 [detached])
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:335) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:949) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:1011) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:658) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:570) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2081) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:322) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:281) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:267) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:437) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:194) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:210) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:514) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:86) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:97) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:326) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:63) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:937) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:836) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:114) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:91) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3056) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1876) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1858) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1808) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:248) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:147) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4411) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1514) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1650) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:477) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:1009) ~[org.eclipse.persistence.jpa-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261052]
... 156 common frames omitted
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint ; SYS_CT_10109 table: FLOWUI_FILTER_CONFIGURATION column: CONFIGURATION_ID
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-7.0.2.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-7.0.2.jar:na]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:939) ~[org.eclipse.persistence.core-5.0.0-1-jmix.jar:5.0.0-1-jmix.v202605261051]
... 186 common frames omitted
Caused by: org.hsqldb.HsqlException: integrity constraint violation: NOT NULL check constraint ; SYS_CT_10109 table: FLOWUI_FILTER_CONFIGURATION column: CONFIGURATION_ID
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.Table.enforceRowConstraints(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.Table.generateAndCheckData(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.Table.insertSingleRow(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.StatementDML.insertSingleRow(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.StatementInsert.getResult(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.StatementDMQL.execute(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.Session.executeCompiledStatement(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
at org.hsqldb.Session.execute(Unknown Source) ~[hsqldb-2.7.3.jar:2.7.3]
... 191 common frames omitted
Environment
Jmix version: 3.0.0
Bug Description
User with
UiFilterRolecan not save filter configurationSteps To Reproduce
Resource rolewith access to userCurrent Behavior
Expected Behavior
Successful save
Proposed solution
Add access to
FilterConfigurationModelentity toUiFilterRole