Unable to login to WebView with AD users

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

Unable to login using AD/LDAP users.  The IntroscopeEnterpriseManager.log shows this error

ERROR: insert or update on table "aca_user_group" violates foreign key constraint "aca_user_group_group_id"

Environment

APM 10.8

Resolution

ACA cache got corrupted, need to delete the data from the APM DB tables and allow EM to reload it.

Do the following...

1) Make a backup of the APM DB

2) Stop EM and WV

3) Run this

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

NOTE: The -d option is for the name of the DB being used which can be found in the tess-db-cfg.xml

Example:  <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/wilydb</property>

So the name of the DB is wilydb

The -U option is for the name of the user which can also be found in the tess-db-cfg.xml

<property name="hibernate.connection.username">admin</property>