spierepf

Yes, I saw the rest_v2 api. But I cannot use it because then my code would depend on the server version. The documentation for the rest api in 5.1 http://community-static.jaspersoft.com/sites/default/files/docs/jasperreports-server-web-services-guide_1.pdf has a whole section (4.2 starting on p86) on the user service, so I don't think that the old api has gone away.

Somewhere, the post editor on this site changed part of my request from <fullName/> to <fullName></fullName>. Weird!

Greetings, I am trying to use the REST API to create users. The following request used to work in jasperserver 4.5.1: PUT /jasperserver-pro/rest/user HTTP/1.1Authorization: Basic c3VwZXJ1c2VyOnN1cGVydXNlcg==Transfer-Encoding: chunkedHost: localhost:8081Connection: Keep-AliveUser-Agent: Apache-HttpClient/4.2.1 (java 1.5)88 organization_1 username password 0 and used to get me a 201-Created response: HTTP/1.1 201 CreatedServer: Apache-Coyote/1.1Cache-Control: privateExpires: Wed, 31 Dec 1969 20:00:00 ASTSet-Cookie: JSESSIONID=A936AE3DD13F4A42F893F5592A81D26F; Path=/jasperserver-pro/; HttpOnlyContent-Type: text/xml;charset=UTF-8Content-Length: 0Date: Fri, 14 Feb 2014 18:59:56 GMT However this request no longer works in 5.5.0 and just gets me: HTTP/1.1 400 Bad RequestServer: Apache-Coyote/1.1Cache-Control: privateExpires: Wed, 31 Dec 1969 20:00:00 ASTP3P: CP="ALL"Set-Cookie: JSESSIONID=57E555D7C12FB5619B00A25B5828310A; Path=/jasperserver-pro/; HttpOnlyContent-Type: text/xml;charset=UTF-8Content-Length: 0Date: Fri, 14 Feb 2014 18:46:58 GMTConnection: close Is anyone aware of any changes to the REST API between 4.5.1 and 5.5.0? Peter.

I am trying to use the REST API to create users, and these users need to belong to a number of roles. The examples in the documentation all involve users with single roles. The descriptor that I send to the REST API looks like: <user> <tenantId>xxx</tenantId> <username>xxx</username> <password>xxx</password> <fullName>xxx</fullName> <enabled>true</enabled> <roles> <roleName>ROLE_ALL</roleName> <roleName>ROLE_DISPENSARY</roleName> <roleName>ROLE_FRONTSTORE</roleName> </roles> </user> And the user descriptor that I get when I immediately ask the API to give me that user looks like: <user> <enabled>true</enabled> <externallyDefined>false</externallyDefined> <fullName>xxx</fullName> <password>xxx</password> <roles> <externallyDefined>false</externallyDefined> <roleName>ROLE_FRONTSTORE</roleName> </roles> <tenantId>xxx</tenantId> <username>xxx</username> </user> Somewhere the two roles ROLE_DISPENSARY and ROLE_ALL disappear. Does anyone have any idea why this might be? Can I only give a user a single role? Peter

Greetings, I've built a simple report with a date input control and a single text field showing the value of that input control. When I log into JRS and set a timezone, the date displayed by the report is still in my local timezone. Does anyone know the reason why? Peter

I've just installed JS 4.7.1 on a brand new box, and I can't convince it to start up. Examining the logs seems to indicate that the jasperserver database isn't configured. However, I configured the database using buildomatic, and it managed to create the database just fine. Anyway, here is the exception: Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555) ... 273 more Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 278 more Caused by: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:524) at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:493) at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307) at java.sql.DriverManager.getDriver(DriverManager.java:262) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437) Peter.

