Error "Last acquisition attempt exception: java.sql.SQLException: Login failed for user 'ussdbadmin'" when starting Unified Self-Service (USS)

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The USS homepage is blank and never loads. The following error appears in liferay.year-mm-dd.log for USS when starting the USS services:

[email protected]c9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Login failed for user 'ussdbadmin'.

 

 

Environment

Service Desk Manager 14.1Unified Self-Service 14.1

Cause

The USSDBADMIN account password has been set without encryption in the portal-ext.properties file, but the jdbc.default.encrypted.password setting is set to true

Resolution

1.  Stop all Unified Self-Service (USS) services

2.  Go to USS install directory (by default, C:\Program Files\CA\Self Service\OSOP) and make a backup of the portal-ext.properties file

3.  Open portal-ext.properties with a text editor and locate the line for 'jdbc.default.encrypted.password=true' and set the value to false

(i.e. jdbc.default.encrypted.password=false)

4.  Save changes to the file.

5.  Restart the USS service