You

• ...try to edit/create a user on the Trados GroupShare web interface or
• ...try to check in a new file to an existing Trados GroupShare project.

You receive following error:

The type initializer for 'ExtentPlaceholderCreator' threw an exception




The full error can be found in the Trados GroupShare application log :

2022-12-08 12:51:35.2950 | SERVERNAMEHERE | Pid: 9408 | Thread:22 | StudioServer.Management.RestApi | Error | 
The type initializer for 'ExtentPlaceholderCreator' threw an exception. | 
System.TypeInitializationException: The type initializer for 'ExtentPlaceholderCreator' threw an exception. ---> 
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 
System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
   at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
   at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
   at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Data.SqlClient.SqlSpatialServices.GeometryFromText(String geometryText)
   at System.Data.Spatial.DbGeometry.FromText(String wellKnownText)
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.InitializeTypeDefaultMap()
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator..cctor()
   --- End of inner exception stack trace ---
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.GetPropagatorResultForPrimitiveType(PrimitiveType primitiveType, PropagatorResult& result)
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.Visit(EdmMember node)
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.CreateEntitySetPlaceholder(EntitySet entitySet)
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.CreatePlaceholder(EntitySetBase extent, UpdateTranslator parent)
   at System.Data.Mapping.Update.Internal.Propagator.Visit(DbScanExpression node)
   at System.Data.Common.CommandTrees.DbScanExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
   at System.Data.Mapping.Update.Internal.UpdateExpressionVisitor`1.Visit(DbExpression expression)
   at System.Data.Mapping.Update.Internal.Propagator.Visit(DbProjectExpression node)
   at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
   at System.Data.Mapping.Update.Internal.Propagator.Propagate(UpdateTranslator parent, EntitySet table, DbQueryCommandTree umView)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.<ProduceDynamicCommands>d__44.MoveNext()
   at System.Linq.Enumerable.<ConcatIterator>d__59`1.MoveNext()
   at System.Data.Mapping.Update.Internal.UpdateCommandOrderer..ctor(IEnumerable`1 commands, UpdateTranslator translator)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.ProduceCommands()
   at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
   at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
   at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
   at Sdl.StudioServer.Services.IdentityModel.Data.IdentityModelDataAccess.UpdateUser(User user)
   at Sdl.StudioServer.Services.IdentityModel.UserManager.UpdateUser(User user)
   at Sdl.StudioServer.Services.Management.RestApi.Api.UserManagerAdapter.UpdateUser(User user)
   at Sdl.StudioServer.Services.Management.RestApi.Controllers.UsersController.UpdateUser(UserWithRoles user)
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.EntryPointNotFoundException: 
Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
   at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
   at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
   at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Data.SqlClient.SqlSpatialServices.GeometryFromText(String geometryText)
   at System.Data.Spatial.DbGeometry.FromText(String wellKnownText)
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.InitializeTypeDefaultMap()
   at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator..cctor()
System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
   at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
   at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
   at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)

Note: The error may not occur for all such actions - but just intermittently.
 

Install System CLR Types for SQL Server delivered with GroupShare

On the Trados GroupShare application server:

1. Uninstall Microsoft System CLR Types for SQL Server 2012 (32- and also 64-bit version if present)
2. At C:\Windows\assembly, verify that the assembly Microsoft.SqlServer.Types.dll (assembly version 11.0.0.0) is no longer present on the server and in case it exists uninstall/delete it. Note: If you cannot uninstall it as mentioned, follow the steps below:
   • Open the Registry Editor
   • Go to HKLM\SOFTWARE\Classes\Installer\Assemblies\Global
   • Locate the key: Microsoft.SqlServer.Types,fileVersion="2011.110.3000.0",version="11.0.0.00000000
   • Delete this key. Note: Preferable make a backup of this registry folder/key before-hand.
3. Install version of Microsoft System CLR Types for SQL Server 2012 delivered with Trados GroupShare (2012 SP1, e.g. from C:\ProgramData\Package Cache\SDL\Dependencies\SQL11\SQLSysClrTypes.msi)

 

Note: After applying the steps, the file version in the assembly cache should be 11.1.3000.0 (C:\Windows\assembly > right click Microsoft.SqlServer.Types, Version 11.0.0.0 > Properties > tab Version).

Defect in assembly Microsoft.SqlServer.Types.dll, file version 2011.110.6020.0: https://connect.microsoft.com/SQLServer/Feedback/Details/2139143 .
A *.dll version not affected by the issue is delivered with Trados GroupShare 2015/2017/2020 as part of the "Microsoft System CLR Types for SQL Server 2012".