Re: Unable to Integrate ClearCase with Remedy
I am able to integrate it now. the issue was that the entry in ar.conf file for the integration exceeded 255 characters. I shortened the the directory structure and the directory names. It went fine But now when I am trying to export all the objects it gives an error Cannot get the def of the Object named Name of the object If I cancel this error to go on to next object then it gives same error again. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tanner, Doug Sent: 13 June 2007 09:10 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to Integrate ClearCase with Remedy ** Need to make sure that the client machine (where you are running the Admin tool from) has the CC Client loaded. Doug From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, June 13, 2007 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Unable to Integrate ClearCase with Remedy Are you trying to integrate it with an existing Remedy application platform, or just base Remedy AR System without any existing applications? In what application environment do you intend to use CC? Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: Tuesday, June 12, 2007 11:56 PM To: arslist@ARSLIST.ORG Subject: Unable to Integrate ClearCase with Remedy ** Hi Listers, ARS: 7.01 OS: Solaris I am trying to integrate ClearCase with remedy. Followed the instructions done whatever was mentioned in the setup pages from the Adv guide. The issue is that the Source Control menu options are still disabled. I can see an extra column in the admin which says Not in SC but I cannot import it in ClearCase as that option is still disabled and other SC options. I have done all the changes in server information too. checked the ar.conf file and all the changes are there. Any suggestions...? Cheers Ankur __20060125___This posting was submitted with HTML in it___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Unable to Integrate ClearCase with Remedy
Hi Listers, ARS: 7.01 OS: Solaris I am trying to integrate ClearCase with remedy. Followed the instructions done whatever was mentioned in the setup pages from the Adv guide. The issue is that the Source Control menu options are still disabled. I can see an extra column in the admin which says Not in SC but I cannot import it in ClearCase as that option is still disabled and other SC options. I have done all the changes in server information too. checked the ar.conf file and all the changes are there. Any suggestions...? Cheers Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: REMEDY PERL Programming
Hi Steve, To start with I'd suggest you to go through http://www.perl.org/books/beginning-perl/ BLOCKED::http://www.perl.org/books/beginning-perl/ to get some exp in perl and then you can go through www.arsperl.org BLOCKED::http://www.arsperl.org and http://www.arsperl.org/manual/toc.html BLOCKED::http://www.arsperl.org/manual/toc.html for ARSPerl HTH Regards Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steve Sent: 28 May 2007 11:38 AM To: arslist@ARSLIST.ORG Subject: REMEDY PERL Programming ** Dear List, I have been tasked to use PERL in my day-to-day REMEDY programming. Please let me know which documents to start-off with. I have no previous experience in PERL. Many thanks __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
User tool crashes
Hi List, Scenario: ARS 7.0.1 Patch 2 Database: Oracle 9i Some times back we did a migration from 6.0.1 to 7.0.1. Few days back the system administrator created some new groups. When the users belonging to these new groups login to the user tool via Citrix and try to save a record, the user tool crashes without any error message. When we tried to associate a user from one of the new groups with an old group which existed before the migration, it works fine but you again reassociate it with new, it crashes the user tool again. Regards Ankur PS: I saw that there is already an issue being discussed of User tool crashing. This issue had some more things to it so I thought of starting a new thread on this: ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Performance Issues
Thank you Joe, Micheal and Patrick... will try out your suggestions and will let you know the results. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Worts Sent: 16 March 2007 06:38 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues ** Ankur, You said that API shows a delay. Are you sure the API call is the one causing the problem or is it the SQL generated from the API call. If you combine your API and SQL log files, by writing them to the same file, you will be able to see which one is giving you the problem. e.g. it may take the API 0.001 seconds to call the SQL, it may take 60 seconds for the SQL to run and then another 0.001 seconds to return the results to the API. If the SQL is taking a long time to run, you may want to extract the SQL statement and run an EXPLAIN PLAN to see if you are using indexes correctly (or at all!). If the delay is in the API, you could be looking at a network/connectivity problem between the AR Server and the database (are you running your database remotely?) If you combine you API and SQL log files, you should be able to get a better understanding of what the API call is trying to do ... remember, one single API call (arCreateEntry) could generate multiple SQL statements and API's, so you need to make sure you understand what function you are testing in the application and what API and SQL is being executed. This will give you the big picture. Thanks, Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] Joe DeSouza [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 16/03/2007 11:59 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Performance Issues ** My guess is it might be one of these few things.. Memory leak on the current version/patch of the ARS you are on.. If this is the problem, in my experience with ARS 6.3 patch 19 is stable enough. Patch 20 reccommended though for the new DST update. However 20 is pretty new and though there are no known issues with memory leaks, there have been reported problems with the DST update itself. Another reason could be data fragmentation on the disk. This could be rectified with an backup of the database after stopping the ARS. Delete the database and recreate it using the same original parameters and restore the database. Another possible reason might be that there are certain searches happening on the current table whose record count is 700K. And the searches happening on this table is not using any defined indexes. You say it is a home grown application so it is very possible the developers who built it might have not defined the indexes required. You might need to see if your table is indexed properly. Look for all possible searches happening through qualifications used in 'set field if' actions of workflow, or qualifications used in table fields, qualifications used in search menus that might be defined and are used on this form, etc.. Hope this helps.. Joe D'Souza - Original Message From: Ankur Gulati (GR/EIL) [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Friday, March 16, 2007 7:15:38 AM Subject: Performance Issues ** Hi Listers, We have a home grown application with few integrations with external interfaces. Since last few weeks the application performance has depleted by 60%. Earlier it was 20% CPU utilization and now the remedy application takes 70-75% at any given time. The data would not be more than 700,000. Some times the external integrations would fail, restart of AR Server sometimes do help, but again in 1 or 2 days it starts to suck all the system resources and takes 70% utilization. The system takes more than 4 mins to save a record and some times it takes lil more than that too, same is the case with the searches too. SQL and API Log shows lot of delay. mainly APIs are having delay but I don't have much knowledge to interpret API log. I don't understand what has affected the application suddenly. As far as hardware goes...I don't know the exact specs but I am sure tht it is under utilized. the System is ARS 6.0.1 on Solaris 9, database :Oracle 9i we also noticed lot of inactive remedy sessions in the oracle. Any idea what are they? Can they affect the performance. There aren't many indexes but still the system was running fine till few weeks back. I need help as from where should I start looking at the probable performance issues and what all things I can tweak to improve it. Incase you need more details, please do let me know. Regards Ankur Never miss an email again! Yahoo! Toolbar http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar /features/mail/ alerts you the instant new
Performance Issues
Hi Listers, We have a home grown application with few integrations with external interfaces. Since last few weeks the application performance has depleted by 60%. Earlier it was 20% CPU utilization and now the remedy application takes 70-75% at any given time. The data would not be more than 700,000. Some times the external integrations would fail, restart of AR Server sometimes do help, but again in 1 or 2 days it starts to suck all the system resources and takes 70% utilization. The system takes more than 4 mins to save a record and some times it takes lil more than that too, same is the case with the searches too. SQL and API Log shows lot of delay. mainly APIs are having delay but I don't have much knowledge to interpret API log. I don't understand what has affected the application suddenly. As far as hardware goes...I don't know the exact specs but I am sure tht it is under utilized. the System is ARS 6.0.1 on Solaris 9, database :Oracle 9i we also noticed lot of inactive remedy sessions in the oracle. Any idea what are they? Can they affect the performance. There aren't many indexes but still the system was running fine till few weeks back. I need help as from where should I start looking at the probable performance issues and what all things I can tweak to improve it. Incase you need more details, please do let me know. Regards Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Miscellaneous tli error - System error (Connection refused) while accessing forms
Hi Joe, RPC Daemon is enabled and running fine From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 26 February 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Miscellaneous tli error - System error (Connection refused) while accessing forms ** Your RPC daemon must be disabled? This has to be running at the time of starting the ARS servers.. You can disable RPC after restarting your ARS servers so if for any reasons your RPC is disabled (some do it for security reasons) enable it, start your ARS server and then disable it.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ankur Gulati (GR/EIL) Sent: Sunday, February 25, 2007 11:27 PM To: arslist@ARSLIST.ORG Subject: Re: Miscellaneous tli error - System error (Connection refused) while accessing forms No ARS Server is not in admin mode. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: 23 February 2007 06:35 PM To: arslist@ARSLIST.ORG Subject: Re: Miscellaneous tli error - System error (Connection refused) while accessing forms Hi All, Is possible that ARS server is in administrator mode. Regards, Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: Friday, February 23, 2007 6:40 AM To: arslist@ARSLIST.ORG Subject: RPC: Miscellaneous tli error - System error (Connection refused) while accessing forms Hi All, Well now I am able to start the arserver process and am able to log in with all the users.I just started the Server from root this time rather than from admin. But still when I login through a normal user(not with admin rights) and try to open some form then it gives ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). I can access same forms with user Demo but not with any other user. Though they are able to log in to the system but while trying to open the forms getting RPC error. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: 22 February 2007 08:14 PM To: arslist@ARSLIST.ORG Subject: Re: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed ** Ankur, try running ldd command against the library which gives the error. The command should look something like: ldd ld.so.1 ldd shows dynamic dependencies of executable files or shared objects. Hopefully you will see the path it is trying to use to find the libclntsh.so.10.1 . You can then take it from there. Regards Jiri Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: 22 February 2007 14:25 To: arslist@arslist.org Subject: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed Hi Listers, A wicked error is giving me a hard time.. Here's the scenario: OS: Solaris 9 ARS: 6.0.1 and 7.0.1 DB: Oracle, oracle 9.1 client for 6 and 10.2 client for 7 Yes I have two different versions of remedy running on same server, till morning both were running perfectly fine. Few hours back we noticed that one of our users (not with Admin rights) started getting ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). but it was working fine for users with admin rights. I tried to restart the server and since then I all the processes start except arserver for version 7.0. Other versions which are on 6.0.1 run fine. The error which I recieve when I try to start arsystem is ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed: No such file or directory I have checked the rights of this file and its fine, all the path variables are set properly too. Just dont know what went wrong suddenly. The last thing that I remember doing on this arsystem
Re: Miscellaneous tli error - System error (Connection refused) while accessing forms
No ARS Server is not in admin mode. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: 23 February 2007 06:35 PM To: arslist@ARSLIST.ORG Subject: Re: Miscellaneous tli error - System error (Connection refused) while accessing forms Hi All, Is possible that ARS server is in administrator mode. Regards, Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: Friday, February 23, 2007 6:40 AM To: arslist@ARSLIST.ORG Subject: RPC: Miscellaneous tli error - System error (Connection refused) while accessing forms Hi All, Well now I am able to start the arserver process and am able to log in with all the users.I just started the Server from root this time rather than from admin. But still when I login through a normal user(not with admin rights) and try to open some form then it gives ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). I can access same forms with user Demo but not with any other user. Though they are able to log in to the system but while trying to open the forms getting RPC error. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: 22 February 2007 08:14 PM To: arslist@ARSLIST.ORG Subject: Re: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed ** Ankur, try running ldd command against the library which gives the error. The command should look something like: ldd ld.so.1 ldd shows dynamic dependencies of executable files or shared objects. Hopefully you will see the path it is trying to use to find the libclntsh.so.10.1 . You can then take it from there. Regards Jiri Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: 22 February 2007 14:25 To: arslist@arslist.org Subject: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed Hi Listers, A wicked error is giving me a hard time.. Here's the scenario: OS: Solaris 9 ARS: 6.0.1 and 7.0.1 DB: Oracle, oracle 9.1 client for 6 and 10.2 client for 7 Yes I have two different versions of remedy running on same server, till morning both were running perfectly fine. Few hours back we noticed that one of our users (not with Admin rights) started getting ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). but it was working fine for users with admin rights. I tried to restart the server and since then I all the processes start except arserver for version 7.0. Other versions which are on 6.0.1 run fine. The error which I recieve when I try to start arsystem is ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed: No such file or directory I have checked the rights of this file and its fine, all the path variables are set properly too. Just dont know what went wrong suddenly. The last thing that I remember doing on this arsystem was to import the user records from 6.0 to 7.0 and then also it worked fine for a day and now this has resulted in tired afternoon and evening and might have a sleepless night. what to do? Ankur NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information. __20060125___This posting was submitted with HTML in it___
ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed
Hi Listers, A wicked error is giving me a hard time.. Here's the scenario: OS: Solaris 9 ARS: 6.0.1 and 7.0.1 DB: Oracle, oracle 9.1 client for 6 and 10.2 client for 7 Yes I have two different versions of remedy running on same server, till morning both were running perfectly fine. Few hours back we noticed that one of our users (not with Admin rights) started getting ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). but it was working fine for users with admin rights. I tried to restart the server and since then I all the processes start except arserver for version 7.0. Other versions which are on 6.0.1 run fine. The error which I recieve when I try to start arsystem is ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed: No such file or directory I have checked the rights of this file and its fine, all the path variables are set properly too. Just dont know what went wrong suddenly. The last thing that I remember doing on this arsystem was to import the user records from 6.0 to 7.0 and then also it worked fine for a day and now this has resulted in tired afternoon and evening and might have a sleepless night. what to do? Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
RPC: Miscellaneous tli error - System error (Connection refused) while accessing forms
Hi All, Well now I am able to start the arserver process and am able to log in with all the users.I just started the Server from root this time rather than from admin. But still when I login through a normal user(not with admin rights) and try to open some form then it gives ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). I can access same forms with user Demo but not with any other user. Though they are able to log in to the system but while trying to open the forms getting RPC error. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: 22 February 2007 08:14 PM To: arslist@ARSLIST.ORG Subject: Re: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed ** Ankur, try running ldd command against the library which gives the error. The command should look something like: ldd ld.so.1 ldd shows dynamic dependencies of executable files or shared objects. Hopefully you will see the path it is trying to use to find the libclntsh.so.10.1 . You can then take it from there. Regards Jiri Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati (GR/EIL) Sent: 22 February 2007 14:25 To: arslist@arslist.org Subject: ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed Hi Listers, A wicked error is giving me a hard time.. Here's the scenario: OS: Solaris 9 ARS: 6.0.1 and 7.0.1 DB: Oracle, oracle 9.1 client for 6 and 10.2 client for 7 Yes I have two different versions of remedy running on same server, till morning both were running perfectly fine. Few hours back we noticed that one of our users (not with Admin rights) started getting ARERR [90] Cannot establish a network connection to the AR System server : testserver(0) : RPC: Miscellaneous tli error - System error (Connection refused). but it was working fine for users with admin rights. I tried to restart the server and since then I all the processes start except arserver for version 7.0. Other versions which are on 6.0.1 run fine. The error which I recieve when I try to start arsystem is ld.so.1: arserverd: fatal: libclntsh.so.10.1: open failed: No such file or directory I have checked the rights of this file and its fine, all the path variables are set properly too. Just dont know what went wrong suddenly. The last thing that I remember doing on this arsystem was to import the user records from 6.0 to 7.0 and then also it worked fine for a day and now this has resulted in tired afternoon and evening and might have a sleepless night. what to do? Ankur NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information. __20060125___This posting was submitted with HTML in it___
Re: Difference in execution of Application-Bus-Time-Diff
Hm..I think what you are saying is rightlemme get more into it and do some more tests Will keep the list posted. Ankur -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: 06 February 2007 03:15 PM To: arslist@ARSLIST.ORG Subject: Re: Difference in execution of Application-Bus-Time-Diff Hi again, I did miss one more or less inconsequential thing... The dates differed on the working call, and the time span was 2007-02-02 09:41:51 to 2007-02-06 07:01:12. The Gold - Critical apparently is active for 24 hours a day. Best Regards - Misi, RRR AB, http://www.rrr.se Hi Ankur, The Bus-Time-Form-Data is recached periodically. This is why it sometimes does more SQL-calls. I would guess that the Silver - Major does not span the time specified in the first call. I think you are in the same timezone as I. My guess is that Silver - Major probably starts at 8:00 or so, and that Gold - Critical is active during the span specified. The failing call spans from 2007-02-06 07:05:00 to 07:06:26. The working call spans from 2007-02-06 07:01:12 to 09:41:51. Best Regards - Misi, RRR AB, http://www.rrr.se Hi All, I suddenly got into a spooky situation when everything works fine and suddenly next day you retry and things starts to act weird. There's a filter which when passed sets a field and here's the SQL and FLTR log excerpt for the same. This is for the ticket coming in through mail 0: Set Fields /* Tue Feb 06 2007 07:06:28.0521 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 '093' /* Tue Feb 06 2007 07:06:28.0547 */COMMIT WORK Application-Bus-Time-Diff 1170741900 1170741986 Silver - Major Silver - Major Exit code: 0 Value: 0 Temp_Restoration_Time (1404051404) = 0 till 3 days back this would calculate the exact difference and now it only gives me 0. Nothing changed in these few days. Now the scary part is, when this same filter acts and pass the qualification for another ticket, it calculates the right business time difference and also the log shows more SQL commands: 0: Set Fields /* Tue Feb 06 2007 07:01:15.0537 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 '089' /* Tue Feb 06 2007 07:01:15.0574 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0595 */SELECT T80.C1,C8 FROM T80 WHERE (T80.C8 = 'Gold - Critical') ORDER BY 1 ASC /* Tue Feb 06 2007 07:01:15.0632 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0656 */SELECT C600 FROM T80 WHERE C1 '016' /* Tue Feb 06 2007 07:01:15.0682 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0702 */SELECT T153.C1,C8 FROM T153 WHERE (T153.C8 = 'Gold - Critical') ORDER BY 1 ASC /* Tue Feb 06 2007 07:01:15.0729 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0749 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C180,C181,C620,C621,C622,C623,C624,C625,C62 6,C 630,C631,C632,C633,C634,C635,C636,C1201032721,C1201032802,C1402031913 ,C2 005101201 FROM T153 WHERE C1 = '027' /* Tue Feb 06 2007 07:01:15.0777 */SELECT entryId,T0,U0,T1,U1,T2,U2 FROM H153 WHERE entryId = '027' /* Tue Feb 06 2007 07:01:15.0799 */COMMIT WORK Application-Bus-Time-Diff 1170405711 1170741672 Gold - Critical Gold - Critical Exit code: 0 Value: 335961 Temp_Restoration_Time (1404051404) = 335961 there is NO SET FIELD IF condition why it is calculating 0 in the first case? and Why is the difference between the number of SQL calls? Regards Ankur _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Difference in execution of Application-Bus-Time-Diff
Hi All, I suddenly got into a spooky situation when everything works fine and suddenly next day you retry and things starts to act weird. There's a filter which when passed sets a field and here's the SQL and FLTR log excerpt for the same. This is for the ticket coming in through mail 0: Set Fields /* Tue Feb 06 2007 07:06:28.0521 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 = '093' /* Tue Feb 06 2007 07:06:28.0547 */COMMIT WORK Application-Bus-Time-Diff 1170741900 1170741986 Silver - Major Silver - Major Exit code: 0 Value: 0 Temp_Restoration_Time (1404051404) = 0 till 3 days back this would calculate the exact difference and now it only gives me 0. Nothing changed in these few days. Now the scary part is, when this same filter acts and pass the qualification for another ticket, it calculates the right business time difference and also the log shows more SQL commands: 0: Set Fields /* Tue Feb 06 2007 07:01:15.0537 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 = '089' /* Tue Feb 06 2007 07:01:15.0574 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0595 */SELECT T80.C1,C8 FROM T80 WHERE (T80.C8 = 'Gold - Critical') ORDER BY 1 ASC /* Tue Feb 06 2007 07:01:15.0632 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0656 */SELECT C600 FROM T80 WHERE C1 = '016' /* Tue Feb 06 2007 07:01:15.0682 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0702 */SELECT T153.C1,C8 FROM T153 WHERE (T153.C8 = 'Gold - Critical') ORDER BY 1 ASC /* Tue Feb 06 2007 07:01:15.0729 */COMMIT WORK /* Tue Feb 06 2007 07:01:15.0749 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C180,C181,C620,C621,C622,C623,C624,C625,C626,C 630,C631,C632,C633,C634,C635,C636,C1201032721,C1201032802,C1402031913,C2 005101201 FROM T153 WHERE C1 = '027' /* Tue Feb 06 2007 07:01:15.0777 */SELECT entryId,T0,U0,T1,U1,T2,U2 FROM H153 WHERE entryId = '027' /* Tue Feb 06 2007 07:01:15.0799 */COMMIT WORK Application-Bus-Time-Diff 1170405711 1170741672 Gold - Critical Gold - Critical Exit code: 0 Value: 335961 Temp_Restoration_Time (1404051404) = 335961 there is NO SET FIELD IF condition why it is calculating 0 in the first case? and Why is the difference between the number of SQL calls? Regards Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARLogAnalyzer output
Hi Misi, I Would love to go through the copy of the presentation. BR Ankur -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: 01 February 2007 03:19 AM To: arslist@ARSLIST.ORG Subject: Re: ARLogAnalyzer output Thad, Well, rrrLic is the most popular one. Probably because it is easier to understand than hardcor logfile analysis... Regardless of the tool you use (Notepad works), I would urge everyone to use the logfiles more. Both for performance and troubleshooting issues. You do not need to know that much to make use of them. I did a presentation at UKRUG about performance tuning with logfiles. Please let me know if you want a copy of the presentation. It goes through the important API-calls for performance, and maps them to the actual workflow involved to trigger them. Best Regards - Misi, RRR AB, http://www.rrr.se Misi, I've used your rrrLic tool and guess I forgot about the others. I'll have to check them out. Thank you, Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Misi Mladoniczky [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/31/2007 06:47 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARLogAnalyzer output Hi, I usually focus on the number of calls with no gap, compared to the total number of calls. To this end our rrrLog-tool presents a percentage for a gap less than 1, 0.1, 0.01, 0.001 and 0.0001 seconds. http://www.rrr.se/tmp/rrrLogThread.html You have to decide what no gap means. My experience tell me to look at the less than 0.01 seconds column. To get the exact number of times the server has queued calls, Server Statistics would be the way to go. Best Regards - Misi, RRR AB, http://www.rrr.se I've spent countless hours reading and analyzing files like this and troubleshooting performance problems for the last couple years with more than 70% increase in performance. In my case the AVG Idle time was less than a second and in some cases very close to zero. We ended up doubling the number of threads, twice and saw a dramatic improvement. While this may be subjective, I would increase your threads, but without knowing how many you already have It's hard to say by how much. Though I'll stick my neck out and say, increase by about a third and evaluate your hardware performance during system load to determine whether it will remain that much, AND look at new logs again, then adjust from there. By looking at your numbers too, I might suggest increasing Fast threads more than List. This is however a subjective and difficult to say how much better your system will be without just doing it and by trial and error. If you would like more info, or if I can further answer questions, contact me. Thanks, Rem Date: Tue, 30 Jan 2007 11:16:59 -0800From: [EMAIL PROTECTED]: ARLogAnalyzer outputTo: [EMAIL PROTECTED] Hello, I haven't had much occasion to use the log analyzer very much, and I want to make sure I'm interpreting the results correctly as part of thread tuning. In determining if I need to increase my threads, which column is more important, the AVG Idle Time or the MIN Idle Time? I can see it either way and was hoping someone would share their experience. Thanks, Thad API STATISTICS BY THREAD IDQueue Thread CountGaps MIN Idle Time MAX Idle Time AVG Idle Time Total Idle Time-- -- --- --- -- -- -- ---Admin 001772 83 83 0.0150 46:01.622055.63441:16:57.6600Fast 000744 4,015 4,014 0.015017.8430 1.1034 1:13:49.3890Fast 001432 3,977 3,976 0.016019.1870 1.1128 1:13:44.7590Fast 001784 3,988 3,987 0.0160 12.8110 1.11311:13:57.9920Fast 001956 3,868 3,867 0.13.4830 1.1428 1:13:39.5520Fast 002264 3,970 3,969 0.016012.8280 1.1217 1:14:12.0360Fast 003660 3,983 3,982 0.0150 19.5150 1.11541:14:01.7290Fast 003832 3,950 3,949 0.016012.8120 1.1145 1:13:21.3690List 001284 1,478 1,477 0.031019.9840 2.6610 1:05:30.3070List 001508 1,684 1,683 0. 14.8270 2.43141:08:12.1150List 001580 1,384 1,383 0.062014.4050 2.6266 1:00:32.6020List 001616 1,523 1,522 0.16.1870 2.4974 1:03:21.1640List 001732 1,519 1,518 0. 13.9830 2.53071:04:01.7340List 001752 1,454 1,453 0.13.0150 2.5978
ARPlugin error + Web Service mapping
Hi Listers, Wish you all a happy new year. :) When the Web Service is called I get an error message ARERR [8939] The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. Though the web service gets invoked and only username and password are picked and are mapped, rest of the fields are not picked up by the webservice, though in some places in arplugin log there are entries like FINE About to invoke PLGN TID: 16 RPC ID: 05 Queue: ARFILTERAPI Client-RPC: 390695 /* Tue Jan 02 2007 07:21:00.7698 */ FINE java.net.SocketTimeoutException: Read timed out PLGN TID: 16 RPC ID: 05 Queue: ARFILTERAPI Client-RPC: 390695 /* Tue Jan 02 2007 07:21:00.7742 */ -CALL FAIL Well this happened in non licencesed server, and when I try the same in Licensed Server, ARERR [8939] doesn't come up but still the webservice is not picking up the values from the fields except username and password. Is the problem with the webservice? I tried to remap the fields but the result was the same. ARServer: 6.0.1 OS:Solaris 9 midtier:6.3 DB:Oracle Ankur ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARPlugin error + Web Service mapping
Thanks Kelly... I'll try this out. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Heikkila Sent: 02 January 2007 08:20 PM To: arslist@ARSLIST.ORG Subject: Re: ARPlugin error + Web Service mapping ** Unlicensed servers only have one thread (Admin thread). So, when you make a web service call, that thread locks, and if the service you are calling also needs to interact with the ARServer, there are no threads available, and it will timeout. Applying a license to an unlicensed serverlicensed will not automatically increase the allotted threads (only make the option available). So, you will also need to adjust your fast/list threads upward. Kelly Heikkila -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 02, 2007 12:59 AM To: arslist@ARSLIST.ORG Cc: Ankur Gulati (GR/EIL) Subject: ARPlugin error + Web Service mapping ** Hi Listers, Wish you all a happy new year. :) When the Web Service is called I get an error message ARERR [8939] The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. Though the web service gets invoked and only username and password are picked and are mapped, rest of the fields are not picked up by the webservice, though in some places in arplugin log there are entries like FINE About to invoke PLGN TID: 16 RPC ID: 05 Queue: ARFILTERAPI Client-RPC: 390695 /* Tue Jan 02 2007 07:21:00.7698 */ FINE java.net.SocketTimeoutException: Read timed out PLGN TID: 16 RPC ID: 05 Queue: ARFILTERAPI Client-RPC: 390695 /* Tue Jan 02 2007 07:21:00.7742 */ -CALL FAIL Well this happened in non licencesed server, and when I try the same in Licensed Server, ARERR [8939] doesn't come up but still the webservice is not picking up the values from the fields except username and password. Is the problem with the webservice? I tried to remap the fields but the result was the same. ARServer: 6.0.1 OS:Solaris 9 midtier:6.3 DB:Oracle Ankur __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Date/Time in table field Qualification
David Both are Date/Time Fields and radhika I did check regarding any NULL values in $Start_Date$, but there are none. Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Narayanan, Radhika Sent: 13 December 2006 15:21 To: arslist@ARSLIST.ORG Subject: Re: Date/Time in table field Qualification ** I think you'ld get that error whenever $Start_Date$ is NULL. You wouldn't get any error when $Start_Date$ has a valid date/time value. So, you'ld have to make sure that $Start_Date$ always has a value. If null, give it a default value like '1-Jan-1970'. (provided you're using this qualification directly in the Table Property- Qualification) OR You may also get this error if you're building the qualification string dynamically using the EXTERNAL keyword. In that case you may want to use double-quotes around $Start_Date$. Thanks Radhika Direct : +44 20718 20262 Extn : 20262 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ankur Gulati Sent: 13 December, 2006 7:34 PM To: arslist@ARSLIST.ORG Subject: Re: Date/Time in table field Qualification ** Joe, Both are Date/Time fields. 'create_date' and $Start_Date$ Ankur On 12/13/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Ankur, Make sure you are not comparing a Date field to a Date/Time field... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Ankur Gulati [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, December 13, 2006 7:25:37 AM Subject: Date/Time in table field Qualification ** Hi Listers, I am trying a basic qualification in the Table field 'create_date'=$Start_Date$ both the fields are the Date/Time fields of a regular forms. when I run it it gives ARERR [313] Data types are not appropriate for relational operation but when I try 'create_date'=$DATE$ it works fine, in this one is date/time and other is date field. I am clueless as what needs to be substituted for 'create_date'=$Start_Date$ to work. I know this topic has been discussed lot of times in past, have gone through the archives but couldn't resolve it. Ankur Everyone is raving about the all-new Yahoo! Mail beta. http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/m ailbeta __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are