Stream read error when executing query against V$SQL in Editor

rwiggins · March 21, 2018, 12:06pm

The following SQL executes once for me in a newly opened Toad 12.12.0.39 (or 12.10.0.30) Editor tab.

SELECT S.sql_fulltext FROM v$sql S

I get a “Stream read error.” popup if…

I try to go to the bottom of the results in the Data Grid.
I try to re-execute the same SQL in the same editor after the error occurs the first time. (Will execute once if SQL is copied to another Editor window.)
I leave and then return focus to aToad window and/or Editor tab that has already produced the error.
Started out with a more complex SQL statement, but reduced to bare minimum that would produce the symptoms.

May be related to text content in the CLOB SQL_FULLTEXT column. Adding an arbitrary WHERE clause (e.g. WHERE UPPER(S.sql_fulltext) LIKE ‘%DUAL%’) to limit the results returns less rows and can be run repeatedly without issue. May try to pin down specific SQL text that may be causing the trouble and will report back if I come up with anything useful.

DB is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.

Oracle Client is Release 12.1.0.2.0 Production on Wed Mar 21 14:08:34 2018.

Works fine against any Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production. No issues at all.

Have pasted the error report below offered when I try #2 above. The popup seen for #1 doesn’t offer the error report.

Would love to get my more complex V$SQL query working as I use it for diagnosis and tuning and currently have to use SQL Developer (gasp!) instead on my 12.2 DBs.

Thanks!

-Rick

EurekaLog 7.5.1.0

Application:

1.1 Start Date : Wed, 21 Mar 2018 09:15:01 -0400
1.2 Name/Description: Toad.exe - (Toad® for Oracle)
1.3 Version Number : 12.12.0.39
1.4 Parameters :
1.6 Up Time : 5 hour(s), 18 minute(s), 22 second(s)

Exception:

2.1 Date : Wed, 21 Mar 2018 14:33:24 -0400
2.2 Address : 00000000042F7EFD
2.3 Module Name: Toad.exe - (Toad® for Oracle)
2.5 Type : EReadError
2.6 Message : Stream read error.
2.7 ID : 2E320000
2.8 Count : 1
2.11 Sent : 0

User:

3.2 Name: Bob

Active Controls:

4.1 Form Class : TfrmMain
4.2 Form Text : Toad for Oracle - [SCHEDULER@OMXT001 - Editor (New 12 *)]
4.3 Control Class: TToadCXGridSite
4.4 Control Text :

Computer:

5.2 Total Memory : 17054638080 (15.88 Gb)
5.3 Free Memory : 7991861248 (7.44 Gb)
5.4 Total Disk : 511031898112 (475.94 Gb)
5.5 Free Disk : 99414933504 (92.59 Gb)
5.6 System Up Time : 6 hour(s), 45 minute(s), 40 second(s)
5.7 Processor : Intel® Core™ i7-6500U CPU @ 2.50GHz
5.8 Display Mode : \.\DISPLAY1: 1280x1024x32 96 DPI @ 2560x-227, \.\DISPLAY2[PRIMARY]: 2560x1440x32 96 DPI @ 0x0, \.\DISPLAY3: 1280x1024x32 96 DPI @ 3840x-227
5.9 Display DPI : 96
5.10 Video Card : Intel® HD Graphics 520 (driver 20.19.15.4457 - RAM 1073741824)
5.11 Printer : SHARP MX-M453N PCL6 (driver 0.00.0000.106.0145)
5.12 Virtual Machine:

Operating System:

6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build # : 7601 (6.1.7601.18015)
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 |

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

Modules Information:

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

