Support Article
Error occurs when running a secondary upgrade for Plan Objects
SA-58946
Summary
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.
Error Messages
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.
Root Cause
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.
Resolution
Perform 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.
Tags:
Published September 18, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.