Truncate the db tables that store the email error logs. Axton Grams
On Thu, Oct 22, 2009 at 9:22 AM, John Kelley <[email protected]>wrote: > > I just deleted the error logs. > > I reopen my Messages form and it still takes over a minute to open the form > in search mode to display only one item. > > Any other suggestions? > > Could it be thread settings for email? Here is what I have set. > Private-RPC-Socket: 390601 1 1 > Private-RPC-Socket: 390603 1 1 > Private-RPC-Socket: 390620 4 10 > Private-RPC-Socket: 390626 2 4 > Private-RPC-Socket: 390627 4 4 > Private-RPC-Socket: 390635 4 10 > Private-RPC-Socket: 390650 4 6 > > > > *"Chowdhury, Tauf" <[email protected]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 10/22/2009 10:07 AM > Please respond to > [email protected] > > To > [email protected] cc > Subject > Re: AR System Email Messages Form > > > > > Yes... but make sure you don't need the logs. Is this a production system? > If you are not sure, you may want to export them first to .arx. > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) on behalf of John > Kelley > Sent: Thu 10/22/2009 8:20 AM > To: [email protected] > Subject: Re: AR System Email Messages Form > > I do have over 95,000 items in the email error logs form. > Are you saying to delete those out and retry opening the email messages > form. > > JK > > > > > > "Chowdhury, Tauf" <[email protected]> > Sent by: "Action Request System discussion list(ARSList)" > <[email protected]> > 10/22/2009 06:18 AM > Please respond to > [email protected] > > > To > [email protected] > cc > > Subject > Re: AR System Email Messages Form > > > > > > > ** > What I?ve seen as the usual suspect is the Email Error Logs form . > Depending on what level of logging you have turned on for E-mail messages, > that 1 e-mail entry may have 20 entries associated within the error log > form. (I may be exaggerating) > > Tauf Chowdhury > Analyst, Service Management > Office: 631.858.7765 > Mobile:646.483.2779 > > > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Frank Caruso > Sent: Thursday, October 22, 2009 1:15 AM > To: [email protected] > Subject: Re: AR System Email Messages Form > > ** > Its probably not the search of that form but the refresh of several table > fields that are on that form. > On Wed, Oct 21, 2009 at 11:10 PM, John Kelley < > [email protected]> wrote: > > Hi List > Has anyone had issues loading the AR System Email Messages in search mode? > > It takes way to long to load. > > I deleted all but one entry in the messages form and if I refresh my > search results, it takes over a minute to load the one entry. > It is so slow. > > Any Suggestions? > > ARS 7.1 patch 6 > Oracle 10G > > ************************************************************* > This e-mail message, including any attachments, is for the sole use of the > addressee(s) to whom it has been sent, and may contain information that is > confidential or legally protected. If you are not the intended recipient > or have received this message in error, you are not authorized to copy, > distribute, or otherwise use this message or its attachments. Please > notify the sender immediately by return e-mail and permanently delete this > message and any attachments. Dunkin' Brands Inc. makes no warranty that > this e-mail is error or virus free. > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > This e-mail and its attachments may contain Forest Laboratories, Inc. > proprietary information that is privileged, confidential or subject to > copyright belonging to Forest Laboratories, Inc. This e-mail is intended > solely for the use of the individual or entity to which it is addressed. > If you are not the intended recipient of this e-mail, or the employee or > agent responsible for delivering this e-mail to the intended recipient, > you are hereby notified that any dissemination, distribution, copying or > action taken in relation to the contents of and attachments to this e-mail > is strictly prohibited and may be unlawful. If you have received this > e-mail in error, please notify the sender immediately and permanently > delete the original and any copy of this e-mail and any printout. > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > > > ************************************************************* > This e-mail message, including any attachments, is for the sole use of the > addressee(s) to whom it has been sent, and may contain information that is > confidential or legally protected. If you are not the intended recipient or > have received this message in error, you are not authorized to copy, > distribute, or otherwise use this message or its attachments. Please notify > the sender immediately by return e-mail and permanently delete this message > and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail > is error or virus free. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > > ********************************************************************** > This e-mail and its attachments may contain Forest Laboratories, Inc. > proprietary information that is privileged, confidential or subject to > copyright belonging to Forest Laboratories, Inc. This e-mail is intended > solely for the use of the individual or entity to which it is addressed. If > you are not the intended recipient of this e-mail, or the employee or agent > responsible for delivering this e-mail to the intended recipient, you are > hereby notified that any dissemination, distribution, copying or action > taken in relation to the contents of and attachments to this e-mail is > strictly prohibited and may be unlawful. If you have received this e-mail in > error, please notify the sender immediately and permanently delete the > original and any copy of this e-mail and any printout. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > > ************************************************************* > This e-mail message, including any attachments, is for the sole use of the > addressee(s) to whom it has been sent, and may contain information that is > confidential or legally protected. If you are not the intended recipient or > have received this message in error, you are not authorized to copy, > distribute, or otherwise use this message or its attachments. Please notify > the sender immediately by return e-mail and permanently delete this message > and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail > is error or virus free. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
