Symptoms
The following error appears in the EUM-processor log, or while querying the accounts table from the EUM database schema.
Failed to query account table: java.sql.SQLException: Can't find file: './eum_db/accounts.frm' (errno: 13)
Diagnosis
The "Accounts.frm" file is missing or does not have the correct user permissions. The file is located at <Controller_Home>/db/data/eum_db/accounts.frm.
Solution
If the file is located in the proper path, the problem is a permissions issue.
To resolve the error, enter the following command in the terminal for the Controller host to change the ownership of the file to the correct user and group. For example, the user/group through which the Controller was installed.
Then restart the EUM-processor to resolve the issue.
chown -R <user>:<group> /AppD4214/Controller/db/
Example:
chown -R appdyn:appdyn <Controller_Home>/db/
If the file is missing, contact AppDynamics support for further troubleshooting, as it could be caused by database corruption.
