Re: DMT and extra Zeros

[Carl Wilson]

Hi,

All data in the DMT spreadsheets is required to be stored as text (with the
latest version) - this is due to Excel converting all other formats to what
it thinks the value should be, thus the additional ".0".

Convert the cells to text only, then put the date in as straight text .

It can be a pain to do initially, but that way you will not get Excel
appending the ".0".

 

  _  

 

Kind Regards,

 

Carl Wilson

 

http://www.missingpiecessoftware.com/

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Boyd, Rebecca
Sent: 21 February 2014 21:13
To: arslist@ARSLIST.ORG
Subject: DMT and extra Zeros

 

** 

Hello everyone,

 

I am trying to load incidents using the HPD_LoadHelpDesk tab of the
Transactional_Incident spreadsheet.

 

The job is erroring out on the Load step because it can't convert a date.
The date looks correct on the spreadsheet, but when Remedy reports the
error, it always reports an extra zero for the seconds.  

 

2014/01/02 00:00:00.00 - Spreadsheet data

2014/01/02 00:00:00.000 - Remedy error

 

I have typed the date in fresh. I've changed the date & time. I've
re-formatted the cell. I've created new jobs every time only to get the same
'ol error message.

 

8.1 Clean Install, Oracle 11g

 

Here's a truncated version of the error message:

 

2014/02/21 15:36:17 - Transactional_Incident - Start of job execution

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : Unexpected error : 

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : org.pentaho.di.core.exception.KettleValueException: 

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : Reported Date String : couldn't convert string
[2014/01/02 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]

2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident

2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build 1
from 2012-11-06 13.20.53) : Errors detected!

2014/02/21 15:36:18 - Transactional_Incident - Job execution finished

 

 

-- 
Rebecca Boyd
Application Administrator
Wake Forest University

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: DMT and extra Zeros

[Boyd, Rebecca]

Michelle,

Yes. I have typed the date in fresh. I've changed the date and time. I've
reformatted the cells.

2014/01/02 00:00:00.00 -  What it looks like in my Spreadsheet

2014/01/02 00:00:00.000 - What Remedy reports that it sees


I don't know where/when/how/why Remedy is picking up an extra digit. But I
sure wish it would stop.


Rebecca


On Fri, Feb 21, 2014 at 4:51 PM, Lucero, Michelle <
michelle.luc...@bankofamerica.com> wrote:

> **
>
> HI, Rebecca:
>
>
>
> Have you attempted to reformat the date as mentioned in the message to
> 01/02/2014 00:00:00?
>
>
>
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : Reported Date String : couldn't convert string [2014/01/02
> 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]
>
>
>
> Michelle
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Boyd, Rebecca
> *Sent:* Friday, February 21, 2014 3:36 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: DMT and extra Zeros
>
>
>
> **
>
> Thanks, Roger.
>
>
>
> I tried deleting the first row of data. The new first row generated the
> same error message. Then I tried loading the spreadsheet with a single row
> of data. Same error.
>
>
>
> I've seen variations of this before. For example, when loading people, the
> Corporate IDs all had a ".0" appended to them. That didn't cause an error
> so we didn't catch it until it got into the people form. The corporate IDs
> on the spreadsheet definitely didn't have ".0" at the end.
>
>
>
>
>
> On Fri, Feb 21, 2014 at 4:16 PM, Roger Justice  wrote:
>
> ** Since the error message includes the Pentaho application it could be
> that Pentaho is causing the error. You could attempt to import a single
> entry directly to the DMT form to isolate the error.
>
>  -Original Message-
> From: Boyd, Rebecca 
> To: arslist 
> Sent: Fri, Feb 21, 2014 4:12 pm
> Subject: DMT and extra Zeros
>
> **
>
> Hello everyone,
>
>
>
> I am trying to load incidents using the HPD_LoadHelpDesk tab of the
> Transactional_Incident spreadsheet.
>
>
>
> The job is erroring out on the Load step because it can't convert a date.
> The date looks correct on the spreadsheet, but when Remedy reports the
> error, it always reports an extra zero for the seconds.
>
>
>
> 2014/01/02 00:00:00.00 - Spreadsheet data
>
> 2014/01/02 00:00:00.000 - Remedy error
>
>
>
> I have typed the date in fresh. I've changed the date & time. I've
> re-formatted the cell. I've created new jobs every time only to get the
> same 'ol error message.
>
>
>
> 8.1 Clean Install, Oracle 11g
>
>
>
> Here's a truncated version of the error message:
>
>
>
> 2014/02/21 15:36:17 - Transactional_Incident - Start of job execution
>
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : Unexpected error :
>
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : org.pentaho.di.core.exception.KettleValueException:
>
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : Reported Date String : couldn't convert string [2014/01/02
> 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]
>
> 2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident
>
> 2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build
> 1 from 2012-11-06 13.20.53) : Errors detected!
>
> 2014/02/21 15:36:18 - Transactional_Incident - Job execution finished
>
>
>
>
>
> --
> Rebecca Boyd
> Application Administrator
> Wake Forest University
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
>
>
> --
> Rebecca Boyd
> Application Administrator
> Wake Forest University
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>  --
> This message, and any attachments, is for the intended recipient(s) only,
> may contain information that is privileged, confidential and/or proprietary
> and subject to important terms and conditions available at
> http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
> recipient, please delete this message.
>  _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
Rebecca Boyd
Application Administrator
Wake Forest University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: DMT and extra Zeros

[Lucero, Michelle]

HI, Rebecca:

Have you attempted to reformat the date as mentioned in the message to 
01/02/2014 00:00:00?

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : Reported Date String : couldn't 
convert string [2014/01/02 00:00:00.000] to a date using format [MM/dd/ 
HH:mm:ss]

Michelle

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Boyd, Rebecca
Sent: Friday, February 21, 2014 3:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: DMT and extra Zeros

**
Thanks, Roger.

I tried deleting the first row of data. The new first row generated the same 
error message. Then I tried loading the spreadsheet with a single row of data. 
Same error.

I've seen variations of this before. For example, when loading people, the 
Corporate IDs all had a ".0" appended to them. That didn't cause an error so we 
didn't catch it until it got into the people form. The corporate IDs on the 
spreadsheet definitely didn't have ".0" at the end.


On Fri, Feb 21, 2014 at 4:16 PM, Roger Justice 
mailto:rjust2...@aol.com>> wrote:
** Since the error message includes the Pentaho application it could be that 
Pentaho is causing the error. You could attempt to import a single entry 
directly to the DMT form to isolate the error.

-Original Message-
From: Boyd, Rebecca mailto:boy...@wfu.edu>>
To: arslist mailto:arslist@ARSLIST.ORG>>
Sent: Fri, Feb 21, 2014 4:12 pm
Subject: DMT and extra Zeros
**
Hello everyone,

I am trying to load incidents using the HPD_LoadHelpDesk tab of the 
Transactional_Incident spreadsheet.

The job is erroring out on the Load step because it can't convert a date. The 
date looks correct on the spreadsheet, but when Remedy reports the error, it 
always reports an extra zero for the seconds.

2014/01/02 00:00:00.00 - Spreadsheet data
2014/01/02 00:00:00.000 - Remedy error

