Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login
    1. Home
    2. Evan_Mulawski_8840

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    E Offline
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 2
    • Groups 0

    Evan_Mulawski_8840

    @Evan_Mulawski_8840

    0
    Reputation
    1
    Profile views
    2
    Posts
    0
    Followers
    0
    Following
    Joined
    Last Online

    Evan_Mulawski_8840 Unfollow Follow

    Latest posts made by Evan_Mulawski_8840

    • RE: ProGet 2023 Data Migration fails with database timeout

      In case anyone runs into this issue, stop the web app (i.e. stop the app pool) and create a new execution:

      USE [ProGet]
      GO
      
      DECLARE @RC int
      DECLARE @Start_Date datetime
      DECLARE @ExecutionMode_Code char(1) = 'O'
      DECLARE @ExecutionRunState_Code char(1)
      DECLARE @ExecutionType_Name varchar(50) = 'ProGet 2023 Feed Data Migration'
      DECLARE @Execution_Configuration xml = (select Execution_Configuration from dbo.Executions where Execution_Id = <ID_OF_FAILED_EXECUTION>)
      DECLARE @ScheduledTask_Id int = NULL
      DECLARE @Feed_Id int = NULL
      DECLARE @Connector_Id int = NULL
      DECLARE @FeedReplication_Id int = NULL
      DECLARE @Execution_Id int
      
      EXECUTE @RC = [dbo].[Executions_CreateExecution] 
         @Start_Date
        ,@ExecutionMode_Code
        ,@ExecutionRunState_Code
        ,@ExecutionType_Name
        ,@Execution_Configuration
        ,@ScheduledTask_Id
        ,@Feed_Id
        ,@Connector_Id
        ,@FeedReplication_Id
        ,@Execution_Id OUTPUT
      GO
      
      posted in Support
      E
      Evan_Mulawski_8840
    • RE: ProGet 2023 Data Migration fails with database timeout

      I just encountered this on 2023.18. Any way to re-run this?

      DEBUG: 2023-09-18 16:05:38Z - Deactivating feed...
      INFO : 2023-09-18 16:05:38Z - Importing legacy data for npm (Npm) feed...
      ERROR: 2023-09-18 16:06:46Z - Error importing data: Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.
         at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__209_0(Task`1 result)
         at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
         at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
      --- End of stack trace from previous location ---
         at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
      --- End of stack trace from previous location ---
         at Inedo.Data.DatabaseContext.DbResult.CreateAsync(DbCommand command, DatabaseContext context, DateTimeOffset startTime, Stopwatch stopwatch)
         at Inedo.Data.DatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
         at Inedo.Data.SqlServerDatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
         at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync(String storedProcName, GenericDbParameter[] parameters)
         at Inedo.ProGet.Feeds.StandardPackageFeed`3.ImportLegacyPackageDataAsync[TOldRow](ImportLegacyPackageDataContext context, IEnumerable`1 oldRows, Func`2 importAsync, CancellationToken cancellationToken)
         at Inedo.ProGet.Feeds.Npm.NpmFeed.Inedo.ProGet.Feeds.ILegacyImportableFeed.ImportLegacyPackageDataAsync(ImportLegacyPackageDataContext context, CancellationToken cancellationToken)
         at Inedo.ProGet.Executions.MigrateFeedsForProGet23Execution.ExecuteAsync(IManualExecutionContext context)
      ClientConnectionId:58ed9c81-5e72-4dd3-808a-612492ad0b86
      Error Number:-2,State:0,Class:11
      DEBUG: 2023-09-18 16:06:46Z - Deactivating feed...
      INFO : 2023-09-18 16:06:46Z - Importing legacy data for nuget (NuGet) feed...
      INFO : 2023-09-18 16:06:47Z - Migrating legacy .snupkg tables...
      INFO : 2023-09-18 16:06:47Z - .snupkg migration complete.
      DEBUG: 2023-09-18 16:06:47Z - Reactivating feed...
      INFO : 2023-09-18 16:06:47Z - Import complete for nuget feed.
      
      posted in Support
      E
      Evan_Mulawski_8840