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