search cancel

Suddenly unable to login to Clarity on SQL server

book

Article ID: 130114

calendar_today

Updated On:

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