Does the BCC field on the AR System Email Messages form populate from incoming messages?
We have recently migrated to Remedy 9.1.02 from 9.0.1. In our 9.0.1 environment, when an incoming email that had a BCC on it was processed by the AR Email Engine into the AR System Email Messages form, the BCC value on the form had the appropriate BCC value on it. Now in our 9.1.02 environment, when an email with a BCC is processed into the AR System Email Messages form, there is no BCC value on the AR System Email Messages. I am being told from BMC that not having the BCC populated is "by design" and that they tested this on an OOB 9.0.1 version with the same results (and therefore it is by design on v9.1) and that we must have a customization in place to do this. I cannot find any type of customization that we put in place that would populate the BCC field via Remedy workflows (and how we would populate this correctly without reverse engineering the email engine executable is beyond me) So I am looking for some input from the other Remedy system admins...For those of you that have either v9.0.1 and/or v9.1.x (or even earlier versions), would you confirm the BCC value on incoming email messages is ether being or not being populated on the AR System Email Messages form when the corresponding entry is created? Also, would you let me know the ARS version regardless of the answer Thanks for the help! John [I have also asked this in the communities pages, but thought it a good idea to each out here as well...thanks!] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Blank Body in AR System Email Messages form
What do you observe in log when you send an plain text mail, html mail from Outlook. Can you check with the content type in debug email logs. when sending an email to incoming configured email. Regards, Ravindrakumar On 16-Sep-2015 11:38 AM, "Satpal Singh Ply" wrote: > ** > Hello Terri, > > We have seen this issue, this might happen due to Exchange Server Version > or the format of an email has. Please find the KB below, this might help > you to resolve the issue. > > > https://kb.bmc.com/infocenter/index?page=content&id=KA362351&actp=search&viewlocale=en_US&searchid=1441776705345 > > Regards, > Satpal Singh > > On Thu, Sep 3, 2015 at 12:41 AM, Terri Lockwood < > teresa.lockw...@sungard.com> wrote: > >> ** >> >> Thank you John. Both the Plain Text Body and HTML Body fields are blank >> in the AR System Email Messages form. Under Advanced Options/Attachment >> Alternatives I do see the .eml file but again it is blank as well. I >> forgot to mention that this is an intermittent issue…doesn’t happen all the >> time so logging is tough as well. Troubleshooting continues….. >> >> >> >> *TERRI* >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Reiser, John J >> *Sent:* Wednesday, September 02, 2015 2:16 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Blank Body in AR System Email Messages form >> >> >> >> ** >> >> Terri, >> >> I’ve seen this and the message body usually ends up in the HTML Body tab >> on the AR System Email form. >> >> Also, in the advanced options tab there are three more tabs. The >> Attachment Alternatives has an Attachment Pool and one of the attachments >> is almost always a an email file. >> >> So the data are there you may need to change workflow to retrieve it into >> the ticket. >> >> >> >> Maybe there’s a way to force your email inbox to only accept ( or convert >> to) plain text. >> >> Thank you, >> >> --- >> John J. Reiser >> Building 760-J202 >> Remedy Developer/Administrator >> >> Senior Software Development Analyst >> Lockheed Martin - MST Moorestown Region >> The star that burns twice as bright burns half as long. >> Pay close attention and be illuminated by its brilliance. - paraphrased >> by me >> >> >> >> *From:* Action Request System discussion list(ARSList) [ >> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Terri >> Lockwood >> *Sent:* Wednesday, September 02, 2015 1:54 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* EXTERNAL: Blank Body in AR System Email Messages form >> >> >> >> ** >> >> I am hoping someone has had this same issue and can help me. I do >> already have a ticket with BMC as well. >> >> >> >> When our customers send an email to our email address it comes into the >> mailbox complete and I can see it. However, when it gets pushed to the AR >> System Email Messages form the “Plain Text Body” field is blank. It, >> therefore, gets pushed into the ticket with a blank body as well. BMC is >> looking at our logs but I was hoping someone has seen this and maybe can >> provide a solution. >> >> >> >> Thank you, >> >> >> >> ~~~ >> >> Terri >> >> >> >> ARS 7.6.04 >> >> ITSM 7.6.03 >> >> Midtier 7.6.04 >> >> Windows 2008 >> >> MS SQL 2008 R2 SP2 >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Blank Body in AR System Email Messages form
Hello Terri, We have seen this issue, this might happen due to Exchange Server Version or the format of an email has. Please find the KB below, this might help you to resolve the issue. https://kb.bmc.com/infocenter/index?page=content&id=KA362351&actp=search&viewlocale=en_US&searchid=1441776705345 Regards, Satpal Singh On Thu, Sep 3, 2015 at 12:41 AM, Terri Lockwood wrote: > ** > > Thank you John. Both the Plain Text Body and HTML Body fields are blank > in the AR System Email Messages form. Under Advanced Options/Attachment > Alternatives I do see the .eml file but again it is blank as well. I > forgot to mention that this is an intermittent issue…doesn’t happen all the > time so logging is tough as well. Troubleshooting continues….. > > > > *TERRI* > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Reiser, John J > *Sent:* Wednesday, September 02, 2015 2:16 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Blank Body in AR System Email Messages form > > > > ** > > Terri, > > I’ve seen this and the message body usually ends up in the HTML Body tab > on the AR System Email form. > > Also, in the advanced options tab there are three more tabs. The > Attachment Alternatives has an Attachment Pool and one of the attachments > is almost always a an email file. > > So the data are there you may need to change workflow to retrieve it into > the ticket. > > > > Maybe there’s a way to force your email inbox to only accept ( or convert > to) plain text. > > Thank you, > > --- > John J. Reiser > Building 760-J202 > Remedy Developer/Administrator > > Senior Software Development Analyst > Lockheed Martin - MST Moorestown Region > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Terri > Lockwood > *Sent:* Wednesday, September 02, 2015 1:54 PM > *To:* arslist@ARSLIST.ORG > *Subject:* EXTERNAL: Blank Body in AR System Email Messages form > > > > ** > > I am hoping someone has had this same issue and can help me. I do already > have a ticket with BMC as well. > > > > When our customers send an email to our email address it comes into the > mailbox complete and I can see it. However, when it gets pushed to the AR > System Email Messages form the “Plain Text Body” field is blank. It, > therefore, gets pushed into the ticket with a blank body as well. BMC is > looking at our logs but I was hoping someone has seen this and maybe can > provide a solution. > > > > Thank you, > > > > ~~~ > > Terri > > > > ARS 7.6.04 > > ITSM 7.6.03 > > Midtier 7.6.04 > > Windows 2008 > > MS SQL 2008 R2 SP2 > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Blank Body in AR System Email Messages form
Thank you John. Both the Plain Text Body and HTML Body fields are blank in the AR System Email Messages form. Under Advanced Options/Attachment Alternatives I do see the .eml file but again it is blank as well. I forgot to mention that this is an intermittent issue...doesn't happen all the time so logging is tough as well. Troubleshooting continues. TERRI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, September 02, 2015 2:16 PM To: arslist@ARSLIST.ORG Subject: Re: Blank Body in AR System Email Messages form ** Terri, I've seen this and the message body usually ends up in the HTML Body tab on the AR System Email form. Also, in the advanced options tab there are three more tabs. The Attachment Alternatives has an Attachment Pool and one of the attachments is almost always a an email file. So the data are there you may need to change workflow to retrieve it into the ticket. Maybe there's a way to force your email inbox to only accept ( or convert to) plain text. Thank you, --- John J. Reiser Building 760-J202 Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MST Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terri Lockwood Sent: Wednesday, September 02, 2015 1:54 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: EXTERNAL: Blank Body in AR System Email Messages form ** I am hoping someone has had this same issue and can help me. I do already have a ticket with BMC as well. When our customers send an email to our email address it comes into the mailbox complete and I can see it. However, when it gets pushed to the AR System Email Messages form the "Plain Text Body" field is blank. It, therefore, gets pushed into the ticket with a blank body as well. BMC is looking at our logs but I was hoping someone has seen this and maybe can provide a solution. Thank you, ~~~ Terri ARS 7.6.04 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Blank Body in AR System Email Messages form
Terri, I've seen this and the message body usually ends up in the HTML Body tab on the AR System Email form. Also, in the advanced options tab there are three more tabs. The Attachment Alternatives has an Attachment Pool and one of the attachments is almost always a an email file. So the data are there you may need to change workflow to retrieve it into the ticket. Maybe there's a way to force your email inbox to only accept ( or convert to) plain text. Thank you, --- John J. Reiser Building 760-J202 Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MST Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terri Lockwood Sent: Wednesday, September 02, 2015 1:54 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Blank Body in AR System Email Messages form ** I am hoping someone has had this same issue and can help me. I do already have a ticket with BMC as well. When our customers send an email to our email address it comes into the mailbox complete and I can see it. However, when it gets pushed to the AR System Email Messages form the "Plain Text Body" field is blank. It, therefore, gets pushed into the ticket with a blank body as well. BMC is looking at our logs but I was hoping someone has seen this and maybe can provide a solution. Thank you, ~~~ Terri ARS 7.6.04 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Blank Body in AR System Email Messages form
I am hoping someone has had this same issue and can help me. I do already have a ticket with BMC as well. When our customers send an email to our email address it comes into the mailbox complete and I can see it. However, when it gets pushed to the AR System Email Messages form the "Plain Text Body" field is blank. It, therefore, gets pushed into the ticket with a blank body as well. BMC is looking at our logs but I was hoping someone has seen this and maybe can provide a solution. Thank you, ~~~ Terri ARS 7.6.04 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
No key back to the originating form/record from "AR System Email Messages" form records??
Hi all: It appears that records on the "AR System Email Messages" form, caused by a Notify action in a filter, contain no information to indicate which form and which record it originated from. I would have thought they would have designed the email subsystem to include the form name on which the filter fired, and the record on which the filter fired. There is a unique GUID on each email message's record, but that doesn't tie back to the form/record. I am trying to have a table on my ticket form to display all the emails that have been sent from the ticket. Looks like I have to add records on a separate form on each Notify action. Or add filters to the AR System Email Messages form to populate some fields based on keywords on the message. Somebody please tell me I am wrong. ARS 6.3 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re : Re : AR System Email Messages Form
Can't agree more LJ. You are right :) De : LJ Longwing À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 19 h 08 min 17 s Objet : Re: Re : AR System Email Messages Form ** There shouldn't be an extended lock on the table, yes it will take awhile, but the way the Remedy client works is it issues a delete for each record, so any statements working on those tables will be able to work within the gaps between delete statements. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frex Popo Sent: Thursday, October 22, 2009 10:46 AM To: arslist@ARSLIST.ORG Subject: Re : Re : AR System Email Messages Form ** If you decide to delete some or all the data from the client, you will have to think about locking issues, as it takes time to delete large amounts of data from the client, especially on a production system ...other users will be blocked, since a delete operation - me think - will require an exclusive lock on the table.. So you will perhaps need to do this at the database level ... this is not straight foward ... you will need to look for the T, B, H tables (in the arschema) and any other attachment field tables for the error log form before runing any truncate or delete etc.. De : Frex Popo À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 18 h 33 min 48 s Objet : Re : AR System Email Messages Form I had the same problem, but with an asset management form with a couple of tables ... I enabled the SQL logging for the client, did a refresh, and then copied the select statements from the log file to a SQL editor and ran the queries ... found two of the the select statements taking too long before coming back with data added chunking to the field table and also an index to one of the classes and it resolved my issue Add the followings before your selects if you don't want to execute your query and want to see how long it will take and if any indexes are being used etc ... set noexec on set showplan on set statistics time on De : John Kelley À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 14 h 20 min 35 s Objet : 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 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: rmisoluti...@verizon.net 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
Re: AR System Email Messages Form
Yeah, this is a good starting point :-) http://communities.bmc.com/communities/docs/DOC-126 -- Jarl 2009/10/22 Thad K Esser > ** > Lyle said everything I was about to suggest. > > It would also be nice if BMC wouldn't refresh tables on tabs unless that > tab is showing (on display of a record). They do it all over the place. It > slows down display of the form, and almost always, the table doesn't need to > be refreshed until the user selects the tab. It bugs me almost as much as > using a TR value. > > So, depending on how much of an issue it is for you, you could modify the > email messages form to not automatically refresh the tables, and then add an > active link on tab select that refreshes the table. > > *Thad Esser* > Remedy Developer > "*Now... Just where did I put that cheese...?"* > > > From: Lyle Taylor To: arslist@ARSLIST.ORG Date: > 10/22/2009 > 10:17 AM Subject: Re: AR System Email Messages Form > Sent by: "Action Request System discussion list(ARSList)" < > arslist@ARSLIST.ORG> > -- > > > > ** > We had the exact same issue. The problem isn’t the number of errors > associated with any given message, it’s the number of total errors in the > error log form combined with the fact that 1) BMC didn’t add any indexes to > the form (that’s an issue in several places), and 2) the form does not get > cleaned up as e-mails get deleted (that is, BMC didn’t include workflow to > delete error logs as the corresponding e-mail get deleted). The issue is > that there is a table on the email messages form that references the error > logs form, and when you view a message, it refreshes the table. Since the > error logs form doesn’t have an index on it, it does a table scan in the > database every time. > > To fix it, do at least the following: > > *Add an index on the field ‘Email ID’ on the AR System Email Error Logs > forms.* > > That will significantly speed up viewing e-mails regardless of how many > records are in the error logs form. > > Next, you can add a filter to AR System Email Messages that runs on Delete > and performs a Run Process action with the following text: > > Application-Query-Delete-Entry "AR System Email Error Logs" '18023' = > "$Email ID$" > > This will remove errors from the error log as e-mails get deleted from the > email messages form. That will keep your error logs from continuously > growing out of control (assuming that you don’t keep all e-mails in your > email messages form). > > Lastly, I would clean out all the current entries in the error logs form, > unless you need them for some reason. If you really want to be clever, you > can only clean out entries that don’t still have a corresponding e-mail in > the e-mail messages form, but you’d probably have to either write program or > write some workflow to determine if a given error entry has a corresponding > e-mail. You don’t need to worry about deleting large amounts of data in the > user tool. I’ve routinely deleted 5-20K records at a time in the User tools > without causing any issues for other users on the system. It does take a > long time, though. > > Doing all three of those things will keep viewing e-mails fast and keep > your error logs cleaned up with only relevant data (it’s no longer relevant > if the corresponding e-mail is no longer there). > > Good luck, > Lyle > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] *On Behalf Of *John > Kelley* > Sent:* Thursday, October 22, 2009 6:21 AM* > To:* arsl...@arslist.org* > 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" * > Sent by: "Action Request System discussion list(ARSList)" < > arslist@ARSLIST.ORG> > > 10/22/2009 06:18 AM > > > Please respond to > arslist@ARSLIST.ORG > > > To > arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG ] *On Behalf Of *
Re: AR System Email Messages Form
I agree, although having the table refresh at the beginning wouldn't be as much of an issue if BMC would simply add appropriate indexes to the forms they reference... Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Thursday, October 22, 2009 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Lyle said everything I was about to suggest. It would also be nice if BMC wouldn't refresh tables on tabs unless that tab is showing (on display of a record). They do it all over the place. It slows down display of the form, and almost always, the table doesn't need to be refreshed until the user selects the tab. It bugs me almost as much as using a TR value. So, depending on how much of an issue it is for you, you could modify the email messages form to not automatically refresh the tables, and then add an active link on tab select that refreshes the table. Thad Esser Remedy Developer "Now... Just where did I put that cheese...?" From: Lyle Taylor To: arslist@ARSLIST.ORG Date: 10/22/2009 10:17 AM Subject: Re: AR System Email Messages Form Sent by: "Action Request System discussion list(ARSList)" ** We had the exact same issue. The problem isn't the number of errors associated with any given message, it's the number of total errors in the error log form combined with the fact that 1) BMC didn't add any indexes to the form (that's an issue in several places), and 2) the form does not get cleaned up as e-mails get deleted (that is, BMC didn't include workflow to delete error logs as the corresponding e-mail get deleted). The issue is that there is a table on the email messages form that references the error logs form, and when you view a message, it refreshes the table. Since the error logs form doesn't have an index on it, it does a table scan in the database every time. To fix it, do at least the following: Add an index on the field 'Email ID' on the AR System Email Error Logs forms. That will significantly speed up viewing e-mails regardless of how many records are in the error logs form. Next, you can add a filter to AR System Email Messages that runs on Delete and performs a Run Process action with the following text: Application-Query-Delete-Entry "AR System Email Error Logs" '18023' = "$Email ID$" This will remove errors from the error log as e-mails get deleted from the email messages form. That will keep your error logs from continuously growing out of control (assuming that you don't keep all e-mails in your email messages form). Lastly, I would clean out all the current entries in the error logs form, unless you need them for some reason. If you really want to be clever, you can only clean out entries that don't still have a corresponding e-mail in the e-mail messages form, but you'd probably have to either write program or write some workflow to determine if a given error entry has a corresponding e-mail. You don't need to worry about deleting large amounts of data in the user tool. I've routinely deleted 5-20K records at a time in the User tools without causing any issues for other users on the system. It does take a long time, though. Doing all three of those things will keep viewing e-mails fast and keep your error logs cleaned up with only relevant data (it's no longer relevant if the corresponding e-mail is no longer there). Good luck, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 6:21 AM To: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 mailto:john.kel...@dunkinbr
Re: AR System Email Messages Form
** Lyle said everything I was about to suggest. It would also be nice if BMC wouldn't refresh tables on tabs unless that tab is showing (on display of a record). They do it all over the place. It slows down display of the form, and almost always, the table doesn't need to be refreshed until the user selects the tab. It bugs me almost as much as using a TR value. So, depending on how much of an issue it is for you, you could modify the email messages form to not automatically refresh the tables, and then add an active link on tab select that refreshes the table. Thad Esser Remedy Developer "Now... Just where did I put that cheese...?" From: Lyle Taylor To: arslist@ARSLIST.ORG Date: 10/22/2009 10:17 AM Subject: Re: AR System Email Messages Form Sent by: "Action Request System discussion list(ARSList)" ** We had the exact same issue. The problem isn’t the number of errors associated with any given message, it’s the number of total errors in the error log form combined with the fact that 1) BMC didn’t add any indexes to the form (that’s an issue in several places), and 2) the form does not get cleaned up as e-mails get deleted (that is, BMC didn’t include workflow to delete error logs as the corresponding e-mail get deleted). The issue is that there is a table on the email messages form that references the error logs form, and when you view a message, it refreshes the table. Since the error logs form doesn’t have an index on it, it does a table scan in the database every time. To fix it, do at least the following: Add an index on the field ‘Email ID’ on the AR System Email Error Logs forms. That will significantly speed up viewing e-mails regardless of how many records are in the error logs form. Next, you can add a filter to AR System Email Messages that runs on Delete and performs a Run Process action with the following text: Application-Query-Delete-Entry "AR System Email Error Logs" '18023' = "$Email ID$" This will remove errors from the error log as e-mails get deleted from the email messages form. That will keep your error logs from continuously growing out of control (assuming that you don’t keep all e-mails in your email messages form). Lastly, I would clean out all the current entries in the error logs form, unless you need them for some reason. If you really want to be clever, you can only clean out entries that don’t still have a corresponding e-mail in the e-mail messages form, but you’d probably have to either write program or write some workflow to determine if a given error entry has a corresponding e-mail. You don’t need to worry about deleting large amounts of data in the user tool. I’ve routinely deleted 5-20K records at a time in the User tools without causing any issues for other users on the system. It does take a long time, though. Doing all three of those things will keep viewing e-mails fast and keep your error logs cleaned up with only relevant data (it’s no longer relevant if the corresponding e-mail is no longer there). Good luck, Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 6:21 AM To: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 <john.kel...@dunkinbrands.com> 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 i
RESOLVED -Re: AR System Email Messages Form
Thanks Lyle Setting an Index on the 'Email ID' field on the Email Error Logs form was the solution. I do the same thing every month deleting 20k-30k items from the messages form. I should probably setup an archive. I wonder if ARS 7.5 has the fix for when you delete the message it deletes its associated error log entry. Thanks again all, for the suggestions. JK Lyle Taylor Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 01:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** We had the exact same issue. The problem isn?t the number of errors associated with any given message, it?s the number of total errors in the error log form combined with the fact that 1) BMC didn?t add any indexes to the form (that?s an issue in several places), and 2) the form does not get cleaned up as e-mails get deleted (that is, BMC didn?t include workflow to delete error logs as the corresponding e-mail get deleted). The issue is that there is a table on the email messages form that references the error logs form, and when you view a message, it refreshes the table. Since the error logs form doesn?t have an index on it, it does a table scan in the database every time. To fix it, do at least the following: Add an index on the field ?Email ID? on the AR System Email Error Logs forms. That will significantly speed up viewing e-mails regardless of how many records are in the error logs form. Next, you can add a filter to AR System Email Messages that runs on Delete and performs a Run Process action with the following text: Application-Query-Delete-Entry "AR System Email Error Logs" '18023' = "$Email ID$" This will remove errors from the error log as e-mails get deleted from the email messages form. That will keep your error logs from continuously growing out of control (assuming that you don?t keep all e-mails in your email messages form). Lastly, I would clean out all the current entries in the error logs form, unless you need them for some reason. If you really want to be clever, you can only clean out entries that don?t still have a corresponding e-mail in the e-mail messages form, but you?d probably have to either write program or write some workflow to determine if a given error entry has a corresponding e-mail. You don?t need to worry about deleting large amounts of data in the user tool. I?ve routinely deleted 5-20K records at a time in the User tools without causing any issues for other users on the system. It does take a long time, though. Doing all three of those things will keep viewing e-mails fast and keep your error logs cleaned up with only relevant data (it?s no longer relevant if the corresponding e-mail is no longer there). Good luck, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 6:21 AM To: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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
Re: AR System Email Messages Form
We had the exact same issue. The problem isn't the number of errors associated with any given message, it's the number of total errors in the error log form combined with the fact that 1) BMC didn't add any indexes to the form (that's an issue in several places), and 2) the form does not get cleaned up as e-mails get deleted (that is, BMC didn't include workflow to delete error logs as the corresponding e-mail get deleted). The issue is that there is a table on the email messages form that references the error logs form, and when you view a message, it refreshes the table. Since the error logs form doesn't have an index on it, it does a table scan in the database every time. To fix it, do at least the following: Add an index on the field 'Email ID' on the AR System Email Error Logs forms. That will significantly speed up viewing e-mails regardless of how many records are in the error logs form. Next, you can add a filter to AR System Email Messages that runs on Delete and performs a Run Process action with the following text: Application-Query-Delete-Entry "AR System Email Error Logs" '18023' = "$Email ID$" This will remove errors from the error log as e-mails get deleted from the email messages form. That will keep your error logs from continuously growing out of control (assuming that you don't keep all e-mails in your email messages form). Lastly, I would clean out all the current entries in the error logs form, unless you need them for some reason. If you really want to be clever, you can only clean out entries that don't still have a corresponding e-mail in the e-mail messages form, but you'd probably have to either write program or write some workflow to determine if a given error entry has a corresponding e-mail. You don't need to worry about deleting large amounts of data in the user tool. I've routinely deleted 5-20K records at a time in the User tools without causing any issues for other users on the system. It does take a long time, though. Doing all three of those things will keep viewing e-mails fast and keep your error logs cleaned up with only relevant data (it's no longer relevant if the corresponding e-mail is no longer there). Good luck, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 6:21 AM To: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 mailto:john.kel...@dunkinbrands.com>> 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: rmisoluti...@verizon.net 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
Re: Re : AR System Email Messages Form
There shouldn't be an extended lock on the table, yes it will take awhile, but the way the Remedy client works is it issues a delete for each record, so any statements working on those tables will be able to work within the gaps between delete statements. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frex Popo Sent: Thursday, October 22, 2009 10:46 AM To: arslist@ARSLIST.ORG Subject: Re : Re : AR System Email Messages Form ** If you decide to delete some or all the data from the client, you will have to think about locking issues, as it takes time to delete large amounts of data from the client, especially on a production system ...other users will be blocked, since a delete operation - me think - will require an exclusive lock on the table.. So you will perhaps need to do this at the database level ... this is not straight foward ... you will need to look for the T, B, H tables (in the arschema) and any other attachment field tables for the error log form before runing any truncate or delete etc.. _ De : Frex Popo À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 18 h 33 min 48 s Objet : Re : AR System Email Messages Form I had the same problem, but with an asset management form with a couple of tables ... I enabled the SQL logging for the client, did a refresh, and then copied the select statements from the log file to a SQL editor and ran the queries ... found two of the the select statements taking too long before coming back with data added chunking to the field table and also an index to one of the classes and it resolved my issue Add the followings before your selects if you don't want to execute your query and want to see how long it will take and if any indexes are being used etc ... set noexec on set showplan on set statistics time on _ De : John Kelley À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 14 h 20 min 35 s Objet : 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What Ive 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < <mailto:john.kel...@dunkinbrands.com> john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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 s
Re : Re : AR System Email Messages Form
If you decide to delete some or all the data from the client, you will have to think about locking issues, as it takes time to delete large amounts of data from the client, especially on a production system ...other users will be blocked, since a delete operation - me think - will require an exclusive lock on the table.. So you will perhaps need to do this at the database level ... this is not straight foward ... you will need to look for the T, B, H tables (in the arschema) and any other attachment field tables for the error log form before runing any truncate or delete etc.. De : Frex Popo À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 18 h 33 min 48 s Objet : Re : AR System Email Messages Form I had the same problem, but with an asset management form with a couple of tables ... I enabled the SQL logging for the client, did a refresh, and then copied the select statements from the log file to a SQL editor and ran the queries ... found two of the the select statements taking too long before coming back with data added chunking to the field table and also an index to one of the classes and it resolved my issue Add the followings before your selects if you don't want to execute your query and want to see how long it will take and if any indexes are being used etc ... set noexec on set showplan on set statistics time on De : John Kelley À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 14 h 20 min 35 s Objet : 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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 erro
Re : AR System Email Messages Form
I had the same problem, but with an asset management form with a couple of tables ... I enabled the SQL logging for the client, did a refresh, and then copied the select statements from the log file to a SQL editor and ran the queries ... found two of the the select statements taking too long before coming back with data added chunking to the field table and also an index to one of the classes and it resolved my issue Add the followings before your selects if you don't want to execute your query and want to see how long it will take and if any indexes are being used etc ... set noexec on set showplan on set statistics time on De : John Kelley À : arslist@ARSLIST.ORG Envoyé le : Jeu 22 Octobre 2009, 14 h 20 min 35 s Objet : 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: AR System Email Messages Form
Hi Axton Where do make the truncate setting? I do notice in the form Properties of Email messages form the following fields are Indexed, is there supposed to be that many fields being indexed? Mailbox ID Message Type Priority Send Message Parse Message Execute/Send At Thanks Axton Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 10:32 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** Truncate the db tables that store the email error logs. Axton Grams On Thu, Oct 22, 2009 at 9:22 AM, John Kelley 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" Sent by: "Action Request System discussion list(ARSList)" < arslist@ARSLIST.ORG> 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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 s
Re: AR System Email Messages Form
Truncate the db tables that store the email error logs. Axton Grams On Thu, Oct 22, 2009 at 9:22 AM, John Kelley 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" * > Sent by: "Action Request System discussion list(ARSList)" < > arslist@ARSLIST.ORG> > > 10/22/2009 10:07 AM > Please respond to > arslist@ARSLIST.ORG > > To > arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG > 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" > Sent by: "Action Request System discussion list(ARSList)" > > 10/22/2009 06:18 AM > Please respond to > arslist@ARSLIST.ORG > > > To > arslist@ARSLIST.ORG > 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:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Thursday, October 22, 2009 1:15 AM > To: arslist@ARSLIST.ORG > 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 < > john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > * > Thi
Re: AR System Email Messages Form
Turn on DB logging before you open the form, open the form. Analyze the log and find out what query is taking so long, then find what on the form is causing the query. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, October 22, 2009 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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. Pleas
Re: AR System Email Messages Form
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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Ar
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: arslist@ARSLIST.ORG 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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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:rmisoluti...@verizon.net 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
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" Sent by: "Action Request System discussion list(ARSList)" 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 < john.kel...@dunkinbrands.com> 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG 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 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: rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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 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. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
AR System Email Messages Form
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.