That could do it :-) Does AIE still hog user connections though? It would not release the user connection after the schedule had run, and use another user connection the next time that same schedule runs.. These user connections were relased only upon stopping the EIE/AIE service.
I remember this being a issue a few versions ago and if I remember right, it still was with version 7.1 I haven't worked with the SQL server and AIE 7.5 so cannot comment for the new one.. It always worked nicely with Oracle though.. Joe ________________________________ From: Frank Caruso <caruso.fr...@gmail.com> To: arslist@ARSLIST.ORG Sent: Tuesday, August 4, 2009 3:37:28 AM Subject: RESOLVED Re: AIE Data Exchange Not Re-Starting I was using the interval setting incorrectly. On Tue, Aug 4, 2009 at 9:48 AM, Joe DeSouza<joe_rem...@yahoo.com> 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 <caruso.fr...@gmail.com> > To: arslist@ARSLIST.ORG > 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
