markbeardhome

I have some sql code that was working in a report, after upgrading from 6.3 > 7.2 comunity version I now get an validation error. I have tracked this down to this section of code regexp_replace(replace(customer.accounts_note,',',''), E'[\n\r]+', ',,', 'g' ) as reg_rep if I change the \n\r for something else all is ok. where is this turned off as I have to remove blank lines from my output any help would be good

The difference is these are actualy working and just stop. Via the web interface all I have to do is re test the jdbc and save and they then work for some time then stop again. this is both mysql and mssql and there on both different machines is this a known issue in V6 server?

I have 2 extra JDBC data sources set up, one for MSSQL and another for MySql. Both occasionally fail, I have to re test and save the data source and all is ok. The server is 6.0 all reports work and then suddenly they stop. to fix I just need to re save the settings on the server. error log below 2018-09-21 14:14:49,959 ERROR GenericExceptionMapper,http-nio-8080-exec-7:47 - Unexpected error occurs com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:2257) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EhcacheEngineService.executeQuery(EhcacheEngineService.java:184) at com.jaspersoft.jasperserver.war.cascade.CachedEngineService.executeQuery(CachedEngineService.java:136) at com.jaspersoft.jasperserver.war.cascade.handlers.QueryValuesLoader.loadValues(QueryValuesLoader.java:102) at com.jaspersoft.jasperserver.war.cascade.handlers.SingleSelectListInputControlHandler.fillStateValue(SingleSelectListInputControlHandler.java:123) at com.jaspersoft.jasperserver.war.cascade.handlers.BasicInputControlHandler.getState(BasicInputControlHandler.java:160) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControls(GenericInputControlLogic.java:211) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControlsFromRawData(GenericInputControlLogic.java:258) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:200) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:192) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.callControlLogic(InputControlsLogicServiceImpl.java:248) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getValuesForInputControls(InputControlsLogicServiceImpl.java:192) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getInputControlsWithValues(InputControlsLogicServiceImpl.java:130) at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService$1.call(InputControlsJaxrsService.java:113) at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService$1.call(InputControlsJaxrsService.java:105) at com.jaspersoft.jasperserver.jaxrs.report.ReportsServiceCallTemplate.callRemoteService(ReportsServiceCallTemplate.java:49) at com.jaspersoft.jasperserver.remote.common.RemoteServiceWrapper.callRemoteService(RemoteServiceWrapper.java:44) at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService.internalGetReportInputParameters(InputControlsJaxrsService.java:105) at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService.getReportInputParametersViaPost(InputControlsJaxrsService.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:72) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:586) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:526) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:72) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219) at com.jaspersoft.jasperserver.api.common.util.JdbcDriverShim.connect(JdbcDriverShim.java:66) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56) ... 139 more Caused by: com.mysql.cj.core.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at com.mysql.cj.mysqla.io.MysqlaProtocol.rejectConnection(MysqlaProtocol.java:327) at com.mysql.cj.mysqla.authentication.MysqlaAuthenticationProvider.connect(MysqlaAuthenticationProvider.java:207) at com.mysql.cj.mysqla.io.MysqlaProtocol.connect(MysqlaProtocol.java:1414) at com.mysql.cj.mysqla.MysqlaSession.connect(MysqlaSession.java:132) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1726) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596) ... 152 more

After an upgrade from server 5.0 to 6.3 my exports via to excel format have lost the left boarder. I am exporting a table based element and my first column always appeared in B now it is in A. Can anyone tell me how to have the blank column on the left again as it was useful? I have too many reports to add a blank column on the left and that would affect printing via PDF

That option only hids the cloumn and not the row, if I set this on Group1 Footer band, then it shows on all cells in that colum. in a standard report with detail and group bands you can set the print when on the group row.

