ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Invalid User ID or password when connecting to OData

book

Article ID: 238507

calendar_today

Updated On:

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