Deleted symptom still triggers after creating new Symptoms with same conditional property and a different name.
Validated deleted symptoms were not present in active Policy as well as showing deleted in Aria Operations vpostgres database. Connect to DB with following command.
su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433
Run following query to validate the deletion of Symptom definition, where SYMPTOM_NAME should be replaced with actual symptom name.
select col__kv_strvalue,status from kv_symptomproblemdefinition where col__kv_strvalue like '%SYMPTOM_NAME%';
Environment
Aria Operations 8.18.x
Cause
Cache issue in Aria Operations causing deleted Symptoms to trigger.