Unable to Save Input Controls

[rchristianson]

Found that when a user tries to save a multi select input control where a high number of selections are made that it won't save the input controls. Regardless of the report, this error will be produced. The error basically states that it "could not insert collection". I found a SQL error code -302 which confirms my suspicion that there is an issue with the input control having too many selections to be saved. Is this a bug, is there a way around this or to increase the size of the collection being saved? One of our clients has a multiselect where over 900 selections can be made and I'm assuming the space allocated for saved input controls needs to be increased.

 

 

 

 

The entire error message looks like this:

{"message":"could not insert collection: [com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues#56822]; SQL [insert into JIReportOptionsInput (options_id, input_name, input_value) values (?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert collection: [com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues#56822]","errorCode":"unexpected.error","parameters":["com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.DataIntegrityViolationException: could not insert collection: [com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues#56822]; SQL [insert into JIReportOptionsInput (options_id, input_name, input_value) values (?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert collection: [com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues#56822]ntat org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648)ntat org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)ntat org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)ntat org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)ntat org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:881)ntat com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:78)ntat com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResourceWithFlush(HibernateRepositoryServiceImpl.java:551)ntat com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:538)ntat sun.reflect.GeneratedMethodAccessor1306.invoke(Unknown Source)ntat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)ntat java.lang.reflect.Method.invoke(Method.java:620)ntat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)ntat org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)ntat com.sun.proxy.$Proxy32.saveResource(Unknown Source)ntat sun.reflect.GeneratedMethodAccessor1159.invoke(Unknown Source)ntat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)ntat java.lang.reflect.Method.invoke(Method.java:620)ntat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)ntat com.jaspersoft.ji.adhoc.service.EasyXMLizer.invoke(EasyXMLizer.java:66)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat com.jaspersoft.jasperserver.api.metadata.user.service.impl.PermissionsPrefetcher.invoke(PermissionsPrefetcher.java:79)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)ntat com.sun.proxy.$Proxy46.saveResource(Unknown Source)ntat com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.saveResource(PathTransformationRepositoryService.java:462)ntat sun.reflect.GeneratedMethodAccessor1159.invoke(Unknown Source)ntat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)ntat java.lang.reflect.Method.invoke(Method.java:620)ntat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)ntat org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)ntat com.sun.proxy.$Proxy46.saveResource(Unknown Source)ntat com.jaspersoft.ji.report.options.metadata.ReportOptionsFacade.performSave(ReportOptionsFacade.java:118)ntat com.jaspersoft.jasperserver.multipleTenancy.MTReportOptionsFacade.performSave(MTReportOptionsFacade.java:44)ntat com.jaspersoft.ji.report.options.metadata.ReportOptionsFacade.saveOptions(ReportOptionsFacade.java:135)ntat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)ntat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)ntat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)ntat java.lang.reflect.Method.invoke(Method.java:620)ntat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)ntat org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)ntat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)ntat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)ntat com.sun.proxy.$Proxy60.saveOptions(Unknown Source)ntat com.jaspersoft.ji.remote.services.impl.RemoteReportOptionsServiceImpl.createReportOptions(RemoteReportOptionsServiceImpl.java:101)ntat com.jaspersoft.ji.jaxrs.reports.ReportOptionsJaxrsService$3.call(ReportOptionsJaxrsService.java:100)ntat com.jaspersoft.ji.jaxrs.reports.ReportOptionsJaxrsService$3.call(ReportOptionsJaxrsService.java:98)ntat com.jaspersoft.jasperserver.jaxrs.report.ReportsServiceCallTemplate.callRemoteService(ReportsServiceCallTemplate.java:49)ntat com.jaspersoft.jasperserver.remote.common.RemoteServiceWrapper.callRemoteService(RemoteServiceWrapper.java:44)ntat com.jaspersoft.ji.jaxrs.reports.ReportOptionsJaxrsService.createReportOptions(ReportOptionsJaxrsService.java:98)ntat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)ntat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)ntat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)ntat java.lang.reflect.Method.invoke(Method.java:620)ntat com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)ntat com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)ntat com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)ntat com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)ntat com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)ntat com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)ntat com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)ntat com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483)ntat com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414)ntat com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363)ntat com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353)ntat com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)ntat com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)ntat com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708)ntat javax.servlet.http.HttpServlet.service(HttpServlet.java:731)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:163)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)ntat org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)ntat org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:148)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94)ntat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)ntat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)ntat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.war.NullFilter.doFilterHttp(NullFilter.java:44)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)ntat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)ntat org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:79)ntat org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)ntat org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)ntat org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43)ntat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)ntat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)ntat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)ntat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)ntat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)ntat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)ntat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)ntat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)ntat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)ntat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)ntat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)ntat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)ntat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)ntat org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)ntat org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)ntat org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)ntat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1164)ntat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:634)ntat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)ntat java.lang.Thread.run(Thread.java:798)nCaused by: org.hibernate.exception.DataException: could not insert collection: [com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues#56822]ntat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)ntat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)ntat org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1205)ntat org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:58)ntat org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)ntat org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)ntat org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)ntat org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:322)ntat org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)ntat org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)ntat org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:883)ntat org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)nt... 167 morenCaused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.13.80ntat com.ibm.db2.jcc.am.id.a(id.java:669)ntat com.ibm.db2.jcc.am.id.a(id.java:60)ntat com.ibm.db2.jcc.am.id.a(id.java:127)ntat com.ibm.db2.jcc.am.fo.b(fo.java:2310)ntat com.ibm.db2.jcc.am.fo.c(fo.java:2293)ntat com.ibm.db2.jcc.t4.cb.l(cb.java:370)ntat com.ibm.db2.jcc.t4.cb.a(cb.java:62)ntat com.ibm.db2.jcc.t4.q.a(q.java:50)ntat com.ibm.db2.jcc.t4.tb.b(tb.java:220)ntat com.ibm.db2.jcc.am.go.oc(go.java:3424)ntat com.ibm.db2.jcc.am.go.b(go.java:4379)ntat com.ibm.db2.jcc.am.go.b(go.java:4550)ntat com.ibm.db2.jcc.am.go.gc(go.java:782)ntat com.ibm.db2.jcc.am.go.executeUpdate(go.java:761)ntat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)ntat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)ntat org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)ntat org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1168)nt... 176 moren"]}