cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Anywhere 17 .NET provider impacted by Carbon Black endpoint security

former_member260088
Discoverer

I have a product consisting of two ASP.NET web apps and one web service sitting on 32-bit SQL Anywhere 17.0.0.1359. It is deployed in a Windows environment at over a thousand customer sites and happily runs at the vast majority. Over the past six months or so, we have received a number of reports from customer sites saying they are seeing this exception thrown when attempting to access the web apps:

The type initializer for 'Sap.Data.SQLAnywhere.SAConnection' threw an exception.

It has also been observed in the log maintained by the web service.

Information of note:

- This issue is occurring solely at sites which have deployed Carbon Black endpoint security

- Once a web app or service throws this exception it will continue to do so on subsequent attempts to access it.

- If the system is left to itself, eventually both web apps and the web service will continually throw this exception

- The issue can be temporarily resolved by recycling the application pool the web apps and web service are assigned to

- If the "C:\Program Files (x86)\SQL Anywhere 17" folder tree is excluded from virus scanning, the issue does not occur

Has anyone experienced this issue and been able to resolve it without resorting to virus scan folder exclusions?

TIA

Accepted Solutions (0)

Answers (1)

Answers (1)

michael_loop
Contributor

It seems likely that you will need to use scanning exceptions, but if you look at the anti-virus log, you may be able to narrow down the offending file or directory so that you can exclude a minimum of items.

Also remember that excluding items from on-access scans does not prevent you from performing on-demand or scheduled scans.