I would export tables Import into another db , hook up an ars and clean it up.
Sent from my iPhone so typo's or funky words can and do happen! On Oct 14, 2011, at 3:13 PM, JD Hood <hood...@gmail.com> wrote: > ** Having a really weird issue at a client where, when you restart the AR > Server service (not every time, but at random nth restarts)... > - Random forms fail to load in the server (won't list in client & won't list > in the Admin tool, but T,H,B tables are still there with data) > - Random fields vanish on forms > - All guides (filter & active link) fail to load > - could be some other probs, but we didn't look as we have our hands full > dealing with the first three > > The first time this occurred, we found that the numfields value in ARSCHEMA > table did not agree with the rowcount in the FIELD table for some CMDB forms > (AST: forms). The problem has occurred three times over as many weeks and > restoring the DB from backup each time it happens is not feasible as along > term resolution -- we need to figure out the root cause. The site is secure > and sharing logs, screenshots or webexing is not allowed, so troubleshooting > is problematic. > > I mentioned the symptoms to a colleague and it prompted a vague memory of > some issue between an earlier version of ARS and Oracle-RAC, even though the > versions were listed as compatible. BMC support can't find any mention and so > far (considering the site security restrictions) have only been treating the > symptoms. BMC support seems to think the problem is running multiple class > manager jobs at the same time, but we aren't doing that. The last time it > happened, the system came back up with a *bunch* of corrupted forms (bad > field counts between arschema and field tables for a variety of forms) and a > "change pending" class manager job showed up out of nowhere -- before system > restart, we weren't doing anything in class manager / class manager was idle. > > In trying to make sense of this, I can only imagine that ARS starts up and > connects to the Oracle-RAC cluster in such a screwed-up fashion that it > either retrieves (or causes RAC to return) pieces of the database from > different points in time -OR- skips parts of the DB -OR- the Oracle-RAC > cluster is not keeping itself in sync like we think -OR- > <heck-if-i-know-feel-free-to-guess>. All I can say is I've never encountered > the behavior before and it's beyond weird. > > Two questions: > 1. Disregarding the issues I've mentioned, does anyone recall ANY (and I mean > *any*) issues between Oracle-RAC and any version of ARS? It's the only clue > we have at this point and I'm grasping at straws. > > 2. Has anybody experienced the described weirdness, regardless of ARS version? > > Thanks, > JDHood > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"