What the use of CLSEpicor.dll
I think youâll have to provide a lot more context to motivate anyone to answer that
after upgrade SQL Server 2016 to 2017 reports not working due to below errors
Failed to load expression host assembly. Details: Could not load file or assembly âCLSEpicor, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullâ or one of its dependencies. The system cannot find the file specified.
Searching the forum for âCLSEpicor.dllâ turns up several posts, including this one:
that post is about VS editor. For SSRS it should be in Report Server folder, in my case it is in âC:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\binâ
So Epicor has a couple of custom DLLâs that they use to turn numbers into words (for checks among other things)
These DLLâs are installed in your
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
When you first deploy epicor and this DLL is one of those.
Do you think that redploying the Report Service in the Admin Console would take care of this?
Yes re-deploying should, I would check the Import Reports when you do just make sure you have good SSRS backups and make sure the account you are deploying with has full rights to
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
or if using a separate SQL DB
\\remote\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
Thanks, Issue resolved
There are two files CLSEPicor.dll and EpiNum2Words.dll
If you are trying to install the app server with a scale out deployment, or even just HA, then these files need to be on each SSRS install.