So, I have 364 records in CAI:Events and 3,353 records in SYS:Action. I take it this is not a good thing?
On Mon, Oct 10, 2011 at 6:56 PM, Schon, Stuart <[email protected]>wrote: > ** > > Check the CAI Event table for a stuck record, I have seen that as an issue > several times leading to the plugin being unable to start. It should be > empty. Any record there is transitory like sys:action**** > > ** ** > > *Stuart Schon** > **Team Leader** > > **Fujitsu Australia Limited* > 2 Julius Avenue, North Ryde NSW 2113, Australia > *T* +61 2 9113 9435 *M* +61 458 592 245 > [email protected] > au.fujitsu.com > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Joe Martin D'Souza > *Sent:* Tuesday, 11 October 2011 06:04 > *To:* [email protected] > *Subject:* Re: Server Slow Down**** > > ** ** > > ** **** > > **** > > So although the SYS:Action table has workflow to delete the processed > records that are no longer needed on that table using as in that example, > Application-Delete-Entry "SYS:Action" 000000000407386, it has no way to > lower the high water mark caused by the continuously growing table.. Over > time that table is likely to occupy a lot of disk space although the number > of entries in the table may be quite low.**** > > **** > > I’m guessing that may be one of the problem.**** > > **** > > Ask your DBA to check into that and see if that’s the problem’..**** > > **** > > Joe**** > > **** > > **** > > **** > > *From:* Boyd, Rebecca <[email protected]> **** > > *Sent:* Monday, October 10, 2011 2:52 PM**** > > *Newsgroups:* public.remedy.arsystem.general**** > > *To:* [email protected] **** > > *Subject:* Server Slow Down**** > > **** > > ** Everyone, > > I recently had an issue where performance became very poor and didn't learn > about the problem in time to capture any logs. However, I saw the following > repeated in the arerror.log: > > 390620 : The AR System Plug-In server is not responding. Cannot connect to > the system at this time. Contact your AR System Administrator for > assistance. (ARERR 8939) > Failure during an attempt to perform an application command (ARERR 4554) > Application-Delete-Entry "SYS:Action" 000000000407386 > > ARS 7.5.00 Patch 003 > ITSM 7.5.01 patch 001 > SLM 7.5.00 patch 001; > SRM 7.6, patch 2 > Windows 2008 Enterprise > Oracle 11g > > Any ideas of what was happening or where to look should this happen again? > > > -- > Rebecca Boyd > Application Administrator > Wake Forest University > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Rebecca Boyd Application Administrator Wake Forest University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
