Re: ARGetMultipleCurrencySetRatios X a zillion
Nope. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: Wednesday, August 13, 2008 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion ** William, Have any Currency Ratios actually been defined on the system? Janie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, August 13, 2008 12:31 PM To: arslist@ARSLIST.ORG Subject: ARGetMultipleCurrencySetRatios X a zillion I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
I am pretty sure the performance problem is unrelated. I'll post more on that later today after I chase it down. It's been an interesting nut to crack. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:14 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you elaborate on this? we are having performance problems Anything specific? Any examples? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
William, I have seen some problem occur, even in 7.1, if currencies aren't defined in any way. I would make sure that you at least have default currencies defined. Rick On Thu, Aug 14, 2008 at 8:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
Are there currency fields on the form that the user is opening? Axton Grams On Thu, Aug 14, 2008 at 11:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
It's ITSM - I'll just assume there are. Plus we are using SLM which does all that costing analysis if you want it to so I know it has related currency values, etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 14, 2008 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Are there currency fields on the form that the user is opening? Axton Grams On Thu, Aug 14, 2008 at 11:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion - RESOLVED
DING! DING! WINNER! Issue resolved. We didn't have a default currency defined even though we are not doing anything remotely related to money in the app. Ironic, considering I'm working at a Federal agency's accounting service center. I went from 509 calls in a very short time to 71 in 20 minutes or so. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, August 14, 2008 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion ** William, I have seen some problem occur, even in 7.1, if currencies aren't defined in any way. I would make sure that you at least have default currencies defined. Rick On Thu, Aug 14, 2008 at 8:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
I wouldn't worry about these. These look like the mid-tier logs, which don't show which queue is in use, but I don't think these are anything to worry about. Speculating here, but if you have currency fields, it would make sense that it would pull the conversion ratios at the time some currency data is returned to provide the proper currency values. Axton Grams On Thu, Aug 14, 2008 at 1:44 PM, William Rentfrow [EMAIL PROTECTED] wrote: It's ITSM - I'll just assume there are. Plus we are using SLM which does all that costing analysis if you want it to so I know it has related currency values, etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 14, 2008 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Are there currency fields on the form that the user is opening? Axton Grams On Thu, Aug 14, 2008 at 11:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
I've seen this type of API logging every time the Default and Actual Cost values are set on the Financial tab -- specifically Incident (b/c it's used heavily), but it could occur anywhere. The workflow sets the Cost fields to $DEFAULT$ and then sums the Cost from the table. The Active Links seem to have a Currency Conversion function in the setting of the field -- but the calls occur whether or not the Conversion function is used. For what it's worth, I did set up some default currency ratios and didn't see any change in API logging. I also have defaults set for the fields and the API still calls for the ratios. I know this doesn't actually solve the issue but just wanted to post it in the event that it helps William with the recreation of the issue and helps anyone figure out where the issue really is. Personally, I would think it's a bug--that the setting in ar.cfg is being disregarded but I have no way proving that. Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 14, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Are there currency fields on the form that the user is opening? Axton Grams On Thu, Aug 14, 2008 at 11:54 AM, William Rentfrow [EMAIL PROTECTED] wrote: Here's a snippet of what's happening - User ID's and IP addresses removed (XX, 1.1.1.1 are not real obviously): /* Wed Aug 13 2008 12:50:07.6113 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6517 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:07.6983 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 /* Wed Aug 13 2008 12:50:16.0895 */+GMCRS ARGetMultipleCurrencyRatioSets -- as user XX from Mid-tier (protocol 13) at IP address 1.1.1.1 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 13, 2008 8:12 PM To: arslist@ARSLIST.ORG Subject: Re: ARGetMultipleCurrencySetRatios X a zillion Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
Can you post an entry from the api logs for one of the calls? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARGetMultipleCurrencySetRatios X a zillion
Can you elaborate on this? we are having performance problems Anything specific? Any examples? Axton Grams On Wed, Aug 13, 2008 at 3:31 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I have been troubleshooting an unrelated problem. In 40 minutes of server side logging I have 509 instances of this API call happening. Each one is about 4/1000 of a second long or a total of 2 seconds of time in 40 minutes = 3 seconds of time an hour. Granted this is very small - but I am in a large environment and we are having performance problems. Every one that can be solved will be. However, I am not too familiar with what controls this API call. Since we are doing zero financials and no foreign currency this call is not (strictly speaking) needed. The server configuration guide (7.1) says the Currency Ratio Cache Refresh Interval is the setting to change for this. It's defaulted to 60 seconds meaning each client will check the ratios once every minute. This makes complete sense to me if you are dealing in any financials with foreign currency. However, I can see in the logs that this API call happens a LOT more than every 60 seconds- like every few seconds during a save of an Incident for example. It's called 4 times in 13 seconds for the same user (and 3 of those are in the span of 1/10 of a second) in one example and this just seems pointless. Anyone know how to slow this down to something more like once an hour per user? It's overkill X a zillion right now. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
