Some Users Unable to Login After an Upgrade

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrade, various users are getting error in the UI after login:

Error 501- Not Implemented. The server does not support the requested feature. Contact your system administrator.

or HTTP 500 and unable to login

Errors in app-ca.logs: 

WARN  2022-02-25 11:53:34,612 [https-jsse-nio2-8143-exec-3] web.WebActionController (clarity:<user>none:npt.overview) User <user> may exist in SSO but is not defined in the application.
com.niku.union.security.SecurityException: Database error while inserting user session
 at com.niku.security.cache.UserSessionCache.insertToPersistence(UserSessionCache.java:345)

ERROR 2022-02-25 11:53:34,612 [https-jsse-nio2-8143-exec-3] niku.security (clarity:<user>:none:npt.overview) UserSessionCache.insertToPersistence:PMD error
com.niku.union.persistence.PersistenceException: 
SQL error code: 1403
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "CLARITY.CMN_SESSIONS_INS_ID_SP2", line 14
ORA-06512: at line 1

The issue may be only via SSO and not be present in Incognito mode

Resolution

Clear the Clarity Server cache

1. Log in to Clarity application as an admin user
2. Modify the URL field to: https://<server>/niku/nu#action:security.caches
3. From the Caches tab, Select all by clicking the Select All button
4. Click the Flush All button
5. Log out & Log in back in