I can't find Help Desk View
Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: I can't find Help Desk View
Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: I can't find Help Desk View
Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: I can't find Help Desk View
Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: I can't find Help Desk View
Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third
Re: I can't find Help Desk View
Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg
Re: I can't find Help Desk View
Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete a new field which added upon customer's requirements from the form Hel Desk, but it couldn't be deleted so, I tried to delete it from ARSystem DB from both (Help Desk View, Help Desk Table). Unfortunately,after deleting the field I can't find Help Desk View in the ARSchema. Please I need your advice to know why this happened. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are *
Re: I can't find Help Desk View
Hi, Apparently you corrupted the system by deleting the wrong things. Possibly, you system is already corrupt, as you are unable to delete a field in the normal way. Corruptions can happen either by doing things directly in the database, or by BUGs in the AR System. You can take your pick, but I have not had problems deleting a field, unless some previous change to the form has gone wrong. It will NOT affect performance if you export a DEF of HPD:Help Desk only. This is done by the clients all the time. This is a way for you to check the consistency of the definitions of HPD:Help Desk. If you can successfully import it into a test-system, you can then compare the objects in the ar system database to that of your production system. Turn on API/SQL logging when you import the form, and you may be able to understand what is needed on the DB side. Best Regards - Misi, RRR AB, http://rrr.se Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you deleted columns and fields directly in the database? That might be tricky to fix... I would suggest that you restore the database, and try to do it in Dev Studio anyway. What was the error message you got when originally trying to delete the field? Which version are you on? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free
BMC ITSM Implementation Project/Programme Manager required 8 Month plus contract
Dear All I am currently looking for a Senior BMC ITSM Project/Programme Manager for a long term ITSM implementation assignment in Dallas. There will be remote working available however the beginning of the assignment will need to be based onsite. Due to the nature of the client applicants must be US nationals. For additional information please contact me on the below details. Greg Park Client Engagement Manager Fusion Business Solutions (UK) Ltd Tel: +44 (0) 208 814 6194 Mob: +44 (0) 7815 576 613 www.fusion.co.uk http://www.fusion.co.uk/ Fusion is the largest consultancy in Europe that focuses exclusively on BMC Software solutions ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: I can't find Help Desk View
Hate to be blunt but the root-cause is: *YOU* are the root cause! You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients. Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. -JDHood On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, Do you mean that you
Re: I can't find Help Desk View
Man... that was harsh. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 8:14 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Hate to be blunt but the root-cause is: *YOU* are the root cause! You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients. Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. -JDHood On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find form... Best Regards - Misi, RRR AB, http://rrr.se Dears, I'm using 7.1 version and the error message is can't find Help Desk Form to Open when I tried to open it. I already restored the DB but I need the root cause of the problem or what the reasons that may cause to lose Help Desk View. Thanks Best Regards -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
Re: I can't find Help Desk View
Dears, Thanks for all I closed the issue and learned the lesson from my mistake. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chowdhury, Tauf Sent: Monday, November 14, 2011 3:48 PM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Man... that was harsh. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 8:14 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Hate to be blunt but the root-cause is: *YOU* are the root cause! You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients. Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. -JDHood On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.commailto:mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer the question about how you did this. Did you do it directly in the database? In theory, you should be back to where you started, and in the first email you just said could not delete field, but now you are saying can't find
Re: I can't find Help Desk View
Apologies if I seemed overly harsh, but I don't see much point in tip-toeing around when the problem was self-inflicted. He kept replying that he wanted to identify the root-cause and no-one else seemed like they were going to spell it out for him, so I just cut to the heart of the matter. Ehh. It's early yet and apparently the coffee hasn't kicked in. Again, apologies... -JDHood On Mon, Nov 14, 2011 at 8:47 AM, Chowdhury, Tauf tauf.chowdh...@frx.comwrote: ** Man… that was harsh. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *JD Hood *Sent:* Monday, November 14, 2011 8:14 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: I can't find Help Desk View ** ** ** Hate to be blunt but the root-cause is: ** ** *YOU* are the root cause! ** ** You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). ** ** The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients.** ** ** ** Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. ** ** When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. ** ** -JDHood ** ** ** ** On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the db, and restarting your AR Server, you get this message? What is the message number, is this in ARUser or in ARAdmin? You did not answer
Re: I can't find Help Desk View
It's OK. I think your point is well taken though and for any people who are new to the list, it's important to realize that as Remedy and especially ITSM evolves, there are additional layers of metadata being introduced between the DB and ARS application. I remember when I was new to ARS, there was a comment in one of the admin classes like, It's just data in a relational DB. Of course while that is technically true, the rest of that comment should be, ... but don't go changing stuff directly in the DB because you'll be screwed in record time. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 9:24 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Apologies if I seemed overly harsh, but I don't see much point in tip-toeing around when the problem was self-inflicted. He kept replying that he wanted to identify the root-cause and no-one else seemed like they were going to spell it out for him, so I just cut to the heart of the matter. Ehh. It's early yet and apparently the coffee hasn't kicked in. Again, apologies... -JDHood On Mon, Nov 14, 2011 at 8:47 AM, Chowdhury, Tauf tauf.chowdh...@frx.com wrote: ** Man... that was harsh. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 8:14 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Hate to be blunt but the root-cause is: *YOU* are the root cause! You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients. Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. -JDHood On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to
Re: I can't find Help Desk View
Mahmoud, Sometimes the most enduring lessons are (unfortunately) learned painfully. I've learned my fair share that way as well. -JDHood On Mon, Nov 14, 2011 at 9:08 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: ** Dears, ** ** Thanks for all…. I closed the issue and learned the lesson from my mistake. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Chowdhury, Tauf *Sent:* Monday, November 14, 2011 3:48 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: I can't find Help Desk View ** ** ** Man… that was harsh. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *JD Hood *Sent:* Monday, November 14, 2011 8:14 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: I can't find Help Desk View ** ** ** Hate to be blunt but the root-cause is: ** ** *YOU* are the root cause! ** ** You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). ** ** The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients.** ** ** ** Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. ** ** When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. ** ** -JDHood ** ** ** ** On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Dears, I tried to delete the field from the form but when I couldn't do that I deleted it from the DB from both (Help Desk view, Help Desk Table) but unfortunately when I tested after deleting those fields from DB I opened ARUser to open Help Desk Form but error message appeared Can't find Help desk form to open So, I searched for the Help Desk View in DB but I couldn't find it which cause to restore our daily DB Backup. The system now is working fine but due to shutdown the system for about 7 hours, I'm asked to introduce the root cause of the problem or the reasons that may cause this defect. I don't have realistic reasons for what happened. Please I need your advice. Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, So after restoring the
Re: I can't find Help Desk View
Dears, I suffered a lot from this mistake and I learned well from this lesson and I asked for the root cause to gain more benefit from this issue and advice others not to repeat my problem. I believe that anybody can do mistakes but the most important thing is to learn from our mistakes. Thanks again for all who tried to help me. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chowdhury, Tauf Sent: Monday, November 14, 2011 4:30 PM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** It's OK. I think your point is well taken though and for any people who are new to the list, it's important to realize that as Remedy and especially ITSM evolves, there are additional layers of metadata being introduced between the DB and ARS application. I remember when I was new to ARS, there was a comment in one of the admin classes like, It's just data in a relational DB. Of course while that is technically true, the rest of that comment should be, ... but don't go changing stuff directly in the DB because you'll be screwed in record time. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 9:24 AM To: arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Apologies if I seemed overly harsh, but I don't see much point in tip-toeing around when the problem was self-inflicted. He kept replying that he wanted to identify the root-cause and no-one else seemed like they were going to spell it out for him, so I just cut to the heart of the matter. Ehh. It's early yet and apparently the coffee hasn't kicked in. Again, apologies... -JDHood On Mon, Nov 14, 2011 at 8:47 AM, Chowdhury, Tauf tauf.chowdh...@frx.commailto:tauf.chowdh...@frx.com wrote: ** Man... that was harsh. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Monday, November 14, 2011 8:14 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View ** Hate to be blunt but the root-cause is: *YOU* are the root cause! You deleted structure directly in the DB, and not via the Remedy API (using a Remedy client like Dev Studio) which caused the meta-data to be incorrect. If the meta-data is not correct, the form will not display (among other weird behaviors). The AR system maintains some meta-data for each object in the system. When you deleted the column directly in the DB, you corrupted the meta-data for that table in the system. Likely, the row-count from the FIELD table did not agree with the NUMFIELDS column value for that table in the ARSCHEMA table. One of the behaviors you will see when this happens is that the affected forms (tables) will not display in the Remedy clients. Presuming you are just starting to gain experience with ARS, the best way to recover from your mistake is to restore the DB from backup. When you add, alter, delete structure in DevStudio, there is more going on in the background than a simple DROP sql statement. When you do it directly in the DB, the only thing that happens is the column vanishes. None of the houskeeping/recordkeeping tasks get done. If you do not know what you are doing in the AR System, you should definitely not go monkeying around in the DB altering structure -- unless you want to learn a hard lesson via the burn learn method. -JDHood On Mon, Nov 14, 2011 at 5:13 AM, Mahmoud Mahdy-Mohamed mahmoud.mahdy-moha...@vodafone.commailto:mahmoud.mahdy-moha...@vodafone.com wrote: Dears, To export def file for Help Desk form, this may affect the production performance. So, I think this solution will be difficult and for the error message it will appear when I will try to delete the field again. I will send you the error message when it will appear. Now my concentration on the root cause for what happened. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 11:59 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: I can't find Help Desk View Hi, If you deleted things directly in the DB, this is most likely the root-cause. When you had problems deleting a field initially, this may be the result of an EARLIER direct sql change... I would not bother to understand why your view vanished when you deleted things in the DB, I would concentrate on why you could not delete the field in the first place. What is the ARERR-code when you try to delete your field? Try exporting your def-file of the form, and import it into a test/dev system, to check that your def is OK. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save
Set Field Calculation
I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Email Error Message 362
Good Morning, Has anyone seen an error message like this in the AR System Email Error Logs? I have a couple of these and the numbers between RED and TMP are different. The mailbox is in the /var/mail directory. Mailbox Name: Out_Going Message Type: Severe Message Number: 362 Message Text: Cannot find/open the directory file /var/tmp/RED6550561TMP ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
Hi, The problem is that the contents go to a text field, so if you want to do maths, you need to go via a numeric field: Set-Fields 1: tmpreal = $Field1$ / 100.0 Set-Fiedls 2: Testfield = $tmpreal$ Or maybe you can do something like this: Set-Fields: Testfield = ROUND($Field1$ / 100.0) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
Thanks... The Real Number field fixed it. I assumed that a character field would work since it could hold any text/numbers, but I was obviously wrong. Thanks again. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation Hi, The problem is that the contents go to a text field, so if you want to do maths, you need to go via a numeric field: Set-Fields 1: tmpreal = $Field1$ / 100.0 Set-Fiedls 2: Testfield = $tmpreal$ Or maybe you can do something like this: Set-Fields: Testfield = ROUND($Field1$ / 100.0) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How to use an HTML template?
Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial Black RequestID: #$$Request-ID$$#/font/p pfont face=Arial Black Status: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template - why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
Try changing the Content Template: to just plain text (the name of your template) instead of $Short Description$. I believe you should select include all fields, but you don't need to supply any test in the Text: field, because that isn't used at all w/ templates. Since you are getting NO template at all I suspect it is failing on looking up the template in the AR System Email Templates form based on your Content Template: field. Brien On 11/14/2011 10:20 AM, Mark Milke wrote: Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial Black RequestID: #$$Request-ID$$#/font/p pfont face=Arial Black Status: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template - why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
Thanks Brien, did that, but still same problem. When the message waits in the AR System Email Messages the both tabs Plain and HTML are empty. Is this normal? On Nov 14, 6:32 pm, Brien Dieterle brien.diete...@cgcmail.maricopa.edu wrote: Try changing the Content Template: to just plain text (the name of your template) instead of $Short Description$. I believe you should select include all fields, but you don't need to supply any test in the Text: field, because that isn't used at all w/ templates. Since you are getting NO template at all I suspect it is failing on looking up the template in the AR System Email Templates form based on your Content Template: field. Brien On 11/14/2011 10:20 AM, Mark Milke wrote: Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial Black RequestID: #$$Request-ID$$#/font/p pfont face=Arial Black Status: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template - why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
Yeah, that is normal. On the Email Message record you have there, go to Advanced Options-- Templates and make sure you see your template named there,and make sure it matches one of the available templates in the dropdown menu on that field (*just in case*). Also, check the Variable Replacement tab and check the Field Values. You should see all the mapped variables. I suppose you could look at the errors tab too, but I doubt there are any errors there. Oh yeah, you *did* create the template as an html file, and attach it to the Email Template form entry, right? Double check it is indeed attached in the attachment pool? *grasping* Brien On 11/14/2011 10:39 AM, Mark Milke wrote: Thanks Brien, did that, but still same problem. When the message waits in the AR System Email Messages the both tabs Plain and HTML are empty. Is this normal? On Nov 14, 6:32 pm, Brien Dieterle brien.diete...@cgcmail.maricopa.edu wrote: Try changing the Content Template: to just plain text (the name of your template) instead of $Short Description$. I believe you should select include all fields, but you don't need to supply any test in the Text: field, because that isn't used at all w/ templates. Since you are getting NO template at all I suspect it is failing on looking up the template in the AR System Email Templates form based on your Content Template: field. Brien On 11/14/2011 10:20 AM, Mark Milke wrote: Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial BlackRequestID: #$$Request-ID$$#/font/p pfont face=Arial BlackStatus: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template -why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
We actually create an HTML file in the AR System Email Templates form, then refer to the html name in the Content, Header or Footer field on the Templates tab of the filter. We never did it the way you are doing it.. Thanks! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mark Milke Sent: Monday, November 14, 2011 12:20 PM To: arslist@ARSLIST.ORG Subject: How to use an HTML template? Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial Black RequestID: #$$Request-ID$$#/font/p pfont face=Arial Black Status: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template - why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
SQL ?
All I in the midst of creating a view for dashboards because I don't want to use Dashboards functions for performance reasons. I need to convert Date field from an integer value to mm/dd/ . Here is a sample of what I've tried. The Date 11/14/2011 = 2455880 The Statement SELECT CONVERT(varchar(30),DATEADD(s,C3,'19700101'),101) FROM T2677 Returns 01/29/1970 I need it to return 11/14/2011 Note that if use the same sql statement on a Date/Time field the return is 11/14/2011. Evidently, I'm missing something but I'm not sure what. Any thoughts? Thanks Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
IBRSD Plug-in Error
All, I'm seeing an error when trying to create new tickets (or update existing tickets) Cannot establish a connection to the AR System Plug-in server I validated all the correct lines are added to the ar.cfg file on both of our servers and that the plug-in server is running. The strange thing is that right after initially install it worked fine but after we restarted the services on the servers at a later time we are seeing this error. An ideas? TIA Mike -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Error-tp6993491p6993491.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
Check the port to see if it is already in use.. Sounds like you have 2 contending for same port # just a quess.. mind you.. On Mon, Nov 14, 2011 at 1:18 PM, Mike Ziniti versi...@aol.com wrote: All, I'm seeing an error when trying to create new tickets (or update existing tickets) Cannot establish a connection to the AR System Plug-in server I validated all the correct lines are added to the ar.cfg file on both of our servers and that the plug-in server is running. The strange thing is that right after initially install it worked fine but after we restarted the services on the servers at a later time we are seeing this error. An ideas? TIA Mike -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Error-tp6993491p6993491.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
Mike, Is it a load balanced environment? If so, check that you have the correct SERVER_NAME entries configured in ar.cfg or on the IBRSD side. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Ziniti Sent: Monday, November 14, 2011 1:18 PM To: arslist@ARSLIST.ORG Subject: IBRSD Plug-in Error All, I'm seeing an error when trying to create new tickets (or update existing tickets) Cannot establish a connection to the AR System Plug-in server I validated all the correct lines are added to the ar.cfg file on both of our servers and that the plug-in server is running. The strange thing is that right after initially install it worked fine but after we restarted the services on the servers at a later time we are seeing this error. An ideas? TIA Mike -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Err or-tp6993491p6993491.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Email Error Message 362
Have you checked the permissions of the file it is trying to attempt to open? You may have started the AR System as a different user leaving the file inaccessible to the current user that started the AR System. Joe From: Brittain, Mark Sent: Monday, November 14, 2011 11:09 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Email Error Message 362 ** Good Morning, Has anyone seen an error message like this in the AR System Email Error Logs? I have a couple of these and the numbers between RED and TMP are different. The mailbox is in the /var/mail directory. Mailbox Name: Out_Going Message Type: Severe Message Number: 362 Message Text: Cannot find/open the directory file /var/tmp/RED6550561TMP ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL ?
The Date field is stored as the # of days since 4714 BC From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joran, Peter CTR WHS/ITMD/CACI Sent: Monday, November 14, 2011 10:12 AM To: arslist@ARSLIST.ORG Subject: SQL ? ** All I in the midst of creating a view for dashboards because I don't want to use Dashboards functions for performance reasons. I need to convert Date field from an integer value to mm/dd/ . Here is a sample of what I've tried. The Date 11/14/2011 = 2455880 The Statement SELECT CONVERT(varchar(30),DATEADD(s,C3,'19700101'),101) FROM T2677 Returns 01/29/1970 I need it to return 11/14/2011 Note that if use the same sql statement on a Date/Time field the return is 11/14/2011. Evidently, I'm missing something but I'm not sure what. Any thoughts? Thanks Pete _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
It is load balanced and in the ar.cfg file we have the individual host names and on BEM side we have it pointing to the LB name. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Error-tp6993491p6993578.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Weblogic - debug messages - large log files
Thanks for this John, I think we've covered these off already. So far we've set the following .xml files to read Error or Fatal and nothing lower. ./ARSystem/api/lib/log4j.xml ./ARSystem/pluginsvr/log4j.xml ./ARSystem/pluginsvr/log4j_pluginsvr.xml ./ARSystem/flashboards/log4j.xml ./ARSystem/midtier/WEB-INF/lib/log4j.xml ./ARSystem/AREmail/log4j.xml ./AtriumCore/cmdb/plugins/log4j_pluginsvr.xml ./AtriumCore/cmdb/plugins/ne/log4j_pluginsvr.xml ./AtriumCore/cmdb/plugins/shared/log4j_pluginsvr.xml ./AtriumCore/cmdb/sdk/bin/log4j.xml ./AtriumCore/cmdb/sdk/bin/log4j_cmdbapi.xml ./AtriumCore/cmdb/sdk/bin/log4j_vzutil.xml ./AtriumCore/cmdb/sdk64/bin/log4j.xml ./AtriumCore/cmdb/sdk64/bin/log4j_cmdbapi.xml I'm certainly not savvy with these though so if there is a particular line entry we should be examining please let me know. Thanks again, much appreciated ...anik -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: November 11, 2011 03:21 AM To: arslist@ARSLIST.ORG Subject: Weblogic - debug messages - large log files LJ It looks like Anik may need to find the CMDB log4j.xml file and switch the debug logging to info. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
When you say two contending for the same port...are you referring to the plug-in ports? Most of my entries in the ar.cfg file for plug-in alias reference port -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Error-tp6993491p6993583.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
is the entry inside the ar.conf listed once? or Twice? check for double configurations.. On Mon, Nov 14, 2011 at 1:44 PM, Mike Ziniti versi...@aol.com wrote: When you say two contending for the same port...are you referring to the plug-in ports? Most of my entries in the ar.cfg file for plug-in alias reference port -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Error-tp6993491p6993583.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL ?
Peter, Date fields count the number of days from the beginning of its range.( January 1, 4713 B.C.E. - January 1, C. E.) Date/Time fields count the number of seconds from the Unix epoch. (January 1, 1970 00:00:00 AM) I'm not brushed up on SQL statements but you could try to change the operator s to d(?) so it counts days instead of seconds. SELECT CONVERT(varchar(30),DATEADD(d,C3,'19700101'),101) FROM T2677 --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 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 Joran, Peter CTR WHS/ITMD/CACI Sent: Monday, November 14, 2011 1:12 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: SQL ? ** All I in the midst of creating a view for dashboards because I don't want to use Dashboards functions for performance reasons. I need to convert Date field from an integer value to mm/dd/ . Here is a sample of what I've tried. The Date 11/14/2011 = 2455880 The Statement SELECT CONVERT(varchar(30),DATEADD(s,C3,'19700101'),101) FROM T2677 Returns 01/29/1970 I need it to return 11/14/2011 Note that if use the same sql statement on a Date/Time field the return is 11/14/2011. Evidently, I'm missing something but I'm not sure what. Any thoughts? Thanks Pete _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: How to use an HTML template?
I'm not quite sure what you mean Lisa. Here is a screenshot: http://twitter.com/?photo_id=1#!/MarkMilke/status/136161772859179008/photo/1 What else can I do? On Nov 14, 7:09 pm, Kemes, Lisa lisa.ke...@te.com wrote: We actually create an HTML file in the AR System Email Templates form, then refer to the html name in the Content, Header or Footer field on the Templates tab of the filter. We never did it the way you are doing it.. Thanks! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Monday, November 14, 2011 12:20 PM To: arsl...@arslist.org Subject: How to use an HTML template? Hello there, I've read the BMC Remedy Email Engine Guide but I'm not really getting it. I want to send an Email and use an HTML template to do it. The only thing that arrives in my mailbox is: --=_Part_1933319_8646463.1321290438759-- HERE IS WHAT I TRIED: I created a simple form and attached a filter to it. It fires when the status changes. I created one record. Here the field Short Description contains the name of the Template in the AR System Email Template: html head meta http-equiv=Content-Language content=en-us meta http-equiv=Content-Type content=text/ html;charset=windows-1252 titleLighthouse/title /head body pfont face=Arial Black RequestID: #$$Request-ID$$#/font/p pfont face=Arial Black Status: #$$Status$$#/font/p /body /html And the $Short Description$ variable is entered into the Content field in the notify action. Now, I'm really not sure what I have to put into the Text field in the Notify action of the filter and since I have the template - why do I have to put into this field? The template contains my content, right? If I still have to put something into the Text field (Apparently I can't leave this thing empty) then in what format? Also, do I have to select any fields from the list Include fields? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
Yeah, that is normal. On the Email Message record you have there, go to Advanced Options-- Templates and make sure you see your template named there,and make sure it matches one of the available templates in the dropdown menu on that field (*just in case*). Unfortunately it is. It named here and it matches. Also, check the Variable Replacement tab and check the Field Values. You should see all the mapped variables. Yes, here everything looks perfect! I suppose you could look at the errors tab too, but I doubt there are any errors there. This one is empty. No errors. Oh yeah, you *did* create the template as an html file, and attach it to the Email Template form entry, right? Double check it is indeed attached in the attachment pool? *grasping* It is, see here: http://twitter.com/?photo_id=1#!/MarkMilke/status/136161772859179008/photo/1 I even tried to delete it, save it and add it again. It's still not workig. Is there any debug I can turn on to figure you what it's missing? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL ?
For Date fields in remedy if you are using Oracle I have used this feature of oracle for several views into Remedy data and it has worked well for me. TO_DATE(START_DATE,'J') The J converts the value to a Julian date which matches up with Remedy Date types. Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Monday, November 14, 2011 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL ? ** Peter, Date fields count the number of days from the beginning of its range.( January 1, 4713 B.C.E. - January 1, C. E.) Date/Time fields count the number of seconds from the Unix epoch. (January 1, 1970 00:00:00 AM) I'm not brushed up on SQL statements but you could try to change the operator s to d(?) so it counts days instead of seconds. SELECT CONVERT(varchar(30),DATEADD(d,C3,'19700101'),101) FROM T2677 --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 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 Joran, Peter CTR WHS/ITMD/CACI Sent: Monday, November 14, 2011 1:12 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: SQL ? ** All I in the midst of creating a view for dashboards because I don't want to use Dashboards functions for performance reasons. I need to convert Date field from an integer value to mm/dd/ . Here is a sample of what I've tried. The Date 11/14/2011 = 2455880 The Statement SELECT CONVERT(varchar(30),DATEADD(s,C3,'19700101'),101) FROM T2677 Returns 01/29/1970 I need it to return 11/14/2011 Note that if use the same sql statement on a Date/Time field the return is 11/14/2011. Evidently, I'm missing something but I'm not sure what. Any thoughts? Thanks Pete _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
BTW, on which tab of the AR System Templates are you adding you HTML templates? * Template Information * Template Attachments ? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: IBRSD Plug-in Error
Mike, When you say you have the individual host names do you also have the load balanced name also? I think you may need the load balanced name configured for SERVER_NAME. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Ziniti Sent: Monday, November 14, 2011 1:44 PM To: arslist@ARSLIST.ORG Subject: Re: IBRSD Plug-in Error It is load balanced and in the ar.cfg file we have the individual host names and on BEM side we have it pointing to the LB name. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Err or-tp6993491p6993578.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL ?
If you are working in SQL Server (2000 or later), the following UDF will do the trick: ALTER FUNCTION [dbo].[fnGetRemedyDateOnly](@Days int) RETURNS datetime AS BEGIN DECLARE @BaseDate datetime DECLARE @TargetDate datetime SET @BaseDate='1900-01-01' SET @TargetDate=dateadd(dd,@Days - 2415021,@BaseDate) RETURN (@TargetDate) END ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
I just add the template to the template information tab. Then I add the name of the template to the content field: (in your case it would be Formtest) [cid:723355919@14112011-301F] Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: Outlook.jpg
Re: How to use an HTML template?
Thanks for the screenshot Lisa. I did the exact same thing. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL ?-RESOLVED
Very close This is what worked. SELECT CONVERT(varchar(30),dateadd(day, (C536870928 - 2361331), '1/1/1753'),101)FROM T2677 Reference Tim Widowfields ARS post for the explanation. http://www.javasystemsolutions.com/arslist/view/5761 Many thanks to all! Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Monday, November 14, 2011 1:57 PM To: arslist@ARSLIST.ORG Subject: Re: SQL ? ** Peter, Date fields count the number of days from the beginning of its range.( January 1, 4713 B.C.E. - January 1, C. E.) Date/Time fields count the number of seconds from the Unix epoch. (January 1, 1970 00:00:00 AM) I'm not brushed up on SQL statements but you could try to change the operator s to d(?) so it counts days instead of seconds. SELECT CONVERT(varchar(30),DATEADD(d,C3,'19700101'),101) FROM T2677 --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 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 Joran, Peter CTR WHS/ITMD/CACI Sent: Monday, November 14, 2011 1:12 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: SQL ? ** All I in the midst of creating a view for dashboards because I don't want to use Dashboards functions for performance reasons. I need to convert Date field from an integer value to mm/dd/ . Here is a sample of what I've tried. The Date 11/14/2011 = 2455880 The Statement SELECT CONVERT(varchar(30),DATEADD(s,C3,'19700101'),101) FROM T2677 Returns 01/29/1970 I need it to return 11/14/2011 Note that if use the same sql statement on a Date/Time field the return is 11/14/2011. Evidently, I'm missing something but I'm not sure what. Any thoughts? Thanks Pete _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: IBRSD Plug-in Error
does the server listed have a dns record? or if on solaris /etc/hosts file needs to have something.. On Mon, Nov 14, 2011 at 2:37 PM, Chowdhury, Tauf tauf.chowdh...@frx.comwrote: Mike, When you say you have the individual host names do you also have the load balanced name also? I think you may need the load balanced name configured for SERVER_NAME. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Ziniti Sent: Monday, November 14, 2011 1:44 PM To: arslist@ARSLIST.ORG Subject: Re: IBRSD Plug-in Error It is load balanced and in the ar.cfg file we have the individual host names and on BEM side we have it pointing to the LB name. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/IBRSD-Plug-in-Err or-tp6993491p6993578.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
I just rebooted the Email Engine and it started working... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
It's strange, but it looks like I have to restart the Email Engine every time a change the HTML Template. Is this because we're running a Server Group? Is this normal? Anyway, I have one more question or problem I discovered now. The app I'm working with is build on a Display Only form. So when the user presses a button I do a Push (Submit) on the Display Only form to trigger the filters, which in turn run on table field to prepare data for the Emails. When working without Email templates this works just fine, i.e. I can use variables in the notification and they get filled out. However when using HTML templates it looks like the variables are empty... The Email Engine uses my template but there is no data in it. It seems like the Email engine does fill out the template immediately but later on and since this is not a regular form it cannot find the data to fill out the template. Is this correct? Mark On Nov 14, 9:23 pm, Mark Milke mark_mi...@yahoo.com wrote: I just rebooted the Email Engine and it started working... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How to do a line break and a tab?
Hello there, I'm looping through a table field and to put together a list of users like this: Character Field 1 = $Character Field 1$ + here a break + $Tbl_Col_1$ + + $Tbl_Col_2$ + + $Tbl_Col_3$ Then I'm sending Character Field 1 via Email but outlook removes the breaks somehow. Is there a way I can force the line breaks here? Also how can I use a tab instead of between the columns? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
Mark, From the email engine guide (v7.1) *When the email engine starts, it retrieves all the entries in the AR System Email Mailbox Configuration form and creates incoming and outgoing mailboxes. Every 30 minutes, the email engine automatically queries the form for changes to the form entries and updates the information. To enable changes to form entries before the next default query time, stop and restart the email engine. To shorten the default time interval in the EmailDaemon.properties file, set the polling parameter. For example, shorten the time to 5 minutes: com.bmc.arsys.emaildaemon.AR_System_server_name.Interval = 5 For more information about this property or the EmailDaemon.properties file, see “Performance and configuration settings” on page 198.* As far as your 2nd issue, Filters + Table Walk + data weirdness = Phasing Issues. Have you checked into that? Thad On Mon, Nov 14, 2011 at 1:01 PM, Mark Milke mark_mi...@yahoo.com wrote: It's strange, but it looks like I have to restart the Email Engine every time a change the HTML Template. Is this because we're running a Server Group? Is this normal? Anyway, I have one more question or problem I discovered now. The app I'm working with is build on a Display Only form. So when the user presses a button I do a Push (Submit) on the Display Only form to trigger the filters, which in turn run on table field to prepare data for the Emails. When working without Email templates this works just fine, i.e. I can use variables in the notification and they get filled out. However when using HTML templates it looks like the variables are empty... The Email Engine uses my template but there is no data in it. It seems like the Email engine does fill out the template immediately but later on and since this is not a regular form it cannot find the data to fill out the template. Is this correct? Mark On Nov 14, 9:23 pm, Mark Milke mark_mi...@yahoo.com wrote: I just rebooted the Email Engine and it started working... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to do a line break and a tab?
Outlook automatically tries to do its own cleanup of data. Each user has control on turning it on and off. Tools - Options - Preferences - E-mail Options button Remove Extra line breaks in plain text messages Here is a little know trick for Outlook. Outlook will not remove the extra line break if it is preceded by 3 spaces (so you need to put 3 spaces at the end of the lines you don't want Outlook to join together). As for a tab character, when you are building your string you can copy a tab character from Notepad and place it between the Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mark Milke Sent: Monday, November 14, 2011 3:09 PM To: arslist@ARSLIST.ORG Subject: How to do a line break and a tab? Hello there, I'm looping through a table field and to put together a list of users like this: Character Field 1 = $Character Field 1$ + here a break + $Tbl_Col_1$ + + $Tbl_Col_2$ + + $Tbl_Col_3$ Then I'm sending Character Field 1 via Email but outlook removes the breaks somehow. Is there a way I can force the line breaks here? Also how can I use a tab instead of between the columns? Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to use an HTML template?
** Well, he does mention it works fine with a regular email, so I don't think phasing issues would *only* affect HTML templates. I don't think I've ever tried what he's doing, either. Mark, you might just have to paste your fields into a normal form and try what you're doing there. It shouldn't be too painful if that is the only solution, right? Brien On 11/14/2011 2:18 PM, Thad Esser wrote: ** Mark, From the email engine guide (v7.1) When the email engine starts, it retrieves all the entries in the AR System Email Mailbox Configuration form and creates incoming and outgoing mailboxes. Every 30 minutes, the email engine automatically queries the form for changes to the form entries and updates the information. To enable changes to form entries before the next default query time, stop and restart the email engine. To shorten the default time interval in the EmailDaemon.properties file, set the polling parameter. For example, shorten the time to 5 minutes: com.bmc.arsys.emaildaemon.AR_System_server_name.Interval = 5 For more information about this property or the EmailDaemon.properties file, see “Performance and configuration settings” on page 198. As far as your 2nd issue, Filters + Table Walk + data weirdness = Phasing Issues. Have you checked into that? Thad On Mon, Nov 14, 2011 at 1:01 PM, Mark Milke mark_mi...@yahoo.com wrote: It's strange, but it looks like I have to restart the Email Engine every time a change the HTML Template. Is this because we're running a Server Group? Is this normal? Anyway, I have one more question or problem I discovered now. The app I'm working with is build on a Display Only form. So when the user presses a button I do a Push (Submit) on the Display Only form to trigger the filters, which in turn run on table field to prepare data for the Emails. When working without Email templates this works just fine, i.e. I can use variables in the notification and they get filled out. However when using HTML templates it looks like the variables are empty... The Email Engine uses my template but there is no data in it. It seems like the Email engine does fill out the template immediately but later on and since this is not a regular form it cannot find the data to fill out the template. Is this correct? Mark On Nov 14, 9:23 pm, Mark Milke mark_mi...@yahoo.com wrote: I just rebooted the Email Engine and it started working... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: BMC's Future on the horizon.. IMHO
Where do I go to turn this off? 5) Go to the System config settings and set the option that turns off the use of Flash for these three capabilities – you will not get rounded corners, vertical text, or gradient colors but you will not loose any other functionality or capability within the system. It is a cosmetic affect -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: Friday, November 11, 2011 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: BMC's Future on the horizon.. IMHO And of course you're making the assumption we have control over the items in your workaround. Quite often we don't. - Original Message - From: Doug Mueller doug_muel...@bmc.com To: arslist@ARSLIST.ORG Sent: Friday, November 11, 2011 1:53:35 PM Subject: Re: BMC's Future on the horizon.. IMHO ** Everyone, What Chris describes here is a new discovery that is unique to IE9 where something has changed in the IE implementation. As part of the model that BMC uses for the AR System, we support the specified versions of products or later. In this case, IE9 was not available when the current version was released (7.6.04 was released in January 2011 and IE9 in March 2011). The product is fully functional with IE9. However, we have discovered an interaction issue that causes a performance problem with IE9. We are working with both Microsoft and Adobe on this issue to see if can be resolved. In addition, some redesign of the approach has mostly eliminated the problem from the next major release (but that strategy cannot be backported to the current release). So, enough of the overall philosophy, let's look at this situation. There are a number of UI features that we added in recent releases. Some of them were not supported on specific browsers so we had to find alternatives for supporting the capability. Specifically, there are three features: rounded corners, gradient colors, and vertical text. These three capabilities could not be supported in IE natively because the capability was not present. To allow these capabilities, we incorporated the use of Flash for IE. All of the other browsers – Safari, Firefox, and even the other used but unsupported browsers like Chrome – have the necessary support. So, the workaround was used only for IE environments. Everything works fine for IE6, IE7, and IE8 but with IE9, something has changed so that there is now a performance cost for the workaround. This is what we are working to find out what the issue is with the other vendors. Now, there are several options: 1) The performance issues is not really affecting you so do nothing 2) Use a browser other than IE 3) Use a version of IE before IE9 (for example, use IE8) 4) Use FlashPlayer 10.2 or earlier (the problem has been isolated to the combination of IE9 using FlashPlayer 10.3, or later unless a fix is added later) 5) Go to the System config settings and set the option that turns off the use of Flash for these three capabilities – you will not get rounded corners, vertical text, or gradient colors but you will not loose any other functionality or capability within the system. It is a cosmetic affect So, in summary…. This may affect you ONLY IF you n Run IE9 as your browser n Use FlashPlayer 10.3 or later n Leave the system config setting to use Flash for these features turned on (the default) Otherwise, this issue does not have any affect on your system. And, it will affect only users that have this combination as their client – other users on the same system without this combination will not be affected. There are several options (which may or may not be possible in your environment) to eliminate the problem immediately. BMC is continuing to work with the vendors on this problem to see we can find out why the problem suddenly showed up with this combination of technology and to see if we can eliminate the issue from future releases with alternate designs or approaches. I hope this explanation has been helpful both for this specific issue and to show a case in action of the or later support strategy. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Wednesday, November 09, 2011 10:39 AM To: arslist@ARSLIST.ORG Subject: Re: BMC's Future on the horizon.. IMHO ** We can hope; the dialog performance problems that we have been experiencing on production with ITSM 7.6.04.01 Incidents in IE9 have now been tracked down specifically to flash, and confirmed in my testing. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent:
Re: Email Error Message 362
Mark: You might also check whether /var/tmp is out of space. --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza [jdso...@shyle.net] Sent: Monday, November 14, 2011 13:39 To: arslist@ARSLIST.ORG Subject: Re: Email Error Message 362 ** Have you checked the permissions of the file it is trying to attempt to open? You may have started the AR System as a different user leaving the file inaccessible to the current user that started the AR System. Joe From: Brittain, Markmailto:mbritt...@navisite.com Sent: Monday, November 14, 2011 11:09 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Email Error Message 362 ** Good Morning, Has anyone seen an error message like this in the AR System Email Error Logs? I have a couple of these and the numbers between RED and TMP are different. The mailbox is in the /var/mail directory. Mailbox Name: Out_Going Message Type: Severe Message Number: 362 Message Text: Cannot find/open the directory file /var/tmp/RED6550561TMP ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are