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.

.aep files multiplying like rabbits

5 posts in AEP Last posting was on 2009-07-22 16:49:05.0Z
Philippe Bruno Posted on 2009-07-21 15:33:33.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.AEP
Subject: .aep files multiplying like rabbits
Date: Tue, 21 Jul 2009 11:33:33 -0400
Lines: 25
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: 69.70.67.26
Message-ID: <4a65de93@solutions.advantagedatabase.com>
X-Trace: 21 Jul 2009 09:28:19 -0700, 69.70.67.26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.70.67.26
Xref: solutions.advantagedatabase.com Advantage.AEP:740
Article PK: 1104017

Hello,

I created my first stored procedure in Delphi using the template provided.
Everything worked like a charm, except one thing: in my database folder on
the server, files prefixed with my original "aep" DLL (AdsProcs.aep),
followed by an hexadecimal sequence are multiplying like rabbits. Here is a
some of those files:

AdsProcs1A852604.aep
AdsProcs62542F4C.aep
AdsProcs831A2C51.aep
AdsProcsA12C5B6D.aep
AdsProcsB2DF60C0.aep
AdsProcsC3EE12ED.aep
AdsProcsEB0E8705.aep
...

I assume these are temporary files, but when do they get deleted by ADS?
Although not really convenient, is it safe for me to manually delete them?

Thanks in advance,

Philippe


Philippe Bruno Posted on 2009-07-21 18:36:18.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.AEP
References: <4a65de93@solutions.advantagedatabase.com>
Subject: Re: .aep files multiplying like rabbits
Date: Tue, 21 Jul 2009 14:36:18 -0400
Lines: 57
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: 69.70.67.26
Message-ID: <4a660968@solutions.advantagedatabase.com>
X-Trace: 21 Jul 2009 12:31:04 -0700, 69.70.67.26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.70.67.26
Xref: solutions.advantagedatabase.com Advantage.AEP:743
Article PK: 1104018

Lance,

I did some tests and both the Startup and Shutdown functions of the AEP get
called as shown in the log file below:
...
2009-07-21 14:28:15 Startup
2009-07-21 14:28:15 Adding testuser
2009-07-21 14:28:22 Shutdown
...

Everything else executed normally and there was no error condition. Both
Startup and Shutdown are as-is (ie. they were not modified). Only the
exported function was modified between the

//// Place the business logic of your procedure here. ///////////////////
and
////////////////////////////////////////////////////////////////////////////////////////////////

with the exception of some code before to access the input parameters:

tblInput.open;
FtpUser := tblInput.FieldByName('FtpUser').Value;
Password := tblInput.FieldByName('Password').Value;
tblInput.close;

Thanks in advance,

Philippe

"Philippe Bruno" <pbruno@deveauxbrault.com> a écrit dans le message de news:
4a65de93@solutions.advantagedatabase.com...

> Hello,
>
> I created my first stored procedure in Delphi using the template provided.
> Everything worked like a charm, except one thing: in my database folder on
> the server, files prefixed with my original "aep" DLL (AdsProcs.aep),
> followed by an hexadecimal sequence are multiplying like rabbits. Here is
> a some of those files:
>
> AdsProcs1A852604.aep
> AdsProcs62542F4C.aep
> AdsProcs831A2C51.aep
> AdsProcsA12C5B6D.aep
> AdsProcsB2DF60C0.aep
> AdsProcsC3EE12ED.aep
> AdsProcsEB0E8705.aep
> ...
>
> I assume these are temporary files, but when do they get deleted by ADS?
> Although not really convenient, is it safe for me to manually delete them?
>
> Thanks in advance,
>
> Philippe
>


Philippe Bruno Posted on 2009-07-21 16:09:35.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.AEP
References: <4a65de93@solutions.advantagedatabase.com>
Subject: Re: .aep files multiplying like rabbits
Date: Tue, 21 Jul 2009 12:09:35 -0400
Lines: 59
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: 69.70.67.26
Message-ID: <4a65e704@solutions.advantagedatabase.com>
X-Trace: 21 Jul 2009 10:04:20 -0700, 69.70.67.26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.70.67.26
Xref: solutions.advantagedatabase.com Advantage.AEP:742
Article PK: 1104019

Hi Lance,

