"Transaction rolled back because it has been marked as rollback-only" in Jaspersoft after in place upgrade to Jaspersoft 9

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After upgrade to Jaspersoft 9 in same place upgrade from 8.1.1, error is thrown on Search and accessing some folders in Advanced Reporting (Time Management and Project Management): 

2024-12-12T08:49:46,877 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-6:135 [] - Transaction rolled back because it has been marked as rollback-only
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:870) ~[spring-tx-5.3.33.jar:5.3.33]
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:707) ~[spring-tx-5.3.33.jar:5.3.33]

Environment

Jaspersoft 9

Cause

DEST_TYPE column value in JIREPORTJOBREPODEST table has value 11 after in place upgrade of Jaspersoft. This is a Tibco defect

Resolution

1. Run the SQL Statements:
   update JIREPORTJOBREPODEST set dest_type =1 
   commit
   ---Make sure all the dest_type is 1
   ALTER TABLE JIREPORTJOBREPODEST modify dest_type number(10,0) DEFAULT 1
   ---This will make the value default for new entries going forward
2. No restart is required