Question
TCS
GB
Last activity: 14 Jun 2021 7:38 EDT
PxCheckFlowDependencies
While resolving case using a local action using pxForceCaseClose, it's calling pxcheckflowdependencies. This pega ootb contains a Java step in step 6 which is framing an SQL query. The sql contains syntax errors. Attached the screenshots for the same. It's failing due to SQL error in pega 7.3.1
Activity Name: pxCheckFlowDependencies
Class: work-
Version: Pega-ProcessEngine:07-10-31
Is there any other ways to resove and close the open assignment in worklist for time being.
***Edited by Moderator Marissa to update Platform Capability tags****
Pegasystems Inc.
US
HFix-39248 for Pega 7.3.1 makes a change to the where clause.
Snippet from step 6 of pxCheckFlowDependencies in Pega-ProcessEngine:07-10-34
if (pyAccessGroupExposed) { preparedQuery += " , pyAccessGroup as \"pyAccessGroup\" "; }
if(strDepStatus != "" && strDepStatus.startsWith("Resolved-")) { preparedQuery += " from {Class:Index-AssignmentDeps}" + " where pyDependencyClass = {" + tools.getParamValue("DependencyList") + ".pyPreparedValues(1)} " + " AND pyDependencyStatus IN ("+strDepStatus+ ",'Resolved-%')"+ " AND pyWorkObjectInsKey IN ("+tools.getParamValue("ListofInskeys")+")"; } else { preparedQuery += " from {Class:Index-AssignmentDeps}" + " where pyDependencyClass = {" + tools.getParamValue("DependencyList") + ".pyPreparedValues(1)} " + " AND pyDependencyStatus IN ("+strDepStatus+")" + " AND pyWorkObjectInsKey IN ("+tools.getParamValue("ListofInskeys")+")"; }
Pegasystems Inc.
US
if (pyAccessGroupExposed) {
preparedQuery += " , pyAccessGroup as \"pyAccessGroup\" ";
}
if(strDepStatus != "" && strDepStatus.startsWith("Resolved-")) {
preparedQuery += " from {Class:Index-AssignmentDeps}" +
" where pyDependencyClass = {" + tools.getParamValue("DependencyList") + ".pyPreparedValues(1)} " +
" AND pyDependencyStatus IN ("+strDepStatus+ ",'Resolved-%')"+
" AND pyWorkObjectInsKey IN ("+tools.getParamValue("ListofInskeys")+")";
}
else {
preparedQuery += " from {Class:Index-AssignmentDeps}" +
" where pyDependencyClass = {" + tools.getParamValue("DependencyList") + ".pyPreparedValues(1)} " +
" AND pyDependencyStatus IN ("+strDepStatus+")" +
" AND pyWorkObjectInsKey IN ("+tools.getParamValue("ListofInskeys")+")";
}
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
You can use tickets to achieve this, set the ticket on the end shape of the flow, and in the post-processing of the flow action you can use "setTicket" OOTB activity and pass the ticket name as parameter. This will also close all the open assignments and resolve the case,