Password Checking Problem

2008-05-14 Thread manjunath badiger
Hi,

I am using @@:Application-Confirm-Password field ID inorder to check
whether user's password is right.
When the password is not correct, it pops-up the following error
message:


ARERR [4549] Confirming password is not valid for the current user
Set fields active link running a process failed (ARERR 1603)


Althought i am trying to store this result in a result field. Now how
do i
prevent this pop-up...
My intent here is to avoid this pop-up and provide a customised error
mesg.

I am using remedy ARS 6.3 it works good for remedy 7.0

Please do let me know

   
  
   
  Thanks
  Manjunath

   
-
 Bring your gang together. Do your thing. Find your favourite Yahoo! Group.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Field 112 control in ITSM 7

2008-05-14 Thread ITSM Support

Hi Strauss,

What we understand is that you want to add group information to Assignee
Group(ID 112), dynamically  explicitly.
To do this add your own worlflows  dynamic groups to your own fields
without affecting the default workflows of ITSM 7.
This will definitely save your efforts of reinvention from the scratch.

Hope this helps...
Regards.

*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*
strauss wrote:

It has become evident that the ITSM 7 application does not, in fact,
implement multi-tenancy properly, only a faint shadow of it.  We had
been led to believe in all of our discussions with engineers at two
different UserWorlds (and had not been able to disprove it in testing)
that the permissions of an Incident would be modified to reflect the
customer, current owner, and current assigned group throughout the life
cycle of the request.  This is not, in fact, what is taking place, OOTB,
at least not once you have patched through 007.  The only permissions
being posted to the incident are those of the customer - one group id in
field 112.

Has anyone had to supplement the ITSM 7 application with workflow that
dynamically and explicitly adds group information to field 112 for the
assigned support group and the owner group, and removes it as the
incident changes assignment/ownership?  If not, I guess I will be
inventing it from scratch - this HAS to work.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


  


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Value too large for the meta table FIELD_DISPROP table!!!

2008-05-14 Thread Joe DeSouza
It is a Unicode setup, and I had set the environment variable NLS_LANG on the 
database server to American_America.UTF8
Does this have to be setup in the ardbc.cfg file too? If so what is the 
paramter name?
Joe

- Original Message 
From: Walters, Mark [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 13, 2008 5:14:32 PM
Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!

** 
Joe,
 
Is this a Unicode ARS installation and which platform is it on?  Does the view 
contain accented characters?  If so it may be that the NLS_LANG is not set 
correctly – for Unicode systems it should end .AL32UTF8
 
Mark Walters
 
The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or support representative for BMC Software, Inc.
 
 
 
From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: 13 May 2008 21:45
To: arslist@ARSLIST.ORG
Subject: Value too large for the meta table FIELD_DISPROP table!!!
 
** 
I got this strange error when the SLM install script was trying to import one 
of the views. This is strange considering that a value being inserted into a 
meta data table should not have technically overshot the column length..
 
Failure during SQL operation to the database: ORA-12899: value too large for 
column ARADMIN701.FIELD_DISPPROP.PROPSHORT (actual: 270, maximum: 255) 
(ARERR 552)
 
It looks like the data that needs to be written to this column is 15 characters 
too large..
 
Has anyone else seen a problem like this and if so how did you'll get around 
it? I'm not quite excited by the thought of having to alter a meta data table 
although that seems to be the only logical thing to do given this situation..
 
Cheers
 
Joe D'Souza
 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Creating a view in Remedy using dblink?

2008-05-14 Thread Ravi
Can somebody tell me if it's possible to create a form in Remedy which 
is a view created using dblink? If yes, which document describes this? I 
have searched through all the docs and couldn't find it.


TIA
Ravi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Is it possible to generate a XSD-file from cmdbdriver???

2008-05-14 Thread Marc Prang
Hi all,

I can export a definition file from cmdbdriver. Is it possible to generate a 
xsd file (as W3C standard) from definition file or directly from cmdbdriver. 
I need a xsd file to import CIs as xml file thru cmdbdriver?
I found only some samples of xsd files on the filesystem.

We're using CMDB 2.1p1 with additional classes on sun solaris10.

with best regards,
marc

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Value too large for the meta table FIELD_DISPROP table!!!

2008-05-14 Thread Walters, Mark
What platform is the ARS server running on?  You mention ardb.cfg so is
it Windows?  The Oracle client used by ARS needs to have NLS_LANG set.
On Windows it is a registry key - exactly which one depends on the type
of Oracle client installed.  On Unix this can be done via the arsystem
script or an environment variable.   

 

I suspect you may find a registry key where NLS_LANG is set to
lang_country.WE8MSWIN1252 on the ARS server system.

 

Database server

 

NLS_LENGTH_SEMANTICS = BYTE

NLS_CHARACTERSET = language_country.UTF8 (or AL32UTF8)

 

Database CLIENT

 

NLS_LANG = language_country.UTF8 (or AL32UTF8)

 

Mark

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: 14 May 2008 12:16
To: arslist@ARSLIST.ORG
Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!

 

** 

It is a Unicode setup, and I had set the environment variable NLS_LANG
on the database server to American_America.UTF8

 

Does this have to be setup in the ardbc.cfg file too? If so what is the
paramter name?

 

Joe

- Original Message 
From: Walters, Mark [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, May 13, 2008 5:14:32 PM
Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!

** 

Joe,

 

Is this a Unicode ARS installation and which platform is it on?  Does
the view contain accented characters?  If so it may be that the NLS_LANG
is not set correctly - for Unicode systems it should end .AL32UTF8

 

Mark Walters

 

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or support representative for BMC
Software, Inc.

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: 13 May 2008 21:45
To: arslist@ARSLIST.ORG
Subject: Value too large for the meta table FIELD_DISPROP table!!!

 

** 

I got this strange error when the SLM install script was trying to
import one of the views. This is strange considering that a value being
inserted into a meta data table should not have technically overshot the
column length..

 

Failure during SQL operation to the database: ORA-12899: value too large
for column ARADMIN701.FIELD_DISPPROP.PROPSHORT (actual: 270,
maximum: 255) (ARERR 552)

 

It looks like the data that needs to be written to this column is 15
characters too large..

 

Has anyone else seen a problem like this and if so how did you'll get
around it? I'm not quite excited by the thought of having to alter a
meta data table although that seems to be the only logical thing to do
given this situation..

 

Cheers

 

Joe D'Souza

 

__Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/
ARSlist: Where the Answers Are html___ 

__Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/
ARSlist: Where the Answers Are html___

 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Value too large for the meta table FIELD_DISPROP table!!!

2008-05-14 Thread Joe D'Souza
Thank you.. I'll check these settings as soon as I get to work..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Walters, Mark
  Sent: Wednesday, May 14, 2008 7:48 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!


  **
  What platform is the ARS server running on?  You mention ardb.cfg so is it
Windows?  The Oracle client used by ARS needs to have NLS_LANG set.  On
Windows it is a registry key – exactly which one depends on the type of
Oracle client installed.  On Unix this can be done via the arsystem script
or an environment variable.



  I suspect you may find a registry key where NLS_LANG is set to
lang_country.WE8MSWIN1252 on the ARS server system.



  Database server



  NLS_LENGTH_SEMANTICS = BYTE

  NLS_CHARACTERSET = language_country.UTF8 (or AL32UTF8)



  Database CLIENT



  NLS_LANG = language_country.UTF8 (or AL32UTF8)



  Mark



  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
  Sent: 14 May 2008 12:16
  To: arslist@ARSLIST.ORG
  Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!



  **

  It is a Unicode setup, and I had set the environment variable NLS_LANG on
the database server to American_America.UTF8



  Does this have to be setup in the ardbc.cfg file too? If so what is the
paramter name?



  Joe

  - Original Message 
  From: Walters, Mark [EMAIL PROTECTED]
  To: arslist@ARSLIST.ORG
  Sent: Tuesday, May 13, 2008 5:14:32 PM
  Subject: Re: Value too large for the meta table FIELD_DISPROP table!!!

  **

  Joe,



  Is this a Unicode ARS installation and which platform is it on?  Does the
view contain accented characters?  If so it may be that the NLS_LANG is not
set correctly – for Unicode systems it should end .AL32UTF8



  Mark Walters



  The opinions, statements, and/or suggested courses of action expressed in
this E-mail do not necessarily reflect those of BMC Software, Inc.  My
voluntary participation in this forum is not intended to convey a role as a
spokesperson, liaison or support representative for BMC Software, Inc.







  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
  Sent: 13 May 2008 21:45
  To: arslist@ARSLIST.ORG
  Subject: Value too large for the meta table FIELD_DISPROP table!!!



  **

  I got this strange error when the SLM install script was trying to import
one of the views. This is strange considering that a value being inserted
into a meta data table should not have technically overshot the column
length..



  Failure during SQL operation to the database: ORA-12899: value too large
for column ARADMIN701.FIELD_DISPPROP.PROPSHORT (actual: 270, maximum:
255) (ARERR 552)



  It looks like the data that needs to be written to this column is 15
characters too large..



  Has anyone else seen a problem like this and if so how did you'll get
around it? I'm not quite excited by the thought of having to alter a meta
data table although that seems to be the only logical thing to do given this
situation..



  Cheers



  Joe D'Souza

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1430 - Release Date: 5/13/2008
7:31 AM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Passing parameter to Crystal Report

2008-05-14 Thread Marek Marek
Hi list,

I am thinking of the idea of having reports based on a user's selection.
User with the search criteria finds required records and then all (or
only selected) records are to be displayed as multiple crystal reports
But the problem is how to build the qualification string of selected
IDs which is to be passed to crystal.
If there is an another way of achieving this functionality, I'll appreciate
any ideas.
Marek

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Passing parameter to Crystal Report

2008-05-14 Thread Murtuza B
Hi Marek,
 
I dunno what exactly u r looking for, but the Open Window action of your
activelink will allow you to put a qualification that automatically gets
passed to crystal.
 
Cheers,
Murtuza.


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Marek Marek
Sent: Wednesday, May 14, 2008 5:39 PM
To: arslist@ARSLIST.ORG
Subject: Passing parameter to Crystal Report


** 
Hi list,
 
I am thinking of the idea of having reports based on a user's selection.
User with the search criteria finds required records and then all (or
only selected) records are to be displayed as multiple crystal reports
But the problem is how to build the qualification string of selected IDs
which is to be passed to crystal.
If there is an another way of achieving this functionality, I'll
appreciate any ideas.
Marek
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses.  The sender 
therefore does not accept liability for any errors or omissions in the 
contents of this message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities 
or related financial instruments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Creating a view in Remedy using dblink?

2008-05-14 Thread Michiel Beijen
Ouch, you don't provide much information. Then again, I guess I can
answer anyway.

Are you running Oracle and referring to a linked table on a remote
database? And you want to create a View Form on top of that?
You have to make sure that whatever database user Remedy uses (by
default ARAdmin) has appropriate permissions on these database
objects. After that you can add a View Form as usual. Check the
Integrating... document for information on that:
http://documents.bmc.com/supportu/documents/93/94/69394/69394.pdf

For more information you can also refer to this link below, from the
ARSList Archives.
http://www.nabble.com/Oracle-View-Forms-tp8676950p8678435.html

HTH,

Michiel Beijen

On Wed, May 14, 2008 at 1:28 PM, Ravi [EMAIL PROTECTED] wrote:
 Can somebody tell me if it's possible to create a form in Remedy which is a
 view created using dblink? If yes, which document describes this? I have
 searched through all the docs and couldn't find it.

  TIA
  Ravi


 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


More than 2 gigs of memory on Tomcat?

2008-05-14 Thread Covert, Jack
Hi all.  We've recently deployed ITSM 7 and have our users using the
mid-tier.  We have dual web servers using a load balancer but we're
having some performance issues.  We've got plenty of memory on the
server, it isn't taxed but Tomcat won't allow us to start up w/ more
than 1.7 gigs of memory (which it is always topped out at).

 

Anybody know how to get it to run w/ more memory?  Thanks all!!!

 

Jack Covert

 

Corporate IT

Enterprise Systems Management

Remedy Support Team

 

Remedy Support Team Home Page

 http://collaborate.mckesson.com/sites/esm/remedy
http://collaborate.mckesson.com/sites/esm/remedy

 

ESM - Leveraging the power of automation for the benefit of the business

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Question: SYS:Notification Messages

2008-05-14 Thread T. Dee
That worked Kevin!  THANK YOU VERY MUCH!!

I was looking in the Transate Filter for Change.

Appreciate your help

If you don't mind I would love to read that document that you got from
BMC on Notifications.

Kind regards,

Ty



On 5/13/08, Kevin Shaffer [EMAIL PROTECTED] wrote:

 Which notification are you trying to add the Change Type field to?  I have 
 added it to the Approval notifications and all I had to do was add the 
 following set field to the filter , 
 NTE:SHR:TranslateNotificationMessageAPR_135.

 Set zID Translation Text to REPLACE($zID Translation Text$, #Change Type#, 
 $Change Type$)

  Date: Tue, 13 May 2008 21:42:15 +0100 From: [EMAIL PROTECTED] Subject: 
  Re: Question: SYS:Notification Messages To: arslist@ARSLIST.ORG  Hhmm... 
  If I were sure that there was a value in that change record for Change 
  Type, the only next step I would take would be to log it and ensure that 
  the Z field is getting set as the filter indicates.  Other than that, I 
  don't have any more rabbits up my sleeve - sorry.  -Original 
  Message- From: Action Request System discussion list(ARSList) 
  [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Tuesday, May 13, 2008 
  3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Question: SYS:Notification 
  Messages  Thanks Lisa - I found the one for Change 
  NTE:SHR:TranslateNotificationMessageCRQ1_125 and it does have a 
  translation for #Change Type#, but it is not working.  Any other 
  suggestions?  Thanks again.  Ty   On 5/13/08, Lisa Westerfield 
  [EMAIL PROTECTED] wrote:  I've found that there are additional filters 
  that translate the  #fieldname# from the SYS:form into the $fieldname$ 
  variables that we're  use to seeing.   For example, take a look at 
  this filter:  NTE:SHR:TranslateNotificationMessageINC1_100   It very 
  well could be the one that you need to modify for your change.   Hope 
  that helps,  LisaD   -Original Message-  From: Action 
  Request System discussion list(ARSList)  [mailto
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Password Checking Problem

2008-05-14 Thread Grooms, Frederick W
According to the 6.3 docs it is supposed to generate the error.
 
Application-Confirm-Password password 
Validates if the password is the password for the current user. 
For password, you can use a reference to field 102, which is the
password field. Returns ARERR 4549 or no error: 
- No error-Indicates success of the password confirmation, with a
returned value of NULL.
- ARERR 4549-Indicates failure of the password confirmation.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of manjunath badiger
Sent: Wednesday, May 14, 2008 4:27 AM
To: arslist@ARSLIST.ORG
Subject: Password Checking Problem


** 
Hi,

I am using @@:Application-Confirm-Password field ID inorder to check
whether user's password is right.
When the password is not correct, it pops-up the following error
message:


ARERR [4549] Confirming password is not valid for the current user
Set fields active link running a process failed (ARERR 1603)


Althought i am trying to store this result in a result field. Now how
do i
prevent this pop-up...
My intent here is to avoid this pop-up and provide a customised error
mesg.

I am using remedy ARS 6.3 it works good for remedy 7.0

Please do let me know

 

 
Thanks
Manjunath



Bring your gang together. Do your thing. Find your favourite Yahoo!
Group.
http://in.rd.yahoo.com/tagline_groups_9/*http://in.promos.yahoo.com/gro
ups/  __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Are html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Question: Overview Console

2008-05-14 Thread T. Dee
Currently when I make changes to the Overview Console I STOP and
RESTART Remedy Services.

Is there another way of restting the Overview Console without stopping
and restarting Remedy Services?

Thanks!

Ty

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Question: Overview Console

2008-05-14 Thread Gayford, Matthew C.
You shouldn't have to stop/restart anything unless you're making changes
that call vendor forms.

Matthew C. Gayford
Technology Research  Development
Information Technology Systems Division
University of North Carolina Wilmington 
(910) 962-7177


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Wednesday, May 14, 2008 10:42 AM
To: arslist@ARSLIST.ORG
Subject: Question: Overview Console

Currently when I make changes to the Overview Console I STOP and
RESTART Remedy Services.

Is there another way of restting the Overview Console without stopping
and restarting Remedy Services?

Thanks!

Ty


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Import into HPD:HelpDesk ARS 6.3

2008-05-14 Thread Sanford, Claire
Jamie,
 
If you can give us some more information about your environment and what
you are using for the automation, we can probably give you more
assistance.
 
an example would be
 
ARS 6.3 Patch 18 
HD 6.0 
Oracle 10 w/9 libraries 
Oracle on a remote server 
Windows 2003 4 gig on app server and 8 gig on DB server 

 
Claire



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heinzel, Jamie
Sent: Tuesday, May 13, 2008 1:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Import into HPD:HelpDesk ARS 6.3


** 

Thanks for all your help and guidance on this, I'll try what you said
and see how it goes.

 

Jamie

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Tuesday, May 13, 2008 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Import into HPD:HelpDesk ARS 6.3

 

Jamie,

Without knowing all of the ins and outs of your environment and exactly
what you are trying to do it's hard to say what the best route may be,
but if it were me, I would probably create a Display Only staging form
with just the fields that are being imported. I would have workflow that
executes On Merge to push the data from the staging form into the
HPD:HelpDesk form (as this will cause a submit and all workflow that
executes on submit will execute). There's many ways to skin this cat,
this is just one of them.

 

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heinzel, Jamie
Sent: Tuesday, May 13, 2008 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Import into HPD:HelpDesk ARS 6.3

 

No this is going to be an ongoing process. I'm still trying to figure
out the best way to do it, so all options are on the table. I think it's
obvious from my posts that I'm fairly new to Remedy. This is part of a
larger automation project that I'm working on and scripted creation of
Remedy profiles and tickets are part of it.

 

Jamie

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish
Sent: Tuesday, May 13, 2008 1:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Import into HPD:HelpDesk ARS 6.3

 

To Rick's point: The issue you are running into, I believe, is that none
of the filter workflow associated with generating a help desk ticket
executes on merge, therefore, the SHR:ConsolidatedList form isn't going
to be populated. If this is going to be an ongoing process you will need
to modify some of the out-of-the-box filter workflow. If it's a one-time
thing you could, conceivable, find a way to trigger the push OR export
what you have imported and import that export into the
SHR:ConsolidatedList.

 

 

Scott Parrish
IT Prophets, LLC
(770) 653-5203
www.itprophets.com 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Tuesday, May 13, 2008 1:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Import into HPD:HelpDesk ARS 6.3

 

** The support console is sourced in the SHR:ConsolidatedList form.  You
will need to look at the workflow that pushes to there when a Help Desk
record is created, and ensure that workflow fires when you import your
tickets.

Rick

On Tue, May 13, 2008 at 10:01 AM, Heinzel, Jamie [EMAIL PROTECTED]
wrote:

** 

I'm looking for some assistance in importing from a csv into
HPD:HelpDesk to create tickets as part of a batch process when a new
user is set up. I have the import working, but it doesn't seem that the
tickets are showing up in Remedy User. They show up if I do a search for
open tickets, but they aren't showing up in the support console for some
reason.

 

I can provide any additional information that is needed to help out.

 

If someone has done this before or if someone can point me in the right
direction it would be great.

 

Thanks in advance,

 

Jamie



This communication may contain confidential Protected Health
Information. This information is intended only for the use of the
individual or entity to which it is addressed. The authorized recipient
of this information is prohibited from disclosing this information to
any other party unless required to do so by law or regulation and is
required to destroy the information after its stated need has been
fulfilled.

If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or action taken in reliance on the
contents of these documents is strictly prohibited by federal law. If
you have received this information in error, please notify the sender
immediately and arrange for the return or destruction of these
documents.


__
This email has been scanned by 

Re: Question: Overview Console

2008-05-14 Thread T. Dee
I added Assigned Group and added 3 new records to SHR:ARDBCFields.



On 5/14/08, Gayford, Matthew C. [EMAIL PROTECTED] wrote:
 You shouldn't have to stop/restart anything unless you're making changes
 that call vendor forms.

 Matthew C. Gayford
 Technology Research  Development
 Information Technology Systems Division
 University of North Carolina Wilmington
 (910) 962-7177


 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
 Sent: Wednesday, May 14, 2008 10:42 AM
 To: arslist@ARSLIST.ORG
 Subject: Question: Overview Console

 Currently when I make changes to the Overview Console I STOP and
 RESTART Remedy Services.

 Is there another way of restting the Overview Console without stopping
 and restarting Remedy Services?

 Thanks!

 Ty

 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Question: Overview Console

2008-05-14 Thread Audrey H Franklin
You will need to restart the Plug-in server.

Audrey H. Franklin
Senior Systems Analyst
ITS-ECOMS
New York University
Tel: 212.998.1146
[EMAIL PROTECTED]

- Original Message -
From: T. Dee [EMAIL PROTECTED]
Date: Wednesday, May 14, 2008 10:54 am
Subject: Re: Question: Overview Console
To: arslist@ARSLIST.ORG


 I added Assigned Group and added 3 new records to SHR:ARDBCFields.
  
  
  
  On 5/14/08, Gayford, Matthew C. [EMAIL PROTECTED] wrote:
   You shouldn't have to stop/restart anything unless you're making changes
   that call vendor forms.
  
   Matthew C. Gayford
   Technology Research  Development
   Information Technology Systems Division
   University of North Carolina Wilmington
   (910) 962-7177
  
  
   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
   Sent: Wednesday, May 14, 2008 10:42 AM
   To: arslist@ARSLIST.ORG
   Subject: Question: Overview Console
  
   Currently when I make changes to the Overview Console I STOP and
   RESTART Remedy Services.
  
   Is there another way of restting the Overview Console without stopping
   and restarting Remedy Services?
  
   Thanks!
  
   Ty
  
   
   ___
   UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
   Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
  
   
 ___
   UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
   Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
  
  
  
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
  

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


MidTier and Global Fields

2008-05-14 Thread Frank Caruso
I am getting the following error message on MT 7.0.1 p7 and MT 6.3p20 when a
form opens: The current global field values are too large to be stored
(ARERR 9360)

On the form there are several global fields and they are all size 0. I have
work flow that walks a table and builds a very large string of values and
sets the end value into a global field. I have narrowed it down to a size
limitation of 1059 characters. If there are more than that I get the error.

This does not happen on the 6.3p20 User Tool.


Frank

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Debugging runmacro in ARS 6.3

2008-05-14 Thread Reiser, John J
Hello Listers,
ARS 6.3 Patch 21
MS SQLServer 2000

I am trying to update a runmacro used in an Escalation Run Process.
Is there anyway to debug the runmacro to see why it stopped working?
The macro logs in as a valid user. Performs a query passed in by the -p
parameter and Reports To File a simple tab delimited ARS Report.

This newly recorded macro works in the WUT but will not produce any
output when executed with runmacro.

I have all of the paths specified. and the servername is fully qualified
in the macro as well as with the -x parameter.

Workflow.log doesn't get activated by the runmacro and there is little
to see in the API, SQL and Escalation logs.

I guess I'm looking for the verbose switch?

TIA,


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 www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: MidTier and Global Fields

2008-05-14 Thread Grooms, Frederick W
I believe on the Web a Global field is stored as a cookie so you have to
deal with the limitations of cookies by the browser.
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Wednesday, May 14, 2008 10:17 AM
To: arslist@ARSLIST.ORG
Subject: MidTier and Global Fields


** I am getting the following error message on MT 7.0.1 p7 and MT 6.3p20
when a form opens: The current global field values are too large to be
stored (ARERR 9360)

On the form there are several global fields and they are all size 0. I
have work flow that walks a table and builds a very large string of
values and sets the end value into a global field. I have narrowed it
down to a size limitation of 1059 characters. If there are more than
that I get the error.

This does not happen on the 6.3p20 User Tool.


Frank

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


synchronization of servers

2008-05-14 Thread Zoltán Nemes
Dear Listers!

There will be major changes in our Remedy system architecture soon and we are 
trying to be prepared with a concept to support it.

Our company currently uses one production server for ticketing purpose. The 
server is located in Europe.
According to the new plans, there will be a new production server deployed for 
the USA region. Both these servers has to be real-time synchronized and they 
would have to contain the same case related data, so that they can replace each 
other in case of failures or outages.

The no-brainer solution of course would be DSO. But considering the amount of 
data to be transferred, our belief is that with DSO the overhead on the systems 
will be huge and this leads to intensive network traffic that would cause 
performance problems for us.

We are planning to use a solution based on a database syncronization product 
called Shareplex for Oracle.

Does anyone of you have experience in synchronizing Remedy using this product? 
What are you guys using for syncing your systems?

I would appreciate if you shared your ideas with me. 

Thanks,
Zoltan





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: synchronization of servers

2008-05-14 Thread Rick Cook
I don't have any experience with this product, but I will say that by doing
your syncing via DB replication, I think you're on the right track.  It's
the fastest way I know of to do what you're doing.

Rick

On Wed, May 14, 2008 at 8:43 AM, Zoltán Nemes [EMAIL PROTECTED] wrote:

 ** Dear Listers!

 There will be major changes in our Remedy system architecture soon and we
 are trying to be prepared with a concept to support it.

 Our company currently uses one production server for ticketing purpose. The
 server is located in Europe.
 According to the new plans, there will be a new production server deployed
 for the USA region. Both these servers has to be real-time synchronized and
 they would have to contain the same case related data, so that they can
 replace each other in case of failures or outages.

 The no-brainer solution of course would be DSO. But considering the amount
 of data to be transferred, our belief is that with DSO the overhead on the
 systems will be huge and this leads to intensive network traffic that would
 cause performance problems for us.

 We are planning to use a solution based on a database syncronization
 product called Shareplex for Oracle.

 Does anyone of you have experience in synchronizing Remedy using this
 product? What are you guys using for syncing your systems?

 I would appreciate if you shared your ideas with me.

 Thanks,
 Zoltan

  __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: email question

2008-05-14 Thread Gary Opela (Corporate)
I never did see a response to this, so I'll repost it.

 

Basically, I have a filter that does an email notification. In the User
Name: field, I have $Originator$; $data_Alt Approval Manager$;
$data_Approval Manager$; $data_Purchaser$

 

This gets translated to the users that are in the field just fine, but
it's not looking up their email addresses from the user form, It's just
trying to send the email to the literal value that is in that field. For
instance, if Bob.Smith is in data_Alt Approval Manager, then it is
trying to send an email to Bob.Smith instead of [EMAIL PROTECTED],
which would be in his user account.

 

Any suggestions? Am I using the wrong delimiter?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Gary Opela (Corporate) 
Sent: Tuesday, May 13, 2008 3:08 PM
To: 'arslist@ARSLIST.ORG'
Subject: email question

 

I am doing a notify filter that uses email. On the Recipient line, I'm
specifying a mix of field values and groups.

 

I currently have the recipient set as: $Originator$; Finance; Contracts;
$data_Purchaser$

 

Originator and data_Purchaser fields, Finance and Contracts are groups.


I want the email to go out to the Originator, the data_Purchaser, and
everyone in contracts and finance.


I'm having a few issues that I'm not yet sure from where they are
coming. I just wanted to make sure I had this part of it correct first.

 

Any comments?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: email question

2008-05-14 Thread Decou, Candace M
Gary - in the filter in the Mechanism did you select Email?  Try
selecting User Default or Cross Reference and see if that will go get
the correct value for you.  

:-)

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Wednesday, May 14, 2008 8:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: email question

 

I never did see a response to this, so I'll repost it.

 

Basically, I have a filter that does an email notification. In the User
Name: field, I have $Originator$; $data_Alt Approval Manager$;
$data_Approval Manager$; $data_Purchaser$

 

This gets translated to the users that are in the field just fine, but
it's not looking up their email addresses from the user form, It's just
trying to send the email to the literal value that is in that field. For
instance, if Bob.Smith is in data_Alt Approval Manager, then it is
trying to send an email to Bob.Smith instead of [EMAIL PROTECTED],
which would be in his user account.

 

Any suggestions? Am I using the wrong delimiter?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Gary Opela (Corporate) 
Sent: Tuesday, May 13, 2008 3:08 PM
To: 'arslist@ARSLIST.ORG'
Subject: email question

 

I am doing a notify filter that uses email. On the Recipient line, I'm
specifying a mix of field values and groups.

 

I currently have the recipient set as: $Originator$; Finance; Contracts;
$data_Purchaser$

 

Originator and data_Purchaser fields, Finance and Contracts are groups.


I want the email to go out to the Originator, the data_Purchaser, and
everyone in contracts and finance.


I'm having a few issues that I'm not yet sure from where they are
coming. I just wanted to make sure I had this part of it correct first.

 

Any comments?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: email question

2008-05-14 Thread Gary Opela (Corporate)
Issue solved. A former co-worker sent the following to me off-list:

 

4 In the User Name field, enter the name of the users or groups to
notify.

You can enter a maximum of 255 characters. Use the User Name list to
insert

fields or keywords. Click the text edit button to open a Text dialog box
for

easier data entry.

74 Chapter 4-Specifying workflow actions

BMC Remedy Action Request System 7.0

To specify one or more recipients, enter any of the following choices

separated by hard returns (the server evaluates each line separately):

 AR System user logins

 AR System groups

This option enables you to send notifications to all members of a group

simultaneously. When you include a group in a notification, you are not

notifying the group itself but rather the individuals in the group. The

group name expands the notification to each individual. Do not put the

group name in dollar signs ($) or in quotation marks.

Do not use group notifications as an email system for broadcast items

because the server processes a notification for each member. An email

alias is more efficient.

 

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M
Sent: Wednesday, May 14, 2008 10:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: email question

 

Gary - in the filter in the Mechanism did you select Email?  Try
selecting User Default or Cross Reference and see if that will go get
the correct value for you.  

:-)

 

Candace DeCou

DOI Remedy Systems Analyst 
Verizon Business 
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  

 

Verizon Business - global capability, personal accountability. 

This e-mail is strictly confidential and intended only for use by the
addressee unless otherwise indicated



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Wednesday, May 14, 2008 8:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: email question

 

I never did see a response to this, so I'll repost it.

 

Basically, I have a filter that does an email notification. In the User
Name: field, I have $Originator$; $data_Alt Approval Manager$;
$data_Approval Manager$; $data_Purchaser$

 

This gets translated to the users that are in the field just fine, but
it's not looking up their email addresses from the user form, It's just
trying to send the email to the literal value that is in that field. For
instance, if Bob.Smith is in data_Alt Approval Manager, then it is
trying to send an email to Bob.Smith instead of [EMAIL PROTECTED],
which would be in his user account.

 

Any suggestions? Am I using the wrong delimiter?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Gary Opela (Corporate) 
Sent: Tuesday, May 13, 2008 3:08 PM
To: 'arslist@ARSLIST.ORG'
Subject: email question

 

I am doing a notify filter that uses email. On the Recipient line, I'm
specifying a mix of field values and groups.

 

I currently have the recipient set as: $Originator$; Finance; Contracts;
$data_Purchaser$

 

Originator and data_Purchaser fields, Finance and Contracts are groups.


I want the email to go out to the Originator, the data_Purchaser, and
everyone in contracts and finance.


I'm having a few issues that I'm not yet sure from where they are
coming. I just wanted to make sure I had this part of it correct first.

 

Any comments?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Answers Are html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: synchronization of servers

2008-05-14 Thread Robert Molenda
The issue with DB Sync is that logically youwould need a server-group to do
this.

In the past DSO has never been an issue of performance in my experiance.

On Wed, May 14, 2008 at 8:48 AM, Rick Cook [EMAIL PROTECTED] wrote:

 ** I don't have any experience with this product, but I will say that by
 doing your syncing via DB replication, I think you're on the right track.
 It's the fastest way I know of to do what you're doing.

 Rick


 On Wed, May 14, 2008 at 8:43 AM, Zoltán Nemes [EMAIL PROTECTED] wrote:

 **  Dear Listers!

 There will be major changes in our Remedy system architecture soon and we
 are trying to be prepared with a concept to support it.

 Our company currently uses one production server for ticketing purpose.
 The server is located in Europe.
 According to the new plans, there will be a new production server deployed
 for the USA region. Both these servers has to be real-time synchronized and
 they would have to contain the same case related data, so that they can
 replace each other in case of failures or outages.

 The no-brainer solution of course would be DSO. But considering the amount
 of data to be transferred, our belief is that with DSO the overhead on the
 systems will be huge and this leads to intensive network traffic that would
 cause performance problems for us.

 We are planning to use a solution based on a database syncronization
 product called Shareplex for Oracle.

 Does anyone of you have experience in synchronizing Remedy using this
 product? What are you guys using for syncing your systems?

 I would appreciate if you shared your ideas with me.

 Thanks,
 Zoltan

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___




-- 
If it were not for the gutter, my mind would be homeless!

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Import into HPD:HelpDesk ARS 6.3

2008-05-14 Thread Robert Molenda
If you can use web-services, you can also use the standard OOB Web Service:
HelpDesk_Submit_Service, else you must create a queueing form and do the
push into incident as previously suggested...
HTH
Robert

On Wed, May 14, 2008 at 7:46 AM, Sanford, Claire 
[EMAIL PROTECTED] wrote:

 ** Jamie,

 If you can give us some more information about your environment and what
 you are using for the automation, we can probably give you more assistance.

 an example would be


 ARS 6.3 Patch 18
 HD 6.0
 Oracle 10 w/9 libraries
 Oracle on a remote server
 Windows 2003 4 gig on app server and 8 gig on DB server

 Claire

  --
  *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Heinzel, Jamie
 *Sent:* Tuesday, May 13, 2008 1:45 PM

 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Import into HPD:HelpDesk ARS 6.3

   **

 Thanks for all your help and guidance on this, I'll try what you said and
 see how it goes.



 Jamie


  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Scott Parrish
 *Sent:* Tuesday, May 13, 2008 1:49 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Import into HPD:HelpDesk ARS 6.3



 Jamie,

 Without knowing all of the ins and outs of your environment and exactly
 what you are trying to do it's hard to say what the best route may be, but
 if it were me, I would probably create a Display Only staging form with just
 the fields that are being imported. I would have workflow that executes On
 Merge to push the data from the staging form into the HPD:HelpDesk form (as
 this will cause a submit and all workflow that executes on submit will
 execute). There's many ways to skin this cat, this is just one of them.



 Scott Parrish
 IT Prophets, LLC
 (770) 653-5203
 www.itprophets.com
  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Heinzel, Jamie
 *Sent:* Tuesday, May 13, 2008 1:40 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Import into HPD:HelpDesk ARS 6.3



 No this is going to be an ongoing process. I'm still trying to figure out
 the best way to do it, so all options are on the table. I think it's obvious
 from my posts that I'm fairly new to Remedy. This is part of a larger
 automation project that I'm working on and scripted creation of Remedy
 profiles and tickets are part of it.



 Jamie


  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Scott Parrish
 *Sent:* Tuesday, May 13, 2008 1:32 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Import into HPD:HelpDesk ARS 6.3



 To Rick's point: The issue you are running into, I believe, is that none of
 the filter workflow associated with generating a help desk ticket executes
 on merge, therefore, the SHR:ConsolidatedList form isn't going to be
 populated. If this is going to be an ongoing process you will need to modify
 some of the out-of-the-box filter workflow. If it's a one-time thing you
 could, conceivable, find a way to trigger the push OR export what you have
 imported and import that export into the SHR:ConsolidatedList.





 Scott Parrish
 IT Prophets, LLC
 (770) 653-5203
 www.itprophets.com
  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Rick Cook
 *Sent:* Tuesday, May 13, 2008 1:16 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Import into HPD:HelpDesk ARS 6.3



 ** The support console is sourced in the SHR:ConsolidatedList form.  You
 will need to look at the workflow that pushes to there when a Help Desk
 record is created, and ensure that workflow fires when you import your
 tickets.

 Rick

 On Tue, May 13, 2008 at 10:01 AM, Heinzel, Jamie [EMAIL PROTECTED]
 wrote:

 **

 I'm looking for some assistance in importing from a csv into HPD:HelpDesk
 to create tickets as part of a batch process when a new user is set up. I
 have the import working, but it doesn't seem that the tickets are showing up
 in Remedy User. They show up if I do a search for open tickets, but they
 aren't showing up in the support console for some reason.



 I can provide any additional information that is needed to help out.



 If someone has done this before or if someone can point me in the right
 direction it would be great.



 Thanks in advance,



 Jamie
  --

 This communication may contain confidential Protected Health Information.
 This information is intended only for the use of the individual or entity to
 which it is addressed. The authorized recipient of this information is
 prohibited from disclosing this information to any other party unless
 required to do so by law or regulation and is required to destroy the
 information after its stated need has been fulfilled.

 If you are not the intended recipient, you are hereby 

Re: synchronization of servers

2008-05-14 Thread Rick Cook
In many environments, DSO will work just fine.  Where the network
performance is less than optimal, I wouldn't probably choose it as my first
option.  I have seen it at times not handle hiccups very well (though that
was a couple of versions ago), and if that is still a possibility, given his
requirement, that would be a potential problem at a critical time.

Rick

On Wed, May 14, 2008 at 9:09 AM, Robert Molenda [EMAIL PROTECTED]
wrote:

 ** The issue with DB Sync is that logically youwould need a server-group
 to do this.

 In the past DSO has never been an issue of performance in my experiance.

 On Wed, May 14, 2008 at 8:48 AM, Rick Cook [EMAIL PROTECTED] wrote:

 ** I don't have any experience with this product, but I will say that by
 doing your syncing via DB replication, I think you're on the right track.
 It's the fastest way I know of to do what you're doing.


 Rick


 On Wed, May 14, 2008 at 8:43 AM, Zoltán Nemes [EMAIL PROTECTED] wrote:

 **  Dear Listers!

 There will be major changes in our Remedy system architecture soon and we
 are trying to be prepared with a concept to support it.

 Our company currently uses one production server for ticketing purpose.
 The server is located in Europe.
 According to the new plans, there will be a new production server
 deployed for the USA region. Both these servers has to be real-time
 synchronized and they would have to contain the same case related data, so
 that they can replace each other in case of failures or outages.

 The no-brainer solution of course would be DSO. But considering the
 amount of data to be transferred, our belief is that with DSO the overhead
 on the systems will be huge and this leads to intensive network traffic that
 would cause performance problems for us.

 We are planning to use a solution based on a database syncronization
 product called Shareplex for Oracle.

 Does anyone of you have experience in synchronizing Remedy using this
 product? What are you guys using for syncing your systems?

 I would appreciate if you shared your ideas with me.

 Thanks,
 Zoltan

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___




 --
 If it were not for the gutter, my mind would be homeless! __Platinum
 Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: synchronization of servers

2008-05-14 Thread Wheeler, Dylan
I used Shareplex a couple companies ago. I think they're still using it. We 
were replicating between 2 production server and 2 reporting servers. It worked 
great and I'd definitely use it again if I was on Oracle and had money to burn.
We also tried to switch out Shareplex with DSO to try and save cost but the 
performance wasn't good enough with DSO for our requirements.
As it was put to us by one of the DSO architects
It's DSO, not Replico
:)

- 

Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings  Loan Association, F.A. 
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Zoltán Nemes
Sent: Wednesday, May 14, 2008 8:44 AM
To: arslist@ARSLIST.ORG
Subject: synchronization of servers


** 
Dear Listers!

There will be major changes in our Remedy system architecture soon and 
we are trying to be prepared with a concept to support it.

Our company currently uses one production server for ticketing purpose. 
The server is located in Europe.
According to the new plans, there will be a new production server 
deployed for the USA region. Both these servers has to be real-time 
synchronized and they would have to contain the same case related data, so that 
they can replace each other in case of failures or outages.

The no-brainer solution of course would be DSO. But considering the 
amount of data to be transferred, our belief is that with DSO the overhead on 
the systems will be huge and this leads to intensive network traffic that would 
cause performance problems for us.

We are planning to use a solution based on a database syncronization 
product called Shareplex for Oracle.

Does anyone of you have experience in synchronizing Remedy using this 
product? What are you guys using for syncing your systems?

I would appreciate if you shared your ideas with me. 

Thanks,
Zoltan


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___



This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

AD and CTM:People

2008-05-14 Thread Kathy Morris
Hi,
 
 
AR System: 7.0.1
Thru workflow, data is passed from Active Directory into Remedy vendor  
tables then thru escalations into Remedy CTM:People. We have users  that 
sometimes 
enter the field values in upper/lower case. Whenever they  enter 
uppercase/lower case or leave certain fields BLANK, the record does  not get 
into the 
CTM:People form.  I would like to build workflow that  changes the case to 
LOWERCASE and does error-checking on records that come from  AD that don't make 
it 
into the CTM:People form.  Am I approaching this  correctly, or is there a 
better 
way?



**Wondering what's for Dinner Tonight? Get new twists on family 
favorites at AOL Food.  
(http://food.aol.com/dinner-tonight?NCID=aolfod000301)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Errors when trying to Use the CI Relationship Viewer

2008-05-14 Thread Howard Richter
When I open the CI Relationship View from the CMDB console, I get the error
below. I have checked the mid-tier (running version 7.0.01) and Data
Visuatization Module is on.

Everything else appears to be working (Change Calandar for example).

What am I missing (and Axton or Matt be nice).

As always thanks,

Howard



HTTP Status 500 -

type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
javax.servlet.ServletException: Servlet execution threw an exception
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:222)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)

root cause
java.lang.UnsupportedClassVersionError: com/bmc/cmdb/viewer/CiViewerMain
(Unsupported major.minor version 49.0)
 at java.lang.ClassLoader.defineClass0(Native Method)
 at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
 at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
 at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)
 at java.net.URLClassLoader.access$100(URLClassLoader.java:55)
 at java.net.URLClassLoader$1.run(URLClassLoader.java:194)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
 at
com.remedy.arsys.plugincontainer.impl.PluginFactory$PluginInfo.getPlugin(Unknown
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginFactory.getInstance(Unknown
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContextImpl.init(Unknown
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContainer.setupEnv(Unknown
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContainer.doRequest(Unknown
Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.postInternal(Unknown Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.doPost(Unknown Source)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:716)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
 at

Re: synchronization of servers

2008-05-14 Thread LJ Longwing
The only caveat that I would put on this is that if you are doing total db
sync then you would need to do development on only one of the servers (or
deploys as it may be) and then restart the other remedy server after the
modifications were made, or run an arsignal.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Wednesday, May 14, 2008 9:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: synchronization of servers


** I don't have any experience with this product, but I will say that by
doing your syncing via DB replication, I think you're on the right track.
It's the fastest way I know of to do what you're doing.

Rick


On Wed, May 14, 2008 at 8:43 AM, Zoltán Nemes [EMAIL PROTECTED] wrote:


** 
Dear Listers!

There will be major changes in our Remedy system architecture soon and we
are trying to be prepared with a concept to support it.

Our company currently uses one production server for ticketing purpose. The
server is located in Europe.
According to the new plans, there will be a new production server deployed
for the USA region. Both these servers has to be real-time synchronized and
they would have to contain the same case related data, so that they can
replace each other in case of failures or outages.

The no-brainer solution of course would be DSO. But considering the amount
of data to be transferred, our belief is that with DSO the overhead on the
systems will be huge and this leads to intensive network traffic that would
cause performance problems for us.

We are planning to use a solution based on a database syncronization product
called Shareplex for Oracle.

Does anyone of you have experience in synchronizing Remedy using this
product? What are you guys using for syncing your systems?

I would appreciate if you shared your ideas with me. 

Thanks,
Zoltan


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Errors when trying to Use the CI Relationship Viewer

2008-05-14 Thread Phil Murnane
Howard:

What version of Apache httpd and tomcat are you running?

--Phil


- Original Message 
From: Howard Richter [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 9:59:11 AM
Subject: Errors when trying to Use the CI Relationship Viewer

** 
When I open the CI Relationship View from the CMDB console, I get the error 
below. I have checked the mid-tier (running version 7.0.01) and Data 
Visuatization Module is on. 
 
Everything else appears to be working (Change Calandar for example).
 
What am I missing (and Axton or Matt be nice).
 
As always thanks,
 
Howard
 
 
 
HTTP Status 500 - 

type Exception report
message 
description The server encountered an internal error () that prevented it from 
fulfilling this request.
exception 
javax.servlet.ServletException: Servlet execution threw an exception
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:222)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
 at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
 at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
 at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)

root cause 
java.lang.UnsupportedClassVersionError: com/bmc/cmdb/viewer/CiViewerMain 
(Unsupported major.minor version 49.0)
 at java.lang.ClassLoader.defineClass0(Native Method)
 at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
 at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
 at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)
 at java.net.URLClassLoader.access$100(URLClassLoader.java:55)
 at java.net.URLClassLoader$1.run(URLClassLoader.java:194)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
 at 
com.remedy.arsys.plugincontainer.impl.PluginFactory$PluginInfo.getPlugin(Unknown
 Source)
 at com.remedy.arsys.plugincontainer.impl.PluginFactory.getInstance(Unknown 
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContextImpl.init(Unknown 
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContainer.setupEnv(Unknown 
Source)
 at com.remedy.arsys.plugincontainer.impl.PluginContainer.doRequest(Unknown 
Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.postInternal(Unknown Source)
 at com.remedy.arsys.stubs.GoatHttpServlet.doPost(Unknown Source)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:716)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
 at 

Re: Max Index on Form!

2008-05-14 Thread Rick Cook
The two things to look in determining the appropriate maximum number of
indexes for a form are the usage of the form and the number of rows
involved.  If you have only a few hundred or thousand rows in a table,
indexes probably won't help all that much, and performance might be
negatively impacted if you went way over the top in your indexing.  (Aside:
Remedy put like 16 on HPD:HelpDesk in ITSM 7.  Draw whatever conclusions you
like from that).

On tables with ~100k+ rows, the basic rule is that indexes speed up queries,
but slow down submits, because on each submit, every index must be updated.
So on forms where lots of records are submitted, you might want to keep the
number of indexes lower than on a form against which reports are run.  7
indexes is not excessive, but is starting to get to the point where adding
more would probably be noticed on submits.  There isn't a hard number at
which your performance will fall off a cliff, you will just notice gradual
degradation of performance as the number increases beyond somewhere around
7.  It's up to you to find the best balance of performance and functionality
for your installation.

One other thing to look at, if you haven't already, is how the indexes you
have in place are being used, and whether changing or removing one or more
of those makes sense.  That takes a lot of analysis of SQL logs, and working
with your DBA to determine which searches are taking the most time, etc.

Rick

On Wed, May 14, 2008 at 10:35 AM, Tadeu Augusto Dutra Pinto 
[EMAIL PROTECTED] wrote:

 ** Hi all,

 I'd like to know if has a white paper that describes what's max number of
 index to a form...

 I've read a document from 2003 and I've noticed that more than 7 index (or
 4 composite index) in one form is bad...


 I have an application that has a form with 8 index (some of them composite
 index) ... and we're having problems with performance (searches in
 database).. I'd like to know if it's possible to insert more index in this
 form!

 Remembering: I'd like to improve performance...


 Att,
 Tadeu Augusto Dutra Pinto
 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Max Index on Form!

2008-05-14 Thread john rosquist
Tadeu,
Indexesare a balencing act.  the more you have the more options the sql 
analyzer has to construct an optimal execution plan.  The cost is at the write, 
meaning commit, time. the system has to update all the indexes to maintain 
system integrity.  This cost time during the commit phase.
If your data is infrequently written or change, more indexes are ok.  If the 
data is volital or not highly selective, more indexes are bad.
the answer is it depends on your data.
John


- Original Message 
From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 1:35:46 PM
Subject: Max Index on Form!

** 
Hi all,
 
I'd like to know if has a white paper that describes what's max number of index 
to a form...
 
I've read a document from 2003 and I've noticed that more than 7 index (or 4 
composite index) in one form is bad...
 
 
I have an application that has a form with 8 index (some of them composite 
index) ... and we're having problems with performance (searches in database).. 
I'd like to know if it's possible to insert more index in this form!
 
Remembering: I'd like to improve performance...
 
 
Att,
Tadeu Augusto Dutra Pinto__Platinum Sponsor: www.rmsportal.com ARSlist: Where 
the Answers Are html___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: AD and CTM:People

2008-05-14 Thread Pierson, Shawn
That is the way I did it, including defaulting some NULL fields that
Remedy requires.  I have an escalation that pulls the AD data (via a
vendor form) into a staging table, which then uses filters to do
validations and auto-population of some data, then if it passes all the
validations, passes it into the CTM:People form and all the related
forms that need populated.  It sounds like you already have that, but
need to use a LOWER() function in your Push Fields that passes the
Remedy Login Name field.



Something else that will be useful for you is to set up another filter
to find users to automatically disable too.  In my filter to do that, I
have:

(( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR (
'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050))

The userAccountControl field are set to those values when a person is
de-activated, so you can create a filter to set them to Obsolete in
CTM:People as well as set Support Staff? To No and remove all their
permissions.  This helps quite a bit in keeping license costs down
because you're not wasting licenses by maintaining them for people that
are no longer with the company.



Shawn Pierson



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris
Sent: Wednesday, May 14, 2008 11:37 AM
To: arslist@ARSLIST.ORG
Subject: AD and CTM:People



**

Hi,





AR System: 7.0.1

Thru workflow, data is passed from Active Directory into Remedy vendor
tables then thru escalations into Remedy CTM:People. We have users that
sometimes enter the field values in upper/lower case. Whenever they
enter uppercase/lower case or leave certain fields BLANK, the record
does not get into the CTM:People form.  I would like to build workflow
that changes the case to LOWERCASE and does error-checking on records
that come from AD that don't make it into the CTM:People form.  Am I
approaching this correctly, or is there a better way?







Wondering what's for Dinner Tonight? Get new twists on family favorites
at AOL Food
http://food.aol.com/dinner-tonight?NCID=aolfod000301 .

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___


Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Max Index on Form!

2008-05-14 Thread Tadeu Augusto Dutra Pinto
Hi all,
 
I'd like to know if has a white paper that describes what's max number of index 
to a form...
 
I've read a document from 2003 and I've noticed that more than 7 index (or 4 
composite index) in one form is bad...
 
 
I have an application that has a form with 8 index (some of them composite 
index) ... and we're having problems with performance (searches in database).. 
I'd like to know if it's possible to insert more index in this form!
 
Remembering: I'd like to improve performance...
 
 
Att,
Tadeu Augusto Dutra Pinto

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Max Index on Form!

2008-05-14 Thread Pierson, Shawn
Tadeu,



I don't think it's a matter of what the system allows, but what is best
practices.  There is no single right answer.  You have to consider how
many records are in the table, what the most common searches will be,
etc.  It's something that you need to work with a DBA on.  They can run
SQL Profiler and other tools to be able to determine what is causing the
most slowdowns in the queries.  Then, when you look at that and see the
need for a new index, you can create a new one.



Shawn Pierson



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Wednesday, May 14, 2008 12:36 PM
To: arslist@ARSLIST.ORG
Subject: Max Index on Form!



**

Hi all,



I'd like to know if has a white paper that describes what's max number
of index to a form...



I've read a document from 2003 and I've noticed that more than 7 index
(or 4 composite index) in one form is bad...





I have an application that has a form with 8 index (some of them
composite index) ... and we're having problems with performance
(searches in database).. I'd like to know if it's possible to insert
more index in this form!



Remembering: I'd like to improve performance...





Att,

Tadeu Augusto Dutra Pinto

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___


Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: AD and CTM:People

2008-05-14 Thread Rick Cook
Shawn's approach is a very sound one; I've used it myself.  Having that
staging form means that you can do whatever you want/need to the data there,
and then just push the records that really need updating to CTM:People.
Makes a big difference when you're dealing with thousands of people.

Rick

On Wed, May 14, 2008 at 10:53 AM, Pierson, Shawn [EMAIL PROTECTED]
wrote:

 **

 That is the way I did it, including defaulting some NULL fields that Remedy
 requires.  I have an escalation that pulls the AD data (via a vendor form)
 into a staging table, which then uses filters to do validations and
 auto-population of some data, then if it passes all the validations, passes
 it into the CTM:People form and all the related forms that need populated.
 It sounds like you already have that, but need to use a LOWER() function in
 your Push Fields that passes the Remedy Login Name field.



 Something else that will be useful for you is to set up another filter to
 find users to automatically disable too.  In my filter to do that, I have:

 (( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR (
 'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050))

 The userAccountControl field are set to those values when a person is
 de-activated, so you can create a filter to set them to Obsolete in
 CTM:People as well as set Support Staff? To No and remove all their
 permissions.  This helps quite a bit in keeping license costs down because
 you're not wasting licenses by maintaining them for people that are no
 longer with the company.



 Shawn Pierson



 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Kathy Morris
 *Sent:* Wednesday, May 14, 2008 11:37 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* AD and CTM:People



 **

 Hi,





 AR System: 7.0.1

 Thru workflow, data is passed from Active Directory into Remedy vendor
 tables then thru escalations into Remedy CTM:People. We have users that
 sometimes enter the field values in upper/lower case. Whenever they enter
 uppercase/lower case or leave certain fields BLANK, the record does not get
 into the CTM:People form.  I would like to build workflow that changes the
 case to LOWERCASE and does error-checking on records that come from AD that
 don't make it into the CTM:People form.  Am I approaching this correctly, or
 is there a better way?



   --

 Wondering what's for Dinner Tonight? Get new twists on family favorites at
 AOL Food http://food.aol.com/dinner-tonight?NCID=aolfod000301.

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___
  Private and confidential as detailed 
 herehttp://www.sug.com/disclaimers/default.htm#Mail.
 If you cannot access hyperlink, please e-mail sender.
 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


RES: Max Index on Form!

2008-05-14 Thread Tadeu Augusto Dutra Pinto
Thanks for your reply Rick, John and Shawn...
 
Some data:
 
- form receives about 15K records/month; 
- total number of records is almost 480K;
- number of fields on form are 168;
- 8 simple index;
- 2 composite index (two fields per index);
 
 
Thankx!
Tadeu Augusto Dutra Pinto
 



De: Action Request System discussion list(ARSList) em nome de Rick Cook
Enviada: qua 14/5/2008 14:53
Para: arslist@ARSLIST.ORG
Assunto: Re: Max Index on Form!


** The two things to look in determining the appropriate maximum number of 
indexes for a form are the usage of the form and the number of rows involved.  
If you have only a few hundred or thousand rows in a table, indexes probably 
won't help all that much, and performance might be negatively impacted if you 
went way over the top in your indexing.  (Aside: Remedy put like 16 on 
HPD:HelpDesk in ITSM 7.  Draw whatever conclusions you like from that).

On tables with ~100k+ rows, the basic rule is that indexes speed up queries, 
but slow down submits, because on each submit, every index must be updated.  So 
on forms where lots of records are submitted, you might want to keep the number 
of indexes lower than on a form against which reports are run.  7 indexes is 
not excessive, but is starting to get to the point where adding more would 
probably be noticed on submits.  There isn't a hard number at which your 
performance will fall off a cliff, you will just notice gradual degradation of 
performance as the number increases beyond somewhere around 7.  It's up to you 
to find the best balance of performance and functionality for your installation.

One other thing to look at, if you haven't already, is how the indexes you have 
in place are being used, and whether changing or removing one or more of those 
makes sense.  That takes a lot of analysis of SQL logs, and working with your 
DBA to determine which searches are taking the most time, etc.

Rick


On Wed, May 14, 2008 at 10:35 AM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] 
wrote:


** 
Hi all,
 
I'd like to know if has a white paper that describes what's max number 
of index to a form...
 
I've read a document from 2003 and I've noticed that more than 7 index 
(or 4 composite index) in one form is bad...
 
 
I have an application that has a form with 8 index (some of them 
composite index) ... and we're having problems with performance (searches in 
database).. I'd like to know if it's possible to insert more index in this form!
 
Remembering: I'd like to improve performance...
 
 
Att,
Tadeu Augusto Dutra Pinto
__Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/  
ARSlist: Where the Answers Are html___


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Errors when trying to Use the CI Relationship Viewer

2008-05-14 Thread Howard Richter
IPhil,

 have 5.5 installed, but the mid-tier is talking to a 4.1 install I have as
well.

hbr

On Wed, May 14, 2008 at 1:26 PM, Phil Murnane [EMAIL PROTECTED] wrote:

 **  Howard:

 What version of Apache httpd and tomcat are you running?

 --Phil

   - Original Message 
 From: Howard Richter [EMAIL PROTECTED]
 To: arslist@ARSLIST.ORG
 Sent: Wednesday, May 14, 2008 9:59:11 AM
 Subject: Errors when trying to Use the CI Relationship Viewer

 ** When I open the CI Relationship View from the CMDB console, I get the
 error below. I have checked the mid-tier (running version 7.0.01) and Data
 Visuatization Module is on.

 Everything else appears to be working (Change Calandar for example).

 What am I missing (and Axton or Matt be nice).

 As always thanks,

 Howard



 HTTP Status 500 -

 
 type Exception report
 message
 description The server encountered an internal error () that prevented it
 from fulfilling this request.
 exception
 javax.servlet.ServletException: Servlet execution threw an exception
  at
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:222)
  at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
  at
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
  at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
  at
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
  at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
  at
 org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
  at
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
  at
 org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
  at
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
  at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
  at
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
  at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
  at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
  at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
  at
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
  at
 org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
  at 
 org.apache.tomcat.util.nethttp://org.apache.tomcat.util.net.tcpworkerthread.ru/
 .TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
  at
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
  at java.lang.Thread.run(Thread.java:534)

 root cause
 java.lang.UnsupportedClassVersionError: com/bmc/cmdb/viewer/CiViewerMain
 (Unsupported major.minor version 49.0)
  at java.lang.ClassLoader.defineClass0(Native Method)
  at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
  at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
  at java.net http://java.net.urlclassloader.de/
 .URLClassLoader.defineClass(URLClassLoader.java:251)
  at java.net.URLClassLoader.access$100(URLClassLoader.java:55)
  at java.net.URLClassLoader$1.run(URLClassLoader.java:194)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.net http://java.net.urlclassloader.fi/
 .URLClassLoader.findClass(URLClassLoader.java:187)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
  at
 com.remedy.arsys.plugincontainer.impl.PluginFactory$PluginInfo.getPlugin(Unknown
 Source)
  at com.remedy.arsys.plugincontainer.impl.PluginFactory.getInstance(Unknown
 Source)
  at com.remedy.arsys.plugincontainer.impl.PluginContextImpl.init(Unknown
 Source)
  at com.remedy.arsys.plugincontainer.impl.PluginContainer.setupEnv(Unknown
 Source)
  at 

Re: Max Index on Form! - Rick's response is recommended reading

2008-05-14 Thread Susan Palmer
Great explanation Rick.  Short, not too involved but yet covers the topic
nicely.  Something everyone needs to review periodically.

Thanks,
Susan

On Wed, May 14, 2008 at 12:53 PM, Rick Cook [EMAIL PROTECTED] wrote:

 ** The two things to look in determining the appropriate maximum number of
 indexes for a form are the usage of the form and the number of rows
 involved.  If you have only a few hundred or thousand rows in a table,
 indexes probably won't help all that much, and performance might be
 negatively impacted if you went way over the top in your indexing.  (Aside:
 Remedy put like 16 on HPD:HelpDesk in ITSM 7.  Draw whatever conclusions you
 like from that).

 On tables with ~100k+ rows, the basic rule is that indexes speed up
 queries, but slow down submits, because on each submit, every index must be
 updated.  So on forms where lots of records are submitted, you might want to
 keep the number of indexes lower than on a form against which reports are
 run.  7 indexes is not excessive, but is starting to get to the point where
 adding more would probably be noticed on submits.  There isn't a hard number
 at which your performance will fall off a cliff, you will just notice
 gradual degradation of performance as the number increases beyond somewhere
 around 7.  It's up to you to find the best balance of performance and
 functionality for your installation.

 One other thing to look at, if you haven't already, is how the indexes you
 have in place are being used, and whether changing or removing one or more
 of those makes sense.  That takes a lot of analysis of SQL logs, and working
 with your DBA to determine which searches are taking the most time, etc.

 Rick


 On Wed, May 14, 2008 at 10:35 AM, Tadeu Augusto Dutra Pinto 
 [EMAIL PROTECTED] wrote:

 ** Hi all,

 I'd like to know if has a white paper that describes what's max number of
 index to a form...

 I've read a document from 2003 and I've noticed that more than 7 index (or
 4 composite index) in one form is bad...


 I have an application that has a form with 8 index (some of them composite
 index) ... and we're having problems with performance (searches in
 database).. I'd like to know if it's possible to insert more index in this
 form!

 Remembering: I'd like to improve performance...


 Att,
 Tadeu Augusto Dutra Pinto
 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Field Meta Properties?

2008-05-14 Thread William Rentfrow
I'm going to put this in as an RFE - I highly expect to get shot down
even though it would save a LOT of coding work at times.
 
First though I thought I'd ask for input and criticism of the idea.
 
Frequently I want workflow to fire on dependencies like a field being
visible/hidden or a field value having been changed.  TR/DB value
comparisons frequently do not do it depending on what I'm trying to
accomplish.
 
What I'd really like to be able to do at least in Active Links is a Run
IF that went something like:
 
'Status'.changed=1
 
or
 
'Myfield.visible=0
 
Just about every GUI coding platform I've seen has things like this.
 
I'm also going to put in an RFE for improved logging for things like
Dialog Open/Close field mappings, etc.
 
Crazy requests?  What say you?
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Misi Mladoniczky
Hi,

The TR/DB-functionality allways does it. The problem is that the syntax
is, for some very obscure reason, not available in Active Links.

('Status' != 'DB.Status') is the exact same thing as ('Status'.changed =
1) would be. I see no point in changing the syntax, but it would be nice
to use it in Active Links.

The Hidden/Visible stuff is less useful. It can allways be tracked with a
display-only-flag. It does no great harm to do one extra Hide or Show...

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

 I'm going to put this in as an RFE - I highly expect to get shot down
 even though it would save a LOT of coding work at times.

 First though I thought I'd ask for input and criticism of the idea.

 Frequently I want workflow to fire on dependencies like a field being
 visible/hidden or a field value having been changed.  TR/DB value
 comparisons frequently do not do it depending on what I'm trying to
 accomplish.

 What I'd really like to be able to do at least in Active Links is a Run
 IF that went something like:

 'Status'.changed=1

 or

 'Myfield.visible=0

 Just about every GUI coding platform I've seen has things like this.

 I'm also going to put in an RFE for improved logging for things like
 Dialog Open/Close field mappings, etc.

 Crazy requests?  What say you?

 William Rentfrow, Principal Consultant
 [EMAIL PROTECTED]
 C 701-306-6157
 O 952-432-0227


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

 --
 This message was scanned by ESVA and is believed to be clean.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Rick Cook
William, I wonder if we'll have functionality like that in the new Eclipse
tool in 7.5?  Could anyone from BMC feel comfortable commenting generically
on the issue?

Rick

On Wed, May 14, 2008 at 12:00 PM, William Rentfrow 
[EMAIL PROTECTED] wrote:

 ** I'm going to put this in as an RFE - I highly expect to get shot down
 even though it would save a LOT of coding work at times.

 First though I thought I'd ask for input and criticism of the idea.

 Frequently I want workflow to fire on dependencies like a field being 
 visible/hidden
 or a field value having been changed.  TR/DB value comparisons frequently do
 not do it depending on what I'm trying to accomplish.

 What I'd really like to be able to do at least in Active Links is a Run
 IF that went something like:

 'Status'.changed=1

 or

 'Myfield.visible=0

 Just about every GUI coding platform I've seen has things like this.

 I'm also going to put in an RFE for improved logging for things like Dialog
 Open/Close field mappings, etc.

 Crazy requests?  What say you?

 William Rentfrow, Principal Consultant
 [EMAIL PROTECTED]
 C 701-306-6157
 O 952-432-0227

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Tomcat won't run right.....why?

2008-05-14 Thread Richard Copits
We have a 7.1 system installed along with Tomcat 5.5.17. The
installation

went apparently ok. However, when I checked out Tomcat by going into

the start menu and clicking on the Welcome screen, it gave an error

about not finding the page to display. The tomcat service is running.
The

log shows that it apparently tried to load  arsys_api.xml - but when I
search

for that in the Programs directory it's not there. Looks like the
midtier

stuff doesn't work as well. I'm trying to access the Tomcat welcome
screen

on the same machine as all of the software, etc. I'd appreciate any
guidance

as to what I should be checking. Thank you!



Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Rick Cook
In the interim, you could create view forms into the metatables that might
get you the data you want.  I'm sure you know how to do that.  Then run
workflow against the conditions found in the view form.

Rick

On Wed, May 14, 2008 at 12:09 PM, Rick Cook [EMAIL PROTECTED] wrote:

 William, I wonder if we'll have functionality like that in the new Eclipse
 tool in 7.5?  Could anyone from BMC feel comfortable commenting generically
 on the issue?

 Rick


 On Wed, May 14, 2008 at 12:00 PM, William Rentfrow 
 [EMAIL PROTECTED] wrote:

 ** I'm going to put this in as an RFE - I highly expect to get shot down
 even though it would save a LOT of coding work at times.

 First though I thought I'd ask for input and criticism of the idea.

 Frequently I want workflow to fire on dependencies like a field being 
 visible/hidden
 or a field value having been changed.  TR/DB value comparisons frequently do
 not do it depending on what I'm trying to accomplish.

 What I'd really like to be able to do at least in Active Links is a Run
 IF that went something like:

 'Status'.changed=1

 or

 'Myfield.visible=0

 Just about every GUI coding platform I've seen has things like this.

 I'm also going to put in an RFE for improved logging for things like
 Dialog Open/Close field mappings, etc.

 Crazy requests?  What say you?

 William Rentfrow, Principal Consultant
 [EMAIL PROTECTED]
 C 701-306-6157
 O 952-432-0227

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread J.T. Shyman
That would be a useful feature.

 

Does anyone know if this is possible in 7.5 being that the development
method has, from what I've heard, gone more toward a IDE?

 

--- J.T. Shyman

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Wednesday, May 14, 2008 3:01 PM
To: arslist@ARSLIST.ORG
Subject: Field Meta Properties?

 

I'm going to put this in as an RFE - I highly expect to get shot down even
though it would save a LOT of coding work at times.

 

First though I thought I'd ask for input and criticism of the idea.

 

Frequently I want workflow to fire on dependencies like a field being
visible/hidden or a field value having been changed.  TR/DB value
comparisons frequently do not do it depending on what I'm trying to
accomplish.

 

What I'd really like to be able to do at least in Active Links is a Run IF
that went something like:

 

'Status'.changed=1

 

or

 

'Myfield.visible=0

 

Just about every GUI coding platform I've seen has things like this.

 

I'm also going to put in an RFE for improved logging for things like Dialog
Open/Close field mappings, etc.

 

Crazy requests?  What say you?

 

William Rentfrow, Principal Consultant

[EMAIL PROTECTED]

C 701-306-6157

O 952-432-0227

 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Joe DeSouza
Can't you just control the visibility of the field using an AL Guide and use 
that guide to do the rest of the stuff you want depending on its visibility 
status?
Checking the change flag of a field at client level would be a nice to have 
feature though it is possible to do this via workflow too..
Go for it, they seem to be reasonable RFE's.. having these would make life a 
little more easier..
Joe

- Original Message 
From: Rick Cook [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 3:09:00 PM
Subject: Re: Field Meta Properties?

** William, I wonder if we'll have functionality like that in the new Eclipse 
tool in 7.5?  Could anyone from BMC feel comfortable commenting generically on 
the issue?

Rick


On Wed, May 14, 2008 at 12:00 PM, William Rentfrow [EMAIL PROTECTED] wrote:

** 
I'm going to put this in as an RFE - I highly expect to get shot down even 
though it would save a LOT of coding work at times.
 
First though I thought I'd ask for input and criticism of the idea.
 
Frequently I want workflow to fire on dependencies like a field being 
visible/hidden or a field value having been changed.  TR/DB value comparisons 
frequently do not do it depending on what I'm trying to accomplish.
 
What I'd really like to be able to do at least in Active Links is a Run IF 
that went something like:
 
'Status'.changed=1
 
or
 
'Myfield.visible=0
 
Just about every GUI coding platform I've seen has things like this.
 
I'm also going to put in an RFE for improved logging for things like Dialog 
Open/Close field mappings, etc.
 
Crazy requests?  What say you?
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Field Meta Properties?

2008-05-14 Thread Rick Cook
Misi, as best I understand it, the TR/DB functionality only exists in
Server-based workflow due to the client/server traffic involved in making it
functional (retrieving DB info and processing it in phase, etc.) on
client-based Active Links.  There's almost certainly a better answer than
that, but that one makes enough sense to me.

Rick

On Wed, May 14, 2008 at 12:08 PM, Misi Mladoniczky [EMAIL PROTECTED] wrote:

 Hi,

 The TR/DB-functionality allways does it. The problem is that the syntax
 is, for some very obscure reason, not available in Active Links.

 ('Status' != 'DB.Status') is the exact same thing as ('Status'.changed =
 1) would be. I see no point in changing the syntax, but it would be nice
 to use it in Active Links.

 The Hidden/Visible stuff is less useful. It can allways be tracked with a
 display-only-flag. It does no great harm to do one extra Hide or Show...

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

  I'm going to put this in as an RFE - I highly expect to get shot down
  even though it would save a LOT of coding work at times.
 
  First though I thought I'd ask for input and criticism of the idea.
 
  Frequently I want workflow to fire on dependencies like a field being
  visible/hidden or a field value having been changed.  TR/DB value
  comparisons frequently do not do it depending on what I'm trying to
  accomplish.
 
  What I'd really like to be able to do at least in Active Links is a Run
  IF that went something like:
 
  'Status'.changed=1
 
  or
 
  'Myfield.visible=0
 
  Just about every GUI coding platform I've seen has things like this.
 
  I'm also going to put in an RFE for improved logging for things like
  Dialog Open/Close field mappings, etc.
 
  Crazy requests?  What say you?
 
  William Rentfrow, Principal Consultant
  [EMAIL PROTECTED]
  C 701-306-6157
  O 952-432-0227
 
 
 
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
  --
  This message was scanned by ESVA and is believed to be clean.
 
 


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Max Index on Form!

2008-05-14 Thread Robert Thomas
Tadeu,

You probably will not find a white paper, however there is knowledge base
@ BMC.

KM-00011012

Regards,

Robert

- Start Original Message -
Sent: Wed, 14 May 2008 12:59:28 -0500
From: Pierson, Shawn
To: arslist@ARSLIST.ORG
Subject: Re: Max Index on Form!


 **

Tadeu,

I don’t think it’s a matter of what the system allows, but
what is best practices. There is no single right answer. You have to
consider how many records are in the table, what the most common searches
will be, etc. It’s something that you need to work with a DBA on.
They can run SQL Profiler and other tools to be able to determine what is
causing the most slowdowns in the queries. Then, when you look at that
and see the need for a new index, you can create a new one.

Shawn Pierson

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Wednesday, May 14, 2008 12:36 PM
To: arslist@ARSLIST.ORG
Subject: Max Index on Form!

**

Hi all,

I'd like to know if has a white paper that describes what's max number of
index to a form...

I've read a document from 2003 and I've noticed that more than 7 index
(or 4 composite index) in one form is bad...

I have an application that has a form with 8 index (some of them
composite index) ... and we're having problems with performance (searches
in database).. I'd like to know if it's possible to insert more index in
this form!

Remembering: I'd like to improve performance...

Att,

Tadeu Augusto Dutra Pinto

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___

Private and confidential as detailed here. If you cannot access
hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com
ARSlist: Where the Answers Are html___


- End Original Message -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Tomcat won't run right.....why?

2008-05-14 Thread William Rentfrow
What port are you using?  Check the server.xml file to see the defined
default Tomcat port.
 
Then go to http://yourservername:/ where  is the defined port.
 
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits
Sent: Wednesday, May 14, 2008 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Tomcat won't run right.why?


** 

We have a 7.1 system installed along with Tomcat 5.5.17. The
installation

went apparently ok. However, when I checked out Tomcat by going into

the start menu and clicking on the Welcome screen, it gave an error

about not finding the page to display. The tomcat service is running.
The

log shows that it apparently tried to load  arsys_api.xml - but when I
search

for that in the Programs directory it's not there. Looks like the
midtier

stuff doesn't work as well. I'm trying to access the Tomcat welcome
screen

on the same machine as all of the software, etc. I'd appreciate any
guidance

as to what I should be checking. Thank you!



Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message. __Platinum Sponsor:
www.rmsportal.com ARSlist: Where the Answers Are html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread William Rentfrow
Yep - that's very doable.  But let's say you have a medium complex set
of conditions that shows/hides fields based on a person's previous
actions, the time of day, the time of issue, or any of 1000 other
things.  It would be so much nicer to have the meta property available
for Run if to save workflow.
 
It would also save the creation of creating a zillion temp fields at
times.  You really shouldn't have to create a field that is a flag
indicating the state of another field (zTmpStatusChanged ring a bell to
anyone?).



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Wednesday, May 14, 2008 2:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field Meta Properties?


** 
Can't you just control the visibility of the field using an AL Guide and
use that guide to do the rest of the stuff you want depending on its
visibility status?
 
Checking the change flag of a field at client level would be a nice to
have feature though it is possible to do this via workflow too..
 
Go for it, they seem to be reasonable RFE's.. having these would make
life a little more easier..
 
Joe

- Original Message 
From: Rick Cook [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 3:09:00 PM
Subject: Re: Field Meta Properties?

** William, I wonder if we'll have functionality like that in the new
Eclipse tool in 7.5?  Could anyone from BMC feel comfortable commenting
generically on the issue?

Rick


On Wed, May 14, 2008 at 12:00 PM, William Rentfrow
[EMAIL PROTECTED] wrote:


** 
I'm going to put this in as an RFE - I highly expect to get shot
down even though it would save a LOT of coding work at times.
 
First though I thought I'd ask for input and criticism of the
idea.
 
Frequently I want workflow to fire on dependencies like a field
being visible/hidden or a field value having been changed.  TR/DB value
comparisons frequently do not do it depending on what I'm trying to
accomplish.
 
What I'd really like to be able to do at least in Active Links
is a Run IF that went something like:
 
'Status'.changed=1
 
or
 
'Myfield.visible=0
 
Just about every GUI coding platform I've seen has things like
this.
 
I'm also going to put in an RFE for improved logging for things
like Dialog Open/Close field mappings, etc.
 
Crazy requests?  What say you?
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Tomcat won't run right.....why?

2008-05-14 Thread Gary Opela (Corporate)
Ran into exactly the same problem. Fixing the port didn't' help either,
as not even tomcat's default config pages would load.

 

I was using 7.1 and let it install tomcat.


Finally, I unistalled everything, then installed tomcat manually, then
installed the mid-tier.


I had to change my port settings and some other manual stuff, and it
took forever, but that was the only way I could get 7.1 to work with
tomcat. I also disabled IIS.

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Wednesday, May 14, 2008 2:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat won't run right.why?

 

What port are you using?  Check the server.xml file to see the defined
default Tomcat port.

 

Then go to http://yourservername:/ where  is the defined port.

 

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits
Sent: Wednesday, May 14, 2008 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Tomcat won't run right.why?

** 

We have a 7.1 system installed along with Tomcat 5.5.17. The
installation

went apparently ok. However, when I checked out Tomcat by going into

the start menu and clicking on the Welcome screen, it gave an error

about not finding the page to display. The tomcat service is running.
The

log shows that it apparently tried to load  arsys_api.xml - but when I
search

for that in the Programs directory it's not there. Looks like the
midtier

stuff doesn't work as well. I'm trying to access the Tomcat welcome
screen

on the same machine as all of the software, etc. I'd appreciate any
guidance

as to what I should be checking. Thank you!



Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message. __Platinum Sponsor:
www.rmsportal.com ARSlist: Where the Answers Are html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Gary Opela (Corporate)
You can simulate TR/DB functionality in active links by looking at the
value in the database and comparing it to the current value.

 

Set tmpStatus = (lookup status from DB where Request ID = Request ID)

If tmpStatus != Status, then fire.

 

This requires an extra field and one extra active link. You could get
away with using the same tmp field for all of your workflow if you want
to keep the number of objects down. This is important if you have users
that open many many windows at once.

 

I highly doubt they will ever add this as an RFE. You can try though :-)
I've got stuff from several years ago out three still!

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Wednesday, May 14, 2008 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field Meta Properties?

 

** Misi, as best I understand it, the TR/DB functionality only exists in
Server-based workflow due to the client/server traffic involved in
making it functional (retrieving DB info and processing it in phase,
etc.) on client-based Active Links.  There's almost certainly a better
answer than that, but that one makes enough sense to me.

Rick

On Wed, May 14, 2008 at 12:08 PM, Misi Mladoniczky [EMAIL PROTECTED] wrote:

Hi,

The TR/DB-functionality allways does it. The problem is that the syntax
is, for some very obscure reason, not available in Active Links.

('Status' != 'DB.Status') is the exact same thing as ('Status'.changed =
1) would be. I see no point in changing the syntax, but it would be nice
to use it in Active Links.

The Hidden/Visible stuff is less useful. It can allways be tracked with
a
display-only-flag. It does no great harm to do one extra Hide or Show...

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


 I'm going to put this in as an RFE - I highly expect to get shot down
 even though it would save a LOT of coding work at times.

 First though I thought I'd ask for input and criticism of the idea.

 Frequently I want workflow to fire on dependencies like a field being
 visible/hidden or a field value having been changed.  TR/DB value
 comparisons frequently do not do it depending on what I'm trying to
 accomplish.

 What I'd really like to be able to do at least in Active Links is a
Run
 IF that went something like:

 'Status'.changed=1

 or

 'Myfield.visible=0

 Just about every GUI coding platform I've seen has things like this.

 I'm also going to put in an RFE for improved logging for things like
 Dialog Open/Close field mappings, etc.

 Crazy requests?  What say you?

 William Rentfrow, Principal Consultant
 [EMAIL PROTECTED]
 C 701-306-6157
 O 952-432-0227





___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


 --
 This message was scanned by ESVA and is believed to be clean.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Tomcat won't run right.....why?

2008-05-14 Thread David Sanders
In my experience, the default install of Tomcat performed during the
Mid-Tier installation has the default Tomcat port 8080 commented out.  The
Mid-Tier itself relies on Jakarta redirection.  If you want to enable the
default Tomcat port and pages you need to edit the server.xml file
(C:\Program Files\Apache Software Foundation\Tomcat-5.5.17\conf\server.xml)

Find the following section:

!-- Define a non-SSL HTTP/1.1 Connector on port 8080 --
!---comment out port 8080
Connector
port=8080   maxHttpHeaderSize=8192
URIEncoding=UTF-8
   maxThreads=150 minSpareThreads=25 maxSpareThreads=75
   enableLookups=false redirectPort=8443 acceptCount=100
   connectionTimeout=2 disableUploadTimeout=true /
   end comment out port 8080 --

And remove the comment-out by deleting the second and last lines above.

HTH

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
 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Wednesday, May 14, 2008 8:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat won't run right.why?

Ran into exactly the same problem. Fixing the port didn’t’ help either, as
not even tomcat’s default config pages would load.

I was using 7.1 and let it install tomcat.

Finally, I unistalled everything, then installed tomcat manually, then
installed the mid-tier.

I had to change my port settings and some other manual stuff, and it took
forever, but that was the only way I could get 7.1 to work with tomcat. I
also disabled IIS.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Wednesday, May 14, 2008 2:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tomcat won't run right.why?

What port are you using?  Check the server.xml file to see the defined
default Tomcat port.
 
Then go to http://yourservername:/ where  is the defined port.
 
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits
Sent: Wednesday, May 14, 2008 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Tomcat won't run right.why?
** 
We have a 7.1 system installed along with Tomcat 5.5.17. The installation
went apparently ok. However, when I checked out Tomcat by going into
the start menu and clicking on the “Welcome” screen, it gave an error
about not finding the page to display. The tomcat service is running. The
log shows that it apparently tried to load  arsys_api.xml – but when I
search
for that in the “Programs” directory it’s not there. Looks like the midtier
stuff doesn’t work as well. I’m trying to access the Tomcat welcome screen
on the same machine as all of the software, etc. I’d appreciate any guidance
as to what I should be checking. Thank you!


Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception,
please delete all copies from your system without disclosing, copying, or
transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist:
Where the Answers Are html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread Joe DeSouza
I second Gary as I ahve actually done such things in the past and had the 
functionality work pretty good..
Joe


- Original Message 
From: Gary Opela (Corporate) [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 3:54:53 PM
Subject: Re: Field Meta Properties?

** 
You can simulate TR/DB functionality in active links by looking at the value in 
the database and comparing it to the current value.
 
Set tmpStatus = (lookup status from DB where Request ID = Request ID)
If tmpStatus != Status, then fire.
 
This requires an extra field and one extra active link. You could get away with 
using the same tmp field for all of your workflow if you want to keep the 
number of objects down. This is important if you have users that open many many 
windows at once.
 
I highly doubt they will ever add this as an RFE. You can try though JI’ve got 
stuff from several years ago out three still!
 
Thanks,
 
Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI® Level 3 Rated Company



From:Action Request System discussion list(ARSList) [mailto: 
arslist@ARSLIST.ORG ] On Behalf Of Rick Cook
Sent: Wednesday, May 14, 2008 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field Meta Properties?
 
** Misi, as best I understand it, the TR/DB functionality only exists in 
Server-based workflow due to the client/server traffic involved in making it 
functional (retrieving DB info and processing it in phase, etc.) on 
client-based Active Links.  There's almost certainly a better answer than that, 
but that one makes enough sense to me.

Rick
On Wed, May 14, 2008 at 12:08 PM, Misi Mladoniczky [EMAIL PROTECTED] wrote:
Hi,

The TR/DB-functionality allways does it. The problem is that the syntax
is, for some very obscure reason, not available in Active Links.

('Status' != 'DB.Status') is the exact same thing as ('Status'.changed =
1) would be. I see no point in changing the syntax, but it would be nice
to use it in Active Links.

The Hidden/Visible stuff is less useful. It can allways be tracked with a
display-only-flag. It does no great harm to do one extra Hide or Show...

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

 I'm going to put this in as an RFE - I highly expect to get shot down
 even though it would save a LOT of coding work at times.

 First though I thought I'd ask for input and criticism of the idea.

 Frequently I want workflow to fire on dependencies like a field being
 visible/hidden or a field value having been changed.  TR/DB value
 comparisons frequently do not do it depending on what I'm trying to
 accomplish.

 What I'd really like to be able to do at least in Active Links is a Run
 IF that went something like:

 'Status'.changed=1

 or

 'Myfield.visible=0

 Just about every GUI coding platform I've seen has things like this.

 I'm also going to put in an RFE for improved logging for things like
 Dialog Open/Close field mappings, etc.

 Crazy requests?  What say you?

 William Rentfrow, Principal Consultant
 [EMAIL PROTECTED]
 C 701-306-6157
 O 952-432-0227


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

 --
 This message was scanned by ESVA and is believed to be clean.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: AD and CTM:People

2008-05-14 Thread Kathy Morris
I am concerned about error-checking - perhaps I should build workflow to  
send out notifications when there records make it to the staging table and do  
not merge into the CTM:People
 
 
In a message dated 5/14/2008 10:58:03 A.M. Pacific Daylight Time,  
[EMAIL PROTECTED] writes:

**   
 
That  is the way I did it, including defaulting some NULL fields that Remedy  
requires.  I have an escalation that pulls the AD data (via a vendor  form) 
into a staging table, which then uses filters to do validations and  
auto-population of some data, then if it passes all the validations, passes it  
into the 
CTM:People form and all the related forms that need populated.   It sounds 
like you already have that, but need to use a LOWER() function in  your Push 
Fields that passes the Remedy Login Name  field. 
Something  else that will be useful for you is to set up another filter to 
find users to  automatically disable too.  In my filter to do that, I  have: 
((  'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR (  
'userAccountControl' = 65538) OR ( 'userAccountControl' =  66050)) 
The  userAccountControl field are set to those values when a person is  
de-activated, so you can create a filter to set them to “Obsolete” in  
CTM:People 
as well as set Support Staff? To No and remove all their  permissions.  This 
helps quite a bit in keeping license costs down  because you’re not wasting 
licenses by maintaining them for people that are no  longer with the company. 
Shawn  Pierson 
 
From: Action Request  System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of  Kathy Morris
Sent: Wednesday, May 14, 2008 11:37  AM
To: arslist@ARSLIST.ORG
Subject: AD and  CTM:People
**  
 
Hi,
 

 

 
AR  System: 7.0.1
 
Thru  workflow, data is passed from Active Directory into Remedy vendor  
tables then thru escalations into Remedy CTM:People. We have users  that 
sometimes 
enter the field values in upper/lower case. Whenever they  enter 
uppercase/lower case or leave certain fields BLANK, the record does  not get 
into the 
CTM:People form.  I would like to build workflow that  changes the case to 
LOWERCASE and does error-checking on records that come  from AD that don't make 
it 
into the CTM:People form.  Am I approaching  this correctly, or is there a 
better way?



  

 
Wondering  what's for Dinner Tonight? _Get new twists on family favorites at 
AOL  Food_ (http://food.aol.com/dinner-tonight?NCID=aolfod000301) .
__Platinum Sponsor:  www.rmsportal.com ARSlist: Where the Answers Are 
html___  
Private and confidential as detailed _here_ 
(http://www.sug.com/disclaimers/default.htm#Mail) . If you cannot  access 
hyperlink, please e-mail sender. 
__Platinum Sponsor: www.rmsportal.com  ARSlist: Where the Answers Are  html___




**Wondering what's for Dinner Tonight? Get new twists on family 
favorites at AOL Food.  
(http://food.aol.com/dinner-tonight?NCID=aolfod000301)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: (Pattern - $MENU$) Problem

2008-05-14 Thread Mayfield, Andy L.
I had this same problem a little while back and never found a solution.
I will have to try this.

I wound up making the field display as a drop-down, which of course
forces them to select from the menu, so as far as I can tell has the
same effect.

Andy L. Mayfield 
Sr. System Operation Specialist 
Alabama Power Company 
Office: 205-226-1805 
Cell: 205-288-9140 
SoLinc: 10*19140 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Friday, May 09, 2008 3:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: (Pattern - $MENU$) Problem

Nyall, that was it, thank you. Our dba did just do a patch. You gotta 
love the simple-easy fixes.

Gary and Rick, thanks for the responses. Rick, I did start to look 
through the SQL file but I didn't really know where to begin.

Drew


On Fri, 9 
May 2008, Nyall McCavitt wrote:

 Hi,

 I recently got this error message when our Oracle 10g database was
upgraded 
 to the latest patch level.

 I found that if you remove the $MENU$ key word from the field
attributes, 
 save the form and then add the $MENU$ key word back again then the
error 
 message will not appear again.

 Hope that this helps.

 Nyall

 Drew Shuller wrote:
 I'm saving a record in a form but I get this error message: ARERR
[306] 
 Value does not fall within the limits specified for the field :
(Pattern - 
 $MENU$) : 301107120
 
 That field id represents a character field with a search menu
attached. I 
 ran that down and the contents of the field match the contents of the
field 
 that the search menu is pulling from. Nothing seems out of place.
 
 Not that this would make a difference, but what I'm doing is creating
a 
 Copy Dataset job in the CMDB Reconciliation manager. The error
message 
 appears when the Save button is pressed. The field that the error
message 
 is complaining about (there's actually two of them) is the Source
Dataset 
 and the Destination Dataset. Again, I'm not sure that this is
relevant, but 
 it might be.
 
 Since we have mutiple servers and this operation works on the other 
 servers, I exported and then imported the form that ITSM uses to
create the 
 Copy Dataset job. This didn't help.
 
 I imagine that I could safely remove the $MENU$ field constraint as a

 workaround, but now I worried that something may be wrong with the
server.
 
 Has anyone ever seen this kind of behavior? Thanks in advance for the
help.
 
 Drew
 Tulsa
 


___ 
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 
 



___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Field Meta Properties?

2008-05-14 Thread William Rentfrow
True.  It works.
 
However, I have come to hate temp fields on principle.  This is not
rocket science - it's done in most major programming languages that are
object based.  Having these properties available is pretty simple stuff.
 
Furthermore - there is DB activity going on that is superfluous.  Doing
a lookup to see if a value changed is not necessary if meta-properties
were available.
 
That said - these are all valid points.  There are a lot of ways to
accomplish these things - I just don't like that so many of them feel
like workarounds.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Wednesday, May 14, 2008 3:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field Meta Properties?


** 
I second Gary as I ahve actually done such things in the past and had
the functionality work pretty good..
 
Joe


- Original Message 
From: Gary Opela (Corporate) [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 3:54:53 PM
Subject: Re: Field Meta Properties?

** 

You can simulate TR/DB functionality in active links by looking at the
value in the database and comparing it to the current value.

 

Set tmpStatus = (lookup status from DB where Request ID = Request ID)

If tmpStatus != Status, then fire.

 

This requires an extra field and one extra active link. You could get
away with using the same tmp field for all of your workflow if you want
to keep the number of objects down. This is important if you have users
that open many many windows at once.

 

I highly doubt they will ever add this as an RFE. You can try though :-)
I've got stuff from several years ago out three still!

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com http://www.5pointleader.com/ 

http://www.lcibest.com http://www.lcibest.com/ 

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList) [mailto:

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: Issues sending emails even though service is running - UPDATE

2008-05-14 Thread Jason Miller
Hi all,

I had to restart the email engine for the first time after removing all of
the temp files.  It resumed processing emails with no problem.  I am not
sure if cleaning out the temp files was the solution yet but it is looking
good so far.

I just checked and there is a build up of REDTMP files.  It looks like
these are the shortcuts to request being sent via email.  Below is the
contents of the files.

[Shortcut]
Name = HPD:HelpDesk
Type = 0
Server = servername
Ticket = HD02318724

I guess these don't automatically delete along with the tmp files?  Now that
I know they are there I can create a process to clean them up.

Jason

On Wed, May 7, 2008 at 8:33 PM, Matt Ferrigno [EMAIL PROTECTED]
wrote:

 ** Jason,

 I'm not sure the exact purpose of the .tmp file, but if I had to guess ...
 It's most likely a .eml file that the email engine passes to the mail
 server, but uses a .tmp extention to identify it as temporary since once it
 is sent to the mail server it is no longer needed on the AR server.  Anyway,
 Since you went to patch 006 a while ago and are just now seeing this
 problem, I'm assuming that this is not that cause of your issue. Though,
 there's always room for hope. Good luck with your problem.

 Regards,
 Matt Ferringo


 On 5/7/08, Jason Miller [EMAIL PROTECTED] wrote:

 ** Hi Matt,


 Yes it is definitely patch 6.

 loaded libraryApplication has started Version:  7.0.01 Patch 006
 200712011959
 Using JRE: 1.4.2_14

 I didn't know that the email service created temp files.  I just took a
 look in C:\Documents and Settings\username that service runs as\Local
 Settings\Temp and there are +484k files named like E2_100234.tmp.
 According to the dates they haven't been created in a while so we
 unknowingly fixed it in the last few months when we brought it up from no
 patch.  Looks like we have some clean up to do.  I can see that if the
 service has to search through all of these that it could cause some issues
 even if it isn't creating new files.  We'll delete them and see if that
 fixes the issue.  Thanks for the tip!

 Does anybody know the purpose of these temp files?

 Thanks,
 Jason



 On Wed, May 7, 2008 at 1:06 PM, Matt Ferrigno [EMAIL PROTECTED]
 wrote:

 ** Are you sure you are running patch 6 on the email engine? I ran into a
 problem at one point with because email engine pre-patch 2 does not delete
 temporary files.  In which case the temp folder filled up with over 1
 million files and caused poor performance of the email engine (about 6
 emails per minute). A simple resart of the email engine did not fix the
 issue.  We had to remove all the temporary files in the directory.

 On 5/7/08, Jason Miller [EMAIL PROTECTED] wrote:

 ** Has anybody had issues with the Email Engine stop processing outgoing
 and incoming mail while the service still running.  Restarting the email
 service alone usually does not fix the issue.  There are no errors in the
 email logs or email error form.


 I have noticed that the aremaild.exe process usually takes a while to
 stop so I have started doing a full service start/stop instead of a 
 restart,
 and sometimes I have to kill the process.

 We usually we only have an issue if we have to restart the ARS service
 or if the Exchange mailbox is unavailable for some reason (configured for
 MAPI).  A fresh OS restart and the email engine fires up fine.  What we 
 have
 had to do lately when email stops processing is:
 •Stop the service/kill the process
 •Delete the pending email messages that are waiting to be sent
 (export them first)
 •Move the incoming emails that are waiting in Exchange from the
 inbox
 •Start the service and try sending a new message (repeat until it
 will process the message(s))
 •Move the incoming email back to the Inbox (verify they are
 processed)
 •Import the previously deleted records

 I have noticed this issue in the previous shop where I worked at too, on
 various patches of 7.0 and 7.0.1 (all Windows 2003).  I have seen some
 threads on the list where it looks like similar issues but no resolutions 
 or
 how many others have seen this behavior.

 Thanks,
 Jason

 ARS/Email 7.0.1 P6
 Windows 2003
 MS SQL 2005 SP 2
 Java 1.4.2_14

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: AD and CTM:People

2008-05-14 Thread Joe DeSouza
A staging form with data checks for everything including duplicate login ID's 
is what I did when I had to integrate Remedy with the PeopleSoft database 
recently.. works like a charm.. Creates new users from Peoplesoft with all the 
necessary permissions they require, and updates existing users..
Joe



- Original Message 
From: Kathy Morris [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 4:34:55 PM
Subject: Re: AD and CTM:People

** I am concerned about error-checking - perhaps I should build workflow to 
send out notifications when there records make it to the staging table and do 
not merge into the CTM:People
 
In a message dated 5/14/2008 10:58:03 A.M. Pacific Daylight Time, [EMAIL 
PROTECTED] writes:
** 
That is the way I did it, including defaulting some NULL fields that Remedy 
requires.  I have an escalation that pulls the AD data (via a vendor form) into 
a staging table, which then uses filters to do validations and auto-population 
of some data, then if it passes all the validations, passes it into the 
CTM:People form and all the related forms that need populated.  It sounds like 
you already have that, but need to use a LOWER() function in your Push Fields 
that passes the Remedy Login Name field.
 
Something else that will be useful for you is to set up another filter to find 
users to automatically disable too.  In my filter to do that, I have:
(( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR ( 
'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050))
The userAccountControl field are set to those values when a person is 
de-activated, so you can create a filter to set them to “Obsolete” in 
CTM:People as well as set Support Staff? To No and remove all their 
permissions.  This helps quite a bit in keeping license costs down because 
you’re not wasting licenses by maintaining them for people that are no longer 
with the company.
 
Shawn Pierson
 
From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kathy Morris
Sent: Wednesday, May 14, 2008 11:37 AM
To: arslist@ARSLIST.ORG
Subject: AD and CTM:People
 
** 
Hi,
 
 
AR System: 7.0.1
Thru workflow, data is passed from Active Directory into Remedy vendor 
tables then thru escalations into Remedy CTM:People. We have users that 
sometimes enter the field values in upper/lower case. Whenever they enter 
uppercase/lower case or leave certain fields BLANK, the record does not get 
into the CTM:People form.  I would like to build workflow that changes the case 
to LOWERCASE and does error-checking on records that come from AD that don't 
make it into the CTM:People form.  Am I approaching this correctly, or is there 
a better way?





Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL 
Food.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 
Private and confidential as detailed here. If you cannot access hyperlink, 
please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the 
Answers Are html___





Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL 
Food.__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___


 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 

Re: Changing a Field to Required

2008-05-14 Thread Mayfield, Andy L.
What action are you executing on? Submit? 

If this has already been resolved, sorry for missing that.


Andy L. Mayfield 
Sr. System Operation Specialist 
Alabama Power Company 
Office: 205-226-1805 
Cell: 205-288-9140 
SoLinc: 10*19140 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Friday, May 09, 2008 8:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Changing a Field to Required

Hi Roger,

Thank you and all for the emails.  Sorry I haven't replied sooner, we
are in the middle of audit season :-(

Anyway, here is my Run if statement: ( 'Actual Start Date' !=  $NULL$ )
AND  ( 'z1D_Activity Type*' != Closure Information ) AND (
'z1D_Summary' =  $NULL$ ).  My If Action is simple, Message w/Type of
Error, Please enter Closure Information into the Work Info section of
the change ticket in order to Complete the ticket.

I've set the Execution order to 0.

It looks like the action works, but it is rather shaky.  The Error
Message pops up as needed but the status still shows Completed and you
have to refresh the screen in order for it to go back to Implementation
in Progress.  Also it still populates the Actual Start and End dates.

Thank you,
Lou

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Wednesday, May 07, 2008 1:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Changing a Field to Required

Louis,

What are the Execute On conditions and Execution Order of your Active
Link? That may point you in the right direction.

HTH,

Roger A. Nall
Manager, OSSNMS Remedy
T-Mobile USA
Desk: 813-348-2556
Cell: 973-652-6723
FAX: 813-348-2565
sf49fanv AIM IM
RogerNall   Yahoo IM
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Wednesday, May 07, 2008 1:17 PM
To: arslist@ARSLIST.ORG
Subject: Changing a Field to Required

Good Afternoon List,

I've been asked to make a Work Info entry required when a Change
Ticket has 
been moved to a status of Completed.   I thought it might be easiest to 
make the z1D_Summary required on the Dialog View - Close view.  But it
seem 
that the Field Change Function doesn't allow for making a field
required, 
just visable and font changes seem to be the only changes allowed.

I also tried creating a simple error message active link but it is
firing 
after all the Completed workflow function fires.  The error messages 
comes up but ticket shows Completed even though no entry was made.

Any thoughts would be great.

We run AR applications and System v 7.0.01 patch 006, all on Windows
2003 
Servers and MS SQL 2005.

Thank you


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: AD and CTM:People

2008-05-14 Thread SUBSCRIBE arslist Melissa
Joe - Can you share how are you did the PeopleSoft integration?  We are 
working on that here too.  Is your PeopleSoft in Oracle or SQL?





Joe DeSouza [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
05/14/2008 03:47 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: AD and CTM:People






** 
A staging form with data checks for everything including duplicate login 
ID's is what I did when I had to integrate Remedy with the PeopleSoft 
database recently.. works like a charm.. Creates new users from Peoplesoft 
with all the necessary permissions they require, and updates existing 
users..
 
Joe


- Original Message 
From: Kathy Morris [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 4:34:55 PM
Subject: Re: AD and CTM:People

** 
I am concerned about error-checking - perhaps I should build workflow to 
send out notifications when there records make it to the staging table and 
do not merge into the CTM:People
 
In a message dated 5/14/2008 10:58:03 A.M. Pacific Daylight Time, 
[EMAIL PROTECTED] writes:
** 
That is the way I did it, including defaulting some NULL fields that 
Remedy requires.  I have an escalation that pulls the AD data (via a 
vendor form) into a staging table, which then uses filters to do 
validations and auto-population of some data, then if it passes all the 
validations, passes it into the CTM:People form and all the related forms 
that need populated.  It sounds like you already have that, but need to 
use a LOWER() function in your Push Fields that passes the Remedy Login 
Name field.
 
Something else that will be useful for you is to set up another filter to 
find users to automatically disable too.  In my filter to do that, I have:
(( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR ( 
'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050))
The userAccountControl field are set to those values when a person is 
de-activated, so you can create a filter to set them to ?Obsolete? in 
CTM:People as well as set Support Staff? To No and remove all their 
permissions.  This helps quite a bit in keeping license costs down because 
you?re not wasting licenses by maintaining them for people that are no 
longer with the company.
 
Shawn Pierson
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris
Sent: Wednesday, May 14, 2008 11:37 AM
To: arslist@ARSLIST.ORG
Subject: AD and CTM:People
 
** 
Hi,
 
 
AR System: 7.0.1
Thru workflow, data is passed from Active Directory into Remedy vendor 
tables then thru escalations into Remedy CTM:People. We have users that 
sometimes enter the field values in upper/lower case. Whenever they enter 
uppercase/lower case or leave certain fields BLANK, the record does not 
get into the CTM:People form.  I would like to build workflow that changes 
the case to LOWERCASE and does error-checking on records that come from AD 
that don't make it into the CTM:People form.  Am I approaching this 
correctly, or is there a better way?



Wondering what's for Dinner Tonight? Get new twists on family favorites at 
AOL Food.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___ 
Private and confidential as detailed here. If you cannot access hyperlink, 
please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: 
Where the Answers Are html___



Wondering what's for Dinner Tonight? Get new twists on family favorites at 
AOL Food.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are 
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Help with Vertical Navigation Bar and strange permissions happenings

2008-05-14 Thread Gary Opela (Corporate)
I have a user called test.biz. He has three permission groups, groupa,
groupb, groupc. I have a vertical navigation bar that has several
top-level menus on it. One of the menus is called Add/Modify Quote. It
has groupa permissions on it. The permission groupa is just a generic
permission group that everyone has, like public, but it's explicit.

 

The menu option of Add/Modify Quote has several menu items under it.
They are Add Quote, Delete Quote, Approve Quote, Modify Quote. All have
groupa permission, except approve quote. If I do not give it any
permission, then test.biz cannot see it. However, if I give it any
permission group, even a group that test.biz does not have, then
test.biz can see that menu item. He cannot see any of the other stuff
that has the same permissions, such as tabs. 


For some strange reason, if I give that menu item any permission at all,
it's basically the same as giving it public. Does anyone know of
anything different that I have to do? Has anyone else run into this?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


BMC_SLM_JAVA_HOME Error

2008-05-14 Thread jaimie
I am attempting to install SLM on a Windows 2003 Server with a MSSQL
2005 db.   I have also installed JRE v1.6.0_05.  When I run the
installer it keeps coming up with this error Installer unable to
verify BMC_SLM_JAVA_HOME system environment variable.  Please make
sure system environment variable is set and its pointing to Java
Runtime environment home.

I opened up the ar.conf and added the following lines:

Variable name: BMC_SLM_JAVA_HOME
Variable value: C:\Program Files\Java\jre1.6.0_05

I saved the config, restarted the server and it is still coming up
with the above error.

Any ideas?  Any help is greatly appreciated.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: BMC_SLM_JAVA_HOME Error

2008-05-14 Thread J.T. Shyman
Jaimie,

It is looking for a system variable and not an AR variable.

Right-click on My Computer, go to Properties, then Advanced. Click
Environment Variables and set BMC_SLM_JAVA_HOME in the lower (system
variables) window. This should not require a restart of Windows.

--- J.T. Shyman

 -Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of jaimie
Sent: Wednesday, May 14, 2008 4:53 PM
To: arslist@ARSLIST.ORG
Subject: BMC_SLM_JAVA_HOME Error

I am attempting to install SLM on a Windows 2003 Server with a MSSQL
2005 db.   I have also installed JRE v1.6.0_05.  When I run the
installer it keeps coming up with this error Installer unable to
verify BMC_SLM_JAVA_HOME system environment variable.  Please make
sure system environment variable is set and its pointing to Java
Runtime environment home.

I opened up the ar.conf and added the following lines:

Variable name: BMC_SLM_JAVA_HOME
Variable value: C:\Program Files\Java\jre1.6.0_05

I saved the config, restarted the server and it is still coming up
with the above error.

Any ideas?  Any help is greatly appreciated.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: BMC_SLM_JAVA_HOME Error

2008-05-14 Thread strauss
J.T. has told you what you need to do to set the BMC_SLM_JAVA_HOME
variable properly in Control Panel - System Properties - Advanced -
Environment Variables - System Variables. Also, I would not expect any
BMC Remedy 7.x product to work properly with Java 1.6.x.  As far as I
know, they were all developed against Java 1.5.x, and contrary to what
Sun would like to have you believe, there is very little compatibility
between major versions of Java.  Try 1.5.0_14; it works just fine.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of jaimie
 Sent: Wednesday, May 14, 2008 3:53 PM
 To: arslist@ARSLIST.ORG
 Subject: BMC_SLM_JAVA_HOME Error
 
 I am attempting to install SLM on a Windows 2003 Server with a MSSQL
 2005 db.   I have also installed JRE v1.6.0_05.  When I run the
 installer it keeps coming up with this error Installer unable to
 verify BMC_SLM_JAVA_HOME system environment variable.  Please make
 sure system environment variable is set and its pointing to Java
 Runtime environment home.
 
 I opened up the ar.conf and added the following lines:
 
 Variable name: BMC_SLM_JAVA_HOME
 Variable value: C:\Program Files\Java\jre1.6.0_05
 
 I saved the config, restarted the server and it is still coming up
 with the above error.
 
 Any ideas?  Any help is greatly appreciated.
 

___
 
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: BMC_SLM_JAVA_HOME Error

2008-05-14 Thread J.T. Shyman
Great point, Chris. 

 

The compatibility matrix for AR 7.1 states:

 

Java Support

AR System (Server and Mid-Tier) 7.1.00 requires Java 5.0 and supports that
version or higher. Supported Vendors are:

Operating System Vendor Minimum recommended version

Operating System
Vendor  Minimum recommended version

Windows, Solaris, Linux (Red Hat and SuSE)   Sun Microsystems
JDK 1.5.0_12

HP-UX
HP  HP JDK 1.5 build 1.5.0.05

IBM
IBM JDK 1.5 SR2

 

 

So 1.6 should work but YMMV. 1.5 does work so I agree with Chris. You should
stick to 1.5.0_12 or higher which is compatible with AR 7.0.x as well.

 

--- J.T. Shyman

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Wednesday, May 14, 2008 5:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC_SLM_JAVA_HOME Error

 

J.T. has told you what you need to do to set the BMC_SLM_JAVA_HOME

variable properly in Control Panel - System Properties - Advanced -

Environment Variables - System Variables. Also, I would not expect any

BMC Remedy 7.x product to work properly with Java 1.6.x.  As far as I

know, they were all developed against Java 1.5.x, and contrary to what

Sun would like to have you believe, there is very little compatibility

between major versions of Java.  Try 1.5.0_14; it works just fine.

 

Christopher Strauss, Ph.D.

Call Tracking Administration Manager

University of North Texas Computing  IT Center

http://itsm.unt.edu/

 

 -Original Message-

 From: Action Request System discussion list(ARSList)

 [mailto:[EMAIL PROTECTED] On Behalf Of jaimie

 Sent: Wednesday, May 14, 2008 3:53 PM

 To: arslist@ARSLIST.ORG

 Subject: BMC_SLM_JAVA_HOME Error

 

 I am attempting to install SLM on a Windows 2003 Server with a MSSQL

 2005 db.   I have also installed JRE v1.6.0_05.  When I run the

 installer it keeps coming up with this error Installer unable to

 verify BMC_SLM_JAVA_HOME system environment variable.  Please make

 sure system environment variable is set and its pointing to Java

 Runtime environment home.

 

 I opened up the ar.conf and added the following lines:

 

 Variable name: BMC_SLM_JAVA_HOME

 Variable value: C:\Program Files\Java\jre1.6.0_05

 

 I saved the config, restarted the server and it is still coming up

 with the above error.

 

 Any ideas?  Any help is greatly appreciated.

 

 

___

 

 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

 


___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Re: AD and CTM:People

2008-05-14 Thread Joe DeSouza
Yes my PeopleSoft database is on Oracle...
I used the AIE engine to do the data interchange on a staging form.. On this 
staging form I created filters to validate the data that has to go into the 
CTM:People form and the User form..
As a part of the validations I also manupulated data such as the full name to 
be in the format that the ITSM configuration tool puts it - Firstname + Middle 
Initial if it exists + Last name.
I also created filters to manupulate phone numbers and extensions like Remedy 
ITSM does..
You will need to create workflow for inserting data into the 
CTM:PeoplePermissions group form for default groups that you want new users to 
be in..
This is just the gist of it..
If you want any other specific details feel free to write to me..
Joe



- Original Message 
From: SUBSCRIBE arslist Melissa [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 4:48:41 PM
Subject: Re: AD and CTM:People

** 
Joe - Can you share how are you did the PeopleSoft integration?  We are working 
on that here too.  Is your PeopleSoft in Oracle or SQL? 





Joe DeSouza [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 
05/14/2008 03:47 PM 
Please respond to
arslist@ARSLIST.ORG 
 To arslist@ARSLIST.ORG  
cc  
Subject Re: AD and CTM:People 
  
 


** 
A staging form with data checks for everything including duplicate login ID's 
is what I did when I had to integrate Remedy with the PeopleSoft database 
recently.. works like a charm.. Creates new users from Peoplesoft with all the 
necessary permissions they require, and updates existing users.. 
  
Joe 


- Original Message 
From: Kathy Morris [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 14, 2008 4:34:55 PM
Subject: Re: AD and CTM:People

** 
I am concerned about error-checking - perhaps I should build workflow to send 
out notifications when there records make it to the staging table and do not 
merge into the CTM:People 
  
In a message dated 5/14/2008 10:58:03 A.M. Pacific Daylight Time, [EMAIL 
PROTECTED] writes: 
** 
That is the way I did it, including defaulting some NULL fields that Remedy 
requires.  I have an escalation that pulls the AD data (via a vendor form) into 
a staging table, which then uses filters to do validations and auto-population 
of some data, then if it passes all the validations, passes it into the 
CTM:People form and all the related forms that need populated.  It sounds like 
you already have that, but need to use a LOWER() function in your Push Fields 
that passes the Remedy Login Name field. 
  
Something else that will be useful for you is to set up another filter to find 
users to automatically disable too.  In my filter to do that, I have: 
(( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR ( 
'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050)) 
The userAccountControl field are set to those values when a person is 
de-activated, so you can create a filter to set them to “Obsolete” in 
CTM:People as well as set Support Staff? To No and remove all their 
permissions.  This helps quite a bit in keeping license costs down because 
you’re not wasting licenses by maintaining them for people that are no longer 
with the company. 
  
Shawn Pierson 
  
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kathy Morris
Sent: Wednesday, May 14, 2008 11:37 AM
To: arslist@ARSLIST.ORG
Subject: AD and CTM:People 
  
** 
Hi, 
  
  
AR System: 7.0.1 
Thru workflow, data is passed from Active Directory into Remedy vendor tables 
then thru escalations into Remedy CTM:People. We have users that sometimes 
enter the field values in upper/lower case. Whenever they enter uppercase/lower 
case or leave certain fields BLANK, the record does not get into the CTM:People 
form.  I would like to build workflow that changes the case to LOWERCASE and 
does error-checking on records that come from AD that don't make it into the 
CTM:People form.  Am I approaching this correctly, or is there a better way? 




Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL 
Food. 
__Platinum Sponsor: www.rmsportal.comARSlist: Where the Answers Are html___ 
Private and confidential as detailed here. If you cannot access hyperlink, 
please e-mail sender. __Platinum Sponsor: www.rmsportal.comARSlist: Where the 
Answers Are html___ 





Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL 
Food. 
__Platinum Sponsor: www.rmsportal.comARSlist: Where the Answers Are html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com 

Re: synchronization of servers

2008-05-14 Thread Jason Miller
I have never used Shareplex but have talked to some people that supported a
large DoD agency that used it (I think maybe the project Dylan worked on).
It sounded pretty impressive performance wise and they were happy with it.
From what I understand there are a few things to watch out for like doing
admin work as LJ has suggested and I think that it takes a while to get it
all setup and working as desired.

In regards to DSO, the same large DoD agency (in another area) has (or had)
a pretty good size DSO infrastructure to pass requests to the various Remedy
systems.  One draw back to this is that none of the admin code is
synchronized and you would have to run DSO filters/mappings on all forms
that you want to replicate/fail over.  If you are looking for complete data
synchronization I could see how this could be a lot to manage and this would
not replicate admin changes.  This was all fine for this implementation
because they only synchronized data between one form and this also allowed
them to keep their own systems customized.

I mentioned that they had a DSO infrastructure...  They have mostly moved to
ARSXML (looks like it now called ARSXLink).  This is a better product for
their application.  I think the performance is better and it is more
reliable.  It also handles data conflicts better then DSO.  I believe that
Gidd is a reseller of ARSXML. Here is a link
http://www.ntuition.de/index.php?arsxlink_en.

HTH,
Jason

On Wed, May 14, 2008 at 10:01 AM, LJ Longwing [EMAIL PROTECTED] wrote:

 ** The only caveat that I would put on this is that if you are doing total
 db sync then you would need to do development on only one of the servers (or
 deploys as it may be) and then restart the other remedy server after the
 modifications were made, or run an arsignal.

  --
 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Rick Cook
 *Sent:* Wednesday, May 14, 2008 9:49 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: synchronization of servers

 ** I don't have any experience with this product, but I will say that by
 doing your syncing via DB replication, I think you're on the right track.
 It's the fastest way I know of to do what you're doing.

 Rick

 On Wed, May 14, 2008 at 8:43 AM, Zoltán Nemes [EMAIL PROTECTED] wrote:

 **  Dear Listers!

 There will be major changes in our Remedy system architecture soon and we
 are trying to be prepared with a concept to support it.

 Our company currently uses one production server for ticketing purpose.
 The server is located in Europe.
 According to the new plans, there will be a new production server deployed
 for the USA region. Both these servers has to be real-time synchronized and
 they would have to contain the same case related data, so that they can
 replace each other in case of failures or outages.

 The no-brainer solution of course would be DSO. But considering the amount
 of data to be transferred, our belief is that with DSO the overhead on the
 systems will be huge and this leads to intensive network traffic that would
 cause performance problems for us.

 We are planning to use a solution based on a database syncronization
 product called Shareplex for Oracle.

 Does anyone of you have experience in synchronizing Remedy using this
 product? What are you guys using for syncing your systems?

 I would appreciate if you shared your ideas with me.

 Thanks,
 Zoltan

 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___
 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are


Widescreen Remedy User Tool Display 1440 x 900 Resolution

2008-05-14 Thread Bulls-n-Bears
Greetings Listers,
There's almost 40% of my screen on right side that's blank . User
forms/objects are displayed only towards the left rectangle. Is there
any setting/config I need to perform so I'd be able to utilize my
display ?

Mine is a wide screen monitor and the aspect ratio remains like this .
Anyone who could help ?

Cheers

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are