RE: Anybody still doing Custom Development?
Hi Jason, Down here in sunny South Africa, we are still actively doing custom Remedy development for a large telco. I did the first implementation of Remedy for these guys back in 1998 on ARS 4.0 which was, initially, a like-for-like functional replacement for an in-house developed VB app they used to do network fault and event management. Since then, we have grown that system through the years to include a long list of other custom apps, and have, quite frankly, lost count of how many they are. We have also inherited a heavily customized (but labelled “OOTB”) ITSM implementation that was done for a different org unit initially. Now we are, like at every other customer site where I have worked at for the last 6 years or so, spending more of our time doing integrations with, and configuring ITSM, than maintaining or enhancing existing custom modules, leave alone creating new apps on Remedy. (Now, I felt a lump in my throat, just writing this sentence, because it is sad that an era of creativity, productivity and excitement has now finally gone not only in my home country, but seemingly, everywhere else too….) I have been subscribed on and off to the list since more or less around that time of doing that initial implementation for these guys. The ARSList has always been a most valuable resource to me through the years so I’d like to thank Dan, Misi and you for keeping it up this long. Another big thanks to all my fellow listers who shared their thoughts, experiences, tips and solutions through the years – it certainly helped at least one person! :) When the final day for the ARSList eventually rolls in, I hope that we could all meet again on https://communities.bmc.com/ as that is now proving to be a valuable resource too. Having lost so many fellow Remedy people to SN, I am very pleased to hear Roger’s story, but to tie in with what he said about CIO’s wanting “industry standard” systems: That is true, and I wish that the industry would wake up the realization to what I said in a post on BMC Communities long ago about so-called industry standard “best practice” actually now becoming “average practice” having no leading egde without the added customizations we do. Maybe then Remedy skills will be in the demand it ought to be…. Good luck with the job hunting – here’s hoping that you do get another “dream job” !!! :) Happy thanksgiving to my fellow listers in the US! Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Joanne Janssen Sent: Thursday, 28 November, 2019 12:14 AM To: ARSList Subject: Re: Anybody still doing Custom Development? Jason, Doug, Claire, Misi and all of those other folks whose posts I’ve Read over the years without responding. I wanted to say Happy Thanksgiving and you are not alone in having tears in your eyes. I mostly did Remedy development in the mid to late 90’s with a brief Sojourn back into the world in 2011-2016. I miss the days when you could develop a system that operated exactly as the customer wished. I loved it. Good luck to everyone from one of the many quiet devotees Joanne On Wed, Nov 27, 2019 at 2:58 PM Roger Justice via ARSList mailto:arslist@arslist.org> > wrote: I just completed a project that converted a customer from Service Now to Helix the main office is in the UK.. My initial role was to be the SN SME since I have over four years assisting companies do implementations. I do not do SN development I do requirement review with the SN developers that were offshore. I assisted in reviewing what was built in SN and how the capability could be converted to Remedy. I also did DWPA development for over four months and determined this is the next generation of Service Catalog that we needed when I was a BMC employee until they went private. If a customer reviews Smart IT and DWPA and understands the maturity of the ITSM processes and compares it to the OOTB Service Now BMC could still be successful. Both Remedy and Service now can have custom applications built as we know the question is does the CIO want a custom application or an industry standard. My 2 cents, a Remedy devotee since 2000. -Original Message- From: Jason Miller mailto:jason.mil...@gmail.com> > To: arslist@arslist.org <mailto:arslist@arslist.org> mailto:arslist@arslist.org> > Sent: Wed, Nov 27, 2019 2:44 pm Subject: Anybody still doing Custom Development? Hello my Lister family! As the list comes to a close in the near future I figured I would send my final post (in a non List admin role). I have two intentions with this post... One to have a final discussion regarding development on the AR System platform and 2) looking to find work doing AR System development or any Remedy work for that matter. 1) It has been years since our beloved List buzzed with posts from people sharing what they are building,
RE: Announcements: Doug Mueller has left BMC, ARSlist will be shutting down on US Thanksgiving, Nov. 28th
Farewell Doug! Thanks for all your insights and guidance through the years! Best wishes for the retirement years! You will be missed! Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Randeep Atwal Sent: Thursday, 3 October, 2019 06:13 AM To: ARSList Subject: Re: Announcements: Doug Mueller has left BMC, ARSlist will be shutting down on US Thanksgiving, Nov. 28th Doug. So long and thanks for everything you have done for so many of us in the Remedy community. It is a bit mind boggling to this day that the platform architecture continues to evolve on the original technical foundation you set in motion. And you have always been such a great person to talk to anyone in the community, and meet them where they are. Every conversation with you was truly an opportunity to learn something, which is something that is getting rarer and rarer these days. Thanks for the inspiration! I hope you can continue your pursuit of happiness, in this next chapter of your life All of my best wishes.. Randeep Atwal On Wed, Oct 2, 2019 at 2:46 PM mailto:arsl...@danielbloom.ca> > wrote: Doug Mueller’s last day at BMC was Monday, September 30th. As we all know, Doug was the creator of the ARSystem as a founding member of Remedy Corporation. He has always retained the philosophy of supporting the user community, even before he accepted my invitation to join this list in 1993. After consultation with Jason and Misi, the current custodians of this ARSlist, it was decided that I should post to this external list that Doug has left, in the hopes that all current and former members of our community can express their best wishes here where it can be done outside of a Corporation based community and where Doug can of course also read them. In Doug’s honor, it was also decided that we would shut down the ARSlist permanently on US Thanksgiving, giving folks until then to post their comments, and to signify the thanks we give to Doug for all he has done. My understanding is that the archives will continue to be available, and of course can be saved for posterity. For my part, it was sad news that someone who has contributed so much, holds so many forward thinking innovative patents singularly and jointly with others, would be departing. I was supposed to post this yesterday and it took me until today to accept that he really had left. I won’t be disappointed if I am proven wrong ……. Dan Daniel Bloom Founder of the ARSlist in November 1993 Active in the Remedy ARSystem world since 1.0 -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: How to duplicate 1000 records without a time out?
Hi Thomas, I might have misread your requirement here.. :-) Where do you need the "backup" data to end up and how are you doing it currently? The fastest way to get data out of Remedy is with an SQL query directly on the DB, but even that may time out if there is too much data. At the very least, you will have to have a two-phased approach using a staging form of some kind that kicks off an external export process that does the "export" work outside of Remedy to avoid the timeout issue. Best Regards, Theo On Tue, Oct 1, 2019 at 9:46 AM Theo Fondse wrote: > Hi Thomas, > > Yes, this could be done by using a staging form. > You need to have a 3-phased approach. > >- >- Phase 1 submits ONLY the EntryID of the source record to the staging >form and returns a confirmation message to the user. >- Phase 2 is done by an escalation running on the staging form that >triggers workflow to collect the rest of the fields data to be duplicated >and then does a push field to create the new duplicate record on the source >form. >- Phase 3 is done by archiving that deletes the record from the >staging form overnight. > > > Best Regards, > Theo > > On Tue, Oct 1, 2019 at 9:10 AM Thomas Miskiewicz > wrote: > >> Hi Listers >> >> User clicks on the button to take a back up off 1000 records. Is there a >> way to achieve that using filter workflow without causing a time out for >> the User? >> >> Thank you >> >> Thomas >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist >> > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: How to duplicate 1000 records without a time out?
Hi Thomas, Yes, this could be done by using a staging form. You need to have a 3-phased approach. - - Phase 1 submits ONLY the EntryID of the source record to the staging form and returns a confirmation message to the user. - Phase 2 is done by an escalation running on the staging form that triggers workflow to collect the rest of the fields data to be duplicated and then does a push field to create the new duplicate record on the source form. - Phase 3 is done by archiving that deletes the record from the staging form overnight. Best Regards, Theo On Tue, Oct 1, 2019 at 9:10 AM Thomas Miskiewicz wrote: > Hi Listers > > User clicks on the button to take a back up off 1000 records. Is there a > way to achieve that using filter workflow without causing a time out for > the User? > > Thank you > > Thomas > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: How to run a job on individual servers?
Hi Thomas, Conny has a very good idea. If your organization’s security policies allow for it, it will work just fine. If you wanted / were forced to use a more old-school AR System-based approach, you will need to create two dummy forms populated with a record for each server in the group and then trigger something like the driver program or arimport from a run process triggered by an escalation on Dummy Form 1. The driver/arimport then does a login to the individual server in the group and modify the record for that server on Dummy Form 2. This can then trigger workflow to execute locally on the intended server in the group to do what you want on that specific server. See https://docs.bmc.com/docs/ars91/en/enabling-the-data-import-utility-609071980.html for info on running arimport (much easier than doing this with the driver program). Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of conny.mar...@t-systems.com Sent: Wednesday, 21 August, 2019 02:11 PM To: arslist@arslist.org Subject: AW: How to run a job on individual servers? I would not recommend to run arsystem as root (from a security point of view) For ssh you can use whatever user you like, which has sufficient permissions to run your “licensetracker”. You’ll have to make sure, that the user running arsystem is able to do ssh to the target servers/user without the need of any password. (Public-Key Authentication) KR Conny Von: ARSList mailto:arslist-boun...@arslist.org> > Im Auftrag von Thomas Miskiewicz Gesendet: Mittwoch, 21. August 2019 14:03 An: ARSList mailto:arslist@arslist.org> > Betreff: Re: How to run a job on individual servers? Fabulous idea. As which use shall I do the ssh? The system is running as root On Wed 21. Aug 2019 at 13:46, mailto:conny.mar...@t-systems.com> > wrote: Hi, if you're on *x, you can do something like RUN-PROCESS ssh server1 /path/to/your/licensetracker RUN-PROCESS ssh server2 /path/to/your/licensetracker RUN-PROCESS ssh server3 /path/to/your/licensetracker within an escalation. If escalations are running on server1 it will connect via ssh to itself, which does not really matter. KR Conny -Ursprüngliche Nachricht- Von: ARSList mailto:arslist-boun...@arslist.org> > Im Auftrag von Thomas Miskiewicz Gesendet: Mittwoch, 21. August 2019 13:21 An: ARSList mailto:arslist@arslist.org> > Betreff: Re: How to run a job on individual servers? We're collecting license information on each individual server reading the user.log I’m looking for a way to trigger the action on each individual server without having to use a cron job. > On 21. Aug 2019, at 13:18, Tauf Chowdhury <mailto:taufc...@gmail.com> > wrote: > > Do you mean escalations? Also is this during a maintenance period or > scheduled outage? You could always bring up one server at a time and that way > you can ensure escalations are running on that server if you’re in a server > group with the failover configured. > > Sent from my iPhone > >> On Aug 21, 2019, at 6:50 AM, Thomas Miskiewicz > <mailto:tmisk...@gmail.com> > wrote: >> >> Hi there >> >> we got three servers in the group and would like to collect information on >> every individual server. We did that in the past using a cron job but would >> prefer escalation which can be controlled by workflow. The problem is >> explanations run only on one of the three servers. Any idea how to trigger >> workflow on each individual server? >> >> >> Thomas >> -- >> ARSList mailing list >> ARSList@arslist.org <mailto:ARSList@arslist.org> >> https://mailman.rrr.se/cgi/listinfo/arslist > > -- > ARSList mailing list > ARSList@arslist.org <mailto:ARSList@arslist.org> > https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: How to consume Rest API within BMC Remedy version 9.1.04 ?
Hi Carl, BMC would definitely be great again if they can make this happen. We have the same requirement here. Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Carl Wilson Sent: Saturday, 23 March, 2019 03:10 AM To: 'ARSList' Subject: RE: How to consume Rest API within BMC Remedy version 9.1.04 ? Hi, I hope BMC pick this up, which is “really” something basic which is required to keep in parallel with SNOW and other ITSM tools (REST API as a standard interface …) i.e. a 2 way REST API integration (it is available via DWP Catalog, so porting back makes sense as this is the “future” of integrations i.e. lightweight, standard, universal, etc). I understand the challenges, but REST is now an industry standard in interfacing and now that ARS is Java based this should be very easy to implement. That said, recently having done an integration with a custom “Message Bus” having to call the bus with a WS call and the “BUS” talking back to Remedy via the REST API worked well. Unfortunately, the customer I am working with requires a “fully supported solution” which is only achievable via the above method (WS and REST). I would like to be able to implement a full REST solution (supported by BMC), so kudos to LJ to build something that allows a single integration technology to be utilised without the mixing of WS and REST. As LJ has an inside track to BMC internals, hopefully BMC implement this very soon to align a full REST solution to stay on par with other vendors ….. -- Kind Regards, Carl Wilson From: ARSList mailto:arslist-boun...@arslist.org> > On Behalf Of Walters, Mark Sent: 19 March 2019 15:24 To: ARSList mailto:arslist@arslist.org> > Subject: RE: How to consume Rest API within BMC Remedy version 9.1.04 ? There is no BMC provided feature to consume a REST webservice but there is a 3rd party option – see http://remedylegacy.com/tools/restful-api-plugin/ Mark From: ARSList mailto:arslist-boun...@arslist.org> > On Behalf Of Dinesh Gottipati Sent: 19 March 2019 15:10 To: ARSList mailto:arslist@arslist.org> > Subject: [EXTERNAL] How to consume Rest API within BMC Remedy version 9.1.04 ? Hi Experts, We have a requirement to consume REST API for B2B Integration. Can you please assist. I have already gone through the <https://communities.bmc.com/docs/DOC-48676> documentation, but couldn't see the way to consume.. Also, from communities I understand there are no OOTB ways to consume, so any option that you have or other solution which can help ? Regards, Dinesh BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately. <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> Virus-free. <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> www.avast.com -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: How To Make an AR Server an Admin Server
Hi Thomas, Is the DB a restored copy from prod or another environment? I would also make sure to change the servergroup name (Server Name Alias) on the new server if the DB was a copy of another server’s DB. Also have a look at the below to get more info on the places to fix server references: https://communities.bmc.com/message/139868#139868 https://docs.bmc.com/docs/ars81/changing-a-server-name-when-using-a-duplicated-or-migrated-environment-225971671.html You could also use MPS to fix server references: https://www.missingpiecessoftware.com/products/remedy-restore-tool Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Thomas Miskiewicz Sent: Sunday, 9 December, 2018 10:35 PM To: ARSList Subject: Re: How To Make an AR Server an Admin Server I did everything you said, I even now removed the ARSystemInstalledConfiguraiton.xml and on the last screen before the installation the installer already says it will perform a a secondary server install / upgrade. Again, my question is where is the primary / secondary info stored? Why is the ranking config being ignored? On 7. Dec 2018, at 20:01, LJ LongWing mailto:lj.longw...@gmail.com> > wrote: all of the ones that start with srvgrp in the db On Fri, Dec 7, 2018 at 11:48 AM Thomas Miskiewicz mailto:tmisk...@gmail.com> > wrote: which table? On Fri 7. Dec 2018 at 19:45, Kevin Shaffer mailto:kshaf...@partneritsm.com> > wrote: We had a similar issue where our srvgrp forms in the DB still had references to other servers. Make sure tgose tables are correct. Get Outlook for Android <https://aka.ms/ghei36> _ From: ARSList mailto:arslist-boun...@arslist.org> > on behalf of LJ LongWing mailto:lj.longw...@gmail.com> > Sent: Friday, December 7, 2018 10:07:18 AM To: arslist@arslist.org <mailto:arslist@arslist.org> Subject: Re: How To Make an AR Server an Admin Server after setting it, did you either press the 'sync' button, or restart the server to have it take effect? On Fri, Dec 7, 2018 at 9:05 AM Thomas Miskiewicz mailto:tmisk...@gmail.com> > wrote: Did that. Zero effect on anything. On Fri 7. Dec 2018 at 17:02, LJ LongWing mailto:lj.longw...@gmail.com> > wrote: Rank it as an Admin in the Server Group Operational Ranking form, and for that matter, rank it as 1 for the rest of them as well. On Fri, Dec 7, 2018 at 8:52 AM Thomas Miskiewicz mailto:tmisk...@gmail.com> > wrote: Thank Carl, yes it is. 9.1.04 Fine, then let me rephrase my question. How to tell the server that it’s an admin server so that the installer imports / updates the system forms etc, Thomas > On Dec 7, 2018, at 4:46 PM, Carl Wilson <mailto:carlbwil...@gmail.com> > wrote: > > Hi, > If it is one of the latest versions of Remedy, all Servers are Server Group > members by default now. > > -- > > Kind Regards, > > Carl Wilson > > > -Original Message- > From: ARSList <mailto:arslist-boun...@arslist.org> > On Behalf Of Thomas Miskiewicz > Sent: 07 December 2018 15:25 > To: ARSList mailto:arslist@arslist.org> > > Subject: How To Make an AR Server an Admin Server > > Hi Listers, > > installed a server that wasn’t in a server group. The server is now suddenly > a server group member and a non-admin server on top of that. > > I tried to change IS_SECONDARY to false und set the Server-Group-Memeber to > false but it doesn’t help. > > How is that information stored? Support came up with the genius idea to fall > back and start from scratch. > > > > Thomas > -- > ARSList mailing list > ARSList@arslist.org <mailto:ARSList@arslist.org> > https://mailman.rrr.se/cgi/listinfo/arslist > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > > -- > ARSList mailing list > ARSList@arslist.org <mailto:ARSList@arslist.org> > https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: BMC Remedy Decommissioning Process
At minimum, you can back up the Remedy database and scrap the entire system after verifying the last backup. You can always access the data directly from the restored DB if needs be. There should not be any issue if you retain the system as-is and make it “read-only” in whatever way you choose. Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Dave Shellman Sent: Monday, 26 November, 2018 02:35 PM To: ARSList Subject: Re: BMC Remedy Decommissioning Process Good day Sriram You should be able to access the data using read licenses. Especially since no changes will be made. Dave On Mon, Nov 26, 2018 at 5:50 AM sriram pm mailto:ramjavas...@gmail.com> > wrote: Hi Misi, We have already moved to a different ITSM Tool. The licensing completes by Dec 2018 and we have already stopped using the tool. We want only the read-only archival data as per the company data retention policy. We would remove all the paid licenses and hold only the demo license for retrieving the archived data. I remember when I worked for other companies they used to have the Remedy Server running in a read only mode with the demo license in place for pulling archived data. Just wanted to confirm/understand whether this policy with BMC is still valid or not. Regards, Sriram. On Mon, Nov 26, 2018 at 2:30 PM Misi Mladoniczky mailto:m...@rrr.se> > wrote: Hi, I thought that you might even continue to use the licenses you have on your server and just stop paying support. You will then not be able to get upgrades, support or new license keys if you need to reinstall. Another solution is to dump out the data to ARX-files and convert these to HTML-pages where you can then review data there if you need to. I have created a set of free tools to accomplish exactly this task: - RRR|Chive to dump data to ARX-files: https://rrr.se/cgi/index?pg=chive - RRR|ArxToHtml to convert the ARX-files and Form Definitions to crude HTML-pages that you store on a file share: https://rrr.se/cgi/tools/main?tool=rrrArxToHTML Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se November 26, 2018 8:33 AM, "sriram pm" mailto:%22sriram%20pm%22%20%3cramjavas...@gmail.com%3E> > wrote: Hi Experts, Query regarding BMC Remedy Decommissioning. As part of the data retention policy we need to retain the data. In my previous organizations they used to remove the all the paid licenses from remedy and server will run with the standard demo licenses. This demo login would be used to pull data from remedy based on requirements from the users. Just wanted to confirm whether this decommissioning process is still applicable. If not please let me know the current process. Thank you, Sriram. -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: [E] Re: Special characters in ARS
Hi Thomas, LJ is correct, you are attempting to enter a character with a UNICODE code into a NON-UNICODE DB. Your NLS_CHARACTERSET value indicates you have a NON-UNICODE DB. You will need to convert your DB to UNICODE to sort out your issue. Oracle 12c has a conversion utility (DMU) to convert a DB to UNICODE. We had to use DMU recently to convert a DB to UNICODE. BE WARNED: This process takes very long and you need a lot of free space available to do this (depending on the size of your DB). Please also remember to set the LANG variable correctly on your Remedy ARS server if that runs on a Solaris or Unix OS afterwards, to ensure Remedy talks in UNICODE to the DB. Alternatively, stick to NON-UNICODE and forget about adding “very special” characters to your data…. The below links might be helpful: * Oracle How to check character set in Oracle: http://support.etouch.net/cm/wiki/?id=43321 * Oracle Character Set Migration: https://docs.oracle.com/cd/B10500_01/server.920/a96529/ch10.htm * Change Oracle 12c database character set to WE8MSWIN1252 from AL32UTF8 without recreating the DB: https://stackoverflow.com/questions/34763891/change-oracle-12c-database-characterset-to-we8mswin1252-from-al32utf8-without-re * Oracle Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1): https://oracle-base.com/articles/12c/database-migration-assistant-for-unicode-dmu-12cr1 Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, 4 April, 2018 07:54 PM To: ARSList <arslist@arslist.org> Subject: Re: [E] Re: Special characters in ARS I'm not a unicode expert, but I believe what you might be dealing with is that the characterset you are using might not be able to properly store the character you are asking for. On Wed, Apr 4, 2018 at 11:18 AM, Fred Grooms via ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > wrote: Yep … For ARS 9 I would have expected NLS_CHARACTERSET to be AL32UTF8 (The Unicode value) From: ARSList [mailto:arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> ] On Behalf Of Thomas Miskiewicz Sent: Wednesday, April 4, 2018 6:57 AM To: LJ LongWing <lj.longw...@gmail.com <mailto:lj.longw...@gmail.com> > Cc: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Subject: [E] Re: Special characters in ARS On Apr 4, 2018, at 1:56 PM, LJ LongWing <lj.longw...@gmail.com <mailto:lj.longw...@gmail.com> > wrote: Character set at the db? On April 4, 2018 4:47:12 AM Thomas Miskiewicz <tmisk...@gmail.com <mailto:tmisk...@gmail.com> > wrote: Hi there, We’re on ARS 9.1.03 with Oracle 12. When I enter Avșar into the a character field I get Av¿ar after saving. Any idea how to fix this? Thomas -- ARSList mailing list ARSList@arslist.org <mailto:ARSList%40arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=Yj3CmHHm6F9uWhgJeWLmkHV-zdqz_nDsL-v_SsGICdg=UdcwcFOjXTJFfA5-XKryB0xjoRujPbFTuowgEggjRVI=> -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: First message on Mailman
Thanks a stack Misi! Best Regards, Theo Fondse From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Jason Miller Sent: Friday, 1 December, 2017 05:22 PM To: ARSList <arslist@arslist.org> Subject: Re: First message on Mailman Thank you Misi for all of your work on switching over the ARSlist! Jason On Fri, Dec 1, 2017 at 3:21 AM, Misi Mladoniczky <m...@rrr.se <mailto:m...@rrr.se> > wrote: Hi friends, Now the Mailman should be up and running, and you should have received a welcome email. The normal address http://arslist.org should give you all the information you need if you forget anything, or if you want to search the archives. Your old passwords has been discarded and you now have random passwords which was sent in the welcome email. We now have 1443 regular subscribers and 586 digest subscribers. The current digest setting is weekly. Let me know if this is too often, as I think the old digests were monthly... Enjoy! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: How to perform the Integration for third party using the Web Service?
Hi Abhishek, You have two options here: 1) Use the OOTB ITSM Web Services (which uses the OOTB staging forms) and add some overlay filters on the relevant staging forms to perform the logic you want to add. For the Work Log updates going out, you can then add an overlay filter on the work Log forms to consume the 3rd-pary web services. 2) Create your own staging forms that have the exact logic you need and publish some web services from your staging forms after integrating it with the relevant "request" forms. Both options will work, but I personally prefer option 2 because it keeps OOTB code OOTB and gives you more functional control, but it does require some extra development work initially. It also depends on: 1) How much time you have to do the development. 2) How concerned you are with keeping OOTB things OOTB for support and the next upgrade's sake. 3) How much control you need in terms of adding your own business logic/functions to the integration that may not be part of the OOTB functionality. 4) Will the extra logic you need to add break any of the OOTB workflows on the OOTB staging forms or vice versa? 5) Whether or not you have an existing custom module you can use for this type of integration and business logic. Best Regards, Theo Fondse -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand Sent: Tuesday, 13 June, 2017 11:23 AM To: arslist@ARSLIST.ORG Subject: How to perform the Integration for third party using the Web Service? Hi Experts, We are having below requirement for Web Service integration:- 1. To create new requests in remedy with the help of web service integration with third party. 2. The third party data will be also having customer/requester details so as to feed it in customer contact details for Incident creation. 3. The challenge is that we need to apply the business logic that if customer detail is not present in CTM:People form, then we need to create new people record. 4. Also we have to perform the status update towards the customer/third party along with other updates like work log update via web service only. 5. At last we have to perform the Resolved/Closed status update for every incident towards third party/customer. Please could you suggest the best feasible approach to achieve the above mentioned scenario via web service only. We are working on ITSM/ARS 8.1.02. Early response will be highly appreciated. Regards, AA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ARSlist Future
Hi Dan, This is sad news for me, but I suppose it was inevitable with the way current market trends are going. Thanks for all these years of keeping the list up! The ARSList was a life saver for me on a good number of occasions over the years and I've met some good folks here. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom Sent: 01 June 2016 22:37 To: arslist@ARSLIST.ORG Subject: ADM: ARSlist Future ** I will be moving the ARSlist Community to BMC Communities. Where our members will still be the only ones that know why this is the Action Request System list and not the Remedy list. Some of the concerns expressed have been raised by me with BMC and I make this move with the assurance of non-interference and in fact increased co-operation for the good of the community. At least one server will stay commissioned until October, but various web sites and services you see will vanish between now and then as I work with BMC and my ISP. The URLs will be changed to point to the new home at the appropriate time, and I will continue with (likely monthly) updates over the summer. Note: WWRUG still exists and like any franchise of repeatable events, can return at any time with the same or a new cast :) The Farewell to the Listserv based version of the ARSlist will be held at BMC:Engage, where the answers are. Cheers Daniel RAC 1995 [no number, they didn't have them yet] Founder of the ARSlist Chairman of WWRUG _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: AR System Email Mailbox Configuration
Hi Anonymous, This might be a browser cache issue - open the form in Mid-Tier and press Ctrl+F5 to force the browser to get a fresh copy of the form from the server instead of using it's cache on your PC to display the form. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE arslist Anonymous Sent: 11 December 2015 00:26 To: arslist@ARSLIST.ORG Subject: Re: AR System Email Mailbox Configuration Yes. I have enabled that option and it does open Default admin view now but I sill have issues. Can't update email server password. It allows only a single character to be entered. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: direct URL in ITSM 8.X
Hi Dan, Sandra, This may or may not be useful at this point, but you can use the URL encoder to find out what the correct string is to use to embed in your URL for your form: https:// midtierserver.my.domain:8443/arsys/shared/ar_url_encoder.jsp Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of arslist Sent: 22 May 2015 03:08 To: arslist@ARSLIST.ORG Subject: Re: direct URL in ITSM 8.X Hi Sandra, Thanks for the post. I was already aware of the things like %3A and the rest being the URL substitutions, but pointing that out is useful nonetheless. There is a utility to convert single clauses to the url version, it would be nice to have something that will take an entire URL and normalize it. As far as I can tell I may have what I need now, as soon as it is confirmed I will post an email with all the references for things related to a direct URL. (turned out to be much simpler than I thought for this instance, spent around 15 hours exploring and learning more than I needed to). There are several different java applets that can be called with different parameters for different purposes, sadly I wasn't able to find a reference for exactly what I needed, hence the learning about many aspects I didn't need (right now). Dan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra, CTR, DSS Sent: May 21, 2015 3:21 PM To: arslist@ARSLIST.ORG Subject: Re: direct URL in ITSM 8.X Dan, We have SSO so the URL does not include login content but this is the URL in the customer email for our custom Survey: https://midtierserver.my.domain:8443/arsys/forms/arserver/ITM%3ASurvey/User +View/?eid=$Request ID$ Where %3A replaces a : in the Form name and + replaces a space in the View name. Thank you, Sandra -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Sent: Thursday, May 21, 2015 1:48 PM To: arslist@ARSLIST.ORG Subject: direct URL in ITSM 8.X ** I was hoping someone would have an example of a direct URL to open a form (I am trying to open Survey once it all works) where the login is part of the URL, so you don't have to manually log in. As a starting point I used what was supposed to be one that works opening Incident in Search mode, with parameters for the search. The only examples I have seen do http:// and of course I am doing https:// I was able to get it to open Incident, after manually logging in, but it ignored the parameters to search a specific Incident ID I was also able to get it to log in with the direct URL, and open the Landing Page, and show that it was in Incident, but did not show the Incident form on the screen (so obviously also did not show me the incident I was looking for) The latter, getting it to log me in via the direct URL, got that far when I put those parameters at the end of everything. Does anyone have a working example of this that I can take a look at or can you fix what I have below? It seems close enough I must have missed something simple. Also, if someone could explain why it all seems designed to require the Landing Console? When I go to communities and start searching I start with current information and it quickly refers me to other articles until I am looking at some unknown version of Remedy that worked differently. Wouldn't it be nice if we ask for V 8.X it only showed things that are valid in 8.X? Thanks Dan p.s. here is what I tried, the mid-tier server could be going through a load balancer of course , the version that does the login and goes pear shaped after https://mid-tier https://%3cmid-tier server/arsys/forms/arserver/SHR:LandingConsole/Default+Administrator+ serverView /?mode=searchF304255500=HPD:Help+DeskF100076=FormOpenF303647600=Searc hTicketWithQualF304255610=%27100161%27%3D%22INCGB0011741915%22?Server= arserver/username=a correct useridpwd=a correct password _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Requirements Doc
Hi LJ, I had a little hardware trouble with my laptop dying on me, but the manufacturer has now repaired it under the warranty, hence my late reply. You’re welcome. I hope it helps. I never bothered to compare the new online documentation version of this to the old documentation, but we used Chapter 6 of the 7.6.04 Concepts guide as requirements input and tested the newbie’s on their documentation skills on creating a requirements document as well as their development skills. Testing them on something as unconventional as a wild animal park / zoo tends to also test their ability to tackle the unfamiliar and the concepts tested here are not too difficult for anyone that has passed the Admin training. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 09 March 2015 15:22 To: arslist@ARSLIST.ORG Subject: Re: Requirements Doc ** Theo, Thanks...I've never explored that section of the Wikiit's not as detailed as I would like, but it's certainly something, thank you for the heads up. On Mon, Mar 9, 2015 at 12:58 AM, Theo Fondse theo.fon...@gmail.com mailto:theo.fon...@gmail.com wrote: ** LJ, Why don't you just use the Zoo Project in the BMC doumentation? We used this at a previous company I worked for on all the junior newbie's to test their skills. Best Regards, Theo On Fri, Mar 6, 2015 at 4:18 PM, LJ LongWing lj.longw...@gmail.com mailto:lj.longw...@gmail.com wrote: ** All, I'm training up a newbie on Remedy Development, and we have reached the point where I think he's ready for a 'test'I remember going through my 7.x RAC class, and they gave us a small 'requirements doc' for a fairly simple, yet complex enough application that needed to be built...the guys that were in the class with me all built different applications of course, but they all met the application...it was a good exercise and helped hone the blade so to speak on all of our skills...I was wondering if anyone happened to have something like that laying around that I would be able to use It doesn't need to be related to any particular industry, etc...just a couple of pages of requirements for an app that requires a few forms, and some description of functionality, but of course, not how the functionality needs to be built If anyone is willing to send me some stuff, either on or offline, I would appreciate it. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Requirements Doc
LJ, Why don't you just use the Zoo Project in the BMC doumentation? We used this at a previous company I worked for on all the junior newbie's to test their skills. Best Regards, Theo On Fri, Mar 6, 2015 at 4:18 PM, LJ LongWing lj.longw...@gmail.com wrote: ** All, I'm training up a newbie on Remedy Development, and we have reached the point where I think he's ready for a 'test'I remember going through my 7.x RAC class, and they gave us a small 'requirements doc' for a fairly simple, yet complex enough application that needed to be built...the guys that were in the class with me all built different applications of course, but they all met the application...it was a good exercise and helped hone the blade so to speak on all of our skills...I was wondering if anyone happened to have something like that laying around that I would be able to use It doesn't need to be related to any particular industry, etc...just a couple of pages of requirements for an app that requires a few forms, and some description of functionality, but of course, not how the functionality needs to be built If anyone is willing to send me some stuff, either on or offline, I would appreciate it. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: The ~! for filter names
Harsh, I agree with Fred Rick, it makes more sense to rather have it as a property rather than only as some text appended to the name, but you would need to have BMC automate keeping both conventions going to make it backward compatible with existing workflow. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 03 March 2015 18:56 To: arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Harsh- You would still have the option of using that naming convention to indicate the phasing but I think it makes more sense to make it a property of the filter rather than relying on the filter name to trigger the phasing. There’s no reason we can’t set the phasing in a filter property and also append `! to the name (or whatever other naming syntax you wish, there might be something else that makes more sense). -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Harsh Sent: Monday, March 02, 2015 7:31 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Yes, it is there `! , and i don't think it would be better to remove `!, as a developer i am not at all wishing to open each filter and check if it is overriding the filter phasing. Better i can guess from its name. Regards, Harsh On Tue, Mar 3, 2015 at 4:04 AM, Grooms, Frederick W frederick.w.gro...@xo.com mailto:frederick.w.gro...@xo.com wrote: The 2 are not exactly the same. The release pending causes the Phase 2 actions to happen, then comes back to this Filter. The `! causes this filter to run in Phase 1 I put an idea out in the Developer Communities to change needing `! https://communities.bmc.com/ideas/3639 Vote it up ;) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Joe D'Souza Sent: Monday, March 02, 2015 4:20 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names Still there as far as I know as well. They have an additional PROCESS action though that was added somewhere around AR System 6.3 days that mimics that so that the code is not dependant on the name of the Filter. The action is RELEASE-APPLICATION-PENDING. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Mitcham, Ross Sent: Monday, March 02, 2015 1:24 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names It should still be there, but it is `! not ~! (not sure if this is a typo) Regards, Ross Mitcham Lead Product Developer Direct +1 905.707.3534 tel:%2B1%20905.707.3534 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Ray Gellenbeck Sent: Monday, March 02, 2015 1:14 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: The ~! for filter names Was the ~! function deprecated out in 8.x? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years -- Thanks regards “Harsh Chaudhary” Impatience never commanded success _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Best Mobile Interface Development Path Opinion
Hi Levi, I see you are thinking of adding views to the ITSM forms. Another option that might give you more flexibility, performance and freedom would be to create separate staging forms with their own views and workflow. That way you do not change the OOTB stuff. Overlays are great, but there still are certain risks involved in upgrading to the next ITSM patch or release in spite of having overlays. Best Regards, Theo On Fri, Feb 6, 2015 at 7:50 PM, Lippincott, Levi (OMA-GIS) levi.lippinc...@interpublic.com wrote: ** Hello, First let me state we are going to be building this in house so, thank you if you have a product that will fit my needs but we are not in a position to purchase something. We are starting the process of building a mobile interface for, what I hope will be, some simple tasks. Ideally we would like our users to be able to login to the system and be brought to a slim view of the HPD:Incident Management Console with the only options available are applying/clearing filters, looking at their list of tickets, and then opening the tickets up. Then they can be brought to a slim view of the HPD:Help Desk form where they will see really basic info with some options like, “assign to me,” “reassign,” “resolve,” “update work log,” etc. All that being said, in everyone’s opinion would this be best achieved through separate HTML/Java web pages connected to the system via Web Services, or through a custom view on the respective forms, or is there another way that I have not thought of yet that might be better? We are running 8.1.00 ARS/ITSM with 8.1.01 (SP1) Mid Tier with Tomcat 6.0. [image: Description: Description: cid:411C7191-C84A-4BC4-84A6-03A2A02A75D5] [image: Description: Description: cid:5B14E19B-6B68-4C9C-84B4-F4330F2857CF] [image: Description: Description: cid:08D97333-1C57-4D34-91BD-254ADB3942AF] Connect with us:interpublic.com http://www.interpublic.com/ Twitter https://twitter.com/#%21/interpublicipg Facebook https://www.facebook.com/InterpublicGroup [image: Description: Description: cid:771DBABB-241A-47AB-AEEB-230567236D6E] *Levi Lippincott /* Remedy Administrator +1 402 561 7014 office +1 402 321 5421 mobile levi.lippinc...@interpublic.com Lync Communcator [image: Description: Description: cid:21DB6442-3C43-4D3D-BFC3-C2DA30C66CBF] *Interpublic Group *6825 Pine Street, Omaha, NE 68106 *Talent is a Gift; But Character is a Choice. -Matt Grotewold-* This message contains information which may be confidential and privileged. Unless you are the intended recipient (or authorized to receive this message for the intended recipient), you may not use, copy, disseminate or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail, and delete the message. Thank you very much. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: OT: Setting up a demo environment on LINUX..
Hi Joe, Because most of the companies I work with, that uses Linux, use RedHat, I initially chose RedHat for my demo/testing VM. When I found out that RedHat is only free for a limited time (about 30 days if memory serves me correctly), and that you will need to buy a license to get further OS updates, I decided to switch to CentOS, as it is also provided by the same organisation that distributes RedHat. CentOS is free and close enough to RedHat, and that is why I like it. There are a couple of caveats and tricks when building a CentOS VM to be a Remedy server. I struggled to get it to work initially, but, like Misi, I have found that keeping a Trial Tribulation Script of notes on what worked and what not, helps in finally arriving at a point where you can use that TT script to build the entire VM quickly, and in one go. I have now built several working CentOS based VM's using Oracle as the DB for ARS v7.1 to 7.6.4 with and without ITSM and even went as far as writing a couple of bash scripts to help prepare the server for Oracle and Remedy installation. My advice: 1) Choose your Linux distro carefully and stick to it. Not all distro's will work (most will require some tinkering to make them work), but let the compatibility matrix guide your choice. 2) Stock up on patience and coffee. 3) Google will become your best friend. 4) Make a backup of the entire VM at key milestone points (i.e.: OS installed and patched, Prepped for Oracle Install, Oracle installed, ARS Installed, etc.) and keep each milestone backup until everything is loaded and working, so you can revert to the previous milestone and try again if something went horribly wrong. 5) Be prepared to spend a lot of time getting it to work if you are coming at it being used to non-'nix servers. 6) Be prepared to spend a lot of time getting it to work if you are coming at it being used to non-'nix servers. 7) Be prepared to spend a lot of time getting it to work if you are coming at it being used to non-'nix servers. (I think you get the message now...) :-) Also, having lots of RAM (16Gb or more) and super fast disks on your host machine won't hurt, and will go a long way towards keeping your patience at healthy levels - especially if you are building an ITSM server. :-) One of the many rewards for getting that Linux VM going, after all that hard work, is having a machine with a free OS, that outperforms the socks off any Windows server. Good luck and please let us know what you choose to do with this server. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: 05 February 2015 22:49 To: arslist@ARSLIST.ORG Subject: Re: OT: Setting up a demo environment on LINUX.. Hi, Just to clarify about the script. It is not a shell script, it is just a text file telling me what I need to install as prerequisites and some files that you need to create/edit, as well as the exact stuff I put into the installer screens. Best Regards - Misi, RRR AB, http://rrr.se Hi, It has never been free as far as I know. I guess you can request a trial version. The best way would probably to do it through one of your clients Support Contract IDs, as they typically has no limit on the number of servers. I have installed AR 8.1 on Scientific Linux (Red Hat Clone) with Oracle without any problem. I used Oracle XE which is free for small environments, and the full Oracle Client to connect through, in order to fool the Remedy installer. Mid-Tier + AR runs fine on 2GB memory in my VM, but I do not have ITSM installed on that machine. To run the installer you need X. I typically use Cygwin as X-server, and then do a ssh -X to the Linux server. I have a detailed script I follow in order to make everything run smoothly, so if anyone is interested, let me know. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Its been a while since I have set up a LINUX demo environment for use with the AR System Is it still a free for non commercial use? If so if anyone has recently set this up, I'd like some information of what I need to download, from where - and any do's and don'ts so. I would appreciate this information as it would save me some time. Cheers Joe _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years __ _ UNSUBSCRIBE or access
Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space
Hi Lisa, Another possible issue you might be encountering here is a full disk volume on a mounted folder. (See http://msdn.microsoft.com/en-us/library/windows/desktop/aa365733(v=vs.85).aspx ) If the folder you are installing to (or any of it's parents), or any other folder the installer is writing files to, is a mounted folder and the underlying volume/disk is full, you might encounter an issue that seems as if you have space left on the drive but you get errors regarding running out of disk space. HTH. Best Regards, Theo On Wed, Dec 24, 2014 at 4:54 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil wrote: I want to thank everyone for their help. I've tried all of your suggestions and nothing it working (I did not try the quota thing though from the MSDN link - that's the only thing I did not try). What I'm going to do is try to upgrade from 7.6.4 SP4 to SP5 and see if I get the same problem, if so, then it's definitely something on the server that's not allowing me to read or install (even though I have admin rights on the server and the folders). Stay tuned! Thanks! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, December 23, 2014 3:22 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space Personally I would do the install like this ... Shift Right-Click on the Disk1 folder you extracted to the D drive and choose Open command Window here In the command prompt do: SET TEMP=D:\TEMP SET TMP=D:\TEMP setup.cmd This will set the environment to the temp folder you want the install to use and will also run the install as admin. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Tuesday, December 23, 2014 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space Hi Anish! I did not run the installer from the zip file. I open up the zip file and take the disk1 folder and move it under the D: drive and then double click on the setup file. Maybe I just need to uninstall 7.6.04 sp4 and just install a fresh 8.1 sp2. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Anish Karkare 2 Sent: Tuesday, December 23, 2014 1:53 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space Just to confirm, did you extract the install files before running the installer? I have seen this when you open the downloaded zipped file directly by double clicking and running the installer? Try this, Right click downloaded zip file and extract using winzip or any other third party utility to a folder on your d drive. This will extract all files to the directory specified. Run the installer from there --- Original Message --- From: Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil Sent: December 23, 2014 11:28 AM To: arslist@ARSLIST.ORG Subject: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space I'm getting an error that my installation folder only has 0 MB of free Disk Space and I have over 4 GB's of Free Disk Space. I researched this and some people suggested updating the TEMP environment which I have done, but to no avail. Is there anything else I need to check? I'm an administrator on the folders. This is a Windows Server. I was able to upgrade my other server from 8.1.01 to 8.1 SP2 without any problems (same server type and structure). Any ideas? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space
Hi Lisa, It sounds to me like someone has set file system quotas on your server. See http://msdn.microsoft.com/en-us/library/windows/desktop/aa365228(v=vs.85).aspx. HTH. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Patrick Zandi Sent: 24 December 2014 00:16 To: arslist@ARSLIST.ORG Subject: Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space ** call me tomorrow lisa... 8-) On Tue, Dec 23, 2014 at 3:02 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil mailto:lisa.kemes@dla.mil wrote: That's under User Variables correct? I tried D:\TEMP, I'll try C:\TEMP, but I think I'll probably get the same error. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Givens, Gregory CTR NPC, Pers 54 Sent: Tuesday, December 23, 2014 2:36 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space Lisa, Change you Environment Variable TEMP (%TEMP%) to C:\TEMP It doesn't like it if there are spaces in the path Gregory Givens -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Tuesday, December 23, 2014 11:28 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Upgrading from 7.6.04 SP4 to 8.1 - Folder only has 0 MB of Free Disk Space I'm getting an error that my installation folder only has 0 MB of free Disk Space and I have over 4 GB's of Free Disk Space. I researched this and some people suggested updating the TEMP environment which I have done, but to no avail. Is there anything else I need to check? I'm an administrator on the folders. This is a Windows Server. I was able to upgrade my other server from 8.1.01 to 8.1 SP2 without any problems (same server type and structure). Any ideas? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com mailto:lisa.ke...@devtechnology.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Help with upgrade path
Hi Scott, We have a large Custom-Only installation – no ITSM or any other OOTB apps, thus – ARS only. I suggest not to skip the x or x.y major versions of the base AR System. The x.y.z minor versions generally do not have a notable design change on the DB – with the exception of 7.6.04, which introduced overlays (Don’t understand why BMC did not release this as a Major version???). This comes out of previous experience with having been called in to “fix” a number of failed upgrades in the past, amplified by a recent round of failed upgrade attempts. You could try to skip one or two of these versions – that’s up to you – YMMD – but no guarantees. You might be lucky when going directly from 7.0.1 to 8.1…. but I would not advise doing it to your Prod environment before doing some extensive testing on a duplicate test bed environment. We had the before-last round of upgrade attempts directly from 7.1.0 to 7.6.04 fail repeatedly on colleagues, a local support vendor and myself. We were desperate to get to a currently supported version of ARS, so I decided not to give up and find out why it fails….. Eventually got it sorted out safely using the steps I outlined before. We decided not to go to 8.0 or 8.1 as 7.6.04 is the last version that is shipped with the User Tool. Our user base are still making extensive use of the User tool and are reluctant to use Mid-Tier because of it’s lack of performance and because of the limitations it imposes on you as opposed to the User Tool. I would suggest using the ARS upgrade path with each of the versions I mentioned as I outlined it in my previous mail, (however you might want to upgrade to ARS 7.1.0 first), just to be on the safe side, because it is known to work that way. A single ARS Base upgrade does not take very long. We had a Saturday morning and afternoon change window to do the ARS Base upgrade from 7.1 to 7.6.04 SP5 and that was enough time to get it done. As far as the OOTB modules are concerned, I have not yet tried to use the 7.x ITSM modules on the 8.x AR Server, but logic dictates that it should still work if the 7.x ITSM libraries are still intact after the ARS upgrade, as the ARS API is backwards compatible. HTH. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: 18 December 2014 18:41 To: arslist@ARSLIST.ORG Subject: Re: Help with upgrade path ** Theo.. was this an ARS upgrade only, or were you upgrading the whole ITSM suite. I'm looking into an upgrading of only my ARS 7.0.01 base, which has ITSM running on top of it, to to 8.1 or 7.6. We would leave the ITSM portion as is for now. Are you saying to do this we need to install every version of ARS until we get to 8.1 On Monday, December 15, 2014 2:11 PM, Theo Fondse (GMail) theo.fon...@gmail.com mailto:theo.fon...@gmail.com wrote: ** Hi Carina, We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 7.6.4/11g/RedHat. I always suggest NOT to skip a major version when doing an upgrade, due to the fact that BMC only supports the last 3 versions, and therefore, might not test their software during development for upgrades from unsupported versions at the time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support policies). Before I started my current stint at the company where I am working now, they attempted an upgrade from 7.1 to 7.6.4 and failed several times. Even with the assistance of a local support partner, the upgrade failed and they eventually gave up. The solution to the problem later turned out to be that you should not skip any major versions and go through the installer logs to find out what went wrong if the installer fails. We found a caveat with some of the AR System forms and tables which had to be addressed manually before the upgrade in order to get the upgrade to work. I suggest the following steps which worked for us to do a successful upgrade (please test it first on a development/test environment before doing this on prod): 1. Back up the current DB (full DB export dump). 2. Export and delete all records from the AR System User Central File form. 3. Export and delete all records from the AR System User Preference form. 4. Temporary Disable Automatic Processes (performance tuning to make upgrade complete faster): Escalations Alerts Archive Log Files Server Events 5. Temporary Decrease Threads count (max 2 each) to enable faster re-caching during upgrade. 6. Shut Down AR System. 7. Verify that the Oracle 11g 64 bit client has been installed on the server and update the tnsnames file for this client. 8. Verify that at least java 1.6 32 and 64 bit has been installed. 9. Comment out Db
Re: Help with upgrade path
Hi Carina, We moved everything to 64-bit, but also installed a 32-bit copy of Java especially for the Email Engine. Best Regards, Theo On Fri, Dec 19, 2014 at 5:45 PM, Carina Burns carina.bu...@risd.org wrote: Thanks for the info Theo. One more question. Did you migrate the 3rd party pieces to 64bit as well? We are using Exchange/Outlook for our mail server so we are using the MAPI protocol for the email engine. This means we have to use the 32bit JRE. I'm wondering whether I need to use the 32bit 2.4.x Apache HTTPD or whether I can use the 64bit. On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) theo.fon...@gmail.com wrote: Hi Carina, We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 7.6.4/11g/RedHat. I always suggest NOT to skip a major version when doing an upgrade, due to the fact that BMC only supports the last 3 versions, and therefore, might not test their software during development for upgrades from unsupported versions at the time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support policies). Before I started my current stint at the company where I am working now, they attempted an upgrade from 7.1 to 7.6.4 and failed several times. Even with the assistance of a local support partner, the upgrade failed and they eventually gave up. The solution to the problem later turned out to be that you should not skip any major versions and go through the installer logs to find out what went wrong if the installer fails. We found a caveat with some of the AR System forms and tables which had to be addressed manually before the upgrade in order to get the upgrade to work. I suggest the following steps which worked for us to do a successful upgrade (please test it first on a development/test environment before doing this on prod): 1. Back up the current DB (full DB export dump). 2. Export and delete all records from the AR System User Central File form. 3. Export and delete all records from the AR System User Preference form. 4. Temporary Disable Automatic Processes (performance tuning to make upgrade complete faster): Escalations Alerts Archive Log Files Server Events 5. Temporary Decrease Threads count (max 2 each) to enable faster re-caching during upgrade. 6. Shut Down AR System. 7. Verify that the Oracle 11g 64 bit client has been installed on the server and update the tnsnames file for this client. 8. Verify that at least java 1.6 32 and 64 bit has been installed. 9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using UTF-8. 10.Run the following script on Oracle (fix for SW00327170): CREATE TABLE SCHEMA_ARCHIVE_BACKUP AS SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = NULL; COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NUMBER (15)); COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = (SELECT ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE_BACKUP WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NOT NULL); 11.Upgrade to ARS 7.5.0 12.Upgrade to ARS 7.6.04 SP5 13.Upgrade to ARS 8.0 14.Upgrade to ARS 8.1 15.Restore original config for Escalations Alerts Archive Log Files Server Events Threads count 16.Import backed up records for the AR System User Central File form. 17.Import backed up records for the AR System User Preference form. HTH, Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: 12 December 2014 22:44 To: arslist@ARSLIST.ORG Subject: Re: Help with upgrade path My suggestion Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c (Your DBA could also do this with oracle DataPump). Install 8.1 on the new server against the copy/restored data. When installing it should ask you if you want to upgrade or start new in the database. Choose upgrade. (You do NOT need to have an existing set of ARS binaries on the new server to choose upgrade as this only refers to the database data) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Carina Burns Sent: Friday, December 12, 2014 11:38 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Help with upgrade path Greetings!!! I am turning to you all for suggestions for an upgrade path for our
Re: Help with upgrade path
Hi Carina, We are running Mid-Tier, but with Tomcat on it's own and without HTTPD. You do not need httpd to run mid-tier unless you want to host other normal web sites/pages. Mid-Tier is perfectly happy on Tomcat only. (You can even configure Tomcat to bind on Port 80 in stead of 8080 if you want to.) Best Regards, Theo On Fri, Dec 19, 2014 at 5:52 PM, Carina Burns carina.bu...@risd.org wrote: And I just read your other replyYou likely don't run HTTPD because you don't run Mid-Tier... So I'll open the question to others, will Apache HTTPD 2.4.x 64bit work well with the 32bit JRE? And is anyone running the later versions of JRE? The support matrix lists JRE6u17 but Oracle has that in the Nope column. On Fri, 19 Dec 2014 10:45:22 -0500, Carina Burns carina.bu...@risd.org wrote: Thanks for the info Theo. One more question. Did you migrate the 3rd party pieces to 64bit as well? We are using Exchange/Outlook for our mail server so we are using the MAPI protocol for the email engine. This means we have to use the 32bit JRE. I'm wondering whether I need to use the 32bit 2.4.x Apache HTTPD or whether I can use the 64bit. On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) theo.fon...@gmail.com wrote: Hi Carina, We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 7.6.4/11g/RedHat. I always suggest NOT to skip a major version when doing an upgrade, due to the fact that BMC only supports the last 3 versions, and therefore, might not test their software during development for upgrades from unsupported versions at the time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support policies). Before I started my current stint at the company where I am working now, they attempted an upgrade from 7.1 to 7.6.4 and failed several times. Even with the assistance of a local support partner, the upgrade failed and they eventually gave up. The solution to the problem later turned out to be that you should not skip any major versions and go through the installer logs to find out what went wrong if the installer fails. We found a caveat with some of the AR System forms and tables which had to be addressed manually before the upgrade in order to get the upgrade to work. I suggest the following steps which worked for us to do a successful upgrade (please test it first on a development/test environment before doing this on prod): 1.Back up the current DB (full DB export dump). 2.Export and delete all records from the AR System User Central File form. 3.Export and delete all records from the AR System User Preference form. 4.Temporary Disable Automatic Processes (performance tuning to make upgrade complete faster): Escalations Alerts Archive Log Files Server Events 5.Temporary Decrease Threads count (max 2 each) to enable faster re-caching during upgrade. 6.Shut Down AR System. 7.Verify that the Oracle 11g 64 bit client has been installed on the server and update the tnsnames file for this client. 8.Verify that at least java 1.6 32 and 64 bit has been installed. 9.Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using UTF-8. 10. Run the following script on Oracle (fix for SW00327170): CREATE TABLE SCHEMA_ARCHIVE_BACKUP AS SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = NULL; COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NUMBER (15)); COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = (SELECT ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE_BACKUP WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NOT NULL); 11. Upgrade to ARS 7.5.0 12. Upgrade to ARS 7.6.04 SP5 13. Upgrade to ARS 8.0 14. Upgrade to ARS 8.1 15. Restore original config for Escalations Alerts Archive Log Files Server Events Threads count 16. Import backed up records for the AR System User Central File form. 17. Import backed up records for the AR System User Preference form. HTH, Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: 12 December 2014 22:44 To: arslist@ARSLIST.ORG Subject: Re: Help with upgrade path My suggestion Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c (Your DBA could also do this with oracle DataPump). Install 8.1 on the new server against the copy/restored data. When installing it should ask you if you
Re: Help with upgrade path
You're welcome! Let me know if the upgrade works for you without running the SW00327170 script. Would be interesting to note. Good luck with the rest of your upgrade hope all goes well! On Fri, Dec 19, 2014 at 7:10 PM, Carina Burns carina.bu...@risd.org wrote: I just looked and that column in our linux Ora10g Schema_archive table is a varchar2(254) with no “not null” constraint. I don’t think I’m going to change it to a number(15) not null column before I try the upgrade since this may be a Solaris only issue. If the upgrade bombs then I’ll look over the install log and see if it’s something I should address. Thanks for the heads up though. From: Theo Fondse [mailto:theo.fon...@gmail.com] Sent: Friday, December 19, 2014 10:25 AM To: Burns, Carina Subject: Re: Help with upgrade path Nope, SW00327170 is on BMC. I see how you could have thought it was on Oracle... :-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Help with upgrade path
Hi Carina, We upgraded our Custom-Only 7.1/10g/Slolaris server recently to 7.6.4/11g/RedHat. I always suggest NOT to skip a major version when doing an upgrade, due to the fact that BMC only supports the last 3 versions, and therefore, might not test their software during development for upgrades from unsupported versions at the time. (I seriously doubt that BMC would have tested a straight upgrade from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support policies). Before I started my current stint at the company where I am working now, they attempted an upgrade from 7.1 to 7.6.4 and failed several times. Even with the assistance of a local support partner, the upgrade failed and they eventually gave up. The solution to the problem later turned out to be that you should not skip any major versions and go through the installer logs to find out what went wrong if the installer fails. We found a caveat with some of the AR System forms and tables which had to be addressed manually before the upgrade in order to get the upgrade to work. I suggest the following steps which worked for us to do a successful upgrade (please test it first on a development/test environment before doing this on prod): 1. Back up the current DB (full DB export dump). 2. Export and delete all records from the AR System User Central File form. 3. Export and delete all records from the AR System User Preference form. 4. Temporary Disable Automatic Processes (performance tuning to make upgrade complete faster): Escalations Alerts Archive Log Files Server Events 5. Temporary Decrease Threads count (max 2 each) to enable faster re-caching during upgrade. 6. Shut Down AR System. 7. Verify that the Oracle 11g 64 bit client has been installed on the server and update the tnsnames file for this client. 8. Verify that at least java 1.6 32 and 64 bit has been installed. 9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using UTF-8. 10. Run the following script on Oracle (fix for SW00327170): CREATE TABLE SCHEMA_ARCHIVE_BACKUP AS SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = NULL; COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NUMBER (15)); COMMIT; UPDATE SCHEMA_ARCHIVE SET ARCHIVEFROMFORM = (SELECT ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE_BACKUP WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); COMMIT; ALTER TABLE SCHEMA_ARCHIVE MODIFY (ARCHIVEFROMFORM NOT NULL); 11. Upgrade to ARS 7.5.0 12. Upgrade to ARS 7.6.04 SP5 13. Upgrade to ARS 8.0 14. Upgrade to ARS 8.1 15. Restore original config for Escalations Alerts Archive Log Files Server Events Threads count 16. Import backed up records for the AR System User Central File form. 17. Import backed up records for the AR System User Preference form. HTH, Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: 12 December 2014 22:44 To: arslist@ARSLIST.ORG Subject: Re: Help with upgrade path My suggestion Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c (Your DBA could also do this with oracle DataPump). Install 8.1 on the new server against the copy/restored data. When installing it should ask you if you want to upgrade or start new in the database. Choose upgrade. (You do NOT need to have an existing set of ARS binaries on the new server to choose upgrade as this only refers to the database data) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns Sent: Friday, December 12, 2014 11:38 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Help with upgrade path Greetings!!! I am turning to you all for suggestions for an upgrade path for our ARS system. I've contacted BMC for advice, however our support contract level is Basic... which is also the adjective I would use to describe my current level of customer satisfaction. Has anyone gone from ARS 7.1 to 8.1? How did you do it? If you don't want to wade thru my specifics, kindly preface your reply with TLDR before you explain your upgrade method. The specifics: Our production set up is ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal Reports XI running on WinSvr 2003 SP2 against an Oracle 10g last patch database on RedHat Enterprise 4.0 I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised after opening a support ticket
Re: Developer Tool Crashing
Changing the 8.1 devstudio.ini to the following did help some for me - also made it slightly faster and more responsive: -vm JavaInstallDir\jre\bin\javaw.exe -vmargs -server -Xms768m -Xmx2048m -Xmn128m -XX:PermSize=128m -XX:MaxPermSize=128m -XX:+UseLargePages -verbose:gc -XX:+UseParallelGC -XX:ParallelGCThreads=2 -XX:+CMSIncrementalPacing -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+PrintGCApplicationStoppedTime -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=InsertYourOwnPathHere\DSDump.log -XX:ErrorFile=InsertYourOwnPathHere\DSDump.log I have found the standard devstudio.ini settings to be insufficient to keep DS running if you are doing serious development - it was obviously only intended as minimum config to get it working for extreme light loads such as modifying one or two active links a day. :-) HTH Best Regards, Theo On Fri, Nov 14, 2014 at 8:34 PM, Andrew Hicox and...@hicox.com wrote: ** If what you're hitting is infinite wait while doing something like expanding a guide, try deleting the dev-studio cache. Seems like I've gotta do that at least twice a week since we moved to 8.1 Andy On Nov 13, 2014 2:44 PM, Frank Caruso caruso.fr...@gmail.com wrote: Not seeing a lot of discussion on the list about this but others must be impacted. For that last few weeks the developer tool has been crashing intermittently. Ive tried all the way up to 8.1 sp2 but no luck. There is a BMC KA on this issue but the solutions do not help. We cannot back out the Windows Security patch that is supposedly causing the issue. The tool has crashed a dozen times today so it is almost impossible to do any development. Does anybody have any more information on a fix for this issue? Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how fast could that be?
This is a little late, but I was just reminded by something else about some of the unusual systems I have done development on, using Remedy (excluding integration projects) as your post came in: CD Music Inventory Custom Fleet Asset Management KPI Monitoring Telco Project Management Custom Project Tracking Custom License Tracking Custom Data Configuration Controlled Business Process Management (very generic robust) Banking Merchant Customer Onboarding Asset Tracking Banking Tactical CMDB for a datacenter migration User Activity Monitoring Business Process Monitoring for ITSM System Monitoring Automation Tool Timesheet Management Claims Management Best Regards, Theo On Thu, Nov 13, 2014 at 10:58 AM, Zee Remshab 6mor...@gmail.com wrote: many thanks all for your inputs. Especially Jason and Rick. I was seeking for just some mental support I received as bonus some cuisine tips. Never thought to ARS dev as a sausage grinder though ... rather like doing a pizza ... ok looking for Easter Eggs could also be pretty similar sometimes I believe the ITSM being jelly for sure though I would try not to get crazy too Claire ... not sure getting crazy s gonna help... Possibly the subject of my initial post should have been how difficult could that be ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: dde.ini and slow start of Excel 2013
Hi Misi! Personally, I haven't used DDE.ini in years, but you could try something like this: Command1=[App.Minimize()] Command2=[NEW(G:\ABC\ARS-files\rek.xlt)] Command3=[PASTE()] Command4=[CLOSE(1)] Command5=[App.Maximize()] HTH. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: 03 November 2014 12:33 To: arslist@ARSLIST.ORG Subject: dde.ini and slow start of Excel 2013 Hi, I have a client experiencing problems with ARUser.exe and exporting data to excel through the report to application functionality. The dde.ini works fine for older versions of Excel, and also works fine for Excel 2013 if it is ALREADY OPEN. If Excel is NOT open when doing this, it seems like Excel takes too much time to start, and the PASTE operation fails. Only the empty template is opened. Any ideas on how to fix this? Maybe some kind of Pause-command? # from the DDE.INI file [Rek] Path= C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE Application=excel Topic=system Format=Record CharsPerLine=100 XFRDATA=Clipboard Command1=[CLOSE(1)][NEW(G:\ABC\ARS-files\rek.xlt)] Command2=[PASTE()] Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Server side filter log not getting captured!
Hi Ayushi, Please post the output from the following commands in your putty session: ps -ef | grep arserverd uname -a df -h Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: 29 September 2014 10:23 To: arslist@ARSLIST.ORG Subject: Re: Server side filter log not getting captured! Hi, Why not go for Client Side Filter Logs? You just need to make sure you belong to the Client Side Logging Group specified in the Log Files tab you mentioned. Then you go in to your User Preference Record and enable it. Close the logging window just before the operation you want to investigate. But some things not directly triggered by you will indeed require server side logs, which I have never seen fail. If the log is too big, you might have problems getting the file through ARUser/Mid-Tier. You should log in to the server on the OS level to get it. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi List, Can any one please help me here? I am unable to capture server side filter log from. I am using the following way to enable filter logs. AR System Administration- AR System Administration Console -System-General - Server Information-'Log Files' tab. But when I click the 'View' - button next to filter log, it simply shows: Attchment Size (KB) :0.0 Can you please assist me if I am missing anything here. Thanks in Advance, Ayushi Agrawal __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Diary field usage
Hi John, We still use diary fields in some cases here, but, due to their limitations, we have been steering clear of using them - same for status history. We prefer to use a related companion form with workflow and a table field on the main form to store a Work Log in stead of a Diary Field because of the extra possibilities it offers for expansion and reporting. (same goes for Status History). At the end of the day, if you are talking about a Work Log or status history on a small data form somewhere in the background of your application, sure, use the Diary and standard Status History, but if you are talking about a main application form, rather go with the related companion form to store a Work Log (or Status History). Reporting on the related form is relatively easy to do with sub-reports etc. If you are using Oracle, you could even use the LISTAGG function to combine your related records into a single column value on a SQL Query or DB view you create. HTH, Best Regards, Theo On Tue, Sep 30, 2014 at 12:30 AM, Reiser, John J john.j.rei...@lmco.com wrote: ** Hello Listers, I have quick question. What is the general consensus on the use of Diary fields? Are they going out of style? I have tried a “work log” table type of design to replace the diary function on a form. This method works ok except when it comes time to run reports. Do you dump the table field data to a large character field? Or is there a slick way to incorporate the child records into the report on the fly? Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst 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 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Number of user logins in remedy
Hi Saurabh, This is relatively quick and easy to do. We have done exactly this for our Remedy server. 1) Create a small form that has fields for the data you need to know. 2) Enable archiving on this form to keep 7 days of history. 3) Add an active link attached to the Home page form or to your application main form that runs on Window Open and add a Push Fields action that submits a new record every time and populates the new form using the system keywords. 4) You can write a SQL query or a report to interrogate the new form's data to get the info you need. You can get an at-the-moment real time figure of how many users are logged in to the server at the moment, from the AR System Administration Console under Application--License Review, but that does not hold history. You could also enable the User Log File and parse it daily, but that is not as easy to do. Best Regards, Theo On Tue, Sep 23, 2014 at 6:15 AM, MalviyaSaurabh malviya.saurab...@gmail.com wrote: Hi All, How can I determine the number of users that have logged in remedy for the last 7 days. My remedy application is on ARS v 7.1 It will be even better if I get to know via which mode they have logged in i.e. user tool or web. Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Number-of-user-logins-in-remedy-tp119033.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RESOLVED: E-mail engine not getting POP3 messages (Linux) but not logging errors
Rick, Glad to hear your problem is sorted. Thanks for sharing. I’ll keep your solution in mind because this might also help with any other mailbox you need to monitor for mails being processed or not. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 11 September 2014 23:54 To: arslist@ARSLIST.ORG Subject: RESOLVED: E-mail engine not getting POP3 messages (Linux) but not logging errors ** I finally got some scripting to do exactly what I needed. I did it the kludgy way for now but it works. I first had to use Autoexpect to help me build a script to connect to the mailbox via openssl s_client, then issue the STAT command to get the message count. I tweaked that Expect script and used the log_file command to send the output to a text file. I then wrote a BASH script that first calls the Expect script, then parses the resulting text file to get out the number of messages queued up; if that is greater than zero then it uses mailx to send me an alert so that I can bounce the e-mail engine. Phase two will be modifying the script so that it will bounce the e-mail engine and just send an informational (instead of actionable) e-mail to notify me that there had been messages queued but the engine was restarted. Of course the problem hasn’t reoccurred since my last message on 9/5. I did get a successful test last night though, I put the script in the crontab to run every one minute and since the e-mail engine only polls the mailbox every two minutes I got several alerts overnight. In the future I will investigate using Ruby or Perl instead so that I can leverage existing POP3 libraries but for now this addresses my problem (even if it isn’t in the most elegant manner). My script is now running every ten minutes which gives the e-mail engine at least four tries to pull down messages. In case anyone is curious the STAT command returns this sort of output (including the line break) where the first integer is message count and the second is total size: stat +OK 14 3561 That made it slightly more difficult to parse out what I needed which is the first integer after the OK. I ended up chaining two awk commands together to do it. awk '/stat/,/+OK/' $ETC_DIR/output.txt | awk '{print $2}' -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: Friday, September 05, 2014 2:39 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: E-mail engine not getting POP3 messages (Linux) but not logging errors ** Theo- Actually that is a good solution and we have something almost exactly like that in place. That works well in restarting the service and since our script sends a notification I know that it fires off every week or two (we don’t have very much e-mail volume). My current issue is that our script doesn’t catch the fact that the engine is not pulling down the messages so it never stops the service. That being said the script predates me here so I need to read it through and see if it references the specific string you mentioned. If not that might be my magic bullet. Thanks for the suggestion! Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse (GMail) Sent: Wednesday, September 03, 2014 11:29 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: E-mail engine not getting POP3 messages (Linux) but not logging errors ** Rick, We were also running 7.1 on RHEL up until a couple of weeks ago, and also had to deal with reliability issues with the Remedy Email Engine stopping to process mail without any warning or without inscriptions in the debug log that points to any real issues or leads to what the issue might be….. very frustrating…… We send and receive a lot of e-mail to/from our Remedy server and users have become quite dependant on the e-mails (against our better advice), so we got into a lot of hot water every time someone discovered that mail was not being processed. This meant that we had to log a daily maintenance call for whoever’s turn it is to be on standby for the week to restart the Remedy Email Engine and babysit the Email Engine to clear out the unprocessed mail queue. This was NOT fun…… In response to this I implemented a workaround and our Remedy Email Engine woes disappeared…. Emails continued to be processed 24/7 and we did not get lambasted any more by angry users about emails not being sent/received. This workaround was quite simple to implement: 1) Configure the Remedy Email Engine to write to the debug log. 2) Write a small shell script to monitor the debug log file for inscriptions of “/221 2.0.0 Service closing transmission channel” and kill the Email Engine process once the inscriptions appear
Re: E-mail engine not getting POP3 messages (Linux) but not logging errors
Rick, We were also running 7.1 on RHEL up until a couple of weeks ago, and also had to deal with reliability issues with the Remedy Email Engine stopping to process mail without any warning or without inscriptions in the debug log that points to any real issues or leads to what the issue might be….. very frustrating…… We send and receive a lot of e-mail to/from our Remedy server and users have become quite dependant on the e-mails (against our better advice), so we got into a lot of hot water every time someone discovered that mail was not being processed. This meant that we had to log a daily maintenance call for whoever’s turn it is to be on standby for the week to restart the Remedy Email Engine and babysit the Email Engine to clear out the unprocessed mail queue. This was NOT fun…… In response to this I implemented a workaround and our Remedy Email Engine woes disappeared…. Emails continued to be processed 24/7 and we did not get lambasted any more by angry users about emails not being sent/received. This workaround was quite simple to implement: 1) Configure the Remedy Email Engine to write to the debug log. 2) Write a small shell script to monitor the debug log file for inscriptions of “/221 2.0.0 Service closing transmission channel” and kill the Email Engine process once the inscriptions appear. (Since the Email Engine is taking a nap for a while when it writes this line to the log, it means that you are not killing it whilst it is busy processing mail.) Old Faithful ARMonitor will do it’s job immediately and start the Email Engine right up again (unless your email engine is running on a different server from your ARSystem server – then your script will have to start the Email Engine up again). 3) Schedule the script as a cron job to run once an hour. This is not the most desirable or elegant method, and some might call it crude, but it has the end result of emails being processed 24/7 without fail and keeps angry users off our backs…. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 02 September 2014 20:00 To: arslist@ARSLIST.ORG Subject: Re: E-mail engine not getting POP3 messages (Linux) but not logging errors ** With a suggestion from Laurent on BMC Communities I realized that I should have just searched for POP3 commands to find what I need and then write a quick BASH script to log into the mailbox (hopefully I can to it via SSH instead of telnet) and then if the result of the LIST command is greater than zero fire the alert. Since the e-mail engine does a POP3 poll every two minutes I can run my script every 10 minutes to minimize false positives. In fact it looks like maybe just doing the login should tell me the number of messages. Once I get this written I will post my results in case anyone else might benefit from it. Incidentally the same thing happened on Friday night and I caught it when I got back in the office this morning by visually inspecting the mailbox. I have a feeling the problem may be related to the fact that this particular mailbox is hosted by Microsoft in the cloud. :/ -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, August 29, 2014 6:22 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: E-mail engine not getting POP3 messages (Linux) but not logging errors ** You can do the same thing I have listed in reverse (I do that also) Change the Count to find out if there have been any inbound in the last x minutes and if not then send an email Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: Thursday, August 28, 2014 5:39 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: E-mail engine not getting POP3 messages (Linux) but not logging errors ** Thanks for all the helpful suggestions. Our outbound e-mail is SMTP so it is decoupled from the inbound mail which is where I’m having the problem. I guess what I am looking for is really something I can run from a different server that can check the number of messages in the mailbox via POP3 without pulling any of them down. If the check only runs every 10 minutes then the Remedy e-mail engine will have had four chances to pick up the messages and I could trigger an alert on that. I’ll have to exercise some good-old fashioned Google-fu to see what I can come up with. The frustrating part is that there was nothing logged at all, the engine just failed to grab the messages. I had already thought of calling an external script to use sendmail to send the alert for queued up outbound messages but fortunately that isn’t a problem. -Rick From: Action Request System discussion list(ARSList)
Re: Remedy 6.3 and Solaris x86?
LJ, Is it possible that you are thinking of the old “Flat-file DB” option we had in versions prior to 4..x (if my memory serves me correctly)? As far as I am aware, we never had Slolaris x86 support for AR Server. I tried forcing the install on a x86 Slolaris dev VM about 2 or 3 years ago and had to be reminded the hard way that it just won’t work….. :) I suggest going with Linux. It is close enough to Sloraris as a dev server and you have all the flexibility and portability you need with it. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 27 August 2014 00:18 To: arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 and Solaris x86? ** No clue where my brain is then. On Aug 26, 2014 4:17 PM, Grooms, Frederick W frederick.w.gro...@xo.com mailto:frederick.w.gro...@xo.com wrote: ** Nah … There is no platform requirement for the database. As long as it is a supported version and I can connect to it from the AR Server it will work. Fred From: Action Request System discussion list(ARSList) [mailto: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 26, 2014 5:02 PM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 and Solaris x86? ** Maybe it's the db that'd no longer supported on that platform? On Aug 26, 2014 3:51 PM, Grooms, Frederick W wrote: ** I know we changed from Solaris SPARC to Linux at either 6.3 or 7.They moved our database from Solaris SPARC to Solaris x86 around that same time as well. From: Action Request System discussion list(ARSList) [mailto: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Tuesday, August 26, 2014 4:46 PM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 and Solaris x86? ** I had 6.3 Linux servers at one point. Or maybe it was 6.0? It was some flavor of 6. Jason On Tue, Aug 26, 2014 at 1:32 PM, LJ LongWing wrote: ** yes, you are 100% correctLinux is what I was thinking. On Tue, Aug 26, 2014 at 2:31 PM, Grooms, Frederick W wrote: ** Linux is x86 Unix is HP-UX, Solaris SPARC, and AIX From: Action Request System discussion list(ARSList) [mailto: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 26, 2014 2:02 PM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 and Solaris x86? ** h...I swear I remember some discussion at some point...maybe it was one of the 'unix' installers that worked on Solaris x86. On Tue, Aug 26, 2014 at 1:00 PM, Grooms, Frederick W wrote: ** There was never a Solaris x86 version of the AR server (as far as I know). The only Solaris supported for AR Server is the SPARC version. Fred From: Action Request System discussion list(ARSList) [mailto: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 26, 2014 1:42 PM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Remedy 6.3 and Solaris x86? ** I know I'm asking about something relatively old...but I remember that Sparc/x86 support was dropped at some point, but I'm wondering if Remedy 6.3 still had that ability or not. Does anyone remember? _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy Developer Performance Metrics
Hi Charlie! Although I have grown over the past few years to fully agree with LJ on this subject, I can also understand the need for metrics to have something to go by to know if our performance is on-par or not. Sadly, measurements in the LOC style no longer give a true picture of actual performance especially in terms of Remedy development. The company I am currently working for has a 100% custom Remedy solution, and are measuring performance based on number of requests closed per day irrespective of workflow object count (but they include all types of incidents, problems and change requests in this figure). In my opinion, this is a better performance metric than pure LOC count, but is also flawed because some types of requests are quicker and easier to close than others. Shawn Pierson nailed it very well in his mail, if the purpose of the exercise is to determine the quality of a Remedy developer or to guide decisions around which questions your metrics should answer if you want your company to keep the Remedy developer that will truly be most beneficial to keep when the time comes to make those hard decisions. Dave Shellman also pointed out the efficiency of code argument. I would like to add to what he said by pointing out that the better Remedy Developer will: 1) Add config data to the system to configure it to do something rather than write superfluous/duplicate code. 2) Pre-allocate field ID's and share Filters/Active Links between multiple forms. These effectively lowers your LOC count and therefore LOC count does not paint a true picture of quality or quantity of performance in such cases. Server and network infrastructure performance also plays a role in developer performance. If you are working on a server that takes 38 seconds just to open an active link, you cannot be expected to churn hundreds of active links a day. Anyone will be able to (intentionally or unintentionally) exploit LOC-based metrics to their advantage by bloating their code, simply by: 1) Adding a number of extra Filters or Active links in stead of making something data configurable or generic. 2) Copy-Pasting Filters or Active Links rather than pre-allocating fieldID's and sharing workflow between forms. 3) Writing bloat-up Filters/Active Links that only seem to be doing something relevant, but has no consequence to the actual functionality. But, to answer your original question: If the company insistence remains on measuring performance on an LOC basis, and if 1) You are guaranteed to always be presented with complete, clear, signed off and sufficient requirement specification documentation, 2) You are guaranteed to have access to properly performing infrastructure (active link opens up in 3s), 3) You are focussed on doing development and are not required to stop what you are doing and attend to support issues, 4) You do not attend more than 2 hours worth of meetings or workshops a week, 4) Complexity of the solution is low to medium, 5) Good quality code is required. (As opposed to only evaluating if it seems to be doing what was required), 6) There are no external integrations to other systems where you do not have full admin access and responsibility, then my opinion is that, on an 8-hour working day, a good Remedy Developer should be able to produce anywhere between 15 and 100 objects a day counting a total combination of Forms, Active Links, Filters, Escalations, Guides, Applications, Web Services, Menus, and Flashboards. This is based on an approximate average of between ~5 to ~30 minutes time spent on average per object. If a Remedy developer is creating more than an average of 100 objects a day, then that developer is running the risk of probably not ensuring good quality code, because he/she is: 1) Copy-pasting code and not testing it the way it should be tested. 2) Unwittingly creating a bloated monster of a system that is going to be a costly nightmare to maintain. In such cases, one could start looking at: 1) Synchronising field ID's across al forms. 2) Writing more generic code that can rather be shared and/or data-driven. HTH. Best Regards, Theo On Wed, Jun 4, 2014 at 4:41 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hi all, Thanks for all your responses. And, while I didn't get quite what I was looking for, it's certainly my own fault for not starting with the more narrow question I eventually posed. And even that I should have qualified by stating assuming perfectly efficient workflow. I fully agree with all of the positions that the quantity of workflow varies significantly with the quality of that workflow, the complexity of the requirements, and many other factors. I also agree that in isolation, workflow object count is a useless number. I *do* think that as part of a broader set of measurable characteristics it can be used to say something useful about the developer, hopefully to be used constructively. But this is a conversation that is diverging
Re: Remedy Developer Performance Metrics
. Fast, Accurate, Cheap Pick two.. - Matt Black On Thu, Jun 5, 2014 at 10:55 AM, Danny Kellett dkell...@javasystemsolutions.com wrote: ** Quantity != Quality -- Danny Kellett dkell...@javasystemsolutions.com On Thu, Jun 5, 2014, at 09:31 AM, Theo Fondse wrote: ** Hi Charlie! Although I have grown over the past few years to fully agree with LJ on this subject, I can also understand the need for metrics to have something to go by to know if our performance is on-par or not. Sadly, measurements in the LOC style no longer give a true picture of actual performance especially in terms of Remedy development. The company I am currently working for has a 100% custom Remedy solution, and are measuring performance based on number of requests closed per day irrespective of workflow object count (but they include all types of incidents, problems and change requests in this figure). In my opinion, this is a better performance metric than pure LOC count, but is also flawed because some types of requests are quicker and easier to close than others. Shawn Pierson nailed it very well in his mail, if the purpose of the exercise is to determine the quality of a Remedy developer or to guide decisions around which questions your metrics should answer if you want your company to keep the Remedy developer that will truly be most beneficial to keep when the time comes to make those hard decisions. Dave Shellman also pointed out the efficiency of code argument. I would like to add to what he said by pointing out that the better Remedy Developer will: 1) Add config data to the system to configure it to do something rather than write superfluous/duplicate code. 2) Pre-allocate field ID's and share Filters/Active Links between multiple forms. These effectively lowers your LOC count and therefore LOC count does not paint a true picture of quality or quantity of performance in such cases. Server and network infrastructure performance also plays a role in developer performance. If you are working on a server that takes 38 seconds just to open an active link, you cannot be expected to churn hundreds of active links a day. Anyone will be able to (intentionally or unintentionally) exploit LOC-based metrics to their advantage by bloating their code, simply by: 1) Adding a number of extra Filters or Active links in stead of making something data configurable or generic. 2) Copy-Pasting Filters or Active Links rather than pre-allocating fieldID's and sharing workflow between forms. 3) Writing bloat-up Filters/Active Links that only seem to be doing something relevant, but has no consequence to the actual functionality. But, to answer your original question: If the company insistence remains on measuring performance on an LOC basis, and if 1) You are guaranteed to always be presented with complete, clear, signed off and sufficient requirement specification documentation, 2) You are guaranteed to have access to properly performing infrastructure (active link opens up in 3s), 3) You are focussed on doing development and are not required to stop what you are doing and attend to support issues, 4) You do not attend more than 2 hours worth of meetings or workshops a week, 4) Complexity of the solution is low to medium, 5) Good quality code is required. (As opposed to only evaluating if it seems to be doing what was required), 6) There are no external integrations to other systems where you do not have full admin access and responsibility, then my opinion is that, on an 8-hour working day, a good Remedy Developer should be able to produce anywhere between 15 and 100 objects a day counting a total combination of Forms, Active Links, Filters, Escalations, Guides, Applications, Web Services, Menus, and Flashboards. This is based on an approximate average of between ~5 to ~30 minutes time spent on average per object. If a Remedy developer is creating more than an average of 100 objects a day, then that developer is running the risk of probably not ensuring good quality code, because he/she is: 1) Copy-pasting code and not testing it the way it should be tested. 2) Unwittingly creating a bloated monster of a system that is going to be a costly nightmare to maintain. In such cases, one could start looking at: 1) Synchronising field ID's across al forms. 2) Writing more generic code that can rather be shared and/or data-driven. HTH. Best Regards, Theo On Wed, Jun 4, 2014 at 4:41 PM, Charlie Lotridge lotri...@mcs-sf.com wrote: ** Hi all, Thanks for all your responses. And, while I didn't get quite what I was looking for, it's certainly my own fault for not starting with the more narrow question I eventually posed. And even that I should have qualified by stating assuming perfectly efficient workflow. I fully agree with all of the positions that the quantity of workflow varies significantly with the quality
Re: OT: Baby Sofia
Congratulations Tauf!! May you and your wife experience all the love and real joys of parenthood with this little one! Don't worry about the sleep for now. It will return eventually. :-) And remember: There are no perfect parents in this world, only parents who try to be perfect...:-) Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Friday, May 30, 2014 8:19 PM To: arslist@ARSLIST.ORG Subject: [arslist] OT: Baby Sofia All, Just wanted to share with you guys that we are proud parents to a baby girl, Sofia, who was born on 05/25/2014 09:14:00 PM (ET). She was 6lbs, 6oz and 19.5 tall. Everyone is doing well. Sleep is an issue so I guess it's all normal. Here's a pic! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Non-Unicode database
Hi Tony, I have a client that runs a non-unicode DB on Oracle due to legacy reasons. There are currently no plans to switch over as the general feeling is that they do not stand to gain anything by doing so as their system is custom built and only used in one timezone one language - English Best Regards, Theo . On Tue, May 13, 2014 at 5:03 PM, Tony Myers tony_my...@bmc.com wrote: Hi ARList, I doing some research on non-Unicode database usage with Remedy. Are there folks out there that still deploy non-Unicode DB's and if so, why? Do you plan to move to Unicode? Many thanks, TM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Transactional (TR) and Database (DB)
James, This is to allow you to, for a specific field, 1) Determine programmatically if a (user or automated) transaction has attempted to change the field value or not . OR - 2) Compare what the value used to be, just before the current transaction attempted to change it, as opposed to what it is being changed to. A good example of a use case for this is if you have a business rule requirement that neither users nor other systems or processes integrated to your form are allowed to change the Status of a record from Assigned to Closed, because you want them to set it to Resolved first, because; 1) You have other workflow and/or SLA's and/or reports that depend on the Status.History.Resolved.TIME to be populated. OR - 2) You have a quality control process that determines that a different group of users pick up the Resolved records and phones the customer back to find out if they are happy with the resolution and only then is the record to be set to Status = Closed. In either of these cases, you would implement these business rules quickly and easily through the relatively simple creation of a single Filter that Checks if 'TR.Status' = Closed AND 'DB.Status' != Resolved and returns an error. If you only use Status = Closed in this filter run if, you will end up with the filter getting triggered for updates that legitimately set Status = Closed as well. If you used an active link on Return/Menu Choice/Lose Focus of the Status field, sure, you would prevent your users from making an invalid change, but, any Filter Push Field or API integration update would still manage to do the invalid update because active links don't get triggered on that level. Sure, you can achieve the same result by adding lots of Temp fields doing set-fields from the database to get the old DB value for your fields, but this starts to get very messy if you; 1) Have multiple business rules that require you to do this type of comparison on multiple fields. (You could potentially end up duplicating almost all your fields on the form doing things this way). 2) Have to deal with confused user questions as to which field should we believe to hold the actual value for their reports if the fields are named similarly to avoid programmer confusion. 3) Have to add extra filters to do a relatively expensive and redundant second lookup on the database to find the old DB value for a field - which only serves to slow down your system. 4) Forget to change the lookup field attributes if the actual field attributes has been changed. Therefore, the need for Transactional (TR) and Database (DB) values on filter level. HTH. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: 08 May 2014 17:22 To: arslist@ARSLIST.ORG Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Finding AR License without accessing Remedy
Thanks William! You could also run the following: select License_Type, Key from AR_System_Licenses where License_Type ='AR Server' Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 17 April 2014 05:07 To: arslist@ARSLIST.ORG Subject: Re: Finding AR License without accessing Remedy What version of ARS are we talking about? Anything 7.1 and higher stores it in the database, specifically in the AR System Licenses form. If your server is unusable you can get it directly out of the database by doing this: select schemaid from arschema where name='AR System Licenses'; Assuming the result of the above is 47 (which it is in the environment I just checked) you'd then do this: select C2703 from T47 where C2700='AR Server' C2700=License type C2703=Key -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of James Smith Sent: Wednesday, April 16, 2014 6:32 AM To: arslist@ARSLIST.ORG Subject: Finding AR License without accessing Remedy Good Day List! Server has crashing and I am planning to reinstall it all over again but I need the license info before I proceed. There must be some place on the server where this information is stored? I remember license information is stored in ARLicense.txt file but I am not sure. Can you help me to get back my license? Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4355 / Virus Database: 3882/7349 - Release Date: 04/15/14 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM on a Laptop Question
Hi James, This is possible indeed. I have done this many times in the past for my previous company (another BMC Partner) in order to do development and demo's on ITSM etc. The catch here is that you are guaranteed to have BAD performance of an ITSM VM if you only have 8GB RAM or less. If you use a laptop with 16GB RAM, i7 CPU and a fast set of disks, you are ok. I would also recommend for ITSM VM's to run a single VM due to the extra RAM you are wasting to run the second VM OS. I am currently using a two-VM set with CentOS 5.10, Oracle 11g, ARS 7.1.0 on my laptop for RD. (Yes, we're still on 7.1 here, but that is a different long story. We are also busy with an upgrade project at the moment) There's 12Gb RAM allocated to these two VM's in total (10 for DB and 2 for AR) and it performs well until I start 2 or 3 copies each of Admin tool and User Tool alongside Toad, Excel, Outlook and Notepad++ as the host machine goes over 15GB RAM and starts to swap heavily. (Unfortunately, my two internal HDD's are spinning @5400RPM. I'd recommend having =2 disks @7200RPM in RAID config for best performance/cost/reliability ratio. SSD's will be best for performance, but come at a crazy cost and seldom lasts for long if pounded with lots of writes, like what Remedy does to the DB) Maximum RAM availability and disk performance is the key here to have something that is not going to buckle under the slightest of duress. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: 08 April 2014 20:22 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question James: This portable server would run using a demo license from BMC, and would primarily serve as a reference instance. My company is a BMC partner, so BMC would give us a demo license to support their end customer. BMC used to produce VM images for sales partners to use to demonstrate the product to potential customers, but I haven't seen one of them in a few years. HTH, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of James Smith [bmcremedyarslis...@gmail.com] Sent: Tuesday, April 08, 2014 11:38 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question Is there a way to create an VM Image for remedy and use it commercially for trainings or leaning on multiple systems? How can you install ITSM on laptop? Don't you need a license from BMC? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Significance of Development cache mode
Hi Prathap , Development Cache Mode also makes things slow when multiple developers use the same server to do development. We have had to change our development server to switch off Development Cache Mode to get things to run smoothly. Development Cache Mode improves performance only if a single developer is working on the dev server. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: 26 March 2014 16:52 To: arslist@ARSLIST.ORG Subject: Re: Significance of Development cache mode Development cache mode is intended for servers whose main purpose is application development. It is unsuitable for servers with many application users in a production environment because user operations are blocked when administrative operations, such as form and workflow changes, occur. This is especially noticeable when many structures are changed, such as when an application is imported. This often gives the false impression that the server is hung. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Prathap Pb Sent: Wednesday, March 26, 2014 8:01 AM To: arslist@ARSLIST.ORG Subject: Significance of Development cache mode ** Hi Experts, Can you someone let me know the significance of Development cache mode. Does this have an effect on the application server performance ? When this option needs to be enabled ? How is this different from the normal mode ( dev cache mode = disabled) ? Regards PB _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: arserverd binding to 0.0.0.0
Hi Radhika! The only way you will be able to do this is to fool Remedy into thinking each instance is running on a diferent hostname by: 1) Aliasing the 3 different server names in the host file. 2) Setting the HOSTNAME variable before installing / starting each copy of ARSystem. This may or may not work, is a bit dangerous and can NOT be recommended for a production environment. Best Regards, Theo On Fri, Feb 21, 2014 at 11:05 AM, Narayanan, Radhika radhika.naraya...@cgi.com wrote: ** Hi Axton/Longwing, My first problem is that the AR Server itself is not starting when I setup 3 AR Servers in a server group on a single physical server. (ARS 8.1, RHEL 6.4) AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10 AR Server 2: Server-Name: d1, Server-Connect-Name: d11 AR Server 3: Server-Name: d1, Server-Connect-Name: d11 The 3 AR Servers are on one physical server and in a server group. d10, d11, d12 are 3 different virtual IP Addresses/Names for the physical server. AR Server service refuses to start. It complains armonitor.conf file cannot be found. *Each AR Server (arsystem startup script) is looking for /etc/arsystem/d1/armonitor.conf !!* d1 is the Load balancer = Server-Name in ar.conf. I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The server-connect-name is referred inside the armonitor.conf which is different for the 3 AR Servers! I find this architecture/requirement equally weird. It was decided by the client. They want 3 AR Servers on one physical server in a server group. I'm trying to squeeze Remedy into it now. Thanks Radhika +44 20718 25880 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* 20 February 2014 21:39 *To:* arslist@ARSLIST.ORG *Subject:* Re: arserverd binding to 0.0.0.0 ** If done properly, the rpc port mapper could work on all interfaces for all 3 servers. I say could because it's probably not been proven/done, but in theory it should work. Axton Grams On Thu, Feb 20, 2014 at 9:59 AM, Axton axton.gr...@gmail.com wrote: You could setup redirection using iptables to achieve what you want. Each server would effectively be listening on all ip addresses on different ports, but the redirection would redirect things as desired. http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/ http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika radhika.naraya...@cgi.com wrote: ** Thank you so much, Axton, Fred and others. Our client gave us one physical server with 3 virtual IP Addresses. And asked us to install AR Server on each of the virtual IP Addresses, all on *same port*. I guess I'm not able to use iptables restriction because I want to use the other IPs too , but for a second and third instance of AR Server. I'll write back to them stating that the current version of AR Server doesn't support this. Perhaps I should raise an RFE. Thanks again, Radhika +44 20718 25880 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* 19 February 2014 03:57 *To:* arslist@ARSLIST.ORG *Subject:* Re: arserverd binding to 0.0.0.0 ** Network daemons bind to address/protocol/port. 0.0.0.0 means all addresses. I looked through all the ar.conf parameters and flags supported by arserverd and it does not look like there is a way to tell arserverd to listed on a specific IP. You could use iptables to restrict access on those other IP addresses since you are on linux. Axton Grams On Tue, Feb 18, 2014 at 11:21 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: As far as I know the ARS binaries do not bind to an IP. They will bind to a TCP port if one is specified (and/or use portmapper if that is set). If you are not connecting to the AR Server one item to check is the /etc/hosts file. See if the name you used for your AR Server is listed as a valid name for an IP. If it is then check if your DNS server has it listed. Example: AR Server = arsdev01 Physical Server = devserver1 /etc/hosts file # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.1.101 devserver1 devserver1.mycorp.com arsdev01 DNS has a cname record for arsdev01 pointing to 192.168.1.101 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Narayanan, Radhika Sent: Tuesday, February 18, 2014 7:14 AM To: arslist@ARSLIST.ORG Subject: arserverd binding to 0.0.0.0 ** Hi List, How can I make the arserverd executable listen on a given, specific IP Address and
Re: arserverd binding to 0.0.0.0
Hi Radhika! You should do the same trick you did with the installer, to the startup script as well and start the instances manually and one at a time. If you are already doing this, it then becomes a matter of finding out where it gets the physical host name from since you have changed the HOSTNAME variable before starting each instance. Could be /etc/sysconfig/network ?? If you find out where it reads the physical host name from, then you have to change that too before starting each instance. Come to think of it, you probably also have to ensure they run in separate memory space by installing and running each instance under a separate non-root OS user. Best Regards, Theo On Fri, Feb 21, 2014 at 2:57 PM, Narayanan, Radhika radhika.naraya...@cgi.com wrote: ** Hi Theo, You're right. I managed to install the 3 AR Servers by fooling the installer as you said. But when I configure them in a server group and start the servers one after the other, the service wouldn't start. It complains armonitor.conf file cannot be found. It is looking for a folder in the Load balancer name in /etc/arsystem ! Thanks Radhika +44 20718 25880 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Theo Fondse *Sent:* 21 February 2014 15:12 *To:* arslist@ARSLIST.ORG *Subject:* Re: arserverd binding to 0.0.0.0 ** Hi Radhika! The only way you will be able to do this is to fool Remedy into thinking each instance is running on a diferent hostname by: 1) Aliasing the 3 different server names in the host file. 2) Setting the HOSTNAME variable before installing / starting each copy of ARSystem. This may or may not work, is a bit dangerous and can NOT be recommended for a production environment. Best Regards, Theo On Fri, Feb 21, 2014 at 11:05 AM, Narayanan, Radhika radhika.naraya...@cgi.com wrote: ** Hi Axton/Longwing, My first problem is that the AR Server itself is not starting when I setup 3 AR Servers in a server group on a single physical server. (ARS 8.1, RHEL 6.4) AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10 AR Server 2: Server-Name: d1, Server-Connect-Name: d11 AR Server 3: Server-Name: d1, Server-Connect-Name: d11 The 3 AR Servers are on one physical server and in a server group. d10, d11, d12 are 3 different virtual IP Addresses/Names for the physical server. AR Server service refuses to start. It complains armonitor.conf file cannot be found. *Each AR Server (arsystem startup script) is looking for /etc/arsystem/d1/armonitor.conf !!* d1 is the Load balancer = Server-Name in ar.conf. I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The server-connect-name is referred inside the armonitor.conf which is different for the 3 AR Servers! I find this architecture/requirement equally weird. It was decided by the client. They want 3 AR Servers on one physical server in a server group. I'm trying to squeeze Remedy into it now. Thanks Radhika +44 20718 25880 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* 20 February 2014 21:39 *To:* arslist@ARSLIST.ORG *Subject:* Re: arserverd binding to 0.0.0.0 ** If done properly, the rpc port mapper could work on all interfaces for all 3 servers. I say could because it's probably not been proven/done, but in theory it should work. Axton Grams On Thu, Feb 20, 2014 at 9:59 AM, Axton axton.gr...@gmail.com wrote: You could setup redirection using iptables to achieve what you want. Each server would effectively be listening on all ip addresses on different ports, but the redirection would redirect things as desired. http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/ http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika radhika.naraya...@cgi.com wrote: ** Thank you so much, Axton, Fred and others. Our client gave us one physical server with 3 virtual IP Addresses. And asked us to install AR Server on each of the virtual IP Addresses, all on *same port*. I guess I'm not able to use iptables restriction because I want to use the other IPs too , but for a second and third instance of AR Server. I'll write back to them stating that the current version of AR Server doesn't support this. Perhaps I should raise an RFE. Thanks again, Radhika +44 20718 25880 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* 19 February 2014 03:57 *To:* arslist@ARSLIST.ORG *Subject:* Re: arserverd binding to 0.0.0.0 ** Network daemons bind to address/protocol/port. 0.0.0.0 means all addresses. I looked through all the ar.conf parameters and flags supported by arserverd and it does not look like there is a way to tell arserverd to listed
Re: arserverd binding to 0.0.0.0
Hi LJ, It used to be like that, up to ~v5.x or so, but AFAIK, the issue you mentioned has been fixed. The problem used to be that ARSystem validates the server license against what it deemed the Host ID to be and the Host ID was linked to the MAC of the first NIC. The AR System server would then not start up properly if the first NIC has the wrong MAC. It was changed at some point to search for any NIC with the correct MAC. To answer Radhika's original question: AFAIK: No, you cannot bind ARSystem to a specific interface. It binds to all interfaces (0.0.0.0) by default. This is hardcoded into the arserverd code. You will have to log an RFE with BMC if you want to have this changed. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 18 February 2014 19:35 To: arslist@ARSLIST.ORG Subject: Re: arserverd binding to 0.0.0.0 ** I don't know if 'bind' is the proper term, but Remedy DOES get the MAC address of the first ethernet, and if it can't find that ethernet, I have experienced issues in the past with Remedy starting because it can't tell what the host ID should be. On Tue, Feb 18, 2014 at 10:21 AM, Grooms, Frederick W frederick.w.gro...@xo.com mailto:frederick.w.gro...@xo.com wrote: As far as I know the ARS binaries do not bind to an IP. They will bind to a TCP port if one is specified (and/or use portmapper if that is set). If you are not connecting to the AR Server one item to check is the /etc/hosts file. See if the name you used for your AR Server is listed as a valid name for an IP. If it is then check if your DNS server has it listed. Example: AR Server = arsdev01 Physical Server = devserver1 /etc/hosts file # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.1.101 devserver1 devserver1.mycorp.com http://devserver1.mycorp.com arsdev01 DNS has a cname record for arsdev01 pointing to 192.168.1.101 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Narayanan, Radhika Sent: Tuesday, February 18, 2014 7:14 AM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: arserverd binding to 0.0.0.0 ** Hi List, How can I make the arserverd executable listen on a given, specific IP Address and not on 0.0.0.0? By default, arserverd binds to the interface 0.0.0.0. My RHEL 6.4 server has 5 IP Addresses. I want it to bind only to one of the 5 IP Addresses that I mention in armonitor.conf. armonitor.conf: /apps/tim/ar/timw0/bin/arserverd.sh -s dc5chw-000 -i /apps/tim/ar/timw0 -l /etc/arsystem/dc5chw-000 In this line, the server name is mentioned as dc5chw-000. I want arserverd to bind only to this IP Address. How can I achieve this? Environment: ARS 8.1 Patch 2 on RHEL 6.4 Thanks Radhika +44 20718 25880 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Friday Special, The First Post to the ARSList
Oh boy, this does bring back memories..:-) I started With Remedy in late '96 (ver 2.1) and must have joined the list initially around '97 or '98. Even though I also have not been a frequent poster, and like Joe and Dariusz, also switched domains through the years until finally rather settling on using my personal mailbox for the list, the list has been a valuable resource for me ever since those early days - a big thanks to Dan and all the others who also post Friday Humor, good-to-know things and real solutions to issues here! If memory serves me correctly, Joe is right about the versions features - not 100% sure about the currency fields though (... it is a long time ago... :-) ), but I am sure about page tabs being introduced in v4.00 as I am currently back at the company who had the very first implementation of ARS v4.00 in my country (South Africa). I remember making the decision to design and develop their first event logging system (still running) on the new, feared and unknown v4.00 because v3.2.1. did not offer tabs and the customer expected a like-or-better GUI than the VB-based app we had to replace. At the time, I was sick and tired of battling the mess of placing and hiding fields on top of each other to make the system appear to have tabs with buttons and active links. That turned out to be the right decision in the end. :--) This company is still a 100% custom-built shop and I truly hope that it will stay that way, because custom-built shops are a dying breed in the Remedy space in my country. @ Dan: With 4214 current subscribers, you have come a long way with keeping the list going from that first lot of 27..Thanks a stack!! :-) @Dariusz: Just do a quick scan through the subject lines once in the morning and pick the topics of interest to you. There sometimes truly is too much to read each and every post Best Regards, Theo On Sun, Feb 16, 2014 at 5:42 PM, Joe D'Souza jdso...@shyle.net wrote: ** Brings back some memories too... Trim fields were introduced in version 3 I think with horizontal and vertical lines. You actually needed to check MPSO and buy an MPSO license in that version and the next in order to implement multiple processes. It was actually recognized as a feature. There were no currency fields until much later (version 4.5 I think). Good naming convention however has not lost as much importance as some of the other features have lost as others were built over them. I still think you could end up with quite a messy system with bad or arbitrary conventions. And yes Shared Workflow came in version 5.x if I recall right, and if used correctly is a very useful tool. I do not recall the exact year I joined, but it could not have been as early as mid 1998 (that was the timeframe I began with Remedy) but not as late as after 1999. I think somewhere mid 1999.. Since then I have switched a domain, and then stuck to my joe_rem...@yahoo.com address for quite a while now as its my personal address. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge *Sent:* Friday, February 14, 2014 4:21 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Friday Special, The First Post to the ARSList ** Hi Dan Fred, This brings back memories. Though I've only been a very infrequent participant in the ARSList (something I've been lately trying to change), I've been working with ARS for nearly as long. I was with Brookhaven National Lab (home of the RHIC) back in the 93-94 timeframe when we bought ARS at version (something like) 1.2b. I was the lead developer on our own project to implement our own Help Desk. In those days object names were only 30 characters in length, and the Admin tool didn't allow for detailed listing, so you only had the names to go by. Imagine (or recollect) looking at the list of, say, filters for all forms and not knowing which filter goes with which form, what triggers they'd fire on, or what order they'd fire. Good naming conventions were critical. There were no table fields and a more limited set of field data types. And if I remember correctly, no trim fields either. There also was no shared workflow, but I've come to think that shared workflow was a mistake anyway. Yes, Fred, I also remain 100% custom, though I think I installed some of ITSM once a long time ago...this doesn't count against me, does it? ;) -charlie On Fri, Feb 14, 2014 at 1:13 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I wonder how many List members are from 2000 or earlier Some of us are still 100% pure custom (no CMDB, no ITSM) Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Daniel *Sent:* Friday, February 14, 2014 3:04 PM *To:* arslist@ARSLIST.ORG *Subject:* ADM: Friday Special, The
Re: Target Attack and BMC Software ITSM?
Hi Doug! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! For finally phasing out the dreaded Demo account! I have lost count on how many times I had to defend Remedy's honour about the Demo account and countless more times having to either delete the account or set a password for that account where no one has bothered to give it a password before. Again, Thank you! Best Regards, Theo PS: I feel sorry for whomever is working at the Target IT Dept. That's some serious bad luck they had. They must be facing some tough times now. Hope things turn out OK for them and hopefully the perpetrators are brought to book soon. One can already think about some hacking Target jokes doing the rounds later... On Thu, Jan 30, 2014 at 10:19 PM, Mueller, Doug doug_muel...@bmc.comwrote: An update on this Actually, a feature change that I knew was in the works has already been done in the shipping product (I was a bit behind). Everything is still the same from the original message... EXCEPT for the Demo user. In the current release (and going forward of course), we DO NOT create a user named Demo -- you specify the user to create at installation for that initial user. So, there is no longer a Demo user to worry about. That is unless you have an older install and that user is still hanging around from that previous version -- and it is safe to remove them. So, the only known password is if WE create the DB (and again, you can do that create if you want to control even that) and we strongly recommend you change that after the initial installation. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, January 30, 2014 9:19 AM To: arslist@ARSLIST.ORG Subject: Re: Target Attack and BMC Software ITSM? Everyone, Just to be clear about the Remedy environment and passwords: 1) There are absolutely NO backdoor passwords that are used for system access that are not visible and under the control of the Administrator. 2) Since about 7.0, we have REQUIRED that you supply a password for the system users -- Remedy Application Password, DSO (there is no password for Escalator) 3) Yes, there is a default Database password to get started -- and you are encouraged to change it immediately. 4) Yes, there is a default user installed (Demo) to give a starting point -- and you are encouraged to change it or delete this user immediately (and all of the installers have been corrected for several years now to not look for a user named Demo) So, there are no secret back doors to the system that would provide access and there are only two cases where there is even a temporary default password -- if WE create the DB, we need to do something and then you change it and this can be worked around if you create the DB and give us the information AND the Demo user that is loaded to give you initial access into the system (you have to get in somehow the first time). Again, if you have not changed either of the two passwords noted here, you should do that immediately and on every system. Otherwise, there is no issue within the product around this topic. Now, there are a bunch of other security settings that I encourage you to use -- -- restrict where run processes can run processes -- control the shell under which processes can run -- use the password management feature to enforce password rules -- use the feature that disables an account after x bad password attempts (and make x a relatively small number like 5 or at most 10) -- disallow blank passwords (except for AREA cross-reference situations) -- and a number of other things We encrypt passwords on the wire. We in fact default encrypt the entire traffic on the wire (with higher levels of encryption than the default available if desired). We use a connectionless protocol with user validation at every call to ensure that you are who you say you are to prevent piggybacking connections. Remedy should not be vulnerable to attack of the kind described unless you have opened your systems to the outside and have not followed suggestions of changing the to key initial passwords (I would consider changing the DB name from ARAdmin as well just to make it that much harder to find -- and that is fully supported). Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, January 30, 2014 5:31 AM To: arslist@ARSLIST.ORG Subject: Re: Target Attack and BMC Software ITSM? I read the article and clicked on the link to the Krebs on security site. Based on that site, which may or may not be correct, it's saying that the potential BMC product is BMC Performance Assurance Agent. Since this isn't a part of Remedy I really have no idea how it
Re: [EXTERNAL] OpCat menu on Mid-Tier isn't matching WUT
Ken, Also press Ctrl-F5 on the browser after it displays the weird web-page. That forces it to request a fresh uncached copy from the server of the current page. Sometimes your proxy server also caches your web pages, (including Mid-Tier pages) which could also explain the weirdness and make it seem as if clearing the Mid-Tier (or local) cache does not help. HTH. Best Regards, Theo Fondse On Thu, Dec 12, 2013 at 5:29 PM, Cecil, Ken kce...@hubbell.com wrote: ** Yep. Forgot to mention that I did clear all the temporary internet files on the local user side and the menu is still not correct. Also, This is all users. Ken. *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Stroud, Natalie K *Sent:* Thursday, December 12, 2013 10:18 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: [EXTERNAL] OpCat menu on Mid-Tier isn't matching WUT ** Ken: Be sure to completely clear the web browser cache on the local machine after flushing the MT cache. By “completely”, I mean remove *every* file in the web browser’s cache. (For instance, with IE, this is the Temporary Internet Files folder in the logged-in user’s Windows profile). Then check again. *Natalie Stroud* SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2003 – SQL Server 2008 *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Cecil, Ken *Sent:* Thursday, December 12, 2013 8:07 AM *To:* arslist@ARSLIST.ORG *Subject:* [EXTERNAL] OpCat menu on Mid-Tier isn't matching WUT ** Today for some reason the some of the Operational Categorization menu items are missing on the Mid Tier but they are showing up properly in the windows user tool. There have been no recent changes. I tried flushing the Mid Tier cache but the menu is still not behaving correctly. Here is what I see in the Mid Tier… Here is what I see in WUT… As you can see there are supposed to be 15 items on Tier 2 when Tier 1 is “Service Request” Anybody see weirdness like this before. Any suggestions. It is ARS 7.5 ITSM 7.6 and I have fluched the mid tier. I guess I could restart it off hours but still am not sure if that will resolve the issue. Ken Cecil -- Confidentiality Requirement: This communication, including any attachment(s), may contain confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, you are hereby notified that you have received this communication in error and any unauthorized review, use, disclosure, dissemination, distribution or copying of it or its contents is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone or e-mail and destroy all copies of this communication and any attachments. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Opinions on COBIT
Hi Rick! You are right about the comparison between ITIL and COBIT, but COBIT, like ITIL, is a framework, not a solution to the problem. Back when the dinosaurs were still roaming the earth, I once did COBIT 4.1 foundation and found that it had some merit, and a couple of good things to go and implement, but, like ITIL, it's bloated with some superfluous academic surrealism that you have to filter out for yourself to make it work in real life. The foundation exam, like the ITIL foundation exam, is dumbed down to test your thought processes, grammar and comprehension of the English language with questions referring to the subject, rather than your knowledge and recollection of the subject matter itself, making it fall-out-of-a-tree easy to pass the foundation exam. That said, I would still recommend doing both ITIL and COBIT as both have some good pointers in the right direction. I remember walking out of the COBIT exam, thinking that it would be a great idea to publish a book that combines the best of ITIL and COBIT whilst aligning them, but got busy at work and never got round to it. The good news is that there are folks at ISACA who also had the same idea: http://www.isaca.org/KNOWLEDGE-CENTER/RESEARCH/RESEARCHDELIVERABLES/Pages/CO BIT-Mapping-Mapping-of-ITIL-V3-With-COBIT-4-11.aspx http://www.isaca.org/Knowledge-Center/Research/ResearchDeliverables/Pages/Al igning-COBIT-4-1-ITIL-V3-and-ISO-IEC-27002-for-BusinessBenefit.aspx In short: -COBIT is about defining and managing IT processes in general. -ITIL is about managing the IT support shop specifically. -They overlap in some areas and you have to align them yourself. -Do COBIT to compliment your SOX compliance. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 27 November 2013 00:08 To: arslist@ARSLIST.ORG Subject: Opinions on COBIT Hi all- Lately I have seen several references to COBIT and being unfamiliar with it I did some quick research. My take is that in some ways it complements ITIL and in other ways competes with ITIL at some level. I am very interested to hear what the fine folks on the list have to say about COBIT, especially anyone who is currently following the COBIT framework (or has in the past). If you prefer to contact me off-list with your thoughts I'm fine with that although I have a feeling that everyone could benefit from the responses. Thanks in advance, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy Log Parsing Utilities
WOW! Thanks LJ!! On Tue, Oct 29, 2013 at 3:51 PM, LJ LongWing lj.longw...@gmail.com wrote: ** All, I have put together a set of tools that I utilize for log parsing that has worked rather well for me personally. I presented these tools at WWRUG13 this year and everyone was happy to take a copy. I have put them out on communities, please feel free to run over there and grab a copy to play with. If you have any problems, please comment over there and I'll see what I can do to fix the issues :) https://communities.bmc.com/docs/DOC-27022 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to determine when a user last logged in
Hi Tony, This is easy if you create a simple data form and an active link that gets attached to all your active forms used by your users on Window open. I have created such a form for the same reason and it works well. You can use archiving to clear old data from this form. Also make sure you add the right permissions to the Active Link, form and fields. The entire exercise should take a matter of minutes to develop. Not a big job! For your particular purpose, you might even go a step further and create a second form that only tracks the last transaction per user in the first form and gets updated by an escalation once a day to make it easy to get a report on the info you want or to automate the account expiry workflow. I have created a couple of extra fields on the form we use, that also gets populated with standard keywords, and the stats we get from that is great! It has some other uses in terms of, for example, performance tuning, as well! The performance hit on this is negligible if you delete old data daily. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 28 October 2013 21:26 To: arslist@ARSLIST.ORG Subject: Re: How to determine when a user last logged in ** Terry, One problem I have with the BMC's provided historical license usage form is that it doesn't cover 'all' users...only users with write licenses...why does this matter you ask? Well, Read and Read Restricted users are completely valid users of the system, but because their licenses don't cost anything, BMC doesn't deign it necessary to track their usage. As such, you can't track 'all' of your users through this method. A simple Active Link that makes a service call to a login audit form any time 'selected' forms are opened will track all of your users that utilize 'main' forms. On Mon, Oct 28, 2013 at 11:30 AM, tboot...@objectpath.com mailto:tboot...@objectpath.com tboot...@objectpath.com mailto:tboot...@objectpath.com wrote: ** You can investigate this: On the ARSystem Server configuration tab - enable the field : License Tracking Peridocially check the form called ARSystem Administration: License Review form for entries (userids) that do not appear in this form that appear in your User or appropriate CTM:People form. A quick outer join would give you the details. Check the admin manual for details on the License Tracking setting. Terry on Oct 28, 2013, SUBSCRIBE ARSLIST theReel tony.r...@bt.com mailto:tony.r...@bt.com wrote: Hi Guys, Is there a way to determine when a user last logged into Remedy/ITSM without having to enable the user logs. Basically I want to identify any user accounts that have not logged into Remedy in X months. We have a multi-tenant ITSM 8.1 environment and do not have full control of our user base leaving procedures. So if someone with a Remedy account was to leave one of our customers and they do not notify us then that persons account will remain active. To mitigate against this we are planning to supply the customers with an active users report to check and want to include the last time they each logged on and any other useful information. There is the user-cache table which has a timestamp column but that only seems to be updated when the user account is updated/changed and not when they login. Any ideas how I could achieve this or how do you identify unused accounts? Thanks Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Date in the holiday list is invalid (ARWARN 625)
Hi Sashi, This could be that the last date is in the format mm/dd/yy and your server o/s has a different date format setting, or that there was invalid whitespace text in the field? Best regards, Theo On Apr 2, 2013 10:50 AM, shashidhar M S shashi.catch...@gmail.com wrote: Hi, Require your expertise again. The arerror.log file shows the below warning. Thu Mar 28 06:31:32 2013 390620 : Date in the holiday list is invalid (ARWARN 625) Thu Mar 28 06:31:32 2013 SGP0009 On checking the support group specified, we found some holiday list configured as below 01/01/08 07/04/08 11/11/08 12/25/08 Time zone: (GMT-05:00) Eastern Time (US Canada) I have removed these holiday list and there is no more warning, but want to know what was the cause for that warning. Is that due to the date specified has already expired? I mean, current year is 2013 where as holiday list refers to 2008. Thanks in Advance, Shashi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: CentOS 6.3 Installation Port Mapper Issue
Nathan, I've done many CentOS installations before without issue. Even though CentOS is not officially supported by BMC, it does work well as a development/testing environment as it is the free version of RHEL. RHEL is listed on BMC's compatibility matrix. That is why you should run production environments on RHEL and not CentOS. You have expierienced that problem probably because the built-in firewall on CentOS blocked the Remedy network traffic. This is why it is always a good idea to have Remedy run on a specific TCP port. If you want to use the portmapper, you will probably have to switch off the firewall as Remedy will probably have a different port allocated to it every time you restart it. (Which will probably be blocked by the firewall if it is running.) This is not a safe thing to do as it will open your server up to hackers and/or viruses and other malware for attack. Best regards, Theo On Apr 1, 2013 8:12 AM, munesh konda munesh.ko...@gmail.com wrote: ** Nathan, Did you check the portmapper process/daemon is running on that box. Also I am not sure whether BMC would support Remedy on CentOS as it is not mentioned in their Comp Matrix. But the Remedy would work on CentOS as it using the bin/lib of RHEL... Thanks. Regards Munesh On Mon, Apr 1, 2013 at 11:26 AM, Nathan Brandt nathanrbra...@gmail.comwrote: ** I am trying to install ARS 7.6.04 SP2 on 64 bit Centos 6.3 on top of Oracle database. For now, I am using same machine to install db, midtier and AR Server. This is what I did - Created a user in OS oracle and installed oracle database using this user at /home/oracle/app/ - Installed ARS using root user Installation goes fine, but in the end, during system validation checks, I get a message AR System Server unable to create (390600, 0) for TCP User Tool gives this error when trying to connect to AR Server. ARERR [90] Cannot establish a network connection to the AR System server RPC: Program not registered Then I did re-installation with following Register with Portmapper: NO AR System Server TCP Port Number: 8081 AR System Server Plug-in TCP Port Number: 8082 and it worked fine. Are there any issues if we we keep Register with Portmapper: YES? ~ Nathan _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARerror.log file size control
Neha, You could write your own custom Remedy application that collects the arerror.log file daily and email it to you whilst clearing its contents on the server. We have written a small Remedy application that does this and sends an e-mail and SMS (optional) to the Admin/s on duty with app server disk usage stats and the arerror.log file attached for our own purposes. Theo Fondse | Solutions Architect | metaWEAVE | Email: theo.fon...@metaweave.co.zamailto:theo.fon...@metaweave.co.za?subject=metaWEAVE:%20 | Tel: +27 (0) 12 756 4227/8 | Cell: +27 (0) 83 77 33 075 | Fax: +27 (0) 86 681 9984 | Centurion Close | Suite 2C | 119 Gerhard Street | Centurion CBD | 0157 | South Africa | [Description: cid:image002.jpg@01CD3767.7A4AE420]http://www.metaweave.co.za/ [Description: Description: MW_FB] https://www.facebook.com/metaweave [Description: Description: MW_twitter] https://twitter.com/#!/metaweave Not Sent from your BlackBerry® wireless device… -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Neha Khandelwal Sent: 26 November 2012 08:32 AM To: arslist@ARSLIST.ORG Subject: ARerror.log file size control Hello All, There is a requirement to control size of arerror.log file. Is there any option or setting available through which arerror.log file can be made empty automatically, if it size goes beyond a particular limit. OR The only option is to manually open the file and remove its contents? Thanks in advance Regards Neha ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.jpginline: image002.pnginline: image003.png
Re: If BMC Remedy had a theme song
Just found out that a band in South Africa (Seether) has a song called Remedy . (These guys are currently on-tour in the US.) This is especially for those that like post-grunge/alternative/metal genres: http://www.youtube.com/watch?v=FZLILV18ut8 Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Manuel Huerta Guillén Sent: 31 August 2012 18:57 To: arslist@ARSLIST.ORG Subject: Re: If BMC Remedy had a theme song ** Money for nothing!!! AWESOME!! Jose Manuel Huerta http://theremedyforit.com/ On Fri, Aug 31, 2012 at 6:51 PM, Howard Richter hbr4...@gmail.commailto:hbr4...@gmail.com wrote: Money for Nothing - Dire Straits _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Notification Recommendations
Kevin! I have been asked to do something similar. The only way I see this happening is with customisation, unfortunately. Will start designing this probably by next week. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Manuel Huerta Guillén Sent: 01 October 2012 18:58 To: arslist@ARSLIST.ORG Subject: Re: Notification Recommendations ** I only see two solutions without coding: - Use milestones and action of SLM: Don't like it at all, since users will see SVT attached to their incidents. - Use a generic group mail address. Then create rules at the email server (you can do it if you have Lotus, Exchange, Zimbra or similar email server). If you are going to code, The rules will easily change at the future? - Yes: Create a module to handle the rules that sends notifications. Then add a filter to HPD:Help Desk to call a service of the module at every change. - No: Create a guide in HPD:Help Desk with all rules hardcoded with filters. Then add a filter that calls the guide at every change. Jose Manuel Huerta http://theremedyforit.com/ On Mon, Oct 1, 2012 at 6:12 PM, Roger J rjust2...@aol.commailto:rjust2...@aol.com wrote: ** I will be the first to suggest you review the capabilities that Xmatters can provide. www.xmatters.com/http://www.xmatters.com/ I am not affiliated with Xmatters. -Original Message- From: Kevin Shaffer kevin_l_shaf...@hotmail.commailto:kevin_l_shaf...@hotmail.com To: arslist arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Mon, Oct 1, 2012 12:09 pm Subject: Notification Recommendations ** ARS 7.6.04 SP 4 ITSM 7.6.04 SP 2 My IT department is moving from another product to Remedy. In the current product, they currently are able to send notifications to interested parties that are not the customer, the contact, the assigned individual or the owner group. The notifications can be driven by Status, Categorization and/or Priority. For example: If Incident A has a Tier 1 of Termination and Priority is Medium and it is assigned to the Service Desk, then an external DL called HR would like to be notified. I hae been given a mandate of no customizations, but this may have to be something that slides. Is there a solution OOTB without customization? I can think of the following: 1. Hardcode Custom Filters and specify my criteria in the Run If - (Hate this option) 2. Build a custom Notification Module to allow the flexibility to build out these requirements with configuration. (Don't really have the time in the project timelines for this option) 3. Use SLM (not sure this is what SLM was intended for) 4. Upgrade to 8.x and use the RBE - Rule Based Engine (not an option to upgrade) 5. Use the Email System link on the Incident and enforce with process (there are too many processes that the service desk would need to know) 6. Other (I haven't thought of another option) Any advice would be appreciated. Thanks Kevcin _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SQL or Oracle
Sandra, Both SQL Server and Oracle are pretty stable. I prefer Oracle because of the following reasons 1) Performs faster than MS SQL under ANY load especially when you have huge databases running huge transaction volumes. 2) Has more functionality than MS SQL - especially when it comes to fine-tuning performance or monitoring what is happening on the db in real-time. 3) It Runs on more OS'es than just (Mister Slow) Windows. e.g: Linux (When running on non-Windows OS'es (like Linux), your risk level for being exposed to viruses is a lot lower.) 4) MS has too much of a monopoly - Supporting the likes of Oracle ensures one vendor does not have a total monopoly. 5) Due to Oracle not being as easy to tamper with for non-dba's, you are ensured that only the correctly skilled professionals are working on it, reducing risk of outtages due to operator error. 6) All the reasons Axton and Joe mentioned as well. 7) Case sensitivity is not such a huge issue with Oracle, as is often thought. Any DBA worth his salt CAN set up your Oracle DB to be Case-Insensitive. We do use MS SQL a lot as well for smaller low-volume implementations where budgets are very limited and fast performance is not a priority requirement. So, to pick between the two, ask yourself this: 1) Do I want best possible DB performance and granular functionality and control, that is more difficult to maintain without a DBA, at a higher cost? OR 2) Do I want a lower cost DB with an easy-to-use GUI that is limited in functionality and will have slower performance? If you do not already have an Oracle DBA and your answer for Q2 is yes, then go MS-SQL, otherwise, go Oracle. Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: 30 September 2012 05:43 To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle ** Some things I like with Oracle: - XMLGEN package: if you want to get at your AR data in xml format, this works great - Dynamic performance views: want to see what your database is, or was, doing? - Flashback capabilities: want to take a snapshot before major releases and fail back in a matter of minutes? - BCV: Want to get a copy of your database in minutes? - It runs on OS's that are not Windows (I don't care for MS as a server OS; it's my personal preference, but I loathe the mentality that a reboot is a cure-all; I like my machines to run like ... machines -- efficient, predictable, and reliable) - I can manage it without a GUI Maybe some of these things are available with MSSQL. I try to separate myself from MS technologies because they only tend to work with other MS technologies and I don't like to be boxed in. Axton Grams On Fri, Sep 28, 2012 at 4:03 PM, patchsk vamsi...@gmail.commailto:vamsi...@gmail.com wrote: ** Yes it works. We do it all the time copying db from prod to pre-production environments. It is a standard task to dbas. No special instructions needed. On Friday, September 28, 2012 12:24:40 PM UTC-7, Hennigan, Sandra wrote: BMC guide speaks to SQL but not Oracle. Can a backup of Oracle be taken and moved to another environment then ARS be made to point to the database backup? Will this be a capability with Oracle? Thank you, Sandra Hennigan Remedy Developer Criminal Division | U.S. Department of Justice ☎ (202) 353-0557tel:%28202%29%20353-0557 Mobile: 202-716-0848tel:202-716-0848 sandra@usdoj.govmailto:sandra@usdoj.gov -Original Message- From: Action Request System discussion list(ARSList) [mailto:ars...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 3:10 PM To: ars...@arslist.orgmailto:ars...@arslist.org Subject: Re: SQL or Oracle I'm not quite sure I understood your question.. What exactly is your requirement? Joe -Original Message- From: Hennigan, Sandra Sent: Friday, September 28, 2012 2:28 PM Newsgroups: public.remedy.arsystem.general To: ars...@arslist.orgmailto:ars...@arslist.org Subject: Re: SQL or Oracle Thank you, Lister. I also reviewed the archives. For you Oracle users, a question: Even with every best intention, keeping Support Group IDs, foundation data etc. matched between Test and Production is difficult so routinely, the production database is backed up and a copy moved to our test environment. Using SQL, this is a simple process. Is this an action I can take with Oracle? Sandra Hennigan Remedy Developer -Original Message- From: Action Request System discussion list(ARSList) [mailto:ars...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: ars...@arslist.orgmailto:ars...@arslist.org Subject: Re: SQL or Oracle I agree about MS-SQL being maintenance light, cheap, and at the same time a fairly robust database, which has a winning point on case sensitivity.. But
Re: 6-8 project - Remote
Hi Folks! Just had to re-open this thread... I have been quoting Matt on Fast, Accurate, Cheap Pick two for years now, but just found an interesting blog by someone named Brad Neuberg and he usess a similar, more elaborate phrase he calls square of development: features, quality, schedule, cost -- choose 3 (see: http://codinginparadise.org/weblog/2007/02/problem-with-code-bounty-sites.html) The following Wikipedia site also goes into more detail on this subject: http://en.wikipedia.org/wiki/Project_management_triangle Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 September 2012 15:17 To: arslist@ARSLIST.ORG Subject: Re: 6-8 project - Remote Yesbut I didn't hear it from manufacturing...I heard it from Carey Matthew Black :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, September 12, 2012 8:35 PM To: arslist@ARSLIST.ORG Subject: Re: 6-8 project - Remote You guys realize that it is an OLD saying right? Probably from before computers. Early manufacturing would have probably come up with it. Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.com On Mon, Aug 20, 2012 at 6:31 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: I knew I stole it from someone I respect the opinion of :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Doug Blair Sent: Sunday, August 19, 2012 4:38 PM To: arslist@ARSLIST.ORG Subject: Re: 6-8 project - Remote ** LJ, That would be: -- 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. I've also always admired that last line. It's been an effective meeting closer more that once ;-) On Aug 17, 2012, at 10:48 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: I don't remember who on the list I stole this from, but I use it ALL the time Good, Fast, Cheap. Pick Two. Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 BMC/Remedy Skilled Professional ITILv3 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: JOB: Senior Remedy Developer needed - Brooklyn, NY
Rick, Just gotta agree with your statement: Schooling will teach methodology, but experience teaches reality Excellent!! Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 28 August 2012 20:00 To: arslist@ARSLIST.ORG Subject: Re: JOB: Senior Remedy Developer needed - Brooklyn, NY ** Yeah, it is clear that the HR folks wrote this req. I have yet to see a role in Remedy that required more than maybe an A.S. in Computers, as long as some significant experience accompanied it. Schooling will teach methodology, but experience teaches reality. Rick On Aug 28, 2012 1:49 PM, Dale Hurtt dale_hu...@yahoo.commailto:dale_hu...@yahoo.com wrote: Unless I am reading it wrong, it is interesting that the City of New York considers a Master's Degree in Computer Science the equivalent of only one year of experience in industry and a Bachelor's the equivalent of only two years. Dale Hurtt 1. A master's degree in computer science from an accredited college and three years of progressively more responsible, full-time, satisfactory experience using information technology in computer applications programming, systems programming, computer systems development, data telecommunications, database administration, planning of data/information processing, user services, or area networks at least 18 months of this experience must have been in an administrative, managerial or executive capacity in the areas of computer applications programming, systems programming, computer systems development, data telecommunications, data base administration, or planning of data processing or in the supervision of staff performing these duties; or 2. A baccalaureate degree from an accredited college and four years of experience as described in 1 above; or 3. A four-year high school diploma or its educational equivalent approved by a State's department of education or recognized accrediting organization and six years of experience as described in 1 above; or ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OT: ARSLIST Signal-to-noise ratio
Dan, You are not alone on your sentiments on blogs and twitter... Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of arslist Sent: 07 August 2012 12:43 To: arslist@ARSLIST.ORG Subject: Re: OT: ARSLIST Signal-to-noise ratio ** The ARSlist has been email based for 20 years, because it is ideal for the purpose. Or at least, the use of email delivery of the discussion content is, As it is the method that can be received by the most number of people At work. Many are blocked from web sites etc. The arslist does have a searchable web based interface as well at www.arslist.comhttp://www.arslist.com (www.arslist.orghttp://www.arslist.org). Not the prettiest on the planet but it does work. You can post from there if you wish. I wrote a Remedy based system over ten years ago to provide all the functionality of listserv, but in the end it too was going to receive and send the email part as well. It was a surprisingly simple And straight forward app to create too. Seemed a whole lot easier not to maintain a custom app nonetheless. As someone mentioned BMC Communities exists as well. It is web based, and quite frankly I do not see it as an easier to use method. It does provide more focused discussions for a single area, for example what you were trying to do last week. All you have to know is precisely what part of the communities to post your question in. The ARSlist, and this will answer where you will go next, is also one spot for ALL Remedy related questions. There have been discussions For fifteen years on and off about should we have more than one list and split the discussions. Once again, my answer is always no: we are all good enough at what we do to filter out what we don’t need, and sometimes, most of the time, The Remedy world crosses lines from database, to ARsystem, to network, to OS, to ITSM code, to 3rd party apps, and if it isn’t all in one place, The flavour of the discussion gets lost. So, welcome to the first and the largest Remedy discussion group, with over five thousand end readers. Feel free to change your subscription to HTML based if you wish, mine is, because I have all the bandwidth I need and can. You will also note that I only include HTML or attachments when needed. Usually the Subject line is enough for the thread match up, so I have left your subject line in. Daniel p.s. and don’t get me started on what I think of blogs, or worse yet Twitter: the world in sound bites and out of context From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: August 6, 2012 5:42 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: OT: ARSLIST Signal-to-noise ratio snip Regards, Jose Huerta theremedyforit.comhttp://theremedyforit.com _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: how to create Incident using incoming mail
Hi DuggiReddy! Have a look at this : http://www.metaweave.co.za/products/metaweave/bidirectional.htm Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ravindrareddy Duggireddy Sent: 01 August 2012 18:17 To: arslist@ARSLIST.ORG Subject: how to create Incident using incoming mail Hi All, I am very new to ITSM; In my current remedy setup,we have to create incidents using incoming email(MAPI). How can i achieve this,please suggest me. Thanks in Advance. Regards, DuggiReddy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Running ARS on laptop - options
Hi Tauf, There have already been a lot of good advice on this thread. I'll just add my 2 cents' worth After having lots of issues with previous laptops underperforming badly, I'm currently using an old Dell Precision M6400 with 16GB RAM, two 7200RPM internal HDD's in RAID-0 (for performance) and in spite of the Dual Core 2.66Ghz CPU, I am still getting very good performance under Win7 64-bit and VMWare Player (free) when running ITSM 7.6.4 in a VM with 8.5GB RAM allocated to the VM. BMC uses VMWare themselves, so chances are good that Remedy should be more stable under VMWare if not running directly on the host, even though the likes of VBox also performs well. Fisrt, ask yourself these questions before buying the laptop: A) For how many future versions of ITSM should this laptop be good enough? B) Do you like it when a laptop makes you wait most of the time? C) Are you going to use this laptop to do development or demo's? Decide on that and then plan on how much you want to spend. There are 3 things you should spend as much as possible $$$ on for a laptop running ITSM, in this order: 1) Fastest possible performing Disk Drive (go dual internal 7200+RPM HDD's in RAID config OR preferably add a decent SDD to the mix) 2) Stupidly excessive amounts of RAM (go with a machine that can take 16GB RAM or more and put at least 8GB in it from the start) 3) The best CPU you can afford. The rest of the config on the laptop depends on personal choice. Rest assured that it is almost impossible to spend too much on any of these 3 items if you want a laptop that performs well with ITSM Buy anything less, and you'll probably be shopping for a new laptop as soon as the next major version of ITSM comes out If you can't get a good HDD, then at least get 16GB RAM or more so you can use some of that RAM to create a RAMDrive and put your ARS DB on the RAMDrive when you need the extra performance. Running ITSM straight on the host OS gives best performance, but my experience has been that since using VM's for development, demo's etc., I have had only one Blue-Screen-Of-Death episode, and only reloaded the OS once (by choice), since buying this laptop in 2009. (Some of my other colleagues with different strategies are rebuilding their laptops at least once or twice a year after having lots of BSOD's). I believe that this is due to the fact that the host OS of my laptop has the minimum stuff loaded on it (less that can go wrong with it) and new installs of other software do not affect the host OS when loading them in a VM. Hope this helps... Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Hurtt Sent: 16 July 2012 19:15 To: arslist@ARSLIST.ORG Subject: Re: Running ARS on laptop - options One of the US Army clients uses Dell Precision M6500 laptops running 64-bit Business Vista with 16 GB of RAM and the 1.6 GHz Intel i7 processor. (During installation it will complain about processor speed, but ignore it.) I run mine on the metal but others run it under VM. The latter is good if you have several configurations you want to try, but I usually do not have that requirement. Dale Hurtt ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Hi Howard! We've been using CRExport for years and have even developed a Remedy App around it that schedules reports to be run and uses an escalation to kick off the reports and optionally mail them out in .pdf attachments to users using the AR Email engine. See http://www.rainforestnet.com/crystal-reports-exporter/ Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 07 July 2012 13:18 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can look into this site: http://www.kenhamady.com/bookmarks.html The site list a comparison of tools, some free, for running, viewing, automating, etc for Crystal reports. Hope this helps. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: 06 July 2012 19:59 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Carl, Thanks. We are trying not to push out the user tool at this point. I can see some trying to open incident with it, then say the system is broken. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, July 06, 2012 2:55 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: 06 July 2012 19:46 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Happy Friday to all, I have a request to find a cheap way to run the BMC provided OOB crystal reports that came with 7.6.4. Since we use Hyperion for reporting, we do not need to create any new crystal reports and are not looking to print them. Just run them and save off the file. So I am looking for a cheap way of getting around the requirement to buy and then build a crystal server. Too bad that we can't use the user tool in ITSM 7.6.4. Any ideas? Also a Friday thought, Only Robinson Crusoe had everything done by Friday. ~Author Unknown Take care, Howard _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OT: Howard Richter's is having a kidney Transplant on the April the 17th
Howard, Our prayers are with you and your brave son! Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: 14 April 2012 02:36 To: arslist@ARSLIST.ORG Subject: OT: Howard Richter's is having a kidney Transplant on the April the 17th All, I apologies for posting something to this list that is not Remedy related. It was the only way that I could think of to contact all of the people I have worked with in the world of Remedy. I know that in my 16 years of working with the AR system, I have crossed paths with a number of the members of this great list and I just wanted to let that at 8:30am the 17th my 23 year old son will be donating his kidney to me. He graduated from college in December (with a degree in IT security) he has put his life on hold and spent his time helping my wife and I as we struggle with the loss of my kidney functions (due to some RA meds I was on in the 90s). We do dialysis at home, so I can work fulltime and he sees my struggles every day. I know that we all think our children are unique and will always do the right thing, but Andrew is the example of that. How many of us would in truth change our lives forever for someone else? He is doing this with humor and a desire to get his old man (me) off of that darn dialysis machine. Words cannot describe how proud I am of him. In a lot of ways he has set the tone on how my wife’s and I should handle this challenge we are going through. So if you have a minute on the morning of the 17th, think a good thought for me and my son. Take care and keep well, Howard Sent from Howard's iPad 2a ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Filter names question - `!
John, I agree! Hopefully BMC will do something about this? Using an object name to control how the system operates is hardly best practice. Adding a couple of flag fields on filters active links to achieve this is certainly not going to be difficult for BMC. I have had to defend Remedy's honour in the past from developers, dba's and sysadmins outside of the Remedy world for various things, but this ''worst practice is one thing that is simply not defendable Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: 06 April 2012 19:53 To: arslist@ARSLIST.ORG Subject: Re: Filter names question - `! ** I think the convention should be REMOVED... Add a flag on Filter -- Run Immediately... Approx 10 years ago -- I was brought into a big telco project to fix it After a new developer went through and renamed filters/actlinks to meet a nicer naming convention... (to work with BMCs new filtering based on COLON) Try -- troubleshooting that Old name: mtc_FindIPAddress`! New name: MTC:IP:Find_Address (in a haystack of 2000 filters -- that all got renamed) (OK - I am exaggerating the situation a bit -- but -- either way -- my opinion it is TOO WEIRD to add something to a name - and now it works different) -John On Fri, Apr 6, 2012 at 12:46 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: We are allowed that on Friday :-) This is an interesting thread though.. It would be nice to have a full list of all these small conventions that could affect functionality.. Imagine fat fingering the keyboard (although that's as likely to happen anytime too soon as as having a snow storm in the middle east) and naming a piece of workflow with these characters and have functionality affected, and not have a clue why.. Joe -Original Message- From: LJ LongWing Sent: Friday, April 06, 2012 12:30 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Filter names question - `! Ah...yes, I'll agree that * in a workflow doesn't indicate anything then :)mis-read the darn post :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, April 06, 2012 10:13 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Filter names question - `! Dee was asking about the * in the beginning of workflow names.. That in front of workflow is more the work of a developer customizing an OTB app.. While I was aware that the * at the end of field names was just a visual thing for bold fields, I wasn't aware it was because of the section 508 compliance standards.. That's a good to know and thanks for that info. -Original Message- From: LJ LongWing Sent: Friday, April 06, 2012 12:06 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Filter names question - `! The * at the beginning of the field name is a Section 508 compliance thing...it designates to visually impaired people that the field is required http://www.uspto.gov/web/offices/cio/s508/03web.htm search for the word 'asterisk' -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Dee Sent: Friday, April 06, 2012 9:27 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Filter names question - `! Thanks Joe, Like John in this post and Sam in Suggestions post last week, are these commands/tricks written any where and are there more? Looking at System Forms/Workflow, do these mean anything or just name conventions? 1. (*)At the begin of Name of workflow, ex. (*TS-SI 100 Upper Server) 2. (~!) At the end of name of workflow, ex. (AP:Sig-RecentHistoryDate~!) 3. (`1)At the end of name of workflow, ex. (XR:GetSchemaWorkflow1`1) -- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com www.kineticdata.comhttp://www.kineticdata.com/ I community.kineticdata.comhttp://community.kineticdata.com/ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
Re: Solid State Hard Drives
Peter, I use a much cheaper (and faster) alternative: RAM Drive. We have bumped up the RAM on my laptop to 16Gb and I downloaded a free RAMDrive utility that uses RAM to simulate a HDD. I then placed the ARSystem DB files of my ITSM764 VM on the RAMDrive. In spite of the fact that my laptop has 2 RAID-0 striped disks, Remedy now starts up 30% faster and rebuilding all the indexes on this ARSystem DB is approximately 6x faster (just over 1 minute). Allocating 8.5 GB RAM to the VM then makes for a ITSM 7.6.4 VM on your laptop that actually has acceptable performance. Be warned, however, there is a trade-off for the extra performance: The RAM Drive can get corrupted if your laptop is powered down unexpectedly. You need to ensure that you always shut down the VM and then the host to make sure your data is saved correctly to the image of the RAMDrive on your HDD. I also recommend using a partition with 64K file allocation blocks to store the RAMDrive image on your HDD to make sure laptop start-up/shut-down times are minimised. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 16 March 2012 23:26 To: arslist@ARSLIST.ORG Subject: Re: Solid State Hard Drives ** Modern versions are better, but you can still get corrupted sectors on SSDs. I wouldn't use one as my only disk, but as part of a SAN, if you can afford it, no problem. Rick On Mar 16, 2012 5:17 PM, Peter Romain p.romain.arsl...@parsolutions.co.ukmailto:p.romain.arsl...@parsolutions.co.uk wrote: I'd try the SSD if I was you. Cloning and replacing the hard drive in the laptop is a breeze. Paying for the SSD is painful though - ~ £460 for a 500G version here in the UK -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: 16 March 2012 13:30 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Solid State Hard Drives Peter: I have a habit of keeping a resource monitor (Windows 7 Resource Monitor or CentOS GNOME widget) running on my laptop at all times and of never using the host OS to do anything except run VMs. Given sufficient RAM (8GB seems adequate), I've found that the hard disk is almost always the bottleneck in performance, especially when running more than one VM. I've been considering buying an external esata enclosure with two 7200 RPM drives configured as RAID 0 for my work laptop. I use a similar storage configuration on my home server, and the disk bottleneck is much reduced. All that being said, SSDs have seemed pretty stable for the last couple of years. If performance similar to the RAID 0 configuration can be achieved internally, then it would be _way_ more convenient than an external enclosure. HTH, --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Peter Romain Sent: Friday, March 16, 2012 07:49 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Solid State Hard Drives Hi All, I couldn't get ITSM to run on my laptop which has an i7 processor and 8G RAM. I recently upgraded it to 16G and replaced the hard drive with a 500GB SSD. Now ITSM flies and I can run it and ADDM together in VM's and still do the normal document/email stuff. Are SSD's now sufficiently stable to use in datacenter servers? If so, would this help solve some performance issues? I'm not responsible for any servers so am just asking out of interest. Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Solid State Hard Drives
Jose, I agree with you on the theory, but have just tested this again with one of my VM's. Allocating extra RAM to MSSQL does not have the desired effect. ARS Startup times are still longer with the DB sitting on a HDD as opposed to a RAMDrive. Normal Remedy DevStudio stuff like opening HPD:Help Desk, adding a field and saving the form does take much longer - in spite of extra RAM allocated to SQL. Maybe there's more one can do to speed up MSSQL(?), but my tests so far have shown that having the ARSystem DB on a RAMDrive does provide the best possible performance on a laptop. I would not recommend the RAMDrive config for a production environment, but for a consultant/developer looking to finish his/her work soonest, the DB-On-RAMDrive is both the cheapest and fastest solution I have found so far. Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: 19 March 2012 11:40 To: arslist@ARSLIST.ORG Subject: Re: Solid State Hard Drives ** As far as I know, To have a RAM drive to feed the database engine theoretically has the same performance as giving this RAM to the database and tune to use this amount of cache. But also avoiding the counterpart of database corrupted on an unexpected power off. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 [cid:image001.jpg@01CD05DD.55310680]http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca [cid:image002.jpg@01CD05DD.55310680] http://es-es.facebook.com/pages/SM2-Baleares/158608627954 [cid:image003.jpg@01CD05DD.55310680] http://twitter.com/#!/SM2Baleares [cid:image004.jpg@01CD05DD.55310680] http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Mon, Mar 19, 2012 at 09:58, Theo Fondse t...@remex.co.zamailto:t...@remex.co.za wrote: ** Peter, I use a much cheaper (and faster) alternative: RAM Drive. We have bumped up the RAM on my laptop to 16Gb and I downloaded a free RAMDrive utility that uses RAM to simulate a HDD. I then placed the ARSystem DB files of my ITSM764 VM on the RAMDrive. In spite of the fact that my laptop has 2 RAID-0 striped disks, Remedy now starts up 30% faster and rebuilding all the indexes on this ARSystem DB is approximately 6x faster (just over 1 minute). Allocating 8.5 GB RAM to the VM then makes for a ITSM 7.6.4 VM on your laptop that actually has acceptable performance. Be warned, however, there is a trade-off for the extra performance: The RAM Drive can get corrupted if your laptop is powered down unexpectedly. You need to ensure that you always shut down the VM and then the host to make sure your data is saved correctly to the image of the RAMDrive on your HDD. I also recommend using a partition with 64K file allocation blocks to store the RAMDrive image on your HDD to make sure laptop start-up/shut-down times are minimised. Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 16 March 2012 23:26 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Solid State Hard Drives ** Modern versions are better, but you can still get corrupted sectors on SSDs. I wouldn't use one as my only disk, but as part of a SAN, if you can afford it, no problem. Rick On Mar 16, 2012 5:17 PM, Peter Romain p.romain.arsl...@parsolutions.co.ukmailto:p.romain.arsl...@parsolutions.co.uk wrote: I'd try the SSD if I was you. Cloning and replacing the hard drive in the laptop is a breeze. Paying for the SSD is painful though - ~ £460 for a 500G version here in the UK -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: 16 March 2012 13:30 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Solid State Hard Drives Peter: I have a habit of keeping a resource monitor (Windows 7 Resource Monitor or CentOS GNOME widget) running on my laptop at all times and of never using the host OS to do anything except run VMs
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Hi Gary, Jean-Louis is correct. If my memory serves me well, I have also had to do it like that in the past. Unfortunately, if you want to do this on DB level, the only other alternative in this case, would be to duplicate the data using, for example, a stored procedure, but that is not ideal nor recommended. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: 06 March 2012 20:23 To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds another point of failure. My main goal was to control as much of the process at the application level and let ARS do what it is designed to do. I have built a dblink and a view form from remedy to a remote db in the past, about 6 years ago, but in a different configuration ARS on Oracle and the external db on SQL and that worked with any issues at all. The difference was not only the order of the db servers but I also had full Server Admin rights, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J john.j.rei...@lmco.com wrote: Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst 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 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Re: Resolved: Error: Installing Approval Server Assignment Engine 7.5P4
Hi RemedyAdmin, If you put the ALIAS as an alternate server name in the /etc/hosts file for the localhost BEFORE starting the install, it should work with Server-Name = ALIAS. e.g.: 127.0.0.1 localhost ALIAS Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RemedyAdmin Sent: 16 February 2012 23:16 To: arslist@ARSLIST.ORG Subject: Resolved: Error: Installing Approval Server Assignment Engine 7.5P4 Resolved... Assignment Engine and Approval Server failed to install below because the installer cannot resolve the aliases. It is recommended to install with hostname, then change the Server-Name to alias in ar.conf and armonitor. Note: All other components installed with Alias successfully. So during installation, on the GUI Existing AR System Server, enter AR System Server Alias = HOSTNAME and NOT ALIAS. Then to ar.conf, change Server-Name = ALIAS Domain-Name = company.com Server-Connect-Name = hostname.company.com RemedyAdmin wrote: I'm getting the below error upon installation of the 7.5p4 approval server component only, on aix 6.1. 10g. on the GUI: Enter Admin User Info Entered: ServerAlias: XXXalias Hostname/IP: XXXalias Install GUI Title Gui: Approval Server Dependency Failed to detect AR System Server alias XXXalias and can not proceed woth installation of featureApprovalServer. Install.log LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[APPROVAL_SERVER_UPGRADE_DEPENDANCY_ME SSAGE4[String:XXXalias,String:featureApprovalServer]]} (Feb 09 2012 06:59:03.604 PM -0500),CONFIG,com.bmc.install.builder.installanywhere.InstallationTask Action, WHAT IS THE DEPENDENCY? __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- View this message in context: http://old.nabble.com/Error%3A-Installing-Approval-Server-7.5P4-tp33297459p9030.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy forms
Hi Remedy! Try the following SQL statement on your Remedy server database: select name from arschema Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: 17 February 2012 08:09 To: arslist@ARSLIST.ORG Subject: Remedy forms ** Hi All, Can anyone please share the list of form name's available in the Remedy system ( for any version ). -- Thanks Regards _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Overlay and Applications
John, Firstly, the 3/4 GL differentiation is important to appreciate in this regard, and therefore, relevant. The Action Request System platform *IS* a 4GL and as such it is not fair to do direct comparisons to functionality or ways of working that we find in 3GL environments such as Java, C, VB or even .Net. ARS allows someone with no programming background whatsoever, to create working, usable applications within a matter of hours. No 3GL does that. ARS just sits in a different niche of the market. Secondly, my open challenge still stands to any 3GL platform to develop a working functional and customisable client/server workflow application from scratch, in less time than with ARS, that (to name only a few) a) can run on Windows, Linux and Unix and be migrated between all these within a matter of minutes b) has a native and web front-end capable of Query-by-Example or advanced search criteria c) is capable of full customisable application and data permission structures d) is capable of handling more than 200K records in all tables (meaning integration to a mainstream RDBMS and not using ODBC) e) is integrateable to other systems using an open API amongst about 19 (or more) other mechanisms. Even Java can try with EJB's... Thirdly, Yes, having done a lot of scripting development outside of ARS using 3GL platforms such as COBOL, Java, VB etc, I too, have been frustrated by some of the development (and source control) limitations posed by ARS in the past since starting out with Ver 2 in late '96, but the platform has grown significantly since then especially with the bold move to the new eclipse-based DevStudio (Hats off to Doug and the team). Conversely to your statement, one could also argue: I don't see why AR System developers should be placed into a box and told they must do things the way those in the 3GL world does it There are a number of tools available to compare different copies of code (such as Remedy Migrator). We just have to be patient and give Doug and the boys more time to slicken up the new overlay and version control functionality. Lastly, To answer your question can anyone think of a disadvantage with taking workflow from the schema and into scripts?: Having to debug large workflow systems, sometimes cold-faced, after things have gone wrong, is a huge and daunting task. Doing this with having the ARS code in db tables has turned out to be a heaven-sent thing for me. This is because a) you can run customised sql scripts in one place on the ARS Code to find out within seconds where the fault could be in the code or to see what code is related to what. Scripts won't give you that. b) you can run customised sql scripts in one place on the ARS Code to find form/workflow objects you should re-use within seconds. Scripts won't give you that. c) you can run customised sql scripts in one place on the ARS Code to document your system or specific portions of it. Scripts won't give you that same type of flexibility. Furthermore, scripts pose other disadvantages: d) a single backup command backs up all your data and all your code in one managed location. Storing scripts across multiple ssh connected servers will make it difficult to back up or replicate your system elsewhere e) ARS (with it's table based code storage) provides functionality to limit permissions to view or change code. Scripts stored on a filesystem pose a security vulnerability of being overwritten, deleted or infected by viruses as well as access to view it's contents by unintended individuals. f) Managing a code base where your code lies in scripts across multiple locations can be costly on time as opposed to have everything in one spot. I agree with you that we should keep on looking for better ways to do things, but ARS would not have come as far as it has done if it did not provide a huge positive netto balance of advantages as opposed to it's cost and disadvantages. To throw something out because we have newer different ways of doing the same thing would be like stopping traditional procreation activities because we have invented artificial insemination. The way ARS is designed around storing it's code may not be 100% perfect, but my vote is to keep the code in the tables. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: 12 January 2012 21:37 To: arslist@ARSLIST.ORG Subject: Overlay and Applications Guillaume I do take onboard your points but I have to disagree: AR System provides no version control. If you believe it does, please tell me how I revert a form to its state at any point in time since AR System was installed, and no, taking hourly backups of my database isn't a useful step forward. I don't feel the 4/5/6GL discussion is relevant to my post (and it's not something I really recognise now-a-days). I'm talking about how to improve the
Re: Overlay and Applications
John, On your reply: a) That is still a challenge with scripts scattered across different servers - even with source control b) You would not be able to customise the output into the format you need for a specific purpose. The show references functionality is not as flexible or extensible as a sql statement. c) If you read my sentence on scripts for this point again, you'll see I referred to flexibility - not if it can or can not be done. My point here was that (even though scripts themeselves are much more flexible as you rightly pointed out than filters or active links) the electronic generation of documentation about scripts is a bit rigid and not as flexible or extensible as a sql statement. d) Ever migrated (or re-deployed a copy of) an application based on scripts spanning across multiple servers (code and data all at once)? it's a lot easier, quicker and more reliable to backup and restore a single database. If BMC does consider your suggestion to rather compile scripts, I would suggest that they are indeed stored in a DB to make migration much less of a pain. We will lose the performance benefit if AR server checks out code live-on-the-go from another system. e) It is a bit bizarre to suggest that There's no useful purpose for permissioning code between different users - it cuts out finger-pointing and politics between developers and in certain environments like certain governmental orgs, you have to use permissions to comply to job segregation and security policies. f) Although source control systems goes a long way to centralize access to code, it does not guarantee unauthorised code changes with scripts scattered across different filesystems. I agree that an ITSM 7.6.4 implementation has become a bit heavy for a desktop to handle (esp. on RAM), but all serious enterprise-class systems have sadly gone that way over the years...but BMC can remedy this to an extent (please excuse the pun) by optimising the code for the OOTB modules. One idea that your suggestion have sparked in my mind is that it would possibly be nice to have a tool that can look at Remedy code and generate a Java app/code from that. This will allow ARS to be used as a rapid prototype modelling tool for Java projects...? If, coming from a Java programming background for instance, you still prefer using scripts, that's ok, Remedy has the ability (albeit limited) for you to do that in certain instances, like using the filter scripting library (See https://communities.bmc.com/communities/docs/DOC-63) (as I've used in the past myself), web-services or even run-process actions executing your local scripts, but I would still argue that the way ARS handles it's own code has it's benefits and it's place under the sun and that we need not change ARS in this regard. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: 13 January 2012 13:53 To: arslist@ARSLIST.ORG Subject: Overlay and Applications Theo, Lastly, To answer your question can anyone think of a disadvantage with taking workflow from the schema and into scripts?: (a) Or you can use one of a million tools, such as grep. (b) Yes, they do. Any good plugin to Eclipse or whatever will have a show references. (c) Yes, they do. It is a bit bizarre to suggest you can't document scripts, when they are infinitely more flexible. Furthermore. (d) If that is a serious concern, they can be stored in a database. However, it's really not hard to copy a package (a single zip file) between different AR System instances when you deploy an application. Or tell AR System to check it out of svn/git/etc. (e) There's no useful purpose for permissioning code between different users. If you want to allow user input, that's what the database is for - to hold user/application specific information. Comment about viruses is bizarre; this is how the rest of the world operators, so I don't see why it's a concern to ARS. (f) I refer you to a source control system. I'm afraid I can only bring you back to my original point: Storing workflow code as scripts makes far more sense, brings AR System into a new world where it can make use of the countless source control systems and tools available to everyone else, and can be achieved without changing the UI. Since I started this discussion, I've thought of another superb advantage. Once the workflow isn't stuffed into the scheam, AR System will be far more efficient. A standalone AR System instance should be able to run on a desktop machine, connect to a database, and read local workflow scripts. One can finally develop a solution without having to negotiate for control of workflow with others in the team. This single change would vastly reduce costs for BMC when developing ITSM, assuming there is more than one person working on the product. John
Re: Overlay and Applications
David, Thanks for this, I'll definitely give Mendix a look. I know there are lots of other Rapid development tools out there, but My point with this was that Remedy, as a 4GL, is flexible, powerful and limited - all at the same time, but the way it does things have certain merit to it and is not fair to expect ARS to give everything the 3GL world offers and in the same way, as it has it's niche area where it sits with its own set of real benefits in spite of certain limitations. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Sanders Sent: 13 January 2012 15:23 To: arslist@ARSLIST.ORG Subject: Re: Overlay and Applications Theo ARS is not the only rapid development platform. For example, take a look at this http://www.youtube.com/watch?v=FWUb_4XqHcwfeature=player_embedded This is Mendix (http://www.mendix.com) which is an example of the new breed of agile development tools. Source control, yes; PaaS, yes; SaaS, yes; Cloud or On-site deployment, yes... etc. Windows, Linux, yes; migrate between platforms, yes; proper permissions modelling, yes; scalable, yes ... I'm a good Remedy developer, but I can develop apps 2 or 3 times as quickly on this platform as I can in Remedy. We have a full ITSM suite written in both ARS and in Mendix - virtually identical functionality. Some things are easier in ARS, many more are easier in Mendix, and one of the things I really like about Mendix is that it has a fully-normalized data structure. Not scripts for workflow, but visual modeling, but with full version control. There are other platforms out there too - so if what you want is rapid and agile development tools, take a broader view of what's available in the Market, it's not just 3GLs Regards David Sanders Solution Architect Enterprise Service Suite @ Work == tel +44 1494 468980 mobile +44 7710 377761 email david.sand...@westoverconsulting.co.uk web http://www.e-servicesuite.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Friday, January 13, 2012 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Overlay and Applications John, Firstly, the 3/4 GL differentiation is important to appreciate in this regard, and therefore, relevant. The Action Request System platform *IS* a 4GL and as such it is not fair to do direct comparisons to functionality or ways of working that we find in 3GL environments such as Java, C, VB or even .Net. ARS allows someone with no programming background whatsoever, to create working, usable applications within a matter of hours. No 3GL does that. ARS just sits in a different niche of the market. Secondly, my open challenge still stands to any 3GL platform to develop a working functional and customisable client/server workflow application from scratch, in less time than with ARS, that (to name only a few) a) can run on Windows, Linux and Unix and be migrated between all these within a matter of minutes b) has a native and web front-end capable of Query-by-Example or advanced search criteria c) is capable of full customisable application and data permission structures d) is capable of handling more than 200K records in all tables (meaning integration to a mainstream RDBMS and not using ODBC) e) is integrateable to other systems using an open API amongst about 19 (or more) other mechanisms. Even Java can try with EJB's... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: POLL: would you like the user tool back (7.6.04)
yes yes yes Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: 03 January 2012 16:11 To: arslist@ARSLIST.ORG Subject: POLL: would you like the user tool back (7.6.04) ** Curiosity poll: Of those who have tested, or used 7.6.04 ((only)) please: Would you like to see the user tool come back? (don't need comments:: just yes or no: OR yes yes yes to show your support is allowed.. lol) yes or no: I am not saying it is going to happen: I am not giving any indication it ever will ! I know nothing:: just asking.. -- Patrick Zandi _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Log File Editor....
You're welcome! Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller Sent: 09 November 2011 21:56 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor That's pretty sweet Theo! Thanks for sharing! Drew Comayagua ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Log File Editor....
Notepad++ also has a neat FTP plugin that allows you to access files on a unix box with an 'explorer type tree view' of the folders on the ftp site. Only downside is that you have to double-click on the file in the ftp-snap-in-window each time you want to see if the file has changed in the meanwhile... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: 07 November 2011 21:20 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** Oh, yes - the ability to register a site's ftp login and edit files directly without the extra down/up load steps is also a pleasure, particularly for doing quick website work. Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Monday, November 07, 2011 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** UltraEdit can, I believe. I know it can use (s)ftp to transfer files and I know it can monitor the files that it has open to see if they change. I honestly have to say I don't recall trying to monitor a unix file through ftp but I am fairly confident that it can. On Mon, Nov 7, 2011 at 11:08 AM, Larry Barnes larry.bar...@thecreek.commailto:larry.bar...@thecreek.com wrote: ** Thanks Theo. I was thinking it was an xml file created by Remedy? I missed your earlier post. Thanks again! Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, November 07, 2011 10:04 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Log File Editor ** Larry, It's attached to one of my earlier posts today, but check out the attachment on this one again... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes Sent: 07 November 2011 19:17 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I'm somewhat new to Remedy and I've been introduced to Notepad++; great tool. I'm curious about the xml file discussed below (userDefineLang.xml file); where do I find this file? Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: Monday, November 07, 2011 7:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Log File Editor ** Trying out Notepad++, thanks Theo. Note that rather than changing your APPDATA setting, you can instead go to View - User Defined Dialogue... Use 'Create New' to create a Remedy entry, then import your .xml file. Setting the Language to your Remedy entry then provides the highlighting you created. Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777tel:734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.comhttp://www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, November 07, 2011 5:09 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use either baretail or Notepad++ (http://notepad-plus-plus.org/) for most log files and have created a Notepad++ user defined language descriptor for some Remedy related files a couple of years ago. This colour-codes the files for easy reading. The following files are included: Remedy .Def
Re: Log File Editor....
I use either baretail or Notepad++ (http://notepad-plus-plus.org/) for most log files and have created a Notepad++ user defined language descriptor for some Remedy related files a couple of years ago. This colour-codes the files for easy reading. The following files are included: Remedy .Def Remedy .Cfg Remedy .Log Remedy .Arr Remedy .Arq Remedy .Arm Notepad++ can also auto-detect file changes and prompts you to reload the file once you bring it into focus. You can also force it to reload an open file with two mouse clicks. Old log entries can also be removed without having to switch off the logging in Remedy. (This way you keep the log file small manageable whilst debugging a process.) To configure Notepad++ to use this: 1. Add the userDefineLang.xml file to the Notepad++ install dir 2. Disable the use APPDATA setting 3. Restart Notepad++ HTH... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: 05 November 2011 22:51 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use UltraEdit. You can create a language file for AR log files if you wished. As well as it has some great macro functionality. I have macros that remove an entries that didn't perform work which makes the log file MUCH easier to use. It also allows javascripts also, but I haven't done much with that. There is also a tool out there called Jedit and it is written in java and might allow interface with the Remedy API which would allow some really impressive stuff to be done with a log file. But I haven't really played with that one either. HTH, Brian Goralczyk On Sat, Nov 5, 2011 at 8:22 AM, Jarl Grøneng jarl.gron...@gmail.commailto:jarl.gron...@gmail.com wrote: I`m using BareTail BareGrep, http://www.baremetalsoft.com/baretailpro/index.php http://www.baremetalsoft.com/baregreppro/index.php -- J 2011/11/4 Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us: ** Does anyone have a recommendation for a good, flexible log file editor? Ideally, one that can be configured specifically for Remedy log viewing? Thanks for any suggestions... 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. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are -- Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.commailto:bgoralc...@gmail.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are userDefineLang.xml Description: userDefineLang.xml
Re: Log File Editor....
Thanks Kelly! Yes, this is also possible. Thanks for the reminder! I had problems with this method on the first version of Notepad++ I used and therefore reverted to the APPDATA setting method, but I suppose that those issues have long been resolved with all the versions that have been released since then :-) Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: 07 November 2011 17:16 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** Trying out Notepad++, thanks Theo. Note that rather than changing your APPDATA setting, you can instead go to View - User Defined Dialogue... Use 'Create New' to create a Remedy entry, then import your .xml file. Setting the Language to your Remedy entry then provides the highlighting you created. Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, November 07, 2011 5:09 AM To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use either baretail or Notepad++ (http://notepad-plus-plus.org/) for most log files and have created a Notepad++ user defined language descriptor for some Remedy related files a couple of years ago. This colour-codes the files for easy reading. The following files are included: Remedy .Def Remedy .Cfg Remedy .Log Remedy .Arr Remedy .Arq Remedy .Arm Notepad++ can also auto-detect file changes and prompts you to reload the file once you bring it into focus. You can also force it to reload an open file with two mouse clicks. Old log entries can also be removed without having to switch off the logging in Remedy. (This way you keep the log file small manageable whilst debugging a process.) To configure Notepad++ to use this: 1. Add the userDefineLang.xml file to the Notepad++ install dir 2. Disable the use APPDATA setting 3. Restart Notepad++ HTH... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: 05 November 2011 22:51 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use UltraEdit. You can create a language file for AR log files if you wished. As well as it has some great macro functionality. I have macros that remove an entries that didn't perform work which makes the log file MUCH easier to use. It also allows javascripts also, but I haven't done much with that. There is also a tool out there called Jedit and it is written in java and might allow interface with the Remedy API which would allow some really impressive stuff to be done with a log file. But I haven't really played with that one either. HTH, Brian Goralczyk On Sat, Nov 5, 2011 at 8:22 AM, Jarl Grøneng jarl.gron...@gmail.commailto:jarl.gron...@gmail.com wrote: I`m using BareTail BareGrep, http://www.baremetalsoft.com/baretailpro/index.php http://www.baremetalsoft.com/baregreppro/index.php -- J 2011/11/4 Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us: ** Does anyone have a recommendation for a good, flexible log file editor? Ideally, one that can be configured specifically for Remedy log viewing? Thanks for any suggestions... 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. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are -- Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.commailto:bgoralc...@gmail.com _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_
Re: Log File Editor....
Larry, It's attached to one of my earlier posts today, but check out the attachment on this one again... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes Sent: 07 November 2011 19:17 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I'm somewhat new to Remedy and I've been introduced to Notepad++; great tool. I'm curious about the xml file discussed below (userDefineLang.xml file); where do I find this file? Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: Monday, November 07, 2011 7:16 AM To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** Trying out Notepad++, thanks Theo. Note that rather than changing your APPDATA setting, you can instead go to View - User Defined Dialogue... Use 'Create New' to create a Remedy entry, then import your .xml file. Setting the Language to your Remedy entry then provides the highlighting you created. Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, November 07, 2011 5:09 AM To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use either baretail or Notepad++ (http://notepad-plus-plus.org/) for most log files and have created a Notepad++ user defined language descriptor for some Remedy related files a couple of years ago. This colour-codes the files for easy reading. The following files are included: Remedy .Def Remedy .Cfg Remedy .Log Remedy .Arr Remedy .Arq Remedy .Arm Notepad++ can also auto-detect file changes and prompts you to reload the file once you bring it into focus. You can also force it to reload an open file with two mouse clicks. Old log entries can also be removed without having to switch off the logging in Remedy. (This way you keep the log file small manageable whilst debugging a process.) To configure Notepad++ to use this: 1. Add the userDefineLang.xml file to the Notepad++ install dir 2. Disable the use APPDATA setting 3. Restart Notepad++ HTH... Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: 05 November 2011 22:51 To: arslist@ARSLIST.ORG Subject: Re: Log File Editor ** I use UltraEdit. You can create a language file for AR log files if you wished. As well as it has some great macro functionality. I have macros that remove an entries that didn't perform work which makes the log file MUCH easier to use. It also allows javascripts also, but I haven't done much with that. There is also a tool out there called Jedit and it is written in java and might allow interface with the Remedy API which would allow some really impressive stuff to be done with a log file. But I haven't really played with that one either. HTH, Brian Goralczyk On Sat, Nov 5, 2011 at 8:22 AM, Jarl Grøneng jarl.gron...@gmail.commailto:jarl.gron...@gmail.com wrote: I`m using BareTail BareGrep, http://www.baremetalsoft.com/baretailpro/index.php http://www.baremetalsoft.com/baregreppro/index.php -- J 2011/11/4 Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us: ** Does anyone have a recommendation for a good, flexible log file editor? Ideally, one that can be configured specifically for Remedy log viewing? Thanks for any suggestions... 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. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp
Re: Barcode Scanners
Hi Vishwa! We use this system a lot for doing fast Asset Audits, but it also works with receiving/dispatching goods etc.: Key Features Benefits Provides a simple, fast barcode scanning user interface to your Service Desk to significantly improve the time required for the following actions: o Goods Received, Physical Asset Audits, Installs, Moves, Additions of infrastructure, Changes of configuration topology, Decommissioning of infrastructure. o Tracking “Break Fix”, “Break and Replace” and “Break and Loan” asset movements. Runs in real time mode for up to date asset and inventory location tracking Includes population of items as well as topology (relationships) linking between Configuration Items to the CMDB Backend workflow is configurable based on business rules per client and per action Has offline functionality with auto sync once the connection is re-established Input to staging tables for data accuracy verification (configurable option) Voice prompt command verification (configurable option) “Repeat scan” option for rapid scanning of multiples of the same item Associate “parent – child” equipment relationships and allow them to be moved as a single entity Provides audit trail history Works with basic and complex barcodes as well as RFID’s. It consists of a Remedy ARS application module and a windows application installed on any workstation (we use those small netbooks) to connect your own scanner device to. I will send you a summary doc off-list. Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of anurag saxena Sent: 03 October 2011 16:48 To: arslist@ARSLIST.ORG Subject: Re: Barcode Scanners ** Hi Theo, There is similar need in my organization; can you please explain the setup to integrate Barcode stuff with Atrium? Thank you in advance. Best Wishes, Vishwa AON Hewitt | Remedy Lead img src=http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif;font color=#4040ff face=systemHAVE A NICE DAY/font From: Theo Fondse t...@remex.co.za To: arslist@ARSLIST.ORG Sent: Monday, October 3, 2011 4:51 PM Subject: Re: Barcode Scanners ** We wrote our own barcode scanning solution and integrated it with Atrium. Best Regards, Theo Sent from my Black/Silver Personal Computer “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: 30 September 2011 15:06 To: arslist@ARSLIST.ORG Subject: Barcode Scanners ** Anyone out there in ARS land familiar with the Grabba barcode scanners? Feedback? -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG11 www.wwrug.comhttp://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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Barcode Scanners
We wrote our own barcode scanning solution and integrated it with Atrium. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: 30 September 2011 15:06 To: arslist@ARSLIST.ORG Subject: Barcode Scanners ** Anyone out there in ARS land familiar with the Grabba barcode scanners? Feedback? -- Warren R. Baltimore II Remedy Developer 410-533-5367 _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
Re: IP Provisioning Applet
Hi Doug! If you do manage to find it, I am also interested in a copy, please? Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tanner, Doug Sent: 05 August 2011 18:55 To: arslist@ARSLIST.ORG Subject: IP Provisioning Applet ** arslist, Anyone have a Remedy built application to manage IP provisioning and would be willing to share? I wrote one many years ago, but cannot locate it. Thanks in Advance, Doug This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx _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 inline: image002.gif
Re: ARS Illustrator
Hi Kirill, One feature you might want to add is for the application to remember the last folder used when opening up a file. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid Sent: 28 July 2011 09:36 To: arslist@ARSLIST.ORG Subject: Re: ARS Illustrator Hello guys, I am working on a first release version now to present it officially. I guess it will be ready in a month. So I am looking for a little feedback here. Any ideas are wellcome :) Best regards, Kirill. Kirill Eitvid wrote: Hi, I am working on the project, which goal is to make ARS development a little bit easier. It's called ARS Illustrator. Here is a very short introduction: 1. ARS log files visualisation. This is a GUI tool, which parses ARS logs and generates several views: tree view, sequence diagram view, time tracking view, source view and related objects index. Also you can save workflow model to XML. Beta version is done now. Although I work in German company, so it handles only German log files now. 2. ARS Project Bay. This is a database with GUI access, which is a nice place to keep all information about your use-cases: requirements, technical documentation and tests. It can easily replace tools like testbench in you process. Also if you don't mind turning on logging while testing your application, it will create relations between workflow objects and test-cases. This gives you additional benefits like test-case relations, workflow coverage tracking, automatic regression tests planning etc. This should be finished around December this year. The thing is I am not quite sure that my company will use it at all. I would like to know whether anybody of you is interested to use this kind of technology in your projects, so this work makes any sense. Please feel free to ask any questions. And here are a few screenshots of beta version: http://old.nabble.com/file/p32137640/screen01.jpg http://old.nabble.com/file/p32137640/screen02.jpg -- View this message in context: http://old.nabble.com/ARS-Illustrator-tp32137640p32154349.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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
MS TechNet vs. RKM Integration
Hi Folks! I was wondering if there is anyone out there whom have done MS TechNet vs. RKM Integration before? Best Regards, Theo Fondse | Senior Consultant | Remedy Integrated Solutions, member of the Remex Group | Email: t...@remex.co.zamailto:t...@remex.co.za | Tel: +27 (0) 12 756 4227/8 | Cell: +27 (0) 83 77 33 075 | Fax: +27 (0) 86 681 9984 | Centurion Close | Suite 2C | 119 Gerhard Street | Centurion CBD | South Africa | [cid:image002.jpg@01CC4218.106FC330] visit us at www.remex.co.zahttp://www.remex.co.za/ Try not to become a person of success, but a person of value. - Albert Einstein ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are inline: image001.jpginline: image002.jpg
Re: Excel frustration with AIE and Data Imports
Hi Ron! CSVed is a small freeware tool and automatically keeps the leading zeroes. As a consultant working across many projects where you are confronted with requests to import data into Remedy from various legacy systems (that can only provide .csv files), you frequently get a lot of .csv files that must be checked for data quality and possibly minor manual correction before it can be fed to the Import Tool. So, I was looking for a small app that could allow me to view edit .csv files without having to have to use Excel with all it's overboard automatic features such as truncating zeroes . CSVed was the closest thing I could find. It is function-rich, but it's version of direct editing is not as direct as I would like. I use it every now and then if I get large .csv files that I browse but do not need to edit. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 29 June 2011 21:20 To: arslist@ARSLIST.ORG Subject: Re: Excel frustration with AIE and Data Imports ** All, Thank you for your responses. Michelle, thanks for listing out the steps. I was somewhat aware of this process, but felt there were too many clicks to make it worth the effort. BUT, you are correct, once I do it enough times, it becomes second nature. This is especially useful with large files. Theo, This tool looks pretty cool and could be exactly what I am looking for. I looked over the website, but I cannot download it where I am currently working. Will need to give it a try when I am home. Have you used it? Can you confirm that it can retain the leading zeros without having to go through a bunch of steps? Also, is there a cost or is this freeware? Thanks, .ron On Wed, Jun 22, 2011 at 1:39 PM, Theo Fondse t...@remex.co.zamailto:t...@remex.co.za wrote: ** Hi Ron! You could try CSVed to see if it works for you: http://csved.sjfrancke.nl/index.html Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 22 June 2011 15:31 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Excel frustration with AIE and Data Imports ** Good Morning Listers, You how when you open a .csv file in Excel, Microsoft will do it's magic and start changing the format of certain values? As an example, it will drop the leading zeros form a value because it assumes it is numeric, (like a serial number). So you have to fix the data, format the column as 'text' and save the file. Then, the next time you open the file, the process starts all over again. I know I can use notepad to edit, but that is a pain. So I have two questions: 1) Is there a way to set a preference in Excel to say Hey! don't do that! 2) Assuming the answer to question one is no, is there another tool out there that works like Excel but is geared toward developer geeks? Sort of like what Notepad is for Windows, except it would display the data in column/row. I know I would really like a tool like that. Thanks, .ron _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.comhttp://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
Re: ADM:Arslist is up and running, Web is working, archives are back
Thanks Dan!!! Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom Sent: 27 June 2011 22:35 To: arslist@ARSLIST.ORG Subject: ADM:Arslist is up and running, Web is working, archives are back ** Seems a quiet day on the list. Just formally saying: We are on a new server, everything appears functional and stable. List is up. Daniel Founder of the ARSlist _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
Re: arserver.exe is consuming 100% cpu - possible DB corruption? (Long Post)
Hi John! Just a thought: Disable escalations in the ar config file and restart the server - what happens? If the server runs fine (for, say, 15-30 min after starting up), back up all escalations to a .DEF, delete them, stop ar server, enable escalations, restart the server and start importing escalations 1 at a time to see which escalation(s) are causing the problem. Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: 27 June 2011 23:27 To: arslist@ARSLIST.ORG Subject: arserver.exe is consuming 100% cpu - possible DB corruption? (Long Post) Hello Listers, ARS 7.6.03 MS 2003 Enterprise MS SQL 2005 (remote) Total home grown system. No OOTB modules. I have a real stumper here. It even has BMC scratching their heads. I have a production system that is experiencing cpu overload that runs up to 99 in the processes and sits there. The ARSystem server is virtual machine. We thought maybe it was a MS Patch Tuesday issue and we removed the 10 recent MS patches one at a time and restarted the machine each time. The problem still exists after the arserver service starts. Sometime immediately and sometimes it will sit for 1- 20 minutes before it starts to hog the CPUs. To eliminate any other OS and file system issues we grabbed a two week old backup image of the server and restored it. The system came back ok for a short while and then started to lock up the CPU again. Working with BMC I set the logs on and restarted. We saw the system jump to 100% within a minute and captured a 10MB arsql.log file. It can force the overload at anytime by firing filter workflow with a notification action in it. I disabled this one filter but the system still loaded up. I added a Filter that ran a 0 and the only action was Goto 1000 to jump all Filter actions that fired on the change of the Status field in question. Still no joy. I've disabled every piece of Notify workflow. That worked the best and kept the system alive for longer stretches but we can't run a system that way. I've come to the realization that there may be corrupted information in the DB object tables and I wanted to get some feedback. Using rrrChive I can pull a copy of every form's data since, say, two weeks ago. Then have the DBA restore the entire system from that date. After the restore I would use rrrChive to reload the two weeks' data (Modified date' 06/11/2011) and hope for the best. Any workflow that was changed in the last two weeks is negligible and could be recreated/updated as needed. Do you think this is a viable solution? When I asked the BMC tech if I could dump the T,H B tables ; restore the db and reload the T, H B tables he reminded me that the arschema and other meta tables would probably be out of synch. That's when I thought of using rrrChive. Sorry to be so long winded but I need to get this back online, BMC can't find anything in the logs and I don't want to lose the tickets we've taken in the last week. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst 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 ___ 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
Re: Excel frustration with AIE and Data Imports
Hi Ron! You could try CSVed to see if it works for you: http://csved.sjfrancke.nl/index.html Best Regards, Theo Sent from my Black/Silver Personal Computer Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 22 June 2011 15:31 To: arslist@ARSLIST.ORG Subject: Excel frustration with AIE and Data Imports ** Good Morning Listers, You how when you open a .csv file in Excel, Microsoft will do it's magic and start changing the format of certain values? As an example, it will drop the leading zeros form a value because it assumes it is numeric, (like a serial number). So you have to fix the data, format the column as 'text' and save the file. Then, the next time you open the file, the process starts all over again. I know I can use notepad to edit, but that is a pain. So I have two questions: 1) Is there a way to set a preference in Excel to say Hey! don't do that! 2) Assuming the answer to question one is no, is there another tool out there that works like Excel but is geared toward developer geeks? Sort of like what Notepad is for Windows, except it would display the data in column/row. I know I would really like a tool like that. Thanks, .ron _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
Re: Data validation checks when user uses the Modify All option in the client
Hi Debra! Remember to also consider the use of TR vs DB values of your fields when designing Filter Run-If qualifications. I would definitely also suggest to convert some active links to filters in this case. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson Debra (PRN) Sent: 14 June 2011 23:48 To: arslist@ARSLIST.ORG Subject: Re: Data validation checks when user uses the Modify All option in the client I agree with Fred filters really are the only option I can see working. However, has anyone ever seen a case where set fields doesn't seem to work across all records selected for Modify All. Do you know if any issue with how fields are set - via SQL query vs. regular form query? Thanks Debra -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 14, 2011 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Data validation checks when user uses the Modify All option in the client Filters are the only way to go to validate data during Modify All. All Set Fields used to pull in data (needed for validation) should also be in the Filters. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson Debra (PRN) Sent: Tuesday, June 14, 2011 3:52 PM To: arslist@ARSLIST.ORG Subject: Data validation checks when user uses the Modify All option in the client ** Hi Everyone, We're using ARS 7.0 all custom code system. In the past I have pretty much not allowed user's to use the modify ALL option however I have a new feature where there is a strong request to allow this option. Unfortunately I am having some challenges getting workflow that would do data validation to work when more than one record is modified. I believe filters are probably the only option to that is workable (instead of active links) but even in this case some of my On Modify filters do not see to catch data validation issues in all cases. Part of the workflow involves setting some fields via queries to other forms to verify existing data. Does anyone have any suggested best practices for handling this type of process? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St . San Francisco, CA . 94107 PRN | media where when it matters ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: *******ITSM 7.6.4 install in VM environment
Hi Enslin! If this is a production environment, rather put your DB on a physical host - especially if you need high throughput and/or reliability and/or good performance. (Otherwise, suffer in silence...) :-) One reliable, good performing VM environment would be Solaris/Oracle, but you are using Micro...t. We've had to solve some serious problems on 7.6.4 recently relating to running the DB on a VM (Bad Performance and serious system outages). It's OK to run everything else in a VM, but the DB should rather be on a physical host if you want best performance reliability. If you use these servers for Dev or QA, I'd say, you can run the DB on a VM, but be prepared for bad performance. Alternatively, If you absolutely have to stick to these VM's, install Remedy directly on the SQL box and beef up the RAM to 16Gb or more. Then use the old APP VM for Mid-Tier AIE on 8Gb RAM. You won't gain extreme amounts of performance, but this split should give best possible performance within that specific configuration set. Also test your network and disk setups to see if they are performing optimally, as disk and network could also have a huge impact on performance. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Enslin Van Blerk - MWEB Sent: 11 June 2011 10:41 To: arslist@ARSLIST.ORG Subject: ***ITSM 7.6.4 install in VM environment Hi All We created two VM Servers, one for APP and MidTier and the other one for SQL. After the install it is simply to slow to use and I need to know if there are any best practises and advice for installing Remedy ITSM 7.6.4 in a virtual environment? Windows 2008 R2 16Gig RAM 4 CPU - App server Windows 2008 R2 8Gig RAM 4 CPU - SQL server Maybe someone tried it before and realized that the application simply does not perform in a virtual environment Maybe some specific configurations to be set, any data would be welcomed. Regards Enslin Connect with South Africa?s leading Internet Service Provider and discover the magic of the Internet and all its possibilities. Call 08600 32000 or click here(http://www.mweb.co.za/productsservices/) for more. MWEB :-) CONNECT AND YOU CAN. This electronic communication and the attached file(s) are subject to a disclaimer which can be accessed on the following link: Disclaimer - or copy the following URL into your browser - http://www.mweb.co.za/disclaimer. If you are unable to view the disclaimer, please contact ab...@mweb.com for a copy. ___ 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
Re: Server rename question...
You may also want to run the following sql statements to find out if there's anything in the DB that is pointing to the old server name after the migration: select distinct tfServer from field_table select distinct sampleServer from field_table select distinct serverName from actlink_open select distinct server from char_menu_query select distinct sampleserver from char_menu_query select distinct server from char_menu_sql Best Regards, Theo Sent from my Black/Silver Personal Computer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 30 March 2011 05:02 AM To: arslist@ARSLIST.ORG Subject: Re: Server rename question... ** There's 177 or so files that contain the server name reference in Linux - not sure about Windows. Various things in the database also contain the server name. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richard Copits Sent: Tuesday, March 29, 2011 8:01 AM To: arslist@ARSLIST.ORG Subject: Server rename question... ** It appears as if the MS2003R2 server that our system is living on is going to be renamed. Will this require us to do a full reinstall in order to accommodate the new name or can we just edit the ar.cfg file and change the server name there after the platform is renamed? Same with the database name 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. _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
Re: Oracle 11G and AR 7.6.04 64Bit Install issues
Kathy, I did an ARS install on a RHEL5.5/Oracle 11g 64bit VM a couple of weeks ago for some research, also ran into a connection issue during the install. Whilst looking through the installer logs, it seemed that the BMC installer gets confused between using either the Service Name or the SID string as SID to connect to Oracle... and since the default install of Oracle sets different values for these, this error comes up... Since I'm not an Oracle dba and did not have more time available to battle with a research installation, I had to abandon the install at that point. HTH. Best Regards, Theo Sent from my Black/Silver Personal Computer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: 04 March 2011 08:47 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** That should be the 64 bit client then.. do you also have a 32 bit client which may be in your PATH? Joe From: Kathy Morrismailto:kathymorris...@aol.com Sent: Friday, March 04, 2011 1:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** What I was stating in my email is how do I determine if I have the required 64 or not. I know the client libraries are required - that does not need to be determined. I installed the full package of the 64-Oracle11g which installed the clients. Thanks. In a message dated 3/4/2011 1:19:47 P.M. Eastern Standard Time, jdso...@shyle.net writes: ** The client libraries are required.. there is no question of having to determine whether or not they are required.. The question is whether what you have is 32 or 64 bit.. As for how to determine if they are 64 bit, if you are not sure, uninstall the current client, and reinstall the 64 bit client, and reconfigure the tnsnames.ora upon installing the 64 client. The installer for the 64 bit client is different from the 32 bit installer.. It should be available on oracle.com for download.. There is a file command in unix to determine if files are 32 or 64 bit but I’m not sure how you would do that in windows.. This article may help.. http://stackoverflow.com/questions/495244/how-can-i-test-a-windows-dll-to-determine-if-it-is-32bit-or-64bit Joe From: Kathy Morrismailto:kathymorris...@aol.com Sent: Friday, March 04, 2011 1:09 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** Hi, How could I determine if the Oracle client libraries are the required? I have win64-11g release that I downloaded. I am not sure how to verify if I have the 64 client. In a message dated 3/4/2011 1:05:09 P.M. Eastern Standard Time, jdso...@shyle.net writes: ** Have you checked if the Oracle client libraries are the 64 bit libraries as required? And that you are using the right client and not a 32 bit client if that is installed too?? Your path does not look like what I think the default paths for the oracle client installs look like so its hard to say if it may be a 64 bit client.. Joe From: Kathy Morrismailto:kathymorris...@aol.com Sent: Friday, March 04, 2011 10:53 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Oracle 11G and AR 7.6.04 64Bit Install issues ** Hi, Can someone tell me how to get Oracle 11g to work/install with AR 7.6.04?. I have a 64-bit laptop. I installed 11g Oracle on Windows 7. I am trying to install AR 7.6.04 on Oracle 11g. During the AR install, I selected 64 bit. I am getting error messages and cannot proceed with the installation of AR System. The database seems to be running successfully. During the install when I connect to the database using DBMS account, I get a warning message that says: Possible causes - path variables point to incorrect Oracle client - tnsnames.ora does not exist or has incorrect connection details - missing 64 bit oracle client libraries My system path is: C:\app\oracle\product\11.2.0\dbhome_1\bin;C:\app\oracle\product\11.2.0\dbhome_1\lib; My tnsnames.ora displays: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Servername) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.x)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Servername) (SID = orcl) [ (GLOBAL_NAME=DatabaseName) ] ) ) _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_
Re: HPD:Help Desk ERD
Hi Gopal, Use Abydos Analyser, it gives a nice diagram and even drills down into the workflow from the diagram. Best Regards, Theo Sent from my Black/Silver Personal Computer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: 10 February 2011 07:45 AM To: arslist@ARSLIST.ORG Subject: Re: HPD:Help Desk ERD There is no one yet published for 7.5. However look for this whitepaper BMC Remedy IT Service Management 7.0 Architecture. It should be closer to 7.5. On Feb 9, 1:27 pm, Gopal-SRG srgr...@gmail.com wrote: Hi all, I am learning ITSM 7.5. Are there any association diagram lie EntityRelationshipDiagram for the HPD:Help Desk? It will be helpful, as i would be knowing what are the forms of are getting updated for any operations. Regards, Gopal -- View this message in context:http://old.nabble.com/HPD%3AHelp-Desk-ERD-tp30886041p30886041.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug11www.wwrug.comARSList: Where the Answers Are ___ 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
Re: AR User Tool Deprecated?
Firstly, I have to echo Jennifer's comments. Secondly, being a consultant, I work with various companies using Remedy and I know of companies still using 5.X and 6.X systems because they built their own custom applications and the migration path to the new versions of ARS sometimes seems too painful and costly, especially when it comes to paying to evaluate and convert thousands of (working) user macro's before re-training your user base again. Even though 7.X has come a long way (especially if you look at the performance gains of Mid-Tier 7.5) many people are still wary of upgrading just for the sake of upgrading - especially if ...the system isn't broken to begin with RANT So many users have become accustomed to creating their own macro's to automate various things and without having to wait for the red tape associated with a change management process, so it is sad to know that yet another selling point for Remedy is being canned as macro's will disappear when the AR User Tool is finally deprecated. There was a time when we sold Remedy (very successfully) with the slogan ...Run your business YOUR way... (remember that one Doug?). That, in practice, has unfortunately changed with the growing popularity of ITIL and the OOTB modules. It feels like the end of an era, where we now sell OOTB applications instead of having fun with writing our own reliable apps faster than anyone else on any other platform... /RANT In spite of all that, there is still light at the end of the tunnel: 1) There are shiny new features with each new major version of ARS that help in some or another way...and with that the OOTB apps are getting better too... 2) Going forward, with Remedy's Adapt-Or-Die capabilities still (largely) intact, an attitude of ...You cannot prevent change ... but you can adapt... still gives those investing in Remedy a leading edge to do things in a better way and to stay ahead of the curve... (IMHO, even if you are still running on 5.X) Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: 07 July 2010 03:55 PM To: arslist@ARSLIST.ORG Subject: Re: AR User Tool Deprecated? ** Susan's post brings up an excellent point. It is now 2010, and the current most-recent-version of ARS is 7.5. Susan's system is 8 years old. In 2002, she would have been installing a 5.X system. The 5.X releases were stable, reliable, and flexible. (Others may recall 2002 as the year of the P-word.) I recall being highly impressed with 5.X's flexibility and the ease of developing new applications. I believe that BMC announced with the release of 6.X that macros would not be supported in future versions. Those who moved on to more recent versions of ARS parted ways with macros along the way, often with users kicking and screaming; however, a number of organizations remain on 5.X and 6.X systems-and their users continue to use macros. The answer to Susan's question is that the 7.X experience is quite different from the 6.X or 5.X experience. The users will have to ditch their macros in any case and start over. 7.X introduced templates and decision trees to the ticket creation process. The Reporting Console will satisfy most of your users' reporting needs and Saved Searches will assist with the custom search and reporting issues without resorting to keystroke logging. Jennifer Meyer ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: User Tool On Win 7 64 Bit
I'm using WUT 7.1 P8 on my Dell Precision M6400 with Win7 Pro 64-bit - no problems - not even using compatibility mode... Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Maher, Jeff Sent: 23 June 2010 08:16 PM To: arslist@ARSLIST.ORG Subject: Re: User Tool On Win 7 64 Bit ** Hi Joe, right click on the program icon, select properties, then click the Compatibility tab. In there you can select what OS you want it to simulate when you run the program.. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, June 23, 2010 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: User Tool On Win 7 64 Bit ** Maybe a dumb question to ask, but how do you install something in 7 in an XP mode? I am pretty new to Windows 7 myself and can't quite say I like it as yet except for the pretty desktop pictures it comes with out of the box :-) Too much has changed from the XM / Windows 2000 Professional days, and many of those changes appear like they have tried to make things easier for new users just learning a new OS, but has left some of us old school guys wondering where is what.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of McClure, Don Sent: Wednesday, June 23, 2010 1:56 PM To: arslist@ARSLIST.ORG Subject: Re: User Tool On Win 7 64 Bit ** Hi Brian and Joe. I am using WUT 7.5/patch 5 and 7.1/patch 7 on my Win7 Ultimate, 64-bit (Dell Precision T7500). As I remember--the 7.5 installed without issue; the 7.1 required installing in XP/SP2 mode (basic installer would not recognize available disk space for installation). Don W. McClure, P.E. CITC Call Tracking Administration University of North Texas dwmac @ unt . edu From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, June 23, 2010 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: User Tool On Win 7 64 Bit ** Try 7.5. I had it installed on windows 7 home premium edition with no problems.. I have not tried earlier versions on windows 7. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Sokol, Brian Sent: Wednesday, June 23, 2010 1:41 PM To: arslist@ARSLIST.ORG Subject: User Tool On Win 7 64 Bit ** Will the Remedy User app work on Windows 7 64 Bit? If so what version(s)? I tried an unpatched 7.1 and it would not install. Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.scholastic.com/ http://www.Scholastic.com _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: Automatic logon to a display form
Glad it's working now... You're welcome! Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Victor Sent: 19 June 2010 09:17 AM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form On Monday 14 Jun 2010 08:34:40 Theo Fondse (RIS) wrote: Hi Victor! Try the following: jsp:forward page= http://my midtier server:8080/arsys/servlet/ViewFormServlet jsp:param name=server value=my AR server/ jsp:param name=mode value=Submit/ jsp:param name=form value=my display form name/ jsp:param name=username value=predefined login/ jsp:param name=pwd value=predefined password/ /jsp:forward The original format of the script assumes that the script is on the mid-tier server itself. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Victor Sent: 12 June 2010 12:37 PM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form Hi Victor! It's fairly simple. I have attached a .ZIP that contains a sample .jsp file. 1) Place the file on your web server and edit it to use the correct link, server, form, user, password and view parameters. 2) Then place a link to the .jsp file on a normal web page. 3) Done. Best Regards, Theo Hello Theo, I rewrote the jsp file to read: jsp:forward page=arsys/servlet/ViewFormServlet jsp:param name=server value=my AR server/ jsp:param name=mode value=Submit/ jsp:param name=form value=my display form name/ jsp:param name=username value=predefined login/ jsp:param name=pwd value=predefined password/ /jsp:forward Then I placed a link to the file on a web page. When I clicked on the link I received a file not found error However when I replaced the contents of the jsp file to read: % response.sendRedirect(http://my midtier server:8080/arsys/servlet/ViewFormServlet?form=my display form nameserver=my AR Serverusername=predefined loginpwd=predifined password); % everything worked as expected. The problem is that response.sendRedirect method shows the new url to the requested form. I need to hide all references to the actual display form because I'm afraid the login details could be captured. That is why I prefer to use the forward method as this hides the destination form references - But it's not working :( What am I doing wrong? Regards, Victor ___ _ ___ 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 Problem solved ! I rewrote the first line to: jsp:forward page=/servlet/ViewFormServlet and everything is working as expected. Thanks Theo, thanks all Victor ___ 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: Automatic logon to a display form
Hi Victor! Try the following: jsp:forward page= http://my midtier server:8080/arsys/servlet/ViewFormServlet jsp:param name=server value=my AR server/ jsp:param name=mode value=Submit/ jsp:param name=form value=my display form name/ jsp:param name=username value=predefined login/ jsp:param name=pwd value=predefined password/ /jsp:forward The original format of the script assumes that the script is on the mid-tier server itself. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Victor Sent: 12 June 2010 12:37 PM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form Hi Victor! It's fairly simple. I have attached a .ZIP that contains a sample .jsp file. 1) Place the file on your web server and edit it to use the correct link, server, form, user, password and view parameters. 2) Then place a link to the .jsp file on a normal web page. 3) Done. Best Regards, Theo Hello Theo, I rewrote the jsp file to read: jsp:forward page=arsys/servlet/ViewFormServlet jsp:param name=server value=my AR server/ jsp:param name=mode value=Submit/ jsp:param name=form value=my display form name/ jsp:param name=username value=predefined login/ jsp:param name=pwd value=predefined password/ /jsp:forward Then I placed a link to the file on a web page. When I clicked on the link I received a file not found error However when I replaced the contents of the jsp file to read: % response.sendRedirect(http://my midtier server:8080/arsys/servlet/ViewFormServlet?form=my display form nameserver=my AR Serverusername=predefined loginpwd=predifined password); % everything worked as expected. The problem is that response.sendRedirect method shows the new url to the requested form. I need to hide all references to the actual display form because I'm afraid the login details could be captured. That is why I prefer to use the forward method as this hides the destination form references - But it's not working :( What am I doing wrong? Regards, Victor ___ 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: Automatic logon to a display form
This email contained a .zip file attachment. Raytheon does not allow email attachments that are considered likely to contain malicious code. For your protection this attachment has been removed. If this email is from an unknown source, please simply delete this email. If this email was expected, and it is from a known sender, you may follow the below suggested instructions to obtain these types of attachments. + Instruct the sender to enclose the file(s) in a .zip compressed file, and rename the .zip compressed file with a different extension, such as, .rtnzip. Password protecting the renamed .zip compressed file adds an additional layer of protection. When you receive the file, please rename it with the extension .zip. Additional instructions and options on how to receive these attachments can be found at: http://security.it.ray.com/antivirus/extensions.html http://security.it.ray.com/news/2007/zipfiles.html Should you have any questions or difficulty with these instructions, please contact the Help Desk at 877.844.4712 --- Hi Victor! It's fairly simple. I have attached a .ZIP that contains a sample .jsp file. 1) Place the file on your web server and edit it to use the correct link, server, form, user, password and view parameters. 2) Then place a link to the .jsp file on a normal web page. 3) Done. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Victor Sent: 08 June 2010 07:01 PM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form On Monday 07 Jun 2010 20:27:56 Theo Fondse (RIS) wrote: You could also use jscripts placed on your web server for this...it works - especially if you want to hide the user/form/etc parameter details on the initial link! Best Regards, Theo Thanks all for your suggestions. I think Theo's idea is the most suitable to what I have in mind. Theo, could you please say something more about your idea? Thanks, Victor ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Automatic logon to a display form
You could also use jscripts placed on your web server for this...it works - especially if you want to hide the user/form/etc parameter details on the initial link! Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: 07 June 2010 07:59 PM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form ** Just to add to Frank's suggestion, create a group called InternetAccess or something like that, and make that user a part of that group, and keep that user access to that form only and nothing else.. Also disable guest user if you do not need guest users enabled for whatever reasons.. This will make that user secure, meaning even if people do figure the username and password of that user (the username and password has to be passed in clear text in the URL), they will not be able to take undesired advantage of that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Frank Caruso Sent: Monday, June 07, 2010 1:49 PM To: arslist@ARSLIST.ORG Subject: Re: Automatic logon to a display form ** The MidTier admin guide should provide you with the solution. I know you can pass the id and password as a parameter but I cannot remember the syntax. On Mon, Jun 7, 2010 at 1:44 PM, Victor vic...@klub.chip.pl wrote: Hello Listers, This is the scenario: I want to give users a defined link (say: http://My_form). On clicking at this link the user is logged on to AR System using a predefined login and password - and a predefined display form is opened. The details of the login is hidden from the user and the (predefined)user is logged out as soon as the form is closed. Any hint (or a push to the appropriate documentations) on how this could be accomplished? ARSystem 7.5 with ITSM 7.6 patch 001 on windows 2003, MS SQL 2005 and Tomcat midtier. Thanks in advance Victor. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are