Re: ARSLIST AWARDS
Congratulations to all the winners!!! A very deserving group! :) Matt R. -Original Message- From: Doug Blair [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: BMCWorld happenings
** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. Frank Sent: Thursday, August 31, 2006 6:04 PM To: arslist@ARSLIST.ORG Subject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: OT: Excel
** Lars,There is a function in excel (davarage) that will do what you want. Below is a copy of the helptext from excel regarding daverage. Good LuckOscar Herrera: Syntax DAVERAGE(database,field,criteria) Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column. Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on. Criteria is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column[EMAIL PROTECTED] wrote: But data from ars Is there a way, I know it is, to make a diagram based on the visible rows when autofilter has been selected for some columns.Now I have the formula Average(A2:A120), if I activate autofilter, maybe only 22 rows are returned, so I want average to be calculated only for those 22 rows.With my formula now the diagram is not changed as the intervall is the same, in what way do I have to change the formula to only use visible rows?I think someone has the answer.L ars PetterssonVattenfall Business Services Nordic ABAction Request System Engineer (Tabasco)S-461 88 TrollhättanSwedenPhone +46 520 888 35 Mobil +46 70 608 99 95e-mail: [EMAIL PROTECTED]___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. __20060125___This posting was submitted with HTML in it___
Re: Attachment Format Conversion?
** James, I'll agree with OLE. I did something very similar many years back (in my old Visual Foxpro developer days), using OLE automation to do a lot of processing in Excel that would have just been too painful (or impossible) to perform in VFP (the data that I was using was supplied in Excel format, it would have been a good idea in hindsight to convert it back over to CSV and store that as well, it would have been quite a simple process). But as that was maybe 10 years back, exact details are somewhat vague ... Good luck with it! Regards Dave On 31/08/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Lori: I think you are on the correct track with OLE. I'm not totally familiar with all of the available functions, but I think it is possible to open a file/template with an embedded macro that reads in the .xls file and then can save it as the same named .csv file. Sadly, I cannot try this today. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lori Gumbiner Sent: Thursday, August 31, 2006 9:15 AM To: arslist@ARSLIST.ORG Subject: Attachment Format Conversion? ** Hi guys! the WAG Remedy team all stayed home from RUG in a BUG this year, too. And, we are trying to do a nifty trick: User opens a record with an attachment file that is an Excel worksheet, formatted *.xls Can we give the User a button on the Remedy form that will convert that attachment to *.csv format? We have brainstormed all sorts of ideas (some feasible, some wishful thinking) , e.g. calling a converter utility, or using OLE to run a macro in the xls to save it as csv. Thought we'd bring the List's creativity to the problem. Any ideas? Oh, and any utility needs to be credible and free. ARS System Specs: Remedy: 6.3, patch 17 SunOS 5.9 Oracle 9.2.0.4.0 *Lori * Lori Gumbiner IT Systems Architecture - Process Automation Initiatives Walgreens Co. 847.914.5796 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: BMCWorld happenings
** Jarl,Thor was the code name for v7, check the archives...--MichielOn 9/1/06, Jarl Grøneng [EMAIL PROTECTED] wrote:Is'nt version 8 codenamed thor?--Jarl On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: ** Really not all that much.They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world.So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Gordon M. Frank Sent: Thursday, August 31, 2006 6:04 PM To: arslist@ARSLIST.ORG Subject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7 /434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
AREA LDAP Authentication on Solaris using SSL
Dear listers who are not at BUW (and those who are and are checking their email!) ARS 6.3 Solaris 8 I am currently using AREA LDAP successfully to authenticate ARS users to an LDAP tree fronting Novell E-Directory. Everyone thinks it's marvellous. However, the E-Directory team want to withdraw the unencrypted LDAP service, and require everyone to use LDAP over SSL. Fair enough, a very sensible thing to do. The LDAP tree certificate doesn't go back to one of the trusted root certificate authorities, but is self signed. There is a RootCert.der certificate to be imported. However, the AREA LDAP plug-in is based on the Netscape SDK, and requires a cert7.db and key3.db incorporating the credentials. On Windows, I can do this by running version 4.7 of Netscape and opening the RootCert.der file. This imports it and incorporates the credentials into the cert7.db and key3.db files. This is explained at http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402L=arslistP=R54534 However, if I try the same on Solaris, it doesn't work, and I can't seem to copy across the db files from Windows to Solaris - or at least Netscape on Solaris seems not to notice them. Does anyone have any suggestions? Jerry Jerry Niman Tel +44 (0)161-247 1474 Head of Information Systems Email [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan Universitys email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: AREA LDAP Authentication on Solaris using SSL
Jerry, I have managed to set up AREA LDAP over SSL on our HP server. First, we tried to import the certificate directly to the cert7.db file using the certutil utility, which worked fine, but Remedy authentication was not working with cert7.db file generated this way. Next option was using stunnel or similar utility to create secure connection from Remedy server to the LDAP machine. That worked fine, only worry is that you are relying on yet another external process running. In this case the AREA LDAP is configured to connect to a port on the Remedy server and stunnel takes care of forwarding that connection securely to LDAP server. Finally, you can try to run Netscape on your Remedy server and attempt connecting to the LDAP server over https. You can use a URL like https:\\your.LDAP.server:636 (not sure about the exact syntax of the URL) After connecting, Netscape will ask if you trust the site and want to install the certificate. After answering yes, the cert7.db file should get updated. You can then reference this file in the AREA LDAP configuration and all should work. Hope this will help and save you some time. Regards Jiri -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Niman Sent: 01 September 2006 09:21 To: arslist@arslist.org Subject: AREA LDAP Authentication on Solaris using SSL Dear listers who are not at BUW (and those who are and are checking their email!) ARS 6.3 Solaris 8 I am currently using AREA LDAP successfully to authenticate ARS users to an LDAP tree fronting Novell E-Directory. Everyone thinks it's marvellous. However, the E-Directory team want to withdraw the unencrypted LDAP service, and require everyone to use LDAP over SSL. Fair enough, a very sensible thing to do. The LDAP tree certificate doesn't go back to one of the trusted root certificate authorities, but is self signed. There is a RootCert.der certificate to be imported. However, the AREA LDAP plug-in is based on the Netscape SDK, and requires a cert7.db and key3.db incorporating the credentials. On Windows, I can do this by running version 4.7 of Netscape and opening the RootCert.der file. This imports it and incorporates the credentials into the cert7.db and key3.db files. This is explained at http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402L=arslistP=R54534 However, if I try the same on Solaris, it doesn't work, and I can't seem to copy across the db files from Windows to Solaris - or at least Netscape on Solaris seems not to notice them. Does anyone have any suggestions? Jerry Jerry Niman Tel +44 (0)161-247 1474 Head of Information Systems Email [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Difference in times - Oracle DB and forms
Hi all, The HPD-HelpDesk fields display an actual time whilst after recalculating the database's time I got 2 hour delay. It concerns all date fields (arrival time, resolved time, work in progres time...). When I check database time zone: select dbtimezone from dual; it gives me +02:00 on the other Remedy server I got: -07:00 But still the difference is 2 hours. I think it's an Oracle issue, perhaps wrong configuration. Can anyone point me to the solvation. Tanks Mark B. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
I totally agree. I have a confession to make though. I have now eaten the first Twinkie of my life. It is very unlikely that this will occur again... I first thought that this black hole in my experience was due to Swedish Twinkie-tolls, but after the memorable experience this very eavning, I have come to reassess my standpoint! Best Regards - Misi, RRR AB, http://www.rrr.se Congratulations to all the winners!!! A very deserving group! :) Matt R. -Original Message- From: Doug Blair [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: BMCWorld happenings
Misi (All), An exact code name was not mentioned. ( As far as I can remember.) However an example of amber was given. And the pattern would be to follow the alphabet like they do with hurricane names. A= Amber then B= Bob then C=Charlie, etc... If the need to do a B.5 type thing then I think the idea would be to find a Ba 'ish (alpha sort after the name that was picked for B) name to get the job done. I did gleam that the time of year for BUW ( BMC User World ) next year will be this bat time. And based on when v8 (or v7.5 depending on what they end up doing) will likely be released _before_ the next BUW. They have been only the most vague about themas for what they are trying to do for the next version. No demos, samples, screenshots, or it might change later, but look at this stuff this year. (They did all of that at the last RUG. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote: Hi again, Loke has been rejected as the code name, to my great distress. During this conference, as well as the last ten years, I have been carrying Thors hammer around my neck. They have actually decided to skip the Norse mythology and restart things with minerals and the first letter of the alphabet. At this point in time, I am unable to recall the exact mineral/stone/substance in question... Pleas help me out! As far as the Admin Tool is concerned, they have indicated a move towards Eclipse and Java, rather than the web. Best Regards - Misi, RRR AB, http://www.rrr.se Jarl, snip On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: ** Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gordon M. Frank Sent: Thursday, August 31, 2006 6:04 PM To: arslist@ARSLIST.ORG Subject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Difference in times - Oracle DB and forms
** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well.The value stored in the database is GMT. Does this help you?Kind regards,MichielOn 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: Hi all,The HPD-HelpDesk fields display an actual time whilstafter recalculating the database's time I got 2 hour delay. It concerns all date fields (arrival time, resolved time, work in progrestime...).When I check database time zone:select dbtimezone from dual;it gives me+02:00on the other Remedy server I got: -07:00But still the difference is 2 hours.I think it's an Oracle issue, perhaps wrong configuration.Can anyone point me to the solvation.TanksMark B.___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Difference in times - Oracle DB and forms
Thank you for your answer. But I still don't know how I'm suppose to retrieve the data using API or by SQL query. That would stil give me the wrong time. MarkB. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Difference in times - Oracle DB and forms
** If you would like to retrieve the time using SQL, you should add the offset to the time in the database yourself.Also if you're using the API your API program should take account of your offset to GMT. This would normally be stored in an environment variable. Regards,MichielOn 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: Thank you for your answer.But I still don't know how I'm suppose to retrieve the datausing API or by SQL query.That would stil give me the wrong time.MarkB.___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
OT: Twinkie Experiments - Friday Humor
** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___
Re: Twinkie Experiments - Friday Humor
** Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday Humor** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Twinkie Experiments - Friday Humor
** also a good test of Twinkies capacity to keep the qualities during a long flight. Oh, I think they'll hold up. Even through a nuclear winter. :-) All Things Considered, August 1, 2005 · Michele Norris speaks with Roger Bennatti, a recently retired science teacher at George Stevens Academy in Blue Hill, Me., about a food preservation experiment he began 30 years ago. He and students set out to determine the shelf life of a Hostess Twinkie. http://www.npr.org/templates/story/story.php?storyId=4780900 Happy Friday everyone... -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/01/2006 07:17 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Twinkie Experiments - Friday Humor ** Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacity to keep the qualities during a long flight. L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark Blankenship Sent: Friday, September 01, 2006 2:06 PM To: arslist@ARSLIST.ORG Subject: OT: Twinkie Experiments - Friday Humor ** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Twinkie Experiments - Friday Humor
** Don't worry L ars. Twinkies can even withstand a Nucular[sic] blast. Just ask Peter Griffin John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor ** Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday Humor** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
funny stuff Axton On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote: I totally agree. I have a confession to make though. I have now eaten the first Twinkie of my life. It is very unlikely that this will occur again... I first thought that this black hole in my experience was due to Swedish Twinkie-tolls, but after the memorable experience this very eavning, I have come to reassess my standpoint! Best Regards - Misi, RRR AB, http://www.rrr.se Congratulations to all the winners!!! A very deserving group! :) Matt R. -Original Message- From: Doug Blair [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 8:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
Title: RE: ARSLIST AWARDS ** Axton: Congratulations. I bet the voting was very close. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Friday, September 01, 2006 6:10 AM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS funny stuff Axton On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote: I totally agree. I have a confession to make though. I have now eaten the first Twinkie of my life. It is very unlikely that this will occur again... I first thought that this black hole in my experience was due to Swedish Twinkie-tolls, but after the memorable experience this very eavning, I have come to reassess my standpoint! Best Regards - Misi, RRR AB, http://www.rrr.se Congratulations to all the winners!!! A very deserving group! :) Matt R. -Original Message- From: Doug Blair [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 8:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Title: RE: ARSLIST AWARDS ** Congratulations Axton Gordon Frank US Army __20060125___This posting was submitted with HTML in it___
Re: Question: Administrator Tool Not Showing Details
Title: RE: Question: Administrator Tool Not Showing Details ** Tyrone: Are you limiting the return items list on the production server? If so, the details for Filters ONLY will be hidden when you request the complete filter list AND it is larger than the number allowed in the return list. BMC states this is as designed. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of T. Dee Sent: Thursday, August 31, 2006 4:58 PM To: arslist@ARSLIST.ORG Subject: Question: Administrator Tool Not Showing Details I am running ARS 6.00.01 Patch 1394. I login to 3 servers (production, development and sandbox). I have details turned on. When I click on Filters I see all the details in production and sandbox, but in development only the names shows up (no other details). I have rebooted the server, but this changes nothing. This only happened today - prior to this all the details have always shown up. The admin tool is 6.00.01. This is very odd - any suggestions? THANKS ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Congratulations to all -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, August 31, 2006 8:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: SSO via user tool
Title: Re: SSO via user tool ** Carolyn, Please contact me off list at: [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wixson Carolyn L PSNS Sent: Thursday, August 31, 2006 3:32 PM To: arslist@ARSLIST.ORG Subject: Re: SSO via user tool Benjamin, We are also CAC enabled. We need to get the mid-tier up for Requesters to submit tickets. Our management does not want them to see a login screen. Can you share your CAC solution? We are currently using: ARS ver 5.1.2 HelpDesk ver 5.6 We may be upgrading to ARS ver 6.3 very soon. Any help you can give will be GREATLY appreciated. Carolyn Wixson (360) 476-6197 PSNS IMF Remedy ARS Administrator __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: BMCWorld happenings
** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 PMTo: arslist@ARSLIST.ORGSubject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
JOBS: Contract Permanent, Nationwide
List, Good afternoon, Turing SMI and Turing SMI Resource Management are urgently seeking a Remedy Developer for a contract in the North West of England for the short to medium term. Start date within the next 2-4 weeks. We also have ongoing urgent requirements in the South of England and are always keen to hear from individuals who are available within the next 1-2 months. On the permanent side we have a number of opportunities for Remedy Developers and will consider all locations. As always, many thanks for your attention and I hope you all have a pleasant weekend. Kind regards, Rachel Kerwick Resourcing TuringSMI 200 Brook Drive Green Park Reading Berkshire RG2 6UB Office: +44 (0) 1189 256049 Mobile: +44 (0) 7875 431604 Fax: +44 (0) 1189 497221 Website: www.turingsmi.com eMail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Hellllloooooo!!!!
Title: RE: Heloo ** Rick and Bing: I'll leave the Mexican here. Being from Southern Arizona, I cannot walk a block without seeing some sort of Mexican resturant. However, I will not pass up a good (read, great) place to be a true carnivore. Be it steak, chicken or some exotic meats (you really don't want to know what I've consumed in my lifetime.) And I don't consider Black Angus to be in the category I'm talking about. Lawrey's is. McCormick Smicks is for food from the sea. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Thursday, August 31, 2006 9:40 PMTo: arslist@ARSLIST.ORGSubject: Re: Heloo ** Oh, the Blue Agave is to DIE for. The chicken Mole was best Mexican meal I have ever had. I'm not a Tequila drinker, but if you are, they have a multi-page book with all of them they serve, like a nice steakhouse would have a big wine list. Great Thai place in Mountain View, too - can't remember the name, but it was on that new trendy street they have - Castro St.? Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bradford BingelSent: Thursday, August 31, 2006 9:30 PMTo: arslist@ARSLIST.ORGSubject: Re: Heloo ** Take it from a "local" just up the road in Walnut Creek .. . lots of places to see and plenty of things to do in Northern California. Better still, spend a few more days and explore San Francisco, Monterey Bay, Napa Valley, Old Sacramento, Lake Tahoe,or Yosemite. Looking for best picksin food? You probably won't have much time to explore for breakfast or lunch, but there are several excellent choices for dinner. For Mexican, I'd suggest the Blue Agave in downtown Pleasanton, or La Ultima in Danville (5 miles north). Looking for asteak? Try Cattleman'soutside Livermore (5 miles east), orcome to Walnut Creek (15 miles north)for Ruth's Chris or Vic Stewart's. Too many excellent Chinese restaurants to name, but Uncle Yu's in San Ramon (5 miles north) and P. F. Chang's (Walnut Creek) stand out. BBQ fans, try Back 40 in Pleasant Hill (20 miles north), consistent winner of the national rib cook-off held each year in Reno. Please feel free to drop me a line for additional ideas andinformation! -- Bing Bradford Bingel ("Bing")ITM3 California http://www.itm3.com/[EMAIL PROTECTED] (email)925-260-6394 (mobile) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Thursday, August 31, 2006 3:47 PMTo: arslist@ARSLIST.ORGSubject: Re: Heloo ** Wow, there are so many. I have honestly never had a bad meal in that town (as those who've seen me can attest). There's a sandwich place right across the street from the training facility that sells a steak sandwich that is absolutely the best I've ever had. All the places downtown are great. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Thursday, August 31, 2006 3:21 PMTo: arslist@ARSLIST.ORGSubject: Re: Heloo ** Rick: And your favorite place is??? BTW, the RAC and RSP are deliberately hard to keep the number of people with them current and knowledgeable. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook Sent: Thursday, August 31, 2006 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo ** Audrey, if the RSP class is like the RAC class, you'll need to demonstrate the ability to gather requirements from a customer, write a requirements doc., develop a system from a set of requirements, and present it to the customer. The application is significant, but isn't a rocket science type of thing. There's also a written test. And Pleasanton is a wonderful place to have a class. If you go, you HAVE to go to the old downtown. I just love it there. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Thursday, August 31, 2006 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo ** Audrey: You want Lenny as your instructor if he teaches the course. I've heard that he is working on the other instructors trying to bring them up to and keeping them at his level. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Audrey H Franklin Sent: Thursday, August 31, 2006 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Heloo James, I am not familiar with Pleasanton, CA. All Remedy Classes I attended were in Columbia, MD. However, I plan to take the RSP class in October, and would like to know if you have any pointers on the best way
Quick Report in MidTier?
From our client (6.3) we have a quick report button that prints out a ticket and the specified fields so you get a report that has all the information from the fields in the report. What report options are there from midtier? Just printing from the browser only gives you what you can see of course. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: AREA LDAP Authentication on Solaris using SSL
Title: RE: AREA LDAP Authentication on Solaris using SSL ** Jerry: You have the files, use them. You have to copy them into the appropriate directory on Solaris and the method to do this is described in the documents. I have never been able to get Netscape on Solaris to do what you described. I use the Windows version. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jerry Niman Sent: Friday, September 01, 2006 1:21 AM To: arslist@ARSLIST.ORG Subject: AREA LDAP Authentication on Solaris using SSL Dear listers who are not at BUW (and those who are and are checking their email!) ARS 6.3 Solaris 8 I am currently using AREA LDAP successfully to authenticate ARS users to an LDAP tree fronting Novell E-Directory. Everyone thinks it's marvellous. However, the E-Directory team want to withdraw the unencrypted LDAP service, and require everyone to use LDAP over SSL. Fair enough, a very sensible thing to do. The LDAP tree certificate doesn't go back to one of the trusted root certificate authorities, but is self signed. There is a RootCert.der certificate to be imported. However, the AREA LDAP plug-in is based on the Netscape SDK, and requires a cert7.db and key3.db incorporating the credentials. On Windows, I can do this by running version 4.7 of Netscape and opening the RootCert.der file. This imports it and incorporates the credentials into the cert7.db and key3.db files. This is explained at http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402=arslist=R54534 However, if I try the same on Solaris, it doesn't work, and I can't seem to copy across the db files from Windows to Solaris - or at least Netscape on Solaris seems not to notice them. Does anyone have any suggestions? Jerry Jerry Niman Tel +44 (0)161-247 1474 Head of Information Systems Email [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: BMCWorld happenings
** Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support.I've not been able to even start RDP ...L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cookSent: Friday, September 01, 2006 4:10 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 PMTo: arslist@ARSLIST.ORGSubject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Thanks James, Frank. I've found that the voting is always very close with these things. Axton On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote: ** Congratulations Axton Gordon Frank US Army __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Difference in times - Oracle DB and forms
Title: RE: Difference in times - Oracle DB and forms ** Michiel: Huh? The time stored in the database is the same TZ as the ARS server from what I've been able to determine. However, that being set aside you do have a point. If you look at the time on the WUT, it will be the same as the user machine. But if you run an external process to the server, the time displayed will be the server's time and NOT the user local time, unless you use processes to grab the user's local time and then adjust for the difference between the two. This has resulted in some interesting time differences and a lot of work to correct. I would be very happy if the database did store times in UTC/GMT. It would make some of the things I do much easier. James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen Sent: Friday, September 01, 2006 3:25 AM To: arslist@ARSLIST.ORG Subject: Re: Difference in times - Oracle DB and forms ** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well. The value stored in the database is GMT. Does this help you? Kind regards, Michiel On 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: Hi all, The HPD-HelpDesk fields display an actual time whilst after recalculating the database's time I got 2 hour delay. It concerns all date fields (arrival time, resolved time, work in progres time...). When I check database time zone: select dbtimezone from dual; it gives me +02:00 on the other Remedy server I got: -07:00 But still the difference is 2 hours. I think it's an Oracle issue, perhaps wrong configuration. Can anyone point me to the solvation. Tanks Mark B. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: AR Plugin for Vendor Form
Did you ever figure out how you were going to handle this? We would like to be able to take a excel list of device tags and create change management request for each device without having to manually entering each one. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: BMCWorld happenings
** In v7, I have not been able to get RDP to work at all. I have contacted support - it's an open issue. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 7:16 AMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support.I've not been able to even start RDP ...L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cookSent: Friday, September 01, 2006 4:10 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 PMTo: arslist@ARSLIST.ORGSubject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Whether it was close or not, I would have been disappointed if I had deprived either you or James of an award that both of you deserved. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, September 01, 2006 7:18 AM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS Thanks James, Frank. I've found that the voting is always very close with these things. Axton On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote: ** Congratulations Axton Gordon Frank US Army __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
Title: RE: ARSLIST AWARDS ** Rick: If you had won the award, I would still have congratulated you. The real winners in all of this are the members of the list, who receive information from other members, saving valuable hours of troubleshooting and BMC who can discover if anyone else found a workaround or a fix without having to go into the lab. BMC also discovers if this is a 'one off' problem or if it affects many of us. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook Sent: Friday, September 01, 2006 7:23 AM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS Whether it was close or not, I would have been disappointed if I had deprived either you or James of an award that both of you deserved. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Friday, September 01, 2006 7:18 AM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS Thanks James, Frank. I've found that the voting is always very close with these things. Axton On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote: ** Congratulations Axton Gordon Frank US Army __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Deletion of non-reference entry mechanism
Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
Hey Axton, Congratulations. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Thursday, August 31, 2006 9:28 PM To: arslist@ARSLIST.ORG Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ADM:OT:BUW:MVP:Congratulations to All!
Just in the mood for prefixes/acronyms. Thought I would mention in general terms, I have never given a vote by vote accounting, (I do have them all archived however), the voting was not close this year. Not that there was a weak candidate (not sure there has ever been anyone that didn't deserve the nomination, just others that did as well). I think there was a feeling that Axton has been in the running for years, and this year was his. This years BUW/RUG seemed busier and more hopping than last year, hope it continues. The messages I am leaving with: BSM is good, ITIL, BSM is good, ITIL, ITSM7, get to ARSystem 7, and CMDB2.0 if you are on CMDB1.1, ARSystem is the platform for them to build the applications for you to use. They are concentration on their cross platform integrations using ARSystem as the workflow glue. Oh, did I mention BSM and ITIL? ... Daniel ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Twinkie Experiments - Friday Humor
** You may want to call the airline first to see if you are even allowed to carry a Twinkie on board. The chemical makeup of those things may prevent you from being able to board the aircraft ;-) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 01, 2006 8:17 AM To: arslist@ARSLIST.ORG Subject: Re: Twinkie Experiments - Friday Humor Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark Blankenship Sent: Friday, September 01, 2006 2:06 PM To: arslist@ARSLIST.ORG Subject: OT: Twinkie Experiments - Friday Humor ** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: BMCWorld happenings
** Rick I had the same problem but someone from support was able to help me get it to work. Here is what support had me do. Un-install RDB Install Patch 1 of the AR 7 Admin tool Install RDB And that worked for me. Kim Olds Sr. User Support Specialist - Help Desk Anne Arundel County Public Schools Phone 410-222-5254 Fax 410-222-5611 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook Sent: Friday, September 01, 2006 10:21 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings In v7, I have not been able to get RDP to work at all. I have contacted support - it's an open issue. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 01, 2006 7:16 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support.I've not been able to even start RDP ...L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cook Sent: Friday, September 01, 2006 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Thursday, August 31, 2006 11:33 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. Frank Sent: Thursday, August 31, 2006 6:04 PM To: arslist@ARSLIST.ORG Subject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Setup Dev Server
Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
I3 and Remedy?
** Has anyone integreated Remedy with the I3 client? Was this done out of the box or did it require COM programming? -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 __20060125___This posting was submitted with HTML in it___
Re: RKM 7.0 is out
Do you need to buy a licenses or can this be installed for testing ? You mention '1 user' Has anyone installed it yet ? Rgds, chris ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
Congrats, Axton! --Tim ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: RKM 7.0 is out
** I have it up and running... It requries a database (seperate from Remedy) to store statistics, etc. I have temporarily set up MySQL for this. Oracle, sybase, mssql are also supported. The directions (not the clearest) are geared towards ServletExec ASAPI or Tomcat. Other jsp engines will require enough knowledge to figure it out yourself. I do have it running under ServletExec AS. You do need to buy the product; the 1 user is just the text that shows on upgrade central. Licensing is somewhat different from other apps as it isn't enforced (we do have additional user licenses, but they're not applied or stored anywhere) I can't speak as to whether it shows in upgrade central if you don't have it on your license shelf -- probably not. hth, tony -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 Chris Rom [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/01/2006 10:40 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: RKM 7.0 is out Do you need to buy a licenses or can this be installed for testing ? You mention '1 user' Has anyone installed it yet ? Rgds, chris ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Second and a great win for an awesome contributor ! Regards...Gidd -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, September 01, 2006 8:46 AM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS Congrats, Axton! --Tim ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS
Congrats Axton Herb Partlow ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Twinkie Experiments - Friday Humor
** Hmm...is is really good forhuman beingsto eat those things ...Maybegood for meI didn't attended the Conference this year ../L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Ron GehringSent: Friday, September 01, 2006 4:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor** You may want to call the airline first to see if you are even allowed to carry a Twinkie on board. The chemical makeup of those things may prevent you from being able to board the aircraft ;-) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday Humor ** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Pushing values to the CTM:People Form
I have created about a dozen records and logged everything. The problem is that you must somehow emulate the menu selection that you would do manually during the escalation pushing LDAP data. Remedy Support has only had some vague info and there is no documentation. It isn't pretty nor is it perfect but it works with a few assumptions. I am using the streetAddress field from LDAP to cross-reference the Site Name in the ITSM Foundation. Using this as the key, I implemented a custom Escalation to import and synch the user data and a subsequent custom Filter to emulate the Active Links and Active Link Guides that a normal Menu Selection action in the Site Name field of the CTM:People form would force. I have also had to add a few LDAP related fields and set some additional default values in the CTM:People form. The key assumptions are: 1) the streetAddress values across the company are unique for each site (e.g. there can't be two 123 Main Streets, one in Austin and another in San Diego); 2) streetAddress is not NULL; and 3) there is an exact and direct one-to-one correspondence between the values of streetAddress in LDAP and Street Address in ITSM. As always, if you feel this should be addressed in some type of whitepaper, please log an enhancement request on the web for this. --- We are using Employee ID/Corporate ID as the common field between LDAP and CTM:People. I just can't believe that no one else is doing this yet ? Any help would be appreciated. Rgds, Chris ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ITSM 7 Implementation Workshop RSMG-ITIW-0700
I was able to register in the U.S. after the BMC EMEA Education dept. kicked me out of the Stockholm class because I did not have the CMDB 2.0 pre-requisite. Interestingly the class-description has since been updated to read: Note: In the EMEA region this course is only available to Alliance Partner consultants. There were several changes in scheduling already. An October class at one of their partner sites in Clearwater, FL was cancelled, but now it looks like they added a second, concurrent, class in Columbia, MD from Sep. 18- 22. Kinda strange, but perhaps because of the great demand. They had also closed an early Sep. class in Pleasanton, CA to the public in order to get their own people trained. Chris ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: BMCWorld happenings
** I was on patch 1 - didn't help. Glad it helped you. I even tried a patch 2 .dll that support sent me. It made Sync Search DB work but still no RDP. I don't have that box anymore, so I guess it's a moot point. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly MSent: Friday, September 01, 2006 8:03 AMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Rick I had the same problem but someone from support was able to help me get it to work. Here is what support had me do. Un-install RDB Install Patch 1 of the AR 7 Admin tool Install RDB And that worked for me. Kim Olds Sr. User Support Specialist - Help Desk Anne Arundel County Public Schools Phone 410-222-5254 Fax 410-222-5611 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Friday, September 01, 2006 10:21 AMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings In v7, I have not been able to get RDP to work at all. I have contacted support - it's an open issue. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 7:16 AMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support.I've not been able to even start RDP ...L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cookSent: Friday, September 01, 2006 4:10 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt compare. Thanks! Matt From: Rick cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2006 11:35 PMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld happenings Really not all that much. They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the ITSM 7 world. So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it. Not even a projected due date for a next versioncurious. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 PMTo: arslist@ARSLIST.ORGSubject: BMCWorld happenings ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe Curious! Gordon Frank --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Twinkie Experiments - Friday Humor
** That would be an interesting ACADEMIC question - could they be made even more deadly to humans than they already are? (disclaimer - I am NOT advocating in any way that someone should try to find out). Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron GehringSent: Friday, September 01, 2006 7:46 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor ** You may want to call the airline first to see if you are even allowed to carry a Twinkie on board. The chemical makeup of those things may prevent you from being able to board the aircraft ;-) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday Humor ** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: BMCWorld happenings (RDP or no RDP?)
Title: RE: BMCWorld happenings (RDP or no RDP?) ** Rick: I'm glad we decided to not pick up this product to assist in our documentation efforts. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook Sent: Friday, September 01, 2006 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** I was on patch 1 - didn't help. Glad it helped you. I even tried a patch 2 .dll that support sent me. It made Sync Search DB work but still no RDP. I don't have that box anymore, so I guess it's a moot point. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Olds, Kimberly M Sent: Friday, September 01, 2006 8:03 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** Rick - I had the same problem - but someone from support was able to help me get it to work. Here is what support had me do. Un-install RDB Install Patch 1 of the AR 7 Admin tool Install RDB And that worked for me. Kim Olds Sr. User Support Specialist - Help Desk Anne Arundel County Public Schools Phone 410-222-5254 Fax 410-222-5611 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook Sent: Friday, September 01, 2006 10:21 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings In v7, I have not been able to get RDP to work at all. I have contacted support - it's an open issue. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 01, 2006 7:16 AM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support. I've not been able to even start RDP ...L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick cook Sent: Friday, September 01, 2006 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** I totally agree with you, but have heard nothing about enhancements to the RDP. Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Reinfeldt Sent: Thursday, August 31, 2006 11:33 PM To: arslist@ARSLIST.ORG Subject: Re: BMCWorld happenings ** Rick, Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesn't compare. Thanks! Matt __20060125___This posting was submitted with HTML in it___
Re: Twinkie Experiments - Friday Humor
** Rick: Well the local Funeral Parlor encourages the consumption of foodstufs like Twinkies. Why? They have to use less preservative (read the ingredients list and you will understand) in their embalming fluids. And I really don't want a 'more deadly' Twinkie. They are just fine when I get them home (and that is very, very rare) from the store. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Friday, September 01, 2006 10:00 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor ** That would be an interesting ACADEMIC question - could they be made even more deadly to humans than they already are? (disclaimer - I am NOT advocating in any way that someone should try to find out). Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron GehringSent: Friday, September 01, 2006 7:46 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor ** You may want to call the airline first to see if you are even allowed to carry a Twinkie on board. The chemical makeup of those things may prevent you from being able to board the aircraft ;-) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday Humor Curious about all this discussion about Twinkies, misi, please bring one or two home to Sweden, also a good test of Twinkies capacityto keep the qualities during a long flight. L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday Humor ** For Misi, having eaten his first twinkie. A scientific analysis of the twinkie http://www.twinkiesproject.com/ Mark __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
Rick, Actually as I've heard the nuclear meltdown theory the survivors would be Twinkies, cockroaches, and portions of Cher. D. Friday! ___ Doug Blair Remedy Skilled Professional dougatblairingdotcom +1-224-558-5462 .. Original Message ... On Fri, 1 Sep 2006 07:05:09 -0700 Rick cook My own opinion is that in a nuclear holocaust, the only survivors would be cockroaches and Twinkies. And the roaches probably would still have more sense than to eat the Twinkies. Rick ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Julie: All UNIX versions of ARS require that the associated 32 bit client libaries be installed and placed in the library path file before any 64 bit libraries. This may also be true for the 64 bit Windows systems. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Julie Rockwood Sent: Friday, September 01, 2006 10:38 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
I can SQL plus on the Dev box to the DB. I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name? Oh -- the Production server has the same version or Oracle. John Julie Rockwood [EMAIL PROTECTED] V To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Setup Dev Server ORG 09/01/2006 01:38 PM Please respond to [EMAIL PROTECTED] RG John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deletion of non-reference entry mechanism
Have you considered the possibility of preventing the orphans to begin with?...If you create an AL that happens on Window Close where Operation = CREATE that does a delete query on it's child tables base on the GUID you have already generated...if you wanted to keep it dynamic...you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre Sent: Friday, September 01, 2006 8:33 AM To: arslist@ARSLIST.ORG Subject: Deletion of non-reference entry mechanism Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Quick Report in MidTier?
** Is this button in you menu bar?There is no menu bar in mid-tier, but you can create a regular button on the form, and connect it to the active link that will run this report. If it is an ordinary plain-text remedy report it should run just fine on mid-tier. If it is a crystal report you would need to buy and install Crystal Reports Enterprise Server. Regards,MichielOn 9/1/06, James Pifer [EMAIL PROTECTED] wrote: From our client (6.3) we have a quick report button that prints out aticket and the specified fields so you get a report that has all theinformation from the fields in the report.What report options are there from midtier? Just printing from the browser only gives you what you can see of course.Thanks,James___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Difference in times - Oracle DB and forms
** I guess you are right on the DB time zone thing.This will make it a 'best practice' to set your server to GMT, especially if you are working in a global environment.It would be an enhancement request to let the server store gmt by default, regardless of the server timezone setting. --MichielOn 9/1/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Michiel: Huh? The time stored in the database is the same TZ as the ARS server from what I've been able to determine. However, that being set aside you do have a point. If you look at the time on the WUT, it will be the same as the user machine. But if you run an external process to the server, the time displayed will be the server's time and NOT the user local time, unless you use processes to grab the user's local time and then adjust for the difference between the two. This has resulted in some interesting time differences and a lot of work to correct. I would be very happy if the database did store times in UTC/GMT. It would make some of the things I do much easier. James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen Sent: Friday, September 01, 2006 3:25 AM To: arslist@ARSLIST.ORG Subject: Re: Difference in times - Oracle DB and forms ** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well. The value stored in the database is GMT. Does this help you? Kind regards, Michiel On 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: Hi all, The HPD-HelpDesk fields display an actual time whilst after recalculating the database's time I got 2 hour delay. It concerns all date fields (arrival time, resolved time, work in progres time...). When I check database time zone: select dbtimezone from dual; it gives me +02:00 on the other Remedy server I got: -07:00 But still the difference is 2 hours. I think it's an Oracle issue, perhaps wrong configuration. Can anyone point me to the solvation. Tanks Mark B. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
** Thank you everybody voting for ARInside. This ARSList Award is more then i expected when programming this application. I hope i will find some time in the near future to update and improve this application. I wouldt like to mention that many users of this list helped developing ARInside by sending me comments, reports and improvement suggestions. Thank you! Please feel free to contact me off-list for question and comments. And of course ... congratulations to the other winners. Best regardsStefan Nerlich2006/9/1, Doug Blair [EMAIL PROTECTED]: ALMOST LIVE,From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,CaliforniaThere are too many inside jokes, singing, dancing, Twinkie-hurling peoplehere that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With ALittle Help From My Friends (... From The List). I think that I reallyshouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year!AWARDS:LONGEST THREAD: What Bugs You About Remedy? (84 posts)WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can beexplained by incompetence / Matt BlackWORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'SousaBEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny WarrenMOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and JamesMcKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resoundinghoots, cheers and thunderous applause!Congratulations, Axton, and all the other ARSLIST winners!Doug___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS
To the winners and contenders, I wish to add my congratulations to all winners of the ARSList Awards and to the contenders as well. All you folks are very special and giving people and I, as most others, recognize and appreciate your efforts. Warm regards and best wishes, Tom Thomas J. Mutaffis Remedy Architect/Developer - Original Message - From: Doug Blair [EMAIL PROTECTED] Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, August 31, 2006 9:27 PM Subject: ARSLIST AWARDS ALMOST LIVE, From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco, California There are too many inside jokes, singing, dancing, Twinkie-hurling people here that it is impossible to convey the true essence of the camaraderie we all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A Little Help From My Friends (... From The List). I think that I really shouldn't tell you more because that would spoil it. You'll just have to get your boss to foot the bill next year! AWARDS: LONGEST THREAD: What Bugs You About Remedy? (84 posts) WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text) James Ward BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be explained by incompetence / Matt Black WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row) BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James McKenzie): AXTON GRAMS ...who was duly contacted by Dan on cell phone immediately, with resounding hoots, cheers and thunderous applause! Congratulations, Axton, and all the other ARSLIST winners! Doug ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** John: You can create as many tablespaces in one Oracle DB as you need. I would not, if possible, install the production and development tablespaces into the same Oracle DB instance. I have two different versions of ARS installed on the same Oracle DB instance, however. James Mckenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I can SQL plus on the Dev box to the DB. I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name? Oh -- the Production server has the same version or Oracle. John Julie Rockwood [EMAIL PROTECTED] V To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList) Subject [EMAIL PROTECTED] Re: Setup Dev Server ORG 09/01/2006 01:38 PM Please respond to [EMAIL PROTECTED] RG John, Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ? I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure that it had something to do with the Oracle client. Recently I noticed a note on the compatibility matrix that may provide a clue: Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have. I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems. I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it. Julie At 09:30 AM 9/1/2006, you wrote: Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --- Julie Rockwood Los Alamos National Laboratory IST-AUBAD Remedy Technical Lead (505) 667-9846 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ITSM 7 SRM Error - RESOLVED
Title: RE: ITSM 7 SRM Error ** BMC solved the issue, specifically Steven Duncan (very friendly and resourceful). In our 'Configure Incident Rules' form, we had 'Create Request on Submit' set to "Yes" ("No" is the default). This essentially means (p. 340 of the ITSM Config Guide) that, for the entire company listed in the record, a separate request ticket (SRM form) is created for those companies (customers) that will be using the Requester Console. Well, we had created users in that same company that had no login id. The problem occurred because we were saying for that company, we were saying that the customer would have no access to the system yet wanted to create a request that they couldn't see anyway. So now that I understand the problem, I think Remedy should have somehow prevented this error from happening or at least provide a better error message. They could have made the login id field required if 'Create Request on Submit' was already set to "Yes". It would have saved a lot of time. - Greg From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Thursday, August 31, 2006 3:44 PMTo: arslist@ARSLIST.ORGSubject: Re: ITSM 7 SRM Error ** Greg: Is this on one particular machine? If so, you may need to do some work, but I would start with uninstalling, powering down the machine (not just restarting) and then power it back up and install again. Sometimes systems get really confused if you don't restart between an uninstall and an install. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Orndorff, Greg Sent: Thursday, August 31, 2006 3:30 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 SRM Error ** Joe and Lars - Thanks for responding. I'm the user and have 'God' permissions. This application is out of the box with all the forms and workflow already created by BMC. We have not changed anything; we're just using/testing the application. I should have stated that my question is directed to just those who have installed ITSM 7.0, i.e. the non-Developers. I'm not real hopeful as it doesn't appear that a lot of people have ITSM 7.0 installed. - Greg From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Wednesday, August 30, 2006 5:45 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 SRM Error ** Are you doing a Push Fields operation on submit either using a filter or an Active Link to another form that does not allow those users to write to the fields that your system is complaining about? Check the permissions of those users on that form... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Greg Orndorff [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, August 30, 2006 8:30:46 PM Subject: ITSM 7 SRM Error When submitting an Incident, I and another user get the following message: "ARERR [326] Required field cannot be reset to a NULL value: SRM: RequestInterface_Create (100337) ARERR [326] Required field cannot be reset to a NULL value: SRM: RequestInterface_Create: Login ID" It prevents us from submitting the ticket. All other users are fine. At one point, I was able to submit Incidents. I've tried completely uninstalling and reinstalling to no avail. When we log in on other machines though, it works fine. I've logged a ticket with BMC and sent the filter log to them but haven't heard anything back. We're using Windows XP. Has anyone else experienced this error? Thanks, Greg Orndorff Pegasus Solutions ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org/ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Error sending email
Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini -- * Rafael Bertolini * System Analyst Ícaro Technologies http://www.icaro.com.br *Work:* +55 19 3731 8308 *E-mail:* [EMAIL PROTECTED] *Fax:* +55 19 3731 8304 / A informação transmitida destina-se apenas à pessoa ou entidade a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto do computador. Este ambiente está sujeito a monitoramento. //The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This environment is subject to monitoring. / ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS - For Dan
** Let us not forget to thank Dan for the endless hours and time he dedicates all year long to keeping the ARSLIST up and running And for all his efforts year after year for pulling together the stat, the gifts and the entertainment to make the ARSList Awards a hit!! Thank You Dan for all your hard work year after year!! Herb Partlow President/CEO IB Technical Consulting, Inc. (O) 408-253-0344 (F) 408-253-0344 (C) 408-309-5316 [EMAIL PROTECTED] http://www.ibtechnicalconsulting.com __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS - PHOTOS
Where are all the photos? _ Search from any web page with powerful protection. Get the FREE Windows Live Toolbar Today! http://get.live.com/toolbar/overview ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
Title: RE: Setup Dev Server ** He said they were on 2 different servers From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Error sending email
What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form? Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server. If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA. Axton Grams Rafael Bertolini wrote: Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Setup Dev Server
What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy. Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS - For Dan
** I'll second that! He even keeps us in line to keep the list from becoming free-for-all - a thankless job. THANKS DAN!! At 01:07 PM 9/1/2006, you wrote: ** Let us not forget to thank Dan for the endless hours and time he dedicates all year long to keeping the ARSLIST up and running And for all his efforts year after year for pulling together the stat, the gifts and the entertainment to make the ARSList Awards a hit!! Thank You Dan for all your hard work year after year!! Herb Partlow President/CEO IB Technical Consulting, Inc. (O) 408-253-0344 (F) 408-253-0344 (C) 408-309-5316 [EMAIL PROTECTED] http://www.ibtechnicalconsulting.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Error sending email
** Rafael - Are you able to manually send an email through the Email Messages form to your address? Sound like this is more of a mail server configuration error than a Remedy one. [EMAIL PROTECTED]... Relaying denied You could also try telnetting to your SMTP server and testing. http://www.yuki-onna.co.uk/email/smtp.html hth, tony -- Tony Worthington [EMAIL PROTECTED] 262-703-6125 Rafael Bertolini [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/01/2006 01:59 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Error sending email Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini -- * Rafael Bertolini * System Analyst Ícaro Technologies http://www.icaro.com.br *Work:* +55 19 3731 8308 *E-mail:* [EMAIL PROTECTED] *Fax:* +55 19 3731 8304 / A informação transmitida destina-se apenas à pessoa ou entidade a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto do computador. Este ambiente está sujeito a monitoramento. //The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This environment is subject to monitoring. / ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Error sending email
Title: RE: Error sending email ** Rafael: The error message is coming back from your mail server. Is this server the same server that sends you your mail? What platform are you running your mail server on and which MTA are you using? James Mckenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rafael Bertolini Sent: Friday, September 01, 2006 11:59 AM To: arslist@ARSLIST.ORG Subject: Error sending email Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini -- * Rafael Bertolini * System Analyst Ícaro Technologies http://www.icaro.com.br *Work:* +55 19 3731 8308 *E-mail:* [EMAIL PROTECTED] *Fax:* +55 19 3731 8304 / A informação transmitida destina-se apenas à pessoa ou entidade a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto do computador. Este ambiente está sujeito a monitoramento. //The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This environment is subject to monitoring. / ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Deletion of non-reference entry mechanism
I dont see how that would work (you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. ) How dont see how it would work because I cannot lookup at the different forms dynamically in the same escalation. Unless I am wrong but here is what I was thinking about: Push 3 values in the OrphansToDelete form 1- The GUID 2- The parent form name 3- The child form name The problem is that I cannot use a generic way of querying on the proper form. I would need to do a SQL query but the table names vs the remedy schema are not nesserary the same. Can I get the real oracle table name from the Remedy schema name. I would then use the returned value to create an SQL query dynamically. >From there I will know if the entry is a real orphan or not. I need your help guys! Mathieu Pitre IT Business Systems Analyst Production Operation Computer Sciences Corporation Pratt Whitney Canada, Plant 1 Sametime: Mathieu Pitre office: 450-647-8008 x7030 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. L. J. Head [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/09/2006 02:12 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Deletion of non-reference entry mechanism Have you considered the possibility of preventing the orphans to begin with?...If you create an AL that happens on Window Close where Operation = CREATE that does a delete query on it's child tables base on the GUID you have already generated...if you wanted to keep it dynamic...you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre Sent: Friday, September 01, 2006 8:33 AM To: arslist@ARSLIST.ORG Subject: Deletion of non-reference entry mechanism Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Error sending email
Title: RE: Error sending email ** Axton: You just about hit the nail on the head. However, I've seen mail servers (MTA) that are setup to allow local delivery only where this error (SMTP 550) happens. The fix is to reconfigure the MTA to allow delivery to a limited set of addresses only. Also, thanks for the wiki page for MTA conversations. It's filed away. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: Error sending email What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form? Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server. If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA. Axton Grams Rafael Bertolini wrote: Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule .java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini __20060125___This posting was submitted with HTML in it___
FIXED: arimportcmd on Escalation
** I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the elsetab and it ran. Den ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 12:58 PM Den: Why are you doing things the hard way? Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so: /opt/ar/bin/somescript_exists_here.sh In the script the first line is: #!/bin/sh # some comments here. Commands # Yet another comment It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation ** Okay I thought back to basics was the best way to do this. So I ran the process: /bin/env /export/home/remps/import/env.txt To get anything out, and nothing.** PC Wai [EMAIL PROTECTED] 8/30/2006 11:44 AM Hi Den, Does the mapping file directory (-d) or some files has the right file path? When the AR System shells out the process, it may not have the same system environment as you run it interactively. Regards PC Wai From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation ** I'm running the script as a user, this is the generic Remedy system user on the sun box. This is the user that owns the arsystem and files. The script has Read Execute by everyone, the .arm file has read by everyone and so does the .csv file. ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 10:17 AM Den: This may sound stupid, but are you running Remedy ARS as root or another user? If it is another user, make sure that user has access to the entire file structure of at least read/execute and that the user has read and execute permissions. Of course, this does not apply if the user is root. James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation ** Okay I tried that and still no luck without the @@: Den ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 10:03 AM Den: Loose the two at signs and the colon. All escalations run against the server and never against the client. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:01 AM To: arslist@ARSLIST.ORG Subject: arimportcmd on Escalation ** Hey Guys I'm trying to get s script to execute on an escalation, the scipt works fine if we execute it via a shell, but not through an escalation. In the escalation I have it as a run process : @@:/export/home/remps/import/smsimport.sh Which doesn't do anything. Any ideas? Den __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick WSent: Friday, September 01, 2006 12:12 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** He said they were on 2 different servers From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Axton: What I seen was that the tablespace was the same name, which with two servers is not a problem. I've delt with one admin, here on the list, that had installed the production and development to the same server, same tablespace. Disaster was the result. As far as running two or more servers against the same instance. No problem. However, you will need to size the PGA and SGA to accomidate the additional load. I prefer what John has done. Two servers, two instances and never the two shall meet. And if you are covered by SarbOx, you may have to do things this way. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy. Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___
Re: Error sending email
Yea, doing the conversations manually will tell you where the problem is, and the docs/google for whatever MTA is in use should tell you how to fix it. Axton McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Axton: You just about hit the nail on the head. However, I've seen mail servers (MTA) that are setup to allow local delivery only where this error (SMTP 550) happens. The fix is to reconfigure the MTA to allow delivery to a limited set of addresses only. Also, thanks for the wiki page for MTA conversations. It's filed away. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: Error sending email What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form? Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server. If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA. Axton Grams Rafael Bertolini wrote: Hi all!!! I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848) at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323) at com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74) at com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule .java:1468) at com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360) at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268) at java.lang.Thread.run(Thread.java:534) It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine). What else could be? ARS 6.3 Solaris 8 TIA, Rafael Bertolini __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: FIXED: arimportcmd on Escalation
Title: RE: FIXED: arimportcmd on Escalation ** Den: Now you explan this. I've seen this before where the escalation would not run because there was no qualification. Strange as it should run if there is no qualification every time. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Friday, September 01, 2006 12:35 PM To: arslist@ARSLIST.ORG Subject: FIXED: arimportcmd on Escalation ** I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the else tab and it ran. Den ** McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] 8/30/2006 12:58 PM Den: Why are you doing things the hard way? Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so: /opt/ar/bin/somescript_exists_here.sh In the script the first line is: #!/bin/sh # some comments here. Commands # Yet another comment It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it) James McKenzie L-3 GSI __20060125___This posting was submitted with HTML in it___
Re: Deletion of non-reference entry mechanism
** My approach is a preventative measure instead of an escalation type of thing Setup: Form with fields 'Parent' and 'Child' This form keeps track of al of your parent child relationships...which forms have children forms and the sort Form with fields 'Parent GUID' and'Parent Form' This will be the temp holding place to store your 'delete these things' record You then would have an AL that fires on close of any window that is in submit mode...maybe doing some sort of flag field that fires on after submit that indicates if a submit occurred and not fire if one did. This AL could do a push to your 'delete these things' form with its GUID and $SCHEMA$. That form might have a table field that lists all of the children forms of that $SCHEMA$ value that was submitted. This filter does a loop through the table and issues a delete query to each form in the table for the GUID submitted. I have never performed this type of thing so I'm just coding off the top of my head...and it might not work quite like I'm thinking...but it should cause any submit window that is closed without a submit to cause each of its children windows to be purged of any children records that were created immediately...instead of doing it in an escalation Feel free to contact me off list if you have questions about what I'm thinking about L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu PitreSent: Friday, September 01, 2006 1:32 PMTo: arslist@ARSLIST.ORGSubject: Re: Deletion of non-reference entry mechanism I dont see how that would work (you could pushthe Form and GUID to another form to create a new record and then have thatone do a lookup of which tables are children of the parent in question andthen have a filter do the delete query action. ) How dont see how it would work because I cannot lookup at the different forms dynamically in the same escalation. Unless I am wrong but here is what I was thinking about: Push 3 values in the OrphansToDelete form 1- The GUID 2- The parent form name 3- The child form name The problem is that I cannot use a generic way of querying on the proper form. I would need to do a SQL query but the table names vs the remedy schema are not nesserary the same. Can I get the "real" oracle table name from the Remedy schema name. I would then use the returned value to create an SQL query dynamically. From there I will know if the entry is a real orphan or not. I need your help guys! Mathieu Pitre IT Business Systems AnalystProduction OperationComputer Sciences CorporationPratt Whitney Canada, Plant 1Sametime: Mathieu Pitreoffice: 450-647-8008 x7030This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "L. J. Head" [EMAIL PROTECTED] Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 01/09/2006 02:12 PM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Deletion of non-reference entry mechanism Have you considered the possibility of preventing the orphans to beginwith?...If you create an AL that happens on Window Close where Operation ="CREATE" that does a delete query on it's child tables base on the GUID youhave already generated...if you wanted to keep it dynamic...you could pushthe Form and GUID to another form to create a new record and then have thatone do a lookup of which tables are children of the parent in question andthen have a filter do the delete query action. L. J. HeadSoftware EngineerRemedy Approved Consultant-Original Message-From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu PitreSent: Friday, September 01, 2006 8:33 AMTo: arslist@ARSLIST.ORGSubject: Deletion of non-reference entry mechanismHi all,I need your attention on this one.I am becoming creative and I wonder if I should. I am trying to figure howto automaticly delete the entries which have
Re: Setup Dev Server
I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley Help Desk Analyst 130 Royall Street Canton, MA 02021 Mail Center 1W 781-737-3564 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at
Re: Setup Dev Server
Title: RE: Setup Dev Server ** Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server 15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible. Anyboby have something similar. Or suggestion. John Kelley
Re: Setup Dev Server
That's why it's better to look up the schema ids and field ids in your workflow based on the form/field names, then use var substitution in your direct sql (e.g. select C$fieldid1$ from T$schemaid1$ where C$fieldid2$ = 'some literal value or field'). Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Fred: (Wacking self on head). Thanks. Now the next question is how did they duplicate the database? There are variables in the Remedy metadata that will error out if they did a physical vice ARExport/ARImport move of data. This may be causing the problem. I tried a physical move from one tablespace to another on the same server and Oracle would not let me. James Mckenzie L-3 GSI -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, September 01, 2006 12:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** He said they were on 2 different servers -- -- *From:* Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC HQISEC/L3 *Sent:* Friday, September 01, 2006 1:41 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Setup Dev Server ** Fred: I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions. Solution: Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.) James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 01, 2006 11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server Do you have the environment variables set up correctly? The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. ORACLE_SID and TWO_TASK set for your dev database. TNS_ADMIN pointing to your tnsnames.ora file. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley Sent: Friday, September 01, 2006 10:31 AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server Hi List: First time emailer. Long time reader. I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. We took a copy of production DB, and placed it on a different oracle Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb listener. The name of the DB is the same for Production and Dev. Which is OK. They are on different servers. When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server. Here is the Error 15:40:39 An error was encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact and accessible 15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories 15:40:40 Setup is
Re: ITSM 7.0 Rolled Out?
Greg, I am running the full ITSM 7.0 suite on a dev server right now and we are in the first phase of a rollout project. My first impressions are pretty good, besides the initiall problems during the install. What kind of bugs have you found and did you submit them to BMC ? You can expect some bugs with a x.0 version, which is why most people will wait for 7.1 This is still pretty new, even for Remedy support and consultants. You are right, there is quite a bit more configuration involved and hardly any 'sample' data, like there was in 6.3 and previous versions. I would also like to know if there are already any ITSM implementations in production, which I doubt since the ITSM apps have only been out for just over a month unless someone already did a lot of work during the Early Access program. Rgds, Chris ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: FIXED: arimportcmd on Escalation
** James I tried that, and the 1=1 but neither works. Because there are no records, the system won't run anything on the if side. Den ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 9/1/2006 2:42 PM Den: That explains a lot. Why not just run the escalation as a timed event with no run-if statement and see if that works?I think that if this does not work the old '1=1' should force it to work. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Den FongSent: Friday, September 01, 2006 1:28 PMTo: arslist@ARSLIST.ORGSubject: Re: FIXED: arimportcmd on Escalation ** Okay I found out why now, there is a process that runs just before this one and it removes all the records from this form. So therefore when the escalation runs there are no records and does not execute the if tab and uses the else tab instead. Den ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 9/1/2006 1:44 PM Den: Now you explan this. I've seen this before where the escalation would not run because there was no qualification. Strange as it should run if there is no qualification every time. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Friday, September 01, 2006 12:35 PM To: arslist@ARSLIST.ORG Subject: FIXED: arimportcmd on Escalation ** I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the else tab and it ran. Den ** "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 12:58 PM Den: Why are you doing things the hard way? Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so: /opt/ar/bin/somescript_exists_here.sh In the script the first line is: #!/bin/sh # some comments here. Commands # Yet another comment It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it) James McKenzie L-3 GSI __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS - For Dan
Apparently not entirely thankless :-) The plaque's are fedexed in the winner's directions. I have included some of this years pin and Magnetic Words. Patrick (Zandi): In case you hear, I used Zandiish more than once this year, I promise not to again for at least 12 months. Has anyone mentioned that the Next BUW has been scheduled? October 29th, 2007 (in other words, 14 months from now). Place not mentioned yet, perhaps in the closing session Daniel ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS - For Dan
Daniel, I did not hear anyone speak of a location, but I am guessing -- being late October -- maybe Orlando??? Celebration would, of course, be in Halloween attire... Kelvin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Bloom Sent: Friday, September 01, 2006 6:31 PM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS - For Dan Apparently not entirely thankless :-) The plaque's are fedexed in the winner's directions. I have included some of this years pin and Magnetic Words. Patrick (Zandi): In case you hear, I used Zandiish more than once this year, I promise not to again for at least 12 months. Has anyone mentioned that the Next BUW has been scheduled? October 29th, 2007 (in other words, 14 months from now). Place not mentioned yet, perhaps in the closing session Daniel ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS - For Dan
** A double Amen from me! Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie RockwoodSent: Friday, September 01, 2006 12:21 PMTo: arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For Dan ** I'll second that!He even keeps us in line to keep the list from becoming free-for-all - a thankless job.THANKS DAN!!At 01:07 PM 9/1/2006, you wrote: ** Let us not forget to thank Dan for the endless hours and timehe dedicates all year long to keeping the ARSLIST up and runningAnd for all his efforts year after year for pulling togetherthe stat, the gifts and the entertainment to make the ARSListAwards a hit!!Thank You Dan for all your hard work year after year!!Herb PartlowPresident/CEOIB Technical Consulting, Inc.(O) 408-253-0344(F) 408-253-0344(C) 408-309-5316[EMAIL PROTECTED]http://www.ibtechnicalconsulting.com__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Remedy ARS Developer Needed in NJ
Hi All! I currently have a permanent opening in the Parsippany, NJ area for a Senior Remedy Developer. I've outlined the position below. Please feel free to call or email me should you have any questions. Enjoy your weekend! Must have three plus years experience of ARS development and support. Intimately involved in Problem Management and Change Managements methods and services. Project Management and Requirements Analysis skills. Technically proficient in Perl, Sybase, HTML, Java, Unix, NT, Crystal Reports or other reporting tool, and most Remedy off-the-shelf products. Strong experience in being the technical lead for multiple projects. Must have excellent problem solving skills. Must be detail oriented and capable of writing technical documentation. Must be able to work under pressure and in a fast paced environment. Strong computer aptitude with Microsoft Office. Strong interpersonal skills. Kathleen Kathco Recruiting 973-257-8890 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org