|0000000002740000|wmi.dll |WMI DC and DP functionality |6.1.7601.17787 |5120 |2013-12-03 20:09:27|C:\Windows\System32\ |
|0000000004190000|Toad.exe |Toad® for Oracle |12.12.0.39 |139216296|2017-09-28 09:33:24|C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Toad for Oracle 12.12\ |
|0000000010680000|icmp.dll |ICMP DLL |6.1.7600.16385 |3072 |2009-07-13 21:27:58|C:\Windows\System32\ |
|0000000011290000|MfeResource.dll |McAfee Endpoint Encryption for Files and Folders String and Graphical Resources|4.3.1.138 |1173872 |2015-05-18 08:00:22|C:\Program Files\McAfee\Endpoint Encryption for Files and Folders\ |
|0000000014DC0000|SR0E2DRV.DLL |Sharp Printer Driver |0.3.0.0 |597504 |2012-02-03 13:47:36|C:\Windows\System32\spool\drivers\x64\3\ |
|000000001DAB0000|QSE.dll |Quest® Script Engine |12.12.0.39 |2898856 |2017-09-28 09:08:04|C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Toad for Oracle 12.12\ |
|00000000227B0000|QP5.dll | |5.318.17248.26858 |24207848 |2017-09-13 11:26:40|C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Toad for Oracle 12.12\ |
|0000000063480000|security.dll |Security Support Provider Interface |6.1.7600.16385 |5120 |2009-07-13 21:32:34|C:\Windows\System32\ |
|000000006A900000|SR0EU.DLL |Sharp Printer Driver |0.3.1536.0 |114688 |2011-12-08 08:56:08|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000071A20000|msvcr100.dll |Microsoft® C Runtime Library |10.0.40219.325 |829264 |2011-06-11 02:15:38|C:\Windows\System32\ |
|0000000071B00000|msvcp100.dll |Microsoft® C Runtime Library |10.0.40219.325 |608080 |2011-06-11 02:15:38|C:\Windows\System32\ |
|00000000734B0000|msvcr90.dll |Microsoft® C Runtime Library |9.0.30729.6161 |641360 |2016-01-22 19:42:19|C:\Windows\winsxs\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_08e61857a83bc251\ |
|0000000073560000|msvcp90.dll |Microsoft® C++ Runtime Library |9.0.30729.6161 |853328 |2016-01-22 19:42:19|C:\Windows\winsxs\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_08e61857a83bc251\ |
|0000000073790000|TortoiseOverlays.dll |Tortoise overlay handler shim |1.1.4.26626 |115072 |2015-08-25 20:58:06|C:\Program Files\Common Files\TortoiseOverlays\ |
|0000000074A60000|mdnsNSP.dll |Bonjour Namespace Provider |3.1.0.1 |133392 |2015-08-12 17:03:42|C:\Program Files\Bonjour\ |
|0000000076E40000|user32.dll |Multi-User Windows USER API Client DLL |6.1.7601.23594 |1009152 |2016-11-10 12:32:41|C:\Windows\System32\ |
|0000000076F40000|kernel32.dll |Windows NT BASE API Client DLL |6.1.7601.23677 |1163264 |2017-02-09 12:31:56|C:\Windows\System32\ |
|0000000077060000|ntdll.dll |NT Layer DLL |6.1.7601.23677 |1732864 |2017-02-09 12:33:37|C:\Windows\System32\ |
|0000000077220000|normaliz.dll |Unicode Normalization DLL |6.1.7600.16385 |2560 |2009-07-13 21:31:40|C:\Windows\System32\ |
|0000000077230000|psapi.dll |Process Status Helper |6.1.7600.16385 |9216 |2009-07-13 21:41:53|C:\Windows\System32\ |
|0000000180000000|MfeFfDesktopIntegration.dll |McAfee Endpoint Encryption for Files and Folders Explorer Extension |4.3.1.138 |1507184 |2015-05-18 08:01:46|C:\Program Files\McAfee\Endpoint Encryption for Files and Folders\ |
|000007FEBAB10000|orahasgen12.dll |Oracle PCW generic Library |12.1.0.2 |10691072 |2014-09-03 03:59:38|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBB550000|oraplp12.dll |Oracle PLP runtime Library |12.1.0.2 |4205056 |2014-09-11 02:58:02|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBB960000|orapls12.dll |Oracle PLS runtime Library |12.1.0.2 |6395392 |2014-09-11 02:57:54|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBBF80000|oraztkg12.dll |Oracle Kerberos/GSS-API DLL |11.1.0.1 |4934656 |2014-08-01 07:47:00|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBC440000|orazt12.dll |Oracle SQLNet SUPPORT DLL |11.1.0.1 |5101056 |2014-08-01 07:46:44|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBC930000|oraldapclnt12.dll |Oracle Internet Directory Client Library |10.1.4.0 |5029376 |2014-08-01 07:46:36|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEBCE10000|orageneric12.dll |Oracle RDBMS Generic Library |12.1.0.2 |19112960 |2014-09-11 03:01:52|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC3770000|oran12.dll |Oracle SQLNet ORAN DLL |12.1.0.2 |4529152 |2014-08-05 08:36:22|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC3BD0000|orannzsbb12.dll |Oracle Security Library |12.1.0.2 |4694528 |2014-08-01 07:46:50|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC4370000|oraasmclnt12.dll |ASM Client Access Library |12.1.0.2 |1066496 |2014-09-11 03:33:50|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC4480000|oraxml12.dll |Oracle XML Library |12.1.0.2 |7452672 |2014-08-04 05:57:02|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC4BB0000|oracommon12.dll |Oracle RDBMS Common Library |12.1.0.2 |6919680 |2014-09-11 02:59:24|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC5800000|oci.dll |Oracle Call Interface |12.1.0.0 |641536 |2014-09-11 02:49:48|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC58B0000|oraocrb12.dll |Oracle OPSM OCRB DLL |12.1.0.2 |956416 |2014-09-03 03:59:24|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC59A0000|oraocr12.dll |Oracle OPSM OCR DLL |12.1.0.2 |1218048 |2014-09-03 03:59:26|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC5AD0000|oranls12.dll |Oracle NLS Runtime Library |12.1.0.2 |1041408 |2014-08-04 09:17:24|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC5BE0000|oracore12.dll |Oracle CORE Library |12.0.0.0 |1755136 |2014-08-01 19:46:40|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC5DA0000|oraclient12.dll |Oracle RDBMS Client Library |12.1.0.2 |5630464 |2014-09-11 03:00:10|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC7030000|oranl12.dll |Oracle SQLNet ORANL DLL |12.1.0.2 |535552 |2014-08-05 08:36:08|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC72B0000|orasql12.dll |Oracle SQL Runtime Library |12.1.0.2 |310784 |2014-09-11 02:48:26|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEC7340000|SciLexer.dll |Scintilla.DLL - a Source Editing Component |3.6.1.2 |675328 |2016-12-09 13:34:40|C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Toad for Oracle 12.12\ |
|000007FEC9320000|hhctrl.ocx |Microsoft® HTML Help Control |6.1.7600.16385 |701952 |2009-07-13 21:38:53|C:\Windows\System32\ |
|000007FEC9540000|oracell12.dll |Oracle SAGE shared library |11.1.0.6 |488960 |2014-09-11 03:26:42|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FECA9C0000|oraons.dll |Oracle Notification Service |12.1.0.1 |214528 |2014-08-03 13:59:52|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FECB800000|GrooveIntlResource.dll | |16.0.4504.1000 |8911560 |2017-02-22 23:49:34|C:\Program Files\Microsoft Office\Office16\1033\ |
|000007FECC240000|GROOVEEX.DLL |Microsoft OneDrive for Business Extensions |16.0.4504.1000 |2179376 |2017-02-22 23:51:54|C:\Program Files\Microsoft Office\Office16\ |
|000007FECC460000|msftedit.dll |Rich Text Edit Control, v4.1 |5.41.21.2510 |799744 |2010-11-20 23:24:01|C:\Windows\System32\ |
|000007FECCAD0000|cscui.dll |Client Side Caching UI |6.1.7601.17514 |498688 |2010-11-20 23:24:41|C:\Windows\System32\ |
|000007FED1870000|cscdll.dll |Offline Files Temporary Shim |6.1.7601.17514 |30208 |2010-11-20 23:23:51|C:\Windows\System32\ |
|000007FED7830000|oraclsce12.dll |Oracle Clusterware Cluster Events Library |12.0.0.0 |265216 |2014-09-03 03:59:46|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FED79B0000|api-ms-win-downlevel-shlwapi-l2-1-0.dll |ApiSet Stub DLL |6.2.9200.16492 |5632 |2013-12-03 19:35:31|C:\Windows\System32\ |
|000007FED7B20000|EhStorShell.dll |Windows Enhanced Storage Shell Extension DLL |6.1.7600.16385 |203264 |2009-07-13 21:40:36|C:\Windows\System32\ |
|000007FEDBF10000|riched20.dll |Rich Text Edit Control, v3.1 |5.31.23.1230 |633344 |2010-11-20 23:24:15|C:\Windows\System32\ |
|000007FEDBFD0000|oranro12.dll |Oracle SQLNet ORANRO DLL |12.1.0.2 |339456 |2014-08-05 08:36:04|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEDDBD0000|oranldap12.dll |Oracle SQLNet ORANLDAP DLL |12.1.0.2 |284160 |2014-08-05 08:36:20|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEDF2F0000|browcli.dll |Browser Service Client DLL |6.1.7601.17887 |59392 |2013-12-03 20:10:48|C:\Windows\System32\ |
|000007FEDF8E0000|ntshrui.dll |Shell extensions for sharing |6.1.7601.17755 |509952 |2013-12-03 20:09:01|C:\Windows\System32\ |
|000007FEDFEC0000|orantcp12.dll |Oracle SQLNet ORANTCP DLL |12.1.0.2 |190464 |2014-08-05 08:36:10|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEDFF00000|orawsec12.dll | | |236544 |2014-09-11 02:29:54|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE0050000|tiptsf.dll |Tablet PC Input Panel Text Services Framework |6.1.7601.18984 |503296 |2015-09-01 14:14:28|C:\Program Files\Common Files\microsoft shared\ink\ |
|000007FEE0150000|wbemdisp.dll |WMI Scripting |6.1.7600.16385 |266752 |2009-07-13 21:41:56|C:\Windows\System32\wbem\ |
|000007FEE04B0000|oraplc12.dll |Oracle PLC runtime Library |12.1.0.2 |108032 |2014-09-11 02:57:46|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE09A0000|orasnls12.dll |Oracle SNLS Runtime Library |12.1.0.2 |241664 |2014-08-04 08:53:34|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE0ED0000|msvcp140.dll |Microsoft® C Runtime Library |14.10.25008.0 |627368 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE0F70000|gitdll.dll |libgit (based on git version 2.15) implementation for TortoiseGit |2.6.0.0 |1074848 |2018-02-17 16:43:50|C:\Program Files\TortoiseGit\bin\ |
|000007FEE10B0000|ucrtbase.dll |Microsoft® C Runtime Library |10.0.10586.9 |994760 |2015-11-19 10:07:55|C:\Windows\System32\ |
|000007FEE11B0000|libgit2_tgit.dll |libgit2 - the Git linkable library |0.26.0.0 |1024160 |2018-02-17 16:43:52|C:\Program Files\TortoiseGit\bin\ |
|000007FEE12B0000|TortoiseGit.dll |TortoiseGit shell extension client |2.6.0.0 |662688 |2018-02-17 16:43:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE1360000|TortoiseShell64.dll |TortoiseShell |1.12.5.6 |2041856 |2011-01-24 14:13:20|C:\Program Files\TortoiseCVS\ |
|000007FEE1580000|googledrivesync64.dll |Google Drive shell extension |3.39.8370.7843 |775064 |2018-01-29 13:42:34|C:\Program Files (x86)\Google\Drive\ |
|000007FEE1640000|FileSyncShell64.dll |Microsoft OneDrive Shell Extension |18.25.204.9 |2941600 |2018-03-09 09:38:56|C:\Users\rwiggins\AppData\Local\Microsoft\OneDrive\18.025.0204.0009\amd64\ |
|000007FEE2510000|crshhndl.dll |Crash handler library |1.0.15.0 |68768 |2018-02-17 16:43:50|C:\Program Files\TortoiseGit\bin\ |
|000007FEE2900000|qwave.dll |Windows NT |6.1.7600.16385 |242688 |2009-07-13 21:41:53|C:\Windows\System32\ |
|000007FEE5530000|IconCodecService.dll |Converts a PNG part of the icon to a legacy bmp icon |6.1.7600.16385 |14336 |2009-07-13 21:41:05|C:\Windows\System32\ |
|000007FEE5540000|oraocrutl12.dll |Oracle OPSM OCRUTL DLL |12.1.0.2 |84480 |2014-09-03 03:59:20|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE58D0000|oravsn12.dll |Oracle RDBMS Version Library |12.1.0.2 |10240 |2014-09-10 22:12:38|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE58E0000|api-ms-win-crt-multibyte-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |26304 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE58F0000|oraslax12.dll |Oracle SLAX runtime Library |12.1.0.2 |35840 |2014-08-06 11:35:10|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE5900000|orantns12.dll |Oracle SQLNet ORANTNS DLL |12.1.0.2 |41984 |2014-08-05 08:36:18|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE5990000|orancrypt12.dll |Oracle SQLNet ORANCRYPT DLL |12.1.0.2 |100864 |2014-08-05 08:36:16|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE59B0000|oraunls12.dll |Oracle UNLS Runtime Library |12.1.0.2 |105472 |2014-08-04 08:53:32|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE6100000|api-ms-win-crt-math-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |27840 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE6110000|api-ms-win-crt-locale-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |19136 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE6C00000|orancds12.dll |Oracle SQLNet ORANCDS DLL |12.1.0.2 |8192 |2014-08-05 08:35:48|C:\Oracle\product\12.1.0\client\BIN\ |
|000007FEE74C0000|api-ms-win-crt-environment-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |19136 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE7660000|api-ms-win-crt-filesystem-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |20672 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE8420000|api-ms-win-crt-time-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |21184 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE8430000|api-ms-win-crt-utility-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |19136 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE8AD0000|npmproxy.dll |Network List Manager Proxy |6.1.7600.16385 |31744 |2009-07-13 21:41:53|C:\Windows\System32\ |
|000007FEE8B00000|api-ms-win-crt-convert-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |22720 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE8C50000|dssenh.dll |Microsoft Enhanced DSS and Diffie-Hellman Cryptographic Provider |6.1.7600.16385 |190880 |2009-07-13 21:43:36|C:\Windows\System32\ |
|000007FEE8D10000|oledlg.dll |OLE User Interface Support |6.1.7600.16385 |128000 |2009-07-13 21:41:53|C:\Windows\System32\ |
|000007FEE8FD0000|cscapi.dll |Offline Files Win32 API |6.1.7601.17514 |46080 |2010-11-20 23:23:51|C:\Windows\System32\ |
|000007FEE93B0000|wsnmp32.dll |Microsoft WinSNMP v2.0 Manager API |6.1.7601.17514 |67072 |2010-11-20 23:24:28|C:\Windows\System32\ |
|000007FEE97B0000|api-ms-win-crt-stdio-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |24768 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE97C0000|api-ms-win-crt-heap-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |19136 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEE9B10000|wmiutils.dll |WMI |6.1.7600.16385 |137216 |2009-07-13 21:41:56|C:\Windows\System32\wbem\ |
|000007FEE9B40000|wbemsvc.dll |WMI |6.1.7600.16385 |64512 |2009-07-13 21:41:56|C:\Windows\System32\wbem\ |
|000007FEE9D80000|dbghelp.dll |Windows Image Helper |6.1.7601.17514 |1087488 |2010-11-20 23:24:00|C:\Windows\System32\ |
|000007FEE9EB0000|ntdsapi.dll |Active Directory Domain Services API |6.1.7600.16385 |152064 |2009-07-13 21:41:53|C:\Windows\System32\ |
|000007FEE9EE0000|fastprox.dll |WMI Custom Marshaller |6.1.7600.16385 |909312 |2009-07-13 21:40:51|C:\Windows\System32\wbem\ |
|000007FEEA460000|cabinet.dll |Microsoft® Cabinet File API |6.1.7601.17514 |94720 |2010-11-20 23:24:32|C:\Windows\System32\ |
|000007FEEA580000|api-ms-win-crt-string-l1-1-0.dll |ApiSet Stub DLL |10.0.14393.795 |24768 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEEA7A0000|api-ms-win-core-file-l1-2-0.dll |ApiSet Stub DLL |10.0.10586.9 |11616 |2015-11-19 10:07:55|C:\Windows\System32\ |
|000007FEEA850000|VCRUNTIME140.dll |Microsoft® C Runtime Library |14.10.25008.0 |87224 |2018-02-17 14:06:54|C:\Program Files\TortoiseGit\bin\ |
|000007FEEA8D0000|api-ms-win-core-processthreads-l1-1-1.dll|ApiSet Stub DLL |10.0.10586.9 |12128 |2015-11-19 10:07:55|C:\Windows\System32\ |
|000007FEEA9D0000|zlib1_tgit.dll |zlib data compression library |1.2.11.0 |106144 |2018-02-17 16:43:56|C:\Program Files\TortoiseGit\bin\ |
|000007FEEAAE0000|api-ms-win-core-localization-l1-2-0.dll |ApiSet Stub DLL |10.0.10586.9 |14176 |2015-11-19 10:07:55|C:\Windows\System32\ |
|000007FEEAB00000|TortoiseGitStub.dll |TortoiseGit sh

