Remedy View ValidationPretty normal behaviour, there is no actually a way to "modify" a view in the database sense of it - it is one entity, so you just have to replace/delete/add it. And there is no problem with it, unless you start renaming fields - that will change the names in the view as well. I dont think you have to add/remoive filed, it is triggered when the view entry in the vui table is updated, which may be caused by some more inocent changes. Finally, there are some gaps in the db view management, because some times the views are not updated as expected and the dba's complain of "orphan" views all the time.
Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: [email protected] Sent: Monday, February 22, 2010 3:03 PM Subject: Re: Remedy View Validation ** So, all that said, was this view just a view you created manually in the database? If so, I don't see Remedy actively doing anything to that view when you make changes to the underlying form. However, making changes to the underlying form could potentially invalidate the view, or make Oracle believe that it may no longer be valid. In that case, however, I would expect that the view would still be there in the database, just flagged as being broken. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, February 22, 2010 12:49 PM To: [email protected] Subject: Re: Remedy View Validation ** Views, it replaces.. It uses the syntax Create or Replace view as blah blah blah.. If present it just replaces - if absent it creates.. Tables like Rick says, it used to rename, create a new one, copy data from renamed table to new table, drop old.. Right now I'm not exactly sure what it does when you alter table, maybe it just issues the good old alter table statement?? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Rick Cook Sent: Monday, February 22, 2010 2:42 PM To: [email protected] Subject: Re: Remedy View Validation ** I cry BS, too. Remedy USED to drop forms when a field was deleted, but I don't think even that happens any more. Rick ---------------------------------------------------------------------------- From: Tommy Morris <[email protected]> Date: Mon, 22 Feb 2010 13:36:04 -0600 To: <[email protected]> Subject: Remedy View Validation AR 7.5p1 Oracle 11g We had a custom view built against HPD_Help Desk to facilitate external reporting. This view was recently dropped and then recreated by some "unknown entity" (I blame the kittens). When I asked our dba's about this they responded that the Remedy Application drops views and recreates them when a new field is added or moved around (customizing form views through Developer/ Admin tool). I of course cried BS but just wanted to ask the list; Has anyone seen where modifying a form causes database objects to drop and recreate? Tommy Morris _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
