I´m I updated the main chg form in ITSM 7 in arschema to start over with nextid, no problem with that.
-- Jarl On 5/8/07, Axton <[EMAIL PROTECTED]> wrote:
If you update arschema, the record will have an invalid checksum in the safeguard column, and you will be in the same boat. You used to be able to do this with 5.x servers and earlier, but since 6.x, you can no longer take this approach. Axton Grams Name Null? Type ------------ -------- ------------- NAME NOT NULL VARCHAR2(254) SCHEMAID NOT NULL NUMBER(15) SCHEMATYPE NOT NULL NUMBER(15) TIMESTAMP NOT NULL NUMBER(15) OWNER NOT NULL VARCHAR2(254) LASTCHANGED NOT NULL VARCHAR2(254) COREVERSION NOT NULL NUMBER(15) NUMFIELDS NOT NULL NUMBER(15) NUMVUIS NOT NULL NUMBER(15) DEFAULTVUI NOT NULL VARCHAR2(254) NEXTID NOT NULL NUMBER(15) NEXTFIELDID NOT NULL NUMBER(15) MAXSTATENUMS NOT NULL NUMBER(15) UPGRDVERSION NUMBER(15) SAFEGUARD NOT NULL VARCHAR2(254) HELPTEXT CLOB CHANGEDIARY CLOB OBJPROP CLOB VERSION VARCHAR2(32) SMOBJPROP CLOB On 5/8/07, Kendhammer, Mike <[EMAIL PROTECTED]> wrote: > 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" > _______________________________________________________________________________ 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"
