Hi everyone, I set up a Horizon Session Recording lab environment and transferred the database to PostgreSQL version 16.4.
Once I finished the process, the application started writing to the DB, but I got the following error.
When I checked the log file, this is the error I received during the save configuration:
at Horizon.Recording.WebAPI.Controllers.SecureControllers.SetupController.Post(SetupConfiguration value) in C:\actions-runner\_work\HorizonRecording\HorizonRecording\Horizon.Recording.WebAPI\Controllers\SecureControllers\SetupController.cs:line 252|
2024-09-11 18:23:50.1645|ERROR|Horizon.Recording.WebAPI.Controllers.SecureControllers.SetupController|Failed to migrate machines to destination database: Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
It seems to be an application error.
I'm attaching info from the Postgres documents. - https://www.npgsql.org/doc/types/datetime.html
The Omnissa documentation doesn’t have a compatibility matrix for supported database versions.
I can’t reach support. Can this information be passed on to the relevant parties?