Adding keys to DD
Hello,
I´m trying to put another primary keys in Decision Data is giving us a lot of problems due to we´ve applied some solutions as: doing a save as of the DD we want to modify and deleting all the records and then try to add the property which we want to be a primary key also we´ve created a new DD and tyrying to add the others primary keys and in both cases Pega is not allowing us to do it.
Exist any other form to do it? Are there any limitations about primary keys?
I´ve seen it that are other similar question but is redirecting me to main page.
Pegasystems Inc.
GB
@RocioG63 In Pega, adding or modifying primary keys in existing data types can be challenging. One approach to change primary keys is to use RDB-Open and RDB-Save methods in an activity and execute SQL queries to update the primary key constraints in the database. However, this method requires caution and should be done only in a development environment after exporting all records from the table.
Another option is to create a new data type with the desired primary keys and migrate the data from the old data type to the new one. This approach is safer and avoids directly modifying the database schema.
There are no specific limitations on primary keys, but it's essential to ensure that the primary keys uniquely identify each record in the data type. If you still face issues, it might be helpful to consult Pega Support for further assistance.
This answer came from a Pega gen-AI assistant using the following references:
How to change the key in Data Type
Changing a datatype value for a key in while configure source.
As a Support Center moderator, I reviewed the answer and references for accuracy.