| Newsgroups |
gmane.comp.db.oracle.toad.free |
| Message-ID |
<[email protected]> |
Hi Greg,
thanks a lot for the help.
Still there is nothing like that in my version.
Could you post an example file output from that command??
I will then take it and change the filenames.
Thanks
manuel
________________________________
Da: Gregory Liss <[email protected]>
A: "[email protected]" <[email protected]>
Inviato: Venerdì 2 Marzo 2012 15:18
Oggetto: RE: [toad] Re: Access Violation on module toad.exe but only from command line
You should be able to right click in the GUI and get the Create Command Line Parameter File item.
From:[email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, March 02, 2012 09:11 AM
To: [email protected]
Subject: Re: [toad] Re: Access Violation on module toad.exe but only from command line
Nothing like that in my Version :-(
Is there a Chance to open a bug request/Ticket somewhere?
I tried on the Quest Support, but there seems we do not have a Maintenance Support even if having a Company wide professional License.
Other Question: Is there a way to upgrade to a newer version, or is it needed also to buy new licenses/license upgrade?
regards
manuel
________________________________
Da:Gregory Liss <[email protected]>
A: "[email protected]" <[email protected]>
Inviato: Venerdì 2 Marzo 2012 14:57
Oggetto: RE: [toad] Re: Access Violation on module toad.exe but only from command line
From:[email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, March 02, 2012 08:55 AM
To: [email protected]
Subject: Re: [toad] Re: Access Violation on module toad.exe but only from command line
Hi,
there does not seems to be such an option in my Toad version.
I have tried with both XML and HTML to 0 and di not work. Even with CODEXpert to 0 did not work.
manuel
________________________________
Da:Gregory Liss <[email protected]>
A: "[email protected]" <[email protected]>
Inviato: Venerdì 2 Marzo 2012 14:28
Oggetto: RE: [toad] Re: Access Violation on module toad.exe but only from command line
Manuel,
On the main GUI, there's a button with a button that looks like a command prompt. You can use that to generate the ini file.
You also should be able to set them both to 0 and have it run – I think. That version is pretty old and I'm not totally sure of what it did and didn't do.
Greg
From:[email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, March 02, 2012 08:24 AM
To: [email protected]
Subject: Re: [toad] Re: Access Violation on module toad.exe but only from command line
Hi Greg,
cx.ini has been generated by Sonar. I can generate my own for test, but in production these files get generated automatically.
I have simplified it by removing the other 49 files being analysed, and just keeping one.
But how do it create an INI from Toad?
Other Question.
If I put XML and HTML to 0, will it run anyway the analysis but not export anything? So I could test if the problem lies in the export or in the analysis.
regards
manuel
________________________________
Da:Gregory Liss <[email protected]>
A: "[email protected]" <[email protected]>
Inviato: Venerdì 2 Marzo 2012 14:14
Oggetto: RE: [toad] Re: Access Violation on module toad.exe but only from command line
Is the CX.ini file being made by Toad or by the third party vendor? You can try creating your own cx.ini file from the GUI and running that. Unfortunately, there's no way in that version of Toad to export the results as XML.
Greg
From:[email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, March 02, 2012 08:11 AM
To: [email protected]
Subject: Re: [toad] Re: Access Violation on module toad.exe but only from command line
Hi Greg,
I have just tried with these settings (rest unchanged):
INCLUDE_HTML=1
INCLUDE_XML=0
Unfortunately still getting Access violation.
I have two Questions:
- Is there a way to reproduce exactly on the Gui what it is doing with the command toad.exe -CX C:\tmp\cx.ini ?? I know how to run the export, but what is it doing apart from that 8some kind of XMl export)?
- I have put also debug=1 in toad.ini, and I see a log coming out which always looks like this:
14:04:35 Initializing application
14:04:35 Creating GlobalDataModule
14:04:37 Performing Toad's startup tasks
14:04:37 Setting Toad help file
14:04:37 Setting global options
14:04:37 Updating license key file with app info
14:04:37 Loading Formatter Plus
14:04:39 Creating main window
14:04:39 Create Bitmaps Form
14:04:40 Checking for Spotlight
14:04:40 Checking for SQL Impact
14:04:40 Initializing Team Coding
14:04:40 Building quick scripts menu
14:04:40 Building external tools menu
14:04:41 Restoring dock layout
14:04:41 Enabling features based on license
14:04:41 Restoring size and position
14:04:41 Performing Toad's command line tasks
14:04:41 Calling OCI connect
14:04:41 Connected
14:04:41 Initializing connection
14:04:41 Getting Oracle version
14:04:41 Fetch session SID
14:04:41 Checking for access to DBMS_TRANSACTION
14:04:41 Checking for SELECT_CATALOG_ROLE
14:04:41 Setting module info
14:04:41 Creating Debugger Object
14:04:41 Checking for TOAD_PROFILER
14:04:42 get nls_charset from server
14:04:42 Restricting product features based on Toad security
14:04:42 Checking for RAC support...
14:04:42 Out of RAC support check.
14:04:42 Fetching owner names
14:04:43 TTeamCoding.AddTCSession
14:04:43 TTeamCoding.CheckSupport
14:04:43 -> TTeamCoding.ExecuteQuery( SELECT table_name, table_owner FROM ALL_SYNONYMS WHERE owner = 'PUBLIC' AND synonym_name = '!SYN_TC!' )
14:04:43 <- TTeamCoding.ExecuteQuery
14:04:46 Application.Run
14:04:51 Checking connection's active state
while if I start toad.exe and connect to a db it looks like
14:09:59 Initializing application
14:09:59 Creating GlobalDataModule
14:10:01 Performing Toad's startup tasks
14:10:01 Setting Toad help file
14:10:01 Setting global options
14:10:01 Updating license key file with app info
14:10:01 Loading Formatter Plus
14:10:04 Creating main window
14:10:04 Create Bitmaps Form
14:10:05 Checking for Spotlight
14:10:05 Checking for SQL Impact
14:10:05 Initializing Team Coding
14:10:05 Building quick scripts menu
14:10:05 Building external tools menu
14:10:06 Restoring dock layout
14:10:06 Enabling features based on license
14:10:06 Restoring size and position
14:10:06 Performing Toad's command line tasks
14:10:06 Application.Run
14:10:06 Create Login Form
14:10:12 Calling OCI connect
14:10:14 Connected
14:10:14 Initializing connection
14:10:14 Getting Oracle version
14:10:14 Fetch session SID
14:10:14 Checking for access to DBMS_TRANSACTION
14:10:14 Checking for SELECT_CATALOG_ROLE
14:10:14 Setting module info
14:10:14 Creating Debugger Object
14:10:14 Checking for TOAD_PROFILER
14:10:14 get nls_charset from server
14:10:14 Restricting product features based on Toad security
14:10:14 Checking for RAC support...
14:10:14 Out of RAC support check.
14:10:14 Fetching owner names
14:10:16 TTeamCoding.AddTCSession
14:10:16 TTeamCoding.CheckSupport
14:10:16 -> TTeamCoding.ExecuteQuery( SELECT table_name, table_owner FROM ALL_SYNONYMS WHERE owner = 'PUBLIC' AND synonym_name = '!SYN_TC!' )
14:10:16 <- TTeamCoding.ExecuteQuery
14:10:17 TFormToadEditor.Create
14:10:17 Creating QSEEx (Loads QSE.dll)
14:10:17 Creating new editor tab
14:10:18 Loading desktop layout
14:10:19 Refreshing dbms_output data structure (not necessarily polling at this time)
14:10:19 Desktop layout loaded
14:10:19 Parsing code
14:10:19 Code parsed
14:10:19 Clearing custom bookmarks
14:10:19 Custom bookmarks cleared
14:10:19 Clearing custom bookmarks
14:10:19 Custom bookmarks cleared
14:10:19 Refreshing the executable line map display
14:10:19 Line map refreshed
14:10:19 Loading saved breakpoints
14:10:19 Breakpoints loaded
14:10:19 Loading saved watches
14:10:19 Watches loaded
So it looks like having probmes here:
14:10:17 TFormToadEditor.Create
14:10:17 Creating QSEEx (Loads QSE.dll)
14:10:17 Creating new editor tab
14:10:18 Loading desktop layout
manuel
________________________________
Da:Gregory Liss <[email protected]>
A: "[email protected]" <[email protected]>
Inviato: Venerdì 2 Marzo 2012 14:01
Oggetto: RE: [toad] Re: Access Violation on module toad.exe but only from command line
Have you tried INCLUDE_HTML instead of INCLUDE_XML as a test? Toad uses MSXML to process the XML files so it's possible that something got patched and is no longer compatible with the 9.7 code.
Greg
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of deftones209
Sent: Friday, March 02, 2012 07:58 AM
To: [email protected]
Subject: [toad] Re: Access Violation on module toad.exe but only from command line
Hi Greg,
I am running 9.7.2.5 Professional
Making CodExpert Analysis on the same files from GUI works. Also on other files did not have a Problem.
toad.elf does not shows anything relevant.
CXCmd...log is like this:
End run for C:\tmp\cx.ini at 02.03.2012 12:19:39 No Errors Found.
Here the Files I am using for testing(very simplified, but even this give the error).
I am starting toad like this:
toad.exe -CX C:\tmp\cx.ini
cx.ini
[OPTIONS]
RULESET=C:\tmp\rules.rst
RSET=min
OUTPUTDIR=C:\tmp
HTMLFILENAME=test.html
XMLFILENAME=test.xml
CODEXPERT_SCAN=1
SQL_SCAN=0
PASSWORDS_ENCRYPTED=0
INCLUDE_HTML=0
INCLUDE_XML=1
INCLUDE_SERVERSIDE_INSERT=0
[CONNECTIONS]
LOGIN1=someuser@somedatabase
[PASSWORDS]
PASSWORD1=somepassword
[FILES]
FILE1=C:\tmp\cx.sql
with the user/psw/db above I can connect from Toad and also from prompt with sqlplus.
cx.sql is like this (yes, i am doing the test as simple as possible) select * from dual;
and rules.rst like this (also here stripped to the minimum)
<RULESET title="min" version ="11.0">
<RULES>
<RULE rid="4804"/>
</RULES>
</RULESET>
I am running Oracle Client 11.2 on my Client, on Windows Vista.
Identical problem appears on Server with Oracle 10.1 and 10.2 Clients on Windows Server 2003 64.
Any help is very appreciated, i am starting to bang my head against the wall.
manuel
-