Suddenly unable to login to Clarity on SQL server

book

Article ID: 130114

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Suddenly the users cannot login to Clarity anymore.
We already tried to reset the password by executing queries with no luck.


Reviewing the logs:
It could not 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:
Component: GROUPS

Resolution

This is not to do with the passwords at all.
 
This is a SQL server issue, and has to be addressed by DBA. Here is an example of possible solution:
 
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3a886763-82d0-43b0-b804-24ca1ee44ed1/failed-to-update-database-because-the-database-is-readonly?forum=sqlexpress