Re: How to display DATE field in date format (from DB)
alter session set NLS_DATE_FORMAT='DD.MM. HH24:MI:SS';
select TO_DATE('1970-01-01 00:00:00', '-MM-DD hh24:mi:ss') +
numtodsinterval(c6, 'SECOND') from t954 where rownum 2;
Kind Regards
Torsten Brosow
Senior Solution Consultant
Column Technologies Australia Pty Ltd
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kali Obsum
Sent: Tuesday, 6 April 2010 11:59
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] How to display DATE field in date format (from DB)
**
Hi,
We have a field of type 'DATE'. It is stored as an integer in DB. Does
anyone know how to display this in Date format? (e.g. are there
functions that we can use?)
Regards,
Kali
NOTICE
The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Hi, It's a Sybase DB. But we've figured it out. Thanks!:) Regards, Kali -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tristan Roppel Sent: Tuesday, 6 April 2010 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: How to display DATE field in date format (from DB) Kali Obsum schrieb: ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Hi, If this is an Oracle DB, you can use Oracle's time functions in PL/SQL function to calculate the date from an integer value. The exact function can i send you later ! Cheers Tristan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Find Known Errors that are NOT related to a Change
I am trying to figure out how to find Known Errors that are not associated to a Change request. We are using Known Errors to track bugs and enhancements to in-house software. We associate corrected KEs to change requests as a Release. I am trying to find KEs that are not associated to a change (release) to make sure that they are addressed and don't fall through the cracks. I can easily find which ones are associated to a change by looking at the Associations forms, but I am stumped on how to find ones that are NOT associated. We are on ARS 7.1 and ITSM 7.03. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Executing ALs in ALGs on predefined interval
Hi LJ, thanks a lot for your reply. Yesterday i managed that and did something like you suggested :) Cheers, Plamen Ivanov www.remedy.bg On 1 Апр, 20:10, LJ Longwing lj.longw...@gmail.com wrote: Ok...this is ugly, but it should work. Create two tmp fields, one is 'current record', another is 'execute time' Create an AL that fires on interval of something like 3 seconds Have it call a guide looping through the table Within that guide have it check to see if the currently selected row = 'current record'...and if $TIMESTAMP$ 'execute time'if it is, do what you need and then increment 'current record' and 'execute time' appropriatelythe next time the loop runs it will only fire if the timestamp is greater than your 'execute time' and the row you are to take action on matches the row you set There's lots of logistics that would need to be worked out beyond what I have outlinedbut it shouldn't be too hard to do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of pivanov Sent: Thursday, April 01, 2010 2:50 AM To: arsl...@arslist.org Subject: Executing ALs in ALGs on predefined interval Hello, i need to perform table loop with ALG, which must to fire ALs with delay (after 1 minutes for example) after each interaction. (executing on 1rst row - wait 1 min - execute on 2nd row - wait 1 min and so on) That must to be done without user interaction (wait action is not working in that case as I think) Is that possible and how I can realize it? Thanks in advance, Plamen Ivanov ____ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are- Скриване на цитирания текст - - Показване на цитирания текст - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Cell Based Table Problem
OS Linux 2.6.16.60-0.21-smp DB Oracle 10.2.0.4.0 - Prod ARS 7.5 Patch 2 Is it possible to display more than 254 characters of a field in a cell based table? Currently it is truncating any values greater than 254 on display. Derek ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Events in Workflows
Hi nn-11, But for the dummy form to push some data, (lemme assume its some kind of flag) you need to have write previlege over the table from which I am accessing the data to be fetched into view form. But unfortunatley i cant add new coloumns to the external table. Hence it wouldnt be a viable solution :( nn-11 wrote: What about periodically running an escalation off of a Dummy form (that contains only 1 record) and have a filter on the Dummy form push the data to the view form that will subsequently fire the filter on the View form? On Wed, Mar 31, 2010 at 4:14 PM, navinem naveen...@gmail.com wrote: Hi All, Is there any way of creating a custom event and captruing it in Remedy. The reason why i need this is because of the following reason. I have an escalation which gets triggered from a view form. But i dont want this escalation to process records because of performance reasons. So i was looking for methods to trigger a filter in the same form from this escalation and i cant introduce any field to this view form to act as a flag. Can i generate any kind of custom event in the escalation and make the filter run on capture of this event? Please provide any inputs on this. Thank you -- View this message in context: http://old.nabble.com/Events-in-Workflows-tp28101842p28101842.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- View this message in context: http://old.nabble.com/Events-in-Workflows-tp28101842p28150573.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Find Known Errors that are NOT related to a Change
Here's a quick stab at how I'd do it. I'm not sure if you're trying to show this info in a report or in a form, but basically you want to compare records in PBM:Known Error against PBM:Known error Associations. Then search against Request ID02 where it does not match Known Error ID and Request Type equals Infrastructure Change. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 jha...@gmail.com 04/06/10 3:08 AM I am trying to figure out how to find Known Errors that are not associated to a Change request. We are using Known Errors to track bugs and enhancements to in-house software. We associate corrected KEs to change requests as a Release. I am trying to find KEs that are not associated to a change (release) to make sure that they are addressed and don't fall through the cracks. I can easily find which ones are associated to a change by looking at the Associations forms, but I am stumped on how to find ones that are NOT associated. We are on ARS 7.1 and ITSM 7.03. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Executing ALs in ALGs on predefined interval
Lad to hear :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of pivanov Sent: Tuesday, April 06, 2010 1:11 AM To: arslist@ARSLIST.ORG Subject: Re: Executing ALs in ALGs on predefined interval Hi LJ, thanks a lot for your reply. Yesterday i managed that and did something like you suggested :) Cheers, Plamen Ivanov www.remedy.bg On 1 Апр, 20:10, LJ Longwing lj.longw...@gmail.com wrote: Ok...this is ugly, but it should work. Create two tmp fields, one is 'current record', another is 'execute time' Create an AL that fires on interval of something like 3 seconds Have it call a guide looping through the table Within that guide have it check to see if the currently selected row = 'current record'...and if $TIMESTAMP$ 'execute time'if it is, do what you need and then increment 'current record' and 'execute time' appropriatelythe next time the loop runs it will only fire if the timestamp is greater than your 'execute time' and the row you are to take action on matches the row you set There's lots of logistics that would need to be worked out beyond what I have outlinedbut it shouldn't be too hard to do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of pivanov Sent: Thursday, April 01, 2010 2:50 AM To: arsl...@arslist.org Subject: Executing ALs in ALGs on predefined interval Hello, i need to perform table loop with ALG, which must to fire ALs with delay (after 1 minutes for example) after each interaction. (executing on 1rst row - wait 1 min - execute on 2nd row - wait 1 min and so on) That must to be done without user interaction (wait action is not working in that case as I think) Is that possible and how I can realize it? Thanks in advance, Plamen Ivanov __ _-_ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug10www.wwrug.comARSlist: Where the Answers Are __ _- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are- Скриване на цитирания текст - - Показване на цитирания текст - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS 7.5 User Cache Gremlin
I trapped an instance of it today on the ARS 7.5.00.004 - ITSM 7.6.00.001 server that has sample data loaded. Yesterday, at 15:20:29 the MidTier Service logged in. Then it tried to login Demo (impersonated): USER: MidTier Service /* Mon Apr 05 2010 15:20:29.4000 */ LOGIN MidTier Service USER: Demo /* Mon Apr 05 2010 15:20:29.4000 */ LOGIN Demo (impersonated) USER: Demo-- Impersonated by MidTier Service -- /* Mon Apr 05 2010 15:20:29.4050 */ LOGOUT Demo USER: Demo /* Mon Apr 05 2010 15:20:29.4240 */ LOGIN FAILED Demo (user) ...followed by: USER: Demo /* Mon Apr 05 2010 15:20:29.5110 */ LOGIN FAILED Demo (lockout) The mid-tier logs show 25 lines of: Apr 5, 2010 3:20:29 PM - FINE (com.remedy.log.INTERNAL) : Throw ARException - ERROR (623): Authentication failed; ERROR (623): Authentication failed; ...followed by a crash: Apr 5, 2010 3:20:29 PM - FINE (com.remedy.log.INTERNAL) : Throw Error - 9280 Apr 5, 2010 3:20:29 PM - SEVERE (com.remedy.log.DVMODULE) : Exception while processing requestARERR [9280] Server not present in the configured servers list - ldalvi-pun-02v75p2 at com.remedy.arsys.stubs.ServerLogin.getServerInformation(Unknown Source) (followed by 25 more lines of goat barfing) ...so, something is trying to connect thru the mid-tier to a server named ldalvi-pun-02v75p2 - wherever that came from. So far the only time I have seen the impersonation of Demo by the mid-tier service when I KNOW what triggered it, is when I launch the Atrium Core Console. I can do so successfully on the same server with the appadmin account, so the Console is configured correctly. It must be something else trying to access something via the mid-tier, in the background, using Demo with a blank password and pointing to that bizarre server name. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: Monday, March 29, 2010 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 User Cache Gremlin ** Christopher, What you are seeing here -- the word INVALID being the password in the user_cache record -- is a characteristic of the system disabling the account. This word will never hash from any password so the account is inherently disabled but we can find all accounts that have been disabled by searching for the word INVALID. So, how does a user get disabled by the system? Generally, the cause of this is having a maximum number of bad passwords setting and there being a set of login attempts of that user with bad passwords that exceed the maximum count. Do you have user logging on during the night to see if there are attempts to login as this user and getting bad password attempts? There is a bad password attempt counter on the user_cache record. What is that number when you see the password as INVALID? Could there be an old integration somewhere that runs periodically that runs during the night that causes the buildup of bad passwords and you have changed the password? Maybe during the day, other integrations are running which are OK and they cause a reset so this bad password doesn't trigger except during quiet times when other things are not running? I don't know of another reason that the word INVALID is written to the user_cache record. A change on 1st login would not because you need your password to get in and then you are asked to change it. Marking a user as disabled or something leaves their password record there. So, I assume you have the setting for max bad passwords before invalidating the user feature active -- if not, I am very confused at this point how the word INVALID is getting in the user_cache. And, then, it is tracking down where the bad login attempts for the user Demo are coming from. I don't know if we are logging anywhere that a user is being invalidated for too many bad passwords. But, you may want to see if there is a note in the server error log. I hope this gives a pointer to help track down what is happening. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Friday, March 26, 2010 8:41 AM To: arslist@ARSLIST.ORG Subject: ARS 7.5 User Cache Gremlin ** This week we started seeing a brand new gremlin on our two ARS 7.5.00.004 - ITSM 7.6.00.001 servers. The Demo account gets flagged as having an INVALID password overnight. If you reset its password, it's good for the day, but the next morning it is not valid again. When you look at the actual record in the dbo.user.cache table on the SQL Server,
Re: ARS 7.5 User Cache Gremlin
Looks like perhaps a stray piece of test data someone forgot to strip out. It isn't in the 7.6 WS or Filters I saw. Rick -Original Message- From: strauss stra...@unt.edu Date: Tue, 6 Apr 2010 10:01:08 To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 User Cache Gremlin I trapped an instance of it today on the ARS 7.5.00.004 - ITSM 7.6.00.001 server that has sample data loaded. Yesterday, at 15:20:29 the MidTier Service logged in. Then it tried to login Demo (impersonated): USER: MidTier Service /* Mon Apr 05 2010 15:20:29.4000 */ LOGIN MidTier Service USER: Demo /* Mon Apr 05 2010 15:20:29.4000 */ LOGIN Demo (impersonated) USER: Demo-- Impersonated by MidTier Service -- /* Mon Apr 05 2010 15:20:29.4050 */ LOGOUT Demo USER: Demo /* Mon Apr 05 2010 15:20:29.4240 */ LOGIN FAILED Demo (user) ...followed by: USER: Demo /* Mon Apr 05 2010 15:20:29.5110 */ LOGIN FAILED Demo (lockout) The mid-tier logs show 25 lines of: Apr 5, 2010 3:20:29 PM - FINE (com.remedy.log.INTERNAL) : Throw ARException - ERROR (623): Authentication failed; ERROR (623): Authentication failed; ...followed by a crash: Apr 5, 2010 3:20:29 PM - FINE (com.remedy.log.INTERNAL) : Throw Error - 9280 Apr 5, 2010 3:20:29 PM - SEVERE (com.remedy.log.DVMODULE) : Exception while processing requestARERR [9280] Server not present in the configured servers list - ldalvi-pun-02v75p2 at com.remedy.arsys.stubs.ServerLogin.getServerInformation(Unknown Source) (followed by 25 more lines of goat barfing) ...so, something is trying to connect thru the mid-tier to a server named ldalvi-pun-02v75p2 - wherever that came from. So far the only time I have seen the impersonation of Demo by the mid-tier service when I KNOW what triggered it, is when I launch the Atrium Core Console. I can do so successfully on the same server with the appadmin account, so the Console is configured correctly. It must be something else trying to access something via the mid-tier, in the background, using Demo with a blank password and pointing to that bizarre server name. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: Monday, March 29, 2010 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 User Cache Gremlin ** Christopher, What you are seeing here -- the word INVALID being the password in the user_cache record -- is a characteristic of the system disabling the account. This word will never hash from any password so the account is inherently disabled but we can find all accounts that have been disabled by searching for the word INVALID. So, how does a user get disabled by the system? Generally, the cause of this is having a maximum number of bad passwords setting and there being a set of login attempts of that user with bad passwords that exceed the maximum count. Do you have user logging on during the night to see if there are attempts to login as this user and getting bad password attempts? There is a bad password attempt counter on the user_cache record. What is that number when you see the password as INVALID? Could there be an old integration somewhere that runs periodically that runs during the night that causes the buildup of bad passwords and you have changed the password? Maybe during the day, other integrations are running which are OK and they cause a reset so this bad password doesn't trigger except during quiet times when other things are not running? I don't know of another reason that the word INVALID is written to the user_cache record. A change on 1st login would not because you need your password to get in and then you are asked to change it. Marking a user as disabled or something leaves their password record there. So, I assume you have the setting for max bad passwords before invalidating the user feature active -- if not, I am very confused at this point how the word INVALID is getting in the user_cache. And, then, it is tracking down where the bad login attempts for the user Demo are coming from. I don't know if we are logging anywhere that a user is being invalidated for too many bad passwords. But, you may want to see if there is a note in the server error log. I hope this gives a pointer to help track down what is happening. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Friday, March 26, 2010 8:41 AM To: arslist@ARSLIST.ORG Subject: ARS 7.5 User Cache Gremlin ** This week we started seeing a brand new gremlin on our two
Re: How to display DATE field in date format (from DB)
Hi, Please look to the Database reference. Here you have the instruction for all supported database. Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 3:59 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Find Known Errors that are NOT related to a Change
You could easily do this using a join form between PBM:Known Error and PBM:Known Error Associations. Create the form as an outer join with the associations form on the right. You join criteria will be $Known Error ID$ = 'Request ID02' AND 'Request Type01' = Infrastructure Change. Add the Known Error ID field and Request ID02 fields to the form. When you do a search, it will show a record for each Known Error record. If there is a match in the associations table, it will also bring that information in as well. If there is no match, then any fields from the associations table that you put on the join form (Request ID02 in this case) will be NULL. So to find all Known Errors that don't have a corresponding change, just search for all the records in the join form where one of the association fields (Request ID02) is $NULL$. That will show all Known Errors that don't have a corresponding relationship record to a Change. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Benedetto Cantatore Sent: Tuesday, April 06, 2010 7:48 AM To: arslist@ARSLIST.ORG Subject: Re: Find Known Errors that are NOT related to a Change ** Here's a quick stab at how I'd do it. I'm not sure if you're trying to show this info in a report or in a form, but basically you want to compare records in PBM:Known Error against PBM:Known error Associations. Then search against Request ID02 where it does not match Known Error ID and Request Type equals Infrastructure Change. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 jha...@gmail.com 04/06/10 3:08 AM I am trying to figure out how to find Known Errors that are not associated to a Change request. We are using Known Errors to track bugs and enhancements to in-house software. We associate corrected KEs to change requests as a Release. I am trying to find KEs that are not associated to a change (release) to make sure that they are addressed and don't fall through the cracks. I can easily find which ones are associated to a change by looking at the Associations forms, but I am stumped on how to find ones that are NOT associated. We are on ARS 7.1 and ITSM 7.03. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com 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 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed. BTW - I am responding with the iPad. It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it. -John Sent from my iPad On Apr 5, 2010, at 4:47 PM, Paolino, Andrew apaol...@columnit.com wrote: ** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful. John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues…. Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com Skype ID: apaolino Web: http://www.columnit.com P Please consider the environment before printing this email From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Monday, April 05, 2010 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J 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 Pierson, Shawn Sent: Monday, April 05, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc. Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting, but it seems too limiting to me. 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. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
** John,So to resurrect a thread from a couple of months ago, do other Remedy apps work on your iPad, or is there too much dependency on Flash in the current versions? I don't expect Flashboards or the CI viewer, but how about minimal functionality on an Incident? Safari's a supported browser.I don't expect the iPad to be able to do *everything* in 1st iteration, but I was impressed with Steven Colbert's use of an IPad as vegetable slicer the other night. Can't really do that well with an iPhone.DougOn Apr 6, 2010, at 11:29 AM, John Sundberg wrote:** I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed.BTW - I am responding with the iPad.It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it.-JohnSent from my iPadOn Apr 5, 2010, at 4:47 PM, "Paolino, Andrew" apaol...@columnit.com wrote:** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful.John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues….Andrew PaolinoColumn Technologies130 William Street, 8th FloorNew York, New York 10038Cell: 551-486-2549Office: 201-676-0277Fax: 212-227-3040Email: apaol...@columnit.comSkype ID: apaolinoWeb: http://www.columnit.comP Please consider the environment before printing this email From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Monday, April 05, 2010 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J Tauf Chowdhury| Forest Laboratories, Inc.Analyst, Service ManagementMobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Monday, April 05, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc.Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting, but it seems too limiting to me. 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._attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ Doug--Doug Blaird...@blairing.com+1 224-558-5462200 North Arlington Heights RoadArlington Heights, Illinois 60004 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
AIE not connecting with rlohelper getting Error ORA-12514
I have a new installation of AIE running 7.1 Patch 8 running on a ARS 7.1 Patch 6. When I try to connect AIE to an Oracle 10G database I get the following error: *** ERROR *** ORA-12514: TNS:listener does not currently know of service requested in connect descriptor My DBAs tell me that my TNS:Listner is running fine. I can tnsping the databases from the Remedy server as well as SQL Plus into them so it seems like they should be fine. Does anyone have any suggestions on this? Regards, David Charters 317-331-8985 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
Doug, I can check if the iPad works on the latest version of MidTier -- if somebody has an external link I can get to. Otherwise - I will spin up a 7.5 and try it out -- and let you know. One thing the iPad/Safari does not do - is upload files. (No real file system is available to upload from anyway) -- probably the same with download -- except I would imagine it does launch other apps with the file. For example: a ppt would open in Keynote. a pdf would open in (some viewer). etc... I think it has quite a few viewers built into the mail application -- as I was able to see an XL ss and Visio diagrams in an email sent to me earlier today. For a totally sweet usage of Kinetic Request -- Contract Management (it will be used to manage the vendor onboarding process at this company) So - if anybody has an external 7.5+ Remedy app -- that they would like me to load on the iPad -- let me know. -John On Apr 6, 2010, at 11:58 AM, Doug Blair wrote: ** John, So to resurrect a thread from a couple of months ago, do other Remedy apps work on your iPad, or is there too much dependency on Flash in the current versions? I don't expect Flashboards or the CI viewer, but how about minimal functionality on an Incident? Safari's a supported browser. I don't expect the iPad to be able to do *everything* in 1st iteration, but I was impressed with Steven Colbert's use of an IPad as vegetable slicer the other night. Can't really do that well with an iPhone. Doug On Apr 6, 2010, at 11:29 AM, John Sundberg wrote: ** I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed. BTW - I am responding with the iPad. It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it. -John Sent from my iPad On Apr 5, 2010, at 4:47 PM, Paolino, Andrew apaol...@columnit.com wrote: ** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful. John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues…. Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com Skype ID: apaolino Web: http://www.columnit.com P Please consider the environment before printing this email From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Chowdhury, Tauf Sent: Monday, April 05, 2010 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Pierson, Shawn Sent: Monday, April 05, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc. Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting, but it seems too limiting to me. 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
Re: OT:Kinetic apps and some iPad fun
Double checked my facts -- it is a .pdf of a visio. So -- the email client may be able to view a visio -- but what I did see was a .pdf of the visio - as that is what was attached. -John On Apr 6, 2010, at 12:36 PM, John Sundberg wrote: Doug, I can check if the iPad works on the latest version of MidTier -- if somebody has an external link I can get to. Otherwise - I will spin up a 7.5 and try it out -- and let you know. One thing the iPad/Safari does not do - is upload files. (No real file system is available to upload from anyway) -- probably the same with download -- except I would imagine it does launch other apps with the file. For example: a ppt would open in Keynote. a pdf would open in (some viewer). etc... I think it has quite a few viewers built into the mail application -- as I was able to see an XL ss and Visio diagrams in an email sent to me earlier today. For a totally sweet usage of Kinetic Request -- Contract Management (it will be used to manage the vendor onboarding process at this company) So - if anybody has an external 7.5+ Remedy app -- that they would like me to load on the iPad -- let me know. -John On Apr 6, 2010, at 11:58 AM, Doug Blair wrote: ** John, So to resurrect a thread from a couple of months ago, do other Remedy apps work on your iPad, or is there too much dependency on Flash in the current versions? I don't expect Flashboards or the CI viewer, but how about minimal functionality on an Incident? Safari's a supported browser. I don't expect the iPad to be able to do *everything* in 1st iteration, but I was impressed with Steven Colbert's use of an IPad as vegetable slicer the other night. Can't really do that well with an iPhone. Doug On Apr 6, 2010, at 11:29 AM, John Sundberg wrote: ** I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed. BTW - I am responding with the iPad. It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it. -John Sent from my iPad On Apr 5, 2010, at 4:47 PM, Paolino, Andrew apaol...@columnit.com wrote: ** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful. John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues…. Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com Skype ID: apaolino Web: http://www.columnit.com P Please consider the environment before printing this email From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Chowdhury, Tauf Sent: Monday, April 05, 2010 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Pierson, Shawn Sent: Monday, April 05, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc. Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting, but it seems too limiting to me. 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
Re: Suggestions for daily auto Crystal Report export email?
Alan; The problem with most of the freeware are the limitations (it is free after all). So the more options you want to do the harder it is to use a free one. The cheapest product I have found that has the most options is CRD from Christiansteven software. http://www.christiansteven.com/index.html Bill Clary Bright House R. Alan Monroe amon...@columbus.rr.com wrote in message news:199439918178.20100403093...@columbus.rr.com... I'm looking for some freeware that can export _standalone .rpt files_ created with Crystal Reports 9.x (we DON'T have any Crystal Enterprise etc. backend infrastructure nor any web server) daily with changing date parameters and email them to a short list of recipients. At the moment I have to manually run them from the user tool, save pdfs and email them by hand. My top candidate from the handful I found on the top google hits was Crystal Delivery from groffautomation.com, which worked great on my local workstation, but fails to output reports when run on the server (Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). I am open to just about any solutions, gui, commandline, or even source code (this seemed like something one could cobble together using VBScript and COM, but I couldn't google up a Crystal COM API reference sheet). Alan CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for daily auto Crystal Report export email?
HI Bill, good to see you on the list. We also use CRD. It is a wonderful product. We dropped CRD a few years ago when we went to Crystal 11 and had a full Crystal Reports Server that can also automate reports. We found that CR Server had many limitations, it was kind of clunky and we had to use all kinds of work arounds to things that were easy in CRD (like suppress sending a blank report). When talking to BO/SAP they were trying to up sell us to other products. We brought back CRD and have been happy since. I highly recommend CRD for report automation. Jason On Tue, Apr 6, 2010 at 11:07 AM, Clary, William M. william.cl...@mybrighthouse.com wrote: Alan; The problem with most of the freeware are the limitations (it is free after all). So the more options you want to do the harder it is to use a free one. The cheapest product I have found that has the most options is CRD from Christiansteven software. http://www.christiansteven.com/index.html Bill Clary Bright House R. Alan Monroe amon...@columbus.rr.com wrote in message news: 199439918178.20100403093...@columbus.rr.com... I'm looking for some freeware that can export _standalone .rpt files_ created with Crystal Reports 9.x (we DON'T have any Crystal Enterprise etc. backend infrastructure nor any web server) daily with changing date parameters and email them to a short list of recipients. At the moment I have to manually run them from the user tool, save pdfs and email them by hand. My top candidate from the handful I found on the top google hits was Crystal Delivery from groffautomation.com, which worked great on my local workstation, but fails to output reports when run on the server (Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). I am open to just about any solutions, gui, commandline, or even source code (this seemed like something one could cobble together using VBScript and COM, but I couldn't google up a Crystal COM API reference sheet). Alan CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AIE not connecting with rlohelper getting Error ORA-12514
Go to the Atrium Integration Engine console. Then go to the Configuration-Connections link. You should be at the Connections Console. Click on the Oracle tab. For each data exchange you have listed on the left you can configure the Oracle connection setting. You must do several things for it to work properly: 1. The SID/DB Alias must be configured in your TNSNames.ora file. 2. The path to the DB Directory must be correct. 3. Your Login/Password must be correct. At startup there is a aie001 startup script that contains the library paths in an environment variable called AIE_ORACLE_LIB_DIR make sure that is set. If missing reintsall AIE. Another thing to check (although I don't think this is it) is the eie.reg file in the conf directory of where you installed aie. In there should be an entry for your Oracle adapter. If it isn't there just reinstall AIE. That's about all I can think of. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of David Charters Sent: Tuesday, April 06, 2010 1:04 PM To: arslist@ARSLIST.ORG Subject: AIE not connecting with rlohelper getting Error ORA-12514 ** I have a new installation of AIE running 7.1 Patch 8 running on a ARS 7.1 Patch 6. When I try to connect AIE to an Oracle 10G database I get the following error: *** ERROR *** ORA-12514: TNS:listener does not currently know of service requested in connect descriptor My DBAs tell me that my TNS:Listner is running fine. I can tnsping the databases from the Remedy server as well as SQL Plus into them so it seems like they should be fine. Does anyone have any suggestions on this? Regards, David Charters 317-331-8985 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AIE not connecting with rlohelper getting Error ORA-12514
I ran into a similar error on AIE. Our Oracle team patched to a version that no longer used tnsname.ora so I just had to remove the entire fqdn and used the short alias. Instead of the SID being db.tis.company.com it is now just db. The only way I could find the correct SID to use was to ping the name until I received a return then plugged that value into AIE. Of course I could not get the full story from the oracle team as to what happened when and why no one was informed but you know how those magical, mystical db gurus are. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, April 06, 2010 1:35 PM To: arslist@ARSLIST.ORG Subject: Re: AIE not connecting with rlohelper getting Error ORA-12514 ** Go to the Atrium Integration Engine console. Then go to the Configuration-Connections link. You should be at the Connections Console. Click on the Oracle tab. For each data exchange you have listed on the left you can configure the Oracle connection setting. You must do several things for it to work properly: 1. The SID/DB Alias must be configured in your TNSNames.ora file. 2. The path to the DB Directory must be correct. 3. Your Login/Password must be correct. At startup there is a aie001 startup script that contains the library paths in an environment variable called AIE_ORACLE_LIB_DIR make sure that is set. If missing reintsall AIE. Another thing to check (although I don't think this is it) is the eie.reg file in the conf directory of where you installed aie. In there should be an entry for your Oracle adapter. If it isn't there just reinstall AIE. That's about all I can think of. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of David Charters Sent: Tuesday, April 06, 2010 1:04 PM To: arslist@ARSLIST.ORG Subject: AIE not connecting with rlohelper getting Error ORA-12514 ** I have a new installation of AIE running 7.1 Patch 8 running on a ARS 7.1 Patch 6. When I try to connect AIE to an Oracle 10G database I get the following error: *** ERROR *** ORA-12514: TNS:listener does not currently know of service requested in connect descriptor My DBAs tell me that my TNS:Listner is running fine. I can tnsping the databases from the Remedy server as well as SQL Plus into them so it seems like they should be fine. Does anyone have any suggestions on this? Regards, David Charters 317-331-8985 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about the Service field on a 7.6 Incident
I hit the same thing you did when I tried to open and/or resolve test Incidents with the sample data users. Did you install the BSM Enablement data for the BMC Atrium CMDB (separate download from BMCDN)? I wondered if it contained any sample defined business services. Nothing came in with ITSM Sample Data, of course, and nothing came in with the Product Catalog data, which I did import on the sample data server during the Atrium Core install (it makes it impossible to bring your own foundation data in because it loads the app up with companies and sites, etc., that overlap the ones we have defined). I might try loading it even though it says it is for 7.5 or 7.5.00.001 and I am on 7.6.00.001. I'll be blowing away the sample data server fairly soon anyway - it's on the production hardware. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Monday, April 05, 2010 12:15 PM To: arslist@ARSLIST.ORG Subject: Question about the Service field on a 7.6 Incident ** I am working with a new ITSM 7.6 install to test an integration, and am starting with the existing sample data. I created some servers to use as CIs, related them to people as Used by, but I cannot figure out the nature of the required Service field on the Incident. This is keeping me from creating new Incidents or processing existing ones. I get what a Service is from an ITIL perspective, but requiring it is a new thing in ITSM, and I have a few questions about it. ARS 7.5p3/ITSM 7.6p1 (IM/PM/AM/CM/CMDB). Windows 2003/SQL 2005. * Why is the Service field required? * How can I make it optional via configuration? * Is it standard practice for the field to be required? Why? * As I understand it, this field's menu can be populated with Application Service CIs. I see the CMDB form in which those would go, but I have no guidelines from which to know how those are defined. Any assistance would be appreciated. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about the Service field on a 7.6 Incident
No, I didn't install that component, and there were no services installed with the sample data. Rick -Original Message- From: strauss stra...@unt.edu Date: Tue, 6 Apr 2010 14:43:03 To: arslist@ARSLIST.ORG Subject: Re: Question about the Service field on a 7.6 Incident I hit the same thing you did when I tried to open and/or resolve test Incidents with the sample data users. Did you install the BSM Enablement data for the BMC Atrium CMDB (separate download from BMCDN)? I wondered if it contained any sample defined business services. Nothing came in with ITSM Sample Data, of course, and nothing came in with the Product Catalog data, which I did import on the sample data server during the Atrium Core install (it makes it impossible to bring your own foundation data in because it loads the app up with companies and sites, etc., that overlap the ones we have defined). I might try loading it even though it says it is for 7.5 or 7.5.00.001 and I am on 7.6.00.001. I'll be blowing away the sample data server fairly soon anyway - it's on the production hardware. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Monday, April 05, 2010 12:15 PM To: arslist@ARSLIST.ORG Subject: Question about the Service field on a 7.6 Incident ** I am working with a new ITSM 7.6 install to test an integration, and am starting with the existing sample data. I created some servers to use as CIs, related them to people as Used by, but I cannot figure out the nature of the required Service field on the Incident. This is keeping me from creating new Incidents or processing existing ones. I get what a Service is from an ITIL perspective, but requiring it is a new thing in ITSM, and I have a few questions about it. ARS 7.5p3/ITSM 7.6p1 (IM/PM/AM/CM/CMDB). Windows 2003/SQL 2005. * Why is the Service field required? * How can I make it optional via configuration? * Is it standard practice for the field to be required? Why? * As I understand it, this field's menu can be populated with Application Service CIs. I see the CMDB form in which those would go, but I have no guidelines from which to know how those are defined. Any assistance would be appreciated. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
If your DB is SQL, then use this function:- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER function [dbo].[fn_Convert_Date_HMS](@i int) returns datetime as begin return (Select DATEADD(second, @i+19800,'19700101')) end Thanks Regards, Rambabu Rudra System Administrator _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 7:29 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about the Service field on a 7.6 Incident
There is a Rules setting in that you can set to not require a Service. You can also set the Classic view back as the default view for each module instead of using the Best Practices view. There is a Best Practice view for each module in 7.6 as well instead of just the Incident form. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, April 06, 2010 2:48 PM To: arslist@ARSLIST.ORG Subject: Re: Question about the Service field on a 7.6 Incident ** No, I didn't install that component, and there were no services installed with the sample data. Rick From: strauss stra...@unt.edu Date: Tue, 6 Apr 2010 14:43:03 -0500 To: arslist@ARSLIST.ORG Subject: Re: Question about the Service field on a 7.6 Incident I hit the same thing you did when I tried to open and/or resolve test Incidents with the sample data users. Did you install the BSM Enablement data for the BMC Atrium CMDB (separate download from BMCDN)? I wondered if it contained any sample defined business services. Nothing came in with ITSM Sample Data, of course, and nothing came in with the Product Catalog data, which I did import on the sample data server during the Atrium Core install (it makes it impossible to bring your own foundation data in because it loads the app up with companies and sites, etc., that overlap the ones we have defined). I might try loading it even though it says it is for 7.5 or 7.5.00.001 and I am on 7.6.00.001. I'll be blowing away the sample data server fairly soon anyway - it's on the production hardware. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Monday, April 05, 2010 12:15 PM To: arslist@ARSLIST.ORG Subject: Question about the Service field on a 7.6 Incident ** I am working with a new ITSM 7.6 install to test an integration, and am starting with the existing sample data. I created some servers to use as CIs, related them to people as Used by, but I cannot figure out the nature of the required Service field on the Incident. This is keeping me from creating new Incidents or processing existing ones. I get what a Service is from an ITIL perspective, but requiring it is a new thing in ITSM, and I have a few questions about it. ARS 7.5p3/ITSM 7.6p1 (IM/PM/AM/CM/CMDB). Windows 2003/SQL 2005. * Why is the Service field required? * How can I make it optional via configuration? * Is it standard practice for the field to be required? Why? * As I understand it, this field's menu can be populated with Application Service CIs. I see the CMDB form in which those would go, but I have no guidelines from which to know how those are defined. Any assistance would be appreciated. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about the Service field on a 7.6 Incident
Rick, One answer for you. The Service field it optional, can can be turned off in: App Admin - Custom Configuration - Incident Management - Advanced Options - Rules Search for the company or Global Require Service CI Related on Submit - change to No John On 4/6/2010 2:48 PM, Rick Cook wrote: ** No, I didn't install that component, and there were no services installed with the sample data. Rick *From: * strauss stra...@unt.edu *Date: *Tue, 6 Apr 2010 14:43:03 -0500 *To: *arslist@ARSLIST.ORG *Subject: *Re: Question about the Service field on a 7.6 Incident I hit the same thing you did when I tried to open and/or resolve test Incidents with the sample data users. Did you install the BSM Enablement data for the BMC Atrium CMDB (separate download from BMCDN)? I wondered if it contained any sample defined business services. Nothing came in with ITSM Sample Data, of course, and nothing came in with the Product Catalog data, which I did import on the sample data server during the Atrium Core install (it makes it impossible to bring your own foundation data in because it loads the app up with companies and sites, etc., that overlap the ones we have defined). I might try loading it even though it says it is for 7.5 or 7.5.00.001 and I am on 7.6.00.001. I’ll be blowing away the sample data server fairly soon anyway – it’s on the production hardware. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Monday, April 05, 2010 12:15 PM *To:* arslist@ARSLIST.ORG *Subject:* Question about the Service field on a 7.6 Incident ** I am working with a new ITSM 7.6 install to test an integration, and am starting with the existing sample data. I created some servers to use as CIs, related them to people as Used by, but I cannot figure out the nature of the required Service field on the Incident. This is keeping me from creating new Incidents or processing existing ones. I get what a Service is from an ITIL perspective, but requiring it is a new thing in ITSM, and I have a few questions about it. ARS 7.5p3/ITSM 7.6p1 (IM/PM/AM/CM/CMDB). Windows 2003/SQL 2005. * Why is the Service field required? * How can I make it optional via configuration? * Is it standard practice for the field to be required? Why? * As I understand it, this field's menu can be populated with Application Service CIs. I see the CMDB form in which those would go, but I have no guidelines from which to know how those are defined. Any assistance would be appreciated. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- ** John A. Underwood NDUS Help Center Project Manager IACC Rm. 206NDSU/ITS Help Desk Manager NDUS Help Desk Co-Manager 1320 Albrecht Blvd. Office: (701) 231-6109 Fargo, ND 58105Cell: (701) 730-5337 e-mail: john.underw...@ndsu.edu Fax:(701) 231-8541 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: KMX problems
Thanks Alan! I was able to get things resolved. I don't know why, but the Hummingbird UI is toast on my server, so I was forced to utilize the command line app. It turned out that the issue was a News Flash item that was in there from a couple of years back. It seemed to be corrupted in some way (I couldn't tell how/why). I removed every item from the published folder. I then triggered the index check for that folder. I then placed the published docs back in small batches. Each time running the index. I did this till it failed. I then went through the failed bunch until I found the offending document and DELTED it! Once I did that, the rest went in as nice as could be. Now everything is indexing just fine. I suspect that the corrupted doc may have been playing havoc with some other items... Now if I could just figure out why the UI is hosed! Take care! Warren On Fri, Apr 2, 2010 at 10:35 AM, Alan Blake alan_knowly...@yahoo.comwrote: ** Hummingbird has a UI where you can go in and unprotect and delete the tables if needed and then the rebuild should be able to build the entire index over from scratch. The URL is typically http://server:8666/ssadmin Alan Blake Knowlysis --- On *Thu, 4/1/10, Warren Baltimore warrenbaltim...@gmail.com* wrote: From: Warren Baltimore warrenbaltim...@gmail.com Subject: KMX problems To: arslist@ARSLIST.ORG Date: Thursday, April 1, 2010, 3:47 PM ** Folks, I am blindly trying to fix a problem with my Knowledge base. First off... KB is running on a Windows 2000 server. It is KMX 5.4 (I think). Running on Hummingbird 5.4. It's normally very quiet and I don't need to do anything, but I followed the instructions to update the indexes (Killed KMS Indexing Service and IIS). Ran the Update scripts Brought everything back andMy helpdesk complained that it was even worse! They were right. The thing was fried. So, I ran kms_Rebuild.bat. This seemed to clean things up BUT none of the published KB's are available! I went back and took a look, and whenever the Published index attempts to build, it comes back with an error: *C:\Program Files\ar system\apps\kms\bin\Indexingexecsql c:\progra~1\arsyst~1\ap ps\kms\bin\indexing\up.txt* *validate index published validate table; execsql: execute failed* *SQLSTATE: 80913, Native error: 0, error text [Hummingbird][SearchServer]Table is protected* * *C:\Program Files\ar system\apps\kms\bin\Indexingpause Press any key to continue . . .* Now, I've tried everything I can think of but no luck. I have even tried adding unprotect table Published; to the Update_Published.bat script without any luck. The other update scripts run fine. Just not the published -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Hi, Please look to the Database reference. Here you have the instruction for all supported database. Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 3:59 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John On Apr 6, 2010, at 11:58 AM, Doug Blair wrote: ** John, So to resurrect a thread from a couple of months ago, do other Remedy apps work on your iPad, or is there too much dependency on Flash in the current versions? I don't expect Flashboards or the CI viewer, but how about minimal functionality on an Incident? Safari's a supported browser. I don't expect the iPad to be able to do *everything* in 1st iteration, but I was impressed with Steven Colbert's use of an IPad as vegetable slicer the other night. Can't really do that well with an iPhone. Doug On Apr 6, 2010, at 11:29 AM, John Sundberg wrote: ** I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed. BTW - I am responding with the iPad. It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it. -John Sent from my iPad On Apr 5, 2010, at 4:47 PM, Paolino, Andrew apaol...@columnit.com wrote: ** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful. John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues…. Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com Skype ID: apaolino Web: http://www.columnit.com P Please consider the environment before printing this email From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Chowdhury, Tauf Sent: Monday, April 05, 2010 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Pierson, Shawn Sent: Monday, April 05, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc. Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting, but it seems too limiting to me. 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
Re: ARReload Issue - Please Help (UNCLASSIFIED)
Thanks to one and all,
Appreciate all your efforts,
For the first time I am using arreload command line utility.
I have used it in my dev server with below syntaxes; please correct me if I
am wrong at anywhere.
I have run the below command on USER Form
C:\Program Files\AR System\serverarreload -a MyAdmin -p password -u
User -f -d
The above command successfully reloaded all the user entries in the cache.
Here are my questions -
1) Can we have any log file during arreload command runs with all the
details?
2) Can we run arreload command for a single user? How?
3) Do I require restarting any of the Remedy services after running arreload
command?
I have run the below command on GROUP Form
C:\Program Files\AR System\serverarreload -a MyAdmin -p password -u
Group -f -d
Giving error as below
Updating 'target' server -- localhost
Verifying Admin access to server
Deleting existing group cache entries on localhost
Reloading groups
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Group does not exist on server (ARERR 318)
Any help?
Thanks Regards,
Rambabu Rudra
System Administrator
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of William Abdo
Sent: Friday, April 02, 2010 2:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help (UNCLASSIFIED)
Hi Rambabu,
I believe you are confusing the command with arcache:
arcache has the L option.
arcache -Ua -e9888597 -n tmpuser -p admin -g 1: -lw 1
Arreload does not have the L option.
arreload -a adminUser [-p adminPassword] {-u|-g} schema [-f] [-s
server_name] [-h Server-Name_value][-d]
Respectfully,
William Abdo
Verio - Boca Raton
Remedy Administration Group
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Luttmann, Michael W CTR USA
Sent: Thursday, April 01, 2010 2:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: FOUO
I guess I meant uppercase I versus lowercase L... but you got my
meaning anyway.
When Frank advised the command arreload -a Admin -p password -g 1 -l 1
to indicate the license type, I would think the proper parameter
would be L for License.
Mike L.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ram Rudra
Sent: Monday, March 29, 2010 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help (UNCLASSIFIED)
It's a lowercase l.
Thanks Regards,
Rambabu Rudra
System Administrator
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Luttmann, Michael W CTR USA
Sent: Monday, March 29, 2010 8:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: FOUO
Is that a lowercase L or a lowercase I?
Michael W. Luttmann
Lead Remedy Developer
Fort Carson NEC
If you don't like change, you're going to dislike irrelevance even
more.
Gen Shinseki
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ram Rudra
Sent: Monday, March 29, 2010 4:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help
**
I am getting the below error after running the given command. Any help
would be appreciated.
C:\Program Files\AR System\serverarreload -a myadmin -p password -g 1
-l 1
Unrecognized command line option (ARERR 601)
-l
C:\Program Files\AR System\serverarreload -a myadmin -p password -g 1
Invalid password or authentication string for an existing user (ARERR
329)
server
Thanks Regards,
Rambabu Rudra
System Administrator
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Sunday, March 28, 2010 10:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARReload Issue - Please Help
** Read the documentation on this command.
When reloading the Admin user you need to tell the group number 1 as
well as the license type. Something like the following:
arreload -a Admin -p password -g 1 -l 1
On Sun, Mar 28, 2010 at 7:17 PM, Ram Rudra
rambabu.ru...@gssamerica.com
Re: OT:Kinetic apps and some iPad fun
This sounds very similar to what I have seen trying to use a Blackberry with Mid-Tier. Jason On Tue, Apr 6, 2010 at 1:46 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John On Apr 6, 2010, at 11:58 AM, Doug Blair wrote: ** John, So to resurrect a thread from a couple of months ago, do other Remedy apps work on your iPad, or is there too much dependency on Flash in the current versions? I don't expect Flashboards or the CI viewer, but how about minimal functionality on an Incident? Safari's a supported browser. I don't expect the iPad to be able to do *everything* in 1st iteration, but I was impressed with Steven Colbert's use of an IPad as vegetable slicer the other night. Can't really do that well with an iPhone. Doug On Apr 6, 2010, at 11:29 AM, John Sundberg wrote: ** I checked and yes Kinetic Response works with the iPad. So the idea is a mobile worker or manager in a meeting can immediately connect up and see the high priority issues and participate if needed. BTW - I am responding with the iPad. It is surprisingly fast - not sure if it is because of the ssd hard drive or possibly because for the most part it is single tasking - either way - I like it. -John Sent from my iPad On Apr 5, 2010, at 4:47 PM, Paolino, Andrew apaol...@columnit.com wrote: ** And somewhere between 300,000 and 700,000 people agree. Despite some of the obvious limitations of the technology, there’s certainly a demographic that is (at least initially) finding this useful. John – Does KD Response work as well? I could see IT folks in the field using this tool to collaborate on complex open issues…. Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.comapaol...@columnit.com Skype ID: apaolino Web: http://www.columnit.com/http://www.columnit.com P *Please consider the environment before printing this email* *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Chowdhury, Tauf *Sent:* Monday, April 05, 2010 2:27 PM *To:* arslist@ARSLIST.ORGarslist@ARSLIST.ORG *Subject:* Re: OT:Kinetic apps and some iPad fun ** I got one for my mom. She wants to use a computer and access the internet. She’s never used a computer and hates using a mouse. She loves pointing at things. The iPad is pretty much the perfect device for someone like that. J *T**auf** **C**howdhury** **|** **F**orest** **L**aboratories**, **I**nc.* ** Analyst, Service Management Mobile:646.483.2779 -- *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Pierson, Shawn *Sent:* Monday, April 05, 2010 2:18 PM *To:* arslist@ARSLIST.ORGarslist@ARSLIST.ORG *Subject:* Re: OT:Kinetic apps and some iPad fun Too bad BMC is so focused on moving things to Flash (CI Viewer, Flashboards, etc) and Apple seems to have a problem with Adobe. It’s cool that the Kinetic apps work, but I think I’ll be waiting for a Windows or Android based equivalent that costs $200 and is capable of things like copy and paste, multitasking, flash, installing software that doesn’t require the manufacturer’s approval, letting you change the battery, etc. Sorry, I just don’t understand the fascination with recent Apple products. It’s a great marketing tool if you can use it with your software, but as a consumer I am not convinced. I played around with one at the Apple store and found it interesting
Re: Find Known Errors that are NOT related to a Change
Thanks Ben and Lyle. I tried what you suggested Lyle and I think that will work for us. Thank you, James On Apr 6, 12:09 pm, Lyle Taylor tayl...@ldschurch.org wrote: You could easily do this using a join form between PBM:Known Error and PBM:Known Error Associations. Create the form as an outer join with the associations form on the right. You join criteria will be $Known Error ID$ = 'Request ID02' AND 'Request Type01' = Infrastructure Change. Add the Known Error ID field and Request ID02 fields to the form. When you do a search, it will show a record for each Known Error record. If there is a match in the associations table, it will also bring that information in as well. If there is no match, then any fields from the associations table that you put on the join form (Request ID02 in this case) will be NULL. So to find all Known Errors that don't have a corresponding change, just search for all the records in the join form where one of the association fields (Request ID02) is $NULL$. That will show all Known Errors that don't have a corresponding relationship record to a Change. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Benedetto Cantatore Sent: Tuesday, April 06, 2010 7:48 AM To: arsl...@arslist.org Subject: Re: Find Known Errors that are NOT related to a Change ** Here's a quick stab at how I'd do it. I'm not sure if you're trying to show this info in a report or in a form, but basically you want to compare records in PBM:Known Error against PBM:Known error Associations. Then search against Request ID02 where it does not match Known Error ID and Request Type equals Infrastructure Change. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 jha...@gmail.com 04/06/10 3:08 AM I am trying to figure out how to find Known Errors that are not associated to a Change request. We are using Known Errors to track bugs and enhancements to in-house software. We associate corrected KEs to change requests as a Release. I am trying to find KEs that are not associated to a change (release) to make sure that they are addressed and don't fall through the cracks. I can easily find which ones are associated to a change by looking at the Associations forms, but I am stumped on how to find ones that are NOT associated. We are on ARS 7.1 and ITSM 7.03. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orghttp://www.arslist.org attend wwrug10www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10www.wwrug.comARSlist: 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 attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
John, If Apple does not lift its ban on Flash technology, and if BMC does not move away from it. not sure how they will address it. one can always hope, though. Matt From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Tuesday, April 06, 2010 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Finding memory leaks in the AR System
Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
We have a few of them here at work. We already have Citrix working on it. It would be a bummer to have to use that as a middle layer but could be an option. Jason On Tue, Apr 6, 2010 at 2:23 PM, Matt Reinfeldt arsl...@mattreinfeldt.comwrote: ** John, If Apple does not lift its ban on Flash technology, and if BMC does not move away from it… not sure how they will “address” it… one can always hope, though. Matt *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *John Sundberg *Sent:* Tuesday, April 06, 2010 3:47 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: OT:Kinetic apps and some iPad fun ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Two things: 1) The memory usage issue is definitely true at the DB level, especially if you're using SQL. 2) If this is an AR Server issue, it is one more issue with patch 4 that has and will keep me from installing it. Better the devil I know in patch 3... That being said, pre-allocating idle memory isn't an issue as long as the application is willing and able to give it back if something else needs it. SQL allegedly will. I haven't seen that behavior in AR System. Rick On Tue, Apr 6, 2010 at 2:38 PM, Robert Halstead badbee...@gmail.com wrote: ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Are you making form or workflow changes on that server while users are using it? Are you creating new ITSM Support Groups while other are logged on to the system? Is Development Cache Mode turned off? If the answer to the last question is “yes”, then either of the first two actions will cause the server to create a new copy of the workflow/forms cache in memory until the users that were logged in during the change log out for a short period. For example, if you create a support group, the server thinks it needs to recache everything, so it creates a copy of the current cache for those that are currently logged in and then pulls the new one from the server to reflect the changes (or something along those lines). In any case, the result is that you then have multiple copies of the cache in memory, which can easily consume all of your memory depending on how much workflow you have loaded and how many times it pulls a new copy of the cache into memory. That said, my experience is based on ARS 7.1, but I wouldn’t be surprised if it’s essentially the same in 7.5… Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Halstead Sent: Tuesday, April 06, 2010 3:39 PM To: arslist@ARSLIST.ORG Subject: Finding memory leaks in the AR System ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com 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.
Re: OT:Kinetic apps and some iPad fun
I think HTML5 has stepped up to the plate -- my guess is it will be easier and more in BMC's control to switch to that. The question is -- will large companies switch to a more modern browser. -John On Apr 6, 2010, at 4:23 PM, Matt Reinfeldt wrote: ** John, If Apple does not lift its ban on Flash technology, and if BMC does not move away from it… not sure how they will “address” it… one can always hope, though. Matt From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of John Sundberg Sent: Tuesday, April 06, 2010 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Hi guys, during the time we had to restart it, I was off on vacation and I'm the only developer, so I don't believe we were making workflow modifications to the system, though i'm not too sure.. Development Cache mode is checked on the Configuration tab so it should not be making a copy of the cache. On Tue, Apr 6, 2010 at 3:55 PM, Lyle Taylor tayl...@ldschurch.org wrote: Are you making form or workflow changes on that server while users are using it? Are you creating new ITSM Support Groups while other are logged on to the system? Is Development Cache Mode turned off? If the answer to the last question is “yes”, then either of the first two actions will cause the server to create a new copy of the workflow/forms cache in memory until the users that were logged in during the change log out for a short period. For example, if you create a support group, the server thinks it needs to recache everything, so it creates a copy of the current cache for those that are currently logged in and then pulls the new one from the server to reflect the changes (or something along those lines). In any case, the result is that you then have multiple copies of the cache in memory, which can easily consume all of your memory depending on how much workflow you have loaded and how many times it pulls a new copy of the cache into memory. That said, my experience is based on ARS 7.1, but I wouldn’t be surprised if it’s essentially the same in 7.5… Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Robert Halstead *Sent:* Tuesday, April 06, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Finding memory leaks in the AR System ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com 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. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead ___ UNSUBSCRIBE or access
Re: Finding memory leaks in the AR System
What about queries that have a large result set? How does the AR System handle those? On Tue, Apr 6, 2010 at 4:24 PM, Robert Halstead badbee...@gmail.com wrote: Hi guys, during the time we had to restart it, I was off on vacation and I'm the only developer, so I don't believe we were making workflow modifications to the system, though i'm not too sure.. Development Cache mode is checked on the Configuration tab so it should not be making a copy of the cache. On Tue, Apr 6, 2010 at 3:55 PM, Lyle Taylor tayl...@ldschurch.org wrote: Are you making form or workflow changes on that server while users are using it? Are you creating new ITSM Support Groups while other are logged on to the system? Is Development Cache Mode turned off? If the answer to the last question is “yes”, then either of the first two actions will cause the server to create a new copy of the workflow/forms cache in memory until the users that were logged in during the change log out for a short period. For example, if you create a support group, the server thinks it needs to recache everything, so it creates a copy of the current cache for those that are currently logged in and then pulls the new one from the server to reflect the changes (or something along those lines). In any case, the result is that you then have multiple copies of the cache in memory, which can easily consume all of your memory depending on how much workflow you have loaded and how many times it pulls a new copy of the cache into memory. That said, my experience is based on ARS 7.1, but I wouldn’t be surprised if it’s essentially the same in 7.5… Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Robert Halstead *Sent:* Tuesday, April 06, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Finding memory leaks in the AR System ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com 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. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus
Re: OT:Kinetic apps and some iPad fun
Hmmm. Safari is a supported browser. The iPad is using a variant of the iPhone/Touch OS. Mostly soon to be the same version. Has anyone been able to connect to MidTier using the Safari browser on an iPhone or Touch? If so then the issue may reside with the Safari port for the iPad which hopefully would be corrected with the next patch? Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Tuesday, April 06, 2010 6:06 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I think HTML5 has stepped up to the plate -- my guess is it will be easier and more in BMC's control to switch to that. The question is -- will large companies switch to a more modern browser. -John On Apr 6, 2010, at 4:23 PM, Matt Reinfeldt wrote: ** John, If Apple does not lift its ban on Flash technology, and if BMC does not move away from it... not sure how they will address it... one can always hope, though. Matt From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Tuesday, April 06, 2010 3:47 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: OT:Kinetic apps and some iPad fun ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.comhttp://www.kineticdata.com/ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Open a ticket with BMC. Just make sure you have ALL the files they will want or you will wind up playing volleyball email. At a minimum: Do a trace on memory usage; You better make the case here. How long, how fast, etc. Monitor threads. Use prstat, truss, whatever debug tools at your disposal. Check the pfiles, give them filehandle usage. Capture the memory footprint right before it dies. Have your ar.conf file ready.. On Tue, Apr 6, 2010 at 4:38 PM, Robert Halstead badbee...@gmail.com wrote: ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for daily auto Crystal Report export email?
The cheapest product I have found that has the most options is CRD from Christiansteven software. We also use CRD. It is a wonderful product. Thanks for the tip. I'll try the demo tomorrow. Alan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Events in Workflows
OK, I will explain in more detail, this assumes you know how to use the new
error handler feature of filters.
[ I Love it!!]
1) Create a filter on the View form that access the external table that you
do not have a privilige on.
2) Have a dummy form and filter push data to the view form.
3) (Remember Filters will fire before a commit to the DB)
4) You need 2 filters. 1 that is normal (fire on modify) 1 that acts as your
ERROR handler [ no firing condition]
5) When you push to the View form the following will happen.
1) Filter fires on Modify
2) DB error is generated cause you don't have access.
3) 1st Filter then uses the 2nd filter as error handler.
4) Use you 2nd filter as your Error processing to handle the real meat
of the workflow. The first filter is just basically a try {} catch{} So the
first filter just has to do something mundane like try to set a field (which
it can't do)
--hope that helps--
On Tue, Apr 6, 2010 at 6:46 AM, navinem naveen...@gmail.com wrote:
Hi nn-11,
But for the dummy form to push some data, (lemme assume its some kind of
flag) you need to have write previlege over the table from which I am
accessing the data to be fetched into view form. But unfortunatley i cant
add new coloumns to the external table. Hence it wouldnt be a viable
solution :(
nn-11 wrote:
What about periodically running an escalation off of a Dummy form (that
contains only 1 record)
and have a filter on the Dummy form push the data to the view form that
will
subsequently fire the
filter on the View form?
On Wed, Mar 31, 2010 at 4:14 PM, navinem naveen...@gmail.com wrote:
Hi All,
Is there any way of creating a custom event and captruing it in Remedy.
The
reason why i need this is because of the following reason.
I have an escalation which gets triggered from a view form. But i dont
want
this escalation to process records because of performance reasons. So i
was
looking for methods to trigger a filter in the same form from this
escalation and i cant introduce any field to this view form to act as a
flag. Can i generate any kind of custom event in the escalation and make
the
filter run on capture of this event?
Please provide any inputs on this.
Thank you
--
View this message in context:
http://old.nabble.com/Events-in-Workflows-tp28101842p28101842.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
--
View this message in context:
http://old.nabble.com/Events-in-Workflows-tp28101842p28150573.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Cell Based Table Problem
Sorry that is the current limitation as noted by the documents. But I have gotten around it using ugly table loop code that performs a set field into each individual cell table field. Don't do it , its a resource hog and midTier don't like it. On Tue, Apr 6, 2010 at 6:12 AM, Derek Herndon dhern...@tampabay.rr.comwrote: OS Linux 2.6.16.60-0.21-smp DB Oracle 10.2.0.4.0 - Prod ARS 7.5 Patch 2 Is it possible to display more than 254 characters of a field in a cell based table? Currently it is truncating any values greater than 254 on display. Derek ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Error creating JDBC plugin for federation
This first line says it all, you are missing your resource bundle: *java.util.MissingResourceException: Can't find bundle for base name JDBCMessages, locale pl_PL* *Find the code in your program where it calls for the Resource.* *usually the resource bundle is a directory with the name pl_PL located at the top of a jar package* a directory structure for the JAR file** *Do a google search of the above error and that should point the way.* On Mon, Apr 5, 2010 at 3:26 AM, Victor Olufowobi vic...@klub.chip.plwrote: ** Hello Listers, I am trying to federate CI data from MS SQL server. After creating JDBC plugin as described in Atrium CMDB Admin Guide I reopened the Federation Manager and the Loaded column continues to read No. The entries i AtriumPlugonSvr.log are as follows: *kwi 04 2010 22:17:57.418 ERROR ( ?:?) - getListForms() FAILs in plugin: L43104 java.util.MissingResourceException: Can't find bundle for base name JDBCMessages, locale pl_PL at java.util.ResourceBundle.throwMissingResourceException(Unknown Source) at java.util.ResourceBundle.getBundleImpl(Unknown Source) at java.util.ResourceBundle.getBundle(Unknown Source) at com.bmc.atrium.federation.jdbc.JDBCMessageHelper.getLocalizedMessage(JDBCMessageHelper.java:71) at com.bmc.atrium.federation.jdbc.JDBCMessageHelper.createARException(JDBCMessageHelper.java:52) at com.bmc.atrium.federation.jdbc.JdbcAdapter.getListForms(JdbcAdapter.java:293) at com.bmc.arsys.pluginsvr.plugins.a.ArdbcGetListForms(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcGetListForms_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcGetListForms_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)* Could anyone advice as to what could be tha cause? AR system 7.5 with ITSM 7.6 on Windows 2k3 + MS SQL 2005 + Tomcat Thanks, Victor _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Since you are on Solaris/sparc you have some really good options for seeing if there are memory leaks. Look into the slab memory allocator (libumem). http://blogs.sun.com/ahl/entry/solaris_10_top_11_20 http://blogs.sun.com/ahl/entry/solaris_10_top_11_20There are actually performance benefits to using this memory allocator to the standard libc (though it does make the memory footprint slightly larger), but it's going to hard stop your software (sigsegv, sigbus, etc.) in the event nasty things are going on that shouldn't be going on. Good news is that it tells you what/where if you tell your system to generate a core in the event. Once you have things running under libumem, you can put some checks on memory usage (see the following): UMEM_DEBUG UMEM_LOGGING Once you do that, it makes some handy options available in dbx (RTC): http://www.mail-archive.com/arslist@arslist.org/msg33614.html http://www.fortran-2000.com/ArnaudRecipes/SunMemoryDB.html#SunDbx You can attach the debugger to the process in flight to check for memory leaks: http://technopark02.blogspot.com/2005/10/sun-studio-investigating-memory-leaks.html See here for the high-level gory details. Pretty cool stuff: http://developers.sun.com/solaris/articles/libumem_library.html Axton Grams On Tue, Apr 6, 2010 at 4:38 PM, Robert Halstead badbee...@gmail.com wrote: ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
Companies switching to a more modern browser? Come on John, hold these kind of postings for Friday :) On Tue, Apr 6, 2010 at 3:05 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** I think HTML5 has stepped up to the plate -- my guess is it will be easier and more in BMC's control to switch to that. The question is -- will large companies switch to a more modern browser. -John On Apr 6, 2010, at 4:23 PM, Matt Reinfeldt wrote: ** John, If Apple does not lift its ban on Flash technology, and if BMC does not move away from it… not sure how they will “address” it… one can always hope, though. Matt *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* Tuesday, April 06, 2010 3:47 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: OT:Kinetic apps and some iPad fun ** I have been sent a couple of links to external facing ARS -- both I think were 7.6. One was ITSM 7.6 One was a custom simple app Unfortunately - neither worked. I did not do a lot of testing -- as the issues I found were early show stoppers: 1) You cannot select an item in a row (rendering consoles useless) (The iPad asks me if I want to copy the row) 2) You cannot select an item in a dropdown menu (rendering my available forms useless) (The iPad does nothing -- as if I have not clicked on it at all) I could however login and see the homepage. I was able to click on approval central and technically get there -- however error messages that popped must have been serious enough - as I was unable to do anything once I got there. (meaning -- I was not able to select the Approval tasks (Needs Attention, etc...) or again -- any dropdown menus) So -- I was unable to look at any console/click on a record/and see an entry. Also -- I was unable to create a record - as the forms I had access to seem to all have at least one menu (Priority for example) It is early days -- I expect BMC will be able to address. I did check to see if the browser on the iPad is Acid3 compliant -- it appears it is. http://img.skitch.com/20100406-kutr5pmp4c3ud5ch4fire9i76s.jpg -John _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT:Kinetic apps and some iPad fun
On 07/04/2010 01:37, Shellman, David wrote: ** Hmmm. Safari is a supported browser. The iPad is using a variant of the iPhone/Touch OS. Mostly soon to be the same version. Has anyone been able to connect to MidTier using the Safari browser on an iPhone or Touch? If so then the issue may reside with the Safari port for the iPad which hopefully would be corrected with the next patch? Dave The problems that John experienced with the iPad are exactly the same as those I experienced with the iPhone. I should therefore assume that the Safari browser on the iPad is the same as that on the iPhone - you just see a larger web page :-) I have done a few workarounds on forms that I wanted to use on the iPhone. For example, on a table I have added a button to each row allowing users to select a row (we are using ARS 7.5). I am unsure what it is that the iPhone/iPad Safari is missing to stop the Mid-Tier working properly. It would be extremely useful to know whether this is something that BMC is looking into but I can't imaging that it is high on their list of priorities. Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support Development, Training Support Services, Academic Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England Wales and a charity registered in Scotland (SC 038302). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
