Issue ID:
Type
Bug
Title:
FIX: Build compliance analysis with long report results may fail to save [PostgreSQL]
Created:
4/2/2026 12:25:49 AM by Alana Tripp
Status:
Completed on
Last pulled:
4/3/2026 9:36:31 PM
Description:
This should be fixable by truncating string before saving during `AnalyzePackageInternalAsync` ``` An error occurred in the web application: 22001: value too long for type character varying(1000) URL: http://example.com/feeds/REDACTED-FEED-group/com.fasterxml.jackson.core/jackson-databind/2.19.4 Referrer: https://example.com/projects2/packages?buildId=21&skip=0&take=1000 User: JoshuaM User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:149.0) Gecko/20100101 Firefox/149.0 IP Address: ::ffff:172.18.1 Stack trace: at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() 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\_E649756\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.ProGet.Policies.ComplianceMan.AnalyzePackageInternalAsync(IPackageFeed feed, IPackageMetadata package, Boolean alwaysReanalyze, Func`2 getLocalLatestPatchVersion, ILogSink log, CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\Policies\ComplianceMan.cs:line 136 at Inedo.ProGet.WebApplication.Pages.Packages.PackageOverviewPage.b__5_11(IPackageMetadata p) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\WebApplication\Pages\Packages\PackageOverviewPage.cs:line 137 at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIteratorWithTask`2.MoveNextCore() at System.Linq.AsyncIteratorBase`1.MoveNextAsync() in /_/Ix.NET/Source/System.Linq.Async/System/Linq/AsyncIterator.cs:line 70 at System.Linq.AsyncIteratorBase`1.MoveNextAsync() in /_/Ix.NET/Source/System.Linq.Async/System/Linq/AsyncIterator.cs:line 75 at System.Linq.OrderedAsyncEnumerable`1.TryGetFirstAsync(CancellationToken cancellationToken) in /_/Ix.NET/Source/System.Linq.Async/System/Linq/Operators/OrderedAsyncEnumerable.cs:line 269 at System.Linq.OrderedAsyncEnumerable`1.TryGetFirstAsync(CancellationToken cancellationToken) in /_/Ix.NET/Source/System.Linq.Async/System/Linq/Operators/OrderedAsyncEnumerable.cs:line 290 at System.Linq.AsyncEnumerable.g__Core|91_0[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) at Inedo.ProGet.WebApplication.Pages.Packages.PackageOverviewPage.g__createPackageStatusInfoAsync|5_1() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\WebApplication\Pages\Packages\PackageOverviewPage.cs:line 135 at Inedo.ProGet.WebApplication.Pages.Packages.PackageOverviewPage.AddContentControlsAsync(ContentContainer content) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\WebApplication\Pages\Packages\PackageOverviewPage.cs:line 38 at Inedo.ProGet.WebApplication.Pages.Packages.PackagePageBase.CreateChildControlsAsync() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\WebApplication\Pages\Packages\PackagePageBase.cs:line 91 at Inedo.ProGet.WebApplication.Pages.ProGetSimplePage.InitializeAsync() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E649756\Src\src\ProGet\WebApplication\Pages\ProGetSimplePage.cs:line 69 at Inedo.Web.PageFree.SimplePageBase.ExecutePageLifeCycleAsync() at Inedo.Web.PageFree.SimplePageBase.ProcessRequestAsync(AhHttpContext context) at Inedo.Web.AhWebMiddleware.InvokeAsync(HttpContext context) ::Web Error on 31/03/2026 1:58:15 pm:: ```