Re: CMDB installation issues

[Jason Miller]

**
Hi John,Have you looked at the logs to verify that the data import errors are truly errors to be concerned with? If the CMDB is already (partially?) installed and has some data, the data import will typically error out because the records already exist. This may not be the solution to your problem buy may help make sure you are not barking up the wrong tree and getting too hung up in the data import errors just because of some dup records.
Also you mentioned that various components have been installed by various OS users. Did you chown/chmod/chgrp all of the directories and files to make ownership and access consistent? I have had really good results doing all installs/upgrades as root, shutting down ARS, changing permissions/owners on all files Remedy and restarting as the non root user. I did run into a situation last week where root didn't have read rights to a dir/files and the script kept bombing until I adjusted rights (just because root can't read the file doesn't mean it can't changes the rights ;-)
The last thing... I have noticed there tends to be less problems with the scripts when I set the server to run on a specific TCP port and not use portmapper. Generally my errors have been at the beginning of the script when trying to authenticate the admin user who I know is an admin and that I have typed the correct pw. Once the port was defined the script ran with no issue. Why there would be an authentication/permissions issue ("Demo is not a admin") when using portmapper doesn't make sense to me but it goes away with a specified port.
HTH,JasonBTW, it could easily take over 2 hours to install HD/CMDB depending our your hardware, etc (there are a LOT of forms in the CMDB). You may need to give it a bit more time next time. Maybe turn on SQL logging and tail -f the log file so you can see that there is activity (make sure you have some good disk space available)?
On 9/28/06, John Hanson <[EMAIL PROTECTED]> wrote:
**










Hello everybody!!


We've been upgrading our dev server and have run into a bit of an issue.  We installed ARS 6.3 patch 18, email 6.3 patch 18, and mid-tier 6.3 patch 18 on a Solaris server with an Oracle database.  All of these installed with little or no problems.  We installed ARS and email as a non-root user, and mid-tier as root.  These pieces are all working OK.


Then, we tried to install Help Desk.  The first time, it sat for over 2 hours before we shut it off.  Each time after, it would give an error when attempting to install it's version of CMDB.  I reported this to support and they told me that CMDB needs to be installed before HD.  So I removed all of the Help Desk stuff and attempted to install CMDB.  I am using the CMDB patch 3 installer file, and every time it gets to "Loading definitions and data for Shared workflow", it generates an error during the data import while attempting to run a 'rik' command.  It then tries to continue the installation until it says "Generating CDM"; then after a minute or so it pops up another error "Problem generating CDM" and the installation quits.


After reading many many KB articles and poring over several old ARS List emails, I got a few good ideas, but none of them worked.  I have increased my thread count for list and fast servers to 4 each at startup with a max of 8 each.  The odd thing about this is that I had to update the threads directly in the 
ar.conf file, because Remedy Administrator (also version 6.3 patch 18) doesn't show the box for threads at the bottom of the Server Ports and Queues tab of the server info dialog.

I would greatly appreciate any further insight from the list.  I'm about at my wit's end here after spending a day and a half trying to install the CMDB.

Thank you,


John Hanson
Remedy Administrator/Developer
The Standard
1100 SW Sixth Avenue
Portland, OR 97204
Telephone (971) 321-7153
[EMAIL PROTECTED]





__20060125___This posting was submitted with HTML in it___

__20060125___This posting was submitted with HTML in it___

Re: Integer date conversion in Business Object WebIntelligence

[CONDREA, Daniel]

Thank you very much Thomas.

Best regards,
Daniel

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Friday, September 29, 2006 2:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Integer date conversion in Business Object WebIntelligence

Oh, what the heck... here are the methods for the three databases I 
mentioned :-)

--MS-SQL:
CREATE FUNCTION dbo.remedydate_to_datetime(@dateint int)
RETURNS DATETIME AS
BEGIN
DECLARE @sql_date datetime;
IF @dateint < 2361331
   SET @sql_date = '17530101'
ELSE
   SET @sql_date = DATEADD(dd,@dateint - 2361331,'17530101');
RETURN @sql_date;
END

--INFORMIX:
CREATE PROCEDURE "informix".remedydate_to_informix(i INTEGER) RETURNING 
DATE;
DEFINE d DATE;
DEFINE n INTEGER;
IF i < 2415021 THEN
   LET d = MDY(1,1,1900);
ELSE
   LET n = (i - 2415021);
   LET d = MDY(1,1,1900) + n UNITS DAY;
END IF;
RETURN d;
END PROCEDURE;

--ORACLE (following is an example using the built-in function to convert
the 
date integer '2449992'):
SELECT TO_CHAR(TO_DATE(2449992, 'J'), 'MON-DD-') FROM DUAL;

Keep in mind, MS-SQL dates only go back to Jan 1, 1753 and Informix
dates 
only go back to Jan 1, 1900.  Oracle dates cover the same range as
Remedy's 
Date fields -- back to Jan. 1, 4713 B.C.

HTH,

Thomas

- Original Message - 
From: "Thomas Bean" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, September 28, 2006 16:49
Subject: Re: Integer date conversion in Business Object WebIntelligence


> Hey Steve,
> What RDBMS are you working with?  I've created several user-defined 
> functions in MS-SQL and Informix that perform these conversions, also 
> Oracle has a built-in function that should work.
>
> --Thomas
>
> - Original Message - 
> From: "Steve McDonald" <[EMAIL PROTECTED]>
> Newsgroups: gmane.comp.crm.arsystem.general
> Sent: Thursday, September 28, 2006 15:47
> Subject: Integer date conversion in Business Object WebIntelligence
>
>
>> Hello all,
>>
>> Just wondering if anyone has tackled the database stored integer for 
>> Remedy
>> date fields to a human readable date?  If so, I'd love your help.  I 
>> figure
>> with BO and Remedy being partners there would be something built in
but I
>> cant find it.
>>
>> Steve
> 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

--

*DISCLAIMER*

The information contained in this communication is confidential and may be 
legally privileged. It is intended solely for the use of the individual or 
entity to whom it is addressed and others authorized to receive it. If you are 
not the intended recipient you are hereby notified that any disclosure, 
copying, distribution or taking action in reliance of the contents of this 
information is strictly prohibited and may be unlawful. Orange Romania S.A. is 
neither liable for the proper, complete transmission of the information 
contained in this communication nor any delay in its receipt.

*END OF DISCLAIMER*

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Passing Work Log

[Carey Matthew Black]

Tom,

Well that all really depends... :) Let me try to give you a shot at this.

As I understand things:

A Push action will only push the transactional value of a Diary field
IF there was a transactional value in the transaction. So if the user
or workflow added a value to the Diary then that is the only part that
the Push action will see.

IF however the user did not update the diary then the full value of
the Diary will be available in the transaction.

See if you can verify that behaviour then I think you will be able to
workout the rest of the details.


And another thought that might help

Create a display only diary field and do a SetField action to get the
DB part from the RDBMS into the "Transaction" when there is a
Transactional Diary entry.


HTH

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 9/28/06, Tom L <[EMAIL PROTECTED]> wrote:

Does anyone know how to access the entire Work Log with Remedy
workflow?

I am running ARS 6.3 w/ Oracle 9.2, Help Desk 6.0, and we have
integrated Pinnacle. When an existing case is reassigned to a
particular group, we create a case in Pinnacle and passing some key
information using Remedy workflow. With this case creation, it appears
that Remedy will only pass the last Work Log entry. I need to pass the
entire Work Log. Has anyone ever do something like this or does anyone
know how to access all text in a CLOB type within Remedy? Thanks much.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: driver.exe (Yet Another Driver Question): deleting entries

[Carey Matthew Black]

Alex,

Hum... are you limited to only using _the_ driver program? Or just
limited to an API program in general?

I could easily suggest that you write an API program to do what your
after. You could choose from the languages of: C, Java or Perl.

Or you might have an outside chance of finding an existing filter on
your server that has the "Application-Query-Delete-Entry" command in
it in a way that would let you sub in the form and qualification then
the driver program might still be an option.

Or you might be able to try this approach...

Write a controller script that calls the driver program multiple
times. More specifically you can run the driver program to get the
entries that match your query. Then parse the output file and then
call the driver program for each and every entry that was found in the
output file.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 9/28/06, Alex Straph <[EMAIL PROTECTED]> wrote:

Carey: while I would like to do that, I am loathe to make any changes to
the workflow or add new forms.  The servers are under a
modification "lockdown" of sorts and any changes that would be made,
including this one, would have to be subject to a review by department
heads, of course I already asked them and they said no.  This has to be
exclusively through the driver program.

Is there another possible function that would delete these entries using
custom criteria other than using the "de" command in DRIVER?

Thanks.

Alex


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: CMDB installation issues

[Rick cook]

Title: CMDB installation issues
**



If your admin doesn't show the multiple threads, it may be 
on an unlicensed server.  Is that possible, or that it doesn't recognize 
the server license you have?
 
Rick

From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John 
HansonSent: Thursday, September 28, 2006 3:00 PMTo: 
arslist@ARSLIST.ORGSubject: CMDB installation 
issues
** 

Hello everybody!! 
We've been upgrading our dev server and have run into 
a bit of an issue.  We installed ARS 6.3 patch 18, email 6.3 patch 18, and 
mid-tier 6.3 patch 18 on a Solaris server with an Oracle database.  All of 
these installed with little or no problems.  We installed ARS and email as 
a non-root user, and mid-tier as root.  These pieces are all working 
OK.
Then, we tried to install Help Desk.  The first 
time, it sat for over 2 hours before we shut it off.  Each time after, it 
would give an error when attempting to install it's version of CMDB.  I 
reported this to support and they told me that CMDB needs to be installed before 
HD.  So I removed all of the Help Desk stuff and attempted to install 
CMDB.  I am using the CMDB patch 3 installer file, and every time it gets 
to "Loading definitions and data for Shared workflow", it generates an error 
during the data import while attempting to run a 'rik' command.  It then 
tries to continue the installation until it says "Generating CDM"; then after a 
minute or so it pops up another error "Problem generating CDM" and the 
installation quits.
After reading many many KB articles and poring over 
several old ARS List emails, I got a few good ideas, but none of them 
worked.  I have increased my thread count for list and fast servers to 4 
each at startup with a max of 8 each.  The odd thing about this is that I 
had to update the threads directly in the ar.conf file, because Remedy 
Administrator (also version 6.3 patch 18) doesn't show the box for threads at 
the bottom of the Server Ports and Queues tab of the server info 
dialog.
I would greatly appreciate any further insight from 
the list.  I'm about at my wit's end here after spending a day and a half 
trying to install the CMDB.
Thank you, 
John HansonRemedy Administrator/DeveloperThe Standard1100 SW Sixth AvenuePortland, OR 97204Telephone (971) 
321-7153[EMAIL PROTECTED] __20060125___This 
posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Database results

[Halstead, Robert]

**



I would like to 
handle multiple results from a sql query in remedy.  The query I want to 
run may return multiple results in which I would like to push each result to a 
form. Is this possible?
 

Bob 
Halstead
__20060125___This posting was submitted with HTML in it___

Re: Integer date conversion in Business Object WebIntelligence

[Thomas Bean]

Oh, what the heck... here are the methods for the three databases I 
mentioned :-)


--MS-SQL:
CREATE FUNCTION dbo.remedydate_to_datetime(@dateint int)
RETURNS DATETIME AS
BEGIN
DECLARE @sql_date datetime;
IF @dateint < 2361331
  SET @sql_date = '17530101'
ELSE
  SET @sql_date = DATEADD(dd,@dateint - 2361331,'17530101');
RETURN @sql_date;
END

--INFORMIX:
CREATE PROCEDURE "informix".remedydate_to_informix(i INTEGER) RETURNING 
DATE;

DEFINE d DATE;
DEFINE n INTEGER;
IF i < 2415021 THEN
  LET d = MDY(1,1,1900);
ELSE
  LET n = (i - 2415021);
  LET d = MDY(1,1,1900) + n UNITS DAY;
END IF;
RETURN d;
END PROCEDURE;

--ORACLE (following is an example using the built-in function to convert the 
date integer '2449992'):

SELECT TO_CHAR(TO_DATE(2449992, 'J'), 'MON-DD-') FROM DUAL;

Keep in mind, MS-SQL dates only go back to Jan 1, 1753 and Informix dates 
only go back to Jan 1, 1900.  Oracle dates cover the same range as Remedy's 
Date fields -- back to Jan. 1, 4713 B.C.


HTH,

Thomas

- Original Message - 
From: "Thomas Bean" <[EMAIL PROTECTED]>

To: 
Sent: Thursday, September 28, 2006 16:49
Subject: Re: Integer date conversion in Business Object WebIntelligence



Hey Steve,
What RDBMS are you working with?  I've created several user-defined 
functions in MS-SQL and Informix that perform these conversions, also 
Oracle has a built-in function that should work.


--Thomas

- Original Message - 
From: "Steve McDonald" <[EMAIL PROTECTED]>

Newsgroups: gmane.comp.crm.arsystem.general
Sent: Thursday, September 28, 2006 15:47
Subject: Integer date conversion in Business Object WebIntelligence



Hello all,

Just wondering if anyone has tackled the database stored integer for 
Remedy
date fields to a human readable date?  If so, I'd love your help.  I 
figure

with BO and Remedy being partners there would be something built in but I
cant find it.

Steve




___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Break out Member List from AP:Role form (Approval Server)?

[Rebecca Hammond]

**








This is great – although we’re
in Prod. Code lockdown, so I can’t do this now ;-)  However, I’m
going to definitely save it and try to implement as an enhancement!  Thank you!

 

I did figure it out, in SQL*Plus, at least
to find the affected records – if anyone’s interested, I can send
you the query syntax (darn Oracle, and using pipes - | - instead of percent
signs!)

 









From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Thad Esser
Sent: Thursday, September 28, 2006
1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Break out Member List
from AP:Role form (Approval Server)?



 

** 
Rebecca, 

It
is what it would like in a set fields of a filter.  For my setup, I have a
filter guide on the SHR:People form that when triggered, goes through all the
forms and deletes the users or updates records associated with them as
appropriate.  In the case of AP:Role, I push a value to a "Command
field" (display only char field) on the AP:Role form, where a filter
detects that and does the set fields below.  Specifically: 

---
The "Delete Person" filter guide searches the AP:Role form for roles where
the Login Name is the only value in the member list, and then displays an error
if it finds any, 
---
Having passed the above, the next filter pushes to the AP:Role form:

 
   Push If: 
 
      ( 'Member List' LIKE ((
"%"  + $Login Name$) +  "%" )) AND ( 'Status' =
"Active") 
 
              If none, take no action.  If
