web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data import error: Exc...
Finance | Project Operations, Human Resources, ...
Unanswered

Data import error: Exception from HRESULT: 0xC020801C

(0) ShareShare
ReportReport
Posted on by Gian Paolo Dell Erba 210

Hello folks,

I'm dealing with a data import error which returns an error code I do not understand (I looked here and there but can't understand what might be the cause): HRESULT: 0xC020801C. A little summary:

  • Business scenario: recurring integration. File is enqueued in D365 by a middleware bus
  • Data entity = Inventory movement journal headers and lines V3
  • File format = EXCEL

I'm sure mapping is not the cause since attribute lists (data project & incoming file) match perfectly. What could it be? Has it ever happened to you?

Thank you for your help

Gian Paolo

I have the same question (0)
  • zhifeng Profile Picture
    zhifeng on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    Hello Gian,

    0xC020801C is a very generic error, can you please refer below steps to review execution/staging logs and share detailed logs? To narrow down the issue, if we manually create import project from F&O and import with same file did we see same exception? 

    docs.microsoft.com/.../data-entities-data-packages

    Import process troubleshooting

    When uploading data entity files:

    • If data entities do not display in Selected files and entities after you click Upload during the import process, wait a few minutes, and then check whether the OLEDB driver is still installed. If not, then reinstall the OLEDB driver. The driver is Microsoft Access Database Engine 2010 Redistributable – AccessDatabaseEngine_x64.exe.
    • If data entities display in Selected Files and Entities with a warning after you click Upload during the import process, verify and fix the mapping of individual data entities by clicking View map. Update the mapping and click Save for each data entity.

    During data entity import:

    • If data entities fail (shown with a red X or yellow triangle icon on the data entity tile) after you click Import, click View staging data on each tile under the Execution summary page to review the errors. Sort and scroll through the records with Transfer status = Error to display the errors in the Message section. Download the staging table. Fix a record (or all records) directly in staging by clicking Edit, Validate all, and Copy data to target, or fix the import file (not staging file) and reimport the data.
    • If data entities fail (shown with a red x or yellow triangle icon on the data entity tile) after you click Import, and View staging data shows no data, go back to the Execution summary page. Go to View execution log, select the data entity, and review the Log text, Staging log details, and Infolog for more information. Staging log details will display Error column (field) details and Log description will describe errors in detail.
    • If data entities fail, you can check the import file to see if there's an extra line in the file with text which displays, "This is a string that is inserted into Excel as a dummy cell to make the column to support more than 255 characters. By default, an Excel destination component will not support more than 255 characters. The default type of Excel will be set based on the first few rows". This line is added during data export. If this line exists, delete this line, re-package the data entity, and try to import.

  • Gian Paolo Dell Erba Profile Picture
    Gian Paolo Dell Erba 210 on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    Hi Kevin,

    We are facing the scenario where "View staging data" shows no data at all, so the files are rejected entirely. If we try to import them manually then they get imported with no problem at all.

    Gian Paolo

  • zhifeng Profile Picture
    zhifeng on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    Hello Gian,

    What about View execution log, does it give us more details?

  • Gian Paolo Dell Erba Profile Picture
    Gian Paolo Dell Erba 210 on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    No details. Here's a screeshot (sorry it's in Italian):

    04_2D00_05_2D00_2021-10_2D00_17_2D00_28.png

  • AnithaEswaran Profile Picture
    AnithaEswaran 2,032 on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    You can try this.

    1) First Export in the same format for one of the records. Then try importing the same file with your changes.

    This helps you to cross-verify both the import files.

  • Dean Stegmiller Profile Picture
    Dean Stegmiller on at
    RE: Data import error: Exception from HRESULT: 0xC020801C

    You could look at opening a case with support as there might be more details within the telemetry data that is captured.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,177

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 860 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans