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"
Group ID in To field of AR System Email Messages
Gupta This was discussed only a couple days ago: http://www.javasystemsolutions.com/arslist/view/89039297 John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Group ID in To field of AR System Email Messages
Dear all, When I put Group ID in To field of AR System Email Messagess form, it send out notifications to all the user in the group. I would like to know how ARS transaltes this as there are no filters AR System Email Messagess form to perform this. Is this achived via some API calls? Thanks, Bhupesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: AR System Email Messages - Error Behaviour?
That actually wasn't the case. I had tried restarting the email engine. I had to remove all errored messages after the messages that were to send. Then they went. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Wednesday, December 15, 2010 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages - Error Behaviour? Yes, an escalation was needed to fulfill this task, or just a restart of the email engine was enough. Thank you! Koray On Nov 6, 12:24 am, Andrew Fremont wrote: > We sometimes need to re-start the email engine to have those emails going. > > > > On Fri, Nov 5, 2010 at 12:26 PM, Ramey, Anne wrote: > > I've had some email errors today, and when I click send in the error-ed > > message, the "Send Message" gets changed back to Yes, but the message never > > appears to retry. I've run a report on those messages and the new once that > > are going out--but they appear the same (I though maybe a hidden field/flag > > wasn't getting set). Any idea why they aren't going or how I can get them > > to send? > > > ARS 7.1 p 11 > > ITSM 7.0.3 p 9 > > Oracle 10g > > Linux RHEL4 > > > Anne Ramey > > *** > > E-mail correspondence to and from this address may be subject to the North > > Carolina Public Records Law and may be disclosed to third parties only by an > > authorized State Official. > > > -Original Message- > > From: Action Request System discussion list(ARSList) [mailto: > > arsl...@arslist.org] On Behalf Of Guillaume Rheault > > Sent: Thursday, November 04, 2010 10:36 AM > > To: arsl...@arslist.org > > Subject: Possibly spam: Re: AR System Email Messages - Error Behaviour? > > > I think this is the first time that somebody has asked this question. > > It does not retry by default. I think you would need to create some custom > > functionality to accomplish like, such as an escalation that queries the > > emails not sent because of an error and reset the flag to send it again. > > > Guillaume > > > ____________ > > From: Action Request System discussion list(ARSList) [arsl...@arslist.org] > > on behalf of koray [ko...@alkankoray.net] > > Sent: Thursday, November 04, 2010 7:40 AM > > To: arsl...@arslist.org > > Subject: AR System Email Messages - Error Behaviour? > > > Hello together, > > > I have one simple question: If an outgoing e-mail message is set to > > Error on ARS Email Messages form, does the system try re-sending it > > with any intervals? > > > Thanks in advance, > > Koray > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > If this message is a valid email, you can request that future messages from > > this source be processed normally through the email system by visiting > >http://www.ncmail.net/whitelist_procedures.htm > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: AR System Email Messages - Error Behaviour?
Yes, an escalation was needed to fulfill this task, or just a restart of the email engine was enough. Thank you! Koray On Nov 6, 12:24 am, Andrew Fremont wrote: > We sometimes need to re-start the email engine to have those emails going. > > > > On Fri, Nov 5, 2010 at 12:26 PM, Ramey, Anne wrote: > > I've had some email errors today, and when I click send in the error-ed > > message, the "Send Message" gets changed back to Yes, but the message never > > appears to retry. I've run a report on those messages and the new once that > > are going out--but they appear the same (I though maybe a hidden field/flag > > wasn't getting set). Any idea why they aren't going or how I can get them > > to send? > > > ARS 7.1 p 11 > > ITSM 7.0.3 p 9 > > Oracle 10g > > Linux RHEL4 > > > Anne Ramey > > *** > > E-mail correspondence to and from this address may be subject to the North > > Carolina Public Records Law and may be disclosed to third parties only by an > > authorized State Official. > > > -Original Message- > > From: Action Request System discussion list(ARSList) [mailto: > > arsl...@arslist.org] On Behalf Of Guillaume Rheault > > Sent: Thursday, November 04, 2010 10:36 AM > > To: arsl...@arslist.org > > Subject: Possibly spam: Re: AR System Email Messages - Error Behaviour? > > > I think this is the first time that somebody has asked this question. > > It does not retry by default. I think you would need to create some custom > > functionality to accomplish like, such as an escalation that queries the > > emails not sent because of an error and reset the flag to send it again. > > > Guillaume > > > ________ > > From: Action Request System discussion list(ARSList) [arsl...@arslist.org] > > on behalf of koray [ko...@alkankoray.net] > > Sent: Thursday, November 04, 2010 7:40 AM > > To: arsl...@arslist.org > > Subject: AR System Email Messages - Error Behaviour? > > > Hello together, > > > I have one simple question: If an outgoing e-mail message is set to > > Error on ARS Email Messages form, does the system try re-sending it > > with any intervals? > > > Thanks in advance, > > Koray > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > If this message is a valid email, you can request that future messages from > > this source be processed normally through the email system by visiting > >http://www.ncmail.net/whitelist_procedures.htm > > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: AR System Email Messages - Error Behaviour?
We sometimes need to re-start the email engine to have those emails going. On Fri, Nov 5, 2010 at 12:26 PM, Ramey, Anne wrote: > I've had some email errors today, and when I click send in the error-ed > message, the "Send Message" gets changed back to Yes, but the message never > appears to retry. I've run a report on those messages and the new once that > are going out--but they appear the same (I though maybe a hidden field/flag > wasn't getting set). Any idea why they aren't going or how I can get them > to send? > > ARS 7.1 p 11 > ITSM 7.0.3 p 9 > Oracle 10g > Linux RHEL4 > > Anne Ramey > *** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by an > authorized State Official. > > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Guillaume Rheault > Sent: Thursday, November 04, 2010 10:36 AM > To: arslist@ARSLIST.ORG > Subject: Possibly spam: Re: AR System Email Messages - Error Behaviour? > > I think this is the first time that somebody has asked this question. > It does not retry by default. I think you would need to create some custom > functionality to accomplish like, such as an escalation that queries the > emails not sent because of an error and reset the flag to send it again. > > Guillaume > > > From: Action Request System discussion list(ARSList) [arsl...@arslist.org] > on behalf of koray [ko...@alkankoray.net] > Sent: Thursday, November 04, 2010 7:40 AM > To: arslist@ARSLIST.ORG > Subject: AR System Email Messages - Error Behaviour? > > Hello together, > > I have one simple question: If an outgoing e-mail message is set to > Error on ARS Email Messages form, does the system try re-sending it > with any intervals? > > Thanks in advance, > Koray > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > If this message is a valid email, you can request that future messages from > this source be processed normally through the email system by visiting > http://www.ncmail.net/whitelist_procedures.htm > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: AR System Email Messages - Error Behaviour?
I've had some email errors today, and when I click send in the error-ed message, the "Send Message" gets changed back to Yes, but the message never appears to retry. I've run a report on those messages and the new once that are going out--but they appear the same (I though maybe a hidden field/flag wasn't getting set). Any idea why they aren't going or how I can get them to send? ARS 7.1 p 11 ITSM 7.0.3 p 9 Oracle 10g Linux RHEL4 Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Thursday, November 04, 2010 10:36 AM To: arslist@ARSLIST.ORG Subject: Possibly spam: Re: AR System Email Messages - Error Behaviour? I think this is the first time that somebody has asked this question. It does not retry by default. I think you would need to create some custom functionality to accomplish like, such as an escalation that queries the emails not sent because of an error and reset the flag to send it again. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of koray [ko...@alkankoray.net] Sent: Thursday, November 04, 2010 7:40 AM To: arslist@ARSLIST.ORG Subject: AR System Email Messages - Error Behaviour? Hello together, I have one simple question: If an outgoing e-mail message is set to Error on ARS Email Messages form, does the system try re-sending it with any intervals? Thanks in advance, Koray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" If this message is a valid email, you can request that future messages from this source be processed normally through the email system by visiting http://www.ncmail.net/whitelist_procedures.htm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: AR System Email Messages - Error Behaviour?
I think this is the first time that somebody has asked this question. It does not retry by default. I think you would need to create some custom functionality to accomplish like, such as an escalation that queries the emails not sent because of an error and reset the flag to send it again. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of koray [ko...@alkankoray.net] Sent: Thursday, November 04, 2010 7:40 AM To: arslist@ARSLIST.ORG Subject: AR System Email Messages - Error Behaviour? Hello together, I have one simple question: If an outgoing e-mail message is set to Error on ARS Email Messages form, does the system try re-sending it with any intervals? Thanks in advance, Koray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
AR System Email Messages - Error Behaviour?
Hello together, I have one simple question: If an outgoing e-mail message is set to Error on ARS Email Messages form, does the system try re-sending it with any intervals? Thanks in advance, Koray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Email messages in the AR System Email Messages are not sent
Not having an index on Unique Identifier should not be a problem (It's the Mailbox... index that is most used by the engine) None of my indexes have the Unique flag checked Turn on your SQL logs on the server for a few minutes and see how long the Remedy Application Service user takes to pull your email form -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, May 25, 2010 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent Fred, I don't have unique identifier checked. Is that bad? Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, May 25, 2010 9:49 AM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent How many of the 87k have not been sent? You may also want to open the AR System Email Messages form in the admin tool and make sure you still have the indexes. On my system the 3 indexes are: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID, Execute/Send At Unique Identifier Send Message Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, May 25, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent ** Ravi, Can you manually send an email from Remedy? Open the AR System Email Messages form in New mode and send an email to yourself. If you receive the email message, then your configuration is correct, otherwise you need to revise HTH, Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramagiri Sent: Tuesday, May 25, 2010 2:14 AM To: arslist@ARSLIST.ORG Subject: Email messages in the AR System Email Messages are not sent ** Hi All, We are using AR System 7.1. The problem is ... " Email messages in the "AR System Email Messages "form are not sent when new incident is raised, assigned or change the status". Is this due to high AR System email Messages. Please suggest why this problem occurs. Right now the email messages count is show below. If Yes ,is there any limit for this message count. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Email messages in the AR System Email Messages are not sent
Fred, I don't have unique identifier checked. Is that bad? Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, May 25, 2010 9:49 AM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent How many of the 87k have not been sent? You may also want to open the AR System Email Messages form in the admin tool and make sure you still have the indexes. On my system the 3 indexes are: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID, Execute/Send At Unique Identifier Send Message Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, May 25, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent ** Ravi, Can you manually send an email from Remedy? Open the AR System Email Messages form in New mode and send an email to yourself. If you receive the email message, then your configuration is correct, otherwise you need to revise HTH, Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramagiri Sent: Tuesday, May 25, 2010 2:14 AM To: arslist@ARSLIST.ORG Subject: Email messages in the AR System Email Messages are not sent ** Hi All, We are using AR System 7.1. The problem is ... " Email messages in the "AR System Email Messages "form are not sent when new incident is raised, assigned or change the status". Is this due to high AR System email Messages. Please suggest why this problem occurs. Right now the email messages count is show below. If Yes ,is there any limit for this message count. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Email messages in the AR System Email Messages are not sent
How many of the 87k have not been sent? You may also want to open the AR System Email Messages form in the admin tool and make sure you still have the indexes. On my system the 3 indexes are: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID, Execute/Send At Unique Identifier Send Message Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, May 25, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: Re: Email messages in the AR System Email Messages are not sent ** Ravi, Can you manually send an email from Remedy? Open the AR System Email Messages form in New mode and send an email to yourself. If you receive the email message, then your configuration is correct, otherwise you need to revise HTH, Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramagiri Sent: Tuesday, May 25, 2010 2:14 AM To: arslist@ARSLIST.ORG Subject: Email messages in the AR System Email Messages are not sent ** Hi All, We are using AR System 7.1. The problem is ... " Email messages in the "AR System Email Messages "form are not sent when new incident is raised, assigned or change the status". Is this due to high AR System email Messages. Please suggest why this problem occurs. Right now the email messages count is show below. If Yes ,is there any limit for this message count. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Email messages in the AR System Email Messages are not sent
Ravi, Can you manually send an email from Remedy? Open the AR System Email Messages form in New mode and send an email to yourself. If you receive the email message, then your configuration is correct, otherwise you need to revise HTH, Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramagiri Sent: Tuesday, May 25, 2010 2:14 AM To: arslist@ARSLIST.ORG Subject: Email messages in the AR System Email Messages are not sent ** Hi All, We are using AR System 7.1. The problem is ... " Email messages in the "AR System Email Messages "form are not sent when new incident is raised, assigned or change the status". Is this due to high AR System email Massages. Please suggest why this problem occurs. Right now the email messages count is show below. If Yes ,is there any limit for this message count. [cid:image001.png@01CAFBE8.C4D1AAE0] RAVI CHANDRA . RAMAGIRI Infrastructure Management Services Team System Administrator - Windows / Remedy * ravi.ramag...@gssamerica.com<mailto:rambabu.ru...@gssamerica.com> Please do not print this email unless it is absolutely necessary. Spread environmental awareness. Disclaimer This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. __ Information from ESET NOD32 Antivirus, version of virus signature database 5142 (20100524) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" <>
Re: {Remedy ARS} Email messages in the AR System Email Messages are not sent
There is no default but in the years we have been processing incoming and
outgoing mail, we have seen that anything over 10K in stored messages begins to
cause a problem.
Set the outgoing mail to be deleted after its sent and then set an escalation
to delete the incoming mail after a day or so, or however many days it takes to
only have 10K or so emails in the message form.
Also, be sure you index properly.
The email engine has to continually search for mail to send out, then send it
all in just a few seconds. If it takes more than the few seconds to do the
search, it will never get to actually send.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of patchsk
Sent: Tuesday, May 25, 2010 5:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: {Remedy ARS} Email messages in the AR System Email Messages are
not sent
There is no out of the box limit on the number of entries in the email
messages form.
I guess with a default installation email engine processes 100 entries
per min.
Check your process list and see if email process/daemon is still
running or crashed.
On May 25, 12:13 am, Ramagiri wrote:
> Hi All,
>
> We are using AR System 7.1. The problem is ...
>
> " Email messages in the "AR System Email Messages "form are not sent
> when new incident is raised, assigned or change the status".
>
> Is this due to high AR System email Massages.
>
> Please suggest why this problem occurs. Right now the email messages
> count is show below. If Yes ,is there any limit for this message count.
>
>
>
> RAVI CHANDRA . RAMAGIRI
> Infrastructure Management Services Team
>
> System Administrator - Windows / Remedy
> * <mailto:rambabu.ru...@gssamerica.com> ravi.ramag...@gssamerica.com
>
> Please do not print this email unless it is absolutely necessary. Spread
> environmental awareness.
>
> Disclaimer
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and delete
> this e-mail from your system. E-mail transmission cannot be guaranteed to be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message, which arise as a result of e-mail transmission. If
> verification is required please request a hard-copy version.
>
> ___
>
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> --
> You received this message because you are subscribed to the Google Groups
> "Remedy ARS" group.
> To post to this group, send email to arsl...@googlegroups.com.
> To unsubscribe from this group, send email to
> arslist+unsubscr...@googlegroups.com.
> For more options, visit this group
> athttp://groups.google.com/group/arslist?hl=en.
>
> image001.png
> 1KViewDownload
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: {Remedy ARS} Email messages in the AR System Email Messages are not sent
There is no out of the box limit on the number of entries in the email messages form. I guess with a default installation email engine processes 100 entries per min. Check your process list and see if email process/daemon is still running or crashed. On May 25, 12:13 am, Ramagiri wrote: > Hi All, > > We are using AR System 7.1. The problem is ... > > " Email messages in the "AR System Email Messages "form are not sent > when new incident is raised, assigned or change the status". > > Is this due to high AR System email Massages. > > Please suggest why this problem occurs. Right now the email messages > count is show below. If Yes ,is there any limit for this message count. > > > > RAVI CHANDRA . RAMAGIRI > Infrastructure Management Services Team > > System Administrator - Windows / Remedy > * <mailto:rambabu.ru...@gssamerica.com> ravi.ramag...@gssamerica.com > > Please do not print this email unless it is absolutely necessary. Spread > environmental awareness. > > Disclaimer > This message contains confidential information and is intended only for the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. E-mail transmission cannot be guaranteed to be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. The sender > therefore does not accept liability for any errors or omissions in the > contents of this message, which arise as a result of e-mail transmission. If > verification is required please request a hard-copy version. > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > -- > You received this message because you are subscribed to the Google Groups > "Remedy ARS" group. > To post to this group, send email to arsl...@googlegroups.com. > To unsubscribe from this group, send email to > arslist+unsubscr...@googlegroups.com. > For more options, visit this group > athttp://groups.google.com/group/arslist?hl=en. > > image001.png > 1KViewDownload ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Email messages in the AR System Email Messages are not sent
Hi, I would suggest to look in the Log folder of the AREmail folder to find out, if the notifications are fired or there is a configuration error ! Cheers Tristan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Email messages in the AR System Email Messages are not sent
Hi All, We are using AR System 7.1. The problem is ... " Email messages in the "AR System Email Messages "form are not sent when new incident is raised, assigned or change the status". Is this due to high AR System email Massages. Please suggest why this problem occurs. Right now the email messages count is show below. If Yes ,is there any limit for this message count. RAVI CHANDRA . RAMAGIRI Infrastructure Management Services Team System Administrator - Windows / Remedy * <mailto:rambabu.ru...@gssamerica.com> ravi.ramag...@gssamerica.com Please do not print this email unless it is absolutely necessary. Spread environmental awareness. Disclaimer This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" <>
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.
AR System Email Messages Error in Event Viewer.
Hello Listers, Has anyone ever seen this error before in the Windows Server 2003 Application Event Viewer Log: Source: AR System Email Engine Category: None Type: Error Event ID: 4097 Description: The RegQueryValueEx function failed for the following reason: The system cannot find the file specified. AR System Server: v6.4 patch 20 DB: Oracle 9i We have had issues due to RAM leaks where the Email service has hung every couple of days and needed to be kicked but a RAM upgrade has basically solved that problem. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
James and Mike, thanks for the quick responses. When our developer said he "set up archiving" I thought he meant he was archiving data to an archive form. When I looked at the form I saw that he had set the Archive type to "Delete from Source", so we won't have an archive form after all... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Friday, July 11, 2008 12:35 PM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages? ** Just to share the other side We started archiving 09/2006 while on ARS 6.0.1, patch 1497. We're now running 7.0.1, patch 7 (on Solaris 5.10, Oracle 10g). We archive all Sent messages, using Archive Type "Copy to Archive and Delete from Source", daily @ 0700. We've never had a problem with it. Several years ago, we tried to archive user logins as we removed them and ran into a reserved field id issue that sounds similar to what James described. We just haven't seen it on our email form. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] James Van Sickle <[EMAIL PROTECTED]> James Van Sickle <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 07/11/2008 13:28 Please respond to arslist To: arslist@ARSLIST.ORG cc: Subject: Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages? Laura I tried to setup an Archive form for the Email Messages form a while ago, and ran into the unusual activity that Susan was referring to. Here is what I wrote to the list a few months ago about it: According to Remedy Support, creating an Archive Form for the AR System Email Messages form causes a duplication of the reserved fields used by the email engine to send email. Apparently the email engine was not setup to distinguish Field IDs such as 18085 between two separate forms. When I created an Archive form off the Email Messages form, the Email Engine decided that my Archived Email Messages form was the new form to process incoming and outgoing email on. This became somewhat amusing as Incoming email went directly to my Archive Form, and Outgoing email just sat in my original Email Messages form waiting to get processed. Removing the Archive form and restarting the Email Engine fixes the problem. (Embedded image moved to file: pic23851.gif)Countrywide James Van Sickle Remedy Developer II Enterprise Service Management 972-696-5779 Office 1000 Coit Road 92-540-5779Mail Stop: PCRD-2-19 Internal Plano, TX 75075 "Nichols, Laura (Laura)" <[EMAIL PROTECTED]> To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)" Subject <[EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to ORG> Archive and Delete from Source - AR System Email Messages? 07/11/2008 12:06 PM Please respond to [EMAIL PROTECTED] RG ** Susan, Can you elaborate on your statement, "I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it."? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I wa
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Just to share the other side
We started archiving 09/2006 while on ARS 6.0.1, patch 1497. We're now
running 7.0.1, patch 7 (on Solaris 5.10, Oracle 10g). We archive all Sent
messages, using Archive Type "Copy to Archive and Delete from Source",
daily @ 0700. We've never had a problem with it.
Several years ago, we tried to archive user logins as we removed them and
ran into a reserved field id issue that sounds similar to what James
described. We just haven't seen it on our email form.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
James Van Sickle
<[EMAIL PROTECTED]To: arslist@ARSLIST.ORG
RYWIDE.COM>cc:
Sent by: "Action Subject: Re: BMC Remedy -
Copy to Archive and Delete from Source - AR System
Request System Email Messages?
discussion
list(ARSList)"
07/11/2008 13:28
Please respond to
arslist
Laura
I tried to setup an Archive form for the Email Messages form a while ago,
and ran into the unusual activity that Susan was referring to. Here is
what I wrote to the list a few months ago about it:
According to Remedy Support, creating an Archive Form for the AR System
Email Messages form causes a duplication of the reserved fields used by the
email engine to send email. Apparently the email engine was not setup to
distinguish Field IDs such as 18085 between two separate forms. When I
created an Archive form off the Email Messages form, the Email Engine
decided that my Archived Email Messages form was the new form to process
incoming and outgoing email on. This became somewhat amusing as Incoming
email went directly to my Archive Form, and Outgoing email just sat in my
original Email Messages form waiting to get processed.
Removing the Archive form and restarting the Email Engine fixes the
problem.
(Embedded image moved to file: pic23851.gif)Countrywide
James Van Sickle
Remedy Developer II
Enterprise Service Management
972-696-5779 Office 1000 Coit Road
92-540-5779Mail Stop: PCRD-2-19
Internal Plano, TX 75075
"Nichols, Laura
(Laura)"
<[EMAIL PROTECTED]> To
Sent by: "Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)"Subject
<[EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to
ORG> Archive and Delete from Source - AR
System Email Messages?
07/11/2008 12:06
PM
Please respond to
[EMAIL PROTECTED]
RG
**
Susan,
Can you elaborate on your statement, "I was also notified yesterday that it
is not recommended to archive system email messages, there is some unusal
result related to it."? Do you remember where you got this information?
Are you still archiving your email messages?
Anyone else heard or read anything on this??
Thanks,
Laura
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, March 26, 2008 10:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Remedy - Copy to Archive and Delete from Source
**
Mel,
I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level. You have to remember
that all workflow is affected by the number of records in the form and keep
in mind any table fields that are refreshed.
We generally keep 13 months of or closed records.
Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option. In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option. That needs to be planned for and it was greater than 1
for 1 which is logical since ano
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Laura
I tried to setup an Archive form for the Email Messages form a while ago,
and ran into the unusual activity that Susan was referring to. Here is
what I wrote to the list a few months ago about it:
According to Remedy Support, creating an Archive Form for the AR System
Email Messages form causes a duplication of the reserved fields used by the
email engine to send email. Apparently the email engine was not setup to
distinguish Field IDs such as 18085 between two separate forms. When I
created an Archive form off the Email Messages form, the Email Engine
decided that my Archived Email Messages form was the new form to process
incoming and outgoing email on. This became somewhat amusing as Incoming
email went directly to my Archive Form, and Outgoing email just sat in my
original Email Messages form waiting to get processed.
Removing the Archive form and restarting the Email Engine fixes the
problem.
(Embedded image moved to file: pic23851.gif)Countrywide
James Van Sickle
Remedy Developer II
Enterprise Service Management
972-696-5779 Office 1000 Coit Road
92-540-5779Mail Stop: PCRD-2-19
Internal Plano, TX 75075
"Nichols, Laura
(Laura)"
<[EMAIL PROTECTED]> To
Sent by: "Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)"Subject
<[EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to
ORG> Archive and Delete from Source - AR
System Email Messages?
07/11/2008 12:06
PM
Please respond to
[EMAIL PROTECTED]
RG
**
Susan,
Can you elaborate on your statement, "I was also notified yesterday that it
is not recommended to archive system email messages, there is some unusal
result related to it."? Do you remember where you got this information?
Are you still archiving your email messages?
Anyone else heard or read anything on this??
Thanks,
Laura
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Wednesday, March 26, 2008 10:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Remedy - Copy to Archive and Delete from Source
**
Mel,
I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level. You have to remember
that all workflow is affected by the number of records in the form and keep
in mind any table fields that are refreshed.
We generally keep 13 months of or closed records.
Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option. In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option. That needs to be planned for and it was greater than 1
for 1 which is logical since another table is now holding the same record.
For us it was quite a bit more than that infact we nearly brought the
server down.
I only archive in the lowest of production hours (night) when minimal users
are on the system.
I was also notified yesterday that it is not recommended to archive system
email messages, there is some unusal result related to it. Sorry did not
get more info.
I found the actual archiving to go fairly quick, was doing about 70k
records both times. I liked the fact I didn't have to manually delete the
records afterwards.
hth,
Susan
ShopperTrak
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
==
Confidentiality Notice:
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Susan, Can you elaborate on your statement, "I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it."? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly brought the server down. I only archive in the lowest of production hours (night) when minimal users are on the system. I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it. Sorry did not get more info. I found the actual archiving to go fairly quick, was doing about 70k records both times. I liked the fact I didn't have to manually delete the records afterwards. hth, Susan ShopperTrak ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Kevin, Using the SYS:Application Clean form might not be such a bad idea. Howard On 6/11/08, Kevin Shaffer <[EMAIL PROTECTED]> wrote: > > ** Another option might be to add a record to the SYS:Application Clean Up > form and a couple of filters. > > -- > Date: Wed, 11 Jun 2008 13:35:22 -0600 > From: [EMAIL PROTECTED] > Subject: Re: Workflow to delete records from AR System Email Messages > To: arslist@ARSLIST.ORG > > ** Ravi, > > And BMC support told me to do that for the mail messages form when I did my > go-live (with ITSM 7, patch 2) last year, since the number of messages this > system sends out is quite large. > > Maybe BMC needs to create a clean up program, if the OOB method (the > archiving funtion) is not to be used on that form. > > Howard > > > On 6/11/08, *Ravi* <[EMAIL PROTECTED]> wrote: > > I am being told by BMC support to not turn on archiving for system forms. > This form is one of them. > Sokol, Brian wrote: > > Can't you just turn on the archive for that form and set it to delete > all records older then 90 days? > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Ravi > Sent: Wednesday, June 11, 2008 7:20 AM > To: arslist@ARSLIST.ORG > Subject: Workflow to delete records from AR System Email Messages > > Hi: I am trying to build a escalation to delete records from AR System > Email Messages form that have a create date older than 90 days. What do > I include in Command Line field within the Run Process Action? The > following doesn't seem to be working. > > Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > > Also is there a recommended way to delete data from this form rather > than using escalation? > > Thanks > Ravi > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > -- > Howard Richter > Red Hat Certified Technician > CompTIA Linux+ Certified > ITIL Foundation Certified > E-Mail = [EMAIL PROTECTED] > Resume = http://www.richter-home.net/resume/ > LinkedIn Profile = http://www.linkedin.com/in/hbr4270 > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Another option might be to add a record to the SYS:Application Clean Up form and a couple of filters. Date: Wed, 11 Jun 2008 13:35:22 -0600From: [EMAIL PROTECTED]: Re: Workflow to delete records from AR System Email MessagesTo: [EMAIL PROTECTED] Ravi, And BMC support told me to do that for the mail messages form when I did my go-live (with ITSM 7, patch 2) last year, since the number of messages this system sends out is quite large. Maybe BMC needs to create a clean up program, if the OOB method (the archiving funtion) is not to be used on that form. Howard On 6/11/08, Ravi <[EMAIL PROTECTED]> wrote: I am being told by BMC support to not turn on archiving for system forms. This form is one of them. Sokol, Brian wrote: Can't you just turn on the archive for that form and set it to deleteall records older then 90 days? -Original Message-From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of RaviSent: Wednesday, June 11, 2008 7:20 AMTo: [EMAIL PROTECTED]: Workflow to delete records from AR System Email MessagesHi: I am trying to build a escalation to delete records from AR SystemEmail Messages form that have a create date older than 90 days. What doI include in Command Line field within the Run Process Action? Thefollowing doesn't seem to be working.Application-Delete-Entry "BMC:SSP:Issue" $Request ID$Also is there a recommended way to delete data from this form ratherthan using escalation?ThanksRavi___UNSUBSCRIBE or access ARSlist Archives at www.arslist.org PlatinumSponsor: www.rmsportal.com ARSlist: "Where the Answers Are"___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgPlatinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgPlatinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"-- Howard RichterRed Hat Certified TechnicianCompTIA Linux+ CertifiedITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/LinkedIn Profile = http://www.linkedin.com/in/hbr4270__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Ravi, And BMC support told me to do that for the mail messages form when I did my go-live (with ITSM 7, patch 2) last year, since the number of messages this system sends out is quite large. Maybe BMC needs to create a clean up program, if the OOB method (the archiving funtion) is not to be used on that form. Howard On 6/11/08, Ravi <[EMAIL PROTECTED]> wrote: > > I am being told by BMC support to not turn on archiving for system forms. > This form is one of them. > Sokol, Brian wrote: > >> Can't you just turn on the archive for that form and set it to delete >> all records older then 90 days? >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Ravi >> Sent: Wednesday, June 11, 2008 7:20 AM >> To: arslist@ARSLIST.ORG >> Subject: Workflow to delete records from AR System Email Messages >> >> Hi: I am trying to build a escalation to delete records from AR System >> Email Messages form that have a create date older than 90 days. What do >> I include in Command Line field within the Run Process Action? The >> following doesn't seem to be working. >> >> Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ >> >> Also is there a recommended way to delete data from this form rather >> than using escalation? >> >> Thanks >> Ravi >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum >> Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> >> > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] Resume = http://www.richter-home.net/resume/ LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
RES: Workflow to delete records from AR System Email Messages
Ravi, How many records has your AR System Email Messages Form?? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Sokol, Brian Enviada: qua 11/6/2008 12:10 Para: arslist@ARSLIST.ORG Assunto: Re: Workflow to delete records from AR System Email Messages That is how I have been doing it for over a year without a problem. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 10:32 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages I am being told by BMC support to not turn on archiving for system forms. This form is one of them. Sokol, Brian wrote: > Can't you just turn on the archive for that form and set it to delete > all records older then 90 days? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Ravi > Sent: Wednesday, June 11, 2008 7:20 AM > To: arslist@ARSLIST.ORG > Subject: Workflow to delete records from AR System Email Messages > > Hi: I am trying to build a escalation to delete records from AR System > Email Messages form that have a create date older than 90 days. What > do I include in Command Line field within the Run Process Action? The > following doesn't seem to be working. > > Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > > Also is there a recommended way to delete data from this form rather > than using escalation? > > Thanks > Ravi > > __ > __ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > __ > _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
That is how I have been doing it for over a year without a problem. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 10:32 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages I am being told by BMC support to not turn on archiving for system forms. This form is one of them. Sokol, Brian wrote: > Can't you just turn on the archive for that form and set it to delete > all records older then 90 days? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Ravi > Sent: Wednesday, June 11, 2008 7:20 AM > To: arslist@ARSLIST.ORG > Subject: Workflow to delete records from AR System Email Messages > > Hi: I am trying to build a escalation to delete records from AR System > Email Messages form that have a create date older than 90 days. What > do I include in Command Line field within the Run Process Action? The > following doesn't seem to be working. > > Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > > Also is there a recommended way to delete data from this form rather > than using escalation? > > Thanks > Ravi > > __ > __ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > __ > _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
I am being told by BMC support to not turn on archiving for system forms. This form is one of them. Sokol, Brian wrote: Can't you just turn on the archive for that form and set it to delete all records older then 90 days? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:20 AM To: arslist@ARSLIST.ORG Subject: Workflow to delete records from AR System Email Messages Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Can't you just turn on the archive for that form and set it to delete all records older then 90 days? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:20 AM To: arslist@ARSLIST.ORG Subject: Workflow to delete records from AR System Email Messages Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
[RESOLVED] Re: Workflow to delete records from AR System Email Messages
Thanks Lammey, Peter A. wrote: Basically as a general rule, if you want to setup a process to delete entries from a form as part of a filter I would use this command (no quotes around schema or the 1 actually in your syntax): Application-Delete-Entry "$SCEHMA$" "$1$" So basically on a certain change in that target form (say when the Status moves to a Delete status) you can use this command for any forms to indicate that you want to delete the entry for that form. The SCHEMA keyword will always be the form the filter fires for and Field 1 is a field that is always contains the system generated ticket number. Since forms released by ITSM or by AR System releases there may be cases where Field 1's database name can be different. If you always indicate Field 1 as I have shown above it will always work and you don't have to always specify the actual database name set for that form's entry ID in the syntax. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hardy, Patrick Sent: Wednesday, June 11, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages We have an escalation that does the same thing (def attached). Here is the command line: Application-Delete-Entry "AR System Email Messages" $Email ID$ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages But I donot see a field called Request ID in this form. Could that be the issue. There is a field called Unique Identifier. Should I be using that one? Remprof wrote: ** Hi Ravi, It is the field id for Request ID field, right??? :) Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi: Just so that I understand, what does the $1$ mean? Thanks Ravi Remprof wrote: ** Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you are not the intended addressee, then you have received this email in error and any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately of your unintended receipt by reply and then delete this email and your reply. Tyson Foods, Inc. and its subsidiaries and affiliates will not be held liable to any person resulting from the unintended or unauthorized use of any information contained in this email or as a result of any additions or deletio
Re: Workflow to delete records from AR System Email Messages
Basically as a general rule, if you want to setup a process to delete entries from a form as part of a filter I would use this command (no quotes around schema or the 1 actually in your syntax): Application-Delete-Entry "$SCEHMA$" "$1$" So basically on a certain change in that target form (say when the Status moves to a Delete status) you can use this command for any forms to indicate that you want to delete the entry for that form. The SCHEMA keyword will always be the form the filter fires for and Field 1 is a field that is always contains the system generated ticket number. Since forms released by ITSM or by AR System releases there may be cases where Field 1's database name can be different. If you always indicate Field 1 as I have shown above it will always work and you don't have to always specify the actual database name set for that form's entry ID in the syntax. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hardy, Patrick Sent: Wednesday, June 11, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages We have an escalation that does the same thing (def attached). Here is the command line: Application-Delete-Entry "AR System Email Messages" $Email ID$ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages But I donot see a field called Request ID in this form. Could that be the issue. There is a field called Unique Identifier. Should I be using that one? Remprof wrote: > ** > Hi Ravi, > > It is the field id for Request ID field, right??? :) > > Thanks, > RemProf > > On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > Hi: Just so that I understand, what does the $1$ mean? > > Thanks > Ravi > Remprof wrote: > > ** > Hi Ravi, > This should be working fine with giving the field id $1$, > instead of $Request ID$. > You do try that and see whether it works or not. > Thanks, > RemProf > On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > >Hi: I am trying to build a escalation to delete records from AR >System Email Messages form that have a create date older > than 90 >days. What do I include in Command Line field within the Run >Process Action? The following doesn't seem to be working. > >Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > >Also is there a recommended way to delete data from this form >rather than using escalation? > >Thanks >Ravi > > > ___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > <http://www.arslist.org/> ><http://www.arslist.org/> >Platinum Sponsor: www.rmsportal.com > <http://www.rmsportal.com/> <http://www.rmsportal.com/> >ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: www.rmsportal.com > <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" > html___ > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > <http://www.arslist.org/> > Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> > ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you are not the intended addressee, then you have received this email in error and any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately of your unintended receipt by reply and then delete this email and your reply. Tyson Foods, Inc. and
Re: Workflow to delete records from AR System Email Messages
We have an escalation that does the same thing (def attached). Here is the command line: Application-Delete-Entry "AR System Email Messages" $Email ID$ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages But I donot see a field called Request ID in this form. Could that be the issue. There is a field called Unique Identifier. Should I be using that one? Remprof wrote: > ** > Hi Ravi, > > It is the field id for Request ID field, right??? :) > > Thanks, > RemProf > > On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > Hi: Just so that I understand, what does the $1$ mean? > > Thanks > Ravi > Remprof wrote: > > ** > Hi Ravi, > This should be working fine with giving the field id $1$, > instead of $Request ID$. > You do try that and see whether it works or not. > Thanks, > RemProf > On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > >Hi: I am trying to build a escalation to delete records from AR >System Email Messages form that have a create date older > than 90 >days. What do I include in Command Line field within the Run >Process Action? The following doesn't seem to be working. > >Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > >Also is there a recommended way to delete data from this form >rather than using escalation? > >Thanks >Ravi > > > ___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > <http://www.arslist.org/> ><http://www.arslist.org/> >Platinum Sponsor: www.rmsportal.com > <http://www.rmsportal.com/> <http://www.rmsportal.com/> >ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: www.rmsportal.com > <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" > html___ > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > <http://www.arslist.org/> > Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> > ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you are not the intended addressee, then you have received this email in error and any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately of your unintended receipt by reply and then delete this email and your reply. Tyson Foods, Inc. and its subsidiaries and affiliates will not be held liable to any person resulting from the unintended or unauthorized use of any information contained in this email or as a result of any additions or deletions of information originally contained in this email. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" emailrecorddeletion.def Description: emailrecorddeletion.def
Re: Workflow to delete records from AR System Email Messages
But I donot see a field called Request ID in this form. Could that be the issue. There is a field called Unique Identifier. Should I be using that one? Remprof wrote: ** Hi Ravi, It is the field id for Request ID field, right??? :) Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi: Just so that I understand, what does the $1$ mean? Thanks Ravi Remprof wrote: ** Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Hi Ravi, It is the field id for Request ID field, right??? :) Thanks, RemProf On 6/11/08, Ravi <[EMAIL PROTECTED]> wrote: > > Hi: Just so that I understand, what does the $1$ mean? > > Thanks > Ravi > Remprof wrote: > >> ** >> Hi Ravi, >> This should be working fine with giving the field id $1$, instead of >> $Request ID$. >> You do try that and see whether it works or not. >> Thanks, >> RemProf >> On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: >> >>Hi: I am trying to build a escalation to delete records from AR >>System Email Messages form that have a create date older than 90 >>days. What do I include in Command Line field within the Run >>Process Action? The following doesn't seem to be working. >> >>Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ >> >>Also is there a recommended way to delete data from this form >>rather than using escalation? >> >>Thanks >>Ravi >> >> >> >> ___ >>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >><http://www.arslist.org/> >>Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> >>ARSlist: "Where the Answers Are" >> >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Using Application-Delete-Entry "$SCHEMA$" $1$ will work. $1$ is the core Request ID field and is the example usage shown in the v7 documentation and does work. You then just need to add your qualification to the Run IF statement. Craig Carter Software Engineer, RSP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 5:48 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages Thanks. Actually I have Application-Delete-Entry "$SCHEMA$" $Request ID$ David Sanders wrote: > ** > > Also use the correct form name - that might help !! > > David Sanders > > Remedy Solution Architect > > **Enterprise Service Suite @ Work** > > == > > **ARS List Award Winner 2005** > > **Best 3rd party Remedy Application** > > ** ** > > See the **ESS Concepts Guide** > <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> > > tel +44 1494 468980 > > mobile +44 7710 377761 > > email [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > web http://www.westoverconsulting.co.uk > <http://www.westoverconsulting.co.uk/> > > > > *From:* Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] *On Behalf Of *Remprof > *Sent:* Wednesday, June 11, 2008 12:36 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Workflow to delete records from AR System Email Messages > > ** > > Hi Ravi, > > This should be working fine with giving the field id $1$, instead of > $Request ID$. > > You do try that and see whether it works or not. > > Thanks, > > RemProf > > On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > Hi: I am trying to build a escalation to delete records from AR System > Email Messages form that have a create date older than 90 days. What > do I include in Command Line field within the Run Process Action? The > following doesn't seem to be working. > > Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > > Also is there a recommended way to delete data from this form rather > than using escalation? > > Thanks > Ravi > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > <http://www.arslist.org/> > Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> > ARSlist: "Where the Answers Are" > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Thanks. Actually I have Application-Delete-Entry "$SCHEMA$" $Request ID$ David Sanders wrote: ** Also use the correct form name – that might help !! David Sanders Remedy Solution Architect **Enterprise Service Suite @ Work** == **ARS List Award Winner 2005** **Best 3rd party Remedy Application** ** ** See the **ESS Concepts Guide** <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Remprof *Sent:* Wednesday, June 11, 2008 12:36 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Workflow to delete records from AR System Email Messages ** Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Also use the correct form name - that might help !! David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remprof Sent: Wednesday, June 11, 2008 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages ** Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, Ravi <[EMAIL PROTECTED]> wrote: Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Hi: Just so that I understand, what does the $1$ mean? Thanks Ravi Remprof wrote: ** Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, *Ravi* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Workflow to delete records from AR System Email Messages
Hi Ravi, This should be working fine with giving the field id $1$, instead of $Request ID$. You do try that and see whether it works or not. Thanks, RemProf On 6/11/08, Ravi <[EMAIL PROTECTED]> wrote: > > Hi: I am trying to build a escalation to delete records from AR System > Email Messages form that have a create date older than 90 days. What do I > include in Command Line field within the Run Process Action? The following > doesn't seem to be working. > > Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ > > Also is there a recommended way to delete data from this form rather than > using escalation? > > Thanks > Ravi > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Workflow to delete records from AR System Email Messages
Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry "BMC:SSP:Issue" $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: FW: Archive email records from 'AR System Email Messages' to a new staging form
Good morning all, I tried using a archive form on the e-mail messages form (by enabling the new Archive tab) and for some reason the link was broken between the mail messages form and the e-mail engine. I needed to import all mail objects from production to development (where I tried this little experiment). We are planning a refresh of Development from production (So I will have over 400k mail messaged to try and delete) and I will then try the delete option on the archive tab (I am not going to try using archive form again). Let you know in a week what happens. Howard Richter On 6/12/07, Neel Guatam <[EMAIL PROTECTED]> wrote: ** Hello list, Sorry for bugging you again but this is very urgent for me and any help would be highly appreciated. Thank you, *Neel Gautam* *From:* Gautam, Neel *Sent:* Monday, June 11, 2007 1:56 PM *To:* 'arslist@ARSLIST.ORG' *Subject:* Archive email records from 'AR System Email Messages' to a new staging form Hello listers, The idea is to use form archiving on 'AR System Email Messages' form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can't locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? 3) Any guidelines as to which/how many fields to copy over to staging form from 'AR System Email Messages' form? Is it advisable to copy over EVERY SINGLE field from 'AR System Email Messages' regardless of if you are using it or not? 4) One of the work-flow uses 'RTF Content' field on 'AR System Email Messages' form. It is of type "attachment" and display type is "list control". However, I can't see that field on 'AR System Email Messages' form. There is not a single field that's not in the current view! Position size is X:0, Y:0, Width:0 and Height:0 and they are grayed out. How do I copy this field over from 'AR System Email Messages' to my new staging form? Thank you, Neel Gautam. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. __20060125___This posting was submitted with HTML in it___ -- Howard Richter Remedy ServiceDesk Manager CedarCrestone Managed Services Center [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Archive email records from 'AR System Email Messages' to a new staging form
The new Audit feature can be used to track any changes on a form or the whole form if needed. The information you need is located in the Form and Application Objects manual. -Original Message- From: Neel Guatam <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tue, 12 Jun 2007 11:03 am Subject: Re: Archive email records from 'AR System Email Messages' to a new staging form Hi Roger, I'm still a novice so not sure what you meant. How can audit feature be helpful n archiving situation? Could you please give me more specifics to this? Thank you, eel Gautam. rom: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] n Behalf Of Roger Justice ent: Tuesday, June 12, 2007 9:36 AM o: arslist@ARSLIST.ORG ubject: Re: Archive email records from 'AR System Email Messages' to a new taging form ** Since you are on version 7 review the new Audit feature before you make a inal decision. rom: Gautam, Neel ent: Monday, June 11, 2007 1:56 PM o: 'arslist@ARSLIST.ORG' ubject: Archive email records from 'AR System Email Messages' to a new staging orm ello listers, he idea is to use form archiving on 'AR System Email Messages' form to a new taging form. I have following questions regarding the same: (We are using ARS .0.01 Patch 001) ) Are there any known issues with archiving that anybody have experienced? I ave read a few emails in past few days regarding this in which somebody claimed ome defect or something, can't locate that email anymore. ) Any guidelines that one should follow while using archiving? Best ractices? This message is for the designated recipient only and may contain privileged, roprietary, or otherwise private information. If you have received it in rror, please notify the sender immediately and delete the original. Any other se of the email by you is prohibited. ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the nswers Are" AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Archive email records from 'AR System Email Messages' to a new staging form
I'm still on 6.3 but I can tell you the RTF Content is an attachment located on the Advanced Options tab in the Attachment Alternatives tab Attachment pool (It's one of the 5 Attachment fields). Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Neel Guatam Sent: Tuesday, June 12, 2007 9:27 AM To: arslist@ARSLIST.ORG Subject: FW: Archive email records from 'AR System Email Messages' to a new staging form ** Hello list, Sorry for bugging you again but this is very urgent for me and any help would be highly appreciated. Thank you, Neel Gautam From: Gautam, Neel Sent: Monday, June 11, 2007 1:56 PM To: 'arslist@ARSLIST.ORG' Subject: Archive email records from 'AR System Email Messages' to a new staging form Hello listers, The idea is to use form archiving on 'AR System Email Messages' form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can't locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? 3) Any guidelines as to which/how many fields to copy over to staging form from 'AR System Email Messages' form? Is it advisable to copy over EVERY SINGLE field from 'AR System Email Messages' regardless of if you are using it or not? 4) One of the work-flow uses 'RTF Content' field on 'AR System Email Messages' form. It is of type "attachment" and display type is "list control". However, I can't see that field on 'AR System Email Messages' form. There is not a single field that's not in the current view! Position size is X:0, Y:0, Width:0 and Height:0 and they are grayed out. How do I copy this field over from 'AR System Email Messages' to my new staging form? Thank you, Neel Gautam. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Archive email records from 'AR System Email Messages' to a new staging form
Hi Roger, I'm still a novice so not sure what you meant. How can audit feature be helpful in archiving situation? Could you please give me more specifics to this? Thank you, Neel Gautam. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Tuesday, June 12, 2007 9:36 AM To: arslist@ARSLIST.ORG Subject: Re: Archive email records from 'AR System Email Messages' to a new staging form ** Since you are on version 7 review the new Audit feature before you make a final decision. From: Gautam, Neel Sent: Monday, June 11, 2007 1:56 PM To: 'arslist@ARSLIST.ORG' Subject: Archive email records from 'AR System Email Messages' to a new staging form Hello listers, The idea is to use form archiving on 'AR System Email Messages' form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can't locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Archive email records from 'AR System Email Messages' to a new staging form
Since you are on version 7 review the new Audit feature before you make a final decision. -Original Message- From: Neel Guatam <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tue, 12 Jun 2007 10:27 am Subject: FW: Archive email records from 'AR System Email Messages' to a new staging form ** Hello list, Sorry for bugging you again but this is very urgent for me and any help would be highly appreciated. Thank you, Neel Gautam From: Gautam, Neel Sent: Monday, June 11, 2007 1:56 PM To: 'arslist@ARSLIST.ORG' Subject: Archive email records from 'AR System Email Messages' to a new staging form Hello listers, The idea is to use form archiving on ‘AR System Email Messages’ form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can’t locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? 3) Any guidelines as to which/how many fields to copy over to staging form from ‘AR System Email Messages’ form? Is it advisable to copy over EVERY SINGLE field from ‘AR System Email Messages’ regardless of if you are using it or not? 4) One of the work-flow uses ‘RTF Content’ field on ‘AR System Email Messages’ form. It is of type “attachment” and display type is “list control”. However, I can’t see that field on ‘AR System Email Messages’ form. There is not a single field that’s not in the current view! Position size is X:0, Y:0, Width:0 and Height:0 and they are grayed out. How do I copy this field over from ‘AR System Email Messages’ to my new staging form? Thank you, Neel Gautam. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. __20060125___This posting was submitted with HTML in it___ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
FW: Archive email records from 'AR System Email Messages' to a new staging form
Hello list, Sorry for bugging you again but this is very urgent for me and any help would be highly appreciated. Thank you, Neel Gautam From: Gautam, Neel Sent: Monday, June 11, 2007 1:56 PM To: 'arslist@ARSLIST.ORG' Subject: Archive email records from 'AR System Email Messages' to a new staging form Hello listers, The idea is to use form archiving on 'AR System Email Messages' form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can't locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? 3) Any guidelines as to which/how many fields to copy over to staging form from 'AR System Email Messages' form? Is it advisable to copy over EVERY SINGLE field from 'AR System Email Messages' regardless of if you are using it or not? 4) One of the work-flow uses 'RTF Content' field on 'AR System Email Messages' form. It is of type "attachment" and display type is "list control". However, I can't see that field on 'AR System Email Messages' form. There is not a single field that's not in the current view! Position size is X:0, Y:0, Width:0 and Height:0 and they are grayed out. How do I copy this field over from 'AR System Email Messages' to my new staging form? Thank you, Neel Gautam. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Archive email records from 'AR System Email Messages' to a new staging form
Hello listers, The idea is to use form archiving on 'AR System Email Messages' form to a new staging form. I have following questions regarding the same: (We are using ARS 7.0.01 Patch 001) 1) Are there any known issues with archiving that anybody have experienced? I have read a few emails in past few days regarding this in which somebody claimed some defect or something, can't locate that email anymore. 2) Any guidelines that one should follow while using archiving? Best practices? 3) Any guidelines as to which/how many fields to copy over to staging form from 'AR System Email Messages' form? Is it advisable to copy over EVERY SINGLE field from 'AR System Email Messages' regardless of if you are using it or not? 4) One of the work-flow uses 'RTF Content' field on 'AR System Email Messages' form. It is of type "attachment" and display type is "list control". However, I can't see that field on 'AR System Email Messages' form. There is not a single field that's not in the current view! Position size is X:0, Y:0, Width:0 and Height:0 and they are grayed out. How do I copy this field over from 'AR System Email Messages' to my new staging form? Thank you, Neel Gautam. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: AR System Email Messages
I don't know if this is best solution, but I've made similar task for auto create helpdesk ticket from email. 1. Add field in HPD:Helpdesk to store Email UID (EmailUID) 2. Add attachment pool in AR System Email Attachment Join 3. Create filter which query ( $EmailUID$ = 'Source ID2') then set attachment to the HPD:HelpDesk. IPBS On 3/26/07, ORA-600 <[EMAIL PROTECTED]> wrote: This is my problem though_HOW_ would i copy it over? I'm new to remedy, and a simple form to form push is ok, but since there is no relations in the DB, how can I put from 2 tables into 1? Ben Cantatore wrote: > > AR System Email Attachments and AR system Email Attachment Join are the > two you want to look at. Personally, to save space, I'd just reference > the GUID on the AR System Email Attachments form rather than copying it > over. If you still need to copy it for some reason, you should be able to > push it over. > > > > > > > ORA-600 <[EMAIL PROTECTED]> > Sent by: "Action Request System discussion list(ARSList)" > > 03/25/2007 01:29 AM > Please respond to > arslist@ARSLIST.ORG > > > To > arslist@ARSLIST.ORG > cc > > Subject > Re: AR System Email Messages > > > > > > > Doug, > > Thanks! This works. My problem is now that incoming email messages which > have attachments. I can see the attachments in the AR System Email > Messages > form, but evidently they are actually on a different form, because they > aren't in the 'table' when I create my escalation. I would like to grab > any > attachments that are included and put them to my attachment pool in > another > form. How can I do this? > > Thanks again! > Michael > > > > > Tanner, Doug wrote: >> >> There are a few ways to do, but there is a hidden field that has the >> mailbox ID (GUID). Doug >> >> >> >> ____ >> >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF >> AFRL/SNOD >> Sent: Wednesday, March 21, 2007 2:47 PM >> To: arslist@ARSLIST.ORG >> Subject: AR System Email Messages >> Importance: High >> >> >> >> I have a need to set up an escalation, etc that runs against AR System >> Email Messages. >> >> When it finds new messages in this form (as placed there by the remedy >> email engine), I would like to run a set fields to push the data to a >> new form. My problem is that I want to look at Mailbox Name to secure >> messages that come in from a specific remedy mailbox setup. I get an >> error that I can't since the mailbox name field is display only. Ah ha! >> So I'll instead use the to field, and grab only messages that were sent >> to the inbox in question. Now I get "Failure during SQL operation to >> the database" - evidently there is a further issue. "The data types >> text and varchar are incompatible in the equal to operator. (SQL Server >> 402)" >> >> My question is, once I have the email in remedy, procedurally, what is a >> good way to find it and process it? Someone has to have done this - >> please help me. >> >> >> >> Thanks! >> >> --- >> Michael Cupp, Jr., Contractor, RCF >> Oracle Database Administrator >> AFRL EBS Helpdesk Team Lead >> AFRL/SNOD Enterprise Operations Center >> Wright-Patterson AFB, Ohio >> DSN 785-3827 >> >> __20060125___This posting was submitted with HTML in >> it___ >> >> DISCLAIMER Important! This message is intended for the above named >> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the >> intended recipient of this e-mail and have received it in error, please >> immediately notify the sender by return email and then delete it from > your >> mailbox. This message may be protected by the attorney-client privilege >> and/or work product doctrine. Accessing, copying, disseminating or >> re-using any of the information contained in this e-mail by anyone other >> than the intended recipient is strictly prohibited. Finally, you should >> check this email and any attachments for the presence of viruses, as the >> sender accepts no liability for any damage caused by any virus > transmitted >> by this email. Thank you. >> >> >> >> > ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" &g
Re: AR System Email Messages
This is my problem though_HOW_ would i copy it over? I'm new to remedy, and a simple form to form push is ok, but since there is no relations in the DB, how can I put from 2 tables into 1? Ben Cantatore wrote: > > AR System Email Attachments and AR system Email Attachment Join are the > two you want to look at. Personally, to save space, I'd just reference > the GUID on the AR System Email Attachments form rather than copying it > over. If you still need to copy it for some reason, you should be able to > push it over. > > > > > > > ORA-600 <[EMAIL PROTECTED]> > Sent by: "Action Request System discussion list(ARSList)" > > 03/25/2007 01:29 AM > Please respond to > arslist@ARSLIST.ORG > > > To > arslist@ARSLIST.ORG > cc > > Subject > Re: AR System Email Messages > > > > > > > Doug, > > Thanks! This works. My problem is now that incoming email messages which > have attachments. I can see the attachments in the AR System Email > Messages > form, but evidently they are actually on a different form, because they > aren't in the 'table' when I create my escalation. I would like to grab > any > attachments that are included and put them to my attachment pool in > another > form. How can I do this? > > Thanks again! > Michael > > > > > Tanner, Doug wrote: >> >> There are a few ways to do, but there is a hidden field that has the >> mailbox ID (GUID). Doug >> >> >> >> ________ >> >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF >> AFRL/SNOD >> Sent: Wednesday, March 21, 2007 2:47 PM >> To: arslist@ARSLIST.ORG >> Subject: AR System Email Messages >> Importance: High >> >> >> >> I have a need to set up an escalation, etc that runs against AR System >> Email Messages. >> >> When it finds new messages in this form (as placed there by the remedy >> email engine), I would like to run a set fields to push the data to a >> new form. My problem is that I want to look at Mailbox Name to secure >> messages that come in from a specific remedy mailbox setup. I get an >> error that I can't since the mailbox name field is display only. Ah ha! >> So I'll instead use the to field, and grab only messages that were sent >> to the inbox in question. Now I get "Failure during SQL operation to >> the database" - evidently there is a further issue. "The data types >> text and varchar are incompatible in the equal to operator. (SQL Server >> 402)" >> >> My question is, once I have the email in remedy, procedurally, what is a >> good way to find it and process it? Someone has to have done this - >> please help me. >> >> >> >> Thanks! >> >> --- >> Michael Cupp, Jr., Contractor, RCF >> Oracle Database Administrator >> AFRL EBS Helpdesk Team Lead >> AFRL/SNOD Enterprise Operations Center >> Wright-Patterson AFB, Ohio >> DSN 785-3827 >> >> __20060125___This posting was submitted with HTML in >> it___ >> >> DISCLAIMER Important! This message is intended for the above named >> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the >> intended recipient of this e-mail and have received it in error, please >> immediately notify the sender by return email and then delete it from > your >> mailbox. This message may be protected by the attorney-client privilege >> and/or work product doctrine. Accessing, copying, disseminating or >> re-using any of the information contained in this e-mail by anyone other >> than the intended recipient is strictly prohibited. Finally, you should >> check this email and any attachments for the presence of viruses, as the >> sender accepts no liability for any damage caused by any virus > transmitted >> by this email. Thank you. >> >> >> >> > ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- > View this message in context: > http://www.nabble.com/AR-System-Email-Messages-tf3442763.html#a9657487 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/AR-System-Email-Messages-tf3442763.html#a9666731 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: AR System Email Messages
AR System Email Attachments and AR system Email Attachment Join are the two you want to look at. Personally, to save space, I'd just reference the GUID on the AR System Email Attachments form rather than copying it over. If you still need to copy it for some reason, you should be able to push it over. ORA-600 <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 03/25/2007 01:29 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Doug, Thanks! This works. My problem is now that incoming email messages which have attachments. I can see the attachments in the AR System Email Messages form, but evidently they are actually on a different form, because they aren't in the 'table' when I create my escalation. I would like to grab any attachments that are included and put them to my attachment pool in another form. How can I do this? Thanks again! Michael Tanner, Doug wrote: > > There are a few ways to do, but there is a hidden field that has the > mailbox ID (GUID). Doug > > > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF > AFRL/SNOD > Sent: Wednesday, March 21, 2007 2:47 PM > To: arslist@ARSLIST.ORG > Subject: AR System Email Messages > Importance: High > > > > I have a need to set up an escalation, etc that runs against AR System > Email Messages. > > When it finds new messages in this form (as placed there by the remedy > email engine), I would like to run a set fields to push the data to a > new form. My problem is that I want to look at Mailbox Name to secure > messages that come in from a specific remedy mailbox setup. I get an > error that I can't since the mailbox name field is display only. Ah ha! > So I'll instead use the to field, and grab only messages that were sent > to the inbox in question. Now I get "Failure during SQL operation to > the database" - evidently there is a further issue. "The data types > text and varchar are incompatible in the equal to operator. (SQL Server > 402)" > > My question is, once I have the email in remedy, procedurally, what is a > good way to find it and process it? Someone has to have done this - > please help me. > > > > Thanks! > > --- > Michael Cupp, Jr., Contractor, RCF > Oracle Database Administrator > AFRL EBS Helpdesk Team Lead > AFRL/SNOD Enterprise Operations Center > Wright-Patterson AFB, Ohio > DSN 785-3827 > > __20060125___This posting was submitted with HTML in > it___ > > DISCLAIMER Important! This message is intended for the above named > person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the > intended recipient of this e-mail and have received it in error, please > immediately notify the sender by return email and then delete it from your > mailbox. This message may be protected by the attorney-client privilege > and/or work product doctrine. Accessing, copying, disseminating or > re-using any of the information contained in this e-mail by anyone other > than the intended recipient is strictly prohibited. Finally, you should > check this email and any attachments for the presence of viruses, as the > sender accepts no liability for any damage caused by any virus transmitted > by this email. Thank you. > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/AR-System-Email-Messages-tf3442763.html#a9657487 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: AR System Email Messages
Doug, Thanks! This works. My problem is now that incoming email messages which have attachments. I can see the attachments in the AR System Email Messages form, but evidently they are actually on a different form, because they aren't in the 'table' when I create my escalation. I would like to grab any attachments that are included and put them to my attachment pool in another form. How can I do this? Thanks again! Michael Tanner, Doug wrote: > > There are a few ways to do, but there is a hidden field that has the > mailbox ID (GUID). Doug > > > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF > AFRL/SNOD > Sent: Wednesday, March 21, 2007 2:47 PM > To: arslist@ARSLIST.ORG > Subject: AR System Email Messages > Importance: High > > > > I have a need to set up an escalation, etc that runs against AR System > Email Messages. > > When it finds new messages in this form (as placed there by the remedy > email engine), I would like to run a set fields to push the data to a > new form. My problem is that I want to look at Mailbox Name to secure > messages that come in from a specific remedy mailbox setup. I get an > error that I can't since the mailbox name field is display only. Ah ha! > So I'll instead use the to field, and grab only messages that were sent > to the inbox in question. Now I get "Failure during SQL operation to > the database" - evidently there is a further issue. "The data types > text and varchar are incompatible in the equal to operator. (SQL Server > 402)" > > My question is, once I have the email in remedy, procedurally, what is a > good way to find it and process it? Someone has to have done this - > please help me. > > > > Thanks! > > --- > Michael Cupp, Jr., Contractor, RCF > Oracle Database Administrator > AFRL EBS Helpdesk Team Lead > AFRL/SNOD Enterprise Operations Center > Wright-Patterson AFB, Ohio > DSN 785-3827 > > __20060125___This posting was submitted with HTML in > it___ > > DISCLAIMER Important! This message is intended for the above named > person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the > intended recipient of this e-mail and have received it in error, please > immediately notify the sender by return email and then delete it from your > mailbox. This message may be protected by the attorney-client privilege > and/or work product doctrine. Accessing, copying, disseminating or > re-using any of the information contained in this e-mail by anyone other > than the intended recipient is strictly prohibited. Finally, you should > check this email and any attachments for the presence of viruses, as the > sender accepts no liability for any damage caused by any virus transmitted > by this email. Thank you. > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/AR-System-Email-Messages-tf3442763.html#a9657487 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: AR System Email Messages
There are a few ways to do, but there is a hidden field that has the mailbox ID (GUID). Doug From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF AFRL/SNOD Sent: Wednesday, March 21, 2007 2:47 PM To: arslist@ARSLIST.ORG Subject: AR System Email Messages Importance: High I have a need to set up an escalation, etc that runs against AR System Email Messages. When it finds new messages in this form (as placed there by the remedy email engine), I would like to run a set fields to push the data to a new form. My problem is that I want to look at Mailbox Name to secure messages that come in from a specific remedy mailbox setup. I get an error that I can't since the mailbox name field is display only. Ah ha! So I'll instead use the to field, and grab only messages that were sent to the inbox in question. Now I get "Failure during SQL operation to the database" - evidently there is a further issue. "The data types text and varchar are incompatible in the equal to operator. (SQL Server 402)" My question is, once I have the email in remedy, procedurally, what is a good way to find it and process it? Someone has to have done this - please help me. Thanks! --- Michael Cupp, Jr., Contractor, RCF Oracle Database Administrator AFRL EBS Helpdesk Team Lead AFRL/SNOD Enterprise Operations Center Wright-Patterson AFB, Ohio DSN 785-3827 __20060125___This posting was submitted with HTML in it___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
AR System Email Messages
I have a need to set up an escalation, etc that runs against AR System Email Messages. When it finds new messages in this form (as placed there by the remedy email engine), I would like to run a set fields to push the data to a new form. My problem is that I want to look at Mailbox Name to secure messages that come in from a specific remedy mailbox setup. I get an error that I can't since the mailbox name field is display only. Ah ha! So I'll instead use the to field, and grab only messages that were sent to the inbox in question. Now I get "Failure during SQL operation to the database" - evidently there is a further issue. "The data types text and varchar are incompatible in the equal to operator. (SQL Server 402)" My question is, once I have the email in remedy, procedurally, what is a good way to find it and process it? Someone has to have done this - please help me. Thanks! --- Michael Cupp, Jr., Contractor, RCF Oracle Database Administrator AFRL EBS Helpdesk Team Lead AFRL/SNOD Enterprise Operations Center Wright-Patterson AFB, Ohio DSN 785-3827 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Email Engine: Attachment-Flag in AR System Email Messages not been set
hello everyone, first some platform info: ars 6.03.00 patch 13 os solaris 9 db oracle 9.2 well, i've got a problem with the email-engine, more precisely with the attachment flag field "Attachments ?" in the AR System Email Messages Form. When sending a mail with attachments to the ars the flag won't be set to 'yes', althoug all other entries in the concernde forms are ok. the filter AR System Email Association Mark Email Entry Attachments(core)is also ok, run if condition works, but he can't find an entry in the AR System Email Message Form, so he takes no action (if no request match ...). i'm a little bit confused about this ... hope somebody could help me ... thanks and best regards tina ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
