Rabi, That's a good point and while that may be one of the reasons why this error is occurring..
However since you say the view is missing altogether, that error may be possibly occurring during the creation of the view. I do not recall if the DROP and CREATE of a view are two separate statements or combined into a single statement as CREATE or REPLACE. If the DROP is issued independently, that is why you must be facing that error, as there is no view to drop. So just to trick the system, why don't you just create a view with the name it expects. Or even better if you have a previous snapshot of the database, just import that view using imp from a previous Oracle dump that contains that view definition, since you are on Oracle. Even if that view contains fields that are not currently in that form, it will import with errors.. As long as you get the view in, its all that matters.. If you do not have a previous oracle dump to bring that view in from, then use the statement.. CREATE view HPD_HELPDESK as select * from Tnnn; commit; nnn is a table number, preferably the Help Desk form, but it doesn't matter as you just want a view there by that name so the system can drop it.. After that, try to modify the form.. Joe From: Jason Miller Sent: Sunday, October 17, 2010 5:31 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: How to recreate missing view of a form? ARs 6.3, Oracle 10g ** Usually when I have seen an error about not being able to create a db view it was because there is a field with the name of a database keyword. I have seen this happen many times when somebody adds a field called 'function'. Jason On Oct 15, 2010 2:13 PM, "Rabi Tripathi" <[email protected]> wrote: > Hi all, for unknown reason the usual HPD_HELPDESK view for my HPD:Helpdesk > form is missing. I tried resaving the form, adding a data field and saving > etc to recreate the view, but no luck. On adding a field and saving, get the > usual error about sql view not being in place: > Field : Modified Time: > Creation of one of the SQL views for the form failed within the SQL database. > Operation completed successfully, but the SQL view is not in place. (ARERR > 69). > > Any ideas on recreating the view? I have some scripts reading directly from > this view, so it's a problem not to have this view. > > I though I could go to another server and do this > > select text from all_views where view_name = 'HPD_HELPDESK'; > > and use the resulting text to manually recreate this oracle view on this > server, but no luck so far. The "text" column is so long I am trouble having > all the text show up on sqlplus, no matter how I play with the display > settings. > > I though SQL log would show me the statement using which ARS is trying to > create the view, but can't locate it. > > What changed recently? Hmm a lot. Migrated from oracle 9i to 10g. Not sure if > the issue began right after that or later. > > TIA. > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
