No execution history

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
PeterTambien
Posts: 1
Joined: Thu 01 Jul 2021 08:20

No execution history

Post by PeterTambien » Thu 01 Jul 2021 08:23

After latest update for Sql Complete (6.8.13) not any execution history is available. Only till 21-06-2021
The option is still enabled. After checking setting now it suddenly works again.....strange.
So I have a history gap from 21-06 till 01-07

alexa

Re: No execution history

Post by alexa » Mon 05 Jul 2021 10:28

Please pay attention to the date fields FROM and TO. In the TO field, there should be stated the date of the current day.

Will it be possible to provide us a video or screenshots demonstrating the issue?

You can send the reply straight to our support system at supportATdevartDOTcom.

Justin8888CT
Posts: 2
Joined: Thu 08 Jul 2021 14:18

Re: No execution history

Post by Justin8888CT » Thu 08 Jul 2021 14:22

I am having the exact same issue. I toggled the history off/on and it worked for a short time, but this morning again no history from today. I am also seeing more "hang" time than usual when moving between servers.

SQL Complete version 6.8.13
SQL Server Management Studio 15.0.18384.0
SQL Server Management Objects (SMO) 16.100.46367.54
Microsoft Analysis Services Client Tools 15.0.19535.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19043

Vaxman2
Posts: 4
Joined: Thu 09 Feb 2017 22:40

Re: No execution history

Post by Vaxman2 » Thu 08 Jul 2021 15:44

I have the same issue. The dates are showing properly 7/1/2021 to 7/8/2021 and is showing nothing recorded.

If I change the dates back to 7/1/2020 to 7/8/2021, the last execution history is 6/29/2021 which is when I installed the update to 6.8.13

Update;
I disabled Execution History, exited options, then re-enabled Execution History. So far, queries since then have been saved and I did not lose my history from before June 29th.

alexa

Re: No execution history

Post by alexa » Fri 09 Jul 2021 11:48

Hello Vaxman2, PeterTambien,

Could you please specify what version of SSMS you are using?

Vaxman2
Posts: 4
Joined: Thu 09 Feb 2017 22:40

Re: No execution history

Post by Vaxman2 » Fri 09 Jul 2021 17:38

I am using SSMS 18.6

alexa

Re: No execution history

Post by alexa » Tue 13 Jul 2021 09:46

Thank you for the reply.

We will investigate this issue and will answer you as soon as possible.

Vaxman2
Posts: 4
Joined: Thu 09 Feb 2017 22:40

Re: No execution history

Post by Vaxman2 » Thu 15 Jul 2021 00:19

My history stopped recording after the 12th. I disabled it and then re-enabled it and it is recording once again, but I lost all my execution history in between - grrrr!

Justin8888CT
Posts: 2
Joined: Thu 08 Jul 2021 14:18

Re: No execution history

Post by Justin8888CT » Thu 15 Jul 2021 12:34

UPDATE: I am finding that the execution history will work if I open the tool and leave it running as a tab in my SSMS. If I forget to open it I don't collect history for that day.

alexa

Re: No execution history

Post by alexa » Fri 16 Jul 2021 07:00

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

Post Reply