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.

Users with access granted through OBS units cannot login

book

Article ID: 241585

calendar_today

Updated On:

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).

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

Environment

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

Resolution

A better execution plan was baselined to resolve the issue.