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.

Multiuser AEP?

4 posts in AEP Last posting was on 2009-02-11 22:37:56.0Z
David Looney Posted on 2009-02-11 19:28:34.0Z
From: "David Looney" <davidl@autostarsolutions.com>
Newsgroups: Advantage.AEP
Subject: Multiuser AEP?
Date: Wed, 11 Feb 2009 13:28:34 -0600
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 67.152.110.130
Message-ID: <499326ce@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2009 12:28:14 -0700, 67.152.110.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.152.110.130
Xref: solutions.advantagedatabase.com Advantage.AEP:678
Article PK: 1103959

We are writting an AEP to take payments and have run into a problem. When
we do simultaneous testing to simulate multi-users one session will complete
just fine but the other one will not. We've changed our code to use the
connection coming in from the AEP call and we are creating a second
connection to point to our company folder tables. Can anyone provide me
with some suggestions on what I might be able to do to debug this and find
what the problem is?

Thanks
David


Lance Schmidt Posted on 2009-02-11 20:49:16.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.AEP
References: <499326ce@solutions.advantagedatabase.com>
Subject: Re: Multiuser AEP?
Date: Wed, 11 Feb 2009 13:49:16 -0700
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.117
Message-ID: <499339b5@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2009 13:48:53 -0700, 10.24.38.117
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.117
Xref: solutions.advantagedatabase.com Advantage.AEP:679
Article PK: 1103956

Hi David,

Debugging AEPs takes a bit of setup. First of all you need to you need to
disable DLL caching. You can use the following SQL statement to do that:

execute procedure sp_ModifyDatabase ('DISABLE_DLL_CACHING', 'TRUE');

Next you need to build debug symbols for the AEP. On the Delphi menu choose
'Project', then 'Options'. Select the 'Linker' tab, and check the 'Include
Remote Debug Symbols' and the 'Include TD32 debug info' checkboxes.

Finally you need to use the ads.exe as the host application. You can find
this under Run | Parameters.
a. Set the host application to ads.exe
b. Set the parameters to '/exe'
c. Set the working directory to the directory where the Advantage Server is
installed.

You can now set breakpoints and debug the AEP. I would first start by
looking at what your doing in that second connection and why you need it
instead of the connection being passed in by Advantage. Is that connection
on a data module that is specific to each user or are you using a single
global connection?

Best Regards,

Lance Schmidt
Advantage R&D

"David Looney" <davidl@autostarsolutions.com> wrote in message
news:499326ce@solutions.advantagedatabase.com...
> We are writting an AEP to take payments and have run into a problem. When
> we do simultaneous testing to simulate multi-users one session will
> complete just fine but the other one will not. We've changed our code to
> use the connection coming in from the AEP call and we are creating a
> second connection to point to our company folder tables. Can anyone
> provide me with some suggestions on what I might be able to do to debug
> this and find what the problem is?
>
> Thanks
> David
>


David Looney Posted on 2009-02-11 21:26:35.0Z
From: "David Looney" <davidl@autostarsolutions.com>
Newsgroups: Advantage.AEP
References: <499326ce@solutions.advantagedatabase.com> <499339b5@solutions.advantagedatabase.com>
Subject: Re: Multiuser AEP?
Date: Wed, 11 Feb 2009 15:26:35 -0600
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 67.152.110.130
Message-ID: <49934278@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2009 14:26:16 -0700, 67.152.110.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.152.110.130
Xref: solutions.advantagedatabase.com Advantage.AEP:680
Article PK: 1103957

The reason I need the second connection is because our tables are located in
different folders. Our folder structure looks like this:

c:\Customer\
c:\Customer\ASDate1\
c:\Customer\ASDate1\CO1\

Our global tables, which are used by all companies, are in the ASData1
folder, while our company specific tables are in the CO1 folder and we can
have up to 99 different companies.

As for the debugging, I have not done two of the things you mentioned and
those are disable caching and setting the working folder.

The problem I am having only appears when two different users hit the AEP at
the same time, so I'm not quite sure how to debug a scenario like this.

David

