Pega Marketplace Terms of Use
Pega Marketplace
Database Query Extractor
Extract the complete query for a report definition which can be ran directly in the database.
By using or submitting listings via the Pega Marketplace, you agree to our Terms of Use.
Overview
When database queries on your Pega instance are taking longer to execute then expected a PEGA0005 alert will appear ( DB query taking long time). The first step we do to resolve the issue is running tracer. However running tracer slows down the system further. The other alternative is to get the query from the clipboard and run the query directly on the DB and manually check the behavior. However, forming the query from tracer/clipboard is a cumbersome task because we have to manually replace the unknown parameter field that appears as "?" with the SQL inserts. This process is not only time consuming, but it is also error prone.
This component is provided as an activity rule developed with an aim to help engineers and developers extract the complete query for a report definition which DBA can be ran directly in the database. It can save loads of time while debugging report related slowness issues.
Key Features
- Eliminates manual task in forming the query which is highly error-prone and time-consuming.
Resources
Version
Compatible with
Pega Platform 8.1 8.2 8.3 8.4 8.5Product Owner
Slawomir MichalskiLast updated
February 25, 2022Product Capability
Dev/Designer Studio