Unable to push nuget symbols package

---

• ?

  Joël Luijmes last edited by
  
  

  Hey,

  I'm unable to push nuget symbols packages to my feed. When I do so I get a sql exception:

  Postgres logs

  proget-postgres_1  | 2019-02-07 13:41:56.160 UTC [364] ERROR:  invalid input syntax for integer: ""
  proget-postgres_1  | 2019-02-07 13:41:56.160 UTC [364] CONTEXT:  SQL statement "INSERT INTO "NuGetPackageSymbolsV2"
  proget-postgres_1  |                    (
  proget-postgres_1  |                        "Feed_Id",
  proget-postgres_1  |                        "Symbol_Id",
  proget-postgres_1  |                        "SymbolFileName_Text",
  proget-postgres_1  |                        "Package_SymbolFilePath_Text",
  proget-postgres_1  |                        "Symbol_Age",
  proget-postgres_1  |                        "NuGetPackageV2_Id",
  proget-postgres_1  |                        "Package_Version_Text"
  proget-postgres_1  |                    )
  proget-postgres_1  |                    SELECT "@Feed_Id",
  proget-postgres_1  |                           decode(array_to_string(xpath('@Id', S), ''), 'base64'),
  proget-postgres_1  |                           array_to_string(xpath('@FileName', S), ''),
  proget-postgres_1  |                           array_to_string(xpath('@Path', S), ''),
  proget-postgres_1  |                           CAST(array_to_string(xpath('@Age', S), '') AS INT),
  proget-postgres_1  |                           "@NuGetPackageV2_Id",
  proget-postgres_1  |                           "@Version_Text"
  proget-postgres_1  |                      FROM unnest(xpath('/SymbolFiles/SymbolFile', "@SymbolFiles_Xml")) S"
  proget-postgres_1  |    PL/pgSQL function "NuGetPackagesV2_CreateOrUpdatePackage"(integer,character varying,character varying,character varying,timestamp with time zone,bigint,bytea,bytea,character varying,bytea,ynindicator,ynindicator,yni
  ndicator,ynindicator,integer,character varying,character varying,xml,ynindicator,integer,username) line 97 at SQL statement
  

  Stack trace

  Npgsql.PostgresException (0x80004005): 22P02: invalid input syntax for integer: ""
  at Npgsql.NpgsqlConnector.DoReadMessageAsync (System.Threading.CancellationToken cancellationToken, Npgsql.DataRowLoadingMode dataRowLoadingMode, System.Boolean isPrependedMessage) [0x002d7] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlConnector.ReadMessageWithPrependedAsync (System.Threading.CancellationToken cancellationToken, Npgsql.DataRowLoadingMode dataRowLoadingMode) [0x001c3] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlDataReader.NextResultInternalAsync (System.Threading.CancellationToken cancellationToken) [0x0070a] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlDataReader.NextResultAsync (System.Threading.CancellationToken cancellationToken) [0x0014a] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlCommand.ExecuteAsync (System.Threading.CancellationToken cancellationToken, System.Data.CommandBehavior behavior) [0x003d8] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlCommand.ExecuteDbDataReaderInternalAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x000f1] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x000a7] in <4985dea8374f4819bebb7847d95ad483>:0 
  at Inedo.Postgres.WrappedPgCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x001db] in <ea20532795e64ea18852ec006a228cde>:0 
  at Inedo.Data.DatabaseContext+DbResult.CreateAsync (System.Data.Common.DbCommand command, Inedo.Data.DatabaseContext context, System.DateTimeOffset startTime, System.Diagnostics.Stopwatch stopwatch) [0x00082] in <647507080523420180e9f186fe046588>:0 
  at Inedo.Data.DatabaseContext.ExecuteInternalAsync (System.String storedProcName, Inedo.Data.GenericDbParameter[] parameters) [0x0021e] in <647507080523420180e9f186fe046588>:0 
  at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync (System.String storedProcName, Inedo.Data.GenericDbParameter[] parameters) [0x0007b] in <647507080523420180e9f186fe046588>:0 
  at Inedo.ProGet.Feeds.NuGet.NuGetFeed.InstallOrUpdatePackageAsync (System.IO.Stream stream, System.Boolean calculateHash, System.Boolean cached, System.Boolean install, System.Boolean overwrite, System.Nullable`1[T] publishDate, System.Nullable`1[T] listed, System.Nullable`1[T] downloadCount, System.Boolean promoted) [0x00b20] in <dd1843234460462097fc07427b3e0889>:0 
  at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi+PutHandler.ProcessPutRequestAsync (System.Web.HttpContext context, Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi+RequestData urlData, Inedo.ProGet.Feeds.NuGet.NuGetFeed feed) [0x00170] in <2bc106c38f86445894485c967c113a09>:0 
  at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi.ProcessRequestAsync (System.Web.HttpContext context, Inedo.ProGet.Feeds.NuGet.NuGetFeed feed, System.String relativeUrl) [0x0019b] in <2bc106c38f86445894485c967c113a09>:0 
  at Inedo.ProGet.WebApplication.FeedEndpoints.FeedEndpointHandler+FeedRequestHandler.ProcessRequestAsync (System.Web.HttpContext context) [0x000a4] in <2bc106c38f86445894485c967c113a09>:0
  

  Pushing the 'normal' package (i.e. not the symbols one) it works fine.

  I'm running proget inside a docker container and tried various versions, 5.1.22, 5.1.12, 5.1.11, 5.1.6

  Kind regards,
  Joël Luijmes

  Product: ProGet
  Version: 5.1.22

  Reply Quote 0

  1 Reply Last reply

  ---
• ?

  Alana last edited by
  
  

  Unfortunately we can't figure out any reason that Age would be returning an empty string. We're thinking there must be something else... can you share the entire NUSPEC file so we can reproduce it better.

  Reply Quote 0

  1 Reply Last reply

  ---