I just searched through our PDF archive back to 3.0. The earliest match for the checkdb option was in the 7.5 docs.
I would expect that kind of thing to be captured in the sql log or at least one of the logs. I would try logging API, SQL, Filter, Escalation to the same log file and use LJ's ParseString utility to look for ARERR. If a match is found get the RPC ID and then run the log through the utility again looking for that RPC ID. Doing this has helped me so many times quickly find odd errors that would usually a pain to find (also works well for striping down server-side logs to a specific user prior to it being available in 9.0). Jason On Thu, Sep 24, 2015 at 11:14 AM Rick Westbrock <[email protected]> wrote: > ** > > I made the rookie mistake of not including my ARS version 7.1 in my > initial post. /facepalm > > > > LJ, I am not sure if that utility is available for 7.1 since one of the > command line parameters is the <ARSystemLicenseDir> which I don’t think > existed before version 7.5. I will still try to make it work though. > > > > Jarl, I did have SQL logging on but couldn’t find anything helpful. It > shows SQL Trace Log stopping at 07:39 (when I ran the restart script) and > starting at 07:43 but the string “err” isn’t even in the first minute of > the log (shown below) but the 481 error was logged in arerror.log at 07:41. > > > > *arerror.log* > > Thu Sep 24 07:41:28 2015 390600 : Requested database table not found. > Please check the spelling (table name is case-sensitive) (ARERR 481) > > > > *arsql.log* > > <SQL > <TID: 0000000000> <RPC ID: 0000000000> <Queue: Dispatcher> > <Client-RPC: 000000 > <USER:> /* Thu Sep 24 2015 07:39:27.8954 */SQL > Trace Log -- OFF > > <SQL > <TID: 0007362240> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Thu Sep 24 2015 07:43:18.1889 */SQL > Trace Log -- ON (AR Server 7.1.00 Patch 011 201007230200) > > <SQL > <TID: 0029207440> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER: > /* Thu Sep 24 2015 07:43:18.2519 */CONNECT > ARAdmin > > <SQL > <TID: 0029207440> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER: > /* Thu Sep 24 2015 07:43:18.3376 */SELECT > BANNER FROM V$VERSION > > > > > > -Rick > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *LJ LongWing > *Sent:* Thursday, September 24, 2015 8:45 AM > *To:* [email protected] > *Subject:* Re: How does one track down a missing or broken DB table > (ARERR 481)? > > > > ** > > Rick, > > I recommend this article :) > > > > > https://docs.bmc.com/docs/display/public/ars81/Running+the+database+consistency+checker > > > > On Thu, Sep 24, 2015 at 9:27 AM, Rick Westbrock <[email protected]> > wrote: > > ** > > A while back my development server started throwing ARERR 481 on startup > where the log only says "Requested database table not found. Please check > the spelling (table name is case-sensitive)". I was really disappointed to > see that it did not actually list the table with which it was having > problems since that seems like a logical piece of data to include in the > error message. > > > > I looked up the 481 error at https://www.rrr.se/cgi/arerrr to find that > not only could it be a missing table but it could also be that "the correct > column information (for example, the right number of columns) for the > external schema was not retrieved.". (I love that tool since it is a very > quick way of getting more details about system error codes.) > > > > The only thing I can think of that happened around the time the errors > started was maybe while working with a pair of tables (one regular, one > view) I borked up something and might have had to reimport one of the > forms. I am not sure if that was before or after the 481 errors started > appearing though. > > > > Does anybody have a good method of tracking down the table that is missing > or broken that might be throwing the error on startup? All of our apps work > fine including the forms that I fixed but I'm still getting the error. When > I first looked at this I did find a problem with a row in the arschema > table but that was resolved. > > > > > > -Rick > > > > *_________________________* > > > *Rick Westbrock *AppOps Engineer | IT Department > 24 Hour Fitness USA, Inc. > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
