Question

1
Replies
15
Views
Close popover
Amaranathan Suriyanathan (AMARAN84)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
AMARAN84 Member since 2011 1 post
Cognizant Technology Solutions
Posted: March 11, 2021
Last activity: March 25, 2021
Solved

Inserts into pr_data_notification_recipient

We are seeing millions of inserts happening into the table pr_data_notification_recipient since we have upgraded PEGA Robotics from 7 to 8.5. Below is the insert query which keeps on running. Any idea from where and why it is getting executed, and how it can be prevented?

 

INSERT INTO CIWPROD_DATA.pr_data_notification_recipient (pzInsKey , pxCommitDateTime , "PXAPPLICATION" , "PXCREATEDATETIME" , "PXCREATEOPERATOR" , "PXCREATEOPNAME" , "PXINSNAME" , "PXNOTIFICATIONID" , "PXOBJCLASS" , "PXRECIPIENTID" , "PXSAVEDATETIME" , "PXUPDATEDATETIME" , "PXUPDATEOPERATOR" , "PXUPDATEOPNAME" , "PYGUID" , "PYRULESETNAME" , "PYSTATUS") VALUES (:1  , CURRENT_TIMESTAMP , :2  , :3  , :4  , :5  , :6  , :7  , :8  , :9  , :10  , :11  , :12  , :13  , :14  , :15  , :16 )

Pega Robotic Process Automation Robotic Process Automation Healthcare and Life Sciences Senior System Architect