Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SqlException / Patch 5
#3
(24-10-2019, 10:51 AM)DevOma Wrote: Was heisst "die Datenbankverbindung stürzt ab"? Wann genau, welche Fehlermeldung?

Hallo Oliver,

sorry für die extrem später Rückmeldung. 
Die Fehler treten im Hinbtergrund auf, während man arbeitet.
Im Log habe ich immer folgende Meldung:
Code:
An error occured on executing an sql statement
PropertiesGet
Internal connection fatal error. Error state: 15, Token : 51

---------------------------

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at CloudAdminDataAccess.SqlDataAccessor._PropertiesGet(Guid userId, Guid itemId, Guid rolePropertyId)


Wir nutzen eine Shared Database. Die Installation ist in der Form schon ein paar Jahre her.
Gegen die aktuelle Datenbank haben wir mit folgenden Versionen getestet:
- 12.0.6504.1  (permanente Probleme, mehr als 8 pro Stunde)
- 12.0.6342.1  (gelegentliche Probleme)
- 11.0.6169.1  (keine Probleme)
- 10.1.5629.1  (keine Probleme)


Viele Grüße
Markus
Reply


Messages In This Thread
SqlException / Patch 5 - by adestis - 24-10-2019, 10:45 AM
RE: SqlException / Patch 5 - by DevOma - 24-10-2019, 10:51 AM
RE: SqlException / Patch 5 - by adestis - 25-11-2019, 11:39 AM
RE: SqlException / Patch 5 - by DevOma - 25-11-2019, 11:54 AM
RE: SqlException / Patch 5 - by adestis - 25-11-2019, 12:02 PM
RE: SqlException / Patch 5 - by adestis - 20-12-2019, 09:37 AM
RE: SqlException / Patch 5 - by adestis - 20-12-2019, 09:41 AM
RE: SqlException / Patch 5 - by adestis - 20-12-2019, 09:46 AM
RE: SqlException / Patch 5 - by DevOma - 27-12-2019, 02:38 PM
RE: SqlException / Patch 5 - by adestis - 02-01-2020, 11:39 AM
RE: SqlException / Patch 5 - by DevOma - 02-01-2020, 11:53 AM
RE: SqlException / Patch 5 - by adestis - 03-01-2020, 03:33 PM
RE: SqlException / Patch 5 - by DevOma - 07-01-2020, 10:12 AM
RE: SqlException / Patch 5 - by DevOma - 13-01-2020, 04:56 PM



Users browsing this thread: 1 Guest(s)