Toad World® Forums

SB data grid column filter of (NonBlanks) causes AV

Correct data is displayed, just get annoying AV whenever I select (NonBlanks).

This is first part - can send the rest if needed.

EurekaLog 7.4.9.3 10.1 Berlin-only BETA 3

Application:

1.1 Start Date : Tue, 19 Jul 2016 10:15:19 -0500
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.10.0.9
1.4 Parameters :
1.6 Up Time : 2 day(s), 4 hour(s), 22 minute(s), 52 second(s)

Exception:

2.1 Date : Thu, 21 Jul 2016 14:38:12 -0500
2.2 Address : 00000000049C3730
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00000000049C3730 in module ‘Toad.exe’. Read of address 0000000000000028.
2.7 ID : D07B0000
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 17-August-2016
4.3 Control Class: TToadCXGridSite
4.4 Control Text :

Computer:

5.2 Total Memory : 8453214208 (7.87 Gb)
5.3 Free Memory : 1051299840 (1002.60 Mb)
5.4 Total Disk : 250056704000 (232.88 Gb)
5.5 Free Disk : 103884500992 (96.75 Gb)
5.6 System Up Time : 4 day(s), 12 hour(s), 22 minute(s), 32 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)
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

Steps to reproduce:

8.1 Text:

Call Stack Information:

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