I have typed the date in fresh. I've changed the date & time. I've re-formatted 
the cell. I've created new jobs every time only to get the same 'ol error 
message.

8.1 Clean Install, Oracle 11g

Here's a truncated version of the error message:

2014/02/21 15:36:17 - Transactional_Incident - Start of job execution
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : Unexpected error :
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : 
org.pentaho.di.core.exception.KettleValueException:
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : Reported Date String : couldn't 
convert string [2014/01/02 00:00:00.000] to a date using format [MM/dd/ 
HH:mm:ss]
2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident
2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build 1 
from 2012-11-06 13.20.53) : Errors detected!
2014/02/21 15:36:18 - Transactional_Incident - Job execution finished


--
Rebecca Boyd
Application Administrator
Wake Forest University
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_



--
Rebecca Boyd
Application Administrator
Wake Forest University
_ARSlist: "Where the Answers Are" and have been for 20 years_

--
This message, and any attachments, is for the intended recipient(s) only, may 
contain information that is privileged, confidential and/or proprietary and 
subject to important terms and conditions available at 
http://www.bankofamerica.com/emaildisclaimer.   If you are not the intended 
recipient, please delete this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

AD: Registration for India BMC Remedy User Group Conference (WWRUG14IN) is now Open!

[Daniel]

I am excited to announce that Registration is now open for the first BMC
Remedy User Group Conference at Le Meridien Bangalore, March 27-29, 2014/

 

We have Keynote Speakers including:

 

Tarun Sharma, VP R&D, CEO of BMC Software India Pvt Ltd

Kumar Prabhas, VP and General Manager, UGSI Managing Director, Unisys India

 

A third keynote speaker, who of course will be presenting sessions as well,
and no RUG is a RUG without .

 

Doug Mueller, Chief Technology Officer, Service Management Business Unit,
BMC Software

 

We have dozens of sessions, and presenting many of them is of course ..

 

Lenny Warren, most recently seen at WWRUG13 as a member of the Advisory
Board and presenting.

 

 

The details of the conference, including the schedule  of sessions and links
for the hotel and registration are at: www.ibrug.com  

 

There is special pricing for the first 100 Registrations, and even after
that, it is still great value for the depth of sessions, the level of
technical training, and opportunity to meet and discuss ideas with fellow
Remedy developers, administrators and Managers. 

 

Of course there will be a Vendor area: Unisys(our Cornerstone Sponsor) and
BMC (a Gold sponsor) and Kinetic Data (our first Silver Sponsor) are already
committed to being there, more to be announced next week.

 

I am looking forward to meeting everyone, since I will, of course, be there
too.

 

Cheers Daniel

Daniel Bloom

Founder of the ARSlist

Chairman, WWRUG

Member of IBRUG

 

 

 

 

 

 

 

 

 

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: DMT and extra Zeros

[Boyd, Rebecca]

Thanks, Roger.

I tried deleting the first row of data. The new first row generated the
same error message. Then I tried loading the spreadsheet with a single row
of data. Same error.

I've seen variations of this before. For example, when loading people, the
Corporate IDs all had a ".0" appended to them. That didn't cause an error
so we didn't catch it until it got into the people form. The corporate IDs
on the spreadsheet definitely didn't have ".0" at the end.



On Fri, Feb 21, 2014 at 4:16 PM, Roger Justice  wrote:

> ** Since the error message includes the Pentaho application it could be
> that Pentaho is causing the error. You could attempt to import a single
> entry directly to the DMT form to isolate the error.
>
>
> -Original Message-
> From: Boyd, Rebecca 
> To: arslist 
> Sent: Fri, Feb 21, 2014 4:12 pm
> Subject: DMT and extra Zeros
>
> **
> Hello everyone,
>
>  I am trying to load incidents using the HPD_LoadHelpDesk tab of the
> Transactional_Incident spreadsheet.
>
>  The job is erroring out on the Load step because it can't convert a
> date. The date looks correct on the spreadsheet, but when Remedy reports
> the error, it always reports an extra zero for the seconds.
>
>  2014/01/02 00:00:00.00 - Spreadsheet data
> 2014/01/02 00:00:00.000 - Remedy error
>
>  I have typed the date in fresh. I've changed the date & time. I've
> re-formatted the cell. I've created new jobs every time only to get the
> same 'ol error message.
>
>  8.1 Clean Install, Oracle 11g
>
>  Here's a truncated version of the error message:
>
>  2014/02/21 15:36:17 - Transactional_Incident - Start of job execution
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : Unexpected error :
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : org.pentaho.di.core.exception.KettleValueException:
> 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
> 2012-11-06
> 13.20.53) : Reported Date String : couldn't convert string [2014/01/02
> 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]
> 2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident
> 2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build
> 1 from 2012-11-06 13.20.53) : Errors detected!
> 2014/02/21 15:36:18 - Transactional_Incident - Job execution finished
>
>
>  --
> Rebecca Boyd
> Application Administrator
> Wake Forest University
>  _ARSlist: "Where the Answers Are" and have been for 20 years_
>  _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
Rebecca Boyd
Application Administrator
Wake Forest University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: DMT and extra Zeros

[Roger Justice]

Since the error message includes the Pentaho application it could be that 
Pentaho is causing the error. You could attempt to import a single entry 
directly to the DMT form to isolate the error.



-Original Message-
From: Boyd, Rebecca 
To: arslist 
Sent: Fri, Feb 21, 2014 4:12 pm
Subject: DMT and extra Zeros


** 
Hello everyone,


I am trying to load incidents using the HPD_LoadHelpDesk tab of the 
Transactional_Incident spreadsheet.


The job is erroring out on the Load step because it can’t convert a date. The 
date looks correct on the spreadsheet, but when Remedy reports the error, it 
always reports an extra zero for the seconds.  


2014/01/02 00:00:00.00 – Spreadsheet data
2014/01/02 00:00:00.000 – Remedy error


I have typed the date in fresh. I've changed the date & time. I've re-formatted 
the cell. I've created new jobs every time only to get the same 'ol error 
message.


8.1 Clean Install, Oracle 11g




Here’s a truncated version of the error message:


2014/02/21 15:36:17 - Transactional_Incident - Start of job execution
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : Unexpected error : 
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : org.pentaho.di.core.exception.KettleValueException: 
2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 
2012-11-06 13.20.53) : Reported Date String : couldn't convert string 
[2014/01/02 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]
2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident
2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build 1 
from 2012-11-06 13.20.53) : Errors detected!
2014/02/21 15:36:18 - Transactional_Incident - Job execution finished




-- 
Rebecca Boyd
Application Administrator
Wake Forest University

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

DMT and extra Zeros

[Boyd, Rebecca]

Hello everyone,


I am trying to load incidents using the HPD_LoadHelpDesk tab of the
Transactional_Incident spreadsheet.


The job is erroring out on the Load step because it can't convert a date.
The date looks correct on the spreadsheet, but when Remedy reports the
error, it always reports an extra zero for the seconds.


2014/01/02 00:00:00.00 - Spreadsheet data

2014/01/02 00:00:00.000 - Remedy error


I have typed the date in fresh. I've changed the date & time. I've
re-formatted the cell. I've created new jobs every time only to get the
same 'ol error message.


8.1 Clean Install, Oracle 11g


Here's a truncated version of the error message:


2014/02/21 15:36:17 - Transactional_Incident - Start of job execution

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : Unexpected error :

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : org.pentaho.di.core.exception.KettleValueException:

2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from
2012-11-06 13.20.53) : Reported Date String : couldn't convert string
[2014/01/02 00:00:00.000] to a date using format [MM/dd/ HH:mm:ss]

2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident

2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build
1 from 2012-11-06 13.20.53) : Errors detected!

2014/02/21 15:36:18 - Transactional_Incident - Job execution finished


-- 
Rebecca Boyd
Application Administrator
Wake Forest University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Get Entry filter trigger - request for opinions

[Misi Mladoniczky]

Hi,

An ACTL is triggered by the user, and definitely involves the browser. If it
needs to access data on the server, it naturally goes to the mid-tier and then
to the server and then to the DB and back again.

I use GetEntry filters a lot, as it removes a bunch of roundtrips to the
server involving latency etc. along each trip.

If something is very rarely used by the client, you can always do it in
ACTL:s, but if something is commonly needed when retrieving a request, it is
good to use GetEntry filters.

The ServiceCall is also a very nice thing. On one roundtrip to the server you
can do a bunch of things within an ACTL ServicecCall.

Best Regards - Misi, RRR AB, http://rrr.se

> Hi Fred,
>
> So, interesting...I was thinking that the AL's pulling that data were fired
> directly in the user's browser, so there would be three legs: browser to
> mid-tier, mid-tier to ARS, and ARS to DB.  Are you saying that those AL's
> are actually executed by the mid-tier?  I really don't yet know enough
> about the division of labor between the mid-tier and the browser.
>
> The $CLIENT-TYPE$ idea is excellent.  Thanks.
>
> -charlie
>
>
> On Fri, Feb 21, 2014 at 11:52 AM, Grooms, Frederick W <
> frederick.w.gro...@xo.com> wrote:
>
>> **
>>
>> Yes we are using them here.
>>
>>
>>
>> You are describing exactly the reason to use the Get Entry filters.
>> (Actually
>> the User Tool pulling the data in an Active Link is the same as Mid-Tier.
>> Client to ARS, ARS to DB)
>>
>>
>>
>> If you are worried about it being pulled when it is not being used by a
>> visible user you can use the $CLIENT-TYPE$ to only have the filter fire
>> when you want it to.
>>
>>
>>
>> Fred
>>
>>
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge
>> *Sent:* Friday, February 21, 2014 1:44 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Get Entry filter trigger - request for opinions
>>
>>
>>
>> **
>>
>> Hi all,
>>
>>
>>
>> In some 20+ years of doing Remedy development, if I've written 2 filters
>> that use Get Entry as a trigger, that's a lot.  I've just never found any
>> significant reason to use the mechanism.  But now I'm having second
>> thoughts.
>>
>>
>>
>> So, first, I'd like to get an idea...does anyone use Get Entry filters?
>>  Does ITSM (I've never really worked with it)?  If so, what are the use
>> cases for this?
>>
>>
>>
>> Now on to my own new potential use case: If a user (of an application I've
>> written) opens a form on some entry that has foreign keys, and assuming it
>> makes sense to do so, I'll pull descriptive information from the foreign
>> form into local display fields.  So, for example, if we have a one-to-many
>> from Customer to Invoice, and the user opens an Invoice, I'll use the
>> Customer ID on the Invoice to pull maybe the Customer Name into a local.
>>  Nothing new here and I'm sure every application does this to some degree.
>>
>>
>>
>> Historically I've done this using active links.  With the heavy client
>> User Tool, this approach has always made the most sense to me.  For one
>> thing, if the active link was being invoked, I could be sure a user was
>> actually going to see the pulled data (the active link only would fire if
>> the user were opening the record), so the effort was not wasted.  For
>> another, since the User tool was more tightly coupled than the mid-tier,
>> the requests and replies didn't have to hit the wires so many times (2
>> round-trips for each request: User tool to ARS, ARS to DB).
>>
>>
>>
>> I've only recently moved up from v7.1 to v8.1, and only with this change
>> have I really started using and adopting the mid-tier.  So I'm relatively
>> new to thinking about how to best and most efficiently use it.  Given,
>> though, that it introduces both additional processing and an additional
>> round-trip (mid-tier to ARS), I'm now wondering if I should adopt a
>> different approach to pulling this foreign descriptive data.  Specifically,
>> I'm wondering if I should instead have Get Entry filters set up to pull it
>> on the entry's way "up from" the database to the user.
>>
>>
>>
>> The upside of this approach is that it'll be much quicker for the
>> transactional user who is opening these entries individually (and for whom
>> this foreign descriptive data is intended).  The downside of course is that
>> this data will potentially be fetched every time the entry is retrieved,
>> whether or not it'll be seen by any user or not (e.g. reporting, API
>> programs, etc.).
>>
>>
>>
>> A quick aside: I just ran a quick test to discover that while the
>> ARGetEntry API certainly does invoke Get Entry triggered filters, the
>> ARGetListEntryWithFields API does not.  So this may not be as bad as I
>> thought since, at least, a query list on the form (which uses
>> ARGetListEntryWithFields) will not invoke these filters.  It's true that
>> any kind of automation or reporting tool that processes on an
>> entry-by-entry

Re: 8.1 AI and Spoon modification...

[Rick Phillips]

Francois, thanks, I had to play with it abit, but it worked.

rp

On 2/18/2014 9:39 PM, Francois Seegers wrote:

Hi Rick,

I would propose to use the Value Mapper step to map the zero indexed values to 
the Remedy selection list values.

Francois

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Phillips
Sent: Wednesday, February 19, 2014 5:16 AM
To: arslist@ARSLIST.ORG
Subject: 8.1 AI and Spoon modification...

Hi,

I've got a step question about an existing transformation.  I have a source db 
where field A (integer type) has two values, 0 or 1.  I want to map that such 
that 0 maps to a selection field in ComputerSystem (CMDB not AST).

Can anyone tell me what type of step I need (and any examples would be great!).

Thanks,

Rick

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, 
and have been for 20 years"


__ Information from ESET Mail Security, version of virus signature 
database 9440 (20140218) __

The message was checked by ESET Mail Security.

http://www.eset.com





Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | 
http://www.blueturtle.co.za
Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)86 208 0237 | Midridge Office 
Estate, International Business Gateway, cnr New Road & Sixth Street, Midrand, 
1685 | P O Box 31331, Kyalami, 1684
Western Cape: Tel: +27 (0)87 702 1867 | Fax: +27 (0)21 552 7764 | Unit E6, 
Century Square, Heron Crescent, Century City, Cape Town, 7446

DISCLAIMER: This email and any files transmitted with it are confidential and 
are intended solely for the use of the individual or entity to whom they are 
addressed. This communication represents the originator's personal views and 
opinions, which do not necessarily reflect those of Blue Turtle Technologies 
(Pty) Ltd. If you are not the original recipient or the person responsible for 
delivering the email to the intended recipient, be advised that you have 
received this email in error, and that any use, dissemination, forwarding, 
printing, or copying of this email is strictly prohibited. If you received this 
email in error, please immediately notify the sender. Thank you.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

A simple question on Hardware Product Catalogs

[Terry Bootsma]

Hello everyone:
 
I have a relatively simple question which I am hoping to get answered.
 
If I have an environment that does not include ADDM (at this time) and I
want to have a pretty standardized list of hardware product catalog entries
(ie. Routers, Servers, Manufacturer, with CTI, Product Name, Model/Version,
Manufacturer) into my product catalog, where can I get such a list?   As an
example, this list would include the standard list of computer systems
(Dell, HP, IBM, etc.) as well as network devices (Routers, switches, etc.),
storage devices (NAS, etc) .From what I have experienced, the list that
is included with the BMC Atrium Product Catalog Data is for software
products only.  
 
The intention here is to properly categorize hardware equipment manually
(Phase 1) so that when going to ADDM, it won't be entirely throw away
(especially at the Product Name, Model/Version and Manufacturer level). 
 
Please advise.
 
 
Terry
 
 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy Knowledge Management Licenses

[Carl Wilson]

Hi,
The Paper License concept is that you estimate the number of end users that 
will access the system and pay BMC a license fee based on this number.  The 
users don't get a license allocated in the tool (Floating/Fixed) so to speak, 
but as they are accessing the system (Consoles, etc) you need to pay BMC the 
associated license fees.

Best to check with your BMC Sales Rep as things change regularly.  I am not 
sure on the end users without RKM permissions as it used to be that these were 
included in the total count (same as SRM licensing), but that may have changed.

You can get detailed information here on the SRM model that was also used for 
RKM (although it needs to be updated with the latest licensing model for RKM):

https://communities.bmc.com/docs/DOC-2975

 
Kind Regards,
 
Carl Wilson
 
http://www.missingpiecessoftware.com/

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rabi Tripathi
Sent: 21 February 2014 17:37
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Knowledge Management Licenses

Thank you Carl, Roger,  Joe.

So we concur: no license for end users to browse.

I don't fully understand the "paper license" concept. 

Are you saying yes, license is needed to manage articles, but the mechanics of 
the license is that you don't add the license like others, but pay based on how 
many users are given the Knowledge "permission?"

Regards.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Get Entry filter trigger - request for opinions

[Charlie Lotridge]

Hi Fred,

So, interesting...I was thinking that the AL's pulling that data were fired
directly in the user's browser, so there would be three legs: browser to
mid-tier, mid-tier to ARS, and ARS to DB.  Are you saying that those AL's
are actually executed by the mid-tier?  I really don't yet know enough
about the division of labor between the mid-tier and the browser.

The $CLIENT-TYPE$ idea is excellent.  Thanks.

-charlie


On Fri, Feb 21, 2014 at 11:52 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> **
>
> Yes we are using them here.
>
>
>
> You are describing exactly the reason to use the Get Entry filters.  (Actually
> the User Tool pulling the data in an Active Link is the same as Mid-Tier.
> Client to ARS, ARS to DB)
>
>
>
> If you are worried about it being pulled when it is not being used by a
> visible user you can use the $CLIENT-TYPE$ to only have the filter fire
> when you want it to.
>
>
>
> Fred
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge
> *Sent:* Friday, February 21, 2014 1:44 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Get Entry filter trigger - request for opinions
>
>
>
> **
>
> Hi all,
>
>
>
> In some 20+ years of doing Remedy development, if I've written 2 filters
> that use Get Entry as a trigger, that's a lot.  I've just never found any
> significant reason to use the mechanism.  But now I'm having second
> thoughts.
>
>
>
> So, first, I'd like to get an idea...does anyone use Get Entry filters?
>  Does ITSM (I've never really worked with it)?  If so, what are the use
> cases for this?
>
>
>
> Now on to my own new potential use case: If a user (of an application I've
> written) opens a form on some entry that has foreign keys, and assuming it
> makes sense to do so, I'll pull descriptive information from the foreign
> form into local display fields.  So, for example, if we have a one-to-many
> from Customer to Invoice, and the user opens an Invoice, I'll use the
> Customer ID on the Invoice to pull maybe the Customer Name into a local.
>  Nothing new here and I'm sure every application does this to some degree.
>
>
>
> Historically I've done this using active links.  With the heavy client
> User Tool, this approach has always made the most sense to me.  For one
> thing, if the active link was being invoked, I could be sure a user was
> actually going to see the pulled data (the active link only would fire if
> the user were opening the record), so the effort was not wasted.  For
> another, since the User tool was more tightly coupled than the mid-tier,
> the requests and replies didn't have to hit the wires so many times (2
> round-trips for each request: User tool to ARS, ARS to DB).
>
>
>
> I've only recently moved up from v7.1 to v8.1, and only with this change
> have I really started using and adopting the mid-tier.  So I'm relatively
> new to thinking about how to best and most efficiently use it.  Given,
> though, that it introduces both additional processing and an additional
> round-trip (mid-tier to ARS), I'm now wondering if I should adopt a
> different approach to pulling this foreign descriptive data.  Specifically,
> I'm wondering if I should instead have Get Entry filters set up to pull it
> on the entry's way "up from" the database to the user.
>
>
>
> The upside of this approach is that it'll be much quicker for the
> transactional user who is opening these entries individually (and for whom
> this foreign descriptive data is intended).  The downside of course is that
> this data will potentially be fetched every time the entry is retrieved,
> whether or not it'll be seen by any user or not (e.g. reporting, API
> programs, etc.).
>
>
>
> A quick aside: I just ran a quick test to discover that while the
> ARGetEntry API certainly does invoke Get Entry triggered filters, the
> ARGetListEntryWithFields API does not.  So this may not be as bad as I
> thought since, at least, a query list on the form (which uses
> ARGetListEntryWithFields) will not invoke these filters.  It's true that
> any kind of automation or reporting tool that processes on an
> entry-by-entry bases WILL invoke these filters, but this is probably the
> exceptional situation and well worth the enhanced user experience.
>
>
>
> Well, after about an hour of writing this email and doing the research, at
> this point I'm pretty much convinced that Get Entry is the way to go for
> this.  But I'll send this out anyway to maybe provoke some Friday afternoon
> conversation.  I'm still curious if & how people use Get Entry filters.
>
>
>
> Thoughts?  Comments?
>
>
>
> -charlie
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>  _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Get Entry filter trigger - request for opinions

[Charlie Lotridge]

Hi all,

In some 20+ years of doing Remedy development, if I've written 2 filters
that use Get Entry as a trigger, that's a lot.  I've just never found any
significant reason to use the mechanism.  But now I'm having second
thoughts.

So, first, I'd like to get an idea...does anyone use Get Entry filters?
 Does ITSM (I've never really worked with it)?  If so, what are the use
cases for this?

Now on to my own new potential use case: If a user (of an application I've
written) opens a form on some entry that has foreign keys, and assuming it
makes sense to do so, I'll pull descriptive information from the foreign
form into local display fields.  So, for example, if we have a one-to-many
from Customer to Invoice, and the user opens an Invoice, I'll use the
Customer ID on the Invoice to pull maybe the Customer Name into a local.
 Nothing new here and I'm sure every application does this to some degree.

Historically I've done this using active links.  With the heavy client User
Tool, this approach has always made the most sense to me.  For one thing,
if the active link was being invoked, I could be sure a user was actually
going to see the pulled data (the active link only would fire if the user
were opening the record), so the effort was not wasted.  For another, since
the User tool was more tightly coupled than the mid-tier, the requests and
replies didn't have to hit the wires so many times (2 round-trips for each
request: User tool to ARS, ARS to DB).

