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]<mailto:[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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
