Issue: Receive an error when executing ArchiveTask for some Deploy tasks

Issue

Unable to archive tasks and receive the following error:

deployit.log.psbsirxd01.20220215-org.springframework.dao.DataIntegrityViolationException: 
PreparedStatementCallback; SQL [insert into "XLD_ARCHIVED_TASKS" 
("task_id", "task_kind", "worker_name", "task_details") values (?, ?, ?, ?)]; 
DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.27.25; 
nested exception is com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001,
   SQLERRMC=null, DRIVER=4.27.25

Cause

The issue is caused by the column size in the DB2 table where you receive the SQL code error. See below the explanation for the DB2 error code SQLCODE=-302:  https://stackoverflow.com/questions/9625336/sqlexception-db2-sql-error-sqlcode-302-sqlstate-22001-sqlerrmc-null

Workaround/Resolution Action

To fix this issue please increase the column of task_details in the XLD_ARCHIVED_TASKS table. Use the command below or a similar command that can execute in DB to increase the size.

Make a backup of the database before running the query.

alter table XLD_ARCHIVED_TASKS modify task_details longtext;