[SA 9.0.176 Pro] - Changing SCS settings breaks repo browser

[SA 9.0.176 Pro] - Changing SCS settings breaks repo browser

In testing to see if another bug was fixed I changed my External Compare tool from BC to SQL Assistant.

Upon returning to my Repo browser, none of the left click functions worked and the menu pulldowns were dead as well. All I could do was close and re-open the repo browser.

Re: [SA 9.0.176 Pro] - Changing SCS settings breaks repo bro

	Mindflux wrote:
	In testing to see if another bug was fixed I changed my External Compare tool from BC to SQL Assistant. Upon returning to my Repo browser, none of the left click functions worked and the menu pulldowns were dead as well. All I could do was close and re-open the repo browser.

I'm told that so far the team has failed to reproduce this issue. From my personal past experience, when there are multiple development environments running, recurring changes in the Options dialog after opening and closing it multiple times sometime remain in limbo until all development environments are restarted or even cause them to stop functioning correctly. It has happened to me more than once, and I submitted a ticket, but developers insist it's not reproducible on their end. I don't know how to reproduce it on demand. Your description of the issue seems to be of the same kind. If you can figure out how to reproduce the issue on demand, please share with us, so that we can fix it.

I can reproduce it quite handily:

1) Open SQL Editor

2) Open SCS Repository browser

3) Go back to SQL Editor (leave repo browser open) and pull down options, SQL Assistant.

4) Go to the Source Control tab

5) Select SCS Settings on the left

6) Change your Compare tool to anything but what it's set at presently

7) Press ok

8) Go back to the SCS repository (which is still open)..

9) Wonder why none of your buttons or right click menus work.

10) Watch the taskbar bubble for multiple unhandled exception messages.

Code:

Exception: Unhandled exception
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 2 days 17 hours
program up time : 1 day
processors : 4x Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz
physical memory : 2815/8162 MB (free/total)
free disk space : (C:) 45.61 GB
display mode : 1920x1080, 32 bit
process id : $27a0
allocated memory : 174.67 MB
largest free block : 8180.73 GB
executable : SqlEditor64.exe
current module : SqlAssistPrefs64.dll
module date/time : 2016-10-26 16:24
version : 9.0.176.0
callstack crc : $63fa9676, $0e77994d, $932bbd70
exception number : 36
exception class : EAccessViolation
exception message : Access violation at address 0000000005C62139 in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040.

thread $2d50:
05c62139 +019 SqlAssistPrefs64.dll SCSBrowserForm 2429 +1 TfmSCSBrowser.actDBRefreshUpdate
05c5dc22 +042 SqlAssistPrefs64.dll SCSBrowserForm 1417 +3 TfmSCSBrowser.UpdateControlActions
05c62ac1 +011 SqlAssistPrefs64.dll SCSBrowserForm 2524 +1 TfmSCSBrowser.UpdateFormDBActions
05c5dec4 +004 SqlAssistPrefs64.dll SCSBrowserForm 1471 +1 TfmSCSBrowser.tvDBClick
059cdc66 +066 SqlAssistPrefs64.dll VirtualTrees 19221 +7 TBaseVirtualTree.WMLButtonUp
059e00f0 +150 SqlAssistPrefs64.dll VirtualTrees 27178 +32 TBaseVirtualTree.WndProc
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 1:
>> EAccessViolation, Access violation at address 0000000005C62139 in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c62139 +019 SqlAssistPrefs64.dll SCSBrowserForm 2429 +1 TfmSCSBrowser.actDBRefreshUpdate
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 2:
>> EAccessViolation, Access violation at address 0000000005C80EAD in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c80ead +01d SqlAssistPrefs64.dll SCSUnit 1228 +1 TSCSProject.GetDBContext
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 3:
>> EAccessViolation, Access violation at address 0000000005C80EAD in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c80ead +01d SqlAssistPrefs64.dll SCSUnit 1228 +1 TSCSProject.GetDBContext
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 4:
>> EAccessViolation, Access violation at address 0000000005C62139 in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c62139 +019 SqlAssistPrefs64.dll SCSBrowserForm 2429 +1 TfmSCSBrowser.actDBRefreshUpdate
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 5:
>> EAccessViolation, Access violation at address 0000000005C80EAD in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c80ead +01d SqlAssistPrefs64.dll SCSUnit 1228 +1 TSCSProject.GetDBContext
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 6:
>> EAccessViolation, Access violation at address 0000000005C62139 in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c62139 +019 SqlAssistPrefs64.dll SCSBrowserForm 2429 +1 TfmSCSBrowser.actDBRefreshUpdate
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 7:
>> EAccessViolation, Access violation at address 0000000005C80EAD in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c80ead +01d SqlAssistPrefs64.dll SCSUnit 1228 +1 TSCSProject.GetDBContext
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 8:
>> EAccessViolation, Access violation at address 0000000005C62139 in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c62139 +019 SqlAssistPrefs64.dll SCSBrowserForm 2429 +1 TfmSCSBrowser.actDBRefreshUpdate
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2d50, inner exception level 9:
>> EAccessViolation, Access violation at address 0000000005C80EAD in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000040
05c80ead +01d SqlAssistPrefs64.dll SCSUnit 1228 +1 TSCSProject.GetDBContext
055c9d37 +3f7 SqlAssistPrefs64.dll madExcept 13460 +75 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept
055c9d6a +42a SqlAssistPrefs64.dll madExcept 13464 +79 HandleException
055d6d34 +074 SqlAssistPrefs64.dll madExcept 16652 +4 InterceptAHandleExcept

thread $2910:
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $29b4:
060a21e3 +53 SqlAssistPrefs64.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $195c:
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $3334:
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $2058:
059af81e +2e SqlAssistPrefs64.dll VirtualTrees 6375 +4 TWorkerThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $287c:
060a21e3 +53 SqlAssistPrefs64.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $2aa4:
060a21e3 +53 SqlAssistPrefs64.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $3320:
060a21e3 +53 SqlAssistPrefs64.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $2a18:
060a21e3 +53 SqlAssistPrefs64.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute
00500ff4 +24 SqlEditor64.exe madExcept 17299 +3 HookedTThreadExecute
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

cpu registers:
rax = 0000000000000000
rbx = 0000000009318880
rcx = 0000000000000000
rdx = 000000000012f728
rsi = 0000000005c2f748
rdi = 00000000059a6120
rip = 0000000005c80ead
rsp = 000000000012f620
rbp = 000000000012f620
r8 = 0000000000000000
r9 = 00000000087e7a30
r10 = 000000000012f8df
r11 = 0000000000000246
r12 = 0000000000000000
r13 = 0000000000000000
r14 = 0000000000000000
r15 = 0000000000240860

disassembling:
[...]
05c80e98 mov [rbp+$20], rcx
05c80e9c mov [rbp+$30], rdx
05c80ea0 mov qword ptr [rbp+$38], 0
05c80ea8 nop
05c80ea9 1228 mov rax, [rbp+$20]
05c80ead > cmp qword ptr [rax+$40], 0
05c80eb2 setnz al
05c80eb5 mov [rbp+$2f], al
05c80eb8 1229 movzx rax, byte ptr [rbp+$2f]
05c80ebd test al, al
05c80ebf jz loc_5c80f99
[...]

Thank you so much. I have added this information to the ticket.