It looks as though the error may be being thrown during server startup as the server loads the metadata to create the cache. I've seen similar issues where the problem was a view form which was referencing a db table which had been removed. Do you have any view forms where this may be the case - a table accessed via a db link for example?
Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: 24 September 2015 20:23 To: arslist@ARSLIST.ORG Subject: Re: How does one track down a missing or broken DB table (ARERR 481)? ** 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 <rwestbr...@24hourfit.com<mailto:rwestbr...@24hourfit.com>> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ LongWing Sent: Thursday, September 24, 2015 8:45 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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 <rwestbr...@24hourfit.com<mailto:rwestbr...@24hourfit.com>> 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_ _ARSlist: "Where the Answers Are" and have been for 20 years_ BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
