Re: JSP and ARS
Guillermo, AR System form names standards are not required to be compliant with SQL object name standards. You likely are trying to search on an DB object that does not exists. I think the ARODBC driver uses the views that exist in the AR System DB and that you need to use the DB names of those views. Maybe a few examples will help you guess what the name should be: _assuming Sybase or MS SQL_ values will be different based on your RDBMS rules. ARS Form name = This is my form RDBMS View name = this_is_my_form ARS Form name = User RDBMS View name = User_x ARS Form name = form/with(special characters) RDBMS View name = form_with_special_characters_ Note: I did not test each of these names, but I think my estimations of what the view names would be is fair. There is documentation about how these names are created somewhere in the pdf's. But I do not have an exact page number at the moment. Oh.. and there is a setting in the ODBC client setup that tells the driver to use underscores. You likely want to use that option. Hope that helps. Merry Christmas to you too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Dec 23, 2008 at 8:35 PM, Guillermo Alfredo Torres Barron guillermo.torres.bar...@banorte.com wrote: Hi dear listers We have a next Project, we need obtain information via JSP from our AR Server by AR System ODBC drivers, anybody have an example that you can provide me?, when try execute a query to a remedy form appear the next error java.sql.SQLException: The result set type is not supported. The query is: select (*) from form1, where form1 is my remedy form Thanks in advance Greeting from Mexico City Merry Christmas and happy new year ;) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
AR Server Crash - Not sure why... - ARS 7.1 patch 2
All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes... step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT: Seasons Greetings..
Wish you all on the list a Very Merry Christmas and a bright and prosperous New Year ahead. For those of you who are non Christians, I wish you a very happy holidays and a Happy New Year.. Have a safe celebration. Cheers Joseph D'Souza No virus found in this outgoing message. Checked by AVG. Version: 7.5.552 / Virus Database: 270.10.0/1862 - Release Date: 12/23/2008 12:08 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error happened and then investigate why that search was failing.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, Tauf Sent: Wednesday, December 24, 2008 10:11 AM To: arslist@ARSLIST.ORG Subject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes… step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 -- This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. No virus found in this outgoing message. Checked by AVG. Version: 7.5.552 / Virus Database: 270.10.0/1862 - Release Date: 12/23/2008 12:08 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
Is there anything new in the Oracle configuration? This sounds like AR server is losing connectivity with the db. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: Chowdhury, Tauf tauf.chowdh...@frx.com Date: Wed, 24 Dec 2008 10:10:38 To: arslist@ARSLIST.ORG Subject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes... step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
Joe, Thanks for the quick response. I think RPC is the clue. The reason I think that is because after this happened, when I tried using RDP to remote into the 'secondary' AR server, I got an RPC error. RPC Unavailable. So what that leads me to believe is that because the 1 server could not execute RPC calls, it locked up and crashed... which in turn took down the other AR server as well. Does that sound logical? I will investigate with our windows admins. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, December 24, 2008 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error happened and then investigate why that search was failing.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, Tauf Sent: Wednesday, December 24, 2008 10:11 AM To: arslist@ARSLIST.ORG Subject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes... step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
Not really, that doesn't sound too logical. Failure on one ARS Server in a server group shouldn't impact other ARS Servers in the same server group if the database is intact. Try finding out what search the user tried to run and investigate if there is anything that the search returns that the AR Server might not like. Also as Rick pointed out in a response to you on this thread, did the DB by any chance go offline? Although I doubt that might have happened because you would have got ARERR 552 errors if that happened but it could be worth checking too. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, Tauf Sent: Wednesday, December 24, 2008 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** Joe, Thanks for the quick response. I think RPC is the clue. The reason I think that is because after this happened, when I tried using RDP to remote into the ‘secondary’ AR server, I got an RPC error. RPC Unavailable. So what that leads me to believe is that because the 1 server could not execute RPC calls, it locked up and crashed… which in turn took down the other AR server as well. Does that sound logical? I will investigate with our windows admins. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, December 24, 2008 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error happened and then investigate why that search was failing.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, Tauf Sent: Wednesday, December 24, 2008 10:11 AM To: arslist@ARSLIST.ORG Subject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes… step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or
Re: JSP and ARS
Also view names cannot be more than 30 characters in length and if that means that you get two forms that might generate a duplicate view, the second form will get post fixed with its schemaid. Also recently I got to know through one of the members on the list on a similar thread that if there is a database keyword in the form name, that keyword is replaced with X. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Carey Matthew Black Sent: Wednesday, December 24, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: JSP and ARS Guillermo, AR System form names standards are not required to be compliant with SQL object name standards. You likely are trying to search on an DB object that does not exists. I think the ARODBC driver uses the views that exist in the AR System DB and that you need to use the DB names of those views. Maybe a few examples will help you guess what the name should be: _assuming Sybase or MS SQL_ values will be different based on your RDBMS rules. ARS Form name = This is my form RDBMS View name = this_is_my_form ARS Form name = User RDBMS View name = User_x ARS Form name = form/with(special characters) RDBMS View name = form_with_special_characters_ Note: I did not test each of these names, but I think my estimations of what the view names would be is fair. There is documentation about how these names are created somewhere in the pdf's. But I do not have an exact page number at the moment. Oh.. and there is a setting in the ODBC client setup that tells the driver to use underscores. You likely want to use that option. Hope that helps. Merry Christmas to you too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Dec 23, 2008 at 8:35 PM, Guillermo Alfredo Torres Barron guillermo.torres.bar...@banorte.com wrote: Hi dear listers We have a next Project, we need obtain information via JSP from our AR Server by AR System ODBC drivers, anybody have an example that you can provide me?, when try execute a query to a remedy form appear the next error java.sql.SQLException: The result set type is not supported. The query is: select (*) from form1, where form1 is my remedy form Thanks in advance Greeting from Mexico City Merry Christmas and happy new year ;) No virus found in this outgoing message. Checked by AVG. Version: 7.5.552 / Virus Database: 270.10.0/1862 - Release Date: 12/23/2008 12:08 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Regarding Macros
Macro will overwrite the defaults. You need to pass the values in the macro. I would recommend using an AL Open Window action though as the Macro action is fairly outdated for this. Ron Date: Tue, 23 Dec 2008 17:33:15 +From: rav...@rediffmail.comsubject: Regarding MacrosTo: arsl...@arslist.org** Hi Friends,This is regarding macro issue. while running macros,default values are not being populated on opening the form.Let say, When I run the macro, help desk form is being opened, On opening this form, HD(it is a default value) should be populated in the Heldesk ID field. but this is not happening while running macros, where as default values are being populated when I click on 'Create Issue' on the form.Can you please share your ideas why this issue is being occured??Thanks RegardsRameswar__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ _ It’s the same Hotmail®. If by “same” you mean up to 70% faster. http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
Tauf, I had a similarissue, about exact actually, last week. It ended up being 1 User Tool Client that was crashing when any workflow kicked off and, somehow, it was crashing the ARS server as well. Once the single User Tool instance was identified and the User closed and restarted the UT everything went back to normal. Might not be the exact same thing for you of course but just to let you know things like this can happen. Ron Date: Wed, 24 Dec 2008 10:22:20 -0500From: tauf.chowdh...@frx.comsubject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2To: arsl...@arslist.org** Joe, Thanks for the quick response. I think RPC is the clue. The reason I think that is because after this happened, when I tried using RDP to remote into the ‘secondary’ AR server, I got an RPC error. RPC Unavailable. So what that leads me to believe is that because the 1 server could not execute RPC calls, it locked up and crashed… which in turn took down the other AR server as well. Does that sound logical? I will investigate with our windows admins. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'SouzaSent: Wednesday, December 24, 2008 10:18 AMTo: arsl...@arslist.orgsubject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error happened and then investigate why that search was failing.. Cheers Joe -Original Message-From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, TaufSent: Wednesday, December 24, 2008 10:11 AMTo: arsl...@arslist.orgsubject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes… step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user. Then again, this new user later in the afternoon. 8. I asked the users if they had been using the system all day. Answer was yes. I asked what they might have been doing at the time, and they stated just updating an incident. 9. SO I contacted BMC and I am basically running every log under the sun for them until this error happens again. BMC stated I should upgrade to Patch 5 on ARS. 10. Has anyone experienced this and if so, what should I look at??? Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender
Creating Decrementing value in Table
Hi All, I am currently working on ARS 7.1 and have a query to ask you all. I have created a Regular Form on which i have added a table field(holding data into anothe form) which displays only those records which have a flag set to Yes On this Regular Form i have added a Add/Modify and Delete Button with some selection fields on top of this Table field which user will select and either add to the table or select any record from the table and delete it. When user selects the value from selection field and clicks on Add button the record gets added into the Table Field with an incrementing Value i.e 1,2,3 and so on..which i managed to do so... But now i have a problem in where in if i select a record from Table and click on Delete Button then that particular record show go from the table and then the next records order id shuld get updated to previous one and same follows through rest of the table. for e.g Now suppose i have added records as below Order Id Value 1 Test 2 Test1 3 Test2 4 Test3 5 Test4 Now if i want to delete second record i.e Order id = 2 then when it gets deleted the third record i.e Order id =3 shuld get updated as Order id = 2 and then all the below record shuld similarly get updated i.e fourth record i.e Order id =4 should get updated to 3 and Order id =5 to 4 Can someone let me know how this can be implemented? Regards Amey Bhosale Remedy Application Developer J . P. Morgan Services India Pvt. Ltd. Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating Decrementing value in Table
I'm assuming that whenever you 'delete' a record, you are simply changing the status so that it doesn't show up on the table, then refreshing the table. You could add a filter that runs on the child form, the one from which the table is pulling its data, and have that filter run whenever the status is set to inactive, delete, whatever it is getting set to. The filter will then do a push fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket found. Then, simply do the push fields of Counter = Counter - 1. I think that this should work for you. Order IDValue 1 Test 2 Test1 3 Test2 4 Test3 If you deleted 2, then the filter would decrement test2 and test3, giving you the following: Order IDValue 1 Test 2 Test2 3 Test3 I think this will work. There might be a timing issue, however, on the refreshing of the table. Since you are using a filter, I'm afraid that your table might refresh prior to all of the tickets in the child form getting decremented. Let me know if it works. Thanks, Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amey Bhosale Sent: Wednesday, December 24, 2008 10:21 AM To: arslist@ARSLIST.ORG Subject: Creating Decrementing value in Table ** Hi All, I am currently working on ARS 7.1 and have a query to ask you all. I have created a Regular Form on which i have added a table field(holding data into anothe form) which displays only those records which have a flag set to Yes On this Regular Form i have added a Add/Modify and Delete Button with some selection fields on top of this Table field which user will select and either add to the table or select any record from the table and delete it. When user selects the value from selection field and clicks on Add button the record gets added into the Table Field with an incrementing Value i.e 1,2,3 and so on..which i managed to do so... But now i have a problem in where in if i select a record from Table and click on Delete Button then that particular record show go from the table and then the next records order id shuld get updated to previous one and same follows through rest of the table. for e.g Now suppose i have added records as below Order Id Value 1 Test 2 Test1 3 Test2 4 Test3 5 Test4 Now if i want to delete second record i.e Order id = 2 then when it gets deleted the third record i.e Order id =3 shuld get updated as Order id = 2 and then all the below record shuld similarly get updated i.e fourth record i.e Order id =4 should get updated to 3 and Order id =5 to 4 Can someone let me know how this can be implemented? Regards Amey Bhosale Remedy Application Developer J . P. Morgan Services India Pvt. Ltd. Cricket on your mind? Visit the ultimate cricket website. Enter now! http://in.rd.yahoo.com/tagline_cricket_1/*http://beta.cricket.yahoo.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Creating Decrementing value in Table
You could use a single SQL statement in an Active Link to update records to order_id -1, where the order_id than that for the record just deleted. Just add an integer display only field 'zTmpCurOrderId' which is set to the order_id for the current record about to be deleted. Use this value in the SQL statement. The table refreshes correctly and the order_id's get updated as expected. Can send you the code off-line if it helps? I trust this is of some help. Kind regards Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
cmdb2.x import templates
Hi there, I am trying to create some excel templates, so that I can import cmdb data in CSV file into CMDB. What is the best way to generate the templates? Or what is your approach to this? I am concerning there are too many fields in each cmdb Class and also there are over 10 classes I may need to use. Happy Holidays to all who are working today!! Thanks, Jason Niu - Know what you want and be focused. - Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: cmdb2.x import templates
I would start with an export from existing records. That way you will get the hidden fields. Make sure you don't import data that is supposed to be created by work flow. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: Jason Niu thevis...@optonline.net Date: Wed, 24 Dec 2008 17:53:41 To: arslist@ARSLIST.ORG Subject: cmdb2.x import templates Hi there, I am trying to create some excel templates, so that I can import cmdb data in CSV file into CMDB. What is the best way to generate the templates? Or what is your approach to this? I am concerning there are too many fields in each cmdb Class and also there are over 10 classes I may need to use. Happy Holidays to all who are working today!! Thanks, Jason Niu - Know what you want and be focused. - Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating Decrementing value in Table
Hi Mike, Can you tell me whether writing SQL statement will it affect the performance of checking each record and then updating it? Also would you be able to send me the code at amey.x.bhos...@jpmorgan.com id so that i can check and test the same? Regards Amey On Wed, Dec 24, 2008 at 10:20 PM, arlist...@aol.com wrote: ** You could use a single SQL statement in an Active Link to update records to order_id -1, where the order_id than that for the record just deleted. Just add an integer display only field 'zTmpCurOrderId' which is set to the order_id for the current record about to be deleted. Use this value in the SQL statement. The table refreshes correctly and the order_id's get updated as expected. Can send you the code off-line if it helps? I trust this is of some help. Kind regards Mike __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: Creating Decrementing value in Table
Hi Opela, Thanks for the response. On Delete Button i have set an AL which set the record status to No which was initially Yes and hence the record will no longer appear in the Table as the qualification of table is to display only those records which are Yes.So now this record will still exist on the Child Form with status set to No but not in the table on Parent Form. Now as per ur suggestion of creating a filter on the child form of pushing fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket can you elaborate on how to check counter on the current ticket is less than the counter on any other ticket? And if this works will it take a Large amount of time to update the records? Regards, Amey On Wed, Dec 24, 2008 at 9:57 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil wrote: I'm assuming that whenever you 'delete' a record, you are simply changing the status so that it doesn't show up on the table, then refreshing the table. You could add a filter that runs on the child form, the one from which the table is pulling its data, and have that filter run whenever the status is set to inactive, delete, whatever it is getting set to. The filter will then do a push fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket found. Then, simply do the push fields of Counter = Counter - 1. I think that this should work for you. Order IDValue 1 Test 2 Test1 3 Test2 4 Test3 If you deleted 2, then the filter would decrement test2 and test3, giving you the following: Order IDValue 1 Test 2 Test2 3 Test3 I think this will work. There might be a timing issue, however, on the refreshing of the table. Since you are using a filter, I'm afraid that your table might refresh prior to all of the tickets in the child form getting decremented. Let me know if it works. Thanks, Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amey Bhosale Sent: Wednesday, December 24, 2008 10:21 AM To: arslist@ARSLIST.ORG Subject: Creating Decrementing value in Table ** Hi All, I am currently working on ARS 7.1 and have a query to ask you all. I have created a Regular Form on which i have added a table field(holding data into anothe form) which displays only those records which have a flag set to Yes On this Regular Form i have added a Add/Modify and Delete Button with some selection fields on top of this Table field which user will select and either add to the table or select any record from the table and delete it. When user selects the value from selection field and clicks on Add button the record gets added into the Table Field with an incrementing Value i.e 1,2,3 and so on..which i managed to do so... But now i have a problem in where in if i select a record from Table and click on Delete Button then that particular record show go from the table and then the next records order id shuld get updated to previous one and same follows through rest of the table. for e.g Now suppose i have added records as below Order Id Value 1 Test 2 Test1 3 Test2 4 Test3 5 Test4 Now if i want to delete second record i.e Order id = 2 then when it gets deleted the third record i.e Order id =3 shuld get updated as Order id = 2 and then all the below record shuld similarly get updated i.e fourth record i.e Order id =4 should get updated to 3 and Order id =5 to 4 Can someone let me know how this can be implemented? Regards Amey Bhosale Remedy Application Developer J . P. Morgan Services India Pvt. Ltd. Cricket on your mind? Visit the ultimate cricket website. Enter now! http://in.rd.yahoo.com/tagline_cricket_1/*http://beta.cricket.yahoo.com __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: Creating Decrementing value in Table
Well, if you are wanting to increment the counter, then you are going to have to increment any ticket that has a counter greater than the counter on the current ticket. This could potentially get to be a very large update, depending on how many records are in this table. Now, how you accomplish this, let's say that you have your child form is named FormB and the counter field is called Counter and is an integer field. So, you put a filter on FormB that does a Push Fields. Server Name: CURRENT SERVER Push Value To: FormB Push Field If: 'Counter' $Counter$ If No Request Match: Take No Action If Any Requests Match: Modify All Matching Requests Fields: Name: Counter Value: Okay, scratch this idea. I forgot that on a push fields action, you have to push a value from the current window; you cannot use a value on the ticket to which you are pushing a value. I was going to have you put in 'Counter' - 1, but it won't work. Sorry for the delay. So, to still be able to do this using straight remedy: Let's say on your current form you have a table called Table1. The table has a few columns, some of which will be Counter from the child form, as well as Request ID from the child form. These can be hidden fields if need be. Now, whenever the user deletes a request from the table, you kick off an active link. The first thing this active link will do is to set a tmpInt field = $col_Counter$, which is the counter on the ticket that the user just deleted. The next thing this active link will do is to call an Active Link Guide. Make sure on this active link that you select Table Loop and choose the Table1. The active link guide will call another active link. This active link will do a set fields. The Run If on the Basic tab will be col_Counter tmpInt. The If Action tab will have a Push Fields action. The Push Fields will push to your child form where 'Request ID' = $col_Request ID$. The Name will be Counter (the Counter field on the child form) and the Value you are pushing would be $col_Counter$ - 1. I think this should work, sorry if it's brief, I would like to expand it more, but I'm heading out of the office for the week. I hope you all have a very very merry Christmas/New Year/Chanukkah/Qwanzaa/ and all of those other holidays/celebrations that I cannot spell. Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of AMEY BHOSALE Sent: Wednesday, December 24, 2008 12:18 PM To: arslist@ARSLIST.ORG Subject: Re: Creating Decrementing value in Table Hi Opela, Thanks for the response. On Delete Button i have set an AL which set the record status to No which was initially Yes and hence the record will no longer appear in the Table as the qualification of table is to display only those records which are Yes.So now this record will still exist on the Child Form with status set to No but not in the table on Parent Form. Now as per ur suggestion of creating a filter on the child form of pushing fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket can you elaborate on how to check counter on the current ticket is less than the counter on any other ticket? And if this works will it take a Large amount of time to update the records? Regards, Amey On Wed, Dec 24, 2008 at 9:57 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil wrote: I'm assuming that whenever you 'delete' a record, you are simply changing the status so that it doesn't show up on the table, then refreshing the table. You could add a filter that runs on the child form, the one from which the table is pulling its data, and have that filter run whenever the status is set to inactive, delete, whatever it is getting set to. The filter will then do a push fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket found. Then, simply do the push fields of Counter = Counter - 1. I think that this should work for you. Order IDValue 1 Test 2 Test1 3 Test2 4 Test3 If you deleted 2, then the filter would decrement test2 and test3, giving you the following: Order IDValue 1 Test 2 Test2 3 Test3 I think this will work. There might be a timing issue, however, on the refreshing of the table. Since you are using a filter, I'm afraid that your table might refresh prior to all of the tickets in the child form getting decremented. Let me know if it works. Thanks, Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amey Bhosale Sent: Wednesday, December 24, 2008 10:21 AM To: arslist@ARSLIST.ORG Subject: Creating Decrementing value in Table ** Hi All, I am currently working on ARS 7.1 and have a query to
OT: May we all find happiness in the upcoming year
The past year has been hard for some members of this list, and my hope is next year that are all just a little happer and a little better off. With that said, now for one of my my quotes; *True happiness is to enjoy the present, without anxious dependence upon the future, not to amuse ourselves with either hopes or fears but to rest satisfied with what we have, which is sufficient, for he that is so wants nothing. The great blessings of mankind are within us and within our reach. A wise man is content with his lot, whatever it may be, without wishing for what he has not. **Seneca *http://www.great-quotes.com/cgi-bin/viewquotes.cgi?action=searchAuthor_First_Name=Author_Last_Name=SenecaMovie= *4 B.C. �** 65 A.D., Spanish-born Roman Statesman, philosop*her And *Our greatest happiness does not depend on the condition of life in which chance has placed us, but is always the result of a good conscience, good health, occupation, and freedom in all just pursuits. **Thomas Jefferson *http://www.great-quotes.com/cgi-bin/viewquotes.cgi?action=searchAuthor_First_Name=ThomasAuthor_Last_Name=JeffersonMovie= *1743-1826, Third President of the USA* And I do believe in Santa, even to this day. -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270
Rajini K Sanapala is out of the office.
I will be out of the office starting 25/12/2008 and will not return until 26/12/2008. Thank you for your message, I will respond to your message when I return. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ADM:Merry insert celebration of your choice
I expect traffic on the list to be light for the next week or so, therefore allow me to: 1) Wish you all the best... Christmas, Hannukah, Kwanza or other celebration of the Season 2) Wish you a Happy New Year! For those that follow the western calendar 3) In these difficult times, both economically and weather wise, may you have a happy and healthy gathering of your choice, and a prosperous new year (see #2 above) 4) Please expect in the following two weeks: a) A brief outage for the upgrade of the ARSlist software b) An announcement for voting for the ARSlist Awards for 2008 c) An announcement for the new sponsor(s) of the ARSlist Cheers Everyone! Daniel Founder of the ARSlist p.s. for Canada: Support our Troups, Bring them home Now and Alive ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are