[SA 9.0.176 Pro] - Data Transfer "Exceptions"

[SA 9.0.176 Pro] - Data Transfer "Exceptions"

I'm trying to transfer data to my new DB and I keep getting exceptions.

The weird thing is, I can't pick my target schema if I pick the connection name (local)\SQLEXPRESS2012, that one shows me my "Current" schemas. If I pick my "FRY (ADO)" (which is the source) as the destination then magically my target schemas show up. As if somehow the connections are getting themselves confused in the Data Transfer utility.

I also get an exception bubble when trying to do the "schema picker" on the destination when it's not my "Current" context.

Video:

http://screencast.com/t/OxVDUFOEa2

Exception:

Code:

Exception: Unhandled exception
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 3 days 1 hour
program up time : 6 minutes 29 seconds
processors : 4x Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz
physical memory : 2155/8162 MB (free/total)
free disk space : (C:) 41.66 GB
display mode : 1920x1080, 32 bit
process id : $40f8
allocated memory : 149.36 MB
largest free block : 8180.94 GB
executable : SqlEditor64.exe
current module : SqlAssistPrefs64.dll
module date/time : 2016-10-26 15:24
version : 9.0.176.0
callstack crc : $cbd4e3c5, $2ca144c7, $07de33c2
exception number : 6
exception class : EAccessViolation
exception message : Access violation at address 0000000005802F8F in module 'SqlAssistPrefs64.dll'. Read of address 0000000000000008.

main thread ($3970):
05802f8f +0f SqlAssistPrefs64.dll DBConnectionInfo 232 +1 TMultiConnManager.InitConn
0580307b +1b SqlAssistPrefs64.dll DBConnectionInfo 253 +2 TMultiConnManager.GetConn
059b9fe6 +56 SqlAssistPrefs64.dll ImportXMLForm 3462 +3 TfmImportXML.cbDstChange

thread $3770:
05cc21e3 +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 $3ab4:
055cf81e +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 $4b0:
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

thread $2fa8: <priority>
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

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

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

thread $3dd4:
05cc21e3 +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 $1964:
00500ec9 +49 SqlEditor64.exe madExcept 17280 +7 ThreadExceptFrame

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

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

cpu registers:
rax = 0000000000000000
rbx = 000000000b056f60
rcx = 000000000b056f60
rdx = 0000000000000000
rsi = 0000000000000000
rdi = 0000000000000000
rip = 0000000005802f8f
rsp = 000000000012d6f0
rbp = 000000000012d780
r8 = 000000000012d668
r9 = 0000000000870ab0
r10 = 0000000000000000
r11 = 0000000000000246
r12 = 0000000000000000
r13 = 0000000000000111
r14 = 0000000000000000
r15 = 0000000000c00b3e

disassembling:
[...]
05802f83 push rsi
05802f84 push rbx
05802f85 sub rsp, $28
05802f89 mov rbx, rcx
05802f8c mov rsi, rdx
05802f8f 232 > cmp qword ptr [rsi+8], 0
05802f94 jnz loc_5803047
05802f9a 234 mov rcx, rsi
05802f9d call -$932 ($5802670) ; DBConnectionInfo.TConnInfo.CreateWndHdl
05802fa2 mov r13, rax
05802fa5 236 mov rcx, rbx
[...]

Hi.

I'm unable to reproduce this issue.
I'm reviewing your screencast video and I cannot figure out when you get an exception. In the video everything seems to be working correctly. What am I missing?

Last edited by SysOp on Fri Nov 18, 2016 1:35 pm; edited 1 time in total

	SysOp wrote:
	Hi. I'm unable to reproduce this issue. I reviewing your screencast video and I cannot figure out when you get an exception. In the video everything seems to be working correctly. What am I missing?

When I select my Destination server (local\SQLEXPRESS2012) and click the box to select my schema I get the exception, also the schema that pops up at that time is the schema for my source object not my destination object.

So then if I set my destination server to Fry (ADO) (which is also "CURRENT" and the SOURCE server), and press the button to get the schema, then it picks up the schema for my (local)\SQLEXPRESS2012 instance. (which is the server I am trying to copy to)..

Thank you. That's helpful.