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 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 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 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"**** > > ** ** > > _attend WWRUG12 www.wwrug.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.**** > > _attend WWRUG12 www.wwrug.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 > > > ************************************************************************************************************************* > _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"