rwiggins · March 21, 2018, 12:08pm

And yes, I tried the suggestions in the other posts for this error, even though the context was different, and removed the specified data files. Didn’t help.

-Rick

JohnDorlon · March 21, 2018, 12:17pm

The content of the SQL_FULLTEXT could be the cause. I wasn’t able to reproduce any problems here. Do you have Options -> Data Grids -> Data -> “Preview CLOB and LONG data” checked or unchecked? That could also be a contributing factor. Error would be less likely to happen with that option unchecked (but then would likely still happen if you double-clicked a cell that had some offending data)

rwiggins · March 21, 2018, 1:23pm

The “Preview CLOB and LONG data” option is checked.

If unchecked, I don’t get the error as reported, and it’s a lot faster, but I also can’t review the SQL_FULLTEXT with as much ease, which reduces the utility of my query.

Gonna turn it back on.

If I stumble across a specific SQL statement that causes the error, I’ll share.

-Rick

rwiggins · March 21, 2018, 2:30pm

Another tidbit…

If I retrieve 100 or less rows, I seem to be OK, no matter what I do, even with the “Preview CLOB and LONG data” option is checked.

With this simple SQL,I can retrieve up to a certain point before things explode. I can retrieve whatever it retrieves with the first fetch (100 rows, in my case) without issue.

