Permissions and SQL Errors
If Genie cannot read your FileMaker schema, it usually involves missing extended privileges.
Error 825: Metadata Retrieval Failing
Section titled “Error 825: Metadata Retrieval Failing”- Symptoms:
Could not fetch tables,FileMaker SQL - Error 825(), or the Metadata Explorer is empty. - Cause: The current FileMaker user’s privilege set does not have the fmplugin extended privilege enabled. Genie requires this permission so the Genie plugin can safely query your solution’s structure and data.
How to Fix Error 825
Section titled “How to Fix Error 825”To resolve this, follow these steps in your FileMaker Pro file:
- Go to File > Manage > Security…
- Click on the Advanced Settings… button.
- Select the Extended Privileges tab.
- Scroll down to find the keyword fmplugin. Click to edit.
- In the Privilege Sets list, check the box next to your current privilege set (usually [Full Access]).
- Click OK to save all changes.
- Close and re-open Genie to refresh the connection.
Visual Guide
Section titled “Visual Guide”Step 1: Open Security Management
Step 2: Find Extended Privileges
Step 3: Enable fmplugin
Step 4: Assign to your Privilege Set
