Suddenly unable to login to Clarity on SQL server

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Suddenly the users cannot login to Clarity anymore (MSSQL only).
You already tried to reset the password by executing queries with no luck

In logs, it cannot insert the session on login:
 
ERROR 2019-03-12 16:15:52,999 [http-nio-80-exec-16] niku.security (clarity:unknown:none:security.loginAction) UserSessionCache.insertToPersistence:PMD error
com.niku.union.persistence.PersistenceException:
SQL error code: 3906
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Failed to update database "niku" because the database is read-only.
Executed:
{call CMN_ID_SP(?,?,?,?)}
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="unionPMD.xml" id="union.genID_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>{call CMN_ID_SP(?,?,?,?)}</text>
<param name="tableName" type="string" direction="IN" expressionListDelimiter=","/>
<param name="result" type="long" direction="OUT" expressionListDelimiter=","/>
<param name="size" type="long" direction="IN" expressionListDelimiter=","/>
<param name="sequenceName" type="string" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>
 

Environment

Release: Any

Resolution

• This issue has nothing to do with Clarity passwords
• This is a SQL server issue, and has to be addressed by DBA.
• Here is an example of possible solution (Microsoft SQL article): Failed to update database because the database is read-only