Well...I've never done this myself...but you are in luck...with Join Forms you don't have T and H's
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kendhammer, Mike Sent: Monday, May 07, 2007 12:51 PM To: [email protected] Subject: Manual Removal of Forms from Database Hi, Without going into a long story here, I try to explain the aftermath... I have a number of Join forms that appear to have been corrupted. The view and corresponding record in the ARSCHEMA table exist, yet they do not appear in the Admin Tool. (Yes, I did check that the 'By Form' filter was set to All Forms...:-) ) They don't compile, thus underlying tables have been altered or are gone. I do see an error in the arerror.log file stating "The form definition file field count does not match number of fields in the file (ARERR 403)" then the form name. I need to know besides dropping the T and H tables and deleting the records from the ARSCHEMA table, what other tables need to be updated or dropped? It looks like records in many of the 'FIELD*' tables may need to be updated as well. I no longer need these join forms, thus I don't need to worry about restoring them. We are running ARS 6.3.0 patch 20 on HP-UX 11i/Oracle 9i. If anyone has gone through the process of manually removing tables within ARS, I'll like to hear your comments or see any notes/steps you may have or gone through to do it. Thanks! Mike K. American Standard/Trane ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
