Issue ID:
Type
Bug
Title:
PgvdVulnerabilities_MigrateVulnerabilityAssessments error on PostgreSQL
Created:
7/9/2025 2:46:25 PM by Steve Dennis
Status:
Awaiting Release on 7/10/2025 12:29:58 AM
Last pulled:
7/11/2025 11:05:58 PM
Description:
This should not run on PostgreSQL: From the ProGet Diagnostic Center: Failed to import offline PGVD: 42883: function PgvdVulnerabilities_MigrateVulnerabilityAssessments(integer, integer) does not exist POSITION: 15 Npgsql.PostgresException (0x80004005): 42883: function PgvdVulnerabilities_MigrateVulnerabilityAssessments(integer, integer) does not exist POSITION: 15 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.NpgsqlCommand.g__PrepareLong|95_1(NpgsqlCommand command, Boolean async, NpgsqlConnector connector, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.g__PrepareLong|95_1(NpgsqlCommand command, Boolean async, NpgsqlConnector connector, CancellationToken cancellationToken) at Inedo.ProGet.Data.PostgresDatabaseContext.CreateCommand(String storedProcName, ReadOnlySpan`1 parameters, DatabaseCommandReturnType returnType, DbConnection connection) at Inedo.Data.DatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters, DatabaseCommandReturnType returnType) at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync(String storedProcName, GenericDbParameter[] parameters) at Inedo.ProGet.Data.DB.Context.PgvdVulnerabilities_MigrateVulnerabilityAssessmentsAsync(Nullable`1 AssessmentsMigrated_Count, Nullable`1 CommentsMigrated_Count) at Inedo.ProGet.Service.ProGetService.ImportPgvdAsync() Exception data: Severity: ERROR SqlState: 42883 MessageText: function PgvdVulnerabilities_MigrateVulnerabilityAssessments(integer, integer) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15 File: parse_func.c Line: 636 Routine: ParseFuncOrColumn ::PGVD Warning on 7/9/2025 7:31:32 AM::