Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Error when importing E...
Finance forum
Unanswered

Error when importing Excel file in Data Management

Posted on by 27
Hello community,
 
When creating new import project in Data Management and selecting excel file we get an error:
 
System.MissingMethodException: Method not found: 'System.String[] Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Contract.ServiceContract.GetSheetNamesFromExcelV2(System.String, System.String)'. at Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntitySharedTypesProxy.<>c__DisplayClass33_...
 
The same when trying to import excel file with the existing projects. This happens for all data entities and only for one T1 environment. It has the latest 10.0.39 update, full build and sync was done, data entities were refreshed. Any ideas why we get this errors and what else could we do to fix it?
Categories:
  • CU08051555-0 Profile Picture
    CU08051555-0 27 on at
    Error when importing Excel file in Data Management
    Can you try please to create an export project in DMF to export the data (maybe 2 records) then import them again? So that we know if it's a data issue or not.
     
    No, not the data issue, I'm already using the file I've just exported. Also, I get this error when trying to add new data entity and uploading the file, system can't read excel file itself. It works for csv and it works on other devboxes with the same data
     
    Hi, can you confirm if the issue is due to some extensions.
     
    we have 3 T1 devboxes where it's working, also 2 T2 envs, so this is specifically for one CHE and it started happening recently.
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Error when importing Excel file in Data Management
    Hi, can you confirm if the issue is due to some extensions.
    I think you can debug the code to find the root cause.
  • Layan Jwei Profile Picture
    Layan Jwei 4,112 Super User on at
    Error when importing Excel file in Data Management
    Hi,
     
    Can you try please to create an export project in DMF to export the data (maybe 2 records) then import them again? So that we know if it's a data issue or not.
  • CU08051555-0 Profile Picture
    CU08051555-0 27 on at
    Error when importing Excel file in Data Management
    Thanks, but that service is running (
  • S Gopi Krishna Profile Picture
    S Gopi Krishna 259 on at
    Error when importing Excel file in Data Management
    Make sure that the below service is in 'running' state. I'm not sure if this will resolve your issue or not but you can give it a try.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,436 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,206 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans