Question
Capgemini Technological Services
IN
Last activity: 12 Aug 2022 12:21 EDT
Slow SQL on table PEGADATA.PR_DATA_OP_SESSION.
I am getting this error in PDC constantly.
SQL Analysis
SQL Statement
UPDATE pegadata.pr_data_op_session "PC0" SET "pxstate" = ?, "pxupdatedatetime" = ?, "pxnodeid" = ? WHERE (pzRequestorId = ? AND pxState <> ? AND "PC0"."pxclusterid" = ?)
REFERENCED COLUMNS IN WHERE CLAUSE
PR_DATA_OP_SESSION.PXCLUSTERID, PR_DATA_OP_SESSION.PXSTATE, PR_DATA_OP_SESSION.PZREQUESTORID
REFERENCED TABLES
PEGADATA.PR_DATA_OP_SESSION
Does anyone have idea how to resolve this issue.
Pegasystems Inc.
IN
Quick questions here.
What is your total operator base
which region are you seeing this error happening (DEV/QA/UAT/PROD) ?
At a given point in time how many operators will be active?
ING Bank NV
NL
@Abhishek_Pega Hi Abhishek,
we too seeing the same error,
did you got any fix for this , could you please help.
Thanks in Advance,
Tejas
Mphasis
US
@Abhishek_Pega I hope you have large amount of data in this table. Please create indexes on where clause columns used in above query. Problem will be solved automatically.