PowerShell Universal - 3.8.0

I seem to run into an issue: The added or subtracted value results in an un-representable DateTime. (Parameter ‘months’). Seems to be something with license

System.ArgumentOutOfRangeException: The added or subtracted value results in an un-representable DateTime. (Parameter ‘months’)
at System.DateTime.ThrowDateArithmetic(Int32 param)
at System.DateTime.AddMonths(Int32 months)
at Universal.Server.Services.LicenseService.CacheLicenses(Boolean force) in C:\actions-runner_work\universal\universal\src\Universal.Server\Services\LicenseService.cs:line 238

Tried to update, now all my pages just show:



EDIT
Rolled back and saw this in my error log:

I received this when I try to load my dev environment using 3.8.0 :



I have just spun up 2 additional containers (1 licenced and 1 not licenced). The unlicensed container appears to load, and I receive the same error with the licenced container.

I’ve generated some debug logs and will upload them to a support ticket.

Hope they help

Thanks. We’re rolling out a fix for this shortly.

my dashboards start but display nothing just blank screens.

get this message looping in the logs

2023-03-14 09:01:28.157 +01:00 [DBG] Socket opened using Sub-Protocol: ‘null’.
2023-03-14 09:01:28.169 +01:00 [DBG] Completed connection handshake. Using HubProtocol ‘json’.
2023-03-14 09:01:28.176 +01:00 [DBG] Waiting for the client to close the socket.
2023-03-14 09:01:28.177 +01:00 [DBG] Socket closed.

I’m having the same issue, my end running 3.8.1.

Debug logs available on request

Can you please email support@ironmansoftware.com so we can get some more info?

Hi @Adam Driscoll,

The requested logs are in your inbox

@AnonymousUser,

Is your instance connected to an SQL server or does it use litedb?

Few issues after updating to 3.8

This keeps showing up in the logs

2023-03-14 10:21:08.416 -05:00 [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.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:1d25a122-80e2-4c14-ab45-d610eef28e80
Error Number:208,State:1,Class:16

and I get this when loading the homepage.

Looks like the schema upgrade is failing → SQL Upgrade in 3.8.1 is not running properly · Issue #2186 · ironmansoftware/issues · GitHub

hi, its SQL

Thanks @AnonymousUser,

I raised a support ticket for this and, for me, it appears to be resolved in 3.8.2.

The problem was traced to instances using SQL.

Added support for PSScriptAnalyzer in editors within the admin console (#1987)

@Adam Driscoll - I added KB0040 to describe how to address the PSScriptAnalyzer warning in the Health Check feature when the module has not been installed yet (to the PSU integrated environment).