SELECT S.sql_id,S.sql_fulltext FROM v$sql S

If I am careful not to scroll past row 100, open the Grid Popup Editor for SQL_FULLTEXT, and then advance forward or backward one row at a time, I’m fine until I try to go past row 100. If I do, the status line says it fetched 25 more but I then get the “Stream read error.” popup and then my Editor tab is unusable. 100 seems conspicuously “round” but that may be a red herring.

Also, I then un-checked the “Preview CLOB and LONG data” option and tried the same thing, opening the (HUGECLOB) viewer on a row in the 90s and stepping past row 100. I never got the “Stream read error.” popup, but once I got past 100 I noticed my statements started including some extraneous characters, disappear, or contain nothing but gobbledygook or non-SQL nonsense. Here’s one of the more readable examples, which obviously isn’t a SQL statement.

C:\Data\Toad-12.12\User Files\SavedSQL.xmlaWtlICcl

The actual SQL_FULLTEXT for the related SQL_ID is this.

SELECT /+ FULL§ +/ * FROM “OMXMASTER”.“CLIENT” P

Looks like we may be overrunning a memory buffer of some sort.

My original, more complex V$SQL query with more columns and WHERE clause won’t even make it past 1 row before the SQL_FULLTEXT is fouled up.

If you have any other suggestions for me to try, I’ll let you know my findings.

