User with Favorites with more than one section will have dbOdataAccess set to false

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Using OData and found that user with more than one section in Favorites will return "dbOdataAccess": "false" in the API GET call on authorize

STEPS TO REPRODUCE

1. Connect to Clarity with API tool
2. Run the below request on any user who has OData Access permission (i.e. any admin user with all rights), use Basic Auth  

http://<localhost>/ppm/rest/v1/auth/authorize

3. Note the response:

{

    "_self": "http://<localhost>/ppm/rest/v1/auth/authorize",

    "dbOdataAccess": "true"

}

4. Now connect to Clarity with this user
5. Go to Favorites – Configure
6. Click Add – Section - Next
7. Add any Name and ID, Save
8. Now repeat the same API request

Expected Results: dbOdataAccess to remain “true”

Actual Results: Resulting response is with dbOdataAccess = false

{

    "_self": "http://<localhost>/ppm/rest/v1/auth/authorize",

    "dbOdataAccess": "false"

}

A user with multiple sections in Favorites cannot connect with OData, and note there are no links under that section

Environment

Clarity 16.3.3, 16.4.0

Cause

DE181190

Resolution

Fixed in Clarity 16.4.2

Workaround: 

1. Move all links if any to My Links
2. Delete any extra sections in Favorites 

or 

Use a dedicated OData user without custom sections in Favorites