RE: Re: Access Violation on module toad.exe but only from command line

[cid:[email protected]]

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]<mailto:[email protected]>>
A: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]>
Sent: Friday, March 02, 2012 08:24 AM
To: [email protected]<mailto:[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]<mailto:[email protected]>>
A: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]>
Sent: Friday, March 02, 2012 08:11 AM
To: [email protected]<mailto:[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]<mailto:[email protected]>>
A: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of deftones209
Sent: Friday, March 02, 2012 07:58 AM
To: [email protected]<mailto:toad%40yahoogroups.com>
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

-