Sage 200 Native API not returning companies

Sage 200 Native API not returning companies

Summary

When calling upon the API, no companies are returned, and this means that no information can be retrieved. This has been seen following upgrades of Sicon products to the following versions (not exclusive list):

·       Sicon Intercompany V221.0.42

·       Sicon Manufacturing 221.0.71

·       Sicon Documents V221.0.71

 

Observed Errors:

The following errors can be observed throughout the Sage200NativeAPI Logs - C:\inetpub\Sage 200 App Services\Sage200NativeAPI\Log\WebAPI.log:

Sage.MMSAdmin.AddOnManagement.Common.AddOnSynchroniser System.IO.IOException: The process cannot access the file 'C:\inetpub\Sage 200 App Services\Sage200NativeAPI\AddOns\Sage\Sage200\AssemblyCache\’*’ because it is being used by another process.

 
DLLs mentioned to be inaccessible when calling API:

·       Sicon.Sage200.DMS.DAL.dll

·       Sicon.Sage200.Intercompany.WebAPI.dll

·       Sicon.Sage200.Architecture.DAL.dll


Resolution

1.       Stop IIS (‘IISRESET /Stop)

2.       Rename "C:\inetpub\Sage 200 App Services\Sage200NativeAPI\AddOns"

3.       Start IIS (‘IISRESET /Start)

4.       Call API via query – this will then cause the IIS worker to rebuild its assembly caches.