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
Article ID: 238507
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
Feedback
Yes
No
Powered by
