Support Article
There was a problem getting a list: code: 909 SQLState
SA-25556
Summary
Out-of-the-box CPM reports CPMThroughputByResolveOpByYear have pxBalance function used in columns and Summarize column value as Count. These reports cannot be saved in a different class.
Error Messages
There was a problem getting a list: code: 909 SQLState: 42000 Message: ORA-00909: invalid number of arguments
Steps to Reproduce
- Log into Designer Studio with administrative privileges and open a report definition CPMThroughputByResolveOpByYear/Month/Day.
- Run the report without any modification and with the tracer on. It should run fine without error.
- Copy the same Report Definition rule to another class and save.
Root Cause
There was a defect with out-of-the-box rules when trying to save in different class other than PegaCA-work class using Save As.
Resolution
Apply HFix-28205.
Published July 16, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.