pr_data_op_session
Hi - how/when should this table be cleaned up? It appears to be growing continually with multiple entries (35000 for one of the ids) for operators. The name would suggest that it contains an entry for the current operator session. We have 2000 users on our system and there are 200,000 entries in this table.
We are starting to see PEGA0042 alerts for the id that has 35000 entries. Here is the query that the PEGA0042 references.
What I want to understand is what process should be keeping this table clean as it obviously isn't working.
SELECT "SESS".pyOperatorId AS "pyOperatorId", "SESS".pxState AS "pxState", "SESS".pxCreateDateTime AS "pxCreateDateTime", "CustomCategoryAlias".pzPVStream AS "pzPVStream" FROM SSWMS01.pr_data_op_session "SESS" LEFT JOIN SSWMS01.pr_ChannelServices_OperatorPre "CustomCategoryAlias" ON (("SESS".pyOperatorId = "CustomCategoryAlias".pyOperatorId) AND ("SESS".pxClusterId = "CustomCategoryAlias".pxClusterId) ) WHERE ("SESS".pyOperatorId = ?) AND ("SESS".pxClusterId = '7a1920d61156abc05a60135aefe8bc67')