Question
Tech Mahindra Ltd
IN
Last activity: 21 Jul 2016 8:17 EDT
Pega Warning Table (pr_index_warnings) column 'pxiswarningjustified' possible values
As per the name of column('pxiswarningjustified'), it should contain either true or false as permissible values. If warning is justified value set as true which is ok.
But we have observed that lot of warning records are having 'null' value for this column and very few warnings records contains 'false'.
We are trying to get the acurate number of preflight warnings for our application ruleset rules. Is there any better way(apart from Guardrail report) to get the correct count of preflight warnings after upgrade to Pega 7.1.7 from Pega 6.2.
***Updated by moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
EPAM Systems, Inc.
ES
Hi Yuvraj,
I am not sure about the enteries in your environment for "pxiswarningjustified".
Just to add on "to get the correct count of preflight warnings", You can try two ways :-
1. You can customised "pxRuleWarningsInAppAndFW" report definition based on your need. You can add an aggregate function on the column to get the count of the warnings and run the report.
2. Below query is to get the list of all warnings against ruleset versions
"SELECT
Hi Yuvraj,
I am not sure about the enteries in your environment for "pxiswarningjustified".
Just to add on "to get the correct count of preflight warnings", You can try two ways :-
1. You can customised "pxRuleWarningsInAppAndFW" report definition based on your need. You can add an aggregate function on the column to get the count of the warnings and run the report.
2. Below query is to get the list of all warnings against ruleset versions
"SELECT
PXREFERENCINGRULESETNAME AS "RuleSet",
PXREFERENCINGRULESETVERSION AS "Version",
PXREFERENCINGCLASSNAME AS "Applies-To",
PXREFERENCINGOBJCLASS AS "RuleType",
PXREFERENCINGRULENAME AS "RuleName",
PXWARNINGNAME AS "Warning",
PXWARNINGSEVERITY AS "WarningSeverity",
PXWARNINGTYPE AS "WarningType",
PXWARNINGDETAILS AS "WarningDetails"
FROM
pega1.Pegarules.PR_INDEX_WARNINGS
WHERE
PXREFERENCINGRULESETNAME IN ('ImplApp', 'FW', 'Org', 'OrgInt')
AND PXREFERENCINGRULESETVERSION like '01-05-%'
AND pxIsWarningJustified IS NULL
ORDER BY
PXREFERENCINGRULESETNAME,
PXREFERENCINGRULESETVERSION,
PXREFERENCINGOBJCLASS,
PXREFERENCINGRULENAME;"
Kindly create index as well to enhance the performance the query as it may be slow due to large number of data retrieval.
create index pr_index_warnings_tidx1 on pr_index_warnings(PXREFERENCINGRULEINSKEY, PXOBJCLASS)
RUNSTATS ON TABLE pr_index_warnings
Kindly update me, if it helps.
Tech Mahindra Ltd
IN
Thanks for the details.We have created similer type of query to get the count of preflight.
But we have observed that the count is varying on different environments inspite having same number of rules in application ruleset. So we deleted all the preflight warnings and re-generated warnings by skimming all app ruleset versions to a higher ruleset version. This time the count of warnings has gone up more than twice, it was earlier.
Now the question here is ,which count is accurate and we should rely?
- existing preflight warnings which we observed just after upgrade to Pega7?
- warnings generated in skim exercise in Pega 7?
Thanks & Regards,
Yuvraj Joshi