I've only recently moved up from v7.1 to v8.1, and only with this change
have I really started using and adopting the mid-tier.  So I'm relatively
new to thinking about how to best and most efficiently use it.  Given,
though, that it introduces both additional processing and an additional
round-trip (mid-tier to ARS), I'm now wondering if I should adopt a
different approach to pulling this foreign descriptive data.  Specifically,
I'm wondering if I should instead have Get Entry filters set up to pull it
on the entry's way "up from" the database to the user.

The upside of this approach is that it'll be much quicker for the
transactional user who is opening these entries individually (and for whom
this foreign descriptive data is intended).  The downside of course is that
this data will potentially be fetched every time the entry is retrieved,
whether or not it'll be seen by any user or not (e.g. reporting, API
programs, etc.).

A quick aside: I just ran a quick test to discover that while the
ARGetEntry API certainly does invoke Get Entry triggered filters, the
ARGetListEntryWithFields API does not.  So this may not be as bad as I
thought since, at least, a query list on the form (which uses
ARGetListEntryWithFields) will not invoke these filters.  It's true that
any kind of automation or reporting tool that processes on an
entry-by-entry bases WILL invoke these filters, but this is probably the
exceptional situation and well worth the enhanced user experience.

Well, after about an hour of writing this email and doing the research, at
this point I'm pretty much convinced that Get Entry is the way to go for
this.  But I'll send this out anyway to maybe provoke some Friday afternoon
conversation.  I'm still curious if & how people use Get Entry filters.

Thoughts?  Comments?

-charlie

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy Knowledge Mangement and Kinetic Request: work well together?

[Rabi Tripathi]

Thank you Derick.

The pages mention a "bundle.". Are RKM and Kinetic Request sold/implemented 
together in a bundle, or does the customer buy optional RKM adapter that will 
connect RKM and Kinetic Request? 

If latter, you are better off calling it something else (RKM Adapter?) rather 
than just "Remedy Knowledge Management."

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Caught Exception issue...

[Pierson, Shawn]

That's been our experience as well.  If we don't flush the Mid Tier cache we 
have no issues, but if we do, there is still a subset of people that will get 
"caught exception" and HTTP 500 errors.  Fortunately, we're slowing down our 
need for 8.1 fixes so we should be doing less code changes to ITSM 8.1 going 
forward.  Hopefully before our next big custom activity BMC gets the Mid Tier 
completely fixed.

Thanks,

Shawn Pierson 
Remedy Developer | Energy Transfer


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso
Sent: Friday, February 21, 2014 12:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Caught Exception issue...

We installed hotfix 8.1.00 201402031033 Hotfix (sp2) on our 8.1 sp2 Weblogic 
build the other night to help fix some of the NULL pointer and caught exception 
errors. At this time it appears the hot fix may have corrected "some" of these 
issues as the number of users reporting the issue has dropped off.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

Private and confidential as detailed here: 
http://www.energytransfer.com/mail_disclaimer.aspx .  If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Caught Exception issue...

[Frank Caruso]

We installed hotfix 8.1.00 201402031033 Hotfix (sp2) on our 8.1 sp2 Weblogic 
build the other night to help fix some of the NULL pointer and caught exception 
errors. At this time it appears the hot fix may have corrected "some" of these 
issues as the number of users reporting the issue has dropped off.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy Knowledge Management Licenses

[Rabi Tripathi]

Thank you Carl, Roger,  Joe.

So we concur: no license for end users to browse.

I don't fully understand the "paper license" concept. 

Are you saying yes, license is needed to manage articles, but the mechanics of 
the license is that you don't add the license like others, but pay based on how 
many users are given the Knowledge "permission?"

Regards.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Courian Connector to Remedy

[Saji Philip]

Hello,

I implemeted Courion with Remedy.  But that was like 6 years ago.  I
believe it was Courion 6.3.

And they had a built in connector for Remedy.
On Feb 19, 2014 7:44 AM, "Barb S."  wrote:

> Hello Listers,
>
> Has anyone implemented the Courian IDM connector with Remedy?  Could you
> provide any insight/words of advice as to which method you used ie. API,
> web service, email?  My company is implementing Courian in our environment
> and would like the connector to create asssignments to support staff to
> create all accounts that the Courian app is currently not configured to do.
>  This is new territory for me.  Thanks.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: EXTERNAL: Re: ARS 6.3 import question - RESOLVED

[Warren R. Baltimore II]

The answer was to create a .arx file, and that turned out to be pretty
easy.  I just used Notepad++ to create the headers, and then used replace
to get rid of the commas and replace with " ".  The only thing I had to do
extra was add "DATA" to the start of each line of data and in the field
with the return, swap out return for "\n".  Worked like a charm and did not
take more then 20 minutes.

Thanks for the help!

Warren

On Thu, Feb 20, 2014 at 12:23 PM, Reiser, John J wrote:

> **
>
> Warren,
>
> I tried it with the Data Import tool 8.1 and even though the CRs were not
> visible in the .csv file when viewed with notepad it imported multiple
> lines to the field in question.
>
> So if an upgrade is in your future it looks like it will work then.
>
>
>
> Thank you,
>
> ---
> John J. Reiser
> Remedy Developer/Administrator
>
> Senior Software Development Analyst
> Lockheed Martin - MS2
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II
> *Sent:* Thursday, February 20, 2014 9:45 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Re: ARS 6.3 import question
>
>
>
> **
>
> Thanks folks!  John, the quotes were added by excel.  I tried taking them
> out to see if that affected it, but no go
>
>
>
> Fred, I'll pull a .arx and see if I can't replicate it.
>
>
>
> Warren
>
> On Wed, Feb 19, 2014 at 5:18 PM, Reiser, John J 
> wrote:
>
> **
>
> Warren,
>
> Are the double quotes that you displayed actually in the cell? I would
> think they encapsulate the CR.
>
>
>
> Fred's idea is probably the best and not too hard to implement.
>
>
>
> Thank you,
>
> ---
> John J. Reiser
> Remedy Developer/Administrator
>
> Senior Software Development Analyst
> Lockheed Martin - MS2
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
> *Sent:* Wednesday, February 19, 2014 5:13 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* EXTERNAL: Re: ARS 6.3 import question
>
>
>
> **
>
> I would convert it to an ARX format
>
>
>
> The difference between CSV and ARX is not that great.  In ARX the line
> break is \n in the text.  The separator is a space instead of a comma.
> (and there is a couple of extra header lines)
>
>
>
> Fred
>
>
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Warren
> R. Baltimore II
> *Sent:* Wednesday, February 19, 2014 4:08 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* ARS 6.3 import question
>
>
>
> **
>
> I have been batting this around for a bit.  I feel like I've done this
> before, but I can't seem to figure it out.
>
>
>
> I've got a .csv file that needs to be imported into remedy.  I'm using the
> arimport tool.
>
>
>
> It's a straightforward file with one exception.  One row has a line break
> in each entry.  It is VERY important that this be maintained in the exact
> same format it is being entered.
>
>
>
> For example, an entry may say:
>
>
>
> "Functional  Role iPhone
>  replace blackberry"
>
>
>
> It must be placed into the field so that a check can be run against it in
> an attempt to find a previous entry.  The problem that I am having is that
> the import tool is treating the line break as the end of the entry.  It
> then jumps to the next line (replace blackberry) and attempts to treat it
> as a separate entry.
>
>
>
> Any ideas on how I can handle this.  I suspect that the .xml format is my
> answer, if so, any idea how I can (easily) convert the file?
>
>
>
> Thanks in advance!
>
> --
> Warren R. Baltimore II
> Remedy Developer
> 410-533-5367
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
>
> --
> Warren R. Baltimore II
> Remedy Developer
> 410-533-5367 _ARSlist: "Where the Answers Are" and have been for 20
> years_
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
Warren R. Baltimore II
Remedy Developer
410-533-5367

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: arserverd binding to 0.0.0.0

[Theo Fondse]

Hi Radhika!

You should do the same trick you did with the installer, to the startup
script as well and start the instances manually and one at a time.

If you are already doing this, it then becomes a matter of finding out
where it gets the physical host name from since you have changed the
HOSTNAME variable before starting each instance.

Could be /etc/sysconfig/network ??

If you find out where it reads the physical host name from, then you have
to change that too before starting each instance.

Come to think of it, you probably also have to ensure they run in separate
memory space by installing and running each instance under a separate
non-root OS user.


Best Regards,
Theo


On Fri, Feb 21, 2014 at 2:57 PM, Narayanan, Radhika <
radhika.naraya...@cgi.com> wrote:

> **
>
> Hi Theo,
>
>
>
> You're right. I managed to install the 3 AR Servers by fooling the
> installer as you said. But when I configure them in a server group and
> start the servers one after the other, the service wouldn't start.
>
>
>
> It complains armonitor.conf file cannot be found. It is looking for a
> folder in the Load balancer name in /etc/arsystem !
>
>
>
> Thanks
>
> Radhika
>
> +44 20718 25880
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Theo Fondse
> *Sent:* 21 February 2014 15:12
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arserverd binding to 0.0.0.0
>
>
>
> **
>
> Hi Radhika!
>
> The only way you will be able to do this is to fool Remedy into thinking
> each instance is running on a diferent hostname by:
>
> 1) Aliasing the 3 different server names in the host file.
>
> 2) Setting the HOSTNAME variable before installing / starting each copy of
> ARSystem.
>
> This may or may not work, is a bit dangerous and can NOT be recommended
> for a production environment.
>
>  Best Regards,
>
> Theo
>
>
>
> On Fri, Feb 21, 2014 at 11:05 AM, Narayanan, Radhika <
> radhika.naraya...@cgi.com> wrote:
>
> **
>
> Hi Axton/Longwing,
>
>
>
> My first problem is that the AR Server itself is not starting when I setup
> 3 AR Servers in a server group on a single physical server. (ARS 8.1, RHEL
> 6.4)
>
>
>
> AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10
>
> AR Server 2: Server-Name: d1, Server-Connect-Name: d11
>
> AR Server 3: Server-Name: d1, Server-Connect-Name: d11
>
>
>
> The 3 AR Servers are on one physical server and in a server group. d10,
> d11, d12 are 3 different virtual IP Addresses/Names for the physical server.
>
>
>
> AR Server service refuses to start. It complains armonitor.conf file
> cannot be found. *Each AR Server (arsystem startup script) is looking for
> /etc/arsystem/d1/armonitor.conf !!* d1 is the Load balancer = Server-Name
> in ar.conf.
>
>
>
> I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The
> server-connect-name is referred inside the armonitor.conf which is
> different for the 3 AR Servers!
>
>
>
> I find this architecture/requirement equally weird. It was decided by the
> client. They want 3 AR Servers on one physical server in a server group.
> I'm trying to squeeze Remedy into it now.
>
>
>
> Thanks
>
> Radhika
>
> +44 20718 25880
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Axton
> *Sent:* 20 February 2014 21:39
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arserverd binding to 0.0.0.0
>
>
>
> **
>
> If done properly, the rpc port mapper could work on all interfaces for all
> 3 servers.  I say "could" because it's probably not been proven/done, but
> in theory it should work.
>
>
>
> Axton Grams
>
>
>
> On Thu, Feb 20, 2014 at 9:59 AM, Axton  wrote:
>
> You could setup redirection using iptables to achieve what you want. Each
> server would effectively be listening on all ip addresses on different
> ports, but the redirection would redirect things as desired.
>
>
>
> http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/
>
> http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection
>
>
>
> On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika <
> radhika.naraya...@cgi.com> wrote:
>
> **
>
> Thank you so much, Axton, Fred and others.
>
>
>
> Our client gave us one physical server with 3 virtual IP Addresses. And
> asked us to install AR Server on each of the virtual IP Addresses, all on 
> *same
> port*. I guess I'm not able to use iptables restriction because I want to
> use the other IPs too , but for a second and third instance of AR Server.
>
> I'll write back to them stating that the current version of AR Server
> doesn't support this. Perhaps I should raise an RFE.
>
>
>
> Thanks again,
>
>
>
> Radhika
>
> +44 20718 25880
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Axton
> *Sent:* 19 February 2014 03:57
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arserverd binding to 0.0.0.0
>
>
>
> **
>
> Network daemons bind to address/protocol/port.  0.0.0.0 means al

Re: arserverd binding to 0.0.0.0

[Narayanan, Radhika]

Hi Theo,

You're right. I managed to install the 3 AR Servers by fooling the installer as 
you said. But when I configure them in a server group and start the servers one 
after the other, the service wouldn't start.

It complains armonitor.conf file cannot be found. It is looking for a folder in 
the Load balancer name in /etc/arsystem !

Thanks
Radhika
+44 20718 25880

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse
Sent: 21 February 2014 15:12
To: arslist@ARSLIST.ORG
Subject: Re: arserverd binding to 0.0.0.0

**
Hi Radhika!
The only way you will be able to do this is to fool Remedy into thinking each 
instance is running on a diferent hostname by:
1) Aliasing the 3 different server names in the host file.
2) Setting the HOSTNAME variable before installing / starting each copy of 
ARSystem.
This may or may not work, is a bit dangerous and can NOT be recommended for a 
production environment.

Best Regards,
Theo

On Fri, Feb 21, 2014 at 11:05 AM, Narayanan, Radhika 
mailto:radhika.naraya...@cgi.com>> wrote:
**
Hi Axton/Longwing,

My first problem is that the AR Server itself is not starting when I setup 3 AR 
Servers in a server group on a single physical server. (ARS 8.1, RHEL 6.4)

AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10
AR Server 2: Server-Name: d1, Server-Connect-Name: d11
AR Server 3: Server-Name: d1, Server-Connect-Name: d11

The 3 AR Servers are on one physical server and in a server group. d10, d11, 
d12 are 3 different virtual IP Addresses/Names for the physical server.

AR Server service refuses to start. It complains armonitor.conf file cannot be 
found. Each AR Server (arsystem startup script) is looking for 
/etc/arsystem/d1/armonitor.conf !! d1 is the Load balancer = Server-Name in 
ar.conf.

