SQL and IF Statements in AIE

2009-08-13 Thread Frank Caruso
I made a few postings about having issues using the IF and SQL
statements in field mappings within AIE. Although I appeared to be
using valid syntax in my class mappings, AIE would not process those
statements. No errors were shown in the logs. After a bunch of emails
back and forth with BMC I was able to figure out the issue and felt it
was worth posting to the list.

These type of statements must contain spaces between all
fields\variables. A statement such as:

STMT|IF $Index0$=0 THEN VALUE=1000 ELSE VALUE=5000 ENDIF

will not work but the following will:

STMT|IF $Index0$ = 0 THEN VALUE = 1000 ELSE VALUE = 5000 ENDIF

The same with an SQL statement:

sql|select column from table where column=$column$

will not work but:

sql|select column from table where column = $column$

does work.


Frank

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Have I misunderstood something? [Vendor forms and DataType.Attachment]

2009-08-13 Thread Jonas Stumph Stevnsvig
HI listers,

I have this nagging problem. I just read through this plugin one of my 
colleagues has writtenm since it keeps inserting thousand seperators in integer 
values, which makes it impossible to use the value for a further lookup.
eg 861002000 becomes 861.002.000 - now to the fun stuff:

The field in the database is an integer.
The field is regarded as a decimal in remedy.
The API only formats fields of type Datatype.ATTACHMENT as %s.%s.%s

and finally, my questions:

1. I thought Remedy disallowed attachemnt fields in vendor forms?
2. why is the integer interpreted as an attachment?
3. how can remedy justify allowing multiple decimal points in a decimal field?


(ARS 7.5 patch 2, W2k3, MSSQL, vendor form connects to DB2 DB)

I hope someone can help me spread some light on this subject.


