Not Able to Access GCP/SaaS Environment

Products

• Clarity PPM SaaS

Issue/Introduction

We are not able to access the environment after login.

There is no error message, just a blank page.

The APP shows:

ERROR 2023-04-24 15:05:34,690 [http-nio-8080-exec-82] niku.security (clarity:admin:-1:none) UserSessionCache.insertToPersistence:PMD error
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: duplicate key value violates unique constraint "cmn_session_attrs_u2"
  Detail: Key (auth_source_identifier)=(idxxxxxxxxxxxxxxxxx) already exists.
  Where: SQL statement "INSERT INTO CMN_SESSION_ATTRS(  SESSION_ID,
                AUTH_SOURCE_IDENTIFIER
                )
    VALUES ( P_ID,
              p_auth_source
             )"
PL/pgSQL function cmn_sessions_ins_id_sp2(bigint,text,text,bigint,text,text) line 30 at SQL statement
Executed:
call CMN_SESSIONS_INS_ID_SP2(?,?,?,?,?,?)

Environment

Release : 16.1.1

Resolution

Please open a case to have Support check if there is any blocking database queries blocking login sessions from being created.