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"
