Forum Discussion

Karen_Mendez2's avatar
Karen_Mendez2
Frequent Visitor
1 year ago
Solved

FnO-812: Need to enable additional

Hi, We are experiencing the following error in our Azure Synapse Link for Dataverse:   FnO-812: Need to enable additional indexes in your Finance and Operations environment. Visit aka.ms/SynapseLi...
  • v-sgandrathi's avatar
    1 year ago

    Hi Karen_Mendez2,
    Thank you for using Microsoft Fabric Community Forum!

    Firstly:

    The FnO-812 error means that the required indexes for Azure Synapse Link are not enabled in your Finance and Operations (FnO) environment. These indexes are essential for efficient and reliable data extraction from FnO tables to Synapse. This error usually happens if the necessary indexes for certain tables haven’t been created or enabled, or if changes like a database refresh or reset have removed or disabled them.

    For the second one:
    Yes, a recent database refresh or restore in the UAT environment can remove custom or system-generated indexes needed by Synapse Link. These actions may also reset configurations that had previously enabled those indexes, which is a common reason for the FnO-812 error after environment refreshes.

    To fix the error, please follow these steps: Go to the Microsoft troubleshooting guide at:
    Azure Synapse Link for Dataverse trouble shooting guide - Power Apps | Microsoft Learn
    Next:

    Usually, this means running the "Enable Entity Indexes for Synapse Link" batch job in your Finance and Operations (FnO) environment. Go to System Administration > Setup > Azure Synapse Link > Enable Entity Indexes. Here, you can pick the tables or entities to re-index, or select all. After making your selection, run the job to recreate the necessary indexes. This will help restore the indexing structure for smooth data synchronization with Synapse.
    After re-indexing, check your Azure Synapse Link configuration in the Power Platform Admin Center to confirm that the tables are syncing properly and the required indexes are in place.
    Lastly:
    To prevent the FnO-812 error during future environment refreshes, it is advisable to document and re-run the "Enable Entity Indexes" batch job immediately after each database refresh. Where possible, automating this step as part of your post-refresh process can further reduce risk. Including this activity as a standard item in your UAT or Development environment refresh documentation is also recommended. Additionally, keeping an up-to-date list of entities connected to Synapse will make it easier to re-index them after any data restoration, supporting ongoing stability in your Synapse Link integration.

    I hope this helped! Feel free to ask any further questions
    Thank you.