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?