[Getting Session Error alert when running report]

Hi,

         I am getting Session Error alert when running the jasper report. This is happening after I changed the Tomcat 7 server from Tomcat 6.

         Thanks for your appricate answers.

 

Vasanth

[How to set the time value like 23:59:59 in Date input control]

Hi ernestoo, I used jasper 4.1.0 version and there is no Time data type. I need to use both date and time in input.

[How to set the time value like 23:59:59 in Date input control]

Hi,

          How to set the time value like with '23:59:59' (i.e., 2014-12-09 23:59:59) in Date input control. I need this for only end time not a start time. Now the both times are working like 2014-12-09 00:00:00 format.

  Advance thanks for your appreciate answers.

Thanks,

Vasanth

[Jasper Report UI getting collapsed when using Cluster between two server]

@nthapa

     No error in log. I put inspect element in Firefox, it shows JS,CSS and images are in 404 response, its not loading.

[Jasper Report UI getting collapsed when using Cluster between two server]

Hi,

             We using two Windows azure servers and installed Jasper in both servers. The OS is Ubuntu 13.10. Using Tomcat for running jasper server. In tomcat we configured 'Simple TCP Cluster' for session replication and using Azure Load Balancing between the two servers. If we start the jasper in single server its working fine. Started in the both servers, the UI is gettiong collapsed, See the below Image of collapsed UI. Anyone know what is the issue?

 

 

Thanks,

Vasanth

[Jasper Server is very slow when using Seperate Cloud servers for Jasper war and Database]

Hi hozawa,

        Copied jasperserver/META_INF/context.xml file  below. I need to change anything?

 

