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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Data Import Error usi...
Customer experience | Sales, Customer Insights,...
Unanswered

Data Import Error using downloaded data template - Error Code 2147187704

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

I am using "Template for Data Import"  option to import data into the Incident table.

When I upload the Excel file sing the data import, I get the error "State code is invalid or state code is valid but status code is invalid for a specified state code"..

And under further information the message is " 5 is not a valid status code for state code for IncidentState.Active"

I am not sure, how to troubleshoot this error?

I would greatly appreciate some guidance.

Thank you.

David

I have the same question (0)
  • TD-28081737-0 Profile Picture
    TD-28081737-0 Microsoft Employee on at

    Hi David,

    Hope you are doing well.  Have you had any previous issues with importing new records into this table?  

    Are you aware of any workflows/plug-ins/business rules that exist for a new incident?

    It may be a good first step to check in on any that apply to this entity that could be triggered and may have some additional field requirements.  

    One other path to verify is to possibly create a test incident record and then export that record via the excel export process.  Make a slight change or no change at all and then attempt reimport that file to see if it executes without error.  That way you know you aren't having an issue with the import process itself and it may be more related to something that is executing when the entity record is created.

    Hopefully this helps.  I will keep an eye out for any updates on this issue.

    Thanks David and have a happy New Year!

    TD

  • Jameswick Profile Picture
    Jameswick 55 on at

    And usually, this happens when you try to import an excel file that has been previously exported as ready for import. Below is a sample file that has been previously exported in that format. If you open the file and expand the columns A, B & C, you shall see the record GUID and checksum.

    And when you use the same format and try to import it again, if any of the records does not exist in CRM, you will get that error.

    How can you get rid of this error? You can save the file as .csv format and delete columns A, B & C. And then change the column values and try to import. Everything should work fine.

    Regards,

    J Wick

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 202 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans