ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 4717


Updated On:


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


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'.




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


Service Desk Manager 14.1Unified Self-Service 14.1


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 file

3.  Open 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