[11.0.35 Pro] - BUG: To-Do Tasks and Reminders

I still cannot add database objects with 11.1.120 in SSMS. The plus sign no longer gives me an exception popup, nothing happens GUI side at all now.

SSMS 18.4 and 11.1.120 SA Pro. I can however add database objects in SQL Editor Pro 64 bit.

Could you please check the log file in C:\Users\[user name here]\AppData\Roaming\SQL Assistant\11.1\SQLAssist Log

Based in notes in the ticket the command that does the actual scanning should log internal errors to the common log. Hope something would turn up in the log that helps with troubleshooting it.

Code:

1/15/2020 9:47:49 AM Ssms.exe Client: Detach
1/15/2020 9:48:44 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:48:44 AM taskhostw.exe Client: Attach
1/15/2020 9:48:44 AM taskhostw.exe Client: Detach
1/15/2020 9:48:45 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:48:45 AM taskhostw.exe Client: Attach
1/15/2020 9:48:45 AM taskhostw.exe Client: Detach
1/15/2020 9:49:13 AM Signal.exe SA=11.1.120; Exe=C:\Users\Ryan\AppData\Local\Programs\signal-desktop\Signal.exe; Cmd="C:\Users\Ryan\AppData\Local\Programs\signal-desktop\Signal.exe" --updated; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:49:13 AM Signal.exe Client: Attach
1/15/2020 9:52:36 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:52:36 AM taskhostw.exe Client: Attach
1/15/2020 9:52:37 AM taskhostw.exe Client: Detach
1/15/2020 9:52:54 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:52:54 AM taskhostw.exe Client: Attach
1/15/2020 9:52:54 AM taskhostw.exe Client: Detach
1/15/2020 9:53:32 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:53:32 AM taskhostw.exe Client: Attach
1/15/2020 9:53:32 AM taskhostw.exe Client: Detach
1/15/2020 9:53:58 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:53:58 AM taskhostw.exe Client: Attach
1/15/2020 9:53:58 AM taskhostw.exe Client: Detach
1/15/2020 9:54:25 AM ConEmu64.exe SA=11.1.120; Exe=C:\Program Files\ConEMU\ConEmu64.exe; Cmd="C:\Program Files\ConEMU\ConEmu64.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:54:25 AM ConEmu64.exe Client: Attach
1/15/2020 9:54:26 AM putty.exe SA=11.1.120; Exe=C:\Program Files\PuTTY\putty.exe; Cmd="C:\Program Files\PuTTY\putty.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:54:26 AM putty.exe Client: Attach
1/15/2020 9:54:53 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe KEYROAMING; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:54:53 AM taskhostw.exe Client: Attach
1/15/2020 9:54:53 AM taskhostw.exe Client: Detach
1/15/2020 9:54:54 AM OUTLOOK.EXE SA=11.1.120; Exe=C:\Program Files\Microsoft Office\Office15\OUTLOOK.EXE; Cmd="C:\Program Files\Microsoft Office\Office15\OUTLOOK.EXE" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000000AC0000
1/15/2020 9:54:54 AM OUTLOOK.EXE Client: Attach
1/15/2020 9:54:58 AM SearchProtocolHost.exe SA=11.1.120; Exe=C:\Windows\system32\SearchProtocolHost.exe; Cmd="C:\Windows\system32\SearchProtocolHost.exe" Global\UsGthrFltPipeMssGthrPipe_S-1-5-21-1962581180-2985025175-2306875418-1188927_ Global\UsGthrCtrlFltPipeMssGthrPipe_S-1-5-21-1962581180-2985025175-2306875418-1188927 1 -2147483646 "Software\Microsoft\Windows Search" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT; MS Search 4.0 Robot)" "C:\ProgramData\Microsoft\Search\Data\Temp\usgthrsvc" "DownLevelDaemon" "1"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:54:58 AM SearchProtocolHost.exe Client: Attach
1/15/2020 9:55:18 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:55:18 AM taskhostw.exe Client: Attach
1/15/2020 9:55:18 AM taskhostw.exe Client: Detach
1/15/2020 9:55:49 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:55:49 AM taskhostw.exe Client: Attach
1/15/2020 9:55:49 AM taskhostw.exe Client: Detach
1/15/2020 9:55:58 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:55:58 AM taskhostw.exe Client: Attach
1/15/2020 9:55:58 AM taskhostw.exe Client: Detach
1/15/2020 9:56:35 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:56:35 AM taskhostw.exe Client: Attach
1/15/2020 9:56:35 AM taskhostw.exe Client: Detach
1/15/2020 9:56:40 AM SearchProtocolHost.exe Client: Detach
1/15/2020 9:56:50 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe KEYROAMING; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:56:50 AM taskhostw.exe Client: Attach
1/15/2020 9:56:50 AM taskhostw.exe Client: Detach
1/15/2020 9:57:05 AM SearchProtocolHost.exe SA=11.1.120; Exe=C:\Windows\system32\SearchProtocolHost.exe; Cmd="C:\Windows\system32\SearchProtocolHost.exe" Global\UsGthrFltPipeMssGthrPipe_S-1-5-21-1962581180-2985025175-2306875418-1188928_ Global\UsGthrCtrlFltPipeMssGthrPipe_S-1-5-21-1962581180-2985025175-2306875418-1188928 1 -2147483646 "Software\Microsoft\Windows Search" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT; MS Search 4.0 Robot)" "C:\ProgramData\Microsoft\Search\Data\Temp\usgthrsvc" "DownLevelDaemon" "1"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:57:05 AM SearchProtocolHost.exe Client: Attach
1/15/2020 9:57:06 AM iexplore.exe SA=11.1.120; Exe=C:\Program Files\Internet Explorer\iexplore.exe; Cmd="C:\Program Files\Internet Explorer\iexplore.exe" http://www.softtreetech.com/support/phpBB2/viewtopic.php?p=35126#35126; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000000960000
1/15/2020 9:57:06 AM iexplore.exe Client: Attach
1/15/2020 9:57:27 AM NOTEPAD.EXE SA=11.1.120; Exe=C:\Windows\system32\NOTEPAD.EXE; Cmd="C:\Windows\system32\NOTEPAD.EXE" C:\Users\Ryan\AppData\Roaming\SQL Assistant\11.1\SqlAssist.log; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:57:27 AM NOTEPAD.EXE Client: Attach
1/15/2020 9:57:29 AM NOTEPAD.EXE Client: Detach
1/15/2020 9:57:31 AM notepad++.exe SA=11.1.120; Exe=C:\Program Files\Notepad++\notepad++.exe; Cmd="C:\Program Files\Notepad++\notepad++.exe" "C:\Users\Ryan\AppData\Roaming\SQL Assistant\11.1\SqlAssist.log"; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:57:31 AM notepad++.exe Client: Attach
1/15/2020 9:57:39 AM iexplore.exe Client: Detach
1/15/2020 9:57:50 AM Ssms.exe SA=11.1.120; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssist.dll; ImageBase=08080000
1/15/2020 9:57:50 AM Ssms.exe Client: Attach
1/15/2020 9:57:50 AM Ssms.exe Client: Create
1/15/2020 9:57:56 AM Ssms.exe Client: CreateTargetList
1/15/2020 9:57:56 AM Ssms.exe SA=11.1.120; Exe=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe; Cmd="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" ; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin\SqlAssistPrefs.dll; ImageBase=28100000
1/15/2020 9:57:56 AM Ssms.exe Prefs: Attach
1/15/2020 9:57:56 AM Ssms.exe TargetList: SetSuspend=0
1/15/2020 9:57:56 AM Ssms.exe TargetList: Create: Rok=1
1/15/2020 9:57:56 AM Ssms.exe TargetList: SetSuspend=0
1/15/2020 9:57:56 AM Ssms.exe TargetList: EnumWnd (class=VsTextEditPane)
1/15/2020 9:57:57 AM Ssms.exe Client: SetCbtHook
1/15/2020 9:57:58 AM unsecapp.exe SA=11.1.120; Exe=C:\Windows\system32\wbem\unsecapp.exe; Cmd=C:\Windows\system32\wbem\unsecapp.exe -Embedding; LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:57:58 AM unsecapp.exe Client: Attach
1/15/2020 9:58:14 AM Ssms.exe Target: Create: Pref=SQL Server Management Studio
1/15/2020 9:58:14 AM Ssms.exe Target: Create: Code=14
1/15/2020 9:58:15 AM Ssms.exe PopupInitBars: result=1
1/15/2020 9:58:16 AM taskhostw.exe SA=11.1.120; Exe=C:\Windows\system32\taskhostw.exe; Cmd=taskhostw.exe Install $(Arg0); LogLvl=1; MsgLvl=0; Module=C:\Program Files (x86)\SQL Assistant 11\bin64\SqlAssist.dll; ImageBase=0000000008080000
1/15/2020 9:58:16 AM taskhostw.exe Client: Attach
1/15/2020 9:58:16 AM taskhostw.exe Client: Detach
1/15/2020 9:58:20 AM Ssms.exe fmTaskListOpt: Create
1/15/2020 9:58:22 AM Ssms.exe fmSelMultiConnObjs: Destroy
1/15/2020 9:58:23 AM Ssms.exe Error: Exception: Unhandled
operating system : Windows 10 x64 build 18363
system language : English
system up time : 33 days 1 hour
program up time : 26 seconds
processors : 12x AMD Ryzen 5 3600 6-Core Processor
physical memory : 8078/16315 MB (free/total)
free disk space : (C:) 129.99 GB
display mode : 1920x1080, 32 bit
process id : $1ea84
allocated memory : 678.34 MB
largest free block : 1.97 GB
executable : Ssms.exe
current module : SqlAssistPrefs.dll
module date/time : 2020-01-15 02:16
version : 11.1.120.0
callstack crc : $d5d42819, $8e312446, $8e312446
exception number : 1
exception class : EClassNotFound
exception message : Class TComboBox not found.

