Horizon Session Recording and PostgerSQL

[Ofir Dalal]

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?

 

 

 

 

 

Edited September 13 by Ofir Dalal

[Clifford O'Rourke]

You cant reach support? Is that you cannot create an SR?

Ive seen a case similar to this recently where postgreSQL for windows was deployed on the Horizon Recording Server.

I suggested to deploy postgreSQL on a separate Linux VM as postgres uses UTC and it may have been conflicting with the Server NTP time/date.

I have yet to hear from the TSE about the status of this test.

[Ofir Dalal]

Thank you, Cliff.

I'll test PostgreSQL on a Linux system in a lab environment.

Regarding ticket creation, the system didn't allow opening a ticket with a customer account. Yesterday, there was a problem with the Issue Type field in the drop-down menu being empty, and it's a required field.

I'll check again with the customer to see if it's resolved.

Do you know if the Horizon Session Recording Server will also support PostgreSQL on Windows environments? Unfortunately, the customer wants PostgreSQL to run only on a Windows system.