ldevigne

I think I have found what is wrong. Now it works since I have upgraded tomcat 5 to tomcat 6. With JasperServer 3.7.1 and iReport 3.7.5, it works fine. Please tell me if it's ok for you after upgrading tomcat. Regards, -- Laurent.

Hi Tom, You have to migrate from JasperServer 3.7.0 to JasperServer 3.7.1 (i'm not sure) But I'm sure you have to migrate iReport 3.7.1 to iReport 3.7.5 I have the same configuration, when I use direct link : https://myserver:8443/jasperserver/services/repository/, it works (iReport tells me to accept an auto-signed certificate which I have previously generated) but if I use "http://myserver:8080/jasperserver/services/repository" I have this error : Error: (302)Moved Temporarily (the redirection seems to be not understood by iReport) Regards, -- Laurent.

Hi everybody, I have a simple cross tab, which you just have an example below, the measure is of type "count" (it shows the count of number of failure by month) /uploads/projects/ireport/cross_count.png As you can see, the last line is the "total". But I'd like to have the "average" instead of "total". I'd just like the last line to be the average of the upper lines (average by month). Do you think it is possible ? I'm not sure ? Thanks for help ! -- Laurent.

Any idea ? I think the problem is well-known ? Please help ! Thanks,

Ok that's ok now with this parameter metadata.hibernate.dialect=com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect instead of metadata.hibernate.dialect=org.hibernate.dialect.PostgresqlDialect That's all Folks !! Post Edited by ldevigne at 06/11/2010 14:57

I'm using JasperServer 3.7.1 with a Postgres 8.2 database. I tryed to import a simple "Report Unit" with a single paramter (which I beforehand successfully exported) So I use this script : ./js-import.sh --input-dir /tmp/LDE/try/ This directory contains resources/datasources/datasource.xml resources/datatypes/id.xml (input contrrol) based on resources/datatypes/integer.xml (datatype) resources/reports/try/simple_try.xml and resources/reports/simple_try_files When I import, the datasource and datatypes are stored onto JasperServer database, no problem ! But there is a problem with the importation of the report. Here are the logs, it seems to be a problem with the "data" colum of JIFileResource, which is of type "bytea" and I think the JRXML file is not converted or something like that in this Postgres table. Please Help, Here is the output errors : Created repository folder /reports/try Imported resource /datasources/datasource Imported resource /datatypes/Integer Imported resource /datatypes/id 2010-06-11 11:07:59,091 WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 42804 2010-06-11 11:07:59,095 ERROR JDBCExceptionReporter:101 - ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer 2010-06-11 11:07:59,097 ERROR AbstractFlushingEventListener:325 - Could not synchronize database state with session org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285) 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:424) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417) 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 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 $Proxy1.saveResource(Unknown Source) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124) at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146) at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95) at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268) ... 34 more 2010-06-11 11:07:59,098 ERROR HibernateDaoImpl:79 - Hibernate DataAccessException org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) 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:424) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417) 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 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 $Proxy1.saveResource(Unknown Source) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124) at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146) at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95) at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285) 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) ... 24 more Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268) ... 34 more 2010-06-11 11:07:59,145 ERROR BaseExportImportCommand:45 - com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) 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:424) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417) 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 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 $Proxy1.saveResource(Unknown Source) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352) at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124) at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146) at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95) at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285) 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) ... 24 more Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268) Post Edited by ldevigne at 06/11/2010 14:59 Post Edited by ldevigne at 06/11/2010 15:00

No idea ?

Any idea ? It would help so much...

I have many crosstabs and information to display in my summary band With "Page break", I manage the display of many crosstabs of which I can reduce the height in the designer. But I can't do this with the charts I have change the "Page Height" master paramter, so I can grow my Summary band height, but it's not good when I want to print the report (a lot of bank page) Any idea to workaround this problem ? Thanks a lot ! A screenshot of the design :

It's just a simple problem but disturbing in the look and feel of my reports So I designed a report in iReport with crosstabs with cell rotation just like this : /uploads/projects/jasperserver/crosstab(1).png But when I upload the report onto JasperServer, the result is : /uploads/projects/jasperserver/crosstab1(2).png Any idea about this problem which seems to be "minor" ? Thanks, Post Edited by ldevigne at 06/04/2010 08:17

Hi everybody, I have 2 input controls in my JS report. The first one "param1" is a boolean. I'd like to "deactiavte" the second parameter (becomes grey for example), if param1 is true Is it possible ? In fact, the second parameter is optionnal and has sense only if param1 is false. Thanks for help ! -- Laurent.

Any idea ? It's really disturbing me. Post Edited by ldevigne at 05/28/2010 08:23

Any idea ?

When I had to manipulate dates in iReport, I used the scriptlet class to write some Java functions, which I called in derived parameters...

Hi everybody, I'd like to open my templates from JasperServer in iReport with the context menu "Open in Editor", but everytime I get a Java Exeption /uploads/projects/ireport/exception.png So after reading this post, http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=55948 I confirm that I do use a Sun JDK on both the sides (iReport and JasperServer) The releases are : iReport 3.7.1 and JasperServer 3.7.0 and Sun JDK 1.6.0_16 I had a look to "catalina.out" log file and there seems to be a problem with the RU which is null : 2010-05-25 17:11:56,423 WARN LoggerListener,http-8080-Processor18:60 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: org.springframework.security.ui.WebAuthenticationDetails@0: RemoteIpAddress: 172.25.250.128; SessionId: 68A65DF99BC9216F52E078DA79B68057 2010-05-25 17:11:56,426 WARN ManagementService,http-8080-Processor18:805 - Loading uri: /reports/Vigilo/vigilo_dispo_hote 2010-05-25 17:11:56,471 WARN ManagementService,http-8080-Processor18:813 - Loaded RU null 2010-05-25 17:11:56,486 WARN ManagementService,http-8080-Processor18:820 - Loaded resource /reports/Vigilo/vigilo_dispo_hote_files/vigilo_dispo_hote_jrxml com.jaspersoft.jasperserver.api.metadata.common.domain.client.FileResourceImpl@1c436fe Thanks so much for you help Post Edited by ldevigne at 05/25/2010 15:02