Thanks!

-Rick

JohnDorlon · March 21, 2018, 2:41pm

can you give it a try in the beta?

JohnDorlon · March 21, 2018, 2:52pm

Ah-hah! I am able to reproduce it this way:

64 bit Toad 12.12 connected to 12.2 database, “Preview CLOB/LONG” checked.
run “SELECT S.sql_id,S.sql_fulltext FROM v$sql S” in editor.
double-click the cell in first row to show popup editor.
close popup editor, scroll down past row #100.

I can also reproduce this in the 32 bit current beta. Haven’t tried 64 yet bit but bitness doesn’t seem relevant at this point. We did have a bug a little while back with the CLOB popup editor, which was fixed. I was hoping that was relevant but I guess not. I’ll try to figure out the cause of this one tomorrow.

rwiggins · March 21, 2018, 3:01pm

Sounds promising…

To muddy the waters even further, I’m currently downloading the Oracle 12.2 client…! [;)]

Thanks for your attention!

-Rick

JohnDorlon · March 21, 2018, 3:15pm

It seems related to the 12.2 server. I get the error with 12.1 or 12.2 client.

I do not have any problems on a 12.1 server.

JohnDorlon · March 22, 2018, 10:28am

More Info:

I can repeat the problem with a query as simple as:

       select level, to_clob(level) LEVEL_AS_CLOB
