Re: server crash ARS 7.0.1 web services ORACLE 10 Solaris
It's a defect in arserverd. Log a ticket with your support channel; they are the only ones that can fix the issue. Generate a core file to include with the ticket, as this will expedite the resolution of the issue from the vendor. The data is as important as the stack trace when debugging. http://docs.sun.com/app/docs/doc/820-0434/gbpjz?a=view You may request a patch 8 debug build, then generate the core file; this will cause the core file to include debugging symbols. You can check whether the build of arserverd you have is stripped or not using file(1). Axton Grams On Tue, Nov 4, 2008 at 10:05 AM, anil RAI [EMAIL PROTECTED] wrote: ** Dear All, The AR Server gets restarted at regular Mon Nov 03terval of time. Mostly tickets were logged to the remedy through web services. 700 users are concurrently logged Mon Nov 03to the remedy system and on an average 40,000 tickets are logged every day. The environment is ARS 7.0.1 patch 8, OS is Solaris, Web server is Tomcat 5.0.28, and Database is ORACLE 10g. arerror.log is as bellows. Timestamp: Mon Nov 03 2008 11:30:42.5492 Thread Id: 20 Version: 7.0.01 Patch 008 200805271830 May 27 2008 19:12:08 ServerName: t1u014 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 144664 RPC Call: 121 (XMLGE) RPC Queue: 390620 Client: User Demo from Webservice (protocol 12) at IP address 2db21fcd6e676d68 Form: LoggMon Nov 03g On: Stacks: _/remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:DumpStackTrace+0xc8 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:SignalTrapProc+0x1a8 /lib/libc.so.1:0xc01dc /lib/libc.so.1:0xb52d4 /lib/libc.so.1:__lwp_kill+0x8 [ Signal 6 (ABRT)] /lib/libc.so.1:abort+0xd0 /usr/lib/libCrun.so.1:__1cH__CimplRdefault_termMon Nov 03ate6F_v_+0x4 /usr/lib/libCrun.so.1:__1cH__CimplMex_termMon Nov 03ate6F_v_+0x2c /usr/lib/libCrun.so.1:0x5ba4 /usr/lib/libCrun.so.1:__1cG__CrunRex_chk_unexpected6F_v_+0xa8 /usr/lib/libCrun.so.1:__1c2n6FI_pv_+0x98 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:CreateXMLParserHandle+0xec /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:GetComplexEntryGetFromXML+0x30 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:arxmlgetentry_12_svc+0x588 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:HandleRPCs+0x14a64 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:WorkerThread+0x74c /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:RestartableThreadMaMon Nov 03+0x68 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:UnixThreadStartRoutMon Nov 03e+0x118 /lib/libc.so.1:0xc00b0 Mon Nov 03 11:32:32 2008 Dispatch : Cannot establish a network connection to the AR System server (t1u014.ir : RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90 Mon Nov 03 11:33:32 2008 Dispatch : Cannot establish a network connection to the AR System server (t1u014. cell.ir: RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90 Mon Nov 03 11:35:32 2008 AssignEng : AR System Application server termMon Nov 03ated -- fatal error encountered (ARAPPNOTE 4501) Mon Nov 03 11:37:48 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 11:38:18 2008 Approve : Some of the fields have been truncated fults list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 12:48:26 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:22:40 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:23:01 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:29:58 2008 Approve : MissMon Nov 03g data Mon Nov 03 the SQL database (ARERR 556) Mon Nov 03 14:29:58 2008 Approve : (H923) Mon Nov 03 14:59:17 2008 390620 : User is currently connected from another machMon Nov 03e (ARERR 9093) Mon Nov 03 14:59:17 2008 Client already connected - username:imtiaz.r, client-type:Remedy User - User has Override option Mon Nov 03 14:59:19 2008 390620 : User is currently connected from another machMon Nov 03e (ARERR 9093) Mon Nov 03 14:59:19 2008 Client already connected - username:imtiaz.r, client-Nov 03e (ARERR 9093) Mon Nov 03 14:59:22 2008 Client already connected - username:imtiaz.r, client-type:Remedy User - User has
Re: 2009 BMC World??
So much for budgeting... that's FY 2010 for some of us. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Sent: Tuesday, November 04, 2008 6:07 AM To: arslist@ARSLIST.ORG Subject: Re: 2009 BMC World?? ** http://www.bmcworldcommunity.com/conferences It says rescheduled to Oct, 2009. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] On Nov 3, 2008, at 11:16 PM, Steven Pataray wrote: ** Has there been any rumors yet on when/where next years BMC World will be? It's budgeting time again and would like to make sure there is enough money. Mahalo's, Steve Pataray __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 2009 BMC World??
http://www.bmcworldcommunity.com/conferences It says rescheduled to Oct, 2009. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [EMAIL PROTECTED] On Nov 3, 2008, at 11:16 PM, Steven Pataray wrote: ** Has there been any rumors yet on when/where next years BMC World will be? It's budgeting time again and would like to make sure there is enough money. Mahalo's, Steve Pataray __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
BasicAuthenticator
Is there a site where I can download a copy of the Java based BasicAuthenticator code? If not, can anybody send me a copy of the latest version. We are running MT 7.1.0 p5. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Server Name Change
Dip, Can you please share what you've documented with the list? Julie Rockwood From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dip Patel Sent: Monday, November 03, 2008 7:56 AM To: arslist@ARSLIST.ORG Subject: Re: Server Name Change ** We do Environment Refresh from Production for new environments have documented registry changes other changes required to change the servername.However if you've installed CMDB 2.0 or greater version ,its advisable to manually install it as it stores the server name in binaries in some places not easy to detect. n Mon, Nov 3, 2008 at 7:59 AM, Steve Michadick [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Has anyone changed the server name running ARS 7.1 ITSM 7.0? We have a hot backup server with the same name as our production server, but on a different domain and with a different IP. We found out that they will eventually be on the same domain, so we'll have to change the name of our hot backup server. Anyone have to do this before? Since we backup the production db and restore it to the hot backup server, we are wondering how this will effect changing the name of the server. Both are Win2003 SP2 OS with MS SQL 2005 on a separate server. Steve Michadick Remedy Engineer Marine Corps Network Operations and Security Center (MCNOSC) Phone: 703-432-6726 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Changing Login Name
Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Login Name
The obvious problem is that shafqatayaz becomes 123456 in the submitter field. You could use the Authentication Login Name reserved field to get round it. Matt Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Login Name
You should protest this change... who wants to login with numbers anyway?? It's kind of prison-ish. Just kidding... Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Tuesday, November 04, 2008 12:05 PM To: arslist@ARSLIST.ORG Subject: Changing Login Name ** Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: On Call System
Just wondering -- would you like to provide visibility into the schedules of the people on-call? Example: A person might want to see their schedule in a calendar format for the week? A manager might want to see their groups schedule for a week? If so - please take a look at Kinetic Calendar. http://www.kineticdata.com/Products/KineticCalendar/index.html The original goal of Kinetic Calendar was to be able to view On-call schedules for Remedy. However, we built it much more generically than that - and most people use it to view change management information. We actually have a writeup on how to use Kinetic Calendar to view/ manage/change your on-call schedule of people for ITSM7 -- if you have interest - let me know. Thanks, -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [EMAIL PROTECTED] On Oct 30, 2008, at 2:58 PM, lisakemes wrote: I've decided to go with Fred's suggestion and just have the user click on a start time and end time as to when they are on call. One question, have you had any problems with DST? Grooms, Frederick W wrote: No. None of the users have asked for that option (s, Dont give them the idea). Our on call data is like... GroupUser StartEnd Remedy Fred 2/6/2008 8:00 AM 2/13/2008 8:00 AM Remedy Fred 2/13/2008 8:00 AM 2/20/2008 8:00 AM Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, February 21, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** Another question, do you have a recurring option? So someone could enter a start date and end date (let's say 5:00pm to 7:00am) and then recur that for 7 days or weeks or months? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, February 21, 2008 2:39 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** What we do here is give the user's start and end fields so we don't have to have a record per day. A group that may have 1 person on call for a week would only have 1 record instead of 7. When displaying the on call we show any record whose start = $TIMESTAMP$ and end = $TIMESTAMP$. To validate on Submit or Modify we check that the Start Date/Time = an ending Date/Time for the same group (or this start is in between another records start/end dates). Showing it in a calander is a bit trickier but can be done. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, February 21, 2008 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** The application is going to cover a year. Each group is going to have their own oncall schedule so that our help desk knows who to call after hours for an urgent ticket. We are a 24/7 shop. It's all in Microsoft Access right now (a different access database for each group that I tie in all together through a website). It's horrible to maintain, so we are going to develop something in the AR System (7.0.1 Patch 005, Windows 2003, Oracle 10i) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore Sent: Thursday, February 21, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** Lisa, Can you provide a little more information about your app? For example how is the user prompted for his/her oncall schedule? What period of time does this cover, week, month, reoccurring, variable? Just off the top of my head, if you were getting the users to enter their oncall schedule for let's say a month, then all you need to do is a tablewalk check for days missing between the beginning and end of the month. Assuming this was a 24/7 shop. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Kemes, Lisa [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/21/2008 01:11 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject On Call System ** I'm creating an on call system for our company and I would like to make sure that the end user does not accidentally skip a date or a time. So when they are entering information as to who is on call I don't want (this would be in a table): Feb 20 Lisa Kemes Feb 22 Lisa Kemes Feb 23 Lisa Kemes I would like them to see: Feb 20 Lisa Kemes Feb 21 Feb 22 Lisa Kemes Feb 23 Lisa Kemes Is there any easy way to do this? (other than creating a separate table with every hour and date on it). Just wondering/brain storming Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax
JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas or Houston
We are seeking Mid and Senior level Remedy Consultants based in Texas- preferably Houston or Dallas. *These are permanent positions with generous salary, bonus, benefits and vacation packages. Senior Level Candidates must have ITSM implementation experience. If you're interested please email me your resume as a PDF or MS Word document and we can coordinate a time to talk. The job description is below. You will be employed at Column Technologies as a Consulting Applications Engineer to architect, deploy, support, and in some cases, train the Remedy product to our growing nationwide customer base. Your responsibilities will include but not limited to: *Provide maintenance tips for BMC Remedy applications *Configuration of BMC Remedy applications *Customization of BMC Remedy applications *Conduct Requirements Analysis sessions and customer workshops *Provide solution designs based on requirements *Scope and develop custom applications *Provide system and customization documentation *System troubleshooting *Installation and configuration of all BMC Remedy applications *Implement integrations to the BMC Remedy applications *Assist the Frontline Support team when not working on active projects You will primarily serve our customers who are located in the southwest but travel will be required based on project needs. Thanks! Melissa Wish Corporate Recruiter Column Technologies, Inc. Home Office: 718-399-2136 Cell/Evenings: 917-748-7104 E-Fax: 646-349-3799 Email: [EMAIL PROTECTED] www.columnit.com BMC Remedy Partner of the Year 2000 - 2004 BMC Solution Partner of the Year 2004 - 2006 BMC Fastest Growing Worldwide Partner - 2006 Inc. 500 Fastest Growing Private Companies - 2006 BMC 2007 Americas and Worldwide Top Solution Provider VARBusiness- North America's Largest 500 IT Solution Providers, 2007 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RSP 7.X?
I'm thinking about taking the BMC Remedy AR System 7.x: Application Requirements Analysis, Design Development class and getting my RSP certification. If anyone has taken it, what's the level of difficulty in your opinion? I was going to take it in March, but at the end of 2008, simply taking the What's New in 7.x is not going to be good enough anymore. Here's what I've taken so far: BMC Remedy AR System 6.x: Administering - Part 1 (WBT) BMC Remedy AR System 6.x: Administering - Part 2 BMC Remedy AR System 6.x: Administering - Part 3 BMC Remedy AR System 7.x: Performance Tuning and Troubleshooting If I take Remedy AR System 7.x: Application Requirements Analysis, Design Development and take the test before 2008, I'll only have to take the What's New in 7.x WBT (which I think I already took) After 2008, you have to either take 7.x Part 1, 2, and 3, or take an equivalency exam for Part 1 and 2 (and still take the class for Part 3) for 7.x. So now I'm going to have to take this class in December and I was hoping for a nice holiday with no studying, but I guess that's not going to be. When studying for this exam, are the books the main resource? Thanks everyone! Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: PL/SQL function call via set fields.
Hey B,
I think this is the same error I get whenever an attempt is made to use
the SELECT on the first attempt. But, it works on the second attempt
and every other attempt until Remedy server is restarted. The Oracle
error is basically saying that Remedy is not defining the variable
before it is getting to Oracle.
HTH,
Kelvin
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears
Sent: Tuesday, November 04, 2008 1:16 PM
To: arslist@ARSLIST.ORG
Subject: PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RSP 7.X?
When I took RAD 2 years ago it wasn't too hard, simple things like how to take a requirements doc and turn it into functional requirements, how to get information from the customer that they didn't initially provide, that sort of thing. I was told that the entire process would be changing significantly and be more ITSM based than generic like I dealt with... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, November 04, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: RSP 7.X? ** I'm thinking about taking the BMC Remedy AR System 7.x: Application Requirements Analysis, Design Development class and getting my RSP certification. If anyone has taken it, what's the level of difficulty in your opinion? I was going to take it in March, but at the end of 2008, simply taking the What's New in 7.x is not going to be good enough anymore. Here's what I've taken so far: BMC Remedy AR System 6.x: Administering - Part 1 (WBT) BMC Remedy AR System 6.x: Administering - Part 2 BMC Remedy AR System 6.x: Administering - Part 3 BMC Remedy AR System 7.x: Performance Tuning and Troubleshooting If I take Remedy AR System 7.x: Application Requirements Analysis, Design Development and take the test before 2008, I'll only have to take the What's New in 7.x WBT (which I think I already took) After 2008, you have to either take 7.x Part 1, 2, and 3, or take an equivalency exam for Part 1 and 2 (and still take the class for Part 3) for 7.x. So now I'm going to have to take this class in December and I was hoping for a nice holiday with no studying, but I guess that's not going to be. When studying for this exam, are the books the main resource? Thanks everyone! Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Microsoft MapPoint
Does anyone out there have any experience with integrating Remedy with MapPoint? I am trying to put something together to pass data from Remedy to MapPoint on demand. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RSP 7.X?
Lisa, I found all of the classes fairly easy and straightforward. If you've been developing remedy solutions for awhile, especially if you have much custom experience, then the classes should be cake for you. The final class, where you actually earn your RSP, involves spending around 3 or 4 days creating an application. They will give you a little to start with, and then you finish the rest. The people in my class ranged on their abilities. We had two people finish a day or day and a half early, and then, from what I understand, a few people finished on the last day. Mainly go in it with confidence, and don't get freaked out. They are good classes and the RSP is worth it. Gary Opela, Jr. RSP since February 2008 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, November 04, 2008 12:21 PM To: arslist@ARSLIST.ORG Subject: RSP 7.X? ** I'm thinking about taking the BMC Remedy AR System 7.x: Application Requirements Analysis, Design Development class and getting my RSP certification. If anyone has taken it, what's the level of difficulty in your opinion? I was going to take it in March, but at the end of 2008, simply taking the What's New in 7.x is not going to be good enough anymore. Here's what I've taken so far: BMC Remedy AR System 6.x: Administering - Part 1 (WBT) BMC Remedy AR System 6.x: Administering - Part 2 BMC Remedy AR System 6.x: Administering - Part 3 BMC Remedy AR System 7.x: Performance Tuning and Troubleshooting If I take Remedy AR System 7.x: Application Requirements Analysis, Design Development and take the test before 2008, I'll only have to take the What's New in 7.x WBT (which I think I already took) After 2008, you have to either take 7.x Part 1, 2, and 3, or take an equivalency exam for Part 1 and 2 (and still take the class for Part 3) for 7.x. So now I'm going to have to take this class in December and I was hoping for a nice holiday with no studying, but I guess that's not going to be. When studying for this exam, are the books the main resource? Thanks everyone! Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RSP 7.X?
Not so much difficult technically, it really just helps to round out your 'consulting' skills. All about how to best conduct the full life cycle of the software development process. Back when I took them, The RADD class was basically a shorter version of the RAC class. Mark Mark Blankenship blocked::mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] blocked::http://www.linkedin.com/in/blankenshipmg http://www.linkedin.com/in/blankenshipmg _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, November 04, 2008 12:21 PM To: arslist@ARSLIST.ORG Subject: RSP 7.X? ** I'm thinking about taking the BMC Remedy AR System 7.x: Application Requirements Analysis, Design Development class and getting my RSP certification. If anyone has taken it, what's the level of difficulty in your opinion? I was going to take it in March, but at the end of 2008, simply taking the What's New in 7.x is not going to be good enough anymore. Here's what I've taken so far: BMC Remedy AR System 6.x: Administering - Part 1 (WBT) BMC Remedy AR System 6.x: Administering - Part 2 BMC Remedy AR System 6.x: Administering - Part 3 BMC Remedy AR System 7.x: Performance Tuning and Troubleshooting If I take Remedy AR System 7.x: Application Requirements Analysis, Design Development and take the test before 2008, I'll only have to take the What's New in 7.x WBT (which I think I already took) After 2008, you have to either take 7.x Part 1, 2, and 3, or take an equivalency exam for Part 1 and 2 (and still take the class for Part 3) for 7.x. So now I'm going to have to take this class in December and I was hoping for a nice holiday with no studying, but I guess that's not going to be. When studying for this exam, are the books the main resource? Thanks everyone! Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
server crash ARS 7.0.1 web services ORACLE 10 Solaris
Dear All, The AR Server gets restarted at regular Mon Nov 03terval of time. Mostly tickets were logged to the remedy through web services. 700 users are concurrently logged Mon Nov 03to the remedy system and on an average 40,000 tickets are logged every day. The environment is ARS 7.0.1 patch 8, OS is Solaris, Web server is Tomcat 5.0.28, and Database is ORACLE 10g. arerror.log is as bellows. Timestamp: Mon Nov 03 2008 11:30:42.5492 Thread Id: 20 Version: 7.0.01 Patch 008 200805271830 May 27 2008 19:12:08 ServerName: t1u014 Database: SQL -- Oracle Hardware: sun4u OS: SunOS 5.10 RPC Id: 144664 RPC Call: 121 (XMLGE) RPC Queue: 390620 Client: User Demo from Webservice (protocol 12) at IP address 2db21fcd6e676d68 Form: LoggMon Nov 03g On: Stacks: _/remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:DumpStackTrace+0xc8 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:SignalTrapProc+0x1a8 /lib/libc.so.1:0xc01dc /lib/libc.so.1:0xb52d4 /lib/libc.so.1:__lwp_kill+0x8 [ Signal 6 (ABRT)] /lib/libc.so.1:abort+0xd0 /usr/lib/libCrun.so.1:__1cH__CimplRdefault_termMon Nov 03ate6F_v_+0x4 /usr/lib/libCrun.so.1:__1cH__CimplMex_termMon Nov 03ate6F_v_+0x2c /usr/lib/libCrun.so.1:0x5ba4 /usr/lib/libCrun.so.1:__1cG__CrunRex_chk_unexpected6F_v_+0xa8 /usr/lib/libCrun.so.1:__1c2n6FI_pv_+0x98 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:CreateXMLParserHandle+0xec /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:GetComplexEntryGetFromXML+0x30 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:arxmlgetentry_12_svc+0x588 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:HandleRPCs+0x14a64 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:WorkerThread+0x74c /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:RestartableThreadMaMon Nov 03+0x68 /remedy/arsystem/product/remedy7/bMon Nov 03/arserverd:UnixThreadStartRoutMon Nov 03e+0x118 /lib/libc.so.1:0xc00b0 Mon Nov 03 11:32:32 2008 Dispatch : Cannot establish a network connection to the AR System server (t1u014.ir : RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90 Mon Nov 03 11:33:32 2008 Dispatch : Cannot establish a network connection to the AR System server (t1u014. cell.ir: RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90Mon Nov 03 11:35:32 2008 AssignEng : AR System Application server termMon Nov 03ated -- fatal error encountered (ARAPPNOTE 4501) Mon Nov 03 11:37:48 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 11:38:18 2008 Approve : Some of the fields have been truncated fults list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 12:48:26 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:22:40 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:23:01 2008 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Mon Nov 03 14:29:58 2008 Approve : MissMon Nov 03g data Mon Nov 03 the SQL database (ARERR 556) Mon Nov 03 14:29:58 2008 Approve : (H923) Mon Nov 03 14:59:17 2008 390620 : User is currently connected from another machMon Nov 03e (ARERR 9093) Mon Nov 03 14:59:17 2008 Client already connected - username:imtiaz.r, client-type:Remedy User - User has Override option Mon Nov 03 14:59:19 2008 390620 : User is currently connected from another machMon Nov 03e (ARERR 9093) Mon Nov 03 14:59:19 2008 Client already connected - username:imtiaz.r, client-Nov 03e (ARERR 9093) Mon Nov 03 14:59:22 2008 Client already connected - username:imtiaz.r, client-type:Remedy User - User has Override option Mon Nov 03 14:59:31 2008 390620 : User is currently connected from another machMon Nov 03e (ARERR 9093) Mon Nov 03 14:59:31 2008 Client already connected - username:imtiaz.r, client-type:Remedy User - User has Override option Mon Nov 03 14:59:50 2008 390620 : User is currently connected from another Mon Nov 03 16:37:18 2008 390620 : AR System server termMon Nov 03ated when a signal/exception was received by the server (ARNOTE 20) Mon Nov 03 16:37:18 2008 6 Timestamp: Mon Nov 03 2008 16:37:18.8560 Thread Id: 17 Version: 7.0.01 Patch 008 200805271830 May 27 2008 19:12:08 ServerName: t1u014 Database:
Re: PL/SQL function call via set fields.
You may want to default the value in your get_hash function in Oracle
Try something like
CREATE OR REPLACE FUNCTION GET_hash (in_value VarChar2 :=
'somedefault') return VarChar2 is
for your function definition
This way if Remedy does not have a value for current_field when you call
the function it will use the default value
Another thing you may look at is to see exactly what Remedy is sending
to the database by looking in the SQL logs.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wallace, Kelvin
Sent: Tuesday, November 04, 2008 12:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: PL/SQL function call via set fields.
Hey B,
I think this is the same error I get whenever an attempt is made to use
the SELECT on the first attempt. But, it works on the second attempt
and every other attempt until Remedy server is restarted. The Oracle
error is basically saying that Remedy is not defining the variable
before it is getting to Oracle.
HTH,
Kelvin
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears
Sent: Tuesday, November 04, 2008 1:16 PM
To: arslist@ARSLIST.ORG
Subject: PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: PL/SQL function call via set fields.
Have you tried this?
BEGIN
get_hash('$current_field$');
END;
Thanks,
Sean
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Wallace, Kelvin
Sent: Tuesday, November 04, 2008 1:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: PL/SQL function call via set fields.
Hey B,
I think this is the same error I get whenever an attempt is made to use
the SELECT on the first attempt. But, it works on the second attempt
and every other attempt until Remedy server is restarted. The Oracle
error is basically saying that Remedy is not defining the variable
before it is getting to Oracle.
HTH,
Kelvin
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears
Sent: Tuesday, November 04, 2008 1:16 PM
To: arslist@ARSLIST.ORG
Subject: PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: stripping HTML from email
Remove and from users' keyboards. Jennifer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ramey, Anne Sent: Friday, October 31, 2008 2:16 PM To: arslist@ARSLIST.ORG Subject: stripping HTML from email We are looking for a good way to strip HTML code from emails that we make tickets out of. If I remove anything between a and a we can catch the wrong thing if folks use a or in their text. Ideas? Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Server Name Change
I withdraw the question. Since the one server is a hot backup, it will not be on the domain at the same time as the production server. So no name change will be required. Steve Michadick Remedy Engineer MCNOSC -Original Message- From: Dip Patel [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 9:56 AM Subject: Re: Server Name Change ** We do Environment Refresh from Production for new environments have documented registry changes other changes required to change the servername.However if you've installed CMDB 2.0 or greater version ,its advisable to manually install it as it stores the server name in binaries in some places not easy to detect. n Mon, Nov 3, 2008 at 7:59 AM, Steve Michadick [EMAIL PROTECTED] wrote: Has anyone changed the server name running ARS 7.1 ITSM 7.0? We have a hot backup server with the same name as our production server, but on a different domain and with a different IP. We found out that they will eventually be on the same domain, so we'll have to change the name of our hot backup server. Anyone have to do this before? Since we backup the production db and restore it to the hot backup server, we are wondering how this will effect changing the name of the server. Both are Win2003 SP2 OS with MS SQL 2005 on a separate server. Steve Michadick Remedy Engineer Marine Corps Network Operations and Security Center (MCNOSC) Phone: 703-432-6726 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 2009 BMC World??
Okay my sales rep said he heard rumors of having it in Vegas. Anybody heard this? Steve On Tue, Nov 4, 2008 at 5:34 AM, strauss [EMAIL PROTECTED] wrote: So much for budgeting... that's FY 2010 for some of us. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of John Sent: Tuesday, November 04, 2008 6:07 AM To: arslist@ARSLIST.ORG Subject: Re: 2009 BMC World?? ** http://www.bmcworldcommunity.com/conferences It says rescheduled to Oct, 2009. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] On Nov 3, 2008, at 11:16 PM, Steven Pataray wrote: ** Has there been any rumors yet on when/where next years BMC World will be? It's budgeting time again and would like to make sure there is enough money. Mahalo's, Steve Pataray __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
JOB: Column Technologies is seeking a Remedy Solutions Architect based in the Washington DC Metro Area
We are seeking a Remedy Solutions Architect based the Washington DC metro area. This is a permanent position with a generous salary, bonus, benefits and vacation. Candidates must have ITSM 7 implementation experience. If you're interested please email me your resume as a PDF or MS Word document and we can coordinate a time to talk. You will be employed at Column Technologies as a BMC Remedy Solutions Architect to provide technical consulting services for our growing global customer base. Your responsibilities will include but are not limited to: * Install and configure BMC Remedy applications * Customize BMC Remedy applications * Implement integrations with BMC Remedy applications * Troubleshoot and support BMC Remedy based applications and systems * Draft technical installation, configuration and customization specification documents * Design appropriate supporting infrastructure (including Hardware, OS, DB, Web Server, and Load Balancing architecture) to support customer's performance and availability requirements * Design and document Disaster Recovery strategies for customers * Conduct requirements gathering workshops * Draft use cases and functional requirements documents * Communicate strategies and best practices for product implementation * Design custom or product-based solutions based on BMC Remedy applications * Demonstrate BMC Remedy products to customers * Respond to customer requests for product or solution information * Estimate level of effort to design or deploy products or solutions * Draft proposals and statements of work for solutions * Provide technical assistance in a pre-sales capacity * Mentor Junior Remedy Consultants You will primarily serve our customers remotely or who are located in your region but travel will be required based on project needs. Melissa Wish Corporate Recruiter Column Technologies, Inc. Home Office: 718-399-2136 Cell/Evenings: 917-748-7104 E-Fax: 646-349-3799 Email: [EMAIL PROTECTED] www.columnit.com BMC Remedy Partner of the Year, 2000 - 2004 BMC Solution Partner of the Year, 2004 - 2006 BMC Fastest Growing Worldwide Partner, 2006 Inc. 500- Fastest Growing Private Companies, 2006 BMC Americas Worldwide Top Solution Provider, 2007 VARBusiness- North America's Largest 500 IT Solution Providers, 2007 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Job: 3 Remedy Openings - Rockville, MD - US Citizen - Contract - Kforce
Here is what we are looking for: * 1 Remedy Consultant to upgrade from 6.3 - 7.0.2. Modules being focused in are Asset, Problem, and Incident. (Pay Rate 70/HR on a C2C All Inclusive or 60/HR on a W2 All Inclusive) * 2 Remedy Admin/Developers to help with the migration/upgrade of 6.3 - 7.0.2 (Pay Rate 55/HR on a C2C All Inclusive or 45/HR on a W2 All Inclusive) Title: Remedy Developer Type: Contract Authorization Status: US Citizen Only Duration: 6 Months with possible extension Location: Rockville, MD Interview Process: 1st round phone (May hire off phone - but not a guarantee) , 2nd round in-person Industry: Federal Government Basic Requirements * 3-5 years of Remedy development experience in 6.3 and 7.x. * Experience migrating/implementing/installing/upgrading from 6.x to 7.x Joshua Kitchen Information Technology Recruiter Kforce Professional Staffing Two Prestige Place (Suite 350) 937.449.1749 Office 937.461.6888 Fax 937.416.3456 Cell Great People = Great Results http://www.linkedin.com/in/joshkitchen Please don't keep me a secret... a referral is the best compliment I can receive. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are btn_viewmy_160x33.gif
Re: Microsoft MapPoint
I worked on a system once that needed GIS Located points on a map for incidents. What was basically done is that each site that could have an incident built against it had its lat and long loaded into a table, and I published a web service for MapPoint to poll on a specified period, this web service provided them basic information that they wanted in mouse hover events and they placed the ticket data on the map based on the lat and long stored for that site... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 04, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Microsoft MapPoint Does anyone out there have any experience with integrating Remedy with MapPoint? I am trying to put something together to pass data from Remedy to MapPoint on demand. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Job: 3 Remedy Openings - Rockville, MD - US Citizen - Contract - Kforce
Joshua, Thanks for contacting me regarding this opportunity; however, I am currently contracted thru the end of March and as such unavailable. Regards, Julie From: Kitchen, Joshua T [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 4, 2008 2:57:40 PM Subject: Job: 3 Remedy Openings - Rockville, MD - US Citizen - Contract - Kforce ** Here is what we are looking for: * 1 Remedy Consultant to upgrade from 6.3 - 7.0.2. Modules being focused in are Asset, Problem, and Incident. (Pay Rate 70/HR on a C2C All Inclusive or 60/HR on a W2 All Inclusive) * 2 Remedy Admin/Developers to help with the migration/upgrade of 6.3 - 7.0.2 (Pay Rate 55/HR on a C2C All Inclusive or 45/HR on a W2 All Inclusive) Title: Remedy Developer Type: Contract Authorization Status: US Citizen Only Duration: 6 Months with possible extension Location:Rockville, MD Interview Process: 1st round phone (May hire off phone - but not a guarantee) , 2nd round in-person Industry: Federal Government Basic Requirements * 3-5 years of Remedy development experience in 6.3 and 7.x. * Experience migrating/implementing/installing/upgrading from 6.x to 7.x Joshua Kitchen Information Technology Recruiter Kforce Professional Staffing Two Prestige Place (Suite 350) 937.449.1749 Office 937.461.6888 Fax 937.416.3456 Cell Great People =Great Results Please don't keep me a secret... a referral is the best compliment I can receive. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM install: ASI import fails
Hello Raido, This you resolved this issue? I am installing IM 7.0.02 and I encountered an error with the asi_deplapp.def. It failed to import this particular definition files and here's the details from the log file: [Tue Nov 04 12:26:09.478] ImportFileNode- AR Status (14 items) [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:SearchFromBase_Dependency1 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:InventoryStorage [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:InventoryStorage [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 301156500 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:SearchFromBase_Dependency [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:InventoryQuantity_Storage_Join [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:DependencyStorageJoin [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:SearchFromBase_Dependency1 [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:LPAR [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:InventoryStorage [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:BulkInventory I tried to manually import the failed def files but wasn't successful because the AST:InventoryStorage form does not exist. Does anyone encountered this before? Any helpful tips to resolve this issue is highly appreciated. Windows Environment: ARS 7.0.01 p5 CMDB 2.0.1 MS SQL 2000 Thanks, Tina [EMAIL PROTECTED] wrote: Hello, Something for the weekend… for me at least. I am installing Change Management as the first app in ITSM. Right at the beginning the installer fails to deploy the Remedy Asset Inventory app. The install log claims that the defs from asi_deplapp.def were imported successfully. I tried importing all of the defs manually and indeed – an Import Successful message is displayed but nothing is imported. When trying to import the app or any of the forms from this def file one by one, a ARERR55 is displayed, but no further info about the cause. I exported an AST form from another server and was able to import this successfully. Have you experienced this before and how do you get around this? I'd like to import the Remedy Asset Inventory app beforehand so it would not cause the other defs to fail. Thanks, Raido ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/ITSM-install%3A-ASI-import-fails-tp20272391p20331757.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Prefix on Request ID
Hi, If you want to change the prefix of old records, RRR|Chive can do this for you. https://www.rrr.se/cgi/rrrchive/main Sample config to change the prefix: source_server = myserver source_user = Demo source_password = source_form = HelpDesk target_server = myserver target_form = HelpDesk qual = 1=1 transfertype = MOVE entryidmode = ABC logfile = rrrchive.log loglevel = INFO progressbar = YES Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Okay, I need to add a prefix to my request id. I did it in test, and all looks fine. Can anyone think of anything I might need to test? As far as I know, we don't use the request ID field for anything specific. Thanks, Gary ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Login Name
Hi, If you need to change the data in your current system, you can use our free RRR|LoginConv tool. You need a conversion file in the following format: mizm = 12345 shafqata = 54321 axtong = 2 https://www.rrr.se/cgi/tools/main#rrrLoginConv It will go through all (or the specified) forms and change all character fields with an exact match. It will also fix diary-data and status-history to the new login name. It will even change the User-form record. The newest version of RRR|LoginConv handles the 60xxx fields if you have user names in there. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 2009 BMC World??
On Tue, Nov 4, 2008 at 2:56 PM, Steven Pataray [EMAIL PROTECTED] wrote: ** Okay my sales rep said he heard rumors of having it in Vegas. Anybody heard this? Steve On Tue, Nov 4, 2008 at 5:34 AM, strauss [EMAIL PROTECTED] wrote: So much for budgeting... that's FY 2010 for some of us. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of John Sent: Tuesday, November 04, 2008 6:07 AM To: arslist@ARSLIST.ORG Subject: Re: 2009 BMC World?? ** http://www.bmcworldcommunity.com/conferences It says rescheduled to Oct, 2009. -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] On Nov 3, 2008, at 11:16 PM, Steven Pataray wrote: ** Has there been any rumors yet on when/where next years BMC World will be? It's budgeting time again and would like to make sure there is enough money. Mahalo's, Steve Pataray __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ITSM install: ASI import fails
Tina, Looks like you have not loaded the ITSM CMDB extentions. You will find them in the celsdk/extensions folder on the install media. This is not the case for me as these forms clearly do exist. ..and no, I have not been able to figure it out yet. I was able to manually import forms from asi_deplapp.def on another server though, the only difference being that the one where the import fails is unicode. I have compared the BMC forms that make up the AST joins and they are an exact match. Raido On Tue, Nov 4, 2008 at 9:38 PM, tina flores [EMAIL PROTECTED] wrote: Hello Raido, This you resolved this issue? I am installing IM 7.0.02 and I encountered an error with the asi_deplapp.def. It failed to import this particular definition files and here's the details from the log file: [Tue Nov 04 12:26:09.478] ImportFileNode- AR Status (14 items) [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:SearchFromBase_Dependency1 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:InventoryStorage [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 303 Form does not exist on server AST:InventoryStorage [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 301156500 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [ERROR][Tue Nov 04 12:26:09.478] ImportFileNode- 314 Field does not exist on current form 1706300 [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:SearchFromBase_Dependency [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:InventoryQuantity_Storage_Join [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:DependencyStorageJoin [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:SearchFromBase_Dependency1 [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:LPAR [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:InventoryStorage [WARNING][Tue Nov 04 12:26:09.478] ImportFileNode- 55 The following item was not imported AST:BulkInventory I tried to manually import the failed def files but wasn't successful because the AST:InventoryStorage form does not exist. Does anyone encountered this before? Any helpful tips to resolve this issue is highly appreciated. Windows Environment: ARS 7.0.01 p5 CMDB 2.0.1 MS SQL 2000 Thanks, Tina [EMAIL PROTECTED] wrote: Hello, Something for the weekend… for me at least. I am installing Change Management as the first app in ITSM. Right at the beginning the installer fails to deploy the Remedy Asset Inventory app. The install log claims that the defs from asi_deplapp.def were imported successfully. I tried importing all of the defs manually and indeed – an Import Successful message is displayed but nothing is imported. When trying to import the app or any of the forms from this def file one by one, a ARERR55 is displayed, but no further info about the cause. I exported an AST form from another server and was able to import this successfully. Have you experienced this before and how do you get around this? I'd like to import the Remedy Asset Inventory app beforehand so it would not cause the other defs to fail. Thanks, Raido ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/ITSM-install%3A-ASI-import-fails-tp20272391p20331757.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Login Name
Hey Tauf I know! I don't know if anyone on this list ever saw a television series called The Prisoner. If they did, they will probably remember the signature line, I am a man, not a number. Ah well! Unfortunately we are having problems with our Far East sites, where a lot of users apparently have the same first and last names, and not only AD but Remedy Admins are getting really really confused, when one of them calls with a problem !!! Shafqat --- On Tue, 11/4/08, Chowdhury, Tauf [EMAIL PROTECTED] wrote: From: Chowdhury, Tauf [EMAIL PROTECTED] Subject: Re: Changing Login Name To: arslist@ARSLIST.ORG Date: Tuesday, November 4, 2008, 5:20 PM ** You should protest this change… who wants to login with numbers anyway?? It’s kind of prison-ish. Just kidding… Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Tuesday, November 04, 2008 12:05 PM To: arslist@ARSLIST.ORG Subject: Changing Login Name ** Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Login Name
Matt yeah there are a few problems, like firstly changing the names in the User and People form, secondly the biggest issue is the Submitter field on all open tickets, we will need to change those, the Submitter field is locked on our servers, so have to get around that. I am really interested in Misi's solution and am going to look into it. Many thanks --- On Tue, 11/4/08, Matt Worsdell [EMAIL PROTECTED] wrote: From: Matt Worsdell [EMAIL PROTECTED] Subject: Re: Changing Login Name To: arslist@ARSLIST.ORG Date: Tuesday, November 4, 2008, 5:13 PM The obvious problem is that shafqatayaz becomes 123456 in the submitter field. You could use the Authentication Login Name reserved field to get round it. Matt Hi List Our AD is changing the way it stores the employee names, instead of a character based login name we are moving to a numeric based login id. As anyone implemented something like this before? If so, any gotcha's to look out for, any advice would be useful. We are on 7.01 ARS, Oracle 10 and ITSM 7 Many thanks Shafqat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: PL/SQL function call via set fields.
I've checked in SQL Logs that the value of my current_field is being
passed on fine to the select Get_Hast('current value') from dual;.
Doesnt look like null value is a problem,
as the Filter qualification itself filters out null values.
checking out other suggestions on the thread.
On Nov 5, 12:10 am, Grooms, Frederick W [EMAIL PROTECTED]
wrote:
You may want to default the value in your get_hash function in Oracle
Try something like
CREATE OR REPLACE FUNCTION GET_hash (in_value VarChar2 :=
'somedefault') return VarChar2 is
for your function definition
This way if Remedy does not have a value for current_field when you call
the function it will use the default value
Another thing you may look at is to see exactly what Remedy is sending
to the database by looking in the SQL logs.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wallace, Kelvin
Sent: Tuesday, November 04, 2008 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: PL/SQL function call via set fields.
Hey B,
I think this is the same error I get whenever an attempt is made to use
the SELECT on the first attempt. But, it works on the second attempt
and every other attempt until Remedy server is restarted. The Oracle
error is basically saying that Remedy is not defining the variable
before it is getting to Oracle.
HTH,
Kelvin
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears
Sent: Tuesday, November 04, 2008 1:16 PM
To: [EMAIL PROTECTED]
Subject: PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
