PowerShell Universal - 3.8.1

PowerShell Universal - 3.8.1

Release Notes

Dashboards

  • Fixed an issue where New-UDNivoChart was missing an alias for the renamed parameter -CirclePacking (-Bubble)
  • Fixed an issue where New-UDNivoChart -OnClick did not work

Platform

  • Fixed an issue where licensing would not work for online licenses (#2183)
  • Fixed an issue where resources, like dashboards, would reload with each git sync (#2184)

Downloads

2 Likes

I now get this in PUD:


yes it’s then i manually run it from the command line, but it dont throw any error if run from the normal launcher.
well except that webview cant connect to localhost:5000

OK I installed the following into the install folder:

and it now work

I opened an issue for this here: Missing Files in PSU Desktop Installer · Issue #2187 · ironmansoftware/issues · GitHub

Good afternoon… Just performed a “Manual” Zip upgrade to our 3.7.4 IIS instance…
Steps:
backedup Appsettings & web.config
Deleted IIS PSU folder
Expanded new IIS PSU Zip to wwwroot sub folder PowershellUniversal
ran unblockfile commandlet
Copied Appsettings & web config to folder
Started IIS

When I reach the login screen and enter the User/Password, click login nothing happens. Conversely if I enter the incorrect credentials the system gives back a U/P error.

Here are some logs…

[12:07:51 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[12:07:51 INF] Executing endpoint 'UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server)'
[12:07:51 INF] Route matched with {action = "SignIn", controller = "Authentication"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SignIn(UniversalDashboard.Controllers.Credential) on controller UniversalDashboard.Controllers.AuthenticationController (Universal.Server).
[12:07:51 INF] Executed action UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server) in 4.758ms
[12:07:51 INF] Executed endpoint 'UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server)'
[12:07:51 ERR] An unhandled exception has occurred while executing the request.
System.InvalidOperationException: Sequence contains no elements
   at System.Linq.ThrowHelper.ThrowNoElementsException()
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at PowerShellUniversal.MemoryTable`1.First() in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal\MemoryTable.cs:line 45
   at Universal.Server.Services.ClaimsEvaluator.EvaluateAsync(ClaimsPrincipal principal, HttpContext httpContext, Boolean cache, String userInfo) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\Authentication\ClaimsEvaluator.cs:line 59
   at Universal.Server.Startup.<>c.<<ConfigureServices>b__6_21>d.MoveNext() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Startup.cs:line 216
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleSignInAsync(ClaimsPrincipal user, AuthenticationProperties properties)
   at Microsoft.AspNetCore.Authentication.AuthenticationService.SignInAsync(HttpContext context, String scheme, ClaimsPrincipal principal, AuthenticationProperties properties)
   at UniversalDashboard.Controllers.AuthenticationController.Authorize(AuthenticationResult result) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Controllers\AuthenticationController.cs:line 249
   at UniversalDashboard.Controllers.AuthenticationController.SignIn(Credential credential) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Controllers\AuthenticationController.cs:line 173
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>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.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at PowerShellUniversal.FeatureMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Middleware\FeatureMiddleware.cs:line 43
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at PowerShellUniversal.DisallowedModeMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Middleware\ModeMiddleware.cs:line 47
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Universal.Server.Middleware.RoutingMiddleware.Invoke(HttpContext httpContext, IPolicyEvaluator policyEvaluator) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Middleware\RoutingMiddleware.cs:line 201
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Universal.Server.Middleware.SwaggerAuthenticationMiddleware.InvokeAsync(HttpContext context, RequestDelegate next) in C:\actions-runner\_work\universal\universal\src\Universal.Server\Middleware\SwaggerAuthMiddleware.cs:line 37
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at AspNetCoreRateLimit.RateLimitMiddleware`1.Invoke(HttpContext context) in C:\actions-runner\_work\universal\universal\src\AspNetCoreRateLimit\Middleware\RateLimitMiddleware.cs:line 109
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
[12:07:51 INF] Request finished HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/api/v1/signin application/json 47 - 500 - text/plain 15.6041ms
[12:07:51 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[12:07:51 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.

Accidentally deleted my original comment…

Seeing this issue after manually upgrading IIS from 3.7.4 to 3.8.1

Login screen does not do anything after entering correct user name and password. However if you enter incorrect creds it does say they are invalid credentials.
Log info… (2 sections in same box)

[12:05:19 INF] Application started. Press Ctrl+C to shut down.
[12:05:19 INF] Hosting environment: Production
[12:05:19 INF] Content root path: C:\inetpub\wwwroot\PowershellUniversal
[12:05:19 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/ - -
[12:05:19 INF] Server eclwswd00027:6780:3c705a3f successfully announced in 10.4691 ms
[12:05:19 INF] Server eclwswd00027:6780:3c705a3f is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, SqlServerHeartbeatProcess, Worker, DelayedJobScheduler, RecurringJobScheduler...
[12:05:19 ERR] Connection ID "17870283323016740865", Request ID "80000011-0000-f800-b63f-84710c7967bb": An unhandled exception was thrown by the application.
System.ArgumentException: Options.ClientId must be provided (Parameter 'ClientId')
   at Microsoft.AspNetCore.Authentication.OpenIdConnect.OpenIdConnectOptions.Validate()
   at Microsoft.AspNetCore.Authentication.RemoteAuthenticationOptions.Validate(String scheme)
   at Microsoft.AspNetCore.Authentication.AuthenticationBuilder.<>c__DisplayClass4_0`2.<AddSchemeHelper>b__1(TOptions o)
   at Microsoft.Extensions.Options.ValidateOptions`1.Validate(String name, TOptions options)
   at Microsoft.Extensions.Options.OptionsFactory`1.Create(String name)
   at Microsoft.Extensions.Options.OptionsMonitor`1.<>c__DisplayClass10_0.<Get>b__0()
   at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
   at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.get_Value()
   at Microsoft.Extensions.Options.OptionsCache`1.GetOrAdd(String name, Func`1 createOptions)
   at Microsoft.Extensions.Options.OptionsMonitor`1.Get(String name)
   at Microsoft.AspNetCore.Authentication.AuthenticationHandler`1.InitializeAsync(AuthenticationScheme scheme, HttpContext context)
   at Microsoft.AspNetCore.Authentication.AuthenticationHandlerProvider.GetHandlerAsync(HttpContext context, String authenticationScheme)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Server.IIS.Core.IISHttpContextOfT`1.ProcessRequestAsync()
[12:05:19 INF] Server eclwswd00027:6780:3c705a3f all the dispatchers started

2nd Section

12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/loginPage - -
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[12:05:25 INF] Executing endpoint 'Universal.Server.Services.VersionController.Get (Universal.Server)'
[12:05:25 INF] Route matched with {action = "Get", controller = "Version"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Get() on controller Universal.Server.Services.VersionController (Universal.Server).
[12:05:25 INF] Executing endpoint 'UniversalAutomation.LoginPageController.Get (Universal.Server)'
[12:05:25 INF] Executing OkObjectResult, writing value of type 'System.String'.
[12:05:25 INF] Route matched with {action = "Get", controller = "LoginPage"}. Executing controller action with signature PowerShellUniversal.LoginPage Get() on controller UniversalAutomation.LoginPageController (Universal.Server).
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Executed action Universal.Server.Services.VersionController.Get (Universal.Server) in 8.0706ms
[12:05:25 INF] Executed endpoint 'Universal.Server.Services.VersionController.Get (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/version - - - 200 - text/plain;+charset=utf-8 41.1157ms
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/sso - -
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 50.4307ms
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/version/build - -
[12:05:25 INF] Executing endpoint 'UniversalDashboard.Controllers.AuthenticationController.SingleSignOn (Universal.Server)'
[12:05:25 INF] Executing endpoint 'Universal.Server.Services.VersionController.GetBuildVersion (Universal.Server)'
[12:05:25 INF] Route matched with {action = "GetBuildVersion", controller = "Version"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult GetBuildVersion() on controller Universal.Server.Services.VersionController (Universal.Server).
[12:05:25 INF] Route matched with {action = "SingleSignOn", controller = "Authentication"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult SingleSignOn() on controller UniversalDashboard.Controllers.AuthenticationController (Universal.Server).
[12:05:25 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType18`1[[System.String, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.
[12:05:25 INF] Executing JsonResult, writing value of type '<>f__AnonymousType4`1[[System.Boolean, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.
[12:05:25 INF] Executed action UniversalDashboard.Controllers.AuthenticationController.SingleSignOn (Universal.Server) in 15.1372ms
[12:05:25 INF] Executed action Universal.Server.Services.VersionController.GetBuildVersion (Universal.Server) in 15.389ms
[12:05:25 INF] Executed endpoint 'UniversalDashboard.Controllers.AuthenticationController.SingleSignOn (Universal.Server)'
[12:05:25 INF] Executed endpoint 'Universal.Server.Services.VersionController.GetBuildVersion (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/sso - - - 200 - application/json;+charset=utf-8 30.3724ms
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/version/build - - - 200 - application/json;+charset=utf-8 21.1254ms
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/alive - -
[12:05:25 INF] Executing endpoint 'UniversalAutomation.AliveController.Get (Universal.Server)'
[12:05:25 INF] Route matched with {action = "Get", controller = "Alive"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Get() on controller UniversalAutomation.AliveController (Universal.Server).
[12:05:25 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType1`3[[System.Boolean, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Boolean, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.String, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.
[12:05:25 INF] Executed action UniversalAutomation.AliveController.Get (Universal.Server) in 7.1407ms
[12:05:25 INF] Executed endpoint 'UniversalAutomation.AliveController.Get (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/alive - - - 200 - application/json;+charset=utf-8 13.5237ms
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/accessible - -
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/version/update - -
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/accessible - - - 401 - - 11.7973ms
[12:05:25 INF] Executing endpoint 'Universal.Server.Services.VersionController.GetUpdate (Universal.Server)'
[12:05:25 INF] Route matched with {action = "GetUpdate", controller = "Version"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult GetUpdate() on controller Universal.Server.Services.VersionController (Universal.Server).
[12:05:25 INF] Executing JsonResult, writing value of type 'PowerShellUniversal.Update'.
[12:05:25 INF] Executed action Universal.Server.Services.VersionController.GetUpdate (Universal.Server) in 4.6324ms
[12:05:25 INF] Executed endpoint 'Universal.Server.Services.VersionController.GetUpdate (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/version/update - - - 200 - application/json;+charset=utf-8 10.9984ms
[12:05:25 INF] Executing ObjectResult, writing value of type 'PowerShellUniversal.LoginPage'.
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/settings/public - -
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/license/feature - -
[12:05:25 INF] Executed action UniversalAutomation.LoginPageController.Get (Universal.Server) in 95.9899ms
[12:05:25 INF] Executed endpoint 'UniversalAutomation.LoginPageController.Get (Universal.Server)'
[12:05:25 INF] Executing endpoint 'Universal.Server.Controllers.LicenseController.GetLicensedFeatures (Universal.Server)'
[12:05:25 INF] Executing endpoint 'UniversalAutomation.SettingsController.GetPublic (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/loginPage - - - 200 - application/json;+charset=utf-8 128.3003ms
[12:05:25 INF] Route matched with {action = "GetLicensedFeatures", controller = "License"}. Executing controller action with signature System.Collections.Generic.IEnumerable`1[UniversalAutomation.Common.Interfaces.Feature] GetLicensedFeatures() on controller Universal.Server.Controllers.LicenseController (Universal.Server).
[12:05:25 INF] Route matched with {action = "GetPublic", controller = "Settings"}. Executing controller action with signature System.Collections.Generic.IEnumerable`1[PowerShellUniversal.Settings] GetPublic() on controller UniversalAutomation.SettingsController (Universal.Server).
[12:05:25 INF] Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[UniversalAutomation.Common.Interfaces.Feature, PowerShellUniversal, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'.
[12:05:25 INF] Executing ObjectResult, writing value of type 'PowerShellUniversal.Settings[]'.
[12:05:25 INF] Executed action Universal.Server.Controllers.LicenseController.GetLicensedFeatures (Universal.Server) in 6.016ms
[12:05:25 INF] Executed endpoint 'Universal.Server.Controllers.LicenseController.GetLicensedFeatures (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/license/feature - - - 200 - application/json;+charset=utf-8 12.7961ms
[12:05:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/gitstatus/edit - -
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[12:05:25 INF] AuthenticationScheme: Cookies was challenged.
[12:05:25 INF] AuthenticationScheme: Bearer was challenged.
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/gitstatus/edit - - - 401 - - 11.3043ms
[12:05:25 INF] Executed action UniversalAutomation.SettingsController.GetPublic (Universal.Server) in 25.2128ms
[12:05:25 INF] Executed endpoint 'UniversalAutomation.SettingsController.GetPublic (Universal.Server)'
[12:05:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/settings/public - - - 200 - application/json;+charset=utf-8 32.5687ms
[12:05:25 ERR] Failure configuring Universal. Some settings from your configuration files may not be applied.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'RunId'.
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__19_0(DbContext _, Enumerator enumerator)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass31_0`2.<Execute>b__0(DbContext context, TState state)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   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 PowerShellUniversal.SQL.SqlTable`1.<>c.<ToArray>b__18_0(IQueryable`1 m) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 592
   at PowerShellUniversal.SQL.SqlTable`1.DisposeAfterCall[X](Func`2 call) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 652
   at PowerShellUniversal.SQL.SqlTable`1.ToArray() in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 592
   at PowerShellUniversal.SQL.Database.FailOrphanedJobs() in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 0
   at UniversalAutomation.StartupService.RunStartup() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\StartupService.cs:line 256
ClientConnectionId:adee1878-a7f0-41ac-a53c-610b7e37e1fc
Error Number:207,State:1,Class:16
[12:05:25 INF] Running git sync, if configured.
[12:05:25 INF] Scheduling git sync service.
[12:05:25 INF] Scheduling heartbeat job.
[12:05:25 INF] Scheduling update check.
[12:05:25 INF] Starting security proxy.

We are validating a fix for this SQL issue and added a note to the changelog in the meantime.

1 Like