Well, not really. Other than using the tblInput to access the input
parameter, I do not access any other table in my database. The AEP is simply
adding a line to a text log file, creating a folder on the server and
creating a new user in the FTP server (the application is some sort of a CRM
that allows clients to connect via FTP and upload required documents).

Also, I don't know if this could be the problem, but while looking at my
source, I realise that the DataConn component in the data module of my AEP
has no ConnectPath nor AliasName defined. Since there are calls to it in the
DLL, I assume it finds the database by itself being in the same folder.
Should I explicitely close the connection when I am done?

If you have more ideas, let me know.

> Hi Philippe,
>
> Those are cached copies of the AEP as described by this help file entry,
> http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_concepts/advantage_functionality/dll_caching.htm.
> They should be deleted when the last user having a connection to them is
> finished with the AEP. Is it possible that the AEP is making a connection
> of it's own?
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>

>> Hello,
>>
>> I created my first stored procedure in Delphi using the template
>> provided. Everything worked like a charm, except one thing: in my
>> database folder on the server, files prefixed with my original "aep" DLL
>> (AdsProcs.aep), followed by an hexadecimal sequence are multiplying like
>> rabbits. Here is a some of those files:
>>
>> AdsProcs1A852604.aep
>> AdsProcs62542F4C.aep
>> AdsProcs831A2C51.aep
>> AdsProcsA12C5B6D.aep
>> AdsProcsB2DF60C0.aep
>> AdsProcsC3EE12ED.aep
>> AdsProcsEB0E8705.aep
>> ...
>>
>> I assume these are temporary files, but when do they get deleted by ADS?
>> Although not really convenient, is it safe for me to manually delete
>> them?
>>
>> Thanks in advance,
>>
>> Philippe
>>
>
>


Lance Schmidt Posted on 2009-07-22 15:40:44.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.AEP
References: <4a65de93@solutions.advantagedatabase.com> <4a65e704@solutions.advantagedatabase.com>
Subject: Re: .aep files multiplying like rabbits
Date: Wed, 22 Jul 2009 09:40:44 -0600
Lines: 77
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: <4a6732ba@solutions.advantagedatabase.com>
X-Trace: 22 Jul 2009 09:39:38 -0700, 10.24.38.117
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.117
Xref: solutions.advantagedatabase.com Advantage.AEP:752
Article PK: 1104028

Hi Philppe,

It is fine that the ConnectPath is not defined not defined. In the startup
function we set the handle for the connection to use. Make sure you are
using the latest version of the AEP template that uses a DllMain to clean up
at the end.

Best Regards,

Lance Schmidt
Advantage R&D

"Philippe Bruno" <pbruno@deveauxbrault.com> wrote in message
news:4a65e704@solutions.advantagedatabase.com...
> Hi Lance,
>
> Well, not really. Other than using the tblInput to access the input
> parameter, I do not access any other table in my database. The AEP is
> simply adding a line to a text log file, creating a folder on the server
> and creating a new user in the FTP server (the application is some sort of
> a CRM that allows clients to connect via FTP and upload required
> documents).
>
> Also, I don't know if this could be the problem, but while looking at my
> source, I realise that the DataConn component in the data module of my AEP
> has no ConnectPath nor AliasName defined. Since there are calls to it in
> the DLL, I assume it finds the database by itself being in the same
> folder. Should I explicitely close the connection when I am done?
>
> If you have more ideas, let me know.
>
>> Hi Philippe,
>>
>> Those are cached copies of the AEP as described by this help file entry,
>> http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_concepts/advantage_functionality/dll_caching.htm.
>> They should be deleted when the last user having a connection to them is
>> finished with the AEP. Is it possible that the AEP is making a
>> connection of it's own?
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>>
>
>>> Hello,
>>>
>>> I created my first stored procedure in Delphi using the template
>>> provided. Everything worked like a charm, except one thing: in my
>>> database folder on the server, files prefixed with my original "aep" DLL
>>> (AdsProcs.aep), followed by an hexadecimal sequence are multiplying like
>>> rabbits. Here is a some of those files:
>>>
>>> AdsProcs1A852604.aep
>>> AdsProcs62542F4C.aep
>>> AdsProcs831A2C51.aep
>>> AdsProcsA12C5B6D.aep
>>> AdsProcsB2DF60C0.aep
>>> AdsProcsC3EE12ED.aep
>>> AdsProcsEB0E8705.aep
>>> ...
>>>
>>> I assume these are temporary files, but when do they get deleted by ADS?
>>> Although not really convenient, is it safe for me to manually delete
>>> them?
>>>
>>> Thanks in advance,
>>>
>>> Philippe
>>>
>>
>>
>
>


