Summary
Error
In OO 2020.08 environment, the Run Explorer tab in the Run Management workspace of Central UI failed to show all run history after it was upgraded from 10.80. All the run history used to be shown there before the upgrade. In addition, new run history of flow executions after the upgrade were not visible too.
When the problematic behavior was observed, there was the following ERROR message recorded in server.log of Central:
20YY-MM-DD HH:mm:ss,SSS [http-nio-8080-exec-10] (FlowExecutionV1Controller.java:126) ERROR - Null value was assigned to a property [class com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume] of primitive type setter of com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property [class com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume] of primitive type setter of com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume
org.springframework.orm.jpa.JpaSystemException: Null value was assigned to a property [class com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume] of primitive type setter of com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property [class com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume] of primitive type setter of com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:333)
(snipped)
at com.hp.oo.orchestrator.services.ExecutionSummaryServiceImpl.readExecutions(ExecutionSummaryServiceImpl.java:128)
(snipped)
Caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property [class com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume] of primitive type setter of com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume
at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:47)
(snipped)
Caused by: java.lang.IllegalArgumentException: Can not set boolean field com.hp.oo.orchestrator.entities.ExecutionSummaryEntity.autoResume to null value
at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
at sun.reflect.UnsafeBooleanFieldAccessorImpl.set(UnsafeBooleanFieldAccessorImpl.java:80)
at java.lang.reflect.Field.set(Field.java:764)
at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:41)
... 282 more
Cause
This kind of problem might be caused by some inconsistent hotfix files for Central applied before an upgrade.
Fix
In such a case, manually set all AUTO_RESUME columns of the OO_EXECUTION_SUMMARY table to '0' and then restart Central as a workaround.