I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The server-connect-name 
is referred inside the armonitor.conf which is different for the 3 AR Servers!

I find this architecture/requirement equally weird. It was decided by the 
client. They want 3 AR Servers on one physical server in a server group. I'm 
trying to squeeze Remedy into it now.

Thanks
Radhika
+44 20718 25880

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: 20 February 2014 21:39
To: arslist@ARSLIST.ORG
Subject: Re: arserverd binding to 0.0.0.0

**
If done properly, the rpc port mapper could work on all interfaces for all 3 
servers.  I say "could" because it's probably not been proven/done, but in 
theory it should work.

Axton Grams

On Thu, Feb 20, 2014 at 9:59 AM, Axton 
mailto:axton.gr...@gmail.com>> wrote:
You could setup redirection using iptables to achieve what you want. Each 
server would effectively be listening on all ip addresses on different ports, 
but the redirection would redirect things as desired.

http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/
http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection

On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika 
mailto:radhika.naraya...@cgi.com>> wrote:
**
Thank you so much, Axton, Fred and others.

Our client gave us one physical server with 3 virtual IP Addresses. And asked 
us to install AR Server on each of the virtual IP Addresses, all on same port. 
I guess I'm not able to use iptables restriction because I want to use the 
other IPs too , but for a second and third instance of AR Server.
I'll write back to them stating that the current version of AR Server doesn't 
support this. Perhaps I should raise an RFE.

Thanks again,

Radhika
+44 20718 25880

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: 19 February 2014 03:57
To: arslist@ARSLIST.ORG
Subject: Re: arserverd binding to 0.0.0.0

**
Network daemons bind to address/protocol/port.  0.0.0.0 means all addresses.  I 
looked through all the ar.conf parameters and flags supported by arserverd and 
it does not look like there is a way to tell arserverd to listed on a specific 
IP.  You could use iptables to restrict access on those other IP addresses 
since you are on linux.

Axton Grams

On Tue, Feb 18, 2014 at 11:21 AM, Grooms, Frederick W 
mailto:frederick.w.gro...@xo.com>> wrote:
As far as I know the ARS binaries do not bind to an IP.  They will bind to a 
TCP port if one is specified (and/or use portmapper if that is set).

If you are not connecting to the AR Server one item to check is the /etc/hosts  
file.  See if the name you used for your AR Server is listed as a valid name 
for an IP.  If it is then check if your DNS server has it listed.

Example:
   AR Server = arsdev01
   Physical Server = devserver1

   /etc/hosts file
  # Do not remove the following line, or various programs
  # that require network functionality will fail.
  127.0.0.1

Re: Questing on accessing our Remedy/ITSM system outside of the corporate network

[Pierson, Shawn]

I second the VPN strategy.  There are VPN clients that can be loaded over the 
web through any external computer (or phone/tablet) so there's really no reason 
to avoid VPN really.  Plus that offers a lot more security since they have to 
have an account to get in so you know who they are rather than letting outside 
people try to get in anonymously.

Also, a lot of what you do really depends on who you are targeting.  If it's 
employees, VPN is absolutely the right answer.  If it's external customers, 
then I wouldn't give them access to Remedy except through some customer portal 
or application that has an integration with Remedy (through the firewall.)

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Thursday, February 20, 2014 6:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Questing on accessing our Remedy/ITSM system outside of the 
corporate network

**

I would consider the VPN strategy, or perhaps an email interface.  Exposing the 
Mid-tier outside the DMZ can be done safely, but requires cooperation with your 
network security team.

Rick
**
Yup, same here.  We had a little internal rift internally between a few teems.  
Team X decided that servers didn't need to be placed in the DMZ to expose to 
the outside world; they would just proxy to the LAN via F5 load balancer.  Team 
Y said no thank you, we should not have servers that are exposed to the world 
inside the main LAN.  So it is possible but you may need to consider if it is a 
good idea or even acceptable practice.

Jason

On Thu, Feb 20, 2014 at 3:02 PM, LJ LongWing 
mailto:lj.longw...@gmail.com>> wrote:
**

Howard,
A reverse proxy exposed to the internet would be one way I have seen it done
On Feb 20, 2014 3:54 PM, "Howard Richter" 
mailto:hbr4...@gmail.com>> wrote:
**
Good morning, afternoon and evening all,

I just got asked if there was a way to access our Remedy/ITSM system outside of 
the corporate network, if there are no parts (i.e. mid-tiers) in the DMZ.  They 
are thinking that they can use some magic with SSO and federation to do this. 
We are using the JSS plugin (which is great) for our ITSM 7.6.4. system.

So my first answer is no, one would need to have a mid-tier (or even an 
arserver) on a box in the DMZ and then give a method to access that system or 
open a firewall port (not very safe).

However, as I get older I have started to ask if I might be wrong., maybe 
someone else has found a way to do this. So is there some method where one 
could access the system if they were not on the corporate network (and a 
firewall was blocking access to the system inside the network).

Also I remember a doc, that BMC produced, that showed how to build out a system 
that would have external access. So if someone has an idea what it might be. 
Let me know.
As always take care and be well,

Howard

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

Private and confidential as detailed here: 
http://www.energytransfer.com/mail_disclaimer.aspx .  If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: arserverd binding to 0.0.0.0

[Theo Fondse]

Hi Radhika!

The only way you will be able to do this is to fool Remedy into thinking
each instance is running on a diferent hostname by:
1) Aliasing the 3 different server names in the host file.
2) Setting the HOSTNAME variable before installing / starting each copy of
ARSystem.

This may or may not work, is a bit dangerous and can NOT be recommended for
a production environment.


Best Regards,
Theo


On Fri, Feb 21, 2014 at 11:05 AM, Narayanan, Radhika <
radhika.naraya...@cgi.com> wrote:

> **
>
> Hi Axton/Longwing,
>
>
>
> My first problem is that the AR Server itself is not starting when I setup
> 3 AR Servers in a server group on a single physical server. (ARS 8.1, RHEL
> 6.4)
>
>
>
> AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10
>
> AR Server 2: Server-Name: d1, Server-Connect-Name: d11
>
> AR Server 3: Server-Name: d1, Server-Connect-Name: d11
>
>
>
> The 3 AR Servers are on one physical server and in a server group. d10,
> d11, d12 are 3 different virtual IP Addresses/Names for the physical server.
>
>
>
> AR Server service refuses to start. It complains armonitor.conf file
> cannot be found. *Each AR Server (arsystem startup script) is looking for
> /etc/arsystem/d1/armonitor.conf !!* d1 is the Load balancer = Server-Name
> in ar.conf.
>
>
>
> I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The
> server-connect-name is referred inside the armonitor.conf which is
> different for the 3 AR Servers!
>
>
>
> I find this architecture/requirement equally weird. It was decided by the
> client. They want 3 AR Servers on one physical server in a server group.
> I'm trying to squeeze Remedy into it now.
>
>
>
> Thanks
>
> Radhika
>
> +44 20718 25880
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Axton
> *Sent:* 20 February 2014 21:39
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arserverd binding to 0.0.0.0
>
>
>
> **
>
> If done properly, the rpc port mapper could work on all interfaces for all
> 3 servers.  I say "could" because it's probably not been proven/done, but
> in theory it should work.
>
>
>
> Axton Grams
>
>
>
> On Thu, Feb 20, 2014 at 9:59 AM, Axton  wrote:
>
> You could setup redirection using iptables to achieve what you want. Each
> server would effectively be listening on all ip addresses on different
> ports, but the redirection would redirect things as desired.
>
>
>
> http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/
>
> http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection
>
>
>
> On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika <
> radhika.naraya...@cgi.com> wrote:
>
> **
>
> Thank you so much, Axton, Fred and others.
>
>
>
> Our client gave us one physical server with 3 virtual IP Addresses. And
> asked us to install AR Server on each of the virtual IP Addresses, all on 
> *same
> port*. I guess I'm not able to use iptables restriction because I want to
> use the other IPs too , but for a second and third instance of AR Server.
>
> I'll write back to them stating that the current version of AR Server
> doesn't support this. Perhaps I should raise an RFE.
>
>
>
> Thanks again,
>
>
>
> Radhika
>
> +44 20718 25880
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Axton
> *Sent:* 19 February 2014 03:57
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: arserverd binding to 0.0.0.0
>
>
>
> **
>
> Network daemons bind to address/protocol/port.  0.0.0.0 means all
> addresses.  I looked through all the ar.conf parameters and flags supported
> by arserverd and it does not look like there is a way to tell arserverd to
> listed on a specific IP.  You could use iptables to restrict access on
> those other IP addresses since you are on linux.
>
>
>
> Axton Grams
>
>
>
> On Tue, Feb 18, 2014 at 11:21 AM, Grooms, Frederick W <
> frederick.w.gro...@xo.com> wrote:
>
> As far as I know the ARS binaries do not bind to an IP.  They will bind to
> a TCP port if one is specified (and/or use portmapper if that is set).
>
> If you are not connecting to the AR Server one item to check is the
> /etc/hosts  file.  See if the name you used for your AR Server is listed as
> a valid name for an IP.  If it is then check if your DNS server has it
> listed.
>
> Example:
>AR Server = arsdev01
>Physical Server = devserver1
>
>/etc/hosts file
>   # Do not remove the following line, or various programs
>   # that require network functionality will fail.
>   127.0.0.1 localhost.localdomain localhost
>   ::1   localhost6.localdomain6 localhost6
>   192.168.1.101  devserver1 devserver1.mycorp.com arsdev01
>
>DNS has a cname record for arsdev01 pointing to 192.168.1.101
>
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Narayanan, Radhika
> Sent: Tuesday, February 18, 2014 7:14 AM
> To: ar

Re: arserverd binding to 0.0.0.0

[Narayanan, Radhika]

Hi Axton/Longwing,

My first problem is that the AR Server itself is not starting when I setup 3 AR 
Servers in a server group on a single physical server. (ARS 8.1, RHEL 6.4)

AR Server 1: Server-Name: d1 (Load balancer), Server-Connect-Name: d10
AR Server 2: Server-Name: d1, Server-Connect-Name: d11
AR Server 3: Server-Name: d1, Server-Connect-Name: d11

The 3 AR Servers are on one physical server and in a server group. d10, d11, 
d12 are 3 different virtual IP Addresses/Names for the physical server.

AR Server service refuses to start. It complains armonitor.conf file cannot be 
found. Each AR Server (arsystem startup script) is looking for 
/etc/arsystem/d1/armonitor.conf !! d1 is the Load balancer = Server-Name in 
ar.conf.

I cannot use 1 armonitor.conf for 3 AR Servers. Can I? The server-connect-name 
is referred inside the armonitor.conf which is different for the 3 AR Servers!

I find this architecture/requirement equally weird. It was decided by the 
client. They want 3 AR Servers on one physical server in a server group. I’m 
trying to squeeze Remedy into it now.

Thanks
Radhika
+44 20718 25880

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: 20 February 2014 21:39
To: arslist@ARSLIST.ORG
Subject: Re: arserverd binding to 0.0.0.0

**
If done properly, the rpc port mapper could work on all interfaces for all 3 
servers.  I say "could" because it's probably not been proven/done, but in 
theory it should work.

Axton Grams

On Thu, Feb 20, 2014 at 9:59 AM, Axton 
mailto:axton.gr...@gmail.com>> wrote:
You could setup redirection using iptables to achieve what you want. Each 
server would effectively be listening on all ip addresses on different ports, 
but the redirection would redirect things as desired.

http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/
http://blog.softlayer.com/2011/iptables-tips-and-tricks-port-redirection

On Wed, Feb 19, 2014 at 1:54 AM, Narayanan, Radhika 
mailto:radhika.naraya...@cgi.com>> wrote:
**
Thank you so much, Axton, Fred and others.

Our client gave us one physical server with 3 virtual IP Addresses. And asked 
us to install AR Server on each of the virtual IP Addresses, all on same port. 
I guess I’m not able to use iptables restriction because I want to use the 
other IPs too , but for a second and third instance of AR Server.
I’ll write back to them stating that the current version of AR Server doesn’t 
support this. Perhaps I should raise an RFE.

Thanks again,

Radhika
+44 20718 25880

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: 19 February 2014 03:57
To: arslist@ARSLIST.ORG
Subject: Re: arserverd binding to 0.0.0.0

**
Network daemons bind to address/protocol/port.  0.0.0.0 means all addresses.  I 
looked through all the ar.conf parameters and flags supported by arserverd and 
it does not look like there is a way to tell arserverd to listed on a specific 
IP.  You could use iptables to restrict access on those other IP addresses 
since you are on linux.

Axton Grams

On Tue, Feb 18, 2014 at 11:21 AM, Grooms, Frederick W 
mailto:frederick.w.gro...@xo.com>> wrote:
As far as I know the ARS binaries do not bind to an IP.  They will bind to a 
TCP port if one is specified (and/or use portmapper if that is set).

If you are not connecting to the AR Server one item to check is the /etc/hosts  
file.  See if the name you used for your AR Server is listed as a valid name 
for an IP.  If it is then check if your DNS server has it listed.

Example:
   AR Server = arsdev01
   Physical Server = devserver1

   /etc/hosts file
  # Do not remove the following line, or various programs
  # that require network functionality will fail.
  127.0.0.1 localhost.localdomain localhost
  ::1   localhost6.localdomain6 localhost6
  192.168.1.101  devserver1 
devserver1.mycorp.com arsdev01

   DNS has a cname record for arsdev01 pointing to 192.168.1.101


Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
Narayanan, Radhika
Sent: Tuesday, February 18, 2014 7:14 AM
To: arslist@ARSLIST.ORG
Subject: arserverd binding to 0.0.0.0

**
Hi List,

How can I make the arserverd executable listen on a given, specific IP Address 
and not on 0.0.0.0?

By default, arserverd binds to the interface 0.0.0.0. My RHEL 6.4 server has 5 
IP Addresses. I want it to bind only to one of the 5 IP Addresses that I 
mention in armonitor.conf.

armonitor.conf:
/apps/tim/ar/timw0/bin/arserverd.sh -s dc5chw-000 -i /apps/tim/ar/timw0 -l 
/etc/arsystem/dc5chw-000

In this line, the server name is mentioned as dc5chw-000. I want arserverd to 
bind only to this IP Address. How can I achieve this?

Environment: ARS  8.1 Pa