|*Exception Thread: ID=5308; 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
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=3940; Parent=5308; 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: [ 0F64 / 3940 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=2656; Parent=5308; 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: [ 0A60 / 2656 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5724; Parent=5308; Priority=0
Class=TWorkerThread; Name=[Unnamed thread] Kind: TThread. Thread function: VirtualTrees.WorkerThread.TWorkerThread.Execute + $0. Thread caller: VirtualTrees.WorkerThread.TWorkerThread.Create + $42 (VirtualTrees.WorkerThread.TWorkerThread.Execute)
DeadLock=0; Wait Chain=thread: [ 165C / 5724 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5324; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 14CC / 5324 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=6064; Parent=0; Priority=2
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 17B0 / 6064 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=2236; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 08BC / 2236 ] is blocked
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=5072; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9276; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=10908; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040

Modules Information:

|Handle |Name |Description |Version |Size |Modified |Path |

|0000000003320000|oraunls11.dll |Oracle UNLS Runtime Library |11.1.0.6 |112128 |2010-02-17 20:28:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000003350000|orauts.dll |Oracle CORE UTS PT Library |11.2.0.1 |10240 |2010-02-11 20:31:08|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000003380000|orasnls11.dll |Oracle SNLS Runtime Library |11.1.0.6 |231424 |2010-02-17 20:28:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000004190000|Toad.exe |Toad™ for Oracle® |12.10.0.9 |55005080|2016-07-18 15:45:52|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|0000000010F50000|oracore11.dll |Oracle CORE Library |11.2.0.1 |1411072 |2010-02-11 20:31:06|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000110B0000|oranls11.dll |Oracle NLS Runtime Library |11.1.0.6 |1020928 |2010-02-17 20:28:50|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000111D0000|oranl11.dll |Oracle SQLNet ORANL DLL |11.2.0.1 |430592 |2010-03-15 19:48:00|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000011250000|orantcp11.dll |Oracle SQL
Net ORANTCP DLL |11.2.0.1 |199680 |2010-03-15 19:48:04|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000112A0000|oranldap11.dll |Oracle SQLNet ORANLDAP DLL |11.2.0.1 |290816 |2010-03-15 19:48:00|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000011320000|orancrypt11.dll |Oracle SQL
Net ORANCRYPT DLL |11.2.0.1 |133120 |2010-03-15 19:47:56|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000122A0000|oranhost11.dll |Oracle SQLNet ORANHOST DLL |11.2.0.1 |21504 |2010-03-15 19:47:58|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000012B50000|orancds11.dll |Oracle SQL
Net ORANCDS DLL |11.2.0.1 |8704 |2010-03-15 19:47:56|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000136F0000|oranro11.dll |Oracle SQLNet ORANRO DLL |11.2.0.1 |350720 |2010-03-15 19:48:02|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000137E0000|orantns11.dll |Oracle SQL
Net ORANTNS DLL |11.2.0.1 |48128 |2010-03-15 19:48:04|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000166E0000|oraslax11.dll |Oracle SLAX runtime Library |11.1.0.6 |38400 |2010-01-21 04:35:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016700000|oravsn11.dll |Oracle RDBMS Version Library |11.2.0.1 |9728 |2010-03-30 03:27:38|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016920000|oraocrutl11.dll |Oracle OPSM OCRUTL DLL |11.2.0.1 |49664 |2010-03-26 12:01:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016950000|oracell11.dll |Oracle SAGE shared library |11.1.0.6 |287744 |2010-03-30 03:07:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017230000|oracommon11.dll |Oracle RDBMS Common Library |11.2.0.1 |2827264 |2010-03-30 06:12:30|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000174F0000|oraztkg11.dll |Oracle Kerberos/GSS-API DLL |11.1.0.1 |712704 |2010-03-13 08:39:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000175B0000|orasql11.dll |Oracle SQL Runtime Library |11.1.0.6 |357888 |2010-03-30 06:01:38|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017A30000|oraplc11.dll |Oracle PLC runtime Library |11.1.0.6 |112128 |2010-03-30 06:11:26|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017ED0000|oraocr11.dll |Oracle OPSM OCR DLL |11.2.0.1 |801280 |2010-03-26 12:01:34|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001C350000|oraxml11.dll |Oracle XML Library |11.1.0.6 |5086720 |2010-01-17 09:08:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001CCE0000|orageneric11.dll |Oracle RDBMS Generic Library |11.2.0.1 |15667200|2010-03-30 06:15:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001DBF0000|oran11.dll |Oracle SQLNet ORAN DLL |11.2.0.1 |4518912 |2010-03-15 19:47:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E050000|orannzsbb11.dll |Oracle SQL
Net ORANNZSBB11 DLL |11.0.0.1 |1564672 |2010-03-13 08:39:50|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E1E0000|oraldapclnt11.dll |Oracle Internet Directory Client Library |10.1.4.0 |2015232 |2010-03-13 08:39:48|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E3E0000|orazt11.dll |Oracle SQLNet SUPPORT DLL |11.1.0.1 |2003968 |2010-03-13 08:39:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E5D0000|orapls11.dll |Oracle PLS runtime Library |11.1.0.6 |5360128 |2010-03-30 06:11:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001EB00000|oraplp11.dll |Oracle PLP runtime Library |11.1.0.6 |4136960 |2010-03-30 06:12:06|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001EF00000|orahasgen11.dll |Oracle PCW generic Library |11.2.0.1 |2950656 |2010-03-26 11:57:32|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001F1E0000|oraocrb11.dll |Oracle OPSM OCRB DLL |11.2.0.1 |978432 |2010-03-26 12:01:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001F5C0000|oci.dll |Oracle Call Interface |11.2.0.1 |657408 |2010-03-30 06:03:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000022550000|QSE.dll |QSE DLL |12.10.0.9 |2899864 |2016-07-18 14:46:02|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|0000000055350000|x2coreQ5.dll |Print Driver Component |5351.800.0.0 |16546304|2014-02-19 13:03:28|C:\Windows\System32\spool\drivers\x64\3\ |
|000000005C110000|QP5.dll | |5.297.16190.29297 |22374808|2016-07-08 16:59:56|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|0000000062A10000|msvcp80.dll |Microsoft® C++ Runtime Library |8.0.50727.6195 |1068368 |2011-06-29 11:32:00|C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6195_none_88e41e092fab0294\ |
|0000000062E50000|x2rpsQ5.dll |PS Print Driver Rendering Component |5351.800.0.0 |1603072 |2014-02-19 12:54:56|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000062FE0000|x2utilQ5.dll |Print Driver Component |5351.800.0.0 |1971712 |2014-02-19 12:54:46|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000066790000|msvcr80.dll |Microsoft® C Runtime Library |8.0.50727.6195 |802640 |2011-06-29 11:32:00|C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6195_none_88e41e092fab0294\ |
|0000000068BB0000|x2upQ5.dll |Print Driver UI Component |5351.800.0.0 |2265600 |2014-02-19 12:54:56|C:\Windows\System32\spool\drivers\x64\3\ |
|000000006E770000|x2wftuQ5.dll |Print Driver Workflow Component |5351.800.0.0 |481280 |2014-02-19 12:54:32|C:\Windows\System32\spool\drivers\x64\3\ |
|000000006E9C0000|x2fputQ5.dll |Print Ticket Provider Component |5351.800.0.0 |539136 |2014-02-19 12:54:26|C:\Windows\System32\spool\drivers\x64\3\ |
|000000006EA50000|x2txtQ5.dll |Print Driver Resources |5351.800.0.0 |285184 |2014-02-19 11:54:20|C:\Windows\System32\spool\drivers\x64\3\Xerox\Language Data\V5.0\en-us\ |
|0000000072B70000|x2comsQ5.dll |Network Communications Library |5351.800.0.0 |659968 |2014-02-19 12:54:34|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000072C40000|icmp.dll |ICMP DLL |6.1.7601.23403 |3072 |2016-03-25 13:58:11|C:\Windows\System32\ |
|0000000072C50000|wmi.dll |WMI DC and DP functionality |6.1.7601.23403 |5120 |2016-03-25 14:04:11|C:\Windows\System32\ |
|0000000072C70000|security.dll |Security Support Provider Interface |6.1.7600.16385 |5120 |2009-07-13 20:32:34|C:\Windows\System32\ |
|0000000072FD0000|TortoiseSVN.dll |TortoiseSVN shell extension client |1.8.7.25475 |494848 |2014-05-06 20:37:48|C:\Program Files\TortoiseSVN\bin\ |
|0000000073050000|msvcp100.dll |Microsoft® C Runtime Library |10.0.40219.325 |608080 |2015-08-03 19:34:00|C:\Program Files\Microsoft Office 15\root\office15\ |
|00000000730F0000|msvcr100.dll |Microsoft® C Runtime Library |10.0.40219.325 |829264 |2015-08-03 19:34:00|C:\Program Files\Microsoft Office 15\root\office15\ |
|0000000073300000|libaprutil_tsvn.dll |Apache Portable Runtime Utility Library |1.5.3.0 |271616 |2014-05-06 20:37:34|C:\Program Files\TortoiseSVN\bin\ |
|0000000074A30000|libapr_tsvn.dll |Apache Portable Runtime Library |1.5.1.0 |181504 |2014-05-06 20:37:34|C:\Program Files\TortoiseSVN\bin\ |
|0000000074A60000|TortoiseStub.dll | |1.8.7.25475 |76032 |2014-05-06 20:37:48|C:\Program Files\TortoiseSVN\bin\ |
|0000000074A80000|TortoiseOver

It looks like the problem is happening for you with NUMBER fields and Toad’s scientific notation option is disabled.

Is it happening with other field types too? Can you reproduce this in the latest beta? It works fine for me.

still happening in .12 beta. Only happens when there are “more rows to fetch”. Once all rows are fetched, it I no longer get the AV.

happens for character columns also - again only when “more rows exist” is in the status line.

EurekaLog 7.4.9.3 10.1 Berlin-only BETA 3

Application:

1.1 Start Date : Mon, 25 Jul 2016 16:32:18 -0500
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.10.0.12
1.4 Parameters :
1.6 Up Time : 3 day(s), 17 hour(s), 16 minute(s), 47 second(s)

Exception:

2.1 Date : Fri, 29 Jul 2016 09:49:05 -0500
2.2 Address : 0000000009544EF6
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 0000000009544EF6 in module ‘Toad.exe’. Read of address 000007FFFFC04AFF.
2.7 ID : 45260000
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 24-August-2016
4.3 Control Class: TToadCXGridSite
4.4 Control Text :

Computer:

5.2 Total Memory : 8453214208 (7.87 Gb)
5.3 Free Memory : 1103335424 (1.03 Gb)
5.4 Total Disk : 250056704000 (232.88 Gb)
5.5 Free Disk : 100675878912 (93.76 Gb)
5.6 System Up Time : 5 day(s), 5 hour(s), 3 minute(s), 19 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)
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

Steps to reproduce:

8.1 Text:

Call Stack Information:

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

|*Exception Thread: ID=8892; 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
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I can’t reproduce it. I’ve tried 32 and 64 bits, varchar2 and number columns.

Will you send me your User Files folder? John.Dorlon@quest.com

-John

John, any progress on this. I’m hoping you received my user files zip on 8/3. If not, I can try to resend.

Oh, sorry I never got back to you on this. I never was able to reproduce it. Does this happen for you on every table that doesn’t have all rows fetched in the first fetch?

Dale and I have been talking offline about this.

So just to close up the thread - it should be fixed in the next beta.