Re: Migrations
We had to move away from HP-UX on PA/RISC running AR System and Oracle which was going to move to HP-UX on IA64 (Itanium) last year, since AR System was not natively compiled on Itanium until version 7.1. We moved to AR Server 7.0.1 on W2K3 with Oracle 10gR2 running on a Linux (RHEL) cluster. The only reason we stayed away from AR Server on Linux was due to the comfort level at our company from a support perspective. Linux is a new entry for AR Server (unlike Solaris, HP-UX and AIX) and hence the decision to move away from the *NIX platform altogether. HTH, -- Shyam - Original Message - From: Drake,Dave Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, April 01, 2008 11:13 AM Subject: Migrations ** Hi all, Hoping someone has a little experience with either one or both of these scenarios. We're considering moving our ARS over to Linux (from Win2K3) and/or moving our DB from MSSQL2K to Oracle. Haven't really decided yet, just trying to get a sounding from the experts. Any tips and snippets would be greatly appreciated. Thanks!! ARS 7.0.1 p002, SQL 2K, Win2K3 servers, ITSM 7 Dave Drake - Remedy Administrator - Cerner Corporation -- CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. __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: Mysterious gap in log files.
Hi! And make sure to put everything in the same file (API, SQL, FLTR, ESCL). That will make it easier to follow. 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. I would add in SQL logging. I bet there is some DB activity that makes up for this gap. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, April 01, 2008 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Unfortunately there's nothing in the API log to show - it calls +CE on HPD:Help Desk to create the entry - the next item in the API log is after the entry is created. That's a 39 second stretch during which the filter items I mentioned are occurring. The snippet below is directly from the filter log - these lines are consecutive - I just shaved off the beginning parts of the lines in my original post for readability. The two consecutive entries from the arfilter log are verbatim below: FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 094 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 01, 2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Post the filter/api log snippets that show the gap with the TID and RPC ID included. Axton On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I am trying to tighten up the time it takes to create a new Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB). I've checked the threads/queues quite thoroughly and they appears to be fine - there's plenty of available time queue time. However, in the filter log there are multiple places where this happens: Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 095 Notice the three second gap between those two - there is NOTHING else going on anywhere else in the SQL or API logs to indicate some processing - it's just three seconds of the nothing in all of the logs. Every time there's a end of filter processing' phase message we just stop for 3 seconds. In my 39-second Incident creation time there are a total of 10 of these gaps - 30 seconds where absolutely nothing appears to be happening. Keep in mind this is a large solaris server and I'm the only one on it - there's no lack of server resources. We've got plenty of hamsters/wheels/etc to power this thing. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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___ - ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Confidential ** ___ 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
5.1.2 download
Dear Listers, Where can i download 5.1.2 server and other components? I checked on the product availability and cant find any reference for 512 -- Thanks Regards Satya Gandhi Consultant - Remedy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 5.1.2 download
5.1.2 is no longer supported by BMC. 6.3 is the oldest version available. - Kelly Deaver [EMAIL PROTECTED] Original Message Subject: 5.1.2 download From: Satya Gandhi [EMAIL PROTECTED] Date: Wed, April 02, 2008 4:48 am To: arslist@ARSLIST.ORG Dear Listers, Where can i download 5.1.2 server and other components? I checked on the product availability and cant find any reference for 512 -- Thanks Regards Satya Gandhi Consultant - Remedy ___ 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: Displaying login.jsp out of Mid-Tier SOLVED
As Carey says, the answer is very simple. Unfortunately some of us have to try all sorts of complications before we find it. To access the login page directly you go to: http://server/arsys/shared/login.jsp So you copy login.jsp to newname.jsp, then point your url to: http://server/arsys/shared/newname.jsp Then you edit newname.jsp till you get it like you want it. Thank you, Carey, and Vinod Suyal of Remedy Support for this solution, and Isabel for your help. Dwayne Martin -- On Wed, Mar 26, 2008 at 9:08 AM, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I want to customize our login.jsp page. But it may take some time, and I don't want mess up the display when users are trying to log in. How can I edit it, and see what it looks like, other than by putting it in the Mid-Tier\shared folder and trying it out? If I open it directly in either Mozilla or IE browser everything is strewed all over the screen. (Mid-Tier 7.1 Patch 2) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Configuring JSpell with Mid-Tier 7.0.1 Patch 6
We found the same problem when implementing it for the first time--the spelling of the function name was wrong and needed to be changed to jspellcheck() as you noted. I'm amazed that hasn't been fixed. We're on v7.0.1 P5 with ServletExec and we haven't noticed the problem with it not using the correct text but we haven't looked for this specific problem. We have noticed it doesn't seem to work properly if you have more than one midtier and are trying to call it from the other midtier server. The form pops up and looks correct but the buttons don't function, etc. As long as it is hosted on the same server, it works fine. We're also looking at a way to make the header code dynamic so we don't have to have the URL hard-coded (due to the problem above). Storing the file on the server and including it somehow would be nice. If anyone has figured out a way to dynamically change the header code stored in the Remedy form, please share. Craig Carter Software Engineer, RSP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sumeetdas Sent: Tuesday, April 01, 2008 10:23 PM To: arslist@ARSLIST.ORG Subject: Re: Configuring JSpell with Mid-Tier 7.0.1 Patch 6 All, I finally got this fixed. I am on ARS and MT 7.1 As per the documentation, the function is called spellcheck() but I scanned thru the jspell.js file and was unable to locate that function. It seems that in the future versions OR in the non-IIS versions of the Java HTML, the function is called jspellcheck(). Another thing which i noticed was that, JSpell worked fine for records which had been saved. It also works fine for records which have been modified and not yet saved. But for some reason, once you save the record, the text field reverts back to the incorrect text field. e.g. I have text field called Description and has the text I like. I modify that recrod [and not Save] and change the text to I like wrld and hit my custom spellcheck button. JSpell is invoked and it corrects the word wrld to world in the text area. However, once I save that record, I like wrld is written to the database. Has any one of you faced this issues [if its even an issues] ? Regards, Sumeet Das On Apr 1, 11:24 pm, sumeetdas [EMAIL PROTECTED] wrote: Hi, I tried all the above steps but i keep on getting the Caught Exception: Object expected Using various alert functions, I can see that the OurSpellCheck function is called and it traverses thru till the spellcheck() is called. and that is when I get the Exception error. any pointers.. or alternative mechanisms to use the spellcheck() would be helpful... On Feb 11, 2:19 pm, Timothy Powell [EMAIL PROTECTED] wrote: Here's what we did to get it to work for multiple fields on the same form: ARS 6.3 with MT 7.0 Patch 2 1) Using at least a 6.3 Admin Tool, on the form where we wanted to check the spelling. Go to the Form/Current View/Properties and the Appearance tab. Add the following to the web header portion: script language=JavaScript src=http://servername/jspellhtml2k4/jspell.js;/script script language=JavaScript !-- var fieldsToCheck=new Array(); function ourSpellCheck(fieldName) { fieldsToCheck=new Array(); fieldsToCheck[fieldsToCheck.length]=fieldName; spellcheck(); } function getSpellCheckArray() { return fieldsToCheck;} //-- /script form name = Helpdesk 2) On the web footer we added the following: /form 3) We created a button on our form for each field we wanted to check. 4) We added an active link for each field we wanted to check. The AL fires on click of the button created in 3 above. Run If: $CLIENT-TYPE$ = 9 If Action: Run Process Command Line: javascript ourSpellCheck('document.yourformname.aridxxx') NOTE: xx = the arid of the field you want to check 5) In JSpell, on the popup.html form, we added the following line: body onload = window.focus() HTH, Tim From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Latter, Kris Sent: Monday, February 11, 2008 1:30 PM To: [EMAIL PROTECTED] Subject: Configuring JSpell with Mid-Tier 7.0.1 Patch 6 ** Hello, I'm having an issue in trying to setup the JSpell program that has been recommended on this list with: (Server, Admin Tool, and Mid-Tier all 7.0.1 Patch 6) in order to provide spell-checking on a specific form. I am wondering if anyone else has successfully setup this program and implemented it with Mid-Tier. Here is what I have done so far: - Placed the jspellhtml2k4.war file into my Tomcat-webapps directory and was able to test the spell checker successfully withhttp://hostname/jspellhtml2k4/test.html - Loaded the form I wanted to implement spell-checking with in the admin tool and clicked on EDIT WEB HEADER CONTENT and added the header content specified by the help
BMC Service Desk vs Service Desk Express
From what I see, BMC Service Desk Express is not just a lite version of BMC Service Desk, it's an entirely different product formerly known as Magic and has nothing to do with Remedy, correct? So if a third party tool worked with Service Desk Express, and we have Service Desk, it will not work? Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
FW: Unable to connect to discovery server.
I m unable to connect to discovery server. It always gives the error message that server is not ready to connect retry after few minutes. Error screenshot is attached. DISCLAIMER: --- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. --- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How put the value of a text field into a text file under UNIX?
Hi, I have a filter. In that filter I have a Run Process. What to I need to type in here to get the content of $Filed1$ into test.txt My OS is Linux. I was experimenting with cat, but I'm failing to get this thing done. Please help me! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
UNSUBSCRIBE
Notice Regarding Confidentiality This email, including any and all attachments, (this Email) is intended only for the party to whom it is addressed and may contain information that is confidential or privileged. Sierra Systems Group Inc. and its affiliates accept no responsibility for any loss or damage suffered by any person resulting from any unauthorized use of or reliance upon this Email. If you are not the intended recipient, you are hereby notified that any dissemination, copying or other use of this Email is prohibited. Please notify us of the error in communication by return email and destroy all copies of this Email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Reporting Time to Resolve
Thanks Brian. What you've said appears to make sense, as some of the records list a total time spent of 330,000+ hours, which comes out to over 37 years. That would put us in 2007 which would make sense for some of these tickets. The strange part is that only about 200 or so of the tickets have these strange dates and the rest are fine. Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk Sent: Wednesday, April 02, 2008 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: Reporting Time to Resolve ** Matt, I am just taking a random whack at this, but could it be that those records don't have the date information your looking for and as such, are displaying the time since January 1st, 1970? Not sure if that has anything to do with it, but something you might look into. Brian On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. [EMAIL PROTECTED] wrote: ** List, I've been tasked with writing some reports to get the duration of time in which tickets were open. We don't have SLM installed, so I decided that I would report off of the Incident Assignment Log. Here's the query: SELECTIncident_Number, SUM(BusinessHoursDurationSeconds) AS TimeOpen FROMHPD_Help_Desk_Assignment_Log GROUP BY Incident_Number ORDER BY TimeOpen DESC So everything was going well until I noticed some of the numbers appear out of whack. For instance, there are a number of tickets where the business hours duration field is 334939:53:44 and the business hours duration (sec) field is 1205783624. Does anyone out there have any good ideas on what could be going wrong here? TIA. -Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 __Platinum Sponsor: www.rmsportal.com http://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: How put the value of a text field into a text file under UNIX?
Hi, Try this: echo $Field$ /tmp/test.txt The problem is if you have any -characters in your data. You can escape them with a Set-fields: Field = REPLACE($Field$, , ') There is also a size limit on the expanded command containing your data. I think it is 1024 or 4096 bytes... Best Regards - Misi, RRR AB, http://rrr.se Hi, I have a filter. In that filter I have a Run Process. What to I need to type in here to get the content of $Filed1$ into test.txt My OS is Linux. I was experimenting with cat, but I'm failing to get this thing done. Please help me! Mark ___ 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: How put the value of a text field into a text file under UNIX?
Someone with more UNIX expertise should be able to verify this, but I believe you just need to use the function, as follows: Run Process $Filed1$ test.txt if you wanted to sepecify a path for the file try this: Run Process $Filed1$ /app/remedy/TestLogs/test.txt On 4/2/08, Mark Milke [EMAIL PROTECTED] wrote: Hi, I have a filter. In that filter I have a Run Process. What to I need to type in here to get the content of $Filed1$ into test.txt My OS is Linux. I was experimenting with cat, but I'm failing to get this thing done. Please help me! Mark ___ 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: How put the value of a text field into a text file under UNIX?
Mark, Please see thread Output of field contents to file via a filter action on ARSList circa Mar 6, 2008. (And I am sure there are other versions of the same concept in the archives too.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Apr 2, 2008 at 8:35 AM, Mark Milke [EMAIL PROTECTED] wrote: Hi, I have a filter. In that filter I have a Run Process. What to I need to type in here to get the content of $Filed1$ into test.txt My OS is Linux. I was experimenting with cat, but I'm failing to get this thing done. Please help me! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Bringing in multiple Views during Prefetch
The Prefect script in 7.1 makes no comment on multiple Views for a form. Is this because all views for the form are prefetched... or only the default view? I have ARS Support claiming all views are prefetched, but my experience indicates only the default view. I have no concrete proof other than just witnessing the time it takes to open each view after the prefetch is finished. -ivan- -- Ivan Runions Information Technologies University of Calgary Calgary Alberta Canada (403) 220-4437 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mysterious gap in log files.
Nope. Nothing - I checked that as wellthe longest SQL statement takes about 0.0176 seconds to complete in the entire log and during this time there's no activity. There's literally NOTHING going on - at least none of the log files indicate anything is going on during this time. There's zero activity. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols Sent: Tuesday, April 01, 2008 2:33 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** I would add in SQL logging. I bet there is some DB activity that makes up for this gap. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, April 01, 2008 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Unfortunately there's nothing in the API log to show - it calls +CE on HPD:Help Desk to create the entry - the next item in the API log is after the entry is created. That's a 39 second stretch during which the filter items I mentioned are occurring. The snippet below is directly from the filter log - these lines are consecutive - I just shaved off the beginning parts of the lines in my original post for readability. The two consecutive entries from the arfilter log are verbatim below: FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 094 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 01, 2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Post the filter/api log snippets that show the gap with the TID and RPC ID included. Axton On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I am trying to tighten up the time it takes to create a new Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB). I've checked the threads/queues quite thoroughly and they appears to be fine - there's plenty of available time queue time. However, in the filter log there are multiple places where this happens: Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 095 Notice the three second gap between those two - there is NOTHING else going on anywhere else in the SQL or API logs to indicate some processing - it's just three seconds of the nothing in all of the logs. Every time there's a end of filter processing' phase message we just stop for 3 seconds. In my 39-second Incident creation time there are a total of 10 of these gaps - 30 seconds where absolutely nothing appears to be happening. Keep in mind this is a large solaris server and I'm the only one on it - there's no lack of server resources. We've got plenty of hamsters/wheels/etc to power this thing. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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___ ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Confidential ** __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
Run Process Help
Hi All, So I'm trying to run the command: copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 via cmd.exe The syntax I have for the Run Process is: %windir%\system32\cmd.exe /c copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 The only thing that is happening is a cmd window opens and then closes. Is my syntax correct? If not any ideas on where I went wrong? Thanks, Mike -- View this message in context: http://www.nabble.com/Run-Process-Help-tp16447087p16447087.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
Job: Remedy Developer - 6 Month CTH or Perm - Baltimore, MD
Dear List, Hope all is well, I am looking for a Mid level Remedy Developer. Location: Baltimore, MD Duration: 6 Month Contract to Hire or Permanent About Client: Our International client specializes in global management and technology consulting. Our client is known for their deep industry experience and high customer satisfaction. They collaborate with clients in government and industry in 60 countries to solve their most pressing challenges from strategy through execution. Skillset: REMEDY v7.x with Help Desk, Asset, Change, CMDB, Migrator Detailed Job Description: Mid level Remedy Developer wanted to build custom interface with Purchase Order system; make enhancements/modifications to Remedy 6.0 modules to support automation of receiving process and configuration item creation for software and hardware. Familiarity with Remedy 7.0. Candidate must be expertly proficient with Remedy's AR System tools and development methodology. Experience with Remedy Help Desk, Asset Management, Change Management, CMDB and Migrator. MS SQL 2000 platform If you are interested please send me a word document version of your resume and salary requirements. Respectfully, 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
Rif: Run Process Help
Ciao Mike, you have to create a .cmd file that execute a copy command and the Run Process executes the .cmd (if you need you can pass parametres fron run Process to .cmd file) ciao Luisa Carena Gestione Postazioni Periferiche cpt Novara SGS BP Gruppo Banco Popolare di Verona e Novara via Negroni 12 - 28100 Novara Tel: 0321-663995 Email: [EMAIL PROTECTED] versicle [EMAIL PROTECTED] - 02/04/2008 16.27 Inviato da: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Per favore, rispondere a arslist@ARSLIST.ORG Per:arslist@ARSLIST.ORG CC: Oggetto:Run Process Help Hi All, So I'm trying to run the command: copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 via cmd.exe The syntax I have for the Run Process is: %windir%\system32\cmd.exe /c copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 The only thing that is happening is a cmd window opens and then closes. Is my syntax correct? If not any ideas on where I went wrong? Thanks, Mike -- View this message in context: http://www.nabble.com/Run-Process-Help-tp16447087p16447087.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 La presente comunicazione e' destinata esclusivamente al soggetto indicato piu' sopra quale destinatario o ad eventuali altri soggetti autorizzati a riceverla. Essa contiene informazioni strettamente confidenziali e riservate, la cui comunicazione o diffusione a terzi e' proibita, salvo che non sia stata espressamente autorizzata. Se avete ricevuto questa comunicazione per errore, Vi preghiamo di darne immediata comunicazione al mittente e di cancellarne ogni evidenza dai Vostri supporti. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: 5.1.2 download
If you have an ftp server I can upload it up there.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Satya Gandhi Sent: Wednesday, April 02, 2008 5:48 AM To: arslist@ARSLIST.ORG Subject: 5.1.2 download ** Dear Listers, Where can i download 5.1.2 server and other components? I checked on the product availability and cant find any reference for 512 -- Thanks Regards Satya Gandhi Consultant - Remedy No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.4/1355 - Release Date: 4/1/2008 5:37 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mysterious gap in log files
Disregard my last update. This speed problem is caused by Oracle update to the LOBs. In short, I'll be moving them in-row and we'll see what happens. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols Sent: Tuesday, April 01, 2008 2:33 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** I would add in SQL logging. I bet there is some DB activity that makes up for this gap. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, April 01, 2008 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Unfortunately there's nothing in the API log to show - it calls +CE on HPD:Help Desk to create the entry - the next item in the API log is after the entry is created. That's a 39 second stretch during which the filter items I mentioned are occurring. The snippet below is directly from the filter log - these lines are consecutive - I just shaved off the beginning parts of the lines in my original post for readability. The two consecutive entries from the arfilter log are verbatim below: FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 094 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 01, 2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Post the filter/api log snippets that show the gap with the TID and RPC ID included. Axton On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I am trying to tighten up the time it takes to create a new Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB). I've checked the threads/queues quite thoroughly and they appears to be fine - there's plenty of available time queue time. However, in the filter log there are multiple places where this happens: Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 095 Notice the three second gap between those two - there is NOTHING else going on anywhere else in the SQL or API logs to indicate some processing - it's just three seconds of the nothing in all of the logs. Every time there's a end of filter processing' phase message we just stop for 3 seconds. In my 39-second Incident creation time there are a total of 10 of these gaps - 30 seconds where absolutely nothing appears to be happening. Keep in mind this is a large solaris server and I'm the only one on it - there's no lack of server resources. We've got plenty of hamsters/wheels/etc to power this thing. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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___ ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Confidential ** __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: Help with Change Management
I checked the list and it is empty. I saw this before but I cannot add names to it. I am guessing my approvers should be inthis list huh. On 4/1/08, Model, Igor [ITSUS Non JJ] [EMAIL PROTECTED] wrote: ** Katherine Check the Member List field of the AP:Roles form if the manager's id was also deleted from that list. Igor *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Katherine Hoffner *Sent:* Monday, March 31, 2008 2:59 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Help with Change Management ** I am not really well versed with this product. Of Course huh. Someone who doesnt know anything. On 3/31/08, *T. Dee* [EMAIL PROTECTED] wrote: Have you checked the Approval Process Configuration and Approval Mappings. Ty On 3/31/08, Katherine Hoffner [EMAIL PROTECTED] wrote: ** This is with all the NEW changes. On 3/31/08, T. Dee [EMAIL PROTECTED] wrote: Is this with current Changes or NEW Changes? Ty On 3/31/08, Katherine Hoffner [EMAIL PROTECTED] wrote: ** Hi all, I have a problem with my change requests. One of our managers left and his name was deleted from the system. I am not sure if this had anything to do with the issue but it did happen after his removal. Anyway we have a new manager and I added her to the all Approvals list. Our CTI'S are set up as ALL. We do not have individual approval for different CTI's everything is approved by 4 people. Anyway I cannot get the approvers up to the current signatures line under the Approvals tab on the change request so none of my approvers can actually sign off the change request. All of my change requests are staying in the pending approval state. Running ARS 6.3 -- Katherine __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 -- Katherine __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 -- Katherine __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Katherine ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Service Desk vs Service Desk Express
I would say that it will not work in the same way. AR System, upon which Service Desk is built, is a very flexible engine to integrate with. I would bet that whatever third-party tool you're talking about could be integrated with AR System, and therefore with Service Desk, with a small to moderate level of effort. Rick On Wed, Apr 2, 2008 at 5:55 AM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: ** From what I see, BMC Service Desk Express is not just a lite version of BMC Service Desk, it's an entirely different product formerly known as Magic and has nothing to do with Remedy, correct? So if a third party tool worked with Service Desk Express, and we have Service Desk, it will not work? Thanks, Chris __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: Run Process Help
I think you need to separate the parameter values to the copy command %windir%\system32\cmd.exe /c copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 I think the Copy command is only seeing 1 parameter an so does not know what to do Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of versicle Sent: Wednesday, April 02, 2008 9:28 AM To: arslist@ARSLIST.ORG Subject: Run Process Help Hi All, So I'm trying to run the command: copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 via cmd.exe The syntax I have for the Run Process is: %windir%\system32\cmd.exe /c copy C:\sample1.txt \\ACNCNU6250FVX\CABMACH4 The only thing that is happening is a cmd window opens and then closes. Is my syntax correct? If not any ideas on where I went wrong? Thanks, Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Resolved: Definitive Software Library - Unresolved: SLM Notifications
It has only taken BMC support six weeks to answer this one (further evidence that they cannot document their own software worth a flip), and it turns out that patch 005 to the DSL was never intended to be used on the DSL installed with ITSM, only the standalone version (which I had never seen mentioned or documented before). So the workaround they gave me a month ago, where you hack the records in Share:Application_Properties to allow the installer to run, should never have been offered or performed; no wonder it left the DSL console completely unusable on my dev server. The same is true of patch 006 to DSL, except that it gives you a much more specific and intelligent error message when you try to run it. So today, DSL installed with ITSM has a maximum patch level of 1516, and only the _data_ should be at patch 005 (the data version in patch 005 is 110.7.0.1). Beware of BMC employees bearing workarounds - chances are they are really just clueless, and grasping at straws (not true for all; there are a few I know I can trust). Footnote: That is why I am holding out for a formal technical bulletin or approved knowledge base article on their proposed workaround for SLM notifications. They want me to hack the HPD:Help Desk form to lookup and store the long group name from the Groups form (for my group that looks like this: UNT CITC Academic Computing and User Services-CITC ACS-US Call Tracking-Call Tracking Administration) that corresponds to the Assigned Group - Support Group Name and ID (SGP000#) because their integration between SLM 7.1 and Incident Management cannot search assigned support groups in CTM:Support Group for members, and so no escalations are being sent at all to support group members or managers (the entire purpose of the SLM application, from my point of view). If that is what they have to do to get SLM to work with IM, it _should_ have been in the integration, and if it wasn't, it _should_ have been documented and already be in a patch, but none of that has been done. I am having to force them to document it, by refusing to let them just toss me a barely coherent workaround, file a defect, and blithely close the issue. Shoddy, and unprofessional. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, February 18, 2008 8:44 PM To: arslist@ARSLIST.ORG Subject: Definitive Software Library I am obviously missing something here. DSL 1.0.00 is installed with ITSM 7.0.02, specifically Change Management I believe. It's console appears on my Home Page as an admin. The Patch 1516 installer runs fine against it. On production I have not loaded updated data, or imported any data yet since we had been debating whether or not to do so. Now I want to load data, but need to patch it first. Development is an older system, upgraded to ARS 7.1.00.01 and CMDB 2.1.00, on which DSL data has been loaded and updated several times. In Share:Application_Properties it shows version 1.0.00 Patch 1516 on both servers. The documentation for DLS 7.0 Patch 005 and DSL 7.1.01 mirrors this, that it should have installed with the ITSM 7.0 installation of Change Management. It says to apply Patch 005 to the DSL. When I run Patch 005 for DSL on my development or production (ARS 7.1.00.001 / CMDB 2.1.00.001 / ITSM 7.0.02.007) servers, it fails after reporting that the three ITSM apps are installed (IM, PM, CM, all 7.0.03.007) with the error: Pre-requisites not met BMC Remedy Definitive Software Library Version 7.00.00 or higher is required. At what point in loading the latest version of every piece of BMC code I could scavenge off support web did I NOT get it to the point where it thinks it has DSL 7.0.x?? Or is this one of those installers than only works against an older code base, which means that I would have had to install it back in December before ITSM Patch 006 or CMDB 2.1.00.001 (January)?? Anyone have any experience with this one?? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ __ _ 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
Incoming emails building up and crashing email engine.
I am running ARS 7, and have it set up to receive incoming emails. What has been going on is that when I look in the AR System Email Message I can see that the incoming emails are building up, but never removing themselves. After a large amount has built up the incoming email system quits accepting these messages and incidents are no longer created off of the incoming emails. If I delete what is in there and then restart the email service, all pending emails are received and all incident are created. If I daily open up AR System Email Messages and delete all incoming messages there is no problem. When or Remedy consultants were out here I think I saw them work on a form that should purge these incoming emails on a defined schedule, however I cannot find that form. Can anyone comment on my issue, and help me find that form name? Thanks np -- View this message in context: http://www.nabble.com/Incoming-emails-building-up-and-crashing-email-engine.-tp16447310p16447310.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: Incoming emails building up and crashing email engine.
I only retain incoming error email for three days by running an Archive Delete from Source on the Email Messages form. That should do it for you. I run this once a day. If I remember correctly you have to space the archives at least an hour apart. I am on ARS 6.3 but I would think this should be the same. Good Luck Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of npeterson Sent: Wednesday, April 02, 2008 11:31 AM To: arslist@ARSLIST.ORG Subject: Incoming emails building up and crashing email engine. I am running ARS 7, and have it set up to receive incoming emails. What has been going on is that when I look in the AR System Email Message I can see that the incoming emails are building up, but never removing themselves. After a large amount has built up the incoming email system quits accepting these messages and incidents are no longer created off of the incoming emails. If I delete what is in there and then restart the email service, all pending emails are received and all incident are created. If I daily open up AR System Email Messages and delete all incoming messages there is no problem. When or Remedy consultants were out here I think I saw them work on a form that should purge these incoming emails on a defined schedule, however I cannot find that form. Can anyone comment on my issue, and help me find that form name? Thanks np -- View this message in context: http://www.nabble.com/Incoming-emails-building-up-and-crashing-email-eng ine.-tp16447310p16447310.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 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Reporting Time to Resolve
Well that part I can't help with. It was just that looking at those numbers I figured that it seemed to go back to about then. Glad it gives you a starting point. On Wed, Apr 2, 2008 at 8:52 AM, Gayford, Matthew C. [EMAIL PROTECTED] wrote: ** Thanks Brian. What you've said appears to make sense, as some of the records list a total time spent of 330,000+ hours, which comes out to over 37 years. That would put us in 2007 which would make sense for some of these tickets. The strange part is that only about 200 or so of the tickets have these strange dates and the rest are fine. Matt *M*atthew *C*. *G*ayford *T*echnology *R*esearch *D*evelopment *I*nformation *T*echnology *S*ystems *D*ivision *U*niversity of *N*orth *C*arolina *W*ilmington (910) 962-7177 *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk *Sent:* Wednesday, April 02, 2008 9:41 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Reporting Time to Resolve ** Matt, I am just taking a random whack at this, but could it be that those records don't have the date information your looking for and as such, are displaying the time since January 1st, 1970? Not sure if that has anything to do with it, but something you might look into. Brian On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. [EMAIL PROTECTED] wrote: ** List, I've been tasked with writing some reports to get the duration of time in which tickets were open. We don't have SLM installed, so I decided that I would report off of the Incident Assignment Log. Here's the query: SELECTIncident_Number, SUM(BusinessHoursDurationSeconds) AS TimeOpen FROMHPD_Help_Desk_Assignment_Log GROUP BY Incident_Number ORDER BY TimeOpen DESC So everything was going well until I noticed some of the numbers appear out of whack. For instance, there are a number of tickets where the business hours duration field is 334939:53:44 and the business hours duration (sec) field is 1205783624. Does anyone out there have any good ideas on what could be going wrong here? TIA. -Matt *M*atthew *C*. *G*ayford *T*echnology *R*esearch *D*evelopment *I*nformation *T*echnology *S*ystems *D*ivision *U*niversity of *N*orth *C*arolina *W*ilmington (910) 962-7177 __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
Re: Mysterious gap in log files.
What about network delays? Are you moving a large amount of data over the network and that is causing the delay? Just an idea. On Wed, Apr 2, 2008 at 9:12 AM, William Rentfrow [EMAIL PROTECTED] wrote: ** Nope. Nothing - I checked that as wellthe longest SQL statement takes about 0.0176 seconds to complete in the entire log and during this time there's no activity. There's literally NOTHING going on - at least none of the log files indicate anything is going on during this time. There's zero activity. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Wes Nichols *Sent:* Tuesday, April 01, 2008 2:33 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mysterious gap in log files. ** I would add in SQL logging. I bet there is some DB activity that makes up for this gap. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *William Rentfrow *Sent:* Tuesday, April 01, 2008 2:12 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mysterious gap in log files. ** Unfortunately there's nothing in the API log to show - it calls +CE on HPD:Help Desk to create the entry - the next item in the API log is after the entry is created. That's a 39 second stretch during which the filter items I mentioned are occurring. The snippet below is directly from the filter log - these lines are consecutive - I just shaved off the beginning parts of the lines in my original post for readability. The two consecutive entries from the arfilter log are verbatim below: FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 094 -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* Tuesday, April 01, 2008 1:07 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Mysterious gap in log files. ** Post the filter/api log snippets that show the gap with the TID and RPC ID included. Axton On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I am trying to tighten up the time it takes to create a new Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB). I've checked the threads/queues quite thoroughly and they appears to be fine - there's plenty of available time queue time. However, in the filter log there are multiple places where this happens: Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 095 Notice the three second gap between those two - there is NOTHING else going on anywhere else in the SQL or API logs to indicate some processing - it's just three seconds of the nothing in all of the logs. Every time there's a end of filter processing' phase message we just stop for 3 seconds. In my 39-second Incident creation time there are a total of 10 of these gaps - 30 seconds where absolutely nothing appears to be happening. Keep in mind this is a large solaris server and I'm the only one on it - there's no lack of server resources. We've got plenty of hamsters/wheels/etc to power this thing. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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___ -- *** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Confidential ** * __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: Mysterious gap in log files.
Hi! Please provide us with the surrounding log lines with the full API-call with all FLTR and SQL lines that belongs to that call. The server performs various internal stuff at times, such as refreshing the ar.cfg-file and throwing out inactive users. These type of thing may show as SQL-rows if SQL is involved. Some of these things does not have an RPC ID attached to them. I would be surprised if this happens in the middle of your call. It should be at the beginning or end of the API... Did you have other users that performed things at the same time? It could affect the responsiveness of the database. One such thing could be the locking of the arschema table. Best Regards - Misi, RRR AB, http://rrr.se Nope. Nothing - I checked that as wellthe longest SQL statement takes about 0.0176 seconds to complete in the entire log and during this time there's no activity. There's literally NOTHING going on - at least none of the log files indicate anything is going on during this time. There's zero activity. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wes Nichols Sent: Tuesday, April 01, 2008 2:33 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** I would add in SQL logging. I bet there is some DB activity that makes up for this gap. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, April 01, 2008 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Unfortunately there's nothing in the API log to show - it calls +CE on HPD:Help Desk to create the entry - the next item in the API log is after the entry is created. That's a 39 second stretch during which the filter items I mentioned are occurring. The snippet below is directly from the filter log - these lines are consecutive - I just shaved off the beginning parts of the lines in my original post for readability. The two consecutive entries from the arfilter log are verbatim below: FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:00.5076 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL FLTR TID: 09 RPC ID: 029441 Queue: Fast Client-RPC: 390620USER: YNZJH0 /* Tue Apr 01 2008 11:08:03.5168 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 094 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 01, 2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Mysterious gap in log files. ** Post the filter/api log snippets that show the gap with the TID and RPC ID included. Axton On Tue, Apr 1, 2008 at 12:32 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** I am trying to tighten up the time it takes to create a new Incident in IM 7.03 (ARS 7.01, Solaris, remote oracle DB). I've checked the threads/queues quite thoroughly and they appears to be fine - there's plenty of available time queue time. However, in the filter log there are multiple places where this happens: Tue Apr 01 2008 11:08:03.6332 */ End of filter processing (phase 1) -- Operation - CREATE on SYS:Action - NULL Tue Apr 01 2008 11:08:06.6404 */ End of filter processing (phase 2) -- Operation - CREATE on SLM:Measurement - 095 Notice the three second gap between those two - there is NOTHING else going on anywhere else in the SQL or API logs to indicate some processing - it's just three seconds of the nothing in all of the logs. Every time there's a end of filter processing' phase message we just stop for 3 seconds. In my 39-second Incident creation time there are a total of 10 of these gaps - 30 seconds where absolutely nothing appears to be happening. Keep in mind this is a large solaris server and I'm the only one on it - there's no lack of server resources. We've got plenty of hamsters/wheels/etc to power this thing. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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___ ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately.
Outgoing Emails Accumulation
Hello List We have upgraded to 7.0.1 Patch 6 and since that time our outgoing email cannot keep up with demand. As best we can tell each polling cycle sends out 90- 100 emails, incoming emails are running perfectly. We have 6 outgoing mail boxes polling every 5 minutes. OS: AIX 5,3 Patch 6 ARS: 7.0.1 Patch 6 Emails Engine: 7.0.1. Patch 6 Java: 1.4.2 Jay P ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Requester Console customization
Listers ~ checking to see if anyone has customized the RQC to allow end users to submit issues on behalf of others. If so, any suggestions? Database: SQL Server 2005 O/S: Windows 2003 (server), R2XP Professional (client), SP2 Apps: Action Request System 7.1 patch 1 Service Desk 7.0.3 patch 6 Laurie Muhlethaler Remedy Developer / Administrator First Republic Bank 415.364.4436 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 message cannot be guaranteed to be secure or error-free. First Republic Bank and its subsidiaries do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Stopping a runaway archive
Hi All, Is there a way to stop a runaway archive? I am getting to turn on archiving for the company's main form using Archive and Delete from Source. I have tested this in development to make sure my qualification is correct. Just to see if it was possible, while the archive test was running I went into the form and disabled archiving. The archiving did not stop until the criteria was no longer met. Hope the answer is not to shutdown the server. Thanks Mark This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Run Process Help
You can also use cmd /c copy /-Y c:\text.txt c:\text2.txt the cmd.exe should be already in the default path setting; so you can use cmd directly; the (/-Y) switch adds a prompt to the copy function. If ignored the copy function will overwrite the existing file or create a new one with the name text2.txt -Subash ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Job: Woodland Hills, CA - Permanent - Remedy Administrator
Dear List, Looking for a Remedy Administrator with 3-5 years experience working with Version 6.x or 7.x. Location: Woodland Hills, CA Duration: Direct-Hire / Permanent Salary: 65K-80K Industry: Insurance About Client: 2.7 Billion dollar company provides Workers' Compensation insurance. Description: Administration and development in a high availability environment. Develop workflows, active links, customizations, escalations in version 6.x or 7.x. * Administer permissions, security, access, logins, passwords in Remedy * Administer and develop forms, fields, menus and workflows in Remedy * Build AR System filters and active links in order to automate responses to user actions and enforce business rules * Create Remedy training documentation in PowerPoint and Word for Webinars with employees * Troubleshoot complex issues regarding forms, workflows, and log files in Remedy Skills: BMC REMEDY (v7.x preferred, v6.x acceptable) products including but not limited to Configuration Management DB (CMDB), IT Service Management (ITSM) Suite including Analytics, Change Management, Flashboards, Migrator, Service Desk, AR System, Service Level Management (SLM), and Service Request Management. Excellent verbal and written communication skills; ability to understand and articulate ideas and concepts in both verbal and written form. Process and Detail Oriented. Experience with Oracle RDBMS, SQL. If you are interested please reply to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with salary requirements and a word document version of your resume. Respectfully, 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: Requester Console customization
Hi Laurie !! We have created a totally new approach to a requester console in our Xtreme Console: Here is the link to our Xtreme Console/Dashboard integration. Xtreme Console http://www.BuoyantSolutions.net/Xtreme blocked::http://www.buoyantsolutions.net/Xtreme Login: Mary McDonald PW: us05gtst802unp Xtreme Dashboard - Same login/pw http://www.buoyantsolutions.net/xtreme/dashboard/ blocked::http://www.buoyantsolutions.net/xtreme/dashboard/ BTW: This is running outside of the Mid-tier (Don't need MT) and we are using XML-Gateway to get/push data. This runs on any browser including a MAC and performance is awesome, as you can see !! Hope ya like it. Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, April 02, 2008 9:01 AM To: arslist@ARSLIST.ORG Subject: Requester Console customization ** Listers ~ checking to see if anyone has customized the RQC to allow end users to submit issues on behalf of others. If so, any suggestions? Database: SQL Server 2005 O/S: Windows 2003 (server), R2XP Professional (client), SP2 Apps: Action Request System 7.1 patch 1 Service Desk 7.0.3 patch 6 Laurie Muhlethaler Remedy Developer / Administrator First Republic Bank 415.364.4436 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 message cannot be guaranteed to be secure or error-free. First Republic Bank and its subsidiaries do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB __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: Question: SYS:Notification Messages - Adding NEW Field to pull down menu
Don't you have to add the new #Change Request Status# from $Change Request Status$ translation to the NTE:SHR:TranslateNotificationMessageCRQ1_126 filter? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, April 02, 2008 12:33 PM To: arslist@ARSLIST.ORG Subject: Question: SYS:Notification Messages - Adding NEW Field to pull down menu I added a new field to SYS:Form Field Selection so it would show up in the pull down menu 'email message body' on SYS:Notifcation Messages. This worked - I now see Change Request Status in the pull down 'email message body'. However, when I select it and save the record the notification goes out, but all I see in the email is: #Change Request Status# The Notifcation Message Tag I am trying to modify is: CHG-APR-ApprovalNTForIndividual Any ideas why the field would not show up in the email? THANKS __ _ 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: Requester Console customization
We use Kinetic Request for that. Some service items submit the logged-in user as the customer/requester, while others allow the logged in user to be entered as the the Contact person and submit someone else as the customer/requester. We used ARSPerl scripts to do the same in the past, but ARSPerl no longer works properly with ARS 7.1 anyway. You would have to do a fairly major customization of the Requester Console to get this kind of capability worked into it, and I would avoid that. I do not know if BMC Service Request Management can do this because we stopped evaluating it after seeing the pricing model. In addition to Kinetic Request, there are other non-BMC customer interfaces to ITSM on the market already (like the one Gidd just mentioned), but they solve a host of other customer self-service issues beyond just proxy ticket entry, and should be examined in that wider context. 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 Muhlethaler, Laurie Sent: Wednesday, April 02, 2008 11:01 AM To: arslist@ARSLIST.ORG Subject: Requester Console customization ** Listers ~ checking to see if anyone has customized the RQC to allow end users to submit issues on behalf of others. If so, any suggestions? Database: SQL Server 2005 O/S: Windows 2003 (server), R2XP Professional (client), SP2 Apps: Action Request System 7.1 patch 1 Service Desk 7.0.3 patch 6 Laurie Muhlethaler Remedy Developer / Administrator First Republic Bank 415.364.4436 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 message cannot be guaranteed to be secure or error-free. First Republic Bank and its subsidiaries do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB __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: Question: SYS:Notification Messages - Adding NEW Field to pull down menu
Thanks - i'll try it. Ty On 4/2/08, strauss [EMAIL PROTECTED] wrote: Don't you have to add the new #Change Request Status# from $Change Request Status$ translation to the NTE:SHR:TranslateNotificationMessageCRQ1_126 filter? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, April 02, 2008 12:33 PM To: arslist@ARSLIST.ORG Subject: Question: SYS:Notification Messages - Adding NEW Field to pull down menu I added a new field to SYS:Form Field Selection so it would show up in the pull down menu 'email message body' on SYS:Notifcation Messages. This worked - I now see Change Request Status in the pull down 'email message body'. However, when I select it and save the record the notification goes out, but all I see in the email is: #Change Request Status# The Notifcation Message Tag I am trying to modify is: CHG-APR-ApprovalNTForIndividual Any ideas why the field would not show up in the email? THANKS __ _ 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
Menu Qualification Problem
I have a menu that I am using to pull all the members of a Group. The menu points to the User form and has a qualification of: 'Group List' LIKE (( % + 1024 ) + % ) This works for me as an admin but not for others. They get a no entries in menu message which I assume is due to lack of permissions. They have rights to the User form and the fields queried and displayed from the User form. They also have permissions to the Group form and it's fields. The Group ID is not listed in the Group List field in the User form. The Group names are listed. If I change the query to use the group name then it does not work for anyone. I am assuming Remedy does a translation of the Group ID to Group name but I am not sure what permission is lacking for this menu to work. Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issues with building a view over a DB Link
Gary, Croom Consulting's Link to External Databases can do what you are looking at and with significant less headache. Contact me off list if you would like to arrange an evaluation. Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries Sent: Wednesday, April 02, 2008 12:14 PM To: arslist@ARSLIST.ORG Subject: Issues with building a view over a DB Link ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create the view, but I get sever fields that retrun the error Failure during SQL operation to the database : ORA-00904: ADDRESS1: invalid identifier (ARERR 552). We are researching several possible issues, such as permissions, and the build of the table that I am creating the view of. One suggetion I found searching the list is to create the view in Oracle to the SQL db and then create the Remedy view to the Oracle view. Is it possible to create a view from a view, and if it is, can the data in the SQL table be modifed from Remedy in this view of a view of a SQL table? -- Gary Dries __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: Issues with building a view over a DB Link
Gary, The short answer is yes a view of a view can be modified. There are a couple caviates here. One. The request ID field in remedy. I suspect from your error message that you have the address1 column matched to column 1 on the view form. even with view forms, Remedy needs a unique identifier field, like the request ID. Two. You have to make sure that the link is setup for you to be able to write to the table from your oracle database. Basically, if it can be done in the database, then you can make Remedy do it very easily. HTH, Brian Goralczyk On Wed, Apr 2, 2008 at 2:13 PM, Gary Dries [EMAIL PROTECTED] wrote: ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create the view, but I get sever fields that retrun the error Failure during SQL operation to the database : ORA-00904: ADDRESS1: invalid identifier (ARERR 552). We are researching several possible issues, such as permissions, and the build of the table that I am creating the view of. One suggetion I found searching the list is to create the view in Oracle to the SQL db and then create the Remedy view to the Oracle view. Is it possible to create a view from a view, and if it is, can the data in the SQL table be modifed from Remedy in this view of a view of a SQL table? -- Gary Dries __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
AR server crashing on Product Categorisation data deletion
Hi Listers, I am facing the problem of AR Server getting crashed, when i delete the Global Product categorisation data through Product Catalog Setup form(using the delete button) This action kills the arserver process. What might be the reason behind this? Has anybody faced this? Please pass your thoughts Thanks, Viji -- View this message in context: http://www.nabble.com/AR-server-crashing-on-Product-Categorisation-data-deletion-tp16449460p16449460.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: Product Catalog Data importing and relating to Company
Have you tried the data load console? I found that using the console wasn't always successful but using the forms that are associated with it and utilising the workflow helps a lot.Kind Regards Alan D West Date: Wed, 2 Apr 2008 12:12:49 -0700 From: [EMAIL PROTECTED] Subject: Product Catalog Data importing and relating to Company To: arslist@ARSLIST.ORG I just imported product catalog data to the PCT:Product Catalog form. Now the only way I see to get this associated to the company is to manually associate them through the Product Catalog setup form. But that means I'll have to do this for 400 entries. Is there an easier way to import this data with the company already associated to it? I'm sure there can be workflow created, but I'm looking for something I don't have to spend weeks trying to figure out. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are _ Get Hotmail on your mobile. Text MSN to 63463 now! http://mobile.uk.msn.com/pc/mail.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Test
Test posting with NOMAIL Gary Opela wrote: Just testing, haven't seen anything come through Nabble since 10:30am. - Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. -- View this message in context: http://www.nabble.com/Test-tp16449073p16449564.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: Issues with building a view over a DB Link
Gary, I understand the budget crunch !! Solution cost is $4999.00 + support Here is a link for more detailed information. http://www.buoyantsolutions.net/External_DB.html BTW: There are many on the ARS List that use this solution and swear by it ... not at it !! HTH Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries Sent: Wednesday, April 02, 2008 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: Issues with building a view over a DB Link ** Gidd, I am not in a position to purchase any tool, apps, or anything for that matter. To evaluate something and recommend to management would take longer than I have to resolve this issue. I will talk to my Mgr. to see if he is interested, what is the cost of this solution? Brian, The field mentioned in the error is not the key, the field we have identified as a key is unique, no null and between 6 to 15 characters, that field is not giving us any problems and successfully maps to the view form when it is created. Now the write access issue is another thing I am working on, what I do not understand is the fields that do get mapped in the view form have the same permissions as the fields that error. Fellas, I appreciate the quick response Gary __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: Issues with building a view over a DB Link
What I've had to do in the past in a similar situation is to have the view form referencing a view on my DB that was using a linked server. If you get that part, you can at least see the data. However, if you have issues modifying or submitting the data, unfortunately the next best solution is to build active links on buttons that run SQL commands for insert and update. Thanks, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries Sent: Wednesday, April 02, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Issues with building a view over a DB Link ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create the view, but I get sever fields that retrun the error Failure during SQL operation to the database : ORA-00904: ADDRESS1: invalid identifier (ARERR 552). We are researching several possible issues, such as permissions, and the build of the table that I am creating the view of. One suggetion I found searching the list is to create the view in Oracle to the SQL db and then create the Remedy view to the Oracle view. Is it possible to create a view from a view, and if it is, can the data in the SQL table be modifed from Remedy in this view of a view of a SQL table? -- Gary Dries __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issues with building a view over a DB Link
Brian, I saw this also and sent it to my DBA, he found it interesting also. The only quick explanation we could come up with is that something is happening to the Column Name in translation via the DBLink. Now this has one flaw, and that is the fact that the field that do not error have very similar names, like Address1 errors but Address2 does not. We are working on the process of building the view in oracle and then the view in Remedy, I will keep in mind the naming issue you mentioned. Thanks Gary ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issues with building a view over a DB Link
You know, I am wonderingSometimes I have seen Oracle return the wrong piece of code for the error. Is there any field on the list that might be a reserved word for Oracle? Were you going with just the error, or did you turn on server sql logging and capture the sql code that Remedy was generating? That might help you identify where the actual error is. as well as it should help your dba create the view. On Wed, Apr 2, 2008 at 4:25 PM, Gary Dries [EMAIL PROTECTED] wrote: ** Brian, I saw this also and sent it to my DBA, he found it interesting also. The only quick explanation we could come up with is that something is happening to the Column Name in translation via the DBLink. Now this has one flaw, and that is the fact that the field that do not error have very similar names, like Address1 errors but Address2 does not. We are working on the process of building the view in oracle and then the view in Remedy, I will keep in mind the naming issue you mentioned. Thanks Gary __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: Product Catalog Data importing and relating to Company
You haven't mentioned your app version, but I assume it is ITSM 7. Here are two options: 1. If all your Product Categories will be associated with a single company. * Import the same source file into the PCT-ProductCompanyAssoc form, mapping only the following fields: * Product Categorization Tier 1 * Product Categorization Tier 2 * Product Categorization Tier 3 * CI Type * Company (Map with a static value representing your single company name) * Status (Map with a static value of Enabled if this value does not exist in your source file) 2. If your Product Categories will be associated with multiple companies. a. Use your original source file (Spreadsheet), and add a Company column. b. Populate the new company column with the appropriate values. c. Import the modified source file into the PCT-ProductCompanyAssoc form, mapping only the following fields: * Product Categorization Tier 1 * Product Categorization Tier 2 * Product Categorization Tier 3 * CI Type * Company * Status (Map with a static value of Enabled if this value does not exist in your source file) Note: If all of your Product Categorization was to be associated with ALL of your companies, you could have simply set the Map to Global field to Yes on your original import, which would have automatically created global associations. HTH _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alan West Sent: Wednesday, April 02, 2008 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Product Catalog Data importing and relating to Company Have you tried the data load console? I found that using the console wasn't always successful but using the forms that are associated with it and utilising the workflow helps a lot. Kind Regards Alan D West _ Date: Wed, 2 Apr 2008 12:12:49 -0700 From: [EMAIL PROTECTED] Subject: Product Catalog Data importing and relating to Company To: arslist@ARSLIST.ORG I just imported product catalog data to the PCT:Product Catalog form. Now the only way I see to get this associated to the company is to manually associate them through the Product Catalog setup form. But that means I'll have to do this for 400 entries. Is there an easier way to import this data with the company already associated to it? I'm sure there can be workflow created, but I'm looking for something I don't have to spend weeks trying to figure out. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are _ A prize an hour, 24 hours a day. Try Big Snap http://www.bigsnapsearch.com%0d%0a%20%0d%0a now! __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: Issues with building a view over a DB Link
Just create a view on the db side, create a dblink, then create a synomn on the ars side. Test link.. select * from synonm... ( I know I cannot spell .. ;-) then create a view form.. watch out of Date fields.. and use an escalation or a filter to write back.. voila .. works great.. been doing this for years.. .. Day 1 since the view form came out.. Hope that helps.. ARS DB ARS VIEW ~~ Synonmn ~~ DBlink ~~ View of tables ~~ Tables test your link ! On 4/2/08, Brian Goralczyk [EMAIL PROTECTED] wrote: ** I queried the error on google and came up with a bit from someone else. The amusing part is that they state that Oracle claims that the error doesn't happen in 10g which caused me to immediately check and notice you are on. So I file that under interesting. Personally, I would first make the database view in your database to the one that you are connecting. Make sure that everything works that way. Then you have the choice of either creating the view form and attaching to your view or attempting to create the same process that your view is creating. One note of caution. If you create your view, you CAN NOT use the same name as the view form. And vice versa, you CAN NOT create a view form with the same name as a view that was created in the database. Remedy tries to create a database view to match the form and errors out. I have included the piece that the individual wrote, mostly cause it amuses me with the contridiction. It came from this site.. http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm The Oracle docs note this on the ora-00904 error*: *ORA-00904 string: invalid identifier* *Cause:* The column name entered is either missing or invalid. *Action: * Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word. *According to Oracle documentation, ORA-00904 does not occur in Oracle 10g When ORA-00904 occurs, you must enter a valid column name as it is either missing or the one entered is invalid. To avoid ORA-00904, column names cannot be a reserved word, and must contain these four criteria to be valid: - begin with a letter - be less than or equal to twenty characters - consist only of alphanumeric and the special characters ($_#); other characters need double quotation marks around them Another important factor in correcting ORA-00904 is remembering to run catproc.sql You can also check your trace file to find the particular error which is causing the ORA-00904 to occur. On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn [EMAIL PROTECTED] wrote: ** What I've had to do in the past in a similar situation is to have the view form referencing a view on my DB that was using a linked server. If you get that part, you can at least see the data. However, if you have issues modifying or submitting the data, unfortunately the next best solution is to build active links on buttons that run SQL commands for insert and update. Thanks, Shawn Pierson *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Gary Dries *Sent:* Wednesday, April 02, 2008 2:14 PM *To:* arslist@ARSLIST.ORG *Subject:* Issues with building a view over a DB Link ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create the view, but I get sever fields that retrun the error Failure during SQL operation to the database : ORA-00904: ADDRESS1: invalid identifier (ARERR 552). We are researching several possible issues, such as permissions, and the build of the table that I am creating the view of. One suggetion I found searching the list is to create the view in Oracle to the SQL db and then create the Remedy view to the Oracle view. Is it possible to create a view from a view, and if it is, can the data in the SQL table be modifed from Remedy in this view of a view of a SQL table? -- Gary Dries __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Patrick Zandi Dev Technology Group -- www.devtechnology.com Exceeding your Expectations ! By Design... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Issues with building a view over a DB Link
do you have encryption turned on between the links ? this could be your issue as well. I have seen a required on one side and a requested on the other.. cause issues.. On 4/2/08, patrick zandi [EMAIL PROTECTED] wrote: Just create a view on the db side, create a dblink, then create a synomn on the ars side. Test link.. select * from synonm... ( I know I cannot spell .. ;-) then create a view form.. watch out of Date fields.. and use an escalation or a filter to write back.. voila .. works great.. been doing this for years.. .. Day 1 since the view form came out.. Hope that helps.. ARS DB ARS VIEW ~~ Synonmn ~~ DBlink ~~ View of tables ~~ Tables test your link ! On 4/2/08, Brian Goralczyk [EMAIL PROTECTED] wrote: ** I queried the error on google and came up with a bit from someone else. The amusing part is that they state that Oracle claims that the error doesn't happen in 10g which caused me to immediately check and notice you are on. So I file that under interesting. Personally, I would first make the database view in your database to the one that you are connecting. Make sure that everything works that way. Then you have the choice of either creating the view form and attaching to your view or attempting to create the same process that your view is creating. One note of caution. If you create your view, you CAN NOT use the same name as the view form. And vice versa, you CAN NOT create a view form with the same name as a view that was created in the database. Remedy tries to create a database view to match the form and errors out. I have included the piece that the individual wrote, mostly cause it amuses me with the contridiction. It came from this site.. http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm The Oracle docs note this on the ora-00904 error*: *ORA-00904 string: invalid identifier* *Cause:* The column name entered is either missing or invalid. * Action:* Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word. *According to Oracle documentation, ORA-00904 does not occur in Oracle 10g When ORA-00904 occurs, you must enter a valid column name as it is either missing or the one entered is invalid. To avoid ORA-00904, column names cannot be a reserved word, and must contain these four criteria to be valid: - begin with a letter - be less than or equal to twenty characters - consist only of alphanumeric and the special characters ($_#); other characters need double quotation marks around them Another important factor in correcting ORA-00904 is remembering to run catproc.sql You can also check your trace file to find the particular error which is causing the ORA-00904 to occur. On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn [EMAIL PROTECTED] wrote: ** What I've had to do in the past in a similar situation is to have the view form referencing a view on my DB that was using a linked server. If you get that part, you can at least see the data. However, if you have issues modifying or submitting the data, unfortunately the next best solution is to build active links on buttons that run SQL commands for insert and update. Thanks, Shawn Pierson *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Gary Dries *Sent:* Wednesday, April 02, 2008 2:14 PM *To:* arslist@ARSLIST.ORG *Subject:* Issues with building a view over a DB Link ** I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to create the view, but I get sever fields that retrun the error Failure during SQL operation to the database : ORA-00904: ADDRESS1: invalid identifier (ARERR 552). We are researching several possible issues, such as permissions, and the build of the table that I am creating the view of. One suggetion I found searching the list is to create the view in Oracle to the SQL db and then create the Remedy view to the Oracle view. Is it possible to create a view from a view, and if it is, can the data in the SQL table be modifed from Remedy in this view of a view of a SQL table? -- Gary Dries __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Help with Change Management
Katherine, Having these values missing in the Member List field is definitely a problem that caused the Approval process to fail. The safest way to fix it - by removing and re-creating your few approvers from the person's profile role. However, it could also be done in the AP:Role record directly if you feel comfortable. Igor From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner Sent: Wednesday, April 02, 2008 11:06 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Change Management ** I checked the list and it is empty. I saw this before but I cannot add names to it. I am guessing my approvers should be inthis list huh. On 4/1/08, Model, Igor [ITSUS Non JJ] [EMAIL PROTECTED] wrote: ** Katherine Check the Member List field of the AP:Roles form if the manager's id was also deleted from that list. Igor From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner Sent: Monday, March 31, 2008 2:59 PM To: arslist@ARSLIST.ORG Subject: Re: Help with Change Management ** I am not really well versed with this product. Of Course huh. Someone who doesnt know anything. On 3/31/08, T. Dee [EMAIL PROTECTED] wrote: Have you checked the Approval Process Configuration and Approval Mappings. Ty On 3/31/08, Katherine Hoffner [EMAIL PROTECTED] wrote: ** This is with all the NEW changes. On 3/31/08, T. Dee [EMAIL PROTECTED] wrote: Is this with current Changes or NEW Changes? Ty On 3/31/08, Katherine Hoffner [EMAIL PROTECTED] wrote: ** Hi all, I have a problem with my change requests. One of our managers left and his name was deleted from the system. I am not sure if this had anything to do with the issue but it did happen after his removal. Anyway we have a new manager and I added her to the all Approvals list. Our CTI'S are set up as ALL. We do not have individual approval for different CTI's everything is approved by 4 people. Anyway I cannot get the approvers up to the current signatures line under the Approvals tab on the change request so none of my approvers can actually sign off the change request. All of my change requests are staying in the pending approval state. Running ARS 6.3 -- Katherine __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Katherine __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Katherine __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Katherine __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: Menu Qualification Problem
Brian, The 'Group List' field is a *special* field. I suggest you do a report of that column into an ARX file to really see what data is in the field and how it is structured. ( BTW: I think your menu qualification should really be more like this... [ 'Group List' LIKE (( %; + 1024 ) + ;% ) ] ) However the permission issue has only to do with the User form. Your users likely do not have access to all rows in the User form. (And they likely should not be granted this access either. IMHO) Check permissions on Field ID 1, and the 'Group List' field and any other field in the Menu qualification. If the users have access to Field 1 and 'Group List' then the menu should work for them as well as it works for any one else. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Apr 2, 2008 at 3:06 PM, Sokol, Brian [EMAIL PROTECTED] wrote: ** I have a menu that I am using to pull all the members of a Group. The menu points to the User form and has a qualification of: 'Group List' LIKE (( % + 1024 ) + % ) This works for me as an admin but not for others. They get a no entries in menu message which I assume is due to lack of permissions. They have rights to the User form and the fields queried and displayed from the User form. They also have permissions to the Group form and it's fields. The Group ID is not listed in the Group List field in the User form. The Group names are listed. If I change the query to use the group name then it does not work for anyone. I am assuming Remedy does a translation of the Group ID to Group name but I am not sure what permission is lacking for this menu to work. Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Product Catalog Data importing and relating to Company
Hi all, Is this the filter you are talking about PCT:PDC:CreateDefaultGlobalCompanyAssoc_795_PPDA? Because I see this filter fires only in the Submit and not in merge Thanks Regards Saravanan Palaniappan ITSM To teach and to learn, to laugh and make others laugh. This is my purpose. Any day I don't do this was not worth the time it took to get through it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Thursday, April 03, 2008 2:50 AM To: arslist@ARSLIST.ORG Subject: Re: Product Catalog Data importing and relating to Company If I remember right there's a filter on the PCT:Product Catalog form that associates the record to the global company. Set the filter to fire on merge and all will be ok. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 02 April 2008 20:13 To: arslist@ARSLIST.ORG Subject: Product Catalog Data importing and relating to Company I just imported product catalog data to the PCT:Product Catalog form. Now the only way I see to get this associated to the company is to manually associate them through the Product Catalog setup form. But that means I'll have to do this for 400 entries. Is there an easier way to import this data with the company already associated to it? I'm sure there can be workflow created, but I'm looking for something I don't have to spend weeks trying to figure out. ___ 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 - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are