Oracle with EF6 - NET: Unknown error 1

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ogi
Posts: 12
Joined: Wed 19 Oct 2016 07:19

Oracle with EF6 - NET: Unknown error 1

Post by ogi » Tue 11 Jun 2019 05:27

Hi,

I'm getting an "NET: Unknown error 1" exception. I'm unable to determine the cause of the error nor have I had any luck googling it. Stack trace:

Code: Select all

NET: Unknown error 1
   at Devart.Data.Oracle.DirectUtils.c(Int32 A_0)
   at Devart.Data.Oracle.d5.a(Byte A_0)
   at Devart.Data.Oracle.cz.b()
   at Devart.Data.Oracle.ck.a(a1 A_0)
   at Devart.Data.Oracle.d7.j()
   at Devart.Data.Oracle.OracleDataReader.Close()
   at Devart.Common.Entity.d.Close()
   at Devart.Common.Entity.d.a(Boolean A_0)
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.Finally()
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.ObjectQueryNestedEnumerator.Dispose()
   at System.Data.Entity.Internal.LazyEnumerator`1.Dispose()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
I'm using Devart.Data.Oracle 9.4.348.0 with EF6 to connect to an Oracle 11.2.0.4 server. I cannot reproduce the bug in our development environment, but our customer is getting the same error every time they run the app. It pops up while loading a query result with about 70k rows and 200+ columns. Do you have any idea what could cause this exception?

Regards, O

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle with EF6 - NET: Unknown error 1

Post by Shalex » Fri 14 Jun 2019 13:59

Does the issue persist with the newest (9.7.770 06-Jun-19) build as well?

We cannot reproduce the problem in our environment. Please specify:
1) your connection string (mark confidential information with asterisks)
2) the DDL script of your table
3) the result set of executing "SELECT * FROM NLS_DATABASE_PARAMETERS" on your Oracle Server

ogi
Posts: 12
Joined: Wed 19 Oct 2016 07:19

Re: Oracle with EF6 - NET: Unknown error 1

Post by ogi » Mon 08 Jul 2019 08:40

As far as the newest build goes - I can't update and deploy a new production version for another month or so...

Requested data:
1) <add name="OracleConnection" providerName="Devart.Data.Oracle" connectionString="User Id=***;Password=***;Direct=true;Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = some-url.net)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = some-url.net)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = some_service_name)))" />

2) It is not a single table rather a set of joined tables. They reported another error that comes from a completely different part of the code (this time from an insert statement, previous was a select).

Code: Select all

NET: Unknown error 1
   at Devart.Data.Oracle.DirectUtils.c(Int32 A_0)
   at Devart.Data.Oracle.d5.a(Byte A_0)
   at Devart.Data.Oracle.cz.b()
   at Devart.Data.Oracle.ba.b()
   at Devart.Data.Oracle.d7.a(Int32 A_0, eb 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 Z.BulkOperations.OracleDevArtArrayProvider.(DbCommand , CommandBehavior , BulkOperation , Int32 )
   at ..(String[] , OracleDevArtArrayProvider ,  )
   at Z.BulkOperations.OracleDevArtArrayProvider.(Boolean , String[] )
   at Z.BulkOperations.OracleDevArtArrayProvider.()
   at ..(BulkOperation )

An error occured while retrieving the InformationSchemaTable information. See the inner exception for details.
   at ..(BulkOperation )
   at ..(BulkOperation )
   at Z.BulkOperations.BulkOperation.BulkInsert()
   at Z.EntityFramework.Extensions.EntityBulkOperation`1.BulkInsert()
   at Z.EntityFramework.Extensions.InternalBulkOperationManager.[](BulkOperation`1 , DbContext , List`1 , Boolean , List`1 , Type , String )
   at Z.EntityFramework.Extensions.InternalBulkOperationManager..(SchemaEntityType )
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Z.EntityFramework.Extensions.InternalBulkOperationManager.[](DbContext , BulkOperation`1 , IEnumerable`1 , List`1 )
   at Z.EntityFramework.Extensions.InternalBulkOperationManager.[](BulkOperation`1 , DbContext , IEnumerable`1 , List`1 )
   at DbContextExtensions.BulkInsert[T](DbContext this, IEnumerable`1 entities, Action`1 bulkOperationFactory)
3)

Code: Select all

PARAMETER	VALUE
NLS_LANGUAGE	SLOVENIAN
NLS_TERRITORY	SLOVENIA
NLS_CURRENCY	SIT
NLS_ISO_CURRENCY	SLOVENIA
NLS_NUMERIC_CHARACTERS	,.
NLS_CHARACTERSET	EE8MSWIN1250
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD.MM.RR
NLS_DATE_LANGUAGE	SLOVENIAN
NLS_SORT	SLOVENIAN
NLS_TIME_FORMAT	HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT	DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT	HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT	DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY	SIT
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE
NLS_NCHAR_CHARACTERSET	UTF8
NLS_RDBMS_VERSION	11.2.0.4.0

ogi
Posts: 12
Joined: Wed 19 Oct 2016 07:19

Re: Oracle with EF6 - NET: Unknown error 1

Post by ogi » Fri 12 Jul 2019 04:48

Additional info about the inner OracleException:

Code: Select all

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while reading from the store provider's data reader. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-03113: end-of-file on communication channel
  at at Devart.Data.Oracle.d5.c()
  at at Devart.Data.Oracle.d5.b()
  at at Devart.Data.Oracle.d5.a(Byte[] A_0, Int32 A_1, Int32 A_2)
  at at Devart.Data.Oracle.d5.g()
  at at Devart.Data.Oracle.dj.a()
  at at Devart.Data.Oracle.d7.b(Int32 A_0)
  at at Devart.Data.Oracle.OracleDataReader.Read()
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()
  --- End of inner exception stack trace ---
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.HandleReaderException(Exception e)
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.RowNestedResultEnumerator.MoveNext()
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.ObjectQueryNestedEnumerator.TryReadToNextElement()
  at at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.ObjectQueryNestedEnumerator.MoveNext()
  at at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  at at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
The query throws an exception after ~35 minutes. If I run the same query via Toad I get the results back successfully in about the same time (~35 minutes).

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle with EF6 - NET: Unknown error 1

Post by Shalex » Mon 15 Jul 2019 17:08

1. Specify "Default Command Timeout=0;" in your connection string explicitly.

2. If the upgrade to v9.7.790 (04-July-19) doesn't help, send us a small test project for reproducing the issue in our environment. If necessary, provide access to your Oracle Server where the issue persists. The database user may have the only privileges required for reproducing.

Post Reply