Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Srinivasu Anjuri (SrinivasuA)
TCS

TCS
IN
SrinivasuA Member since 2015 16 posts
TCS
Posted: Oct 5, 2017
Last activity: Oct 13, 2017
Posted: 5 Oct 2017 2:50 EDT
Last activity: 13 Oct 2017 5:29 EDT
Closed

Remove Primary Key constraint in PYID

Hi

We have a class with keys other than pyid. We want to remove primary key constraint on PYID or entire column as pyid is not required anymore, will it cause any issues ?

Please suggest.

Regards

Srinivasu

To see attachments, please log in.
System Administration
Data Integration

Posted: 7 years ago
Posted: 6 Oct 2017 13:55 EDT
Adam Kraus (AdamKraus) Senior Technical Solutions Engineer
Pegasystems Inc.
US

I wouldn't recommend it - Pega expects pyID to be unique, and there are places where instances are opened by pyID.  If somehow there are two things with the same pyID, that would cause a problem there.  Having pyID be a primary key guarantees it's unique.

To see attachments, please log in.
Posted: 7 years ago
Posted: 13 Oct 2017 5:29 EDT
Srinivasu Anjuri (SrinivasuA)
TCS

TCS
IN

we are using createuniqeid() for generating unique id for pyid. But it is not unique always. There are multiple requests are being processed in 1 sec, which are giving same id and resulting failure.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice