irparajababu5190

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

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)

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"}

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.