Error Accessing Exclude Page Under System Health

[jmeetze]

On my FMC, I recently noticed an issue when I try to access the module exclusion web page under System > Health > Exclude.  When I click on the menu, I get the following error:

Error while fetching data
Details
{"errors":[{"instancePath":"/2/excludedModules/0/id","schemaPath":"#/definitions/ExcludedModuleInfo/properties/id/type","keyword":"type","params":{"type":"string"},"message":"must be string"},{"instancePath":"/6/excludedModules/3/id","schemaPath":"#/definitions/ExcludedModuleInfo/properties/id/type","keyword":"type","params":{"type":"string"},"message":"must be string"},{"instancePath":"/8/excludedModules/3/id","schemaPath":"#/definitions/ExcludedModuleInfo/properties/id/type","keyword":"type","params":{"type":"string"},"message":"must be string"}],"validation":true,"ajv":true}

I am running version 7.4.2.1 on my FMC.  I have been working with TAC for about 3 weeks now with no solution yet so figured I'd see if anyone else has come across this.  I'll upload a screenshot of the error as well.

Thanks in Advance.

[WjamesWilliams]

I have been having an issue with existing health alert exclusions not being excluded(after updating to 7.4.2.1), alerting on interfaces that are showing no traffic( some of our vlans at remote sites see little activity sometimes and i dont want them to be alerted on), i took the time today to look around in the system to see if there was something unchecked somewhere and came across this situation on my FMC2600 running 7.4.2.1 and found the exact message at FMC>Health>Exclude. has there been any resolution to this?

[jmeetze · Accepted solution]

Yes, I worked with TAC and found out I was hitting this bug: https://bst.cloudapps.cisco.com/bugsearch/bug/CSCwi30843

Keep in mind, this was the fix for me so I would err on the side of caution before running these commands and would recommend you open a TAC case just to confirm the bug I hit is the same for you. 

Basically, you have to SSH into your FMC and sudo to root then run the below commands.

root@FMC:/Volume/home/admin# OmniQuery.pl -db mdb

mdb.sfsnort>  delete from eostore where type='BlackListObject';

After that, the exclusion page should come back, but keep in mind you will need to recreate all of your exclusions.  Also, it takes some time for the exclusions page to come back so be patient.

Thanks,

Josh