any, modify all. 
 
   Command = "REMOVE-USER-FROM-MEMBER-LIST
" + $Login Name$ 
 
   Change History = (($Full Name$ +
 " (") + $Login Name$) +  ") is being removed from
Remedy and has been removed from the list of approvers for this role."


Then
over on the AP:Role form, I have the following filter on Modify: 
Run
If: 
 
       'Command' LIKE
 "REMOVE-USER-FROM-MEMBER-LIST %" 
---
Action 1, Set Fields: 
 
      Command = ( ";" + REPLACE($Command$,
 "REMOVE-USER-FROM-MEMBER-LIST ",  "")) +
 ";" 
 
      Member List = ( ";" + $Member
List$) +  ";" 
(parses
the login name out of the command field and adds semi-colons so we can avoid
partial matches, e.g. jdoening matching when trying to remove jdoe)


---
Action 2, Set Fields: 
 
      Member List = REPLACE($Member List$,
$Command$,  ";") 
(pulls
out the login name, replacing it with a semi-colon so that login names are
still separated properly) 

---
Action 3, Set Fields: 
 
      Member List = SUBSTR($Member List$, 1,
LENGTH($Member List$) - 2) 
(cuts
off the leading and trailing semi-colons that we added in action 1 to make our
search easier) 

I
hope that clarifies things for you. 
 
Thad
"Perfection is achieved, not when there is nothing more to add, but when
there is nothing left to take away." - Antoine de
Saint-Exupéry 




 
  
  "Rebecca Hammond"
  <[EMAIL PROTECTED]> 
  Sent
  by: "Action Request System discussion list(ARSList)"  
  09/28/2006 06:44 AM 
  
   

Please
respond to
arslist@ARSLIST.ORG

   
  
  
  
  
  
   

To


arslist@ARSLIST.ORG


   
   

cc


 

   
   

Subject


Re: Break out Member List from AP:Role form
(Approval Server)?

   
  
   
  
   

 


 

   
  
  
  
 





I
may not have had enough coffee this morning...but this, below, is what it 
would look like in a piece of Remedy workflow, or
a SQL command at the DB 
level (or both)?

On Wed, 27 Sep 2006 10:36:40 -0700, Thad Esser
<[EMAIL PROTECTED]> wrote:

>Try:
>
>REPLACE($Member List$, $Login Name$,
 "")
>followed by
>REPLACE($Member List$, ";;",
 ";")
>
>(you could combine them into one if you
wanted)
>
>Thad
>"Perfection is achieved, not when there
is nothing more to add, but when 
>there is nothing left to take away." -
Antoine de Saint-Exupéry
>
>
>
>"Rebecca Hammond"
<[EMAIL PROTECTED]> 
>Sent by: "Action Request System
discussion list(ARSList)" 
>
>09/27/2006 10:28 AM
>Please respond to
>arslist@ARSLIST.ORG
>
>
>To
>arslist@ARSLIST.ORG
>cc
>
>Subject
>Break out Member List from AP:Role form
(Approval Server)?
>
>
>
>
>
>
>Hi all!
>
>I'm going through the process of trying to
remove a whole bunch (hundreds) 
>
>of People/User records - these are people who
no longer work in my 
>organization.
>
>I know if I use the App. Config. Console, this
will blow the users out of 
>places like SHR:Assignment.  However,
I've found that there can be 
>problems 
>if a user is deleted but their login name is
still listed as part of a 
>Member List in the AP:Role form.  In
there, the login is stored with other 
>
>members of the role, separated by a ;
>
>Does anyone have any tricks for editing the
AP:Role records when a User 
>account is deleted?
>
>Thanks!
>
>___

>UNSUBSCRIBE or access ARSlist Archives at
http://www.wwrug.org
>
>
>
>***IMPORTANT NOTICE: This communication,
including an

Re: Remedy V7 - Character Sets

[Don Simmons]

**


AR7x allows for the use of unicode characters through out except for Windows clients.  The windows clients are not unicode safe.  You only need to run one server.  Plug ins on the same server must be of the same character set.  You will need to have your English, French, German and Chinese web clients.  
 
Don Simmons


Date: Thu, 28 Sep 2006 13:42:14 -0500From: [EMAIL PROTECTED]Subject: Remedy V7 - Character SetsTo: arslist@ARSLIST.ORG** 
Hi AllDoes anyone know - with Remedy V7 - if I need to have multiple character sets available (IE L1 - Latin 1 and TC - Traditional Chinese) besides having a unicode database installed and the appropriate character sets available  would I need to run more than one Instance of the ARS Server? Or as long as the character sets are available ... ARS will make the currect decision on what to useExample: We need to have English, French, German and Traditional Chinese available ... the first 3 would be supported in L1, but we are going to need TC to support the Traditional ChineseAnyone had any experience with this?Thank you for any info you may haveBarb Wagner__20060125___This posting was submitted with HTML in it___ Stay connected with the news, people, places and online services that matter to you on Live.com  Try it!
__20060125___This posting was submitted with HTML in it___

CMDB installation issues

[John Hanson]

Title: CMDB installation issues
**






Hello everybody!!


We've been upgrading our dev server and have run into a bit of an issue.  We installed ARS 6.3 patch 18, email 6.3 patch 18, and mid-tier 6.3 patch 18 on a Solaris server with an Oracle database.  All of these installed with little or no problems.  We installed ARS and email as a non-root user, and mid-tier as root.  These pieces are all working OK.

Then, we tried to install Help Desk.  The first time, it sat for over 2 hours before we shut it off.  Each time after, it would give an error when attempting to install it's version of CMDB.  I reported this to support and they told me that CMDB needs to be installed before HD.  So I removed all of the Help Desk stuff and attempted to install CMDB.  I am using the CMDB patch 3 installer file, and every time it gets to "Loading definitions and data for Shared workflow", it generates an error during the data import while attempting to run a 'rik' command.  It then tries to continue the installation until it says "Generating CDM"; then after a minute or so it pops up another error "Problem generating CDM" and the installation quits.

After reading many many KB articles and poring over several old ARS List emails, I got a few good ideas, but none of them worked.  I have increased my thread count for list and fast servers to 4 each at startup with a max of 8 each.  The odd thing about this is that I had to update the threads directly in the ar.conf file, because Remedy Administrator (also version 6.3 patch 18) doesn't show the box for threads at the bottom of the Server Ports and Queues tab of the server info dialog.

I would greatly appreciate any further insight from the list.  I'm about at my wit's end here after spending a day and a half trying to install the CMDB.

Thank you,


John Hanson
Remedy Administrator/Developer
The Standard
1100 SW Sixth Avenue
Portland, OR 97204
Telephone (971) 321-7153
[EMAIL PROTECTED]





__20060125___This posting was submitted with HTML in it___

Re: Integer date conversion in Business Object WebIntelligence

[Thomas Bean]

Hey Steve,
What RDBMS are you working with?  I've created several user-defined 
functions in MS-SQL and Informix that perform these conversions, also Oracle 
has a built-in function that should work.


--Thomas

- Original Message - 
From: "Steve McDonald" <[EMAIL PROTECTED]>

Newsgroups: gmane.comp.crm.arsystem.general
Sent: Thursday, September 28, 2006 15:47
Subject: Integer date conversion in Business Object WebIntelligence



Hello all,

Just wondering if anyone has tackled the database stored integer for 
Remedy
date fields to a human readable date?  If so, I'd love your help.  I 
figure

with BO and Remedy being partners there would be something built in but I
cant find it.

Steve 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: driver.exe (Yet Another Driver Question): deleting entries

[Alex Straph]

Carey: while I would like to do that, I am loathe to make any changes to 
the workflow or add new forms.  The servers are under a 
modification "lockdown" of sorts and any changes that would be made, 
including this one, would have to be subject to a review by department 
heads, of course I already asked them and they said no.  This has to be 
exclusively through the driver program.

Is there another possible function that would delete these entries using 
custom criteria other than using the "de" command in DRIVER?

Thanks.

Alex

On Thu, 28 Sep 2006 16:11:36 -0400, Carey Matthew Black 
<[EMAIL PROTECTED]> wrote:

>Alex,
>
>I would approach the problem from a very different angle.
>
>Make routine and potentially dangerous activities as easy as possible,
>but leave room for verification steps in the process.
>
>I would try to:
>
>1) define the query that you want to use to delete the data from each from 
with.
>2) Create an ARS form that holds the form and Query information in
>character fields.
>3) Use a filter and the "Application-Query-Delete-Entry 
>" $PROCESS$ or Run Process action  to do the
>dead.
>
>4) If you want to review the records manually first, then use an
>advanced Table field to point at the form(s) in question and review
>the matching records first. then push the "Delete" button in the User
>Tool.
>
>Should not take to much effort to put together an "admin only" form to
>hold the data and to be used as a UI for the display/delete of the
>records too.
>
>
>Now if you really need to automate this with the driver program. Then
>write a form that you can use Driver to submit a record to. Have that
>submit trigger filters that loop over the configured information and
>deletes the data it finds "blindly". (I mean without a user review of
>the data.)
>
>
>Just be warned the first data row that you delete that you should not
>have deleted... well... that will be a problem. So be sure that your
>qualifications work, and are tested after every change. (Just a word
>to the wise.)
>
>
>--
>Carey Matthew Black
>Remedy Skilled Professional (RSP)
>ARS = Action Request System(Remedy)
>
>Love, then teach
>Solution = People + Process + Tools
>Fast, Accurate, Cheap Pick two.
>
>
>
>On 9/28/06, Alex Straph <[EMAIL PROTECTED]> wrote:
>> Over the last couple of months, six of our servers have been "invaded" 
with
>> several hundred entries each of dummy data over several forms.  This data
>> is causing performance issues so of course I have been tasked to find and
>> get rid of it.
>>
>> The good news is that the corrupt entries have consistent data meaning 
that
>> I could use a search filter to weed out the data.  Earlier, I have been
>> manually removing entries myself, only to find that these entries have
>> risen from the ashes.  It has become a pain to do each an every single 
week
>> so I need to use a driver script to specify what to delete.  I have 
decided
>> on using a driver script as a temporary fix until I get to the bottom of
>> the corrupt data issue.
>>
>> One question though: there is only one option in driver that will allow 
you
>> to delete entries, and that is de.  From what I gather, it deletes 
entries
>> based on field Id 1.  Is there any way to delete entries based on other
>> parameters OTHER than field Id 1?
>>
>> Thanks.
>>
>> Alex.
>>
>> 

___
>> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>>
>
>___

>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>=

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Server - Timestamp Issues generating random values

[Robert Molenda]

YUP One filter, only on submit, no run if (always runs), and only the
one set-field(s) action. Nothing else updates this field in the
workflow. (it is 'read' from but not during submit)

>From the original post incase it got lost in the 'timestamp' thread :)
>>
I am wondering if someone else has stumbled across this issue.

On a form, we created a "Create Date Copy" field and on Submit (no
run-if) a Filter will simply do a "Set Fields = $TIMESTAMP$" to this
field. This was done as a test to see how long the filters took to run,
and was never removed. 

As you might expect, normally there is only a 0 or 1 second difference
between the core field and this copy.

However since 2003 (that would be ARS 4.5) through today (and we're on
6.3, with 5.1.2 in between) intermittently, this "Create Date Copy"
value will differ by HOURS. The majority of time in the past (Create
Date Copy < Create Date) but also a few in the future (Create Date Copy
> Create Date)

They are always HOURS (plus or minus one second, but that is close
enough for me to say hour) and never anything else odd. (like 30
minutes, etc)

Over the years we only have 252 entries that have this condition out of
966538 tickets, but it is very confusing.
<<

So statically speaking that is akin to the "needle in the haystack" so
to say...

How we "stumbled" across this issue, is that very intermittently, our
OLA / SLA calculations are completely wrong. Looking at the data and
running the calculations that should have happened again, results in
correct data! Again this is normally by an even amount of HOURS. Since
all of the OLA / SLA filters use $TIMESTAMP$ it makes me really start to
wonder. The type of wonder that puts a knot in the stomach..

Thanks again for everyone's input!!! This is what this list is for :)

Thanks-n-advance; 
HDT Platform Incident / Problem Manager & Architect 
Robert Molenda 
IT OS PA 
Tel: +1 408 501 6310 
Fax: +1 408 501 2410 
Mobile: +1 408 472 8097 
[EMAIL PROTECTED] 
Quality begins with your actions.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Thursday, September 28, 2006 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server - Timestamp Issues generating random values

Robert,

RE:
"
> There are differences of up to 16 hours in these timestamps (system
created -create_date- versus our set-fields of TIMESTAMP) so that would
be a bunch of timeouts!
"

So your saying that you have a Date/Time field that is only set via a
filter set field action to a value of $ TIMESTAMP $ and that during a
single submit action that records 'Create Date' and this other field
end up being HOURS apart?  That seems very, very wrong to me. I have
no explanation for how that might even be possible other than a BUG. I
doubt that Filter Looping could be slow enough to not reach a
configured max filter or max filter depth in 16 hours.

Or are these TIMESTAMP values supplied by the client?
Could it be that you have some Clients out there that are configured
to be in a strange Time Zone? Are there any consistency about the
$USER$ values for the records that are off by hours?

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Integer date conversion in Business Object WebIntelligence

[Steve McDonald]

**
Hello all,
 
Just wondering if anyone has tackled the database stored integer for Remedy date fields to a human readable date?  If so, I'd love your help.  I figure with BO and Remedy being partners there would be something built in but I cant find it.

 
Steve
 
__20060125___This posting was submitted with HTML in it___

ARS 7 Tree View - Chunking or Similar

[Heider, Stephen]

List,

I created a test form that has Office, Person, and Computer Name.  I
imported 4000 records (computers).  All fields are indexed.  On a DO
form I added a Tree View pointing to this test form containing
computers.  When I refresh the table field and collapse all leaves (via
a button) it takes a very very long time to display.  I closed the WUT
after waiting about 3 minutes.  

I then changed the tree view to only display two levels (office and
person).  I closed the WUT after waiting 2 minutes.  When I changed the
tree view to only one level then it only took 2 seconds.  

For this particular purpose the new Tree View control is of little
value.  In order to get this to work additional field(s) will need to be
added to the DO forms, and the users will need to first select one or
more options from these additional fields before opening the tree view.
In which case, why use it? It seems like it is only useful for tiny
datasets.

The expected behavior was that ARS would only retrieve the first level
(150 offices).  And then only retrieve the Persons when I expand an
Office.  Apparently ARS is trying to retrieve all records at once.

I created a three-level character menu that displays the office, person,
computers.  When I open the menu it takes only 5 seconds.  

According to the documentation chunking is not directly supported in
Tree View tables fields.

Perhaps I am overlooking something.  Has anyone got this to work?

Thanks.

Stephen

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: How-to have a Mid-Tier Home page different from the Client Home page

[Carey Matthew Black]

Mathieu,

I think your missing the point of the Home Page. ( Or maybe wanting it
to be something it is not intended to be.)

In v6.3 the "Home Page" is a user preference. The user has ultimate
control over what form is their  individual starting point.

Also, from the User Tool the user may not even use a preference server
so you may have no opportunity to affect the form that they see
"first". Yes, the Mid-tier can "require" the user to use a preference
server, and yes in v7 you can force the user to use the ARS server as
a preference server too. However, until you get to v7 I will leave
those options for another day as they will not solve your inquiry
today. :)


There should be nothing "magical" about your system wide, default
"Home Page" form. However, it should be the main (maybe only) place
that you put things that ALL users of your system could use. The scope
of the audience for this form is special in that it really is for the
group "Public".


Maybe you could explain why you want a given user to be routed to two
different forms based on the client they are connecting with? ( It
might help us to make a better suggestion for you.)

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 9/28/06, Mathieu Pitre <[EMAIL PROTECTED]> wrote:

Hi all,

ARS6.3
HP-UX 11.11
Oracle 9.2.0.6

I would like to know if it is possible to have one Home page for the users
who use the Remedy Client and another home page for the Mid-Tier users.

If yes how should I config this because I have not found anything related
to this. Looks like as soon as you set an Home page it is applicable for
both the Client environment and the Web environment.

Mathieu Pitre

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Multi AR system servers V7

[Fannin, Teresa]

Is this possible?  I know you can have Multiple AR System servers on the same 
computer as long as they are installed in different directories.   But can you 
have Multiple AR System servers on the same computer and pointing to different 
Databases?  What I am trying to do is this.  Lets say I have a platform with AR 
System Server and I want to use the platform as a failover system for my 
Production AR System server.But that does not happen very often so I would 
also like to use this platform as a staging area to test before migrating to 
Production. So I was thinking if  I had multiple AR system servers installed on 
the one server but pointing to different db's I could use the server for 
multiple purposes.  Of course if I had to failover I would stop the staging 
testing. 
 
Platform  A  - AR System ONE   pointing to Platform B for its Database  

AR System TWO pointing to Platform C for its 
Database
 
Platform  B-  SQL Database  ONE 
Platform  C   -   SQL Database TWO
 
Teresa

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: driver.exe (Yet Another Driver Question): deleting entries

[Carey Matthew Black]

Alex,

I would approach the problem from a very different angle.

Make routine and potentially dangerous activities as easy as possible,
but leave room for verification steps in the process.

I would try to:

1) define the query that you want to use to delete the data from each from with.
2) Create an ARS form that holds the form and Query information in
character fields.
3) Use a filter and the "Application-Query-Delete-Entry 
" $PROCESS$ or Run Process action  to do the
dead.

4) If you want to review the records manually first, then use an
advanced Table field to point at the form(s) in question and review
the matching records first. then push the "Delete" button in the User
Tool.

Should not take to much effort to put together an "admin only" form to
hold the data and to be used as a UI for the display/delete of the
records too.


Now if you really need to automate this with the driver program. Then
write a form that you can use Driver to submit a record to. Have that
submit trigger filters that loop over the configured information and
deletes the data it finds "blindly". (I mean without a user review of
the data.)


Just be warned the first data row that you delete that you should not
have deleted... well... that will be a problem. So be sure that your
qualifications work, and are tested after every change. (Just a word
to the wise.)


--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 9/28/06, Alex Straph <[EMAIL PROTECTED]> wrote:

Over the last couple of months, six of our servers have been "invaded" with
several hundred entries each of dummy data over several forms.  This data
is causing performance issues so of course I have been tasked to find and
get rid of it.

The good news is that the corrupt entries have consistent data meaning that
I could use a search filter to weed out the data.  Earlier, I have been
manually removing entries myself, only to find that these entries have
risen from the ashes.  It has become a pain to do each an every single week
so I need to use a driver script to specify what to delete.  I have decided
on using a driver script as a temporary fix until I get to the bottom of
the corrupt data issue.

One question though: there is only one option in driver that will allow you
to delete entries, and that is de.  From what I gather, it deletes entries
based on field Id 1.  Is there any way to delete entries based on other
parameters OTHER than field Id 1?

Thanks.

Alex.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

driver.exe (Yet Another Driver Question): deleting entries

[Alex Straph]

Over the last couple of months, six of our servers have been "invaded" with 
several hundred entries each of dummy data over several forms.  This data 
is causing performance issues so of course I have been tasked to find and 
get rid of it.

The good news is that the corrupt entries have consistent data meaning that 
I could use a search filter to weed out the data.  Earlier, I have been 
manually removing entries myself, only to find that these entries have 
risen from the ashes.  It has become a pain to do each an every single week 
so I need to use a driver script to specify what to delete.  I have decided 
on using a driver script as a temporary fix until I get to the bottom of 
the corrupt data issue.

One question though: there is only one option in driver that will allow you 
to delete entries, and that is de.  From what I gather, it deletes entries 
based on field Id 1.  Is there any way to delete entries based on other 
parameters OTHER than field Id 1?

Thanks.

Alex.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

object-prop in def-file

[Shawn Stonequist]

Greetings List!!

We are currently investigating the "object-prop" line that appears at the
end of some workflow when reviewing the definitions. I was able to find this
old post from 5/2004, however, it references a URL that I can't access for
the answer. I am wondering if anyone would be able to assist?

Thx in advance!
Shawn Stonequist
EMNS, Inc.

On Wed, 19 May 2004 21:14:53 +0200, Misi Mladoniczky <[EMAIL PROTECTED]> wrote:

>Lori,
>
>Thank you very much, that helped!
>
>I have made a small program that compares def-file to find differences.
>
>I mask out some things from the comparison in order to make it useful. I.e.
>the modified by and modified date.
>
>I just wanted to make sure that I did not remove things that actually
>indicated real differences.
>
>I have found it useful to compare def-files after migrating/importing an
>application to a new server, just to make sure that nothing was missed.
>
>Best Regards - Misi, RRR AB, http://www.rrr.se
>
>ps. Apparently I have to improve my personal ARSLIST-ARCHIVE-SEARCH-
>Process... ds.
>
>> Misi:
>>
>> I found this old post.
>>
>> http://corp.elegantsp.com/pipermail/remedy/2001-April/027139.html
>>
>> -Lori
>>
>> * * * * * * * * * * * * * * * * * * * * * * * *
>> Lori Gumbiner
>> Walgreen Co.
>> Process Automation Initiatives
>> 847.914.5796
>>
>>
>> |-+>
>> | |   Misi Mladoniczky |
>> | |   <[EMAIL PROTECTED]> |
>> | |   Sent by: "Action |
>> | |   Request System   |
>> | |   discussion   |
>> | |   list(ARSList)"   |
>> | |   <[EMAIL PROTECTED]|
>> | |   ORG> |
>> | ||
>> | ||
>> | |   05/19/04 01:26 PM|
>> | |   Please respond to|
>> | |   arslist  |
>> | ||
>> |-+>
>>  >
>--|
>>  |
>>  | |   To:
>>  ARSLIST@ARSLIST.ORG
>>| |   cc:
>>  | |
>> Subject:  object-prop in def-file
>> |
>>  >
>--|
>>
>>
>>
>>
>> Hi All,
>>
>> Does anyone know what the object-prop:-lines in the definition file is?
>>
>> My problem:
>> - I start by exporting an AL from server A
>> - I then import it to server B
>> - Finally i export it again from server B
>>
>> The two resulting definition files differ by the object-prop-line at
>> the end of the AL.
>>
>> The object-prop does not seem to differ much between different objects
>> in the same definition file...
>>
>>Best Regards - Misi, RRR AB, http://www.rrr.se/sv/
>>
>>
>
>
>>
>> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
>> (Support: mailto:[EMAIL PROTECTED] ) ARSList is hosted by QMX SUPPORT
>> SERVICES at www.QMXS.com
>
>
>UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:[EMAIL PROTECTED] ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com
>=

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Read (floating) license

[Lucero, Michelle - IST contractor]

1.  Someone was correct, the User Tool works differently than the
Mid-Tier.  If logging into the User Tool, it does display
Read(Floating).  When logging into the Mid-Tier, it immediately takes up
a WRITE.

2.  However, in either case it still adheres to the Float Timeout
setting even with inactivity.

3.  We're not using an init-form as someone mentioned.

4.  Yep, we send out periodic reminders for our users to click "Logout"
instead of just closing the browser.

5.  Yep been through major license reviews.  In another custom-built
environment , we had to go through a licensing overhaul.  To make a long
story short, we had to make severe budget cuts.  We ended up reducing
our annual maintenance from 110k to about 18k.  The CFO (yes CFO) had a
talk with me and said "make it work".  Refusing to do anything illegal.
I re-interviewed the direct supervisors of a customer service group that
numbered around 220. It turns out that 200 out of 220 ALWAYS created a
new case with each customer contact, and never updated anyone else's
cases.  Obviously, those 200 received Read licenses.  The remaining 20
customer service supervisors shared Fixed and Floating with the
110-member tech support group.

Anyway, my take on this whole thing is that there is an issue with the
way floating licenses work.  It should at the very least work the same
way in the User Tool and the Mid-Tier.

My two cents,
Michelle

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
Sent: Thursday, September 28, 2006 5:50 AM
To: arslist@ARSLIST.ORG
Subject: Re: Read (floating) license

Hi Michelle

I have always recommended my clients opt for as many fixed licenses as
they
can, rather than using floating licenses, and this test just reinforces
that
opinion.

It looks like when estimating license requirements, you now need to
consider
how frequently occasional users log in to the system, rather than how
often
they need to modify a record. If they log in more than twice a week for
more
than an hour, they are a candidate for either a fixed or read license.
Only
users who are truly 'occasional' should have a floating license.

Also, there is a real training requirement here to make sure that
Mid-Tier
users log out correctly, rather than just closing the browser. Moving
more
users to the thin client will only exacerbates this problem.

A couple of years ago I did some work for a client where they had 24
hour
operations, with a couple of fully staffed shifts, and a graveyard shift
with fewer people at work.  Remedy had recommended and supplied all
floating
licenses as being 'ideal' for shift workers, but actually at shift
changeover time it was a nightmare with half the new shift being unable
to
work.  The solution was to change to all Fixed licenses, and all staff
could
be given a fixed license for the same overall cost.

Also, with good application design and using 'allow any user to submit'
field permissions, and submitter mode locked may allow many users to
operate
with a Read license... and then, if you have more than one Remedy
server,
the advantage of fixed licenses over floating is even more pronounced.

So you're in a situation where you're running out of floating licenses
and
need to buy some more.  Rather than buying say 10 extra floating
licenses,
consider buying 25 extra fixed ones and allocating them to your 25
heaviest
floating users.  This will probably free up more of your floating tokens
than the extra floating licenses would have given.

I have rarely seen a Remedy installation where a large number of
floating
licenses were really cost-effective - by all means have a few, but make
the
majority of your license fixed.

Just MHO.

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
Sent: Thursday, September 28, 2006 12:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Read (floating) license

Hi, David

There was a search menu on the Group field.  But, I had to test this
further.

Here I go beatin' a dead horse.

I created a display only form with not one single field, button,
workflow nor any other object.  I opened the form on the Mid-Tier with
my test floating license.  And again it immediately took up a Float
WRITE.  

It still doesn't flush after a few minutes, etc.

   
  /* Wed
Sep 27 2006 18:28:59.8080 */  FLOAT  GRANT WRITEclucero   (1 of 5
write)

Even if we accept the premise about search menus, etc...
Isn't it unrealistic to assume that a form would have absolutely no
workflow and absolutely no search menus? In other words, in almost all
cases, there will be a search menu, workflow o

Re: How-to have a Mid-Tier Home page different from the Client Home page

[L. J. Head]

**



Lets seeif I think through this...the Mid-Tier doesn't 
have an Init form...so you can't use that...but if you set the home page to the 
one you want for Mid-Tier as a defaultand then set an AL on the home page 
that checks for client type of 3 (WUT) that will open the alternate home page 
and close the default one...that may work...but it would break some of the 
things that are specifically associated with "Home Page" functionality...for 
instance...if they clicked the home page button twice it would open a second 
copy of the same form... which won't happen natively...but depending on what 
workflow you have in place you may not notice as much
 
L. J. HeadSoftware EngineerRemedy Approved 
Consultant 
 


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu 
PitreSent: Thursday, September 28, 2006 11:38 AMTo: 
arslist@ARSLIST.ORGSubject: Re: How-to have a Mid-Tier Home page 
different from the Client Home page
Ok but where am I supposted to use 
the Keyword? If I create an Active Link for instance on the Home Page. The 
Active link should be executed when a user login. If $CLIENT-TYPE$ = 9 then keep 
window open else close it. However, if the user wants to open (Manually) the 
Home page on the client it will always close. Is there any way to start the 
active link on the login?
Mathieu Pitre IT Business 
Systems AnalystProduction Operation Computer Sciences CorporationPratt & Whitney 
Canada, Plant 1Sametime: Mathieu Pitreoffice: 450-647-8008 
x7030This 
is a PRIVATE message. If you are not the intended recipient, please delete 
without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: 
Regardless of content, this e-mail shall not operate to bind CSC to any order or 
other contract unless pursuant to explicit written agreement or government 
initiative expressly permitting the use of e-mail for such 
purpose.

  
  
"L. J. Head" 
  <[EMAIL PROTECTED]> Sent 
  by: "Action Request System discussion list(ARSList)" 
   
  28/09/2006 12:17 PM 
  


  
Please respond 
toarslist@ARSLIST.ORG

  


  
To
  arslist@ARSLIST.ORG 

  
cc
  

  
Subject
  Re: How-to have a Mid-Tier Home 
page different from the Client Home page
  


  
  You could try doing something with $CLIENT-TYPE$ = 9 and set their 
home pageto one thing and then in the else set it to the other 
L. J. HeadSoftware EngineerRemedy Approved 
Consultant-Original Message-From: Action Request System 
discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu 
PitreSent: Thursday, September 28, 2006 9:48 AMTo: 
arslist@ARSLIST.ORGSubject: How-to have a Mid-Tier Home page different from 
the Client HomepageHi all,ARS6.3HP-UX 11.11Oracle 
9.2.0.6I would like to know if it is possible to have one Home page for 
the userswho use the Remedy Client and another home page for the Mid-Tier 
users.If yes how should I config this because I have not found anything 
related tothis. Looks like as soon as you set an Home page it is applicable 
for boththe Client environment and the Web environment.Mathieu 
Pitre___UNSUBSCRIBE 
or access ARSlist Archives at 
http://www.wwrug.org___UNSUBSCRIBE 
or access ARSlist Archives at 
http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Remedy V7 - Character Sets

