[I Tried to upgrade the jasperreport from 7.5.0 to 8.1.0 getting the below ERROR]

Hi All,

I tried to upgrade the jasperreport from 7.5.0 to 8.1.0 anfdgetting below ERROR.

2023-03-06T07:30:44,674 ERROR BatchingBatch,pool-2-thread-22:120 - HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into JIAccessEvent (user_id, event_date, resource_uri, updating, resource_type, hidden, id) values ('jasperadmin', '2023-03-06 07:30:38.745+00', '/Reports/test/summary.jrxml', 'FALSE', 'com.jaspersoft.jasperserver.api.metadata.common.domain.FileResource', 'TRUE', 3030) was aborted: ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49  Call getNextException to see other errors in the batch.], SQL: insert into JIAccessEvent (user_id, event_date, resource_uri, updating, resource_type, hidden, id) values (?, ?, ?, ?, ?, ?, ?)
2023-03-06T07:30:44,675 ERROR SqlExceptionHelper,pool-2-thread-22:131 - Batch entry 0 insert into JIAccessEvent (user_id, event_date, resource_uri, updating, resource_type, hidden, id) values ('jasperadmin', '2023-03-06 07:30:38.745+00', '/Reports/test/summary.jrxml', 'FALSE', 'com.jaspersoft.jasperserver.api.metadata.common.domain.FileResource', 'TRUE', 3030) was aborted: ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49  Call getNextException to see other errors in the batch.
2023-03-06T07:30:44,675 ERROR SqlExceptionHelper,pool-2-thread-22:131 - ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49
2023-03-06T07:30:44,675 ERROR ExceptionMapperStandardImpl,pool-2-thread-22:39 - HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: could not execute batch]
Exception in thread "pool-2-thread-22" org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute batch; SQL [insert into JIAccessEvent (user_id, event_date, resource_uri, updating, resource_type, hidden, id) values (?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute batch
        at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:228)
        at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:804)
        at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:639)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:633)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:386)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
        at com.sun.proxy.$Proxy80.saveEvents(Unknown Source)
        at com.jaspersoft.jasperserver.api.logging.service.impl.LoggingFacade$2.run(LoggingFacade.java:97)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:750)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute batch
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:121)
        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)
        at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:212)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:618)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:493)
        at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3207)
        at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2413)
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
        at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
        at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:627)
        ... 12 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIAccessEvent (user_id, event_date, resource_uri, updating, resource_type, hidden, id) values ('jasperadmin', '2023-03-06 07:30:38.745+00', '/Reports/test/summary.jrxml', 'FALSE', 'com.jaspersoft.jasperserver.api.metadata.common.domain.FileResource', 'TRUE', 3030) was aborted: ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49  Call getNextException to see other errors in the batch.
        at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
        at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:871)
        at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:910)
        at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1649)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:111)
        ... 29 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:315)
        at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:868)
        ... 34 more

[Getting the error while genarating the reports in jasperserver.]

We are getting the below error while sending the japser report sometimes.

2023-02-28T12:06:08,309 ERROR SecureExceptionHandlerImpl,quartzScheduler_Worker-1:116 - There was an error on the server. Try again or contact site administrators. (Error UID: 52231ec7-d786-44e6-9cdb-92b7b4ac81a3) 2023-02-28T12:06:08,310 ERROR ReportExecutionJob,quartzScheduler_Worker-1:367 - The job was not completed. A system error occurred while running it. (Error UID: 52231ec7-d786-44e6-9cdb-92b7b4ac81a3) java.lang.NoSuchMethodError: com.sun.mail.util.LineOutputStream.<init>(Ljava/io/OutputStream;Z)V at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1631) at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1889) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:1121) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:450) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:346) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:341) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:141) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1124) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:582) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:249) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

[Getting 400 bad syntax error]

I am getting the bad syntax error while using the below syntax in jasper report source parameters section only.

 "source": {
       "reportUnitURI": "/root/report",
       "parameters": {
           "parameterValues" : {
             "REPORT_TIME_ZONE": "America/Los_Angeles"
           }
        }
     },

OUT PUT.

{"message":"There was an error on the server. Try again or contact site administrators. (Error UID: f4f5e092-c24a-44e6-80c6-b24d693c60d3)","errorCode":"serialization.error","errorUid":"f4f5e092-c24a-44e6-80c6-b24d693c60d3"}

[Is Jasper reports supports db2 backend database]

I am working on deploy the jasper reports cp version in docker containers, Facing the many issues while building the jasper reports using db2 backend database.