"Lance Schmidt" <LanceSc@ExtendSys.com> wrote in message
news:499339b5@solutions.advantagedatabase.com...
> Hi David,
>
> Debugging AEPs takes a bit of setup. First of all you need to you need to
> disable DLL caching. You can use the following SQL statement to do that:
>
> execute procedure sp_ModifyDatabase ('DISABLE_DLL_CACHING', 'TRUE');
>
> Next you need to build debug symbols for the AEP. On the Delphi menu
> choose 'Project', then 'Options'. Select the 'Linker' tab, and check the
> 'Include Remote Debug Symbols' and the 'Include TD32 debug info'
> checkboxes.
>
> Finally you need to use the ads.exe as the host application. You can find
> this under Run | Parameters.
> a. Set the host application to ads.exe
> b. Set the parameters to '/exe'
> c. Set the working directory to the directory where the Advantage Server
> is installed.
>
> You can now set breakpoints and debug the AEP. I would first start by
> looking at what your doing in that second connection and why you need it
> instead of the connection being passed in by Advantage. Is that
> connection on a data module that is specific to each user or are you using
> a single global connection?
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
>
>
> "David Looney" <davidl@autostarsolutions.com> wrote in message
> news:499326ce@solutions.advantagedatabase.com...
>> We are writting an AEP to take payments and have run into a problem.
>> When we do simultaneous testing to simulate multi-users one session will
>> complete just fine but the other one will not. We've changed our code to
>> use the connection coming in from the AEP call and we are creating a
>> second connection to point to our company folder tables. Can anyone
>> provide me with some suggestions on what I might be able to do to debug
>> this and find what the problem is?
>>
>> Thanks
>> David
>>
>
>


Lance Schmidt Posted on 2009-02-11 22:37:56.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.AEP
References: <499326ce@solutions.advantagedatabase.com> <499339b5@solutions.advantagedatabase.com> <49934278@solutions.advantagedatabase.com>
Subject: Re: Multiuser AEP?
Date: Wed, 11 Feb 2009 15:37:56 -0700
Lines: 91
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.117
Message-ID: <4993532d@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2009 15:37:33 -0700, 10.24.38.117
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.117
Xref: solutions.advantagedatabase.com Advantage.AEP:681
Article PK: 1103962

Hi David,

Disabling DLL caching is the most important step when trying to debug an
AEP, so I strongly suggest you start there.

What type of problem are you experiencing? Is it deadlock or an exception?
If it is deadlock at first you can simply let a version of the ADS hosted by
Delphi run until it deadlocks. At that point you can inspect the different
threads running your AEP and see why they are blocked. If your getting an
exception you can have debugger break when that exception is first thrown.

Best Regards,

Lance Schmidt
Advantage R&D

"David Looney" <davidl@autostarsolutions.com> wrote in message
news:49934278@solutions.advantagedatabase.com...
> The reason I need the second connection is because our tables are located
> in different folders. Our folder structure looks like this:
>
> c:\Customer\
> c:\Customer\ASDate1\
> c:\Customer\ASDate1\CO1\
>
> Our global tables, which are used by all companies, are in the ASData1
> folder, while our company specific tables are in the CO1 folder and we can
> have up to 99 different companies.
>
> As for the debugging, I have not done two of the things you mentioned and
> those are disable caching and setting the working folder.
>
> The problem I am having only appears when two different users hit the AEP
> at the same time, so I'm not quite sure how to debug a scenario like this.
>
> David
>
> "Lance Schmidt" <LanceSc@ExtendSys.com> wrote in message
> news:499339b5@solutions.advantagedatabase.com...
>> Hi David,
>>
>> Debugging AEPs takes a bit of setup. First of all you need to you need
>> to disable DLL caching. You can use the following SQL statement to do
>> that:
>>
>> execute procedure sp_ModifyDatabase ('DISABLE_DLL_CACHING', 'TRUE');
>>
>> Next you need to build debug symbols for the AEP. On the Delphi menu
>> choose 'Project', then 'Options'. Select the 'Linker' tab, and check the
>> 'Include Remote Debug Symbols' and the 'Include TD32 debug info'
>> checkboxes.
>>
>> Finally you need to use the ads.exe as the host application. You can
>> find this under Run | Parameters.
>> a. Set the host application to ads.exe
>> b. Set the parameters to '/exe'
>> c. Set the working directory to the directory where the Advantage Server
>> is installed.
>>
>> You can now set breakpoints and debug the AEP. I would first start by
>> looking at what your doing in that second connection and why you need it
>> instead of the connection being passed in by Advantage. Is that
>> connection on a data module that is specific to each user or are you
>> using a single global connection?
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>>
>>
>>
>> "David Looney" <davidl@autostarsolutions.com> wrote in message
>> news:499326ce@solutions.advantagedatabase.com...
>>> We are writting an AEP to take payments and have run into a problem.
>>> When we do simultaneous testing to simulate multi-users one session will
>>> complete just fine but the other one will not. We've changed our code
>>> to use the connection coming in from the AEP call and we are creating a
>>> second connection to point to our company folder tables. Can anyone
>>> provide me with some suggestions on what I might be able to do to debug
>>> this and find what the problem is?
>>>
>>> Thanks
>>> David
>>>
>>
>>
>
>