Hi, I am just sending a note to let everyone know that my plan below seems to have worked successfully.
After updating the rows in the ARSCHEMA table and a stop/start of the system, the forms became visible again in the Admin tool. I then proceeded to delete those forms. I have not noticed any adverse side effects. Thanks for all the comments and suggestions! Mike -----Original Message----- From: Kendhammer, Mike Sent: Tuesday, May 08, 2007 10:22 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Manual Removal of Forms from Database Thanks for everyone's comments and suggestions. I think I have a plan and that is to follow KM-000000006374 as Supreet suggested and also BMC support suggested. My hope is that if I update the numfields column in the arschema table for each of the 31 join forms that I have that have gone bad, stop and re-start the arsystem, then these forms will become visible in the admin tool once again, and then I can at least delete them the standard way. Now I just need to figure out when to do this as I am leaving for DC tomorrow morning (a bus trip with 90 plus 5th graders!) and won't get back until Sunday, so looks like I won't be able to get to it until next week sometime. I think the system should be fine until then... Thanks! Mike -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Baird Sent: Tuesday, May 08, 2007 8:06 AM To: arslist@ARSLIST.ORG Subject: Re: Manual Removal of Forms from Database Good call Axton. That's the approach I've taken in the past for this same kind of thing. You may still need to remove the record for the join form in arschema and the view for the form if they still exist though. Aradmin.exe may not let you do the .def import if these still exist, even though they don't show up in aradmin. This approach does mean considerably less "hacking" of the DB. Not sure if anyone mentioned this yet, but be sure the AR Service or daemon is shutdown before doing such surgery or you may end up with an even bigger mess. Cheers, Richard -----Original Message----- From: Axton [mailto:[EMAIL PROTECTED] Sent: Monday, May 07, 2007 7:12 PM Subject: Re: Manual Removal of Forms from Database You may have better luck importing a def of the same form type and name into the server, then deleting that. That should keep your db clean if it will work. There are records in a lot of tables to clean up if you had any field fields, workflow, form views, etc. Axton Grams On 5/7/07, supreet gill <[EMAIL PROTECTED]> wrote: > Hi Mike, > Search for KM-000000006374 in the knowledgebase on the support site. > There is also a script attached to the KB for Oracle. > Regards > Supreet > --- "Kendhammer, Mike" > <[EMAIL PROTECTED]> wrote: > > > 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" > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ________________________________________________________________________ ____ ___ > 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" ________________________________________________________________________ _______ 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"
