Devart Forums

We are running on-premise without any patches. This is the version that query 'select * from v$version;' returns

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Original error was in direct mode. Just tried in OCI mode, still getting the same error.

keyword END in the filter results in ORA-00933 error. Without that, it works fine. However, same query executed in Toad parses successfully. I am using oracle 19C with 'dontconnect for Oracle' 9.8.838.0

---------------------dbmonitor log--------------------
6/8/2020 10:32:08 AM 0.000 Creating object Complete
6/8/2020 10:32:08 AM 0.000 Prepare: SELECT DISTINCT user_id FROM Users WHERE Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH'); Complete
6/8/2020 10:32:08 AM 0.000 Execute: SELECT DISTINCT user_id FROM Users WHERE Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH'); Error
6/8/2020 10:32:08 AM 0.000 Creating object Complete

Exception is thrown intermittently during some read operations on our production environment. It does not reproduce on our test servers. any thoughts?

Devart.Data.Oracle.dll 9.0.12.0

call stack:

||544|2019/01/03 14:49:37.074|8284|PoolThread:89|||Details: Devart.Data.Oracle.OracleException: ORA-08103: object no longer exists
at Devart.Data.Oracle.cv.d()
at Devart.Data.Oracle.ah.i()
at Devart.Data.Oracle.ad.s(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.Entity.d.b(Int32 A_0, aa A_1)
at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

This error happens in our production system frequently but is not consistent. We have checked connections and network. No problems were identified. Also, the call stack is not available as the logging is minimal being production. If there is any bug in the code regarding the reader closing etc..., we would see the problem consistently. Interestingly, the reader is loading one row only. It is puzzling why the reader would close prematurely. Can you help?

we are testing our application with 8.4.333 currently. It fixes a multithreaded connection pool issue mentioned below as per your rev. history. This System.IndexOutOfRangeException problem seems to be related. do you think moving to 8.4.333 will help?

---------------
8.4.333 15-Jan-15

•The bug with throwing System.InvalidOperationException by Devart connection pooling in multithreaded applications under high loads is fixed

This happens once in a while in production. It is not reproducing in dev setup. We are using dotconnect for Oracle 8.3.161.6. Any thoughts?


---------

INNER EXCEPTION (System.IndexOutOfRangeException): Index was outside the bounds of the array.
Stack Trace: at Devart.Data.Oracle.DirectUtils.a(String A_0, String A_1)
at Devart.Data.Oracle.g.a()
at Devart.Data.Oracle.b0.a(String A_0, Int32 A_1, String A_2, String A_3)
at Devart.Data.Oracle.c6.a(b2 A_0, Boolean A_1)
at Devart.Data.Oracle.c6.a(b2 A_0, q A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(b2 connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.aq.a(m A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, m A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()

for the exception below, devart returns error code as 208.

EXCEPTION (Devart.Data.Oracle.OracleException): Network error:: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

However, 'ORA-00208' has a different message by oracle --- 'number of control file names exceeds limit of string'

so, what is the reliable way to use the code as they seem to clash? also, I did not find documentation on devart's error codes.

We are running into the same issue with version 7.2.122.0. Is there a fix?

We are running into the same issue with EF4 and oracle 11g while using MAX. I understand that it stems from Microsoft's EF implementation. any ideas whether it's been fixed in EF5?

Sometimes I am getting this oracle exception. Not sure what the exact scenario is. Any ideas?

EXCEPTION (Devart.Data.Oracle.OracleException): ORA-03117: two-task save area overflow
Stack Trace: at Devart.Data.Oracle.a6.b(Int32 A_0)
at Devart.Data.Oracle.a8.a(Int32 A_0, bw A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.w.a(CommandBehavior A_0)
at Devart.Common.Entity.o.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.w.b(CommandBehavior A_0)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

great, thanks

The exception happens when using Entityframework query with a filter on a NVARCHAR2 field. Sounds like a mapping issue between types NVARCHAR2 and NVARCHAR. I am using verion 7.2.96 with settings Direct=True and Unicode=True

here are the details...

CREATE TABLE "MyTable"(
"Id" raw(16) NOT NULL,
"Name" nvarchar2(255) NOT NULL,
CONSTRAINT "PK_MyTable" PRIMARY KEY ("Id")
)

--EF query snippet in C#
string name = "test";
context.MyTable.Where(c => c.Name == name); // results in ORA-01460 exception
--

exception call stack -

EXCEPTION (Devart.Data.Oracle.OracleException): ORA-01460: unimplemented or unreasonable conversion requested
Stack Trace: at Devart.Data.Oracle.u.d()
at Devart.Data.Oracle.ar.h()
at Devart.Data.Oracle.ar.c()
at Devart.Data.Oracle.aa.a(Int32 A_0, by A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.v.a(CommandBehavior A_0)
at Devart.Common.Entity.o.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.v.b(CommandBehavior A_0)

you are right. There are no exceptions while connecting which I thought might happen because the password had to be double quoted originally while creating the user. Please let us know when the double quote issue (ORA-01005: null password given; logon denied
) is fixed.

that partly fixes the problem. How would you handle passwords with space in them such as "Hello World!"?