Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning Invalid AR Export format file error

2008-08-21 Thread Jay Sytangco
Hi All, Have anyone experienced exporting records from a form but the exported arx file cannot be imported back to the same form? I found out that the arx file contains a number of ? characters scattered within the data and I'm not sure what causing these characters to be included in the

ARS.XSD File location

2008-08-21 Thread Saravanan Palaniappan
Hi Listers, I generated a XML file (instead of DEF file) while exporting a form from the server. The XML refers to an XSD file called ars.xsd. I wanted that XSD file to understand the tag definitions better. I did search for that but couldn't find it. Can you please help me out with the

filtering of collection in table object

2008-08-21 Thread rg25
Hi all, I am using ARS 7.1 and have a problem regarding filtering of collection in table object. Table object using Vendor Form as supporting form. I want to filter a result from a Vendor Form by one column (e.g Item No). To do it I have use [Item No LIKE %some_phrase%] in external qualification

Re: filtering of collection in table object

2008-08-21 Thread Carey Matthew Black
Dear rg25, You said: But in this approach I can not filter collection. but you did not explain what is failing. Is there an error message that you are getting? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People +

Re: 6.3 Helpdesk Ar System...

2008-08-21 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
I've done this before. I did the following: Whenever a child ticket is closed, push a value to a hidden, display-only radio button. The Parent Ticket will have a filter that runs on modify if that radio button has a value. It will select the request ID of the first child ticket that is still

Jobs: Multiple Contract-to-Hire Openings Across the US with Kforce

2008-08-21 Thread Kitchen, Joshua T
Dear List, Sorry to overwhelm you all with many postings these past couple weeks. I figured I would post a quick summary of what we are looking for (Must have all of the following to be considered for the position): 1) Remedy Developer - Wisconsin - 6 month CTH - 7+ Years Exp, 7.0.2/7.0.3,

JOB: Column Technologies seeking a Remedy Developer with Secret Clearance based in OK for a 1 yr project

2008-08-21 Thread Melissa Wish
Column Technologies is seeking a Remedy Developer with a Secret Clearance for a gov't project in Oklahoma City, OK. This is a permanent position with a generous salary, benefits, bonus and vacation package. The local project will last 1 year +. Candidates must be based in OK. If you're

Re: Two Tomcat on same server

2008-08-21 Thread Axton
Sweet. Would you mind posting the list of jars to the list that you moved to a common classloader? Thanks, Axton Grams On Wed, Aug 20, 2008 at 4:55 PM, LJ Longwing [EMAIL PROTECTED] wrote: Wow...it's amazing what can be accomplished with the right tools and knowledge...I used my machine as a

Re: Another view form question...

2008-08-21 Thread Axton
Look into using a sequence via a trigger to populate the column. Axton Grams On Wed, Aug 20, 2008 at 4:13 PM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: Drew- I figured I'd have to create a new column, but how can I populate it? Is there a way in SQL to generate a GUID for each

CMDB patching

2008-08-21 Thread Konstantin Pavlov
Hi all I want to ask you something which bother me from the last week. I'm in the process of preparing of test environment for tracking all changes caused by the 7-th and 8-th ITSM patches. I read all the documentation regarding it - patching of all AR components (server, midtier,

Re: Another view form question...

2008-08-21 Thread J.T. Shyman
SQL2005 has a newid() function that you can set a column to. It creates a 16-byte unique identifier...however, that may still be too long for Remedy...but it is worth a shot. http://msdn.microsoft.com/en-us/library/ms190348(SQL.90).aspx Note that this may affect the way data is imported into the

Re: Another view form question...

2008-08-21 Thread Grooms, Frederick W
Why can't you use ROW_ID? You only need the unique ID for displaying the View Form. When selecting records from the View form save the GUID and work with that (just make sure that field is indexed on your table). When the table is overwritten there is no problem because you have never saved the

MidTier 7.0.01/Patch 7 - CRS XI/R2 - Crystal Concurrent License Usage

2008-08-21 Thread Mary Ann
We have used Crystal with Remedy for years now but are new to Crystal Reports Server and the Midtier. We have Crystal Reports Server XI/R2 installed on a separate server from the MidTier 7.0.01/Patch 7. We bought 5 concurrent (not named) Crystal Licenses. What we have noticed is that if only

Question: Help Desk 6.0 - Solutions

2008-08-21 Thread T. Dee
Does anyone use the List Possible Soltuions button on the Solutions tab in HPD:Help Desk 6.0? I click on this button and get a search dialog window that searches HPD:Solutions. The problem is it is not find any matches, despite the fact that there are records in HPD:Solutions. Has anyone

Re: Another view form question...

2008-08-21 Thread Brien Dieterle
I use the SQL 2005 row_number function to do something that sounds like what you want, in a SQL view, and then expose that as a View Form in remedy: SELECT cast(row_number() OVER (ORDER BY somecolumn) AS int) AS Record, column2, column3. One note, don't do this. Since the row_number

RESOLVED Re: Custom arealdap.so

2008-08-21 Thread Frank Caruso
Success!!! Placed the arealdapX.so in the bin directory, added a few .so files from the old server and restarted Remedy. Everything worked. Thank you. On Wed, Aug 20, 2008 at 3:29 PM, Axton [EMAIL PROTECTED] wrote: It might work then. The only commonality between the two will be the

JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas, Oklahoma City, Minneapolis and Chicago

2008-08-21 Thread Melissa Wish
We are seeking Mid and Senior level Remedy Consultants based in Dallas, Oklahoma City, Minneapolis and Chicago. *These are permanent positions with generous salary, bonus, benefits and vacation packages. If you're interested please email me your resume as a PDF or MS Word document and

Remedy Link for SQL server question...

2008-08-21 Thread Payne, George
ARS 7.0.01 P08 on AIX 5.3 Database Oracle 10g on separate AIX 5.3 server Remedy Link for SQL 7.01 Patch 05 It seems as if the Remedy Link for SQL uses a different port each time the service is started on the Windows server. This puts the port number in the EIE:BackUpLoadFlag form in

Task templates used with incident mgmt.

2008-08-21 Thread sivarama velicheti
Hi Group, I have a question. How can I add a task template for an Incident. I don't see any place in the incident templates to add in the task templates that I have defined (one thing which I am able to do with change template). Can I do something similar with incident? I went to custom

Re: ITSM Application Patch 8 Install Error

2008-08-21 Thread Begosh, Kevin
Rick, I think that the issue is our sys:action form is not deleting it's records. When patch 8 runs it tries and install the patch and look through 800,000 records to delete 10 and the processor cannot take it. For some reason the records on sys:action are not being deleted when they should. Has

Running Multiple Instances

2008-08-21 Thread Matt Ferrigno
List, I appologize if this has been asked before, but is it possible to run an instance of AR 7.1 and an instance of AR 5.01.02 on the same machine. I know it is possible to run multiple versions of 7.x on the same machine, but I'm unaware of the capabilities of AR 5.x Thanks Matthew Ferrigno

Re: Running Multiple Instances

2008-08-21 Thread Grooms, Frederick W
Are you asking about Server or User Tool? What platform (O/S)? I believe both can be installed at the same time (in different directories). For the server as long as they run on separate ports (and use different alias names) they should be able to. From:

Re: Running Multiple Instances

2008-08-21 Thread Matt Ferrigno
Ah, sorry, I should have included that Installing AR Server on Windows 2003 server (5.x uses oracle 9i and 7.x will use oracle 10g, both installed locally) On Thu, Aug 21, 2008 at 4:46 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Are you asking about Server or User Tool? What

Re: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning Invalid AR Export format file error

2008-08-21 Thread LJ Longwing
Jay, I would say that the export is converting 'hidden' characters into ?'s when creating the arx. The most common time when I see this type of behavior is when someone copies something out of Email, or Word and pasts it into a char field or maybe even a diary...MS is horrible about putting

Re: Two Tomcat on same server

2008-08-21 Thread LJ Longwing
As I said...I took a shotgun approach...meaning I took all JAR files out of the individual folder and put it in the common classloader...I then moved the MidTier.jar back into and that got Mid-Tier workingbut I couldn't config itI moved the Config.jar file back into the individual folders,

Re: ITSM Application Patch 8 Install Error

2008-08-21 Thread Rick Cook
I suspected as much. I would clear out that form (or at least the stuff that's supposed to be gone) before proceeding with the install. Rick On Thu, Aug 21, 2008 at 1:31 PM, Begosh, Kevin [EMAIL PROTECTED]wrote: ** Rick, I think that the issue is our sys:action form is not deleting it's

Re: Two Tomcat on same server

2008-08-21 Thread Joe DeSouza
LJ, Did you create a directory named arsystem because that is your context path for the Mid-Tier or the name of the Mid-Tier install directory? Or is it a name you chose at random and it doesn't matter what you name it? Joe - Original Message From: LJ Longwing [EMAIL PROTECTED] To:

Re: Task templates used with incident mgmt.

2008-08-21 Thread PCR Remedy
It is a optional Add-on, the patch number is 9002, you must download it from Patch Downloads area under Incident Management product. PCr On Thu, Aug 21, 2008 at 3:27 PM, sivarama velicheti [EMAIL PROTECTED]wrote: ** Hi Group, I have a question. How can I add a task template for an

Re: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning Invalid AR Export format file error

2008-08-21 Thread Joe DeSouza
These '?' characters also could be a result of accented characters when you export them from a database containing such characters.. I'm not sure where I came across this but I think it was the data contained in one of the CFG cities or country forms where one of the countries have an accented

Re: Task templates used with incident mgmt.

2008-08-21 Thread sivarama velicheti
Hi, I am using AR Server 7.1. Are you talking about the same version?? Thanks Sivarama On Thu, Aug 21, 2008 at 2:30 PM, PCR Remedy [EMAIL PROTECTED] wrote: ** It is a optional Add-on, the patch number is 9002, you must download it from Patch Downloads area under Incident

Response time for Midtier

2008-08-21 Thread sivarama velicheti
Hi, I have the AR Server 7.1.00 Set up on windows 2003 environment running on the SQL Server Database. I have installed Midtier in another machine. I am noticing that the response time for the midtier is not as expected. Can any one help me figure out how to enhance the performance of

Re: Exported data from AP Trouble Ticket form cannot be imported back to the same form (using Import Tool) - returning Invalid AR Export format file error (RESOLVED)

2008-08-21 Thread SYTANGCO,JENARO
Joe/LJ, Found out, some of the field labels have carriage return at the end which cause the invalid format error. Thanks for your inputs. Regards, Jay Sytangco CAI Outsourcing IT Equipment and Process Team Phone: 63.2.5819240 Email: [EMAIL PROTECTED]

Re: Response time for Midtier

2008-08-21 Thread Frank Caruso
You need to be specific about what the performance issue is? Also, your ARS server and MidTier versions. I will assume you are running Midtier 7.1. The one thing I remember about MT 7.1 was there was a performance issue moving from record to record in a query list in IE and Firefox. We actually