Re: Archive old data

Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underl

UNSUBSCRIBE

Hi, Can you unsubscribe me from this list. -Syed Abdul Basith ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

St-Pierre Patrick I625ST/Levis/GVDL est absent(e).

Je serai absent(e) à partir du 2008-05-30 de retour le 2008-06-09. ___ Le présent message est destiné uniquement aux personnes indiquées dans l'en-tête. Il contient des informations confidentielles qui ne peuvent être divulguées à des tiers sans que l'expéditeur ait préala

Archive old data

Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul __

Re: Question: Active Link - Checking Table - ITSM 7

I think a simple solution is to check any column in the table for a value. If col1 = $NULL$ or col1 != $NULL$ James On May 30, 2:00 pm, "T. Dee" <[EMAIL PROTECTED]> wrote: > THANKS!!! > > On 5/30/08, Gary Opela (Corporate) <[EMAIL PROTECTED]> wrote: > > > > > > > Tyrone, I just teste

Re: Error with libcaieventcmd

Why have you disabled this file? This needs to be enabled all the time. Have you the patch recently? If so, I believe that you need to manully replace this file with the new file that is provided in the patch. Wirasat On 5/30/08, Nazish Bano <[EMAIL PROTECTED]> wrote: > > ** Hello all, > > Has a

Re: Very Easy TR. Format Question.....

Lou, In addition to the points about TR values in filters, you can compare the status field with the (hidden) Change Request Prev Status field in an active link in Change 7 or with the similar PreviousStatus field in Incident 7. These fields hold the DB status value and are set by workflow w

Re: SOLVED: Tables not refreshing "On Open"

That explains why "Display" wouldn't work, as it would on a regular form. You're right - Window Loaded is your only option. Rick On Fri, May 30, 2008 at 11:32 AM, Morrison, David A. <[EMAIL PROTECTED]> wrote: > ** > > Yes, it is a display only form. Thanks. > > > > David M > > > > *From:* Actio

Help: Remedy Java API 7.0

Hi everyone, I'm trying to use the Java API arapi70.jar... I'm implementing a code that read records of a file and enter this records in a form/table. I would like to know if there is a way to subtitute this code: EntryItem[] entryItems = new EntryItem[15]; entryItems[0] = new EntryItem

Re: Application-Delete-Query-Entry gives errors

Rick, On this new form you created, add a field called Escalation Name, and have a Status values of Active and Inactive. This way, on your escalation, you can run it against this form where 'Escalation Name' = "Name of the current escalation" AND 'Status' = "Active" This allows you to use the

Re: Application-Delete-Query-Entry gives errors

RESOLVED. Thanks to all who contributed to my now-enhanced knowledge level. OK, here is what I've done to resolve this. I created a small form with just the core fields, and created one record in that form. I then restructured my escalation to go against that one-record form, running the Applic

Re: SOLVED: Tables not refreshing "On Open"

Ah, okay. Then you gotta go with Window Loaded. Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Morrison, David A." <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 05/30/2008 11:32 AM Please respond to

Initial Load of Records - ARCHIVE

Hi people, Firstly, I'd like to say that we are facing many performance troubles because of that... I'd like to know if there is a better way to implement ARCHIVE feature in an Application/Form that contains a high number of records - more than 2 million. We are searching for alternatives t

Re: Tables not refreshing "On Open"

It is set for "Select First, Fire Workflow". Thanks. David M -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rocky Rockwell Sent: Friday, May 30, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Op

Re: SOLVED: Tables not refreshing "On Open"

Yes, it is a display only form. Thanks. David M From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, May 30, 2008 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: SOLVED: Tables not refreshing "On Open" ** Display should do

Re: Tables not refreshing "On Open"

