I was using the interval setting incorrectly. On Tue, Aug 4, 2009 at 9:48 AM, Joe DeSouza<[email protected]> wrote: > ** > Frank, > > Do you have a hard limit on the total number of SQL connections to the SQL > database? I remember that there used to be an issue with AIE hogging SQL > user connections and starting a new user connection everytime it runs. So if > you have a limit on the number of open SQL connections, once that limit is > reached the engine would not have an available SQL user connection to start > causing it to fail.. > > Start up your SQL monitor and check if AIE has hogged up all available SQL > user connections.. > > If thats the case, you could use a Windows scheduled task to stop the AIE > service at a reasonable time after it has had enough time to run and > complete its job and use another scheduled task to restart it a few minutes > before the AIE job is scheduled to run.. > > Its a workaround I had used in the past to tackle that issue.. > > Cheers > > Joe > ________________________________ > From: Frank Caruso <[email protected]> > To: [email protected] > Sent: Sunday, August 2, 2009 2:00:41 AM > Subject: AIE Data Exchange Not Re-Starting > > ARS 7.1p5 AIE 7.1p7 SQL Server > > Having an issue where we can get a Data Exchange to run once but cannot get > that DE to run again unless we restart AIE. No errors in any log files. > Tried making changes to the DE to see if that would trigger a restart but no > luck. The one thing that did work was making a copy the DE. Then the new one > ran once but never again. I feel we are missing something obvious as there > was no mention of this being an issue on the ARSList on BMC support. > > Any thoughts? > > Frank Caruso > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
