Re: remotely install ARS7 as non-root user on Solaris server from Window XP desktop

[Michiel Beijen]

Search in the BMC Remedy Knowledge base on 00024200. This entry has a
webex recording and a word doc with screenshots of a non-root installation
on Solaris with Oracle. It is an installation for version 6.3 but the
process should be mainly the same.
Also, of course please check the "AR System 7.0 Installing" guide.

Kind regards,

Michiel

On 2/13/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:


** Log in to the Solaris box (depending on your setup you can use an app
like PuTTY or even telnet)
Set the environment variable ARSNONROOT=TRUE
Run the install

Fred

 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Jiaqi Yu
*Sent:* Tuesday, February 13, 2007 2:50 PM
*To:* arslist@ARSLIST.ORG
*Subject:* remotely install ARS7 as non-root user on Solaris server from
Window XP desktop

 Please let me know if you have any idea how to do it?

JY


__20060125___This posting was submitted with HTML in
it___



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: ARServer 7.00.01 Patch 1

[Niklas Asplund]

I think this is a known error at BMC.
I have read it somewhere, but I can't find it right now.

I believe that the SLA 6.0 service dies when starting the ARServer,
but the armonitor restarts it, and then it works OK.
So according to the KB, or wherever I've read it, this is nothing to care about.

I also have this error in my logs, but if you look in the
armonitor.log you will see that the SLA service is restarted.

// Niklas Asplund
Siemens IT Solutions and Services

ARS 7.0.1 Patch 1
Windows 2003 Cluster
SQL 2000



On 13/02/07, David Yearsley <[EMAIL PROTECTED]> wrote:

**
ARServer 7.00.01 Patch 1
Solaris 9
Helpdesk 6.0
Asset 6.0
SLA 6.0
ORACLE 9.2i

We are in the process of upgrading our servers to patch 7.00.01 Patch 1. Our
development server is running 7.00.01 Patch 1 with no problems, but now that
we have installed it on our Acceptance Test Server we are getting the
following error.

Tue Feb 13 13:39:24 2007  BRIE : Authentication failed ()  ARERR - 623
Tue Feb 13 13:39:24 2007  BRIE : AR System Application server terminated --
fatal error encountered (ARAPPNOTE 4501)

We installed once and received this error, so we restored our system and we
are still getting this error. Also the plugin server keeps dying as well.
Has anyone seen this problem? Any ideas on what to check or where the
problem could be located?

Thanks
__20060125___This posting was submitted
with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Oracle LOB relocation

[Axton]

There is the option to set the cursor_sharing with a parameter in the
ar.conf file, and the aradmin user, by default, has the ALTER SESSION
privelage, but I can not say whether the ar.conf setting causes the sessions
created by arserver to set the cursor_sharing parameter using the alter
session privelage.

Try this:
- Set the parameter in the ar.conf file
- Have your dba's turn on sql*net trace logs
- Start arserver
- Stop arserver
- Review the logs for an alter session statement that sets the
cursor_sharing parameter

If arserver does not set this automatically based on the config setting, you
may ask your dba's to create a separate instance for Remedy so that this can
be set for the instance.  Alternatively, you can submit an RFE to BMC, but
don't hold your breath if you choose this route.

Axton Grams

On 2/13/07, Tucker, Rob <[EMAIL PROTECTED]> wrote:


** My DBA's are having a real problem with setting cursor-sharing
parameter for the entire instance. Evidently is cause some  problems in the
other table spaces.

Is there a means of setting the parameter for just the ars session?
Something like the following when the server is started?

ALTER SESSION set CURSOR_SHARING = FORCE;"

-Rob Tucker

 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Axton
*Sent:* Tuesday, February 13, 2007 10:41 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Oracle LOB relocation

**

Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will greatly
reduce the size requirements of oracle's shared pool and greatly reduce hard
parses.

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams
On 2/13/07, Tucker, Rob <[EMAIL PROTECTED]> wrote:
>
> ** Thanks Axton. As always, great information
>
> -Rob
>
>  --
> *From:* Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG
> ] *On Behalf Of *Axton
> *Sent:* Monday, February 12, 2007 5:34 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Oracle LOB relocation
>
>
> ** Manage the log storage through the ardb.conf file.  Don't let the dba
> do it directly on the db.  This will cause endless headaches for you and
> them.  Probably the best approach would be:
>
> - set up the server
> - create the ardb.conf file to define the log storage
> - have the dba's manually move the lobs while arserver is stopped
> - start arserver
>
> You will more than likely need to experiment with the ardb.conf and some
> test forms to make sure you get the syntax right.  Taking this approach (the
> best I can see at the moment) has several advantages:
> - installer gets to run as it normally would
> - dba's feel cozy because they witnessed the relocation of the lobs
> - the lobs will be managed on an ongoing basis by the ardb.conf file
>
> Some things to keep in mind:
> - you will need to update the ardb.conf every time a new lob is added
> (prior to adding the lob); failure to do so will cause the lob to be stored
> in the same tablespace as tables/indexes
> - the ardb.conf file had some issues in 6.0.1 with length limitations on
> the clauses (300 something characters).  I am not sure if this issue exists
> in the later releases
>
> Some other things your dba's may want to look into as far as performance
> tuning if you go this route (these are possible using the ardb.conf file
> as well):
> - index storage
> - table/index partitioning
>
> Axton Grams
>
> On 2/12/07, Tucker, Rob < [EMAIL PROTECTED] > wrote:
> >
> > ** We are getting ready to stand up ITSM 7 on Oracle 10G.
> >
> > My DBA's want to relocated all the lobs in particularly HPD:Help Desk
> >
> > I grew up with SQL Server and am not:
> >
> >
> >- Sure what it is they are wanting to do
> >- Sure that Remedy will allow them to do what they are planning
> >to do
> >
> > Is there anyone out there who would shout "NO!  GO BACK!  DO NOT PASS
> > GO!"
> >
> > or this something perfectly reasonable and doable?
> >
> > Thanks,
> >
> > -Rob
> >
> >
> >
> > 
> > *Rob Tucker *
> > *New Edge Networks  ARS Administration and Development* [EMAIL PROTECTED]
> >   *  **Vancover,Washington*  tel: 360-759-9670
> > fax:360-693-9997
> >
> >
> > __20060125___This posting was submitted with HTML
> > in it___
>
>
> __20060125___This posting was submitted with HTML in
> it___
> __20060125___This posting was submitted with HTML in
> it___
>

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



___

ARERR 424 question

[Mary Dollus]

Good Evening All,

We did a dbrestore from a preprod server to a dev server to make sure they
were in sync.  When I tried to create a filter on the dev server, I'd get
error 424:

"424 Error: Filter and escalation Push Fields actions can only affect forms
on the same server as the filter or escalation.  In filters and escalations,
you cannot use a Push Fields action to push values to forms residing on
different servers."

I stopped getting the error when I changed my Account to the server name
instead of the server IP Address.

I was wondering why this happened and if it's best to always use the server
name vs. the IP.  If so, what side effects are there if the IP is used.
(Other than ARERR 424 :) ) 

Thanks!!! :)

Mary Dollus
 
ARS 7.0.1
Linux 2.6.9-22.ELsmp

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: mid-tier 5.1.2 and jre

[strauss]

I did not see any issues when replacing Java 1.4.1_02 with 1.4.2_13 on
any of my 5.1.2 or 6.3 mid-tier servers, but all are on Windows Server
2000 or 2003 using IIS 5 or 6 with ServletExec. You will want to use
_13, since _12 and earlier have a security vulnerability.

Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rocky Rockwell
Sent: Tuesday, February 13, 2007 7:24 PM
To: arslist@ARSLIST.ORG
Subject: mid-tier 5.1.2 and jre

Folks,

Anybody had any luck in get java jre 1.4.2_11 or 12 or 13 or any version
that is DST compliant to run on IE6sp2 and mid-tier 5.1.2?

We are having issue in our environment
mid-tier 5.1.2
Web server is weblogic 8.1sp3
solaris 9 w/DST patches
-- 

*Rocky*

Rocky Rockwell
eMA Team - Remedy Developer
[EMAIL PROTECTED] 
Ph#1: 214-567-8874
Ph#2: 325-884-1263


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Oracle LOB relocation

[Tucker, Rob]

My DBA's are having a real problem with setting cursor-sharing parameter
for the entire instance. Evidently is cause some  problems in the other
table spaces.
 
Is there a means of setting the parameter for just the ars session?
Something like the following when the server is started?
 
ALTER SESSION set CURSOR_SHARING = FORCE;"
 
-Rob Tucker



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, February 13, 2007 10:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle LOB relocation


** 

Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will
greatly reduce the size requirements of oracle's shared pool and greatly
reduce hard parses. 

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams


On 2/13/07, Tucker, Rob <[EMAIL PROTECTED]> wrote: 

** 
Thanks Axton. As always, great information
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG ] On Behalf Of Axton
Sent: Monday, February 12, 2007 5:34 PM
To: arslist@ARSLIST.ORG 
Subject: Re: Oracle LOB relocation

 
** Manage the log storage through the ardb.conf file.  Don't let
the dba do it directly on the db.  This will cause endless headaches for
you and them.  Probably the best approach would be: 


- set up the server
- create the ardb.conf file to define the log storage
- have the dba's manually move the lobs while arserver is
stopped
- start arserver 

You will more than likely need to experiment with the ardb.conf
and some test forms to make sure you get the syntax right.  Taking this
approach (the best I can see at the moment) has several advantages: 
- installer gets to run as it normally would 
- dba's feel cozy because they witnessed the relocation of the
lobs
- the lobs will be managed on an ongoing basis by the ardb.conf
file

Some things to keep in mind: 
- you will need to update the ardb.conf every time a new lob is
added (prior to adding the lob); failure to do so will cause the lob to
be stored in the same tablespace as tables/indexes
- the ardb.conf file had some issues in 6.0.1 with length
limitations on the clauses (300 something characters).  I am not sure if
this issue exists in the later releases 

Some other things your dba's may want to look into as far as
performance tuning if you go this route (these are possible using the
ardb.conf file as well):
- index storage
- table/index partitioning

Axton Grams


On 2/12/07, Tucker, Rob < [EMAIL PROTECTED]
 > wrote: 

** 
We are getting ready to stand up ITSM 7 on Oracle 10G.
 
My DBA's want to relocated all the lobs in particularly
HPD:Help Desk
 
I grew up with SQL Server and am not:
 

*   Sure what it is they are wanting to do 
*   Sure that Remedy will allow them to do what they
are planning to do

Is there anyone out there who would shout "NO!  GO BACK!
DO NOT PASS GO!"
 
or this something perfectly reasonable and doable?
 
Thanks,
 
-Rob
 

 
 

Rob Tucker  
New Edge Networks  ARS Administration and Development
[EMAIL PROTECTED] 
  Vancover,Washington   
tel: 360-759-9670
fax:360-693-9997
 
 
__20060125___This posting was
submitted with HTML in it___ 


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


__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

mid-tier 5.1.2 and jre

[Rocky Rockwell]

Folks,

Anybody had any luck in get java jre 1.4.2_11 or 12 or 13 or any version 
that is DST compliant to run on IE6sp2 and mid-tier 5.1.2?


We are having issue in our environment
mid-tier 5.1.2
Web server is weblogic 8.1sp3
solaris 9 w/DST patches
--

*Rocky*

Rocky Rockwell
eMA Team – Remedy Developer
[EMAIL PROTECTED] 
Ph#1: 214-567-8874
Ph#2: 325-884-1263

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Question: Administrator - Password Reset

[Shellman, David]

We set up a couple of things.  We use a User profile form to keep most of the 
information about an individual.  We then added a button that opens a dialog 
box that has 2 fields for password.  When the person saves the new password the 
person that changed it and the date and time are pushed back to the User 
Profile form.  This just logs who changed the password and when.  The new 
password is pushed to the User form.

That's just work flow to catch the who and when. 

We created a permissions group called Dispatcher that's associated with the 
Help Desk folks.  That permissions group is added to the Password field on the 
User form along with the Assignee permissions..  This allows them to change 
passwords without admin permissions..  

Dave
--
[EMAIL PROTECTED] (Wireless)

- Original Message -
From: Tyrone Dee <[EMAIL PROTECTED]>
To: Shellman, David
Sent: Tue Feb 13 19:42:39 2007
Subject: FW: Question:  Administrator - Password Reset

Dave – how did you do this?  We have 10 members on the help desk who currently 
have administrator access and I really don’t like this.

 

Thanks.

 

Ty

 

 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Shellman, David
Sent: Tuesday, February 13, 2007 7:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Administrator - Password Reset

 

Not admin but we have set up our help desk with the necessary permissions to 
change passwords.

Dave
--
[EMAIL PROTECTED] (Wireless)

- Original Message -
From: Action Request System discussion list(ARSList) 
To: arslist@ARSLIST.ORG 
Sent: Tue Feb 13 19:27:44 2007
Subject: Question:  Administrator - Password Reset

I am curious about what others do when their users need their Remedy Password
reset.

Do you give your help desk staff administrator permissions to your
Remedy Server
to reset the users passwords or .?

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Mailto Links Not Opening Right

[Shanmugadas, Suresh]

Fellow Listers
 