from dual connect by level <= 200;

The problem can be reproduced without using the popup CLOB editor.

I can reproduce a similar problem in a simple demo app. It seems to be coming from our 3rd party data access layer. I have opened a support case with them. Will post an update when I get one.

-John

dbfix · June 28, 2018, 5:51am

I’m facing the same problem.

Is there any workaround or a fix available?

paul.walker · August 21, 2018, 4:19pm

I’m also encountering this issue - are there any updates please?

JohnDorlon · August 21, 2018, 4:31pm

As I mentioned initially, this is a problem with a 3rd party component vendor that we use to build Toad.

We have had an update to that component about a month ago but it did not fix the problem.

I have heard no update from our 3rd party vendor about this since I reported the bug with them 6 months ago. I just asked again about it.

I have noticed that I do not get the error when I uncheck this option in Toad: Options -> Data Grids -> Data -> Preview CLOB and LONG data.

paul.walker · August 21, 2018, 4:58pm

Thanks. Yes, turning off “Preview CLOB and LONG data” works, but then I can’t see that data in the grid…

Actually, I’ve just found that putting TO_CHAR around CLOB fields also seems to work, so taking your earlier example:

select level, to_clob(level) LEVEL_AS_CLOB from dual connect by level <= 200;

Changing it to:

select level, to_char(to_clob(level)) LEVEL_AS_CLOB from dual connect by level <= 200;

Not sure off hand what any limitations of this might be, but it just allowed me to do what I needed on my particular use-case

JohnDorlon · August 21, 2018, 5:25pm

If you turn off the preview, you can still double-click on the (HUGECLOB) cell to see the data for the rows that you need it. By the way, the lowercase (HugeClob) indicates null.

To_char will definitely make this go away. In this case you are limited to the first 4000 characters.

JohnDorlon · September 6, 2018, 12:41pm

This will be fixed next beta and in 13.1 GA.