Не запускается служба сервер ЛЭРС УЧЁТ после обновления 3.62.0 [16174]

LipazzZ · 01.Июль.2025 03:52:17

После обновления перестала запускаться служба лерс server
Версия ЛЭРС УЧЁТ:
Сервер БД: SQL Server / PostgreSQL

korotkih · 01.Июль.2025 04:06:16

Попробуйте ещё раз запустить службу сервера вручную. Если попытка будет неудачной, тогда приложите журнала работы службы сервера.

LipazzZ · 01.Июль.2025 06:18:26

2025-07-01 16:10:49.8602	W:1	Microsoft.EntityFrameworkCore.Model.Validation	No store type was specified for the decimal property 'Price' on entity type 'SupplierTariff'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType', specify precision and scale using 'HasPrecision', or configure a value converter using 'HasConversion'.		
2025-07-01 16:10:50.4400	I:1	DevExpress.AspNetCore.Reporting.Logger	AspNetCoreThreadingTimerStoragesCleaner.StartCore
		
2025-07-01 16:10:50.4536	E:1	Lers.Server	============================================		
2025-07-01 16:10:50.4536	E:1	Lers.Server	=== Сервер запущен		
2025-07-01 16:10:50.4536	E:1	Lers.Server	============================================		
2025-07-01 16:10:50.6106	I:11	Lers.Server.BackgroundServices.StartupBackgroundService	Проверка подключения к серверу БД.		
2025-07-01 16:10:50.7629	I:11	Lers.Server.BackgroundServices.StartupBackgroundService	Сервер БД активен.		
2025-07-01 16:10:52.2139	E:10	Microsoft.Extensions.Hosting.Internal.Host	Hosting failed to start	1. [Lers.Dal] System.NullReferenceException: Object reference not set to an instance of an object.

Стек вызовов:
   at Lers.Dal.SystemParametersDataAccess.CorrectDataParameterId(SystemsBadValuesThresholds thresholds)
   at Lers.Dal.SystemParametersDataAccess.LoadJsonSerializedParameters(SystemParameters systemParameters)
   at Lers.Dal.SystemParametersDataAccess.GetSystemParameters()
   at Lers.Administration.SystemParameters.Load(SystemParametersDataAccess dal)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_0(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.CreateServiceAccessor(ServiceIdentifier serviceIdentifier)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_1(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.ConstructorMatcher.CreateInstance(IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProvider provider, Type instanceType, Object[] parameters)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance[T](IServiceProvider provider, Object[] parameters)
   at Lers.Server.BackgroundServices.StartupBackgroundService.ExecuteAsync(CancellationToken stoppingToken)
   at Lers.Server.BackgroundServices.StartupBackgroundService.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)
   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)

HResult:-2147467261
--------------------------------------------------------------------------------------
	
2025-07-01 16:10:52.2139	W:11	Lers.Server.BackgroundServices.DiagBackgroundService	Прекращён фоновый анализ данных из-за остановки сервера.		
2025-07-01 16:10:52.2139	F:10	Lers.Server	Сервер остановился с ошибкой	1. [Lers.Dal] System.NullReferenceException: Object reference not set to an instance of an object.

Стек вызовов:
   at Lers.Dal.SystemParametersDataAccess.CorrectDataParameterId(SystemsBadValuesThresholds thresholds)
   at Lers.Dal.SystemParametersDataAccess.LoadJsonSerializedParameters(SystemParameters systemParameters)
   at Lers.Dal.SystemParametersDataAccess.GetSystemParameters()
   at Lers.Administration.SystemParameters.Load(SystemParametersDataAccess dal)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_0(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.CreateServiceAccessor(ServiceIdentifier serviceIdentifier)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_1(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.ConstructorMatcher.CreateInstance(IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProvider provider, Type instanceType, Object[] parameters)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance[T](IServiceProvider provider, Object[] parameters)
   at Lers.Server.BackgroundServices.StartupBackgroundService.ExecuteAsync(CancellationToken stoppingToken)
   at Lers.Server.BackgroundServices.StartupBackgroundService.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)
   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)
   at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
   at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
   at Program.<Main>$(String[] args)

HResult:-2147467261
--------------------------------------------------------------------------------------
	
2025-07-01 16:11:03.0443	W:1	Microsoft.EntityFrameworkCore.Model.Validation	No store type was specified for the decimal property 'Price' on entity type 'SupplierTariff'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType', specify precision and scale using 'HasPrecision', or configure a value converter using 'HasConversion'.		
2025-07-01 16:11:03.6147	I:1	DevExpress.AspNetCore.Reporting.Logger	AspNetCoreThreadingTimerStoragesCleaner.StartCore
		
