Support Article
PegaHCSPM installation fails importing PegaCRMHC.jar
SA-89445
Summary
PegaHCSPM installation fails importing PegaCRMHC.jar to Pega 8.3.
Error Messages
pzCurrentComponent: The following SQL statement contains a change to column type. Type changes are not allowed.ALTER TABLE DATA.CPMHC_WORK ALTER COLUMN "PYASSIGNEDOPERATOR" SET DATA TYPE CHAR (255)
The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "CHAR (255)" is not valid.. SQLCODE=-604, SQLSTATE=42611, DRIVER=127.0.0.1
Steps to Reproduce
- Import PegaCRMHC.jar
- Apply the generated DDL changes automatically
Root Cause
A defect in Pegasystems’ code or rules. The maximum char column length on DB2 is 254.
Resolution
Perform the following local-change:
Run the below SQL:
ALTER TABLE DATA.CPMHC_WORK ALTER COLUMN "PYASSIGNEDOPERATOR" SET DATA TYPE CHAR (254)
Tags:
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.