Can work table function as it is without pzInsKey as Primary Key
In PEGA PRPC for a work object is it required the underlying mapped work table to have PZINSKEY to be mandatory Primary key on table?
Due to some oracle table partitioning limitations DBAs are asking if we can have it (PZINSKEY column on worktable) as “Unique Key” instead of Primary key. And still all the OOTB step methods obj-* function as it is?
Accepted Solution
Pegasystems Inc.
IN
Hi Ravi,
I have completed the discussion with DataEngineConsulting team.
Having pzInsKey be the primary key is pretty fundamental to PegaRULES.
It's quite possible that most operations would work fine.But it's possible that certain more advanced functionality (such as those related to schema changes) might not work. It's also possible that upgrades would run into difficulties, or that in future versions of PegaRULES something could go wrong.
We can't recommend this considering the above risk, but you could try "at your own risk." If this is something which you thinks is very important, then please describe the use case and we will see what best we can do.
Regards,
Sudhish OP
Pegasystems Inc.
IN
Hi Ravi,
I think we can make it as unique key.There are some differences like unique will allow null and indexs on pk.
We need to get input from DataEngineConsulting team to get assurity on this.Let me try to coordinate with them and will get back to you.
Accepted Solution
Pegasystems Inc.
IN
Hi Ravi,
I have completed the discussion with DataEngineConsulting team.
Having pzInsKey be the primary key is pretty fundamental to PegaRULES.
It's quite possible that most operations would work fine.But it's possible that certain more advanced functionality (such as those related to schema changes) might not work. It's also possible that upgrades would run into difficulties, or that in future versions of PegaRULES something could go wrong.
We can't recommend this considering the above risk, but you could try "at your own risk." If this is something which you thinks is very important, then please describe the use case and we will see what best we can do.
Regards,
Sudhish OP