Question
Morgan Stanley
Morgan Stanley
IN
Morgan Stanley
Posted: Mar 22, 2019
Last activity: Mar 25, 2019
Last activity: 25 Mar 2019 8:16 EDT
Closed
Alter composite key of a class created using a data type
Hi
i have created a db table using a data type with composite key. I need to alter the composite key to remove a field and change it to a single primary key.
I have:
1. Altered the db table and changed the key
2. Changed the keys of the class record.
3. Restarted and saved the DB Table instance
However, when i add a record in the data type and try to edit it its still not allowing me to update the value which was present in the composite key.
The default behavior is that it does not allow us to update any fields if they are part of the class keys.
I'm using Pega 7.4
Posted: 6 years ago
Incessant Technologies
AU
Hello,
It should work if the database table altered externally and modify the class keys and save the respective database table instance.
1. Please check with Obj-Open using class single class key, if this works, then trace if there is any Validate rule triggering while updating the record.
2. Please double check the keys from database schema changes from pega end.