Small and medium business | Business Central, N...

Configuration Package Table Export Error

(1) Share

Report

Posted on by ondix

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:

Dynamics 365 Business Central

All responses (5)

Answers (0)

ondix 2 on at

Like (0)

Report

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 288 on at

Like (0)

Report

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 1 on at

Like (0)

Report

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 4,192 Super User 2025 Season 1 on at

Like (0)

Report

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.
MC-07050738-0 1 on at

Like (0)

Report

Configuration Package Table Export Error

Hi, hope you are doing fine.

Facing the same issue, have you found a fix for yours?