Support Article

Errors in the logs, every time a new interaction is launched

SA-37429

Summary



The user is using CSHC 7.1.4 on Pega 7.2 and seeing the below exception when a new interaction in portal is launched.


Error Messages



An error occured during resolving the report definition - One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: .Member.pyWorkPartyUri. Revise the join conditions or optimize the property.
com.pega.pegarules.data.internal.rd.resolve.UserResolveReportException: One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: .Member.pyWorkPartyUri. Revise the join conditions or optimize the property.


Steps to Reproduce

  1. Launch a new interaction in the portal
  2. Check the log file and see the erros.


Root Cause



A defect in Pegasystems’ code or rules.

Resolution



Perform the following local-change:

Create a Dynamic Syatem Setting Pega-Engine prconfig/reporting/usestreaminjoinconditions/default and set it to true.




Published May 3, 2017 - Updated May 5, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.