azpyrine

up ?

It's a class. Thanks for your response. I can indeed use the compatibility mode, however it remains an anomaly. When exporting to Excel the field is reflected in the format "Text" instead of "Integer".

I have change mysql driver and add JNDI. I have the same problem ! Why it's only when i scheduled this report ? Any Idea ? Thanks

- Yes, it is the same permissions. - no parameters in this report - This report is very simple, 1 or 2 seconds for execute. i dont think it's the time out. Thanks

Hi, When I schedule a report that points to a MySQL database, it is left empty. However if I run the report directly, it is not empty. The problem seems to only be present when using a scheduled task Any idea ?Thanks.Cédric

Thanks very much. Yesterday i change this configuration in js.quartz.base.properties : # org.quartz.scheduler.instanceId = AUTO # org.quartz.jobStore.isClustered = true # org.quartz.jobStore.clusterCheckinInterval = 900000 This morning the problem is solved. If i understand, it is possible to simply increase the "org.quartz.jobStore.clusterCheckinInterval" ? Thanks. Cédric

Hi, After uninstall/install jaspersever and mysql, i have the same problem. Quartz/Jasper send 2 notifications for one schedule ! Why ? Thanks

Hello, Since migration to Jasperserver 4.0, some of my reports schedules send two mails.Are you any idea? Thank you for your help Cédric Post Edited by azpyrine at 03/17/2011 07:18

Hi, May be trying to change the login.jsp file in WEB-INF/jsp Cheers, Cédric

Hi, The field is controlrenderer in table JIReportUnit If someone are problem with message WEB_INF/.../ViewReport.jsp, you can execute this update JIReportUnit set controlslayout = 4 where controlslayout = 3

Jasperserver 4.0 Hi, I have a problem in "Controls and Resources" of reports. I have a problem with "Optional JSP location. In the jasperserver database where is the field "Optional JSP location" ? Thanks Post Edited by azpyrine at 02/22/2011 09:38 Post Edited by azpyrine at 02/22/2011 09:39

Hello, Can you post your applicationContext-security.xml ? Thanks.

Hi, You will find the error we encountered a weekly. A simple restart tomcat can correct this error. What can i do ? 2010-08-01 06:30:00,303 ERROR ReportExecutionJob,quartzScheduler_Worker-1:308 - An error occurred while executing the report. com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:59) 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:64) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:719) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:385) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:871) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:494) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:422) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:510) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) 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) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) ... 12 more Change Oracle Driver ? Change Tomcat 6.0 to Tomcat 7.0 ? Thanks for your responses Post Edited by azpyrine at 08/01/2010 05:24