omarntfs

Hi Susieatl, Would you please share with us your datasource configuration. Thanks

I have the same issue in Jasper Studio 6.2.0, can anyone help Thanks

Hello, I try to configure jasperserver 6.0.1 and OpenAM, but I get the following errors: 2015-07-22 11:34:54,369 ERROR JDBCExceptionReporter,http-bio-8080-exec-9:101 - Batch entry 0 insert into JIUserRole (userId, roleId) values ('323', '6') was aborted. Call getNextException to see the cause.2015-07-22 11:34:54,384 ERROR JDBCExceptionReporter,http-bio-8080-exec-9:101 - ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(323, 6) already exists.2015-07-22 11:34:54,383 ERROR AbstractFlushingEventListener,http-bio-8080-exec-1:325 - Could not synchronize database state with sessionorg.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch updateat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)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.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:657)at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)at com.sun.proxy.$Proxy16.maintainInternalUser(Unknown Source)at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:119)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:210)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.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.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:210)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)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.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95)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.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.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)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:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)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:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)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:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:611)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:724)Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIUserRole (userId, roleId) values ('323', '6') was aborted. Call getNextException to see the cause.at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2619)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2752)at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)... 96 more Any help is appreciated, or article about How to configure jasperserver and OpenAM Thanks in advance

I solved it by changing js.jdbc.properties manually, by modifying these properties: # Property that determines the Hibernate dialect metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect # jasperserver repo db settings metadata.jdbc.driverClassName=oracle.jdbc.OracleDriver metadata.jdbc.url=jdbc:oracle:thin:@localhost:1521:xe metadata.jdbc.username=jasperserver metadata.jdbc.password=password metadata.jdbc.password.escapeXML=password metadata.jndi=jdbc/jasperserver metadata.database.generate=true I post the answer in case someone has the same problem.

I solved it by changing js.jdbc.properties manually, by modifying these properties: # Property that determines the Hibernate dialect metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect # jasperserver repo db settings metadata.jdbc.driverClassName=oracle.jdbc.OracleDriver metadata.jdbc.url=jdbc:oracle:thin:@localhost:1521:xe metadata.jdbc.username=jasperserver metadata.jdbc.password=password metadata.jdbc.password.escapeXML=password metadata.jndi=jdbc/jasperserver metadata.database.generate=true I post the answer in case someone has the same problem.

I solved it by changing js.jdbc.properties manually, by modifying these properties: # Property that determines the Hibernate dialect metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect # jasperserver repo db settings metadata.jdbc.driverClassName=oracle.jdbc.OracleDriver metadata.jdbc.url=jdbc:oracle:thin:@localhost:1521:xe metadata.jdbc.username=jasperserver metadata.jdbc.password=password metadata.jdbc.password.escapeXML=password metadata.jndi=jdbc/jasperserver metadata.database.generate=true I post the answer in case someone has the same problem.

same problem any help please

When I'm runing js-ant import-minimal-ce I have the following error: buildomaticconf_sourceieCeapplicationContext-cascade.xml [java] Started to load resources [java] Resource name: applicationContext.xml [java] Resource name: applicationContext-cascade.xml [java] Resource name: applicationContext-data-snapshots.xml [java] Resource name: applicationContext-events-logging.xml [java] Resource name: applicationContext-export-config.xml [java] Resource name: applicationContext-export-import.xml [java] Resource name: applicationContext-logging.xml [java] Resource name: applicationContext-olap-connection.xml [java] Resource name: applicationContext-report-scheduling.xml [java] Resource name: applicationContext-search.xml [java] Resource name: applicationContext-security.xml [java] Resource name: applicationContext-themes.xml [java] Resource name: applicationContext-virtual-data-source.xml [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'executionOwnerVoter': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityContextProvider': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.facorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'executionOwnerVoter': Injection of resoutory.BeanCreationException: Error creating bean with name 'securityContextProviderTarget' defined in file [C:Jasper softjasperrrce dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with neports-server-cp-5.5 .0buildomaticconf_sourceieCeapplicationContext.xml]: Cannot resolve reference to bean 'userAuthorityService' while setting bean property 'userDetailsService '; nested exception is org.springframework.beans.factory.BeanCreationException:Error creating bean with name 'userAuthorityService' defined in file [C:Jaspers oftjasperreports-server-cp-5.5.0buildomaticconf_sourceieCeapplicationContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFame 'securityContext Provider': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityContextProviderTarget' defined in file [C:Jaspersoftjasperractory' defined in file [C:Jaspersoftjasperreports-server-cp-5.5.0buildomaticconf_sourceieCeapplicationContext.xml]: Invoceports-server-cp-5.5.0buildomaticconf_sourceieCeapplicationContext.xml]: Cannot resolve reference to bean 'userAuthorityService' while setting bean property 'userDetailsService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAuthorityService' defined in file [C:Jaspersoftjasperreport s-server-cp-5.5.0buildomatiation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.ji.hic conf_sourceieCeapplicationContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org. springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in file [C:Jaspersoftjasperreports-server-cp-5.5.0 buildomaticconf_sourceieCeapplicationContext.xml]: Invocbernate.dialect.OracleJICustomDialect [java] at org.springframework.context.annotation.CommonAnnotationBeanPo stProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306 ) any help please thanks

I have the same problem. any help will be appreciated thanks in advance

Same issue here. I tried new installation and I imported the reports, but I still have the probleme. any help Thanks in advance

Hello, I have the same need, I am using jasperserver 4.5.0 and I need Arabic resource bundle properties files. Thanks in advance

I have the same need thanks in advance

jasper support only one font for arabic text(DejaVu Sans)

Hi all, I'm using jasperreport 4.5 and I have the same problem Thanks in advance Omar

Hello everyone, net.sf.jasperreports.chart.range.axis.tick.interval works good but net.sf.jasperreports.chart.domain.axis.tick.interval doesn't work. any Help please. thanks in advance

Is it possible? I also need that

Thank you

Hi, I installed JasperServer without sample databases or reports, and now I instelled them following these steps: create database sugarcrm encoding=’utf8’; create database foodmart encoding=’utf8’; \c sugarcrm; \i sugarcrm-postgresql.sql; \c foodmart; \i foodmart-postqresql.sql; \i supermart-update.sql;js-ant load-sugarcrm-db js-ant load-foodmart-db js-ant update-foodmart-db but when I run a report sample(all report), I get errors lik: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : AllAccounts_Table32Dataset321_1342012602506_458290 any idea?? Thanks in advance