After admin user account is unlocked, the Data Aggregator (DA) status still shows red and DA based views show no data

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The admin user account was locked after logins or rest calls with an incorrect password were made.

The admin user was unlocked using SsoConfig on the Netops Portal but the Data Aggregator (DA) /Data Collector (DC) /Data Repository (DR)
status still shows red on the System Status page and all Data Aggregator based views show no data.

Rest calls to the Data Aggregator rest endpoints such as https://<DA>:8582/rest fail with a 403 error.

Environment

Dx NetOps Performance Management 21.2.1

Cause

Defect: DE509351

Resolution

Defect DE509351 has been submitted for this issue.

At this time there is a workaround.

After enabling the admin user using SsoConfig:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/21-2/administrating/manage-roles-and-user-accounts/enable-disabled-users.html

1. On the Netops Portal run:

mysql -unetqos -p netqosportal -e "update user_definitions set updatedon=UNIX_TIMESTAMP(sysdate()) where name='admin';"

Enter the mysql password when prompted.

2. Wait for the next normal Data Aggregator sync to complete.

After the sync, the Data Aggregator rest endpoints should be available as the admin user using the correct admin user password and functionality restored.