Question

Facing issues with SLA FunctionAlias pxSLAAgeByClassTimeliness and Report Definiton pyAgeResolvedByClass

Hi Team,

I'm working on Pega 7.1.9 and we are using SQL server as our Application DB.

The issue is when I run pyAgeResolvedByClass OOTB Report Definition rule it is only populating the results for within goal cases even though I have cases with past goal and past deadline.

PFA I have the screenshot

Can anyone help on this.

Thanks,

Vyas Raman Loka

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
December 1, 2016 - 12:49am

Hi Vyas,

It seems the properties pySLAGoal and pySLADeadline are being updated as null, through Resolve Activity which is invoked when any WO is resolved. As the report is querying for these corresponding columns we are observing null values in the report.

Attached screenshot of resolve activity.

You may raise an SR with GCS for further investigation.

 

Comments

Keep up to date on this post and subscribe to comments

Pega
November 30, 2016 - 12:46pm

Hi,

Can you post the db query that is getting triggered on running the RD ?
Also please try to execute the same query directly on your db, and check if the results are getting fetched or not .
Also make sure you are trying it with ootb RD .

December 1, 2016 - 12:49am

Hi Vyas,

It seems the properties pySLAGoal and pySLADeadline are being updated as null, through Resolve Activity which is invoked when any WO is resolved. As the report is querying for these corresponding columns we are observing null values in the report.

Attached screenshot of resolve activity.

You may raise an SR with GCS for further investigation.

 

December 1, 2016 - 4:24am

Hi Vyas,

If you go ahead with raising a support request with GCS, please free to share the SR number here within the thread. This will help us track the SR via the thread.

Thank you for your cooperation.

~Vidyaranjan A V | Community Moderator | PegaProductSupport | Pegasystems Inc.

Vidyaranjan | Community Moderator | Pegasystems Inc.