<?xml version="1.0" encoding="UTF-8"?><Context path="/jasperserver" reloadable="false">

 

    <!-- maxActive: Maximum number of dB connections in pool. Make sure you

         configure your mysqld max_connections large enough to handle

         all of your db connections. Set to 0 for no limit.

    -->

    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.

         Set to -1 for no limit.  See also the DBCP documentation on this

         and the minEvictableIdleTimeMillis configuration parameter.

     -->

    <!-- maxWait: Maximum time to wait for a dB connection to become available

         in ms, in this example 10 seconds. An Exception is thrown if

         this timeout is exceeded.  Set to -1 to wait indefinitely.

    -->

 

    <!-- Additional properties to consider. Settings for specifying a      -->

    <!-- validation query to help with reconnect/timeout errors.           -->

    <!-- Exact syntax may vary with database type (this tested on mysql.   -->

    <!--                                                                   -->

    <!--   validationQuery="select 1"                                      -->

    <!--   testOnBorrow="true"                                             -->

    <!--   (and add this to url property): &autoReconnectForPools=true -->

 

 

 

    <Resource auth="Container" driverClassName="org.mariadb.jdbc.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="pass" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:mysql://[My_IP]:3306/jasperserver5.5?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true" username="root" validationQuery="SELECT 1"/>

 

 

 

 

 

    <!-- Comment this line to enable session persistence across Tomcat restarts -->

    <Manager pathname=""/>

</Context>

[Jasper Server is very slow when using Seperate Cloud servers for Jasper war and Database]

Hi,

         I using Seperate Cloud servers for Jasper war (tomcat) and Jasper Database (Mysql). It is Very slow. Sometimes only its working fine, most of the time its not working, came Communication link error in log. Please suggess me if anything I miss in Configuration.

[mysql Communications link failure using remote database server]

Hi hozawa,

Thanks for your suggession,

 

Actually we can connect to DB from jasper(test connection is passed), can run the reports sometimes only, its not frequently work. Most of the time came the above error, and sometimes came the connection timeout error. Please sugges

[mysql Communications link failure using remote database server]

Hi hozawa,

Thanks for your suggession,

Actually we can connect to DB from jasper(test connection is passed), can run the reports sometimes only, its not frequently work. Most of the time came the above error, and somtimes came the connection timeout error. Please suggess anybody know this issue

[mysql Communications link failure using remote database server]

Hi, I faced the below error when run the jasper report 5.0.0, Mysql DB is connected in remote machine, Please sugess the solution.

2014-03-12 19:55:58,262 ERROR ReportsServiceCallTemplate,http-80-8:73 - Unexpected error occurscom.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection   atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:63)   atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49)   atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68)   atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:2029)    at com.jaspersoft.jasperserver.war.cascade.CachedEngineService.executeQuery(CachedEngineService.java:87)    at com.jaspersoft.jasperserver.war.cascade.handlers.QueryValuesLoader.loadValues(QueryValuesLoader.java:83)   atcom.jaspersoft.jasperserver.war.cascade.handlers.SingleSelectListInputControlHandler.fillStateValue(SingleSelectListInputControlHandler.java:106)    at com.jaspersoft.jasperserver.war.cascade.handlers.BasicInputControlHandler.getState(BasicInputControlHandler.java:115)   atcom.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControls(GenericInputControlLogic.java:197)   atcom.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControlsFromRawData(GenericInputControlLogic.java:233)   atcom.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:112)   atcom.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:104)   atcom.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.callControlLogic(InputControlsLogicServiceImpl.java:146)   atcom.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getValuesForInputControls(InputControlsLogicServiceImpl.java:104)   atcom.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl.getInputControlsForReport(RunReportServiceImpl.java:535)   atcom.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$$FastClassByCGLIB$$2b741728.invoke(<generated>)    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)    at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)    at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)   atcom.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$$EnhancerByCGLIB$$631f1f00.getInputControlsForReport(<generated>)    at com.jaspersoft.jasperserver.jaxrs.report.RunReportsJaxrsService$1.call(RunReportsJaxrsService.java:94)    at com.jaspersoft.jasperserver.jaxrs.report.RunReportsJaxrsService$1.call(RunReportsJaxrsService.java:91)    at com.jaspersoft.jasperserver.jaxrs.report.ReportsServiceCallTemplate.callRemoteService(ReportsServiceCallTemplate.java:50)    at com.jaspersoft.jasperserver.jaxrs.report.ReportsServiceCallTemplate.callRemoteService(ReportsServiceCallTemplate.java:43)    at com.jaspersoft.jasperserver.remote.common.RemoteServiceWrapper.callRemoteService(RemoteServiceWrapper.java:44)   atcom.jaspersoft.jasperserver.jaxrs.report.RunReportsJaxrsService.internalGetReportInputParameters(RunReportsJaxrsService.java:91)   atcom.jaspersoft.jasperserver.jaxrs.report.RunReportsJaxrsService.getReportInputParametersViaPost(RunReportsJaxrsService.java:79)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)    at java.lang.reflect.Method.invoke(Method.java:597)    at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)   atcom.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)   atcom.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.RightHandPathRule.accept(RightHandPathRule.java:147)    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: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)   atorg.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)   atcom.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   atcom.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96)    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.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192)    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:192)    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:101)    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)    at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76)    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)    at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130)    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   atorg.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:233)    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)    at java.lang.Thread.run(Thread.java:662)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2260)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)    at java.sql.DriverManager.getConnection(DriverManager.java:582)    at java.sql.DriverManager.getConnection(DriverManager.java:185)    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)   atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55)    ... 115 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)    ... 131 moreCaused by: java.net.ConnectException: Connection timed out    at java.net.PlainSocketImpl.socketConnect(Native Method)    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)    at java.net.Socket.connect(Socket.java:529)    at java.net.Socket.connect(Socket.java:478)    at java.net.Socket.<init>(Socket.java:375)    at java.net.Socket.<init>(Socket.java:218)    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)    ... 132 more[/code]

 

 

[Why Report runs twice at Scheduled time in jasperserver 4.1?]

Hi, We have scheduled a report which runs for every week. But it runs twice at one minute interval. In the two reports, the report which ran at first time was right one. second one was wrong data. We have no logs for finding this issue and it would be jasper-cluster issue? please guide me to resolve this. Thanks and awaiting for reply. It is very serious issue , Please provide solutions ASAP