VERIFIED SOLUTION i
X

Spectrum SQL Server table error

Issue

The following error was presented using Spectrum Spatial stages in a dataflow, to read and write from a SQL table:

SQLServerException: MyTable-Find Nearest threw StageException: java.lang.RuntimeException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not open system assembly ''C:\Windows\assembly\GAC_MSIL\microsoft.sqlserver.types\12.0.0.0__89845dcd8080cc91\microsoft.sqlserver.types.dll'': 32(The process cannot access the file because it is being used by another process.). 

Cause

As per Microsoft: 
"When you run queries in Microsoft SQL Server 2012 or SQL Server 2014, the queries may intermittently fail with a SHARING VIOLATION error on the CLR assembly Microsoft.SqlServer.Types.dll. Additionally, the following error message is logged in SQL Server Error log:
Error 6518, Severity 16, State 2
Could not open system assembly ''C:\Windows\assembly\GAC_MSIL\microsoft.sqlserver.types\11.0.0.0__89845dcd8080cc91\microsoft.sqlserver.types.dll'': 32(The process cannot access the file because it is being used by another process.)."
 

Resolution

UPDATED: March 27, 2017


Updates are required for the SQL Server 2012 and 2014, updates can be obtained here:

https://support.microsoft.com/en-us/kb/3064292
 

Environment Details


 

Downloads

  • No Downloads