Users with access granted through OBS units cannot login

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

It has been noticed that users that have access granted through OBS units that have many child nodes within them, cannot login to the application. This is being noticed after an upgrade to version 15.9.3 (Patch 3).

Environment

• Version: 15.9.3 (Patch 3)
• DB: Oracle

Cause

The DB was picking a bad execution plan when running the following statement. This is one of many SQL queries that are run against the DB by the application to check the access rights of the user attempting to login.

SELECT COUNT(1)
FROM CMN_SEC_CHK_USER_V0
WHERE USER_ID = :B3
 AND OBJECT_ID = :B2
 AND PERMISSION_CODE = :B1
 AND ROWNUM = 1

Resolution

A better execution plan was baselined to resolve the issue.