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 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
