Error occurs when running a secondary upgrade for Plan Objects
The User has Pega Product Composer for Health Care 7.22.
Error occurs when running a secondary upgrade to Product Composer for Health Care 7.31 for new Plan Objects.
Problem writing an instance to the database: code: -302 SQLState: 22001 Message: The value of a host variable in the EXECUTE or OPEN statement is out of rand=ge for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.68.61
Steps to Reproduce
Run a secondary upgrade.
A defect or configuration issue in the operating environment.
One of the columns of PEGARULES.pc_ _Work had less size than the data which was inserted in it.
ResolutionPerform the following local-change:
Increase the column length limit to a greater value.
In this scenario, the size of the pzpvStream column is increased by 1 MB in the table mapped to plan work object.