Update/Generate Model Fails To Get Metadata: ORA-12571

Update/Generate Model Fails To Get Metadata: ORA-12571

Postby gaustin » Wed 25 May 2011 15:00

I inherited a project that uses Oracle dotConnect 5.60. The application builds and runs fine. It's able to pull data from the database with no problem.

There have been some recent changes to the database schema (another group is responsible for the DB). Now I need to update the data model.

When I go into the model viewer, right click and select "Update Model From Database" I get an error that reads:

An error occurred while connecting to the database. The database might be unavailable. An exception of type ' System.Data.EntityCommandExecutionException' occurred. The Error message is: 'An error occurred while executing the command definition. See the inner exception for details. The inner exception caught was of type 'Devart.Data.Oracle.OracleException', with this error message: 'ORA-12571'.'.


The same thing happens when I try to generate a brand new model from the same database. When the wizard tries to retrieve the information about the database schema it gives the above error.

The stack trace makes me believe it's a network error. That's puzzling since the application and the database explorer have no issue querying the database.

Here's the stack traces (cobbled together from an attached debugger):
Devart.Data.Oracle.OracleException occurred
Message=Network error: Invalid operation. The connection is closed.
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=200
Offset=0
StackTrace:
at Devart.Data.Oracle.bs.m()
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=Network error: Invalid operation. The connection is closed.
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=200
Offset=0
StackTrace:
at Devart.Data.Oracle.bs.m()
at xc.y.a()
at xc.l.a()
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.d.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=Network error: Invalid operation. The connection is closed.
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=200
Offset=0
StackTrace:
at Devart.Data.Oracle.bs.m()
at xc.y.a()
at xc.l.a()
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.d.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 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)
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=Network error: Invalid operation. The connection is closed.
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=200
Offset=0
StackTrace:
at Devart.Data.Oracle.bs.m()
at xc.y.a()
at xc.l.a()
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.d.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 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)
InnerException:


Devart.Data.Oracle.OracleException occurred
Message=ORA-12571
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=-12571
Offset=0
StackTrace:
at Devart.Data.Oracle.n.a(Int32 A_0)
at Devart.Data.Oracle.bs.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.bs.a(Byte& A_0)
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.bi.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
InnerException:


System.Net.Sockets.SocketException occurred
Message=An established connection was aborted by the software in your host machine
Source=System
ErrorCode=10053
NativeErrorCode=10053
StackTrace:
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
InnerException:

System.IO.IOException occurred
Message=Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
Source=System
StackTrace:
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
InnerException: System.Net.Sockets.SocketException
Message=An established connection was aborted by the software in your host machine
Source=System
ErrorCode=10053
NativeErrorCode=10053
StackTrace:
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=Network error:: An established connection was aborted by the software in your host machine
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=208
Offset=0
StackTrace:
at Devart.Data.Oracle.bs.a(Byte[] A_0, Int32 A_1)
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=ORA-12571
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=-12571
Offset=0
StackTrace:
at Devart.Data.Oracle.n.a(Int32 A_0)
at Devart.Data.Oracle.bs.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.bs.a(Byte& A_0)
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.bi.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 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)
InnerException:

Devart.Data.Oracle.OracleException occurred
Message=ORA-12571
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=-12571
Offset=0
StackTrace:
at Devart.Data.Oracle.n.a(Int32 A_0)
at Devart.Data.Oracle.bs.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.bs.a(Byte& A_0)
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.bi.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 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)
InnerException:

System.Data.EntityCommandExecutionException occurred
Message=An error occurred while executing the command definition. See the inner exception for details.
Source=System.Data.Entity
StackTrace:
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
InnerException: Devart.Data.Oracle.OracleException
Message=ORA-12571
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=-12571
Offset=0
StackTrace:
at Devart.Data.Oracle.n.a(Int32 A_0)
at Devart.Data.Oracle.bs.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.bs.a(Byte& A_0)
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.bi.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 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.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
InnerException:
gaustin
 
Posts: 2
Joined: Wed 25 May 2011 14:25

Postby gaustin » Wed 25 May 2011 16:02

Just to add a little detail: I have tried all of the above steps after upgrading to 6.30 (latest). Same results.
gaustin
 
Posts: 2
Joined: Wed 25 May 2011 14:25

Postby Shalex » Fri 27 May 2011 14:44

1. Are you using the Direct or OCI (via Oracle Client) connection mode? Try switching to another mode. Does it make any difference?
2. Tell us the versions of your Oracle server and Oracle client.
3. Are you using EDM Wizard or Entity Developer for generating/editing your model? We recommend using Entity Developer (the Devart Entity Model item in Visual Studio).
4. If possible, send us a sample schema to reproduce the problem in our environment.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle