ARS 7.0.1 Server group on Oracle 10g RAC anyone?

2006-12-01 Thread Albert Bihler
Hi list, is someone out there running a ARS Server group on a Oracle RAC (Real Application Cluster) and willing to share some experience and configuration settings? Any real live information about how ARS manages a cluster fail over? Best regards, Albert

Re: Remedy 6.3 with Crystal Report XI

2006-12-01 Thread rakshit bhandary
Hi, Table itself is picking up value from some form. So you have to find the condition on which the table is getting populated. Then you can use the same conditions in ur CR to extract data from the base form. CR allows data to be extracted based on certain conditions. You can use that. Rakshit

Re: Archiving Data in Remedy

2006-12-01 Thread Webster, Basil
Hi Jase, We have tried to use the built in archiving on numerous occasions and it let us down badly. From the archive form not being accessible to adding of fields etc. These can lead to the loss of data. What we did was use a similar approach as Remedy but build our own. We took the origin

Re: Archiving Data in Remedy

2006-12-01 Thread lars . j . pettersson
Hi, we have done exactly the same, and it has been up and running i prod för about 3-4 years, we archive request which have been in staus closed for 13 months, 500 every night including attachments, escalations and push field action, works fine. /L ars -Original Message- From: Action Re

Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
All, One of our users is running a report/extract against a join form. You can browse the join form without any issues, but upon running the report and extracing the data, you get the following : Error occurred in generating report. ARERR [552] failure during SQL operation to the database : Lin

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Ben Chernys
Run SQL logging on the server; grep out unwanted records (say by user id); then look at the SQL statement that throws the error. Cheers Ben >- --- Original Message --- - >From: Dave Barber <[EMAIL PROTECTED]> >To: arslist@ARSLIST.ORG >Sent: Fri, 1 Dec 2006 12:47:

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Carey Matthew Black
Dave, This is a WAG without seeing the SQL in question... but... I would make sure that the user is using the following procedure. 1) Open form in Query mode. 2) Specify search conditions 3) DO NOT DO THE SEARCH 4) Jump directly to the report selection screen from the QUERY window. 5) select th

Re: ARS 7.0.01 in Production

2006-12-01 Thread Howard Richter
I would like to know if they did an upgrade or a new install if they do have it running. Also I am still looking for the release notes on ServiceDesk 7.0.1, if anyone can point me to it that would be of help. Howard Richter On 11/29/06, Axton <[EMAIL PROTECTED]> wrote: ** Is anyone running 7

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
We're definitely doing the search in the correct manner; I learnt about that the hard way a few years back. SQL logging makes for interesting reading, I've grepped out "my" entries into another file, and will start looking through it. Haven't had much experience of this type of debugging before,

Re: Archiving Data in Remedy

2006-12-01 Thread Mike White
I haven't seen discussion about disk space and indexes relative to archival, so thought I'd add it as a consideration. In most databases, such as Oracle and MS SQL, records aren't actually deleted, but rather are flagged for delete. Usually some "other activity" is used to reclaim disk space from

Re: ARS 7.0.01 in Production

2006-12-01 Thread Ford, St John
We are running 7.0.1 in production. We upgraded from 7.0.0 patch 1 on 12th November to try and alleviate problems with mid-tier connections, which it has. We are running separate windows 2000 servers for ARserver, SQL and mid-Tier(Tomcat). Tomcat mid-tier is much faster than previous versions.

Re: Heavy Load Balancing Question

2006-12-01 Thread Barry Lindstrom
Thanks folks...Good input I am also contemplating putting a variable for actual servername on the filter to ensure a user always writes to the same server during the process. As with most Remedy issues, there are multiple solutions and this remains the optimal spot to consult with Remedy Problem

Function of different characters in filters

2006-12-01 Thread Dave Barber
All, This may be an elementary question, but are there any characters that cause different behaviours on filters? I'm looking at a filter that shouldn't seem to work quite as I'd expect it to, but I'm wondering if the use of characters in the name makes any difference? Its got a '! at the end .

Re: Function of different characters in filters

2006-12-01 Thread Mahan, Janet L [EQ]
The '! on the end of the filter name is to make sure that values are retained in memory that might be NULLED out by other workflow. Janet Mahan NSM Systems Admin II EMBARQ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf O

Re: Function of different characters in filters

2006-12-01 Thread Eric Cleereman (IT)
Hi Dave, This one got me before too. The help file from ARAdmin 6.3 shows the following: Using special override naming convention To override the phases for a specific filter, you can make a filter run in-line (sequentially) by using a special naming convention in the filter name. When you c

Re: Version 5 API

2006-12-01 Thread Frank Caruso
Upon further investigation I've found that the Wiki has version 5.0 LIB and INCLUDE but does not contain the arutl50.dll and the arrpc50.dll. It does have the arapi50.dll. It does not matter which version (5 or 5.1) but I am still looking for a complete set from someone: LIB, INCLUDE, DLLS. Than

Re: Heavy Load Balancing Question

2006-12-01 Thread Carey Matthew Black
Barry, Or you can skip this issue and have the Run Process create a "temp record" with the attachment in it. That way the user does not care about the physical OS that is in play and the active link could even delete the temp record after the user gets the Attachment back to their client too. (

Re: Function of different characters in filters

2006-12-01 Thread Dave Barber
Eric, Thanks for that ... I can hear a noise of something wooshing over my head, its gone right over me. Phase1? Phase 3? now that I look further into it, the problem appears to be elsewhere, but this is all good stuff to know. Thanks, Dave ps. Wish there was some nice IDE/debugging tool fo

Re: Function of different characters in filters

2006-12-01 Thread Mike White
? No. Appending `! to a FIlter's name forces it's actions to be processed in "Phase 1". Filter actions are "phased", separated into 3 phases - Phase 1, Phase 2, and Phase 3. Set Fields actions, for example, are processed in Phase 1, while Push Fields actions are processed in Phase 2. Run Proce

Re: Remedy 6.3 with Crystal Report XI

2006-12-01 Thread patrick zandi
Someone Recommended the book :: Crystal reports (the complete reference) by peck.. I have the 9 version. Very handy.. and a good reference.. If I was to remember everything My head would explode. On 12/1/06, rakshit bhandary <[EMAIL PROTECTED]> wrote: ** Hi, Table itself is picking up value f

Re: Popup Blockers

2006-12-01 Thread Robert Molenda
Nice little code chunk, saving to my code bases :) Yes, pop-up blockers are a pain, but we have instructed all of our users to add the base 'domain name' of the company into the pop-up-blocker "allowed" list. Fortunately, there are other applications (like our expense entry system) which have thi

Email Engine Error: No arutiljni63 in java.library.path

2006-12-01 Thread Jack Samson
All- I looked at the previous postings and did not really understand the fix. I am posting this one more time to see if anyone has any ideas. Thanks in advance. Regards, All, I am trying to start my email process and am getting the following error: I am usi

OT:Friday - Holiday Humor

2006-12-01 Thread Gidd Calden
Just before Christmas, there was an honest politician, a kind lawyer and Santa Claus travelling in a lift of a very posh hotel. Just before the doors opened they all noticed a £5 note lying on the floor. Which one picked it up?? Santa of course, the other two don't exist! --- What do you call

Re: Email Engine Error: No arutiljni63 in java.library.path

2006-12-01 Thread James Pifer
I've had this issue with the libraries on linux. In my case even though ldconfig was configured for the libraries I had to have this environment variable before I could get things to work: LD_LIBRARY_PATH=/usr/local/lib/ar63 So I have this in /etc/rc.local so it happens on boot: LD_LIBRARY_PATH=/u

Re: Email Engine Error: No arutiljni63 in java.library.path

2006-12-01 Thread Carey Matthew Black
James, The issue (as I understand it) is more of a Java thing than an OS thing. Java does not tend to take advantage of the full features set of the OS. Rather it uses a LCD (least common denominator) approach and expects you to either pass things in via the env settings or command line settings.

Re: Remedy 6.3 with Crystal Report XI

2006-12-01 Thread Dave Barber
Thats not a bad book; it doesn't help with some things though, such as why global variables are only accessable at print time, not before (that is very, very irritating). Does anyone have suggestions as to other query tools that are more flexible than Crystal? It doesn't seem like too bad a prod

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
Okay then, some (small) amount of progress. I've got the SQL log, which doesn't help that much. However, restricting the report to just one or two fields rather than all allows the query/extract to run correctly. Nothing in the logs points to which field is causing the report to crash out, so i

Re: OT:Friday - Holiday Humor

2006-12-01 Thread Warren Baltimore
GROAN.. On 12/1/06, Gidd Calden <[EMAIL PROTECTED]> wrote: Just before Christmas, there was an honest politician, a kind lawyer and Santa Claus travelling in a lift of a very posh hotel. Just before the doors opened they all noticed a £5 note lying on the floor. Whic

Re: Archiving Data in Remedy

2006-12-01 Thread Richard Crosby
To me, the biggest pitfall is that there is only one thread for escalations. This is problematic if you use escalations for other processes (such as notifications, record clean-up/deletion, etc) that fight for an open escalation thread. In this case, proper table indexing, archiving/record deletion

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Sabrina Ethridge
Dave Do you have any Diary fields in the export when you see the problem? If I recall correctly, we had this problem and it was due to a corrupt timestamp in a diary field, which was corrupted by a bad data import. If I remember correctly, we found the exact record by running smaller and smal

Re: OT:Friday - Holiday Humor

2006-12-01 Thread Thad Esser
A work-waster for the holiday season... http://www.elfyourself.com/ "Gidd Calden" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 12/01/2006 07:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT:Friday - Holiday Humor Just

Login name restrictions

2006-12-01 Thread Ian Trimnell
One for Friday afternoon (well it is here!)... Does anyone know of any character restrictions in the login name field (ID 101)? (ARS 6.0.1 patch 1368, W2K server, SQL Server 2000) In the 9 or so years we've been running AR System we have been using real names for login so that we can easily s

Asset Management & Inventory Control via Remedy

2006-12-01 Thread T Wang
Hi Lister, Right now we are trying to improve our Asset Management & Inventories business processes, which currently involve an intermediate database, etc. We are looking into MagicWand to replace our current barcode system and would like to hear from any one who is actually using this product. R

Re: Login name restrictions

2006-12-01 Thread Eric Cleereman (IT)
Hi Ian, If you use a double apostrophe it should work. i.e. O''Toole Eric Cleereman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ian Trimnell Sent: Friday, December 01, 2006 11:32 AM To: arslist@ARSLIST.ORG Subject: Login

Re: Login name restrictions

2006-12-01 Thread Ian Trimnell
Eric Cleereman (IT) wrote: ** Hi Ian, If you use a double apostrophe it should work. i.e. O''Toole Eric Cleereman Eric, I tried that to start with and got the message: "ARERR [618] Computed group qualification contains invalid content : ProcessComputedGroupFromClient()" Thanks, Ian

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
Sabrina, I've had that issue with diary fields before now. However, there are no diary fields on this join form, I've tried removing all the longer text fields (possible problem with some characters), and that doesn't resolve it. I'm doing this the long winded way - removing fields until I find

Identify which filter created a notification

2006-12-01 Thread Peter Romain
Hi All, Has anyone ever found a way to dynamically identify which filter caused a particular email or alert? The scenario is that when a mail or alert record is generated no mail or alert is sent unless the filter creating the notification is in a list of allowed filters (maintained by users

Email Templates

2006-12-01 Thread David Yearsley
We are using Remedy Email HTML templates with the Purchasing application and everything is working fine except for the dollar amount. It is printing as 6160.00USD. It would be nice if there were only 2 0's and it would be really nice if there was a space before the "USD". i.e., 6160.00 U

Re: Identify which filter created a notification

2006-12-01 Thread Heider, Stephen
Peter, I use codes that appear in the lower right corner of the html email in a small font. You could also make the codes (or names of filters) in hidden text. The text would be visible when you open the email in a text editor. For HPD:HelpDesk notifications, I use H01 - H##, for CHG:Change I

Re: Identify which filter created a notification

2006-12-01 Thread Urbanek, Clint
Peter, I have built a tool to allow me to search for notifications and messages based on notification subject, notification text, message number, message type or message text. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Beh

7.0.1 Midtier login messages

2006-12-01 Thread Anthony Caressimo
Hi all, I am running mid tier 7.0.1 against AR Server 6.3 p18, Helpdesk 6.0. Upon logging in / clicking Helpdesk link for a requester they receive the message 'ARWARN [59] No such user exists -- successfully connected as a guest user ' This is new in 7.0.1 - i just checked on 7.0.0 p2 and it

Re: Login name restrictions

2006-12-01 Thread Scott Parrish
While this is a cumbersome workaround, I would create a separate group strictly for names such as O'Toole then add that special group to the computed group. You could put all special names into this one group or create a separate group for each special name since you may not want to add O'Toole and

ITSM Upgrade Installer

2006-12-01 Thread Kim Ardito
I am a Remedy Admin at Yale New Haven Hospital. We are in the process of trying to upgrade ITSM from version 5.6 to 6.0. Our environment is : Unix AIX 5.2 Oracle 9i release 2 ARS 6.3 patch 18 ITSM 5.6 Oracle is on the same server as the Applications. Our install order was to be: CMDB 1.1,

Re: 7.0.1 Midtier login messages

2006-12-01 Thread Rawat, Jaspal
I think, u need to uncheck "Allow Guest Users" in server configuration window to do this Thanks Jaspal S Rawat TDS Telecom Information Systems Mail: [EMAIL PROTECTED] Phone: (608) 664-4517 Fax: (608) 664-5499 -Original Message- From: Action Request System discussion list(ARSList) [

Problem w/ SLB and Mid-Tier 6.3

2006-12-01 Thread Sean Garrison
We have a web server (1.1.1.1) which is behind an slb (2.2.2.2). We have configured it so that the web server (1.1.1.1) can communicate clear text over port 8080. On the SLB (2.2.2.2) we have set it so that it handle all ssl connectivity to web server 1.1.1.1. So that when you connect like this:

Re: AR WebServices not parsing ok

2006-12-01 Thread Bruce Jeng
Hi, I am having similar OutputMapping problem with Java web service client consuming Remedy 6.03 web service, wonder anyone would have a solution for this. My web service has a Create and Get operation, the Java web service client I built is getting error "Invalid element in ARWSClient.CreateO

Re: ITSM Upgrade Installer

2006-12-01 Thread Rick cook
Yes, AIX is a problem for the CMDB installers. Look for an .html file in the directory from which you ran the CMDB extension loader. It's the most reliable indicator I've found for telling the actual state of the upgrade. Rick -Original Message- From: Action Request System discussion li

Re: AR WebServices not parsing ok

2006-12-01 Thread Dan Hardy
Are you using Axis and wsdl2java for your Java client? I've found that Axis (1.4, I think) is incompatible with Remedy web services. I've needed to manually modify the output classes from wsdl2java to get it to work. The generated stubs looked for responses in the body, but they are sent in

Dumb question? Is Remedy for ITSP 4.0 free?

2006-12-01 Thread Geoffrey Endresen
I know that I've had my head in the sand or I'm just coming up for air... Nevertheless. Is Remedy for IT Service Providers free for use or does it have extra licensing costs? Thanks, -Geoff Endresen ___ UNSUBSCRIBE or a

Re: Dumb question? Is Remedy for ITSP 4.0 free?

2006-12-01 Thread Geoffrey Endresen
The reason that I ask is that it appears in my Support Download at the Remedy / BMC site. I think I would have remembered purchasing it. On 12/1/06, Geoffrey Endresen <[EMAIL PROTECTED]> wrote: I know that I've had my head in the sand or I'm just coming up for air... Nevertheless. Is Remedy fo

Re: 1 Remedy User - Unable to Select in Table

2006-12-01 Thread Candace DeCou
Well darn Sharon - don't you just hate it when that happens? I did have a similar experience recently. After almost shooting myself in the head to stop the pain, I got our Desktop support people looking into the situation. Turns out that this was never a Remedy issue, but something wrong with th

Re: Dumb question? Is Remedy for ITSP 4.0 free?

2006-12-01 Thread Easter, David
IT for Service Provider licenses are not free. In checking Upgrade Central, it appears that ITSP 4.0 is being listed under the Group/Name of AR System for some reason. Have you recently purchased Service Desk under your contract ID - or is your contract for AR System only? -David J. Easter Sr

Re: 1 Remedy User - Unable to Select in Table

2006-12-01 Thread Rawat, Jaspal
Sharon, Can u tell me, after the table rows becomes unselectble, Whether user go to some other menu/form/Nav bar etc inside the User tool and does it works or User tool basically freezes. Thanks Jaspal S Rawat -Original Message- From: Action Request System discussi

Re: Dumb question? Is Remedy for ITSP 4.0 free?

2006-12-01 Thread Lucero, Michelle - IST contractor
Hi, Mr. Easter: It may be the case that the site needs to be checked in general. I could have sworn that I saw extra items on the upgrade list (yesterday) that we should not have access to. Don't worry, I didn't download 'em. It may be that BMC should get a QA group together to do some final

Test Post-plz ignore

2006-12-01 Thread Tim Richardson
Test ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

Re: Test Post-plz ignore

2006-12-01 Thread Halstead, Robert
It works Bob Halstead -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Richardson Sent: Friday, December 01, 2006 4:11 PM To: arslist@ARSLIST.ORG Subject: Test Post-plz ignore Test __

Re: Attachment Name is creating Problem...

2006-12-01 Thread Karim Merali
We've see similar issues with the attachement field on our HPD:Helpdesk forms... Occasionally a user will send in an attachment (routed by email and filters) and when we try and open the Helpdesk form, the AR client just dies! No message or anything... we may get a Windows message about the u

Immediate opening in Mumbai, India

2006-12-01 Thread Tim Richardson
Hello Listers, We have an immediate opening in our company for a sharp Remedy developer in Mumbai. If interested please send an email to [EMAIL PROTECTED] We will be filling six more positions in Mumbai and Pune in January. We look forward to hearing from you. Kind regards, Tim Richardson

Re: Remedy 6.3 with Crystal Report XI

2006-12-01 Thread Siti Hawa Bee SHAIK FARID
Hmm..i'll try to source that book today in the library. Thanks Pat. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, 01 December, 2006 23:01 To: arslist@ARSLIST.ORG Subject: Re: Remedy 6.3 with Crystal Report XI

Re: Dumb question? Is Remedy for ITSP 4.0 free?

2006-12-01 Thread Geoffrey Endresen
Our contact for Amazon is AR System only. Maybe it was purchased years ago and just showed up on the list during the conversion to the new support site. Thanks, -Geoff On 12/1/06, Easter, David <[EMAIL PROTECTED]> wrote: ** IT for Service Provider licenses are not free. In checking Upgrade C