cpu registers:
eax = 2def8e70
ebx = 2d9c7ccc
ecx = 00000000
edx = 21a23a60
esi = 2d9c7ccc
edi = 00000000
eip = 28228372
esp = 00a2d414
ebp = 00a2d460

disassembling:
[...]
283dd489 xor al, 1
283dd48b mov edx, [ebp-4]
283dd48e mov [edx+$3b1], al
283dd494 3880 mov edx, esi
283dd496 mov eax, [ebp-4]
283dd499 > call -$1182ea ($282c51b4) ; Vcl.Controls.TWinControl.ReadState
283dd49e 3881 mov eax, [ebp-4]
283dd4a1 cmp dword ptr [eax+$2e8], 0
283dd4a8 jz loc_283dd631
283dd4ae 3883 mov edx, 3
283dd4b3 mov eax, 6
[...]

main thread ($16628):
2822836d +045 SqlAssistPrefs.dll System.Classes ClassNotFound
283dd499 +065 SqlAssistPrefs.dll Vcl.Forms 3880 +10 TCustomForm.ReadState
283dccf3 +0c7 SqlAssistPrefs.dll Vcl.Forms 3633 +17 TCustomForm.Create
28eaed1d +039 SqlAssistPrefs.dll TaskListOptForm 184 +2 TfmTaskListOpt.sbNewSchClick
284c4356 +07a SqlAssistPrefs.dll sSpeedButton 1473 +8 TsSpeedButton.MouseUp
284c3ab2 +31e SqlAssistPrefs.dll sSpeedButton 1228 +98 TsSpeedButton.WndProc
283e790f +0f3 SqlAssistPrefs.dll Vcl.Forms 10469 +23 TApplication.ProcessMessage
283e7952 +00a SqlAssistPrefs.dll Vcl.Forms 10499 +1 TApplication.HandleMessage
283e314f +1ab SqlAssistPrefs.dll Vcl.Forms 7236 +33 TCustomForm.ShowModal
28eb421a +3aa SqlAssistPrefs.dll TaskListPan 166 +32 ShowTaskListOptions
28eb4907 +033 SqlAssistPrefs.dll TaskListPan 199 +3 TaskListCmd
29173477 +a43 SqlAssistPrefs.dll TargetUnit 1689 +150 TTargetManager.WndProc
2871cb6e +05e SqlAssistPrefs.dll Subclass 70 +6 SubclassWndProc

Thanks a ton. I hope that's what we need to know; going to share it with the team.

The issue with some SSMS versions returning "Class TComboBox not found" error when Tasks and Reminders feature is invoked has been fixed in build 11.1.123 and this build is now available for download. Many thank again for your feedback that helped to resolve that issue.

	SysOp wrote:
	The issue with some SSMS versions returning "Class TComboBox not found" error when Tasks and Reminders feature is invoked has been fixed in build 11.1.123 and this build is now available for download. Many thank again for your feedback that helped to resolve that issue.

Thanks. It does appear fixed. :)

I concur :)