Proget error when setting vulnerability expiry date

[phil.sutherland]

I'm seeing an error in Proget 2025.22 as shown below when attempting to set an expiry date on a vulnerability assessment override. I have tried with my user time zone set to both UTC and local time zone (UTC+8) but that doesn't seem to make a difference. Note that we're using an external Postgres 17 database in its own container. Have we missed a configuration step or is this a bug?

An error occurred in the web application: 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, or multirange. (Parameter 'value')

URL: http://blobstore.rct-global.com/vulnerabilities/assess-pgvd?pgvdVulnerabilityId=388100&assessmentId=3768
Referrer: https://blobstore.rct-global.com/vulnerabilities/assess-pgvd?pgvdVulnerabilityId=388100&assessmentId=3768
User: Phil.Sutherland@xxxx
User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0
IP Address: 10.61.100.160
Stack trace:    at Npgsql.Internal.Converters.DateTimeConverterResolver`1.Get(DateTime value, Nullable`1 expectedPgTypeId, Boolean validateOnly)
   at Npgsql.Internal.PgResolverTypeInfo.GetResolutionAsObject(Object value, Nullable`1 expectedPgTypeId)
   at Npgsql.Internal.PgTypeInfo.GetObjectResolution(Object value)
   at Npgsql.NpgsqlParameterCollection.ProcessParameters(PgSerializerOptions options, Boolean validateValues, CommandType commandType)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Inedo.ProGet.Data.PostgresDatabaseContext.PostgresCommand.ExecuteReader() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E641388\Src\src\ProGet\Data\PostgresDatabaseContext.cs:line 372
   at Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters, DatabaseCommandReturnType returnType)
   at Inedo.Data.DatabaseContext.ExecuteNonQuery(String storedProcName, GenericDbParameter[] parameters)
   at Inedo.Data.DatabaseContext.ExecuteScalar[TResult](String storedProcName, GenericDbParameter[] parameters, Int32 outParameterIndex)
   at Inedo.ProGet.Data.DB.Context.PgvdVulnerabilities_CreateAssessment(Nullable`1 Pgvd_Id, Nullable`1 AssessmentType_Id, Nullable`1 Assessment_Date, Nullable`1 Expiry_Date, String AssessedBy_User_Name, Nullable`1 Policy_Id, Nullable`1 Project_Id, Nullable`1 PgvdAssessment_Id) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E641388\Src\src\ProGet\obj\Release\net8.0\linux-x64\InedoLib.Analyzers\InedoLib.Analyzers.DatabaseContextGenerator\DB.g.cs:line 3785
   at Inedo.ProGet.Data.DB.PgvdVulnerabilities_CreateAssessment(Nullable`1 Pgvd_Id, Nullable`1 AssessmentType_Id, Nullable`1 Assessment_Date, Nullable`1 Expiry_Date, String AssessedBy_User_Name, Nullable`1 Policy_Id, Nullable`1 Project_Id, Nullable`1 PgvdAssessment_Id) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E641388\Src\src\ProGet\obj\Release\net8.0\linux-x64\InedoLib.Analyzers\InedoLib.Analyzers.DatabaseContextGenerator\DB.g.cs:line 1471
   at Inedo.ProGet.WebApplication.Pages.Vulnerabilities.AssessmentVulnerabilityPage.<>c__DisplayClass17_0.<CreateChildControls>b__5() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E641388\Src\src\ProGet\WebApplication\Pages\Vulnerabilities\AssessmentVulnerabilityPage.cs:line 128
   at Inedo.Web.Controls.ButtonLinks.PostBackButtonLink.Inedo.Web.Controls.ISimpleEventProcessor.ProcessEventAsync(String eventName, String eventArgument)
   at Inedo.Web.PageFree.SimplePageBase.ExecutePageLifeCycleAsync()
   at Inedo.Web.PageFree.SimplePageBase.ProcessRequestAsync(AhHttpContext context)
   at Inedo.Web.AhWebMiddleware.InvokeAsync(HttpContext context)

::Web Error on 03/10/2026 17:11:15::

[rhessinger]

Hi @phil-sutherland,

Thanks for sending this over to us. This looks to be a regression in the PostgreSQL migration. I have created a ticket, PG-3241, to fix the issue. This will be fixed in the next maintenance release of ProGet 2025.24, due out on March 20, 2026.

Thanks,
Rich

[phil.sutherland]

@rhessinger Thank you Rich - will install it once released and confirm it is fixed.