HI This JRXML allows to create data using the calendar class, <parameter name="cal" class="java.util.Calendar" isForPrompting="false"> <defaultValueExpression><![CDATA[Calendar.getInstance()]]></defaultValueExpression> </parameter> I am sute you can use this to get the FirstDayOFThisYear ( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_YEAR, 1) ) ? null : $P{cal}.getTime() <parameter name="cal" class="java.util.Calendar" isForPrompting="false"> <defaultValueExpression><![CDATA[Calendar.getInstance()]]></defaultValueExpression> </parameter> ______________________________________________________________________________________ <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2017-10-19T13:06:30 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="dates" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="BlankPage" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4d748c5c-baf3-4519-8e7b-0a775a31aad9"> <property name="ireport.zoom" value="1.5"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="runDate" class="java.util.Date"> <defaultValueExpression><![CDATA[new Date()]]></defaultValueExpression> </parameter> <parameter name="cal" class="java.util.Calendar" isForPrompting="false"> <defaultValueExpression><![CDATA[Calendar.getInstance()]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select id from categories]]> </queryString> <field name="id" class="java.lang.Integer"/> <variable name="yesterday" class="java.util.Date"> <variableExpression><![CDATA[$P{runDate}-1]]></variableExpression> <initialValueExpression><![CDATA[$P{runDate}-1]]></initialValueExpression> </variable> <variable name="lastMonth" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1)|| $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.DAY_OF_MONTH)) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="lastDayOfLastMonth" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) || $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.DAY_OF_MONTH)) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) || $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.DAY_OF_MONTH)) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="lastWeek" class="java.util.Date"> <variableExpression><![CDATA[$P{runDate}-7]]></variableExpression> <initialValueExpression><![CDATA[$P{runDate}-7]]></initialValueExpression> </variable> <variable name="firstDayOfLastMonth" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) || $P{cal}.set(Calendar.DAY_OF_MONTH, 1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) || $P{cal}.set(Calendar.DAY_OF_MONTH, 1) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="lastYear" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="lastSunday" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.DAY_OF_MONTH, $P{cal}.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY ? -7 : Calendar.SUNDAY - $P{cal}.get(Calendar.DAY_OF_WEEK)) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.DAY_OF_MONTH, $P{cal}.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY ? -7 : Calendar.SUNDAY - $P{cal}.get(Calendar.DAY_OF_WEEK)) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="FirstDayOFLASTYear" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1)|| $P{cal}.set(Calendar.DAY_OF_YEAR, 1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1)|| $P{cal}.set(Calendar.DAY_OF_YEAR, 1) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="LastDayOFLASTYear" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1)|| $P{cal}.set(Calendar.DAY_OF_YEAR, $P{cal}.getActualMaximum(Calendar.DAY_OF_YEAR)) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.YEAR, -1)|| $P{cal}.set(Calendar.DAY_OF_YEAR, $P{cal}.getActualMaximum(Calendar.DAY_OF_YEAR)) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="FirstDayOFThisYear" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_YEAR, 1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_YEAR, 1) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="firstDayOfTheMonth" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_MONTH, 1) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_MONTH, 1) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="lastDayOfTheMonth" class="java.util.Date"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.DAY_OF_MONTH)) ) ? null : $P{cal}.getTime()]]></variableExpression> <initialValueExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.DAY_OF_MONTH)) ) ? null : $P{cal}.getTime()]]></initialValueExpression> </variable> <variable name="WeeKOFYEAR" class="java.lang.String"> <variableExpression><![CDATA[( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.set(Calendar.DAY_OF_MONTH, $P{cal}.getActualMaximum(Calendar.WEEK_OF_YEAR)) ) ? null : $P{cal}.getTime()]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="350" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="316" height="34" uuid="b99a7eee-147c-4d0b-9b43-2883648157d1"/> <textElement> <font fontName="Arial" size="18" isBold="true"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Date calculation demo report]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="54" width="130" height="20" forecolor="#666666" uuid="1ccfe108-5021-45cf-a74f-ff224a229ac2"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{yesterday}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="54" width="129" height="20" forecolor="#666666" uuid="a60cc2df-2738-43d3-ad7c-e04b8904dd1e"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Yesterday]]></text> </staticText> <staticText> <reportElement x="0" y="34" width="129" height="20" uuid="49ae7aaf-763d-4a0b-addd-c23dc7fadf93"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Run Date]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="34" width="130" height="20" uuid="6a24e99e-ca58-4fbe-883e-ad329b190d2c"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$P{runDate}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="114" width="130" height="20" forecolor="#666666" uuid="5be98499-8117-4510-91eb-aa6a5083f92f"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastMonth}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="114" width="129" height="20" forecolor="#666666" uuid="19c1330f-9990-4960-b60a-49ce1154b4e5"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Month]]></text> </staticText> <staticText> <reportElement x="0" y="154" width="129" height="20" forecolor="#666666" uuid="977f8a33-da4f-4d1f-bb06-e186af032c32"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Day of Last Month]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="154" width="130" height="20" forecolor="#666666" uuid="f51f8c39-c1ed-4485-b3bc-aa51deb99632"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastDayOfLastMonth}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="129" y="74" width="130" height="20" forecolor="#666666" uuid="2f277bbc-158e-42b0-9d1e-e7d8899aa8bb"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastWeek}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="74" width="129" height="20" forecolor="#666666" uuid="9ebaba65-ebf2-408c-a7ee-b0cf6586893d"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Week]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="134" width="130" height="20" forecolor="#666666" uuid="73516181-8fc9-4e0f-ad2d-34c2c3a6c356"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{firstDayOfLastMonth}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="134" width="129" height="20" forecolor="#666666" uuid="066c07e6-1112-4674-941b-21aca9f38b73"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[First Day of Last Month]]></text> </staticText> <staticText> <reportElement x="0" y="174" width="129" height="20" forecolor="#666666" uuid="d9d4351e-c776-42ad-a29e-f11786dc35c0"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Year]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy"> <reportElement x="129" y="174" width="130" height="20" forecolor="#666666" uuid="92c40161-ba2d-4ddc-b0db-db1a6fae2698"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastYear}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="129" y="94" width="130" height="20" forecolor="#666666" uuid="f0743b6d-d4ea-4db7-9fdb-43bcf48953c1"/> <textElement textAlignment="Right"> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastSunday}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="94" width="129" height="20" forecolor="#666666" uuid="523473bd-5d57-479e-8006-92eaa703d859"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Sunday]]></text> </staticText> <textField pattern="dd/MM/yyyy"> <reportElement x="129" y="194" width="130" height="20" forecolor="#666666" uuid="8620c79f-9e0b-4a06-ae30-bba1c1cc8b8c"/> <textElement textAlignment="Right"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{FirstDayOFLASTYear}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="194" width="129" height="20" forecolor="#666666" uuid="6be8e9c9-9435-4c10-b4bf-ada237dcfc50"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[First Day of Last Year]]></text> </staticText> <textField pattern="dd/MM/yyyy"> <reportElement x="129" y="214" width="130" height="20" forecolor="#666666" uuid="434ff04f-cc0e-4e4f-962d-c913f4d022f7"/> <textElement textAlignment="Right"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{LastDayOFLASTYear}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="214" width="129" height="20" forecolor="#666666" uuid="acf14ac9-5535-4102-b85d-c052f8b42a20"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[Last Day of Last Year]]></text> </staticText> <textField pattern="dd/MM/yyyy"> <reportElement x="129" y="234" width="130" height="20" forecolor="#666666" uuid="39eedcfe-b1a5-43e5-acbe-14dea776882a"/> <textElement textAlignment="Right"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{FirstDayOFThisYear}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="234" width="129" height="20" forecolor="#666666" uuid="c291ecef-a173-41f6-9ee1-e01a1220a9b6"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[First Day of This Year]]></text> </staticText> <textField> <reportElement x="129" y="254" width="130" height="20" forecolor="#666666" uuid="94682c69-0b2c-4762-a799-d1830bd94718"/> <textElement textAlignment="Right"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{firstDayOfTheMonth}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="254" width="129" height="20" forecolor="#666666" uuid="cb8a2ed3-61eb-4990-89e9-4e205be8720c"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[First Day of Selected Month]]></text> </staticText> <textField> <reportElement x="129" y="274" width="130" height="20" forecolor="#666666" uuid="b5db2c39-99e5-479d-883b-409d35d35737"/> <textElement> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{lastDayOfTheMonth}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="274" width="129" height="20" forecolor="#666666" uuid="36bd8f83-e53f-497c-bf07-7280bfb64ab8"/> <textElement> <font fontName="Arial"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[LastDay of Selected Month]]></text> </staticText> </band> </title> <pageHeader> <band splitType="Stretch"/> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band splitType="Stretch"/> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band splitType="Stretch"/> </pageFooter> <summary> <band splitType="Stretch"/> </summary> </jasperReport>

