connect 2022 banner tablet connect 2022 banner mobile

Analyzing Error 412 when Exporting to Data Lake in Dynamics 365 Finance and Operations

By Justin Thain | September 7, 2022

The Export to Data Lake feature is a great way for you to copy data from your Dynamics 365 Finance and Operations environment into your own data lake.

Before you can use this feature, though, you have to install it using the instructions for the Azure Data Lake add-in.

To use this feature, go to System Administration > Setup > Export to Data Lake in your environment.

You can select tables or data entities to export to your own data lake. Data entities are a higher-level abstraction of data if you are not sure exactly what tables you need. On the Export to Data Lake form, select the tables or data entities that should be staged in the data lake and then select Add Tables.

If you are exporting tables with more than 1,000,000 rows, you may receive error code 412 (Error(StatusCode:412)).

Picture1

Microsoft has documented the error code 412:

Picture3

The RecID index must contain the RecID, DataAreald, and Partition fields.

Picture2

Only add the index for tables that produce the 412 error (Error(StatusCode:412)). Creating unnecessary indexes will slow down your user's experience as it must be maintained on insert, update, and delete.

To test the index, you will need to promote your changes to the Tier-2 environment.

Questions?

We have a team of experts ready to assist you! Please contact us if you have any questions about this.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X