Troubleshooting Tip: CMDB 'EntityNotFoundException' error
Description
This article provides a method to fix the CMDB 'EntityNotFoundException' error.
Scope
FortiSIEM.
Solution
The 'EntityNotFoundException' error is common in FortiSIEM when part of the configuration is missing in the database.

If users are trying to edit users in the CMDB and encounter the error above, it can be verified below:
# psql -U phoenix phoenixdb -c "select * from ph_user where id=xxx;"
# psql -U phoenix phoenixdb -c "select * from ph_user where manager_id=xxx;"
Normally, this error occurs because the Manager is configured for the users, and the Manager users are removed from FortiSIEM CMDB.
In that case, users can resolve it by removing the configuration from the backend:
# psql phoenixdb phoenix -c "update ph_user set manager_id=NULL where manager_id=xxx;"