I am done with the SSSO for Midtier with IIS, ARS 7.0.1, win 2003 server
and it is working properly. If I can be of any help, I am glad to help
in this area now. Thanks to all the people who gave some valuable tips.
 
 
My next task is the SSSO for the Remedy User tool, has anyone
implemented it. If yes, could you please provide some guidance. Any
issues/problems you faced, Please let me know.
 
Your response is much appreciated!!
 
 
Thank you
SK



From: Shanmugadas, Suresh 
Sent: Tuesday, February 13, 2007 5:03 PM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Mailto Links Not Opening Right


testmail.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ARSList
Sent: Tuesday, February 13, 2007 4:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mailto Links Not Opening Right


** 

Yah that's a bug until Mid-Tier 6.3 Patch 14.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 6:57 AM
To: arslist@ARSLIST.ORG
Subject: Mailto Links Not Opening Right

 

Hi all:

 

This is probably a version bug, too-I'm still running 5.1.2 server and
midtier-but I was hoping against hope that maybe someone out there has
seen this and knows of a fix.

 

I have an active link that does a simple run process:
PERFORM-ACTION-OPEN-URL mailto:[EMAIL PROTECTED]  It works perfectly in
the client; however, in the midtier, it opens a new browser window and
for some bizarre reason chooses to precede the mailto link with http.
So the midtier tries to open http://mailto:[EMAIL PROTECTED]
 , which causes the browser to open
and attempt to open such a website, which of course doesn't exist, so I
get the page cannot be displayed error.

 

Does anyone know of a way to make the midtier not precede the mailto
address with http://?

 

Thanks,

Norm

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Mailto Links Not Opening Right

[Shanmugadas, Suresh]

testmail.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of ARSList
Sent: Tuesday, February 13, 2007 4:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mailto Links Not Opening Right


** 

Yah that's a bug until Mid-Tier 6.3 Patch 14.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 6:57 AM
To: arslist@ARSLIST.ORG
Subject: Mailto Links Not Opening Right

 

Hi all:

 

This is probably a version bug, too-I'm still running 5.1.2 server and
midtier-but I was hoping against hope that maybe someone out there has
seen this and knows of a fix.

 

I have an active link that does a simple run process:
PERFORM-ACTION-OPEN-URL mailto:[EMAIL PROTECTED]  It works perfectly in
the client; however, in the midtier, it opens a new browser window and
for some bizarre reason chooses to precede the mailto link with http.
So the midtier tries to open http://mailto:[EMAIL PROTECTED]
 , which causes the browser to open
and attempt to open such a website, which of course doesn't exist, so I
get the page cannot be displayed error.

 

Does anyone know of a way to make the midtier not precede the mailto
address with http://?

 

Thanks,

Norm

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Mailto Links Not Opening Right

[ARSList]

Yah that's a bug until Mid-Tier 6.3 Patch 14.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 6:57 AM
To: arslist@ARSLIST.ORG
Subject: Mailto Links Not Opening Right

 

Hi all:

 

This is probably a version bug, too-I'm still running 5.1.2 server and
midtier-but I was hoping against hope that maybe someone out there has
seen this and knows of a fix.

 

I have an active link that does a simple run process:
PERFORM-ACTION-OPEN-URL mailto:[EMAIL PROTECTED]  It works perfectly in
the client; however, in the midtier, it opens a new browser window and
for some bizarre reason chooses to precede the mailto link with http.
So the midtier tries to open http://mailto:[EMAIL PROTECTED]
 , which causes the browser to open
and attempt to open such a website, which of course doesn't exist, so I
get the page cannot be displayed error.

 

Does anyone know of a way to make the midtier not precede the mailto
address with http://?

 

Thanks,

Norm

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Question: Administrator - Password Reset

[Shellman, David]

Not admin but we have set up our help desk with the necessary permissions to 
change passwords. 

Dave
--
[EMAIL PROTECTED] (Wireless)

- Original Message -
From: Action Request System discussion list(ARSList) 
To: arslist@ARSLIST.ORG 
Sent: Tue Feb 13 19:27:44 2007
Subject: Question:  Administrator - Password Reset

I am curious about what others do when their users need their Remedy Password
reset.

Do you give your help desk staff administrator permissions to your 
Remedy Server
to reset the users passwords or .?

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Question: Administrator - Password Reset

[T. Dee]

I am curious about what others do when their users need their Remedy Password
reset.

Do you give your help desk staff administrator permissions to your 
Remedy Server

to reset the users passwords or .?

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

SSSO for Remedy User Tool

[Shanmugadas, Suresh]

Fellow Listers
 
I have completed the SSSO for Midtier with IIS, ARS 7.0.1, win 2003
server and it is working properly. If I can be of any help, I am glad to
help in this area now. Thanks to all the people who gave some valuable
tips.
 
 
My next task is the SSSO for the Remedy User tool, has anyone
implemented it. If yes, could you please provide some guidance. Any
issues/problems you faced, Please let me know.
 
Your response is much appreciated!!
 
 
Thank you
SK
 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

[Roger Justice]

There are 2 entries for Incident and I assume there are 2 entries for  
Change. The Incident entries are Request ID and Incident Number. On the  
notifications both are now listed in the URL.
 
Roger

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Remedy 6.3 Patch 20 ( DST ) (UNCLASSIFIED)

[Mench, Ryan M CTR USA DOIM]

Classification:  UNCLASSIFIED 
Caveats: NONE

I would strongly suggest you export all of your license keys to a file
as well.  I installed patch-20 on my development box with no issues, but
lost all of my keys when I installed on production.  Support was
gracious enough to let me know that should not have happened.  Good
luck!
 
---
Ryan M. Mench
Remedy Development
United States Army
Directorate of Information Management (DOIM)
6151 Specker Ave, Bldg 1550, Rm 2210
Fort Carson, CO 80913
(719)524.0514
---
 
 

-Original Message- 

** 

I know we have discussed this before but I was wondering if any of you
have seen any new problems loading patch 20 for the DST fix.  I am
running the following:

 

Remedy 6.3

Oracle 10g 

patch 18

 

Unfortunately I do not have a development server so once I install patch
20 thats it.  

--
Katherine 

__20060125___This posting was submitted with HTML in
it___ 

__20060125___This posting was submitted with HTML in
it___ 
Classification:  UNCLASSIFIED 
Caveats: NONE

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

[Lucero, Michelle - IST contractor]

Hi, Kim:
 
We haven't tested email notifications in 7.0.1, yet.  Would this format
still work in an email?
http://midtierserver/arsys/forms/arserver/CHG:Change/Support/?eid=CHG000
01023
 

Thanks,

Michelle




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly M
Sent: Tuesday, February 13, 2007 9:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: BUG in 7.0.1 patch 001 that is not reported in the Notes


** 

Tell me about it!  I had to track them all down and manually add the URL
with the Case ID in the test for the email.  

 

I also got this:

 

There are two bug records submitted and our engineers are giving it the
highest priority. 

 

SW00258844 and SW00256255

 

They told me that I would be notified when it was corrected.  So we
shall see.

 

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.
Sent: Tuesday, February 13, 2007 9:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

 

That does not sound good at all!  We are planning to move to 7.01 and we
have numerous email filters that include a hyperlink to the assignee's
ticket.

What do they mean when they say  "a resolution is expected until
Odin"?  Ive heard this support talk about various projects like "Thor"
or something...

 

 

Thanks 
Peter Lammey 
ESPN MIT Technical Services & Applications Management 
860-766-4761 

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly M
Sent: Tuesday, February 13, 2007 7:46 AM
To: arslist@ARSLIST.ORG
Subject: BUG in 7.0.1 patch 001 that is not reported in the Notes

** 

FYI.  I just finished upgrading to 7.0.1 patch 001 and it breaks the URL
link on filter notifications.  It is not on the support web.  If you use
this - as we do - you will need to do the workaround.

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax

-Original Message-
From: BMC Customer Support [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:42 AM
To: Olds, Kimberly M
Subject: Re: (ISS03069335, 2-High)

Hello Kim

This is what I received from the team -lead on the web team:

"Two AR Server defects have been submitted around this problem:

 

ARS 7.0.1 FCS and Patch 1 - filter notifications do not add a value for
"eid=" in Web URL shortcuts, resulting in:

http:///arsys/servlet/ViewFormServlet?form=&server=&eid=NULL

SW00258844, SW00256255

 

These are not yet escalated by Server team(s), so a resolution isn't
expected until Odin.  As a workaround, a customer can add workflow to
generate their own URLs in a character field and include that field as
part of the notification."

 

Thanks,

-Ibrahim Akar

__20060125___This posting was submitted with HTML in
it___

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Error: ARERR [9295] incorrect login parameters

[Pargeter, Christie]

You can build custom login pages with the form & server you want them to
go to embedded into the login page. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Tuesday, February 13, 2007 1:23 PM
To: arslist@ARSLIST.ORG
Subject: Error: ARERR [9295] incorrect login parameters

First off...I know that they need to bookmark the home page...not the
login page...but is there something that can be done with the login.jsp
that if these parameters are empty on submit it defaults them to the
home page?


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

UNSUBSCRIBE

[Richard Copits]

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Tuesday, February 13, 2007 4:23 PM
To: arslist@ARSLIST.ORG
Subject: Error: ARERR [9295] incorrect login parameters

First off...I know that they need to bookmark the home page...not the
login
page...but is there something that can be done with the login.jsp that
if
these parameters are empty on submit it defaults them to the home page?


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


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 ARSlist:"Where the 
Answers Are"

Re: Remedy 6.3 Patch 20 ( DST )

[Candace DeCou]

I installed on ARS with Remedy 6.3 Patch 16 using SQL 2000 and did not
have any problems (in Dev), BUT...when I installed on Mid-Tier 6.3 Patch
16 (in Production) I had huge issues.  We ran into terrible memory
problems, the entire mid-tier stopped functioning and we could not
restart servletexec services.  The ServeletExec 5.0 AS seemed to be
looking for the serveletexec.dll in a file structure that did not even
exist and was not where we were pointing the filter to.  It was a
nightmare in production for almost 3 hours.  Thanks to Venu Reddy at
Remedy Support for helping me while the world was falling apart, we got
it resolved.  

 

You didn't mention mid-tier, but just in casebe very careful.  We
had to update the recommended added statement in StartServeletExec.bat
from the previously recommended '-Xmx512m' to '-Xmx1028m' in spite of
having adequate memory on the server.  That and kicking the server a few
times seemed to resolve the problem and we now seem to be just fine.

 

Hope this helps.

:-)

Candace

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Katherine Hoffner
Sent: Tuesday, February 13, 2007 11:24 AM
To: arslist@ARSLIST.ORG
Subject: Remedy 6.3 Patch 20 ( DST )

 

** 

I know we have discussed this before but I was wondering if any of you
have seen any new problems loading patch 20 for the DST fix.  I am
running the following:

 

Remedy 6.3

Oracle 10g 

patch 18

 

Unfortunately I do not have a development server so once I install patch
20 thats it.  

-- 
Katherine 

__20060125___This posting was submitted with HTML in
it___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Error: ARERR [9295] incorrect login parameters

[L. J. Head]

First off...I know that they need to bookmark the home page...not the login
page...but is there something that can be done with the login.jsp that if
these parameters are empty on submit it defaults them to the home page?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

ARServer 7.00.01 Patch 1

[David Yearsley]

ARServer 7.00.01 Patch 1
Solaris 9
Helpdesk 6.0
Asset 6.0
SLA 6.0
ORACLE 9.2i
 
We are in the process of upgrading our servers to patch 7.00.01 Patch 1. Our 
development server is running 7.00.01 Patch 1 with no problems, but now that we 
have installed it on our Acceptance Test Server we are getting the following 
error. 
 
Tue Feb 13 13:39:24 2007  BRIE : Authentication failed ()  ARERR - 623
Tue Feb 13 13:39:24 2007  BRIE : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
 
We installed once and received this error, so we restored our system and we are 
still getting this error. Also the plugin server keeps dying as well. Has 
anyone seen this problem? Any ideas on what to check or where the problem could 
be located?
 
Thanks

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: remotely install ARS7 as non-root user on Solaris server from Window XP desktop

[Grooms, Frederick W]

Log in to the Solaris box (depending on your setup you can use an app
like PuTTY or even telnet)   
Set the environment variable ARSNONROOT=TRUE   
Run the install   
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jiaqi Yu
Sent: Tuesday, February 13, 2007 2:50 PM
To: arslist@ARSLIST.ORG
Subject: remotely install ARS7 as non-root user on Solaris server from
Window XP desktop


Please let me know if you have any idea how to do it?
 
JY
 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

remotely install ARS7 as non-root user on Solaris server from Window XP desktop

[Jiaqi Yu]

Please let me know if you have any idea how to do it?

JY

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Oracle Cursor Sharing

[Axton]

I did this on 6.0.1 and 7.0.01.  The difference is in the amount of memory
allocated in the shared pool (drops to ~1/5 of original allocation) and the
number of hard parses.  When the cursor_sharing is set to exact, there
is nearly a 1:1 ration between sql statements and hard parses.  This drops
very significantly (maybe 1/100 to 1/1000, depending on how your server is
used).  It's more of a scalability issue that this addresses than anything.
If running 32-bit Oracle, you can only address 4gb of memory; this can
easily be exhaused due to the poor usage of the shared pool because every
statements gets its own cursor if the number of threads is increased beyond
a certain limit.

Axton Grams


On 2/13/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:


** Does anyone using Remedy 6.3 (against Oracle 10g) have their
cursor_sharing set to similiar, and did they notice any improvments?

Fred

 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Axton
*Sent:* Tuesday, February 13, 2007 12:41 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Oracle LOB relocation



Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will greatly
reduce the size requirements of oracle's shared pool and greatly reduce hard
parses.

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams


__20060125___This posting was submitted with HTML in
it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Question. Why is ' replaced with a ? in a email message

[Thomas Bean]

Dan,
If this is in an outgoing e-mail notification from ARS, I would guess that the 
original quote character was copied and pasted into a Remedy field from a M$ 
application such as Word or Outlook.  The AutoCorrect feature in these 
applications will usually transform standard "straight" quote characters into 
the "curly" quote characters that are included in the extended Windows-1252 
character set (see http://en.wikipedia.org/wiki/Windows-1252).  Quite an 
annoying feature IMHO...

The extra characters in the 0x80 to 0x9F range will usually appear as an 
unknown control character when viewed in the Remedy User Tool, and will usually 
appear as a "?" when they are rendered by the ARS E-mail Engine.

This site has info on how to disable or modify the AutoCorrect settings in M$ 
Office applications to prevent this from occurring:

http://office.microsoft.com/en-us/word/HA101732421033.aspx

I haven't attempted it, but I think it should also be possible to clean up the 
input into the Remedy fields using the REPLACE() function in a filter.

HTH,

Thomas

  - Original Message - 
  From: Dan Caissie 
  Newsgroups: gmane.comp.crm.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Tuesday, February 13, 2007 13:17
  Subject: Question. Why is ' replaced with a ? in a email message


  ** 
   

  I have a question.

  Why is ' as in it's would be replaced by it?s being replaced by a ? in a text 
email notification.

  Simple right J

  Thank you,

   

  Dan-

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: CMDB 1.1 Change Pending

[Robert Molenda]

Ah' that wonderful "explode after error and now you are stuck"
condition. I know this because "been there and done that" has applied.

At this point you must manually cleanup the Meta Data, and add the
field(s) back again.

Unfortunately the UI/Workflow does not check for "bad things" but when
you try to update, then it goes BOOM. (You had the '-' character in the
field..)

Before you go in and get "deletion happy" in the OBJSTR: forms, remember
to always CYI and export to arx ALL ENTIRES IN ALL TABLES of OBJSTR:..
One of our contractors went 'delete happy' and then nothing all worked,
and it was restore DB time into a spare DB and recover the entries :(

Q(s)>>

Is this the first MetaUpdate that has run on the system, or have other
custom fields been added. A good test is to go in and simply view some
fields, and the UI thinks you updated and will update it again. This
MUST GO OK before going any further!!

Ensure (by scanning) that you don't duplicate ID/Field Name/name
restrictions, and you should be fine.

Also, we could not add more than 6 or 7 fields at one attempt or would
get the same error.

HTH

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Tuesday, February 13, 2007 11:03 AM
To: arslist@ARSLIST.ORG
Subject: CMDB 1.1 Change Pending

I added several fields via the class manager.  When I clicked "Save" I
received an error:  

ARERR [298] Too many filters processed during this operation
OBJSTR:AttributeDefinition


The preceding message occurred during the execution of active link
OBJSTR:ClassDef_SaveChanges -- action 2. (ARNOTE 1101)

This was in my arerror.log

Mon Feb 12 17:32:40 2007  390620 : Too many filters processed during
this operation (ARERR 298)
Mon Feb 12 17:32:40 2007 OBJSTR:AttributeDefinition

So I go to the admin tool and increase the filter value and then hit
save again and everything looked ok.

All of my fields are still showing "Change Pending" and when I look at
the task manager,  the arcmdbd server process is running, and the
dispatcher (arsvcdsp) server process is running on the server.

The only thing in the view log is:

2/12/2007 5:40:48 PM Remedy Application Service
Sync Class: BMC:BMC_AssetBase

2/12/2007 5:40:49 PM Remedy Application Service
ERROR: 120078 The supplied character is not allowed in the name.
W-Parts: '-'


Do I have to recreate all of the fields?

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


Claire Sanford
Information Systems Division
Memorial Hermann Healthcare System
Phone: 713 448 6035
[EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Limit Number of Items Returned on the Midtier

[Opela, Gary L Contr OC-ALC/ITMA]

I tried both, and both acted as expected. The Mid-Tier is what I was speaking 
of below whenever I stated that only 5 rows were returned.

 

Gary 



 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 2:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

Make what you want to of the above. 

I tried the following scenario on MT 6.3:

I had a table field which had 6 matching results. The table field has Max. Rows 
set to '5.'

I refreshed the table field, and only 5 rows returned.

I think they have fixed it in 6.x.

You should upgrade :-)

Gary

 

Did you try what you tried on the midtier or the client? The client behaves, to 
me, appropriately.  The midtier does not.

And I agree with you on the upgrade.  If only I could...every night I have 
visions of 7.0.1 dancing in my head.

 

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

>From Basic Admin Guide 6.x:

 

Max. Rows 

 

Specifies the maximum number of rows that will appear. If you enable chunking,

this setting is ignored.

If users select Refresh or Refresh Table, the maximum number of rows that the

administrator defines is displayed. In Remedy User, if users select Refresh All 
in

Table, the maximum number of rows that the administrator defines is ignored.

(On web clients, there is no Refresh All function. For more information, see

"Defining Table Labels properties" on page 299.)

 

Note: For results list fields on the web, there is no default maximum for the

number of items returned. If you do not specify a value greater than zero for

Max. Rows, and if the Limit Number of Items Returned user preference is not

selected, then the results list field will return unlimited items during a 
search.

 

 

Make what you want to of the above. 

 

I tried the following scenario on MT 6.3:

 

I had a table field which had 6 matching results. The table field has Max. Rows 
set to '5.'

I refreshed the table field, and only 5 rows returned.

 

I think they have fixed it in 6.x.

 

You should upgrade :-)


Gary



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 1:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

Thanks, Gary.  You are right-the limit is controlled through the preferences 
form and it bleeds over to the midtier, too.  However, that, ultimately, was 
not the source of my trouble.

 

I figured out that if you set a max number of rows to be displayed in a table 
in version 5.1.2 of the midtier (don't know if this happens in 6.0+), if you 
refresh the table and, say, seven database records match the table's 
qualification, the midtier throws ARWARN 66!!! The client doesn't, but the 
midtier does.  I'm curious to know if this happens in 6.3+.

 

Norm

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

I think you can use the AR System User Preferences form to control this on the 
web.

 

https:///AR+System+User+Preference/Default+Administrator+View/

 

You might give that a go, and this is on 6.3, so you might have different 
results.

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Limit Number of Items Returned on the Midtier

 

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to limit 
the number of items returned when executing a search on the midtier.  In the 
client it's an option setting that gets pushed to the user preferences form.  
How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum number 
of entries specified for retrieval" (ARWARN 66) when I run my app in the 
midtier but I don't get it when running it in the client.

 

Thoughts?

Norm

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

Re: Limit Number of Items Returned on the Midtier

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Make what you want to of the above. 

I tried the following scenario on MT 6.3:

I had a table field which had 6 matching results. The table field has Max.
Rows set to '5.'

I refreshed the table field, and only 5 rows returned.

I think they have fixed it in 6.x.

You should upgrade :-)

Gary

 

Did you try what you tried on the midtier or the client? The client behaves,
to me, appropriately.  The midtier does not.

And I agree with you on the upgrade.  If only I could...every night I have
visions of 7.0.1 dancing in my head.

 

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

>From Basic Admin Guide 6.x:

 

Max. Rows 

 

Specifies the maximum number of rows that will appear. If you enable
chunking,

this setting is ignored.

If users select Refresh or Refresh Table, the maximum number of rows that
the

administrator defines is displayed. In Remedy User, if users select Refresh
All in

Table, the maximum number of rows that the administrator defines is ignored.

(On web clients, there is no Refresh All function. For more information, see

"Defining Table Labels properties" on page 299.)

 

Note: For results list fields on the web, there is no default maximum for
the

number of items returned. If you do not specify a value greater than zero
for

Max. Rows, and if the Limit Number of Items Returned user preference is not

selected, then the results list field will return unlimited items during a
search.

 

 

Make what you want to of the above. 

 

I tried the following scenario on MT 6.3:

 

I had a table field which had 6 matching results. The table field has Max.
Rows set to '5.'

I refreshed the table field, and only 5 rows returned.

 

I think they have fixed it in 6.x.

 

You should upgrade :-)


Gary

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 1:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

Thanks, Gary.  You are right-the limit is controlled through the preferences
form and it bleeds over to the midtier, too.  However, that, ultimately, was
not the source of my trouble.

 

I figured out that if you set a max number of rows to be displayed in a
table in version 5.1.2 of the midtier (don't know if this happens in 6.0+),
if you refresh the table and, say, seven database records match the table's
qualification, the midtier throws ARWARN 66!!! The client doesn't, but the
midtier does.  I'm curious to know if this happens in 6.3+.

 

Norm

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

I think you can use the AR System User Preferences form to control this on
the web.

 

https:///AR+System+User+Preference/Default+Administrator+View/
 

 

You might give that a go, and this is on 6.3, so you might have different
results.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Limit Number of Items Returned on the Midtier

 

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to
limit the number of items returned when executing a search on the midtier.
In the client it's an option setting that gets pushed to the user
preferences form.  How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum
number of entries specified for retrieval" (ARWARN 66) when I run my app in
the midtier but I don't get it when running it in the client.

 

Thoughts?

Norm

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Oracle Cursor Sharing

[Grooms, Frederick W]

Does anyone using Remedy 6.3 (against Oracle 10g) have their
cursor_sharing set to similiar, and did they notice any improvments?
 
Fred



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, February 13, 2007 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle LOB relocation



Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will
greatly reduce the size requirements of oracle's shared pool and greatly
reduce hard parses. 

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams


 
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Question. Why is ' replaced with a ? in a email message

[Axton]

Chances are you are using some high order ascii character like char 80 (´)
or 146 (') or 145 (') instead of ascii char 39.  Retype the email text and
make sure you use the apostraphe located to the right of the semi-colon key.

Your mail reader may not know how to handle ascii chars > 127 (7-bit) or
your mta may not know how (configuration) to relay non-7bit ascii chars.

I had one of these in an email template the other day that came out as some
chinese char in some mail readers, and upside question mark in other
readers.

Axton Grams


On 2/13/07, Dan Caissie <[EMAIL PROTECTED]> wrote:


**



I have a question.

Why is ' as in it's would be replaced by it?s being replaced by a ? in a
text email notification.

Simple right J

Thank you,



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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Limit Number of Items Returned on the Midtier

[Opela, Gary L Contr OC-ALC/ITMA]

>From Basic Admin Guide 6.x:

 

Max. Rows 

 

Specifies the maximum number of rows that will appear. If you enable
chunking,

this setting is ignored.

If users select Refresh or Refresh Table, the maximum number of rows
that the

administrator defines is displayed. In Remedy User, if users select
Refresh All in

Table, the maximum number of rows that the administrator defines is
ignored.

(On web clients, there is no Refresh All function. For more information,
see

"Defining Table Labels properties" on page 299.)

 

Note: For results list fields on the web, there is no default maximum
for the

number of items returned. If you do not specify a value greater than
zero for

Max. Rows, and if the Limit Number of Items Returned user preference is
not

selected, then the results list field will return unlimited items during
a search.

 

 

Make what you want to of the above. 

 

I tried the following scenario on MT 6.3:

 

I had a table field which had 6 matching results. The table field has
Max. Rows set to '5.'

I refreshed the table field, and only 5 rows returned.

 

I think they have fixed it in 6.x.

 

You should upgrade :-)


Gary



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 1:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

Thanks, Gary.  You are right-the limit is controlled through the
preferences form and it bleeds over to the midtier, too.  However, that,
ultimately, was not the source of my trouble.

 

I figured out that if you set a max number of rows to be displayed in a
table in version 5.1.2 of the midtier (don't know if this happens in
6.0+), if you refresh the table and, say, seven database records match
the table's qualification, the midtier throws ARWARN 66!!! The client
doesn't, but the midtier does.  I'm curious to know if this happens in
6.3+.

 

Norm

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr
OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

I think you can use the AR System User Preferences form to control this
on the web.

 

https:///AR+System+User+Preference/Default+Administrator+View/

 

You might give that a go, and this is on 6.3, so you might have
different results.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Limit Number of Items Returned on the Midtier

 

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to
limit the number of items returned when executing a search on the
midtier.  In the client it's an option setting that gets pushed to the
user preferences form.  How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum
number of entries specified for retrieval" (ARWARN 66) when I run my app
in the midtier but I don't get it when running it in the client.

 

Thoughts?

Norm

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Automated Data Import

[Clary, Bill]

Dylan;
  A lot of your decision should be based on "how" you get the file and
what "format" you can get it in.

1. Is a file the only way? How about a query into the database it comes
from?
2. The file is emailed to you and they have no way to do FTP or copy it
to your server?
3. The file can "not" be formatted before being sent to you?

  If they have a database that this file is made from (scream and shout)
to get access, then make a view form or maybe a Web service if they
support it.

  If they can format the file as CSV or ASC and can automate copying it
to your server, then use arimport command line and a Remedy escalation.

  If they can not format it before you get it, then you will have to use
"something" to parse it to a format you can use (maybe arspearl if you
have it).

Bill Clary
Remedy Developer, Tech Solutions, FIS



"Wheeler, Dylan" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
I'm trying to figure out the best way to do a scheduled data import into
remedy.
We have a file that we get every week that contains a list of our
network users and I need to automate getting that data into remedy. We
are using 6.3 with MS SQL on the back end. Would it be easiest to
schedule a sql job to import that data? I'm not used to getting user
data this way. I've always had access to everything from AD so I just
used Vendor forms to get it.
Just looking for some advice.

-

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

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.



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 ARSlist:"Where
the Answers Are"
--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Remedy 6.3 Patch 20 ( DST )

[Thomas Bean]

We ran into problems loading Patch 20 on our Mid-Tier using the "File 
Replace" method (Linux OS), due to missing links in shared object libraries. 
The workaround provided by BMC was to rename the original Mid-Tier install 
directory, then apply the patch to the original install location using the 
installer script method and selecting 'Other' when prompted for a web server 
and JSP engine.

The libraries extracted by the installer script were *not* identical to 
those provided in the file replace method, and everything worked correctly 
after running the script.  Don't forget to log into the Mid-Tier 
administration page to restore any settings that were in place prior to the 
patch being applied, such as "Prefer standard/windows views".  The patch 
will erase any custom settings and will reset the password on the 
Administration page back to the default of 'arsystem'.

--Thomas

- Original Message - 
From: "Katherine Hoffner" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: 
Sent: Tuesday, February 13, 2007 13:23
Subject: Remedy 6.3 Patch 20 ( DST )


I know we have discussed this before but I was wondering if any of you have
seen any new problems loading patch 20 for the DST fix.  I am running the
following:

Remedy 6.3
Oracle 10g
patch 18

Unfortunately I do not have a development server so once I install patch 20
thats it.

-- 
Katherine

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Gatewood Kelly]

My suggestion would be to purchase Kinetic Survey.fairly inexpensive
and a BIG bang for the buck 

http://www.kineticdata.com/survey.html

Kelly Gatewood
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Tuesday, February 13, 2007 13:12
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket

I do something similar here with a separate counter form, except every
## ticket that each technician resolves they get a new "follow up"
ticket auto-created and assigned to them the following morning.  The
tech then has to follow up to make sure everything is still fine.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason
Sent: Tuesday, February 13, 2007 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket


I have thought about something similar but never implement it. 

One option is to set a counter in another form, every time a ticket is
resolved, increment 1 to the counter; your survey email will be trigger
once the counter reaches 100 or any number you set. 


Jason Niu

Sr. Remedy System Engineer

Remedy System & Operation

GETS - Enterprise Systems Management 

Email:[EMAIL PROTECTED]

135 W 50th Street, NYC,NY,10020

212-823-6893.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.  
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication
is strictly prohibited. If you are not the intended recipient, please
contact the sender immediately by reply e-mail and destroy all copies of
the original message. Please note that we do not accept account orders
and/or instructions by e-mail, and therefore will not be responsible for
carrying out such orders and/or instructions.  If you, as the intended
recipient of this message, the purpose of which is to inform and update
our clients, prospects and consultants of developments relating to our
services and products, would not like to receive further e-mail
correspondence from the sender, please "reply" to the sender indicating
your wishes.  In the U.S.: 1345 Avenue of the Americas, New York, NY
10105.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Remedy 6.3 Patch 20 ( DST )

[Kyle Whitley]

I had an issue with drill down functionality on flashboards on my mid 
tier, but I think it had already been bugged.  Support had a workaround 
for me that going again.  I have been running it on my dev server for a 
week or so with no issues.


Kyle

Katherine Hoffner wrote:

**
I know we have discussed this before but I was wondering if any of you 
have seen any new problems loading patch 20 for the DST fix.  I am 
running the following:
 
Remedy 6.3

Oracle 10g
patch 18
 
Unfortunately I do not have a development server so once I install 
patch 20 thats it. 


--
Katherine
__20060125___This posting was submitted with HTML 
in it___ 


--
Kyle Whitley
IT System Support Professional
Office of Information and Instructional Technology (OIIT)
Board of Regents of the University System of Georgia

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Limit Number of Items Returned on the Midtier

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Thanks, Gary.  You are right-the limit is controlled through the preferences
form and it bleeds over to the midtier, too.  However, that, ultimately, was
not the source of my trouble.

 

I figured out that if you set a max number of rows to be displayed in a
table in version 5.1.2 of the midtier (don't know if this happens in 6.0+),
if you refresh the table and, say, seven database records match the table's
qualification, the midtier throws ARWARN 66!!! The client doesn't, but the
midtier does.  I'm curious to know if this happens in 6.3+.

 

Norm

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA
Sent: Tuesday, February 13, 2007 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Number of Items Returned on the Midtier

 

I think you can use the AR System User Preferences form to control this on
the web.

 

https:///AR+System+User+Preference/Default+Administrator+View/
 

 

You might give that a go, and this is on 6.3, so you might have different
results.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE
Sent: Tuesday, February 13, 2007 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Limit Number of Items Returned on the Midtier

 

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to
limit the number of items returned when executing a search on the midtier.
In the client it's an option setting that gets pushed to the user
preferences form.  How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum
number of entries specified for retrieval" (ARWARN 66) when I run my app in
the midtier but I don't get it when running it in the client.

 

Thoughts?

Norm

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Limit Number of Items Returned on the Midtier

[Opela, Gary L Contr OC-ALC/ITMA]

I think you can use the AR System User Preferences form to control this
on the web.

 

https:///AR+System+User+Preference/Default+Administrator+View/

 

You might give that a go, and this is on 6.3, so you might have
different results.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CG/SCWOE
Sent: Tuesday, February 13, 2007 1:13 PM
To: arslist@ARSLIST.ORG
Subject: Limit Number of Items Returned on the Midtier

 

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to
limit the number of items returned when executing a search on the
midtier.  In the client it's an option setting that gets pushed to the
user preferences form.  How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum
number of entries specified for retrieval" (ARWARN 66) when I run my app
in the midtier but I don't get it when running it in the client.

 

Thoughts?

Norm

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Remedy 6.3 Patch 20 ( DST )

[Katherine Hoffner]

I know we have discussed this before but I was wondering if any of you have
seen any new problems loading patch 20 for the DST fix.  I am running the
following:

Remedy 6.3
Oracle 10g
patch 18

Unfortunately I do not have a development server so once I install patch 20
thats it.

--
Katherine

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Question. Why is ' replaced with a ? in a email message

[Dan Caissie]

 

I have a question.

Why is ' as in it's would be replaced by it?s being replaced by a ? in a
text email notification.

Simple right :-)

Thank you,

 

Dan-

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Limit Number of Items Returned on the Midtier

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Hi everyone:

 

Please refresh my memory.  I seem to recall there's a fairly easy way to
limit the number of items returned when executing a search on the midtier.
In the client it's an option setting that gets pushed to the user
preferences form.  How is the same reproduced on the midtier?

 

My application is throwing the "The query matched more that the maximum
number of entries specified for retrieval" (ARWARN 66) when I run my app in
the midtier but I don't get it when running it in the client.

 

Thoughts?

Norm


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Heider, Stephen]

I do something similar here with a separate counter form, except every
## ticket that each technician resolves they get a new "follow up"
ticket auto-created and assigned to them the following morning.  The
tech then has to follow up to make sure everything is still fine.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason
Sent: Tuesday, February 13, 2007 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket


I have thought about something similar but never implement it. 

One option is to set a counter in another form, every time a ticket is
resolved, increment 1 to the counter; your survey email will be trigger
once the counter reaches 100 or any number you set. 


Jason Niu

Sr. Remedy System Engineer

Remedy System & Operation

GETS - Enterprise Systems Management 

Email:[EMAIL PROTECTED]

135 W 50th Street, NYC,NY,10020

212-823-6893.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.  
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly
prohibited. If you are
not the intended recipient, please contact the sender immediately by
reply e-mail
and destroy all copies of the original message. Please note that we do
not accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Anyone tried BMC Remedy User or Admin 7.0 on Windows Vista??

[Sanford, Claire]

We tried it on a test machine and the installer did not recognize the
OS. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Troy Sasso
Sent: Tuesday, February 13, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: Anyone tried BMC Remedy User or Admin 7.0 on Windows Vista??

Looking to see if anyone has braved the client tools
using Windows Vista yet.  I don't see any reference in
the latest version of the compatibility matrix.


Troy




 


Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Automated Data Import

[Tony Worthington]

Or you could use EIE if you wanted to keep it strictly "remedy."


-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



Shafqat Ayaz <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

02/13/2007 12:53 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Automated Data Import






** 
or you could use arimportcmd via an escalation
 
shafqat

"L. J. Head" <[EMAIL PROTECTED]> wrote:
** 
If you would like to use an SQL job to get it done you could create a 
table to put the file into...create a view form to point to that db table 
and then an escalation that fired on the view form to do what you 
need...that is certainly one way you could use to get the data in

From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Tuesday, February 13, 2007 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Automated Data Import

** 
I'm trying to figure out the best way to do a scheduled data import into 
remedy. 
We have a file that we get every week that contains a list of our network 
users and I need to automate getting that data into remedy. We are using 
6.3 with MS SQL on the back end. Would it be easiest to schedule a sql job 
to import that data? I'm not used to getting user data this way. I've 
always had access to everything from AD so I just used Vendor forms to get 
it.
Just looking for some advice. 
- 
Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings & Loan Association, F.A. 
Email: [EMAIL PROTECTED] 
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.


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.
__20060125___This posting was submitted with HTML in 
it___ __20060125___This posting was submitted with 
HTML in it___ 



Shafqat Ayaz

"You really shouldn't say 'I love you' unless you mean it.  But if you 
mean it, you should say it a lot. People forget."
 Access over 1 million songs - Yahoo! Music Unlimited. 
__20060125___This posting was submitted with HTML in 
it___


CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages to or from authorized Kohl's Associates 
at any time
without any further consent.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Jack Samson]

Thank you all!  Appreciate the help.



From: "Tanner, Doug" <[EMAIL PROTECTED]>
Reply-To: arslist@ARSLIST.ORG
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket
Date: Tue, 13 Feb 2007 13:59:54 -0500

Another thought is to keep track of who is sent a survey (what day and
time) then you can also assure that the same person is not sent a survey
too often (be defined by your business rules). I would encourage the use
of a reference form that would allow the variables of Send every X and
also do not send if Survey sent within X number of days.

My favorite Mantra - Remedy Drive it with DATA !


Doug Tanner
Senior Developer
Remedy Skilled Professional (RSP)
(704) 328-3178
[EMAIL PROTECTED]


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason
Sent: Tuesday, February 13, 2007 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket


I have thought about something similar but never implement it.

One option is to set a counter in another form, every time a ticket is
resolved, increment 1 to the counter; your survey email will be trigger
once the counter reaches 100 or any number you set.


Jason Niu

Sr. Remedy System Engineer

Remedy System & Operation

GETS - Enterprise Systems Management

Email:[EMAIL PROTECTED]

135 W 50th Street, NYC,NY,10020

212-823-6893.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page.
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly
prohibited. If you are
not the intended recipient, please contact the sender immediately by
reply e-mail
and destroy all copies of the original message. Please note that we do
not accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

DISCLAIMER Important! This message is intended for the above named 
person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the 
intended recipient of this e-mail and have received it in error, please 
immediately notify the sender by return email and then delete it from your 
mailbox. This message may be protected by the attorney-client privilege 
and/or work product doctrine.  Accessing, copying, disseminating or 
re-using any of the information contained in this e-mail by anyone other 
than the intended recipient is strictly prohibited. Finally, you should 
check this email and any attachments for the presence of viruses, as the 
sender accepts no liability for any damage caused by any virus transmitted 
by this email.  Thank you.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where 
the Answers Are"


_
FREE online classifieds from Windows Live Expo – buy and sell with people 
you know 
http://clk.atdmt.com/MSN/go/msnnkwex001001msn/direct/01/?href=http://expo.live.com?s_cid=Hotmail_tagline_12/06


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

CMDB 1.1 Change Pending

[Sanford, Claire]

I added several fields via the class manager.  When I clicked "Save" I
received an error:  

ARERR [298] Too many filters processed during this operation
OBJSTR:AttributeDefinition


The preceding message occurred during the execution of active link
OBJSTR:ClassDef_SaveChanges -- action 2. (ARNOTE 1101)

This was in my arerror.log

Mon Feb 12 17:32:40 2007  390620 : Too many filters processed during
this operation (ARERR 298)
Mon Feb 12 17:32:40 2007 OBJSTR:AttributeDefinition

So I go to the admin tool and increase the filter value and then hit
save again and everything looked ok.

All of my fields are still showing "Change Pending" and when I look at
the task manager,  the arcmdbd server process is running, and the
dispatcher (arsvcdsp) server process is running on the server.

The only thing in the view log is:

2/12/2007 5:40:48 PM Remedy Application Service
Sync Class: BMC:BMC_AssetBase

2/12/2007 5:40:49 PM Remedy Application Service
ERROR: 120078 The supplied character is not allowed in the name.
W-Parts: '-'


Do I have to recreate all of the fields?

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


Claire Sanford
Information Systems Division
Memorial Hermann Healthcare System
Phone: 713 448 6035
[EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Tanner, Doug]

Another thought is to keep track of who is sent a survey (what day and
time) then you can also assure that the same person is not sent a survey
too often (be defined by your business rules). I would encourage the use
of a reference form that would allow the variables of Send every X and
also do not send if Survey sent within X number of days.

My favorite Mantra - Remedy Drive it with DATA !


Doug Tanner
Senior Developer
Remedy Skilled Professional (RSP)
(704) 328-3178
[EMAIL PROTECTED]


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason
Sent: Tuesday, February 13, 2007 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending HD Surveys on 100th Resolved Ticket


I have thought about something similar but never implement it. 

One option is to set a counter in another form, every time a ticket is
resolved, increment 1 to the counter; your survey email will be trigger
once the counter reaches 100 or any number you set. 


Jason Niu

Sr. Remedy System Engineer

Remedy System & Operation

GETS - Enterprise Systems Management 

Email:[EMAIL PROTECTED]

135 W 50th Street, NYC,NY,10020

212-823-6893.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.  
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly
prohibited. If you are
not the intended recipient, please contact the sender immediately by
reply e-mail
and destroy all copies of the original message. Please note that we do
not accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Niu, Jason]

I have thought about something similar but never implement it. 

One option is to set a counter in another form, every time a ticket is
resolved, increment 1 to the counter; your survey email will be trigger
once the counter reaches 100 or any number you set. 


Jason Niu

Sr. Remedy System Engineer

Remedy System & Operation

GETS - Enterprise Systems Management 

Email:[EMAIL PROTECTED]

135 W 50th Street, NYC,NY,10020

212-823-6893.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.  
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


-
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Automated Data Import

[Shafqat Ayaz]

or you could use arimportcmd via an escalation
   
  shafqat

"L. J. Head" <[EMAIL PROTECTED]> wrote:
  ** If you would like to use an SQL job to get it done you could create a 
table to put the file into...create a view form to point to that db table and 
then an escalation that fired on the view form to do what you need...that is 
certainly one way you could use to get the data in


-
  From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Tuesday, February 13, 2007 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Automated Data Import


  
** I'm trying to figure out the best way to do a scheduled data import into 
remedy. 
We have a file that we get every week that contains a list of our network users 
and I need to automate getting that data into remedy. We are using 6.3 with MS 
SQL on the back end. Would it be easiest to schedule a sql job to import that 
data? I'm not used to getting user data this way. I've always had access to 
everything from AD so I just used Vendor forms to get it.
  Just looking for some advice. 
  - 
  Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings & Loan Association, F.A. 
Email: [EMAIL PROTECTED] 
  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.


  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.
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 


Shafqat Ayaz

  "You really shouldn't say 'I love you' unless you mean it.  But if you mean 
it, you should say it a lot. People forget."






 
-
Access over 1 million songs - Yahoo! Music Unlimited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Automated Data Import

[Howard Richter]

A number of years ago for a project, I had a custom api created that would
run as part of a batch job, to move updated people data at night.

You might want to look at going down that path.

Howard


On 2/13/07, Wheeler, Dylan <[EMAIL PROTECTED]> wrote:


**

I'm trying to figure out the best way to do a scheduled data import into
remedy.
We have a file that we get every week that contains a list of our network
users and I need to automate getting that data into remedy. We are using
6.3 with MS SQL on the back end. Would it be easiest to schedule a sql job
to import that data? I'm not used to getting user data this way. I've always
had access to everything from AD so I just used Vendor forms to get it.

Just looking for some advice.

*-*

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

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.


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.
__20060125___This posting was submitted with HTML in
it___





--
Howard Richter
Remedy ServiceDesk Manager
Red Hat Certified Technician
CompTIA Linux+ Certified
CedarCrestone Managed Services Center
[EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Automated Data Import

[L. J. Head]

If you would like to use an SQL job to get it done you could create a table
to put the file into...create a view form to point to that db table and then
an escalation that fired on the view form to do what you need...that is
certainly one way you could use to get the data in

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Tuesday, February 13, 2007 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Automated Data Import


** 

I'm trying to figure out the best way to do a scheduled data import into
remedy. 
We have a file that we get every week that contains a list of our network
users and I need to automate getting that data into remedy. We are using 6.3
with MS SQL on the back end. Would it be easiest to schedule a sql job to
import that data? I'm not used to getting user data this way. I've always
had access to everything from AD so I just used Vendor forms to get it.

Just looking for some advice. 

- 

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

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.



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.

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Oracle LOB relocation

[Axton]

Slightly OT, but you may want to instruct your dba's to set the oracle
instance parameter 'cursor_sharing' to similar or force.  This will greatly
reduce the size requirements of oracle's shared pool and greatly reduce hard
parses.

This whitepaper covers some of the details:
http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf

My favorite quote from this doc: "Any application that uses all literals
without cursor sharing enabled is not a very scalable application."

Axton Grams
On 2/13/07, Tucker, Rob <[EMAIL PROTECTED]> wrote:


** Thanks Axton. As always, great information

-Rob

 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Axton
*Sent:* Monday, February 12, 2007 5:34 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Oracle LOB relocation


** Manage the log storage through the ardb.conf file.  Don't let the dba
do it directly on the db.  This will cause endless headaches for you and
them.  Probably the best approach would be:

- set up the server
- create the ardb.conf file to define the log storage
- have the dba's manually move the lobs while arserver is stopped
- start arserver

You will more than likely need to experiment with the ardb.conf and some
test forms to make sure you get the syntax right.  Taking this approach (the
best I can see at the moment) has several advantages:
- installer gets to run as it normally would
- dba's feel cozy because they witnessed the relocation of the lobs
- the lobs will be managed on an ongoing basis by the ardb.conf file

Some things to keep in mind:
- you will need to update the ardb.conf every time a new lob is added
(prior to adding the lob); failure to do so will cause the lob to be stored
in the same tablespace as tables/indexes
- the ardb.conf file had some issues in 6.0.1 with length limitations on
the clauses (300 something characters).  I am not sure if this issue exists
in the later releases

Some other things your dba's may want to look into as far as performance
tuning if you go this route (these are possible using the ardb.conf file
as well):
- index storage
- table/index partitioning

Axton Grams

On 2/12/07, Tucker, Rob < [EMAIL PROTECTED]> wrote:
>
> ** We are getting ready to stand up ITSM 7 on Oracle 10G.
>
> My DBA's want to relocated all the lobs in particularly HPD:Help Desk
>
> I grew up with SQL Server and am not:
>
>
>- Sure what it is they are wanting to do
>- Sure that Remedy will allow them to do what they are planning to
>do
>
> Is there anyone out there who would shout "NO!  GO BACK!  DO NOT PASS
> GO!"
>
> or this something perfectly reasonable and doable?
>
> Thanks,
>
> -Rob
>
>
>
> 
> *Rob Tucker *
> *New Edge Networks  ARS Administration and Development* [EMAIL PROTECTED]
>   *  **Vancover,Washington*  tel: 360-759-9670
> fax:360-693-9997
>
>
> __20060125___This posting was submitted with HTML in
> it___


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



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Automated Data Import

[Wheeler, Dylan]

I'm trying to figure out the best way to do a scheduled data import into
remedy.
We have a file that we get every week that contains a list of our
network users and I need to automate getting that data into remedy. We
are using 6.3 with MS SQL on the back end. Would it be easiest to
schedule a sql job to import that data? I'm not used to getting user
data this way. I've always had access to everything from AD so I just
used Vendor forms to get it.
Just looking for some advice.

-

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

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.



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 ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Ronald Greene]

We followed a similar approach; but because all problems were not solve
by the help desk we had to pick more than one two digit ending number.

>>> [EMAIL PROTECTED] 2/13/2007 1:05 PM >>>
Use the modulo '%' operator.  Divide the integer portion of the ticket
# by
100, and if modulo = 0, send it out.

Or, if the ticket number ends in "79" for instance, that would work,
too.

Rick

On 2/13/07, Jack Samson <[EMAIL PROTECTED]> wrote:
>
> All,
>
> I am trying to send a survey out on every 100th resolved helpdesk
ticket.
> Has anyone done this and what would be a good workflow approach to
> building
> this?
>
> Thanks,
>
> Jackson

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"

Confidentiality Notice:
This message is intended exclusively for the individual or entity 
to which it is addressed. This communication may contain 
information that is proprietary, privileged, confidential or 
otherwise legally exempt from disclosure. If you are not the named 
addressee, you are not authorized to read, print, retain, copy or 
disseminate this message or any part of it. If you have received 
this message in error, please notify the sender immediately either 
by phone or reply to this e-mail, and delete all copies of this 
message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Rabi Tripathi]

...what I said in earlier post will generate a survey
for every 100th ticket created (roughly, anyway) when
it is resolved. Call this one formula 1.

Formula 2, if you really want to generate it for every
100th ticket resolved (regardless of when they were
created), you will have to keep track of how many have
been resolved so far [[ keep a counter in a separate
form...or you can query the ticket form to find out
how many have been resolved so far...hmm the second
option here may be problematic, when/if you remove
records and it's an expensive query; probably want to
stay with keeping a counter on another form...sorry I
am thinking as I write ]] and use similar logic.

No matter which way you go formula 1 or 2, the result
will be roughly similar. Just because original formula
#1 is simpler, I would go with it.

Most places, to make sure the same person doesn't get
too many surveys, something is put in place such as...
 make sure the same person doesn't get two surveys
within x amount of time. If the same person happens to
be the next one selected for survey, then you can skip
that person and go with the next ticket. It may not be
an issue for you, because your frequency is rather low
(every 100th, instead of, say every 5th). Depends on
you ticket volume and size of user population too.

--- Jack Samson <[EMAIL PROTECTED]> wrote:

> All,
> 
> I am trying to send a survey out on every 100th
> resolved helpdesk ticket.  
> Has anyone done this and what would be a good
> workflow approach to building 
> this?
> 
> Thanks,
> 
> Jackson
> 
>
_
> Get in the mood for Valentine's Day. View photos,
> recipes and more on your 
> Live.com page. 
>
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701
> 
>
___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the Answers Are"
> 



 

Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Reiser, John J]

Jack,

In order to survey the 100th Resolved ticket you will need to build a
small form that counts every ticket that gets resolved.
When the counter hits 100 that is your ticket number and you send a
survey for it.
This is the general idea. 
HTH,

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 
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson
Sent: Tuesday, February 13, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: Sending HD Surveys on 100th Resolved Ticket

All,

I am trying to send a survey out on every 100th resolved helpdesk
ticket.  
Has anyone done this and what would be a good workflow approach to
building this?

Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on
your Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Rick Cook]

Use the modulo '%' operator.  Divide the integer portion of the ticket # by
100, and if modulo = 0, send it out.

Or, if the ticket number ends in "79" for instance, that would work, too.

Rick

On 2/13/07, Jack Samson <[EMAIL PROTECTED]> wrote:


All,

I am trying to send a survey out on every 100th resolved helpdesk ticket.
Has anyone done this and what would be a good workflow approach to
building
this?

Thanks,

Jackson


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Sending HD Surveys on 100th Resolved Ticket

[Rabi Tripathi]

Jack:
I am not sure how much detail are you looking for, but
if your issue is to figure out how to say in workflow
"every 100th", you could just pick any two digits
("00", or, say, "59") and send the survey to any
ticket with Request ID ending with those two digits,
like so (filter run if):
(rest of the qualification such as "TR.Status" =
"Resolved") AND 'Request ID' like "%00"

--- Jack Samson <[EMAIL PROTECTED]> wrote:

> All,
> 
> I am trying to send a survey out on every 100th
> resolved helpdesk ticket.  
> Has anyone done this and what would be a good
> workflow approach to building 
> this?
> 
> Thanks,
> 
> Jackson
> 
>
_
> Get in the mood for Valentine's Day. View photos,
> recipes and more on your 
> Live.com page. 
>
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701
> 
>
___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the Answers Are"
> 



 

Looking for earth-friendly autos? 
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Sending HD Surveys on 100th Resolved Ticket

[Jack Samson]

All,

I am trying to send a survey out on every 100th resolved helpdesk ticket.  
Has anyone done this and what would be a good workflow approach to building 
this?


Thanks,

Jackson

_
Get in the mood for Valentine's Day. View photos, recipes and more on your 
Live.com page. 
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Michael Worts]

There is a KB entry KM-00020267 which discusses this. You may have 
already read it.

Mike.

Michael Worts
Remedy Specialist
IGS, Business Consulting Services
ITIL Service Manager Certified
Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet: 
[EMAIL PROTECTED]



Axton <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

13/02/2007 17:04
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: What Solaris 9 Environment Variables do you use for AR System 7.x?






** 
If you launch ARSPerl scripts from remedy workflow, your script will core 
dump if you start arserver with the libumem libraries preloaded.  The 
scripts seem to run fine, but during finalization./cleanup, they core 
dump.  Maybe I should have compiled ARSPerl with the libumem preloaded? 
 
You can run arserver with the libumem preloaded; the server memory 
footprint larger (only slightly).  I did not do extensive performance 
testing, so I can't really comment one way or the other as to whether 
there is any benefit in this area.  The debugging capabilities are greatly 
increased for non-root accounts when using libumem though, if you do 
anything in that area. 
 
Axton Grams

 
On 2/13/07, Mike Gould <[EMAIL PROTECTED]> wrote: 
** 
Thank you Axton and Michael.
 
Another question, are either of you using the new LD_PRELOAD=libumem.so 
variable?  If so, do you also need to set the UMEM_DEBUG=default and 
UMEM_LOGGING=transaction variables?  Did you notice any performance gains? 
 We have 16GB of memory on the server, so I'm trying to utilize it as best 
as possible. 
 
Axton, you also mentioned something about doing an unset for UMEM_DEBUG 
and UMEM_LOGGING in a previous post.  Is this just for when doing 
installs?  I'm sometimes seeing segmentation faults/core dump messages 
during the ITSM installs and I think I saw in that same post you indicated 
the libumem.so setting fixes this problem.
 
Thanks again!
 
Michael Gould
US House of Representatives


 
On 2/13/07, Michael Worts <[EMAIL PROTECTED] > wrote: 
** 
We use the following and it works ok. Not tested on ARS 7. 

# Variables for Tomcat - used by Midtier 
export JAVA_HOME=/usr/java14 
export CATALINA_HOME=/usr/local/jakarta- tomcat-5.0.28 

# For Oracle 
export ORACLE_BASE=/opt/oracle 
export ORACLE_HOME=/opt/oracle/product/9.2.0 
export ORACLE_SID= 
export PATH=$PATH:$ORACLE_HOME/bin 

# For Remedy 
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 

Mike. 

OS: AIX 5.2 
DB: Oracle 9.2.0 
Remedy: 6.3 Patch 13 
Web: Tomcat 5.0 

Michael Worts
Remedy Specialist 
IGS, Business Consulting Services
ITIL Service Manager Certified
Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet: 
[EMAIL PROTECTED] 


Axton <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" <
arslist@ARSLIST.ORG> 
13/02/2007 16:14 

Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 
cc

Subject
Re: What Solaris 9 Environment Variables do you use for AR System 7.x?









** 
For Oracle:
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
ORA_NLS
ORACLE_DOC
LD_LIBRARY_PATH
CLASSPATH
ORACLE_TERM
ORACLE_LPPROG
ORACLE_LPSTAT 
ORACLE_PAGER
NLS_LANG
NLS_DATE_FORMAT
TMPDIR
TWO_TASK
LANG
LC_ALL 
For Remedy:
ARLANG 
During Installation, depending on approach:
ARNONROOTINSTALL 
 
I don't know the values for your particular environment.  We use UTF8 with 
all the language packs installed.

Axton Grams

On 2/13/07, Mike Gould <[EMAIL PROTECTED] > wrote: 
** 
Hi Axton, 
 
Sorry, forgot to include those settings.  We will be using English only 
with non-Unicode. 
 
Hope that answers the questions. 
 
Mike


On 2/13/07, Axton < [EMAIL PROTECTED] > wrote: 
** What (remedy) languages will you be using and what is the oracle 
instance character set? 


Axton Grams 

On 2/12/07, Mike Gould < [EMAIL PROTECTED]> wrote: 
** 
Hi List, 
 
I was wondering if anyone would be willing to share the Solaris 9 
environment variables they use on their AR System 7.0.x server?  Also, are 
there any special settings you use just during installation vs. normal 
operations?  I basically know enough about Unix to get myself into 
trouble, so any tips and tricks on the OS side to help with the 
installation, maintenance and performance of our AR server, which you 
could pass along, would be most appreciated. 
 
Thanks in advance, 
Michael J. Gould 
U.S. House of Representatives 
 
OS: Solaris 9 
DB: Oracle 10gR2 
Java: J2SDK 1.4.2_12 
Web: Apache Tomcat (bundled version with Midtier) 
AR System: 7.0.01 (soon to be with Patch 01) 
CMDB: 2.0.01 (soon to be with Patch 02) 
Apps: ITSM 7.0.02 (w/ Patch 03) 
 
 
__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 





Unless stated otherwise above:

Anyone tried BMC Remedy User or Admin 7.0 on Windows Vista??

[Troy Sasso]

Looking to see if anyone has braved the client tools
using Windows Vista yet.  I don't see any reference in
the latest version of the compatibility matrix.


Troy




 

Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Axton]

If you launch ARSPerl scripts from remedy workflow, your script will core
dump if you start arserver with the libumem libraries preloaded.  The
scripts seem to run fine, but during finalization./cleanup, they core dump.
Maybe I should have compiled ARSPerl with the libumem preloaded?

You can run arserver with the libumem preloaded; the server memory footprint
larger (only slightly).  I did not do extensive performance testing, so I
can't really comment one way or the other as to whether there is any benefit
in this area.  The debugging capabilities are greatly increased for non-root
accounts when using libumem though, if you do anything in that area.

Axton Grams


On 2/13/07, Mike Gould <[EMAIL PROTECTED]> wrote:


** Thank you Axton and Michael.

Another question, are either of you using the new 
LD_PRELOAD=libumem.sovariable?  If so, do you also need to set the 
UMEM_DEBUG=default and
UMEM_LOGGING=transaction variables?  Did you notice any performance gains?
We have 16GB of memory on the server, so I'm trying to utilize it as best as
possible.

Axton, you also mentioned something about doing an unset for UMEM_DEBUG
and UMEM_LOGGING in a previous post.  Is this just for when doing installs?
I'm sometimes seeing segmentation faults/core dump messages during the
ITSM installs and I think I saw in that same post you indicated the
libumem.so setting fixes this problem.

Thanks again!

Michael Gould
US House of Representatives



On 2/13/07, Michael Worts <[EMAIL PROTECTED] > wrote:
>
> **
> We use the following and it works ok. Not tested on ARS 7.
>
> # Variables for Tomcat - used by Midtier
> export JAVA_HOME=/usr/java14
> export CATALINA_HOME=/usr/local/jakarta- tomcat-5.0.28
>
> # For Oracle
> export ORACLE_BASE=/opt/oracle
> export ORACLE_HOME=/opt/oracle/product/9.2.0
> export ORACLE_SID=
> export PATH=$PATH:$ORACLE_HOME/bin
>
> # For Remedy
> export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
>
> Mike.
>
> OS: AIX 5.2
> DB: Oracle 9.2.0
> Remedy: 6.3 Patch 13
> Web: Tomcat 5.0
>
> Michael Worts
> Remedy Specialist
> IGS, Business Consulting Services
> ITIL Service Manager Certified
> Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet:
> [EMAIL PROTECTED]
>
>
>   *Axton <[EMAIL PROTECTED]>*
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 13/02/2007 16:14   Please respond to
> arslist@ARSLIST.ORG
>
>To
> arslist@ARSLIST.ORG  cc
>   Subject
> Re: What Solaris 9 Environment Variables do you use for AR System 7.x?
>
>
>
>
> **
>
> For Oracle:
> ORACLE_HOME
> ORACLE_BASE
> ORACLE_SID
> ORA_NLS
> ORACLE_DOC
> LD_LIBRARY_PATH
> CLASSPATH
> ORACLE_TERM
> ORACLE_LPPROG
> ORACLE_LPSTAT
> ORACLE_PAGER
> NLS_LANG
> NLS_DATE_FORMAT
> TMPDIR
> TWO_TASK
> LANG
> LC_ALL
>
> For Remedy:
> ARLANG
>
> During Installation, depending on approach:
> ARNONROOTINSTALL
>
>
> I don't know the values for your particular environment.  We use UTF8
> with all the language packs installed.
>
> Axton Grams
>
> On 2/13/07, *Mike Gould* <[EMAIL PROTECTED] * <[EMAIL PROTECTED]>>
> wrote:
> **
> Hi Axton,
>
> Sorry, forgot to include those settings.  We will be using English only
> with non-Unicode.
>
> Hope that answers the questions.
>
> Mike
>
>
> On 2/13/07, *Axton* < [EMAIL PROTECTED] <[EMAIL PROTECTED]> >
> wrote:
> ** What (remedy) languages will you be using and what is the oracle
> instance character set?
>
>
> Axton Grams
>
> On 2/12/07, *Mike Gould* < [EMAIL PROTECTED] <[EMAIL PROTECTED]>>
> wrote:
> **
> Hi List,
>
> I was wondering if anyone would be willing to share the Solaris 9
> environment variables they use on their AR System 7.0.x server?  Also,
> are there any special settings you use just during installation vs. normal
> operations?  I basically know enough about Unix to get myself into trouble,
> so any tips and tricks on the OS side to help with the installation,
> maintenance and performance of our AR server, which you could pass along,
> would be most appreciated.
>
> Thanks in advance,
> Michael J. Gould
> U.S. House of Representatives
>
> OS: Solaris 9
> DB: Oracle 10gR2
> Java: J2SDK 1.4.2_12
> Web: Apache Tomcat (bundled version with Midtier)
> AR System: 7.0.01 (soon to be with Patch 01)
> CMDB: 2.0.01 (soon to be with Patch 02)
> Apps: ITSM 7.0.02 (w/ Patch 03)
>
>
> __20060125___This posting was submitted with HTML in
> it___
>
> __20060125___This posting was submitted with HTML in
> it___
>
> __20060125___This posting was submitted with HTML in
> it___
>
> __20060125___This posting was submitted with HTML in
> it___
>
>
>
> --
>
> *
> *
>
> *Unless stated otherwise above:
> IBM United Kingdom Limited - Registered in England and Wales with number
> 741598.
> Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6
> 3AU *
>
>
>
>
>
>
> __20060125___This posting was submitted with HTML in
> it___
>
>
__20060125_

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Mike Gould]

Thank you Axton and Michael.

Another question, are either of you using the new
LD_PRELOAD=libumem.sovariable?  If so, do you also need to set the
UMEM_DEBUG=default and
UMEM_LOGGING=transaction variables?  Did you notice any performance gains?
We have 16GB of memory on the server, so I'm trying to utilize it as best as
possible.

Axton, you also mentioned something about doing an unset for UMEM_DEBUG and
UMEM_LOGGING in a previous post.  Is this just for when doing installs?  I'm
sometimes seeing segmentation faults/core dump messages during the ITSM
installs and I think I saw in that same post you indicated the
libumem.sosetting fixes this problem.

Thanks again!

Michael Gould
US House of Representatives



On 2/13/07, Michael Worts <[EMAIL PROTECTED]> wrote:


**
We use the following and it works ok. Not tested on ARS 7.

# Variables for Tomcat - used by Midtier
export JAVA_HOME=/usr/java14
export CATALINA_HOME=/usr/local/jakarta- tomcat-5.0.28

# For Oracle
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2.0
export ORACLE_SID=
export PATH=$PATH:$ORACLE_HOME/bin

# For Remedy
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Mike.

OS: AIX 5.2
DB: Oracle 9.2.0
Remedy: 6.3 Patch 13
Web: Tomcat 5.0

Michael Worts
Remedy Specialist
IGS, Business Consulting Services
ITIL Service Manager Certified
Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet:
[EMAIL PROTECTED]


  *Axton <[EMAIL PROTECTED]>*
Sent by: "Action Request System discussion list(ARSList)" <
arslist@ARSLIST.ORG>

13/02/2007 16:14   Please respond to
arslist@ARSLIST.ORG

   To
arslist@ARSLIST.ORG  cc
  Subject
Re: What Solaris 9 Environment Variables do you use for AR System 7.x?




**

For Oracle:
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
ORA_NLS
ORACLE_DOC
LD_LIBRARY_PATH
CLASSPATH
ORACLE_TERM
ORACLE_LPPROG
ORACLE_LPSTAT
ORACLE_PAGER
NLS_LANG
NLS_DATE_FORMAT
TMPDIR
TWO_TASK
LANG
LC_ALL

For Remedy:
ARLANG

During Installation, depending on approach:
ARNONROOTINSTALL


I don't know the values for your particular environment.  We use UTF8 with
all the language packs installed.

Axton Grams

On 2/13/07, *Mike Gould* <[EMAIL PROTECTED] * <[EMAIL PROTECTED]>> wrote:

**
Hi Axton,

Sorry, forgot to include those settings.  We will be using English only
with non-Unicode.

Hope that answers the questions.

Mike


On 2/13/07, *Axton* < [EMAIL PROTECTED] <[EMAIL PROTECTED]> >
wrote:
** What (remedy) languages will you be using and what is the oracle
instance character set?


Axton Grams

On 2/12/07, *Mike Gould* < [EMAIL PROTECTED] <[EMAIL PROTECTED]>> wrote:

**
Hi List,

I was wondering if anyone would be willing to share the Solaris 9
environment variables they use on their AR System 7.0.x server?  Also, are
there any special settings you use just during installation vs. normal
operations?  I basically know enough about Unix to get myself into trouble,
so any tips and tricks on the OS side to help with the installation,
maintenance and performance of our AR server, which you could pass along,
would be most appreciated.

Thanks in advance,
Michael J. Gould
U.S. House of Representatives

OS: Solaris 9
DB: Oracle 10gR2
Java: J2SDK 1.4.2_12
Web: Apache Tomcat (bundled version with Midtier)
AR System: 7.0.01 (soon to be with Patch 01)
CMDB: 2.0.01 (soon to be with Patch 02)
Apps: ITSM 7.0.02 (w/ Patch 03)


__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___



--

*
*

*Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
*






__20060125___This posting was submitted with HTML in
it___




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Oracle LOB relocation

[Tucker, Rob]

Thanks Axton. As always, great information
 
-Rob



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Monday, February 12, 2007 5:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle LOB relocation


** Manage the log storage through the ardb.conf file.  Don't let the dba
do it directly on the db.  This will cause endless headaches for you and
them.  Probably the best approach would be:

- set up the server
- create the ardb.conf file to define the log storage
- have the dba's manually move the lobs while arserver is stopped
- start arserver

You will more than likely need to experiment with the ardb.conf and some
test forms to make sure you get the syntax right.  Taking this approach
(the best I can see at the moment) has several advantages: 
- installer gets to run as it normally would
- dba's feel cozy because they witnessed the relocation of the lobs
- the lobs will be managed on an ongoing basis by the ardb.conf file

Some things to keep in mind: 
- you will need to update the ardb.conf every time a new lob is added
(prior to adding the lob); failure to do so will cause the lob to be
stored in the same tablespace as tables/indexes
- the ardb.conf file had some issues in 6.0.1 with length limitations on
the clauses (300 something characters).  I am not sure if this issue
exists in the later releases

Some other things your dba's may want to look into as far as performance
tuning if you go this route (these are possible using the ardb.conf file
as well):
- index storage
- table/index partitioning

Axton Grams


On 2/12/07, Tucker, Rob < [EMAIL PROTECTED]
 > wrote: 

** 
We are getting ready to stand up ITSM 7 on Oracle 10G.
 
My DBA's want to relocated all the lobs in particularly HPD:Help
Desk
 
I grew up with SQL Server and am not:
 

*   Sure what it is they are wanting to do 
*   Sure that Remedy will allow them to do what they are
planning to do

Is there anyone out there who would shout "NO!  GO BACK!  DO NOT
PASS GO!"
 
or this something perfectly reasonable and doable?
 
Thanks,
 
-Rob
 

 
 

Rob Tucker 
New Edge Networks  ARS Administration and Development
[EMAIL PROTECTED] 
  Vancover,Washington   
tel: 360-759-9670
fax:360-693-9997
 
 
__20060125___This posting was submitted with
HTML in it___ 


__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

[Easter, David]

> What do they mean when they say  "a resolution is expected until
Odin"?  Ive heard this support talk about various projects like "Thor"
or something...
 
"Thor" was the internal code name for the 7.0.00 release of AR System.
"Odin" is the internal code name for the next release of AR System,
tentatively scheduled for release in mid-2007.
 
-David J. Easter
Sr. Product Manager, Service Management Business Unit
 
BMC Software, Inc.
 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.
Sent: Tuesday, February 13, 2007 6:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: BUG in 7.0.1 patch 001 that is not reported in the Notes


** 
That does not sound good at all!  We are planning to move to 7.01 and we
have numerous email filters that include a hyperlink to the assignee's
ticket.
What do they mean when they say  "a resolution is expected until
Odin"?  Ive heard this support talk about various projects like "Thor"
or something...
 


Thanks 
Peter Lammey 
ESPN MIT Technical Services & Applications Management 
860-766-4761 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly M
Sent: Tuesday, February 13, 2007 7:46 AM
To: arslist@ARSLIST.ORG
Subject: BUG in 7.0.1 patch 001 that is not reported in the Notes


** 

FYI.  I just finished upgrading to 7.0.1 patch 001 and it breaks the URL
link on filter notifications.  It is not on the support web.  If you use
this - as we do - you will need to do the workaround.

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax

-Original Message-
From: BMC Customer Support [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:42 AM
To: Olds, Kimberly M
Subject: Re: (ISS03069335, 2-High)

Hello Kim

This is what I received from the team -lead on the web team:

"Two AR Server defects have been submitted around this problem:

 

ARS 7.0.1 FCS and Patch 1 - filter notifications do not add a value for
"eid=" in Web URL shortcuts, resulting in:

http:///arsys/servlet/ViewFormServlet?form=&server=&eid=NULL

SW00258844, SW00256255

 

These are not yet escalated by Server team(s), so a resolution isn't
expected until Odin.  As a workaround, a customer can add workflow to
generate their own URLs in a character field and include that field as
part of the notification."

 

Thanks,

-Ibrahim Akar

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Michael Worts]

We use the following and it works ok. Not tested on ARS 7.

# Variables for Tomcat - used by Midtier
export JAVA_HOME=/usr/java14
export CATALINA_HOME=/usr/local/jakarta-tomcat-5.0.28

# For Oracle
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2.0
export ORACLE_SID=
export PATH=$PATH:$ORACLE_HOME/bin

# For Remedy
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Mike.

OS: AIX 5.2
DB: Oracle 9.2.0
Remedy: 6.3 Patch 13
Web: Tomcat 5.0 

Michael Worts
Remedy Specialist
IGS, Business Consulting Services
ITIL Service Manager Certified
Tel: +44 (0)1962 822273   Mob: +44 (0)7801 755346   Internet: 
[EMAIL PROTECTED]



Axton <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

13/02/2007 16:14
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: What Solaris 9 Environment Variables do you use for AR System 7.x?






** 
For Oracle:
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
ORA_NLS
ORACLE_DOC
LD_LIBRARY_PATH
CLASSPATH
ORACLE_TERM
ORACLE_LPPROG
ORACLE_LPSTAT
ORACLE_PAGER
NLS_LANG
NLS_DATE_FORMAT
TMPDIR
TWO_TASK
LANG
LC_ALL
For Remedy:
ARLANG
During Installation, depending on approach:
ARNONROOTINSTALL
 
I don't know the values for your particular environment.  We use UTF8 with 
all the language packs installed.
 
Axton Grams
 
On 2/13/07, Mike Gould <[EMAIL PROTECTED]> wrote: 
** 
Hi Axton,
 
Sorry, forgot to include those settings.  We will be using English only 
with non-Unicode.
 
Hope that answers the questions.
 
Mike

 
On 2/13/07, Axton <[EMAIL PROTECTED] > wrote: 
** What (remedy) languages will you be using and what is the oracle 
instance character set? 


Axton Grams 

On 2/12/07, Mike Gould < [EMAIL PROTECTED]> wrote: 
** 
Hi List,
 
I was wondering if anyone would be willing to share the Solaris 9 
environment variables they use on their AR System 7.0.x server?  Also, are 
there any special settings you use just during installation vs. normal 
operations?  I basically know enough about Unix to get myself into 
trouble, so any tips and tricks on the OS side to help with the 
installation, maintenance and performance of our AR server, which you 
could pass along, would be most appreciated. 
 
Thanks in advance,
Michael J. Gould
U.S. House of Representatives
 
OS: Solaris 9
DB: Oracle 10gR2
Java: J2SDK 1.4.2_12
Web: Apache Tomcat (bundled version with Midtier)
AR System: 7.0.01 (soon to be with Patch 01)
CMDB: 2.0.01 (soon to be with Patch 02)
Apps: ITSM 7.0.02 (w/ Patch 03)
 
 
__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 

__20060125___This posting was submitted with HTML in 
it___ 






Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: What Solaris 9 Environment Variables do you use for AR System 7.x?

[Axton]

For Oracle:
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
ORA_NLS
ORACLE_DOC
LD_LIBRARY_PATH
CLASSPATH
ORACLE_TERM
ORACLE_LPPROG
ORACLE_LPSTAT
ORACLE_PAGER
NLS_LANG
NLS_DATE_FORMAT
TMPDIR
TWO_TASK
LANG
LC_ALL

For Remedy:
ARLANG

During Installation, depending on approach:
ARNONROOTINSTALL

I don't know the values for your particular environment.  We use UTF8 with
all the language packs installed.

Axton Grams

On 2/13/07, Mike Gould <[EMAIL PROTECTED]> wrote:


** Hi Axton,

Sorry, forgot to include those settings.  We will be using English only
with non-Unicode.

Hope that answers the questions.

Mike


On 2/13/07, Axton <[EMAIL PROTECTED]> wrote:
>
> ** What (remedy) languages will you be using and what is the oracle
> instance character set?
>
> Axton Grams
>
> On 2/12/07, Mike Gould < [EMAIL PROTECTED]> wrote:
> >
> > ** Hi List,
> >
> > I was wondering if anyone would be willing to share the Solaris 9
> > environment variables they use on their AR System 7.0.x server?  Also,
> > are there any special settings you use just during installation vs. normal
> > operations?  I basically know enough about Unix to get myself into trouble,
> > so any tips and tricks on the OS side to help with the installation,
> > maintenance and performance of our AR server, which you could pass
> > along, would be most appreciated.
> >
> > Thanks in advance,
> > Michael J. Gould
> > U.S. House of Representatives
> >
> > OS: Solaris 9
> > DB: Oracle 10gR2
> > Java: J2SDK 1.4.2_12
> > Web: Apache Tomcat (bundled version with Midtier)
> > AR System: 7.0.01 (soon to be with Patch 01)
> > CMDB: 2.0.01 (soon to be with Patch 02)
> > Apps: ITSM 7.0.02 (w/ Patch 03)
> >
> >
> > __20060125___This posting was submitted with HTML
> > in it___
>
>
> __20060125___This posting was submitted with HTML in
> it___
>

__20060125___This posting was submitted with HTML in
it___



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

[Olds, Kimberly M]

Tell me about it!  I had to track them all down and manually add the URL
with the Case ID in the test for the email.  

 

I also got this:

 

There are two bug records submitted and our engineers are giving it the
highest priority. 

 

SW00258844 and SW00256255

 

They told me that I would be notified when it was corrected.  So we
shall see.

 

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.
Sent: Tuesday, February 13, 2007 9:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

 

That does not sound good at all!  We are planning to move to 7.01 and we
have numerous email filters that include a hyperlink to the assignee's
ticket.

What do they mean when they say  "a resolution is expected until
Odin"?  Ive heard this support talk about various projects like "Thor"
or something...

 

 

Thanks 
Peter Lammey 
ESPN MIT Technical Services & Applications Management 
860-766-4761 

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly M
Sent: Tuesday, February 13, 2007 7:46 AM
To: arslist@ARSLIST.ORG
Subject: BUG in 7.0.1 patch 001 that is not reported in the Notes

** 

FYI.  I just finished upgrading to 7.0.1 patch 001 and it breaks the URL
link on filter notifications.  It is not on the support web.  If you use
this - as we do - you will need to do the workaround.

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax

-Original Message-
From: BMC Customer Support [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:42 AM
To: Olds, Kimberly M
Subject: Re: (ISS03069335, 2-High)

Hello Kim

This is what I received from the team -lead on the web team:

"Two AR Server defects have been submitted around this problem:

 

ARS 7.0.1 FCS and Patch 1 - filter notifications do not add a value for
"eid=" in Web URL shortcuts, resulting in:

http:///arsys/servlet/ViewFormServlet?form=&server=&eid=NULL

SW00258844, SW00256255

 

These are not yet escalated by Server team(s), so a resolution isn't
expected until Odin.  As a workaround, a customer can add workflow to
generate their own URLs in a character field and include that field as
part of the notification."

 

Thanks,

-Ibrahim Akar

__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Why not to change Status values?

[Misi Mladoniczky]

Hi,

If you still have to do the change, I would suggest a path like this:
1. Use i.e. ARInside to find workflow references to your Status-field
2. Check Macros and Crystal-Reports that reference the field and actually
make use of the value.
3. Use i.e. rrrSelectionChange to convert your old data to the new layout,
includeing Status-History

Downloads:
ARInside: http://system.devdor.net/
rrrSelectionChange: https://www.rrr.se/cgi/tools/main#rrrSelectionChange

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

> Your own reasons probably coincide with the reasons of most here on the
> list.  That is, since the valuses are really only labels for integer
> data in the database, changing those values compromises any workflow
> that is dependent on an actuall value ('Status' = "Pending").
>
>
> --
>
> Chris Danaceau
> 703-833-2459
>
> The electronic mail message you have received and any files transmitted
> with it are confidential and solely for the intended addressee(s)'s
> attention. Do not divulge, copy, forward, or use the contents,
> attachments, or information without permission of Fannie Mae.
> Information contained in this message is provided solely for the purpose
> stated in the message or its attachment(s) and must not be disclosed to
> any third party or used for any other purpose without consent of Fannie
> Mae. If you have received this message and/or any files transmitted with
> it in error, please delete them from your system, destroy any hard
> copies of them, and contact the sender.
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley
> Sent: Wednesday, February 07, 2007 10:18 AM
> To: arslist@ARSLIST.ORG
> Subject: Why not to change Status values?
>
> I have a few "important" users who are suggesting that my organization
> should change our status values.  Does anyone know of some compelling
> documentation that say why not to do this?  I have many reasons of my
> own such as the workflow, records, and updating issues this would cause,
> but I was looking for something "official" if it exists.
>
> Thanks
>
> Kyle
>
> --
> Kyle Whitley
> IT System Support Professional
> Office of Information and Instructional Technology (OIIT) Board of
> Regents of the University System of Georgia
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Why not to change Status values?

[danaceau, Christopher M]

Your own reasons probably coincide with the reasons of most here on the
list.  That is, since the valuses are really only labels for integer
data in the database, changing those values compromises any workflow
that is dependent on an actuall value ('Status' = "Pending").   


-- 

Chris Danaceau
703-833-2459

The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted with
it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender. 



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley
Sent: Wednesday, February 07, 2007 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Why not to change Status values?

I have a few "important" users who are suggesting that my organization
should change our status values.  Does anyone know of some compelling
documentation that say why not to do this?  I have many reasons of my
own such as the workflow, records, and updating issues this would cause,
but I was looking for something "official" if it exists.

Thanks

Kyle

--
Kyle Whitley
IT System Support Professional
Office of Information and Instructional Technology (OIIT) Board of
Regents of the University System of Georgia


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: IVR & Remedy

[Ross Talbot]

We have integrated IVR and Remedy with Customer Interaction Center.

http://www.teamadapt.com/

- Ross



Den Fong <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

02/13/2007 09:04 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: IVR & Remedy






** 
We don't have an IVR yet, we are looking at this as a solution to for one 
of our projects.  Was this a third party product or in house code?
 
Thx
 
Den

>>> "Soria, Joe" <[EMAIL PROTECTED]> 2/12/2007 5:00 PM >>>
Den,

What IVR system are you using? We are currently communicating back and 
forth between our IVR system and Remedy. It was very easy to setup.

Joe


-Original Message-
From:Action Request System discussion list(ARSList) on behalf of Den Fong
Sent:Mon 2/12/2007 4:32 PM
To:arslist@ARSLIST.ORG
Cc:
Subject:IVR & Remedy

Has anyone integrated IVR technology, (interactive voice recognition)? 
We are looking at this for one of our projects and are looking at costs,
feasibility etc...

Thanks

Den

ARS 6.3 patch 20  (by end of month).



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where 
the Answers Are"




_ 
__
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where 
the Answers Are"
__20060125___This posting was submitted with HTML in 
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: IVR & Remedy

[Den Fong]

We don't have an IVR yet, we are looking at this as a solution to for
one of our projects.  Was this a third party product or in house code?
 
Thx
 
Den

>>> "Soria, Joe" <[EMAIL PROTECTED]> 2/12/2007 5:00 PM >>>
Den,

What IVR system are you using? We are currently communicating back and
forth between our IVR system and Remedy. It was very easy to setup.

Joe


-Original Message-
From:Action Request System discussion list(ARSList) on behalf of Den
Fong
Sent:Mon 2/12/2007 4:32 PM
To:arslist@ARSLIST.ORG 
Cc:
Subject:IVR & Remedy

Has anyone integrated IVR technology, (interactive voice recognition)?

We are looking at this for one of our projects and are looking at
costs,
feasibility etc...

Thanks

Den

ARS 6.3 patch 20  (by end of month).



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Mailto Links Not Opening Right

[Kaiser Norm E CIV USAF 96 CG/SCWOE]

Hi all:

 

This is probably a version bug, too-I'm still running 5.1.2 server and
midtier-but I was hoping against hope that maybe someone out there has seen
this and knows of a fix.

 

I have an active link that does a simple run process:
PERFORM-ACTION-OPEN-URL mailto:[EMAIL PROTECTED] 
.  It works perfectly in the client; however, in the midtier, it opens a new
browser window and for some bizarre reason chooses to precede the mailto
link with http.  So the midtier tries to open
http://mailto:[EMAIL PROTECTED]  , which
causes the browser to open and attempt to open such a website, which of
course doesn't exist, so I get the page cannot be displayed error.

 

Does anyone know of a way to make the midtier not precede the mailto address
with http://?

 

Thanks,

Norm


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: BUG in 7.0.1 patch 001 that is not reported in the Notes

[Lammey, Peter A.]

That does not sound good at all!  We are planning to move to 7.01 and we
have numerous email filters that include a hyperlink to the assignee's
ticket.
What do they mean when they say  "a resolution is expected until
Odin"?  Ive heard this support talk about various projects like "Thor"
or something...
 


Thanks 
Peter Lammey 
ESPN MIT Technical Services & Applications Management 
860-766-4761 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly M
Sent: Tuesday, February 13, 2007 7:46 AM
To: arslist@ARSLIST.ORG
Subject: BUG in 7.0.1 patch 001 that is not reported in the Notes


** 

FYI.  I just finished upgrading to 7.0.1 patch 001 and it breaks the URL
link on filter notifications.  It is not on the support web.  If you use
this - as we do - you will need to do the workaround.

Kim Olds

Anne Arundel County Public Schools - Help Desk

410-222-5254

410-222-5611 fax

-Original Message-
From: BMC Customer Support [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:42 AM
To: Olds, Kimberly M
Subject: Re: (ISS03069335, 2-High)

Hello Kim

This is what I received from the team -lead on the web team:

"Two AR Server defects have been submitted around this problem:

 

ARS 7.0.1 FCS and Patch 1 - filter notifications do not add a value for
"eid=" in Web URL shortcuts, resulting in:

http:///arsys/servlet/ViewFormServlet?form=&server=&eid=NULL

SW00258844, SW00256255

 

These are not yet escalated by Server team(s), so a resolution isn't
expected until Odin.  As a workaround, a customer can add workflow to
generate their own URLs in a character field and include that field as
part of the notification."

 

Thanks,

-Ibrahim Akar

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: SQL Log analyzer of SQL log timer (Performance tools)

[Troy Sasso]

Axton, great help.

Always a pleasure to hear from you.

Thanks,


Troy


--- Axton <[EMAIL PROTECTED]> wrote:

> The is a utility in the dev community of the
> BMC/Remedy Community downloads
> that does this.  It returns all sql from an
> arsql.log that take > a
> specified time to complete.
> 
> Axton Grams
> 
> 
> On 2/12/07, Troy Sasso <[EMAIL PROTECTED]> wrote:
> >
> > Hello all,
> >
> > Is there freeware out there that will analyze MS
> SQL
> > transaction logs or Remedy SQL logs to help
> identify
> > bad queries and improve performance?
> >
> >
> > Troy
> >
> >
> >
> >
> >
> >
> >
>

> > Any questions? Get answers on any topic at
> www.Answers.yahoo.com.  Try it
> > now.
> >
> >
> >
>
___
> > UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where
> > the Answers Are"
> >
> 
>
___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the Answers Are"
> 





 

The fish are biting. 
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: SQL Log analyzer of SQL log timer (Performance tools)

[Troy Sasso]

Thanks Matt, always great to hear from you.


Troy
--- Matt Reinfeldt <[EMAIL PROTECTED]> wrote:

> It's called ARLogAnalyzer. :-) great tool.
> 
>  
> 
> Matt
> 
>  
> 
>   _  
> 
> From: Axton [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 12, 2007 11:28 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: SQL Log analyzer of SQL log timer
> (Performance tools)
> 
>  
> 
> ** 
> 
> The is a utility in the dev community of the
> BMC/Remedy Community downloads
> that does this.  It returns all sql from an
> arsql.log that take > a
> specified time to complete.
> 
>  
> 
> Axton Grams
> 
>  
> 
> On 2/12/07, Troy Sasso <[EMAIL PROTECTED]> wrote: 
> 
> Hello all,
> 
> Is there freeware out there that will analyze MS SQL
> transaction logs or Remedy SQL logs to help identify
> 
> bad queries and improve performance?
> 
> 
> Troy
> 
> 
> 
> 
> 
>

> 
> Any questions? Get answers on any topic at
> www.Answers.yahoo.com.  Try it
> now.
> 
>

> ___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the
> Answers Are"
> 
> 
> __20060125___This posting was
> submitted with HTML in
> it___ 
> 
> 
>
___
> UNSUBSCRIBE or access ARSlist Archives at
> www.arslist.org ARSlist:"Where the Answers Are"
> 





 

Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

BUG in 7.0.1 patch 001 that is not reported in the Notes

[Olds, Kimberly M]

FYI.  I just finished upgrading to 7.0.1 patch 001 and it breaks the URL
link on filter notifications.  It is not on the support web.  If you use
this - as we do - you will need to do the workaround.

Kim Olds
Anne Arundel County Public Schools - Help Desk
410-222-5254
410-222-5611 fax

-Original Message-
From: BMC Customer Support [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 12, 2007 11:42 AM
To: Olds, Kimberly M
Subject: Re: (ISS03069335, 2-High)

Hello Kim

This is what I received from the team -lead on the web team:

"Two AR Server defects have been submitted around this problem:
 
ARS 7.0.1 FCS and Patch 1 - filter notifications do not add a value for
"eid=" in Web URL shortcuts, resulting in:
http:///arsys/servlet/ViewFormServlet?form=&server=&eid=NULL
SW00258844, SW00256255
 
These are not yet escalated by Server team(s), so a resolution isn't
expected until Odin.  As a workaround, a customer can add workflow to
generate their own URLs in a character field and include that field as
part of the notification."
 
Thanks,

-Ibrahim Akar

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

PKI Authentication - Windows User/Admin Tools

[Rebecca Hammond]

Has anyone been able to set up PKI Authentication for users who access the
system (ARS 7.01) using the Windows Clients (User/Admin)?

 

We know we can configure our Web Server to do our PKI (Certificate)
authentication for us, then customize the .properties file, etc, to set up
SSO (using the new 7.x documentation for this).  Our plan is to handle all
of the Web authentication outside of ARS, and assume if the user made it
past the Web Server (BEA WebLogic)'s Certificate checks, the user is ok.  We
just authorize based on the User dn= we get from the header.

 

Where we're having issues now is in terms of having "strong" authentication
for users on the Windows clients.  We have users who will need access to the
system that way (because the Web, no matter "how much better" the 7.x
Mid-Tier "is" aka "is supposed to be"), not to mention our Admins who will
need to use the Admin tool.  IT Security is telling us that anyone with
Admin access must use "Strong Authentication", or in other words, PKI.  LDAP
Authentication just isn't going to cut it with them.

 

Any thoughts?

 

Sincerely,


Rebecca Hammond 

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: ARERR (302) Entry does not exist in database dilemma

[Michiel Beijen]

Hi Christopher,

You've run into a limitation by Remedy. I've had a ticket open on this but
got it back with 'as designed'.

If you would create a join A which uses an outer join B as one of its base
forms, and one of the base forms for outer join B has no record in it, and
you retrieve this record in Join A, you will get the error message 302. In
my opinion this is a system defect.

For instance, if you would have the Remedy Asset Management application, an
asset can have a user assigned, and an asset can have an owner assigned. You
can create nice join forms on this

UserOuterJoin: Form A: AST_Asset, Form B: AST_AssetPeople; where
asset_entry_id = entry_id and role = "User"
OwnerOuterJoin: Form A: AST_Asset, Form B: AST_AssetPeople; where
asset_entry_id = entry_id and role = "Owner"
Both these outer joins would work great and return all assets, with optional
linked users (or owners) if there are any.

Now if you'd want to run one report on all your assets with their Users AND
their Owners, in theory you could build an inner join C on the UserOuterJoin
and the OwnerOuterJoin. If you would do that, you'd get error message 302 on
all assets that do not have related users OR owners.

Now this example is a bit clunky but I guess you can see the problem here.

The good news is that I did find a workaround for this: I ended up creating
joins with the correct data as much as possible. For joining the data from
the different joins, I've added display only fields on the join form and
populated these using filters on GetEntry. Not an ideal solution but at
least it worked.

Good luck,

Michiel


On 2/12/07, Pruitt, Christopher J <[EMAIL PROTECTED]> wrote:


**

I have a question that has now stumped several DBAs and Remedy Developers
now and was hoping someone on this list may have a answer.

We have a Join that is nested with other joins, however, when we perform a
query via the Remedy User tool it returns an "ARERR (302) Entry does not
exist in database".

To make matters worse, on the User Tool it returns 792 records of which
60% display this error and the remaining 40% do not and before anyone says
there are missing records. We have 3 primary data forms included in these
joins and all of them have the corrected and needed data in them.

Now here is the issue. When we perform the same query at the Oracle level
it returns all the records correctly.

This is the query that is run from the Remedy User Tool (when I turn on
SQL and API logging).
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 =
'EBL-590' ) ORDER BY 1 ASC

It returns no record
However, when I modify the query based on the structure of our Join it
returns the record.
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-0001025' and E1 = 'LOC5915' and E2 IS NULL and E3 IS NULL
and E4 = 'EBL-590' ) ORDER BY 1 ASC

E0 and E1 are from the Tele_Location_Join and E2 and E3 should be from the
Location RecType_Join and E4 should be from the Load Data Form, however,
what is happening via the User Tool is E0 and E1 are from the
Tele_Location_Join and E2 and E3 should be from the Location RecType_Join
and it never includes the E4 and the E3 value should be the E4 value and E3
should be null

This is our Join Structure:
Reporting_Form_Join

   An outer join of:
   - Charge_Join (Primary)
  - Load Data Form (Secondary)

   Charge_Join

  An outer join of:**
  - Tele_Location_Join form (Primary)

 An inner join of:
 - Tele Data form (Primary)
- Location Data form (Secondary)
 - Location RecType_Join (Secondary)

 An inner join of:
 - Location Data form (Primary)
- Location Data form (Secondary)


Our environment is:
AR System: 6.03 patch 15
Remedy User Tool: 6.03 patch 15
Oracle 9i - ver 9.2.0.6.0

*Christopher Pruitt *
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
Phone: +1-972-605-7702 (8-835)
mailto:HYPERLINK "mailto:[EMAIL PROTECTED]"***
[EMAIL PROTECTED] 

*Confidentiality Notice:* This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged, and
exempt from disclosure under applicable law. If you are not the intended
addressee for this e-mail, you are hereby notified that any copying,
distribution, or dissemination of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately destroy, erase, or
discard this message. Please notify the sender immediately by return e-mail
if you have received this e-mail by mistake.

__20060125___This posting was submitted with HTML in
it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"