Looking for the ARS user guide
Hello All, I am worked as an ARS programmer, but that was last year. Currently I am starting working with it again. Q: does anyone have the Admin / Client user guide ? or any other related document ? Can't put my finger on these documents found over bmc.com site. Thanks Chanan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
** from the same box where the admin tool is installed, try with Sybase tools such as Advantage or Central, or isql to select the Remedy views and tables. This first step will show whether your DB is ok. Jaya Munjal wrote: ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: ARS 6.3 and Helpdesk 5.6 No Floating Licenses Available
I had a similar problem on this combination of versions. In our case there was a difference in capitalization of the name of the license in the SHR:People form and in the database. After correcting the problem in the database the users were able to work with their licenses. I was not able to ascertain why the license name was being stored incorrectly in the database ... and then we upgraded :) Sharon -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brad Terhune Sent: Thursday, November 12, 2009 12:17 AM To: arslist@ARSLIST.ORG Subject: ARS 6.3 and Helpdesk 5.6 No Floating Licenses Available Hi list. Been a while. I'm currently trying to add some new people to our support group for Remedy access. I'm giving them Helpdesk-Floating licenses and ARS floating licenses. I'm getting an error that indicates: There are no Help Desk Floating licenses available. (ARERR 42338) The preceding message occurred during the execution of active link SHRCFG:PGP-ModPeopleInfo08AddU -- action 1. (ARNOTE 1101) I know that floating means only a certain number of people can log in at once but I thought that as administrator I could assign floating licenses to as large a pool as I wished? Anyone know what might be happening here and how I could fix it? Thanks in advance for any help you can provide. Brad Terhune bterh...@uthsc.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Midtier / view ticket online solution problem.....
Hi all, Can anyone advise on the following please. We're running 6.3 and apache tomcat all on the same server (suse linux) with no issues. We send out an email to the user when a ticket is raised which contains a URL where they can click to check the status of the ticket. The format is below... http://servername/arsys/servlet/ViewFormServlet?form=form-name-hereview=view-name-hereserver=servernamehereusername=vto-683240eid=683240 you will see username variable = vto-nn eid = the users ticket number We have guest user logins enabled so the script that constructs the email gives them a username of vto (for view ticket online) and then appends their ticket number onto the end, with the theory being that it should only be that user that needs to view that ticket. So, all works well but if they close their browser afterwards, i notice in the Remedy admin tool that a Read license for username vto-683240 still remains after they have closed their browser and then, if they click the link in their email at a later time, they get the message user is already logged on - do you want to override Does anyone know why the userid hangs around after closing the browser ? Is it because its not a clean LOGOFF and if so, is there any way i can get this to happen ?? TIA Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Midtier / view ticket online solution problem.....
Not sure what tasks you allow guest logins (Read Only). If it just submit then you could switch the license to Read Restricted which will eliminate the User Logged Into Other Machine issue but will not allow updates to tickets. Closing the browser window does not clear the users connection. You should give them a Logout button which does an Application-Exit. Not sure if doing an Application-Exit on window close will do the same thing. HTH Frank On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine sean_rem...@yahoo.co.uk wrote: ** Hi all, Can anyone advise on the following please. We're running 6.3 and apache tomcat all on the same server (suse linux) with no issues. We send out an email to the user when a ticket is raised which contains a URL where they can click to check the status of the ticket. The format is below... http://servername/arsys/servlet/ViewFormServlet?form=form-name-hereview=view-name-hereserver=servernamehereusername=vto-683240eid=683240 you will see username variable = vto-nn eid = the users ticket number We have guest user logins enabled so the script that constructs the email gives them a username of vto (for view ticket online) and then appends their ticket number onto the end, with the theory being that it should only be that user that needs to view that ticket. So, all works well but if they close their browser afterwards, i notice in the Remedy admin tool that a Read license for username vto-683240 still remains after they have closed their browser and then, if they click the link in their email at a later time, they get the message user is already logged on - do you want to override Does anyone know why the userid hangs around after closing the browser ? Is it because its not a clean LOGOFF and if so, is there any way i can get this to happen ?? TIA Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Midtier / view ticket online solution problem.....
thanks for the reply Frank I have popped a button on the Web View Form with an active link which does a Run Process PERFORM-ACTION-EXIT-APP Once pressed, It pops up the MidTier screen saying You have successfully logged out but upon checking in the Admin tool / Manage User Licenses, the userid is still showing although it seems to have addressed the user already logged on issue. If i click the link again, the ticket seems to display ok without the user already logged on message hmmm From: Frank Caruso caruso.fr...@gmail.com To: arslist@ARSLIST.ORG Sent: Wed, 18 November, 2009 11:04:15 Subject: Re: Midtier / view ticket online solution problem. Not sure what tasks you allow guest logins (Read Only). If it just submit then you could switch the license to Read Restricted which will eliminate the User Logged Into Other Machine issue but will not allow updates to tickets. Closing the browser window does not clear the users connection. You should give them a Logout button which does an Application-Exit. Not sure if doing an Application-Exit on window close will do the same thing. HTH Frank On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine sean_rem...@yahoo.co.uk wrote: ** Hi all, Can anyone advise on the following please. We're running 6.3 and apache tomcat all on the same server (suse linux) with no issues. We send out an email to the user when a ticket is raised which contains a URL where they can click to check the status of the ticket. The format is below... http://servername/arsys/servlet/ViewFormServlet?form=form-name-hereview=view-name-hereserver=servernamehereusername=vto-683240eid=683240 you will see username variable = vto-nn eid = the users ticket number We have guest user logins enabled so the script that constructs the email gives them a username of vto (for view ticket online) and then appends their ticket number onto the end, with the theory being that it should only be that user that needs to view that ticket. So, all works well but if they close their browser afterwards, i notice in the Remedy admin tool that a Read license for username vto-683240 still remains after they have closed their browser and then, if they click the link in their email at a later time, they get the message user is already logged on - do you want to override Does anyone know why the userid hangs around after closing the browser ? Is it because its not a clean LOGOFF and if so, is there any way i can get this to happen ?? TIA Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
please ignore
8:51am EST Really to see if i get this back, for some reason my own feed of the ARSlist stopped when I went to the Conference and I think it is the usual, so much built up my ISP thinks it was spam, sigh. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Midtier / view ticket online solution problem.....
Do the same test again but this time turn on User logging and I think you will see the user being added then removed. Not sure about the license tool. On Wed, Nov 18, 2009 at 3:52 PM, Sean Harrodine sean_rem...@yahoo.co.uk wrote: ** thanks for the reply Frank I have popped a button on the Web View Form with an active link which does a Run Process PERFORM-ACTION-EXIT-APP Once pressed, It pops up the MidTier screen saying You have successfully logged out but upon checking in the Admin tool / Manage User Licenses, the userid is still showing although it seems to have addressed the user already logged on issue. If i click the link again, the ticket seems to display ok without the user already logged on message hmmm From: Frank Caruso caruso.fr...@gmail.com To: arslist@ARSLIST.ORG Sent: Wed, 18 November, 2009 11:04:15 Subject: Re: Midtier / view ticket online solution problem. Not sure what tasks you allow guest logins (Read Only). If it just submit then you could switch the license to Read Restricted which will eliminate the User Logged Into Other Machine issue but will not allow updates to tickets. Closing the browser window does not clear the users connection. You should give them a Logout button which does an Application-Exit. Not sure if doing an Application-Exit on window close will do the same thing. HTH Frank On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine sean_rem...@yahoo.co.uk wrote: ** Hi all, Can anyone advise on the following please. We're running 6.3 and apache tomcat all on the same server (suse linux) with no issues. We send out an email to the user when a ticket is raised which contains a URL where they can click to check the status of the ticket. The format is below... http://servername/arsys/servlet/ViewFormServlet?form=form-name-hereview=view-name-hereserver=servernamehereusername=vto-683240eid=683240 you will see username variable = vto-nn eid = the users ticket number We have guest user logins enabled so the script that constructs the email gives them a username of vto (for view ticket online) and then appends their ticket number onto the end, with the theory being that it should only be that user that needs to view that ticket. So, all works well but if they close their browser afterwards, i notice in the Remedy admin tool that a Read license for username vto-683240 still remains after they have closed their browser and then, if they click the link in their email at a later time, they get the message user is already logged on - do you want to override Does anyone know why the userid hangs around after closing the browser ? Is it because its not a clean LOGOFF and if so, is there any way i can get this to happen ?? TIA Sean _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
Correct - also, if you are using Solaris + remote Oracle db the performance takes a huge hit if you are using out-of-row. However, we are using IN-ROW! :) And the space is still being consumed at a ridiculous rate - I can't believe I didn't mention that but it was rather late last night when I wrote this. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Wednesday, November 18, 2009 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 Hi, In most cases, as I understand, it is definitely better to not use the out-row-lob-setting. This will save a lot of space and time for the DB. Best Regards - Misi, RRR AB, http://rrr.se/sv/ I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory. We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C105940 z1D Template Related CI C100151 Detailed Decription C100156 Resolution C103742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited) length. The questions I have are: 1.) If a LOB is 4K it is stored out of row regardless. Can anyone tell me how to determine the space used by any of those particular fields in Oracle? And how I can tell if these are in fact being stored out of row due to the unlimited option on the field? 2.) Aren't z1D fields supposed to be Display only according to Remedy's design and naming conventions? I'm pretty sure that is the case but both of the fields above with that prefix are stored as optional. Thanks in advance - William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
Reboot your AR server or at the least restart the services. We receive this error when our DB team takes down our database without us knowing. A simple restart of AR reestablishes that connection, of course we also restart mid-tier just to be on the safe side. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jaya Munjal Sent: Tuesday, November 17, 2009 10:31 PM To: arslist@ARSLIST.ORG Subject: URGENT HELP REQUIRED --- PROD ISSUE Importance: High ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated... Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.com mailto:nisha.ram...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
I have seen this pretty recently and there was a corrupted object (form) in the database, we successfully removed the object at the database level (thru Enterprise Manager - Our was on MS SQL). In our case it was a corrupted form so we removed the form, views, fields and 2 active links attached to the form from the database and then imported from a def backup/another server. Hit me off list if you need the exact steps we took. Thanks, Doug doug.tan...@compass-usa.commailto:doug.tan...@compass-usa.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Wednesday, November 18, 2009 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE ** Reboot your AR server or at the least restart the services. We receive this error when our DB team takes down our database without us knowing. A simple restart of AR reestablishes that connection, of course we also restart mid-tier just to be on the safe side. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jaya Munjal Sent: Tuesday, November 17, 2009 10:31 PM To: arslist@ARSLIST.ORG Subject: URGENT HELP REQUIRED --- PROD ISSUE Importance: High ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated... Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.commailto:nisha.ram...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 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: Looking for the ARS user guide
Assuming that you are registered with a support ID. Go to BMC Support / Patch downloads and fixes / Product Downloads (EPD) - After you accept the agreements you can drill down on your products associated to your support ID. Keep drilling in until you get to the documents. Which set are you looking for? 6x/7x/7.5? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chanan Berler Sent: Wednesday, November 18, 2009 1:08 AM To: arslist@ARSLIST.ORG Subject: Looking for the ARS user guide ** Hello All, I am worked as an ARS programmer, but that was last year. Currently I am starting working with it again. Q: does anyone have the Admin / Client user guide ? or any other related document ? Can't put my finger on these documents found over bmc.com site. Thanks Chanan _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Technosys Announce New BMC ITSM to CA Clarity PPM Connector
Dear Listers, We are pleased to announce the availability of our new BMC ITSM to CA Clarity PPM Connector. This connector allows users of BMC ITSM / Remedy to seamlessly link Change Management requests directly to CA Clarity Project Management tools. The out of the box functionality enables organisations using both tool sets to benefit from a complete EITM solution within days rather than months. CA Clarity is typically used to manage strategic and tactical demand within the business. Change programs and requests generated from BMC ITSM can be automatically added to the overall IT Project Portfolio to allow coordinated project and resource planning. By providing a single system of record for IT project portfolio decisions, investment decisions, resource based optimisations, budgeting and forecasting, best practice methodologies and time tracking, IT efficiencies are improved. For further information on this new connector please go http://www.technosysuk.com/services/clarity_connector.htm or email to itsm_clar...@technosysuk.com, book a demo at http://www.technosysuk.com/solutions/demos.htm Technosys is a global solution provider specialising in the BMC portfolio of products for Business Service Management (BSM). Best regards, M. Khalil Technosys Limited Ph: +44(0)2084295955 Mob: +44(0)7916153032 Fax: +44(0)208 866 2400 IMPORTANT NOTICE This communication is from Technosys Limited registered in England and Wales with registered number 4436385. Its registered office is Talbot House, 204-226 Imperial Drive, Harrow, Middlesex, HA2 7HH, United Kingdom. This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please (1) notify secur...@technosysuk.com by forwarding this email and delete all copies from your system and (2) note that disclosure, distribution, copying or use of this communication is strictly prohibited. Email communications cannot be guaranteed to be secure or free from error or viruses. To the extent permitted by law, Technosys Limited does not accept any liability for use of or reliance on the contents of this email by any person save by the intended recipient(s) to the extent agreed in a Technosys Limited engagement contract. Opinions, conclusions and other information in this email which have not been delivered by way of the business of Technosys Limited are neither given nor endorsed by it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Looking for the ARS user guide
Current documentation is only available to those with a Support ID. Documentation for AR System 7.0.01, 7.1.00 and 7.5.00 can be found here: http://webapps.bmc.com/support/faces/prodallversions.jsp?seqid=108018 For legacy documentation (6.3.00 and prior), zip files have been posted to the BMC Developer Network in the Documents section: http://communities.bmc.com/communities/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system?view=documents You will need a BMC DN account to access them, but signing up is free. Since the information is copyrighted, it can't be put on a site that does not require some sort of login/access - and can't legally be forward by non-BMC authorized entities. That's why it's not posted on www.bmc.com. -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of DCI Remedy Sent: Wednesday, November 18, 2009 6:45 AM To: arslist@ARSLIST.ORG Subject: Re: Looking for the ARS user guide ** Assuming that you are registered with a support ID. Go to BMC Support / Patch downloads and fixes / Product Downloads (EPD) - After you accept the agreements you can drill down on your products associated to your support ID. Keep drilling in until you get to the documents. Which set are you looking for? 6x/7x/7.5? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chanan Berler Sent: Wednesday, November 18, 2009 1:08 AM To: arslist@ARSLIST.ORG Subject: Looking for the ARS user guide ** Hello All, I am worked as an ARS programmer, but that was last year. Currently I am starting working with it again. Q: does anyone have the Admin / Client user guide ? or any other related document ? Can't put my finger on these documents found over bmc.comhttp://bmc.com site. Thanks Chanan _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Question about Work Info and View Access in ITSM 7.1
We are running in Single Tenancy and were informed that Public means the end client can see it on Requester Console and Internal means that it doesn't show on Requester Console. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shyam Attavar Sent: Tuesday, November 17, 2009 4:50 PM To: arslist@ARSLIST.ORG Subject: Question about Work Info and View Access in ITSM 7.1 ** Dear Listers, We are trying to see if there is more to what is mentioned in the Incident Management guide for the View Access flag for Work Info records (excerpt below): From the View Access list, select Internal or Public. ! Internal-If you want users within your organization to see the entry. ! Public-If you want everyone with access to the application to see the entry, including requesters from the Requester console. We are using the application in a single tenancy mode and don't have any other companies or organizations being supported on this instance. I was wondering what the within your organization really means, since I see behavior not consistent with what is documented. Any thoughts/inputs? TIA -- Shyam _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Chat with Remedy
Hi All, Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix has just informed us that we have to upgrade to their latest version by the end of the year. The catch is they no longer support integration with Remedy. I like to have back up/company when something stops working. So I was wondering if either BMC has a chat integration product or any other vendors that support the Remedy integration. Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Chat with Remedy
Mark, AT WWRUG09, my eService and Conversive had chat products that integrated within the AR System. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Wednesday, November 18, 2009 11:13 AM To: arslist@ARSLIST.ORG Subject: Chat with Remedy ** Hi All, Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix has just informed us that we have to upgrade to their latest version by the end of the year. The catch is they no longer support integration with Remedy. I like to have back up/company when something stops working. So I was wondering if either BMC has a chat integration product or any other vendors that support the Remedy integration. Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.comhttp://www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or segment_name like '_746C%') Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 12:57 AM, William Rentfrow wrentf...@stratacominc.com wrote: ** I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory. We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C105940 z1D Template Related CI C100151 Detailed Decription C100156 Resolution C103742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited) length. The questions I have are: 1.) If a LOB is 4K it is stored out of row regardless. Can anyone tell me how to determine the space used by any of those particular fields in Oracle? And how I can tell if these are in fact being stored out of row due to the unlimited option on the field? 2.) Aren't z1D fields supposed to be Display only according to Remedy's design and naming conventions? I'm pretty sure that is the case but both of the fields above with that prefix are stored as optional. Thanks in advance - William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Chat with Remedy
So does Bomgar, I believe. Joanne Mansur Client Systems Analyst Northeastern University (617) 373-3295 (office) (617) 373-4354 (fax) j.man...@neu.edu From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Wednesday, November 18, 2009 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Chat with Remedy ** Mark, AT WWRUG09, my eService and Conversive had chat products that integrated within the AR System. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Wednesday, November 18, 2009 11:13 AM To: arslist@ARSLIST.ORG Subject: Chat with Remedy ** Hi All, Currently we have Citrix GoToAssist integrated with ARS 6.3, patch 20. Citrix has just informed us that we have to upgrade to their latest version by the end of the year. The catch is they no longer support integration with Remedy. I like to have back up/company when something stops working. So I was wondering if either BMC has a chat integration product or any other vendors that support the Remedy integration. Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.comhttp://www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Duplicate notifications on helpdesk modify
I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
There was a bug in the email engine that generated duplicate messages. What version of the email engine are you using? Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 11:38 AM To: arslist@ARSLIST.ORG Subject: Duplicate notifications on helpdesk modify ** I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ITSP 4.0 on 7.5 arsystem?
Hi All, The compatibility matrix says that ITSP 4.0 isn't supported on arsystem 7.5. I'm not sure if there's some problem with it or if it just hasn't been QA'd. I've asked several people at BMC and haven't gotten a response, so I'll ask you. Anyone out there running ITSP 4.0 on arsystem 7.5? If so, have you found anything that doesn't work as expected? Thanks in advance! Dennis Ruble Rockwell Collins ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
Hi Robert, I think you have to replace the ORs with ANDs. If 'Last Modified By' is e.g. AR_ESCALATOR then 'Last Modified By' != 'Assignee Login ID' is true Br, Norbert Am 18.11.2009 um 17:37 schrieb Robert Fults: ** I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: [HERD] Duplicate notifications on helpdesk modify
Hi Robert, I'm not sure why it is firing twice, but the 'OR' operators are the reason it is firing even when the assignee makes the update (using 'AND' would probably prevent this). I would recommend trying a much simpler 'Run If' statement: *'Assignee Login ID' != $USER$* If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification. Hope that helps, --Thomas On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults rfu...@fiu.edu wrote: I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: *( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) )* For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: [HERD] Duplicate notifications on helpdesk modify
Thanks! That is one issue down. Still firing twice though. From: Thomas Bean [mailto:bea...@slu.edu] Sent: Wednesday, November 18, 2009 11:54 AM To: Robert Fults Cc: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: Re: [HERD] Duplicate notifications on helpdesk modify Hi Robert, I'm not sure why it is firing twice, but the 'OR' operators are the reason it is firing even when the assignee makes the update (using 'AND' would probably prevent this). I would recommend trying a much simpler 'Run If' statement: 'Assignee Login ID' != $USER$ If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification. Hope that helps, --Thomas On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults rfu...@fiu.edumailto:rfu...@fiu.edu wrote: I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null?Type --- C1 NOT NULL VARCHAR2(15) C2VARCHAR2(254) C3 NOT NULL NUMBER(15) C4VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912VARCHAR2(255) C536870913CLOB C536870914NUMBER(15) C536870915CLOB C536870916NUMBER(15) C536870921VARCHAR2(4000) C536870924VARCHAR2(4000) C536870925NUMBER(15) C54710VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15)NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE)NOT NULL, C6 NUMBER(15)NOT NULL, C7 NUMBER(15)NOT NULL, C8 VARCHAR2(128 BYTE)NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or segment_name like '_746C%') Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 12:57 AM, William Rentfrow wrentf...@stratacominc.com wrote: ** I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory. We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C105940 z1D Template Related CI C100151 Detailed Decription C100156 Resolution C103742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited)
Re: [HERD] Duplicate notifications on helpdesk modify
What does your filter log show? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: [HERD] Duplicate notifications on helpdesk modify ** Thanks! That is one issue down. Still firing twice though. From: Thomas Bean [mailto:bea...@slu.edu] Sent: Wednesday, November 18, 2009 11:54 AM To: Robert Fults Cc: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: Re: [HERD] Duplicate notifications on helpdesk modify Hi Robert, I'm not sure why it is firing twice, but the 'OR' operators are the reason it is firing even when the assignee makes the update (using 'AND' would probably prevent this). I would recommend trying a much simpler 'Run If' statement: 'Assignee Login ID' != $USER$ If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification. Hope that helps, --Thomas On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults rfu...@fiu.edumailto:rfu...@fiu.edu wrote: I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Is there a firewall in between the clients and the server? The initial traffic from the client to the server uses UDP if the TCP port is blank. This is an initial conversation to the portmapper to figure out which TCP port to use to carry on the conversation. Most network folks have UDP blocked in the firewall rules. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at
Re: WWRUG ARSLIST Awards
I have some catching up to doI am averaging 1 post a year right now -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Thursday, November 12, 2009 9:11 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG ARSLIST Awards New or old?and 350?...that's almost a post a day for the entire year -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, November 11, 2009 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG ARSLIST Awards There were some cracks about your last name :) On 11/11/09, LJ Longwing lj.longw...@gmail.com wrote: Wow, what a dubious honor...does that make me helpful or wordy? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Doug Blair Sent: Wednesday, November 11, 2009 11:23 AM To: arslist@ARSLIST.ORG Subject: WWRUG ARSLIST Awards Hello from the conference in Las Vegas For the first time this year, the ARSLIST award winners were announced in near-real time on Twitter :-) But for the rest of us, here's what I remember (Dan et all, please add the ones I missed!) There were, a number of varied, goofy, unusual and amusing awards... you'll just have to come to the next conference to enjoy these. There were also pictures and songs from previous RUG's and Userworld conferences, music and an impassioned speech from Phil Bautista about organizing Remedy User Groups. At several times the presentations were interrupted by spontaneous tossing of the official WWRUG food item: Twinkies! Doug Mueller was kind enough to explain the significance of the fond association between RUG attendees and Twinkies. Most posts: LJ Longwing (350) Longest Thread: (most posts on a single topic) History of the AR System (90) Jet Lag Award - Australia (fellow from New Zealand wasn't in the room!) BMC Employee Beyond The Call of Duty award: Kelly Deaver (who is no longer a BMC employee but was during the nomination and voting period) Most Valuable ARSLIST Poster: Dr. Christopher Strauss Congratulations! Now, I've got to attend some of the sessions and learn some more stuff! Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: WWRUG ARSLIST Awards
I have some catching up to doI am averaging 1 post a year right now Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Thursday, November 12, 2009 9:11 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG ARSLIST Awards New or old?and 350?...that's almost a post a day for the entire year -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, November 11, 2009 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG ARSLIST Awards There were some cracks about your last name :) On 11/11/09, LJ Longwing lj.longw...@gmail.com wrote: Wow, what a dubious honor...does that make me helpful or wordy? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Doug Blair Sent: Wednesday, November 11, 2009 11:23 AM To: arslist@ARSLIST.ORG Subject: WWRUG ARSLIST Awards Hello from the conference in Las Vegas For the first time this year, the ARSLIST award winners were announced in near-real time on Twitter :-) But for the rest of us, here's what I remember (Dan et all, please add the ones I missed!) There were, a number of varied, goofy, unusual and amusing awards... you'll just have to come to the next conference to enjoy these. There were also pictures and songs from previous RUG's and Userworld conferences, music and an impassioned speech from Phil Bautista about organizing Remedy User Groups. At several times the presentations were interrupted by spontaneous tossing of the official WWRUG food item: Twinkies! Doug Mueller was kind enough to explain the significance of the fond association between RUG attendees and Twinkies. Most posts: LJ Longwing (350) Longest Thread: (most posts on a single topic) History of the AR System (90) Jet Lag Award - Australia (fellow from New Zealand wasn't in the room!) BMC Employee Beyond The Call of Duty award: Kelly Deaver (who is no longer a BMC employee but was during the nomination and voting period) Most Valuable ARSLIST Poster: Dr. Christopher Strauss Congratulations! Now, I've got to attend some of the sessions and learn some more stuff! Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
WWRUG09 Twitter Feed @weazel8
What a great conference. I tried to keep everyone up to date with my twitter feed from the conference, weazel8. Hope all of you enjoyed the feed that couldn't make the conferenceCan't wait for WWRUG10 Timothy W. Hulmes ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Firewall TCP Timeouts
Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp0864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using netstat -anto). So, when users get back on the system, MidTier apparently is trying to utilize one of these defunct tcp connections so you end up with problems like ARERR 91 rpc timeouts because these tcp connections are broken pipes. Is there a MidTier/Tomcat or other setting that you have found addresses this problem? Thanks. Ken Background: Version 7.5 patch 3 MidTier - Linux, Tomcat JSP ARS - Linux, Oracle 10g _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Hi David, No there is no firewall. We have two servers in that domain, and until this week we could login to both with TCP port = blank. This week I can still login to the other server with TCP = blank, so that indicates network is not a problem... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Wednesday, November 18, 2009 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Is there a firewall in between the clients and the server? The initial traffic from the client to the server uses UDP if the TCP port is blank. This is an initial conversation to the portmapper to figure out which TCP port to use to carry on the conversation. Most network folks have UDP blocked in the firewall rules. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09 Twitter Feed @weazel8
Is it just me or did everyone else get this exact same post 2 days ago? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR USA IMCOM Sent: Wednesday, November 18, 2009 10:17 AM To: arslist@ARSLIST.ORG Subject: WWRUG09 Twitter Feed @weazel8 What a great conference. I tried to keep everyone up to date with my twitter feed from the conference, weazel8. Hope all of you enjoyed the feed that couldn't make the conferenceCan't wait for WWRUG10 Timothy W. Hulmes ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Parse Group Members for Notification
Thanks for the reply. I was looking at the CTM:Support Group Association form. I wasn't aware of server side tables and how they worked. I did a quick test with some test forms, filters and a filter guide. It worked. Now we just need to go lookup the user notification preferences and some other tweaking and we should be all set. Thanks, James On Nov 17, 5:19 pm, Lyle Taylor tayl...@ldschurch.org wrote: Do you mean that for a given group, you want to create a notification record for each individual in the group, meaning that the problem is how to get the list of members of the group and iterate over that list to create a new record for each one? If that's the case, the group memberships of people are stored in the CTM:Support Group Association form. In principle, you should be able to create a table that references this form, filtering on the support group name, that you can run a filter guide on to iterate over all the records in the table. You can then create an individual notification record for each row in the table. Does that address what you're trying to do? Otherwise, the OOTB workflow handles group notifications a little differently than individual notifications. Individual notifications (e.g., Customer, Assignee, etc.) are processed immediately - so you'll immediately see the notification record for that individual when you perform an action on a record that generates a notification. However, for group notifications, it does it in two steps. First it creates an initial entry for the group, and then an escalation (maybe SYS:NPC:IM1-TriggerGroupNTG) takes care of processing the group notifications to generate the individual notifications. That may be why you weren't seeing it in your log files - if you didn't wait long enough, the escalation may not have fired before you turned off logging. Sorry for not providing more detail - I'm trying to be quick writing this while hoping that the general information will help steer you in the right direction. If any of this doesn't make sense, let me know. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of jham36 Sent: Tuesday, November 17, 2009 2:53 PM To: arsl...@arslist.org Subject: Parse Group Members for Notification Group, We have created some custom workflow and notifications outside of the Notification Engine that ITSM uses. We want to take advantage of the user notification preferences as part of this. I turned logging on for the ootb notification process. I see that for group notifications, a notify record is created for each user in the group. Then the user preferences are checked to see if the notification should be sent. For the life of me, I cannot figure out how to create a record for each of the group members on my notify form. I know the support group name and the group name for it from the group form. I looked over the log file for longer than I want to admit. I cannot seem to identify how bmc creates the individual notify records for the support group members. Any ideas? We have ARS 7.1 patch 7, ITSM 7.03 patch 9, Win 2003 Server, Oracle 10G Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
I should have posted my output: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' SEGMENT_NAMEBYTES -- -- B10 1048576 H10 2097152 T10 2097152 SYS_LOB039519C00010$$ 1048576 SYS_LOB039519C00012$$ 1048576 You can verify the In Row of your CLOB data with: select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%' TABLE_NAME COLUMN_NAME SEGMENT_NAME IN_ROW --- -- --- T10 C536870915 SYS_LOB039519C00012$$ YES T10 C536870913 SYS_LOB039519C00010$$ YES Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, November 18, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null?Type --- C1 NOT NULL VARCHAR2(15) C2VARCHAR2(254) C3 NOT NULL NUMBER(15) C4VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912VARCHAR2(255) C536870913CLOB C536870914NUMBER(15) C536870915CLOB C536870916NUMBER(15) C536870921VARCHAR2(4000) C536870924VARCHAR2(4000) C536870925NUMBER(15) C54710VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15)NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE)NOT NULL, C6 NUMBER(15)NOT NULL, C7 NUMBER(15)NOT NULL, C8 VARCHAR2(128 BYTE)NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or
Re: WWRUG09 Twitter Feed @weazel8
Dan may be resetting servers and messages that were stuck in the web interface are now popping out. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, November 18, 2009 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG09 Twitter Feed @weazel8 Is it just me or did everyone else get this exact same post 2 days ago? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR USA IMCOM Sent: Wednesday, November 18, 2009 10:17 AM To: arslist@ARSLIST.ORG Subject: WWRUG09 Twitter Feed @weazel8 What a great conference. I tried to keep everyone up to date with my twitter feed from the conference, weazel8. Hope all of you enjoyed the feed that couldn't make the conferenceCan't wait for WWRUG10 Timothy W. Hulmes ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
7.1 patch 007 Sincerely, Robert Fults Coordinator, UTS Support Center Florida International University University Park, PC 330 Miami, Florida 33199 Office: 305-348-2284 Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu From: Shellman, David [mailto:dave.shell...@tycoelectronics.com] Sent: Wednesday, November 18, 2009 11:40 AM Subject: Re: Duplicate notifications on helpdesk modify ** There was a bug in the email engine that generated duplicate messages. What version of the email engine are you using? Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 11:38 AM To: arslist@ARSLIST.ORG Subject: Duplicate notifications on helpdesk modify ** I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
It is an item often overlooked. It still doesn't mean that it's not a network issue. The network folks may have that portion of the network configured to not route UDP. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Hi David, No there is no firewall. We have two servers in that domain, and until this week we could login to both with TCP port = blank. This week I can still login to the other server with TCP = blank, so that indicates network is not a problem... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Wednesday, November 18, 2009 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Is there a firewall in between the clients and the server? The initial traffic from the client to the server uses UDP if the TCP port is blank. This is an initial conversation to the portmapper to figure out which TCP port to use to carry on the conversation. Most network folks have UDP blocked in the firewall rules. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs.
JVM output -- only sees 2GB - but machine has 4GB?
Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC+ + 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Which version of AR Server are you running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
Thanks for all the responses. I'm trying to reconcile our db size usage (53% of 47 MB after some re-structuring) with BMC's in-row examples. The in-row examples (from Oracle) in their docs mention a table with 43000+ with 32000+ of those having LOB entries and a size of ~261 MB. Even if I give Remedy a 50% fudge factor and bump that number to 390 (heck, let's go 400) we are using nearly 100X the space. And we only have 10X the records. All LOBS are now confirmed (again) as being in-row - waiting for BMC..and any bright ideas from the list. DBA is working on your suggestions to determine where exactly all the space has gone. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, November 18, 2009 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 I should have posted my output: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' SEGMENT_NAMEBYTES -- -- B10 1048576 H10 2097152 T10 2097152 SYS_LOB039519C00010$$ 1048576 SYS_LOB039519C00012$$ 1048576 You can verify the In Row of your CLOB data with: select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%' TABLE_NAME COLUMN_NAME SEGMENT_NAME IN_ROW --- -- --- T10 C536870915 SYS_LOB039519C00012$$ YES T10 C536870913 SYS_LOB039519C00010$$ YES Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, November 18, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null?Type --- C1 NOT NULL VARCHAR2(15) C2VARCHAR2(254) C3 NOT NULL NUMBER(15) C4VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912VARCHAR2(255) C536870913CLOB C536870914NUMBER(15) C536870915CLOB C536870916NUMBER(15) C536870921VARCHAR2(4000) C536870924VARCHAR2(4000) C536870925NUMBER(15) C54710VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15)NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE)NOT NULL, C6 NUMBER(15)NOT NULL, C7 NUMBER(15)NOT NULL, C8 VARCHAR2(128 BYTE)NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList)
Re: Server Information form time out
Never mind. As you said, if you can see the process listed in the rcpinfo listing, then it's probably running. I haven't dealt with portmapper on Solaris and don't have a Solaris box to look at, so I'm not sure I will be much more help on this. Sorry. This might be a good problem to take up with BMC support if that's an option for you. Good luck, Lyle From: Lyle Taylor Sent: Wednesday, November 18, 2009 10:43 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Server Information form time out Which version of AR Server are you running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor:
Re: Server Information form time out
Jason, Have you tried in your ar.conf file to see if your 'Register-With-Portmapper: T' is set to T? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Wednesday, November 18, 2009 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Never mind. As you said, if you can see the process listed in the rcpinfo listing, then it's probably running. I haven't dealt with portmapper on Solaris and don't have a Solaris box to look at, so I'm not sure I will be much more help on this. Sorry. This might be a good problem to take up with BMC support if that's an option for you. Good luck, Lyle From: Lyle Taylor Sent: Wednesday, November 18, 2009 10:43 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Server Information form time out Which version of AR Server are you running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb. 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail. Thanks! Jason _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out. ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of
Re: Server Information form time out
No worries. Thank you much for helping. I've logged a ticket with my SAs to restart rpcbind. I have found an error on 390600 trying to bind to rpc, even though I see other arserverd processes bound to rpc. I think that's the ultimate cause of my woes... From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Wednesday, November 18, 2009 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Never mind. As you said, if you can see the process listed in the rcpinfo listing, then it's probably running. I haven't dealt with portmapper on Solaris and don't have a Solaris box to look at, so I'm not sure I will be much more help on this. Sorry. This might be a good problem to take up with BMC support if that's an option for you. Good luck, Lyle From: Lyle Taylor Sent: Wednesday, November 18, 2009 10:43 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Server Information form time out Which version of AR Server are you running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: JVM output -- only sees 2GB - but machine has 4GB?
If you're using a 32-bit JVM (which is required for Remedy), then it is limited to a 2GB memory space, as are all 32-bit processes. You may have more memory on the machine, but 32-bit processes cannot access more than 2GB (unless they're specially compiled for that, which these aren't). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 10:38 AM To: arslist@ARSLIST.ORG Subject: JVM output -- only sees 2GB - but machine has 4GB? ** Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC++ 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: [HERD] Duplicate notifications on helpdesk modify
This won't fix the firing twice issue, but I just noticed that my earlier recommendation was incomplete -- you still need to explicitly exclude AR_ESCALATOR and Remedy Application Service: * * *'Assignee Login ID' != $USER$** AND **$USER$ != AR_ESCALATOR AND **$USER$ != Remedy Application Service* I would recommend running a Filter log in the client to determine what is triggering the filter to run twice. --Thomas On Wed, Nov 18, 2009 at 11:00 AM, Robert Fults rfu...@fiu.edu wrote: Thanks! That is one issue down. Still firing twice though. *From:* Thomas Bean [mailto:bea...@slu.edu] *Sent:* Wednesday, November 18, 2009 11:54 AM *To:* Robert Fults *Cc:* arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu *Subject:* Re: [HERD] Duplicate notifications on helpdesk modify Hi Robert, I'm not sure why it is firing twice, but the 'OR' operators are the reason it is firing even when the assignee makes the update (using 'AND' would probably prevent this). I would recommend trying a much simpler 'Run If' statement: *'Assignee Login ID' != $USER$* If the 'Assignee Login ID' field is NULL, it shouldn't meet the qualification. Hope that helps, --Thomas On Wed, Nov 18, 2009 at 10:37 AM, Robert Fults rfu...@fiu.edu wrote: I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: *( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) )* For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Hey LJ, Yes I have checked there, and confirmed it is set to 'T'... I think I've finally found something in the rpcinfo that indicates it's not working. If I get this resolved I'll post it here, as I've seen a few other instances of folks having this problem... Thanks! Jason And on a totally unrelated note, when did the list start limiting email size?? Have to keep chopping these replies to get them through. Makes it harder to follow a thread... From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, November 18, 2009 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Jason, Have you tried in your ar.conf file to see if your 'Register-With-Portmapper: T' is set to T? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Wednesday, November 18, 2009 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Never mind. As you said, if you can see the process listed in the rcpinfo listing, then it's probably running. I haven't dealt with portmapper on Solaris and don't have a Solaris box to look at, so I'm not sure I will be much more help on this. Sorry. This might be a good problem to take up with BMC support if that's an option for you. Good luck, Lyle From: Lyle Taylor Sent: Wednesday, November 18, 2009 10:43 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Server Information form time out Which version of AR Server are you running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Yes the portmapper seems to be the problem, as I also cannot login with the clients with TCP port = blank. As far as I can tell, portmapper is running. It's on a Solaris box, and I can see arserverd processes in the rpcinfo listing. But I am really weak on rpcinfo and portmapper. Do you have any advice on how to check that portmapper is running properly on a unix box? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 7:12 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
I need sleep ;) The B#C# are used for attachments, I believe, at least they were in past versions. This is because Remedy used to use a LONG RAW data type for the binary storage and there could be only 1 long raw per table. The SYS_LOB039519C00010$$ cited by Frederick is the LOB segment. You can add the segment_type column to the results to see what type it actually is. The segment_type will tell you one of these: CACHE CLUSTER INDEX LOBINDEX LOBSEGMENT ROLLBACK TABLE TABLE PARTITION TYPE2 UNDO Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 11:01 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null? Type --- C1 NOT NULL VARCHAR2(15) C2 VARCHAR2(254) C3 NOT NULL NUMBER(15) C4 VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912 VARCHAR2(255) C536870913 CLOB C536870914 NUMBER(15) C536870915 CLOB C536870916 NUMBER(15) C536870921 VARCHAR2(4000) C536870924 VARCHAR2(4000) C536870925 NUMBER(15) C54710 VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15) NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE) NOT NULL, C6 NUMBER(15) NOT NULL, C7 NUMBER(15) NOT NULL, C8 VARCHAR2(128 BYTE) NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') or SEGMENT_NAME like '_10' or SEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or segment_name like '_746C%') Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations
Re: Firewall TCP Timeouts
This can be normal behavior for a firewall. It all depends on how you allow packets to create a state or if you use state at all. You can create a rule that is stateless so that all packets from host X to host Y are allowed. You should explore creating the rule to do a quick pass of the packets and not use state for these connections. Basically, the rules would look like this: pass in quick on $if_1 inet proto tcp from $mt_host_1 to $ar_host_1 pass out quick on $if_2 inet proto tcp from $ar_host_1 to $mt_host_1 Instead of a state based or policy based ruleset. You can also change the type of packet on the firewall so that syn/syn ack packets are not the only type of packet that can insert a state into the state table. This is a little funky and is probably not the best way to do this, but it can be done this way too. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 11:17 AM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp 0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp 0 864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp 0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using netstat -anto).
Re: JVM output -- only sees 2GB - but machine has 4GB?
As I read http://support.microsoft.com/kb/283037 It seems as if ALL programs together under windows can only take 2GB. So - if I have 3 programs each take 1GB -- I would have a problem -- even though I have 4GB. Do others interpret the MS support document similarly? -John On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote: ** If you’re using a 32-bit JVM (which is required for Remedy), then it is limited to a 2GB memory space, as are all 32-bit processes. You may have more memory on the machine, but 32-bit processes cannot access more than 2GB (unless they’re specially compiled for that, which these aren’t). Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 10:38 AM To: arslist@ARSLIST.ORG Subject: JVM output -- only sees 2GB - but machine has 4GB? ** Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC+ + 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: JVM output -- only sees 2GB - but machine has 4GB?
Yes, and thus one of the limitations of 32Bitnow 'servers' can access a total higher than that...even in 32 BitI think they can go as high as 4... _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: JVM output -- only sees 2GB - but machine has 4GB? ** As I read http://support.microsoft.com/kb/283037 It seems as if ALL programs together under windows can only take 2GB. So - if I have 3 programs each take 1GB -- I would have a problem -- even though I have 4GB. Do others interpret the MS support document similarly? -John On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote: ** If you're using a 32-bit JVM (which is required for Remedy), then it is limited to a 2GB memory space, as are all 32-bit processes. You may have more memory on the machine, but 32-bit processes cannot access more than 2GB (unless they're specially compiled for that, which these aren't). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 10:38 AM To: arslist@ARSLIST.ORG Subject: JVM output -- only sees 2GB - but machine has 4GB? ** Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC++ 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: JVM output -- only sees 2GB - but machine has 4GB?
http://msdn.microsoft.com/en-us/library/aa366912%28VS.85%29.aspx Axton On Wed, Nov 18, 2009 at 12:33 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** As I read http://support.microsoft.com/kb/283037 It seems as if ALL programs together under windows can only take 2GB. So - if I have 3 programs each take 1GB -- I would have a problem -- even though I have 4GB. Do others interpret the MS support document similarly? -John On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote: ** If you’re using a 32-bit JVM (which is required for Remedy), then it is limited to a 2GB memory space, as are all 32-bit processes. You may have more memory on the machine, but 32-bit processes cannot access more than 2GB (unless they’re specially compiled for that, which these aren’t). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] on Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 10:38 AM To: arsl...@arslist.org Subject: JVM output -- only sees 2GB - but machine has 4GB? ** Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC++ 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net arslist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net arslist: Where the Answers Are_ -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ITSP 4.0 on 7.5 arsystem?
Hi Dennis, To answer your first question, it's because it hasn't been tested by QA due to ITSP 4.0 being a legacy product. To the best of my knowledge, no BMC testing has been done that would indicate that it won't work - but, as with all things, best to try it in your dev environment first and see if anything negative occurs. And, of course, keep in mind that the combination would be unsupported, so if you run into problems, you may be asked to duplicate the issue on a supported combination. -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dennis Ruble Sent: Wednesday, November 18, 2009 8:44 AM To: arslist@ARSLIST.ORG Subject: ITSP 4.0 on 7.5 arsystem? ** Hi All, The compatibility matrix says that ITSP 4.0 isn't supported on arsystem 7.5. I'm not sure if there's some problem with it or if it just hasn't been QA'd. I've asked several people at BMC and haven't gotten a response, so I'll ask you. Anyone out there running ITSP 4.0 on arsystem 7.5? If so, have you found anything that doesn't work as expected? Thanks in advance! Dennis Ruble Rockwell Collins _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Double-Click to select incident template
A question came up about this on the BMC Communities board today, I thought it was good idea so I implemented it. Requirement: Support Staff wants to be able to double-click incident template on the Incident Template Selection and have it populate the incident instead of having to press the select button. Solution: You need to deselect the Return/Table or Level Dbl-Clk option in HPD:HTU Details_100_OpenDiag. You then select that option to run on the field z2TH Template Selection in the 5 Active Links that start with HPD:HTU:Select. Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Double-Click to select incident template
I would just keep it OOB and have the user Highlight and Select instead of Highlight and Double Click. Selling point? One less mouse click! Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 1:59 PM To: arslist@ARSLIST.ORG Subject: Double-Click to select incident template ** A question came up about this on the BMC Communities board today, I thought it was good idea so I implemented it. Requirement: Support Staff wants to be able to double-click incident template on the Incident Template Selection and have it populate the incident instead of having to press the select button. Solution: You need to deselect the Return/Table or Level Dbl-Clk option in HPD:HTU Details_100_OpenDiag. You then select that option to run on the field z2TH Template Selection in the 5 Active Links that start with HPD:HTU:Select. Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ** 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Midtier / view ticket online solution problem.....
You could as a workaround also have an AL that does the logout on closing the said window.. That should release the license.. Joe From: Frank Caruso caruso.fr...@gmail.com To: arslist@ARSLIST.ORG Sent: Wed, November 18, 2009 6:04:15 AM Subject: Re: Midtier / view ticket online solution problem. Not sure what tasks you allow guest logins (Read Only). If it just submit then you could switch the license to Read Restricted which will eliminate the User Logged Into Other Machine issue but will not allow updates to tickets. Closing the browser window does not clear the users connection. You should give them a Logout button which does an Application-Exit. Not sure if doing an Application-Exit on window close will do the same thing. HTH Frank On Wed, Nov 18, 2009 at 1:46 PM, Sean Harrodine sean_rem...@yahoo.co.uk wrote: ** Hi all, Can anyone advise on the following please. We're running 6.3 and apache tomcat all on the same server (suse linux) with no issues. We send out an email to the user when a ticket is raised which contains a URL where they can click to check the status of the ticket. The format is below... http://servername/arsys/servlet/ViewFormServlet?form=form-name-hereview=view-name-hereserver=servernamehereusername=vto-683240eid=683240 you will see username variable = vto-nn eid = the users ticket number We have guest user logins enabled so the script that constructs the email gives them a username of vto (for view ticket online) and then appends their ticket number onto the end, with the theory being that it should only be that user that needs to view that ticket. So, all works well but if they close their browser afterwards, i notice in the Remedy admin tool that a Read license for username vto-683240 still remains after they have closed their browser and then, if they click the link in their email at a later time, they get the message user is already logged on - do you want to override Does anyone know why the userid hangs around after closing the browser ? Is it because its not a clean LOGOFF and if so, is there any way i can get this to happen ?? TIA Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
Hi Rob, Do you have a development server? If so, make sure the email on development is configured for development and not your production service. Same with your ar.conf. If these settings get copied over from production email do exactly that - send two emails. Tom Lamy UNH From: herd-dispatch-boun...@mailman.stanford.edu [mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 11:38 AM To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: [HERD] Duplicate notifications on helpdesk modify I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
Assuming the OR should be AND in your qualification? Barb Wagner Remedy Architect IBM Global Services (612) 397-2955 Tie Line 608-1958 bar...@us.ibm.com Lamy, Thomas tom.l...@unh.edu Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 11/18/2009 01:40 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Duplicate notifications on helpdesk modify ** Hi Rob, Do you have a development server? If so, make sure the email on development is configured for development and not your production service. Same with your ar.conf. If these settings get copied over from production email do exactly that – send two emails. Tom Lamy UNH From: herd-dispatch-boun...@mailman.stanford.edu [ mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 11:38 AM To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: [HERD] Duplicate notifications on helpdesk modify I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
ARSmarts, free export utility for ITSM7.x
Dear List, For those who need to export ITSM 7.x and other large AR System applications, we are pleased to let you know that the _ARSmarts Export utility is available for free_ with the evaluation version of ARSmarts. Just register on our website (http://www.arsmarts.com/Register) to gain access to the download area. The ARSmarts Export utility: - exports definitions from AR System servers _without limitation of size_ (ITSM7.x, CMDB, SRM, ) - allows you to run exports at night or in the week-end against all your servers. - is free with the evaluation version of ARSmarts. Enjoy :-) :-) Kaïs kais.albas...@arsmarts.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Duplicate notifications on helpdesk modify
Unfortunately, no dev server. ..yet. Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu From: Lamy, Thomas [mailto:tom.l...@unh.edu] Sent: Wednesday, November 18, 2009 2:40 PM To: Robert Fults; arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: RE: Duplicate notifications on helpdesk modify Hi Rob, Do you have a development server? If so, make sure the email on development is configured for development and not your production service. Same with your ar.conf. If these settings get copied over from production email do exactly that - send two emails. Tom Lamy UNH From: herd-dispatch-boun...@mailman.stanford.edu [mailto:herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults Sent: Wednesday, November 18, 2009 11:38 AM To: arslist@ARSLIST.ORG; herd-dispa...@lists.stanford.edu Subject: [HERD] Duplicate notifications on helpdesk modify I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
Read the arfilter log. Shut off offending Filter... --- On Tue, 11/17/09, Frank Caruso caruso.fr...@gmail.com wrote: From: Frank Caruso caruso.fr...@gmail.com Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE To: arslist@ARSLIST.ORG Date: Tuesday, November 17, 2009, 9:18 PM What did you do prior to receiving the error? On Wed, Nov 18, 2009 at 7:31 AM, Jaya Munjal jaya.mun...@rbs.com wrote: ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated… Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
An offending filter? The nerve of some code! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rex Krebs Sent: Wednesday, November 18, 2009 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE Read the arfilter log. Shut off offending Filter... --- On Tue, 11/17/09, Frank Caruso caruso.fr...@gmail.com wrote: From: Frank Caruso caruso.fr...@gmail.com Subject: Re: URGENT HELP REQUIRED --- PROD ISSUE To: arslist@ARSLIST.ORG Date: Tuesday, November 17, 2009, 9:18 PM What did you do prior to receiving the error? On Wed, Nov 18, 2009 at 7:31 AM, Jaya Munjal jaya.mun...@rbs.com wrote: ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated… Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: Firewall TCP Timeouts
We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp0864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using netstat -anto). So, when users get back on the system, MidTier apparently is trying to utilize one of these defunct tcp connections so you end up with problems like ARERR 91 rpc timeouts because these tcp connections are broken pipes. Is there a MidTier/Tomcat or other setting that you have found addresses this problem? Thanks. Ken Background: Version 7.5 patch 3 MidTier - Linux, Tomcat JSP ARS - Linux, Oracle 10g _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE
Issues with moving from SUN Solaris to HP-UX
Hello All, Has anyone on the list every had to move Remedy from a SUN Solaris to an HP-UX environment? If so what were some of the biggest issues you had to deal with making that move? We are in the process of evaluating new servers for our environment. We currently are running on SUN 5.9 OS but are looking at moving either to a SUN Blade or HP server and are looking at the pros and cons of moving from SUN to HP. Anyone ever have to experience this type of move? Can you give me some or your thoughts both good and/or bad. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.commailto:mary.jo...@hp.com www.hp.comhttp://www.hp.com/ [cid:image001.jpg@01CA685B.A65FCF90] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are inline: image001.jpg
AW: Oracle in-row LOB storage issue - IM 7.03
William, here's an excerpt out of the oracle docs Choosing the Value of CHUNK Once the value of CHUNK is chosen (when the LOB column is created), it cannot be changed. Hence, it is important that you choose a value which optimizes your storage and performance requirements. Space Considerations The value of CHUNK does not matter for LOBs that are stored inline. This happens when ENABLE STORAGE IN ROW is set, and the size of the LOB locator and the LOB data is less than 4000 bytes. However, when the LOB data is stored out-of-line, it will always take up space in multiples of the CHUNK parameter. This can lead to a large waste of space if your data is small, but the CHUNK is set to a large number. The following table illustrates this point: Table 4-4 Data Size and CHUNK Size Data Size CHUNK Size Disk Space Used to Store the LOBSpace Utilization (Percent) 3500 enable storage in row irrelevant 3500 in row 100 3500 disable storage in row 32 KB 32 KB 10 3500 disable storage in row 4 KB4 KB 90 33 KB 32 KB 64 KB 51 2 GB +1032 KB 2 GB + 32 KB 99+ HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow Gesendet: Mittwoch, 18. November 2009 18:50 An: arslist@ARSLIST.ORG Betreff: Re: Oracle in-row LOB storage issue - IM 7.03 Thanks for all the responses. I'm trying to reconcile our db size usage (53% of 47 MB after some re-structuring) with BMC's in-row examples. The in-row examples (from Oracle) in their docs mention a table with 43000+ with 32000+ of those having LOB entries and a size of ~261 MB. Even if I give Remedy a 50% fudge factor and bump that number to 390 (heck, let's go 400) we are using nearly 100X the space. And we only have 10X the records. All LOBS are now confirmed (again) as being in-row - waiting for BMC..and any bright ideas from the list. DBA is working on your suggestions to determine where exactly all the space has gone. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, November 18, 2009 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 I should have posted my output: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%') orSEGMENT_NAME like '_10' orSEGMENT_NAME like '_10C%' SEGMENT_NAMEBYTES -- -- B10 1048576 H10 2097152 T10 2097152 SYS_LOB039519C00010$$ 1048576 SYS_LOB039519C00012$$ 1048576 You can verify the In Row of your CLOB data with: select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW from USER_LOBS where TABLE_NAME like '_10' or TABLE_NAME like '_10C%' TABLE_NAME COLUMN_NAME SEGMENT_NAME IN_ROW --- -- --- T10 C536870915 SYS_LOB039519C00012$$ YES T10 C536870913 SYS_LOB039519C00010$$ YES Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, November 18, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null?Type --- C1 NOT NULL VARCHAR2(15) C2VARCHAR2(254) C3 NOT NULL NUMBER(15) C4VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912VARCHAR2(255) C536870913CLOB C536870914NUMBER(15) C536870915CLOB C536870916NUMBER(15) C536870921VARCHAR2(4000) C536870924
Remedy Consulting Company in Atlanta
Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP _ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691816 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
Jamahowal, IT Prophets is based in Atlanta. What might we be able to assist you with today? Thanks Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.comhttp://www.itprophets.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jamahowal Pinitubel Sent: Wednesday, November 18, 2009 3:01 PM To: arslist@ARSLIST.ORG Subject: Remedy Consulting Company in Atlanta ** Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP Windows Live: Make it easier for your friends to see what you're up to on Facebook.http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
IT Prophets is the best one I know. Rick -Original Message- From: Jamahowal Pinitubel jamaho...@hotmail.com Date: Wed, 18 Nov 2009 16:01:00 To: arslist@ARSLIST.ORG Subject: Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP _ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691816 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
I will second that. On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook remedyr...@gmail.com wrote: ** IT Prophets is the best one I know. Rick -- *From: *Jamahowal Pinitubel jamaho...@hotmail.com *Date: *Wed, 18 Nov 2009 16:01:00 -0500 *To: *arslist@ARSLIST.ORG *Subject: *Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP -- Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
If they are such good Prophets then why don't they already know what he needs? False advertising right there in the name shsh. J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Richter Sent: Wednesday, November 18, 2009 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Consulting Company in Atlanta ** I will second that. On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook remedyr...@gmail.com wrote: ** IT Prophets is the best one I know. Rick From: Jamahowal Pinitubel jamaho...@hotmail.com Date: Wed, 18 Nov 2009 16:01:00 -0500 To: arslist@ARSLIST.ORG Subject: Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP Windows Live: Make it easier for your friends to see what you're up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
But they do, they are just waiting for you call.[?] On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris tommy.mor...@radioshack.comwrote: ** If they are such good Prophets then why don’t they already know what he needs? False advertising right there in the name shsh. J *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Howard Richter *Sent:* Wednesday, November 18, 2009 3:35 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Remedy Consulting Company in Atlanta ** I will second that. On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook remedyr...@gmail.com wrote: ** IT Prophets is the best one I know. Rick -- *From: *Jamahowal Pinitubel jamaho...@hotmail.com *Date: *Wed, 18 Nov 2009 16:01:00 -0500 *To: *arslist@ARSLIST.ORG *Subject: *Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP -- Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are 1E3.gif
Re: Firewall TCP Timeouts
Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp0864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using netstat -anto). So, when users get back on the system, MidTier apparently is trying to utilize one of these defunct tcp connections so you end up with problems like ARERR 91 rpc timeouts because these tcp connections are broken pipes.
Re: Firewall TCP Timeouts
Since you are using MidTier I would suggest you do the following... Add a specified port for your AR Server to listen on (The AR Server runs just fine with portmapper and a specified port). Set the MidTier to use the specified port. Also set the MidTier Session TimeOut value to be less than your firewall time out setting. This way Mid-Tier will drop old connections before the firewall does. You should be able to set the MIdTier TimeOut from the configuration pages on your MidTier server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth Sent: Wednesday, November 18, 2009 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp0864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We
Re: Firewall TCP Timeouts
Midtier timeout has to do with the user session timeout. Once arserver is started there is a persistent socket connection to the arserver. Can I ask what type of firewall this is? Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 4:05 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Since you are using MidTier I would suggest you do the following... Add a specified port for your AR Server to listen on (The AR Server runs just fine with portmapper and a specified port). Set the MidTier to use the specified port. Also set the MidTier Session TimeOut value to be less than your firewall time out setting. This way Mid-Tier will drop old connections before the firewall does. You should be able to set the MIdTier TimeOut from the configuration pages on your MidTier server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth Sent: Wednesday, November 18, 2009 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp 0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp 0 864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp 0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you
Kforce - Job Openings - Several - Nationwide
Here is the high level oversight 1) Remedy Developer with heavy infrastructure skills - Columbus, OH (Straight Contract) (Below Market Rates) 2) 2 Remedy SME's with 7.x migration exp - New York (3 Month Contract) (Market Rates) 3) Remedy Process Manager/ITIL Expert - New Jersey (6 Month Contract) (Below Market Rates) 4) Sr. Remedy Developer - San Jose, CA (6 Month Contract to Hire) (Below Market Rates) Ping me for more details! Joshua Kitchen Senior Recruiter Kforce Federal 937.449.1749 office jkitc...@kforce.com mailto:jkitc...@kforce.com http://www.govtrecruiter.com http://www.govtrecruiter.com Great People = Great Results(r) Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
We have also used IT Prophets in the past and those guys are hands down the best group I have ever worked with. Thanks, Jase On Wed, Nov 18, 2009 at 4:41 PM, Howard Richter hbr4...@gmail.com wrote: ** But they do, they are just waiting for you call.[?] On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris tommy.mor...@radioshack.com wrote: ** If they are such good Prophets then why don’t they already know what he needs? False advertising right there in the name shsh. J *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Howard Richter *Sent:* Wednesday, November 18, 2009 3:35 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Remedy Consulting Company in Atlanta ** I will second that. On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook remedyr...@gmail.com wrote: ** IT Prophets is the best one I know. Rick -- *From: *Jamahowal Pinitubel jamaho...@hotmail.com *Date: *Wed, 18 Nov 2009 16:01:00 -0500 *To: *arslist@ARSLIST.ORG *Subject: *Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP -- Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are 1E3.gif
Discovery 1.6
In the Discovery (foundation) - I thought once you run your task to discover the asset - this shows up in BMC.Import.Topo? Is this correct? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03 - RESOLVED - kinda sorta...
After a day's worth of work we've figured out that the vast majority of space being used was coming from: HPD:HelpDesk_AuditLogSystem This is the base product Audit logging built into IM 7.03 and as much as I love Remedy I am willing to call this feature very poor design for an application that is supposed to scale. Actually, I think Log-style auditing is ridiculous for many reasons. In this case the Audit Logging was using 25% of our total disk space. Needless to say we are in the process of disabling it and truncating tables. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 I need sleep ;) The B#C# are used for attachments, I believe, at least they were in past versions. This is because Remedy used to use a LONG RAW data type for the binary storage and there could be only 1 long raw per table. The SYS_LOB039519C00010$$ cited by Frederick is the LOB segment. You can add the segment_type column to the results to see what type it actually is. The segment_type will tell you one of these: CACHE CLUSTER INDEX LOBINDEX LOBSEGMENT ROLLBACK TABLE TABLE PARTITION TYPE2 UNDO Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 11:01 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null? Type --- C1 NOT NULL VARCHAR2(15) C2 VARCHAR2(254) C3 NOT NULL NUMBER(15) C4 VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912 VARCHAR2(255) C536870913 CLOB C536870914 NUMBER(15) C536870915 CLOB C536870916 NUMBER(15) C536870921 VARCHAR2(4000) C536870924 VARCHAR2(4000) C536870925 NUMBER(15) C54710 VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15) NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE) NOT NULL, C6 NUMBER(15) NOT NULL, C7 NUMBER(15) NOT NULL, C8 VARCHAR2(128 BYTE) NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') or SEGMENT_NAME like '_10' or SEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments
Enter character problem in 7.5
ARSystem 7.5 Patch 3 for Server and Dev Studio Prior to 7.5 if I wanted to do a search for an enter in a character string I would specify something like STRSTR($field$, ) and open the ... Box, specify an enter between the and save the workflow. I have done this countless times in the past and it works great. Today I tried the same thing in the dev studio...but there is no ... Anymore...not the same anyway...so I perform the same update but this time it doesn't find the enter in my string so I compared it to the output from the 7.1 Admin tool. In the admin tool it shown one single black box that I recognize as an enter character, if I look a the new filter that does the same thing I see two black boxes instead of 1as noon as I replace the two boxes with the same method used in the old admin tool which gives me a single black box it works just fine...anyone else experienced this scenario? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
I found a bit more in a support doc about checking arserver on rpcinfo with this command: rpcinfo -t server 390600 3 and it should return program 390600 version 3 ready and waiting on my server it is returning rpcinfo: RPC: Rpcbind failure - RPC: Timed out program 390600 version 3 is not available Remedy is running, I can log into it with TCP port set in the client. And RPC is running. But for whatever reason Remedy is not binding to rpc/portmapper properly. Has anyone else seen this particular error and resolved it? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
And because I live in Atlanta and want to be on their good side in case I ever need a job... I'll add that I have spoken with a couple of guys there over the years and they seem cool. I have a peer who worked for them a while back and he had good things to say about them as well... From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, November 18, 2009 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Consulting Company in Atlanta ** We have also used IT Prophets in the past and those guys are hands down the best group I have ever worked with. Thanks, Jase On Wed, Nov 18, 2009 at 4:41 PM, Howard Richter hbr4...@gmail.com wrote: ** But they do, they are just waiting for you call. On Wed, Nov 18, 2009 at 4:38 PM, Tommy Morris tommy.mor...@radioshack.com wrote: ** If they are such good Prophets then why don't they already know what he needs? False advertising right there in the name shsh. :-) From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Howard Richter Sent: Wednesday, November 18, 2009 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Consulting Company in Atlanta ** I will second that. On Wed, Nov 18, 2009 at 4:11 PM, Rick Cook remedyr...@gmail.com wrote: ** IT Prophets is the best one I know. Rick From: Jamahowal Pinitubel jamaho...@hotmail.com Date: Wed, 18 Nov 2009 16:01:00 -0500 To: arslist@ARSLIST.ORG Subject: Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP Windows Live: Make it easier for your friends to see what you're up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gif
Re: Discovery 1.6
It shows up on the query and the console default view on the fd application. But only after syncronization does it get to the cmdb... Then after reconcilation job runs it is in the cmdb.. Hope that helps Sent from my iPhone On Nov 18, 2009, at 5:19 PM, Kathy Morris kathymorris...@aol.com wrote: ** In the Discovery (foundation) - I thought once you run your task to discover the asset - this shows up in BMC.Import.Topo? Is this correct? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Consulting Company in Atlanta
Hi JP, DISYS is a BMC Partner and has offices and consultants in Atlanta. With over 1,300 consultants on billing in North America, we offer many other services in addition to Remedy. Feel free to reach out to me directly - so I can put you in touch with the right person. Best regards, Yvonne Burns Office (813) 207-1204 Mobile (813) 215-7895 yvonne.bu...@disys.com www.disys.com Certified Minority Enterprise (CME) P Please consider the environment before printing this e-mail From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jamahowal Pinitubel Sent: Wednesday, November 18, 2009 4:01 PM To: arslist@ARSLIST.ORG Subject: Remedy Consulting Company in Atlanta Hi there, Does anyone know of a company that has Remedy consultants available with an office that is based in Atlanta, GA? Thanks, JP Windows Live: Make it easier for your friends to see what you're up to on Facebook. http://go.microsoft.com/?linkid=9691811 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.jpg
Re: Kforce - Job Openings - Several - Nationwide
Hi Joshua, Wouldn't it be more effective just to list the rates? Maybe there's someone that would relocate to a different market and accept a higher or lower if they knew what it was. Thanks, Susan On Wed, Nov 18, 2009 at 4:13 PM, Kitchen, Joshua jkitc...@kforce.comwrote: ** Here is the high level oversight 1) Remedy Developer with heavy infrastructure skills – Columbus, OH (Straight Contract) (Below Market Rates) 2) 2 Remedy SME’s with 7.x migration exp – New York (3 Month Contract) (Market Rates) 3) Remedy Process Manager/ITIL Expert – New Jersey (6 Month Contract) (Below Market Rates) 4) Sr. Remedy Developer – San Jose, CA (6 Month Contract to Hire) (Below Market Rates) Ping me for more details! *Joshua Kitchen Senior Recruiter Kforce Federal 937.449.1749 office jkitc...@kforce.com http://www.govtrecruiter.com* *Great People = Great Results®* *Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original.* ** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Report environments: thinking strategically
Hi all, I'm working with a new employer that is making the transition from ITSM 6 to 7 and they are learning the pains associated with some decisions they made that they thought were unrelated. I'm referring to Crystal mostly since a few print features transitioned from ar reports to crystal ones. My new friends here don't have a crystal server set up anywhere and are now contemplating their options. I can look things up on the compatibility matrix and will when it comes time to tell them what they need to buy if they choose to buy at all. What I can't look up so easily is where things are going in the future. Some of you might know or have an educated guess that would help. I'm not looking for the official BMC line here because I should be able to look that up on their website, right? 8) I'm wondering if some of you might share what you've heard on where things might be going. Specifically, I'm wondering if there are any changes in the weather forecast regarding how much the crystal report objects are integrated into ITSM. Ownership of applications can change and cause that butterfly wing flapping half way around the world that creates the typhoon for us. Any thoughts? -al Alfred Differ no.addr...@somemysteriousgovernmentcontractor.mil 8) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: Duplicate notifications on helpdesk modify
Hi Robert, ITSM has some rather complex workflow and quite often it will do two updates on the ticket for one user update. You have to exclude the second update. One thing you could try is to exclude the second update caused by syncing the worklog by adding ('z1D Action' != SYNC_WORKLOG to your condition. Rod 2009/11/19 Robert Fults rfu...@fiu.edu: ** I set up a filter to fire a notification on Modify of the HPD:HelpDesk form by anyone other than the assignee: ( 'Assignee Login ID' != $NULL$ ) AND ( ( 'Last Modified By' != 'Assignee Login ID') OR ( 'Last Modified By' != AR_ESCALATOR ) OR ( 'Last Modified By' != Remedy Application Service ) ) For some reason it fires twice, even when updated by the assignee. Any ideas what I did wrong here? Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edu http://uts.fiu.edu _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
I've had this problem. 1.) Stop the server 2.) Comment out the java plugin process in the armonitor.conf file - this is largely unused by the Remedy application suite. The only thing I know for sure that uses it is the data collector module in SLM. Comment it out anyway to give it a try. 3.) Make sure you have this line in your ar.conf file: Server-Plugin-Alias: REMEDY.ARDBC.SERVER.ADMINISTRATION REMEDY.ARDBC.SERVER.ADMI NISTRATION your_server_name_here:port# You can skip the colon and port # if you're using portmapper. I've always found it easier to NOT use portmapper on Solaris for a variety of reasons related to security. If that works then un-comment out the java plugin server and try it again. I've had identical installs (varying only by port #, server name, and db server name) behave differently running on the same server at the same time. One would run the java plugin server and the other wouldn't. This was with every possible combination of having one or both of them online at the same time, one or the other down, order of starting them up, etc. Never did find the reason William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Wednesday, November 18, 2009 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** I found a bit more in a support doc about checking arserver on rpcinfo with this command: rpcinfo -t server 390600 3 and it should return program 390600 version 3 ready and waiting on my server it is returning rpcinfo: RPC: Rpcbind failure - RPC: Timed out program 390600 version 3 is not available Remedy is running, I can log into it with TCP port set in the client. And RPC is running. But for whatever reason Remedy is not binding to rpc/portmapper properly. Has anyone else seen this particular error and resolved it? Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARSmarts, free export utility for ITSM7.x
Where were you about 4 days ago? :) I registered and I'll be stress-testing your app. I'll post results. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of support Sent: Wednesday, November 18, 2009 1:59 PM To: arslist@ARSLIST.ORG Subject: ARSmarts, free export utility for ITSM7.x ** Dear List, For those who need to export ITSM 7.x and other large AR System applications, we are pleased to let you know that the ARSmarts Export utility is available for free with the evaluation version of ARSmarts. Just register on our website (http://www.arsmarts.com/Register) to gain access to the download area. The ARSmarts Export utility: - exports definitions from AR System servers without limitation of size (ITSM7.x, CMDB, SRM, ) - allows you to run exports at night or in the week-end against all your servers. - is free with the evaluation version of ARSmarts. Enjoy :-) :-) Kaïs kais.albas...@arsmarts.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: Firewall TCP Timeouts
on the arserver! -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 22:51 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp0864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp
Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example)
Hi Fred, Why would this have anything to do with flat files??? The only reason for this that I can think of, is that the developers did not get enough time to do it right. I can not imagine a programmer that would not LOVE the challenge of optimizing a thing like this, and get payed to do it ;-) Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. According to the Workflow Objects docs there is a operator precedence. Operator precedence When you use multiple operators to construct qualification criteria, they are evaluated in the following order: 1 ( ) 2 NOT (!) - (unary minus) 3 * / % 4 + - 5 = = = != LIKE 6 AND () 7 OR (||) Operators of the same precedence are performed left to right. You can use parentheses in an expression to override operator precedence. AR System evaluates expressions inside parentheses first before evaluating those outside. Part of the design of adding parenthesis probably goes back to when Remedy supported using flat files as a database. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Monday, November 02, 2009 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example) It's possible that that's the motivation behind how it's currently architected, but it's not a very good excuse. The SQL will all get dynamically generated based on the qualification tree generated by parsing the qualification string, not on the qualification string itself. It's very doable to define qualification strings so that operator precedence, etc., is in line with common practice, and that wouldn't affect Remedy's ability to be DB agnostic in the slightest. The only difference that it makes is that parsing the qualification strings becomes slightly more complicated (but still very doable - there are tools that will write much of this code for you - e.g., lex/yacc, etc.). Once you've parsed the qualification string according to whatever rules you've put in place, you end up with the same data structure that they currently have which will then be used to generate the SQL just like they do now. The current scheme is unnecessarily simplistic and actually makes the system more difficult to use because of the excessive number of parentheses in qualification schemese. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Monday, November 02, 2009 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example) Lyle, my take on that is that Remedy is trying to be DB agnostic. Rather than compete with how each DB processes SQL, or trying to anticipate how a receiver of an API call might do so, they just kept it simple. Rick -Original Message- From: Lyle Taylor tayl...@ldschurch.org Date: Mon, 2 Nov 2009 12:29:40 To: arslist@ARSLIST.ORG Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example) From what I've been able to tell, there is no such thing as operator precedence in AR System aside from parentheses. It all seems to be dictated on the parentheses which seems to correspond to the tree that their parser build internally. There's a lot of room for improvement in the area of qualifications in Remedy, in my opinion. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Thursday, October 29, 2009 2:13 AM To: arslist@ARSLIST.ORG Subject: Re: Java API for ARS - How to obtain a Run-If line from an Active Link (for example) Hi, Just tested some things. I am working on ARServer/Developer 7.5.0 patch 3. In the Run-If and Set/Push-Fields-If-Qualification, it still puts in extra brackets: What I entered: 'CU:ID' = $CU:ID$ AND 'CO:ID' = $CO:ID$ AND 'Status' = Active After reopen: (('CU:ID' = $CU:ID$) AND ('CO:ID' = $CO:ID$)) AND ('Status' = Active) It seems like they did some efforts on the the VALUE in the Set/Push-Fields Action. The problem is that i does not work, the new BMC parenthesis optimizer is faulty!!! I entered: (1.0 + 2.0) * 3.0 This is shown after reopening the filter: 1.0 + 2.0 * 3.0 They must take into account that the * has a higher priority than the +, and put in parenthesis accordingly, if needed. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: *