Thanks for the response. This has been identified as a defect SW00266125. We applied couple of def files (provided by BMC) and ran an escalation to update some existing incidents. That has resolved our issue.
Atul Vohra -----Original Message----- From: "Kelly Deaver" [kdea...@kellydeaver.com] Date: 06/06/2010 02:03 PM To: arslist@ARSLIST.ORG Subject: Re: SYS:Action has too many records ** We had the same issue and filed an incident with BMC. They had us use a SQL statement to delete all the records. To delete them manually or with an escalation would supposedly result in other issues. I suggest you file a ticket with BMC and have them help you clean it properly. Once we did, they had us had some work flow related to SLM that stopped the problem we were having with too many records Kelly Deaver L-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail) kelly.ctr.dea...@faa.gov (Business mail) -------- Original Message -------- Subject: SYS:Action has too many records From: Atul Vohra <a...@protechsoftwareinc.com> Date: Sat, June 05, 2010 3:33 pm To: arslist@ARSLIST.ORG All, We have ARS 7.1 and am seeing 243K records in the SYS:Action form. I ran a query to find count of different Actions in the table: COUNT(*) ACTION 2 DLDVALIDATEFOUNDATION 3 STARTFOUNDATINLOAD 1018 CALLCAIPLUGIN 235169 UPDATESLMREASON 6465 CALCULATE_SLMDATES 3 INITIATEFOUNDATIONVALIDATION 1 INITIATEFOUNDATINLOAD 21 STARTFOUNDATIONVALIDATION 140 CHECKCMDBASSOC 145 INCUPDATEGROUPLIST 248 INCREMENT_NUM_TIX 105 DECREMENT_NUM_TIX 16 DLDLOADFOUNDATION I am not sure what is the purpose of this form but some of the records are really old and am tempted to delete them. Is there any paper that talks about the SYS:Action form? Any guidance will be appreciated. Atul Vohra _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"