After a successful upgrade to AMX BPM v4.2.0, the following error is seen in the logs - 14 Aug 2018 18:51:10,136 [PVM:Background Processor-1] [ERROR] com.tibco.pvm.system.PvmSystem - TxBlock: Error Running Block - Last State: STARTED_TRANSACTION com.tibco.pvm.db.common.dao.util.fault.IpmPersistenceFault: PVM-PERSIST-100001: Database Query Error: Engine.getOldEngines at com.tibco.pvm.db.common.orm.hb.service.IdbQueryServiceSpringImpl.executeQuery(IdbQueryServiceSpringImpl.java:407) at com.tibco.pvm.db.common.orm.dao.sys.IdbEngineDaoImpl.getOldEngineEntries(IdbEngineDaoImpl.java:163) at com.tibco.pvm.db.common.bridge.sys.impl.IdbEngineBridgeImpl$10.a(IdbEngineBridgeImpl.java:491) at com.tibco.pvm.db.common.bridge.sys.impl.IdbEngineBridgeImpl$10.run(IdbEngineBridgeImpl.java:1) at com.tibco.pvm.db.common.util.block.IdbTxBlockRunner.run(IdbTxBlockRunner.java:55) at com.tibco.pvm.db.common.bridge.sys.impl.IdbEngineBridgeImpl.getOldEngineEntries(IdbEngineBridgeImpl.java:487) at com.tibco.pvm.db.persist.services.recovery.IdbRecoverProviderAbstract.recoverThisNode(IdbRecoverProviderAbstract.java:323) at com.tibco.pvm.db.persist.services.recovery.IdbRecoveryProviderDistributed.checkGroup(IdbRecoveryProviderDistributed.java:36) at com.tibco.pvm.infra.system.recovery.IpmRecoveryServiceDistributed$CheckGroupRunnable.run(IpmRecoveryServiceDistributed.java:165) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of com.tibco.pvm.db.common.orm.dataobj.sys.IdbEngineDOImpl.failed; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.tibco.pvm.db.common.orm.dataobj.sys.IdbEngineDOImpl.failed at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:676) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQueryAndNamedParam(HibernateTemplate.java:1015) at com.tibco.pvm.db.common.orm.hb.service.IdbQueryServiceSpringImpl.executeQuery(IdbQueryServiceSpringImpl.java:403) ... 15 more Caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.tibco.pvm.db.common.orm.dataobj.sys.IdbEngineDOImpl.failed at org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:83) at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329) at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:232) at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3557) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) at org.hibernate.loader.Loader.doQuery(Loader.java:729) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2217) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108) at org.hibernate.loader.Loader.list(Loader.java:2103) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1696) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at org.springframework.orm.hibernate3.HibernateTemplate$34.doInHibernate(HibernateTemplate.java:1024) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 18 more Caused by: java.lang.IllegalArgumentException: Can not set boolean field com.tibco.pvm.db.common.orm.dataobj.sys.IdbEngineDOImpl.failed to null value at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(Unknown Source) at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(Unknown Source) at sun.reflect.UnsafeBooleanFieldAccessorImpl.set(Unknown Source) at java.lang.reflect.Field.set(Unknown Source) at org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:79) ... 34 more

The upgrade to TIBCO ActiveMatrix BPM (AMX BPM) v4.2 is successful. This error is only noticed in the log files. This error impacts process manager's recovery processing after a crash or a shutdown.

All Supported Operating Systems

This is due to a minor defect in the upgrade scripts. The workaround is to run the following statement post-upgrade - UPDATE PVM_ENGINE SET FAILED=0 WHERE FAILED IS NULL; Please contact support to check if this issue has been fixed in a future hotfix. 

WRM-10702 - Internal Defect Id