Deadlock on Jasper Reports for JRS 7.5

[narendrapothuganti7]

Hi Everyone,

I have migrated my dashboards from JRS 7.1 to JRS 7.5 and very frequently i am facing the deadlock issue. Below is the jasperserver.log:

2020-07-14T02:58:57,886 ERROR SqlExceptionHelper,pool-15-thread-504:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1345) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:57,892 ERROR SecureExceptionHandlerImpl,pool-15-thread-504:116 - could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.LockAcquisitionException: could not extract ResultSet
2020-07-14T02:58:57,892 ERROR SecureExceptionHandlerImpl,pool-15-thread-517:116 - could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.LockAcquisitionException: could not extract ResultSet
2020-07-14T02:58:58,043 ERROR SqlExceptionHelper,pool-15-thread-501:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 443) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:58,144 ERROR SqlExceptionHelper,pool-15-thread-507:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1436) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:58,246 ERROR SqlExceptionHelper,pool-15-thread-502:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1304) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:58,345 ERROR SqlExceptionHelper,pool-8-thread-255:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1432) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:58,447 ERROR SqlExceptionHelper,pool-15-thread-509:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1409) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:58:58,647 ERROR SqlExceptionHelper,pool-8-thread-256:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1438) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:59:00,417 ERROR SecureExceptionHandlerImpl,pool-15-thread-503:116 - Error evaluating expression for source text: ContextAwareHeader.chooseHeaderQuery($P{REPORT_CONNECTION}.getMetaData().getDatabaseProductName(),$P{REPORT_PARAMETERS_MAP})
2020-07-14T02:59:00,420 ERROR SecureExceptionHandlerImpl,pool-15-thread-512:116 - Error evaluating expression for source text: ContextAwareHeader.chooseHeaderQuery($P{REPORT_CONNECTION}.getMetaData().getDatabaseProductName(),$P{REPORT_PARAMETERS_MAP})
2020-07-14T02:59:01,950 ERROR SqlExceptionHelper,pool-8-thread-258:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 1276) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2020-07-14T02:59:05,153 ERROR SqlExceptionHelper,pool-15-thread-503:131 - [TibcoSoftware][sqlServer JDBC Driver][sqlServer]Transaction (Process ID 535) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 

Please help me ASAP. Thanks in Advance