Steps to Reproduce
1. Login to Clarity and Navigate to Advance Reporting
2. Take any report example Project Storyboard and choose more than 1000 projects as input control selected
3. Run the report
Expected Result: The report should be able to run successfully
Actual Result: The report gives an error in the popup below and if you copy the error in notepad and you will see the "Error Msg = ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498"
Release : 15.x
Component : CA PPM SAAS JASPERSOFT
This error ORA-01795 in oracle document notes that "ORA-01795 maximum number of expressions in a list is 1000" and in this case of choosing more than 1000 values in the input control is exhausting the limit.
Reduce the number of selected input control and ensure to be below 1000 and run the report.
Also we have a limit of 500 pages limit while running the report immediately and 1000 pages when running the report in scheduled mode. Jaspersoft is a reporting tool and shouldn't be used as data extraction purpose.