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

[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

[Jivan Phadtare]

By looking at log it seems that it caused by below

-------------------
Caused by: org.postgresql.util.PSQLException: ERROR: column "resource_uri" of relation "jiaccessevent" does not exist
  Position: 49
-------------------

Per this error message, kindly check in your 'jasperserver' database "jiaccessevent" table exist if so then make sure this table contains column "resource_uri"