Re: How to see the SQL code generated by Remedy

2006-07-24 Thread Shafqat Ayaz
** Hi Robwhat you have turned on seems to be the Active Link and Macro Logging in the User Tool!do it through the Admin Tool under File Server Information Logs, turn on the SQL logging and the input will be different.any problems dorp me a line and I will try and walk you through

Threads Crashing

2006-07-24 Thread Webster, Basil
** Hi All, We have a major issue which has slowly been creeping up on us. It was something that happened every now and then and has now become a frequent visitor. Today seems to be the day that the wheels have come off. We use the preference server on log in and we are getting

Re: Threads Crashing

2006-07-24 Thread Houldcroft, Darren
** Hi Basil, We have had the same problem with individual server threads dying on a 5.1.2 server - this can lead to slightly random behaviour, depending on what thread your request uses. For example, we had table fields that would return results the first time they were refreshed, but not

Re: Crystal parameters reports

2006-07-24 Thread Frank Caruso
** Create the parameter in Crystal. Go to the Section Expert for the Detail section and create a formula to use for Suppressing a row. Use the parameter in the formula. Save the report and link into your ALink (or add to Report form). Run the report from the user tool and you should see a Crystal

Re: ITSM 7 upgrade

2006-07-24 Thread Kelly Deaver
** Hi Dan, Why without EIE on the Zenworks integration? EIE, Remedy Link for SQL and Remedy Link for Oracle have a great new feature in version 7. It is "CMDB Aware", BMC's term to mean that you can actually choose to import to CMDB CIs and it will handle all the heavy lifting. Also, you can

Test Email(Ignore)

2006-07-24 Thread Harmil Dalal
** Test __20060125___This posting was submitted with HTML in it___

Re: Upgrading Remedy - 4.5 to 6

2006-07-24 Thread Shawn Stonequist
Thanks everyone who responded!!! All this information will be most helpful!!! If anyone else has any/more advice/tips/info- it would be most welcome. We've been on 4.5 for almost 6 years and this is my first upgrade (our SA is receiving help from our Remedy Support too). Our start/end config is

Version 7.0 Sample Data

2006-07-24 Thread Kip Kippley
Version 7.0 Sample Data is available from BMC Professional Services. Expert Help, Timely Advice, World Class Experience and Best Practices. Kip Kippley ConAgra Foods, Inc. BSM Implementation Team ___ UNSUBSCRIBE or

ITSM 7.0 Overview Console - Plug-in Error

2006-07-24 Thread Mike Gould
** Good Morning List, I've just finished a full installation of ITSM 7.0 and was checking out the new features when I tried to open the Foundation Elements Overivew Console and received the following error: ARERR [8939] The AR System Plug-In server is not responding. Cannot connect to the system

Re: COM ActiveLink example

2006-07-24 Thread Heider, Stephen
Angus, Regarding How would I do this as a Remedy Active Link? In a active link you could run the .exe in a Run Process. Example: cmd.exe /c c:\program files\MyDialer\MyDialer.exe 9,19254694200 This number is Remedy's support line, but first dials a 9 to get an outside line. The comma = 2 second

Re: Version 7.0 Sample Data

2006-07-24 Thread Rick Cook
I'm with you, Matt. From a process standpoint, this is one of many shortcomings of this release. I know the Sr. Product managers of this release, and they're smart people experienced with Remedy releases, so I don't know why this release wasn't as well done as previous ones. I smell a

Re: Fallback Mapping - Does it work in 6.3

2006-07-24 Thread Lucero, Michelle - IST contractor
Hi, Michiel: No go. I uninstalled Admin Tool 6.3, patch 12 and installed Admin Tool 6.3, patch 17. I exported data in .csv format and purposely removed the date/time value from the Create Date column from 2 out of 5 records. I defined fallback mapping to set Create Date field with $ TIMESTAMP$.

Re: COM ActiveLink example

2006-07-24 Thread Angus Comber
I have decided to re-work the interface. I have implemented the program as an exe com server. I have made it as simple as possible so for example to dial the active link just needs to call a function Dial and pass a number as parameter. The Remedy OLE automation is fairly basic so needed to

Remedy career opportunity

2006-07-24 Thread Raymond Viens
** The department of Restructuring and Government Efficiency, Alberta Provincial Government, Canada has a requirement for a Remedy Analyst to join our team. Responsibilities include design, quality, change control and development. In-depth understanding of Remedy ARS 5.x or higher is

Remedy career opportunity

2006-07-24 Thread Raymond Viens
** The department of Restructuring and Government Efficiency, Alberta Provincial Government, Canada has a requirement for a Remedy Analyst to join our team. Responsibilities include design, quality, change control and development. In-depth understanding of Remedy ARS 5.x or higher is

Full Time Remedy Administrator Position - Boston Area

2006-07-24 Thread Ron Tavares
** Staples, Inc. is seeking a permanent, full time Remedy Administrator. Position is in Framingham, MA. If you are interested please e-mail [EMAIL PROTECTED] . Thanks,.ron __20060125___This posting was submitted with HTML in it___

Re: Fallback Mapping - Does it work in 6.3

2006-07-24 Thread Lucero, Michelle - IST contractor
Yep, that's in my original report to Tech support and in my original email way below (albeit kind of long) I'm receiving, Record 1 : Required field cannot be reset to a NULL value -- Create Date (ARERR 326), Although I have Try Fallback Mapping before alerting user selected, and although I have a

[no subject]

2006-07-24 Thread Hall, James (West Chester)
** Good afternoon list, I have a quick question. We are moving to a new datacenter and our UNIX administrators have decided to migrate all of the applications including our ARSystem server to a brand new server. The new server is going to have the same host name, IP address, etc. as the

[no subject]

2006-07-24 Thread Carey Matthew Black
James, Yep. That has always been my experience on Solaris. (You did not mention which Unix, but I doubt it really matters.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never

Re: Oracle Analyze

2006-07-24 Thread Sanford, Claire
** This is the thing the DBA did. exec dbms_stats.gather_schema_stats('ARADMIN') Right now we are dead in the water. Remedy Tech Support is working on it too... The AR System was up and running at the time and that command has never been run on this database. If I stop and start the ARS

Re: Version 7.0 Sample Data

2006-07-24 Thread McCabe, Richard A. (CMS/CTR)
** Straight from Remedy's KB that they sent me this morning. (Sorry they did not give a kb number with it.) The DSL is supposed to have approx. 10,000 canned entries. What is the Definitive Software Library? A N S W E R A: The Definitive Software Library (DSL) is a central repository of

Re: Oracle Analyze

2006-07-24 Thread Adam D Pederson
** Hey Claire: Ive been there, (with other non-ARS applications) and it isnt any fun. Have you been able to capture the SQL that the users are getting timeouts with? Since this is slow death by way of DBA, I would suggest that getting him to run an explain plan on the SQL that is

Re: Version 7.0 Sample Data

2006-07-24 Thread McCabe, Richard A. (CMS/CTR)
** Here is another one they sent me for the DSL data. For the DSL data please be sure you have gone through the steps outlined in Chapter 20 of the ITSM 7.0 Configuration Guide. This requires a few additional steps to import the DSL data but it is outlined in Chapter 20. Richard

Application upgrade 5.5 to 5.6

2006-07-24 Thread Barber, Sue
** Hi, Has anyone run into an issue while attempting an application upgrade from version 5.5 to 5.6. We downloaded the archid utility and set the environment, but we continue to get at error: "The upgrade installer needs to modify field IDs in several application forms. However, a

Re: Oracle Analyze

2006-07-24 Thread Benter, David W CTR NSWC PC
** Sounds like this command is still running, or is that what you want it to do. If not, could it be in a loop? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, ClaireSent: Monday, July 24, 2006 13:37To: arslist@ARSLIST.ORGSubject: Re:

Re: Application upgrade 5.5 to 5.6

2006-07-24 Thread Joe DeSouza
** Sue, This is probably because of ainitial dev build bug wherein Remedy used some of the ID's in the user range.. So what you must be experiencing is that those fields created in the legal range have the same ID's as some of the fields that have to be created during the process of your

How to perform a single search of multiple items and return all the matching records???

2006-07-24 Thread Sokol, Brian
I have been asked to replace a Filemaker Pro database with a Remedy application. We are a book publisher and this application is used to request digital assets by their ISBN number. Each asset has their own unique ISBN number. In Filemaker they can cut and paste a long list of ISBN numbers and

Re: Oracle Analyze

2006-07-24 Thread Axton
What may be happening is that the execution plan used ny Oracle to fulfill your sql queries is different due to the stats gathered on you tables. This should help the performance of your apps, but if the indexes/queries are poorly designed, the results of this may be unpredictable. i.e.,

Re: How to perform a single search of multiple items and return all the matching records???

2006-07-24 Thread Rick Cook
I tend to think that in Remedy, anything is possible, just some things are more difficult than others. Would your users be ok with entering the ISBNs individually (i.e. in a dialog), clicking a button to send it to another form, and displaying the currently entered ISBNs in a table field? Then

Re: Fallback Mapping - Does it work in 6.3 - FIXED in extra patch

2006-07-24 Thread Lucero, Michelle - IST contractor
Hi, Folks: I have great news. This issue is fixed with a no-name patch. It was suppose to be included in patch 17, but didn't make it. The issue is not officially fixed until it is included in a new patch. Tech support will be escalating this and hope that it will make it in 6.3, patch 18.

Re: How to perform a single search of multiple items and return all the matching records???

2006-07-24 Thread Carey Matthew Black
Brian, Well... I see an option here How about you walk the string? If you can tell your users that every ISBN number must be on their own line (hard return separated) then you could use a guide to loop over a character field and fix up all the sub strings and at the same time produce a nice

Fields missing using ODBC Driver

2006-07-24 Thread Michiel Beijen
We run AR Server 5.1.2 -- HP-UX -- Oracle 8.1.7 Users who look at data using the ODBC driver cannot see some columns in our biggest two forms. These fields are ordinary character fields to which they have access. Because the forms contain lots and lots of rows I would not like to delete the form

Re: Fields missing using ODBC Driver

2006-07-24 Thread Frank Caruso
** I remember something how the ODBC driver does not show a field unless it has at a minimum Public access.On 7/24/06, Michiel Beijen [EMAIL PROTECTED] wrote:We run AR Server 5.1.2 -- HP-UX -- Oracle 8.1.7 Users who look at data using the ODBC driver cannot see some columnsin our biggest two

Re: Fields missing using ODBC Driver

2006-07-24 Thread Joe DeSouza
** Another stab - maybe you have some special characters in that field name or database name that prevents it from showing up?Try playing around with your 'Use underscores' settings and see if it makes a difference... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.

Re: How to perform a single search of multiple items and return all the matching records???

2006-07-24 Thread Rick Cook
Yeah, EXTERNAL would work, too. Regardless of the solution used, the most difficult part is going to be delimiting and validating the data string. The users are going to have to do some of that themselves, as you can't practically screen every potential problem type out with workflow. Rick

Re: How to perform a single search of multiple items and return all the matching records???

2006-07-24 Thread Sokol, Brian
Cary/Rick, The way it works now is a user sends a request for x# of ISBN records listed in a spreadsheet. Staff here copy and paste the ISBN column from the spreadsheet into a single field. They then search for all the hits from the single field against our database. The spreadsheet could have