Re: Adding days to a Date field in a qualification doesn't work

I usually have to put the Date fields inside quotes when doing calculations 'my_date_field' ($DATE$ + 182) I've tried that. It doesn't work.I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As

Re: Adding days to a Date field in a qualification doesn't work

Hi Doug, 'my_date_field' ($DATE$ + 15724800) I've tried that. It doesn't work.I've entered 28.10.2020 into my date field, i.e. I'm saying in my AL RunIf qualification: 28.10.2020 ($DATE$ + 1), but the AL goes into else action. As this example shows it doesn't really matter it ARS sees date as

Re: Adding days to a Date field in a qualification doesn't work

Hi Gary, Yeah, I think that doug is on to something here. The $DATE$ keyword is referring to seconds, I believe, and thus you need to add six months worth of seconds. Note, that $DATE$ calculates to midnight that day, so if you need to calculate six months from now, then you will likely need

Re: Adding days to a Date field in a qualification doesn't work

An easy way to do this is to use the multipliers. You will also need to use $TIMESTAMP$ 'my_date_field' ($TIMESTAMP$ + (60*60*24*182)) $TIMESTAMP$ returns the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970. Guess what platform Remedy ARS was

Re: Problems calling java api from filter.

Hi people I reply back with the final result. I indicated the correct instruction in a filter, in a Run Process Action: java -Dentorno=D remedyServer.Access new $field1$ password $field2$ $field3$ $field4$ $Description$ $field5$ $field6$ $field7$ J $field8$ $Field9$ $Field10$ It did not

Re: Data - For Server Events

John, Here is how I have learned to read these things... In ar.h the /* Server Event Types */ section defines the 'Event Type' values for the events. However for each value there are other blocks that define the 'Event Cause'. For each 'Event Type', 'Event Cause' the meaning of 'Event Details

Gary A Roach/K-CORP/KMT/KMT is out of the office.

I will be out of the office starting 10/28/2008 and will not return until 10/29/2008. I will be checking email / v-mail regularly. If you need to speak with someone immediately please call (or email) Kim Hawley at 724-539-6145 or Kathy Bangor at 724-539-5648.

Re: Adding days to a Date field in a qualification doesn't work

A couple of questions... Is your field a Date/Time, Date Only, or Time Only field? Since it is an AL have you tried using the 7.1 Client to see if it does the same thing? If your field is a Date/Time field (even if it is set to only display the Date) you will need to use TIMESTAMP instead of

Web Reporting

I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much

Crystal Report Question

Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create

Re: Adding days to a Date field in a qualification doesn't work

There was a native Macintosh client through version 3.2. It was one of the reasons we originally bought the product. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action

Re: LOB Space Reclaim Issue

I have not had your exact issue but we were able to reclaim our db by running a script located in the RemedyAndOracleCLOBS.pdf document. It details how to reclaim space and gives an oracle stored procedure you can use to change all lob storage to In-Row from Out of Row. By running the

Escalation Threads

I was wondering does anyone know what a good numbering is for the AR Escalation threads, min/max. We have a Large system, with about 100,000 incidents just to give you an idea. We have all applications, Service Desk, Change Management, CMDB, Asset, SLM etc... For some reason our escalations

Oracle Link problems

I am trying to work with EIE 5.1 with Oracle Link for AR 6.3. When I try to list the tables from the Oracle DB, I am getting nothing back. When I run rulehelper from the UNIX command line, I am getting Connection to Oracle database Failed yet, SQLPLUS can connect and TNSPING works. Ron

Re: Web Reporting

Use BIRT. Open Source, works OK. You'll need to understand a whack of stuff about Web Reporting and (perhaps) write a one or two line Java class. We use it on this project in ITSM 7. Even easier for your own stuff. Cheers Ben Chernys _ From: Action Request System discussion

Re: Web Reporting

We upgraded our Crystal Reports Professional copies to XI when 7.x came out, and are using the Crystal Reports Server XI that came bundled with it to serve up our reports for mid-tier. Before 7.x, we were using Crystal Reports Professional 9 with the bundled Crystal Enterprise 9 web server in

Re: Active Link Function in an Escalation???

Thanks Fred, that did the trick. I completely forgot about the LPAD command. Must be getting old. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with

Re: Escalation Threads

Not sure I can give you a good number, but definitely increasing it would be a good thing (and then changing the pool on each escalation to the corresponding thread). From: Action Request System discussion list(ARSList) on behalf of Begosh, Kevin Sent: Tue

Re: Escalation Threads

Escalations by default run in 1 (pool/thread), if you have some long running escalations/escalations you want running concurrently you will need to increase the thread count to accommodate as many as you want to run simultaneously, and then edit the escalations to run in specific pools, this will

Re: Crystal Report Question

Hi Shawn, A rather easier way of doing this would be to use Select Expert. Your records probably need grouping via Day/Date. Once the records are grouped you can use select expert to define the criteria for your report. Please consider the following formula as an example. [EMAIL PROTECTED] in

Re: Mid-Tier Web Page is coming up blank

I ran across something similar a few weeks ago after an upgrade. This error will occur if there is a Active Link associated with the form being opened which contains a Open Window action of type Report and the Destination field in the Active Link contains a hard return control character. Look

ARERR [286] Display only fields cannot be included in a query to the database

Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can’t use “$LASTID$.” Instead we query the db for the “max(Request ID).” So in the Active Link, which runs “After Submit,” I set

Re: ARERR [286] Display only fields cannot be included in a query to the database

Since you are using an After Submit AL you can do it much easier. Just do your Window Open action using: 'Request ID' = $Request ID$ The correct Request ID is available in an After Submit Active Link Fred -Original Message- From: Action Request System discussion list(ARSList)

Dave Wallace is out of the office.

I will be out of the office starting 10/28/2008 and will not return until 10/30/2008. I will be OOO until 10.30. If you need immediate assistance then email SMT-ProdEng. ___ UNSUBSCRIBE or access ARSlist Archives at

Where is the arsystem.lic?

Hi all!!! I have my server running on Suse Linux Enterprise Server 10. It is licensed without problem, I can export the lic file from the Arsystem administration console but now here is the question, where is in my server the arsystem.lic?.usually on a Linux server is in

Re: Where is the arsystem.lic?

Since AR System 7.1 the remedy licenses are no longer kept in files, but they are now in the database! You can access them from the AR System Administration console. Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Tue, Oct 28, 2008 at 6:41

Re: Where is the arsystem.lic?

It's ok, I can see them in my AR system administrador console, but do you know w the name of the table in which I could see them?. Thank you very much!!! 2008/10/28 Michiel Beijen [EMAIL PROTECTED] Since AR System 7.1 the remedy licenses are no longer kept in files, but they are now in the

Re: Escalation Threads

We added a second thread and configured the primary notification engine escalation, SYS:NPC:IM1-TriggerGroupNTG, to use that thread. We have significant notification volume based on some standard Service Targets, and this escalation is on a one minute poll. Bottom line, identify your high

Re: Crystal Report Question

