Toad 12.9.0.38b x64
Trying to get table script for partition (run as owner of the table).
Access violation at address 0000000008500657 in module 'Froggy_129b.exe'. Read of address 000000000000001D
Tried refresh, restart Toad and nothing ... all the time same error
Froggy is mine rename of toad.exe to prevent some "DBA" task on killing session...just renamed Toad.exe to that name-done that in last one year all the time with no problems.
This was in previous release...
12.9.0.39 has the same problem.
Damir - I haven’t been able to replicate yet, but partitioning can get kind of complex and use different types, so there might be something specific to that specific setup. Do you get that AV on all partitioned tables? If not, maybe that’ll help narrow down the differences. If you can send the DDL for the table that would help, or specify the type of partitioning being used (Range, List, Hash, System, Supartions, etc.) maybe I’d have better luck trying to replicate. Thanks.
Hi, in attachment are table as well all index that belong to that table
Brg,
Damir Vadas
http://damir-vadas.blogspot.com
It does not matter what you have in your life, but who!
Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email
On Tue, Mar 15, 2016 at 3:11 PM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:
Reply by Dennis Paulus
Damir - I haven't been able to replicate yet, but partitioning can get kind of complex and use different types, so there might be something specific to that specific setup. Do you get that AV on all partitioned tables? If not, maybe that'll help narrow down the differences. If you can send the DDL for the table that would help, or specify the type of partitioning being used (Range, List, Hash, System, Supartions, etc.) maybe I'd have better luck trying to replicate. Thanks.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
Thanks Damir. I setup your table locally, but unfortunately, I haven’t been able to replicate the problem, and nothing stands out on why it might be getting an AV. What Oracle db and client version are you using?
OC 11.2.0.3 x64, db 11.2.0.3 x64 hpux 64
This cone on previous version...will look and try to understand why on some partitions doesn't make problems
On Mar 15, 2016 17:55, "Dennis Paulus" bounce-Dennis_Paulus@toadworld.com wrote:
Reply by Dennis Paulus
Thanks Damir. I setup your table locally, but unfortunately, I haven't been able to replicate the problem, and nothing stands out on why it might be getting an AV. What Oracle db and client version are you using?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
Assembler Information:
; Base Address: $4200000, Allocation Base: $4190000, Region Size: 125128704
; Allocation Protect: PAGE_EXECUTE_WRITECOPY, Protect: PAGE_EXECUTE_READWRITE
; State: MEM_COMMIT, Type: MEM_IMAGE
;
;
; System.AnsiCompareText (Line=5572 - Offset=0)
; ---------------------------------------------
00000000042008C0 4155 PUSH R13
00000000042008C2 57 PUSH RDI
00000000042008C3 56 PUSH RSI
00000000042008C4 53 PUSH RBX
00000000042008C5 4883EC38 SUB RSP, $38
00000000042008C9 4889D3 MOV RBX, RDX
;
; Line=5573 - Offset=12
; ---------------------
00000000042008CC 4833F6 XOR RSI, RSI
00000000042008CF 4885C9 TEST RCX, RCX
00000000042008D2 7403 JZ +3 ; ($00000000042008D7) System.AnsiCompareText (Line=5573)
00000000042008D4 8B71FC MOV ESI, [RCX-4]
00000000042008D7 4833FF XOR RDI, RDI
00000000042008DA 4885DB TEST RBX, RBX
00000000042008DD 7403 JZ +3 ; ($00000000042008E2) System.AnsiCompareText (Line=5573)
;
; Line=5573 - Offset=31
; ---------------------
00000000042008DF 8B7BFC MOV EDI, [RBX-4] ; <-- EXCEPTION
00000000042008E2 E8F913FAFF CALL -$05EC07 ; ($00000000041A1CE0) System._UStrToPWChar
00000000042008E7 4989C5 MOV R13, RAX
00000000042008EA 4889D9 MOV RCX, RBX
00000000042008ED E8EE13FAFF CALL -$05EC12 ; ($00000000041A1CE0) System._UStrToPWChar
00000000042008F2 C7C100040000 MOV ECX, $00000400
00000000042008F8 C7C201000000 MOV EDX, 1
00000000042008FE 4D89E8 MOV R8, R13
0000000004200901 4189F1 MOV R9D, ESI
0000000004200904 4889442420 MOV [RSP+$20], RAX
0000000004200909 897C2428 MOV [RSP+$28], EDI
000000000420090D E82E13FBFF CALL -$04ECD2 ; ($00000000041B1C40->0000000076FF4F30) kernel32.CompareStringW
0000000004200912 83E802 SUB EAX, 2
;
; Line=5575 - Offset=85
; ---------------------
0000000004200915 4883C438 ADD RSP, $38
0000000004200919 5B POP RBX
000000000420091A 5E POP RSI
000000000420091B 5F POP RDI
EurekaLog 7.3.1.0
Application:
1.1 Start Date : Wed, 16 Mar 2016 09:05:59 +0100
1.2 Name/Description: Froggy_129b.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.9.0.39
1.4 Parameters :
1.6 Up Time : 12 minute(s), 34 second(s)
Exception:
2.1 Date : Wed, 16 Mar 2016 09:18:33 +0100
2.2 Address : 00000000042008DF
2.3 Module Name: Froggy_129b.exe - (Toad™ for Oracle®)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00000000042008DF in module ‘Froggy_129b.exe’. Read of address FFFFFFFFFFFFFFFD.
2.7 ID : 5BEC0000
2.8 Count : 1
2.11 Sent : 0
User:
3.2 Name : A1 Telekom Austria AG
3.3 Email:
Active Controls:
4.1 Form Class : TJumpDropdownForm
4.2 Form Text :
4.3 Control Class: TEdit
4.4 Control Text :
Computer:
5.2 Total Memory : 8520146944 (7,94 Gb)
5.3 Free Memory : 4002652160 (3,73 Gb)
5.4 Total Disk : 161755426816 (150,65 Gb)
5.5 Free Disk : 43258408960 (40,29 Gb)
5.6 System Up Time : 19 hour(s), 31 minute(s), 51 second(s)
5.7 Processor : Intel® Core™ i7-3520M CPU @ 2.90GHz
5.12 Virtual Machine:
Operating System:
6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build #: 7601 (6.1.7601.17965)
Steps to reproduce:
8.1 Text:
Call Stack Information:
|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |
|*Exception Thread: ID=2580; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|04 |0000000000000000|00000000042008DF|Froggy_129b.exe|00000000000708DF|System.SysUtils | |AnsiCompareText |5573[1] |
|00000040|04 |000000000042E848|000000000425750D|Froggy_129b.exe|00000000000C750D|System.Classes |TStringList |CompareStrings |6404[4] |
|00000040|03 |000000000042E878|000000000478AFBD|Froggy_129b.exe|00000000005FAFBD|tdClasses |TtdStringList |CompareStrings | |
|00000040|04 |000000000042E8A8|0000000004256EBB|Froggy_129b.exe|00000000000C6EBB|System.Classes |TStringList |Find |6222[7] |
|00000040|04 |000000000042E908|0000000004256A3F|Froggy_129b.exe|00000000000C6A3F|System.Classes |TStringList |AddObject |6099[4] |
|00000040|04 |000000000042E968|0000000004256A01|Froggy_129b.exe|00000000000C6A01|System.Classes |TStringList |Add |6091[1] |
|00000040|03 |000000000042E998|000000000885E79D|Froggy_129b.exe|00000000046CE79D|tjFileIndex |TtjFileIndex |BuildActionFilenames | |
|00000040|03 |000000000042EA48|000000000885F39E|Froggy_129b.exe|00000000046CF39E|tjFileIndex |TtjFileIndex |Build | |
|00000040|03 |000000000042EA88|0000000008884738|Froggy_129b.exe|00000000046F4738|tjManager |TToadJump |StartFileIndexing | |
|00000040|03 |000000000042EAB8|000000000697BA06|Froggy_129b.exe|00000000027EBA06|frmJumpDropdown |TJumpDropdownForm |FormActivate | |
|00000040|03 |000000000042EAE8|00000000045F4CC6|Froggy_129b.exe|0000000000464CC6|Vcl.Forms |TCustomForm |Activate | |
|00000040|03 |000000000042EB28|00000000045F6547|Froggy_129b.exe|0000000000466547|Vcl.Forms |TCustomForm |CMActivate | |
|00000040|04 |000000000042EB68|000000000419CE6E|Froggy_129b.exe|000000000000CE6E|System |TObject |Dispatch |13705[10] |
|00000040|04 |000000000042EBB8|00000000044780C3|Froggy_129b.exe|00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |
|00000040|04 |000000000042ED28|000000000447F4A3|Froggy_129b.exe|00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |
|00000040|03 |000000000042EDF8|00000000045F0D0B|Froggy_129b.exe|0000000000460D0B|Vcl.Forms |TCustomForm |WndProc | |
|00000040|04 |000000000042EEB8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |
|00000040|04 |000000000042EF08|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |
|00000040|03 |000000000042EF58|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |
|00000040|03 |000000000042F018|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |
|00000040|03 |000000000042F078|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |
|00000040|03 |000000000042F0D8|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |000000000042F160|0000000076E7685A|user32.dll |000000000001685A|USER32 | | (possible IsDialogMessageW+410) | |
|00000040|03 |000000000042F168|0000000076E7383E|user32.dll |000000000001383E|USER32 | | (possible GetWindowLongPtrA+126) | |
|00000040|03 |000000000042F1F8|0000000076E76BA8|user32.dll |0000000000016BA8|USER32 | |SendMessageW | |
|00000040|03 |000000000042F248|00000000045EBD84|Froggy_129b.exe|000000000045BD84|Vcl.Forms | |SendFocusMessage | |
|00000040|03 |000000000042F278|00000000045F46B0|Froggy_129b.exe|00000000004646B0|Vcl.Forms |TCustomForm |SetFocusedControl | |
|00000040|04 |000000000042F318|000000000447EECF|Froggy_129b.exe|00000000002EEECF|Vcl.Controls |TWinControl |WndProc |9850[26] |
|00000040|04 |000000000042F3E8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |
|00000040|04 |000000000042F438|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |
|00000040|03 |000000000042F488|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |
|00000040|03 |000000000042F548|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |
|00000040|03 |000000000042F5A8|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |
|00000040|03 |000000000042F608|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |000000000042F690|0000000076E6D22A|user32.dll |000000000000D22A|USER32 | |SetFocus | |
|00000040|03 |000000000042F698|00000000045F4A08|Froggy_129b.exe|0000000000464A08|Vcl.Forms |TCustomForm |SetWindowFocus | |
|00000040|03 |000000000042F6D8|00000000045F4ABF|Froggy_129b.exe|0000000000464ABF|Vcl.Forms |TCustomForm |SetActive | |
|00000040|03 |000000000042F718|00000000045F5A74|Froggy_129b.exe|0000000000465A74|Vcl.Forms |TCustomForm |WMActivate | |
|00000040|04 |000000000042F758|000000000419CE6E|Froggy_129b.exe|000000000000CE6E|System |TObject |Dispatch |13705[10] |
|00000040|04 |000000000042F7A8|00000000044780C3|Froggy_129b.exe|00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |
|00000040|04 |000000000042F918|000000000447F4A3|Froggy_129b.exe|00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |
|00000040|03 |000000000042F9E8|00000000045F0D0B|Froggy_129b.exe|0000000000460D0B|Vcl.Forms |TCustomForm |WndProc | |
|00000040|04 |000000000042FAA8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |
|00000040|04 |000000000042FAF8|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |
|00000040|03 |000000000042FB48|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |
|00000040|03 |000000000042FC08|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |
|00000040|03 |000000000042FC68|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |
|00000040|03 |000000000042FCC8|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |000000000042FD50|0000000076E7908A|user32.dll |000000000001908A|USER32 | | (possible PeekMessageW+186) | |
|00000040|03 |000000000042FD58|0000000076E79050|user32.dll |0000000000019050|USER32 | |PeekMessageW | |
|00000040|03 |000000000042FDA8|00000000045FEB4C|Froggy_129b.exe|000000000046EB4C|Vcl.Forms |TApplication |ProcessMessage | |
|00000040|03 |000000000042FE28|00000000045FECC3|Froggy_129b.exe|000000000046ECC3|Vcl.Forms |TApplication |HandleMessage | |
|00000040|03 |000000000042FE98|00000000045FF1BF|Froggy_129b.exe|000000000046F1BF|Vcl.Forms |TApplication |Run | |
|00000040|03 |000000000042FED8|0000000009743319|Froggy_129b.exe|00000000055B3319|Toad | |Initialization | |
|00000040|03 |000000000042FF58|0000000076FF5A4B|kernel32.dll |0000000000015A4B|kernel32 | |BaseThreadInitThunk | |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=6860; Parent=2580; Priority=0 |
Registers:
RAX: 0000000004788F98 RDI: 0000000000000000
RBX: 0000000000000001 RSI: 0000000000000033
RCX: 00000000275EB4C0 RBP: 000000000042E910
RDX: 0000000000000001 RSP: 000000000042E7F0
R8 : 0000000000000001 R9 : 0000000000000001
R10: 00000000E7FFFFFF R11: 00000000006342A0
R12: 0000000000000000 R13: 0000000000000011
R14: 0000000000000008 R15: 00000000000A0EBE
RIP: 00000000042008DF FLG: 0000000000010202
EXP: 00000000042008DF STK: 000000000042E7F0
Stack: Memory Dump:
0000000029B03578: 000000000000001C 00000000042008DF: 8B 7B FC E8 F9 13 FA FF 49 89 C5 48 89 D9 E8 EE .{…I…H…
0000000029B03570: 0000000000000001 00000000042008EF: 13 FA FF C7 C1 00 04 00 00 C7 C2 01 00 00 00 4D …M
0000000029B03568: 00000000041A03D6 00000000042008FF: 89 E8 41 89 F1 48 89 44 24 20 89 7C 24 28 E8 2E …A…H.D$ .|$(…
0000000029B03560: 0000000027546050 000000000420090F: 13 FB FF 83 E8 02 48 83 C4 38 5B 5E 5F 41 5D C3 …H…8[^_A].
0000000029B03558: 0000000004257512 000000000420091F: CC 48 83 EC 28 E8 97 FF FF FF 85 C0 0F 94 C0 48 .H…(…H
0000000029B03550: 0000000000000011 000000000420092F: 83 C4 28 C3 CC CC CC CC CC CC CC CC CC CC CC CC …(…
0000000029B03548: 0000000000000000 000000000420093F: CC 48 83 EC 38 C7 C0 00 04 00 00 4D 33 C0 49 89 .H…8…M3.I.
0000000029B03540: 0000000000000000 000000000420094F: C9 41 83 CA FF 48 89 54 24 20 C7 44 24 28 FF FF .A…H.T$ .D$(…
0000000029B03538: 0000000000000001 000000000420095F: FF FF 89 C1 44 89 C2 4D 89 C8 45 89 D1 E8 EF 12 …D…M…E…
0000000029B03530: 0000000000000000 000000000420096F: FB FF 83 E8 02 48 83 C4 38 C3 CC CC CC CC CC CC …H…8…
0000000029B03528: 0000000000000000 000000000420097F: CC 48 83 EC 38 C7 C0 00 04 00 00 41 C7 C1 01 00 .H…8…A…
0000000029B03520: 00000000041A0FEC 000000000420098F: 00 00 49 89 CA 45 89 C3 48 89 54 24 20 44 89 44 …I…E…H.T$ D.D
0000000029B03518: 0000000004788F98 000000000420099F: 24 28 89 C1 44 89 CA 4D 89 D0 45 89 D9 E8 AF 12 $(…D…M…E…
0000000029B03510: 0000000000000000 00000000042009AF: FB FF 83 E8 02 48 83 C4 38 C3 CC CC CC CC CC CC …H…8…
0000000029B03508: 000000002747FDB0 00000000042009BF: CC 56 53 48 83 EC 28 48 89 CB 48 33 F6 48 85 D2 .VSH…(H…H3.H…
0000000029B03500: 000000000000001C 00000000042009CF: 74 06 8B 72 FC C1 EE 01 48 89 D1 E8 51 0B FA FF t…r…H…Q…
The matter of fact I have problems even with normal tables…what to reset (that in some upgrade) went “crazy”?
Post the log file, Damir.
I have posted 4 logs from Exception handler, send table and index scripts by mail (do not know now to whom…delete history) and now you asking me for a log…could you be more specific?
The Toad.el file. Anytime you have an error, post it. The posting of the call stack above is helpful, but it’s helpful to see the entire log file as it may contain other exceptions preceding this one.
Is this “toad.el” …which I didn’t find on mine whole disk!
** APPLICATION INFORMATION - BETA VERSION (64-bit)
Support Bundle for Toad for Oracle 12.9.0.39
This copy of Toad for Oracle registered to VADAS SAVJETOVANJE DOO
Bundle: Toad for Oracle Xpert (64-bit), Add-Ons: DB Admin Module
Edition: Toad DBA Suite for Oracle
Toad for Oracle Executable Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\Froggy_129b.exe
User Profile Directory: C:\Users\Q383211\AppData\Roaming\Dell\Toad for Oracle\12.9 beta\
QSEServer DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\qse.dll
QSEServer DLL Version: 12.9.0.39
QP5 DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\QP5.dll
QP5 DLL Version: 5.292.16046.31748
QP5CA DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\QP5CA.dll
QP5CA DLL Version: 5.292.16046.31970
SciLexer DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\SciLexer.dll
SciLexer DLL Version: 3.6.1.1
TOAD Policy Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\Toad.pdl
** TEAM CODING
Connection: Q383211@SMOBCST1
Team Coding Status Checks
Team Coding is not installed
Team Coding@SMOBCST1
Team Coding not installed
Team Coding Session Messages
15:39:57: Team Coding is not installed
** MANAGED ITEMS
Not a managed environment.
** ORACLE CLIENT INFORMATION
Oracle Client Version : 11.2.0.3
Oracle Client DLL : c:\oracle\product\11.2.0\dbhome_1\BIN\oci.dll
TNSNAMES.ora Location : u:\oracle\network\admin\tnsnames.ora
NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH : u:\sql
LOCAL :
** ORACLE SERVER INFORMATION
Connection 1 : Q383211@SMOBCST1 ** Active Session **
Oracle Server Version : Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Oracle Server NLS_CHARACTERSET : WE8ISO8859P1
Oracle Server NLS_NCHAR_CHARACTERSET : AL16UTF16
Oracle Session User : Q383211 (Normal)
** SYSTEM INFORMATION
Operating System: Windows 7 (Build 7601)Service Pack 1
Is Terminal Server: No
Using XP Theme: Yes
Language: German
Country: Austria
Input Language: German
Physical Memory Load: 54,55 %
Physical Memory (Total): 8125 MB
Physical Memory (Free): 3693 MB
Virtual Memory (Total): 8388607 MB
Virtual Memory (Free): 8387889 MB
Swap Space (Total): 16249 MB
Swap Space (Free): 11700 MB
Toad Page File Usage (Virtual Memory): 324 MB
Toad Working Set Usage (RAM): 321 MB
Environment Variable (PATH):
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\Microsoft Application Virtualization Client
C:\Program Files\WIDCOMM\Bluetooth Software\
C:\Program Files\WIDCOMM\Bluetooth Software\syswow64
c:\oracle\product\11.2.0\dbhome_1\bin
c:\Users\Q383211\AppData\Local\WinTools
Environment Variable (TNS_ADMIN): u:\oracle\network\admin
** ORACLE HOMES DATA
(Oracle Root)
inst_loc = C:\Program Files\Oracle\Inventory
NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252
KEY_OraClient12Home2
ORACLE_HOME = C:\Programme\Oracle\product\12.1.0\client_1
ORACLE_HOME_NAME = OraClient12Home2
ORACLE_GROUP_NAME = Oracle - OraClient12Home2
NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\Programme\Oracle\product\12.1.0\client_1\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT-AUTORITÄT\LOKALER DIENST
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = C:\Programme\Oracle\product\12.1.0\client_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home2
MSHELP_TOOLS = C:\Programme\Oracle\product\12.1.0\client_1\MSHELP
KEY_OraDb11g_home1 ***** This is the home currently used by Toad *****
ORACLE_HOME = c:\oracle\product\11.2.0\dbhome_1
ORACLE_HOME_NAME = OraDb11g_home1
ORACLE_GROUP_NAME = Oracle - OraDb11g_home1
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = c:\oracle\product\11.2.0\dbhome_1\oledb\mesg
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = c:\oracle\product\11.2.0\dbhome_1\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
MSHELP_TOOLS = c:\oracle\product\11.2.0\dbhome_1\MSHELP
SQLPATH = c:\oracle\product\11.2.0\dbhome_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb11g_home1
ORACLE_BASE = c:\oracle
RDBMS_CONTROL = c:\oracle\product\11.2.0\dbhome_1\DATABASE
RDBMS_ARCHIVE = c:\oracle\product\11.2.0\dbhome_1\DATABASE\ARCHIVE
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORA_XESSD_AUTOSTART = TRUE
ORA_XESSD_SHUTDOWN = TRUE
ORA_XESSD_SHUTDOWNTYPE = immediate
ORA_XESSD_SHUTDOWN_TIMEOUT = 90
ORACLE_SID = XESSD
_NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252
OraClient12Home2
C:\Programme\Oracle\product\12.1.0\client_1\bin exists
C:\Programme\Oracle\product\12.1.0\client_1\bin is not in PATH
Home is not valid
OraDb11g_home1
c:\oracle\product\11.2.0\dbhome_1\bin exists
c:\oracle\product\11.2.0\dbhome_1\bin is in PATH
Home is valid
** FORMATTER OPTIONS: C:\Users\Q383211\AppData\Roaming\Dell\Toad for Oracle\12.9 beta\User Files\FmtPlus_Vadas.opt
[Qp5FormatterOptions]
Version=252
OutputTabs=2
IndentSize=2
IndentTHENonSameLine=1
IndentLOOPonSameLine=1
RightMargin=140
Tagline=0
** WINDOW USAGE
TfrmObjects - 4824
TFormToadEditor - 4227
TF4HolderForm - 3095
TADDMReportForm - 243
TProjectManagerForm - 163
TTableForm - 155
TTableForm - 155
TfrmAnalyze - 154
TFormToadAppDesigner - 126
TTraceFileBrowserForm - 118
TExportWatchForm - 92
TIndexForm - 92
TTriggerForm - 82
TFmQueryBuilder - 64
TFormSQLOptimizer - 53
TSessionBrowserForm - 51
TAPEXExportForm - 51
TFormExportDDL - 46
TViewForm - 45
TFormWrap - 40
TDataPumpExportForm - 39
TfrmNLSParams - 38
TDataImportForm - 35
TFormObjectSearch - 35
TDiffHolderForm - 28
TfrmRebuildTable - 28
TfrmSchemaDoc - 24
TExportWizardForm - 18
TCreateDataForm - 18
TTablespaceForm - 18
TfrmIndRbld - 15
TImportWizardForm - 14
TExportBrowserForm - 13
TFormERD - 12
TSQLLoader - 12
TSegmentAdvisorForm - 11
TfrmTopSess - 11
TDataPumpImportForm - 10
TAWRBrowserForm - 10
TtdProfileAnalysisForm - 9
TEstimateIndSizeForm - 8
TDirectoryForm - 7
TSchemaScriptForm - 7
TCXMainForm - 6
TSnapshotForm - 5
TSnapshotLogForm - 5
TRedoLogManagerForm - 5
TAlertLogForm - 5
TDataCompareForm - 4
TDBrowserForm - 4
TfrmLogSwitch - 4
TfrmOraInit - 4
TfrmComp1Obj - 4
TfrmTableSpaces - 4
TSchedulerJobForm - 4
TEstimateTabSizeForm - 3
TDBProbeForm - 3
TThreadedQueryViewerForm - 3
TIMonitor - 3
TDBHealthCheckForm - 3
TToadOnlineForm - 3
TCompareSchemasForm - 3
TfrmDbmsMDI - 3
TInstanceManagerForm - 2
TTOADFTP - 2
TCompareMultipleSchemasForm - 2
TfrmTrace - 2
TTablespaceMapForm - 2
TfrmLogMiner - 2
TDBMS_SQLTuneForm - 1
TUndoAdvisorForm - 1
TToadAdvisorForm - 1
TFormSupportBundle - 1
TAuditForm - 1
TActionRecallMoreForm - 1
TfrmExPlan - 1
TProjectLucyForm - 1
TUserViewerForm - 0
TDBDocForm - 0
TCredentialForm - 0
TMediaViewerForm - 0
TWikiPageViewerForm - 0
TThreadViewerForm - 0
TTelligentSearchForm - 0
TBlogPostViewerForm - 0
TCXRuleBuilder - 0
TUnifiedAuditPolicyForm - 0
TFlashbackForm - 0
TTCDockForm - 0
TZoneMapForm - 0
TASHBrowserForm - 0
TContextForm - 0
TTCSummaryForm - 0
TStatsPackBrowserForm - 0
TFlashbackArchiveForm - 0
TFormLegend - 0
TCopyTableDataForm - 0
TMDIDescribeForm - 0
TAuditPolicyForm - 0
TEditionForm - 0
TTransformationForm - 0
TQuickDescribeForm - 0
TDBDocForm - 0
TSearchInFilesForm - 0
TQueryConditionForm - 0
TfrmJava2PLSqlUI - 0
TTelligentForumPostForm - 0
TTelligentForumPostForm - 0
TFormGridSaveAs - 0
TSBLegendForm - 0
TQBForm - 0
TCXMetricsHistory - 0
TRedactionPolicyForm - 0
TFormExecuteScript - 0
TfrmSynonyms - 0
TfrmCreateUser - 0
TScriptManagerForm - 0
TProfileForm - 0
TRBSForm - 0
TfrmMakeSeq - 0
TfrmTKProf - 0
TfrmJavaManager - 0
TDimensionForm - 0
TDatabaseScriptForm - 0
TTNSNamesEditorForm - 0
TSchedulerForm - 0
TOutputFrm - 0
TfrmChainedRows - 0
TfrmTblFilter - 0
TfrmTabDupes - 0
TfrmMain - 0
TOSMonitorForm - 0
TPinnedPackageForm - 0
TMasterDetailForm - 0
TfrmConsDef - 0
TfrmDbLinks - 0
TLibraryForm - 0
TDataSubsetWizardForm - 0
TSecurityForm - 0
TfrmImportExport - 0
TCompareDatabasesForm - 0
TAuditSQLForm - 0
TMultiObjectPrivForm - 0
TIndexMonitoringForm - 0
TWindowForm - 0
TWindowGroupForm - 0
TTaskSchedulerForm - 0
TDataPumpManagerForm - 0
TASMForm - 0
TDiskGroupForm - 0
TDBMSRedefForm - 0
TFormRefCursorResults - 0
TReportsForm - 0
TExplainPlanCompareForm - 0
TClusterForm - 0
TFormRPlanSchedule - 0
TFormModRGroup - 0
TfrmComp1DBObj - 0
TFormCRM - 0
TServiceMgrForm - 0
TFormModRPlan - 0
TScheduleForm - 0
TChainForm - 0
TJobClassForm - 0
TRefreshGroupForm - 0
TQueueForm - 0
TProgramForm - 0
Look for froggy.el (or whatever your exe name is) then. What you just posted is your Support Bundle. Your prior posting from yesterday is a single call stack from the log file.
uf … I see now…
Sent to mail (toadoraclebeta) .zippy file.
Thx
toadoraclebeta@toadworld.com is a no-reply address used for sending out mail. I have no idea where mail sent to it ends up. You can just post it as an attachment to your forum posts or send it to one of us directly. My email is michael.staszewski@quest.com
attached .el file...
Brg,
Damir Vadas
http://damir-vadas.blogspot.com
It does not matter what you have in your life, but who!
Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email
On Thu, Mar 17, 2016 at 3:47 PM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:
Reply by Michael Staszewski
Look for froggy.el (or whatever your exe name is) then.What you just posted is your Support Bundle. Your prior posting from yesterday is a single call stack from the log file.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
Try again, but just send it to me if you don’t mind (michael.staszewski@quest.com). Toad World’s mail gateway has some room for improvement to say the least. Several on here have problems with attachments. It looks like yours was stripped as well.
This may be related:
In .39 and .40, I’ve been getting “Access violation at address 0000000008505727 in module ‘Toad.exe’. Read of address 000000000000001D” while attempting to script one non-partitioned table. This is the last SQL spooled before that AV:
Select CONSTRAINT_NAME, OWNER, TABLE_NAME, CONSTRAINT_TYPE, SUBSTRB(STATUS, 1, 1) STATUS
, SEARCH_CONDITION
, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated
, VALIDATED
, RELY
, VIEW_RELATED
FROM SYS.DBA_CONSTRAINTS
WHERE OWNER = :pOwner
AND CONSTRAINT_TYPE in (:ct, ‘?’, ‘F’)
AND Constraint_name in (‘SYS_C0015371’,‘SYS_C0015372’)
and not ((length(CONSTRAINT_NAME) = 30) and
(substr(CONSTRAINT_NAME, 1, 4) = ‘BIN$’) and
(substr(CONSTRAINT_NAME, 27, 4) = ‘==$0’))
order by table_name, constraint_name
The above query returns 2 rows corresponding to the 2 NOT NULL constraints on the table’s columns.
This works fine in 12.8GA…
Thanks!
Rich
