View Form - Remote DB not available.
Listers, I have a view form(on ARS 6.3 - Oracle) that is looking at a remote database table. If the remote database is not available, I get a nasty Oracle error when trying to access the view form through workflow. Is there anyway to check if the remote DB is available before I run my workflow ?? Thanks, __ John Kovalcik Sr. Service Management Analyst [EMAIL PROTECTED] Kennametal Inc. | 1600 Technology Way | Latrobe, PA 15650 | www.kennametal.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Deleting Fields Above Reserved Range
Listers, I am cleaning up our modified Remedy Helpdesk application and want to delete fields that were defined from the original application. These would be any above the 23000 ID range. Providing there isn't any related workflow, are there any concerns I should be aware of ? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Incoming Emails
Listers, Does anyone know how to re-parse and incoming email ? If the incoming email has an error and you want to re-parse it after the error is corrected, how do you do it ? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re-parse Incoming Emails
Listers, Does anyone know how to re-parse incoming emails. I am importing in email message records from another system. By just setting the 'Parse Message' field to Yes doesn't seem to do it. Any help would be appreciated. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Large Character Fields
Listers, I have quite a few character fields that are 255 characters in length. The majority of them came with the Helpdesk application and are in the 25xxx field ID range. Would there be any performance benefit in reducing these to only the necessary size. For example, a zTmp field at 254 that holds only a login ID. Any insight would be appreciated. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. 1600 Technology Way Phone: 724-539-5228 Fax: 724-539-5797 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Email Template
Listers, When sending out an email notification, I would like to not display a certain field in the template depending on it's value. Does anyone know how to do this in the template without making a change to workflow ? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
User Tool 7.0.01 and Modify All
Listers, I have run in to a problem doing a Modify all on the 7.0.01 user tool. When doing a modify all on CHG:Task, if the first record has a blank assignee, then it will NULL out all assignee's in the following records. Has anyone seen this issue ? It doesn't do it in the 6.x usertool. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Developer Plus
Listers, Is there anyway to improve performance on Developer plus - especially when using it from across the WAN ? It takes forever to load a form. Any help would be greatly appreciated. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Task opening in Dialog Window
Listers, Is there any good reason why Opening a task record from a ticket results in a dialog window instead of a modify within the Helpdesk application ?? I would like to do away with the dialog and make it a modify window. Any thoughts ??? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Remedy performance Overseas
All, We are having an issue with performance across the pond to our India location. Currently, we have one HPUX server here in the States with a dedicated network line overseas. Now, granted the line is not as big as it should be and I know that Remedy is resource intensive, but is there anything that we can do to help performance ?? Any info would be greatly appreciated. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. 1600 Technology Way Phone: 724-539-5228 Fax: 724-539-5797 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Login.jsp
Listers, Does anyone know how to only pull in the users network ID to populate Login.jsp in the midtier? I don't care about password. Our midtier is on HPUX and we do have a Active Directory. Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
External MS SQL Data/SMS
Listers, What is the easiest way to access SMS data that resides in an external MS SQL database ? All I want to do is read the data. Our current environment is ARS 6.3 and Oracle 10g. Thanks, John M. Kovalcik Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ODBC use underscores / Crystal Reports Server
Listers, Does anyone know if it is necessary to use ODBC use underscores on the ODBC connection for Remedy when reporting with Crystal Reports Server. I know for using Crystal through the User Tool it is necessary but is it if you are using Crystal Reports server or Business Objects Enterprise ??? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Key field in view form
Listers, Is it possible to have more than one key field designated in a view form. I am trying to get data from an SAP table but I was given 5 keyfields none of which are unique but in combination they are. I can only specify 1 field on the create of the view form. Any Ideas ?? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Indexes - ARS and Oracle do not match
All, We have just had our DBA's check the number of indexes on a couple of tables and they don't seem to match what we have defined in ARS. For example, Oracle might show two indexes when we have 7 defined in ARS. Is there a way to re-build these in Oracle without having to delete and then re-define them in ARS ? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Push Action Rollback
They are not join forms Just two Regular forms. And it's rolling back on warnings - I would understand if they were errors. Thanks, John M. Kovalcik Global Information Technology Kennametal Inc. Carey Matthew Black [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/20/2007 08:22 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Push Action Rollback John, By any chance this is workflow actually firing on an Outer Join form? Is the workflow actually breaking the Join conditions between Form A and Form B as part of it's processing? The reason I ask is that I reciently found what I would call an odd behaviour in ARS with Outer Join forms. Apparently at the end of a SetEntry (Modify) event the ARS server fetches the Joins 'Entry ID' value back from the DB. ( I presume this is sanity check to verify that the pending GetEntry call from the client will work.) If the ARS server sees that the 'Entry ID' of the Join is no longer valid it then issues a roleback to the transaction that broke the 'EntryID' in question. -- 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 2/19/07, John Kovalcik [EMAIL PROTECTED] wrote: ** All, I have an escalation that updates a record on Table A. When that record is updated a filter then pushes data to a Table B. If the matching record on Table B has a warning fired from a filter, then the change rolls itself back out of Table A and Table B. Is there anyway around this ??? Thanks, John M. Kovalcik Kennametal Inc. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Push Action Rollback
All, I have an escalation that updates a record on Table A. When that record is updated a filter then pushes data to a Table B. If the matching record on Table B has a warning fired from a filter, then the change rolls itself back out of Table A and Table B. Is there anyway around this ??? Thanks, John M. Kovalcik Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
User Tool and DST
All, I have not been able to find out a definitive answer whether the user tool needs patched or not. Currently our user tool is 6.00.01 (patch 1364) . Our server is 6.0.3 and we will be adding patch 20(when it is good ! ) but I'm wondering if we shouldn't just upgrade the user tool to 7.0.01 (patch 001). Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Global Information Technology Kennametal Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Extra Message Info
** Listers, Does anyone know how to eliminate the extra information in a message like The preceding message occurred during the execution of active link KMT:TSK-CheckTransportNum02 -- action 2. (ARNOTE 1101) ??? Thanks, John M. Kovalcik Service Management Sr. Analyst ITIL Foundations Certified Kennametal Inc. __20060125___This posting was submitted with HTML in it___
SSO and Active Directory
** All, To configure Mid-Tier as a Single SignOn application, do you have to have an established SSO environment ? Or can we just use our current Active Directory environment ? Thanks, John M. Kovalcik Kennametal Inc. __20060125___This posting was submitted with HTML in it___