Support Article

Error occurs when using Subtract, Addition, or Divide SQL query

SA-68627

Summary



Error occurs when using Subtract, Addition, or Divide as one of the select columns.




Error Messages



Error - (Code-Pega-List)** An error occured on generating the query for the report definition - null




Steps to Reproduce

  1. Create two subreports.
  2. Use Summarize (sum) in the both the subreports.
  3. Add the column of both the sub reports in main report.
  4. Use the Divide function for the column of subreport1 to column of sub report 2.
  5. Run the Main report definition.


Root Cause



Runtime value was not set for all function aliases that have a parameter with Join type as None (do not join rows).


Resolution



Apply HFix-48220.

 

Published November 21, 2018 — Updated January 12, 2019


Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.