Page 1 of 1
Oracle with EF6 - NET: Unknown error 1
Posted: Tue 11 Jun 2019 05:27
by ogi
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
Re: Oracle with EF6 - NET: Unknown error 1
Posted: Fri 14 Jun 2019 13:59
by Shalex
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
Re: Oracle with EF6 - NET: Unknown error 1
Posted: Mon 08 Jul 2019 08:40
by ogi
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
Re: Oracle with EF6 - NET: Unknown error 1
Posted: Fri 12 Jul 2019 04:48
by ogi
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).
Re: Oracle with EF6 - NET: Unknown error 1
Posted: Mon 15 Jul 2019 17:08
by Shalex
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.