I am trying to use Jasperservers REST API to update a report definition. However, when I do so, I get a 403 Forbidden error that looks like: Access to the specified resource () has been forbidden. and my jasperserver log contains a message like: 2013-06-13 12:02:30,659 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/CutoffDate 2013-06-13 12:02:30,664 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/market_tag 2013-06-13 12:02:30,670 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/dealer_tag 2013-06-13 12:02:30,677 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/branch_id 2013-06-13 12:02:30,684 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/CustomerType 2013-06-13 12:02:30,690 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/CustomerName 2013-06-13 12:02:30,693 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/AccountType 2013-06-13 12:02:30,699 INFO HibernateRepositoryServiceImpl,http-bio-8080-exec-104:1188 - Creating children folder for /public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport_files/MinBalanceAmount 2013-06-13 12:02:30,747 WARN JDBCExceptionReporter,http-bio-8080-exec-104:100 - SQL Error: 1062, SQLState: 23000 2013-06-13 12:02:30,748 ERROR JDBCExceptionReporter,http-bio-8080-exec-104:101 - Duplicate entry 'AccountType-15327' for key 'name' 2013-06-13 12:02:30,748 ERROR AbstractFlushingEventListener,http-bio-8080-exec-104:325 - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl#34801] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2443) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2325) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2625) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115) 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:168) 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:883) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:881) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:77) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:66) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:521) at sun.reflect.GeneratedMethodAccessor933.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy15.saveResource(Unknown Source) at sun.reflect.GeneratedMethodAccessor931.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.jaspersoft.ji.adhoc.service.EasyXMLizer.invoke(EasyXMLizer.java:42) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at com.jaspersoft.ji.adhoc.service.EasyXMLizer.invoke(EasyXMLizer.java:42) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PermissionsPrefetcher.invoke(PermissionsPrefetcher.java:78) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PermissionsPrefetcher.invoke(PermissionsPrefetcher.java:78) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy19.saveResource(Unknown Source) at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.saveResource(PathTransformationRepositoryService.java:525) at sun.reflect.GeneratedMethodAccessor931.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy19.saveResource(Unknown Source) at com.jaspersoft.jasperserver.remote.handlers.AbstractResourceHandler.update(AbstractResourceHandler.java:335) at com.jaspersoft.jasperserver.remote.services.impl.ResourcesManagementRemoteServiceImpl.updateResource(ResourcesManagementRemoteServiceImpl.java:413) at com.jaspersoft.jasperserver.rest.services.RESTResource.doPost(RESTResource.java:304) at com.jaspersoft.jasperserver.rest.RESTAbstractService.execute(RESTAbstractService.java:109) at com.jaspersoft.jasperserver.rest.RESTAbstractService$$FastClassByCGLIB$$c9596599.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) at com.jaspersoft.jasperserver.rest.services.RESTResource$$EnhancerByCGLIB$$e60da745.execute(<generated>) at com.jaspersoft.jasperserver.rest.RESTServlet.service(RESTServlet.java:135) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) 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) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.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) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PasswordExpirationProcessingFilter.doFilter(PasswordExpirationProcessingFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) 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.api.metadata.user.service.impl.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter.java:81) 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 org.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 com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) 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: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:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 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:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'AccountType-15327' for key 'name' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) ... 128 more 2013-06-13 12:02:30,762 ERROR RESTServlet,http-bio-8080-exec-104:187 - request params: Path: /resource/public/overture-01/public/common/Reports/Accounts_Receivable_Reports/AccountsReceivableAgingReport Requested Service: resource httpStatus: 403 error: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl#34801]; SQL [update JIResource set version=?, name=?, parent_folder=?, childrenFolder=?, label=?, description=?, resourceType=?, creation_date=?, update_date=? where id=? and version=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl#34801] The reason that I am confused is that I am attempting to perform an update (using POST instead of PUT) which means that I am expecting the resources to exist already. So why is the backend trying to create new records when it should just be overwriting the old ones? Peter

Greetings, For some reason, my Jasperserver is deleting my report schedules whenever I log in. I can create a report schedule, and have it show up on the schedule list. But if I log in (with a different browser for example) the schedule disappears. There isn't anything in the logs that would indicate a problem. Why is Jasper deleting my schedules? Peter.

Assuming that you meant 'text field' where you wrote 'test field', the yes, that is exactly what I said in my question. What I need to understand is why this is the case, and how to work around it to achieve my goal.

I have a report which contains a table. I would like to hide the columns of that table based on the result set of the query that backs the table. As an example, here is the XML for one of the columns: $F{Total1_header} != null $F{Total1_header} $F{Total1} [/code]For some reason, my jasperserver is complaining about the printWhenExpression. It claims that $F{Total1_header} does not exist. It does not complain however about the instance of $F{Total1_header} in the textFieldExpression. I can't figure out why the field is avaiable for the textFieldExpression, but not the printWhenExpression. Peter.

I am using JasperServer Pro 4.7. I've tried creating the theme in the user's organization but that doesnt seem to help.

Greetings, I have created an 'embedded' theme which hides the banner and footer sections of the jasperserver web page, and I am trying to insert the theme into the URL using a theme=embedded parameter. This works fine when I am logged in as superuser, but when I try to use it as a tenant user, the theme directive is ignored. Any idea what I am doing wrong? Peter

I do indeed get the additional parameter logs. However, as they are not in-line, they are not useful for a cut-and-paste into an SQL executing tool. My query literally has more than seventy parameter entries... I'm hoping that there is a configuration parameter to cause log4j to display parameter values in-line...

Greetings Olga, I don't think encodings are the issue. What is happening is that the report parameters $P{...} are being translated into question marks instead of the parameter values: SELECT * FROM table WHERE table.field = $P{Parameter} gets logged as: SELECT * FROM table WHERE table.field = ? instead of: SELECT * FROM table WHERE table.field = 123.456 I need for the log to report a valid SQL query with parameter values so that I can copy the query into MySQL Workbench and debug it. '?' symbols aren't valid SQL. Cheers, Peter.

I'm trying to convince my JasperServer to spit out the SQL queries it performs to the log file so that I debug them. I've seen the following post http://community.jaspersoft.com/questions/526007/logging-sql-query-executed and that does cause most of the query to be posted to the log. However, the query includes many question marks in place of parameter values. Is there some configuration option to convince Jasper to log the whole query, in a form that I can cut and paste into MySQL Workbench so that I can debug it?

