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 recordsKelly DeaverL-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail)kelly.ctr.dea...@faa.gov(Business mail) Original Message Subject: SYS:Action has too many recordsFrom: Atul Vohra a...@protechsoftwareinc.comDate: Sat, June 05, 2010 3:33 pmTo: arslist@ARSLIST.ORGAll,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(*) ACTION2 DLDVALIDATEFOUNDATION3 STARTFOUNDATIONLOAD1018 CALLCAIPLUGIN235169 UPDATESLMREASON6465 CALCULATE_SLMDATES3 INITIATEFOUNDATIONVALIDATION1 INITIATEFOUNDATIONLOAD21 STARTFOUNDATIONVALIDATION140 CHECKCMDBASSOC145 INCUPDATEGROUPLIST248 INCREMENT_NUM_TIX105 DECREMENT_NUM_TIX16 DLDLOADFOUNDATIONI 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.orgattend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: SYS:Action has too many records - Resolved
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
SYS:Action has too many records
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 STARTFOUNDATIONLOAD 1018CALLCAIPLUGIN 235169 UPDATESLMREASON 6465CALCULATE_SLMDATES 3 INITIATEFOUNDATIONVALIDATION 1 INITIATEFOUNDATIONLOAD 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