Run Explorer of Central UI does not show run history due to 'Null value was assigned to a property'

  • KM03810114
  • 18-May-2021
  • 18-May-2021

Summary

The Run Explorer tab of Central UI does not show run history due to 'Null value was assigned to a property'. It can be resolved by manually setting all AUTO_RESUME columns of the OO_EXECUTION_SUMMARY table to '0'.

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.