2022-02-07 05:32:37.1849 E:96 Lers.EquipmentControl.DeviceInfoSaver Обнаружен сбой архива прибора ВКТ-7 #196524. Архив: Часовые. Ошибка чтения интервала дат архива. Заголовок архива повреждён.Неверная длина пакета. Принято: 8 байт, требуется: 12 байт 00-0cc360729fbc194ebbc94a25ac1aca99-3ab65412ca6da54c-00 2022-02-07 09:03:28.6342 E:68 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T09:03:28/2022-02-07T09:03:28. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-5c7c0757bb549646af5f83f522c470db-a0b3da04cbcf4346-00 2022-02-07 09:13:55.3508 E:85 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Core/GprsModems/120/Call. Использование GSM-модема запрещено или не настроено. Настройки GSM-модема можно изменить в системных параметрах. [Рабочее место оператора] 00-7b46467944b42d438b4962c59e30f2a2-addb65e0b810e243-00 2022-02-07 09:44:01.6637 E:43 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T09:44:01/2022-02-07T09:44:01. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-495c8438254eb64c8812c77c827b3682-cea39dbddbe8774d-00 2022-02-07 09:45:53.5767 E:16 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T09:45:53/2022-02-07T09:45:53. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #54785 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-504c77560bfa7240a245aa8819dceb7a-15ae79cee7304240-00 2022-02-07 11:29:32.2443 E:74 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://192.168.2.2:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-01T00:00:00/2022-02-07T23:59:00. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #СОШ№9мастерские не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-ba7d0a30b4cbe74999e8bf1d78760b6d-7e11c98609000a40-00 2022-02-07 11:32:16.9413 E:36 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T11:32:16/2022-02-07T11:32:16. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мира 71 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-8959dd823ff2f144a3258c9ca692c3ee-eee63008f05d444d-00 2022-02-07 11:37:52.5433 E:77 Lers.ExceptionHandler Ошибка выполнения запроса POST http://192.168.2.2:10000/api/v0.1/Admin/Updates/Install?backupDataBase=true. Cannot access a disposed object. 1. [System.Private.CoreLib] System.ObjectDisposedException: Cannot access a disposed object. Стек вызовов: at System.Threading.ReaderWriterLockSlim.TryEnterReadLockCore(TimeoutTracker timeout) at Lers.UserSessionList.GetSessions() at Lers.UserSessionManager.GetSessions() at Lers.EntityChangedNotifier.BroadcastEvent[TNotifyData](Operation operation, EntityType entityType, Int32 entityId, TNotifyData notifyData, Func`4 accessCheck) at Lers.Poll.GprsStateManager.NotifyModemOnlineChanged(IEquipment equipment, Boolean isOnline, GprsModemSession lastSession, IEquipmentDataAccess equipmentDal, IEntityChangedNotifier notifier) at Lers.Poll.GprsStateManager.SetPollServiceConnectionsOffline(EntityIdentifier pollServiceId, IEquipmentRepository equipmentRepo, IEquipmentDataAccess equipmentDal, IEntityChangedNotifier notifier) at Lers.Poll.Queue.UserSessionClosedHandler.OnUserSessionClosed(UserSession session) at Lers.Poll.PollQueueThread.DeactivatePollSessionPorts(IServiceProvider services, UserSession session) at Lers.UserSessions.EndUserSessionHandler.CloseUserSession(UserSession session, DisconnectionCode exitCode) at Lers.UserSessions.EndUserSessionHandler.CloseAll(DisconnectionCode exitCode) at Lers.Server.Api.Administration.UpdatesController.Install(Boolean backupDataBase, CancellationToken cancellationToken) at lambda_method2027087(Closure , Object ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) HResult:-2146232798 Дополнительная информация (Data): ClientApp=Рабочее место оператора RequestBody= -------------------------------------------------------------------------------------- 00-437e0eca8ef9dc499b85da33a739f477-8694654bf6dfa240-00 2022-02-07 11:37:52.5433 F:77 Lers.ExceptionHandler Ошибка выполнения запроса POST http://192.168.2.2:10000/api/v0.1/Admin/Updates/Install?backupDataBase=true. Cannot access a disposed object. 00-437e0eca8ef9dc499b85da33a739f477-8694654bf6dfa240-00 2022-02-07 11:45:50.3037 E:1 Lers.Server.Program ============================================ 2022-02-07 11:45:50.3677 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 11:45:50.3677 E:1 Lers.Server.Program ============================================ 2022-02-07 11:47:02.1899 E:8 Microsoft.EntityFrameworkCore.Database.Command Failed executing DbCommand (60,469ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (Size = 1) (DbType = Byte), @p2='?' (Size = 4000), @p3='?' (Size = 1) (DbType = Byte)], CommandType='Text', CommandTimeout='60'] insert into "SystemLog" ("DateTime", "Importance", "Message", "EventType") values (@p0, @p1, @p2, @p3) 2022-02-07 11:47:02.1949 E:8 Lers.Logging.SystemLog Не удалось добавить запись в системный журнал. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. 2022-02-07 11:47:51.1378 E:17 Microsoft.EntityFrameworkCore.Database.Command Failed executing DbCommand (38,090ms) [Parameters=[@p2='?' (DbType = Int32), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='60'] SET NOCOUNT ON; UPDATE [Task] SET [LastRunTime] = @p0, [StartDateTime] = @p1 WHERE [Id] = @p2; SELECT @@ROWCOUNT; 2022-02-07 11:47:51.1548 E:8 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:19711b5f-d9da-480a-85d4-a65e3acc4210 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=0 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 11:47:51.1548 E:17 Microsoft.EntityFrameworkCore.Update An exception occurred in the database while saving changes for context type 'Lers.Dal.LersDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - Канал был закрыт.) ---> System.ComponentModel.Win32Exception (109): Канал был закрыт. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) ClientConnectionId:f09fd740-4105-4f4d-a3ef-cd383893d9a0 Error Number:109,State:0,Class:20 --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 1. [Microsoft.EntityFrameworkCore.Relational] Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. Стек вызовов: at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) HResult:-2146233088 -------------------------------------------------------------------------------------- 2. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - Канал был закрыт.) Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at Microsoft.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=109 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 3. [] System.ComponentModel.Win32Exception: Канал был закрыт. Стек вызовов: HResult:-2147467259 Дополнительная информация из ExternalException: HRESULT=0x80004005 Информация из Win32Exception: NativeErrorCode=109 -------------------------------------------------------------------------------------- 2022-02-07 11:47:51.1668 F:8 Lers.Poll.PollQueue Ошибка при инициализации очереди опроса. 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() at System.Collections.Generic.LargeArrayBuilder`1.AddRange(IEnumerable`1 items) at System.Collections.Generic.EnumerableHelpers.ToArray[T](IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Lers.Dal.PollTaskDataAccess.ResetPollQueue(DateTime serverNow, IPollSessionDataAccess pollSessionDal) at Lers.Poll.PollQueue.Reset() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=0 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 11:47:51.1668 F:17 Lers.ExceptionHandler Ошибка сохранения в БД состояния задания System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1+AsyncStateMachineBox`1[Lers.Models.ServerTask,Lers.Tasks.TaskScheduler+d__14] Не удалось выполнить обращение к базе данных: An error occurred while updating the entries. See the inner exception for details. A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - Канал был закрыт.) Канал был закрыт. Проверьте соединение сервера ЛЭРС УЧЕТ с SQL-сервером. 2022-02-07 11:48:08.8045 E:17 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 11:48:08.8095 E:17 Lers.Logging.SystemLog Не удалось добавить запись в системный журнал. Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". 2022-02-07 11:48:08.8095 E:8 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 11:48:08.8095 E:17 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 11:48:08.8095 E:8 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:e9508a9a-2a17-4aa7-a1d1-ecddce5db5ff Error Number:4060,State:1,Class:11 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". Стек вызовов: at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=4060 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 11:48:08.8095 E:17 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:e9508a9a-2a17-4aa7-a1d1-ecddce5db5ff Error Number:4060,State:1,Class:11 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". Стек вызовов: at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=4060 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 11:48:08.8095 F:17 Lers.ExceptionHandler Ошибка сохранения в БД состояния задания System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1+AsyncStateMachineBox`1[Lers.Models.ServerTask,Lers.Tasks.TaskScheduler+d__14] При обращении к базе данных произошла ошибка: Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". Проверьте соединение сервера ЛЭРС УЧЕТ с SQL-сервером. 2022-02-07 11:48:08.8285 E:17 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 11:48:08.8285 E:17 Lers.Logging.SystemLog Не удалось добавить запись в системный журнал. Не удается открыть базу данных "LERS", запрашиваемую именем входа. Не удалось выполнить вход. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". 2022-02-07 11:49:13.4410 E:1 Lers.Server.Program ============================================ 2022-02-07 11:49:13.5980 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 11:49:13.6020 E:1 Lers.Server.Program ============================================ 2022-02-07 11:56:02.0307 E:1 Lers.Server.Program ============================================ 2022-02-07 11:56:02.3967 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 11:56:02.3967 E:1 Lers.Server.Program ============================================ 2022-02-07 12:01:30.3075 E:1 Lers.Server.Program ============================================ 2022-02-07 12:01:30.3715 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 12:01:30.3715 E:1 Lers.Server.Program ============================================ 2022-02-07 12:08:12.7025 E:1 Lers.Server.Program ============================================ 2022-02-07 12:08:12.7615 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 12:08:12.7615 E:1 Lers.Server.Program ============================================ 2022-02-07 12:13:54.4260 E:47 Microsoft.AspNetCore.SignalR.HubConnectionHandler Error when dispatching 'OnDisconnectedAsync' on hub. 1. [System.Private.CoreLib] System.ObjectDisposedException: Cannot access a disposed object. Стек вызовов: at System.Threading.ReaderWriterLockSlim.TryEnterReadLockCore(TimeoutTracker timeout) at Lers.UserSessionList.GetSessions() at Lers.UserSessionManager.GetSessions() at Lers.EntityChangedNotifier.BroadcastEvent[TNotifyData](Operation operation, EntityType entityType, Int32 entityId, TNotifyData notifyData, Func`4 accessCheck) at Lers.Poll.GprsStateManager.NotifyModemOnlineChanged(IEquipment equipment, Boolean isOnline, GprsModemSession lastSession, IEquipmentDataAccess equipmentDal, IEntityChangedNotifier notifier) at Lers.Poll.GprsStateManager.SetPollServiceConnectionsOffline(EntityIdentifier pollServiceId, IEquipmentRepository equipmentRepo, IEquipmentDataAccess equipmentDal, IEntityChangedNotifier notifier) at Lers.Poll.Queue.UserSessionClosedHandler.OnUserSessionClosed(UserSession session) at Lers.Poll.PollQueueThread.DeactivatePollSessionPorts(IServiceProvider services, UserSession session) at Lers.UserSessions.EndUserSessionHandler.CloseUserSession(UserSession session, DisconnectionCode exitCode) at Lers.UserSessions.EndUserSessionHandler.EndSession(String connectionId) at Lers.Server.Api.Rpc.ServerHub.OnDisconnectedAsync(Exception exception) at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnDisconnectedAsync(HubConnectionContext connection, Exception exception) at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnDisconnectedAsync(HubConnectionContext connection, Exception exception) at Microsoft.AspNetCore.SignalR.HubConnectionHandler`1.HubOnDisconnectedAsync(HubConnectionContext connection, Exception exception) HResult:-2146232798 -------------------------------------------------------------------------------------- 2022-02-07 12:23:20.3714 E:1 Lers.Server.Program ============================================ 2022-02-07 12:23:20.4364 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 12:23:20.4364 E:1 Lers.Server.Program ============================================ 2022-02-07 13:03:39.9392 E:108 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/980. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 22 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-5505ec48e9958243a3f9b193539b8391-851b553e5111ed47-00 2022-02-07 13:03:44.7395 E:9 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/980. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 22 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-bbdf1e3966360c44a40176a510c54dde-d13d681d9b1b6f4b-00 2022-02-07 13:03:55.5181 E:8 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/115. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 32 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-d100ce10f8592b4d8fdbb27487511c22-1a851fe992a6d141-00 2022-02-07 13:04:23.8308 E:10 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/928. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Окр.шоссе 49 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-88a0dcad79558049930f99683201b4c4-0b903c63c97d9645-00 2022-02-07 13:04:34.6634 E:123 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/115. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 32 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-848c6794ba68de48bb32888263861174-55ea1d5b8320e64f-00 2022-02-07 13:06:32.6441 E:119 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/977. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж. 14 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-95521ac2f9d3194aa86081757b4ca00f-c40e865d52c3f441-00 2022-02-07 13:06:42.1897 E:114 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/978. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-6e60877b8ef3894cb56a34fa0e9556f0-d1aa4da03e72fc4d-00 2022-02-07 13:06:52.4072 E:114 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/115. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 32 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-8268fe62b7541e4e9338d3bbf9c90c2d-d02b6535d510e347-00 2022-02-07 13:08:11.3158 E:93 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/928. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Окр.шоссе 49 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-adbda3c630adfb4da529c0adea7cd926-8c3bec58ca398240-00 2022-02-07 13:08:23.4705 E:72 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/115. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж 32 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-72aba57984ddc147bfe97f0be0029e96-73163b6690ca4742-00 2022-02-07 13:08:33.1610 E:92 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/RemoteConsole/977. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж. 14 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-a45be433795ea94d92f0fcb0972e8dd5-082058fcc7910f4d-00 2022-02-07 13:21:16.9637 E:61 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T13:21:59/2022-02-07T13:21:59. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж. 14 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-a9ca7d5ab8bfbf409c99c0cc9f032b79-ad0e0984b2b0c844-00 2022-02-07 13:40:48.5007 E:30 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T13:41:32/2022-02-07T13:41:32. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-f231d4142124bd4884750d3ea86dec7f-d6e1b78eef7f064e-00 2022-02-07 13:41:57.0666 E:30 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T13:42:41/2022-02-07T13:42:41. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-dd31e2a132901d46986340ee30ef8aa1-9b92b06763238a44-00 2022-02-07 13:44:05.0299 E:25 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T13:44:48/2022-02-07T13:44:48. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж. 14 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-3e24e373020de94eb50d4c05253bc211-abc08db2d6c71249-00 2022-02-07 14:37:15.3313 E:129 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://192.168.2.2:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-01T00:00:00/2022-02-07T23:59:00. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Разведчиков 54 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-6cdf9c13763aef4795d013bf5f3b2987-6381638930c92549-00 2022-02-07 14:41:48.8653 E:30 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://192.168.2.2:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-01T00:00:00/2022-02-07T23:59:00. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #54785 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [Рабочее место оператора] 00-ea82a5eb62fc0c40ac11a78a5e9abfe0-10fcb7c74dbf3945-00 2022-02-07 14:54:22.1463 E:1 Lers.Server.Program ============================================ 2022-02-07 14:54:22.2293 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 14:54:22.3083 E:1 Lers.Server.Program ============================================ 2022-02-07 14:55:33.0283 E:8 Microsoft.EntityFrameworkCore.Database.Command Failed executing DbCommand (60,069ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (Size = 1) (DbType = Byte), @p2='?' (Size = 4000), @p3='?' (Size = 1) (DbType = Byte)], CommandType='Text', CommandTimeout='60'] insert into "SystemLog" ("DateTime", "Importance", "Message", "EventType") values (@p0, @p1, @p2, @p3) 2022-02-07 14:55:33.0323 E:8 Lers.Logging.SystemLog Не удалось добавить запись в системный журнал. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. 2022-02-07 14:55:40.9013 E:28 Microsoft.EntityFrameworkCore.Database.Command Failed executing DbCommand (47ms) [Parameters=[], CommandType='Text', CommandTimeout='60'] SELECT [t].[Id], [t].[CopyMeasurePointId], [t].[MonthStdTemperature], [t].[Name], [t].[ParentId], [t].[TimeZoneOffset] FROM [Territory] AS [t] 2022-02-07 14:55:40.9513 E:28 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Выполняется команда SHUTDOWN. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". A severe error occurred on the current command. The results, if any, should be discarded. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:0bf34491-991d-4edd-a79c-db5eed55cb98 Error Number:6005,State:1,Class:14 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: Выполняется команда SHUTDOWN. Ошибка входа пользователя "EPTS2\LERSSERVERACCOUNT". A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=6005 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.6263 E:8 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:71a25b57-a6d1-4e90-b808-5f0cf00b0397 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=0 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.6263 F:8 Lers.Poll.PollQueue Ошибка при инициализации очереди опроса. 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Microsoft.Data.SqlClient.SqlDataReader.Read() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() at System.Collections.Generic.LargeArrayBuilder`1.AddRange(IEnumerable`1 items) at System.Collections.Generic.EnumerableHelpers.ToArray[T](IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Lers.Dal.PollTaskDataAccess.ResetPollQueue(DateTime serverNow, IPollSessionDataAccess pollSessionDal) at Lers.Poll.PollQueue.Reset() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=0 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.6693 E:14 Microsoft.EntityFrameworkCore.Database.Command Failed executing DbCommand (4,077ms) [Parameters=[@p2='?' (DbType = Int32), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='60'] SET NOCOUNT ON; UPDATE [Task] SET [LastRunTime] = @p0, [StartDateTime] = @p1 WHERE [Id] = @p2; SELECT @@ROWCOUNT; 2022-02-07 14:55:43.6863 E:14 Microsoft.EntityFrameworkCore.Update An exception occurred in the database while saving changes for context type 'Lers.Dal.LersDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) ClientConnectionId:76049176-cf71-4e02-ada8-d8dc187f2380 --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 1. [Microsoft.EntityFrameworkCore.Relational] Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. Стек вызовов: at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) HResult:-2146233088 -------------------------------------------------------------------------------------- 2. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Стек вызовов: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=0 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.6863 E:8 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 14:55:43.6863 E:8 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Выполняется команда SHUTDOWN. Пользователю "EPTS2\LERSSERVERACCOUNT" не удалось войти в систему. В настоящий момент к серверу могут подключаться только администраторы. at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:8ed572be-55c2-4f8c-9554-72873d46b190 Error Number:6005,State:1,Class:14 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: Выполняется команда SHUTDOWN. Пользователю "EPTS2\LERSSERVERACCOUNT" не удалось войти в систему. В настоящий момент к серверу могут подключаться только администраторы. Стек вызовов: at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=6005 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.7003 F:14 Lers.ExceptionHandler Ошибка сохранения в БД состояния задания System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1+AsyncStateMachineBox`1[Lers.Models.ServerTask,Lers.Tasks.TaskScheduler+d__14] A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. Проверьте соединение сервера ЛЭРС УЧЕТ с SQL-сервером. 2022-02-07 14:55:43.7313 E:14 Microsoft.EntityFrameworkCore.Database.Connection An error occurred using the connection to database 'LERS' on server '(local)\LERS'. 2022-02-07 14:55:43.7313 E:14 Microsoft.EntityFrameworkCore.Query An exception occurred while iterating over the results of a query for context type 'Lers.Dal.LersDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Выполняется команда SHUTDOWN. Пользователю "EPTS2\LERSSERVERACCOUNT" не удалось войти в систему. В настоящий момент к серверу могут подключаться только администраторы. at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() ClientConnectionId:8ed572be-55c2-4f8c-9554-72873d46b190 Error Number:6005,State:1,Class:14 1. [Core Microsoft SqlClient Data Provider] Microsoft.Data.SqlClient.SqlException: Выполняется команда SHUTDOWN. Пользователю "EPTS2\LERSSERVERACCOUNT" не удалось войти в систему. В настоящий момент к серверу могут подключаться только администраторы. Стек вызовов: at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() HResult:-2146232060 Дополнительная информация (Data): HelpLink.ProdName=Microsoft SQL Server HelpLink.EvtSrc=MSSQLServer HelpLink.EvtID=6005 HelpLink.BaseHelpUrl=https://go.microsoft.com/fwlink HelpLink.LinkId=20476 Дополнительная информация из ExternalException: HRESULT=0x80131904 -------------------------------------------------------------------------------------- 2022-02-07 14:55:43.7313 F:14 Lers.ExceptionHandler Ошибка сохранения в БД состояния задания System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1+AsyncStateMachineBox`1[Lers.Models.ServerTask,Lers.Tasks.TaskScheduler+d__14] При обращении к базе данных произошла ошибка: Выполняется команда SHUTDOWN. Пользователю "EPTS2\LERSSERVERACCOUNT" не удалось войти в систему. В настоящий момент к серверу могут подключаться только администраторы. Проверьте соединение сервера ЛЭРС УЧЕТ с SQL-сервером. 2022-02-07 14:56:16.7253 E:1 Lers.Server.Program ============================================ 2022-02-07 14:56:16.8323 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 14:56:16.8323 E:1 Lers.Server.Program ============================================ 2022-02-07 15:03:46.8396 E:1 Lers.Server.Program ============================================ 2022-02-07 15:03:46.9617 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 15:03:46.9617 E:1 Lers.Server.Program ============================================ 2022-02-07 15:05:53.9984 E:1 Lers.Server.Program ============================================ 2022-02-07 15:05:54.0764 E:1 Lers.Server.Program === Сервер запущен 2022-02-07 15:05:54.0764 E:1 Lers.Server.Program ============================================ 2022-02-07 15:11:08.8468 E:53 Lers.Server.ExceptionFilter Ошибка выполнения запроса POST http://91.197.189.194:10000/api/v0.1/Poll/ManualPoll/Archive/2022-02-07T15:11:52/2022-02-07T15:11:52. Опрос невозможен, т.к. GPRS-контроллер БАРС-02 (многопортовый) #Мардж_16 не подключен. Если контроллер поддерживает вызов, настройте его в параметрах GPRS-подключения. [ЛЭРС УЧЁТ - Мобильное приложение Android] 00-c22dfec694ae37499156546cdf10a0b0-651ab2ead2241c40-00