Invalid User ID or password when connecting to OData

Products

• Clarity PPM SaaS

Issue/Introduction

We are getting an error when trying to connect to PROD DWH via ODATA connection. 

Error reads Invalid User ID or password.

Cause

The ODATA service limit is 10,000 entities per page.  if an implementation doesn't pass the $top parameter then will experience the error

Environment

Release : 16.0.1

Component :CLARITY

Resolution

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.

(Example) 

https://cppmxxxx.ondemand.ca.com/api/odata4/xxxxxxpdatasourceV4/DWH_INV_TASK?$top=10000&$skip=10000