2025-07-01 16:11:03.6275	E:1	Lers.Server	============================================		
2025-07-01 16:11:03.6275	E:1	Lers.Server	=== Сервер запущен		
2025-07-01 16:11:03.6275	E:1	Lers.Server	============================================		
2025-07-01 16:11:03.7794	I:9	Lers.Server.BackgroundServices.StartupBackgroundService	Проверка подключения к серверу БД.		
2025-07-01 16:11:03.9295	I:9	Lers.Server.BackgroundServices.StartupBackgroundService	Сервер БД активен.		
2025-07-01 16:11:05.3336	E:9	Microsoft.Extensions.Hosting.Internal.Host	Hosting failed to start	1. [Lers.Dal] System.NullReferenceException: Object reference not set to an instance of an object.

Стек вызовов:
   at Lers.Dal.SystemParametersDataAccess.CorrectDataParameterId(SystemsBadValuesThresholds thresholds)
   at Lers.Dal.SystemParametersDataAccess.LoadJsonSerializedParameters(SystemParameters systemParameters)
   at Lers.Dal.SystemParametersDataAccess.GetSystemParameters()
   at Lers.Administration.SystemParameters.Load(SystemParametersDataAccess dal)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_0(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.CreateServiceAccessor(ServiceIdentifier serviceIdentifier)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_1(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.ConstructorMatcher.CreateInstance(IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProvider provider, Type instanceType, Object[] parameters)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance[T](IServiceProvider provider, Object[] parameters)
   at Lers.Server.BackgroundServices.StartupBackgroundService.ExecuteAsync(CancellationToken stoppingToken)
   at Lers.Server.BackgroundServices.StartupBackgroundService.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)
   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)

HResult:-2147467261
--------------------------------------------------------------------------------------
	
2025-07-01 16:11:05.3336	W:7	Lers.Server.BackgroundServices.DiagBackgroundService	Прекращён фоновый анализ данных из-за остановки сервера.		
2025-07-01 16:11:05.3336	F:9	Lers.Server	Сервер остановился с ошибкой	1. [Lers.Dal] System.NullReferenceException: Object reference not set to an instance of an object.

Стек вызовов:
   at Lers.Dal.SystemParametersDataAccess.CorrectDataParameterId(SystemsBadValuesThresholds thresholds)
   at Lers.Dal.SystemParametersDataAccess.LoadJsonSerializedParameters(SystemParameters systemParameters)
   at Lers.Dal.SystemParametersDataAccess.GetSystemParameters()
   at Lers.Administration.SystemParameters.Load(SystemParametersDataAccess dal)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_0(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.CreateServiceAccessor(ServiceIdentifier serviceIdentifier)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Lers.DependencyInjection.Extensions.ConfigureAdministrationDependencyInjection.<>c.<AddAdministration>b__0_1(IServiceProvider s)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.ConstructorMatcher.CreateInstance(IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProvider provider, Type instanceType, Object[] parameters)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance[T](IServiceProvider provider, Object[] parameters)
   at Lers.Server.BackgroundServices.StartupBackgroundService.ExecuteAsync(CancellationToken stoppingToken)
   at Lers.Server.BackgroundServices.StartupBackgroundService.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)
   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)
   at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
   at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
   at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
   at Program.<Main>$(String[] args)

