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

I have the same question (0)

All responses (5)

Answers (0)

MC-07050738-0 1 on at

Like (0)

Report

Hi, hope you are doing fine.

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

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,780 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MC-07050738-0 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

HVGEEL 308 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ondix 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No