Re: Timeout ARERR 93
James, Error 93 is a timeout error. It is specific to search type commands -- GetList. In addition, it is generally only for entry type operations. Error 92 is also a timeout error. It is specific to point entry access commands -- Create/Set/Merge/Delete/Get. In addition, you will get this for any data dictionary search type operations. So, you are getting a timeout searching for entries. This matches with your discussion that you are not having trouble getting individual incidents, but only on the console where you are doing a search. You didn't mention your version and whether you are on the latest releases where we are keeping the top 10 (a configurable number) API and SQL commands for you automatically and you can drop them out at any time (or on a scheduled basis). If you are, then you can simply drop out the longest commands and see what the timing is. In any version, you can turn on SQL logging and just see what SQL is being issued and why it is taking so long. Being error 93, it is keying off the LONG timeout which defaults to something like 3 or 5 minutes. So, you should be seeing a long delay in response to going to the console and getting the error message. The support team should be able to help isolate the issue. They will want to look at the SQL that is taking the time (from one of the sources I note above). The issue could be anything from very long searches due to indexes that are lost/missing to blocked threads to other similar issues. The key is going to be seeing the command arrive and seeing what SQL is generated (or not and that is significant because it is not even getting to that point) and what is taking the time. Some things to start with, and I would suggest that the support team is a resource that can help you with this type of situation. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Friday, April 17, 2015 1:47 PM To: arslist@ARSLIST.ORG Subject: Timeout ARERR 93 Hi List, It has been a long time since we interacted with each other. Hope entire list is doing fine. Now let me describe you about my issue and grab some info if you can share. I am getting 93 error on Incident Console only but not on other console. I have checked API, SQL and Filter logs but couldn't find anything. Please let me know if you have any solution to fix it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Timeout ARERR 93
Hi James, You can capture the API,FLTR and SQL logs and analyze the timing out API calles using AR Log Analyzer tool online. This helped me a lot identifying the various timeout issues. Regards, Jayesh -Original Message- From: "James Smith" Sent: 20-04-2015 09:06 AM To: "arslist@ARSLIST.ORG" ; "Jayesh Panchal" Cc: "James Smith" Subject: Re: Timeout ARERR 93 Only on Incident Management Console for all users but not on Incidents ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Timeout ARERR 93
Hi James, If you are on 8+ versions, ensure cache is flushed and that there is no corruption. Further, this is the way I would troubleshoot it. 1. Check if the qualification on the table was modified from the OOTB qualification 2. Pick the query that executes while opening the Incident Console from SQL log 3. Execute the query on DB (preferably Test one) to note the time for execution 4. Modify the qualification on the table as required Regards, SriSamSri Appecherla +61 478877812 On Mon, Apr 20, 2015 at 11:22 AM, Jayesh wrote: > ** > Is it while loading ALL incident ? > -- > From: James Smith > Sent: 18-04-2015 02:17 AM > To: arslist@ARSLIST.ORG > Subject: Timeout ARERR 93 > > Hi List, > > It has been a long time since we interacted with each other. Hope entire > list is doing fine. > > Now let me describe you about my issue and grab some info if you can > share. I am getting 93 error on Incident Console only but not on other > console. I have checked API, SQL and Filter logs but couldn't find > anything. > > Please let me know if you have any solution to fix it. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Timeout ARERR 93
Only on Incident Management Console for all users but not on Incidents ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Timeout ARERR 93
Is it while loading ALL incident ? -Original Message- From: "James Smith" Sent: 18-04-2015 02:17 AM To: "arslist@ARSLIST.ORG" Subject: Timeout ARERR 93 Hi List, It has been a long time since we interacted with each other. Hope entire list is doing fine. Now let me describe you about my issue and grab some info if you can share. I am getting 93 error on Incident Console only but not on other console. I have checked API, SQL and Filter logs but couldn't find anything. Please let me know if you have any solution to fix it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Timeout ARERR 93
Hello List, Nobody has an idea to fix it? If you cannot help me to fix it then I can't even image of talking support of BMC. Please, share your thoughts. James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Timeout ARERR 93
Hi List, It has been a long time since we interacted with each other. Hope entire list is doing fine. Now let me describe you about my issue and grab some info if you can share. I am getting 93 error on Incident Console only but not on other console. I have checked API, SQL and Filter logs but couldn't find anything. Please let me know if you have any solution to fix it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"