Error in logs is U00003592 UCUDB - Status: '' Native error: '1017' Msg: 'ORA-01017: invalid username/password; logon denied'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Sample Scenario:

The error is present in Automic utility log file after updating Automic Database Password:

U00003592 UCUDB - Status: '' Native error: '1017' Msg: 'ORA-01017: invalid username/password; logon denied'

 

Environment

Release : 12.0, 12.1, 12.2, 12.3

Component : AUTOMATION ENGINE, Utility

Cause

Configuration

Resolution

Resolution:

1. Verify the Connection String in all of the utilities corresponds to the connection string in the UCSrv.INI file (sqlDriverConnect =). 

2. If the connection string is correct in the Utilities, and your Database Maintenance was set up by Professional Services, you need to go into Database Maintenance workflow and check if there is a variable or login object that corresponds to the Connection to the database. For example, it can be a variable called VARA.DB_CONNECTION or VARA.DB.UTILITY (name can vary) that contains the connection string that must be edited in order for the workflow to run. Most of the time, the variable will be in the Process tab of the first job within the workflow. Check all the variables in the first job as you first step and verify the information further.