with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC Competence Centre
Phone  (+45) 46 38 20 08
Mobile  (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk
becrem...@bec.dk

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


SLA's firing at same time --Please Help

2009-08-13 Thread nsachin
Hi All,

I have configured two resolution SLA's for 75% and 100% milestones for a
support group.I have checked the  workflow of notification engine which
sends these notifications to Case Assignees/Assignee Groups.The workflow is
correct as the time difference between 75% milestones notifications and 100%
notifications to case assginees is showing the configured time in
NTE:Notifier Log form.

But,the problem is that email for these notfications for 75% and 100% are
sent at the same time to support person.

Please help on this.

Regards,
Sachin
-- 
View this message in context: 
http://www.nabble.com/SLA%27s-firing-at-same-time---Please-Help-tp24951106p24951106.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


SV: Have I misunderstood something? [Vendor forms and DataType.Attachment]

2009-08-13 Thread Jonas Stumph Stevnsvig
Hi again

It turns out that it was a regional setting in windows, which was in turn 
formatting the number in the field with the set digit separator...




with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC Competence Centre
Phone  (+45) 46 38 20 08
Mobile  (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk
becrem...@bec.dk




Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
Sendt: 13. august 2009 10:00
Til: arslist@ARSLIST.ORG
Emne: Have I misunderstood something? [Vendor forms and DataType.Attachment]

**
HI listers,

I have this nagging problem. I just read through this plugin one of my 
colleagues has writtenm since it keeps inserting thousand seperators in integer 
values, which makes it impossible to use the value for a further lookup.
eg 861002000 becomes 861.002.000 - now to the fun stuff:

The field in the database is an integer.
The field is regarded as a decimal in remedy.
The API only formats fields of type Datatype.ATTACHMENT as %s.%s.%s

and finally, my questions:

1. I thought Remedy disallowed attachemnt fields in vendor forms?
2. why is the integer interpreted as an attachment?
3. how can remedy justify allowing multiple decimal points in a decimal field?


(ARS 7.5 patch 2, W2k3, MSSQL, vendor form connects to DB2 DB)

I hope someone can help me spread some light on this subject.


with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC Competence Centre
Phone  (+45) 46 38 20 08
Mobile  (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk
becrem...@bec.dk

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: SQL and IF Statements in AIE

2009-08-13 Thread Matt Worsdell
Thanks for the post Frank. I do quick a bit of this and have had some head
scratch moments!!

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: 13 August 2009 07:11
To: arslist@ARSLIST.ORG
Subject: SQL and IF Statements in AIE

I made a few postings about having issues using the IF and SQL
statements in field mappings within AIE. Although I appeared to be
using valid syntax in my class mappings, AIE would not process those
statements. No errors were shown in the logs. After a bunch of emails
back and forth with BMC I was able to figure out the issue and felt it
was worth posting to the list.

These type of statements must contain spaces between all
fields\variables. A statement such as:

STMT|IF $Index0$=0 THEN VALUE=1000 ELSE VALUE=5000 ENDIF

will not work but the following will:

STMT|IF $Index0$ = 0 THEN VALUE = 1000 ELSE VALUE = 5000 ENDIF

The same with an SQL statement:

sql|select column from table where column=$column$

will not work but:

sql|select column from table where column = $column$

does work.


Frank


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


SOLVED: Re: Reconciliation - Identification Stage

2009-08-13 Thread Frank Caruso
Everything is working fine now that I have auto identified the GOLD copy.

Thank you for you help.

On Wed, Aug 12, 2009 at 8:15 PM, Lyle Taylortayl...@ldschurch.org wrote:
 I see.  In that case, you'll need to pick one dataset that you will 
 auto-identify instances in.  You don't have to auto-identify all of them, if 
 you don't want to, but then you will need to find a way to filter the ones 
 you do want to identify that doesn't depend on the contents of another 
 dataset, or simply auto-identify them all, if you think they all will 
 eventually go into Gold.  Once you have auto-identified items in that dataset 
 (which will give them a recon ID other than zero), you can then identify the 
 items in that dataset with other datasets, applying that same recon ID to the 
 instances in the other datasets.  Then you can merge them all into Gold.

 Lyle

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
 Sent: Wednesday, August 12, 2009 12:52 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Reconciliation - Identification Stage

 I guess my issue is that I do not have a GOLD set yet. I have many
 different sources for data that will become the GOLD set but need to
 first identify and then merge them.

 On Tue, Aug 11, 2009 at 8:02 PM, Lyle Taylortayl...@ldschurch.org wrote:
 Items can only be matched between datasets where the item in the master 
 dataset already has a reconciliation ID.  So, if the ID is zero in both 
 datasets, the items will never match.  The usual process is that you will 
 auto-identify the records (or some portion of them based on criteria that 
 you set in a qualification group) in the master dataset, and then you will 
 run an identification activity with the other dataset to see which items in 
 the second dataset match the items that you have already identified in the 
 first dataset.

 If neither of the datasets that you are talking about is the gold dataset 
 (BMC.ASSET), it would be good to first run an identification activity 
 between gold and one or both of the secondary datasets.  That way, you match 
 up any discovery items that already match gold.  Then you can auto-identify 
 items in one of the secondary datasets to identify new items that will 
 eventually get merged into gold.  Then, lastly, you can run an 
 identification activity between the two secondary datasets to find all items 
 that match between them, and merge the final results into gold if you want.

 Does that make sense?

 Lyle

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
 Sent: Tuesday, August 11, 2009 3:35 AM
 To: arslist@ARSLIST.ORG
 Subject: Reconciliation - Identification Stage

 ARS 7.1p5
 SQL Server 2005
 CMDB 2.1 p4

 Have two datasets that were created from two different discovery
 sources. Each has several BMC Computer records. The reconciliation ID
 in both is set to 0 as neither has never been reconciled with another
 source.
 I created an identification activity to compare the two datasets
 matching on the Name. I set one of the datasets as the master in the
 activity. When I run the activity the second data set (non master)
 records gets assigned reconciliation IDs but the master dataset
 records do not.  It is my understanding that the identification
 activity would match records in the two datasets and give them the
 same reconciliation id. If I then take the identification job and
 reverse the roles of each dataset and rerun the job the records on
 both sides will get reconciliation ids that match.

 So it looks like you can do this sort of comparison but only when one
 dataset already has been reconciled?

 Does this make sense or am I missing something.

 TIA

 Frank

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


  NOTICE: This email message is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information. Any unauthorized 
 review, use, disclosure or distribution is prohibited. If you are not the 
 intended recipient, please contact the sender by reply email and destroy all 
 copies of the original message.

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

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

Alternate Approval notification

2009-08-13 Thread John Kelley
Has any setup a notification to the alternate approver if the approval 
hasn't been attended to in 24 hours. 

How and where can I configure that.

Thanks JK


*
This e-mail message, including any attachments, is for the sole use of the 
addressee(s) to whom it has been sent, and may contain information that is 
confidential or legally protected.  If you are not the intended recipient or 
have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments.  Please notify 
the sender immediately by return e-mail and permanently delete this message and 
any attachments.  Dunkin' Brands Inc. makes no warranty that this e-mail is 
error or virus free.


ARIMPORTCMD Problem with accentuation

2009-08-13 Thread Hellyson
I have a problem when I try to import some data with accentuation using
arimporcmd command at the MS-DOS

Here, in Brazil, we use accentuation  (^,~,´, etc) in some words, when i try
to import a csv file, in the arimport.log displays the correct data, but in
the arsql.log displays the wrong data.

Example:
Log of Import
 Marcão;5/7 - 11/7/2009;SextaAusência;;;

Log of SQL:
SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC

I did the test on my machine, development server and approval server.

Operation System: Windows
DB: Microsoft SQL Server 2003
ARS Server Version: 7.1.00 Patch 002



Hellyson
helly...@gmail.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


WWRug09

2009-08-13 Thread Linda J Blomberg
I am in the process of signing up for the Rug conference this year, but am 
unable to get to the Hard Rock Hotel web site to book a room.  Does anyone know 
what the room rate is?

Thanks,
Linda
Fermi National Accelerator Laboratory
blomb...@fnal.gov

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: WWRug09

2009-08-13 Thread Wallace, Kelvin
http://www.hardrockhotel.com/

 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Linda J Blomberg
Sent: Thursday, August 13, 2009 11:12 AM
To: arslist@ARSLIST.ORG
Subject: WWRug09

 

I am in the process of signing up for the Rug conference this year, but
am unable to get to the Hard Rock Hotel web site to book a room.  Does
anyone know what the room rate is?

 

Thanks,

Linda

Fermi National Accelerator Laboratory

blomb...@fnal.gov 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: ARERR 1651 Incorrect Format In The Definition File

2009-08-13 Thread Tony Worthington
I get that sometimes.  I find a restart of arserver usually fixes the 
issue.  I have not had the time to troubleshoot or work with support.

ARS 7.1p2

Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI  53051 | office: (262) 
703-7763 | e-mail: tony.worthing...@kohls.com



From:
manoj jain manoj.jain4...@gmail.com
To:
arslist@ARSLIST.ORG
Date:
08/12/2009 12:40 AM
Subject:
ARERR 1651 Incorrect Format In The Definition File
Sent by:
Action Request System discussion list(ARSList) arslist@ARSLIST.ORG



** 
Hi Remedians,
 
I got one error message Incorrect Format In The Definition File.
What could be the reason  solution of this.
Please guide me.
 
 
Thanks  Regards,
Manoj Jain
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Keeping track of Open forms.

2009-08-13 Thread LJ Longwing
hmmmYou could try using a global field...every time that form is opened,
incrementevery time one is closed, decrement, and send some sort of
warning when the window count gets above a threshold?

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Thursday, August 13, 2009 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Keeping track of Open forms.


** 

Hello Listers,

 

ARS 7.1 Patch4

MS SSQL 2005

MS OS 2003 SP 2 Enterprise

 

We are looking for a way to assist our Call Center operators in managing
multiple Helpdesk Forms.

They have a telephone system that displays a popup identifying the name of
the Heldpesk that the customer is contacting.

The vendor assures us that the telephone tool can send keystroke commands to
a running app (ARUser) and retrieve the proper Helpdesk Form.

 

This would result in the same search or new window opening up each time a
call for Helpdesk A came in. The problem get compounded by Helpdesk B, C and
D. Soon we will have E  F.

 

Has anyone dealt with a method to keep track of the open windows in the WUT
and manage them so we don't open 99 windows in one working session?

I was thinking of using a Close Window Active Link firing on After Submit
but that may confuse and frustrate the Operators when the window disappears
and there is no Request ID feedback.

 

Thanks,

 

--- 
John J. Reiser 
Senior 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 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: WWRug09

2009-08-13 Thread Daniel Bloom
you should be able to get to it via www.wwrug.com
and the accomodations link.
However if you have pop ups block perhaps it blocked the new window from
opening?
 
Here is the URL
https://resweb.passkey.com/Resweb.do?mode=welcome_ei_new
https://resweb.passkey.com/Resweb.do?mode=welcome_ei_neweventID=1406279
eventID=1406279
 
If you go straight to the hotel you won't get the $79.00/night (plus taxes
etc)
I negotiated.
 
 Daniel

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Wallace, Kelvin
Sent: August 13, 2009 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: WWRug09


** 

http://www.hardrockhotel.com/

 

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Linda J Blomberg
Sent: Thursday, August 13, 2009 11:12 AM
To: arslist@ARSLIST.ORG
Subject: WWRug09

 

I am in the process of signing up for the Rug conference this year, but am
unable to get to the Hard Rock Hotel web site to book a room.  Does anyone
know what the room rate is?

 

Thanks,

Linda

Fermi National Accelerator Laboratory

blomb...@fnal.gov 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Keeping track of Open forms.

2009-08-13 Thread Jason Miller
Would it be at all possible to create a single front end form and/or console
that would push/pull from the correct Help Desk form based on some field
selections?

Do you have Mid-Tier?  Another idea would be to create a DO form with a
large view field and then you could load the URL to the correct Help Desk
form in the view field based on some field(s) on the DO form.

Jason

On Thu, Aug 13, 2009 at 9:24 AM, Reiser, John J john.j.rei...@lmco.comwrote:

 **

 Hello Listers,



 ARS 7.1 Patch4

 MS SSQL 2005

 MS OS 2003 SP 2 Enterprise



 We are looking for a way to assist our Call Center operators in managing
 multiple Helpdesk Forms.

 They have a telephone system that displays a popup identifying the name of
 the Heldpesk that the customer is contacting.

 The vendor assures us that the telephone tool can send keystroke commands
 to a running app (ARUser) and retrieve the proper Helpdesk Form.



 This would result in the same search or new window opening up each time a
 call for Helpdesk A came in. The problem get compounded by Helpdesk B, C and
 D. Soon we will have E  F.



 Has anyone dealt with a method to keep track of the open windows in the WUT
 and manage them so we don’t open 99 windows in one working session?

 I was thinking of using a Close Window Active Link firing on “After Submit”
 but that may confuse and frustrate the Operators when the window disappears
 and there is no Request ID feedback.



 Thanks,



 ---
 John J. Reiser
 Senior 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


  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Keeping track of Open forms.

2009-08-13 Thread Reiser, John J
Could that be an Event active link type of workflow?

Maybe sent an Event value After Submit and then Close the window with
Event Done when I open a new Window?

I'll have to look into this.

Thanks for the spark.

 

--- 
John J. Reiser 
Senior 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 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Thursday, August 13, 2009 12:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Keeping track of Open forms.

 

hmmmYou could try using a global field...every time that form is
opened, incrementevery time one is closed, decrement, and send some
sort of warning when the window count gets above a threshold?

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Thursday, August 13, 2009 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Keeping track of Open forms.

** 

Hello Listers,

 

ARS 7.1 Patch4

MS SSQL 2005

MS OS 2003 SP 2 Enterprise

 

We are looking for a way to assist our Call Center operators in managing
multiple Helpdesk Forms.

They have a telephone system that displays a popup identifying the name
of the Heldpesk that the customer is contacting.

The vendor assures us that the telephone tool can send keystroke
commands to a running app (ARUser) and retrieve the proper Helpdesk
Form.

 

This would result in the same search or new window opening up each time
a call for Helpdesk A came in. The problem get compounded by Helpdesk B,
C and D. Soon we will have E  F.

 

Has anyone dealt with a method to keep track of the open windows in the
WUT and manage them so we don't open 99 windows in one working session?

I was thinking of using a Close Window Active Link firing on After
Submit but that may confuse and frustrate the Operators when the window
disappears and there is no Request ID feedback.

 

Thanks,

 

--- 
John J. Reiser 
Senior 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 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


AW: ARIMPORTCMD Problem with accentuation

2009-08-13 Thread Conny Martin
it looks like your csv file is UTF-8 encoded. But arimportcmd is expecting a 
file encoded in your native codepage. (CP1252)
 
Try to open the file in notepad and in the Save As Dialog choose ANSI 
encoding and save the file.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Hellyson
Gesendet: Donnerstag, 13. August 2009 17:06
An: arslist@ARSLIST.ORG
Betreff: ARIMPORTCMD Problem with accentuation


** I have a problem when I try to import some data with accentuation using 
arimporcmd command at the MS-DOS

Here, in Brazil, we use accentuation  (^,~,´, etc) in some words, when i try to 
import a csv file, in the arimport.log displays the correct data, but in the 
arsql.log displays the wrong data.

Example:
Log of Import
 Marcão;5/7 - 11/7/2009;SextaAusência;;;

Log of SQL:
SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC

I did the test on my machine, development server and approval server.

Operation System: Windows
DB: Microsoft SQL Server 2003
ARS Server Version: 7.1.00 Patch 002



Hellyson
helly...@gmail.com
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 


Re: Keeping track of Open forms.

2009-08-13 Thread Reiser, John J
I thought about that but the customized forms are so different that a
unified input process is not applicable, though we would like to work
towards that type of solution.

 

I'm not crazy about working a Midtier app through a view field in the
WUT. Seems like the long way around to accomplish what should be simple.

 Hey BMC, Why can't the Target Location in an open window action work
for the WUT as it does for Midtier?

Current only opens the form in the same window if you use a browser. New
works for Wut and the browser.

 

--- 
John J. Reiser 
Senior 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 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jason Miller
Sent: Thursday, August 13, 2009 1:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: Keeping track of Open forms.

 

** Would it be at all possible to create a single front end form and/or
console that would push/pull from the correct Help Desk form based on
some field selections?

Do you have Mid-Tier?  Another idea would be to create a DO form with a
large view field and then you could load the URL to the correct Help
Desk form in the view field based on some field(s) on the DO form.

Jason

On Thu, Aug 13, 2009 at 9:24 AM, Reiser, John J john.j.rei...@lmco.com
wrote:

** 

Hello Listers,

 

ARS 7.1 Patch4

MS SSQL 2005

MS OS 2003 SP 2 Enterprise

 

We are looking for a way to assist our Call Center operators in managing
multiple Helpdesk Forms.

They have a telephone system that displays a popup identifying the name
of the Heldpesk that the customer is contacting.

The vendor assures us that the telephone tool can send keystroke
commands to a running app (ARUser) and retrieve the proper Helpdesk
Form.

 

This would result in the same search or new window opening up each time
a call for Helpdesk A came in. The problem get compounded by Helpdesk B,
C and D. Soon we will have E  F.

 

Has anyone dealt with a method to keep track of the open windows in the
WUT and manage them so we don't open 99 windows in one working session?

I was thinking of using a Close Window Active Link firing on After
Submit but that may confuse and frustrate the Operators when the window
disappears and there is no Request ID feedback.

 

Thanks,

 

--- 
John J. Reiser 
Senior 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 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Keeping track of Open forms.

2009-08-13 Thread LJ Longwing
I think that would only work if you had another window open to send the
event to...which you may have...:)

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Thursday, August 13, 2009 11:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Keeping track of Open forms.


** 

Could that be an Event active link type of workflow?

Maybe sent an Event value After Submit and then Close the window with Event
Done when I open a new Window?

I'll have to look into this.

Thanks for the spark.

 

--- 
John J. Reiser 
Senior 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 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Thursday, August 13, 2009 12:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Keeping track of Open forms.

 

hmmmYou could try using a global field...every time that form is opened,
incrementevery time one is closed, decrement, and send some sort of
warning when the window count gets above a threshold?

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Thursday, August 13, 2009 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Keeping track of Open forms.

** 

Hello Listers,

 

ARS 7.1 Patch4

MS SSQL 2005

MS OS 2003 SP 2 Enterprise

 

We are looking for a way to assist our Call Center operators in managing
multiple Helpdesk Forms.

They have a telephone system that displays a popup identifying the name of
the Heldpesk that the customer is contacting.

The vendor assures us that the telephone tool can send keystroke commands to
a running app (ARUser) and retrieve the proper Helpdesk Form.

 

This would result in the same search or new window opening up each time a
call for Helpdesk A came in. The problem get compounded by Helpdesk B, C and
D. Soon we will have E  F.

 

Has anyone dealt with a method to keep track of the open windows in the WUT
and manage them so we don't open 99 windows in one working session?

I was thinking of using a Close Window Active Link firing on After Submit
but that may confuse and frustrate the Operators when the window disappears
and there is no Request ID feedback.

 

Thanks,

 

--- 
John J. Reiser 
Senior 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 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Mid Tier Authentication Error ARERR 9388

2009-08-13 Thread Raj
Hello All,
I tried all the steps , changed the application service password and
mid tier password to same one.
Didn't work out.
I mentioned Authentication Server as AR System Server password.
Also the other servers namely Ar system Server , Preference Server,
Data Visualization Server
and Homepage Server , I mentioned AR System Server for all these.

Don't know why I am unable to make the Mid tier work ? Must be doing
something wrong.
Will dig in more and update in here.

Any other sugestions are welcome.

Thank you ,
Raj
On Aug 12, 11:10 pm, Rosemary rjing...@gmail.com wrote:
 I've noticed after installing mid-tier 7.1 that it doesn't automatically
 specify the Authentication Server on the General Settings tab in the Mid
 Tier Configuration webpage. You haven't mentioned that in your original
 post, so you might want to double-check.

 Regards,
 Rosemary





 On Thu, Aug 13, 2009 at 1:03 PM, Raj ravi6...@gmail.com wrote:
  Thank you Joe for your reply.

  I am using IIS(6.0) with TOMCAT(5.5).
  I used the user name Demo but now DEMO, Sorry for typing mistake
  earlier during posting.

  Also without using port number 8080 , i am getting the login page.
  Previously I used to usehttp://midtierserver name : 8080/arsys
  but with that i am getting page cannot be displayed page.

  so I removed the 8080 and i was able to get mid tier login page.

  Also i changed password to a common one. But I will cross check what
  you mentioned:
  If this is not your case (which I do not think it would be as you can
  see the login page if you are attempting your logon), check the AR Mid-
  Tier Application Password. Make sure that it is the same as that what
  is configured in the ar.conf / ar.cfg file via the AR Server
  Configuration.
  but I am pretty sure i changed the ar midtier appln password , and it
  is same in the ar.conf file.

  I will check tomorrow and update in here.

  Thank you for your reply. Really appreciate it.

  On Aug 12, 7:41 pm, Joe DeSouza joe_rem...@yahoo.com wrote:
   Raj,

   First of all it would be nice to know what web server you are using. If
  you are using IIS, then http://mid-tier-server-name/arsys would be
  enough..

   If you are using any other server other than IIS, the default port is not
  80 which is assumed by the http protocol. For eg, it is 8080 for Tomcat,
  8090 for Websphere so in those two cases your URL would turn out to be
  http://mid-tier-server-name:8080/arsys or 
  http://mid-tier-server-name:8090/arsys respectively
  if the default ports were used for these web servers.

   If this is not your case (which I do not think it would be as you can see
  the login page if you are attempting your logon), check the AR Mid-Tier
  Application Password. Make sure that it is the same as that what is
  configured in the ar.conf / ar.cfg file via the AR Server Configuration.

   Lastly, if you are using that default admin user to login, then I thought
  you should know that the user names and passwords in Remedy are case
  sensitive irrespective to whether the database is case sensitive or not.. So
  it will not be DEMO but Demo unless you have modified the login name in the
  User form to be DEMO instead of Demo..

   Cheers

   Joe

   
   From: Raj ravi6...@gmail.com
   To: arsl...@arslist.org
   Sent: Wednesday, August 12, 2009 7:44:16 PM
   Subject: Mid Tier Authentication Error ARERR 9388

   Hello All,
   After the fresh installation of mid tier, I addedhttp://midtierserver
  name/arsys in default webpath under advanced tab in server information form
  through user tool and also added ar system server name under all the options
  available in mid tier configuration tool ie. Ar system Server , Preference
  Server, Data Visualization Server and Homepage Server.

   Still getting an AUTHENTICATION ERROR ARERR 9388 when i am trying to
  login through DEMO.

   Please advise.

   Thanks,
   Raj

  ___­
   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum 
   Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
Where the Answers Are

  ___­
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum 
  Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
   Where the Answers Are

 ___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are- 
 Hide quoted text -

 - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Mid Tier Authentication Error ARERR 9388

2009-08-13 Thread Raj
Sorry typing error
Typo : I mentioned Authentication Server as AR System Server password.

I mentioned Authentication Server name as AR System Server name.

On Aug 13, 11:55 am, Raj ravi6...@gmail.com wrote:
 Hello All,
 I tried all the steps , changed the application service password and
 mid tier password to same one.
 Didn't work out.
 I mentioned Authentication Server as AR System Server password.
 Also the other servers namely Ar system Server , Preference Server,
 Data Visualization Server
 and Homepage Server , I mentioned AR System Server for all these.

 Don't know why I am unable to make the Mid tier work ? Must be doing
 something wrong.
 Will dig in more and update in here.

 Any other sugestions are welcome.

 Thank you ,
 Raj
 On Aug 12, 11:10 pm, Rosemary rjing...@gmail.com wrote:





  I've noticed after installing mid-tier 7.1 that it doesn't automatically
  specify the Authentication Server on the General Settings tab in the Mid
  Tier Configuration webpage. You haven't mentioned that in your original
  post, so you might want to double-check.

  Regards,
  Rosemary

  On Thu, Aug 13, 2009 at 1:03 PM, Raj ravi6...@gmail.com wrote:
   Thank you Joe for your reply.

   I am using IIS(6.0) with TOMCAT(5.5).
   I used the user name Demo but now DEMO, Sorry for typing mistake
   earlier during posting.

   Also without using port number 8080 , i am getting the login page.
   Previously I used to usehttp://midtierservername : 8080/arsys
   but with that i am getting page cannot be displayed page.

   so I removed the 8080 and i was able to get mid tier login page.

   Also i changed password to a common one. But I will cross check what
   you mentioned:
   If this is not your case (which I do not think it would be as you can
   see the login page if you are attempting your logon), check the AR Mid-
   Tier Application Password. Make sure that it is the same as that what
   is configured in the ar.conf / ar.cfg file via the AR Server
   Configuration.
   but I am pretty sure i changed the ar midtier appln password , and it
   is same in the ar.conf file.

   I will check tomorrow and update in here.

   Thank you for your reply. Really appreciate it.

   On Aug 12, 7:41 pm, Joe DeSouza joe_rem...@yahoo.com wrote:
Raj,

First of all it would be nice to know what web server you are using. If
   you are using IIS, then http://mid-tier-server-name/arsys would be
   enough..

If you are using any other server other than IIS, the default port is 
not
   80 which is assumed by the http protocol. For eg, it is 8080 for Tomcat,
   8090 for Websphere so in those two cases your URL would turn out to be
   http://mid-tier-server-name:8080/arsys or 
   http://mid-tier-server-name:8090/arsys respectively
   if the default ports were used for these web servers.

If this is not your case (which I do not think it would be as you can 
see
   the login page if you are attempting your logon), check the AR Mid-Tier
   Application Password. Make sure that it is the same as that what is
   configured in the ar.conf / ar.cfg file via the AR Server Configuration.

Lastly, if you are using that default admin user to login, then I 
thought
   you should know that the user names and passwords in Remedy are case
   sensitive irrespective to whether the database is case sensitive or not.. 
   So
   it will not be DEMO but Demo unless you have modified the login name in 
   the
   User form to be DEMO instead of Demo..

Cheers

Joe


From: Raj ravi6...@gmail.com
To: arsl...@arslist.org
Sent: Wednesday, August 12, 2009 7:44:16 PM
Subject: Mid Tier Authentication Error ARERR 9388

Hello All,
After the fresh installation of mid tier, I addedhttp://midtierserver
   name/arsys in default webpath under advanced tab in server information 
   form
   through user tool and also added ar system server name under all the 
   options
   available in mid tier configuration tool ie. Ar system Server , Preference
   Server, Data Visualization Server and Homepage Server.

Still getting an AUTHENTICATION ERROR ARERR 9388 when i am trying to
   login through DEMO.

Please advise.

Thanks,
Raj

   ___­­
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
Platinum 
Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
 Where the Answers Are

   ___­­
   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
    Platinum 
   Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
Where the Answers Are

  ___­­
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers 

Re: Keeping track of Open forms.

2009-08-13 Thread Mueller, Doug
John,

From your message, I am guessing that what you are trying to accomplish is the 
following (note that I have
simplified the situation to 2 forms just to get the concept across and then you 
can expand it to 3 or 5 or 50
as you need).

You have 2 different forms.  One for logging groceries and one for handling 
automotive maintenance
scheduling.  You have customers that call in and they may ask about either 
groceries or about auto
maintenance.  What you want is for your staff to have 0, 1, or 2 windows open  
(there may be others but of
the windows related to this topic).  They may have no window for either open.  
Or, they may have a grocery
window open but no auto maintenance (or vice versa) or they may have both open.

When, a new call comes in, what you want to happen is for the system to 
determine whether it is a grocery
or auto maintenance issue and if it is grocery, if there is no grocery window 
open, open one and open the
ticket in that window.  If however there is already a grocery window open, then 
open the new ticket within the
existing grocery window and don't open a new window.

(we will ignore the case of whether you are working a grocery ticket in the 
grocery window when the new call
comes in so that the new call will overlay the existing window.)

(we will also ignore the issue of the fact that you are not opening a NEW 
window in that window but are
really resetting a window to the new value -- UNLESS what you do is to close 
the existing window of that
type and open a new one in the correct mode or what you are doing is having a 
submit window of each type
and you just fill it in and hit submit and the new one just prepares for a new 
submit and initializes the data
to be ready for the next submit)


Anyway, a technique to accomplish what this is talking about is the following:

1) For each type of window that you want to have one uniquely opened, create a 
global variable.

