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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
