Good evening. Still seeing the same issue with login after upgrading from 3.7.4 IIS/SQL install to 3.8.2.
Login page “works” as far as authenticating it seems, since if we put in the wrong password it throws a wrong password error.
Below a chunk of the log.
[21:33:28 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:33:28 INF] AuthenticationScheme: Cookies was challenged.
[21:33:28 INF] AuthenticationScheme: Bearer was challenged.
[21:33:28 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 16.6646ms
[21:34:06 INF] Starting heartbeat job.
[21:34:06 INF] Starting groom job.
[21:34:06 WRN] Settings not populated yet. Skipping groom.
[21:34:06 INF] Starting heartbeat job.
[21:34:06 ERR] Failed to groom.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UserSessions'.
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.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(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 Microsoft.EntityFrameworkCore.DbContext.RemoveRange(IEnumerable`1 entities)
at PowerShellUniversal.SQL.SqlTable`1.DeleteRange(Func`2 query) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 669
at UniversalAutomation.GroomService.GroomSessions() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\GroomService.cs:line 68
at UniversalAutomation.GroomService.Groom() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\GroomService.cs:line 272
ClientConnectionId:a17eef53-0f77-4cb9-9d51-520304a1c385
Error Number:208,State:1,Class:16
[21:34:06 INF] Finished groom job.
[21:34:06 INF] Finished heartbeat job.
[21:34:06 INF] Finished heartbeat job.
[21:34:21 INF] Request starting HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/notificationhub/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0
[21:34:21 INF] CORS policy execution failed.
[21:34:21 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[21:34:21 INF] Executing endpoint '/notificationhub/negotiate'
[21:34:21 INF] Executed endpoint '/notificationhub/negotiate'
[21:34:21 INF] Request finished HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/notificationhub/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0 - 200 - application/json 18.3278ms
[21:34:21 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/notificationhub?id=6_xoXrlzvuKwNEM46NHmgg - -
[21:34:21 INF] CORS policy execution failed.
[21:34:21 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[21:34:21 INF] Executing endpoint '/notificationhub'
[21:34:22 ERR] Error when dispatching 'OnConnectedAsync' on hub.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UserSessions'.
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.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
ClientConnectionId:4af22b7f-07a4-46f4-b1d5-c8bedef0fb87
Error Number:208,State:1,Class:16
--- 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(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
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.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
at PowerShellUniversal.SQL.SqlTable`1.Insert(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 554
at UniversalDashboard.NotificationHub.OnConnectedAsync() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Hubs\NotificationHub.cs:line 225
at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
at Microsoft.AspNetCore.SignalR.HubConnectionHandler`1.RunHubAsync(HubConnectionContext connection)
[21:34:22 INF] Executed endpoint '/notificationhub'
[21:34:22 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/notificationhub?id=6_xoXrlzvuKwNEM46NHmgg - - - 101 - - 251.7787ms
[21:34:24 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:24 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:24 INF] AuthenticationScheme: Cookies was challenged.
[21:34:24 INF] AuthenticationScheme: Bearer was challenged.
[21:34:24 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:24 INF] AuthenticationScheme: Cookies was challenged.
[21:34:24 INF] AuthenticationScheme: Bearer was challenged.
[21:34:24 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 11.7389ms
[21:34:25 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:25 INF] AuthenticationScheme: Cookies was challenged.
[21:34:25 INF] AuthenticationScheme: Bearer was challenged.
[21:34:25 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:25 INF] AuthenticationScheme: Cookies was challenged.
[21:34:25 INF] AuthenticationScheme: Bearer was challenged.
[21:34:25 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 13.2133ms
[21:34:26 INF] Request starting HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/api/v1/signin?ReturnUrl=%2F application/json 47
[21:34:26 INF] CORS policy execution failed.
[21:34:26 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[21:34:26 INF] Executing endpoint 'UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server)'
[21:34:26 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).
[21:34:26 INF] Executed action UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server) in 7.6467ms
[21:34:26 INF] Executed endpoint 'UniversalDashboard.Controllers.AuthenticationController.SignIn (Universal.Server)'
[21:34:26 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)
[21:34:26 INF] Request finished HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/api/v1/signin?ReturnUrl=%2F application/json 47 - 500 - text/plain 22.3566ms
[21:34:26 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:26 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:26 INF] AuthenticationScheme: Cookies was challenged.
[21:34:26 INF] AuthenticationScheme: Bearer was challenged.
[21:34:26 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:26 INF] AuthenticationScheme: Cookies was challenged.
[21:34:26 INF] AuthenticationScheme: Bearer was challenged.
[21:34:26 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 12.9017ms
[21:34:27 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:27 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:27 INF] AuthenticationScheme: Cookies was challenged.
[21:34:27 INF] AuthenticationScheme: Bearer was challenged.
[21:34:27 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:27 INF] AuthenticationScheme: Cookies was challenged.
[21:34:27 INF] AuthenticationScheme: Bearer was challenged.
[21:34:27 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 12.6127ms
[21:34:28 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:28 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:28 INF] AuthenticationScheme: Cookies was challenged.
[21:34:28 INF] AuthenticationScheme: Bearer was challenged.
[21:34:28 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:28 INF] AuthenticationScheme: Cookies was challenged.
[21:34:28 INF] AuthenticationScheme: Bearer was challenged.
[21:34:28 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 11.7887ms
[21:34:29 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - -
[21:34:29 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:29 INF] AuthenticationScheme: Cookies was challenged.
[21:34:29 INF] AuthenticationScheme: Bearer was challenged.
[21:34:29 INF] Authorization failed. These requirements were not met:
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
DenyAnonymousAuthorizationRequirement: Requires an authenticated user.
[21:34:29 INF] AuthenticationScheme: Cookies was challenged.
[21:34:29 INF] AuthenticationScheme: Bearer was challenged.
[21:34:29 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/api/v1/identity/my - - - 401 - - 11.4648ms
[21:34:32 INF] Request starting HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/notificationhub/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0
[21:34:32 INF] CORS policy execution failed.
[21:34:32 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[21:34:32 INF] Executing endpoint '/notificationhub/negotiate'
[21:34:32 INF] Executed endpoint '/notificationhub/negotiate'
[21:34:32 INF] Request finished HTTP/1.1 POST http://eclwswd00027.stg-tfayd.com/notificationhub/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0 - 200 - application/json 5.9715ms
[21:34:32 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/notificationhub?id=TW_CfzcCd98_OxTyTYbmIA - -
[21:34:32 INF] CORS policy execution failed.
[21:34:32 INF] Request origin http://eclwswd00027.stg-tfayd.com does not have permission to access the resource.
[21:34:32 INF] Executing endpoint '/notificationhub'
[21:34:32 ERR] Error when dispatching 'OnConnectedAsync' on hub.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UserSessions'.
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.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
ClientConnectionId:4af22b7f-07a4-46f4-b1d5-c8bedef0fb87
Error Number:208,State:1,Class:16
--- 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(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
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.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
at PowerShellUniversal.SQL.SqlTable`1.Insert(T item) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 554
at UniversalDashboard.NotificationHub.OnConnectedAsync() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Hubs\NotificationHub.cs:line 225
at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
at Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher`1.OnConnectedAsync(HubConnectionContext connection)
at Microsoft.AspNetCore.SignalR.HubConnectionHandler`1.RunHubAsync(HubConnectionContext connection)
[21:34:32 INF] Executed endpoint '/notificationhub'
[21:34:32 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/notificationhub?id=TW_CfzcCd98_OxTyTYbmIA - - - 101 - - 108.6211ms
[21:35:06 INF] Starting groom job.
[21:35:06 WRN] Settings not populated yet. Skipping groom.
[21:35:06 INF] Starting heartbeat job.
[21:35:06 INF] Starting heartbeat job.
[21:35:06 INF] Finished heartbeat job.
[21:35:06 ERR] Failed to groom.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UserSessions'.
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.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1
Here is the log from a fresh server startup under 3.8.2
[21:41:27 INF] User profile is available. Using 'C:\windows\system32\config\systemprofile\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
[21:41:29 INF] Starting Hangfire Server using job storage: 'SQL Server: ECLDBWD00031.stg-tfayd.com,4070@IDMPSU'
[21:41:29 INF] Using the following options for SQL Server job storage: Queue poll interval: 00:00:00.
[21:41:29 INF] Using the following options for Hangfire Server:
Worker count: 100
Listening queues: 'default', 'eclwswd00027'
Shutdown timeout: 00:00:15
Schedule polling interval: 00:00:15
[21:41:29 INF] Application started. Press Ctrl+C to shut down.
[21:41:29 INF] Hosting environment: Production
[21:41:29 INF] Content root path: C:\inetpub\wwwroot\PowershellUniversal
[21:41:29 INF] Request starting HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/ - -
[21:41:29 INF] Server eclwswd00027:7780:9802681d successfully announced in 12.3158 ms
[21:41:29 INF] Server eclwswd00027:7780:9802681d is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, SqlServerHeartbeatProcess, Worker, DelayedJobScheduler, RecurringJobScheduler...
[21:41:29 ERR] Connection ID "18086456118015426680", Request ID "80000079-0003-fb00-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()
[21:41:29 INF] Request finished HTTP/1.1 GET http://eclwswd00027.stg-tfayd.com/ - - - 500 - - 90.7212ms
[21:41:29 INF] Server eclwswd00027:7780:9802681d all the dispatchers started
[21:41:33 INF] PowerShell Universal performance counters do not exist.
[21:41:36 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:2016495d-6470-4fd9-95d1-42a21533c0fd
Error Number:207,State:1,Class:16
[21:41:36 INF] Running git sync, if configured.
[21:41:36 INF] Scheduling git sync service.
[21:41:36 INF] Scheduling heartbeat job.
[21:41:36 INF] Scheduling update check.
[21:41:36 INF] Starting security proxy.
[21:42:14 INF] Starting groom job.
[21:42:14 WRN] Settings not populated yet. Skipping groom.
[21:42:14 INF] Starting heartbeat job.
[21:42:14 INF] Finished heartbeat job.
[21:42:14 INF] Starting heartbeat job.
[21:42:14 INF] Finished heartbeat job.
[21:42:14 ERR] Failed to groom.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UserSessions'.
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.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 Microsoft.EntityFrameworkCore.DbContext.RemoveRange(IEnumerable`1 entities)
at PowerShellUniversal.SQL.SqlTable`1.DeleteRange(Func`2 query) in C:\actions-runner\_work\universal\universal\src\PowerShellUniversal.SQL\Database.cs:line 669
at UniversalAutomation.GroomService.GroomSessions() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\GroomService.cs:line 68
at UniversalAutomation.GroomService.Groom() in C:\actions-runner\_work\universal\universal\src\Universal.Server\Services\GroomService.cs:line 272
ClientConnectionId:39066b1a-e1cc-4988-bc24-225a017de1b5
Error Number:208,State:1,Class:16
[21:42:14 INF] Finished groom job.
[21:42:53 INF] PowerShell Universal performance counters do not exist.
[21:42:54 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
with this version we see our column layouts messed up. It seems that the largesize is not respected
It appears we are running into the same problen when using new-udcolumn with the LargeSize parameter.
See this post: Any changes in new-udcolumn on version 3.8.0 3.8.1 - #4 by adam
I think we’ll adjust the behavior for 3.8.3 to prevent having to do this.
Any info/suggestion on the issue I posted? Would like to upgrade my dev instance before I deploy PSU 3.8.x into our upper environments.
Thanks
@JoseJ - It looks like the schema still didn’t upgrade for you. This release did resolve this for other users so we may need to isolate the differences.
There is a setting to avoid migrating the schema in appsettings.json. I have a feeling you did not set that but figured i would check to make sure that isn’t selected.
The other option is to run the SQL migration manually if the service is not updating the schema for some reason. Within the PSU applications files there is a SQL folder that contains 2 SQL files. If you run those against your SQL database, they will add the necessary tables and columns. They are idempotent so you can run them multiple times without issue as they check for the existence of the schema bits before trying to create them.
This setting?
“RunMigrations”?
So it needs to be set to True?
Yes. If you have RunMigrations set to false it will not update the database schema.
Ok…
From a best practices perspective… Should this option only be set to True for upgrades?
Thanks
Unless you have a reason to not allow the service to upgrade the schema, I would recommend keeping it set to True. This is the default value. The service won’t work well (as you can see) if the schema isn’t up to date and it will automatically update when necessary. It will only run the migrations the first time after the upgrade so there isn’t a benefit to turning it off afterwards since it’s a no-op after that first start up.
The reason this was introduced was that some customers do not have the permissions assigned to their service account to alter the schema of the database. This causes PSU to fail to update the schema and then fail to start. They have to provide the included SQL scripts to their DBA team and the schema is upgraded during a change window.
change -LargeSize to -ExtraLargeSize and it will go back to normal.
An additional issue I have found is that New-UDLayout doesn’t seem to be working as far as creating columns.
Had this call in a dashboard working on 3.7.14…
New-UDLayout -Columns 3
Within have 6 different UDDynamic content each with a UDCard to spit out content.
Here is the screenshot of how the page looks now… each No Data to Display is a UDCard…
Previously they would be 2 rows of 3.
EDIT: After some additional testing this appears to be a browser specific issue. Chrome & Edge render the dashboard as above, while Firefox is able to render correctly as shown below…
I upgraded and now have this error on one of my dashboards:
Error rendering component (dynamic)
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
highOrderComponent@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:112277:55
ErrorBoundary@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:83927:197
Suspense
div
./node_modules/@emotion/react/dist/emotion-element-cbed451f.browser.esm.js/withEmotionCache/<@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:190:66
Stack@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:31407:87
highOrderComponent@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:112277:55
ErrorBoundary@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:83927:197
Suspense
div
Resizable@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:7316:35
DraggableCore@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:2528:20
GridItem@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:3833:20
div
ReactGridLayout@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:4511:20
ResponsiveReactGridLayout@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:5583:20
WidthProvider@https://psu.***.dk/vendors-node_modules_react-grid-layout_index_js-node_modules_react-grid-layout_css_styles_css-0dae1f.8cddb7a79b7028de128c.bundle.js:6132:22
highOrderComponent@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:112277:55
ErrorBoundary@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:83927:197
Suspense
main
UDPage@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:80926:17
highOrderComponent@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:112277:55
Route@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:149297:29
Switch@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:149503:29
div
Suspense
highOrderComponent@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:112277:55
Suspense
InnerThemeProvider@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:44211:70
ThemeProvider@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:42551:7
ThemeProvider@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:44233:7
StyledEngineProvider@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:42736:7
n@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:162669:58
./node_modules/use-error-boundary/lib/index.module.js/a/l/<@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:162669:1049
Dashboard@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:111201:17
Route@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:149297:29
Switch@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:149503:29
div
Router@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:148928:30
BrowserRouter@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:148553:35
App@https://psu.***.dk/index.dab5a105dc9d6ac11367.bundle.js:82923:197
@JoseJ - We’re adjusting New-UDColumn to default to undefined for ExtraLargeColumn rather than 12 to avoid this issue. This will be in 3.8.3.
Can you do me a favor and check the network tab in your browser for this dynamic (F12)? If you give it an ID, you will see if listed in the requests.
It seems like it’s returning HTML or something rather than the JSON it should be returning.
So it does return json
But I also see lots of errors including this, that seemed most interesting
I could maybe PM you some code and more of the error messages? 
EDIT
I finally have a dev env, so I can share all the info without caring for secrets, URL and so on.
I thought that this also might be usefull?
As far as test environments go, I have a few docker containers using docker desktop on my laptop. I test a lot of code on this envionment.
It may be a way you can go for testing.
Maybe not release post thread material, but ye I should make a dev env.
I’m off from work in ~30min, so it won’t be today 
