Re: RPC: Program not registered
Hi, The RPC error is irrelevant, it is because the server is down. Check the Java VM memory setting, the default is much lower than needed. Regards, Nicky Madjarov www.speedupars.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Saturday, August 13, 2011 11:30 AM To: arslist@ARSLIST.ORG Subject: Re: RPC: Program not registered ** What else is running on the box? Sent from my iPhone 4 On Aug 13, 2011, at 11:12 AM, Abdul Haque wrote: ** Its 8 GB RAM. On 13 August 2011 17:59, Howard Richter wrote: ** May be a memory issue! How much ram is on the server? Sent from my iPhone 4 On Aug 13,r 2011, at 10:15 AM, Brian Bishop wrote: ** Try switching the server over to development mode. Sent from my BlackBerry _ From: Abdul Haque Sender: "Action Request System discussion list(ARSList)" Date: Sat, 13 Aug 2011 17:03:53 +0300 To: ReplyTo: arslist@ARSLIST.ORG Subject: Re: RPC: Program not registered ** Its not install, the server is running properly, but this happens only when I save a filter or active link, the server gets automatically restarted. regards On 13 August 2011 16:27, Patrick Zandi wrote: Is thus an install. I had to choose port.. Just change ar.confirm Sent from my iPhone so typo's or funky words can and do happen! On Aug 13, 2011, at 8:38 AM, Abdul Haque Khan wrote: > when i m trying to save (Mostly Approvals or Making edit in Active links or > Filters) getting below ERRORs. > > 390600 : Insufficient server memory for running this process. (ARERR 300) > CopyCache > AR System server terminated — fatal error occurred in ARSERVER (ARNOTE 21) > Action Request System(R) Server Version 7.6.04 SP1 201104191058 > (c) Copyright 1991-2011 BMC Software, Inc. > > Cannot establish a network connection to the AR System server (BMCREPORT (0) > : RPC: Program not registered) ARERR - 90 > > Any Help would be appreciated. > >___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" -- BEST REGARDS Abdul Haque +966531861850 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- BEST REGARDS Abdul Haque +966531861850 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
You are invited to vote in the poll How slow is slow
Hello, In the next few months I plan to publish a series of polls aimed to obtaining a better understanding of the Remedy performance glitches and problems you all have come across. The first one : How slow is slow - are your AR System apps meeting the performance expectations is a high level poll just to get the overall impression. All subsequent polls will be driven by the your input in the previous ones. Please, take a minute and cast your vote. Go to http://www.speedupars.com <http://www.speedupars.com/> , no login credentials are required. Polls are open for 2 weeks, the results are published as soon as polls are closed. Thank you for your participation. Have a fun J Nicky Madjarov ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: On "Window Loaded" active link doesn't see field values???
Rabi, what mode is the new window opened in - submit, query, modify, dialog? The behaviour you describe is strange, it has always been working for me, i stopped using macros in workflow since the open window became an option and never ever had problems. I thing the easiest way to make it work is to check all triggering criteria and to run the AL log, make sure there is an active link printing the value of the field you are interested in (the one that gets lost ), just check them all and you will find out what sets the fields to null. Also, in the open window action there is a check box "Set Fields to Defaults" - make shure that it is not checked. In principle the open window have to provide the same behavior as run macro in the past:) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Rabi Tripathi" Newsgroups: public.remedy.arsystem.general To: Sent: Tuesday, April 27, 2010 6:14 PM Subject: Re: On "Window Loaded" active link doesn't see field values??? Now it works, when the macro opens an intermediate window, on which an "on interval" active links fires after 3 seconds. This on interval active link sees all the field values received on the form (and correctly "processes" them as I want, and opens the target window with , my main goal). The same active link, when it fires on "Window Load" on the intermediate or the target form doesn't work. Meaning can't see the field values on the form passed by the macro. Now I have a useless window saying "Opening, please wait..." delaying the user for 3 seconds before the target window is opened by the on interval active link. Me not too happy. But don't see any other way out. It's a bug. LJ, thanks for your input. Nicky: About your question, the field values I want the active links to "see" are the ones sent as macro parameters, not field defaults. --- On Tue, 4/27/10, Rabi Tripathi wrote: From: Rabi Tripathi Subject: Re: On "Window Loaded" active link doesn't see field values??? To: arslist@ARSLIST.ORG Date: Tuesday, April 27, 2010, 12:39 PM I absolutely hate to do this, but I can have an "on interval" active link fire on the window with interval of 1 sec. When the target window opens this way, I am expecting that the window loaded active links there will see the field values. Somebody tell me there's a different way to do this. Not to mess up the main form, I will go with an intermediate form that is opened by the macro on which after a sec an AL will fire to open the main ticket window and close the intermediate window. Ugly ugly. --- On Tue, 4/27/10, Rabi Tripathi wrote: > From: Rabi Tripathi > Subject: Re: On "Window Loaded" active link doesn't see field values??? > To: arslist@ARSLIST.ORG > Date: Tuesday, April 27, 2010, 12:35 PM > LJ, log trace is not helping. There > are no active links clearing the fields. > > I have found absolutely no way to have active links (Win > Open, Win Loaded) read values passed to a window, if the > window was **opened by a macro**!! > > All fields appear blank to these active links, although, > when the window fully opens, all the values are right there > for me to see! It appears that when a macro opens a window, > there is something funky (I say bug) which makes the field > values load *after* the Window Loaded event has completed. > :( > > I tried opening the same window with code (open win action) > and passed values; these values are correctly seen by the > active links on that form. I tried playing with different > window modes no luck. > > I need to trigger code before the window fully opens, based > on value received by the window from the macro. Can't be > done??? > > > > > --- On Thu, 4/22/10, LJ LongWing > wrote: > > > From: LJ LongWing > > Subject: Re: On "Window Loaded" active link doesn't > see field values??? > > To: arslist@ARSLIST.ORG > > Date: Thursday, April 22, 2010, 1:51 PM > > Rabi, > > I recommend having AL Logging turned on and see if > the > > field is being set > > some time after the AL you are looking athappens > to me > > all the time...I > > have AL1 set to fire if value = X, but AL2 fires at a > later > > execution order > > setting the field... > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] > > On Behalf Of Rabi Tripathi > > Sent: Thursday, April 22, 2010 11:19 AM > > To: arslist@ARSLIST.ORG > > Subject: On "Window Loaded" active link doesn't see >
Re: On "Window Loaded" active link doesn't see field values???
Hi, Are you referring to default values? These are controlled by the options setting on user tool/ user preferences resp. I believe that if you record a macro setting the defaults becomes part of it. Give it a try. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Rabi Tripathi" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 22, 2010 1:18 PM Subject: On "Window Loaded" active link doesn't see field values??? I have an active link firing on "Window Loaded". It sees a field as having no value when it fires. That makes me not happy, because the value is there or should be there. The submit window is opened by a macro with a parameter, and the macro is correctly populating the parameter value on the field. I can see it when the window is fully open (meaning active links have all completed firing). When a submit window opens, my understanding is that by the time "Window Loaded" event occurs, all field values (set by "set to default" feature, sent with a macro etc) should already be there on the fields, such that on Window Loaded active links should see the values. Why is my active link not seeing the field value? I put a debug message, and yes, the field is blank when the active links fires. But the value gets to the field, when the window has opened fully. ARS 6.3. from the doc: Window Loaded Executes after all the data values have been loaded into a Submit or Search window (from defaults, from a copy to new, or from an open window action). ___ 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: System Generated Field Value
If that's the case you may consider CREATE SEQUENCE in your sql database and use set fields from sql to populate the unique key :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Gopal-srg" Newsgroups: public.remedy.arsystem.general To: Sent: Tuesday, April 27, 2010 11:43 AM Subject: Re: System Generated Field Value Hi frank, Thanks for the explanation.I have tested this field, it is generating the values similar to instance ID, but i need the values in a format similar to the request ID. Is there any way to do it without involving workflows? Regards, Gopal Frank Caruso-2 wrote: It will get set to a system unique identifier (a GUID) on submit of a record. Add it to a form and see what happens. I would also suggest reading through the documentation to better understand other reserved type fields. On Tue, Apr 27, 2010 at 11:50 AM, Gopal-srg wrote: Hi Frank, Thanks for the information.Could you please explain the sugnificance of this field ID 179, why it is used to get the unique values? Please proviode the info, it will be of great help. Regards, Gopal Frank Caruso-2 wrote: > > If you are looking for a unique value create a character field using field > ID 179. ARS will set this field to a unique string on submit. > > On Tue, Apr 27, 2010 at 9:49 AM, Gopal-srg wrote: > >> Hi all, >> I am using ARS 7.1. I need to create character field whose values >> will be >> system generated just like Request ID. >> I have checkd in the Admin tool for the newly created character field >> under >> the Field properties tab, there is no 'system' value for the Entry Mode >> attribute. >> >> Pleas help us in resolving this. >> >> Regards, >> Gopal >> -- >> View this message in context: >> http://old.nabble.com/System-Generated-Field-Value-tp28373512p28373512.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/System-Generated-Field-Value-tp28373512p28374508.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/System-Generated-Field-Value-tp28373512p28378587.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: Log size and server performance (Log file editor)
Unix has very convenien command, if you split the log in chunks of 50 MB you can look into them with vi or some other editor. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Mansur, Joanne Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 22, 2010 10:10 AM Subject: Re: Log size and server performance (Log file editor) ** I use textpad - the only way I've found to open up some of the bigger files. Joanne Mansur Client Systems Analyst Northeastern University (617) 373-3295 (office) (617) 373-5985 (fax) j.man...@neu.edu From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, April 22, 2010 10:08 AM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Log size and server performance (Log file editor) ** I've been using notepad for the longest and believe my eyes now can move independently of each other. I am now using a utility called WinVi which is freeware and comes in 4 different languages and packs a list of features. this is much better than the old notepad. http://www.winvi.de/en/ I'd also be interested in what others are using. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Thursday, April 22, 2010 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Log size and server performance ** Speaking of logs -- what do people use to read them? Does anybody use splunk -- do you like it -- does it help? -John _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: Log size and server performance
Hi, I bare with Lyle there. Your performance will be the same regardless the size of the log. The only valid concern is if you have that much space on the file system. Bare in mind that when you reach thr max log size it will rename the log files into back-s (depending on your log setting) and if the back-s are still present when you reach the max size of the log, it will actually stop logging. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, April 21, 2010 12:09 PM Subject: Re: Log size and server performance ** Well, this isn't a definitive answer by any means, but my suspicion would be that the log file size should be pretty much irrelevant from a performance perspective, since it is just appending to the existing file, which is a quick operation. The more important point is that if you're getting that much logging output, just having logging on at all is probably impacting performance on the server. So, if the performance of the system seems acceptable with logging turned on, you should be able to let it run as long as you want, at least until you either meet you maximum file size or fill up the file system you're logging to without any additional performance impact due to the size of the log files. Now, how to do something useful with such large files is another question. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Wednesday, April 21, 2010 9:49 AM To: arslist@ARSLIST.ORG Subject: Log size and server performance ** We are looking at capturing more effective logging to try and catch some interrmittent problems in production that we can't seem to re-produce in test. The problem is that the arfilter log on our server that runs escalations is currently 50M and contains about 2 minutes worth of information. This is, obviously, because of the notifications, but I'm curious as to what point I can increase my log file sizes before I start to see a perfomance hit. Any ideas/experiences? ITSM 7.0.03 P9 ARS 7.1 P6 Linux Oracle It looks like 100M would catch a 1/2 hour of information or longer in all logs except the arfilter (but we have to set all of the log files to the same size). 500M might get us a 1/2 hour in the filter log, but the other logs will be unnecessarily big and I'm wondering if having all of the logs that size could cause server response time to slow? Anne Ramey _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. _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: Benefit of Prefetch Remedy midtier 7.1
Well, I agree that the secong part is confusing, and it deffinitely does not happen the way you refered, have no idea where you got this info from, but generally a sales persons (even from bmc) are not a good source. So, the benefits are, as you said, that the forms are pre-cached, especially helpfull when you run multiple mid-tiers. you can put a web in the mix and users won't see the difference (or a delay). For frequently used forms in busy environment you may have multiple users requesting them at the same time, so if 50 users wait for the help desk to cache at the same time that will kill the performance of your mid-tier, because you have 50 requests waiting. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "remedy lee" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, April 14, 2010 9:44 AM Subject: Benefit of Prefetch Remedy midtier 7.1 Hi, I'm confused on this prefetch 'feature' in midtier. The way I read it is that only when a server is restarted will the forms (on the web server) reload in order to save time when the first user logs in. So instead of loading HPD:Help Desk when a user first hits it, it will load by itself when restarted. Benefit is that the first user logging in won't get that 1-2 mins loading wait. Now sales people and certain consultants say that prefetch does more than that. It actually loads the forms into the clients computer and therefore speeds up the whole midtier itself. So they say that prefetch helps overall everyday midtier use such as the 50th person using HPD:Help Desk will notice better speeds with prefetch than without. They say it loads the forms to the clients computers preemptively and therefore improves performance. To me that doesn't make sense, how can the server know where to load the files. Does it work by loading all the web forms when the person logs in? I really see no benefit to using prefetch if our server hardly restarts ___ 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: Dumb Question (but it is Monday)
1. submit 2. no Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Brittain, Mark Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 29, 2010 11:19 AM Subject: Dumb Question (but it is Monday) ** Hi All, Yeah these are really dumb questions that I should know but I have a behavior that makes me doubt myself. 1. When a record on Form A is created from an email template is that a submit or a merge? 2. Record on Form A is created from an email template, then Form A pushes to Form B. Do the active links on Form B fire? ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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: BMC's Bad Idea
Hi, you can still enable loging by changing the ar.conf file and running arsignal after that. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Pat Zandi" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, March 03, 2010 3:51 PM Subject: Re: BMC's Bad Idea Unless you buy the company that is... Sent from my iPhone On Mar 3, 2010, at 3:49 PM, Pat Zandi wrote: Would it be a bad idea to create a web based application that is denpendent on a third party vendor application that could break your web based functionality and do away with the backup like the usertool.. Cough.. Cough.. Flash Sent from my iPhone On Mar 3, 2010, at 3:21 PM, Jarl Grøneng wr ote: You can put the ServerAdmin to run in its own pluginserver, then it will be accessible even if other pluginservers doing heavy work -- Jarl 2010/3/3 Pierson, Shawn : ** After having arplugin.exe suddenly cause the ARServer to stop responding to anything other than the Admin Tool (I assume it was someone running some huge query via a web service or something), I realized how horrible of an idea it was for BMC to take away our ability to turn on logging from the admin tool. It would also defeat the purpose for me to update the config file and restart the service. As a result, I have no way of being able to know why my server was unavailable. Sorry folks, this isn’t a question or necessarily productive, ju st a complaint. Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Friday Humor
True story I spent some time in Nashville and ate mostly out. There was a mexican restorant there, not bad at all. They had on the menu a meal called Speedy Gonzales. The funny thing was that every time me or somebody else ordered Speedy Gonzaales they always brought something different. We never found what Speedy Gonzales actually was. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "LJ Longwing" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, February 26, 2010 11:32 AM Subject: Re: Friday Humor True life story. Burger King used to have a 'Double Bacon Cheeseburger value meal' on their menu that my wife sometimes orders. They took it off the menu and replaced it with a 'Double Cheeseburger value meal' several years ago, but she continued ordering it and never had a problem. One day she ordered the Double Bacon Cheeseburger meal and the guy behind the counter said they don't have that anymore...we exchanged glances and without a beat she says "Ok, I'll have the Double Cheeseburger value meal with bacon"the clerk rang it up without ever realizing what just happenedwe still laugh about it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Friday, February 26, 2010 6:37 AM To: arslist@ARSLIST.ORG Subject: OT:Friday Humor Subject: FW: The Future for Laid off Employees After a company gets rid of all its bloated staff, this is what they will have to choose from at their new Wal-Mart pay scales. ONE Recently, when I went to McDonald's I saw on the menu that you could have an order of 6, 9 or 12 Chicken McNuggets. I asked for a half dozen nuggets. 'We don't have half dozen nuggets,' said the teenager at the counter. 'You don't?' I replied. 'We only have six, nine, or twelve,' was the reply. 'So I can't order a half dozen nuggets, but I can order six?' 'That's right.' So I shook my head and ordered six McNuggets (Unbelievable but sadly true...) TWO I was checking out at the local Wal-Mart with just a few items and the lady behind me put her things on the belt close to mine.. I picked up one of those 'dividers' that they keep by the cash register and placed it between our things so they wouldn't get mixed. After the girl had scanned all of my items, she picked up the 'divider', looking it all over for the bar code so she could scan it. Not finding the bar code, she said to me, 'Do you know how much this is?' I said to her 'I've changed my mind; I don't think I'll buy that today.' She said 'OK,' and I paid her for the things and left. She had no clue to what had just happened. THREE A woman at work was seen putting a credit card into her floppy drive and pulling it out very quickly. When I inquired as to what she was doing, she said she was shopping on the Internet and they kept asking for a credit card number, so she was using the ATM 'thingy.' (keep shuddering!!) FOUR I recently saw a distraught young lady weeping beside her car. 'Do you need some help?' I asked. She replied, 'I knew I should have replaced the battery to this remote door unlocker. Now I can't get into my car. Do you think they (pointing to a distant convenience store) would have a battery to fit this?' 'Hmmm, I don't know. Do you have an alarm, too?' I asked. 'No, just this remote thingy,' she answered, handing it and the car keys to me. As I took the key and manually unlocked the door, I replied, 'Why don't you drive over there and check about the batteries. It's a long walk' PLEASE just lay down before you hurt yourself !!! FIVE Several years ago, we had an Intern who was none too swift. One day she was typing and turned to a secretary and said, 'I'm almost out of typing paper. What do I do?' 'Just use paper from the photocopier', the secretary told her. With that, the intern took her last remaining blank piece of paper, put it on the photocopier and proceeded to make five 'blank' copies. Brunette, by the way!! SIX A mother calls 911 very worried asking the dispatcher if she needs to take her kid to the emergency room, the kid had eaten ants. The dispatcher tells her to give the kid some Benadryl and he should be fine, the mother says, 'I just gave him some ant killer..' Dispatcher: 'Rush him in to emergency!' Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com<mailto:mary.jo...@hp.com> www.hp.com<http://www.hp.com/> Confidentiality Notice: This messa
Re: Friday Humor
Talking of Walmart, I came accross http://www.peopleofwalmart.com You will certainly find something to crack you out there :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Schryver, Curt" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, February 26, 2010 9:44 AM Subject: Re: Friday Humor Drug dealers: o Refer to their clients as "users". o "The first one's free!" o Have important South-East Asian connections (to help move the stuff). o Strange jargon: "Stick", "Rock", "Dime bag," "E". o Realize that there's tons of cash in the 14- to 25-year-old market. o Job is assisted by industry's producing newer, more potent mixes. o Often seen in the company of pimps and hustlers. o Their product causes unhealthy addictions. o Do your job well, and you can sleep with sexy movie stars who depend on you. Software developers: o Refer to their clients as "users". o "Download a free trial version..." o Have important South-East Asian connections (to help debug the code). o Strange jargon: "SCSI", "ISDN", "Java", "RTFM" o Realize that there's tons of cash in the 14- to 25-year-old market. o Job is assisted by industry's producing newer, faster machines. o Often seen in the company of marketing people and venture capitalists. o Their product causes unhealthy addictions - DOOM. Quake. SimCity. Duke Nukem 3D. o Damn! Damn! DAMN!!! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Friday, February 26, 2010 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: Friday Humor I always wondered why that one store always needed those dividers replenished... Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Friday, February 26, 2010 07:37 To: arslist@ARSLIST.ORG Subject: OT:Friday Humor Subject: FW: The Future for Laid off Employees After a company gets rid of all its bloated staff, this is what they will have to choose from at their new Wal-Mart pay scales. ONE Recently, when I went to McDonald's I saw on the menu that you could have an order of 6, 9 or 12 Chicken McNuggets. I asked for a half dozen nuggets. 'We don't have half dozen nuggets,' said the teenager at the counter. 'You don't?' I replied. 'We only have six, nine, or twelve,' was the reply. 'So I can't order a half dozen nuggets, but I can order six?' 'That's right.' So I shook my head and ordered six McNuggets (Unbelievable but sadly true...) TWO I was checking out at the local Wal-Mart with just a few items and the lady behind me put her things on the belt close to mine.. I picked up one of those 'dividers' that they keep by the cash register and placed it between our things so they wouldn't get mixed. After the girl had scanned all of my items, she picked up the 'divider', looking it all over for the bar code so she could scan it. Not finding the bar code, she said to me, 'Do you know how much this is?' I said to her 'I've changed my mind; I don't think I'll buy that today.' She said 'OK,' and I paid her for the things and left. She had no clue to what had just happened. THREE A woman at work was seen putting a credit card into her floppy drive and pulling it out very quickly. When I inquired as to what she was doing, she said she was shopping on the Internet and they kept asking for a credit card number, so she was using the ATM 'thingy.' (keep shuddering!!) FOUR I recently saw a distraught young lady weeping beside her car. 'Do you need some help?' I asked. She replied, 'I knew I should have replaced the battery to this remote door unlocker. Now I can't get into my car. Do you think they (pointing to a distant convenience store) would have a battery to fit this?' 'Hmmm, I don't know. Do you have an alarm, too?' I asked. 'No, just this remote thingy,' she answered, handing it and the car keys to me. As I took the key and manually unlocked the door, I replied, 'Why don't you drive over there and check about the batteries. It's a long walk' PLEASE just lay down before you hurt yourself !!! FIVE Several years ago, we had an Intern who was none too swift. One day she was typing and turned to a secretary and said, 'I'm almost out of typing paper. What do I
Outbound web services stop working after SSO implementation
Hi listers, Well, here is the situation. server group on solaris/oracle/apache 7.01 patch 7. After installing SSO last night the outbound web service calls stop working. arerror.log shows 9130 errors the strange thing about the plugin.log is that you can see the call, but there is no SOAP envilope shown or any other details specific to normal run, just few lines indicating that the call is made, service name, address, namespace, etc and then the generic java.lang.NullPointerException and that the call has FAILED. Any past experiences? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Remedy View Validation
Remedy View ValidationPretty normal behaviour, there is no actually a way to "modify" a view in the database sense of it - it is one entity, so you just have to replace/delete/add it. And there is no problem with it, unless you start renaming fields - that will change the names in the view as well. I dont think you have to add/remoive filed, it is triggered when the view entry in the vui table is updated, which may be caused by some more inocent changes. Finally, there are some gaps in the db view management, because some times the views are not updated as expected and the dba's complain of "orphan" views all the time. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, February 22, 2010 3:03 PM Subject: Re: Remedy View Validation ** So, all that said, was this view just a view you created manually in the database? If so, I don't see Remedy actively doing anything to that view when you make changes to the underlying form. However, making changes to the underlying form could potentially invalidate the view, or make Oracle believe that it may no longer be valid. In that case, however, I would expect that the view would still be there in the database, just flagged as being broken. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Monday, February 22, 2010 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy View Validation ** Views, it replaces.. It uses the syntax Create or Replace view as blah blah blah.. If present it just replaces - if absent it creates.. Tables like Rick says, it used to rename, create a new one, copy data from renamed table to new table, drop old.. Right now I'm not exactly sure what it does when you alter table, maybe it just issues the good old alter table statement?? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: Monday, February 22, 2010 2:42 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy View Validation ** I cry BS, too. Remedy USED to drop forms when a field was deleted, but I don't think even that happens any more. Rick From: Tommy Morris Date: Mon, 22 Feb 2010 13:36:04 -0600 To: Subject: Remedy View Validation AR 7.5p1 Oracle 11g We had a custom view built against HPD_Help Desk to facilitate external reporting. This view was recently dropped and then recreated by some "unknown entity" (I blame the kittens). When I asked our dba's about this they responded that the Remedy Application drops views and recreates them when a new field is added or moved around (customizing form views through Developer/ Admin tool). I of course cried BS but just wanted to ask the list; Has anyone seen where modifying a form causes database objects to drop and recreate? Tommy Morris _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Big fan of Remedy Developer Studio?
yep, it seems that performance has been droped from the list of improved/watched features, and they are spending it big time to make other features available :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Jason Miller Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 10, 2010 3:24 PM Subject: Re: Big fan of Remedy Developer Studio? ** I have been noticing this too lately. I am wondering if it has something to do with having an object open from the WL and then trying to modify the WL. I usually restart DS just to get a fresh start but I am pretty sure that I have been able to to close the objects opened form the WL and then modify the forms in the WL. Usually since I have closed most objects anyways I figure I might as well restart the whole tool. I have found that I have to kill the devstudio.exe process fairly often. Some times when trying to open an object DS will freeze and spike my CPU. Some times it will finish whatever it is doing and return to normal and sometimes I have to kill it. Jason On Wed, Feb 10, 2010 at 10:10 AM, Vinay Vermani wrote: ** Only thing I hate about it, is, Sometimes while creating working list, you can't add a form to working list. Only work around I know is to restart developer studio. Other than that, I haven't experienced any issues. On Wed, Feb 10, 2010 at 11:37 AM, Joe D'Souza wrote: ** Yea that is such a useful 'long awaited' feature too.. That alone I think is enough to justify a few extra mouse clicks.. imagine having to do what you had to do previously.. That could well be what could be considered as the hidden costs of fewer mouse clicks :-) Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Mansur, Joanne Sent: Wednesday, February 10, 2010 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Big fan of Remedy Developer Studio? ** And, of course, there’s the undo button. That counts for a lot. Joanne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mike Buck Sent: Wednesday, February 10, 2010 11:46 AM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Big fan of Remedy Developer Studio? ** After using Developer Studio for some weeks now, my personal view is that it's not as productive as the old 'Admin Tool'. More mouse clicks to do the same thing extends development time. Some of the panes provide too much information and so it takes longer to hone in on the bits that need changing, adding in further time. Consequently it seems to take much longer to complete a development project. On the positive side Developer Studio has a nicer look and feel and some good features. However, it does need some changes to make it more productive. Cheers Mike On Tue, Feb 2, 2010 at 8:43 PM, Robert Page wrote: Well I recently had to go back to the Admin tool from spending the last 12 months on dev studio and I did not enjoy it. I agree certain actions in the admin tool are a little quicker and dev studio has a few things they need to sort out, but I can leave them a side as the admin tool has many years of development behind it. Overall being able to have multiple different tabs with different form queries and lists of workflow makes it richer and I certainly find it easier to find workflow than I did in the admin tool. I look forward to seeing what else they can provide with it. Just my thoughts, we are all different so will have different views on the subject, this is up there with windows/unix, oracle/sql, one that will range forever more! Cheers Robert -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terje Moglestue Sent: 02 February 2010 17:33 To: arslist@ARSLIST.ORG Subject: Big fan of Remedy Developer Studio? I can not make up my mind if I like it or not! I am sorry if this has been debated up and down in the past on the arslist? I find it quicker, faster and more effective to work within the old Remedy Administrator. There is some nice functionality within Remedy Developer Studio but in general everything takes longer time. Well - my fingers are more used to the Admin tool. Even so - I got better control and things are done quicker the "old fashion way". It might b
Re: Server Crash
Kathy, You had to post your message on Friday - that's when some good fellas usually place something called Friday Humor - just to crack the ise. On the other hand, I feel bad for you that you have to deal with such "management". Every Remedy product comes with Minimum/Recommended Disk space requirements, so you can refer to these in your "fight", I think these are usually found in the installation manuals. :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Kathy Morris Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 10, 2010 11:35 AM Subject: Re: Server Crash ** Our database is remote - meaning most of the data is in the database on a remote server. Only the application (Discovery application and the files that it needs) are on the C drive (along with other applications). This is Management's argument - if most of the data is on the database - then why do we need more than 16G of HD space, and 4G of ram. Even though the data is in the database, my position is that you still need more than 16G of HD for the application, and the files that the application needs to write to. -Original Message- From: Susan Palmer To: arslist@ARSLIST.ORG Sent: Wed, Feb 10, 2010 11:29 am Subject: Re: Server Crash ** I don't use Discovery but can you have the files directed to a different server, like the db server? Susan On Wed, Feb 10, 2010 at 10:13 AM, Joe D'Souza wrote: ** I G of free space on something like even your laptop, and you would be sobbing.. Literally.. You got to have way way way more than that.. try something like at least 50 GB of free space on your HD for a start.. Off course it also depends on how much memory your machine uses and what it is configured to use as swap, but 1 GB free space? That is ridiculous to say the least.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Kathy Morris Sent: Wednesday, February 10, 2010 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: Server Crash ** After deleting temp files, I have 1G of HD space left. I can delete more discovery files also, however aren't these files going to regenerate again when I run a synchronization? I noticed files are continually created on our application server by discovery. Our Management believes every application server should be low disk space. They recently increased the hard drive space to 16G (which they thought was a "favor"). I am trying to find out more info about the Discovery allocation of space, so that I can explain WHY we need more space to my Management. To me it's quite simple - 16G is ridiculous, but I can't use that for an argument. -Original Message- From: Rick Cook To: arslist@ARSLIST.ORG Sent: Wed, Feb 10, 2010 10:53 am Subject: Re: Server Crash Seriously, upon what are Management's beliefs based? This seems like an arbitrary limitation. That being said, there are probably some old discovery files you could delete to free up some space. Maybe ask them how much history they want you to store. That way, they can choose between some cheap disk space and what may be more valuable data. And since their decision will have been an informed one, they are responsible for it. Rick -- From: Kathy Morris Date: Wed, 10 Feb 2010 10:37:19 -0500 To: Subject: Server Crash ** Hi All, We have 16G on our Application Server. Our Application Server runs Discovery 1.6. Our database is remote. We have right now 1G of space left. Our Management believes there is no reason why 16G is not sufficient space for this Discovery application to run parallel with other applications. We have other applications running on this server like HP Openview, SQL Server, VMware, etc... I noticed when Discovery runs (during synchronization) files are created also on the application server (i.e. java files, tmp files, etc..). And if logging is on, then files are created also. Is 16G an reasonable size to run Discovery 1.6? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: SSL settings versus nonSSL settings...
Hi, There is an article by Bryan Behling "How to configure the AR System web services plug-in to work with SSL and/or Client Certificates"t hat has helped me a lot working with SSL in the past. It also depends on what level of integration with other systems you have in place, how are they talking to each other, etc. How deep into secure communications you want to go? webs only/webs and aps? These are important questions to answer, then you can figure what needs to be done :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Richard Copits Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, February 09, 2010 9:58 AM Subject: SSL settings versus nonSSL settings... ** We've set up our 7.1 servers (application and web) as non-ssl servers. We're now being told we have to change them to SSl servers. Other than changes to IIS and Tomcat on the web server, are there any other things dealing with the application servers we should be aware of? Thanks! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Discovery and CMDB
Well, Asset statuses are very confusing, the actual field is called cilifecyclestatus, so judge from the name, I generally advice a limited use, because if you switch it "Down", it will most likely be replacing "Deployed", and you will create a hudge mess, Down does not mean that the asset is no longed deployed. Use CI outage information to maintain operational status, like up/down/maintenance etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: patrick zandi Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 03, 2010 4:10 PM Subject: Re: Discovery and CMDB ** Maybe I am getting confused with the "pingable" statement. CMDB is not pinging anything, Configuration Discovery does not ping anything Foundation discovery will ping something, but I have never seen an asset in the down status due to the FD not reaching a host that it previously created a CI for. This is a good question.. I do not know what the Trigger is for that.. except a manual one. or a preconfigured one maybe.. On Wed, Feb 3, 2010 at 12:50 PM, Kathy Morris wrote: ** Ok - then when the status is "Down" - I read in the BMC documentation is defined as "the CI is down, but not yet in maintenance." "Down" is not a location that describes where the asset is at. It's a little confusing. So the user is marking any server that is not pingable as down. But the issue is - the server can be up even though it is not pingable. Down is tricky How is this info captured in Asset Management? In a message dated 2/2/2010 4:54:52 P.M. Eastern Standard Time, remedy...@gmail.com writes: ** the cmdb assets are based on where they are at, not whether they are up? monitoring is one side (Patrol, Ca-unicenter, Whatever) up / down and overall status uptime etc. Asset is different: ordered, recieved, being assembled, deployed, in-repair, down, endof life, transferred, delete, in inventory. Where is the server in the process... On Tue, Feb 2, 2010 at 4:12 PM, Koyb P. Liabt wrote: ** If a server was discovered and marked as "deployed" and then later is not pingable - what status would you give this server? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Oracle / ARS thread linking
Gavin, I'd rather look at oracle top sql's to find if anything is creating an unusual load, then you can possibly match what you find to a remedy sql log based on the sql statement itself. How old is your application, how much data is there? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Coleman, Gavin Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 03, 2010 9:22 AM Subject: Oracle / ARS thread linking ** Hi List - we've been having a few problems with our Remedy systems and I could do with some advice. We have recently experienced a massive slowdown on two consecutive days of our production system. We have tied this to a database problem. There has been an Oracle process that has been taking up 60-70% of our DB CPU. This process was triggered by ARADMIN user. During this slowdown, our Application Servers have shown no significant jump in CPU usage. Is there a way in Oracle to tie the Oracle "thread ID" back to an ARS thread ID? I.e. If I switch on logging by thread on my application servers, this gives me the thread ID and everything that is being processed by that thread. Can I identify that thread number in Oracle in anyway? If I could, then I could potentially narrow down what could have caused this slowdown. Remedy 6.3 Patch 18 (windows 2003) Oracle 9.2.0.6.4 (AIX) Thanks for your help, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com W: www.computacenter.com ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Senior Remedy Consultant/Developer (NY/NJ Metro Area)
Is that legal :) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Chowdhury, Tauf" Newsgroups: public.remedy.arsystem.general To: Sent: Monday, December 28, 2009 10:16 AM Subject: Re: Senior Remedy Consultant/Developer (NY/NJ Metro Area) Richard, $16.50? My IMAX 3D ticket is 18.00 here in NYC. I'm screwed... -Original Message- From: Action Request System discussion list(ARSList) on behalf of copits.rich...@bwc.state.oh.us Sent: Mon 12/28/2009 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Senior Remedy Consultant/Developer (NY/NJ Metro Area) You left out: Able to walk on water and leap tall buildings at a single bound. Pay: $16.50 per hour. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pankaj Warade Sent: Friday, December 25, 2009 8:19 AM To: arslist@ARSLIST.ORG Subject: Job: Senior Remedy Consultant/Developer (NY/NJ Metro Area) ** Dear List, Title - Senior Remedy Consultant/Developer Location - NY/NJ Metro area Responsibilities include but not limited to: . Configuration and integration with Remedy Atrium CMDB . Architect custom or product-based solutions for BMC Remedy applications, including: o Conducting requirements gathering sessions o Preparation and delivery of design specifications o Estimate effort levels to design or deploy product or solutions o Prepare usage and build documentation for Remedy applications and customizations . Communicate best practices for product implementation to customers and internal resources . Define and implement ITIL based policies, processes and procedures in Remedy . Respond to customer requests for product or solution information . Train users/administrators on BMC Remedy applications . Troubleshoot and support BMC Remedy based applications and systems . Provide project leadership and project management . Mentor Junior Consultants Requirements: . 5+ years experience developing Remedy applications . 2+ years experience implementing, configuring, customizing Atrium CMDB . 2+ years experience implementing, configuring, customizing ITSM 6 or 7.x and CMDB 2.x . 2+ years of ITIL based process consulting (Foundation Certificate preferred) . Experience must include designing, developing and testing customizations to CMDB 2.x and one or more of Incident, Change, or Problem Management for Remedy ITSM 6 or 7.x . Experience loading asset and configuration data into CMDB 2.x . Experience in business process and/or technical consulting . Experience defining and leading IT improvement projects . Experience Developing and Performing Training . Self starter with strong analytical and troubleshooting skills . Good written and oral communication skills. . Advanced skills using Microsoft Office applications including Word, Excel, and Access . Be available for weekend and/or late night work as needed . Flexible and team player . Occasional travel outside of the NY/NJ area For all Job inquiries please reply to jobs.rem...@softential.com Thanks & Regards, Pankaj Warade Softential Inc jobs.rem...@softential.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Indexing help
Mark, Indixing is too unique for each environment to have simple rules how to do it. I allways distinguish new system from loaded system. New system is not a good place for analysis, you can leave it as it is out-of-the-box. When you load your system with data and have it in production for awhile, again, all relative based on your daily volumes (but I'd say 6-9 months from deployment), it is a good time to launch a small "fine tunning" project. The best source to start with are the "top sql" at the database level - pretty much the heaviest hitters in your app. Forget about the rules, there are no common rules out there that apply to everyone. It is all give and take - you add index, then you maintain it, again, no rules apply, but it is measurable in db performance stats, so you can actually find if you are gaining or loosing. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Brittain, Mark Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, September 17, 2009 11:30 AM Subject: Indexing help ** Good morning, I think I inherited a mess and need some help with indexing. If I have an index Status Assigned Group Assigned Person And the query is Assigned Group and Assigned Person does the index get ignored because Status was not used? What if I have similar indexes like these Index 1 Status Assigned Group Assigned Person Index 2 Assigned Group Index 3 Assigned Person Are these redundant? Also is there and good information out there that really gets into the nuts and bolts of indexing? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Suggestions for storing/retrieving Remedy Data & Attachments
Hi, WIth a little workflow involved you can save all attachments on disk, take a look at filter action run RERFORM-ACTION-SAVE-ATTACHMENT and use the request id to create directory structure before saving. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Deidre Nail Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, September 17, 2009 3:07 PM Subject: Suggestions for storing/retrieving Remedy Data & Attachments ** I have a company that no longer wishes to use our Remedy System. They are requesting an extract of their data in a fashion that could be read at a later time and also contain attachments. I am aware that attachments can be pulled from Remedy in a .arx or .html file. However, in order to read the .arx and the attachments, you would need to re-import the data into a Remedy System. Does anyone have any suggestions as to how I can pull the data from Remedy with attachments in a way that can be used by a different tool for later reference for this company. Thanks, Deidre Nail Remedy Developer Phone: (770) 858-7053 T/L 88810 1600 RiverEdge Parkway, Atlanta GA 30328 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Remedy Web Service field content
Thanks all for your help, it works ok, and as you mentioned, it ia a painfull process. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Tony Worthington Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, September 10, 2009 2:25 PM Subject: Re: Remedy Web Service field content ** And I can tell you that is NO FUN when dealing with a form like HPD:HelpDesk and its bazillion fields. :-/ From: LJ Longwing To: arslist@ARSLIST.ORG Date: 09/10/2009 01:08 PM Subject: Re: Remedy Web Service field content Sent by: "Action Request System discussion list(ARSList)" -- ** You should be able to right click on the attribute (right side if I remember correctly) and tell it to 'cut' that attribute...it'll remove it from the WSDL. Remember you need to flush your cache to see the changes. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, September 10, 2009 11:44 AM To: arslist@ARSLIST.ORG Subject: Remedy Web Service field content ** Hi, I am creating a web service from a remedy form. The service contain all the fields from the form regardless what I define in the input mapping. Solaris/Apache/Tomcat/ARS and Midtier 7.1 patch 7 Anyone have a workaround? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Remedy Web Service field content
Hi, I am creating a web service from a remedy form. The service contain all the fields from the form regardless what I define in the input mapping. Solaris/Apache/Tomcat/ARS and Midtier 7.1 patch 7 Anyone have a workaround? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Logging onto MidTier
Well, taking away the guest user access will make them login. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Kemes, Lisa Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, August 10, 2009 9:36 AM Subject: Logging onto MidTier ** I have a MidTier form that is open to the public and anyone that gets into it is automatically logged on as a guest user. If they need to change anything, then they will need to log on to the MidTier with their user id and password (if they have one) to make the changes. I have a button that does a run process to this URL: http:///arsys/servlet/ViewFormServlet?server=&form=On+Call Under normal circumstances, this would make the user go to the log in screen, log in and then go to the form, but since they are already "logged" in as guest, it takes them right back to the same form with guest access again Is there any URL or anything that will "force" the user to login? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Encouraging Float License Users to Log Off When Inactive
I don't think there in an elegant solution of this problrm because the user session apis are still strictly bmc propriatory. The whole licensing model seems to be century old. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Carey Matthew Black" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, August 05, 2009 7:12 AM Subject: Re: Encouraging Float License Users to Log Off When Inactive I have often wondered if you could. Create an active link (on interval) that prompts the user for a kind of "session timeout". Say every hour with a dialog asking: "Are you still there?". (with yes/no buttons) Then have a second "on interval" active link on the dialog that would timeout the dialog in 30 seconds. If the 30 second timeout Active Link gets to run then the "No" button is pushed. If the "No" button is pushed then this happens. 1) Send an Event to all open forms and have workflow clear the change flag on all windows. 2) log the user out with the Special Run Process "PERFORM-ACTION-EXIT-APP" If the "Yes" button is pushed then this happens. 1) close the dialog. Now this could be more fancy if you want to also have a display only Date/Time field where other workflow keeps updating the timestamp in the field and the "session timeout" active link could run more frequently than every 30 minutes too. (Then it could look to see if the field's value is <= ($TIMESTAMP $ - 3600) and have an accuracy of say.. 5 minutes+/- instead of prompting every 30 minutes regardless of activity.) And obviously you would need to decide what is "enough activity" to trigger the update of the timestamp value by adding a set field action to the (hopefully already existing) active links that the user is triggering. It seems like it should work in my head. Has anyone tried to implement this (or something like it) as a possible solution? -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Aug 4, 2009 at 4:03 PM, Robert Halstead wrote: ** We are experiencing this same issue.. We are at the point where we're going to remove all workflow that updates tables on an interval as that re-requests a floating license. If there are any other ways to get the licenses freed, I'm all ears.. On Tue, Aug 4, 2009 at 9:25 AM, Arner, Todd wrote: ** Hello Everyone, We are currently experiencing an issue with our float license users not logging out when they are inactive in Remedy. Needless to say this is holding a float license open for an hour that other users could have been using it. My question is, have you found an effective way to encourage your users to log off when inactive? We have sent emails which helps for about a day but then they forget again. Thanks in advance for any suggestions you may have. Todd Arner Great Lakes _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- "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 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Reporting and Archiving
Melissa, I have put together some considerations for designing of reporting/archiving solution. You can find them at http://www.speedupars.com/pdfs/Reporting.pdf Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: SUBSCRIBE arslist Melissa Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, July 31, 2009 11:26 AM Subject: Reporting and Archiving ** I'm hoping someone can help me out with some research I'm starting. We are looking into how best to architect our reporting and archiving needs. I'm trying to get a feel for what other organizations do for these two processes. Separate databases? Out of the box reporting? Analytics? Separating reporting server (either database or front end)? We are using Oracle 10g and ARS 7.1 with ITSM 7.0. TIA! :) Melissa _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Archiving and reporting/searching?
Hi, Justification is very simple: you need to have the data you are reporting on in one form (main or archive), so if you have last 90 days report these records better be in one form, otherwise life could be quite complicated. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Pruitt, Christopher J Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, June 10, 2009 11:10 AM Subject: Re: Archiving and reporting/searching? ** I see no value in not deleting from the original source. I know that option is available but I could never understand why you would want to do that. I am sure there are some who could justify it. We just don't do it. We delete from Source after coping to the Archive. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SUBSCRIBE arslist Melissa Sent: Wednesday, June 10, 2009 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: Archiving and reporting/searching? ** Thanks for the info Chris. I would assume we would do the archive to delete from original. What is the value of archiving, but not deleting? (maybe I'm missing something). Wouldn't it still search all the data in the original form if it weren't deleted? "Pruitt, Christopher J" Sent by: "Action Request System discussion list(ARSList)" 06/10/2009 09:32 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Archiving and reporting/searching? If you are using the imbedded Archiving solution for AR System and you are doing an Archive Type of 'Copy to Archive', then creating a join does not make since because the data would still be in the original data form, so no need to a join. However, it you are doing a 'Copy to Archive and Delete form Source' then building a join is a good idea, however, doing a Join and choosing "Request ID" as the join criteria would not work. The problem is when the data moves to the Archive form the "Request ID" form the original data form is copied into a field called " Original Request ID" and the "Request ID" on the Archive form would never match the "Request ID" on the Original data form, as it gets a new "Request ID" when the record is moved to the Archive. Second, for a join on fields to work there has to be matching data in those fields on both forms. What we did was to include a field called "Form Name" that held the name of the original data form in it and then we did the join criteria on that field. However, you really need to be careful on doing reports off of this join form. I will give you duplicates. For example on one of the Data form to Archive form joins we have the following counts: A_Test_Data: 4,450,400 A_Test_Archive: 34 A_Test_JN: 151,313,600 If you do the math the 151,313,600 equals 4,450,400 x 34. So you really need to make sure when you are doing reports to use a lot of qualifications to eliminate getting duplicate records returned. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immedi
iWave
Hi, Does anyone has experience using iWave for integrating incident/change with other change/incident products. (ITSM 7.1 in place) Thanks in advance. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: BMC KB site - now 100% less useful than before!
RE: BMC KB site - now 100% less useful than before!Well, this message should be dated from the time of the Remedy assets aquisition from Peregrine and consequent merging of the kb's together with the old BMC products, e.g. quite some time ago. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Walters, Mark Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, June 04, 2009 8:56 AM Subject: Re: BMC KB site - now 100% less useful than before! ** BMC are aware that there is a problem with KB searches at the moment - this is from the support web site; Latest Support News We are currently experiencing technical difficulties with our Knowledge Base Search functionality, which is causing inconsistent search results to be returned. We apologize for the inconvenience and are working to resolve the problem as quickly as possible. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718 Sent: 04 June 2009 13:54 To: arslist@ARSLIST.ORG Subject: Re: BMC KB site - now 100% less useful than before! ** THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never gives you a direct result. -Rafael -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire Sent: Wednesday, June 03, 2009 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: BMC KB site - now 100% less useful than before! I so agree! I did a search on "ARERR" and it returned 3 articles! It is a loose situation! They may lose too!! I searched archives of the list and found a conversation regarding my problem from 2006 that was more helpful. It didn't answer the problem, but it at least pointed me in the right direction. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Wednesday, June 03, 2009 2:11 PM To: arslist@ARSLIST.ORG Subject: Re: BMC KB site - now 100% less useful than before! ** All this is to the detriment of BMC support itself, because the KB isn't working now (and before this problem, it was not very good anyway), so we'll have to keep submitting more tickets to BMC support for things that we should be able to find in the KB in the first place. This in turn may raise support fees, or at least eats into R&D dollars. It's a loose-loose situation for everybody -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Rick Cook Sent: Wed 06/03/09 2:12 PM To: arslist@ARSLIST.ORG Subject: BMC KB site - now 100% less useful than before! I can't even search for something like "license" and get even ONE result, despite leaving the search criteria wide open. I need some information that I know is (was?) probably out there, but I can't get to it since they "upgraded" the site recently. Does anyone have any idea who to contact about this? There is no "Contact the webmaster" or some such on the page, either. Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee andmay contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of theintended recipient, you are hereby notified that any dissemination of thiscommunication is strictly prohibited. If you have received this communication inerror, please notify us immediately by e-mail and delete the message and anyattachments from your system. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Odd table field issue
Hi, if you are not looking in different views in admin and user, then you can consider rebuilding an index called FIELD_TABLE_IND. This one is the only index of FIELD_TABLE. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: William Rentfrow Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, June 04, 2009 1:06 PM Subject: Odd table field issue ** I'm working in a 6.3 CSS system (ARS Patch 25, appropriate User/Admin tools)s All of the table fields on every form I open do not show the correct fields. They show the fields for the form the table is located on and not the fields from the selected table in the Admin tool. Even if I change the form the fields do not change. We've tried rebooting, bouncing the AR Server, etc - I've never seen this before. It is essentially impossible at this point to edit existing or add new table fields. Anyone run into this? The only redeeming factor is that this system is in the process of being replaced. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Lost form reference
Jenni, In toad run select * from arschema where schema_id=107; arschema is the top layer where form inforrmation starts, if you dont have a record there, you won't see it. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Wacholz, Jeanette (Jenni) Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, June 04, 2009 12:46 PM Subject: Lost form reference ** Hi Listers, ARS V6.3 P020 ITSM 6 Oracle V10g AIX 5.3 We have lost the ability to access one form via the User or the Admin tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the view of the form. I can also see the t107, h107 and b107 tables there. But the form is not visible or available from inside Remedy. I believe I've seen issues similar to this on the list but I haven't been successful finding them in the archives. The issue began last night after our dba's installed Guardium on the db server. (ARSystem was shutdown correctly before the dba's started their install and brought back up after the install was completed.) Any help you can offer would be appreciated! Jenni Wacholz Coventry Health Care Inc Scottsdale AZ 480-445-2517 Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ARERR [311] Field ID is not related to this form : 200000020
You may want to check your menus for this field as well. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Dwayne Martin" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, May 29, 2009 3:02 PM Subject: ARERR [311] Field ID is not related to this form : 20020 Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the above error- usually. On Form B there is a character field, and a button that calls a link that opens the single record in Form A that matches the character field. That button/link works. If I click a button that should display 35 records I get the error. But I can display each of the 35 records one at a time by pasting the value in the character field and clicking button that opens the matching record. I checked the BMC Knowledge Base and found an entry about an “embedded query.” 20020 is the “Name” fieldid in the Asset Management module, which we have. So somewhere in our set-up there must be a reference to this “Name” field. But I’ve checked the Database data for every field on the form, as well as the form itself. There is no error or reference to 20020 in the Active Link, Filter, or SQL logs. There are no tables with references to 20020 . Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: LDAP question
How many people records do you work with? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Shane Buchholz Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 29, 2009 3:05 PM Subject: LDAP question ** We are trying to configure Remedy to set the Profile Status to "Obsolete" in the CTM:People form when they have been deleted from Active Directory. The most logical approach is to use an escalation that will fire at regular intervals to keep the CTM:People form as up to date as possible, but the limitations of the workflow seem to make this impossible to do. We are using the inetorgperson form to pull data in from AD, and have an escalation that fires and creates new accounts in the CTM:People form. It recognizes new accounts, but we haven't been able to determine how to have it recognize that an account is no longer in AD. Please let me know if this is even possible, and if so what the best approach is. ARS 7.1 ITSM 7.1 SQL Server 2005 Windows Server 2003 Thanks, Shane Buchholz Information Security Specialist Account Services - Information Services -- Confidentiality Notice: This e-mail message, including any attachments, 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 e-mail and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: OT:Server Configuration
Hi Roger, The 7.5 64 bit apps are for unix, so, in order to take advantage of more memory you have to change the os. If I remember correct, the Windows apps are still 32 bit, they can run on 64 bit windows OS, and they will not utilize well the wintel memory (to the limit of how much memory 32 bit app can address). But then, you are still running ms sql, and that will keep you in the wintel world forever. 2-4 processor servers 8-16 GB will be an well oversized server ( bear in mind the quad processors 1=4 these days). How many servers are you going to have in the group? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Nall, Roger Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 28, 2009 10:32 AM Subject: OT:Server Configuration ** Okay, I am not trying to start a debate. I am only looking for some information. We need to replace my production environment. We are currently in a Windows environment on XP. We have 7k+ users but concurrent connections are 750 max. We are going to stay in windows and go to a Server Group. I am just looking for recommendations for processor speed, memory, number of processors, etc. Any help would be appreciated. Thanks, Roger A. Nall Manager Service Assurance/National Applications T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Close window without saving
John, You may consider displaying the message in another dialog window, this way you can pass the user selection back to the original dialog and respond accordingly. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: John Kelley Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 28, 2009 11:13 AM Subject: Close window without saving Hi List ARS 7.1 patch 6 App 7.03 patch 6 I have a custom form which opens in a dialog view. When a users name is populated in the form. It searches its CTM:people profile for an expiration date. I then have a message that pops up if the expiration date has expired "please fill out a new request. " I would want ideally to hit OK on the message and it automatically closes out of the form without saving data. But If I have to clear the fields That would be OK as well. I'm not sure how to close the window after the message. Anyone have any quick ideas. * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Heterogeneous services
Hi, The listener is part of the oracle installation, referred as oracle client. If not installed, you can run the installation and select the client only. In windows you will see it as a service - OracleXETNSListener or similar. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Soria, Joe Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 28, 2009 1:15 PM Subject: Re: Heterogeneous services John, Ensure you have your oracle environment variables properly set (ORACLE_HOME, ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here: $ORACLE_HOME/bin. Hope that helps. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Thursday, May 28, 2009 11:02 AM To: arslist@ARSLIST.ORG Subject: Heterogeneous services Hi List Are there any oracle gurus out there that may be able to assist me. I'm setting up Heterogeneous Services to be able to access columns in an Access DB from within Remedy (Oracle DB 10g). I am trying to figure out how to start and stop a listener on my application server with Oracle 10g I can't find the Listener Utility. Is it part of the Oracle installer? When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not recognized as an internal or external command" I do a search in the oracle directory and it is not there. Any ideas how to install it? What option in the Oracle installer installs the utility? Thanks JK *This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Workflow
See Active Link Guides - walking tables. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: oracle...@aol.com Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 5:57 PM Subject: Workflow ** Hi All, When the user select on the table field, I want the user to be able to select multiple Record ID's within the table, and merge these records together into a form. Is this possible? I know if the user selects 1 record, and then presses a button workflow will trigger. The problem is I need the user to be able to select multiple records in the table and an action is triggered. I hope this is possible. -- A Good Credit Score is 700 or Above. See yours in just 2 easy steps! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ARInside source code
Stefan, Take a look at GNU on wikipedia, they have lots of links and examples. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Stefan Nerlich Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, May 20, 2009 11:43 AM Subject: Re: ARInside source code ** Hi Axton, identifying the best license seems to be quite difficult. Of course i only want to avoid that someone compiles ARInside, renames the executable to (lets say) "Stargazer" and sells this as his own product. Nevertheless ARInside is developed to work in commerical enviroment. Please suggest a license that might fit our needs. Thanks, Stefan -- Date: Wed, 20 May 2009 10:05:24 -0500 From: axton.gr...@gmail.com Subject: Re: ARInside source code To: arslist@ARSLIST.ORG ** Any chance you can release the code under a legally challenged/proven open source license (see OSI approved licenses)? The terms outline in COPYING.txt are nebulous and legally binding. The current terms are a legal liability for anyone that hosts the source. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, May 20, 2009 at 5:21 AM, Stefan Nerlich wrote: ** Hello List, iam releasing the complete C++ source code for ARInside in the hope it will be useful for someone. ARInside is a commandline application that generates linked HTML pages to document ARSystem workflow. The program can be run in online mode connecting to an ARSystem server or file mode using an ARSystem Administrator generated XML server definition file. In advance a Packing List with all ARSystem server objects not to include in the documentation can be specified in the application configuration. ARInside has been awarded as "Best 3rd Party ARSystem releated Product (Freeware)" by the ARSlist 2006. http://devdor.org/files/src/arinside_src.zip (~300KB) I have converted the project successfully to Visual Studio 2008 but Microsoft Visual C/C++ 6.0 and Remedy (C) ARSystem API 7.x or higher will be sufficient to compile the project. Then, a working .exe should fall out of the linker, if not, you've certainly done something wrong. Please DON'T contact me in this case :) In any case, feel free to learn from these sources, or maybe bash me for the bad coding style. Anyway, have a good time with this, Stefan Nerlich, Dortmund, May 2009 Kein Werbe-Blabla - hier klicken! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- Kein Werbe-Blabla - hier klicken! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Index Error
Hi, You have duplicate values of unique key, so - you may have to massage your data prior to import; - you can change the index of the destination form not to be unique, and fix your data after the import. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Dwayne Martin" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, May 20, 2009 8:00 AM Subject: Re: Index Error Try just migrating half the data. If you get the error, try a quarter, etc till you pin down the offending record. Dwayne Martin James Madison University Original message Date: Wed, 20 May 2009 13:02:24 +0530 From: Manish SINGLA Subject: Re: Index Error To: arslist@ARSLIST.ORG ** Hello Bhupesh, Do increase the index values there in ARSchema table at DB level, say by some static value 500 etc. This is because when you were archiving the DB, it was in use and some indexes(At ARschema) remains lesser and at form level it exceeds. Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 12:47 PM To: arslist@ARSLIST.ORG Subject: Index Error ** The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Crystal report Question
Crystal report QuestionHi, You may consider using tcptrace or similar utility to capture what's wrong with your environment. It usually brings more information than the logs in similar cases. There is free eval of tcptrace.exe at www.pocketsoap.com. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Sokol, Brian Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 2:35 PM Subject: Re: Crystal report Question ** Crystal is installed on the same server as my MidTier. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Monday, May 18, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A. Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the "Datasource Location" properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called "Use DSN Default Properties". If the value there is set to "False", try setting it to "True". HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to "Dynamic"? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok excep
Re: Crystal report Question
Crystal report Question and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A. Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the "Datasource Location" properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called "Use DSN Default Properties". If the value there is set to "False", try setting it to "True". HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to "Dynamic"? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answer
Re: Adding a Test server to our Prod and Dev Environment - Best way to sync Test?
Susan, The most effective way, in my opinion, is to restore a copy of the prod db, then masage the data and start the test ar services. It will have all the data from prod, well loaded system takes about 4-6 hours to restore, and then you do the data masaging, that can be scripted as sql and runs for less than a minute. It may sound extreme, but it is the only clean way to find how particular release will affect the production environment. Because this is labor/resource intensive operation you may consider establishing a release cycle, say 2x a month. This will help you to have everything well organized and properly planned. Of course, nothing is bullerproof. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Susan Palmer Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 14, 2009 10:38 PM Subject: Adding a Test server to our Prod and Dev Environment - Best way to sync Test? ** Hi Everyone, We are actually (finally) moving to a Sun Solaris 10 environment. Dev server is built and in use. Prod server almost done and will be in production the weekend of 5/30 !! We'll have a BIGIP to two prod servers, one active and one as a failover if needed. Two Oracle 10g databases using dataguard to keep insync. We even will have dev and prod Crystal Report Servers (not sure I see the value to a dev but it completes the picture). The next step is inserting a Test server(s) into the mix. It's almost overwhelming to go to such a 'full' environment. It brings with it some process changes that are challenging. I'd like some feedback on best methods you've come across. 1. How do you keep the Test server database reasonably current reflecting the Production database? Is there a way to do this without intervention to clean server names or manually migrate data? 2. Do any of you have a situation where the production operations group is responsible for moving all enhancements from Test to Production and they are not Remedy trained? We do have migrator but there are some inherent problems with using it when Forms you migrate have Audit or Archive forms. Not sure if this was just a windows problems but had several situations of corrupted data in the past. Any advice is welcome. Thanks, Susan ARS v7.0.1P2 Sun Solaris 10 Oracle 10gr2 Susan Palmer ShopperTrak RCT Corporation 200 W Monroe St 11th Floor Chicago, IL 60606 Office 312-529-5325 Cell 312-502-7687 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: general advice on how to sell the work - this is not a Friday humour
Hey, It is a no win situation. Just take the 30 days and let BMC do it, I'm sure you will get extra time after that. 30 days is not enough to get everything started anyway. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Remedy Maniac" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, May 15, 2009 7:37 AM Subject: general advice on how to sell the work - this is not a Friday humour my dear senior experts, actually my question could go to a novice as well. It's as the following: I got an offer for an implementation of the ITSM Suite for an African country. It's suppose to be a 30 days of work. And they are looking for a frenchy. So for me it's perfect. The problem is that now after few meetings, one of the managers had the idea to ask BMC for the implementation instead of me. They will still give me the 30 days to do other stuffs anyway. I am just wondering how I could argue to make them stay with me and not go for the BMC guy? I am sure some people from this list will have good ideas to come up with. Many thanks in advance Serouche PS: good arguments from people working currently for BMC are also welcomed ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Czech character are not supported
Ahoj, Also, make sure that your pc where the admin tool runs uses the same char set. I only had success with ms sql implementations in czech (but that was very long time ago). Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Michiel Beijen Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 15, 2009 8:23 AM Subject: Re: Czech character are not supported ** Please make sure both Remedy and your database are configured to handle the Czech character set or UTF8. Refer to the Configuring guide for more details. Kind regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Fri, May 15, 2009 at 12:46, nsachin wrote: Hello All, I want to change the label of a text field in czech language characters.But,when i try to change the label then some of the characters are not displyed correctly in Admin Tool. Please help me on this. Regards, Sachin :rules: -- View this message in context: http://n2.nabble.com/Czech-character-are-not-supported-tp2907080p2907080.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
It is kind of tricky, once you restart the ar server the interval based escalations start counting from 0, so, every time the overall time line will be different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, May 12, 2009 11:32 AM Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry -- From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don’t have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry -- From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Mapping dis-similar Status Histories on data imports
Hi, If you import your assets with the same entry id then you can use sql udate/set statement to bring the selected 4 status history values from the old H table into the new H table. I'd just make shure that there are no user updstes from the time of the import to this update. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Dwayne Martin" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, May 13, 2009 9:09 AM Subject: Mapping dis-similar Status Histories on data imports Dear List, We are exporting our data from the AST:ComputerSystem (Asset Management) form into a totally customized form. AST:ComputerSystem has 14 Status values and the new form has just four, so obviously several AST:ComputerSystem Statuses have to map to just one Status in the new form. No problem. But what about Status History? In a data export file, Status history looks like: firstDate^firstUser^secondDate^secondUser^^^fifthDate^fifthUser . . . (The "^"s appear as squares in Notepad. I don't know what they really are.) You would have to figure out which date&user pairs in the old form map to which date&user pair in the new form, then pick the latest. It sounds hideously complicated. But if anyone has ever tried anything similar, or even has some ideas it would be good to hear from them. Dwayne Martin, James Madison University (ARS 7.1 p2, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: External SQL DB
Hi, The use of dblinks is one way to do it. Once you add a dblink, you can create vendor tables, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, May 13, 2009 5:14 PM Subject: External SQL DB Hello List, I need to have Remedy communicate with an external DB, 2 way. Remedy is only installed on one of the DBs. It needs to recieve data from the external SQL DB, process it, and provide updates back to the external DB. Can anyone tell me the best method to do this? Examples, documentation, links, anything would be great. ARS 7.5 SQL 2008 Windows 2009 Thank you Les Ganton ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Remedy Oracle database growing very quickly for no apparent reason?
Hi,
It is not usual to have sudden growth, so there is a reason.
Oracle enterprice manager provides 2 out of the box reports to show the
table sizes in MB and number of rows.
Home>Utilities>Object Reports>Tables>Table Storage Sizes
Home>Utilities>Object Reports>Tables>Table Statistics
Your dba might be able to generate table growth report, to pinpoint the most
agressive growing tables.
Then you have to figure out why. There is usually a reason.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message -
From: "Pierson, Shawn"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Wednesday, May 13, 2009 5:27 PM
Subject: Re: Remedy Oracle database growing very quickly for no apparent
reason?
If that is what most of the SQL is doing, try running this to see what form
is causing it, and then see if there are any escalations on those forms that
might be triggering this. Basically, you want to find the form names for
all of the "T" tables involved in the update statements specifically to
figure out what is happening.
SELECT [name] FROM arschema WHERE schemaid in (42,50)
Also, you can turn on various logs on the Remedy side, such as your API
logging, and that will give you better information as well. Your best bet
is to try logging when you think nobody will be using the system, as that is
the best time to not also capture all the users logged in to the system
working.
I would also suggest that you do not limit the size of the database. That
can cause some major problems with Remedy if it can't update the database.
Shawn Pierson
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Brad Terhune
Sent: Wednesday, May 13, 2009 4:19 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Oracle database growing very quickly for no apparent reason?
I am running ARS 6.3 with Helpdesk 5.6. The Remedy services run on a
Windows 2003 Server box and the databases are on a remote Oracle
tablespace. The DBA has been confounded by a sudden upsurge or
ARSERVER process activity creating lots of records. Some of his
messages appear below:
The Remedy database is doing a lot of activity, inserting records,
updates, etc. It has been running pretty consistent for the last
couple of days. I have emailed Brad about this, and he is not aware
of anything on the server. But the processes are connected from the
Remedy server from the arserver.exe process. I've tried killing the
processes but the server will restart it. The Remedy tablespace is
about 10G and growing.
We need to get someone to look at this. I am putting a quota of 12G
on the Remedy database tablespace so that is doesn't crash the
database.
Remedy is still doing a lot of database work. Here is a list of
statements its processing. Does this bring anything to mind as to
what its trying to do?
SQL ID
SQL Text
Count
1csjzk0my2pq3
table_e_a_a7bf4_20_0_0 1
avdcjb6g0ybf3
SELECT C26900 FROM T166 WHERE C1 = '001'1
965apkx75pcxx
SELECT C26000 FROM T129 WHERE C1 = '017'1
db86fqnurxpd0
table_e_a_40cd7_f_0_0 1
67z6vurfts1cy
UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 42 1
0s29mjn9wxu2k
table_e_a_40cd7_11_0_0 1
bfqsyft87hs2y
SELECT C24005 FROM T73 WHERE C1 = '035' 1
adxakw3adg33f
SELECT charMenuId,name,version,smObjProp FROM char_menu ORDE1
a3jvwqvwckpgx
table_e_a_40ccf_d_0_0 1
8k2t34c1var7m
UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 50 1
2d2qpdaxgm9rh
SELECT charMenuId,name,version,smObjProp FROM char_menu WHER1
23uk2w34bjm24
SELECT C23009,C26000 FROM T129 WHERE C1 = '01
7cp5gmctv5f18
table_e_a_40b0e_18_0_0 1
96979yh64d6rq
table_e_a_a7bf4_1b_0_0 1
gjqp06u03nmyt
table_e_a_40d40_11_0_0 1
3cc9bcnct8758
table_e_a_40cd7_15_0_0 1
d1p1n7m50y3mg
INSERT INTO H42 (entryId,T0,U0) VALUES ('00025598125',121
ddbqnqgxaxmaj
SELECT C25034 FROM T166 WHERE C1 = '001'1
2t9zma8gt0m8f
SELECT C24005 FROM T73 WHERE C1 = '107' 1
6xaqdh59gs6s3
SELECT C25000 FROM T144 WHERE C1 = '0001006'1
5mdf76761gk6q
SELECT nextId FROM arschema WHERE schemaId = 50 1
c0ugsw952ykzq
SELECT nextId FROM arschema WHERE schemaId = 42 1
a05p2jf1vx8xs
SELECT C24005 FROM T73 WHERE C1 = '101' 1
6a5zk4jt9x02k
SELECT charMenuId,name,version,smObjProp FROM char_menu WHER1
Thank you in advance for any help you all can provide.
Brad Terhune
UTHSC IT Team Leader
bterh...@utmem.edu
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist:
Re: What is the best platform to run Remedy 7.5 in?
Solaris/Oracle, especially if Oracle's bid on Sun goes on. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Kaye Bernales Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, May 13, 2009 9:43 PM Subject: What is the best platform to run Remedy 7.5 in? ** Hi, When downloading from the BMC site, a list of platforms are available: Microsoft Windows/NT, AIX, HP-UX, HP-UX Itanium, Linux, Solaris. Which among these is the best platform to run Remedy 7.5 in? Any advantages of one platform over the other? Also would any have limitations for eventual virtualisation? Thanks! Kaye 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. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Load testing ITSM 7x
Load testing ITSM 7xJohn, Scapa test is a tool that can simulate user load. They say BMC uses it for testing the new solutions. I think that either way you will need some fine tunning at some point when your system is under production load regardless what a load testing results might be. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Bilinski, John Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 14, 2009 9:04 AM Subject: Load testing ITSM 7x ** All, Has anyone done load testing on AR System and ITSM 7x? If so what type of software did you use to perform the load testing? Thank you. John Bilinski US Department of Justice Operations Services Staff Contractor CSC 202-305-3202 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: what is T1 used for?
RE: what is T1 used for?Hi, 1. You can cache an admin user using the arcache utility, see your documentation for details. 2. You can restore T1 and user_cache tables using your recent database backup. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Guillaume Rheault Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 14, 2009 9:26 AM Subject: Re: what is T1 used for? ** In most situations, T1 is the table related to the User form... Of course if the User form was dropped and recreated or anything like that, the User form table could be another T table -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Remedy Maniac Sent: Thu 05/14/09 4:26 AM To: arslist@ARSLIST.ORG Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Repost:Strange Error
Shafqat, I will bear with those who adviced on generating client side logs - I'd run for all of them. Cleaning client cache is a first "must do" step because there has been problems related to it. There are too many things that can cause such an error, lack of permissions is one of them. So, do the next step and see what the log will point to. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Shafqat Ayaz" Newsgroups: public.remedy.arsystem.general To: Sent: Tuesday, May 12, 2009 2:24 AM Subject: Re: Repost:Strange Error Paul My apologies if I did not make it clear, this is happening on the Windows User Tool and not the web. Nicky i have not only cleared all the files, the user was made to delete all Remedy related directories( obviously not the program files) apart from the arcmd directory and re-create them, no help. thanks shafqat --- On Tue, 5/12/09, Paul in Austin wrote: From: Paul in Austin Subject: Re: Repost:Strange Error To: arslist@ARSLIST.ORG Date: Tuesday, May 12, 2009, 5:08 AM I would have your Vista users try the exact same actions using FireFox. If your users are on Vista, then they likely have IE 7.0 installed as that is the default browser. IE 7.0 has given us some problems with some forms (although not SRMS). We enabled a workaround by going to FireFox while we research the issue. Note: IE 8.0 does not seem to have the same issues as IE 7.0. Paul -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz Sent: Monday, May 11, 2009 10:03 PM To: arslist@ARSLIST.ORG Subject: Repost:Strange Error Hi All We are getting a strange error only on some machines running Windows Vista. The error is as follows. ARERR[326]Required field cannot be set to a NULL value-SRM:WorkInfo:Work Info Type The issue is that it is occurring only on some machines and does not seem to be related to the User profile. The users can log in from a Windows XP machine and submit a ticket fine, but not from Vista machines. Have deleted all .arf and .arv files from the home directory, checked all permissions on directories on the machines, all are in order. checked the field on all the relevant forms, all are fine, the permissions are fine. If anyone has encountered this error or know what could be causing this, please help! Many thanks as usual in advance for any help/hints. ARS 7.01 ITSM 7.1 Patch 9 Oracle 10.2 Solaris Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Strange Error
Hi, Before going any further you may want to clean the ar user cached forms on these machines. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Shafqat Ayaz" Newsgroups: public.remedy.arsystem.general To: Sent: Monday, May 11, 2009 6:23 PM Subject: Strange Error Hi All We are experiencing a strange error. It is only happening with some 4 or 5 machines currently. The error is as follows ARERR[326]Required field cannot be reset to a NULL value-SRM:WorkInfo:WorkInfoType. The problem as I said before is that it is occurring on only some machines, the only thing different i have been able to find out is that these machines are running Windows Vista as opposed to Windows XP, where this error is not happening. I can log in as the Users who are getting these error from another machine and do not get the error. I have checked all the forms and work flow permissions etc and they are all fine. The only thing is according to the users these errors started after we upgraded to ITSM patch 9. Anyone seen this error before? or can point me in the correct direction? Much appreciated. just to let you know the steps we have gone through. checked the local permissions, all directories are write able, deleted all arf and arv files, checked all permissions for users and workflow in the Remedy system. The two things pending I am trying to find out from the users(they happen to be in Israel), are, what is the value of the Work Info Type field when the Incident is being submitted and what version is the User Tool. ARS 7.01 Oracle 10.2 ITSM 7.1 patch 9 ( recently upgraded) Many thanks as usual for any help. Shafqat Ayaz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Webservices
I totally agree with you, it is a major pain in the neck. Good or bad, at least it is there and it is usable with some tricks. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: LJ Longwing Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 08, 2009 1:25 PM Subject: Re: Webservices ** making changes isn't a problem...the issue come in with the fact that I would ideally have one filter with a loaded wsdl, and have some method available to tell that filter where to go (data driven). Due to their implementation I need to have a copy of the filter for each environment...which means I'm not properly testing my Prod code in Test because I'm not using the exact same filter...so if the mappings got screwed up on one but not the other...I wouldn't know till I hit that environment. Just FYI...I generally prefer to make changes directly at the def level in an XML def because you don't need to worry about string length in there...:) -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Friday, May 08, 2009 11:18 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices ** The sooner you learn to dig and make changes in the web svcs def files, the less painfull the process is. Also, my c2 on best practice for host/alias servers, etc. naming conventions: keep them the same lenght. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: LJ Longwing Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 08, 2009 11:40 AM Subject: Re: Webservices ** Goodput that as my #1 complaint about web services...:) From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Friday, May 08, 2009 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices ** Of course it counts :) It's the kind of info I am looking for. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, May 8, 2009 at 9:38 AM, LJ Longwing wrote: ** Does it count if I don't like how the target URI isn't data referenceable?by this I mean that when I consume an external web service, I need to point my Dev, Test, and Prod to different URIs. This means that I either can't have the same workflow in all environments, or I need to develop a complicated data driven structure (which is what we have done here) that determines which filter to fire based on what environment we are in, and have as many copies of the filter with the same workflow, but different URIs as I have environments. This is the biggest hurdle I have had to face in regard to Remedy's implementation of web services. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Friday, May 08, 2009 8:27 AM To: arslist@ARSLIST.ORG Subject: Webservices ** I wanted to get a feel from the group on some of the headaches and limitations of the Remedy web services implementation. I've avoided the interface, much like the palgue, since it was first adopted. I'm looking for limitations when people interface bi-directionally with other applications, performing operations like creating incidents, in relation to things like not being able to support certain data types, not being able to query certain outside webservices due to how they are structured, etc. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: Webservices
The sooner you learn to dig and make changes in the web svcs def files, the less painfull the process is. Also, my c2 on best practice for host/alias servers, etc. naming conventions: keep them the same lenght. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: LJ Longwing Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 08, 2009 11:40 AM Subject: Re: Webservices ** Goodput that as my #1 complaint about web services...:) -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Friday, May 08, 2009 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices ** Of course it counts :) It's the kind of info I am looking for. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, May 8, 2009 at 9:38 AM, LJ Longwing wrote: ** Does it count if I don't like how the target URI isn't data referenceable?by this I mean that when I consume an external web service, I need to point my Dev, Test, and Prod to different URIs. This means that I either can't have the same workflow in all environments, or I need to develop a complicated data driven structure (which is what we have done here) that determines which filter to fire based on what environment we are in, and have as many copies of the filter with the same workflow, but different URIs as I have environments. This is the biggest hurdle I have had to face in regard to Remedy's implementation of web services. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Friday, May 08, 2009 8:27 AM To: arslist@ARSLIST.ORG Subject: Webservices ** I wanted to get a feel from the group on some of the headaches and limitations of the Remedy web services implementation. I've avoided the interface, much like the palgue, since it was first adopted. I'm looking for limitations when people interface bi-directionally with other applications, performing operations like creating incidents, in relation to things like not being able to support certain data types, not being able to query certain outside webservices due to how they are structured, etc. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Inconsistant Search times
Mike, I'd perform detailed logging to find out where exactly the time loss happen (in remedy terms). Then I'd compare it to the server events and the tread log to find out if the search co-incides with other server operation or it is waiting for a free tread. I know, it is not a lot of help, but if you are getting consistent search results for different keys on the sql level the most common reason for insonsistent search times - cached entries vs non-cached entries, is out of the picture. BTW, are you testing in production or in dev. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "versicle" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, May 07, 2009 12:26 PM Subject: Inconsistant Search times All, We've created a custom ticket form which as approximately 75 fields including three tables. We've also imported approx 600K records to this form. When we do a search on the unique index (field 1) we are getting inconsistant response times. The search can take anywhere from less then one second to 8 seconds (this happens regardless if you use the same ID over and over or a different ID each time). The search only returns one row as expected. We've run the query on the DB and via SQL plus from the app server and it returns within milliseconds. To add to this strange behaviour, after restarting the application servers, the response time is consistantly at less then a second, then over about an 8 hour period is becomes inconsistant. We've tried disabling escalations and adding indices as well as adding some parameters to the ar.cfg (such as cluster-index, etc). All other forms (HPD, CHG, etc) do not display this behaviour. As anyone seen this before or have any ideas to try and get a consistant response? We are running ARS 7.1 patch 5 and ITSM patch 8 on Windows 2003 and Oracle 10 Mike -- View this message in context: http://www.nabble.com/Inconsistant-Search-times-tp23430541p23430541.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ARS with Load Balance
There is a white paper, just don't know if it is updated for 7.x. It is posted in the kb. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: 金恺 Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 07, 2009 1:41 AM Subject: ARS with Load Balance Hi All Do BMC have some Documents to describe how ARS works with the Load Balance Hardware? Thanks a lot -- Best Regards! Kevin, Jin Leadtrust, Hangzhou, China -- Add: Floor 8, Huaxing Centry Building, No.317 Wantang Rd, Hangzhou, 310012 PRC Tel:086-0571-87397397 Fax:086-0571-87397399 Mobile:13777801411 Web:www.leadtrust.cn ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Filter Phasing and Escalations
RE: Filter Phasing and EscalationsLyle, There is an easy way to check this out. Have a sample escalation logged and you can see if the ations are run in phases or in sequense. I'd think that they run in sequence just because of the nature of escalation - there is only one set of actions, one escalation runs at a time. Personally, I use the "touching" aproach described earlier in this tread and I consider it best practise. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Guillaume Rheault Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, May 06, 2009 4:09 PM Subject: Re: Filter Phasing and Escalations ** It could be a "documentation bug" -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Lyle Taylor Sent: Wed 05/06/09 3:57 PM To: arslist@ARSLIST.ORG Subject: Re: Filter Phasing and Escalations That's interesting - their documentation specifically states that it can be used in escalations as well. Thanks for the info! Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rosana Aira Sent: Wednesday, May 06, 2009 1:17 PM To: arslist@ARSLIST.ORG Subject: Re: Filter Phasing and Escalations ** Hi, I found this KB in the knowledge base of BMC support site. It is KB KM-00025929 and it reads: "Question How is Application-Release-Pending implemented and used in workflow? Answer Application-Release-Pending does have an effect but it is very specific. It releases only pending Push Fields actions on ARSetEntry (Modify) and makes those available to subsequent filters. The Push Fields action needs to be in a filter set to run out of phase (ending in `!) and the Application-Release-Pending needs to also be in a filter that runs out of phase. Filter processing on FormA Filter1`! - push action to FormB Filter2`! - Application-Release-Pending Filter3`! - set fields reading same record from FormB (pushed data is available here) Filter4 - set fields reading same record from FormB (pushed data is available here) If Filter2`! is disabled, then Filter3 and Filter4 no longer have access to the pushed data, but queries the record before the push occurs. " HTH Regards. Rosana On Wed, May 6, 2009 at 2:06 PM, Lyle Taylor mailto:tayl...@ldschurch.org>> wrote: Right, and that takes me back to my question: will that naming convention have the same effect on the actions in an escalation like it does for a filter? Thanks, Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 06, 2009 7:59 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Filter Phasing and Escalations I have used it and it seems to work. The trick is since it is a Run Process action (Phase 3) you put it in its own filter with a naming convention of `! to force the action to run in Phase 1 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Guillaume Rheault Sent: Wednesday, May 06, 2009 7:30 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Filter Phasing and Escalations Hi Lyle, FYI - I've yet to see the Run Process Application-Release-Pending work. Even with 7.5, it seems not to workit has not worked for me in the past or now, the way I was expecting it to work -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Lyle Taylor Sent: Tue 05/05/09 7:59 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Filter Phasing and Escalations Hi Dave, Thanks for replying, but I'm afraid I don't understand where you're trying to take me here. I understand what the various workflow is and where it executes. The problem is that not all actions happen as they are encountered in the workflow due to phasing. This can occasionally cause problems, because something that you may have expected to happen sooner in the workflow processing may not have yet been completed, because it happens in another phase or has been placed later on the queue. This appears to be happening here. Most of the time, things work as expected - however, I've seen it where not all of the processing from step two of my escalation has occurred before step three gets executed, I _think_ due to filter phasing and how the queues for the various filters on the two forms get managed.
Re: Floating License/Write Access Problem after Upgrade to 7.1
Just a blind shot, but in 7.x the Public group has to be "Change" type. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Mitchell, Sharon N. (MSFC-IS30)[UNITeS]" Newsgroups: public.remedy.arsystem.general To: Sent: Wednesday, May 06, 2009 3:44 PM Subject: Re: Floating License/Write Access Problem after Upgrade to 7.1 Misi, I tried this and got the same result. Thanks for the suggestion though! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Wednesday, May 06, 2009 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Floating License/Write Access Problem after Upgrade to 7.1 Hi, I do not know about this particular problem, but would it not be possible to use the Submitter Mode Locked setting and set the Submitter-field to the same as Login Name and Assigned To? With this setting, you can update the User-record without a write-license. You can fix up your current records by exporting to an ARX-file and then reimporting using AR Import where you set the Submitter-field to the correct value. This sounds like a bug though... If a write-license is available, you should definitely be able to update. If it is only out-of-the-box workflow, it should work anyway... I had an issue in an update where one of the field became NULL instead of Zero, which caused the process to hang. This was in conjunction with an upgrade from 6.3 to 7.1. I think I fixed the data with export/import to ARX in this case as well. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. We upgraded our server from 7.0.1 to 7.1 this past weekend. We are now having a problem with our floating license users updating their own user records. The fields they are trying to update have Assignee permissions (write access), and they are the assignee of their own user records. When first logging in, they're given a Read (floating) license. When trying to update their own user record, they get: ARERR [331] You do not have write access (for this entry) to field : [field(s) trying to update] What's strange is they can go to any another form (even when first logging in) and update a record with no problem. At this point they're given a write Floating license. Then after that, they can go to their user record and update it with no problem. So why aren't they given a write Floating license when first trying to update their user record? Any ideas are greatly appreciated. Thanks, Sharon Windows 2003 AR Server/Email Engine 7.1 patch 6 Approval Server 7.0.1 Oracle 10g ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Installing ARS 6.3 with Oracle 10g
It sounds that you are not connecting to the database at all. If you are running other remedy instanses you have to use different oracle database/user (just a reminder). Check the logs of the listener to see if remedy is initiating contact and failing for some reason. Check the permissions of oracle folders and executables (especially if you do non-root install). Make sure that you have valid ORACLE_HOME in the env of the user running ARServer. If everything is defined properly you should be able, as the remedy installation user, to do tnsping from any directory. Well, I listed everything backward, so check it from bottom to top. I run ars 6.3/ 10g/ 9.x listener in the past, it works just fine. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Miguel Suarez Gomez Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 04, 2009 10:19 AM Subject: Re: Installing ARS 6.3 with Oracle 10g ** Hi Nicky: I have other instances of remedy on the same machine, but running on another database instances. The Oracle client is up and i can connect to the database with sqlplus. Thank you very much Miguel 2009/5/4 Nicky Madjarov ** Hi, Do you have other instanses of remedy running on this oracle server? Did you ping/tnsping from remedy server to the database server. Is your oracle client up and running? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Miguel Suarez Gomez Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 04, 2009 5:13 AM Subject: Re: Installing ARS 6.3 with Oracle 10g ** Hi Manish: Yes, i'm using Oracle 9i client to connect to the Oracle 10g database Thanks in advance Miguel 2009/5/4 Manish SINGLA ** Hello Miguel, Please check if you are you using Oracle9i client between ARS6.3 and Oracle 10g, if not can be the catch point. As ARS6.3 has no direct compatibility to 10g. Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Miguel Suarez Gomez Sent: Monday, May 04, 2009 12:39 PM To: arslist@ARSLIST.ORG Subject: Re: Installing ARS 6.3 with Oracle 10g _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Installing ARS 6.3 with Oracle 10g
Hi, Do you have other instanses of remedy running on this oracle server? Did you ping/tnsping from remedy server to the database server. Is your oracle client up and running? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Miguel Suarez Gomez Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 04, 2009 5:13 AM Subject: Re: Installing ARS 6.3 with Oracle 10g ** Hi Manish: Yes, i'm using Oracle 9i client to connect to the Oracle 10g database Thanks in advance Miguel 2009/5/4 Manish SINGLA ** Hello Miguel, Please check if you are you using Oracle9i client between ARS6.3 and Oracle 10g, if not can be the catch point. As ARS6.3 has no direct compatibility to 10g. Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Miguel Suarez Gomez Sent: Monday, May 04, 2009 12:39 PM To: arslist@ARSLIST.ORG Subject: Re: Installing ARS 6.3 with Oracle 10g _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Oracle LOB getting very big
The syntax for in row and out of row LOBs is different. It takes place in the create table statement. If it is not an installation option, there is no way to tell the installer what to do, so the installer will do what it is programmed to - create all lobs out of raw when you install new apps (create new tables). The only fix would be a conversion script after the tables are created. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "William Rentfrow" Newsgroups: public.remedy.arsystem.general To: Sent: Monday, April 27, 2009 5:01 PM Subject: Re: Oracle LOB getting very big A clever person might decide the obvious solution to this is to install the AR Server, then switch the server setting to "in-row", run the conversion, and then install the rest of the ITSM apps. That clever person would be wrong. We tried this and the ITSM installer (specifically IM and SLM if I remember correctly) conveniently reset the option to out of row storage. This definitely should be an installer option for the AR Server. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com www.williamrentfrow.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Monday, April 27, 2009 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle LOB getting very big ** Nope. Take a look at the recommendation on page 5 of this Oracle white paper: http://www.oracle.com/technology/products/database/application_developme nt/pdf/lob_performance_guidelines.pdf Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Apr 27, 2009 at 10:48 AM, Guillaume Rheault wrote: ** Unfortunately with the BMC ITSM apps, we don't have a choice of not using LOBs, right? Or do we? -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Axton Sent: Mon 04/27/09 11:42 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle LOB getting very big Unless explicitly defined when creating a lob, storing the lob out of row is the default behavior. I'm guessing the authors wanted to adhere to the defaults. I do know that when performing the ARS installation, the LOB storage parameter for the meta-data tables (e.g, arschema) is set to store the lob in-row. Imho, it's better to just not use lobs. Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Apr 27, 2009 at 9:23 AM, Guillaume Rheault wrote: ** That is the $6 question. Seems to me the ARS installer should ask what the value of that setting should be set to -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Misi Mladoniczky Sent: Mon 04/27/09 6:40 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle LOB getting very big Hi, Thank you all for the responses. One thing confuses me though... In all these comparisons, the In-Row-LOB requires less space and is faster. Why has BMC set the default to Out-Row-LOB? Especially since older AR System Versions seems to use the In-Row-LOB setting??? Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Just for everyone's records, there's also a white paper on the subject: > > 17-Mar-2008 Using Oracle CLOBs with BMC Remedy Action Request System > http://documents.bmc.com/supportu/documents/96/63/89663/89663.pdf > > -David J. Easter > Sr. Product Manager, Solution Strategy and Development > BMC Software, Inc. > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as > a spokesperson, liaison or public relations representative for BMC > Software, Inc. > > > From: Action Request System discussion list(ARSList) [ arsl...@arslist.org] > On Behalf
Re: Oracle LOB getting very big
RE: Oracle LOB getting very bigOut of line is probably the better way to implement LOB's, you will probably have better transaction processing performance, not to mention the 2 GB limit of the in row LOBs (at least according to Oracle). Why it is slowing down the ARS is entirely different story. I agree with you that there are quite a few settings for each LOB implementation and they should be part of install/config utils. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Guillaume Rheault Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, April 27, 2009 10:23 AM Subject: Re: Oracle LOB getting very big ** That is the $6 question. Seems to me the ARS installer should ask what the value of that setting should be set to -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Misi Mladoniczky Sent: Mon 04/27/09 6:40 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle LOB getting very big Hi, Thank you all for the responses. One thing confuses me though... In all these comparisons, the In-Row-LOB requires less space and is faster. Why has BMC set the default to Out-Row-LOB? Especially since older AR System Versions seems to use the In-Row-LOB setting??? Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Just for everyone's records, there's also a white paper on the subject: > > 17-Mar-2008 Using Oracle CLOBs with BMC Remedy Action Request System > http://documents.bmc.com/supportu/documents/96/63/89663/89663.pdf > > -David J. Easter > Sr. Product Manager, Solution Strategy and Development > BMC Software, Inc. > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as > a spokesperson, liaison or public relations representative for BMC > Software, Inc. > > > From: Action Request System discussion list(ARSList) [arsl...@arslist.org] > On Behalf Of Shellman, David [dave.shell...@tycoelectronics.com] > Sent: Friday, April 24, 2009 6:39 AM > To: arslist@ARSLIST.ORG > Subject: Re: Oracle LOB getting very big > > Misi, > > I see Axton replied. He had some good info on this. > > Here is a sql command that BMC/Remedy support gave me to show lob space > allocation > > select substr(s.segment_name,1,30) Lobsegment, l.table_name, > substr(l.column_name,1,12) Column_name, sum(s.bytes/1024/1024) Mbytes > from user_segments s, user_lobs l > where l.segment_name = s.segment_name > having sum(s.bytes/1024/1024) > 100 > group by s.segment_name, l.table_name, l.column_name > order by sum(s.bytes/1024/1024); > > Dave > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky > Sent: Friday, April 24, 2009 9:02 AM > To: arslist@ARSLIST.ORG > Subject: Re: Oracle LOB getting very big > > Hi David, > > Can anyone explain how it can get som MUCH bigger. > > I estimate that the new system took up 3-4 times as much data in the > database, 45+Gb instead of 15Gb. > > The size of the CLOB for the empty 32000-char-field was 12000 bytes per > record, 500Mb for 44000 records... Note that the data was empty on all > rows. > > Does the system allocate empty space for each record in advance??? > > Best Regards - Misi, RRR AB, http://rrr.se > >> By default, 7.x is configured to always store LOB's out of row. Once >> the >> value is set all forms created after will store in row and out of row >> depending on the data size for that field within the record. >> >> Not all the data is stored in row. There is a limit where the switch is >> made to store out of row for that record. The issue was that data was >> always stored out of row even if there was space to store the data in >> row. >> >> We were on 7.0.1 for a year or so before we found out about this >> behavior. >> Under 7.0.1 the size of the instance was growing faster than under 6.3. >> We fi
Re: ITSM 7 - Orphaned Tasks
Hi, The only place you can check if there are tasks added and the entry is not saved is in Active link - Window close/Un-display. You may consider adding normal save flag and play around with the change flag to avoid quering the tasks every time you close/undisplay an entry. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Chowdhury, Tauf Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, April 21, 2009 5:15 PM Subject: ITSM 7 - Orphaned Tasks ** Hi all, I am running ITSM 7 patch 8. The parallel post about Task Management automation triggered me posting this issue and if anyone has some ideas, that would be awesome. Basically, the issue is this: User is in the process of creating Incident/Change request. They add tasks either adhoc/template/tsg. They don't save the Incident/Change request. Now the Tasks are orphaned! No one can edit them, close them, cancel them until I go in and forcefully delete them. Has anyone found a workaround to this? Is it possible to have a filter that runs when the change/incident isn't submitted that goes and deletes the task? Thanks in advance. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 -- This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Oracle buys Sun
OT: Oracle buys SunI think it is incredible, very good, positive, news, I am hudge fan of Oracle products and what Larry achieved. Wishing them well!!! Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Guillaume Rheault Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, April 20, 2009 1:26 PM Subject: OT: Oracle buys Sun ** Not directly related to Remedy ARS, but still interesting news: http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9131829 I believe Sun being acquired by Oracle is definitely better than if it was acquired by IBM. On the flip side, this probably means mySQL probably needs to find a new home I don't care much about mySQL, although I think it's still a good idea to have a viable open source database available for free -Guillaume _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Form population conundrum
Some outer join of the form with itself enbeded into a select statement will give you all the combinations. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 16, 2009 11:57 AM Subject: Form population conundrum ** I am trying to come up with the best way of doing the following: I have a form with two fields: one character field and the other drop-down. Each has a maximum of about 8 unique records. What I want to do is create a cross reference file in that form of all possible combinations of those data values, and I want to populate it automatically from scratch. The trigger isn't all that important - I have some flexibility there. I cannot seed the data in the character field - it is read from the DB via a SQL call to a metatable, and each installation may have different data. I have thought about building a series of guides to read the data and create the data, or doing it directly in SQL. I have the SQL call to read the data for the character field already working in a menu that's attached to that field. The problem is that I can't figure out how to use the SQL to create new records via workflow, unless I also use a direct SQL call to write the data to the form. That's sounding like it might be a farily complex stored procedure that I have no experience in constructing. Anyone done something like this before? I thought it was going to be much easier than its looking like now, and I think I'm getting into analysis paralysis mode. Rick _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Friday Humor (U)
you miss the DISCLAIMER, that all this is performed by highly trained, skilled professionals and you sould not try to do any of it on your own because of the potencial serious injuries or death, esspecially if you try the skink thing ... Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Hennigan, Sandra H CTR OSD-CIO" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, April 10, 2009 10:21 AM Subject: OT: Friday Humor (U) UNCLASSIFIED AMAZINGLY SIMPLE HOME REMEDIES Avoid cutting yourself when slicing vegetables by getting someone else to hold them while you chop. Avoid arguments with the Mrs. about lifting the toilet seat by using the sink. For high blood pressure sufferers: simply cut yourself and bleed for a few minutes, thus reducing the pressure in your veins. Remember to use a timer. A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. If you have a bad cough, take a large dose of laxatives; then you'll be afraid to cough. You only need two tools in life - WD-40 and Duct Tape. If it doesn't move and should, use the WD-40. If it shouldn't move and does, use the duct tape. Remember: Everyone seems normal until you get to know them. If you can't fix it with a hammer, you've got an electrical problem. Daily Thought: SOME PEOPLE ARE LIKE SLINKIES; NOT REALLY GOOD FOR ANYTHING BUT THEY BRING A SMILE TO YOUR FACE WHEN PUSHED DOWN THE STAIRS Sandra Hennigan Remedy Developer ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Product Categorizations and the Elephant Rhyme
Christopher, I agree that service should be somewhere above the CTI's. Given the fact that service is not present (directly) in most of the itsm apps/forms I am simply looking for a way to utilize what is given to achieve some more service-centric model. For me, becoming service centric is an important step for better utilizing the itil foundations. Your environment is quite unique because all customers are provided the same packege of services (probably with few exceptions) and you have relatively low volume of incidents. I am far from saying that you guys have to make the change for the sake of being service centric. Apparently your support organization works well for you. Look ,however, in the high volume shops - 1 million plus incident per year and vast vatiety of services provided to different users and all the restrictions related to supporting different service and different skill sets needed to do so, especially when it comes to sensitive data - goverment, financial, telecom, pharma, just to name few. In my opinion, one of the the better ways to handle such environments to adopt the service centric model, identify the service managers, and let them define how do they want to handle everything withing their arreas of responsibility. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: strauss Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 09, 2009 6:37 PM Subject: Re: Product Categorizations and the Elephant Rhyme ** If that is all that there is to the Service Catalog, then BMC has been blowing a lot of smoke about it in my opinion. Our CFG:ServiceCatalogAssoc contains the 53 Global CTI that our helpdesk defined before we went live and Don imported with Data Management, plus a few I added to support campus-wide outage reporting. We have another 154 non-Third Party Product CTI that we also imported or defined in four major categories: Computing Services, Desktop Software, Hardware, and Infrastructure. Don built all of this in consultation with the central helpdesk, who incorporated many of these CTI into their Incident templates. We gave every one of the colleges and departments, who each have their own Company, the ability to define their own CTIs within their company, but so far NO ONE has done so in almost a year of production. To me, a Service Catalog entry should exist at a hierarchical level above CTI, as was hinted at but not realized in ITSM 5.x, but I have never found that implemented in the ITSM apps in a practical way. The closest is the Business Service configuration item in Asset Management/CMDB, but like everything in the CMDB it is a Product categorization, not an Operational categorization. There does not appear to be any place that you can tie OpCats and ProdCats together under a defined IT Service at what I have always perceived to be the "Service Catalog" level. Whenever I have heard people talk about a "Service Catalog," I was looking for something where you can define an IT Service like "Payroll Services" and it will have some OpCats for Incidents and Changes to use, and some ProdCats that define the system CIs and component CIs that make up the IT Service. Without the top-level connection, it's the same huge pile of incomprehensible categorizations that we cussed and discussed for the last decade, and finally discarded. I think we actually got the closest to this in our old 5.x app when we added a second tier to the Summaries in the Requester Console, and the top tier included things like "Student Computing Services," "Distributed Computing Services," and "Administrative Computing Services" as well as more specific things like "Residence Networks." Even the helpdesk staff MUCH preferred to use the Summary menus (which carried over into Help Desk cases just like they did in the Requester -New Request form) to quickly categorize a ticket than to wade through the CTI menus, even after we gave them a pull-right hierarchical menu of the CTIs to navigate. Today they have learned to use the 40 some odd incident templates defined by their manager in almost the same way. Looking back, I don't see very many support staff on our ITSM 7 system making use of even the existing categorizations. I reviewed ~16,200 incidents from the last 11 months and the vast majority of those with populated categorizations (6,676) were either generated by Kinetic Request, or by the central helpdesk which uses incident templates wherever possible. The rest had no CTI whatsoever. Once ITSM 7 made it optional data, and without any emphasis from IT managers in most of our support groups to enter it for reporting, CTI usage plummeted. Something to think about if
Re: Product Categorizations and the Elephant Rhyme
While we don't have the service affected identified in the incident, problem, change, etc. (end even if we do, I'd love to have categorization within the affected service) how can one route everything properly if not using the categorization. I have seen months spent by managements to determine proper categorization, and either way they end with too few or too many. My present approach is to embed the actual service (as per service catalog) into the 2'd level of categorization, keep the first to reduce the choices, and use 3'd and further to define specifics. This way you can throw everything from level 2 below in the hands of the service managers to define what they need. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 09, 2009 11:29 AM Subject: Re: Product Categorizations and the Elephant Rhyme ** You're right as usual, Chris. But she said that they were already using Categorizations for Assignment. While testing paradigms is a practice we should all undertake, changing the entire support model is an undertaking that requires buy-in from all users and owners of the Support model. It doesn't sound like Jennifer's organization has those things in place. Categorizations are not REQUIRED for ITSM 7 Assignments to function. However, they may be required for the structure of your Support Organization to function, and they may be required for current reporting purposes. Just because you set the Cats from templates doesn't mean that they aren't being used, just that the values are automatically chosen. The broken "2000 Op Cats" situation (which is not at all abnormal, BTW) is precisely why I cut through the Gordian knot with my idea for generic Op Cats. The bottom line is that the tool and the ITIL protocols are there to support the organization, not the other way around. Can the Support model change? Sure. Whether it should is for each company to decide. Rick On Thu, Apr 9, 2009 at 8:10 AM, strauss wrote: ** I’m going to have to challenge your assumptions here, just as mine were when we first began testing the 7.x applications several years ago. I’m not sure that in 7.x it is a best practice to key on CTI anymore; the app basically discards it as a requirement, and the new 7.x assignment engine doesn’t even support it very well, not when compared to the very specific ways that CTI were processed in 3.x through 6.x applications. Based on our testing of the 7.x apps (where assignment rules using location and/or categorization no longer have reliable outcomes unless every rule is mutually exclusive) we decided to drop category as a determining factor, and key on Organization to tie our customers to a particular distributed support organization based upon their payroll accounting numbers. All tickets opened for a group of customers paid under one account (and assigned to a specific Organization in their location values) route to a particular distributed support organization by default, as set in an explicit assignment rule (there are ~25 desktop support organizations). When we have one Department in an Organization that needs a different routing than the others, the only way you can make that work in 7.x is to build separate, mutually exclusive assignment rules for EVERY Department in the Organization, not just the one that differs, or you will get inconsistent assignments. If you still want to incorporate CTI in the assignment processing, you will be forced to build all of the rules to be at the same level (C or T or I, not some combination of the same as pre-7.x) and make them mutually exclusive. Whatever you were using for 5.x or 6.x isn’t going to work. Our users are, quite frankly, much happier processing large quantities of tickets without any categorization at all, focusing on Assignment and occasionally Ownership. They only categorize them when they need to do so for reporting purposes, and we have facilitated that as much as possible by using a lot of Incident Templates to apply categorizations. They HATED the over 2,000 categorizations that we used in the 3x, 4x, and 5x systems, and don’t miss them at all in 7.x. The other way we have made this easy is to make a lot of the tickets entered through Kinetic Request use the same, pre-defined Incident templates, which can control not only the CTI but the assignment as well. Another factor in your use of categorization is going to be how your organization(s) does reporting. Here almost all reporting is by assigned and/or owner group, and was that way even when we had a VERY detailed categorization scheme. Our message to managers when we implemented 7.x was, if you want ca
OT: Looking for 7.5 project
Folks, I am currently available and looking for a new project. I'd love to join an effort for upgrading/migrating to ITSM 7.5. If interested, please, contact me ofline. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Problem with EXTERNAL() in search menu
Hi,
Can you email screenshot of your menu from admin tool.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message -
From: "Joe Castleman"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Wednesday, April 08, 2009 10:22 AM
Subject: Re: Problem with EXTERNAL() in search menu
Well, it seems to be doing that by itself (and for some reason it no
longer changes 'Status' to $7$). If I don't use the dollar signs, it
won't refer to the current form. I thought the single-quotes would
force it to check against the menu's source form, which I don't want
to do.
Again, the same qualification does what I want it to do (and keeping
the structure I intended) if I use it in a Table Field qualification.
Thanks for your response,
Bill B.
On Tue, Apr 7, 2009 at 9:17 PM, Leonard Neely - FOJ
wrote:
Bill,
I think your qualification needs to be structured as follows:
('Status' = "Active") AND (EXTERNAL('536870930')) AND
(EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
Note: No Dollar Signs
HTH
Leonard Neely
Column Technologies
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Multiple AR Servers in Mid-Tier Config
Folks, Read the BMC white paper on Load Balancing, I think all you are looking for is there. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, April 07, 2009 12:48 PM Subject: Re: Multiple AR Servers in Mid-Tier Config ** Just out of curiosity, why do you need all three servers added to the mid-tier configuration? Normally, if you have the server group behind a load balancer, you only need to have the mid-tier point to the load balancer and let it redirect traffic to the 3 backend servers. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Satya Gandhi Sent: Tuesday, April 07, 2009 5:04 AM To: arslist@ARSLIST.ORG Subject: Multiple AR Servers in Mid-Tier Config ** Hi Listers, I have multiple AR servers in a group and I need all these AR Servers along with the server group name be updated in the MidTier AR Server settings. When I add all three servers + the server group and I login to access the applications, on the Home Page, I see all applications links appearing 4 times, once for each server. How do i avoid this? I was told this has been discussed in the ARS List earlier and I cant access the list from my work network. We are running ARS 7.1 p6. Can someone point me in the right direction? Regards Satya __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Finding LArgest free block in a table grid
Your best bet is to maintain this information in separate content table (like your file system does). When you occupy a block, you go and update your content table. This way you can allways select MAX() and have the largest block. You can certainly write some complicated sql statement to do so as well, however if there are lots of shelves your query will take forever. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Bhupesh Gupta Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, April 06, 2009 12:48 PM Subject: Finding LArgest free block in a table grid ** Dear friends, I am representing racks of book shelf as a table grid in Remedy. Each grid/record is a single unit.some units are ocuupied and some are free. I need to find out the largest available/free block in that Grid. Any help will be highly appreciated! -- Regards, Bhupesh Gupta __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: 75 Install and Database Administrator username/password (SOLVED)
Lyle, Thanks for sharing, it is diffinitelly very insightfull and certainly keeper. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, April 03, 2009 6:13 PM Subject: Re: 75 Install and Database Administrator username/password (SOLVED) ** Thanks, all for your help. I finally figured out what the deal was. So, the issue was due to the fact that we are using an Oracle RAC which has multiple database servers hitting the same database for redundancy. The issue is that, while for most clients, the service name is the service name, for jdbc, it wants to specify the SID which appears to correspond to the Session ID in the RAC. In our case, the normal service name is A036, and normal clients can use that just fine. However, when jdbc goes and hits the server, it specifies a SID of A036, which the instance in the RAC that it's hitting doesn't expect. It turns out that, where we have two servers in the RAC, the Session IDs for the servers are A0361 and A0362. So, in the end, I had to specify A0361 instead of A036. In addition, BMC's install guide mentions that the service name and computer name need to be the same in tnsnames.ora. In this case, that is not correct, and cannot be set up that way. The issue is that, while jdbc needs A0361 to be able to connect, the processes that actually do the database updates don't use jdbc and can connect normally using A036. This has the effect that the installer needs one value to check the status of the database, and then the subprocess that updates the database needs another value. To handle that situation, I had to change the tnsnames.ora file so that it was like this: A0361 = (.. (SERVICE_NAME=A036) That way, the Java installer could test the database using A0361, and then when the subprocess came along and tried to connect to A0361, it would get properly directed to A036, which it can use. Thanks again. Lyle NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: how to change temporary the submitter on the fly
Hi, It depends what is the content of your CC field, user names, full names, etc. Based on it the approach could be quite different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "jham36" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, April 03, 2009 10:51 AM Subject: Re: how to change temporary the submitter on the fly Take a look at Dynamic Groups. I have not used them and I am not sure it will solve your problem, but it's worth looking into. Refer to the Form and Application Objects document. I just noticed your server is 6.0. I don't know if dynamic groups are available for 6.0. James On Apr 3, 4:06 am, Remedy Maniac wrote: dear listers, I have to fulfill the following requirements: only the submitter of a ticket and people in the CC list should have access to the ticket. The CC list being basically a character field My question is then: how do I need to proceed? Right now I am completely stuck. Any great idea would be welcomed Thanks in advance Serouche ENV: ARS 6.00.01 Mid-tiers: 6.3 Sybase 12.5.3 Solaris: 5.8 ARSperl 1.9 ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Direct SQL action to a Linked MS SQL Server db
Direct SQL action to a Linked MS SQL Server dbJohn, I'm sorry, I did not realized that you can run your insert statement from the sql directly. Select into copies records from one table to another, if you specify fields, it will just copy these fields. Now, on your problem. When you run your insert statement from the sql prompt SQL> Insert INTO SW_License.License_Management_Test.dbo.ARS_View1 (MR_Date, EDD) VALUES ( '1/7/2009 12:00:00 AM', '2/19/2009 12:00:00 AM') you will either reproduce the error message or it will be completed with success. This will narrow your effort to: if error - you will see the complete details and will be dealing with some incompatibility between 2 sql servers/versions if success - then the problem is somewhere between Remedy database layer and the linked table. It is not a lot, but each follow completely defferent resolution route. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Reiser, John J Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, April 03, 2009 10:28 AM Subject: Re: Direct SQL action to a Linked MS SQL Server db ** Nicky, Thanks. I tried this select ProductType='HARDWARE' into SW_License from PL_MR_LineItems where MRNumber = 'TM099' and got "1 row affected". I am not a dba so I am winging this. I don't fully understand what this statement means. ProductType='HARDWARE' is the column and data in my ARS Form. SW_License is the name of the linked db as it appears on the SQL Server supporting the ARSystem db. PL_MR_Lineitems is the ARS form MRNumber = 'TM099' is also from the ARS Form. Did I get things in the right order? Because if I run it again I get an error. There is already an object named 'SW_License' in the database. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, April 02, 2009 7:09 PM To: arslist@ARSLIST.ORG Subject: Re: Direct SQL action to a Linked MS SQL Server db ** Hi, this may not resolve your problem but it will help you narrow it change you statement to the following and run it from sql client on the remedy server select values_from_your_form into your_dblink_table from your_form where put_condition_to_return_one_record I think that at least you will be able to see the entire error message, if not more details. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Reiser, John J Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 02, 2009 5:28 PM Subject: Direct SQL action to a Linked MS SQL Server db ** Hello Listers, ARS 7.1 Patch 4 MS SQL Version 9.0.3007 I have a remote linked MS SQL Server (probably SQL 2000) that I have been pushing data to for years. Now that the Remedy ARS db is on a new box and a newer version of MS SQL I can not longer push the data. The SQL statement is Insert INTO SW_License.License_Management_Test.dbo.ARS_View1 (MR_Date, EDD) VALUES ( '1/7/2009 12:00:00 AM', '2/19/2009 12:00:00 AM') I get the following message in the arsql.log file. * WARNING * The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "SW_License" was unable to begin a distributed transaction. (SQL Server 7391)OLE DB provider "SQLNCLI" for linked server "SW_License" returned message "No transaction It gets truncated in the log so I don't know what the returned message is indicating. the ARS_View1 is a view that was created on the remote DB that converts date values to integers so we can display dates in ARSystem using a view form. I am wondering if that is causing a problem when pushing the values back to the remote view. If I am missing some information needed to understand this question please feel free to ping me. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me __Platinum Spo
Re: Direct SQL action to a Linked MS SQL Server db
Direct SQL action to a Linked MS SQL Server dbHi, this may not resolve your problem but it will help you narrow it change you statement to the following and run it from sql client on the remedy server select values_from_your_form into your_dblink_table from your_form where put_condition_to_return_one_record I think that at least you will be able to see the entire error message, if not more details. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Reiser, John J Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 02, 2009 5:28 PM Subject: Direct SQL action to a Linked MS SQL Server db ** Hello Listers, ARS 7.1 Patch 4 MS SQL Version 9.0.3007 I have a remote linked MS SQL Server (probably SQL 2000) that I have been pushing data to for years. Now that the Remedy ARS db is on a new box and a newer version of MS SQL I can not longer push the data. The SQL statement is Insert INTO SW_License.License_Management_Test.dbo.ARS_View1 (MR_Date, EDD) VALUES ( '1/7/2009 12:00:00 AM', '2/19/2009 12:00:00 AM') I get the following message in the arsql.log file. * WARNING * The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "SW_License" was unable to begin a distributed transaction. (SQL Server 7391)OLE DB provider "SQLNCLI" for linked server "SW_License" returned message "No transaction It gets truncated in the log so I don't know what the returned message is indicating. the ARS_View1 is a view that was created on the remote DB that converts date values to integers so we can display dates in ARSystem using a view form. I am wondering if that is causing a problem when pushing the values back to the remote view. If I am missing some information needed to understand this question please feel free to ping me. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Memory issue on sybase ARS 6.0.1
Actually, if you look in the explain paths for each query, you may find that it is vise versa. Status is "skewed" index (99% or so of the tickets are closed) and most optimizers in cost mode will not use it. There are plenty of articles on the topic "why query is not using index ..." and having a "skewed" index is one of the reasons . On the other hand, Closed Time has incredible variety of distinct values, and no, something = null does not necessary perform full scan. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Grooms, Frederick W" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 02, 2009 11:16 AM Subject: Re: Memory issue on sybase ARS 6.0.1 Actually using NULL in a query should always cause a table scan. Using 'Status' <= "Pending" (or whatever the status just before Resolved) should use the index. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, April 02, 2009 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Janet, 'Status'<"Resolved" in most of the database performs full table scan regardless if you have indexed on status or not. Given the amount of data in your table that may well be the reason for the memory problems. The fastest way to resolve this is to create index on Closed Time and change the query to 'Closed Time"=$NULL$ - it will show you all open items ... fast. If you decide to do so you have to add filter to null Closed Time when item is re-opened. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Darrell Reading" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 02, 2009 10:42 AM Subject: Re: Memory issue on sybase ARS 6.0.1 How much memory does your system have, and how large does the arsystem executable grow to? On the table that you are hitting, how many rows are in that table, and how many open tickets are in this table? Lastly, what query is your escalation using to find the open tickets? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Thursday, April 02, 2009 09:23 To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Ok, let me ask something else related to my issue. Does anyone have a recommendation of the best way to update all open tickets every 5 minutes other than an escalation? The escalation seems to fill the memory up and kill the server and my interval does not work correctly. Thanks Janet Mahan Network Systems Administrator II EMBARQ Voice: 941-766-6199 | Wireless: 407-310-4070 | Fax: 941-766-6199 Email: janet.ma...@embarq.com Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 01, 2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Looking below it looks like you are on a Sun V240. What OS Version "uname -a" and what is your "ulimit -a" values. Also check your disk space "df -k" Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Wednesday, April 01, 2009 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Any ideas? Janet Mahan -Original Message- From: Mahan, Janet L[EQ] Sent: Tuesday, March 31, 2009 2:18 PM To: Mahan, Janet L[EQ]; arsl...@listserv.rbugs.com Subject: RE: Memory issue on sybase ARS 6.0.1 Also get these errors: ARERR [160] Decompression has failed ARERR [300] Malloc failed on server Janet Mahan -Original Message- From: Janet Mahan [mailto:janet.ma...@embarq.com] Sent: Tuesday, March 31, 2009 1:20 PM To: arsl...@listserv.rbugs.com Cc: Mahan, Janet L[EQ] Subject: Memory issue on sybase ARS 6.0.1 Does anyone have any suggestions how to fix a memory issue where the arserverd process grows so that the processes
Re: Memory issue on sybase ARS 6.0.1
Janet, 'Status'<"Resolved" in most of the database performs full table scan regardless if you have indexed on status or not. Given the amount of data in your table that may well be the reason for the memory problems. The fastest way to resolve this is to create index on Closed Time and change the query to 'Closed Time"=$NULL$ - it will show you all open items ... fast. If you decide to do so you have to add filter to null Closed Time when item is re-opened. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Darrell Reading" Newsgroups: public.remedy.arsystem.general To: Sent: Thursday, April 02, 2009 10:42 AM Subject: Re: Memory issue on sybase ARS 6.0.1 How much memory does your system have, and how large does the arsystem executable grow to? On the table that you are hitting, how many rows are in that table, and how many open tickets are in this table? Lastly, what query is your escalation using to find the open tickets? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Thursday, April 02, 2009 09:23 To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Ok, let me ask something else related to my issue. Does anyone have a recommendation of the best way to update all open tickets every 5 minutes other than an escalation? The escalation seems to fill the memory up and kill the server and my interval does not work correctly. Thanks Janet Mahan Network Systems Administrator II EMBARQ Voice: 941-766-6199 | Wireless: 407-310-4070 | Fax: 941-766-6199 Email: janet.ma...@embarq.com Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 01, 2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Looking below it looks like you are on a Sun V240. What OS Version "uname -a" and what is your "ulimit -a" values. Also check your disk space "df -k" Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Wednesday, April 01, 2009 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Any ideas? Janet Mahan -Original Message- From: Mahan, Janet L[EQ] Sent: Tuesday, March 31, 2009 2:18 PM To: Mahan, Janet L[EQ]; arsl...@listserv.rbugs.com Subject: RE: Memory issue on sybase ARS 6.0.1 Also get these errors: ARERR [160] Decompression has failed ARERR [300] Malloc failed on server Janet Mahan -Original Message- From: Janet Mahan [mailto:janet.ma...@embarq.com] Sent: Tuesday, March 31, 2009 1:20 PM To: arsl...@listserv.rbugs.com Cc: Mahan, Janet L[EQ] Subject: Memory issue on sybase ARS 6.0.1 Does anyone have any suggestions how to fix a memory issue where the arserverd process grows so that the processes die with malloc errors. It seems to be related to escalations that I have updating tickets every 4 or 6 minutes. I have opened tickets with BMC but our version is not really supported. Some details: Mar 05 16:24:07 EST r...@waterspout#> tail -f arerror.log Thu Mar 5 16:14:39 2009 390620 : Cannot initialize contact with SQL database (ARERR 551) Thu Mar 5 16:14:39 2009 Thread 26 not handling connection Thu Mar 5 16:15:35 2009 390620 : Failure during SQL operation to the database (ARERR 552) Thu Mar 5 16:15:35 2009 ct_cmd_alloc(): user api layer: external error: Memory allocation failure. (Sybase 16843010) : Thu Mar 5 16:15:35 2009 390620 : AR System server terminated -- fatal error encountered (ARNOTE 21) Thu Mar 5 16:15:35 2009 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Thu Mar 5 16:15:35 2009 ct_cmd_alloc(): user api layer: external error: Memory allocation failure. (Sybase 16843010) : Thu Mar 5 16:15:35 2009 390620 : Cannot initialize contact with SQL database (ARERR 551) Thu Mar 5 16:15:35 2009 Thread 27 not handling connection 390603 : Failure during SQL operation to the database (AR
Re: Bug Tracking and ITSM suite
Stan. I hope you are not going to be angry on me if I slightly change the process you are suggesting (exactly like Bill Belichick would do with the palybooks of the other fellow coaches when he put hans on them). 1. user submits incident report 2. analyst troubleshoots, confirms the application deffect and a. creates problem record; b. relates the incident to the problem and then closes the incident; 3. problem management investigates root cause and possible solutions, in the mean time any new incidents reporting the same deffect are related to the problem record. 4. management approves solution (I don't believe it will be the CAB at this point) 5. project is initiated (in the Action Program Manager or other release mgmt tool) for implementing the approved solution 6. change is initiated when the solution is ready 7. solution is implemented, CMDB is updated if necessary, change and problem are closed. Open deffect = persisting problem in your environment There you go, ITIL in action Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Stan Feinstein Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, April 02, 2009 9:34 AM Subject: Re: Bug Tracking and ITSM suite ** Another idea. One of the users of our ActionProgram Manager has the following bug tracking process for bug reports from users. They said: 1. Bug reports from users come into the help desk application. 2. Because they are bug reports, they are assigned to the Change Control Board. 3. The Change Control Board looks at it and decides if it is a change or a project. If it's a project, use the Bug Fix Project Plan template to spawn the project record and all the tasks in the template. 4. The last task is "Implement the fix" and that's done in Operations, so when they come to that task, use workflow to create a change request, and use workflow to notify the person in Operations that there is a new change request. 5. The person in Operations implements the fix and closes the change request. When they do, use workflow to a) close the last task in the project, b) close the project record since all of the tasks are completed (standard in ActionProgram Manager anyway), c) close the original help desk ticket, and d) notify the user that the bug has been fixed. Very cool. When you think about the thread last week about incorporating an SDLC and release management, that's another variation of this same concept: the idea of incorporating program management functionality into your workflow processes. Our users tell us that this is one of the big benefits of using a Remedy-based program management system. Stan. w. 310-230-1722. www.pri-us.com - Original Message - From: Axton Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, April 01, 2009 6:36 PM Subject: Re: Bug Tracking and ITSM suite ** Well said Axton Grams On Wed, Apr 1, 2009 at 6:21 PM, Lyle Taylor wrote: ** The ITSM suite is not really meant for tracking bugs. If you want an application that resides in Remedy, I believe that BMC does sell an application intended for that purpose. If you don’t care if it’s in Remedy, then there are quite a number of tools out there (both free and commercial) for tracking defects and enhancement requests. For example, I believe you can use Bugzilla for free. In any case, I would recommend not trying to shove a square peg in a round hole by trying to fit it into ITSM somehow. Find an actual bug-tracking tool that meets your needs and use that. You could also potentially write your own little custom Remedy app for tracking bugs if you wanted. That would at least let you easily create a bug directly from an Incident ticket if you wanted. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Legters Sent: Wednesday, April 01, 2009 5:11 PM To: arslist@ARSLIST.ORG Subject: Bug Tracking and ITSM suite ** My user base has been using Incident Management as a de facto bug tracking tool for some time now. They just set an Incident to ‘Pending’ and when they get around to fixing the bug, they resolve the Incident. This results in Incidents being in ‘Pending’ for literally years sometimes. Now our senior management would like us to start paying more attention to our Mean Time to Repair statistic, and having Incidents open for a really long time makes that stat less reliable. I also just got a request from someone to add a ‘Status Reason’ of ‘Bug Fix’ to the Pending Status, and I said ‘I don’t think we want to do that’. I don’t know where in the ITSM Suite to point her, though for a better bug tracking tool.
Re: Need Feedback on Hot Fail-Over options
Need Feedback on Hot Fail-Over optionsHi, I have seen Veritas and works just fine, just a few seconds for the services to startup. What is does, in that particular implementation I worked with, the hot stand-by mounts the file system that the regular service uses and starts the services from there when you choose to failover or the primary service goes down. Also, having Oracle on RAC is good idea for your database HA, so I don't understand why are you going without RAC. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Pruitt, Christopher J Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, April 01, 2009 2:21 PM Subject: Need Feedback on Hot Fail-Over options ** Hello Listers, As Oracle 10g RAC will not support hot-failover for BMC Remedy application, we need to choose either of the following options. 1. Veritas Cluster +Oracle 10g (without RAC) 2. SUN Cluster + Oracle 10g (without RAC) Has anyone on this list dealt with either one of these two hot fail-over options before? IF so can you give me your pros/cons on each? Will they work for a Oracle 10g Database with either AR System 7.1 or 7.5? Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: ARS task attachment
ARS task attachmentPeter, 1. You sould have an association for .artask in Contorl Panel>Default Programs>Set Associations set to ARTask Application 2. Maximizing when open is actually user tool setting Tools>Options>General>the top one Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Peter Boock (PJ) Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, March 31, 2009 3:04 AM Subject: ARS task attachment ** ** Hi all! Installed 6.3 client on the following: PC #1: MS Windows XP Professional V.2002 SP2 MS Office Professional Edition 2003 NO Problems. PC #2: MS Windows XP Professional V.2002 SP2 MS Office Professional Plus 2007 Problem: 1. Click once on ARS task attachment in an email, the following message appears: "This file cannot be previewed because there is no previewer installed for it." 2. Double click on the same ARS task attachment, the Remedy User is highlighted on taskbar. It does not maximize Remedy User but it opens the correct record in the background (on pc#1 it will maximizeRemedy User and it will then be the active window). How can I fix this? Thanks Peter __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ~~ This e-mail is subject to the Telkom SA electronic communication legal notice, available at : http://www.telkom.co.za/TelkomEMailLegalNotice.PDF ~~ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
OT:Re: Panacea Workflow Studio (UNCLASSIFIED)
Pat, That should be some time before 1995, or I'm just getting old and my memory is playing tricks Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: patrick zandi Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, March 31, 2009 9:30 AM Subject: Re: Panacea Workflow Studio (UNCLASSIFIED) ** I remember when Remedy was like that.. Sniff.. Sniff.. I really miss those days... On Mon, Mar 30, 2009 at 8:23 PM, Rocky Rockwell wrote: ** Yes, at my previous employer I suggested the buy Panacea Workflow Studios. It was great, I have not had that much experience with Remedy's product. But they had a version compatible with version 7 before remedy did. It does everything you would want. Export forms and workflow and data. Support was great, if you had a problem they normally gave you a debug version within 1 day and more then likely would have a fix back to you in less then one week (more like 2 days). The next job I get I am definitely going to suggest they get it, it makes developing a lot easier and just maintaining the ITSM stuff a snap. Rocky Rocky Rockwell mgrockw...@verizon.net Ph#1: 325-884-1234 Ph#2: 325-884-1263 Mobile: 325-450-1297 __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"<>
Re: 75 Install and Database Administrator username/password
Lyle, you are right, may be I was not clear, if you make a change in the ora files you have to restart the listener to make it read the new configuration. Someone suggested changing the order of NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP) so the listener try the tnsnames first. I'd personally try the 7.1 install to find 100% positively that the problem is or is not related to the installer. The message you are getting is quite specific: it either cannot resolve the host name or the SID, or both. It looks that the listener is not retrieving this from tnsnames.ora. Is there anything in the listener log? Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 30, 2009 5:59 PM Subject: Re: 75 Install and Database Administrator username/password ** Nicky, I'm not quite sure what you mean. The listener is on the server side, correct? I have no control over that and have not changed anything on that side - that works correctly for everything but the Remedy installer. All the changes I am making are on the client side and are to tell the client how to connect to the server (listener). Am I misunderstanding something? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Monday, March 30, 2009 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password ** Lyle, you have to restart the listener in order for changes in the ora files to take effect. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 30, 2009 5:27 PM Subject: Re: 75 Install and Database Administrator username/password ** That doesn't appear to have made any difference. It still can't connect to the database. I get the same error as before. Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, March 30, 2009 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password ** Since you say you are trying to use TNSNAMES switch the order of them around in the sqlnet.ora file. NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP) This will at least get you past that point in the install. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Monday, March 30, 2009 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password Sqlnet.ora contatins NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES) Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, March 30, 2009 8:01 AM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password Check your SQLNET.ORA file for the names.diretory.path to make sure it includes TNSNAMES. I normally use the following: NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, HOSTNAME) Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 27, 2009 6:31 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password I took a look at the installation log files, and it looks like it's actually not able to connect to the database to start with, so it probably thinks it needs to create a new schema, and that's why it's asking for the db administrator username/password. This is what I'm seeing in the log file: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was A036:1601:A036 I can tnsping A036 fine. I've also created a tnsnames.ora file for it, just in case it doesn't like ldap, but based on what I see here, it kind of looks like it's not even trying to actually look up the service in ldap or tnsnames. It looks like it's just going straight to the server and port and passing it this connect string, or something like that. The connect string appears to be in this format: :: Any ideas?
Re: 75 Install and Database Administrator username/password
Lyle, you have to restart the listener in order for changes in the ora files to take effect. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 30, 2009 5:27 PM Subject: Re: 75 Install and Database Administrator username/password ** That doesn't appear to have made any difference. It still can't connect to the database. I get the same error as before. Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, March 30, 2009 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password ** Since you say you are trying to use TNSNAMES switch the order of them around in the sqlnet.ora file. NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP) This will at least get you past that point in the install. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Monday, March 30, 2009 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password Sqlnet.ora contatins NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES) Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, March 30, 2009 8:01 AM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password Check your SQLNET.ORA file for the names.diretory.path to make sure it includes TNSNAMES. I normally use the following: NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, HOSTNAME) Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 27, 2009 6:31 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password I took a look at the installation log files, and it looks like it's actually not able to connect to the database to start with, so it probably thinks it needs to create a new schema, and that's why it's asking for the db administrator username/password. This is what I'm seeing in the log file: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was A036:1601:A036 I can tnsping A036 fine. I've also created a tnsnames.ora file for it, just in case it doesn't like ldap, but based on what I see here, it kind of looks like it's not even trying to actually look up the service in ldap or tnsnames. It looks like it's just going straight to the server and port and passing it this connect string, or something like that. The connect string appears to be in this format: :: Any ideas? Thanks, Lyle - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, March 27, 2009 1:21 PM Subject: 75 Install and Database Administrator username/password Hi again all, My experience with past installers was that if you were creating a new schema (for Oracle at least) from within the installer, it would prompt your for the database administrator username and password, but if you already had a schema, it would instead ask you if you want to overwrite, upgrade or share the database. For 7.5, our DBA has created a new schema for us to install into, and in the 7.5 installer, I have entered the server, port and schema login information and then moved forward. A couple screens later, it then asks me for the database administrator username and password. Does the 7.5 installer _always_ ask for this, or does this mean that it may not be able to connect to the database using the information previously provided, causing it to think that we're creating a fresh new schema? Note that one thing we did not do was create a tnsnames entry for the database, as we are using LDAP. We did, however, create a DNS alias in /etc/hosts that cause our database name to resolve to the first host in our RAC. Is a TNSNAMES entry absolutely essential? Let me know if you need any further information. Thanks, Lyle __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ 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 re
Re: 75 Install and Database Administrator username/password
Lyle, I haven't done RAC/LDAP combo, it is an interesting combination for all kind of trouble. I'd try 7.1 install first, just to exclude installer problems, you can allways interupt it after the db user is verified and schema found. otherwise, - look at /NETWORK/log/listener (this is the listener log file) for irregularities. - if you don't find anything talk to your dba to log the entire remote session in more details. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 30, 2009 12:09 PM Subject: Re: 75 Install and Database Administrator username/password ** Hi Nicky, Responses inlined below. Thanks, Lyle ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Web Services Error
Sharon, Go to pocketsoap.com and download tcptrace.exe (you can try it for free) . TCPTrace is simple utility that stays in the middle of the communication and it will show you every single step of it, and therefore, where your calls fail. The logs you are looking at do not contain relevant information for effective troubleshooting of web services. If you have questions how to use it feel free to drop me a line. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Sharon Menachem Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 30, 2009 8:43 AM Subject: Re: Web Services Error ** Nope that's not it - the web service is available as long as I login to mid-tier. I understand from Carey that all I need to do is to be able to access the xml file and give the contents to the developers in whatever format they want. They do not necessarily need to connect using the WSDL connection string from Remedy. So that's what we are now going to try. Thank you both for all your help. Thanks, Sharon ext. 2219 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, March 27, 2009 3:50 PM To: arslist@ARSLIST.ORG Subject: Re: Web Services Error Oh. The web service is down it sounds. Flush the cache on your Mid Tier web server and restart whatever runs java on your Remedy Mid tier server (we use Apache). Once you do that then you should be able to view the webservice from the Admin tool. Does that also solve the new issue you are getting? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sharon Menachem Sent: Friday, March 27, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Web Services Error ** We have tried entering both WSDLFile - which offers no authentication screens, and URL with authentication, where we put in an active ARSystem user and password. In all cases we get the same error, including now that we have changed output not to include date fields. The thing is I can't access the WSDL from within the administrator either ! Thanks, Sharon ext. 2219 size=2 width="100%" align=center tabindex=-1> From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, March 27, 2009 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Web Services Error It sounds like the User and password being passed is not being validated correctly. In the Altiris component that connects to the the WSDL did you define the Authentication Value correctly? Basically you will need to set the Authentication to "ARSystem" and then set the Username and password that you have in Remedy. You may also need to set the locale and timezone as well but they might be optional. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html_Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ -- Please consider the environment before printing this e-mail. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html_Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: 75 Install and Database Administrator username/password
Hi, Just a few extra questions. What's your oracle installation - remote or local? Do you have other remedy instances running on same oracle? Is it real server with static IP or a pc using DHCP? I noticed few things that rise concerns: 1. dba has created the schema manually. The installer is looking for schemata owned by ARAdmin, so, if the dba has not made proper changes, the installer will not know which shema has (or will have) the AR System objects, also, in this case ARAdmin oracle user has to be created manually and given proper credentials. It may be one of the reasons the installer is asking for system/password. 2. the tnsnames.ora should be edited rather than created, there is one there already. Check the following: the tnsnames.ora should be in \oracle\product\10.2.0\server\NETWORK\ADMIN\ Here is sample entry, in that case I enter XE in the installer when it asks for SID: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = nickym-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, March 27, 2009 7:30 PM Subject: Re: 75 Install and Database Administrator username/password ** I took a look at the installation log files, and it looks like it's actually not able to connect to the database to start with, so it probably thinks it needs to create a new schema, and that's why it's asking for the db administrator username/password. This is what I'm seeing in the log file: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was A036:1601:A036 I can tnsping A036 fine. I've also created a tnsnames.ora file for it, just in case it doesn't like ldap, but based on what I see here, it kind of looks like it's not even trying to actually look up the service in ldap or tnsnames. It looks like it's just going straight to the server and port and passing it this connect string, or something like that. The connect string appears to be in this format: :: Any ideas? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Friday, March 27, 2009 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: 75 Install and Database Administrator username/password ** Hi, If you can tnsping your instance you may be in good shape. Since ARAdmin has been (historically) the only dbo for ARSystem, I'd consider using different db user name for the 7.5. When you dba created a new schema did he/she changed the ownership to ARAdmin? I'd totally let the installer create schema and user, and then, if your dba is not happy, he/she can make changes. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, March 27, 2009 1:21 PM Subject: 75 Install and Database Administrator username/password ** Hi again all, My experience with past installers was that if you were creating a new schema (for Oracle at least) from within the installer, it would prompt your for the database administrator username and password, but if you already had a schema, it would instead ask you if you want to overwrite, upgrade or share the database. For 7.5, our DBA has created a new schema for us to install into, and in the 7.5 installer, I have entered the server, port and schema login information and then moved forward. A couple screens later, it then asks me for the database administrator username and password. Does the 7.5 installer _always_ ask for this, or does this mean that it may not be able to connect to the database using the information previously provided, causing it to think that we're creating a fresh new schema? Note that one thing we did not do was create a tnsnames entry for the database, as we are using LDAP. We did, however, create a DNS alias in /etc/hosts that cause our database name to resolve to the first host in our RAC. Is a TNSNAMES entry absolutely essential? Let me know if you need any further information. Thanks, Lyle 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 cont
Re: 75 Install and Database Administrator username/password
Hi, If you can tnsping your instance you may be in good shape. Since ARAdmin has been (historically) the only dbo for ARSystem, I'd consider using different db user name for the 7.5. When you dba created a new schema did he/she changed the ownership to ARAdmin? I'd totally let the installer create schema and user, and then, if your dba is not happy, he/she can make changes. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, March 27, 2009 1:21 PM Subject: 75 Install and Database Administrator username/password ** Hi again all, My experience with past installers was that if you were creating a new schema (for Oracle at least) from within the installer, it would prompt your for the database administrator username and password, but if you already had a schema, it would instead ask you if you want to overwrite, upgrade or share the database. For 7.5, our DBA has created a new schema for us to install into, and in the 7.5 installer, I have entered the server, port and schema login information and then moved forward. A couple screens later, it then asks me for the database administrator username and password. Does the 7.5 installer _always_ ask for this, or does this mean that it may not be able to connect to the database using the information previously provided, causing it to think that we're creating a fresh new schema? Note that one thing we did not do was create a tnsnames entry for the database, as we are using LDAP. We did, however, create a DNS alias in /etc/hosts that cause our database name to resolve to the first host in our RAC. Is a TNSNAMES entry absolutely essential? Let me know if you need any further information. Thanks, Lyle NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Floating License total the same.
arsignal -l hostname[:port] [sigArgument] Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Richard Copits" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, March 27, 2009 8:58 AM Subject: Re: Floating License total the same. Where is the "arsignal" option found? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Friday, March 27, 2009 8:40 AM To: arslist@ARSLIST.ORG Subject: Re: Floating License total the same. Hi, There is arsignal option that can refresh the license information. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Peter Boock (PJ)" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, March 27, 2009 8:23 AM Subject: Floating License total the same. After adding more floating licenses without any errors, the total number of floating licenses (Server Information) did not increased with the number added. Do I need to restart the services or should this not happen? Peter Env: ARSv6.3 (base) / Unix ~~ This e-mail is subject to the Telkom SA electronic communication legal notice, available at : http://www.telkom.co.za/TelkomEMailLegalNotice.PDF ~~ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Floating License total the same.
Hi, There is arsignal option that can refresh the license information. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Peter Boock (PJ)" Newsgroups: public.remedy.arsystem.general To: Sent: Friday, March 27, 2009 8:23 AM Subject: Floating License total the same. After adding more floating licenses without any errors, the total number of floating licenses (Server Information) did not increased with the number added. Do I need to restart the services or should this not happen? Peter Env: ARSv6.3 (base) / Unix ~~ This e-mail is subject to the Telkom SA electronic communication legal notice, available at : http://www.telkom.co.za/TelkomEMailLegalNotice.PDF ~~ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: DSO Pending Push Question
Just add a flag and use modify all for the entries you want to transfer, then change the filter with dso actions to respond to that flag on modify. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Bala Patel Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, March 26, 2009 10:45 AM Subject: DSO Pending Push Question ** All, Does anyone know if you can force DSO to send a Transfer? I have tried to push a record into the Distributed Pending form and it just sits in the form? I have send over the mapping name and all of the other field information. I wanted to add a number of records to clear a data issue up. Is their some kind of trick to this or has anyone performed this before? If this does not work then is their a more dynamic way to send transfers? I remember in the old days when a Distributed-Transfer was performed in a Run Process you could add the form name. I see in the logs that it only uses the following now. Distribued-Transfer -m "MyMapping" (Are their additional command line options like Distributed-Transfer -m "MyMapping" -e -F -D ? Thanks, Bala Patel Remedy Admin ARS 7.1 P 6 Windows __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Consuming Web Service
Hi, Go to pocketsoap.com and download utility called tcptrace. You will learn to use it in minutes. Technically, you can run it on your desktop. Point the web service to to the desktop and when you launch tcptrace enter the actual web service server name (or address). This way you will be in the middle intercepting all communications going back and forth, including error messages. In my experience this is the best way to troubleshoot any webservice problems. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Kumar, Rajiv (Java) Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, March 25, 2009 2:24 PM Subject: Consuming Web Service ** Hey all, ARS 7.0.1 patch10 Mid Tier 7.0.1 patch 7 Solaris Oracle 10g We have Remedy Application which is consuming external webservice. Previously we were Using AR Server 6.3 ,Mid Tier 6.3 and we upgraded to AR Server 7.0 and Mid Tier 7.0 , upgradation happened smoothly ,but after upgrading to AR Server 7.0 and Mid Tier 7.0 ,external publisher is rejecting the request sent from the Remedy Application. What Could be the solution for this. Rajiv Kumar | Capgemini India | Bangalore Consultant | AT&T Office: +91.80.66567000 Ext. 3289 | Mobile: +91-9886211088 Email: rajiv.ku...@capgemini.com Together: the Collaborative Business Experience This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"<>
Re: How many people using change management for SDLC?
How many people using change management for SDLC?Hi, I am totally with you. ITIL V3 (and earlier) Change Request = Changing of configuration item (CI). That's it, period. That's possibly the reason of including release management in 7.5. Frankly, if you look from the business side, the release management has very different life cycle than the change, although the terminology is very similar, Rational tools is very good example. A release will require a change at some point. So, stick with the ITIL def of the process. It is easier to design your own release management instead trying to deploy change for release purposes. Change Request = Changing of CI. Any other use of change management is simply application abuse. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, March 24, 2009 6:31 PM Subject: Re: How many people using change management for SDLC? ** In my opinion, the Change Management module is not really appropriate for SDLC management. In general, ITIL (at least V2) doesn't define much that relates to the SDLC except where it touches Change Management (requests that initiate a change in a system and to approving the deployment of those changes into the environment) and Release Management (which is concerned more with documenting the system, proper testing and deployment planning). Everything else in between - i.e., actually developing the system and managing that development - is pretty much left alone, and the Change Management module in Remedy reflects that. You could potentially use it to track enhancement requests or defects and then group those into a master Change, but that seems like a bit of a stretch to me and may be difficult to manage. At my last position, we looked at whether or not we should even use the Change Management module for both sides of the Change process (change initiation and then deployment) and felt that Remedy Change Management (and ITIL) didn't address the front side of that well enough. While it does allow you to add an approval process to changes, the business review, justification and approval of new changes (those that would generally involve creating a project to address) is a significant enough process in and of itself, and Remedy didn't suit itself well to how we wanted to handle that process. In addition, the people involved on the Business side are generally different than those that would review a change ready for deployment into the production environment. At the front end, the people are primarily business people with some technical people for reference. On the tail end, you have primarily technical people with business people for reference. So, in short, we essentially just skipped the first half of the Change process as implemented in Remedy and went more or less straight to the technical review and approval for deployment. Other tools were used for evaluating the business justification for changes. Part of whether it would work for you may depend on what type of SDLC you follow. However, I would lean toward tracking your enhancement requests and defects in a tool designed for that and then use those to generate Changes, where a Change represents a group of enhancements and bug fixes to be deployed to the production environment together. Then, if you wanted, you could create a Change Request that contains all of the enhancements and bug fixes you propose to put out with a given release, get a business approval on that, implement those changes (managing any development specific items in another tool of your choice if appropriate), and then continue with the Change Request to get a technical approval for release. I'd be curious to know how other people are using it, too, though. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Covert, Jack Sent: Tuesday, March 24, 2009 4:06 PM To: arslist@ARSLIST.ORG Subject: How many people using change management for SDLC? ** Hi guys. How many of you are using ITSM 7/Change Management for SDLC? Anybody using release management? Details would be great, thanks. Jack Covert Corporate IT Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy Remedy FAQ Sessions on Thursdays @ 10:30 AM PT Details on Remedy Support Team Home Page __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ 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
Re: ITSM naming convention sucks
Hi, If you want to make changes you have to do you own due dilligence any way - logs, workflow analyzers, etc. The naming convensions has been missleading in the past because of the few "exceptions". Technically, every naming convention that is not mine is missing something (just kidding). Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: "Lyle Taylor" Newsgroups: public.remedy.arsystem.general To: Sent: Tuesday, March 24, 2009 11:50 AM Subject: Re: ITSM naming convention sucks I don't think so. They will support the applications out of the box. They won't support customizations. If you break something with your customizations, they are not obligated to help you figure out how you broke it. They might, but they might not. They are also not necessarily obligated to help you understand their workflow, unless it relates to a documented integration point. Many of the whitepapers they provide are nice, but not strictly necessary. Understand that I would love it if BMC documented their systems better. I just don't think that the statement that it is necessary that they document their naming conventions, or the implied statement that they should document other implementation details, is correct. It would be great if they did, but they are under no obligation to do so. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of David.M Clark Sent: Tuesday, March 24, 2009 9:36 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM naming convention sucks I think that paying for support says otherwise... except for that "easy" part. David M Clark Remedy Programmer/Analyst Lyle Taylor 3/24/2009 10:06 AM >>> Strictly speaking, ITSM is BMC's product, and they are under no obligation to provide us with any of the nitty-gritty details about how their application was written including any naming conventions used internally, etc. The fact that BMC allows you to customize the product doesn't mean they need to support you in that effort or to make it easy for you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Coleman, Gavin Sent: Tuesday, March 24, 2009 3:56 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM naming convention sucks ** "In my opinion, ITSP followed some best naming conventions." Well considering that as far as know the naming convention is not explained anywhere in the ITSP or ITSM documentation, I can't see how you can believe that. Remedy allows you up to 80 characters to name workflow items, and it seems that ITSP and ITSM does not use all of these characters. My Active Link workflow has a naming convention as follows 1. Prefix for custom work (CC_) 2. Form abbreviation (NIM:) - New Incident Console 3. Execute on abbreviation (MRC - Menu Row Choice, Btn - Button, WL - Window Loaded). If more than one Execute on is specified, then the abbreviation I use is the most relevant 4. Name of Button, Table, Field etc (E.g. Btn_OpenIncidentTask) 5. Execution Order (-000-) 6. Details of Actions (OpenHelpDesk) Thus, we get CC_NIM:Btn_OpenIncidentTask-000-OpenHelpDesk If an AL or Filter is part of a Guide, then the suffix _GUIDE is applied. If the AL or Filter calls a Guide, then the suffix _CallGuide is applied. I'm sure other people have naming conventions, but if you are providing a product that is to be released to the general public, then surely publishing the naming convention in your documentation is ESSENTIAL. Just my £0.02 worth! Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com W: www.computacenter.com ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which ma
Re: Can't see admin privileges in User Tool
Tools->Options Advanced tab, Display Hidden Forms (Admin Only) should be checked ... just a possibility Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Bob Rowe Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, March 23, 2009 2:02 PM Subject: Can't see admin privileges in User Tool ** Okay, this is probably something obvious. but: On ARS 7.1, ITSM 7.0.03, SQL 2005. I can no longer see everything as Demo with Administrator privileges. Demo can log into the Admin Tool and work as admin just fine. I have run arcache and arreload until--well, in every way I can think of, including using the examples straight out of the book. Arcache creates the admin user who can log into the Admin Tool and see everything, but gets logged into the user tool only with guest privileges. What in the world did I do to cause this? I noticed it late Friday afternoon. -- Bob Rowe, Remedy Action Request System Development and Administration robert.w.r...@gmail.com "The golden rule is to test everything in the light of reason and experience, no matter from where it comes." Mohandas K. Gandhi __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Workflow Order Question
Workflow Order QuestionBrian,
When you have the PR open and doing some modifications on the related line
items the push action actually updates the PR directly into the database. You
need to refresh the content of the PO's field prior to creating HD ticket, for
example, have a set firld from the same form for the same PR_ID.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message -
From: Sokol, Brian
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Friday, March 20, 2009 11:18 AM
Subject: Re: Workflow Order Question
**
Hi Drew,
I just tried and it also looks OK. Here are the results below. In my AL when
I create the HD tkt I set the description field (ID 24007) to: ($Request
ID$ + " Placed. The PO #(s) for this order are ") + $PO Number$ Why is it
that I do not see that info anywhere in the SQL log? I am by no means a SQL
expert. Far from it.
PO # Set:Fri Mar 20 2009 10:48:13.6040
/* Fri Mar 20 2009 10:48:13.6040 */UPDATE T832 SET
C536870953=NULL,C536870952=' 12345',C5='*',C6=1237560493 WHERE C1 =
'PR01335'
HD Tkt created: Fri Mar 20 2009 10:48:13.7750
0 */OK
/* Fri Mar 20 2009 10:48:13.7750 */INSERT INTO T169
(C536871019,C536870977,C536870958,C536870914,C536870913,C536870912,C26130,C26128,C24011,C24006,C24005,C24002,C24000,C20012,C20007,C20006,C20005,C20004,C20003,C8,C7,C179,C25018,C23009,C25030,C25016,C25017,C24016,C26126,C29015,C29014,C29013,C300714900,C536870916,C536870918,C300751500,C25022,C25021,C25015,C25014,C25013,C300566100,C25011,C4,C2,C24009,C25023,C25032,C250907061,C26129,C26131,C26132,C26504,C26011,C260800010,C260800110,C300265600,C300751400,C300836800,C3,C5,C6,C1)
VALUES ('PO001279D84E93O6zDSQuoBXBAqAYC','ITCC Purchasing
NY','Brian',1237560489,'Information Technology','Sokol',1,3,3,'ITCC Purchasing
NY','*','212-343-6494','*','New York','557 Broadway','3003','Order
Placed','Purchase Order','IT Services','IT Purchasing Purchase Order
Submitted',4,'AG001279D84E93razDSQEj5ZBAPQoC','1020','MAINHELPDESK',2,NULL,NULL,NULL,0,'Order
Placed','Purchase Order','IT Services','Help Desk
Case',1237560493,1237560493,1237560493,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'*',0,1,1,0,0,0,0,1,'*',1,0,0,0,0,1237560493,'*',1237560493,'HD000313197')
/* Fri Mar 20 2009 10:48:13.7750 */OK
--
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
Sent: Friday, March 20, 2009 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Order Question
**
Brian, could you use a SQL log to confirm the information in the Workflow log?
Drew
From: "Sokol, Brian"
Date: Fri, 20 Mar 2009 09:13:02 -0400
To:
Subject: Re: Workflow Order Question
Hi Kevin,
No I can not use that. I need this at the time the tkt is created so that
it is part of the email that is sent out at tkt creation.
My original question is about workflow timing and the log file. Do the
events occur in the same order as they appear in the log? The logs show the PO
numbers getting populated before the HD tkt creation but they are not being
pushed to the HD tkt at creation.
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin
Sent: Thursday, March 19, 2009 6:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Order Question
**
I am sure someone will tell me if I am wrong but I think you might be able
to use the last ID keyword.. I think
Kevin Begosh, RSP
Tech Ops
Enterprise Business Services
301-791-3540 Phone
410-422-3623 Cell
kevin.beg...@lmco.com
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian
Sent: Thursday, March 19, 2009 1:30 PM
To: arslist@ARSLIST.ORG
Subject: Workflow Order Question
**
We have a custom purchasing application in Remedy. At the end of the
purchasing process a Help Desk ticket (HD 5.6) is created. I am trying to
populate the description field with our back end purchase order number. The
Remedy purchase request may have more then 1 PO#. At the time that the HD tkt
i