Philippe Bruno Posted on 2009-07-22 16:49:05.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.AEP
References: <4a65de93@solutions.advantagedatabase.com> <4a65e704@solutions.advantagedatabase.com> <4a6732ba@solutions.advantagedatabase.com>
Subject: Re: .aep files multiplying like rabbits
Date: Wed, 22 Jul 2009 12:49:05 -0400
Lines: 96
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: 24.200.56.231
Message-ID: <4a6741c4@solutions.advantagedatabase.com>
X-Trace: 22 Jul 2009 10:43:48 -0700, 24.200.56.231
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.200.56.231
Xref: solutions.advantagedatabase.com Advantage.AEP:753
Article PK: 1104031

Lance,

> Make sure you are using the latest version of the
> AEP template that uses a DllMain to clean up at the end.

I have the one I installed with the latest TDataSet (9.10.0.9) descendant
for Delphi 7 (specifically the Advantage Extended Procedure Interface). What
should I look for exactly in the template? At the very end of the source
DLL, the following line is found:

{* Assign our own cleanup procedure. *}
DllProc := @DllMain;

Philippe

"Lance Schmidt" <LanceSc@ExtendSys.com> a écrit dans le message de news:
4a6732ba@solutions.advantagedatabase.com...
> Hi Philppe,
>
> It is fine that the ConnectPath is not defined not defined. In the
> startup function we set the handle for the connection to use. Make sure
> you are using the latest version of the AEP template that uses a DllMain
> to clean up at the end.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
>
> "Philippe Bruno" <pbruno@deveauxbrault.com> wrote in message
> news:4a65e704@solutions.advantagedatabase.com...
>> Hi Lance,
>>
>> Well, not really. Other than using the tblInput to access the input
>> parameter, I do not access any other table in my database. The AEP is
>> simply adding a line to a text log file, creating a folder on the server
>> and creating a new user in the FTP server (the application is some sort
>> of a CRM that allows clients to connect via FTP and upload required
>> documents).
>>
>> Also, I don't know if this could be the problem, but while looking at my
>> source, I realise that the DataConn component in the data module of my
>> AEP has no ConnectPath nor AliasName defined. Since there are calls to it
>> in the DLL, I assume it finds the database by itself being in the same
>> folder. Should I explicitely close the connection when I am done?
>>
>> If you have more ideas, let me know.
>>
>>> Hi Philippe,
>>>
>>> Those are cached copies of the AEP as described by this help file entry,
>>> http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_concepts/advantage_functionality/dll_caching.htm.
>>> They should be deleted when the last user having a connection to them is
>>> finished with the AEP. Is it possible that the AEP is making a
>>> connection of it's own?
>>>
>>> Best Regards,
>>>
>>> Lance Schmidt
>>> Advantage R&D
>>>
>>
>>>> Hello,
>>>>
>>>> I created my first stored procedure in Delphi using the template
>>>> provided. Everything worked like a charm, except one thing: in my
>>>> database folder on the server, files prefixed with my original "aep"
>>>> DLL (AdsProcs.aep), followed by an hexadecimal sequence are multiplying
>>>> like rabbits. Here is a some of those files:
>>>>
>>>> AdsProcs1A852604.aep
>>>> AdsProcs62542F4C.aep
>>>> AdsProcs831A2C51.aep
>>>> AdsProcsA12C5B6D.aep
>>>> AdsProcsB2DF60C0.aep
>>>> AdsProcsC3EE12ED.aep
>>>> AdsProcsEB0E8705.aep
>>>> ...
>>>>
>>>> I assume these are temporary files, but when do they get deleted by
>>>> ADS? Although not really convenient, is it safe for me to manually
>>>> delete them?
>>>>
>>>> Thanks in advance,
>>>>
>>>> Philippe
>>>>
>>>
>>>
>>
>>
>
>