CultureNotFoundException Querying SQL database using EF

Question

CultureNotFoundException Querying SQL database using EF

Setteidea SRL 0

Hello,

I have a Web App (ASP.NET MVC) with controllers making CRUD operations using EF 6.

Any operation involving the EF context to read data generates the following exception

The Web App is localized in it-IT, setting up ThreadCulture and ThreadUICulture, in Application_Start and setting <globalization culture="it-IT" uiCulture="it-IT" /> in web.config

The error is invariant respect the culture I try to set.

Any idea about this behaviour?

King regards

System.Globalization.CultureNotFoundException: Culture is not supported.

Parameter name: name

ar-DJ is an invalid culture identifier.

at System.Globalization.CultureInfo..ctor(String name, Boolean useUserOverride)

at System.Reflection.AssemblyName.nInit(RuntimeAssembly& assembly, Boolean forIntrospection, Boolean raiseResolveEvent)

at System.Reflection.AssemblyName..ctor(String assemblyName)

at System.Data.Entity.Core.Metadata.Edm.MetadataAssemblyHelper.ComputeShouldFilterAssembly(Assembly assembly)

at System.Data.Entity.Core.Common.Utils.Memoizer`2.Result.GetValue()

at System.Data.Entity.Core.Common.Utils.Memoizer`2.Evaluate(TArg arg)

at System.Data.Entity.Core.Metadata.Edm.DefaultAssemblyResolver.<GetAlreadyLoadedNonSystemAssemblies>b__0(Assembly a)

at System.Linq.Enumerable.WhereArrayIterator`1.MoveNext()

at System.Data.Entity.Core.Metadata.Edm.DefaultAssemblyResolver.GetAllDiscoverableAssemblies()

at System.Data.Entity.Core.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Entity.Core.Metadata.Edm.MetadataArtifactLoaderCompositeResource.CreateResourceLoader(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Entity.Core.Metadata.Edm.MetadataCache.SplitPaths(String paths)

at System.Data.Entity.Core.Common.Utils.Memoizer`2.Result.GetValue()

at System.Data.Entity.Core.Common.Utils.Memoizer`2.Evaluate(TArg arg)

at System.Data.Entity.Core.Metadata.Edm.MetadataCache.GetArtifactLoader(DbConnectionOptions effectiveConnectionOptions)

at System.Data.Entity.Core.Metadata.Edm.MetadataCache.GetMetadataWorkspace(DbConnectionOptions effectiveConnectionOptions)

at System.Data.Entity.Core.EntityClient.EntityConnection.GetMetadataWorkspace()

at System.Data.Entity.Core.Objects.ObjectContext..ctor(EntityConnection connection, Boolean isConnectionConstructor, ObjectQueryExecutionPlanFactory objectQueryExecutionPlanFactory, Translator translator, ColumnMapFactory columnMapFactory)

at System.Data.Entity.Internal.InternalConnection.CreateObjectContextFromConnectionModel()

at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()

at System.Data.Entity.Internal.InternalContext.Initialize()

at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)

at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()

at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()

at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()

at System.Linq.Queryable.Where[TSource]

at WebApp.DataModel.DataExtensions.GetDays(DataEntities context)

Lan Huang-MSFT 30,211 Reputation points Microsoft External Staff

2024-05-07T02:38:53.48+00:00
Hi @Setteidea SRL,

On Windows 7 and later operating systems, the .NET Framework retrieves culture data from the operating system. The CultureNotFoundException exception is thrown if the operating system is unable to find the culture, and the culture is not a custom culture or a replacement culture.

Please check the Region of your operating system.

Control Panel -> Region -> Regional format

Details:How to solve this Exception "Culture is not Supported"?

Some other workarounds:

Go to the Debug -> Options in Visual Studio and check "Just My Code".

Deleted all the folders from in here: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files
Setteidea SRL 0 Reputation points

2024-05-07T06:18:44.94+00:00

Hello Lan,

Thank you very much for the answer.

I've just tried the StackOverflow tricks.

The Operating System is Windows Server 2012 R2 (Datacenter edition), with it-IT language pack (the deployment environment). In the development environment the error is not thrown.

The Temporary ASP.NET File folder is always empty.

The exception is thrown when the EF context is used to retrieve records from the SQL server Database.

Kind regards

Domenico
Lan Huang-MSFT 30,211 Reputation points Microsoft External Staff

2024-05-08T07:54:27.46+00:00

Hi @Setteidea SRL,

Instead of checking language pack, you need to check Region.

As you can see from the error message: ar-DJ is an invalid culture identifier. ar-DJ is only supported on Windows Server 2016, please check your language pack and region is set to Arabic (ar-DJ).https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c?redirectedfrom=MSDN
Setteidea SRL 0 Reputation points

2024-05-08T10:01:00.75+00:00

Hello Lan,

regional and language settings are set on it-IT.

Thank you for the time you spent on my topics.

Kind regards
Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator

2024-05-08T20:52:29.0833333+00:00

Well, your personal regional settings have little to do with what the web app is using.

As a start, check the tab Opzione di ammistrazione to see what the system locale is.

But if the web app is running under some other user, that user may have a funky default.

Then again, if, as Lan says, Windows 2012 does not support ar-DJ, I can't see that any of the settings discussed above could be set to Arabic (Djibouti). But the code itself may be setting the culture. Or, well, there could be a bug where the culture is set to an arbitrary value.

I think you need to do some debugging and see what the culture setting is at various points.