Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

NextBest Action UI Latency caused by poorly performing SQL

SA-17863

Summary



User is using Next-Best-Action Advisor (NBAA) UI on top of Pega 7.1.7 instance.

On the NBAA UI, once the intent is selected and Perform action is clicked, system is very slow and there is a lag before the offers tab is displayed. 


Error Messages



Not Applicable.


Steps to Reproduce



On the NBAA UI, once the intent is selected and Perform action is clicked, system is very slow and there is a lag before the offers tab is displayed.

Root Cause



A defect or configuration issue in the operating environment. 
Analyse the Pega Alert log file and found Pega0005 alerts, since the query time execution exceeds the limit for the below queries:

UPDATE DATA.pr_sys_statusdetails SET pxType='interval' WHERE pxType = 'current' AND pySysNodeId = ? AND pyNodeName = ? AND pySystemName = ?

Delete From DATA.PR_DATA_DM_ADM_PRED_FACT  Where pxObjClass = 'Data-Decision-ADM-PredictorBinningSnapshot' and pySnapshotTime = ?

Resolution



Create indexes for the tables -
pr_sys_statusdetails and PR_DATA_DM_ADM_PRED_FACT.

​ Also, user is suggested to purge and archive unused stale data. 

After creating indexes for the above tables, user has run the use-case and they did not observe Pega0005 alearts.

User has noticed few PEGA0031 alerts and has been advised to refer articles on PDN to understand the root cause for the PEGA0031 alerts, as this is specific to their application code.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

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

Pega Community 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
Contact us