Could you take a def file and then import in place?
Joe
--------------------------------------------------
From: "Rabi Tripathi" <[email protected]>
Sent: Friday, October 15, 2010 5:12 PM
Newsgroups: public.remedy.arsystem.general
To: <[email protected]>
Subject: How to recreate missing view of a form? ARs 6.3, Oracle 10g
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"