2) Whenever a window of that type is opened, assign $WINDOWID$ (or whatever the 
keyword that is the
window identifier) to this global variable.  This field will be cleared 
(set to $NULL$) On Close of this
window.

Now, you have a global variable that is available to anyone who wants that 
holds the handle of the widow
so you can refer to that window.

3) Create a form that has EVERY global from EVERY window type on it that you 
will use as your landing
pad from the outside.  It will also have fields that are the ones that are 
to be passed from the outside.

Define a format for serializing the data passed in to every type of window 
or define gobals to hold data or
some way to get data passed between windows.

4) When a new call comes in and you determine the type of either groceries or 
auto maintenance, gather the
data that is appropriate (if any) for that type and then call AR to open 
the form you created in #3 passing
data and the type of the call.

5) The form will have workflow the runs on Loaded (because the data you are 
passing in needs to arrive) that
will then take the type of window, check the appropriate global field.  If 
it is NULL, there is no window of
that type open and you can use an Open Window action to open it and pass 
the data.  If it is NOT NULL,
you have the window ID of the window that is open and you can send a signal 
to that window either
passing the data you want passed or having it put into globals so that the 
window can pick it up from
them (using them as registers).   Each of the types of forms -- groceries 
and auto maintenance in this
case -- would have active links firing on event that would prepare the 
screen, parse data from the data
passed or get from the global registers into the appropriate fields and you 
are good to go.

