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

droeschley_109 · June 1, 2016, 11:19am

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 |

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

JohnDorlon · June 1, 2016, 11:29am

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?

JohnDorlon · August 4, 2016, 12:08pm

Found the problem, fixed for next beta.

Topic		Replies	Views
'Compare files' utility Toad for Oracle	5	2979	December 15, 2015
Beta Released (13.2.0.148) Toad for Oracle - Beta	0	735	May 28, 2019
Sync multiple tables issue Toad for SQL Server	3	779	January 16, 2020
Compare Data - Update target with Selected rows from Source - not working. Toad for Oracle - Beta	3	1169	March 7, 2014
Data Compare throws error on number and date fields Toad for Oracle - Beta	5	1213	March 26, 2014