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

Document ID : KB000016321
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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. 

Answer:

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