You have just accomplished either opening a window if not available or 
sending data to the existing
window if it is available.


6) You have workflow at execution order 999 on the form in #3 that does a Close 
Window action so that the
window for #3 never really actually opens.

7) Obviously, you just add more globals and more directions to pass the data if 
you later add on pool
reservations and lunch ordering and 10 other divergent forms.


Hopefully, this gives you a picture of a possibility if you wanted to pursue it 
for the type of situation you are
encountering (assuming I interpreted your situation and what you want to 
accomplish correctly).  Anyway,
this is an example of how to achieve the type of interaction like this.

I hope this is an interesting discussion of ways to use the features of the 
system at least and maybe gives
some ideas.

Doug Mueller


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Reiser, John J
Sent: Thursday, August 13, 2009 10:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Keeping track of Open forms.

**
I thought about that but the customized forms 

Re: Alternate Approval notification

2009-08-13 Thread John Kelley
Thanks Bryan

The alternate gets the email now after a certain amount of time.  But is 
there a way to change the approval to show in the Alternates Approval 
Central queue. 
Or does the alternate still have to go in and Act as alternate.  Is that 
how it is designed. 


Thanks Again
JK







Bryan Waters bryancwat...@gmail.com 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
08/13/2009 11:40 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Alternate Approval notification






** 
Hello John,
 
Open the approval process definition screen, use the Signature Escalations 
tab to setup a ?friendly? reminder.

 
Also, make sure to create the following 2 notifications for your approval 
process.

 
Thanks,
Bryan Waters
 
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Kelley
Sent: Thursday, August 13, 2009 10:13 AM
To: arslist@ARSLIST.ORG
Subject: Alternate Approval notification
 

Has any setup a notification to the alternate approver if the approval 
hasn't been attended to in 24 hours.   

How and where can I configure that. 

Thanks JK 

*
This e-mail message, including any attachments, is for the sole use of the 
addressee(s) to whom it has been sent, and may contain information that is 
confidential or legally protected.  If you are not the intended recipient 
or have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments.  Please 
notify the sender immediately by return e-mail and permanently delete this 
message and any attachments.  Dunkin' Brands Inc. makes no warranty that 
this e-mail is error or virus free.
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_ 


*
This e-mail message, including any attachments, is for the sole use of the 
addressee(s) to whom it has been sent, and may contain information that is 
confidential or legally protected.  If you are not the intended recipient or 
have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments.  Please notify 
the sender immediately by return e-mail and permanently delete this message and 
any attachments.  Dunkin' Brands Inc. makes no warranty that this e-mail is 
error or virus free.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Alternate Approval notification

2009-08-13 Thread Chou, David
Hi John,

Depending on the version of Approval Server you are using. In Approval Server 
7.5.00, the alternate approver will see the approval request in the Pending 
Approvals list from the Approval Central, prior to version 7.5.00, the 
alternate needs to do Act as alternate.

Thanks,
David Chou

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Kelley
Sent: Thursday, August 13, 2009 11:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Alternate Approval notification

**
Thanks Bryan

The alternate gets the email now after a certain amount of time.  But is there 
a way to change the approval to show in the Alternates Approval Central queue.
Or does the alternate still have to go in and Act as alternate.  Is that how 
it is designed.


Thanks Again
JK





Bryan Waters bryancwat...@gmail.com
Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

08/13/2009 11:40 AM
Please respond to
arslist@ARSLIST.ORG


To

arslist@ARSLIST.ORG

cc

Subject

Re: Alternate Approval notification







**
Hello John,

Open the approval process definition screen, use the Signature Escalations tab 
to setup a friendly reminder.


Also, make sure to create the following 2 notifications for your approval 
process.


Thanks,
Bryan Waters

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Kelley
Sent: Thursday, August 13, 2009 10:13 AM
To: arslist@ARSLIST.ORG
Subject: Alternate Approval notification


Has any setup a notification to the alternate approver if the approval hasn't 
been attended to in 24 hours.

How and where can I configure that.

Thanks JK
*
This e-mail message, including any attachments, is for the sole use of the 
addressee(s) to whom it has been sent, and may contain information that is 
confidential or legally protected.  If you are not the intended recipient or 
have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments.  Please notify 
the sender immediately by return e-mail and permanently delete this message and 
any attachments.  Dunkin' Brands Inc. makes no warranty that this e-mail is 
error or virus free.




_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_

*

This e-mail message, including any attachments, is for the sole use of the 
addressee(s) to whom it has been sent, and may contain information that is 
confidential or legally protected.  If you are not the intended recipient or 
have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments.  Please notify 
the sender immediately by return e-mail and permanently delete this message and 
any attachments.  Dunkin' Brands Inc. makes no warranty that this e-mail is 
error or virus free.


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


[no subject]

2009-08-13 Thread Arner, Todd
Hello Everyone,
We have been getting two error in the AREmail stderr.log. (see sample
below of errors)  This has been happening for some time now.  The errors
occur every 30 min.  We have not any trouble with the email engine
functioning, mail is going out fine.  I had checked with our support
several months back but they could not determine the cause.  Since it is
still occurring, I thought I'd check with the list to see if anyone else
has experienced this or has suggestions on how to fix.

SQL 2005
ARS 7.1 patch 4
Email engine 7.1 patch 4
JRE 1.6.0_04

Sample Log

Aug 13, 2009 2:13:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
SEVERE: Data types are not appropriate for relational operation 
Aug 13, 2009 2:13:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
SEVERE: Field ID is not related to this form 6
Aug 13, 2009 2:43:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
SEVERE: Data types are not appropriate for relational operation 
Aug 13, 2009 2:43:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
SEVERE: Field ID is not related to this form 6


Thanks,
Todd Arner

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Recurring AREmail Errors

2009-08-13 Thread Arner, Todd
 Hello Everyone,
 We have been getting two error in the AREmail stderr.log. (see sample
 below of errors)  This has been happening for some time now.  The
 errors occur every 30 min.  We have not any trouble with the email
 engine functioning, mail is going out fine.  I had checked with our
 support several months back but they could not determine the cause.
 Since it is still occurring, I thought I'd check with the list to see
 if anyone else has experienced this or has suggestions on how to fix.
 
 SQL 2005
 ARS 7.1 patch 4
 Email engine 7.1 patch 4
 JRE 1.6.0_04
 
 Sample Log
 
 Aug 13, 2009 2:13:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
 SEVERE: Data types are not appropriate for relational operation 
 Aug 13, 2009 2:13:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
 SEVERE: Field ID is not related to this form 6
 Aug 13, 2009 2:43:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
 SEVERE: Data types are not appropriate for relational operation 
 Aug 13, 2009 2:43:04 PM com.bmc.arsys.emaildaemon.LoggingModule doWork
 SEVERE: Field ID is not related to this form 6
 
 
 Thanks,
 Todd Arner

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Wolfram Alpha (Caution: nerd alert!)

2009-08-13 Thread Thad K Esser
The other day I was reading about Wolfram Alpha
(http://www.wolframalpha.com) and one of the things you can use it for is
to compute truth tables.  Naturally, I immediately thought about how that
could be used for ARS development and evaluating Run-If qualifications.

It seems you can actually only get a truth table if you only have 3 or
fewer clauses:
(A  B) || C  --  http://www.wolframalpha.com/input/?i=%28A+%26%26+B%29
+%7C%7C+C

The Venn diagram is a neat way to visualize your qualification.
(A || (B  C))  !D  --  http://www.wolframalpha.com/input/?i=%28A
+%7C%7C+%28B+%26%26+C%29%29+%26%26+%21D

And some other cool stuff.  Anyway, it was something I was playing with so
I thought I'd share.

Thad Esser
Remedy Developer
Now... Just where did I put that cheese...?


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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Form looks stretched or not displaying properly

2009-08-13 Thread Jason Tricky
I ended up rebuilding the PC.  Thanks for those who replied. 
 
Thanks,
Jason

--- On Wed, 8/12/09, Rosemary rjing...@gmail.com wrote:


From: Rosemary rjing...@gmail.com
Subject: Re: Form looks stretched or not displaying properly
To: arslist@ARSLIST.ORG
Date: Wednesday, August 12, 2009, 4:43 PM


** 
You might also want to try deleting the form cache on the users PC. Usually 
located under ARSystem/Home folder - you'll find a bunch of subfolders with 
names corresponding to the forms the user has viewed.
 
Regards,
Rosemary


On Thu, Aug 13, 2009 at 9:10 AM, Shyam Attavar atta...@sbcglobal.net wrote:

Jason,

Check the users' display properties -- settings -- advanced button and on
the general tab, the fonts
are set to Normal size (96 DPI). Many times this has been the cause of the
forms being stretched out.

HTH,
--
Shyam

Jason Tricky trickyma...@yahoo.com wrote in message
news:818379.83098...@web45011.mail.sp1.yahoo.com...

I have a user that when he logs in to Remedy using User tool(7.1 patch 007)
he would need to use the scroll on the bottom to see the whole form.  But if
the user login to another PC with the same version of the user tool, the
display looks normal and can see the whole form without scrolling.  It seems
like the user tool on his machine is messed up... I have uninstalled the
user tool and reinstalled it but the display is still messed up.  Is there a
setting somewhere where I can fix this?  Please help thanks.
 
Jason



--

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



Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Mid Tier Authentication Error ARERR 9388

2009-08-13 Thread Raj
Resolved.

Windows Firewall was on.

Turned it off and it worked.
Thank you everybody for the help.

Raj

On Aug 13, 11:58 am, Raj ravi6...@gmail.com wrote:
 Sorry typing error
 Typo : I mentioned Authentication Server as AR System Server password.

 I mentioned Authentication Server name as AR System Server name.

 On Aug 13, 11:55 am, Raj ravi6...@gmail.com wrote:





  Hello All,
  I tried all the steps , changed the application service password and
  mid tier password to same one.
  Didn't work out.
  I mentioned Authentication Server as AR System Server password.
  Also the other servers namely Ar system Server , Preference Server,
  Data Visualization Server
  and Homepage Server , I mentioned AR System Server for all these.

  Don't know why I am unable to make the Mid tier work ? Must be doing
  something wrong.
  Will dig in more and update in here.

  Any other sugestions are welcome.

  Thank you ,
  Raj
  On Aug 12, 11:10 pm, Rosemary rjing...@gmail.com wrote:

   I've noticed after installing mid-tier 7.1 that it doesn't automatically
   specify the Authentication Server on the General Settings tab in the Mid
   Tier Configuration webpage. You haven't mentioned that in your original
   post, so you might want to double-check.

   Regards,
   Rosemary

   On Thu, Aug 13, 2009 at 1:03 PM, Raj ravi6...@gmail.com wrote:
Thank you Joe for your reply.

I am using IIS(6.0) with TOMCAT(5.5).
I used the user name Demo but now DEMO, Sorry for typing mistake
earlier during posting.

Also without using port number 8080 , i am getting the login page.
Previously I used to usehttp://midtierservername: 8080/arsys
but with that i am getting page cannot be displayed page.

so I removed the 8080 and i was able to get mid tier login page.

Also i changed password to a common one. But I will cross check what
you mentioned:
If this is not your case (which I do not think it would be as you can
see the login page if you are attempting your logon), check the AR Mid-
Tier Application Password. Make sure that it is the same as that what
is configured in the ar.conf / ar.cfg file via the AR Server
Configuration.
but I am pretty sure i changed the ar midtier appln password , and it
is same in the ar.conf file.

I will check tomorrow and update in here.

Thank you for your reply. Really appreciate it.

On Aug 12, 7:41 pm, Joe DeSouza joe_rem...@yahoo.com wrote:
 Raj,

 First of all it would be nice to know what web server you are using. 
 If
you are using IIS, then http://mid-tier-server-name/arsys would be
enough..

 If you are using any other server other than IIS, the default port is 
 not
80 which is assumed by the http protocol. For eg, it is 8080 for Tomcat,
8090 for Websphere so in those two cases your URL would turn out to be
http://mid-tier-server-name:8080/arsys or 
http://mid-tier-server-name:8090/arsys respectively
if the default ports were used for these web servers.

 If this is not your case (which I do not think it would be as you can 
 see
the login page if you are attempting your logon), check the AR Mid-Tier
Application Password. Make sure that it is the same as that what is
configured in the ar.conf / ar.cfg file via the AR Server Configuration.

 Lastly, if you are using that default admin user to login, then I 
 thought
you should know that the user names and passwords in Remedy are case
sensitive irrespective to whether the database is case sensitive or 
not.. So
it will not be DEMO but Demo unless you have modified the login name in 
the
User form to be DEMO instead of Demo..

 Cheers

 Joe

 
 From: Raj ravi6...@gmail.com
 To: arsl...@arslist.org
 Sent: Wednesday, August 12, 2009 7:44:16 PM
 Subject: Mid Tier Authentication Error ARERR 9388

 Hello All,
 After the fresh installation of mid tier, I addedhttp://midtierserver
name/arsys in default webpath under advanced tab in server information 
form
through user tool and also added ar system server name under all the 
options
available in mid tier configuration tool ie. Ar system Server , 
Preference
Server, Data Visualization Server and Homepage Server.

 Still getting an AUTHENTICATION ERROR ARERR 9388 when i am trying to
login through DEMO.

 Please advise.

 Thanks,
 Raj

___­­­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum 
 Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
  Where the Answers Are

___­­­
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum 

*** WARUG-Fri 21 August 2009-8AM to 1PM-BAH Auditorium, Mclean VA *** RSVP By Tues 18 August

2009-08-13 Thread Betina Lose
Dear ARSListers - 

 

This is a reminder of our upcoming Washington D.C. Area Remedy Users Group
(WARUG) meeting on Friday 21 Aug 2009 again at the Booz Allen Hamilton
auditorium in Mclean VA (8283 Greensboro Drive, Mclean, VA 22102).  The
agenda is as follows:

 

   9:00 - 9:15Betina Lose,  WARUG Chairperson,  Welcome

 

   9:15 - 10:00 Abbas Haider Ali,  Alarm Point, Using AlarmPoint
Alert Management w/Remedy ARS

 

  10:00 - 10:15Break

  10:15 - 11:00Quentin Mackey, Column Technologies,ITSM 7.5 -
Implementation Lessons Learned

 

  11:00 - 11:45Lenny Warren,  RMI Solutions, ARS 7.x Best Practice
Troubleshooting Techniques for Serivce Desk Staff

 

  11:45 - 12:00 Betina Lose, Meeting Close

 

There is no formal membership sign up, but you will need to RSVP to me in
order to get on BAH's security access list.  Please send me email
(bet...@bleeding-edge.com) by Tues 18 August  if you think you will attend
and you will be provided a conference badge at the meeting with proper photo
ID.

 

WARUG meetings are for anyone interested in the BMC Remedy products and
related tools.  Please also visit www.warug.org for detailed information
about WARUG and a list of past meeting topics.

 

We look forward to seeing you on 21 August!

 

(Also, please note that our subsequent meeting will be on Friday 23 October
2009 again at the BAH auditorium.)

 

--BL



Betina Lose, President/Software Engineer

Certified Remedy Skilled Professional (5.1.2, 6.3, 7.0)

Certified ITIL V3 Foundation

Bleeding Edge Technologies, LLC

18411 Kingsmill Street

Leesburg, VA 20176

 

Chairperson, WARUG

www.warug.org

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Flashboards issue in client, not web

2009-08-13 Thread Shafqat Ayaz
Markwhat exactly is the problem you are having, but will not work on client 
what is the error message if any?
thanks
shafqat

--- On Wed, 8/12/09, Mark Lev mark@rightstarsystems.com wrote:

From: Mark Lev mark@rightstarsystems.com
Subject: Flashboards issue in client, not web
To: arslist@ARSLIST.ORG
Date: Wednesday, August 12, 2009, 9:46 PM

**



 
 






 



Hi, 

   

Flashboards is working fine in Mid-Tier but will not work on
client.  I thought I saw something on this a while back, but cannot find.  If
anyone has any ideas, it would be appreciated. 

   

ARS 7.1 

ITSM 7.0.3 

Windows Server 

SQL Server 

Windows Vista on Desktop 

   

Thanks, 

Mark 

  



 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Flashboards issue in client, not web

2009-08-13 Thread David Charters
Is your web path set in the user tool?
Regards,

David Charters
317-331-8985

-Original Message-
From: Shafqat Ayaz shafq...@yahoo.com

Date: Thu, 13 Aug 2009 18:24:51 
To: arslist@ARSLIST.ORG
Subject: Re: Flashboards issue in client, not web


Markwhat exactly is the problem you are having, but will not work on client 
what is the error message if any?
thanks
shafqat

--- On Wed, 8/12/09, Mark Lev mark@rightstarsystems.com wrote:

From: Mark Lev mark@rightstarsystems.com
Subject: Flashboards issue in client, not web
To: arslist@ARSLIST.ORG
Date: Wednesday, August 12, 2009, 9:46 PM

**



 
 






 



Hi, 

   

Flashboards is working fine in Mid-Tier but will not work on
client.  I thought I saw something on this a while back, but cannot find.  If
anyone has any ideas, it would be appreciated. 

   

ARS 7.1 

ITSM 7.0.3 

Windows Server 

SQL Server 

Windows Vista on Desktop 

   

Thanks, 

Mark 

  



 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are