[Barb Wagner]

**

Hi All

Does anyone know - with Remedy  V7 - if I need to have multiple character sets available (IE L1 - Latin 1 and TC - Traditional Chinese) besides having a unicode database installed and the appropriate character sets available  would I need to run more than one Instance of the ARS Server? Or as long as the character sets are available ... ARS will make the currect decision on what to use

Example: We need to have English, French, German and Traditional Chinese available ... the first 3 would be supported in L1, but we are going to need TC to support the Traditional Chinese

Anyone had any experience with this?

Thank you for any info you may have

Barb Wagner
__20060125___This posting was submitted with HTML in it___

Re: Filter Guides and Selected Fields in Notify

[Kemes, Lisa]

Thanks for the info about the AR System Email Messages form.  That was
very helpful.

Email is coming over without the Selected values as per the AR System
Email Messages form.

I found out why the selected fields are not coming through, it's all in
the Phase of when the notify fires.

I have an active link that is pushing 4 fields to a form (to create a
new record).

I then have a filter that kicks off a filter guide on Submit of this
form.

My filter guide now has two filters:
Filter A sets a column field to a temp field
Filter B sends the notify

Problem:
If Filter B gets set to Phase 1 (by putting the `! character in
the filter name), all members are notified, but no selected fields come
over.
If Filter B gets set to Phase 3 (by taking the `! Character out
of the filter name), only one member gets notified (the last one on the
table) and the selected fields DO come over.

Ugh...any ideas on how I can have the best of both worlds?  (each member
getting an email with the selected fields)  :)

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Wednesday, September 27, 2006 12:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Filter Guides and Selected Fields in Notify

Lisa,

All "Emails" generated by a Notify action become a record in the "AR
System Email Messages" form. That form is a queue used by the Email
Engine to read from and send emails out. (If there are errors then they
are also visible from there too.) However it is possible that your
"Mailbox Configuration" is also set to delete outgoing records too. So
you might have to check the corresponding "AR System Email Mailbox
Configuration" record too.

Out of curiosity...

What does your HTML template look like?
How do you include "all of the right fields" in the template? (When the
fields that are altered change based on the users interaction with the
record?)

Maybe you can send me that off ARSList?

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 9/27/06, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
> Carey, I'm really appreciating your help, but no luck
>
> All my temp fields have public permissions.
>
> I am using an email template (html) to format the outbound email.
>
> I'm not sure I understand about looking at the Email Messages record, 
> where would I find that?
>
> I now have my filter set to kick off on a modify, so it calls the 
> filter when there is a modification instead of on Submit.
>
> Again, I created another filter outside of the filter guide to kick 
> off as well (on modify) and the notify email comes over just fine.  
> (with the selected values.) Same fields, same everything
>
> I'm starting to think that Notify Selected values somehow get "lost" 
> in a filter within the filter guide?
>
> Lisa
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
> Sent: Wednesday, September 27, 2006 10:50 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Filter Guides and Selected Fields in Notify
>
> Lisa,
>
> Are you  by chance using an email Template to format the outbound
email?
>
> Your sure that the temporary fields passed this test too?
> "Fields have Public permissions"
>
> When you look at the Email Messages record "Advanced" look you should 
> see fields and values in the "Variable Replacement"(tab) and 'Field 
> Values' (field). Do you see them there at all?
>
>
> Can you try the following? Does it work?
>   Have your active link create the record then have it modify that 
> record to actually send the notification. Do the values show up then?
> If your active link can not modify the record then have the submit 
> filter do a push to the current record (in phase 2) to trigger a 
> modify and send the notifications then.
>
> --
> Carey Matthew Black
> Remedy Skilled Professional (RSP)
> ARS = Action Request System(Remedy)
>
> Love, then teach
> Solution = People + Process + Tools
> Fast, Accurate, Cheap Pick two.
>
>
> On 9/27/06, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
> > Already have the `! At the end of my filter (in the filter guide) 
> > and I also tried copying the field values to temporary fields and 
> > using THOSE fields in the "selected values" fields.  This is a 
> > stumper for
> me.
> >
> > -Original Message-
> > From: Action Request System discussion list(ARSList) 
> > [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
> > Sent: Tuesday, September 26, 2006 5:18 PM
> > To: arslist@ARSLIST.ORG
> > Subject: Re: Filter Guides and Selected Fields in Notify
> >
> > Lisa,
> >
> > Name the filter in the guide such that it ends in a `! (that is a 
> > back
>
> > tick and an exclamation mark)
> >
> > ( The notify action is a "Phase 3" action and y

Re: Break out Member List from AP:Role form (Approval Server)?

[Thad Esser]

**

Rebecca,

It is what it would like in a set fields
of a filter.  For my setup, I have a filter guide on the SHR:People
form that when triggered, goes through all the forms and deletes the users
or updates records associated with them as appropriate.  In the case
of AP:Role, I push a value to a "Command field" (display only
char field) on the AP:Role form, where a filter detects that and does the
set fields below.  Specifically:

--- The "Delete Person" filter
guide searches the AP:Role form for roles where the Login Name is the only
value in the member list, and then displays an error if it finds any,
--- Having passed the above, the next
filter pushes to the AP:Role form:
     Push If:
        (
'Member List' LIKE (( "%"  + $Login Name$) +  "%"
)) AND ( 'Status' = "Active")
           
    If none, take no action.  If any, modify all.
     Command = "REMOVE-USER-FROM-MEMBER-LIST
" + $Login Name$
     Change History =
(($Full Name$ +  " (") + $Login Name$) +  ") is
being removed from Remedy and has been removed from the list of approvers
for this role."

Then over on the AP:Role form, I have
the following filter on Modify:
Run If:
         'Command'
LIKE  "REMOVE-USER-FROM-MEMBER-LIST %"
--- Action 1, Set Fields:
        Command
= ( ";" + REPLACE($Command$,
 "REMOVE-USER-FROM-MEMBER-LIST ",  "")) +
 ";"
        Member
List = ( ";" + $Member
List$) +  ";"
(parses the login name out of the command
field and adds semi-colons so we can avoid partial matches, e.g. jdoening
matching when trying to remove jdoe)

--- Action 2, Set Fields:
        Member
List = REPLACE($Member List$, $Command$,
 ";")
(pulls out the login name, replacing
it with a semi-colon so that login names are still separated properly)

--- Action 3, Set Fields:
        Member
List = SUBSTR($Member List$, 1,
LENGTH($Member List$) - 2)
(cuts off the leading and trailing semi-colons
that we added in action 1 to make our search easier)

I hope that clarifies things for you.
 
Thad
"Perfection is achieved, not when there is nothing more to add, but
when there is nothing left to take away."
- Antoine de Saint-Exupéry





"Rebecca Hammond"
<[EMAIL PROTECTED]> 
Sent by: "Action Request System
discussion list(ARSList)" 
09/28/2006 06:44 AM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Re: Break out Member List from AP:Role
form (Approval Server)?








I may not have had enough coffee this morning...but
this, below, is what it 
would look like in a piece of Remedy workflow, or a SQL command at the
DB 
level (or both)?

On Wed, 27 Sep 2006 10:36:40 -0700, Thad Esser <[EMAIL PROTECTED]>
wrote:

>Try:
>
>REPLACE($Member List$, $Login Name$,  "")
>followed by
>REPLACE($Member List$, ";;",  ";")
>
>(you could combine them into one if you wanted)
>
>Thad
>"Perfection is achieved, not when there is nothing more to add,
but when 
>there is nothing left to take away." - Antoine de Saint-Exupéry
>
>
>
>"Rebecca Hammond" <[EMAIL PROTECTED]> 
>Sent by: "Action Request System discussion list(ARSList)"

>
>09/27/2006 10:28 AM
>Please respond to
>arslist@ARSLIST.ORG
>
>
>To
>arslist@ARSLIST.ORG
>cc
>
>Subject
>Break out Member List from AP:Role form (Approval Server)?
>
>
>
>
>
>
>Hi all!
>
>I'm going through the process of trying to remove a whole bunch (hundreds)

>
>of People/User records - these are people who no longer work in my

>organization.
>
>I know if I use the App. Config. Console, this will blow the users
out of 
>places like SHR:Assignment.  However, I've found that there can
be 
>problems 
>if a user is deleted but their login name is still listed as part of
a 
>Member List in the AP:Role form.  In there, the login is stored
with other 
>
>members of the role, separated by a ;
>
>Does anyone have any tricks for editing the AP:Role records when a
User 
>account is deleted?
>
>Thanks!
>
>___

>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>
>
>***IMPORTANT NOTICE: This communication, including any attachment,

contains information that may be confidential or privileged, and is 
intended solely for the entity or individual to whom it is addressed.  If

you are not the intended recipient, you should delete this message and
are 
hereby notified that any disclosure, copying, or distribution of this 
message is strictly prohibited.  Nothing in this email, including
any 
attachment, is intended to be a legally binding signature.***
>
>___

>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is address

Re: How-to have a Mid-Tier Home page different from the Client Home page

[Mathieu Pitre]

Ok but where am I supposted to use the
Keyword? If I create an Active Link for instance on the Home Page. The
Active link should be executed when a user login. If $CLIENT-TYPE$
= 9 then keep window open else close it. However, if the user wants to
open (Manually) the Home page on the client it will always close. Is there
any way to start the active link on the login?
 
Mathieu Pitre

IT Business Systems Analyst
Production Operation
 Computer
Sciences Corporation
Pratt & Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office: 450-647-8008 x7030



This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.







"L. J. Head"
<[EMAIL PROTECTED]> 
Sent by: "Action Request System
discussion list(ARSList)" 
28/09/2006 12:17 PM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Re: How-to have a Mid-Tier Home page
different from the Client Home page








You could try doing something with $CLIENT-TYPE$ =
9 and set their home page
to one thing and then in the else set it to the other 


L. J. Head
Software Engineer
Remedy Approved Consultant
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Thursday, September 28, 2006 9:48 AM
To: arslist@ARSLIST.ORG
Subject: How-to have a Mid-Tier Home page different from the Client Home
page

Hi all,

ARS6.3
HP-UX 11.11
Oracle 9.2.0.6

I would like to know if it is possible to have one Home page for the users
who use the Remedy Client and another home page for the Mid-Tier users.

If yes how should I config this because I have not found anything related
to
this. Looks like as soon as you set an Home page it is applicable for both
the Client environment and the Web environment.

Mathieu Pitre


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

OT: ARS => Oracle 10gR2 RAC + ASM

[Tony Worthington]

**

All -

We're in the process of building our
new production systems, and am interested in hearing feedback from folks
who use ARS against Oracle 10gR2 in a clustered RAC environment + Automated
Storage Management.

ARS version or OS isn't so important
as I'm more concerned with installation gotcha's, lessons learned, etc.
that are specific to the ARS+RAC+ASM environment.

Our Oracle environment will be on Linux/RHAS,
and the AR/Mid-Tier (7.x) will live in the Win2k3 world.

Has anyone installed Remedy local to
their RAC cluster and used OCSF for their AR install?  (I can't see
how this would be possible, given the AR license restrictions/ties.)

I do see on supportweb that an AR install
to ASM is supported, by using the +diskgroup/dir/file.dbf syntax -- but
I've not yet had the opportunity to test it.

Comments/suggestions/warnings?

Thanks,

-tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
__20060125___This posting was submitted with HTML in it___

Re: midtier RPC errors

[Hall Chad - chahal]

**








We had sporadic
RPC errors from Mid Tier a while back (Windows 2003 in a DMZ). Looking at the
firewall logs showed it was attempting to connect to AR Server on port 111
(portmapper) instead of the specific port we had it configured to use. Remedy
suggested adding the “ARTCPPORT” environment variable on the Mid
Tier server to force it to use a specific port. Since then we’ve never had
the problem again. Make sure you create a System environment variable and not a
User variable. 

 

For example, to
force Mid Tier to use port 9000 you would add the following environment
variable:

 

Variable Name:      ARTCPPORT

Variable Value:  9000

 



Chad Hall  
(501) 342-2650











From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Monday, September 25, 2006
3:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: midtier RPC errors



 

We've been having the same problems. 
It's quite frustrating.  We've even pointed to another server for our Mid
Tier and it still happens. (on SOME of the forms, SOME of the time). 
Seems to be when we do a "Search" on the form.  

 

We've submitted a ticket to Remedy and
they say to update to patch 18 (I see that you are already at patch 18).  

 

It will be interesting to see what Remedy
tells you to do.  

 

 







From: Action
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, Jamie
Sent: Monday, September 25, 2006
4:29 PM
To: arslist@ARSLIST.ORG
Subject: midtier RPC errors
Importance: High

** 



Ok, I dug in the knowledgebase,
documentation and ARList archives.  There's very little that addresses what
I have happening.  On some forms, SOME of the time, I'm getting the
following errors.  These forms all have tables.  





Fortunately we are in development mode now
and finalizing code changes to upgrade from 5.0 to 6.3.  We've have
fantastic success on the client side and for the most part on the
midtier.  Except for what you see below.  We are getting intermittent
RPC errors (arerr 91).





AR 6.3 patch 18





Oracle 10.2.0.1 (w/9.2 library files)





HPUX 11.11





Midtier 6.3 patch 18





Microsoft IIS ServletExec/5.0p06





Windows 2000 (have no idea on the patches,
should be up to date)





Java Version 1.5.0_01





 





Any ideas?!?!?!





 





Thanks,





Jamie Blodgett





Rinker Materials





 





 





Here's a snip from the midtier log:





 





Sep 25, 2006 4:18:47 PM
com.remedy.arsys.support.Log log 
SEVERE: GoatException during NDXRequest: 
ARERR [91] RPC call failed : RPC: Procedure unavailable 
at com.remedy.arsys.backchannel.TableEntryListBase.doQuery(Unknown Source) 
at com.remedy.arsys.backchannel.TableEntryListBase.getAndEmitTable(Unknown
Source) 
at com.remedy.arsys.backchannel.GetTableEntryListAgent.process(Unknown Source) 
at com.remedy.arsys.backchannel.NDXRequest.(Unknown Source) 
at com.remedy.arsys.backchannel.EntryListBase.(Unknown Source) 
at com.remedy.arsys.backchannel.TableEntryListBase.(Unknown Source)

at com.remedy.arsys.backchannel.NDXGetTableEntryList.(Unknown
Source) 
at com.remedy.arsys.backchannel.GetTableEntryListAgent.(Unknown
Source) 
at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) 
at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) 
at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) 
at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 
at
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)

at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)

at
com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)

at
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1827)

at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:919)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1002)

Caused by: 
MessageType: 2
MessageNum: 91
MessageText: RPC call failed
AppendedText: RPC: Procedure unavailable 
at com.remedy.arsys.api.Proxy.FindAndIterate(Native Method) 
at com.remedy.arsys.api.EntryFactory.findAndIterate(EntryFactory.java:331) 
... 21 more 





 





 





 





 





CONFIDENTIALITY: The information contained in this transmission may contain
privileged and confidential information. It is intended only for the use of the
person(s) named above. If you are not the intended recipient, you are hereby
notified that any review, dissemination, distribution or duplication of this
communication, and the information contained in it, is strictly prohibited. If
you are not the intended recipient, please contact the sender and i

Anybody use Consulting-Portal ( http://www.consulting-portal.com)

[Covert, Jack]

**



Hi all, has anybody 
used Consulting-Portal before?  Their site is located @ http://www.consulting-portal.com.  
If you have any information about this company, could you please email me 
offline @ [EMAIL PROTECTED].  
Thanks!!!
 
Jack
__20060125___This posting was submitted with HTML in it___

Passing Work Log

[Tom L]

Does anyone know how to access the entire Work Log with Remedy
workflow?

I am running ARS 6.3 w/ Oracle 9.2, Help Desk 6.0, and we have
integrated Pinnacle. When an existing case is reassigned to a
particular group, we create a case in Pinnacle and passing some key
information using Remedy workflow. With this case creation, it appears
that Remedy will only pass the last Work Log entry. I need to pass the
entire Work Log. Has anyone ever do something like this or does anyone
know how to access all text in a CLOB type within Remedy? Thanks much.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Server - Timestamp Issues generating random values

[Carey Matthew Black]

Robert,

RE:
"

There are differences of up to 16 hours in these timestamps (system created 
-create_date- versus our set-fields of TIMESTAMP) so that would be a bunch of 
timeouts!

"

So your saying that you have a Date/Time field that is only set via a
filter set field action to a value of $ TIMESTAMP $ and that during a
single submit action that records 'Create Date' and this other field
end up being HOURS apart?  That seems very, very wrong to me. I have
no explanation for how that might even be possible other than a BUG. I
doubt that Filter Looping could be slow enough to not reach a
configured max filter or max filter depth in 16 hours.

Or are these TIMESTAMP values supplied by the client?
Could it be that you have some Clients out there that are configured
to be in a strange Time Zone? Are there any consistency about the
$USER$ values for the records that are off by hours?

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

CMDB/DSL - Product Class vs. Software Class

[Cindy Sapochetti]

Hi all, 

I'm posting this to Remedy support as well, but does anyone understand why 
the class the  DSL "products" are in is the "Products" class and not 
the "Software" class?  

For example, if you install the sample data, there are a few Computer 
systems created - a Unix server and a Desktop system.  Both of these 
instances reside in the "Computer System" class, and the products hierarchy 
they are created from starts with Computer System.

Yet, if you want to create an instance of what is really a Software CI 
(software asset installation which would be related to a computer, for 
example), you have to create it in the "Product" class if you want to use 
any of the DSL entries.

Does anyone have any insight on this? 

Thanks, 
Cindy

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Server - Timestamp Issues generating random values

[Robert Molenda]

The base fact (known to be 100% true) is that TIMESTAMP and
SERVERTIMESTAMP in a FILTER will always be the same.

I also considered possible timeouts in PROCESS functions, we have ours
set to 60 (seconds) because of some external AD processing done at
times. Of course there are a lot of 'business time calculations'
performed at submit of a ticket as well, which we all know are a "set
fields from PROCESS", but even if everything timed out, we would need 60
of these to fail to get to an hour. There are differences of up to 16
hours in these timestamps (system created -create_date- versus our
set-fields of TIMESTAMP) so that would be a bunch of timeouts!

**GASP** what if the documentation is wrong? Set process timeout is not
seconds but MINUTES? **GASP** naw that could not be true :)

Also, please remember that we see differences that are "before and
after" the create_date.

That wonderful warping of "space and time"...

Good suggestion about the PROCESS functions though,!!

Thanks-n-advance; 
HDT Platform Incident / Problem Manager & Architect 
Robert Molenda 
IT OS PA 
Tel: +1 408 501 6310 
Fax: +1 408 501 2410 
Mobile: +1 408 472 8097 
[EMAIL PROTECTED] 
Quality begins with your actions.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Thursday, September 28, 2006 7:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server - Timestamp Issues generating random values

Robert,

I think your expectations are a bit off...

First a few general statements.
1) All Date/Time fields in ARS are really "epoch GMT integer values".
( If you do not know what the means, try google, or
http://en.wikipedia.org/wiki/Unix_time  :)

2) All Date/Time field displayed values in the User Tool UI is
localized by the client.


So...

When an active link "Returns" the SERVERTIMESTAMP then only "drift"
you should see between TIMESTAMP and SERVERTIMESTAMP should be the
same drift that exists between your client clock and the ARS server
clock. If both are set off of the net (AKA Atomic clocks) then the
values should be fairly close if not exactly the same.

So just for giggle let me walk you through what I think your first
test did not test...

You defined the test as this:
"
Active Link: (on button click)
>
> Char 1 & Date/Time 1 = TIMESTAMP
> Char 2 & Date/Time 2 = SERVERTIMESTAMP
"

When the Client sees TIMESTAMP it grabs the local client PC time
(again in "epoch GMT") and uses the Client settings to localize and
format the value for the 'Char 1' field. For the 'Date/Time 1' field
it simply sets the "epoch GMT" value and lets the field widget do the
localization and formatting for the display.

When the Client sees SERVERTIMESTAMP it talks to the ARS server and
grabs the  SERVER time (again in "epoch GMT") and uses the Client
settings to localize and format the value for the 'Char 2' field. For
the 'Date/Time 2' field it simply sets the "epoch GMT" value and lets
the field widget do the localization and formatting for the display.


Do you see how the displayed values really should be the same?



Now the filter processing time is a bit different so let me walk
through a bit of the "black processing box" that I think (AKA: I am
guessing) the ARS server goes through:

There is a small amount of time that it takes for the client to send
the "CreateEntry" API call from client to server. So any client
TIMESTAMP in "epoch GMT" value is slightly altered already relative to
what the current SERVERTIMESTAMP value is when the API call reaches
the server. Sure we are splitting seconds here, but it could be that
the network lag is such that this small gap of time spans a demark
between one second and the next too. Then the ARS server fixes the
value of SERVERTIMESTAMP/TIMESTAMP  for the entire filter processing.
(Because in truth it takes some time for the server to process each
and every filter/action with possible multiple layers of pushs,
messages to be queued, data base interactions ect...) So for the life
of the filter processing I THINK (again, guessing) that those values
are not really a now() type function, but just a reference to a static
value set at the beginning of the processing.  [ And before you get
the idea that this is "BAD", I actually think it almost has to be done
this way for performance and for consistency.] However, the System
fields values may not be set to this predefined value. It is possible
that just before the final commit to the DB that the ARS server does
do a second now() function and would show the "lag" in time due to the
network/filter processing in the differences between values supplied
by the client, beginning of the Filter processing and the actual end
of the filter processing time.


I hope that helps explain my thinking on the topic.

But all in all... I do not see a problem with what you have documented.


Just as a point of reference...
Some of our submit processing calls $PROCESS$ commands and can delay
the subm

Arlogtmr 6

[PC Wai]

Title: Arlogtmr 6
**






Hi,


I am having problem to use the log timer 6! Does anyone get it working?


Regards

PC Wai




__20060125___This posting was submitted with HTML in it___

Re: How-to have a Mid-Tier Home page different from the Client Home page

[L. J. Head]

You could try doing something with $CLIENT-TYPE$ = 9 and set their home page
to one thing and then in the else set it to the other 


L. J. Head
Software Engineer
Remedy Approved Consultant
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Thursday, September 28, 2006 9:48 AM
To: arslist@ARSLIST.ORG
Subject: How-to have a Mid-Tier Home page different from the Client Home
page

Hi all,

ARS6.3
HP-UX 11.11
Oracle 9.2.0.6

I would like to know if it is possible to have one Home page for the users
who use the Remedy Client and another home page for the Mid-Tier users.

If yes how should I config this because I have not found anything related to
this. Looks like as soon as you set an Home page it is applicable for both
the Client environment and the Web environment.

Mathieu Pitre


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: How-to have a Mid-Tier Home page different from the Client Home page

[Brian Goralczyk]

**
Off the top of my head, you could use the init form to shove User Tool users to a different homepage.Just an idea.HTH,Brian GoralczykOn 9/28/06, 
Mathieu Pitre <[EMAIL PROTECTED]> wrote:
Hi all,ARS6.3HP-UX 11.11Oracle 9.2.0.6I would like to know if it is possible to have one Home page for the userswho use the Remedy Client and another home page for the Mid-Tier users.
If yes how should I config this because I have not found anything relatedto this. Looks like as soon as you set an Home page it is applicable forboth the Client environment and the Web environment.
Mathieu Pitre___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__20060125___This posting was submitted with HTML in it___

Re: ARS 7.0 Patch 2 Table Fields Sort Bug - Workaround

[Heider, Stephen]

Update:

After further research and testing it seems to occur when there are
character fields on the form that are larger than 255 characters.  When
I change the field length to 255 or less the columns reappear in the
Sort/Levels tab.  I was able to reproduce this using ARS 7.0 Patch 1 as
well as Patch 2.

Workaround: Delete the character fields that are larger than 255
characters. Save.  Add new characters fields (with the same IDs if
workflow is attached) with the previous lengths.  Changing the length of
the fields to 255, then saving, then changing it back didn't fix it.

Note: I have only tested this on display-only forms. For regular forms
or any form with data you would need to first store the contents of the
character fields (> 255) in other new fields before deleting the problem
fields.

I have reported this as a bug to our support vendor. 


Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Thursday, September 28, 2006 9:55 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7.0 Patch 2 Table Fields Sort Bug

ARS 7.0 p2
Windows Server 2003
SQL Server 2005

I think I found a bug with Table fields in ARS 7.0 Patch 2.  It works on
another computer with Patch 1.

On the Sort/Levels tab of a table's Field Properties window not all
columns are visible/available...only on Display Only forms. On Regular
forms all columns [in the source form] 255 characters or less are
visible, as they should.

I even tried copying a table field originally created on a Regular form
to a Display Only form.  Most of the sort columns are no longer visible
on the DO form.  I tried List View and Tree View display types.

Has anyone else experienced this?

 
Stephen


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

How-to have a Mid-Tier Home page different from the Client Home page

[Mathieu Pitre]

Hi all,

ARS6.3
HP-UX 11.11
Oracle 9.2.0.6

I would like to know if it is possible to have one Home page for the users 
who use the Remedy Client and another home page for the Mid-Tier users.

If yes how should I config this because I have not found anything related 
to this. Looks like as soon as you set an Home page it is applicable for 
both the Client environment and the Web environment.

Mathieu Pitre

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

ADM:Please Ignore, timing test

[[EMAIL PROTECTED]]

just one of those annoying timing test

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Read (floating) license

[Misi Mladoniczky]

Hi David,

I definitely think that you should analyze your users to find out what the
correct mix are for your specific company. To choose fixed licenses before
float may not be the best course of action.

The best mix for you could be 10% FIXED and 90% FLOAT, or the reverse
could be true.

Use the FREE version of rrrLic to find out the best mix for your specific
company. The only thing you need is at least one week of user log-file.

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

> Hi Michelle
>
> I have always recommended my clients opt for as many fixed licenses as
> they
> can, rather than using floating licenses, and this test just reinforces
> that
> opinion.
>
> It looks like when estimating license requirements, you now need to
> consider
> how frequently occasional users log in to the system, rather than how
> often
> they need to modify a record. If they log in more than twice a week for
> more
> than an hour, they are a candidate for either a fixed or read license.
> Only
> users who are truly 'occasional' should have a floating license.
>
> Also, there is a real training requirement here to make sure that Mid-Tier
> users log out correctly, rather than just closing the browser. Moving more
> users to the thin client will only exacerbates this problem.
>
> A couple of years ago I did some work for a client where they had 24 hour
> operations, with a couple of fully staffed shifts, and a graveyard shift
> with fewer people at work.  Remedy had recommended and supplied all
> floating
> licenses as being 'ideal' for shift workers, but actually at shift
> changeover time it was a nightmare with half the new shift being unable to
> work.  The solution was to change to all Fixed licenses, and all staff
> could
> be given a fixed license for the same overall cost.
>
> Also, with good application design and using 'allow any user to submit'
> field permissions, and submitter mode locked may allow many users to
> operate
> with a Read license... and then, if you have more than one Remedy server,
> the advantage of fixed licenses over floating is even more pronounced.
>
> So you're in a situation where you're running out of floating licenses and
> need to buy some more.  Rather than buying say 10 extra floating licenses,
> consider buying 25 extra fixed ones and allocating them to your 25
> heaviest
> floating users.  This will probably free up more of your floating tokens
> than the extra floating licenses would have given.
>
> I have rarely seen a Remedy installation where a large number of floating
> licenses were really cost-effective - by all means have a few, but make
> the
> majority of your license fixed.
>
> Just MHO.
>
> David Sanders
> Remedy Solution Architect
> Enterprise Service Suite @ Work
> ==
> ARS List Award Winner 2005
> Best 3rd party Remedy Application
>
> tel +44 1494 468980
> mobile +44 7710 377761
> email [EMAIL PROTECTED]
>
> web http://www.westoverconsulting.co.uk
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
> contractor
> Sent: Thursday, September 28, 2006 12:46 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Read (floating) license
>
> Hi, David
>
> There was a search menu on the Group field.  But, I had to test this
> further.
>
> Here I go beatin' a dead horse.
>
> I created a display only form with not one single field, button,
> workflow nor any other object.  I opened the form on the Mid-Tier with
> my test floating license.  And again it immediately took up a Float
> WRITE.
>
> It still doesn't flush after a few minutes, etc.
>
>
>   /* Wed
> Sep 27 2006 18:28:59.8080 */  FLOAT  GRANT WRITEclucero   (1 of 5
> write)
>
> Even if we accept the premise about search menus, etc...
> Isn't it unrealistic to assume that a form would have absolutely no
> workflow and absolutely no search menus? In other words, in almost all
> cases, there will be a search menu, workflow on window open or loaded, a
> table field or something?
> Meaning a FLOAT GRANT WRITE will almost always be taken up upon log on.
> So far in my testing, it is 100% of the time.
>
> In my experience it doesn't drop off after 5-10 minutes of activity.  It
> either expires after the admin defined float license timeout or drops
> off when I click Logout.
>
> I think that if one isn't suppose to be granted a WRITE until after some
> sort of activity (and the behavior clearly doesn't work this way) then
> this is definitely an issue.
>
> OK, OK, I'll leave it alone.  Thanks for listening.
>
> Michelle
> PS  Remember we all could be experiencing different behaviors on
> different versions.
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
> Sent: Wednesday, September 27, 2006 5:32 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Read (floating) license
>
> Hi Michelle
>
> I think that if the form

Midtier jsessionid interfering with a portal page?

[Reiser, John J]

Hello Listers,

AppServer
ARS 6.3 Patch3 
MidTier 6.3 
Windows 2000

DBServer
MS SQL2000
Windows 2000

I have been having problems with a Midtier implementation when accessing
it from the corporate portal web site.
The short story is that the active links stop functioning in Midtier
when the portal page launches an ARS Form.
After confirming that the AL's work when I make my home page something
else I convinced the portal admins to hear my request.

They answered: "The next question I wanted to ask him was if he knew the
domain setting for his JSESSION cookie.  If it is not specific to his
application, it could be getting confused with ours.  We changed the
domain of ours to run within "portal.global.corporate.com" instead of
just "corporate.com" where it was getting confused."

I've seen references to the jsessionid in Midtier logs but they are
usually session id numbers.

How can I find out about this cookie? 
As always I know just enough to get around but not enough to fix these
web browser issues.

Thanks,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
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 
 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Server - Timestamp Issues generating random values

[Carey Matthew Black]

Robert,

I think your expectations are a bit off...

First a few general statements.
1) All Date/Time fields in ARS are really "epoch GMT integer values".
( If you do not know what the means, try google, or
http://en.wikipedia.org/wiki/Unix_time  :)

2) All Date/Time field displayed values in the User Tool UI is
localized by the client.


So...

When an active link "Returns" the SERVERTIMESTAMP then only "drift"
you should see between TIMESTAMP and SERVERTIMESTAMP should be the
same drift that exists between your client clock and the ARS server
clock. If both are set off of the net (AKA Atomic clocks) then the
values should be fairly close if not exactly the same.

So just for giggle let me walk you through what I think your first
test did not test...

You defined the test as this:
"
Active Link: (on button click)


Char 1 & Date/Time 1 = TIMESTAMP
Char 2 & Date/Time 2 = SERVERTIMESTAMP

"

When the Client sees TIMESTAMP it grabs the local client PC time
(again in "epoch GMT") and uses the Client settings to localize and
format the value for the 'Char 1' field. For the 'Date/Time 1' field
it simply sets the "epoch GMT" value and lets the field widget do the
localization and formatting for the display.

When the Client sees SERVERTIMESTAMP it talks to the ARS server and
grabs the  SERVER time (again in "epoch GMT") and uses the Client
settings to localize and format the value for the 'Char 2' field. For
the 'Date/Time 2' field it simply sets the "epoch GMT" value and lets
the field widget do the localization and formatting for the display.


Do you see how the displayed values really should be the same?



Now the filter processing time is a bit different so let me walk
through a bit of the "black processing box" that I think (AKA: I am
guessing) the ARS server goes through:

There is a small amount of time that it takes for the client to send
the "CreateEntry" API call from client to server. So any client
TIMESTAMP in "epoch GMT" value is slightly altered already relative to
what the current SERVERTIMESTAMP value is when the API call reaches
the server. Sure we are splitting seconds here, but it could be that
the network lag is such that this small gap of time spans a demark
between one second and the next too. Then the ARS server fixes the
value of SERVERTIMESTAMP/TIMESTAMP  for the entire filter processing.
(Because in truth it takes some time for the server to process each
and every filter/action with possible multiple layers of pushs,
messages to be queued, data base interactions ect...) So for the life
of the filter processing I THINK (again, guessing) that those values
are not really a now() type function, but just a reference to a static
value set at the beginning of the processing.  [ And before you get
the idea that this is "BAD", I actually think it almost has to be done
this way for performance and for consistency.] However, the System
fields values may not be set to this predefined value. It is possible
that just before the final commit to the DB that the ARS server does
do a second now() function and would show the "lag" in time due to the
network/filter processing in the differences between values supplied
by the client, beginning of the Filter processing and the actual end
of the filter processing time.


I hope that helps explain my thinking on the topic.

But all in all... I do not see a problem with what you have documented.


Just as a point of reference...
Some of our submit processing calls $PROCESS$ commands and can delay
the submit process to take up to about 30 seconds without failing due
to a timeout error. We will routinely see 'Create Date' values that
differ from the "timestamp" that is supplied by the client in a
different field by what we believe to be about the duration of the
$PROCESS$ run time length for that record. (AKA: 10 or more seconds
different.) So I am fairly sure that the value that is stuffed into
'Create Date' is set at the last possible instant in the ARS Server
and is NOT the TIMESTAMP value that I believe it holds as a constant
throughout the Filter processing.

( Yes all of this is very subtle details in the ARS server, but they
can be important to understand all the same. To bad we do not have
better docs to base our understanding on. But Trial and error,
testing, and a few guesses are the best we have at this point. :)

HTH.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 9/27/06, Robert Molenda <[EMAIL PROTECTED]> wrote:

**


My understanding of 'Timestamps' was… (including a quick re-read of the
basic admin pdf which does not say to much about this)



Filters: TIMESTAMP will always equal SERVERTIMESTAMP because it is executing
on the server, and is not aware of the client in any fashion.


Active Links: TIMESTAMP = Localized Time at the client where-as
SERVERTIMESTAMP = the server timestamp (not localized)

Re: passing ipconfig information

[barbourb . ctr]

**








Thanks all for the information.  It ended
up being I had to put the 

 In the header instead of the footer.

Issue resolved.

Thanks again.

 









From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Grooms, Frederick W
Sent: Thursday, September 28, 2006
9:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: passing ipconfig
information



 

Try them 1 at a time to see which is
causing you problems.  I am on Sun (with Apache/Tomcat) and they work for
me.  I take it that you are using Windows IIS with ServletExec.  I
also should have added for #3 that the AL
should have  $CLIENT-TYPE$ = 9  for it's Run-If.

 

Fred

 







From: Action
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 27,
2006 6:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: passing ipconfig
information

** 

I am getting a Caught exception:Object expected
error when running this. 

In the get_client_info.jsp page is there
any other syntax that needs to be in the file?

Any ideas?

Thanks

 









From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 27,
2006 5:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: passing ipconfig
information



 

This is from an old thread "Mid-Tier
6.3 - Get IP Address and Host Name":

1. Create a file in the same folder as
login.jsp named get_client_info.jsp with the following contents:



 



function env_RemoteAddr() {
  return ("<%=request.getRemoteAddr()%>"); }



 



function env_RemoteHost() {
  return ("<%=request.getRemoteHost()%>"); }



 



function env_RemoteUser() {
  return ("<%=request.getRemoteUser().replace('\\', '
')%>"); }



 






2. Add the following code to the footer
properties of the form (Form -> Current View -> Properties
->Appearance -> Edit Web Footer Content):





 







 




3. Add the following AL Run Process command to
the form as needed (Replace the field IDs with your IDs):



 



_javascript_:window.F(536870976).DoSet(env_RemoteAddr());
_javascript_:window.F(536870977).DoSet(env_RemoteHost());
_javascript_:window.F(536870978).DoSet(env_RemoteUser());

Fred

 







From: Action
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, September 27,
2006 3:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: passing ipconfig
information

** 

Has anyone passed the ip address and the
mac address of a client machine from the midtier?  This did work for the
thick client but the midtier errors out.

 









From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Frank Caruso
Sent: Tuesday, September 19, 2006
1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: passing ipconfig
information



 

** This works from the
client. Create an active link that does a set fields $PROCESS$ into a field:

$PROCESS$ cmd /c ipconfig /all

However, you get a large block of text that is not fomratted very well.



On 9/19/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]
> wrote:



** 





All,

Has
anyone through a Run Process or maybe another method to run an  ipconfig
/all on a client pushing the information from the output to a field within a
Remedy form?  Any ideas would be appreciated.

Thanks,

Brandi

 

Windows
2000 Server

SQL
2000 

 ARS
6.3

 














__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Consuming Web Services - A Solution Not A Question !!

[Clements, Paul]

Title: Consuming Web Services - A Solution Not A Question !!
**






Hi,

A few weeks ago I posed a question about Remedy’s inability to deal with complex WSDL’s. By this I meant WSDL’s which import others. Remedy only currently appears to like a WSDL which makes no calls to other WSDL’s or XDS’s. Finally after some help from a .Net specialist we have found a solution:

·   Roll up all the WDSL’s and XSD’s into a vb class using the wsdl.exe process within Visual Studio

·   Create a new web service in .Net which essentially wraps the original service which is contained within the vb class

This means that we are now dealing with a WSDL which is all inclusive…ie has no imports. The web service which wraps round the original one deals with all the actual calls to the methods and shields us from the issues which Remedy had with it. The new web service can be loaded into Remedy and works as needed.

Cheers,

Paul Clements

IT Professional Officer

Glasgow City Council 

Centenary House

100 Morrison Street

Glasgow G5 8LN

Phone: 0141 418 1332

Email:  [EMAIL PROTECTED]

Web: www.glasgow.gov.uk





Support Scotland's Bid to host the 2014 Commonwealth Games in Glasgow - visit www.glasgow2014.com


Disclaimer:
This message is intended only for use of the addressee. If this message
was sent to you in error, please notify the sender and delete this message.
Glasgow City Council cannot accept responsibility for viruses, so please
scan attachments. Views expressed in this message do not necessarily reflect
those of the Council who will not necessarily be bound by its contents.




__20060125___This posting was submitted with HTML in it___

Re: passing ipconfig information

[Wixson Carolyn L PSNS]

**



I just ran into 
something yesterday that may be related. I was getting a "Caught exception 
'LoadResultList' is null or not an object" error on the mid tier, but the client 
ran fine. What I found was that it was a permissions issue related to the 
Results List table field. The permissions on the field and column were ok, but 
the field was in located in the Debug Page Holder. I needed to give permissions 
to the Debug Page Holder. Because we were only running the client before, the 
permissions on the page holder were ok at just the Admin level. I guess it 
doesn't work that way in the Mid-Tier. Kinda defeats the purpose of what the 
Debug was added for, I believe. I am planning to have to create an Active Link 
that will unhide it for Administrators only now that others need permission to 
it.
 
ARSystem 
6.3
HelpDesk 
5.6
Windows
SQL 
2000
 
Carolyn
 -Original Message-From: Grooms, Frederick W 
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 28, 2006 
6:25To: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
information
** 
  
  Try them 1 at a time to see which is causing you 
  problems.  I am on Sun (with Apache/Tomcat) and they work for me.  I 
  take it that you are using Windows IIS with ServletExec.  I also should 
  have added for #3 that the AL should have  $CLIENT-TYPE$ = 9  for 
  it's Run-If.
   
  Fred
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 
  6:25 PMTo: arslist@ARSLIST.ORGSubject: Re: passing 
  ipconfig information
  ** 
  
  

  
  I am getting a 
  Caught 
  exception:Object expected error when 
  running this. 
  In the 
  get_client_info.jsp page is there any other syntax that needs to be in the 
  file?
  Any 
  ideas?
  Thanks
   
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick 
  WSent: Wednesday, September 
  27, 2006 5:03 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
  information
   
  This is from an old 
  thread "Mid-Tier 6.3 - Get IP Address and Host 
  Name":
  1. Create a file in 
  the same folder as login.jsp named get_client_info.jsp with the following 
  contents:
  
   
  function 
  env_RemoteAddr() {  return ("<%=request.getRemoteAddr()%>"); 
  }
  
   
  function 
  env_RemoteHost() {  return ("<%=request.getRemoteHost()%>"); 
  }
  
   
  function 
  env_RemoteUser() {  return 
  ("<%=request.getRemoteUser().replace('\\', ' ')%>"); 
  }
  
   
  
  2. Add 
  the following code to the footer properties of the form (Form -> 
  Current View -> Properties ->Appearance -> Edit Web Footer 
  Content):
  
   
  
  
   
  3. Add 
  the following AL Run Process command to the form as needed (Replace the field 
  IDs with your IDs):
  
   
  _javascript_:window.F(536870976).DoSet(env_RemoteAddr());_javascript_:window.F(536870977).DoSet(env_RemoteHost());_javascript_:window.F(536870978).DoSet(env_RemoteUser());Fred
   
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 3:36 
  PMTo: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
  information
  ** 
  Has anyone passed the 
  ip address and the mac address of a client machine from the midtier?  
  This did work for the thick client but the midtier errors 
  out.
   
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Tuesday, September 19, 2006 1:44 
  PMTo: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
  information
   
  ** This works from the client. Create an 
  active link that does a set fields $PROCESS$ into a field:$PROCESS$ 
  cmd /c ipconfig /allHowever, you get a large block of text that is not 
  fomratted very well.
  
  On 9/19/06, [EMAIL PROTECTED] 
  <[EMAIL PROTECTED] 
  > wrote:
  
  ** 
  
  
  All,
  Has anyone through a Run Process 
  or maybe another method to run an  ipconfig /all on a client pushing the 
  information from the output to a field within a Remedy form?  Any ideas 
  would be appreciated.
  Thanks,
  Brandi
   
  Windows 2000 
  Server
  SQL 2000 
   ARS 
  6.3
   __20060125___This 
  posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

ARS 7.0 Patch 2 Table Fields Sort Bug

[Heider, Stephen]

ARS 7.0 p2 
Windows Server 2003
SQL Server 2005

I think I found a bug with Table fields in ARS 7.0 Patch 2.  It works on
another computer with Patch 1.

On the Sort/Levels tab of a table's Field Properties window not all
columns are visible/available...only on Display Only forms. On Regular
forms all columns [in the source form] 255 characters or less are
visible, as they should.

I even tried copying a table field originally created on a Regular form
to a Display Only form.  Most of the sort columns are no longer visible
on the DO form.  I tried List View and Tree View display types.

Has anyone else experienced this?

 
Stephen

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Break out Member List from AP:Role form (Approval Server)?

[Rebecca Hammond]

I may not have had enough coffee this morning...but this, below, is what it 
would look like in a piece of Remedy workflow, or a SQL command at the DB 
level (or both)?

On Wed, 27 Sep 2006 10:36:40 -0700, Thad Esser <[EMAIL PROTECTED]> wrote:

>Try:
>
>REPLACE($Member List$, $Login Name$,  "")
>followed by
>REPLACE($Member List$, ";;",  ";")
>
>(you could combine them into one if you wanted)
>
>Thad
>"Perfection is achieved, not when there is nothing more to add, but when 
>there is nothing left to take away." - Antoine de Saint-Exupéry
>
>
>
>"Rebecca Hammond" <[EMAIL PROTECTED]> 
>Sent by: "Action Request System discussion list(ARSList)" 
>
>09/27/2006 10:28 AM
>Please respond to
>arslist@ARSLIST.ORG
>
>
>To
>arslist@ARSLIST.ORG
>cc
>
>Subject
>Break out Member List from AP:Role form (Approval Server)?
>
>
>
>
>
>
>Hi all!
>
>I'm going through the process of trying to remove a whole bunch (hundreds) 
>
>of People/User records - these are people who no longer work in my 
>organization.
>
>I know if I use the App. Config. Console, this will blow the users out of 
>places like SHR:Assignment.  However, I've found that there can be 
>problems 
>if a user is deleted but their login name is still listed as part of a 
>Member List in the AP:Role form.  In there, the login is stored with other 
>
>members of the role, separated by a ;
>
>Does anyone have any tricks for editing the AP:Role records when a User 
>account is deleted?
>
>Thanks!
>
>___

>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>
>
>***IMPORTANT NOTICE: This communication, including any attachment, 
contains information that may be confidential or privileged, and is 
intended solely for the entity or individual to whom it is addressed.  If 
you are not the intended recipient, you should delete this message and are 
hereby notified that any disclosure, copying, or distribution of this 
message is strictly prohibited.  Nothing in this email, including any 
attachment, is intended to be a legally binding signature.***
>
>___

>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: passing ipconfig information

[Grooms, Frederick W]

**



Try them 1 at a time to see which is causing you 
problems.  I am on Sun (with Apache/Tomcat) and they work for me.  I 
take it that you are using Windows IIS with ServletExec.  I also should 
have added for #3 that the AL should have  $CLIENT-TYPE$ = 9  for it's 
Run-If.
 
Fred


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 6:25 
PMTo: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
information
** 




I am getting a 
Caught 
exception:Object expected error when running 
this. 
In the 
get_client_info.jsp page is there any other syntax that needs to be in the 
file?
Any 
ideas?
Thanks
 




From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick 
WSent: Wednesday, September 
27, 2006 5:03 PMTo: 
arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
information
 
This is from an old 
thread "Mid-Tier 6.3 - Get IP Address and Host 
Name":
1. Create a file in the 
same folder as login.jsp named get_client_info.jsp with the following 
contents:

 
function 
env_RemoteAddr() {  return ("<%=request.getRemoteAddr()%>"); 
}

 
function 
env_RemoteHost() {  return ("<%=request.getRemoteHost()%>"); 
}

 
function 
env_RemoteUser() {  return 
("<%=request.getRemoteUser().replace('\\', ' ')%>"); 
}

 

2. Add the 
following code to the footer properties of the form (Form -> Current 
View -> Properties ->Appearance -> Edit Web Footer 
Content):

 


 
3. Add the 
following AL Run Process command to the form as needed (Replace the field IDs 
with your IDs):

 
_javascript_:window.F(536870976).DoSet(env_RemoteAddr());_javascript_:window.F(536870977).DoSet(env_RemoteHost());_javascript_:window.F(536870978).DoSet(env_RemoteUser());Fred
 



From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
[EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 3:36 
PMTo: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
information
** 
Has anyone passed the 
ip address and the mac address of a client machine from the midtier?  This 
did work for the thick client but the midtier errors 
out.
 




From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Tuesday, September 19, 2006 1:44 
PMTo: arslist@ARSLIST.ORGSubject: Re: passing ipconfig 
information
 
** This works from the client. Create an 
active link that does a set fields $PROCESS$ into a field:$PROCESS$ cmd 
/c ipconfig /allHowever, you get a large block of text that is not 
fomratted very well.

On 9/19/06, [EMAIL PROTECTED] 
<[EMAIL PROTECTED] 
> wrote:

** 


All,
Has 
anyone through a Run Process or maybe another method to run an  ipconfig 
/all on a client pushing the information from the output to a field within a 
Remedy form?  Any ideas would be appreciated.
Thanks,
Brandi
 
Windows 2000 
Server
SQL 
2000 
 ARS 
6.3
 
__20060125___This posting was submitted with HTML in it___

Re: driver.exe: blanks in table qualifications

[Carey Matthew Black]

Alex,

This is just a WAG... ( I am not a C programmer and I assume your
using the C driver program.) If I tract through the source for the
v6.3 driver program correctly it looks like this is what the
progression of methods would be...

APIARCreateField
GetARFieldLimitStruct
GetARTableLimitsStruct
GetARQualifierStruct
  (assuming Relop choice)
GetARRelOpStruct
GetARFieldValueOrArithStruct
 (assuming Val choice)
GetARValueStruct
 (assuming Char choice)
GetValue
GetMallocChar
GetChar

(Did I make the right assumptions above? Were you doing something else?)

Ending in a GetInputLine() call being the thing that actually collects
the input from you. (or maybe how strlen() counts a space?)


A few WAGs that you might want to try to test out: (possible workarounds?)

Maybe you should try a double space? (Thinking that it might be
trimming one of them off.)
Maybe your fighting a DOS Shell issue and should end your single space
input with a Ctrl+Z  before the return?

or maybe you can look at the C code and see what this non-C
programmer can not see. :)

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 9/27/06, Alex Straph <[EMAIL PROTECTED]> wrote:

I am trying to use a Driver script to update a bunch of tables with the
following expression: ('Marker01' = " ")

I am already familiar with updating Table qualifications, so doing this
simple qualification is not an issue.  What is an issue is the " ".  When I
get to the point where I want to insert the space, I simply enter the space
then continue.  The problem is when I go back to the table, it comes up as
('Marker01' = "").

The reason I have the space there is because we want the table to show when
Marker01 is blank.  It simply won't work with $NULL$ nor will it work
with "".  Having a space in there is the most effective way for the table
to work (AFAIK).

Any ideas how?

Thanks.

Alex.


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: OT:ARSPerl - Error while installing

[Chapman, Gary]

**



1.82 appears to be for V6.
 
1.81 seems to be doing the trick. I shall have a play 
around and start learning the ways of ARSPerl.
 
Thanks again Frank, you've been a star.
 
Cheers,
 
Gary


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank 
CarusoSent: 28 September 2006 13:10To: 
arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - Error while 
installing
** 1.82 appears to be later:http://prdownloads.sourceforge.net/arsperl/arsperl_182.zip?download
On 9/28/06, Chapman, 
Gary <[EMAIL PROTECTED]> 
wrote:
** 

  
  Hi 
  Frank,
   
  ARSPerl 
  installed perfectly this time, however, It seems to be for V6.3. Being the 
  fool I am, I realised that I did not include details of the version I am 
  running, which is 5.01.02.
   
  I checked 
  the site where you pointed me to last time and can see that there is version 
  1.81 which will probably install in the same way. Is this the latest version 
  that will work with 5.01?
   
  Thanks 
  again for your help, very much appreciated.
   
  Cheers,
   
  Gary
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:arslist@ARSLIST.ORG] On 
  Behalf Of Frank CarusoSent: 27 September 2006 
  16:10To: arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - 
  Error while installing
  ** There are two different builds of ARS Perl. If you use the link 
  I provided it will give the PPM version which only contains two files. There 
  are others which contian the complete distribution.
  On 9/27/06, Chapman, 
  Gary <[EMAIL PROTECTED]> wrote: 
  ** 


Hi 
Frank,
 
I tried 
that as suggested but that was the version I have already tried. I may have 
misunderstood but I had many more than 2 files and none were 
.ppd.
 
Thanks 
anyway,
 
Gary


From: Action Request System discussion 
list(ARSList) [mailto:arslist@ARSLIST.ORG] 
On Behalf Of Frank CarusoSent: 27 September 2006 
15:44To: arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - 
Error while installing
** If you are doing this on a Windows platform then you can make 
is a bit easier for yourself by using a Perl build from www.activestate.com. 
Download and install it. Then get ARSPerl  from this link: http://prdownloads.sourceforge.net/arsperl/arsperl_184_63.zip?download 
I put the ZIP in the same folder as Perl (C:\Perl). Unpack 
its contents, two files, and the alter the .ppd file removing the "x86/" 
reference.From a DOS prompt in the C:\perl folder type "ppm install 
ars184_63.ppd".This works for me and I've installed perl and ARS 
Perl a bunch of times. Hope this helps.
On 9/27/06, Thilo 
Stapff <[EMAIL PROTECTED]> wrote: 
The 
  ARSperl Makefile.PL has problems handling directory names 
  containingspace characters (in this case "Program Files" and "AR 
  System"). As a workaround, you might copy the "Api" directory to some 
  otherlocation and compile against this copy.Regards,Thilo 
  StapffChapman, Gary schrieb:> **> Hi 
  Listers, >> I wonder if some one could help me with an issue 
  I have while attempting> to run the makefile.pl for 
  ARSPerl.> I get the following error: ->> /Generating 
  serverTypeInfoHints.h .. > The system cannot find the file 
  specified.> something went wrong when i ran "E:\Perl\bin\perl.exe 
  infra/exsi.pl <> E:/Program>  Files/AR 
  System/Arserver/Api/include/ar.h > serverTypeInfoHints.h " (rv> 
  = 256, e> xpected 0) at E:\Perl\ARSperl-1.85\Makefile.PL line 
  213./>> I am just learning PERL so I can imagine it's 
  something I'm doing> horribly wrong.>> Thanks in 
  advance, > * *>> *Regards,> Gary 
  Chapman*> *Application Support*>> T +44(0)1908 
  696000> D +44(0)1908 257446>> F +44(0)1908 
  692791>> E _gary.chapman@ imserv.invensys.com 
  _> W _http://www.imserv.invensys.com_ >> 
  IMServ Europe Ltd > Scorpio Rockingham Drive Linford Wood Milton 
  Keynes MK14 6LY> Registered in England and Wales No.2749624> 
  Registered Address: Invensys Portland House Stag Place London SW1E 
  5BF>> Disclaimer Notice > This message/attachment(s) 
  are CONFIDENTIAL and may contain LEGALLY> PRIVILEGED information. 
  If this message/attachment(s) were not intended> for you please 
  contact the sender IMMEDIATELY and delete this > 
  message/attachment(s) from your computer. You must not copy, forward 
  or> disclose the contents of this message/attachment(s) to any 
  other person.> The views/opinions in this message are solely of the 
  author and do not > necessarily represent those of the company. 
  Please check this> message/attachment(s) for the presence of 
  viruses. No liability for any> damage caused by any virus 
  transmitted by this message/attachment(s) is > accepted by the 
  company.>>> __20060125___This 
  

Re: Problem Managing Software License Contracts in AM 7

[Kelly Deaver]

**
I haven't fully researched what BMC meant to happen in this case but if it isn't working, you can create your own filter to decrement the count.
 
Do a compare operation as part of your dataset reconciliation Create a workflow to execute as part of the compare operation (see CMDB Config Guide page 148) to do the decrement if the item doesn't exist in the discovered dataset but does exist in the BMC.ASSET dataset. Do this step after your identify function and before you do your merge operation or the delete will kick in and you won't have anything to compare.-Kelly DeaverDirector, ITSM PracticeXinify[EMAIL PROTECTED]

 Original Message Subject: Problem Managing Software License Contracts in AM 7From: Michael Robinson <[EMAIL PROTECTED]>Date: Wed, September 27, 2006 5:44 pmTo: arslist@ARSLIST.ORGWhen a software product is discovered and imported into the CMDB as a"hosted system component" of the parent CI, the license is automaticallyrelated and decremented (assuming the contract licensable products arecorrectly set).The problem we are having is that when the asset is deleted, therelationship remains and the license is still decremented. We thoughtthe cascade delete on the hosted system component would fix this, butwhen we turned cascade delete on for the hosted system componentrelationship, we can not delete any CI's with a hosted system componentrelationship.Has anyone dealt with this issue previously? I feel I might be missing afeature of the software license management part of AM7.Thanks in advance,Michael RobinsonPh (817)525-7211Privileged and Confidential.  This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information.  If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail.  You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
__20060125___This posting was submitted with HTML in it___

Jobs - UK based reasorce needed

[Mike Evans]

 
Hello Listers,

I am currently looking for contractors to work in and around the UK, I
have a few roles live at the moment and would really like to hear from
any Developers that may be interested, or anyone who is currently coming
to the end of their present contracts. I would especially like to hear
from anybody who has a permanent position at the moment but are thinking
about turning to the consulting market.

Please feel free to contact me on any of the numbers below or via my
email address -  [EMAIL PROTECTED] 

Obviously, all communications will be highly confidential!

Thanks in advance,

Mike

Mike Evans
Centaur Corporate Solutions Ltd
DDI: + 44 (0) 1296 678 577
Fax: + 44 (0) 1296 678 597
Mobile: + 44 (0) 7973 574 901 
E-Mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: OT:ARSPerl - Error while installing

[Frank Caruso]

**
1.82 appears to be later:http://prdownloads.sourceforge.net/arsperl/arsperl_182.zip?download
On 9/28/06, Chapman, Gary <[EMAIL PROTECTED]> wrote:
**





Hi Frank,
 
ARSPerl installed perfectly this time, however, It seems to 
be for V6.3. Being the fool I am, I realised that I did not include details of 
the version I am running, which is 5.01.02.
 
I checked the site where you pointed me to last time and 
can see that there is version 1.81 which will probably install in the same way. 
Is this the latest version that will work with 5.01?
 
Thanks again for your help, very much 
appreciated.
 
Cheers,
 
Gary


From: Action Request System discussion 
list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank 
CarusoSent: 27 September 2006 16:10To: 
arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - Error while 
installing
** There are two different builds of ARS Perl. If you use the link I 
provided it will give the PPM version which only contains two files. There are 
others which contian the complete distribution.
On 9/27/06, Chapman, 
Gary <[EMAIL PROTECTED]> 
wrote:
** 

  
  Hi 
  Frank,
   
  I tried 
  that as suggested but that was the version I have already tried. I may have 
  misunderstood but I had many more than 2 files and none were 
  .ppd.
   
  Thanks 
  anyway,
   
  Gary
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:arslist@ARSLIST.ORG] On 
  Behalf Of Frank CarusoSent: 27 September 2006 
  15:44To: arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - 
  Error while installing
  ** If you are doing this on a Windows platform then you can make is 
  a bit easier for yourself by using a Perl build from www.activestate.com. 
  Download and install it. Then get ARSPerl  from this link: 
http://prdownloads.sourceforge.net/arsperl/arsperl_184_63.zip?download 
  I put the ZIP in the same folder as Perl (C:\Perl). Unpack its 
  contents, two files, and the alter the .ppd file removing the "x86/" 
  reference.From a DOS prompt in the C:\perl folder type "ppm install 
  ars184_63.ppd".This works for me and I've installed perl and ARS Perl 
  a bunch of times. Hope this helps.
  On 9/27/06, Thilo 
  Stapff <[EMAIL PROTECTED]> wrote: 
  The 
ARSperl Makefile.PL has problems handling directory names 
containingspace characters (in this case "Program Files" and "AR 
System"). As a workaround, you might copy the "Api" directory to some 
otherlocation and compile against this copy.Regards,Thilo 
StapffChapman, Gary schrieb:> **> Hi Listers, 
>> I wonder if some one could help me with an issue I have 
while attempting> to run the makefile.pl for ARSPerl.> I get 
the following error: ->> /Generating serverTypeInfoHints.h .. 
> The system cannot find the file specified.> something went 
wrong when i ran "E:\Perl\bin\perl.exe infra/exsi.pl <> 
E:/Program>  Files/AR System/Arserver/Api/include/ar.h > 
serverTypeInfoHints.h " (rv> = 256, e> xpected 0) at 
E:\Perl\ARSperl-1.85\Makefile.PL line 213./>> I am just 
learning PERL so I can imagine it's something I'm doing> horribly 
wrong.>> Thanks in advance, > * *>> 
*Regards,> Gary Chapman*> *Application 
Support*>> T +44(0)1908 696000> D +44(0)1908 
257446>> F +44(0)1908 692791>> E _gary.chapman@ 
imserv.invensys.com 
_> W _http://www.imserv.invensys.com_ >> IMServ 
Europe Ltd > Scorpio Rockingham Drive Linford Wood Milton Keynes MK14 
6LY> Registered in England and Wales No.2749624> Registered 
Address: Invensys Portland House Stag Place London SW1E 5BF>> 
Disclaimer Notice > This message/attachment(s) are CONFIDENTIAL and 
may contain LEGALLY> PRIVILEGED information. If this 
message/attachment(s) were not intended> for you please contact the 
sender IMMEDIATELY and delete this > message/attachment(s) from your 
computer. You must not copy, forward or> disclose the contents of 
this message/attachment(s) to any other person.> The views/opinions 
in this message are solely of the author and do not > necessarily 
represent those of the company. Please check this> 
message/attachment(s) for the presence of viruses. No liability for 
any> damage caused by any virus transmitted by this 
message/attachment(s) is > accepted by the 
company.>>> __20060125___This 
posting was submitted with HTML in> 
it__ 
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
-- Frank CarusoSpecific Integration, Inc.Senior 
  Remedy Engineer www.specificintegration.com703-376-1249 
  __20060125___This posting was submitted with HTML in it___ 
  __20060125___This posting was submitted with HTML in 
  it___ -- Frank CarusoSpecific 
Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 
__20060125__

Re: driver.exe: blanks in table qualifications

[Heider, Stephen]

Have you tried using $\NULL$ instead of $NULL$?


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alex Straph
Sent: Wednesday, September 27, 2006 5:05 PM
To: arslist@ARSLIST.ORG
Subject: driver.exe: blanks in table qualifications

I am trying to use a Driver script to update a bunch of tables with the
following expression: ('Marker01' = " ")

I am already familiar with updating Table qualifications, so doing this
simple qualification is not an issue.  What is an issue is the " ".
When I get to the point where I want to insert the space, I simply enter
the space then continue.  The problem is when I go back to the table, it
comes up as ('Marker01' = "").

The reason I have the space there is because we want the table to show
when
Marker01 is blank.  It simply won't work with $NULL$ nor will it work
with "".  Having a space in there is the most effective way for the
table to work (AFAIK).

Any ideas how?

Thanks.

Alex.


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Read (floating) license

[David Sanders]

Hi Michelle

I have always recommended my clients opt for as many fixed licenses as they
can, rather than using floating licenses, and this test just reinforces that
opinion.

It looks like when estimating license requirements, you now need to consider
how frequently occasional users log in to the system, rather than how often
they need to modify a record. If they log in more than twice a week for more
than an hour, they are a candidate for either a fixed or read license.  Only
users who are truly 'occasional' should have a floating license.

Also, there is a real training requirement here to make sure that Mid-Tier
users log out correctly, rather than just closing the browser. Moving more
users to the thin client will only exacerbates this problem.

A couple of years ago I did some work for a client where they had 24 hour
operations, with a couple of fully staffed shifts, and a graveyard shift
with fewer people at work.  Remedy had recommended and supplied all floating
licenses as being 'ideal' for shift workers, but actually at shift
changeover time it was a nightmare with half the new shift being unable to
work.  The solution was to change to all Fixed licenses, and all staff could
be given a fixed license for the same overall cost.

Also, with good application design and using 'allow any user to submit'
field permissions, and submitter mode locked may allow many users to operate
with a Read license... and then, if you have more than one Remedy server,
the advantage of fixed licenses over floating is even more pronounced.

So you're in a situation where you're running out of floating licenses and
need to buy some more.  Rather than buying say 10 extra floating licenses,
consider buying 25 extra fixed ones and allocating them to your 25 heaviest
floating users.  This will probably free up more of your floating tokens
than the extra floating licenses would have given.

I have rarely seen a Remedy installation where a large number of floating
licenses were really cost-effective - by all means have a few, but make the
majority of your license fixed.

Just MHO.

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor
Sent: Thursday, September 28, 2006 12:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Read (floating) license

Hi, David

There was a search menu on the Group field.  But, I had to test this
further.

Here I go beatin' a dead horse.

I created a display only form with not one single field, button,
workflow nor any other object.  I opened the form on the Mid-Tier with
my test floating license.  And again it immediately took up a Float
WRITE.  

It still doesn't flush after a few minutes, etc.

   
  /* Wed
Sep 27 2006 18:28:59.8080 */  FLOAT  GRANT WRITEclucero   (1 of 5
write)

Even if we accept the premise about search menus, etc...
Isn't it unrealistic to assume that a form would have absolutely no
workflow and absolutely no search menus? In other words, in almost all
cases, there will be a search menu, workflow on window open or loaded, a
table field or something?  
Meaning a FLOAT GRANT WRITE will almost always be taken up upon log on.
So far in my testing, it is 100% of the time.

In my experience it doesn't drop off after 5-10 minutes of activity.  It
either expires after the admin defined float license timeout or drops
off when I click Logout.

I think that if one isn't suppose to be granted a WRITE until after some
sort of activity (and the behavior clearly doesn't work this way) then
this is definitely an issue.

OK, OK, I'll leave it alone.  Thanks for listening.

Michelle
PS  Remember we all could be experiencing different behaviors on
different versions.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
Sent: Wednesday, September 27, 2006 5:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Read (floating) license

Hi Michelle

I think that if the form has a field with a search menu on it, this can
cause the floating token to be grabbed just by opening the form.

Regards

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
Sent: Wednesday, September 27, 2006 10:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Read (floating) license

Hi, Misi:

Hope you're doing OK.

Is the operative w

Re: XML format

[Shibu Samuel]

Thanks lot for the info. 
We are planning to pass some values on the URL and return value will be on XML. 
for ex : 
Pass an firstname , lastname to remedy in URL and Remedy can return the 
requestID in XML 
 
Thanks 
Shibu Samuel 
 
 
 

-Original Message- 
From: Action Request System discussion list(ARSList) on behalf of Ben 
Christenson 
Sent: Mon 9/25/2006 10:12 PM 
To: arslist@ARSLIST.ORG 
Cc: 
Subject: Re: XML format



> Is ther any way to pass the values in URL to Remedy
> and Remedy can return values in XML format.

Kinetic Link (http://www.kineticdata.com/products/klink) solves problems
very similiar to what you are discussing.  It is an opensource
web-application that "provides a consistent XML over HTTP interface for
interacting with BMC Remedy Action Request Systems."

Can you be a little more specific about what you are looking to do?  
What
kind of values are you wanting to pass?  What kind of values do you 
want to
return? 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: OT:ARSPerl - Error while installing

[Chapman, Gary]

**



Hi Frank,
 
ARSPerl installed perfectly this time, however, It seems to 
be for V6.3. Being the fool I am, I realised that I did not include details of 
the version I am running, which is 5.01.02.
 
I checked the site where you pointed me to last time and 
can see that there is version 1.81 which will probably install in the same way. 
Is this the latest version that will work with 5.01?
 
Thanks again for your help, very much 
appreciated.
 
Cheers,
 
Gary


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank 
CarusoSent: 27 September 2006 16:10To: 
arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - Error while 
installing
** There are two different builds of ARS Perl. If you use the link I 
provided it will give the PPM version which only contains two files. There are 
others which contian the complete distribution.
On 9/27/06, Chapman, 
Gary <[EMAIL PROTECTED]> 
wrote:
** 

  
  Hi 
  Frank,
   
  I tried 
  that as suggested but that was the version I have already tried. I may have 
  misunderstood but I had many more than 2 files and none were 
  .ppd.
   
  Thanks 
  anyway,
   
  Gary
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:arslist@ARSLIST.ORG] On 
  Behalf Of Frank CarusoSent: 27 September 2006 
  15:44To: arslist@ARSLIST.ORGSubject: Re: OT:ARSPerl - 
  Error while installing
  ** If you are doing this on a Windows platform then you can make is 
  a bit easier for yourself by using a Perl build from www.activestate.com. 
  Download and install it. Then get ARSPerl  from this link: http://prdownloads.sourceforge.net/arsperl/arsperl_184_63.zip?download 
  I put the ZIP in the same folder as Perl (C:\Perl). Unpack its 
  contents, two files, and the alter the .ppd file removing the "x86/" 
  reference.From a DOS prompt in the C:\perl folder type "ppm install 
  ars184_63.ppd".This works for me and I've installed perl and ARS Perl 
  a bunch of times. Hope this helps.
  On 9/27/06, Thilo 
  Stapff <[EMAIL PROTECTED]> wrote: 
  The 
ARSperl Makefile.PL has problems handling directory names 
containingspace characters (in this case "Program Files" and "AR 
System"). As a workaround, you might copy the "Api" directory to some 
otherlocation and compile against this copy.Regards,Thilo 
StapffChapman, Gary schrieb:> **> Hi Listers, 
>> I wonder if some one could help me with an issue I have 
while attempting> to run the makefile.pl for ARSPerl.> I get 
the following error: ->> /Generating serverTypeInfoHints.h .. 
> The system cannot find the file specified.> something went 
wrong when i ran "E:\Perl\bin\perl.exe infra/exsi.pl <> 
E:/Program>  Files/AR System/Arserver/Api/include/ar.h > 
serverTypeInfoHints.h " (rv> = 256, e> xpected 0) at 
E:\Perl\ARSperl-1.85\Makefile.PL line 213./>> I am just 
learning PERL so I can imagine it's something I'm doing> horribly 
wrong.>> Thanks in advance, > * *>> 
*Regards,> Gary Chapman*> *Application 
Support*>> T +44(0)1908 696000> D +44(0)1908 
257446>> F +44(0)1908 692791>> E _gary.chapman@ 
imserv.invensys.com 
_> W _http://www.imserv.invensys.com_ >> IMServ 
Europe Ltd > Scorpio Rockingham Drive Linford Wood Milton Keynes MK14 
6LY> Registered in England and Wales No.2749624> Registered 
Address: Invensys Portland House Stag Place London SW1E 5BF>> 
Disclaimer Notice > This message/attachment(s) are CONFIDENTIAL and 
may contain LEGALLY> PRIVILEGED information. If this 
message/attachment(s) were not intended> for you please contact the 
sender IMMEDIATELY and delete this > message/attachment(s) from your 
computer. You must not copy, forward or> disclose the contents of 
this message/attachment(s) to any other person.> The views/opinions 
in this message are solely of the author and do not > necessarily 
represent those of the company. Please check this> 
message/attachment(s) for the presence of viruses. No liability for 
any> damage caused by any virus transmitted by this 
message/attachment(s) is > accepted by the 
company.>>> __20060125___This 
posting was submitted with HTML in> 
it__ 
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior 
  Remedy Engineer www.specificintegration.com703-376-1249 
  __20060125___This posting was submitted with HTML in it___ 
  __20060125___This posting was submitted with HTML in 
  it___ -- Frank CarusoSpecific 
Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 
__20060125___This posting was submitted with HTML in it___ 

__20060125___This posting was submitted with HTML in it___

Re: OT Re: DATE fields and queries

[Rodney Harris]

Hi Misi,

I have everything set to Australian date format which is dd/mm/ but
to set the date field it has to be done in US format. Mm/dd/. Make
sure you do that and it will work.  You can't assign it directly either.
You must use an intermediate character field. Don't ask my why - that is
just how I managed to get it to work.

I'm surprised if you still can't assign a date field via an integer
field. 

Rod



Hi Rod,

1. I was unable to assign the Date-field to a Integer-field and vice
versa.
2. The MONTH($DATE$) + "/" + DAY($DATE$) + "/" + YEAR($DATE$) did not
work
due to the Swedish date format
3. The equivalent Swedish version did not work either YEAR($DATE$) + "-"
+
MONTH($DATE$) + "-" + DAY($DATE$)

Well, this was all some time ago, so I should better give it another try
with fresh versions of everything...

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

> Hi Misi,
>
> Don't give up!!!
>
>>The good things about the date-fields you mentioned was non-existing
in
> my
>>case. I think this is due to the format "2006-01-31" which was
> interpreted
>>as an arithmetic operation (2006 minus 1 minus 31).
>
> Yes you can't do arithmetic with date string literals - pretty sure
you
> need to use an integer literal that represents the number of days
since
> 4713 BC. Assign a date field to an integer field to find out what it's
> integer equivalent is.
>
>>I could not even create an escalation that did a ('Datefield' $DATE$).
>
>>There were no workflow that allowed me (not even by using a temporary
>>char-field) to move the currend date into a Date-field.
>
> Yep you need to set fields the current $DATE$ to a character string
via
> MONTH($DATE$) + "/" + DAY($DATE$) + "/" + YEAR($DATE$) first and then
> assign the date field to this character string. I guess the thing
about
> this method is that there is no ambiguity about the date format.
>
> Regards,
>
> Rod
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org