EM log showing the error message - Error updating auth info : Expecting zero or one results.

book

Article ID: 16321

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER INTROSCOPE

Issue/Introduction



IntroscopeEnterpriseManager.log shows the following error after uninstalled HotFix :

[ERROR] [PO:main Mailman n] [Manager.AppMap] Error updating auth info : Expecting zero or one results. 

Environment

Release:
Component: APMISP

Resolution

This message indicates that ACA tables are corrupted. Please delete all rows in aca_* tables.

e.g.
# /opt/PostgreSQL-9.2.15/bin/psql -d cemdb -U admin

cemdb=> delete from aca_acl;
cemdb=> delete from aca_audit;
cemdb=> delete from aca_group;
cemdb=> delete from aca_user;
cemdb=> delete from aca_user_group;
cemdb=> \q