OData Credentials failing with Invalid User ID or Password error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Errors / Issues that may be seen when not being able to connect to OData:

• Invalid user ID or password:
  
  <error>
    <code>222206007</code>
    <message lang="en-US">Invalid user ID or password.</message>
  </error>

• We couldn’t authenticate with the credentials provided. Please try again.

• The WWW=Authenticate header doesn’t contain a valid authorization URI. Header value: ‘Basic realm=”DataDirect Cloud ODATA API”’.
• Refresh OData Model job fails with error: Unable to connect to OData Service Server due to invalid credentials.
• When connecting to odata from browser: No data shown, see a blank page 

Environment

• SaaS/On Demand environments
• Release: All Supported Releases
• Component: OData

Cause

This can happen if a second instance of the Refresh OData Model Job is kicked off while one is running. Additional preventive measures:

• The Refresh OData Model job should only be run after any new objects / attributes are created and included in the DWH.
• After the object / attributes are created and included in the DWH, run the full load DWH job once, followed by the Load DWH Access Rights job, and then followed by the Refresh OData Model Job.
• Ensure that when the full load DWH is running that your automation scripts that consume the API are not actually consuming while this job is in motion. 
• When a database is refreshed and the source instance did not had the ODATA but destination had it. Example Test is getting refreshed with production and production did not had ODATA and Test has ODATA

Resolution

Please contact Broadcom support for assistance with below step:

• De-register and then re-register OData service.

Check also KB: OData Error "Invalid user Id or Password" prior to opening a case in case this is an issue with the user that needs updating. 

Additional Information

Note:

If getting the below error:

DataSource.Error: OData: Request failed: The remote server returned an error: (400) Bad Request. (The query is invalid. For more details, contact your administrator.)

Details:

    DataSourceKind=OData

Resolution: 

• De-register and then re-register OData service.