HResult:-2147467261
--------------------------------------------------------------------------------------
[server_error.2025-07-01.log|attachment](upload://amldO6a2OLeFgptpEBemq5jIwFH.log) (6,7 МБ)

korotkih · 01.Июль.2025 06:40:59

Запустите командную строку или командную оболочку PowerShell.

Для командной строки нужно выполнить sqlcmd.exe -S “(local)\LERS” -d LERS -E -I -Q “SELECT BadValuesThreshold_SystemsBadValuesThresholdsSerialized FROM SystemParameters” -y 0

Для командной оболочки PowerShell нужно выполнить sqlcmd.exe -S ‘(local)\LERS’ -d LERS -E -I -Q “SELECT BadValuesThreshold_SystemsBadValuesThresholdsSerialized FROM SystemParameters” -y 0

Покажите результат работы выполненной команды.

LipazzZ · 01.Июль.2025 07:33:29

PS C:\Users\Server01> sqlcmd.exe -S “(local)\LERS” -d LERS -E -I -Q “SELECT BadValuesThreshold_SystemsBadValuesThresholdsSerialized FROM SystemParameters” -y 0
{"SteamBadValuesThreshold":{"SystemType":8,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":500.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":100000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"HeatBadValuesThreshold":{"SystemType":1,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":150.0},{"DataParameter":2,"Low":0.0,"High":150.0},{"DataParameter":47,"Low":0.0,"High":150.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":6,"Low":"NaN","High":1000000.0},{"DataParameter":50,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":-50.0,"High":50.0},{"DataParameter":13,"Low":-50.0,"High":50.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":8,"Low":"NaN","High":1000000.0},{"DataParameter":49,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":1000000.0},{"DataParameter":10,"Low":-1000.0,"High":100000.0},{"DataParameter":11,"Low":-1000.0,"High":100000.0}]},"HotWaterBadValuesThreshold":{"SystemType":2,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":150.0},{"DataParameter":2,"Low":0.0,"High":150.0},{"DataParameter":47,"Low":0.0,"High":150.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":6,"Low":"NaN","High":1000000.0},{"DataParameter":50,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0},{"DataParameter":13,"Low":0.9786,"High":50.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":8,"Low":"NaN","High":1000000.0},{"DataParameter":49,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":100000.0},{"DataParameter":10,"Low":-1000.0,"High":100000.0},{"DataParameter":11,"Low":-1000.0,"High":100000.0}]},"ColdWaterBadValuesThreshold":{"SystemType":4,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"SewageBadValuesThreshold":{"SystemType":64,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"GasBadValuesThreshold":{"SystemType":16,"ConsumptionBadValuesThresholds":[{"DataParameter":16,"Low":-50.0,"High":200.0},{"DataParameter":17,"Low":1.0,"High":16.0},{"DataParameter":18,"Low":"NaN","High":10000000.0},{"DataParameter":19,"Low":"NaN","High":1000000000.0},{"DataParameter":51,"Low":"NaN","High":10000000.0}]},"ElectricityBadValuesThreshold":{"SystemType":32,"ElectricityQualityBadValuesThresholds":[{"DataParameter":88,"Low":-1.0,"High":1.0},{"DataParameter":89,"Low":-1.0,"High":1.0},{"DataParameter":90,"Low":-1.0,"High":1.0},{"DataParameter":91,"Low":-1.0,"High":1.0}],"ConsumptionBadValuesThresholds":[{"DataParameter":20,"Low":0.0,"High":1000000.0},{"DataParameter":24,"Low":0.0,"High":1000000.0},{"DataParameter":28,"Low":0.0,"High":1000000.0},{"DataParameter":32,"Low":0.0,"High":1000000.0},{"DataParameter":21,"Low":0.0,"High":1000000.0},{"DataParameter":25,"Low":0.0,"High":1000000.0},{"DataParameter":29,"Low":0.0,"High":1000000.0},{"DataParameter":33,"Low":0.0,"High":1000000.0},{"DataParameter":36,"Low":0.0,"High":4000000.0},{"DataParameter":37,"Low":0.0,"High":4000000.0},{"DataParameter":22,"Low":0.0,"High":1000000.0},{"DataParameter":26,"Low":0.0,"High":1000000.0},{"DataParameter":30,"Low":0.0,"High":1000000.0},{"DataParameter":34,"Low":0.0,"High":1000000.0},{"DataParameter":23,"Low":0.0,"High":1000000.0},{"DataParameter":27,"Low":0.0,"High":1000000.0},{"DataParameter":31,"Low":0.0,"High":1000000.0},{"DataParameter":35,"Low":0.0,"High":1000000.0},{"DataParameter":38,"Low":0.0,"High":4000000.0},{"DataParameter":39,"Low":0.0,"High":4000000.0}]}}

(обработано строк: 1)
PS C:\Users\Server01> sqlcmd.exe -S ‘(local)\LERS’ -d LERS -E -I -Q “SELECT BadValuesThreshold_SystemsBadValuesThresholdsSerialized FROM SystemParameters” -y 0
{"SteamBadValuesThreshold":{"SystemType":8,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":500.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":100000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"HeatBadValuesThreshold":{"SystemType":1,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":150.0},{"DataParameter":2,"Low":0.0,"High":150.0},{"DataParameter":47,"Low":0.0,"High":150.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":6,"Low":"NaN","High":1000000.0},{"DataParameter":50,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":-50.0,"High":50.0},{"DataParameter":13,"Low":-50.0,"High":50.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":8,"Low":"NaN","High":1000000.0},{"DataParameter":49,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":1000000.0},{"DataParameter":10,"Low":-1000.0,"High":100000.0},{"DataParameter":11,"Low":-1000.0,"High":100000.0}]},"HotWaterBadValuesThreshold":{"SystemType":2,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":150.0},{"DataParameter":2,"Low":0.0,"High":150.0},{"DataParameter":47,"Low":0.0,"High":150.0},{"DataParameter":3,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":6,"Low":"NaN","High":1000000.0},{"DataParameter":50,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0},{"DataParameter":13,"Low":0.9786,"High":50.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":8,"Low":"NaN","High":1000000.0},{"DataParameter":49,"Low":"NaN","High":1000000.0},{"DataParameter":9,"Low":-1000.0,"High":100000.0},{"DataParameter":10,"Low":-1000.0,"High":100000.0},{"DataParameter":11,"Low":-1000.0,"High":100000.0}]},"ColdWaterBadValuesThreshold":{"SystemType":4,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"SewageBadValuesThreshold":{"SystemType":64,"ConsumptionBadValuesThresholds":[{"DataParameter":1,"Low":0.0,"High":50.0},{"DataParameter":4,"Low":-59.5,"High":60.0},{"DataParameter":5,"Low":"NaN","High":1000000.0},{"DataParameter":7,"Low":"NaN","High":1000000.0},{"DataParameter":12,"Low":0.9786,"High":50.0}]},"GasBadValuesThreshold":{"SystemType":16,"ConsumptionBadValuesThresholds":[{"DataParameter":16,"Low":-50.0,"High":200.0},{"DataParameter":17,"Low":1.0,"High":16.0},{"DataParameter":18,"Low":"NaN","High":10000000.0},{"DataParameter":19,"Low":"NaN","High":1000000000.0},{"DataParameter":51,"Low":"NaN","High":10000000.0}]},"ElectricityBadValuesThreshold":{"SystemType":32,"ElectricityQualityBadValuesThresholds":[{"DataParameter":88,"Low":-1.0,"High":1.0},{"DataParameter":89,"Low":-1.0,"High":1.0},{"DataParameter":90,"Low":-1.0,"High":1.0},{"DataParameter":91,"Low":-1.0,"High":1.0}],"ConsumptionBadValuesThresholds":[{"DataParameter":20,"Low":0.0,"High":1000000.0},{"DataParameter":24,"Low":0.0,"High":1000000.0},{"DataParameter":28,"Low":0.0,"High":1000000.0},{"DataParameter":32,"Low":0.0,"High":1000000.0},{"DataParameter":21,"Low":0.0,"High":1000000.0},{"DataParameter":25,"Low":0.0,"High":1000000.0},{"DataParameter":29,"Low":0.0,"High":1000000.0},{"DataParameter":33,"Low":0.0,"High":1000000.0},{"DataParameter":36,"Low":0.0,"High":4000000.0},{"DataParameter":37,"Low":0.0,"High":4000000.0},{"DataParameter":22,"Low":0.0,"High":1000000.0},{"DataParameter":26,"Low":0.0,"High":1000000.0},{"DataParameter":30,"Low":0.0,"High":1000000.0},{"DataParameter":34,"Low":0.0,"High":1000000.0},{"DataParameter":23,"Low":0.0,"High":1000000.0},{"DataParameter":27,"Low":0.0,"High":1000000.0},{"DataParameter":31,"Low":0.0,"High":1000000.0},{"DataParameter":35,"Low":0.0,"High":1000000.0},{"DataParameter":38,"Low":0.0,"High":4000000.0},{"DataParameter":39,"Low":0.0,"High":4000000.0}]}}

korotkih · 01.Июль.2025 08:03:48

Скачайте файл и разархивируйте его на диск C:.
Запустите командную строку и выполните команду sqlcmd.exe -S “(local)\LERS” -d LERS -i C:\update.sql
Перезапустите службу Сервер ЛЭРС УЧЁТ и сообщите результат.

korotkih · 01.Июль.2025 08:10:09

@LipazzZ скрипт скинул вам в личку, поскольку он подойдёт только для вашего сервера.

LipazzZ · 01.Июль.2025 12:21:47

C:\Users\Server01>sqlcmd.exe -S “(local)\LERS” -d LERS -i C:\update.sql
Sqlcmd: ошибка - Microsoft ODBC Driver 17 for SQL Server: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. .
Sqlcmd: ошибка - Microsoft ODBC Driver 17 for SQL Server: Login timeout expired.
Sqlcmd: ошибка - Microsoft ODBC Driver 17 for SQL Server: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

korotkih · 02.Июль.2025 03:07:54

Проверьте, запущен ли у Вас SQL Server.

korotkih · 02.Июль.2025 03:09:44

Сегодня мы опубликуем обновление 3.62.1, в котором будет исправление. Вы сможете установить обновление и тогда не потребуется выполнять скрипт. После установки обновления сообщите результат.

lersbot · 02.Июль.2025 05:09:43

Добрый день!

Обновление 3.62.1 (сборка 36207) от 02.07.2025 доступно для установки.

lersbot · 07.Июль.2025 08:13:45

Добрый день!

Обновление 3.62.1 (сборка 36207) от 07.07.2025 доступно для установки.