Re: Remedy Email Notification Subject Line is Blank

2010-07-16 Thread Prashanth Bhagawat
Hi Thad, There is no filter which is clearing the subject line, and permission isn't an issue to, it has got similar permission to that of the body which is getting set on AR system email messages form. Br, Prashanth From: Action Request System discussion

Re: Corrupt Attachments

2010-07-16 Thread Jason Miller
I don't know what might be happening but just wanted to pass on a observation of attachment behavior. The attachment is opened from the local machine until the records is saved. So before step 4 everything with the attachment is happening on the local machine. To verify add the attachment to

Re: Remedy Email Notification Subject Line is Blank

2010-07-16 Thread Mahendra Mahalkar
Can u try with another test form instead of IPMT, push the subject body to AR System email messages form through a filter? Thanks Regards, Mahendra Mahalkar On Fri, Jul 16, 2010 at 11:29 AM, Prashanth Bhagawat prashanth.bhaga...@accenture.com wrote: ** Hi Thad, There is no filter

OT- Friday Humour

2010-07-16 Thread Nair, Rajesh IN BOM SISL
Have Nice weekend A wealthy man was having an affair with an Italian woman for several years. One night, during one of their rendezvous, she confided in him that she was pregnant. Not wanting to ruin his reputation or his marriage, he paid a large sum of money if she would go to Italy to

Open Spaces ITSM Recruitment - Urgent BMC BSM Positions in the UK, Europe, Middle East and South Africa

2010-07-16 Thread remedypeople
Hi there, it's Ross here from Open Spaces ITSM Recruitment in London. I am now urgently looking for experienced BMC ITSM Specialists and Consultants for implementation, development, support and consultancy roles in the UK, Belgium, Switzerland, Germany, Sweden, The Netherlands, Italy, South

Filter creates one error by calling one API since we've migated to ARS 7.5

2010-07-16 Thread Tournier, Pascal
Hi, We have recently migrated for Remedy ARS 7.0.1 to 7.5 and since then I have one issue with one filter which call one API script.. By looking to the log I see that the filter exit the script with a error Exit Code : 127 ... furthermore it seems that the script is even not exectuted and

WebServiceSoapClient class (ARERR 9130)

2010-07-16 Thread Prashanth Bhagawat
Hi All, We are noticing the below mentioned error message when we restart remedy service in arerror.log Can't locate the WebServiceSoapClient class (ARERR 9130) I could find the attached KB article but is of no help how can I proceed in debugging this further Regards, Prashanth This

Re: Preference Server in a Server Group (7.5)

2010-07-16 Thread William Rentfrow
Doug - Thanks for the repsonse - and I agree with everything you said. The question is how do we actually configure it that way so users don't have to choose it? The issue here is that we do not want the users to specify the preference server in the WUT. Consequently the server side

Re: Capturing SQL Statement

2010-07-16 Thread LJ LongWing
John, I know the question comes up every once in awhile..and the common agreement is that yes, remedy will pass a 1=0 to the DB.the argument typically occurs around what happens when it hits the DB. Well, from personal experience, I have seen remedy pass a 1=1 to the DB and have that query BLOCK

Re: Filter creates one error by calling one API since we've migated to ARS 7.5

2010-07-16 Thread LJ LongWing
Verify that your services are running the sameI have had better success with run-processes if the remedy service isn't running as 'Local Service', but instead as a specific domain user. -Original Message- From: Action Request System discussion list(ARSList)

Re: Capturing SQL Statement

2010-07-16 Thread John Sundberg
Would the SQL log of ARS show that query? (I hope so) And if so - any idea what it would look like in the log? -John On Jul 16, 2010, at 9:18 AM, LJ LongWing wrote: ** John, I know the question comes up every once in awhile….and the common agreement is that yes, remedy will pass a 1=0 to

Re: Preference Server in a Server Group (7.5)

2010-07-16 Thread LJ LongWing
I would agree that 'Use This Server' is the option I would personally choose...basically when a client connects to a server, that server would then say 'oh, I'm your pref server'..due to the fact they wouldn't be connecting to more than one of them at any time.I think that would work J From:

Re: Preference Server in a Server Group (7.5)

2010-07-16 Thread Elry
William... We use the option: Use This Server In addition to that we created a AR Sysem User Preferecne entry in the Preference form for every User Profile. On the Preference Form there are a number of useful parameters that you can set for End Users that are logging into the system. i.e. 1)

Re: Capturing SQL Statement

2010-07-16 Thread AR Admin
Speaking of databases, does anyone know if it's safe to run update queries on remedy database externally with a vb app? Any possible side effects from not using remedy C or java api to do this? Thanks Date: Fri, 16 Jul 2010 07:18:14 -0600 From: lj.longw...@gmail.com Subject: Re:

Re: Remedy Email Notification Subject Line is Blank

2010-07-16 Thread Arner, Todd
Is it possible that the subject field is set to Display Only? I have ran into problems pushing data to an email from a display only field... Just a thought. Todd Arner From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf

Re: Filter creates one error by calling one API since we've migated to ARS 7.5

2010-07-16 Thread Grooms, Frederick W
What does the arfork log say? Also since you are using a specific port, does the new server have that port defined as a private port? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tournier, Pascal Sent: Friday,

Re: Capturing SQL Statement

2010-07-16 Thread Danny Kellett
Depends on the update. If you speaking of just changing a field other that status then that should be ok. Otherwise you will have to update the H tables too Kind regards Danny From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of AR Admin Sent:

Re: Corrupt Attachments

2010-07-16 Thread Jason Miller
Hi William, Is this the same 4 AR Server group that you mention in the Preference Server in a Server Group (7.5) thread? I know your users do not have access a individual server but do you? If you do, does this same issue happen when connected to an AR Server directly? It doesn't make much

Re: Capturing SQL Statement

2010-07-16 Thread John Sundberg
Side question -- if you go raw to the database with your mods -- I assume that does not take an ARS license. Any comments? -John On Jul 16, 2010, at 10:01 AM, AR Admin wrote: ** Speaking of databases, does anyone know if it's safe to run update queries on remedy database externally

Annoying Error

2010-07-16 Thread lakhes
Listners, Has anyone see the follwoing error? Can't find it...can't reproduceThis happens when you want to Resolve a ticket. You can't resolve the ticket unless you make adjustments of the dropdowns on the tickets. Generally you have to change the status or the priority to get it to accept

Re: Capturing SQL Statement

2010-07-16 Thread Matthew Perrault
John, From what we have seen in the SQL Log it will look like: SELECT TOP 2147483648 T983.C1,C100161,C10,C7,C100164,C100169,... FROM T983 ORDER BY 2 DESC, 1 ASC Notice: no WHERE clause. This was issued by an end user, who then cancelled it after ARS had issued it to the DB.

Re: Capturing SQL Statement

2010-07-16 Thread Matthew Perrault
Correct. Just a SQL login and account with the required permissions From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Friday, July 16, 2010 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: Capturing SQL Statement ** Side question

Re: Annoying Error

2010-07-16 Thread Herb Partlow
Hi I had something like that happen on a ARS 7.5/Itsm 7.5 server. Turned out to the values in the tables related to the menu. The data/value had 2 different entries. One spelled or formatted correctly the other was either mid-spelled or had a hidden space in it. Herb Partlow IB Technical

ARS 6.3 and RKM 7

2010-07-16 Thread Frank Caruso
Looking to see if anyone has been able to run the following configuration: ARS 6.3 p24 RKM 7 P4 ServletExec 5.0 Hummingbird SS 6 (I know that ServletExec and or version of ARS is no longer supported by BMC.) Thank you.

Re: ERROR (1291053)

2010-07-16 Thread Kevin Begosh
Mauro, You are getting that message because you have to pass the group ID as well as the group name. The system does not look it up and populate it. At least we had that issue when working with Atrium Orchestrator Kevin Begosh On Thu, Jul 15, 2010 at 9:23 PM, Mauro Monteiro

Re: Preference Server in a Server Group (7.5)

2010-07-16 Thread Mueller, Doug
William, You should be able to use the Use this server Option. This should be turned on for EVERY server in the server group. Then, when you access the one and only server that the mid-tier or windows client has configured, that server will tell you that I am the server for the preference

Re: Capturing SQL Statement

2010-07-16 Thread Guillaume Rheault
the comment is , as you know, you are bypassing at the very minimum, the ARS licensing scheme and permissions model Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of John Sundberg [john.sundb...@kineticdata.com]

Re: ARS 6.3 and RKM 7

2010-07-16 Thread Roger Justice
If you run the RKM and Hummingbird on a separate server with the proper Tomcat version that should work. The issue will be building the customizations to get to the RKM application from the ITSM/custom app you are running. -Original Message- From: Frank Caruso caruso.fr...@gmail.com

Re: Capturing SQL Statement

2010-07-16 Thread Joe DeSouza
Unless you are on 7.5 where you can disable the Status History on a form property. In version 7.5, the AR System doesn't care if the status history table is not populated. BMC is probably working in the direction to depricate that option which frankly in my opinion does not serve much value..

ARS 6.3/Oracle 9 -to- ARS 7.5/Oracle 11g

2010-07-16 Thread Rabi Tripathi
Hi all, To make the above switch, I am planning to first upgrade to Oracle 10g, then upgrade ARS to 7.5, then upgrade Oracle to 11g. The key fact being that Oracle 11g is not supported by ARs 6.3, but Oracle 10g is supported by both ARS 6.3 and ARS 7.5. The lazy in me is trying to find out if

Schrödinger's Active Links on the Mid Tier

2010-07-16 Thread Pierson, Shawn
Ok folks, here is a weird one. I am having an issue with a custom application that started after we upgraded the Mid Tier from 7.1 to 7.5 patch 4. Basically, I have a console with a table field and an external qualification. That qualification is set on Window Open, and it is based on what

Re: Schrödinger's Active Links on the Mid Tier

2010-07-16 Thread Chuck
There are other problems with Patch 4, I don't think Patch 4 or Patch 5 for midTier are any good, back down to Patch 3 and test. On Jul 16, 2:09 pm, Pierson, Shawn shawn.pier...@sug.com wrote: Ok folks, here is a weird one.  I am having an issue with a custom application that started after we

Re: ARS 6.3/Oracle 9 -to- ARS 7.5/Oracle 11g

2010-07-16 Thread Grooms, Frederick W
ARS 6.3 requires the Oracle 9iR2 client. I can't remember if the Oracle 9 client can connect to an Oracle 11g database. If it can then you can upgrade Oracle all the way to 11g while still on ARS 6.3. Fred -Original Message- From: Action Request System discussion list(ARSList)

Re: Schrödinger's Active Links on the Mid Ti er

2010-07-16 Thread Rabi Tripathi
Shawn, That's weird. Instead of relying on logging, you can add active link messages in between the active links that build the field for external qual, and see how the values are changing (especially the field referenced by external() ). Is the field(s) referenced by external() visible? If

SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread Chintan Shah
Hello, I have a table field that represents a view form. Now, I need to get only unique rows in that table. The problem is for a particular ID(on view form) there could be multiple email addresses and I want to get DISTINCT email in table field before walking through it and extracting

Re: ERROR (1291053)

2010-07-16 Thread Joe DeSouza
It might be in one of the views or if not in any might be one of the fields that is not in any view.. Check the Fields in View option and look for fields that are not in view, and you should see it in that list.. If the field was not present at all then the error you would get would be

Re: WebServiceSoapClient class (ARERR 9130)

2010-07-16 Thread Joe DeSouza
I have never received that errors so taking a couple of shots in the dark.. Have you installed the 'Web Service' component while installing the ARS? Is your mid-tier up and running? Joe From: Prashanth Bhagawat prashanth.bhaga...@accenture.com To:

Re: SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread jham36
I'm thinking that a join form might work. I'm going to check the documentation on inner and outer joins. Maybe join the view form to itself. Then use the join form in your table field. James On Jul 16, 4:30 pm, Chintan Shah cbss...@yahoo.com wrote: Hello, I have a table field that

Re: SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread Drew Shuller
-- Drew ique index? Not sure if it will work on a view form. Drew Comayagua On Fri, Jul 16, 2010 at 2:53 PM, jham36 jha...@gmail.com wrote: I'm thinking that a join form might work.  I'm going to check the documentation on inner and outer joins.  Maybe join the view form to itself.  Then

Re: SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread Sam Rx
i have seen something very similar .. we had to publish a webservice with unique records however on our form we had duplicates records. as a workaround..we created a SQL view in the DB (using distinct sql query ).. Created a View form on arserver and then finally created a Webservice on the view

Re: SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread Joe DeSouza
I would go with creating a DB view too as its simpler and not too hard to maintain.. Joe From: Sam Rx sam...@gmail.com To: arslist@ARSLIST.ORG Sent: Fri, July 16, 2010 6:26:21 PM Subject: Re: SQL equivalent of DISTINCT in Remedy ** i have seen something

archgid utility for ARS 7.5...

2010-07-16 Thread Joe DeSouza
Does anyone know where to get this from? It doesn't get installed in the program folder of a windows install. I wonder if UNIX installations install a copy of it? If not is it available on the developers network? I think I might want to rearrange certain field ID's in a small customization

Re: SQL equivalent of DISTINCT in Remedy

2010-07-16 Thread Chintan Shah
Thnx everyone for replies. James, I will take a look at inner-join documentation. Sam, SQL view with distinct SQL query and then build view form on top of it also sounds like a good option. I will check it out. Regards, Chintan. --- On Fri, 7/16/10, Sam Rx sam...@gmail.com wrote: From: Sam

Re: ARS 6.3/Oracle 9 -to- ARS 7.5/Oracle 11g

2010-07-16 Thread D Dussie
If you can verify 9i client works against 11g db on same os, then probably this will work. My environment is .. aix. Our migration path to 11g, aix 5.3 L7 -6.3 - 9i - 10g aix 5.3L7 - 7.5 - 10g aix 6.1 - 7.5 - 10g. We needed aix upgrade and os and application. -Original