bhaugland

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

Is it possible to use$R{resourcename} inside of the Report Query.

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I am having a problem with jobs not running from the scheduler. No errors are reported and the schedule disappears like it should. However no reports are generated. This is completely random since some of the jobs will run. I have 9 jobs scheduled to run at the same time. At least 1 job will not generate the report. I am able to run the report with no problem. My quartz properties have 20 threads with a priority of 5.

You need to assign users to the role ROLE_USER as well as your new role. That will give them access to the system

I managed to get JasperIntelligence 1.1 running on oracle using the oracle patch for 1.0.1. However I am not sure if there were any database changes that might affect the run. Could you shed some light on this Thanks Bruce Haugland

I am interested in this as well. I need to have security in the JasperIntelligence web application. However I want to pass credentials from another web application to the JasperIntelligence so the user is not forced to log on a second time.

I am interested in this as well. I need to have security in the JasperIntelligence web application. However I want to pass credentials from another web application to the JasperIntelligence so the user is not forced to log on a second time.

I did get it to work using a standard JBoss install (i.e 8080 port and default jnp: 1099 Because of my companies many installations of JBoss I need to be able to move the jnp to a different address. I have not figured out how to do this for 1.1. 1.0 had no problem with the different jnp address

Has anyone succeeded in deploying 1.1 to JBoss. I get the error in relationship to the applicationContext.xml and the bean named datasource javax.naming.NameNotFoundException: jdbc not bound. The strange thing about this is that that name should not be there since JBoss has not initialized the Datasources for the JNDI

Is there any news about the availability of an oracle patch for 1.1. I have tried generating the scripts myself using the source from the source zip file but have been unable to compile.

Just wondering if the Oracle Patch for 1.1 is available yet.

I noticed that Jasper1.1 is on source forge. I have a few questions about it. Has the Report Repository changed in anyway? I am using the oracle patch with my current installation. Is this still valid. Thanks Bruce Haugland

Write it as select * from abc $P!{whereclause} The ! in the $P causes the text in the where clause to be substitued.

Write it as select * from abc $P!{whereclause} The ! in the $P causes the text in the where clause to be substitued.

In iReports if you are in the cross tab designer you will see blank cells where your new data cells need to be. somewhere on your screen there is a tab called Crosstab objects. Take a look at the objects listed. Some of them will be from the new row groups you have added. You can drag the Crosstab objects into the empty cels on the cross tab designer. This gets around the fact that the wizard only asks for 2 groups. Hope this helps. I struggled with this for quite a while too.

I have also created the 3 row/column crosstabs. I have found that I need to drag the extra fields into the crosstab designer after I have added the rows or columns.

I have also created the 3 row/column crosstabs. I have found that I need to drag the extra fields into the crosstab designer after I have added the rows or columns.

When I tried to export scheduled reports I discovered that it only threw a null pointer exception. I discovered that mSched in ExportImport.setUpReportRepositoryConnections() was set to null on purpose. I commented out the null setting and rebuilt that jar. This time it appeared to run ok but I had nothing in the export file. Does this functionality not work or am I missing something.

Found the solution. Hibernate requires that the -server parameter be on the command line. Otherwise this exception will pop up from time to time

When I attempted to export my reports repository with the following command ./ji-export.sh --export-path ../reports --verbose --uri / I receive the following stack dump. ExportImportCommand: - running PROD Env mode ExportResource: top of process() ----- Processing Values: mProcessAll=false mProcessUriOnly=true mProcessUserRoleOnly=false mProcessReportJobsOnly=false mProcessNothing=false Exception in thread "main" java.lang.NoSuchMethodError: com.jaspersoft.jasperserver.api.metadata.common.s ervice.impl.hibernate.persistent.RepoFolder.getHibernateLazyInitializer()Lorg/hibernate/proxy/LazyInitial izer; at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder$$ EnhancerByCGLIB$$2530363e.getHibernateLazyInitializer(<generated>) at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:274) at org.hibernate.type.EntityType.resolve(EntityType.java:303) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842) at org.hibernate.loader.Loader.doQuery(Loader.java:717) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:9 66) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:956 ) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:949 ) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServ iceImpl.findByName(HibernateRepositoryServiceImpl.java:387) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServ iceImpl.findByURI(HibernateRepositoryServiceImpl.java:371) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServ iceImpl.loadResource(HibernateRepositoryServiceImpl.java:106) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServ iceImpl$1.execute(HibernateRepositoryServiceImpl.java:100) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback( HibernateDaoImpl.java:56) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServ iceImpl.getResource(HibernateRepositoryServiceImpl.java:98) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodI nvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocatio n.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIntercept or.java:100) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocatio n.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy1.getResource(Unknown Source) at com.jaspersoft.jasperserver.util.ExportResource.handleResourcesInFolder(ExportResource.java:14 78) at com.jaspersoft.jasperserver.util.ExportResource.processFolder(ExportResource.java:563) at com.jaspersoft.jasperserver.util.ExportResource.process(ExportResource.java:542) at com.jaspersoft.jasperserver.util.ExportResource.processUri(ExportResource.java:355) at com.jaspersoft.jasperserver.util.ExportResource.process(ExportResource.java:307) at com.jaspersoft.jasperserver.util.ExportImportCommand.runExport(ExportImportCommand.java:163) This only happens when I am trying to export a large repository. 63 report units, 9 jrxml's 18 Datasource, and other miscelanous. Any workarounds.