This is how I attacked the problem. I created two formulas. * DayOfWeek oDayOfWeek ({HPD_HelpDesk.Create Time}) * Hour oHour ({HPD_HelpDesk.Create Time}) I then used them in the Select Statement. {HPD_HelpDesk.Create Time} in LastFullWeek and (([EMAIL

Re: Crystal Report Question

As far as grouping goes, You can create the first group on DayOfWeek and create a formula for AM/PM and create a second group on that. AM/PM formula If [EMAIL PROTECTED] 12 Then AM Else If [EMAIL PROTECTED] = 12 Then PM -Original Message- From: Action Request System discussion

Re: Crystal Report Question

Sorry, I realized after rereading your email that I missed a portion. (([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] 19) OR ([EMAIL PROTECTED] = 2) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18] OR ([EMAIL PROTECTED] = 3) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13,

Remedy Position in Northern Virginia

Hello Listers We are looking for a experienced Remedy Developers with a secret clearance or the ability to be cleared for a project on Fort Belvoir, VA. Must have a at least 4-5 years experience in the developing of the BMC Remedy (ITSM) application. The candidate must have experience in

Re: LOB Space Reclaim Issue

Sean, I've checked on the support web site and developer network for the RemedyAndOracleCLOBS.pdf. Could you point me to where you found the document? Thanks, Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of

Re: ARERR [286] Display only fields cannot be included in a query to the database SOLVED

Thanks, Fred! That worked! Sometimes you have to do things the long cumbersome way before you see the simple and obvious. Or, as in this case, someone else points out the simple and obvious. I am still curious why the Open Window action wouldn't accept my display-only field as a qualifier.

Re: Web Reporting

Email me off list with your questions. William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: Tuesday, October 28,

7.1 Shared Database Install

Migrating from a 6.3 database to 7.1p3. All home grown stuff with no OOB applications. Also migrating to brand new application hosts and database hosts. This will allow us to leave the entire production environment untouched while we do the upgrade. ARS is Solaris 9 with Sybase 12.5 on RHEL

Java Version

ok... the new compatibility tool boggled my mind. We are installing the Right Answers KB on our production system. Well, they are hosting it, but I need to install the jdk-6u3-windows-i586-p.exe version of Java on the server. It is a different version than the one I have in production. Will

Re: 7.1 Shared Database Install

On UNIX, copying the directories should work.. but not right away... Tweak the system as described below.. The only changes you have to do is changing the server connect name in the ar.conf file, and the AR Server ID in the arsystem startup script, to whatever you want it to be on the other

Re: Where is the arsystem.lic?

If I recall right the name of the table begins with LICENSE or LIC.. You should easily find it with this query after logging into the database using the ARAdmin database user id.. select table_name from user_tables where table_name like 'L%'; Joe From:

Re: LOB Space Reclaim Issue

I'm wondering where you found that document too.. I don't think I came across such a document anywhere.. Joe From: Shellman, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 28, 2008 3:38:44 PM Subject: Re: LOB Space Reclaim Issue **

Re: 7.1 Shared Database Install

Are you using Unicode? I just checked my logs and on Solaris 10 (Oracle no Unicode) it did not do the import on the shared instance. You might check your install log and see if the installer accepted your input as shared. The log location is /usr/tmp/ar_install.log Fred

Re: LOB Space Reclaim Issue

The Using Oracle CLOBs with BMC Remedy Action Request System whitepaper is here; http://www.bmc.com/supportu/documents/96/63/89663/89663.pdf Mark From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Tue 28/10/2008 21:22 To:

Best practice? Email engine with two Remedy servers on a single unix box

Can I do a single email engine to service two Remedy servers? Load isn't an issue as these are my DEV QA servers. My Informix DBs for both are remote. Remedy v7.1 on Solaris 10 Informix 10 Thanks in advance! ___

Re: Best practice? Email engine with two Remedy servers on a single unix box

This in my opinion may not be possible as the core configuration and data forms supporting the email engine have to reside on the AR Server that the Email Engine services. The Email Engine looks for these forms and I'm pretty sure if they are missing, it would complain about their absense. Joe

DSO Help

I'm trying to get a DSO Return action to work and it seems to only work if I physically modify a ticket. Let me explain. On Server A, Form A upon submit it will DSO transfer data with ownership to Server B, Form B. We have that working now. On Server B, Form B we have filter workflow upon

Re: DSO Help

Corey, Set the Update Option in the DSO mapping to Immediately which will automatically update back to server A, form A whenever an update is made to server B, form B. Bruce Hyslop Unisys Bruce Hyslop | Remedy Developer | Remedy Support Unisys | 3199 Pilot Knob Road | Eagan, MN

DSO Question

Hi List, We have two ITSM 7 servers, each one used by different groups of users. However, we would like that when server A is unavailable, its users will be able to connect to server B. This way server B would hold server A data as well as its own data. Server A will just have server A data. In