Get "Run-time error Persistence Units Component! Failed while reading a file" error when running an API program for erwin DM

Problem:

I am trying to run my API program and I get the error: "Run-time error  '-2147219490 (800407de)': Persistence Units Component! Failed while reading a file". What is it and how to remedy it?

 `

Solution:

When using erwin DM APi in a VBA using MS Excel, both erwin DM and MS Excel should either be either 32-bit or 64-bit.  This is most likely because of the incompatibility of the bit-size of erwin DM and MS Excel. You may be using a 32-bit MS Excel and need to register the 32-bit version of the erwin DLLs.

To discover if your copy of Excel is 32-bit go to File | Account | About Excel and the About window will show that detail at the top.

To resolve this problem, you can place a copy of a 32-bit erwin DM install on your PC and then register the DLLs from that directory.  

To register the DLLs, please right-click the shortcut for the DOS prompt and choose Run as Administrator.  That will open an elevated command window.  Then try registering the DLLs from the command line.  For example,

regsvr32.exe "D:\_erwinbuilds\erwin 9.8-32-bit\EAL.dll"

regsvr32.exe "D:\_erwinbuilds\erwin 9.8-32-bit\ERXML.dll"

Related Articles:

https://support.erwin.com/hc/en-us/articles/360015060972-How-to-use-API-using-erwin-DM-64-bit-and-Excel-32-bit-Is-it-possible-to-have-both-32-bit-and-64-bit-versions-of-erwin-DM-on-the-same-PC-