Hey all,
We’re trying to use the Audit functionality, but it’s not working - the page is just not loading
The Audit has always been a bit slow, but I don’t recall seeing it just not work. Is there a known issue at the moment?
Full error…
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Current transactions: Transaction 'GetEventAgents.GetEventAgents|0HMNP0DRJNDEA:00000002|T413' Open with 1 commands started at 2023-01-23T14:43:31 (60.02 seconds ago) 2023-01-23T14:43:31 SELECT DISTINCT [UserAgent] FROM dbo.[Event] WHERE UserAgent is not null AND NOT UserAgent = 'CommandLine' AND NOT UserAgent = 'Server' AND NOT UserAgent LIKE 'OctopusClient-js%' Transaction 'ListServerTasks.ListServerTasks|0HMNP0DRJNDCF:00000054|T168' Open with 3 commands started at 2023-01-23T14:44:31 (0.15 seconds ago) 2023-01-23T14:44:31 SELECT COUNT(*) FROM [dbo].[ServerTask] WHERE (((([SpaceId] in ('Spaces-1'))))) AND ([ProjectId] = @p1) 2023-01-23T14:44:31 SELECT aliased.Id,aliased.Name,aliased.Description,aliased.QueueTime,aliased.StartTime,aliased.CompletedTime,aliased.ErrorMessage,aliased.ConcurrencyTag,aliased.State,aliased.HasPendingInterruptions,aliased.HasWarningsOrErrors,aliased.ServerNodeId,aliased.ProjectId,aliased.EnvironmentId,aliased.TenantId,aliased.RunbookId,aliased.DurationSeconds,aliased.SpaceId,aliased.LastModified,aliased.BusinessProcessState,aliased.ServerTaskType,aliased.JSON FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [QueueTime] DESC, [Id] DESC) AS RowNum, Id,Name,Description,QueueTime,StartTime,CompletedTime,ErrorMessage,ConcurrencyTag,State,HasPendingInterruptions,HasWarningsOrErrors,ServerNodeId,ProjectId,EnvironmentId,TenantId,RunbookId,DurationSeconds,SpaceId,LastModified,BusinessProcessState,ServerTaskType,JSON FROM [dbo].[ServerTask] WHERE (((([SpaceId] in ('Spaces-1'))))) AND ([ProjectId] = @p1) ) aliased WHERE ([RowNum] > @p2) AND ([RowNum] <= @p3) ORDER BY [RowNum] 2023-01-23T14:44:31 SELECT State, Count(*) AS Counter FROM (SELECT CASE WHEN HasPendingInterruptions = 1 AND [State] IN ( 'Queued', 'Executing' ) THEN 'Interrupted' ELSE [State] END AS State, SpaceId FROM ServerTask) AS _ WHERE ([SpaceId] IN ('Spaces-1')) GROUP BY State SQL Error -2 - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Unknown error 258
Thanks,
David