Oracle.ManagedDataAccess.Core beta2 Oracle.ManagedDataAccess.Types.TimeStamp InvalidCastException Er

93aec6ef-f91d-45ba-95c5-35c685adb506

When using the Oracle.ManagedDataAccess.Core(1.12.0-beta2) 

I get the following error.   It goes into the Catch block, during the Open connection.

The below is what ends in Exception.InnerException (converted to String). 

"System.TypeInitializationException: The type initializer for 'OracleInternal.ServiceObjects.OracleConnectionImpl' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Oracle.ManagedDataAccess.Types.TimeStamp' threw an exception. ---> System.InvalidCastException: Object must implement IConvertible.   at OracleInternal.Common.OracleTimeZone.GetInstance()   at Oracle.ManagedDataAccess.Types.TimeStamp..cctor()   --- End of inner exception stack trace ---   at Oracle.ManagedDataAccess.Types.TimeStamp.InitializelatestTZversion()   at OracleInternal.ServiceObjects.OracleConnectionImpl..cctor()   --- End of inner exception stack trace ---   at OracleInternal.ServiceObjects.OracleConnectionImpl..ctor()"

Is anyone else seeing this error?

9192a20a-f37b-47f0-b6b7-9abf79265508

I have same trouble, and i fixed that by removing nuget reference "Microsoft.Windows.Compability"

Alex Keh-Oracle

Which .NET Core runtime version are you using and what NuGet packages do you have installed?

Alex Keh-Oracle

Also, if you can provide a simple test case to reproduce the problem, that would be helpful.

3728170

I have the same problem.

I'm using .Net Core 2.1

The nuget installed are:

Microsoft.AspNetCore.Identity

Microsoft.NetCoreApp

Oracle.ManagedDataAccess.Core (I tried with ODP.NetCore and got the same problem).  The problem happend when I open the connection, so very simple to reproduce

I'm using Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

It is very easy to reproduce.  Create a basic application .netCore 2.1 with Vs.Net 2017 (15.7.3)  and configure a connection to oracle.

****Update:

I found that my main web application used Microsoft.Windows.Compatibility

and it is this DLL how seems to have a conflict with oracle connection even if I don't use it in the oracle library.

Any idea how to fix it?

Alex Keh-Oracle

I haven't been able to reproduce the error myself. Nonetheless, it seems several people have this issue. I have created bug 28240405 to track and investigate this problem.

Alex Keh-Oracle

Also, if anyone who has encountered this error can upload a simple reproducible test case, that would be helpful for my team to diagnose and fix the bug.

Alex Keh-Oracle

FWIW, a workaround was posted on StackOverflow.

https://stackoverflow.com/questions/48942239/oracle-net-core-managed-driver-oracle-manageddataaccess-types-timestamp-cct…

Alex Keh-Oracle

Based on our own internal Oracle testing with the planned production ODP.NET Core release, we have been unable to reproduce the issue. The bug has been closed as we believe the issue is resolved. Feel free to post to this thread if you encounter the same issue after ODP.NET Core 18.3 production is released.