How to Trace Report?

General
, ,
1

Hi All,

How to Trace Report Rule ?

2

Hi @AbhishekC1725

Hope you are doing well.

You can trace the Report definition by enabling the DB Query in event types to trace. Also enable the report related ruleset in tracer settings. After this settings are done you can see and debug the generated SQL script of the report definition rule. It shows each SQL query sent to the PegaRULES databases and its results, including expansion of the BLOB column.

Hope it helps.

Thank You

Megha

3

@Megha007

Hi,

Thanks for reply. But in report definition rule Action menu No Tracer options is present.

Check attached screenshot.

PIC.png
PIC.png1573×685 79.6 KB

4

Hi @AbhishekC1725,

By Default Pega disabled the tracer option in the Action Menu; Pega enabled some of the rules only, like activity, etc.

If you want to trace this report definition from the Action Menu, just do a private edit and add condition as mentioned below.

Note: If you want to see RD results in the tracer, please enable the DB Query in EVENT TYPES TO TRACE

DB Query: Show each SQL query sent to the PegaRULES databases and its results, including expansion of the BLOB column.

Tracer.jpg
Tracer.jpg1381×700 110 KB

I hope this will help you.

Thanks,

Ashok

5

@Megha007 Hi, Yes I have done all the settings you are saying + setting suggest by Bhumireddy.

Thanks

6

@AbhishekC1725

To check the Pre and Post execution queries of report definition, enable DB Query option in Tracer settings and execute the report definition.

Once report is executed switch back to tracer and navigate to SQL Query step :

For Pre SQL: Navigate to the step where Even Type is SQL: Click on the step, the query that is present in SQL attribute is Pre SQL

For post SQL : Navigate to the step where Even Type is Package Results: Click on the step, the query that is present in SQL attribute is Post SQL

https://support.pega.com/question/generated-sql-during-report-definition-execution

7

@Hitesh Jain Thanks for Response. Now I understand what mistake I am doing while tracing report.

I am using tracer from Action menu of Report definition that is suggested from BhumiReddy. In that tracer no events are getting recorded.

Now, I used the tracer which is globally present in DEV studio, bottom ribbon. Now I am able to find the options and step that you mentioned.

Thanks for help.

8

Hi @AbhishekC1725,

Usually, you asked that the trace option not be available from the action menu of the RD, so I have requested that you please private edit the OOTB rule. Mostly Report Definition Trace from the Global Tracer, not from the Action menu; I have just suggested the option from the Trace from Action Menu. Moreover, I am not clear on what you are asking.

I hope your query got resolved ?

Thanks,

Ashok

9

@Bhumireddy Hi,

Thanks for reply, Now I can see trace option in Action menu of report definition.

But after running the report by opening Tracer no events got recorded in Tracer.

I done the DB query setting + Pega-Reporting ruleset setting in Tracer.

10

Hi @AbhishekC1725

Can you please tell that you can see the SQL queries for the particular report definition, and also make sure that you have increased the Max Trace Events to Display to more than 500 so that you dont miss the execution of the report.

Megha

11

@Bhumireddy Yes, Got resolved. Thanks for Help. I leant something new.