Discussion

1
Replies
45
Views
jafferSathick Member since 2010 23 posts
TCS
Posted: 5 years ago
Last activity: 5 years 1 month ago
Closed

-542 error on CPM upgrade from 6.2 sp3 to 713

We are upgrading CPM from 6.2 sp3 to 713. Our Database is DB2ZOS. We just performed an upgrade from Pega 6.2 sp1 to Pega 7.1.8 . As part of the CPM upgrade guide, we executed the generateddl.sh script with the correct parameters as instructed.

When generated ddl was executed, the following error appeared:

ALTER TABLE XXXXXX.pca_rating_knowcont,
ADD CONSTRAINT pca_rating_knowcont_PK PRIMARY KEY
(
EntityKey,
RatingEntity
)
@
---------+---------+---------+---------+---------+---------+---------+--------
DSNT408I SQLCODE = -542, ERROR: RATINGENTITY CANNOT BE A COLUMN OF A HASH
KEY, PRIMARY KEY, A UNIQUE CONSTRAINT, OR A PARENT KEY BECAUSE IT CAN
CONTAIN NULL VALUES

Should RATINGENTITY column be defined as NOT NULL to allow it to be part of the primary key, as a column cannot be NULL and be part of a primary key? If a column can be NULL then it could allow duplicate entries and a primary key has to be unique.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn