Increase The ODATA service limit from 10,000

Products

• Support Offerings

Issue/Introduction

Can we increase the ODATA service limit from 10k.

 

 

Environment

Release : SAAS

Component :CLARITY

Resolution

The ODATA service limit is 10,000 entities per page. With SSIS, if an implementation doesn't pass the $top parameter, the same error may occur. So, it is best to use pagination to remain within the 10,000-record limit. CA Support observed this issue with SSIS; however, the 10,000-entity pagination limit also applies when attempting to automate with other BI tools.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/16-0-0/administration/configure-the-data-warehouse-and-advanced-reporting/configure-odata-access-to-the-data-warehouse.html