RE: 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



--- In [email protected], Gregory Liss <gregory.liss@...> wrote:
>
> Manuel,
>   First, what version of Toad are you running?  Next, can you run the same files/objects via the GUI in Toad?  Also, is there any information in the CXCmdLineErrors.Log located in your user files folder?
> 
> Greg
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of 
> deftones209
> Sent: Friday, March 02, 2012 07:22 AM
> To: [email protected]
> Subject: [toad] Access Violation on module toad.exe but only from 
> command line
> 
> Hi together,
> sorry if I post this here but this is driving me mad.
> 
> I am running an automatic code review based on state of the art tools like Jenkins and sonar, and by using the sonar PL SQL plugin which in the end will call toad.
> This all worked fine till yesterday, when I noticed the process was not running anymore.
> 
> After several hours, I found that everything is boiling down to jenkins calling a command like this:
> toad.exe -CX F:\path\to\ini\cxfile.ini
> 
> The ini file is there and looks also fine. Tryed to connect with sqlplus and the credentials from the INI and it works fine. So connection should not be the problem.
> 
> Now if I run the above command manually, it is not working.
> Toad will start and I can see in the taskbar
> - Connecting to Server 1 of 1
> - Preparing for Scan
> - Crash, error message appears: Access violation at adress 00FFF0AB in module toad.exe. read of address 00000008.
> 
> I have also enabled debugging with debug=1 in toad.ini. log is generated but no errors in there, the last lines contains something like:
> -> TTeamCoding.executequery ('select table_name, table_owner FROM 
> -> ALL_SYNONYMS WHERE owner='PUBLIC' and synonym_name ='!SYN_TC!')
> <- TTeamCoding.executequery
> Application.Run
> 
> Nothing else.
> 
> So far I have tried the following with no luck:
> - Changing Toad options for startup
> - Removing .lay files from User files, as suggested on the net
> - Change to a new different Oracle client (tried with 10.2 and 10.2)
> - Change to a different Database
> - Tryed to change ini file in the command above, removing all the 
> unecessary
> - tested with the same ini, on a complete different machine. Different os (Vista vs Server 2003), different client (11.2) and different database (11.2).
> 
> In all cases I am still seeing always the same error.
> On the second machine I have MCafee AV, but on the first none (is a protected Server), so that cannot be the problem.
> 
> What is strage is that till some days ago it was working fine, and apparently there have been no changes on the server. Eventually some Patch updates?
> 
> Any Idea how to solve this??
> 
> thanks a lot and have a nice weekend
> manuel
> 
> 
> 
> ------------------------------------
> 
> Yahoo! Groups Links
>



------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/