Support Article

WeeklyThroughputIC summary view fails with SQL error

SA-36488

Summary



The WeeklyThroughputIC summary view is throwing a SQL exception if the drilldown link is used.


Error Messages



** There was a problem getting a list: code: 4104 SQLState: S0001 Message: The multi-part identifier "PC0.pxObjClass" could not be bound.


Steps to Reproduce

  1. Run the Work-.WeeklyThroughputIC summary view.
  2. Click on the drilldown link.


Root Cause



A defect in Pegasystems’ code or rules.

The activity getContentWeekly was not setting the flags pyCanUseVirtualList and pyUseVirtualList to true, similar to the activity getContent.

Resolution



Apply HFix-33639.

Published April 13, 2017 - Updated May 4, 2017

Have a question? Get answers now.

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