SA-29098

Summary

There are multiple PEGA0005 alerts for below query. The SQL is taking 3 hours or longer for a simple metadata query. This happens randomly on all of Pega 7.2 MT servers.

DB query: SELECT abc.table_name FROM information_schema.columns abc INNER JOIN information_schema.tables xyz ON ( xyz.table_type = 'BASE TABLE' AND abc.column_name = ? AND xyz.table_name = abc.table_name AND abc.table_schema = ? AND abc.table_schema = xyz.table_schema

Error Messages

Not applicable

Steps to Reproduce

Not applicable(Issue is not reproduced on demand).
 

Root Cause

A defect in Pegasystems’ code or rules 

Resolution

Apply HFIX-29832