Check the Advanced Display tab for the table. For the Refresh Table Options, check if it is set to "Select First, No Workflow" *Rocky* Rocky Rockwell Remedy/BMC Application Designer [EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-450-5076 Morrison, David A. wrote:

Re: Question: Active Link - Checking Table - ITSM 7

THANKS!!! On 5/30/08, Gary Opela (Corporate) <[EMAIL PROTECTED]> wrote: > Tyrone, I just tested this out. > > The value of a Table Field that has one or more rows is 1 or more, depending > on which row you have selected. If there are rows, but you have none > selected, then the value

Re: Application-Delete-Query-Entry gives errors

Hi, Does your escalation run on SHR:TmpMessages? I would run it on some "scheduler" form, and it should trigger once (one record). The normal way to find out what the problem is would be to turn on logging. What happens when you try to delete one record from the user tool? Best Regards

Re: SOLVED: Tables not refreshing "On Open"

Display should do it, unless you are working with a Display-Only form? Is there any workflow that fires after your refresh that could be clearing the table? Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Morrison, David A." <[EMAIL P

Re: SOLVED: Tables not refreshing "On Open"

Thanks for the reply. I tried different combinations and options, and the only one that seems to work is when one of the options is "Window Loaded". That is the only one that refreshes the table when the form opens. David M. ETSU From: Action Request System discussion list(ARSList) [mail

Re: Tables not refreshing "On Open"

Thanks for the advise! David M. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, May 30, 2008 12:38 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" ** If the AL is only running on Display, won'

Re: SOLVED: Tables not refreshing "On Open"

I would also use Display vs. Window Loaded. Display only fires when an existing record loads. Window Loaded fires after the default values are loaded on a form (which could realistically be the best choice only in Search or New mode), but before the data is loaded. Using Display also removes the

Re: SOLVED: Tables not refreshing "On Open"

Make sure you take off the "Window Open" condition, otherwise your table will refresh twice every time the form opens (you can see it in the logs) Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Morrison, David A." <[EMAIL PROTECTED]>

Re: Tables not refreshing "On Open"

If the AL is only running on Display, won't the $OPERATION$ value always be "SET"? By the way, if your table is on a tab, I'd recommend turning OFF the "Refresh On Entry Change" setting. A lot of the performance issues with forms displaying stem from tables that no one is looking at being ref

SOLVED: Tables not refreshing "On Open"

It says "click to refresh.I added the condition "Window Loaded" and it is now refreshing when the form opens. Thanks to all who helped! Have a great day!! David Morrison East Tennessee State Univ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

Re: Tables not refreshing "On Open"

I put in another qualification. Thanks for the reply. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Friday, May 30, 2008 12:16 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refre

Re: Tables not refreshing "On Open"

No, fields from another form. Thanks for the reply. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Friday, May 30, 2008 12:18 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" ** Is your table

Re: Tables not refreshing "On Open"

Why don't you try "Display"? That happens a bit farther down the chain than Window Open, which fires before the data is loaded on the form, and will also fire on a Search window. Display will only fire on a Modify window after the record is fully loaded. Rick On Fri, May 30, 2008 at 9:13 AM, Mo

Re: Tables not refreshing "On Open"

David, I suggest that you change the execute on condition to "Display" and you might want to add $OPERATION$= "SET" (to only refresh the tables when your looking at a data row) to the Run If. (If it is not already there.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Requ

Re: Tables not refreshing "On Open"

Chad, I agree with you, that's where I was headed with my questions. I guess I should have just spit out my point in the beginning. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM

Running Sync Search DB from command line

I am trying to sync the search DB from the command line (looking to eventually schedule this during off-hours). Using the following command aradmin -u Demo -x -s Nothing happens I have also tried add -p and -portnum <> but nothing. Using aradmin 6.3 patch 24 from a Windows system to

Re: Tables not refreshing "On Open"

When you say the table doesn't refresh, does it still display "Click to refresh" within the table field? Or is it just an empty table? If it doesn't have that wording and its just empty, then it refreshed but didn't find any matches. In which case you should check your qualification. Since you say

Re: Tables not refreshing "On Open"

Is your table field using a field on the current form in the qualification? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

Re: Tables not refreshing "On Open"

You took the external operator out and...replaced it with a test qualification? If you had an external() operator as the table's qualification and then removed it, if you didn't plug in another qualification to replace it, you have no qualification on the table. If you DID have an external() oper

Re: Tables not refreshing "On Open"

Only condition is Window Open. Thanks for replying. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, May 30, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" ** David, what are the firing c

Re: Tables not refreshing "On Open"

No external operator. I did have and took it out to try. The AL is running on Window Open. Thanks for the reply. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Friday, May 30, 2008 12:04 PM To:

Re: Tables not refreshing "On Open"

Thanks for the reply. I had not checked this, but did and it still does not work. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Friday, May 30, 2008 12:05 PM To: arslist@ARSLIST.ORG Subject: Re: Tab

Re: Tables not refreshing "On Open"

Make sure your table field has the Refresh On Entry Change option selected. That will cause it to refresh as soon as you display the entry, and you won't need an active link to force the refresh. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(AR

Re: Very Easy TR. Format Question.....

Thank you Matt, Rick and Elia filter will work fine for this. Have a great weekend all, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Friday, May 30, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject

Re: Tables not refreshing "On Open"

David, what are the firing conditions on this Active Link? Rick On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL PROTECTED]> wrote: > Good day everybody, > > Strange problem that is driving me nuts. I have an Active Link that has > as one of its actions a Change Field on a table with

Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the table field? Is your Active Link refreshing the table running on Window Open, Window Loaded, or Display? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lc

Tables not refreshing "On Open"

Good day everybody, Strange problem that is driving me nuts. I have an Active Link that has as one of its actions a Change Field on a table with the option being "Refresh Table". The worklog says the qualification passes and lists the action, but the table does not refresh when the form opens.

Re: Very Easy TR. Format Question.....

Louis, TR and DB values do not work in Active Links, only server side processing. Sorry! To achieve the same affect, you would need to store the 'orig' value in a temp field and compare it to the value at the time of processing. Good luck! Matt R. -Original Message- From: Action Reque

Re: Very Easy TR. Format Question.....

Lou, TR/DB values can only be used on Filters. If you want to track the transition between status values, either do it via a Filter or have a field that stores the "old status" value, and compare that to Status. Rick On Fri, May 30, 2008 at 8:46 AM, Louis Cobuccio <[EMAIL PROTECTED]> wrote: > H

Re: Very Easy TR. Format Question.....

Hi Lou, Active Links do not support TR and DB status values. Since they run client side you only have transaction value. If you only want to fire the AL when the status changes I would suggest you use the Previous Status Value field or the status history to obtain the desired outcome. Cheers!

Very Easy TR. Format Question.....

Happy Friday List! I've got what should be a very, very simple question for the list. I'm trying to get an active Link to fire when the Status field is being moved from its current value to Closed. I've tried adding the statement below in the Run If on the Basic tab but keep getting an error

Error Updating Problem Ticket

I am creating custom workflow by using email update to Problem ticket. During the OOB workflow is checking the user belong to Group "Problem Master". The email user "Remedy Application Service" does not belong to this group and it is throwing error " You do not currently have permission to modify

Re: Midtier Timezone

Frank, I think (I might be wrong though) that Mid-Tier gets its TZ info from Java. You might check out on Sun's website on how to see what time zone java thinks it is dealing with, and how to update it if it is wrong. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http

Midtier Timezone

Have two Midtier 7.0.1p7 servers. Both are Tomcat and Apache on Linux RHEL 64. Both were installed the same way and both show date time in EDT. However, one server is displaying times on tickets one hour different from the other and if I look in the Midtier config tool on the Cache settings page, o

Error with libcaieventcmd

Hello all, Has anyone seen any error with libcaieventcmd.so library, everytime this is enabled in the ar.config the plugin server does not start. The system is ARS 7.1 and ITSM 7 patch 4 TIA, Nazish - Meet people who discuss and share y

Re: Question: Active Link - Checking Table - ITSM 7

Tyrone, I just tested this out. The value of a Table Field that has one or more rows is 1 or more, depending on which row you have selected. If there are rows, but you have none selected, then the value is still 0. You can ctrl-click on a selected row to make it un-selected, so a user could pot

Re: Question: Active Link - Checking Table - ITSM 7

THANKS I'll give these suggestions a try. Ty On 5/30/08, Steven Iocco <[EMAIL PROTECTED]> wrote: > ** > What Ben mentioned is a good option. You could also run a guide looping on > the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as > mentioned below, build your workflow

Re: Stoopid Parenthesis

Lisa, In this case both statements are the same. Because you are using the AND operator each section must be true for the qualification to be true. If you were using the OR operator then the parenthesis in your first statement would remain instead of being deleted. HTH, Roger A. Nall M

Re: Stoopid Parenthesis

You are correct. I don't need the extra parens. Duh I thought I did Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Friday, May 30, 2008 9:43 AM To: arslist@ARSLIST.ORG

Re: Stoopid Parenthesis

** 'sokay, Lisa, those two statements are logically equivalent. ~james > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Friday, May 30, 2008 8:36 AM > To: arslist@ARSLIST.ORG > Subject: Stoopid Parent

Re: Stoopid Parenthesis

Why do you need the extra parenthesis? Remedy is removing them because they are not necessary, since you are using all AND statements. If it is just for readability, then I'm not sure how you would keep them. However, if you are setting a field to that, and trying to use EXTERNAL($FIELD$), then

Stoopid Parenthesis

I forget how to force extra Parenthesis when I need them in the Qualification area on a table field... I would like it to look like this: ( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From Date$) AND ( 'Create Date' < $Result To Date$)) But when I save the form, Remedy changes

Re: Question: Active Link - Checking Table - ITSM 7

What Ben mentioned is a good option. You could also run a guide looping on the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as mentioned below, build your workflow on that result. Steve Date: Fri, 30 May 2008 09:13:32 -0400From: [EMAIL PROTECTED]: Re: Question: Active Lin

Re: Question: Active Link - Checking Table - ITSM 7

T. Dee, Is the 'z2TH Associations' field a required field? ( Or could it happen to be NULL for the currently selected row in the table?) In a Run If a column name value will only evaluate the currently selected record in the table field and not the array of values that are in all rows in the table

Re: Question: Active Link - Checking Table - ITSM 7

Off the top of my head, I think that you do a direct sql that would return the same results that the table would and then do a set field command using the value of lastcount. I think that would give you a number and you can build workflow to check if the value is greater than 0. Ben Cantatore Re

Question: Active Link - Checking Table - ITSM 7

I'm trying to check to see if a table has any rows in it, but i'm not having much luck. I have tried to check for the table NOT being NULL and I have check for a column NOT being NULL, both do not work. I'm looking to see if the Relationship table is NOT NULL - so I tried: 'z2TH Associations' !=