SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.176 Pro] - Data Transfer "Exceptions"

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.176 Pro] - Data Transfer "Exceptions"
Author Message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post [SA 9.0.176 Pro] - Data Transfer "Exceptions" Reply with quote
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
[...]

Thu Nov 17, 2016 4:56 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
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
Fri Nov 18, 2016 1:25 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
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)..
Fri Nov 18, 2016 1:28 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Thank you. That's helpful.
Fri Nov 18, 2016 1:38 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.