Re: Server Slow Down
Having lots of records is a sign but I would look for any records that have a status of pending and the modified date is quite a while ago. Remember that this plugin is really just designed as a client. So the workflow can pass off work that may take time that you don't want users to look at their screen and wait for. Old remedy heads will compare to the rapp service. So make sure you have a private queue set and modify the cai plugin registry form to reflect the rpc number and the number of threads. Finally, enable arplugin logging to see what its doing. And depending on what version you have, depends on whether it's a java or c plugin. Kind regards Danny Sent from my iPad On 11 Oct 2011, at 03:21, Patrick Zandi wrote: > ** > I had 768000, what you have is tiny. Sounds normal. I am not positive you > have my issue. > > Sent from my iPhone so typo's or funky words can and do happen! > > On Oct 10, 2011, at 10:12 PM, "Boyd, Rebecca" wrote: > >> ** 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 >> 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 >> stuart.sc...@au.fujitsu.com >> au.fujitsu.com >> >> >> >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza >> Sent: Tuesday, 11 October 2011 06:04 >> To: arslist@ARSLIST.ORG >> 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" 0407386, 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 >> >> Sent: Monday, October 10, 2011 2:52 PM >> >> Newsgroups: public.remedy.arsystem.general >> >> To: arslist@ARSLIST.ORG >> >> 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" 0407386 >> >> 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 >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Server Slow Down
That’s a normal count.. What I meant by high water mark is not the actual record count. It has very little to do with the record count but more to do with insert transactions on that table. Insert transactions continuously raises the water mark on a table, and deletes does not drop it. So on high transaction tables where there are high number of insert and delete transactions, it’s a good idea to keep a periodic eye on the HWM of that table.. Just something you might want to check on as you may possibly be running short on disk space where that table resides.. Joe From: Boyd, Rebecca Sent: Monday, October 10, 2011 10:12 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Server Slow Down ** 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 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 stuart.sc...@au.fujitsu.com au.fujitsu.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, 11 October 2011 06:04 To: arslist@ARSLIST.ORG 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" 0407386, 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 Sent: Monday, October 10, 2011 2:52 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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" 0407386 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 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Server Slow Down
This points to plugin which makes me think of ram. Are you using swap on you system? Do you have Alot of queues and not so much ram on server? I. E. 8 gig of ram Is oracle and application and flag and apache all on one box? Just thinking Sent from my iPhone so typo's or funky words can and do happen! On Oct 10, 2011, at 3:03 PM, Joe Martin D'Souza wrote: > ** > > 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" 0407386, 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 > Sent: Monday, October 10, 2011 2:52 PM > Newsgroups: public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > 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" 0407386 > > 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Server Slow Down
I had 768000, what you have is tiny. Sounds normal. I am not positive you have my issue. Sent from my iPhone so typo's or funky words can and do happen! On Oct 10, 2011, at 10:12 PM, "Boyd, Rebecca" wrote: > ** 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 > 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 > stuart.sc...@au.fujitsu.com > au.fujitsu.com > > > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza > Sent: Tuesday, 11 October 2011 06:04 > To: arslist@ARSLIST.ORG > 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" 0407386, 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 > > Sent: Monday, October 10, 2011 2:52 PM > > Newsgroups: public.remedy.arsystem.general > > To: arslist@ARSLIST.ORG > > 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" 0407386 > > 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 > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Server Slow Down
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 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 > stuart.sc...@au.fujitsu.com > au.fujitsu.com > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza > *Sent:* Tuesday, 11 October 2011 06:04 > *To:* arslist@ARSLIST.ORG > *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" 0407386, 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 > > *Sent:* Monday, October 10, 2011 2:52 PM > > *Newsgroups:* public.remedy.arsystem.general > > *To:* arslist@ARSLIST.ORG > > *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" 0407386 > > 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"
Re: Server Slow Down
This is a bug: I would contact support! Sys:action should be low and remain low... I had this same issue: support will give you2 little definitions a couple of escalations and modified filters If it is the same as me. Sent from my iPhone so typo's or funky words can and do happen! On Oct 10, 2011, at 3:03 PM, Joe Martin D'Souza wrote: > ** > > 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" 0407386, 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 > Sent: Monday, October 10, 2011 2:52 PM > Newsgroups: public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > 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" 0407386 > > 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Server Slow Down
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 stuart.sc...@au.fujitsu.com <mailto:stuart.sc...@au.fujitsu.com> au.fujitsu.com <http://au.fujitsu.com> From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, 11 October 2011 06:04 To: arslist@ARSLIST.ORG 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" 0407386, 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 <mailto:boy...@wfu.edu> Sent: Monday, October 10, 2011 2:52 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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" 0407386 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
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" 0407386, 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 Sent: Monday, October 10, 2011 2:52 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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" 0407386 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
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" 0407386 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"