Toad World® Forums

Compare Data - can't sync more than 2 rows at a time without getting an Invalid Argument error

Data compare show multiple “Source only” rows. When I select 2 rows to synchronize (insert into Target), it works, but selecting more than 2, I get the following error:

EurekaLog 7.3.1.0

Application:

1.1 Start Date : Tue, 31 May 2016 08:59:28 -0500
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.9.0.66
1.4 Parameters :
1.6 Up Time : 1 day(s), 4 hour(s), 12 minute(s), 22 second(s)

Exception:

2.1 Date : Wed, 1 Jun 2016 13:11:50 -0500
2.2 Address : 000000000421F49A
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EVariantInvalidArgError
2.6 Message : Invalid argument.
2.7 ID : 5B850000
2.8 Count : 1
2.11 Sent : 0

User:

3.2 Name : CHX
3.3 Email:

Active Controls:

4.1 Form Class : TfrmMain
4.2 Form Text : Toad for Oracle (x64) BETA expires on 31-July-2016
4.3 Control Class: TfrmMain
4.4 Control Text : Toad for Oracle (x64) BETA expires on 31-July-2016

Computer:

5.2 Total Memory : 8453214208 (7.87 Gb)
5.3 Free Memory : 1305579520 (1.22 Gb)
5.4 Total Disk : 250056704000 (232.88 Gb)
5.5 Free Disk : 106490200064 (99.18 Gb)
5.6 System Up Time : 3 day(s), 6 hour(s), 45 minute(s), 9 second(s)
5.7 Processor : Intel® Core™2 Duo CPU E8400 @ 3.00GHz
5.12 Virtual Machine:

Operating System:

6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build #: 7601 (6.1.7601.23403)

Steps to reproduce:

8.1 Text:

Call Stack Information:

|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |

|*Exception Thread: ID=2896; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |

Comment=
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5148; Parent=2896; Priority=0
Class=TSendThread; Name=[Unnamed thread] Kind: TThread. Thread function: CSLog.TSendThread.Execute + $0. Thread caller: CSLog.TSendThread.Create + $3C (CSLog.TSendThread.Execute)
DeadLock=0; Wait Chain=thread: [ 141C / 5148 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=2740; Parent=2896; Priority=0
Class=TSaveSettingsThread; Name=[Unnamed thread] Kind: TThread. Thread function: tdSaveSettings.TSaveSettingsThread.Execute + $0. Thread caller: tdSaveSettings.TSaveSettingsThread.Create + $3C (tdSaveSettings.TSaveSettingsThread.Execute)
DeadLock=0; Wait Chain=thread: [ 0AB4 / 2740 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5736; Parent=2896; Priority=0
Class=TWorkerThread; Name=[Unnamed thread] Kind: TThread. Thread function: VirtualTrees.TWorkerThread.Execute + $0. Thread caller: VirtualTrees.TWorkerThread.Create + $42 (VirtualTrees.TWorkerThread.Execute)
DeadLock=0; Wait Chain=thread: [ 1668 / 5736 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5264; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1490 / 5264 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5376; Parent=0; Priority=2
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1500 / 5376 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9856; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=4816; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9940; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 26D4 / 9940 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=3600; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 0E10 / 3600 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9324; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 246C / 9324 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9912; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 26B8 / 9912 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9928; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8196; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8708; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 2204 / 8708 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8792; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 2258 / 8792 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=6852; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1AC4 / 6852 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7588; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1DA4 / 7588 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040

This one worked fine for me, but maybe depends on data types. Can you send me the DDL for your table and a few row’s worth of insert statements?

Found the problem, fixed for next beta.