ClosedXml.dll is not working in Aras12Sp22

Hello All,

To perform excel file operations I'm using ClosedXML.dll file. It is working fine in Aras12SP9 but same dll is not working Aras12Sp22.

I'm getting below error

Could not load file or assembly 'System.IO.Packaging, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.

Regards,

Suhas

  • Hi Suhas,

    happy new year! You probably already solved the issue, but I want to answer anyway. The problem can be solved by adding a assembly binding in one of the web.config files.

    Angela

  • Hello Angelalp,

    In which web.config i need to add assembly binding? & how to add it? 

    Regards,

    Suhas

  • Hi Suhas,

    I probably  was wrong. Your PublicKeyToken doesn´t match the error message you typically get when assembly binding is missing.

    You have to add assembly binding in Innovator/Server/web.config when you use DLLs that use the IOM.dll. This file is typically overwritten when using a update patch. But your dll doesn´t use IOM.dll.

    How did you add your dll? Have you modified method-config.xml?

    Edit: Do you have a backup of you previous codetree? Maybe check if the various web.config already contains something for the dll.

  • Hello ,

    I didn't modified any aras dll (IOM.dll) or web.config file. Just I have added closedxml.dll file in bin folder & added namespaces in  method config file with file path.(How we are using external ddl in aras in same way). Same dll is working for Aras12SP9. 

    The major difference which I noticed is in Aras12SP9 "WindowsBase.dll" is present in server bin folder whereas in Aras12SP22 it is missing. I have copied the same dll in bin folder but then also it is not working.

    Regards,

    Suhas

  • Hi Suhas,

    what release is 12SP22? I thought the last 12 version was SP18? Is this one of the 14+ versions?

    I compared my 12SP7 codetree to Release 2023. Especially Server/web.config and method-config.xml. These files have changed completely and are reduced in size. 

    You error message references to System.IO.Packaging . Maybe Aras removed this one in your version or it´s due to a .NET Core change?

    I will soon do some similar DLL testing with Release 2023. But I still need some time.

    Don´t you have the possibility to ask Aras support?

    Angela

  • Hello AngelaIp,

    I'm using Aras "Release 22 Build 14.0.8.35675" build. And in this version server/web.config file is changed. 

    Regards,

    Suhas

  • Hello and

    I did some comparison between the 2 versions and here are some points which might help you proceed.

    1. In Old Version 12SP9 WindwosBase.dll is available on Innovator/Server/bin folder and it corresponds to .NetFramework you can check the properties. Whereas in new version after 14 the file WindwosBase.dll is moved to Innovator/Server/bin/refs and it corresponds to .NetCore.

    2. I also see there is an update in ClosedXML.dll of version of System.IO.Packaging. Please refer Upgrade minimum required version of System.IO.Packaging dependency du… · ClosedXML/ClosedXML@ba68e7e (github.com)

    May be using the latest version of ClosedXML compatible with .NetCore help. Let me know if this works. Thanks in advance


  • Hello  ,

    I have tried latest version of ClosedXML, but still it is not working.  

    Regards,

    Suhas

  • Do you see the error message in the Method editor or does it appear as popup dialog when you execute your application / trigger the DLL?

    I tested one DLL that I use for generating Excel exports in Releae 2023. I didn´t test the full application cause it´s not fully imported yet, but I added the dlls to the bin folder and modified method-config.xml. After this changes the Method editor was fine with the Method and didn´t thrown any debugging error message.

  • Hello

    While executing method Aras is throwing exception. Method is compiling without any error. 

    Regards,

    Suhas