What types are the date field and the date and date1 parameters? I suspect that converting the date field to a character string will cause you some grief.

Greetings, We've done this using a single select input control where different numbers represent different time periods: 0 -> arbitrarty time interval defined by frm_date_time to to_date_time 1 -> Yesterday 2 -> Today 3 -> Month to date. We then use a BETWEEN condition where the end points are CASE-WHEN-ENDs: report_sales_detail.tran_date BETWEEN (CASE $P{Date_Range_List} WHEN 0 THEN $P{frm_date_time} WHEN 1 THEN CURDATE() WHEN 2 THEN (CURDATE() - INTERVAL 1 DAY) WHEN 3 THEN (CURDATE() - INTERVAL (DAYOFMONTH(CURDATE()) - 1) DAY) END)) AND (CASE $P{Date_Range_List} WHEN 0 THEN $P{to_date_time} WHEN 1 THEN (CURDATE() + INTERVAL 1 DAY) WHEN 2 THEN CURDATE() WHEN 3 THEN (CURDATE() + INTERVAL 1 DAY) END)) Note that I may have the parentheses wrong in the above. I cut it out of one of our existing reports. There is no reason you couldn't extend this to include last-month and last-6-months... Let me know if you need further explanation. Peter.

Greetings, We're using JasperServer 4.5 and we're having a problem with users trying to export huge (200K rows) reports using Excel's xlsx format. What happens is that a user will run a huge report. The report runs fine and the results are returned in the browser, but when the user attempts to export the result to xlsx, the server eats up all its available RAM and hangs itself. We're wondering if there is some way to have the xlsx exporter behave itself, and either generate the report as requested, or have it fail gracefully with some kind of message, or at least not bring the tomcat server to its knees. Cheers, Peter.

Greetings, In our application, we have been using an organization's temp folder as a place to store the results of scheduled reports. However, in 4.7 this folder is not visible to an organization's users. (This was not the case in 4.5) Does anyone know how to make an organization's Temp folder visible to an organization's users? Peter.

Greetings, I'm having some trouble configuring a table component in a JasperReport. My goal is to have cells in a column change either their width or their height depending on the size of their content? I'm looking at the "Stretch Type" property. However this doesn't appear to be what I want. Any suggestions? Peter

I've seen a number of reports in Jasper that use hyperlinks to allow a user to drill-down from a high-level to more specific parts of their data. My understanding is that this uses hyperlinks to navigate between a set of related report definitions, where each separate level uses a different report definition. So a yearly summary report shows rows representing a years worth of data. Clicking on one of these entries hyperlinks you to a separate report showing the same data broken down by quarter for the selected year, then perhaps months within quarters, and so on until you reach individual transactions for a particular day. My understanding however, is that each report is effectively separate so that opening the quarterly summary for a given year means that all the other yearly data disappers and is replaced by the quarterly data for the selected year. What I am looking for however is more like a hierarchy of groups in a tree view. The user could then click on a node in the tree to open the next level summary for that node, while still having the other nodes in the tree visible. The user should also be able to have multiple nodes open at once to facilitate year-by-year comparisons, and that sort of thing. Does anyone know if this is possible in Jasper? Peter.

Greetings, I'm migrating from JRS 4.5 to 4.7 and I'm noticing a problem with some of my hyperlinked reports. What is happening is that when the user clicks on a hyperlink, instead of being transferred to a drill down report, the column goes grey and some icons (formatting, filtering, sorting) appear at the top. I'm guessing that this is the new "Interactive Reporting" feature of 4.7. However, its interfering with my hyperlinks. Anyone know how to disable this feature or make it play nice with hyperlinks? Peter.

Greetings, I'm building a timesheet report that has two levels of grouping, one by employee, and one by week. I would like the employee group header to appear at the top of every page. I've set 'reprint header' to true, however, the second page of the report does not have a group header... Any suggestions? Peter.

Greetings, I've given up on using the REST service. It appears to be incapable of recognizing a valid multipart request, which is necessary for creating file resources. So now I'm on SOAP. But from the docs, it appears that Jasper uses their very own kind of SOAP, without envelopes or other SOAPy constructs. From the doc: The following sample request lists the repository root: <?xml version="1.0" encoding="UTF-8"?><request operationName="list" locale="en"> <resourceDescriptor name="" wsType="folder" uriString="/"> <label>null</label> </resourceDescriptor></request> However, when I send that document to the repository, I get: <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server.userException</faultcode><faultstring>org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 31; XML document structures must start and end within the same entity.</faultstring><detail><ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">localhost.localdomain</ns1:hostname></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope> Does anyone have any experience using the SOAP service? Peter.

For us, the problem was using the parameter in an input control, and removing the "Always prompt" flag. I'm convinced that this is just a bug. Jasper support is aware of the issue. If you've got a support contract, I'd suggest you open your own case, so that the devs can get a sense of how serious a problem this is for their customer base.