Qlik Talend Administration Center: jobconductor/server/taskexecution history list doesn't display correctly after patching

[TalendSolutionExpert]

After patching UAT from temp patch to TPS-5494-V801 , it gives Null error and empty record on executionhistory page

Cause

We found an issue that the jobconductor/server /taskexecution history list does not display any task log message or error information after patching when migrating 7.0, 7.1 and 7.2 projects to higher versions.

It is caused by the older Legacy version 7.0, 7.1 and 7.2 TAC POJO model e_version column value was not initialized with the integer value but null or empty value, which is not allowed in latest V 7.3.1 and 8.0. Due to this issue, the default auto migration step cannot extract the integer value from POJO model e_version column and correctly follow the way to migrate projects in the further steps .

POJOmodelEversionColumn

The model initiative step will throw the following error in UI :

2023-10-23 10:01:50 ERROR TalendRemoteServiceServlet - Unexpected exception : Service method 'public abstract com.extjs.gxt.ui.client.data.PagingLoadResult org.talend.gwtadministrator.client.module.dashboard.taskexecmonitoring.grid.service.TaskExecutionHistoryService.getExecutions(org.talend.gwtadministrator.client.module.dashboard.taskexecmonitoring.grid.model.taskexecution.TaskExecutionHistoryFilterBean,com.extjs.gxt.ui.client.data.FilterPagingLoadConfig) throws org.talend.gwttoolkit.client.exception.ClientBusinessException' threw an unexpected exception: org.talend.administrator.common.exception.SystemException: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.talend.model.conductor.ExecutionTask.version org.talend.administrator.common.exception.SystemException: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.talend.model.conductor.ExecutionTask.version

Resolution

Check which table-related model was impacted by Null value and re-initialize POJO model e_version column value manually with running SQL query upon the tac db:

update executiontask set e_version=0 where e_version is null;
update taskexecutionhistory set e_version=0 where e_version is null;
update executionvirtualserver set e_version=0 where e_version is null;
update executionserver set e_version=0 where e_version is null;

Environment

Talend Administration Center