High TempDB Usage when accessing Links tab in CIT having Categories by Non Admin users

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Links tab in CIT having Categories when accessed by Non Admin users (rights provided through OBS/Instance) causing High DB usage.

STEPS TO REPRODUCE
1. Login to 16.2.0 Clarity machine 
2. Create a Custom Investment 
3. Create a user and provide OBS access to this user to the CIT created in Step 2
4. In the Blueprint, configure the CIT to use Links tab and Categories in it. 
5. Create an instance of the CIT under the OBS which the Non admin user has access to.
6. Navigate to the Links tab and create new categories (may be a couple of them atleast)
7. Login as the Non admin user created in Step 3
8. Navigate to the CIT instance and click on Links tab

Expected: The Links tab opens up quickly and shows the Categories created in Step 6
Actual: The Links tab does not load completely the query which runs at the backend consumes enormous amount of Temp DB

Workaround: Grant global access to the users

Resolution

DE79452 - Fixed in 16.2.1, 16.2.0.1.1