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.

Environment

Release : 16.0.1

Component :CLARITY

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

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://<servername>.ondemand.ca.com/api/odata4/xxxxxxpdatasourceV4/DWH_INV_TASK?$top=10000&$skip=10000