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:
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.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 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: