Clarity: In Advance Reporting selecting more than 1000 values in input controls results in error in oracle
search cancel

Clarity: In Advance Reporting selecting more than 1000 values in input controls results in error in oracle

book

Article ID: 142337

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

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"

 

Environment

Release : 15.x

Component : CA PPM SAAS JASPERSOFT

Cause

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. 

Resolution

Reduce the number of selected input control and ensure to be below 1000 and run the report. 

Additional Information

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.