Timezone region not found

Question

I'm creating a C# MVC project that uses Oracle Database. While trying to connect to the DB, I get following error:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found.

When I try to connect via SQL developer it works fine. Is there any way that I can solve this problem ?

NOTE: I'm using IIS express for testing

user_1172251 · Answer

I was facing the same issue using ODP.NET for .NET Core on Pivotal Cloud Foundry. The core issue is missing timezone information.

Added a timezone by setting "TZ" environment variable for my instance. That fixed the issue for me.

user_6800805 · Answer

Had the same problem in .Net Core 3.1 API with controllers.

had the error on debug, and solved it adding TZ on \Properties\launchSettings.json:

"Docker": {
...
   "environmentVariables": {
        "TZ": "WET"
      }
}

user_7862492 · Answer

According to this and this:

In C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf add

AddVMOption -Duser.timezone="+02:00"