Is theer any way to hid a group row in a table element. there is no print when got yje row only the column

I Found the issue I have called my return value "RetVal1" and collecting data of a variable "Weight" I set the return val From Val "RetVal1" and to Variable "RetVal1" Calculation SUM variable Retval1 defined in Main report and parent sub data set from tthe main Table what I needed to do in both recieving Variables is put in the Variable Expression $V{RetVal1} (name of the sending Variable and then got the sumation correct. I was executing a sum of product in a table that was inside a table. I placed the vatiable in the summary band and also in the product group band inside my table and set evaluation time to Band. Var in Group band contained a running total Var in Summary band returned the grand total

I currently have a report with a Table Element and showing various sales data. Nested inside this I have another Table element showing incoming Purchase orders. I have 2 data sets , one controlling my Main Table and another controlling the incoming Purchase orders, These are linked by parameters and all is working fine. I am returning the sum of the weight of the Po’s back to the main Table. When I try to sum the returned value to the main table to show as a grand total all I get is nulls. I am using Jasper server 6 with studio 6.31 Has anyone got any samples of this working?

Hi I am using the "Output Host File system" foir my report which is working fine I have set the path to "usr2/xxxxx The files are outupt fine and I can uopen them as I am logged in as the same user as the tomcat The rights are set as rw-r----- I need to change these to rw-rw-rw- how can I do this Thank you

Can enyone help me Studio 6.3.1 I have a variable that is collecting information from a field in the main Query, i wish to print data from all the sales items at group level . using a sub select in the sql will not work doue to other issues with the odbc driver when I run the report I get data that comes after the next Group, group 3 is the sales order number. I have tried testing the group count, java.util.List, java.util.ArrayList and Collection I get the same results the system seems to add the next data to the array which is from the next group <variable name="orderitems" class="java.util.List" resetType="Group" resetGroup="Group3" calculation="System"><variableExpression><![CDATA[$V{orderitems}.size() < $V{Group3_COUNT} ? $V{orderitems}.add($F{orderitems}) : $V{orderitems}.add("")]]></variableExpression><initialValueExpression><![CDATA[new ArrayList()]]></initialValueExpression></variable><variable name="capacity" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3" calculation="Sum"><variableExpression><![CDATA[$F{capacity}]]></variableExpression></variable><variable name="volume" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3"/><variable name="cost" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3"><variableExpression><![CDATA[$F{cost}]]></variableExpression></variable><group name="Group3"><groupExpression><![CDATA[$F{orderReference}]]></groupExpression></group></subDataset>

I have Jasper studio 6.3 I have made a report with one parameter $P{Company} I have set this as a list and will be using it for a multiselect query. every time I make a change to the report Studio uploads the parameter as a multi select list of parameteres and changes the type. How can I stop this

I am trying to upgrade a 3.7 Jasper server, but when I back up teh repository I get a fail the system stops on reports that have a list of Values imput Control has anyone fixed this issue?

Solved this , a full Tomcat restart fixed the issue

I restarted the jasper server and since I get the following error on all Groovy based reports. Some I have changed to run java and alll is fine but teh Groovy ones fail. I restored previouse DB etc and I have teh same results 5.0 Jasperserver Any Ideas? 2016-10-26 12:26:56,482 ERROR ManagementServiceImpl,http-8080-18:1295 - caught Throwable exception: java.lang.VerifyError: (class: org/codehaus/groovy/runtime/ArrayUtil, method: createArray signature: ()[Ljava/lang/Object;) Illegal type in constant poolcom.jaspersoft.jasperserver.api.JSException: java.lang.VerifyError: (class: org/codehaus/groovy/runtime/ArrayUtil, method: createArray signature: ()[Ljava/lang/Object;) Illegal type in constant poolat com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:602)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:1820)at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:488)at com.jaspersoft.jasperserver.ws.axis2.ManagementServiceImpl.runReport(ManagementServiceImpl.java:1201)at com.jaspersoft.jasperserver.ws.axis2.ManagementService.runReport(ManagementService.java:240)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)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 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 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.api.metadata.user.service.impl.PasswordExpirationProcessingFilter.doFilter(PasswordExpirationProcessingFilter.java:85)at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)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.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter.java:81)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 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:346)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)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.P3PFilter.doFilter(P3PFilter.java:43)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:228)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)at java.lang.Thread.run(Unknown Source)Caused by: java.lang.VerifyError: (class: org/codehaus/groovy/runtime/ArrayUtil, method: createArray signature: ()[Ljava/lang/Object;) Illegal type in constant poolat org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)at BuyersReport_1477481214067_351164.customizedInit(calculator_BuyersReport_1477481214067_351164:63)at net.sf.jasperreports.engine.fill.JREvaluator.init(JREvaluator.java:88)at net.sf.jasperreports.engine.fill.JRCalculator.init(JRCalculator.java:111)at net.sf.jasperreports.engine.fill.JRFillDataset.initCalculator(JRFillDataset.java:469)at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:529)at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:88)at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:103)at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:61)at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:153)at net.sf.jasperreports.engine.fill.BaseFillHandle.<init>(BaseFillHandle.java:75)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousFillHandle.<init>(EngineServiceImpl.java:840)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1683)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousReportFiller.fillReport(EngineServiceImpl.java:769)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1622)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:859)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:593)... 70 more