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:[email protected]] On Behalf Of Misi Mladoniczky
> Sent: Monday, November 14, 2011 11:05 AM
> To: [email protected]
> 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:[email protected]] On Behalf Of Misi Mladoniczky
>> Sent: Monday, November 14, 2011 10:49 AM
>> To: [email protected]
>> 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"