Jasperservre 4.5.1 64bits version for CUSTOM FIELD FILTERING

[jasper-2013]

I have created a custom field from 6 fields;

then i created the filter;

However, when I ran the report it encounters below errors

Code:

2012-07-04 15:29:39,423 ERROR JDBCExceptionReporter,http-8181-4:101 - Batch entry 0 insert into JIResourceFolder (version, uri, hidden, name, label, description, parent_folder, creation_date, update_date, id) values ('0', '/organizations/organization_1/temp/aru1341386426814_files/field_3_1_files', '1', 'field_3_1_files', 'QTY_ON_HAND + QTY_ON_ORDER + QTY_BACK_ORDER + PJ_QTY_BACK_ORDER + MIN_HOLDING_QTY + MAX_HOLDING_QTY is between', NULL, '18722', '2012-07-04 15:29:39.381000 +08:00:00', '2012-07-04 15:29:39.381000 +08:00:00', '18729') was aborted.  Call getNextException to see the cause.2012-07-04 15:29:39,426 ERROR JDBCExceptionReporter,http-8181-4:101 - ERROR: value too long for type character varying(100)2012-07-04 15:29:39,427 ERROR AbstractFlushingEventListener,http-8181-4:325 - Could not synchronize database state with sessionorg.hibernate.exception.DataException: Could not execute JDBC batch update	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)	at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:322)	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)	at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892)	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)	at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:75)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:430)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PermissionsPrefetcher.invoke(PermissionsPrefetcher.java:78)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy15.saveResource(Unknown Source)	at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.saveResource(PathTransformationRepositoryService.java:483)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy15.saveResource(Unknown Source)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at com.jaspersoft.ji.adhoc.service.EasyXMLizer.invoke(EasyXMLizer.java:42)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy34.saveResource(Unknown Source)	at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.saveARU(AdhocEngineServiceImpl.java:946)	at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.saveTemp(AdhocAjaxController.java:523)	at sun.reflect.GeneratedMethodAccessor995.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)	at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.handleRequest(AdhocAjaxController.java:187)	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)	at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)	at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:108)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:81)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:83)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)	at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)	at java.lang.Thread.run(Thread.java:619)Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIResourceFolder (version, uri, hidden, name, label, description, parent_folder, creation_date, update_date, id) values ('0', '/organizations/organization_1/temp/aru1341386426814_files/field_3_1_files', '1', 'field_3_1_files', 'QTY_ON_HAND + QTY_ON_ORDER + QTY_BACK_ORDER + PJ_QTY_BACK_ORDER + MIN_HOLDING_QTY + MAX_HOLDING_QTY is between', NULL, '18722', '2012-07-04 15:29:39.381000 +08:00:00', '2012-07-04 15:29:39.381000 +08:00:00', '18729') was aborted.  Call getNextException to see the cause.	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)	... 134 more

[jasper-2013]

 bump anyone can help??