Skip to main content

Pega Marketplace Terms of Use

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

User Guide

When to use the Database Query Extractor component

Logo

Version

02

Compatible with

Pega Platform 8.1 8.2 8.3 8.4 8.5

Product Owner

Slawomir Michalski

Last updated

February 25, 2022

Product Capability

Dev/Designer Studio
Share this page Share via X Share via LinkedIn Copying...

Did you find this content helpful?

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