Skip to main content

Notifications

Dynamics 365 Community / Forums / Business Central forum / Configuration Package ...
Business Central forum
Suggested answer

Configuration Package Table Export Error

editSubscribe (1) ShareShare
ReportReport
Posted on by ondix 2
Hi,
 
I have two BC 21.3 instances on different databases and when I try to export table to excel from one it results in error:
A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.CreateSchemaFromOpenXmlUnknown failed with this message: The type of one or more arguments does not match the method's parameter type.
But when I try the same export from the second instance, it works. I tried to restart both instances so they have same DLLs loaded.
 
Error is thrown from codeunit 6223 /OpenXML Management/, line 391:
Schema := WrkbkWriter.CreateSchemaFromOpenXmlUnknown(OpenXmlUnknownElement);

I also checked that both files that variable StreamText are the same.
 
I am testing on configuration package with only one table 270.
 
Thank you for the help
 
Categories:
Integration with Teams, Excel, Outlook
  • ondix Profile Picture
    ondix 2 on at
    Configuration Package Table Export Error
    Hi,
     
    after I upgraded both databases to BC23.4, the problem is solved. I don`t know whether it was data-related (users could have possibly edited the records) or it was technical-related (version-specific). As far as I remember, I tried to export primary key field only with the same result, but I can`t reproduce it.
     
    Thank you for your replies.
    Best regards,
    ondix
  • Suggested answer
    HVGEEL Profile Picture
    HVGEEL 286 on at
    Configuration Package Table Export Error
    I agree that this sounds like a data-problem, not a technical issue.
     
    Have you tried triming down the output to the fields that are 100% necessary, because from what I read, you are simply dumping the table, without (a) a table filter or (b) excluding fields from the output.
     
    Obviously, that is not a fix for the technical issue, but is might point you to where the issue is coming from.
    Iterate exporting, excluding 'suspicious' fields one at the time.
     
    Tedious? I know.
    But sometimes that is all it takes.
  • MC-07050738-0 Profile Picture
    MC-07050738-0 1 on at
    Configuration Package Table Export Error
    Thanks for the idea, Kaspars!
     
    Unfortunately not the case. Setup of Excel is identical to yours and the issue is not reproducible in case I'm switching the database to demo one, so I would suggest that the problem is somewhere in the data.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,099 Super User on at
    Configuration Package Table Export Error
    Hi,
    could it be that You have a fresh Office installation, and user has selected to use OpenDocument format, instead of Open XML format? This can be chosen when Excel is first time opened after installation. 
    If so - try to go to Excel Options, under Save section change "Save files in this format" - to Excel Workbook.

    Solved: The Office Open XML Cannot Be Opened [Full Guide] - EaseUS

  • MC-07050738-0 Profile Picture
    MC-07050738-0 1 on at
    Configuration Package Table Export Error
    Hi, hope you are doing fine.
     
    Facing the same issue, have you found a fix for yours?

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans