Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Getting AV Info

3 posts in AEP Last posting was on 2008-03-27 19:18:56.0Z
Raoul Wedel Posted on 2008-02-20 17:45:40.0Z
From: "Raoul Wedel" <raoul@wedelsoft.com>
Newsgroups: Advantage.AEP
Subject: Getting AV Info
Date: Wed, 20 Feb 2008 18:45:40 +0100
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.84.3.140
Message-ID: <47bc65fe@solutions.advantagedatabase.com>
X-Trace: 20 Feb 2008 10:40:14 -0700, 213.84.3.140
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.84.3.140
Xref: solutions.advantagedatabase.com Advantage.AEP:605
Article PK: 1103891

Hi,

Is there a way to get better info on an AV in an AEP??

All I get is this, and I would like to get a real address.

Raoul.

Error 7200: AQE Error: State = HY000; NativeError =
5154; [Extended Systems][Advantage SQL][ASA] Error 5154: Execution of the
stored procedure failed. ProcError 1: Access violation at address 00000000.
Read of address 00000000.


Jeremy Mullin Posted on 2008-03-24 14:04:32.0Z
Date: Mon, 24 Mar 2008 14:04:32 +0000 (UTC)
Message-ID: <1b468bc8324568ca5b9cd3a80a2b@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Getting AV Info
Newsgroups: Advantage.AEP
References: <47bc65fe@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 24 Mar 2008 07:58:52 -0700, 10.24.38.114
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.AEP:619
Article PK: 1103899

Hi Raoul,

> Is there a way to get better info on an AV in an AEP??

That is the information from the delphi exception object, which is all the
aep was given by the Delphi runtime. You may be able to use something like
MadExcept or EurekaLog to get better stack information, but you would need
to be careful to use those utilities in a fashion that would not raise a
dialog (which they do by default). If a dialog is rasied the Advantage worker
thread will appear hung and never return. In addition, the message box rarely
shows up on the screen. Sometimes it will if you edit the service properties
and select the option to allow the service to interact with the desktop.
Not good for production environments, but it might help for debugging a problem.

You could also just run advantage as an executable (ads.exe -exe), which
will allow message boxes from the AEPs to show up on the console.

J.D. Mullin
Advantage R&D


Raoul Wedel Posted on 2008-03-27 19:18:56.0Z
From: "Raoul Wedel" <raoul@wedelsoft.com>
Newsgroups: Advantage.AEP
References: <47bc65fe@solutions.advantagedatabase.com> <1b468bc8324568ca5b9cd3a80a2b@devzone.advantagedatabase.com>
Subject: Re: Getting AV Info
Date: Thu, 27 Mar 2008 20:18:56 +0100
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.84.3.140
Message-ID: <47ebf1cd@solutions.advantagedatabase.com>
X-Trace: 27 Mar 2008 13:13:17 -0700, 213.84.3.140
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.84.3.140
Xref: solutions.advantagedatabase.com Advantage.AEP:620
Article PK: 1103909

Hi JD,

Took this up with support.

I ran the AEP in the debugger with the -exe option.

The AEP stops at a call on Application.ProcessMessages, once about 3 in 10
times, and in exacly the same procedure and data.... Only on Remote Server,
and only when the calling app is Delphi. If I run the stored procedure in
Architect 100 times with a script, it will run fine.

After this, you'll have to start and stop the ADS Service, no call to the
AEP works anymore.

The processmessages call had no purpose anymore, i could just take it out.
But there is something fishy there.

Raoul.

"Jeremy Mullin" <no@email.com> schreef in bericht
news:1b468bc8324568ca5b9cd3a80a2b@devzone.advantagedatabase.com...

> Hi Raoul,
>
>> Is there a way to get better info on an AV in an AEP??
>
> That is the information from the delphi exception object, which is all the
> aep was given by the Delphi runtime. You may be able to use something like
> MadExcept or EurekaLog to get better stack information, but you would need
> to be careful to use those utilities in a fashion that would not raise a
> dialog (which they do by default). If a dialog is rasied the Advantage
> worker thread will appear hung and never return. In addition, the message
> box rarely shows up on the screen. Sometimes it will if you edit the
> service properties and select the option to allow the service to interact
> with the desktop. Not good for production environments, but it might help
> for debugging a problem.
>
> You could also just run advantage as an executable (ads.exe -exe), which
> will allow message boxes from the AEPs to show up on the console.
>
> J.D. Mullin
> Advantage R&D
>
>