Re: ARSLIST AWARDS

2006-09-01 Thread Matt Reinfeldt
Congratulations to all the winners!!!  A very deserving group!  :)

Matt R.

-Original Message-
From: Doug Blair [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 8:28 PM
To: arslist@ARSLIST.ORG
Subject: ARSLIST AWARDS

ALMOST LIVE,

From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
California

There are too many inside jokes, singing, dancing, Twinkie-hurling people
here that it is impossible to convey the true essence of the camaraderie we
all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A
Little Help From My Friends (... From The List). I think that I really
shouldn't tell you more because that would spoil it. You'll just have to get
your boss to foot the bill next year!

AWARDS:

LONGEST THREAD: What Bugs You About Remedy? (84 posts)

WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
James Ward

BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
explained by incompetence / Matt Black

WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
McKenzie): AXTON GRAMS

...who was duly contacted by Dan on cell phone immediately, with resounding
hoots, cheers and thunderous applause!

Congratulations, Axton, and all the other ARSLIST winners!

Doug


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

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


Re: BMCWorld happenings

2006-09-01 Thread Matt Reinfeldt
**








Rick,



Has there been any mention of reviving
MasterARSuite? Or, at the very least, trashing RDP and replacing it with
something that really works? J 



Sorry to be biased, but I feel the RDP
replacing MasterARSuite was a bad ploy. It just doesnt compare.



Thanks!



Matt











From: Rick cook
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 31, 2006
11:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings





Really not all that much. They
seemed to be focusing on giving people (including themselves) more time to
assimilate, or be assimilated, into the ITSM 7 world. So there will be
more tools for managing the business and better connectivity between the
applications, but they didn't even mention a version 8 today, or some code name
for it.



Not even a projected due date for a next versioncurious.



Rick









From: Action
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Gordon M. Frank
Sent: Thursday, August 31, 2006
6:04 PM
To: arslist@ARSLIST.ORG
Subject: BMCWorld happenings

** 

Hey all of you BMCWorld attendees!



Was anything new announced at the opening?



Web based Admin Tool maybe



Curious!

Gordon Frank



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006

__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___

Re: OT: Excel

2006-09-01 Thread Oscar Herrera
**
Lars,There is a function in excel (davarage) that will do what you want. Below is a copy of the helptext from excel regarding daverage. Good LuckOscar Herrera:    Syntax  DAVERAGE(database,field,criteria)  Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.  Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such
 as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.  Criteria is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column[EMAIL PROTECTED] wrote:  But data from ars Is there a way, I know it is, to make a diagram based on the visible rows when autofilter has been selected for some columns.Now I have the formula Average(A2:A120), if I activate autofilter, maybe only 22 rows are returned, so I want average to be calculated only for those 22 rows.With my formula
 now the diagram is not changed as the intervall is the same, in what way do I have to change the formula to only use visible rows?I think someone has the answer.L ars PetterssonVattenfall Business Services Nordic ABAction Request System Engineer (Tabasco)S-461 88 TrollhättanSwedenPhone +46 520 888 35 Mobil +46 70 608 99 95e-mail: [EMAIL PROTECTED]___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
		Do you Yahoo!? Everyone is raving about the  all-new Yahoo! Mail.
__20060125___This posting was submitted with HTML in it___

Re: Attachment Format Conversion?

2006-09-01 Thread Dave Barber
**
James,

I'll agree with OLE. I did something very similar many years back (in my old Visual Foxpro developer days), using OLE automation to do a lot of processing in Excel that would have just been too painful (or impossible) to perform in VFP (the data that I was using was supplied in Excel format, it would have been a good idea in hindsight to convert it back over to CSV and store that as well, it would have been quite a simple process).


But as that was maybe 10 years back, exact details are somewhat vague ...

Good luck with it!
Regards

Dave

On 31/08/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:

** 

Lori:  I think you are on the correct track with OLE. I'm not totally familiar with all of the available functions, but I think it is possible to open a file/template with an embedded macro that reads in the .xls file and then can save it as the same named .csv file. Sadly, I cannot try this today.

 James McKenzie L-3 GSI  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lori Gumbiner
 Sent: Thursday, August 31, 2006 9:15 AM To: arslist@ARSLIST.ORG
 Subject: Attachment Format Conversion? 

** Hi guys! the WAG Remedy team all stayed home from RUG in a BUG this year, too. 
And, we are trying to do a nifty trick: 
 User opens a record with an attachment file that is an Excel worksheet, formatted *.xls 
 Can we give the User a button on the Remedy form that will convert that attachment to *.csv format? 
We have brainstormed all sorts of ideas (some feasible, some wishful thinking) , e.g. calling a converter utility, or using OLE to run a macro in the xls to save it as csv. 
Thought we'd bring the List's creativity to the problem. Any ideas? 
Oh, and any utility needs to be credible and free. 
ARS System Specs: Remedy: 6.3, patch 17 SunOS 5.9 Oracle 9.2.0.4.0 
*Lori 
* Lori Gumbiner IT Systems Architecture - Process Automation Initiatives Walgreens Co.
 847.914.5796 __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___


Re: BMCWorld happenings

2006-09-01 Thread Michiel Beijen
**
Jarl,Thor was the code name for v7, check the archives...--MichielOn 9/1/06, Jarl Grøneng 
[EMAIL PROTECTED] wrote:Is'nt version 8 codenamed thor?--Jarl
On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: ** Really not all that much.They seemed to be focusing on giving people (including themselves) more time to assimilate, or be assimilated, into the
 ITSM 7 world.So there will be more tools for managing the business and better connectivity between the applications, but they didn't even mention a version 8 today, or some code name for it.
 Not even a projected due date for a next versioncurious. Rick  From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Gordon M. Frank Sent: Thursday, August 31, 2006 6:04 PM To: arslist@ARSLIST.ORG Subject: BMCWorld happenings
 ** Hey all of you BMCWorld attendees! Was anything new announced at the opening? Web based Admin Tool maybe
 Curious! Gordon Frank -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7
/434 - Release Date: 8/30/2006 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___


AREA LDAP Authentication on Solaris using SSL

2006-09-01 Thread Jerry Niman
Dear listers who are not at BUW (and those who are and are checking their 
email!)

ARS 6.3
Solaris 8

I am currently using AREA LDAP successfully to authenticate ARS users to an 
LDAP tree fronting
Novell E-Directory.

Everyone thinks it's marvellous.

However, the E-Directory team want to withdraw the unencrypted LDAP service, 
and require everyone
to use LDAP over SSL. Fair enough, a very sensible thing to do.

The LDAP tree certificate doesn't go back to one of the trusted root 
certificate authorities, but
is self signed. There is a RootCert.der certificate to be imported.

However, the AREA LDAP plug-in is based on the Netscape SDK, and requires a 
cert7.db and key3.db
incorporating the credentials.

On Windows, I can do this by running version 4.7 of Netscape and opening the 
RootCert.der file.
This imports it and incorporates the credentials into the cert7.db and key3.db 
files. 

This is explained at

http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402L=arslistP=R54534

However, if I try the same on Solaris, it doesn't work, and I can't seem to 
copy across the db
files from Windows to Solaris  - or at least Netscape on Solaris seems not to 
notice them.

Does anyone have any suggestions?

Jerry




Jerry Niman Tel +44 (0)161-247 1474
Head of Information Systems Email [EMAIL PROTECTED]
the Manchester Metropolitan University Mobile +44 (0)7770 638104

Before acting on this email or opening any attachments you should read the 
Manchester Metropolitan
University’s email disclaimer available on its website 
http://www.mmu.ac.uk/emaildisclaimer 

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


Re: AREA LDAP Authentication on Solaris using SSL

2006-09-01 Thread Jiri Pospisil
Jerry,

I have managed to set up AREA LDAP over SSL on our HP server. 
First, we tried to import the certificate directly to the cert7.db file
using the certutil utility, which worked fine, but Remedy authentication
was not working with cert7.db file generated this way. 

Next option was using stunnel or similar utility to create secure
connection from Remedy server to the LDAP machine. That worked fine,
only worry is that you are relying on yet another external process
running. In this case the AREA LDAP is configured to connect to a port
on the Remedy server and stunnel takes care of forwarding that
connection securely to LDAP server.

Finally, you can try to run Netscape on your Remedy server and attempt
connecting to the LDAP server over https. You can use a URL like
https:\\your.LDAP.server:636  (not sure about the exact syntax of the
URL)
After connecting, Netscape will ask if you trust the site and want to
install the certificate. After answering yes, the cert7.db file should
get updated. You can then reference this file in the AREA LDAP
configuration and all should work.

Hope this will help and save you some time.

Regards
Jiri

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Niman
Sent: 01 September 2006 09:21
To: arslist@arslist.org
Subject: AREA LDAP Authentication on Solaris using SSL

Dear listers who are not at BUW (and those who are and are checking
their email!)

ARS 6.3
Solaris 8

I am currently using AREA LDAP successfully to authenticate ARS users to
an LDAP tree fronting
Novell E-Directory.

Everyone thinks it's marvellous.

However, the E-Directory team want to withdraw the unencrypted LDAP
service, and require everyone
to use LDAP over SSL. Fair enough, a very sensible thing to do.

The LDAP tree certificate doesn't go back to one of the trusted root
certificate authorities, but
is self signed. There is a RootCert.der certificate to be imported.

However, the AREA LDAP plug-in is based on the Netscape SDK, and
requires a cert7.db and key3.db
incorporating the credentials.

On Windows, I can do this by running version 4.7 of Netscape and opening
the RootCert.der file.
This imports it and incorporates the credentials into the cert7.db and
key3.db files. 

This is explained at

http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402L=arslistP=R54534

However, if I try the same on Solaris, it doesn't work, and I can't seem
to copy across the db
files from Windows to Solaris  - or at least Netscape on Solaris seems
not to notice them.

Does anyone have any suggestions?

Jerry




Jerry Niman Tel +44 (0)161-247 1474
Head of Information Systems Email [EMAIL PROTECTED]
the Manchester Metropolitan University Mobile +44 (0)7770 638104

Before acting on this email or opening any attachments you should read
the Manchester Metropolitan
University's email disclaimer available on its website
http://www.mmu.ac.uk/emaildisclaimer 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  
If you have received this email in error please notify the sender immediately 
and delete this email from your system without copying or disseminating it or 
placing any reliance upon its contents.  We cannot accept liability for any 
breaches of confidence arising through use of email.  Any opinions expressed
 in this email (including attachments) are those of the author and do not 
necessarily reflect our opinions.  We will not accept responsibility for 
any commitments made by our employees outside the scope of our business.  
We do not warrant the accuracy or completeness of such information.

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


Difference in times - Oracle DB and forms

2006-09-01 Thread Mark Bee
Hi all,
The HPD-HelpDesk fields display an actual time whilst 
after recalculating the database's time I got 2 hour delay.
It concerns all date fields (arrival time, resolved time, work in progres 
time...).

When I check database time zone:
select dbtimezone from dual;
it gives me
+02:00
on the other Remedy server I got:
-07:00
But still the difference is 2 hours.

I think it's an Oracle issue, perhaps wrong configuration.
Can anyone point me to the solvation.
Tanks
Mark B.

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


Re: ARSLIST AWARDS

2006-09-01 Thread Misi Mladoniczky
I totally agree.

I have a confession to make though. I have now eaten the first Twinkie of
my life. It is very unlikely that this will occur again...

I first thought that this black hole in my experience was due to Swedish
Twinkie-tolls, but after the memorable experience this very eavning, I
have come to reassess my standpoint!

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

 Congratulations to all the winners!!!  A very deserving group!  :)

 Matt R.

 -Original Message-
 From: Doug Blair [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 31, 2006 8:28 PM
 To: arslist@ARSLIST.ORG
 Subject: ARSLIST AWARDS

 ALMOST LIVE,

From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
 California

 There are too many inside jokes, singing, dancing, Twinkie-hurling people
 here that it is impossible to convey the true essence of the camaraderie
 we
 all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A
 Little Help From My Friends (... From The List). I think that I really
 shouldn't tell you more because that would spoil it. You'll just have to
 get
 your boss to foot the bill next year!

 AWARDS:

 LONGEST THREAD: What Bugs You About Remedy? (84 posts)

 WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
 James Ward

 BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
 explained by incompetence / Matt Black

 WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

 BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

 BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

 BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

 MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
 McKenzie): AXTON GRAMS

 ...who was duly contacted by Dan on cell phone immediately, with
 resounding
 hoots, cheers and thunderous applause!

 Congratulations, Axton, and all the other ARSLIST winners!

 Doug

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

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


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


Re: BMCWorld happenings

2006-09-01 Thread Carey Matthew Black

Misi (All),

An exact code name was not mentioned. ( As far as I can remember.)
However an example of amber was given. And the pattern would be to
follow the alphabet like they do with hurricane names. A= Amber
then B= Bob then C=Charlie, etc... If the need to do a B.5 type
thing then I think the idea would be to find a Ba 'ish (alpha sort
after the name that was picked for B)  name to get the job done.

I did gleam that the time of year for BUW ( BMC User World ) next year
will be this bat time. And based on when v8 (or v7.5 depending on
what they end up doing) will likely be released _before_ the next BUW.


They have been only the most vague about themas for what they are
trying to do for the next version. No demos, samples, screenshots, or
it might change later, but look at this stuff this year. (They did
all of that at the last RUG.

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

Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.



On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote:

Hi again,

Loke has been rejected as the code name, to my great distress. During this
conference, as well as the last ten years, I have been carrying Thors
hammer around my neck. They have actually decided to skip the Norse
mythology and restart things with minerals and the first letter of the
alphabet. At this point in time, I am unable to recall the exact
mineral/stone/substance in question... Pleas help me out!

As far as the Admin Tool is concerned, they have indicated a move towards
Eclipse and Java, rather than the web.

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

 Jarl,


snip


 On 9/1/06, Rick cook [EMAIL PROTECTED] wrote:
  **
  Really not all that much.  They seemed to be focusing on giving people
  (including themselves) more time to assimilate, or be assimilated,
 into
 the
  ITSM 7 world.  So there will be more tools for managing the business
 and
  better connectivity between the applications, but they didn't even
 mention a
  version 8 today, or some code name for it.
 
  Not even a projected due date for a next versioncurious.
 
  Rick
  
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Gordon M. Frank
  Sent: Thursday, August 31, 2006 6:04 PM
  To: arslist@ARSLIST.ORG
  Subject: BMCWorld happenings
 
 
  **
  Hey all of you BMCWorld attendees!
 
  Was anything new announced at the opening?
 
  Web based Admin Tool maybe
 
  Curious!
 
  Gordon Frank


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


Re: Difference in times - Oracle DB and forms

2006-09-01 Thread Michiel Beijen
**
The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well.The value stored in the database is GMT.
Does this help you?Kind regards,MichielOn 9/1/06, Mark Bee [EMAIL PROTECTED] wrote:
Hi all,The HPD-HelpDesk fields display an actual time whilstafter recalculating the database's time I got 2 hour delay.
It concerns all date fields (arrival time, resolved time, work in progrestime...).When I check database time zone:select dbtimezone from dual;it gives me+02:00on the other Remedy server I got:
-07:00But still the difference is 2 hours.I think it's an Oracle issue, perhaps wrong configuration.Can anyone point me to the solvation.TanksMark B.___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___


Re: Difference in times - Oracle DB and forms

2006-09-01 Thread Mark Bee
Thank you for your answer.
But I still don't know how I'm suppose to retrieve the data
using API or by SQL query.
That would stil give me the wrong time.
MarkB.

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


Re: Difference in times - Oracle DB and forms

2006-09-01 Thread Michiel Beijen
**
If you would like to retrieve the time using SQL, you should add the offset to the time in the database yourself.Also if you're using the API your API program should take account of your offset to GMT. This would normally be stored in an environment variable.
Regards,MichielOn 9/1/06, Mark Bee [EMAIL PROTECTED] wrote:
Thank you for your answer.But I still don't know how I'm suppose to retrieve the datausing API or by SQL query.That would stil give me the wrong time.MarkB.___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___


OT: Twinkie Experiments - Friday Humor

2006-09-01 Thread Mark Blankenship
**



For Misi, having eaten his first 
twinkie.
A scientific analysis of the twinkie
http://www.twinkiesproject.com/


Mark
__20060125___This posting was submitted with HTML in it___


Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread lars . j . pettersson
**



Curious about all this discussion about Twinkies, misi, please bring one 
or two home to Sweden, also a good test of Twinkies capacityto keep the 
qualities during a long flight. L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark 
  BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: 
  arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday 
  Humor** 
  
  

  For Misi, having eaten his first 
  twinkie.
  A scientific analysis of the twinkie
  http://www.twinkiesproject.com/
  
  
  Mark__20060125___This posting was 
  submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread Tony Worthington
**

also
a good test of Twinkies capacity to keep the qualities during a long flight.

Oh, I think they'll hold up. Even
through a nuclear winter. :-)

All Things Considered, August 1, 2005
· Michele Norris speaks with Roger Bennatti, a recently retired science
teacher at George Stevens Academy in Blue Hill, Me., about a food preservation
experiment he began 30 years ago. He and students set out to determine
the shelf life of a Hostess Twinkie.

http://www.npr.org/templates/story/story.php?storyId=4780900

Happy Friday everyone...

-tony

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





[EMAIL PROTECTED]

Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
09/01/2006 07:17 AM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Re: Twinkie Experiments - Friday Humor








** 
Curious about all this discussion
about Twinkies, misi, please bring one or two home to Sweden, also a good
test of Twinkies capacity to keep the qualities during a long flight. L
ars
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On
Behalf Of Mark Blankenship
Sent: Friday, September 01, 2006 2:06 PM
To: arslist@ARSLIST.ORG
Subject: OT: Twinkie Experiments - Friday Humor

** 
For Misi, having eaten his first twinkie.
A scientific analysis of the twinkie
http://www.twinkiesproject.com/


Mark
__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___

Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread Reiser, John J
**



Don't worry L ars. Twinkies can even withstand a 
Nucular[sic] blast. 
Just 
ask Peter Griffin
John J. ReiserSoftware Development AnalystRemedy 
Administrator/DeveloperLockheed Martin - MS2The 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:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, September 01, 2006 
8:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Twinkie 
Experiments - Friday Humor
** 

Curious about all this discussion about Twinkies, misi, please bring one 
or two home to Sweden, also a good test of Twinkies capacityto keep the 
qualities during a long flight. L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark 
  BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: 
  arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday 
  Humor** 
  
  

  For Misi, having eaten his first 
  twinkie.
  A scientific analysis of the twinkie
  http://www.twinkiesproject.com/
  
  
  Mark__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___


Re: ARSLIST AWARDS

2006-09-01 Thread Axton

funny stuff

Axton

On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote:

I totally agree.

I have a confession to make though. I have now eaten the first Twinkie of
my life. It is very unlikely that this will occur again...

I first thought that this black hole in my experience was due to Swedish
Twinkie-tolls, but after the memorable experience this very eavning, I
have come to reassess my standpoint!

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

 Congratulations to all the winners!!!  A very deserving group!  :)

 Matt R.

 -Original Message-
 From: Doug Blair [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 31, 2006 8:28 PM
 To: arslist@ARSLIST.ORG
 Subject: ARSLIST AWARDS

 ALMOST LIVE,

From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
 California

 There are too many inside jokes, singing, dancing, Twinkie-hurling people
 here that it is impossible to convey the true essence of the camaraderie
 we
 all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A
 Little Help From My Friends (... From The List). I think that I really
 shouldn't tell you more because that would spoil it. You'll just have to
 get
 your boss to foot the bill next year!

 AWARDS:

 LONGEST THREAD: What Bugs You About Remedy? (84 posts)

 WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
 James Ward

 BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
 explained by incompetence / Matt Black

 WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

 BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

 BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

 BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

 MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
 McKenzie): AXTON GRAMS

 ...who was duly contacted by Dan on cell phone immediately, with
 resounding
 hoots, cheers and thunderous applause!

 Congratulations, Axton, and all the other ARSLIST winners!

 Doug

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

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


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



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


Re: ARSLIST AWARDS

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: ARSLIST AWARDS
**





Axton:


Congratulations.


I bet the voting was very close.


James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Friday, September 01, 2006 6:10 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS


funny stuff


Axton


On 9/1/06, Misi Mladoniczky [EMAIL PROTECTED] wrote:
 I totally agree.

 I have a confession to make though. I have now eaten the first Twinkie 
 of my life. It is very unlikely that this will occur again...

 I first thought that this black hole in my experience was due to 
 Swedish Twinkie-tolls, but after the memorable experience this very 
 eavning, I have come to reassess my standpoint!

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

  Congratulations to all the winners!!! A very deserving group! :)
 
  Matt R.
 
  -Original Message-
  From: Doug Blair [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, August 31, 2006 8:28 PM
  To: arslist@ARSLIST.ORG
  Subject: ARSLIST AWARDS
 
  ALMOST LIVE,
 
 From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
  California
 
  There are too many inside jokes, singing, dancing, Twinkie-hurling 
  people here that it is impossible to convey the true essence of the 
  camaraderie we all feel. So far we have parodies of Y-M-C-A 
  (A-R-S-LIST) and With A Little Help From My Friends (... From 
  The List). I think that I really shouldn't tell you more because 
  that would spoil it. You'll just have to get your boss to foot the 
  bill next year!
 
  AWARDS:
 
  LONGEST THREAD: What Bugs You About Remedy? (84 posts)
 
  WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear 
  text) James Ward
 
  BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can 
  be explained by incompetence / Matt Black
 
  WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa
 
  BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich
 
  BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)
 
  BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren
 
  MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
  McKenzie): AXTON GRAMS
 
  ...who was duly contacted by Dan on cell phone immediately, with 
  resounding hoots, cheers and thunderous applause!
 
  Congratulations, Axton, and all the other ARSLIST winners!
 
  Doug
 
  
  
  ___
  UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
  
  ___ UNSUBSCRIBE or access ARSlist Archives at 
  http://www.wwrug.org
 

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



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




__20060125___This posting was submitted with HTML in it___

Re: ARSLIST AWARDS

2006-09-01 Thread Frank, Gordon Mr 114th Sig BN
Title: RE: ARSLIST AWARDS
**





Congratulations Axton


Gordon Frank
US Army




__20060125___This posting was submitted with HTML in it___

Re: Question: Administrator Tool Not Showing Details

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Question:  Administrator Tool Not Showing Details
**





Tyrone:


Are you limiting the return items list on the production server? If so, the details for Filters ONLY will be hidden when you request the complete filter list AND it is larger than the number allowed in the return list. BMC states this is as designed.

James McKenzie 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of T. Dee
Sent: Thursday, August 31, 2006 4:58 PM
To: arslist@ARSLIST.ORG
Subject: Question: Administrator Tool Not Showing Details


I am running ARS 6.00.01 Patch 1394. I login to 3 servers (production, development and sandbox). I have details turned on. When I click on Filters I see all the details in production and sandbox, but in development only the names shows up (no other details). I have rebooted the server, but this changes nothing. This only happened today - prior to this all the details have always shown up.

The admin tool is 6.00.01.


This is very odd - any suggestions?


THANKS 


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




__20060125___This posting was submitted with HTML in it___

Re: ARSLIST AWARDS

2006-09-01 Thread Grooms, Frederick W
Congratulations to all 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair
Sent: Thursday, August 31, 2006 8:28 PM
To: arslist@ARSLIST.ORG
Subject: ARSLIST AWARDS

ALMOST LIVE,

From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
California

There are too many inside jokes, singing, dancing, Twinkie-hurling
people here that it is impossible to convey the true essence of the
camaraderie we all feel. So far we have parodies of Y-M-C-A
(A-R-S-LIST) and With A Little Help From My Friends (... From The
List). I think that I really shouldn't tell you more because that would
spoil it. You'll just have to get your boss to foot the bill next year!

AWARDS:

LONGEST THREAD: What Bugs You About Remedy? (84 posts)

WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
James Ward

BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
explained by incompetence / Matt Black

WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
McKenzie): AXTON GRAMS

...who was duly contacted by Dan on cell phone immediately, with
resounding hoots, cheers and thunderous applause!

Congratulations, Axton, and all the other ARSLIST winners!

Doug

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


Re: SSO via user tool

2006-09-01 Thread Watson Benjamin A Contr AFWA/XOO
Title: Re: SSO via user tool
**








Carolyn,



Please contact me off list at:



[EMAIL PROTECTED]













From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wixson Carolyn L PSNS
Sent: Thursday, August 31, 2006
3:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: SSO via user tool









Benjamin,











We are also CAC enabled. We need to get
the mid-tier up for Requesters to submit tickets. Our management does not want
them to see a login screen.











Can you share your CAC solution?











We are currently using:





 ARS ver 5.1.2





 HelpDesk ver 5.6











We may be upgrading to ARS ver 6.3 very
soon.











Any help you can give will be GREATLY
appreciated.





Carolyn
Wixson
(360)
476-6197
PSNS  IMF
Remedy ARS Administrator 






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

Re: BMCWorld happenings

2006-09-01 Thread Rick cook
**



I totally agree with you, but have heard nothing about 
enhancements to the RDP.

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt 
ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: 
arslist@ARSLIST.ORGSubject: Re: BMCWorld 
happenings
** 




Rick,

Has there been any 
mention of reviving MasterARSuite? Or, at the very least, trashing RDP and 
replacing it with something that really works? J 


Sorry to be biased, but 
I feel the RDP replacing MasterARSuite was a bad ploy. It just doesnt 
compare.

Thanks!
Matt





From: Rick cook 
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 31, 
2006 11:35 PMTo: 
arslist@ARSLIST.ORGSubject: Re: BMCWorld 
happenings

Really not all that 
much. They seemed to be focusing on giving people (including themselves) 
more time to assimilate, or be assimilated, into the ITSM 7 world. So 
there will be more tools for managing the business and better connectivity 
between the applications, but they didn't even mention a version 8 today, or 
some code name for it.

Not even a projected 
due date for a next versioncurious.

Rick




From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 
PMTo: arslist@ARSLIST.ORGSubject: BMCWorld 
happenings
** 
Hey all of you BMCWorld 
attendees!

Was anything new 
announced at the opening?

Web based Admin Tool 
maybe

Curious!
Gordon 
Frank

--No 
virus found in this outgoing message.Checked by AVG Free 
Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 
8/30/2006
__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___


JOBS: Contract Permanent, Nationwide

2006-09-01 Thread Rachel Kerwick
List, Good afternoon, 

Turing SMI and Turing SMI Resource Management are urgently seeking a 
Remedy Developer for a contract in the North West of England for the short 
to medium term.  Start date within the next 2-4 weeks.

We also have ongoing urgent requirements in the South of England and are 
always keen to hear from individuals who are available within the next 1-2 
months.

On the permanent side we have a number of opportunities for Remedy 
Developers and will consider all locations.

As always, many thanks for your attention and I hope you all have a 
pleasant weekend.

Kind regards,

Rachel Kerwick
Resourcing

TuringSMI
200 Brook Drive
Green Park
Reading
Berkshire
RG2 6UB

Office: +44 (0) 1189 256049
Mobile: +44 (0) 7875 431604
Fax: +44 (0) 1189 497221
Website: www.turingsmi.com
eMail: [EMAIL PROTECTED]

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


Re: Hellllloooooo!!!!

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Heloo
**



Rick and Bing:

I'll leave the Mexican here. Being from Southern 
Arizona, I cannot walk a block without seeing some sort of Mexican 
resturant. However, I will not pass up a good (read, great) place to be a 
true carnivore. Be it steak, chicken or some exotic meats (you really 
don't want to know what I've consumed in my lifetime.) And I don't 
consider Black Angus to be in the category I'm talking about. Lawrey's is. 
McCormick  Smicks is for food from the sea.

James McKenzie



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
cookSent: Thursday, August 31, 2006 9:40 PMTo: 
arslist@ARSLIST.ORGSubject: Re: 
Heloo
** 

Oh, the Blue Agave is to DIE for. The chicken Mole 
was best Mexican meal I have ever had. I'm not a Tequila drinker, but if 
you are, they have a multi-page book with all of them they serve, like a nice 
steakhouse would have a big wine list.

Great Thai place in Mountain View, too - can't remember the 
name, but it was on that new trendy street they have - Castro 
St.?

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bradford 
BingelSent: Thursday, August 31, 2006 9:30 PMTo: 
arslist@ARSLIST.ORGSubject: Re: 
Heloo
** 

Take it from a "local" just up the road in Walnut Creek .. . lots 
of places to see and plenty of things to do in Northern California. Better 
still, spend a few more days and explore San Francisco, Monterey Bay, Napa 
Valley, Old Sacramento, Lake Tahoe,or Yosemite.

Looking for best picksin food? You probably won't have much 
time to explore for breakfast or lunch, but there are several excellent 
choices for dinner. For Mexican, I'd suggest the Blue Agave in downtown 
Pleasanton, or La Ultima in Danville (5 miles north). Looking for 
asteak? Try Cattleman'soutside Livermore (5 miles east), 
orcome to Walnut Creek (15 miles north)for Ruth's Chris or Vic 
Stewart's. Too many excellent Chinese restaurants to name, but Uncle Yu's 
in San Ramon (5 miles north) and P. F. Chang's (Walnut Creek) stand out. 
BBQ fans, try Back 40 in Pleasant Hill (20 miles north), consistent winner of 
the national rib cook-off held each year in Reno.

Please feel free to drop me a line for additional ideas 
andinformation!

-- Bing


Bradford Bingel ("Bing")ITM3 
California
http://www.itm3.com/[EMAIL PROTECTED] 
(email)925-260-6394 (mobile)



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
cookSent: Thursday, August 31, 2006 3:47 PMTo: 
arslist@ARSLIST.ORGSubject: Re: 
Heloo
** 

Wow, there are so many. I have honestly never had a 
bad meal in that town (as those who've seen me can attest). There's a 
sandwich place right across the street from the training facility that sells a 
steak sandwich that is absolutely the best I've ever had. All the places 
downtown are great.

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J 
C-E LCMC HQISEC/L3Sent: Thursday, August 31, 2006 3:21 
PMTo: arslist@ARSLIST.ORGSubject: Re: 
Heloo
** 

Rick:  And 
your favorite place is???  BTW, the RAC and RSP are deliberately hard to keep the number of people 
with them current and knowledgeable.  
James McKenzie  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Rick cook Sent: Thursday, August 31, 2006 3:11 PM 
To: arslist@ARSLIST.ORG Subject: Re: 
Heloo 
** Audrey, if the RSP class is like the 
RAC class, you'll need to demonstrate the ability to gather requirements from a 
customer, write a requirements doc., develop a system from a set of 
requirements, and present it to the customer. The application is 
significant, but isn't a rocket science type of thing. There's also a 
written test.
And Pleasanton is a wonderful place to 
have a class. If you go, you HAVE to go to the old downtown. I just 
love it there.
Rick 
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thursday, August 31, 2006 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: 
Heloo 
** 
Audrey: 
You want Lenny as your instructor if he teaches the 
course. I've heard that he is working on the other instructors trying to 
bring them up to and keeping them at his level.
James McKenzie  
-Original Message- From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Audrey H Franklin Sent: Thursday, August 31, 2006 12:23 
PM To: arslist@ARSLIST.ORG Subject: Re: Heloo 
James, 
I am not familiar with Pleasanton, CA. All Remedy Classes I 
attended were in Columbia, MD. 
However, I plan to take the RSP class in October, and would like 
to know if you have any pointers on the best way 

Quick Report in MidTier?

2006-09-01 Thread James Pifer
From our client (6.3) we have a quick report button that prints out a
ticket and the specified fields so you get a report that has all the
information from the fields in the report.

What report options are there from midtier? Just printing from the
browser only gives you what you can see of course. 

Thanks,
James

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


Re: AREA LDAP Authentication on Solaris using SSL

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: AREA LDAP Authentication on Solaris using SSL
**





Jerry:


You have the files, use them. You have to copy them into the appropriate directory on Solaris and the method to do this is described in the documents. I have never been able to get Netscape on Solaris to do what you described. I use the Windows version.

James Mckenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jerry Niman
Sent: Friday, September 01, 2006 1:21 AM
To: arslist@ARSLIST.ORG
Subject: AREA LDAP Authentication on Solaris using SSL


Dear listers who are not at BUW (and those who are and are checking their email!)


ARS 6.3
Solaris 8


I am currently using AREA LDAP successfully to authenticate ARS users to an LDAP tree fronting Novell E-Directory.


Everyone thinks it's marvellous.


However, the E-Directory team want to withdraw the unencrypted LDAP service, and require everyone to use LDAP over SSL. Fair enough, a very sensible thing to do.

The LDAP tree certificate doesn't go back to one of the trusted root certificate authorities, but is self signed. There is a RootCert.der certificate to be imported.

However, the AREA LDAP plug-in is based on the Netscape SDK, and requires a cert7.db and key3.db incorporating the credentials.

On Windows, I can do this by running version 4.7 of Netscape and opening the RootCert.der file.
This imports it and incorporates the credentials into the cert7.db and key3.db files. 


This is explained at


http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0402=arslist=R54534


However, if I try the same on Solaris, it doesn't work, and I can't seem to copy across the db files from Windows to Solaris - or at least Netscape on Solaris seems not to notice them.

Does anyone have any suggestions?


Jerry





Jerry Niman Tel +44 (0)161-247 1474
Head of Information Systems Email [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104


Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer 

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




__20060125___This posting was submitted with HTML in it___

Re: BMCWorld happenings

2006-09-01 Thread lars . j . pettersson
**



Yes, 
this was a mistake, Mars wes a great product, I used it several days a week 
during development, and it saved hours of time finding wf, unused menues, good 
for documentation and a lot more. And a great support.I've not been able 
to even start RDP ...L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick 
  cookSent: Friday, September 01, 2006 4:10 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings** 
  
  I totally agree with you, but have heard nothing about 
  enhancements to the RDP.
  
  Rick
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt 
  ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  ** 
  
  

  
  Rick,
  
  Has there been any 
  mention of reviving MasterARSuite? Or, at the very least, trashing RDP 
  and replacing it with something that really works? J 
  
  
  Sorry to be biased, 
  but I feel the RDP replacing MasterARSuite was a bad ploy. It just 
  doesnt compare.
  
  Thanks!
  Matt
  
  
  
  
  
  From: Rick 
  cook [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, August 31, 
  2006 11:35 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  
  Really not all that 
  much. They seemed to be focusing on giving people (including themselves) 
  more time to assimilate, or be assimilated, into the ITSM 7 world. So 
  there will be more tools for managing the business and better connectivity 
  between the applications, but they didn't even mention a version 8 today, or 
  some code name for it.
  
  Not even a projected 
  due date for a next versioncurious.
  
  Rick
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 
  PMTo: arslist@ARSLIST.ORGSubject: BMCWorld 
  happenings
  ** 
  Hey all of you 
  BMCWorld attendees!
  
  Was anything new 
  announced at the opening?
  
  Web based Admin Tool 
  maybe
  
  Curious!
  Gordon 
  Frank
  
  --No 
  virus found in this outgoing message.Checked by AVG Free 
  Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 
  8/30/2006
  __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___


Re: ARSLIST AWARDS

2006-09-01 Thread Axton

Thanks James, Frank.  I've found that the voting is always very close
with these things.

Axton

On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote:

**


Congratulations Axton

Gordon Frank
US Army
__20060125___This posting was submitted
with HTML in it___


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


Re: Difference in times - Oracle DB and forms

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Difference in times - Oracle DB and forms
**





Michiel:

Huh? The time stored in the database is the same TZ as the ARS server from what I've been able to determine. However, that being set aside you do have a point. If you look at the time on the WUT, it will be the same as the user machine. But if you run an external process to the server, the time displayed will be the server's time and NOT the user local time, unless you use processes to grab the user's local time and then adjust for the difference between the two. This has resulted in some interesting time differences and a lot of work to correct. 

I would be very happy if the database did store times in UTC/GMT. It would make some of the things I do much easier.

James Mckenzie





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen
Sent: Friday, September 01, 2006 3:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Difference in times - Oracle DB and forms



** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well.

The value stored in the database is GMT.


Does this help you?


Kind regards,


Michiel



On 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: 


 Hi all,
 The HPD-HelpDesk fields display an actual time whilst
 after recalculating the database's time I got 2 hour delay. 
 It concerns all date fields (arrival time, resolved time, work in progres
 time...).
 
 When I check database time zone:
 select dbtimezone from dual;
 it gives me
 +02:00
 on the other Remedy server I got: 
 -07:00
 But still the difference is 2 hours.
 
 I think it's an Oracle issue, perhaps wrong configuration.
 Can anyone point me to the solvation.
 Tanks
 Mark B.
 
 ___ 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 



__20060125___This posting was submitted with HTML in it___ 




__20060125___This posting was submitted with HTML in it___

Re: AR Plugin for Vendor Form

2006-09-01 Thread Julie Devick
Did you ever figure out how you were going to handle this?

We would like to be able to take a excel list of device tags and create 
change management request for each device without having to manually 
entering each one.

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


Re: BMCWorld happenings

2006-09-01 Thread Rick cook
**



In v7, I have not been able to get RDP to work at 
all. I have contacted support - it's an open issue.

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, September 01, 2006 
7:16 AMTo: arslist@ARSLIST.ORGSubject: Re: BMCWorld 
happenings
** 

Yes, 
this was a mistake, Mars wes a great product, I used it several days a week 
during development, and it saved hours of time finding wf, unused menues, good 
for documentation and a lot more. And a great support.I've not been able 
to even start RDP ...L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick 
  cookSent: Friday, September 01, 2006 4:10 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings** 
  
  I totally agree with you, but have heard nothing about 
  enhancements to the RDP.
  
  Rick
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt 
  ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  ** 
  
  

  
  Rick,
  
  Has there been any 
  mention of reviving MasterARSuite? Or, at the very least, trashing RDP 
  and replacing it with something that really works? J 
  
  
  Sorry to be biased, 
  but I feel the RDP replacing MasterARSuite was a bad ploy. It just 
  doesnt compare.
  
  Thanks!
  Matt
  
  
  
  
  
  From: Rick 
  cook [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, August 31, 
  2006 11:35 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  
  Really not all that 
  much. They seemed to be focusing on giving people (including themselves) 
  more time to assimilate, or be assimilated, into the ITSM 7 world. So 
  there will be more tools for managing the business and better connectivity 
  between the applications, but they didn't even mention a version 8 today, or 
  some code name for it.
  
  Not even a projected 
  due date for a next versioncurious.
  
  Rick
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 
  PMTo: arslist@ARSLIST.ORGSubject: BMCWorld 
  happenings
  ** 
  Hey all of you 
  BMCWorld attendees!
  
  Was anything new 
  announced at the opening?
  
  Web based Admin Tool 
  maybe
  
  Curious!
  Gordon 
  Frank
  
  --No 
  virus found in this outgoing message.Checked by AVG Free 
  Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 
  8/30/2006
  __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___ 
__20060125___This posting was submitted with HTML in it___


Re: ARSLIST AWARDS

2006-09-01 Thread Rick cook
Whether it was close or not, I would have been disappointed if I had
deprived either you or James of an award that both of you deserved.

Rick 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Friday, September 01, 2006 7:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS

Thanks James, Frank.  I've found that the voting is always very close with
these things.

Axton

On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote:
 **


 Congratulations Axton

 Gordon Frank
 US Army
 __20060125___This posting was submitted with HTML 
 in it___


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

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


Re: ARSLIST AWARDS

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: ARSLIST AWARDS
**





Rick:


If you had won the award, I would still have congratulated you. The real winners in all of this are the members of the list, who receive information from other members, saving valuable hours of troubleshooting and BMC who can discover if anyone else found a workaround or a fix without having to go into the lab. BMC also discovers if this is a 'one off' problem or if it affects many of us.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook
Sent: Friday, September 01, 2006 7:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS


Whether it was close or not, I would have been disappointed if I had deprived either you or James of an award that both of you deserved.

Rick 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Friday, September 01, 2006 7:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS


Thanks James, Frank. I've found that the voting is always very close with these things.


Axton


On 9/1/06, Frank, Gordon Mr 114th Sig BN [EMAIL PROTECTED] wrote:
 **


 Congratulations Axton

 Gordon Frank
 US Army
 __20060125___This posting was submitted with HTML 
 in it___



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


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




__20060125___This posting was submitted with HTML in it___

Deletion of non-reference entry mechanism

2006-09-01 Thread Mathieu Pitre
Hi all,

I need your attention on this one.

I am becoming creative and I wonder if I should. I am trying to figure how 
to automaticly delete the entries which have no more reference to their 
parent. Let me explain the situation first. I have one form called Parent 
and a second one called Child(Parent and child relation). First, once a 
user opens a new Parent form I generate a GUID. I am using the GUID because 
the user might create a child relation before they save the form(In that 
specific case I could not transfer the RequestID). That way, I can transfer 
it(GUID) to my child form in order to keep my reference. However, if my 
users dont save their parent form and just cancel it I would like to delete 
all the child entries which are now useless. Now that everyone understand 
the situation what is the best approach taking in consideration that I have 
multiple application and multiple parent and child relation. I would like 
to avoid the redundancy in the way I develop this to come up with a generic 
mechanism.

Here is what I did so far:

1- Form Name = AutoDeletionEntry
a) Character field = EntryToDelete (Form and Entry to delete)
b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$

I use the form and filter above to automaticly delete an entry from a 
button. From now on, all the delete entry occure from an action uses the 
form and filter state above. It works like a charm.

I would like to use the same form and filter (if possible) to delete my 
orphans. In fact, I was taking about creating a escalation job to detect my 
orphans in order to push the values (Form name and EntryID) to my 
AutoDeletionEntry form but I cannot get any generic way of managing all the 
forms at once.

Any suggestion?

Mathieu Pitre
IT Business Systems Analyst
CSC @ PWC

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


Re: ARSLIST AWARDS

2006-09-01 Thread Reiser, John J
Hey Axton, Congratulations.
 


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 Doug Blair
Sent: Thursday, August 31, 2006 9:28 PM
To: arslist@ARSLIST.ORG
Subject: ARSLIST AWARDS

ALMOST LIVE,

From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,
California

There are too many inside jokes, singing, dancing, Twinkie-hurling
people here that it is impossible to convey the true essence of the
camaraderie we all feel. So far we have parodies of Y-M-C-A
(A-R-S-LIST) and With A Little Help From My Friends (... From The
List). I think that I really shouldn't tell you more because that would
spoil it. You'll just have to get your boss to foot the bill next year!

AWARDS:

LONGEST THREAD: What Bugs You About Remedy? (84 posts)

WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
James Ward

BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
explained by incompetence / Matt Black

WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
McKenzie): AXTON GRAMS

...who was duly contacted by Dan on cell phone immediately, with
resounding hoots, cheers and thunderous applause!

Congratulations, Axton, and all the other ARSLIST winners!

Doug


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

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


ADM:OT:BUW:MVP:Congratulations to All!

2006-09-01 Thread Daniel Bloom
Just in the mood for prefixes/acronyms.

Thought I would mention in general terms, 
I have never given a vote by vote accounting,
(I do have them all archived however),
the voting was not close this year.

Not that there was a weak candidate
(not sure there has ever been anyone
that didn't deserve the nomination,
just others that did as well).

I think there was a feeling
that Axton has been in the running
for years, and this year was his.

This years BUW/RUG seemed busier
and more hopping than last year,
hope it continues.

The messages I am leaving with:
BSM is good, ITIL, BSM is good, ITIL, ITSM7,
get to ARSystem 7, and CMDB2.0 if you are on CMDB1.1,
ARSystem is the platform for them to build
the applications for you to use.

They are concentration on their cross platform
integrations using ARSystem as the workflow glue.

Oh, did I mention BSM and ITIL?

... Daniel

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


Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread Ron Gehring
**








You may want to call the airline first to
see if you are even allowed to carry a Twinkie on board. The chemical makeup
of those things may prevent you from being able to board the aircraft
;-)











From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, September 01, 2006
8:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Twinkie Experiments -
Friday Humor







Curious about all this discussion about
Twinkies, misi, please bring one or two home to Sweden, also a good test of
Twinkies capacityto keep the qualities during a long flight. L ars





-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED]On
Behalf Of Mark Blankenship
Sent: Friday, September 01, 2006
2:06 PM
To: arslist@ARSLIST.ORG
Subject: OT: Twinkie Experiments -
Friday Humor

** 



For Misi, having eaten his first twinkie.





A scientific analysis of the twinkie





http://www.twinkiesproject.com/

















Mark



__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___

Re: BMCWorld happenings

2006-09-01 Thread Olds, Kimberly M
**








Rick  I had the same problem 
but someone from support was able to help me get it to work. Here is what
support had me do.



Un-install RDB

Install Patch 1 of the AR 7 Admin tool

Install RDB



And that worked for me.







Kim Olds

Sr.
User Support Specialist - Help Desk

Anne
Arundel County Public Schools

Phone
410-222-5254

Fax
410-222-5611











From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook
Sent: Friday, September 01, 2006
10:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings





In v7, I have not been able to get RDP to
work at all. I have contacted support - it's an open issue.



Rick









From: Action
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, September 01, 2006
7:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings

** 



Yes, this was a mistake, Mars wes a great
product, I used it several days a week during development, and it saved hours
of time finding wf, unused menues, good for documentation and a lot more. And a
great support.I've not been able to even start RDP ...L ars





-Original Message-
From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cook
Sent: Friday, September 01, 2006
4:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings

** 

I totally agree with you, but have heard
nothing about enhancements to the RDP.



Rick









From: Action
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt
Sent: Thursday, August 31, 2006
11:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings

** 

Rick,



Has there been any mention of reviving
MasterARSuite? Or, at the very least, trashing RDP and replacing it with
something that really works? J 



Sorry to be biased, but I feel the RDP
replacing MasterARSuite was a bad ploy. It just doesnt compare.



Thanks!

Matt











From: Rick cook
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 31, 2006
11:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings





Really not all that much. They
seemed to be focusing on giving people (including themselves) more time to
assimilate, or be assimilated, into the ITSM 7 world. So there will be
more tools for managing the business and better connectivity between the
applications, but they didn't even mention a version 8 today, or some code name
for it.



Not even a projected due date for a next
versioncurious.



Rick









From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Gordon M. Frank
Sent: Thursday, August 31, 2006
6:04 PM
To: arslist@ARSLIST.ORG
Subject: BMCWorld happenings

** 

Hey all of you BMCWorld attendees!



Was anything new announced at the opening?



Web based Admin Tool maybe



Curious!

Gordon Frank



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 8/30/2006

__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___ 






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

Setup Dev Server

2006-09-01 Thread John Kelley
Hi List:  First time emailer.  Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0   64bit.
My tnsnames is set correctly to Dev Server and connection to remedb
listener.
The name of the DB is the same for Production and Dev.  Which is OK.  They
are on different servers.
When I'm setting up the Dev server running server.exe,  Its asks for SID
name and what type of install.  Upgrade, Overwrite or Shared.  I select
Upgrade because the DB out there is an exact copy of the Production having
all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System
database.
15:40:39 Installation terminating ... Original database server is intact
and accessible
15:40:39 Resolve the problem that causes the error (contact Technical
Support, if necessary)
15:40:40 -[ShowMsg]: Setup is rolling back directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request System
Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original
database is intact and accessible.

Anyboby have something similar.  Or suggestion.



John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA  02021
Mail Center 1W
781-737-3564

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


I3 and Remedy?

2006-09-01 Thread Tony Worthington
**

Has anyone integreated Remedy with the
I3 client?

Was this done out of the box
or did it require COM programming?


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

Re: RKM 7.0 is out

2006-09-01 Thread Chris Rom
Do you need to buy a licenses or can this be installed for testing ?

You mention '1 user'

Has anyone installed it yet ?


Rgds,

chris

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


Re: ARSLIST AWARDS

2006-09-01 Thread Tim Widowfield
Congrats, Axton!


--Tim 

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


Re: RKM 7.0 is out

2006-09-01 Thread Tony Worthington
**

I have it up and running... It
requries a database (seperate from Remedy) to store statistics, etc. I
have temporarily set up MySQL for this. Oracle, sybase, mssql are
also supported.

The directions (not the clearest) are
geared towards ServletExec ASAPI or Tomcat. Other jsp engines will
require enough knowledge to figure it out yourself. I
do have it running under ServletExec AS.

You do need to buy the product; the
1 user is just the text that shows on upgrade central. Licensing
is somewhat different from other apps as it isn't enforced (we do have
additional user licenses, but they're not applied or stored anywhere)

I can't speak as to whether it shows
in upgrade central if you don't have it on your license shelf -- probably
not.

hth,
tony


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






Chris Rom [EMAIL PROTECTED]

Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
09/01/2006 10:40 AM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Re: RKM 7.0 is out








Do you need to buy a licenses or can this be installed
for testing ?

You mention '1 user'

Has anyone installed it yet ?


Rgds,

chris

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


__20060125___This posting was submitted with HTML in it___

Re: ARSLIST AWARDS

2006-09-01 Thread Gidd Calden
Second and a great win for an awesome contributor !

Regards...Gidd 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield
Sent: Friday, September 01, 2006 8:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS

Congrats, Axton!


--Tim 


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

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


Re: ARSLIST AWARDS

2006-09-01 Thread Herb Partlow
Congrats Axton

Herb Partlow

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


Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread lars . j . pettersson
**



Hmm...is is really good forhuman beingsto eat those things 
...Maybegood for meI didn't attended the Conference this year ../L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Ron 
  GehringSent: Friday, September 01, 2006 4:46 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday 
  Humor** 
  
  

  
  You may want to call 
  the airline first to see if you are even allowed to carry a Twinkie on 
  board. The chemical makeup of those things may prevent you from being 
  able to board the aircraft ;-)
  
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 
  AMTo: 
  arslist@ARSLIST.ORGSubject: 
  Re: Twinkie Experiments - Friday Humor
  
  
  Curious about all 
  this discussion about Twinkies, misi, please bring one or two home to 
  Sweden, also a good test of 
  Twinkies capacityto keep the qualities during a long flight. L 
  ars
  
-Original 
Message-From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark 
BlankenshipSent: Friday, 
September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - 
Friday Humor
** 

For Misi, having eaten his first 
twinkie.

A scientific analysis of the 
twinkie

http://www.twinkiesproject.com/





Mark
__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___


Re: Pushing values to the CTM:People Form

2006-09-01 Thread Chris Rom
I have created about a dozen records and logged everything. The problem is 
that you must somehow emulate the menu selection that you would do manually 
during the escalation pushing LDAP data.

Remedy Support has only had some vague info and there is no documentation.

It isn't pretty nor is it perfect but it works with a few assumptions. I am 
using the streetAddress field from LDAP to cross-reference the Site Name in 
the ITSM Foundation.  Using this as the key, I implemented a custom 
Escalation to import and synch the user data and a subsequent custom Filter 
to emulate the Active Links and Active Link Guides that a normal Menu 
Selection action in the Site Name field of the CTM:People form would 
force.  I have also had to add a few LDAP related fields and set some 
additional default values in the CTM:People form.  The key assumptions are: 
1) the streetAddress values across the company are unique for each site 
(e.g. there can't be two 123 Main Streets, one in Austin and another in San 
Diego); 2) streetAddress is not NULL; and 3) there is an exact and direct 
one-to-one correspondence between the values of streetAddress in LDAP and 
Street Address in ITSM.


As always, if you feel this should be addressed in some type of whitepaper, 
please log an enhancement request on the web for this.

---

We are using Employee ID/Corporate ID as the common field between LDAP and 
CTM:People. I just can't believe that no one else is doing this yet ?

Any help would be appreciated.

Rgds,

Chris

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


Re: ITSM 7 Implementation Workshop RSMG-ITIW-0700

2006-09-01 Thread Chris Rom
I was able to register in the U.S. after the BMC EMEA Education dept. 
kicked me out of the Stockholm class because I did not have the CMDB 2.0 
pre-requisite. Interestingly the class-description has since been updated 
to read:

Note: In the EMEA region this course is only available to Alliance Partner 
consultants.

There were several changes in scheduling already. An October class at one 
of their partner sites in Clearwater, FL was cancelled, but now it looks 
like they added a second, concurrent, class in Columbia, MD from Sep. 18-
22. Kinda strange, but perhaps because of the great demand.

They had also closed an early Sep. class in Pleasanton, CA to the public in 
order to get their own people trained.

Chris

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


Re: BMCWorld happenings

2006-09-01 Thread Rick cook
**



I was on patch 1 - didn't help. Glad it helped 
you. I even tried a patch 2 .dll that support sent me. It made Sync 
Search DB work but still no RDP. I don't have that box anymore, so I guess 
it's a moot point.

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Olds, Kimberly 
MSent: Friday, September 01, 2006 8:03 AMTo: 
arslist@ARSLIST.ORGSubject: Re: BMCWorld 
happenings
** 




Rick  I had the same 
problem  but someone from support was able to help me get it to work. 
Here is what support had me do.

Un-install 
RDB
Install Patch 1 of the 
AR 7 Admin tool
Install 
RDB

And that worked for 
me.



Kim 
Olds
Sr. 
User Support Specialist - Help Desk
Anne 
Arundel County Public Schools
Phone 
410-222-5254
Fax 
410-222-5611




From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Friday, September 01, 2006 10:21 
AMTo: 
arslist@ARSLIST.ORGSubject: 
Re: BMCWorld happenings

In v7, I have not been 
able to get RDP to work at all. I have contacted support - it's an open 
issue.

Rick




From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, September 01, 2006 7:16 
AMTo: 
arslist@ARSLIST.ORGSubject: 
Re: BMCWorld happenings
** 

Yes, this was a 
mistake, Mars wes a great product, I used it several days a week during 
development, and it saved hours of time finding wf, unused menues, good for 
documentation and a lot more. And a great support.I've not been able to 
even start RDP ...L ars

  -Original 
  Message-From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick cookSent: Friday, September 01, 2006 4:10 
  PMTo: 
  arslist@ARSLIST.ORGSubject: 
  Re: BMCWorld happenings
  ** 
  I totally agree with 
  you, but have heard nothing about enhancements to the 
  RDP.
  
  Rick
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt ReinfeldtSent: Thursday, August 31, 2006 11:33 
  PMTo: 
  arslist@ARSLIST.ORGSubject: 
  Re: BMCWorld happenings
  ** 
  Rick,
  
  Has there been any 
  mention of reviving MasterARSuite? Or, at the very least, trashing RDP 
  and replacing it with something that really works? J 
  
  
  Sorry to be biased, 
  but I feel the RDP replacing MasterARSuite was a bad ploy. It just 
  doesnt compare.
  
  Thanks!
  Matt
  
  
  
  
  
  From: Rick 
  cook [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, August 31, 
  2006 11:35 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  
  Really not all that 
  much. They seemed to be focusing on giving people (including themselves) 
  more time to assimilate, or be assimilated, into the ITSM 7 world. So 
  there will be more tools for managing the business and better connectivity 
  between the applications, but they didn't even mention a version 8 today, or 
  some code name for it.
  
  Not even a projected 
  due date for a next versioncurious.
  
  Rick
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 
  PMTo: arslist@ARSLIST.ORGSubject: BMCWorld 
  happenings
  ** 
  Hey all of you 
  BMCWorld attendees!
  
  Was anything new 
  announced at the opening?
  
  Web based Admin Tool 
  maybe
  
  Curious!
  Gordon 
  Frank
  
  --No 
  virus found in this outgoing message.Checked by AVG Free 
  Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 
  8/30/2006
  __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___ 
__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___


Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread Rick cook
**



That would be an interesting ACADEMIC question - could they 
be made even more deadly to humans than they already are?
(disclaimer - I am NOT advocating in any way that someone 
should try to find out).

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron 
GehringSent: Friday, September 01, 2006 7:46 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday 
Humor
** 




You may want to call 
the airline first to see if you are even allowed to carry a Twinkie on 
board. The chemical makeup of those things may prevent you from being able 
to board the aircraft ;-)





From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 
AMTo: 
arslist@ARSLIST.ORGSubject: 
Re: Twinkie Experiments - Friday Humor


Curious about all this 
discussion about Twinkies, misi, please bring one or two home to 
Sweden, also a good test of Twinkies 
capacityto keep the qualities during a long flight. L 
ars

  -Original 
  Message-From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 
  PMTo: 
  arslist@ARSLIST.ORGSubject: 
  OT: Twinkie Experiments - Friday Humor
  ** 
  
  For Misi, having eaten his first 
  twinkie.
  
  A scientific analysis of the 
  twinkie
  
  http://www.twinkiesproject.com/
  
  
  
  
  
  Mark
  __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___


Re: BMCWorld happenings (RDP or no RDP?)

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: BMCWorld happenings (RDP or no RDP?)
**





Rick:

I'm glad we decided to not pick up this product to assist in our documentation efforts.

James McKenzie






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook
Sent: Friday, September 01, 2006 9:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings



** 
I was on patch 1 - didn't help. Glad it helped you. I even tried a patch 2 .dll that support sent me. It made Sync Search DB work but still no RDP. I don't have that box anymore, so I guess it's a moot point.


Rick





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Olds, Kimberly M
Sent: Friday, September 01, 2006 8:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings



** 


Rick - I had the same problem - but someone from support was able to help me get it to work. Here is what support had me do.




Un-install RDB


Install Patch 1 of the AR 7 Admin tool


Install RDB





And that worked for me.








Kim Olds


Sr. User Support Specialist - Help Desk


Anne Arundel County Public Schools


Phone 410-222-5254


Fax 410-222-5611





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick cook
Sent: Friday, September 01, 2006 10:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings





In v7, I have not been able to get RDP to work at all. I have contacted support - it's an open issue.





Rick








From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED]

Sent: Friday, September 01, 2006 7:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMCWorld happenings


** 


Yes, this was a mistake, Mars wes a great product, I used it several days a week during development, and it saved hours of time finding wf, unused menues, good for documentation and a lot more. And a great support. I've not been able to even start RDP ...L ars

 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick cook
 Sent: Friday, September 01, 2006 4:10 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: BMCWorld happenings


 ** 


 I totally agree with you, but have heard nothing about enhancements to the RDP.


 


 Rick


 


 


  From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Reinfeldt

 Sent: Thursday, August 31, 2006 11:33 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: BMCWorld happenings


 ** 


 Rick,


 


 Has there been any mention of reviving MasterARSuite? Or, at the very least, trashing RDP and replacing it with something that really works? J 

 


 Sorry to be biased, but I feel the RDP replacing MasterARSuite was a bad ploy. It just doesn't compare.


 


 Thanks!


 Matt


 




__20060125___This posting was submitted with HTML in it___

Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
**



Rick:

Well the local Funeral Parlor encourages the consumption of 
foodstufs like Twinkies. Why? They have to use less preservative (read the 
ingredients list and you will understand) in their embalming 
fluids.

And I really don't want a 'more deadly' Twinkie. They 
are just fine when I get them home (and that is very, very rare) from the 
store.

James McKenzie
L-3 GSI


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick 
cookSent: Friday, September 01, 2006 10:00 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday 
Humor
** 

That would be an interesting ACADEMIC question - could they 
be made even more deadly to humans than they already are?
(disclaimer - I am NOT advocating in any way that someone 
should try to find out).

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron 
GehringSent: Friday, September 01, 2006 7:46 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday 
Humor
** 




You may want to call 
the airline first to see if you are even allowed to carry a Twinkie on 
board. The chemical makeup of those things may prevent you from being able 
to board the aircraft ;-)





From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 
AMTo: 
arslist@ARSLIST.ORGSubject: 
Re: Twinkie Experiments - Friday Humor


Curious about all this 
discussion about Twinkies, misi, please bring one or two home to 
Sweden, also a good test of Twinkies 
capacityto keep the qualities during a long flight. L 
ars

  -Original 
  Message-From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark BlankenshipSent: Friday, September 01, 2006 2:06 
  PMTo: 
  arslist@ARSLIST.ORGSubject: 
  OT: Twinkie Experiments - Friday Humor
  ** 
  
  For Misi, having eaten his first 
  twinkie.
  
  A scientific analysis of the 
  twinkie
  
  http://www.twinkiesproject.com/
  
  
  
  
  
  Mark
  __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___


Re: ARSLIST AWARDS

2006-09-01 Thread Doug Blair
Rick,

Actually as I've heard the nuclear meltdown theory the survivors would be 
Twinkies, cockroaches, and portions of Cher.

D.

Friday!

___
Doug Blair
Remedy Skilled Professional
dougatblairingdotcom
+1-224-558-5462

.. Original Message ...
On Fri, 1 Sep 2006 07:05:09 -0700 Rick cook 

My own opinion is that in a nuclear holocaust, the only survivors would be
cockroaches and Twinkies.  And the roaches probably would still have more
sense than to eat the Twinkies.

Rick


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


Re: Setup Dev Server

2006-09-01 Thread Julie Rockwood

John,

Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a 
Windows 2000 box to ARS 6.3 on Windows 2003 box.  The Oracle 
9.2.0.4.0  64 bit was on an AIX box.  Remedy Support was pretty sure 
that it had something to do with the Oracle client.   Recently I 
noticed a note on the compatibility matrix that may provide a clue: 
Requires 32-bit Oracle 9iR2 database client for connecting to the 
Oracle database.  I'm not sure what I have.


I ended up upgrading the database from the old Win 2000 box, then 
connecting to the upgraded database from the 2003 box.  I then tested 
everything and have now been in production with it since May with no 
problems.


I do not know if I'll have a problem when it comes time to upgrade 
again, so I would love to hear if you find out what causes it.


Julie

At 09:30 AM 9/1/2006, you wrote:

Hi List:  First time emailer.  Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0   64bit.
My tnsnames is set correctly to Dev Server and connection to remedb
listener.
The name of the DB is the same for Production and Dev.  Which is OK.  They
are on different servers.
When I'm setting up the Dev server running server.exe,  Its asks for SID
name and what type of install.  Upgrade, Overwrite or Shared.  I select
Upgrade because the DB out there is an exact copy of the Production having
all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System
database.
15:40:39 Installation terminating ... Original database server is intact
and accessible
15:40:39 Resolve the problem that causes the error (contact Technical
Support, if necessary)
15:40:40 -[ShowMsg]: Setup is rolling back directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request System
Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original
database is intact and accessible.

Anyboby have something similar.  Or suggestion.



John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA  02021
Mail Center 1W
781-737-3564

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


---
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846

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


Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**





Julie:


All UNIX versions of ARS require that the associated 32 bit client libaries be installed and placed in the library path file before any 64 bit libraries. This may also be true for the 64 bit Windows systems.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Julie Rockwood
Sent: Friday, September 01, 2006 10:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


John,


Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure 

that it had something to do with the Oracle client. Recently I 
noticed a note on the compatibility matrix that may provide a clue: 
Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have.


I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems.

I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it.

Julie


At 09:30 AM 9/1/2006, you wrote:
Hi List: First time emailer. Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having 
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0 64bit.
My tnsnames is set correctly to Dev Server and connection to remedb 
listener.
The name of the DB is the same for Production and Dev. Which is OK. 
They are on different servers.
When I'm setting up the Dev server running server.exe, Its asks for 
SID name and what type of install. Upgrade, Overwrite or Shared. I 
select Upgrade because the DB out there is an exact copy of the 
Production having all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System 
database.
15:40:39 Installation terminating ... Original database server is 
intact and accessible
15:40:39 Resolve the problem that causes the error (contact Technical 
Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back 
directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request 
System Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original 
database is intact and accessible.

Anyboby have something similar. Or suggestion.



John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA 02021
Mail Center 1W
781-737-3564

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


---
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846


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




__20060125___This posting was submitted with HTML in it___

Re: Setup Dev Server

2006-09-01 Thread John Kelley
I can SQL plus on the Dev box to the DB.
I log in as ARAdmin default password.  Here is another catch.  If I leave
the tables space name the default (ARSYSTEM) it then goes to the Next
Screen to Upgrade.  I also tried to change the table space name to TABS and
suprisingly it allows me to the next screen also.  Shouldn't the DB only
have one Tablespace name?

Oh -- the Production server has the same version or Oracle.
John





   
 Julie Rockwood
 [EMAIL PROTECTED] 
 V To 
 Sent by: Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)Subject 
 [EMAIL PROTECTED] Re: Setup Dev Server
 ORG  
   
   
 09/01/2006 01:38  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




John,

Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a
Windows 2000 box to ARS 6.3 on Windows 2003 box.  The Oracle
9.2.0.4.0  64 bit was on an AIX box.  Remedy Support was pretty sure
that it had something to do with the Oracle client.   Recently I
noticed a note on the compatibility matrix that may provide a clue:
Requires 32-bit Oracle 9iR2 database client for connecting to the
Oracle database.  I'm not sure what I have.

I ended up upgrading the database from the old Win 2000 box, then
connecting to the upgraded database from the 2003 box.  I then tested
everything and have now been in production with it since May with no
problems.

I do not know if I'll have a problem when it comes time to upgrade
again, so I would love to hear if you find out what causes it.

Julie

At 09:30 AM 9/1/2006, you wrote:
Hi List:  First time emailer.  Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0   64bit.
My tnsnames is set correctly to Dev Server and connection to remedb
listener.
The name of the DB is the same for Production and Dev.  Which is OK.  They
are on different servers.
When I'm setting up the Dev server running server.exe,  Its asks for SID
name and what type of install.  Upgrade, Overwrite or Shared.  I select
Upgrade because the DB out there is an exact copy of the Production having
all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System
database.
15:40:39 Installation terminating ... Original database server is intact
and accessible
15:40:39 Resolve the problem that causes the error (contact Technical
Support, if necessary)
15:40:40 -[ShowMsg]: Setup is rolling back directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request
System
Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original
database is intact and accessible.

Anyboby have something similar.  Or suggestion.



John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA  02021
Mail Center 1W
781-737-3564

___

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

---
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846

___

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

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


Re: Deletion of non-reference entry mechanism

2006-09-01 Thread L. J. Head
Have you considered the possibility of preventing the orphans to begin
with?...If you create an AL that happens on Window Close where Operation =
CREATE that does a delete query on it's child tables base on the GUID you
have already generated...if you wanted to keep it dynamic...you could push
the Form and GUID to another form to create a new record and then have that
one do a lookup of which tables are children of the parent in question and
then have a filter do the delete query action. 


L. J. Head
Software Engineer
Remedy Approved Consultant
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Friday, September 01, 2006 8:33 AM
To: arslist@ARSLIST.ORG
Subject: Deletion of non-reference entry mechanism

Hi all,

I need your attention on this one.

I am becoming creative and I wonder if I should. I am trying to figure how
to automaticly delete the entries which have no more reference to their
parent. Let me explain the situation first. I have one form called Parent
and a second one called Child(Parent and child relation). First, once a user
opens a new Parent form I generate a GUID. I am using the GUID because the
user might create a child relation before they save the form(In that
specific case I could not transfer the RequestID). That way, I can transfer
it(GUID) to my child form in order to keep my reference. However, if my
users dont save their parent form and just cancel it I would like to delete
all the child entries which are now useless. Now that everyone understand
the situation what is the best approach taking in consideration that I have
multiple application and multiple parent and child relation. I would like to
avoid the redundancy in the way I develop this to come up with a generic
mechanism.

Here is what I did so far:

1- Form Name = AutoDeletionEntry
a) Character field = EntryToDelete (Form and Entry to delete)
b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$

I use the form and filter above to automaticly delete an entry from a
button. From now on, all the delete entry occure from an action uses the
form and filter state above. It works like a charm.

I would like to use the same form and filter (if possible) to delete my
orphans. In fact, I was taking about creating a escalation job to detect my
orphans in order to push the values (Form name and EntryID) to my
AutoDeletionEntry form but I cannot get any generic way of managing all the
forms at once.

Any suggestion?

Mathieu Pitre
IT Business Systems Analyst
CSC @ PWC


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

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


Re: Quick Report in MidTier?

2006-09-01 Thread Michiel Beijen
**
Is this button in you menu bar?There is no menu bar in mid-tier, but you can create a regular button on the form, and connect it to the active link that will run this report. If it is an ordinary plain-text remedy report it should run just fine on mid-tier. If it is a crystal report you would need to buy and install Crystal Reports Enterprise Server.
Regards,MichielOn 9/1/06, James Pifer [EMAIL PROTECTED] wrote:
From our client (6.3) we have a quick report button that prints out aticket and the specified fields so you get a report that has all theinformation from the fields in the report.What report options are there from midtier? Just printing from the
browser only gives you what you can see of course.Thanks,James___UNSUBSCRIBE or access ARSlist Archives at 
http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___


Re: Setup Dev Server

2006-09-01 Thread Grooms, Frederick W
Do you have the environment variables set up correctly?

 The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
9iR2 client. 
 ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. 
 ORACLE_SID and TWO_TASK set for your dev database. 
 TNS_ADMIN pointing to your tnsnames.ora file. 

Fred


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 10:31 AM
To: arslist@ARSLIST.ORG
Subject: Setup Dev Server

Hi List:  First time emailer.  Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0   64bit.
My tnsnames is set correctly to Dev Server and connection to remedb
listener.
The name of the DB is the same for Production and Dev.  Which is OK.
They are on different servers.
When I'm setting up the Dev server running server.exe,  Its asks for SID
name and what type of install.  Upgrade, Overwrite or Shared.  I select
Upgrade because the DB out there is an exact copy of the Production
having all the Data - I want the data in tact just to install the
Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System
database.
15:40:39 Installation terminating ... Original database server is intact
and accessible
15:40:39 Resolve the problem that causes the error (contact Technical
Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back
directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request
System Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original
database is intact and accessible.

Anyboby have something similar.  Or suggestion.

John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA  02021
Mail Center 1W
781-737-3564

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


Re: Difference in times - Oracle DB and forms

2006-09-01 Thread Michiel Beijen
**
I guess you are right on the DB time zone thing.This will make it a 'best practice' to set your server to GMT, especially if you are working in a global environment.It would be an enhancement request to let the server store gmt by default, regardless of the server timezone setting.
--MichielOn 9/1/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:
**









Michiel:

Huh? The time stored in the database is the same TZ as the ARS server from what I've been able to determine. However, that being set aside you do have a point. If you look at the time on the WUT, it will be the same as the user machine. But if you run an external process to the server, the time displayed will be the server's time and NOT the user local time, unless you use processes to grab the user's local time and then adjust for the difference between the two. This has resulted in some interesting time differences and a lot of work to correct. 


I would be very happy if the database did store times in UTC/GMT. It would make some of the things I do much easier.

James Mckenzie





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen

Sent: Friday, September 01, 2006 3:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Difference in times - Oracle DB and forms



** The Windows Remedy User tool takes your local timezone, which is set in the Windows Control Panel, into account. This includes daylight saving time if applicable as well.


The value stored in the database is GMT.


Does this help you?


Kind regards,


Michiel



On 9/1/06, Mark Bee [EMAIL PROTECTED] wrote: 


 Hi all,
 The HPD-HelpDesk fields display an actual time whilst
 after recalculating the database's time I got 2 hour delay. 
 It concerns all date fields (arrival time, resolved time, work in progres
 time...).
 
 When I check database time zone:
 select dbtimezone from dual;
 it gives me
 +02:00
 on the other Remedy server I got: 
 -07:00
 But still the difference is 2 hours.
 
 I think it's an Oracle issue, perhaps wrong configuration.
 Can anyone point me to the solvation.
 Tanks
 Mark B.
 
 ___ 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 



__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___


Re: ARSLIST AWARDS

2006-09-01 Thread Stefan Nerlich
**
Thank you everybody voting for ARInside. This ARSList Award is more then i expected when programming this application. I hope i will find some time in the near future to update and improve this application. I wouldt like to mention that many users of this list helped developing ARInside by sending me comments, reports and improvement suggestions. Thank you! Please feel free to contact me off-list for question and comments. And of course ... congratulations to the other winners.
Best regardsStefan Nerlich2006/9/1, Doug Blair [EMAIL PROTECTED]:
ALMOST LIVE,From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,CaliforniaThere are too many inside jokes, singing, dancing, Twinkie-hurling peoplehere that it is impossible to convey the true essence of the camaraderie we
all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With ALittle Help From My Friends (... From The List). I think that I reallyshouldn't tell you more because that would spoil it. You'll just have to get
your boss to foot the bill next year!AWARDS:LONGEST THREAD: What Bugs You About Remedy? (84 posts)WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)James Ward
BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can beexplained by incompetence / Matt BlackWORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'SousaBEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich
BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny WarrenMOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and JamesMcKenzie): AXTON GRAMS
...who was duly contacted by Dan on cell phone immediately, with resoundinghoots, cheers and thunderous applause!Congratulations, Axton, and all the other ARSLIST winners!Doug___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___


Re: ARSLIST AWARDS

2006-09-01 Thread Thomas J. Mutaffis

To the winners and contenders,

I wish to add my congratulations to all winners of the ARSList Awards and to 
the contenders as well. All you folks are very special and giving people and 
I, as most others, recognize and appreciate your efforts.


Warm regards and best wishes,

Tom

Thomas J. Mutaffis
Remedy Architect/Developer

- Original Message - 
From: Doug Blair [EMAIL PROTECTED]

Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Thursday, August 31, 2006 9:27 PM
Subject: ARSLIST AWARDS



ALMOST LIVE,


From the ARSLIST Awards Ceremony at BMC UserWorld, San Francisco,

California

There are too many inside jokes, singing, dancing, Twinkie-hurling people
here that it is impossible to convey the true essence of the camaraderie 
we

all feel. So far we have parodies of Y-M-C-A (A-R-S-LIST) and With A
Little Help From My Friends (... From The List). I think that I really
shouldn't tell you more because that would spoil it. You'll just have to 
get

your boss to foot the bill next year!

AWARDS:

LONGEST THREAD: What Bugs You About Remedy? (84 posts)

WAKE UP AND SMELL THE COFFEE AWARD: (for posting address in clear text)
James Ward

BEST PRACTICES TO LIVE BY: Never ascribe to malice that which can be
explained by incompetence / Matt Black

WORST ANALYSIS OF WORLD CUP OUTCOME: Joe D'Sousa

BEST 3rd PARTY UTILITY (Freeware): ARInside by Stefan Nerlich

BEST 3rd PARTY PRODUCT: Aeroprise (3rd year in a row)

BMC SOFTWARE EMPLOYEE: BEYOND THE CALL OF DUTY: Lenny Warren

MOST VALUABLE POSTER (chosen from Rick Cook, Axton Grams and James
McKenzie): AXTON GRAMS

...who was duly contacted by Dan on cell phone immediately, with 
resounding

hoots, cheers and thunderous applause!

Congratulations, Axton, and all the other ARSLIST winners!

Doug

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




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


Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**





John:


You can create as many tablespaces in one Oracle DB as you need. I would not, if possible, install the production and development tablespaces into the same Oracle DB instance.

I have two different versions of ARS installed on the same Oracle DB instance, however.


James Mckenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 10:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


I can SQL plus on the Dev box to the DB.
I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name?

Oh -- the Production server has the same version or Oracle.
John






 
 Julie Rockwood 
 [EMAIL PROTECTED] 
 V To 
 Sent by: Action arslist@ARSLIST.ORG 
 Request System cc 
 discussion 
 list(ARSList) Subject 
 [EMAIL PROTECTED] Re: Setup Dev Server 
 ORG 
 
 
 09/01/2006 01:38 
 PM 
 
 
 Please respond to 
 [EMAIL PROTECTED] 
 RG 
 
 





John,


Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure

that it had something to do with the Oracle client. Recently I
noticed a note on the compatibility matrix that may provide a clue:
Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database. I'm not sure what I have.


I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems.

I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it.

Julie


At 09:30 AM 9/1/2006, you wrote:
Hi List: First time emailer. Long time reader.

I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having 
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0 64bit.
My tnsnames is set correctly to Dev Server and connection to remedb 
listener.
The name of the DB is the same for Production and Dev. Which is OK. 
They are on different servers.
When I'm setting up the Dev server running server.exe, Its asks for 
SID name and what type of install. Upgrade, Overwrite or Shared. I 
select Upgrade because the DB out there is an exact copy of the 
Production having all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System 
database.
15:40:39 Installation terminating ... Original database server is 
intact and accessible
15:40:39 Resolve the problem that causes the error (contact Technical 
Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back 
directories
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request
System
Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original 
database is intact and accessible.

Anyboby have something similar. Or suggestion.



John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA 02021
Mail Center 1W
781-737-3564

___



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


---
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846


___


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


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




__20060125___This posting was submitted with HTML in it___

Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**





Fred:


I think the problem may be that the production and dev servers are pointing to the same Oracle DB Instance and that they are installed in two different tablespaces. This can lead to disaster of major proportions.

Solution:


Have DBA create a second instance on the Oracle DB for development. Or install Oracle on a second server (this is LEGAL per Oracle.)

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Friday, September 01, 2006 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


Do you have the environment variables set up correctly?


The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
9iR2 client. 
ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. 
ORACLE_SID and TWO_TASK set for your dev database. 
TNS_ADMIN pointing to your tnsnames.ora file. 


Fred



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 10:31 AM
To: arslist@ARSLIST.ORG
Subject: Setup Dev Server


Hi List: First time emailer. Long time reader.


I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0 64bit.
My tnsnames is set correctly to Dev Server and connection to remedb listener.
The name of the DB is the same for Production and Dev. Which is OK.
They are on different servers.
When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production having all the Data - I want the data in tact just to install the Server.

Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System database.
15:40:39 Installation terminating ... Original database server is intact and accessible
15:40:39 Resolve the problem that causes the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back directories

15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request System Server
15:40:41 -[ERROR]: AR System Database upgrade error. The original database is intact and accessible.


Anyboby have something similar. Or suggestion.


John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA 02021
Mail Center 1W
781-737-3564


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




__20060125___This posting was submitted with HTML in it___

Re: ITSM 7 SRM Error - RESOLVED

2006-09-01 Thread Orndorff, Greg
Title: RE: ITSM 7 SRM Error
**



BMC solved the issue, specifically Steven Duncan (very 
friendly and resourceful). In our 'Configure Incident Rules' form, we had 
'Create Request on Submit' set to "Yes" ("No" is the default). This 
essentially means (p. 340 of the ITSM Config Guide) that, for the entire company 
listed in the record, a separate request ticket (SRM form) is created for those 
companies (customers) that will be using the Requester Console. Well, we 
had created users in that same company that had no login id. The problem 
occurred because we were saying for that company, we were saying that the 
customer would have no access to the system yet wanted to create a request that 
they couldn't see anyway. So now that I understand the problem, I think 
Remedy should have somehow prevented this error from happening or at least 
provide a better error message. They could have made the login id field 
required if 'Create Request on Submit' was already set to "Yes". It would 
have saved a lot of time.

- Greg


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J 
C-E LCMC HQISEC/L3Sent: Thursday, August 31, 2006 3:44 
PMTo: arslist@ARSLIST.ORGSubject: Re: ITSM 7 SRM 
Error
** 

Greg:  Is 
this on one particular machine? If so, you may need to do some work, but I 
would start with uninstalling, powering down the machine (not just restarting) 
and then power it back up and install again. Sometimes systems get really 
confused if you don't restart between an uninstall and an install.
 James McKenzie  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Orndorff, Greg Sent: Thursday, August 31, 2006 3:30 
PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 SRM Error 
** Joe and Lars - Thanks for 
responding. I'm the user and have 'God' permissions. This 
application is out of the box with all the forms and workflow already created by 
BMC. We have not changed anything; we're just using/testing the 
application. I should have stated that my question is directed to just 
those who have installed ITSM 7.0, i.e. the non-Developers. I'm not real 
hopeful as it doesn't appear that a lot of people have ITSM 7.0 
installed.
 - Greg 
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Joe DeSouza Sent: Wednesday, August 30, 2006 5:45 
PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 SRM Error 
** Are you doing a Push Fields operation 
on submit either using a filter or an Active Link to another form that does not 
allow those users to write to the fields that your system is complaining about? 
Check the permissions of those users on that form...
 Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. 
- Original Message  From: Greg 
Orndorff [EMAIL PROTECTED] To: 
arslist@ARSLIST.ORG Sent: Wednesday, August 30, 2006 
8:30:46 PM Subject: ITSM 7 SRM Error 
When submitting an Incident, I and another user get the 
following message: "ARERR [326] Required field cannot be 
reset to a NULL value: SRM: RequestInterface_Create 
(100337) 
ARERR [326] Required field cannot be reset to a NULL value: SRM: 
RequestInterface_Create: Login ID" 
It prevents us from submitting the ticket. All other users 
are fine. At one point, I was able to submit 
Incidents. I've tried completely uninstalling and 
reinstalling to no avail. When we log in on other machines though, it works fine. I've logged a ticket with BMC and 
sent the filter log to them but haven't heard anything 
back. We're using Windows XP. Has anyone 
else experienced this error? 
Thanks, Greg Orndorff Pegasus Solutions 
___ 
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org/ 

__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___


Error sending email

2006-09-01 Thread Rafael Bertolini

Hi all!!!

I've created a SLA that sends an email after sometime a incident is 
created. It also sends an alert. The SLA is working, since I've got the 
alert, but no email was sent. In the AR System Email Error Logs, I've 
got this message


Invalid Addresses;
 nested exception is:
   class javax.mail.SendFailedException: 550 5.7.1 
[EMAIL PROTECTED]... Relaying denied


javax.mail.SendFailedException: Invalid Addresses;
 nested exception is:
   class javax.mail.SendFailedException: 550 5.7.1 
[EMAIL PROTECTED]... Relaying denied


   at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
   at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
   at 
com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
   at 
com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468)
   at 
com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)

   at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
   at java.lang.Thread.run(Thread.java:534)

It says invalid addresses, but the email [EMAIL PROTECTED] 
is correct (mine).


What else could be?

ARS 6.3
Solaris 8

TIA,
Rafael Bertolini

--

* Rafael Bertolini *
System Analyst
Ícaro Technologies
http://www.icaro.com.br *Work:* +55 19 3731 8308
*E-mail:* [EMAIL PROTECTED]

*Fax:* +55 19 3731 8304
/
A informação transmitida destina-se apenas à pessoa ou entidade a quem 
foi endereçada e pode conter informação confidencial, legalmente 
protegida e para conhecimento exclusivo do destinatário. Se o leitor 
desta advertência não for o seu destinatário, fica ciente de que sua 
leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso 
a mensagem tenha sido recebida por engano, favor comunicar ao remetente 
e apagar o texto do computador. Este ambiente está sujeito a monitoramento.


//The information transmitted is intended only for the person or entity 
to which it is addressed and may contain confidential and/or privileged 
material. Any review, retransmission, dissemination or other use of, or 
taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited. If you 
received this in error, please contact the sender and delete the 
material from any computer. This environment is subject to monitoring. /


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


Re: ARSLIST AWARDS - For Dan

2006-09-01 Thread Herb Partlow
**










Let us not
forget to thank Dan for the endless hours and time

he dedicates all year long to keeping the ARSLIST up and running



And 



for all his efforts year after year for pulling together

the stat, the gifts and the entertainment to make the ARSList

Awards a hit!!





Thank
You Dan for all your hard work year after year!!





Herb Partlow

President/CEO

IB Technical Consulting, Inc.

(O) 408-253-0344

(F) 408-253-0344

(C) 408-309-5316

[EMAIL PROTECTED]

http://www.ibtechnicalconsulting.com










__20060125___This posting was submitted with HTML in it___


Re: ARSLIST AWARDS - PHOTOS

2006-09-01 Thread Carl Reenus

Where are all the photos?

_
Search from any web page with powerful protection. Get the FREE Windows Live 
Toolbar Today!   http://get.live.com/toolbar/overview


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


Re: Setup Dev Server

2006-09-01 Thread Grooms, Frederick W
Title: RE: Setup Dev Server
**



He said they were on 2 different 
servers


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J 
C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 
PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev 
Server
** 

Fred: 
I think the problem may be that the production and dev servers 
are pointing to the same Oracle DB Instance and that they are installed in two 
different tablespaces. This can lead to disaster of major 
proportions.
Solution: 
Have DBA create a second instance on the Oracle DB for 
development. Or install Oracle on a second server (this is LEGAL per 
Oracle.)
James McKenzie  
-Original Message- From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Grooms, Frederick W Sent: Friday, September 01, 2006 
11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server 
Do you have the environment variables set up correctly? 

The 32 bit Oracle 9iR2 client in the path before your 64 
bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. 
ORACLE_SID and TWO_TASK set for your dev database. 
TNS_ADMIN pointing to your tnsnames.ora file. 

Fred 
-Original Message- From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
John Kelley Sent: Friday, September 01, 2006 10:31 
AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server 
Hi List: First time emailer. Long time 
reader. 
I'm trying to setup our Dev Box(Windows 2003sp1) with AR 
6.3. Having errors upgrading an existing DB. We 
took a copy of production DB, and placed it on a different oracle 
Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb 
listener. The name of the DB is the same for Production 
and Dev. Which is OK. They are on different 
servers. When I'm setting up the Dev server running 
server.exe, Its asks for SID name and what type of install. Upgrade, 
Overwrite or Shared. I select Upgrade because the DB out there is an exact 
copy of the Production having all the Data - I want the data in tact just to 
install the Server.
Here is the Error 15:40:39 An error was 
encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact 
and accessible 15:40:39 Resolve the problem that causes 
the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: 
Setup is rolling back directories
15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request 
System Server 15:40:41 -[ERROR]: AR System 
Database upgrade error. The original database is intact and accessible. 

Anyboby have something similar. Or suggestion. 
John Kelley Help Desk Analyst 
130 Royall Street Canton, MA 
02021 Mail Center 1W 781-737-3564 
___ 
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
__20060125___This posting was submitted with HTML in 
it___
__20060125___This posting was submitted with HTML in it___


Re: Error sending email

2006-09-01 Thread Axton Grams
What MTA are you using (e.g., sendmail) and what is the from address
configured in the AR System Email Mailbox Configuration form?

Try to do a telnet session to your MTA using smtp (port 25) and see if
you can send the message.  See
http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for
instructions on having a conversation with your smtp server.

If you still receive the smtp 550 it's because relaying to address x
(probably outside domains, most common configuration) is not allowed by
your MTA.

Axton Grams

Rafael Bertolini wrote:
 Hi all!!!
 
 I've created a SLA that sends an email after sometime a incident is
 created. It also sends an alert. The SLA is working, since I've got the
 alert, but no email was sent. In the AR System Email Error Logs, I've
 got this message
 
 Invalid Addresses;
  nested exception is:
class javax.mail.SendFailedException: 550 5.7.1
 [EMAIL PROTECTED]... Relaying denied
 
 javax.mail.SendFailedException: Invalid Addresses;
  nested exception is:
class javax.mail.SendFailedException: 550 5.7.1
 [EMAIL PROTECTED]... Relaying denied
 
at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
at
 com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
at
 com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468)
 
at
 com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)
at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
at java.lang.Thread.run(Thread.java:534)
 
 It says invalid addresses, but the email [EMAIL PROTECTED]
 is correct (mine).
 
 What else could be?
 
 ARS 6.3
 Solaris 8
 
 TIA,
 Rafael Bertolini
 

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


Re: Setup Dev Server

2006-09-01 Thread Axton Grams
What problem is there with using the same instance with different
schemas?  We have one server with 4 arsystem schemas in a single
instance, not to mention that are dozens of other schemas in the
instance not being used for Remedy.

Using the same tablespace will be a problem if you try and do a fresh
install because the arserver installer is flawed in the sense that it
drops whatever tablespace you install arserver to and recreates it.

Creating another instance has a lot of overhead associated with it (two
sets of processes, two sga's, etc.)

If the db server has enough hardware to fulfill the software's requests
you should not have a problem sharing an instance.

Axton Grams

Grooms, Frederick W wrote:
 **
 He said they were on 2 different servers
 
 
 *From:* Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC
 HQISEC/L3
 *Sent:* Friday, September 01, 2006 1:41 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 
 Fred:
 
 I think the problem may be that the production and dev servers are
 pointing to the same Oracle DB Instance and that they are installed in
 two different tablespaces.  This can lead to disaster of major proportions.
 
 Solution:
 
 Have DBA create a second instance on the Oracle DB for development.  Or
 install Oracle on a second server (this is LEGAL per Oracle.)
 
 James McKenzie
  
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
 Sent: Friday, September 01, 2006 11:17 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server
 
 Do you have the environment variables set up correctly?
 
  The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
 9iR2 client.
  ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client.
  ORACLE_SID and TWO_TASK set for your dev database.
  TNS_ADMIN pointing to your tnsnames.ora file.
 
 Fred
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley
 Sent: Friday, September 01, 2006 10:31 AM
 To: arslist@ARSLIST.ORG
 Subject: Setup Dev Server
 
 Hi List:  First time emailer.  Long time reader.
 
 I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
 errors upgrading an existing DB.
 We took a copy of production DB, and placed it on a different oracle
 Server. Oracle 9.2.0.4.0   64bit.
 My tnsnames is set correctly to Dev Server and connection to remedb
 listener.
 The name of the DB is the same for Production and Dev.  Which is OK.
 They are on different servers.
 When I'm setting up the Dev server running server.exe,  Its asks for SID
 name and what type of install.  Upgrade, Overwrite or Shared.  I select
 Upgrade because the DB out there is an exact copy of the Production
 having all the Data - I want the data in tact just to install the Server.
 
 Here is the Error
 15:40:39 An error was encountered during the upgrade of the AR System
 database.
 15:40:39 Installation terminating ... Original database server is intact
 and accessible
 15:40:39 Resolve the problem that causes the error (contact Technical
 Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back
 directories
 
 15:40:40 Setup is rolling back the directories.
 15:40:41 ServiceName not found. Using Default: Remedy Action Request
 System Server
 15:40:41 -[ERROR]: AR System Database upgrade error. The original
 database is intact and accessible.
 
 Anyboby have something similar.  Or suggestion.
 
 John Kelley
 Help Desk Analyst
 130 Royall Street
 Canton, MA  02021
 Mail Center 1W
 781-737-3564
 
 ___
 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 __20060125___This posting was submitted with HTML in
 it_20060125___This posting was submitted with
 HTML in it___

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


Re: ARSLIST AWARDS - For Dan

2006-09-01 Thread Julie Rockwood
**


I'll second that!
He even keeps us in line to keep the list from becoming free-for-all - a
thankless job.
THANKS DAN!!
At 01:07 PM 9/1/2006, you wrote:
** 

Let us not forget to
thank Dan for the endless hours and time
he dedicates all year long to keeping the ARSLIST up and running

And 

for all his efforts year after year for pulling together
the stat, the gifts and the entertainment to make the ARSList
Awards a hit!!



Thank You Dan for all your hard work year after year!!


Herb Partlow
President/CEO
IB Technical Consulting, Inc.
(O) 408-253-0344
(F) 408-253-0344
(C) 408-309-5316
[EMAIL PROTECTED]

http://www.ibtechnicalconsulting.com


__20060125___This posting was submitted with
HTML in it___ 

__20060125___This posting was submitted with HTML in it___


Re: Error sending email

2006-09-01 Thread Tony Worthington
**

Rafael -

Are you able to manually send an email
through the Email Messages form to your address?

Sound like this is more of a mail server configuration error than a Remedy
one.

[EMAIL PROTECTED]... Relaying
denied

You could also try telnetting to your
SMTP server and testing.

http://www.yuki-onna.co.uk/email/smtp.html

hth,
tony
-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-6125





Rafael Bertolini [EMAIL PROTECTED]

Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
09/01/2006 01:59 PM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Error sending email








Hi all!!!

I've created a SLA that sends an email after sometime a incident is 
created. It also sends an alert. The SLA is working, since I've got the

alert, but no email was sent. In the AR System Email Error Logs, I've 
got this message

Invalid Addresses;
 nested exception is:
  class javax.mail.SendFailedException: 550 5.7.1 
[EMAIL PROTECTED]... Relaying denied
 
javax.mail.SendFailedException: Invalid Addresses;
 nested exception is:
  class javax.mail.SendFailedException: 550 5.7.1 
[EMAIL PROTECTED]... Relaying denied

  at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
  at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
  at 
com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
  at 
com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468)
  at 
com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)
  at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
  at java.lang.Thread.run(Thread.java:534)

It says invalid addresses, but the email [EMAIL PROTECTED]

is correct (mine).

What else could be?

ARS 6.3
Solaris 8

TIA,
Rafael Bertolini

-- 


* Rafael Bertolini *
System Analyst
Ícaro Technologies
http://www.icaro.com.br  
  *Work:* +55 19 3731 8308
*E-mail:* [EMAIL PROTECTED]

*Fax:* +55 19 3731 8304
/
A informação transmitida destina-se apenas à pessoa ou entidade a quem

foi endereçada e pode conter informação confidencial, legalmente 
protegida e para conhecimento exclusivo do destinatário. Se o leitor 
desta advertência não for o seu destinatário, fica ciente de que sua 
leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso

a mensagem tenha sido recebida por engano, favor comunicar ao remetente

e apagar o texto do computador. Este ambiente está sujeito a monitoramento.

//The information transmitted is intended only for the person or entity

to which it is addressed and may contain confidential and/or privileged

material. Any review, retransmission, dissemination or other use of, or

taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited. If you 
received this in error, please contact the sender and delete the 
material from any computer. This environment is subject to monitoring.
/

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


__20060125___This posting was submitted with HTML in it___

Re: Error sending email

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Error sending email
**





Rafael:


The error message is coming back from your mail server. Is this server the same server that sends you your mail?
What platform are you running your mail server on and which MTA are you using?


James Mckenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rafael Bertolini
Sent: Friday, September 01, 2006 11:59 AM
To: arslist@ARSLIST.ORG
Subject: Error sending email


Hi all!!!


I've created a SLA that sends an email after sometime a incident is created. It also sends an alert. The SLA is working, since I've got the alert, but no email was sent. In the AR System Email Error Logs, I've got this message

Invalid Addresses;
 nested exception is:
 class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied

javax.mail.SendFailedException: Invalid Addresses;
 nested exception is:
 class javax.mail.SendFailedException: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied


 at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
 at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
 at
com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
 at
com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule.java:1468)
 at
com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)
 at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
 at java.lang.Thread.run(Thread.java:534)


It says invalid addresses, but the email [EMAIL PROTECTED] is correct (mine).


What else could be?


ARS 6.3
Solaris 8


TIA,
Rafael Bertolini


-- 


 * Rafael Bertolini *
System Analyst
Ícaro Technologies
http://www.icaro.com.br  *Work:* +55 19 3731 8308
*E-mail:* [EMAIL PROTECTED]


*Fax:* +55 19 3731 8304
/
A informação transmitida destina-se apenas à pessoa ou entidade a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação, distribuição ou cópia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto do computador. Este ambiente está sujeito a monitoramento.

//The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This environment is subject to monitoring. /

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




__20060125___This posting was submitted with HTML in it___

Re: Deletion of non-reference entry mechanism

2006-09-01 Thread Mathieu Pitre

I dont see how that would work (you
could push
the Form and GUID to another form to create a new record and then have
that
one do a lookup of which tables are children of the parent in question
and
then have a filter do the delete query action. )

How dont see how it would work because
I cannot lookup at the different forms dynamically in the same escalation.
Unless I am wrong but here is what I was thinking about:

Push 3 values in the OrphansToDelete
form

1- The GUID
2- The parent form name
3- The child form name

The problem is that I cannot use a generic
way of querying on the proper form. I would need to do a SQL query but
the table names vs the remedy schema are not nesserary the same. Can I
get the real oracle table name from the Remedy schema name.
I would then use the returned value to create an SQL query dynamically.
>From there I will know if the entry is a real orphan or not.

I need your help guys!
 
Mathieu Pitre

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



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







L. J. Head
[EMAIL PROTECTED] 
Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
01/09/2006 02:12 PM



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG


cc



Subject
Re: Deletion of non-reference entry
mechanism








Have you considered the possibility of preventing
the orphans to begin
with?...If you create an AL that happens on Window Close where Operation
=
CREATE that does a delete query on it's child tables base on
the GUID you
have already generated...if you wanted to keep it dynamic...you could push
the Form and GUID to another form to create a new record and then have
that
one do a lookup of which tables are children of the parent in question
and
then have a filter do the delete query action. 


L. J. Head
Software Engineer
Remedy Approved Consultant
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Friday, September 01, 2006 8:33 AM
To: arslist@ARSLIST.ORG
Subject: Deletion of non-reference entry mechanism

Hi all,

I need your attention on this one.

I am becoming creative and I wonder if I should. I am trying to figure
how
to automaticly delete the entries which have no more reference to their
parent. Let me explain the situation first. I have one form called Parent
and a second one called Child(Parent and child relation). First, once a
user
opens a new Parent form I generate a GUID. I am using the GUID because
the
user might create a child relation before they save the form(In that
specific case I could not transfer the RequestID). That way, I can transfer
it(GUID) to my child form in order to keep my reference. However, if my
users dont save their parent form and just cancel it I would like to delete
all the child entries which are now useless. Now that everyone understand
the situation what is the best approach taking in consideration that I
have
multiple application and multiple parent and child relation. I would like
to
avoid the redundancy in the way I develop this to come up with a generic
mechanism.

Here is what I did so far:

1- Form Name = AutoDeletionEntry
a) Character field = EntryToDelete (Form and Entry to delete)
b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$

I use the form and filter above to automaticly delete an entry from a
button. From now on, all the delete entry occure from an action uses the
form and filter state above. It works like a charm.

I would like to use the same form and filter (if possible) to delete my
orphans. In fact, I was taking about creating a escalation job to detect
my
orphans in order to push the values (Form name and EntryID) to my
AutoDeletionEntry form but I cannot get any generic way of managing all
the
forms at once.

Any suggestion?

Mathieu Pitre
IT Business Systems Analyst
CSC @ PWC


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

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

Re: Error sending email

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Error sending email
**





Axton:


You just about hit the nail on the head. However, I've seen mail servers (MTA) that are setup to allow local delivery only where this error (SMTP 550) happens. The fix is to reconfigure the MTA to allow delivery to a limited set of addresses only.

Also, thanks for the wiki page for MTA conversations. It's filed away.


James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams
Sent: Friday, September 01, 2006 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Error sending email


What MTA are you using (e.g., sendmail) and what is the from address configured in the AR System Email Mailbox Configuration form?

Try to do a telnet session to your MTA using smtp (port 25) and see if you can send the message. See http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for instructions on having a conversation with your smtp server.

If you still receive the smtp 550 it's because relaying to address x (probably outside domains, most common configuration) is not allowed by your MTA.

Axton Grams


Rafael Bertolini wrote:
 Hi all!!!
 
 I've created a SLA that sends an email after sometime a incident is 
 created. It also sends an alert. The SLA is working, since I've got 
 the alert, but no email was sent. In the AR System Email Error Logs, 
 I've got this message
 
 Invalid Addresses;
 nested exception is:
 class javax.mail.SendFailedException: 550 5.7.1 
 [EMAIL PROTECTED]... Relaying denied
 
 javax.mail.SendFailedException: Invalid Addresses; nested exception 
 is:
 class javax.mail.SendFailedException: 550 5.7.1 
 [EMAIL PROTECTED]... Relaying denied
 
 at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
 at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
 at
 com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
 at
 com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule
 .java:1468)
 
 at
 com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)
 at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
 at java.lang.Thread.run(Thread.java:534)
 
 It says invalid addresses, but the email [EMAIL PROTECTED] 
 is correct (mine).
 
 What else could be?
 
 ARS 6.3
 Solaris 8
 
 TIA,
 Rafael Bertolini
 




__20060125___This posting was submitted with HTML in it___

FIXED: arimportcmd on Escalation

2006-09-01 Thread Den Fong
**



I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the elsetab and it ran.

Den

** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 12:58 PM 
Den:  Why are you doing things the hard way?  Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so:
 /opt/ar/bin/somescript_exists_here.sh  In the script the first line is:  #!/bin/sh # some comments here. Commands # Yet another comment  It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it)  James McKenzie L-3 GSI  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation 
** Okay I thought back to basics was the best way to do this.  So I ran the process:  /bin/env  /export/home/remps/import/env.txt  To get anything out, and nothing.** 
 PC Wai [EMAIL PROTECTED] 8/30/2006 11:44 AM  
Hi Den,  Does the mapping file directory (-d) or some files has the right file path? When the AR System shells out the process, it may not have the same system environment as you run it interactively.
 Regards PC Wai 
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation 
** I'm running the script as a user, this is the generic Remedy system user on the sun box. This is the user that owns the arsystem and files.
 The script has Read  Execute by everyone, the .arm file has read by everyone and so does the .csv file.   ** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 10:17 AM  
Den:  This may sound stupid, but are you running Remedy ARS as root or another user? If it is another user, make sure that user has access to the entire file structure of at least read/execute and that the user has read and execute permissions. Of course, this does not apply if the user is root.
James Mckenzie  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd on Escalation 
** Okay I tried that and still no luck without the @@:  Den  ** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 10:03 AM  
Den:  Loose the two at signs and the colon. All escalations run against the server and never against the client.  James McKenzie  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Wednesday, August 30, 2006 9:01 AM To: arslist@ARSLIST.ORG Subject: arimportcmd on Escalation 
** Hey Guys  I'm trying to get s script to execute on an escalation, the scipt works fine if we execute it via a shell, but not through an escalation.
In the escalation I have it as a run process :  @@:/export/home/remps/import/smsimport.sh  Which doesn't do anything.  Any ideas?  Den  
__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___
__20060125___This posting was submitted with HTML in it___

Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**



Fred:

(Wacking self on head). Thanks.

Now the next question is how did they duplicate the 
database? There are variables in the Remedy metadata that will error out 
if they did a physical vice ARExport/ARImport move of data. This may be 
causing the problem. I tried a physical move from one tablespace to 
another on the same server and Oracle would not let me. 


James Mckenzie
L-3 GSI


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick 
WSent: Friday, September 01, 2006 12:12 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Setup Dev Server
** 

He said they were on 2 different 
servers


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J 
C-E LCMC HQISEC/L3Sent: Friday, September 01, 2006 1:41 
PMTo: arslist@ARSLIST.ORGSubject: Re: Setup Dev 
Server
** 

Fred: 
I think the problem may be that the production and dev servers 
are pointing to the same Oracle DB Instance and that they are installed in two 
different tablespaces. This can lead to disaster of major 
proportions.
Solution: 
Have DBA create a second instance on the Oracle DB for 
development. Or install Oracle on a second server (this is LEGAL per 
Oracle.)
James McKenzie  
-Original Message- From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Grooms, Frederick W Sent: Friday, September 01, 2006 
11:17 AM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server 
Do you have the environment variables set up correctly? 

The 32 bit Oracle 9iR2 client in the path before your 64 
bit Oracle 9iR2 client. ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. 
ORACLE_SID and TWO_TASK set for your dev database. 
TNS_ADMIN pointing to your tnsnames.ora file. 

Fred 
-Original Message- From: Action 
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
John Kelley Sent: Friday, September 01, 2006 10:31 
AM To: arslist@ARSLIST.ORG Subject: Setup Dev Server 
Hi List: First time emailer. Long time 
reader. 
I'm trying to setup our Dev Box(Windows 2003sp1) with AR 
6.3. Having errors upgrading an existing DB. We 
took a copy of production DB, and placed it on a different oracle 
Server. Oracle 9.2.0.4.0 64bit. My tnsnames is set correctly to Dev Server and connection to remedb 
listener. The name of the DB is the same for Production 
and Dev. Which is OK. They are on different 
servers. When I'm setting up the Dev server running 
server.exe, Its asks for SID name and what type of install. Upgrade, 
Overwrite or Shared. I select Upgrade because the DB out there is an exact 
copy of the Production having all the Data - I want the data in tact just to 
install the Server.
Here is the Error 15:40:39 An error was 
encountered during the upgrade of the AR System database. 15:40:39 Installation terminating ... Original database server is intact 
and accessible 15:40:39 Resolve the problem that causes 
the error (contact Technical Support, if necessary) 15:40:40 -[ShowMsg]: 
Setup is rolling back directories
15:40:40 Setup is rolling back the directories. 15:40:41 ServiceName not found. Using Default: Remedy Action Request 
System Server 15:40:41 -[ERROR]: AR System 
Database upgrade error. The original database is intact and accessible. 

Anyboby have something similar. Or suggestion. 
John Kelley Help Desk Analyst 
130 Royall Street Canton, MA 
02021 Mail Center 1W 781-737-3564 
___ 
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
__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___


Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**





Axton:


What I seen was that the tablespace was the same name, which with two servers is not a problem. I've delt with one admin, here on the list, that had installed the production and development to the same server, same tablespace. Disaster was the result.

As far as running two or more servers against the same instance. No problem. However, you will need to size the PGA and SGA to accomidate the additional load. 

I prefer what John has done. Two servers, two instances and never the two shall meet.


And if you are covered by SarbOx, you may have to do things this way.


James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams
Sent: Friday, September 01, 2006 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy.

Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it.

Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.)


If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance.

Axton Grams


Grooms, Frederick W wrote:
 **
 He said they were on 2 different servers
 
 --
 --
 *From:* Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC
 HQISEC/L3
 *Sent:* Friday, September 01, 2006 1:41 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 
 Fred:
 
 I think the problem may be that the production and dev servers are 
 pointing to the same Oracle DB Instance and that they are installed in 
 two different tablespaces. This can lead to disaster of major proportions.
 
 Solution:
 
 Have DBA create a second instance on the Oracle DB for development. 
 Or install Oracle on a second server (this is LEGAL per Oracle.)
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
 Sent: Friday, September 01, 2006 11:17 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server
 
 Do you have the environment variables set up correctly?
 
 The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
 9iR2 client.
 ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client.
 ORACLE_SID and TWO_TASK set for your dev database.
 TNS_ADMIN pointing to your tnsnames.ora file.
 
 Fred
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
 Sent: Friday, September 01, 2006 10:31 AM
 To: arslist@ARSLIST.ORG
 Subject: Setup Dev Server
 
 Hi List: First time emailer. Long time reader.
 
 I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having 
 errors upgrading an existing DB.
 We took a copy of production DB, and placed it on a different oracle
 Server. Oracle 9.2.0.4.0 64bit.
 My tnsnames is set correctly to Dev Server and connection to remedb 
 listener.
 The name of the DB is the same for Production and Dev. Which is OK.
 They are on different servers.
 When I'm setting up the Dev server running server.exe, Its asks for 
 SID name and what type of install. Upgrade, Overwrite or Shared. I 
 select Upgrade because the DB out there is an exact copy of the 
 Production having all the Data - I want the data in tact just to install the Server.
 
 Here is the Error
 15:40:39 An error was encountered during the upgrade of the AR System 
 database.
 15:40:39 Installation terminating ... Original database server is 
 intact and accessible
 15:40:39 Resolve the problem that causes the error (contact Technical 
 Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back 
 directories
 
 15:40:40 Setup is rolling back the directories.
 15:40:41 ServiceName not found. Using Default: Remedy Action Request 
 System Server
 15:40:41 -[ERROR]: AR System Database upgrade error. The original 
 database is intact and accessible.
 
 Anyboby have something similar. Or suggestion.
 
 John Kelley
 Help Desk Analyst
 130 Royall Street
 Canton, MA 02021
 Mail Center 1W
 781-737-3564
 
 __
 _
 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 __20060125___This posting was submitted with HTML 
 in it_20060125___This posting was submitted 
 with HTML in it___



Re: Error sending email

2006-09-01 Thread Axton Grams
Yea, doing the conversations manually will tell you where the problem
is, and the docs/google for whatever MTA is in use should tell you how
to fix it.

Axton

McKenzie, James J C-E LCMC HQISEC/L3 wrote:
 **
 
 Axton:
 
 You just about hit the nail on the head.  However, I've seen mail
 servers (MTA) that are setup to allow local delivery only where this
 error (SMTP 550) happens. The fix is to reconfigure the MTA to allow
 delivery to a limited set of addresses only.
 
 Also, thanks for the wiki page for MTA conversations.  It's filed away.
 
 James McKenzie
 L-3 GSI
  
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams
 Sent: Friday, September 01, 2006 12:12 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Error sending email
 
 What MTA are you using (e.g., sendmail) and what is the from address
 configured in the AR System Email Mailbox Configuration form?
 
 Try to do a telnet session to your MTA using smtp (port 25) and see if
 you can send the message.  See
 http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol for
 instructions on having a conversation with your smtp server.
 
 If you still receive the smtp 550 it's because relaying to address x
 (probably outside domains, most common configuration) is not allowed by
 your MTA.
 
 Axton Grams
 
 Rafael Bertolini wrote:
 Hi all!!!

 I've created a SLA that sends an email after sometime a incident is
 created. It also sends an alert. The SLA is working, since I've got
 the alert, but no email was sent. In the AR System Email Error Logs,
 I've got this message

 Invalid Addresses;
  nested exception is:
class javax.mail.SendFailedException: 550 5.7.1
 [EMAIL PROTECTED]... Relaying denied

 javax.mail.SendFailedException: Invalid Addresses;  nested exception
 is:
class javax.mail.SendFailedException: 550 5.7.1
 [EMAIL PROTECTED]... Relaying denied

at com.sun.mail.smtp.SMTPTransport.rcptTo(SMTPTransport.java:848)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:323)
at

 com.remedy.arsys.emaildaemon.SenderModule.sendMessage(SenderModule.java:74)
at
 com.remedy.arsys.emaildaemon.CreatorModule.createMessage(CreatorModule
 .java:1468)

at
 com.remedy.arsys.emaildaemon.CreatorModule.doWork(CreatorModule.java:360)
at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
at java.lang.Thread.run(Thread.java:534)

 It says invalid addresses, but the email [EMAIL PROTECTED]
 is correct (mine).

 What else could be?

 ARS 6.3
 Solaris 8

 TIA,
 Rafael Bertolini

 
 __20060125___This posting was submitted with HTML in
 it___

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


Re: FIXED: arimportcmd on Escalation

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: FIXED: arimportcmd on Escalation
**





Den:

Now you explan this. I've seen this before where the escalation would not run because there was no qualification. Strange as it should run if there is no qualification every time.


James McKenzie






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong
Sent: Friday, September 01, 2006 12:35 PM
To: arslist@ARSLIST.ORG
Subject: FIXED: arimportcmd on Escalation



** 
I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the else tab and it ran.


Den

** 



 McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] 8/30/2006 12:58 PM 



Den: 
 
Why are you doing things the hard way? 
 
Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so:


/opt/ar/bin/somescript_exists_here.sh 
 
In the script the first line is: 
 
#!/bin/sh 
# some comments here. 
Commands 
# Yet another comment 
 
It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it) 
 
James McKenzie 
L-3 GSI 




__20060125___This posting was submitted with HTML in it___

Re: Deletion of non-reference entry mechanism

2006-09-01 Thread L. J. Head
**



My approach is a preventative measure instead of an 
escalation type of thing

Setup:
Form with fields 'Parent' and 'Child'
This form keeps track of al of your parent child 
relationships...which forms have children forms and the sort
Form with fields 'Parent GUID' and'Parent 
Form'
This will be the temp holding place to store your 'delete 
these things' record

You then would have an AL that fires on close of any window 
that is in submit mode...maybe doing some sort of flag field that fires on after 
submit that indicates if a submit occurred and not fire if one did. This 
AL could do a push to your 'delete these things' form with its GUID and 
$SCHEMA$. That form might have a table field that lists all of the 
children forms of that $SCHEMA$ value that was submitted. This filter does 
a loop through the table and issues a delete query to each form in the table for 
the GUID submitted.

I have never performed this type of thing so I'm just 
coding off the top of my head...and it might not work quite like I'm 
thinking...but it should cause any submit window that is closed without a submit 
to cause each of its children windows to be purged of any children records that 
were created immediately...instead of doing it in an 
escalation

Feel free to contact me off list if you have questions 
about what I'm thinking about

L. J. HeadSoftware EngineerRemedy 
Approved Consultant 



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu 
PitreSent: Friday, September 01, 2006 1:32 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Deletion of non-reference entry 
mechanism
I dont see how that would work 
(you could pushthe Form and GUID to another form to 
create a new record and then have thatone do a lookup of which tables are 
children of the parent in question andthen have a filter do the delete query 
action. ) How dont see how it would work because I cannot lookup at 
the different forms dynamically in the same escalation. Unless I am wrong but 
here is what I was thinking about: Push 3 values in the OrphansToDelete form 1- The GUID 2- 
The parent form name 3- The child form 
name The problem is that I cannot 
use a generic way of querying on the proper form. I would need to do a SQL query 
but the table names vs the remedy schema are not nesserary the same. Can I get 
the "real" oracle table name from the Remedy schema name. I would then use the 
returned value to create an SQL query dynamically. From there I will know if the 
entry is a real orphan or not. I 
need your help guys!
Mathieu Pitre IT Business 
Systems AnalystProduction OperationComputer Sciences CorporationPratt  Whitney 
Canada, Plant 1Sametime: Mathieu Pitreoffice: 450-647-8008 
x7030This 
is a PRIVATE message. If you are not the intended recipient, please delete 
without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: 
Regardless of content, this e-mail shall not operate to bind CSC to any order or 
other contract unless pursuant to explicit written agreement or government 
initiative expressly permitting the use of e-mail for such 
purpose.

  
  
"L. J. Head" 
  [EMAIL PROTECTED] Sent 
  by: "Action Request System discussion list(ARSList)" 
  arslist@ARSLIST.ORG 
  01/09/2006 02:12 PM 
  


  
Please respond 
toarslist@ARSLIST.ORG

  


  
To
  arslist@ARSLIST.ORG 

  
cc
  

  
Subject
  Re: Deletion of non-reference entry 
mechanism
  


  
  Have you considered the possibility of preventing the orphans to 
beginwith?...If you create an AL that happens on Window Close where 
Operation ="CREATE" that does a delete query on it's child tables base on 
the GUID youhave already generated...if you wanted to keep it dynamic...you 
could pushthe Form and GUID to another form to create a new record and then 
have thatone do a lookup of which tables are children of the parent in 
question andthen have a filter do the delete query action. L. J. 
HeadSoftware EngineerRemedy Approved Consultant-Original 
Message-From: Action Request System discussion 
list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu 
PitreSent: Friday, September 01, 2006 8:33 AMTo: 
arslist@ARSLIST.ORGSubject: Deletion of non-reference entry 
mechanismHi all,I need your attention on this one.I am 
becoming creative and I wonder if I should. I am trying to figure howto 
automaticly delete the entries which have 

Re: Setup Dev Server

2006-09-01 Thread Axton Grams
I duplicate databases infrequently.  The metadata (actlink_open, email
mailbox, etc.) are fairly easy to clean with pl/sql.  Copying between
different tablespaces is a little tricky due to LOB storage, but not
impossible.  You have to manually create the tables with modified DDL
(specifying lob storage) that have LOBs prior to running the imp of the
dmp file to ensure the LOBS go to the right tablespace during import.

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527

The main reason we do it this way is because this method puts the margin
for error/reliability and the time required to complete are in our favor.

Axton Grams

McKenzie, James J C-E LCMC HQISEC/L3 wrote:
 **
 Fred:
  
 (Wacking self on head).  Thanks.
  
 Now the next question is how did they duplicate the database?  There are
 variables in the Remedy metadata that will error out if they did a
 physical vice ARExport/ARImport move of data.  This may be causing the
 problem.  I tried a physical move from one tablespace to another on the
 same server and Oracle would not let me. 
  
 James Mckenzie
 L-3 GSI
 
 
 *From:* Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W
 *Sent:* Friday, September 01, 2006 12:12 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 He said they were on 2 different servers
 
 
 *From:* Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC
 HQISEC/L3
 *Sent:* Friday, September 01, 2006 1:41 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 
 Fred:
 
 I think the problem may be that the production and dev servers are
 pointing to the same Oracle DB Instance and that they are installed in
 two different tablespaces.  This can lead to disaster of major proportions.
 
 Solution:
 
 Have DBA create a second instance on the Oracle DB for development.  Or
 install Oracle on a second server (this is LEGAL per Oracle.)
 
 James McKenzie
  
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
 Sent: Friday, September 01, 2006 11:17 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server
 
 Do you have the environment variables set up correctly?
 
  The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
 9iR2 client.
  ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client.
  ORACLE_SID and TWO_TASK set for your dev database.
  TNS_ADMIN pointing to your tnsnames.ora file.
 
 Fred
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley
 Sent: Friday, September 01, 2006 10:31 AM
 To: arslist@ARSLIST.ORG
 Subject: Setup Dev Server
 
 Hi List:  First time emailer.  Long time reader.
 
 I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
 errors upgrading an existing DB.
 We took a copy of production DB, and placed it on a different oracle
 Server. Oracle 9.2.0.4.0   64bit.
 My tnsnames is set correctly to Dev Server and connection to remedb
 listener.
 The name of the DB is the same for Production and Dev.  Which is OK.
 They are on different servers.
 When I'm setting up the Dev server running server.exe,  Its asks for SID
 name and what type of install.  Upgrade, Overwrite or Shared.  I select
 Upgrade because the DB out there is an exact copy of the Production
 having all the Data - I want the data in tact just to install the Server.
 
 Here is the Error
 15:40:39 An error was encountered during the upgrade of the AR System
 database.
 15:40:39 Installation terminating ... Original database server is intact
 and accessible
 15:40:39 Resolve the problem that causes the error (contact Technical
 Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back
 directories
 
 15:40:40 Setup is rolling back the directories.
 15:40:41 ServiceName not found. Using Default: Remedy Action Request
 System Server
 15:40:41 -[ERROR]: AR System Database upgrade error. The original
 database is intact and accessible.
 
 Anyboby have something similar.  Or suggestion.
 
 John Kelley
 Help Desk Analyst
 130 Royall Street
 Canton, MA  02021
 Mail Center 1W
 781-737-3564
 
 ___
 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 __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 

Re: Setup Dev Server

2006-09-01 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Setup Dev Server
**





Axton:


Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name.

James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams
Sent: Friday, September 01, 2006 12:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import.

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527


The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor.

Axton Grams


McKenzie, James J C-E LCMC HQISEC/L3 wrote:
 **
 Fred:
 
 (Wacking self on head). Thanks.
 
 Now the next question is how did they duplicate the database? There 
 are variables in the Remedy metadata that will error out if they did a 
 physical vice ARExport/ARImport move of data. This may be causing the 
 problem. I tried a physical move from one tablespace to another on 
 the same server and Oracle would not let me.
 
 James Mckenzie
 L-3 GSI
 
 --
 --
 *From:* Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
 *Sent:* Friday, September 01, 2006 12:12 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 He said they were on 2 different servers
 
 --
 --
 *From:* Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] *On Behalf Of *McKenzie, James J C-E LCMC
 HQISEC/L3
 *Sent:* Friday, September 01, 2006 1:41 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server
 
 **
 
 Fred:
 
 I think the problem may be that the production and dev servers are 
 pointing to the same Oracle DB Instance and that they are installed in 
 two different tablespaces. This can lead to disaster of major proportions.
 
 Solution:
 
 Have DBA create a second instance on the Oracle DB for development. 
 Or install Oracle on a second server (this is LEGAL per Oracle.)
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
 Sent: Friday, September 01, 2006 11:17 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server
 
 Do you have the environment variables set up correctly?
 
 The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
 9iR2 client.
 ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client.
 ORACLE_SID and TWO_TASK set for your dev database.
 TNS_ADMIN pointing to your tnsnames.ora file.
 
 Fred
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
 Sent: Friday, September 01, 2006 10:31 AM
 To: arslist@ARSLIST.ORG
 Subject: Setup Dev Server
 
 Hi List: First time emailer. Long time reader.
 
 I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having 
 errors upgrading an existing DB.
 We took a copy of production DB, and placed it on a different oracle
 Server. Oracle 9.2.0.4.0 64bit.
 My tnsnames is set correctly to Dev Server and connection to remedb 
 listener.
 The name of the DB is the same for Production and Dev. Which is OK.
 They are on different servers.
 When I'm setting up the Dev server running server.exe, Its asks for 
 SID name and what type of install. Upgrade, Overwrite or Shared. I 
 select Upgrade because the DB out there is an exact copy of the 
 Production having all the Data - I want the data in tact just to install the Server.
 
 Here is the Error
 15:40:39 An error was encountered during the upgrade of the AR System 
 database.
 15:40:39 Installation terminating ... Original database server is 
 intact and accessible
 15:40:39 Resolve the problem that causes the error (contact Technical 
 Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back 
 directories
 
 15:40:40 Setup is rolling back the directories.
 15:40:41 ServiceName not found. Using Default: Remedy Action Request 
 System Server
 15:40:41 -[ERROR]: AR System Database upgrade error. The original 
 database is intact and accessible.
 
 Anyboby have something similar. Or suggestion.
 
 John Kelley
 

Re: Setup Dev Server

2006-09-01 Thread Axton Grams
That's why it's better to look up the schema ids and field ids in your
workflow based on the form/field names, then use var substitution in
your direct sql (e.g. select C$fieldid1$ from T$schemaid1$ where
C$fieldid2$ = 'some literal value or field').

Axton Grams

McKenzie, James J C-E LCMC HQISEC/L3 wrote:
 **
 
 Axton:
 
 Definitely the way to copy a tablespace from one server to another.  I
 had forgotten about copying the LOB space, too.  I tend to use
 Export/Import from Remedy rather than do this at the DB level.  However,
 this does not scale well if you are working with Direct SQL and
 reference tables by name.
 
 James McKenzie
 L-3 GSI
  
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams
 Sent: Friday, September 01, 2006 12:53 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server
 
 I duplicate databases infrequently.  The metadata (actlink_open, email
 mailbox, etc.) are fairly easy to clean with pl/sql.  Copying between
 different tablespaces is a little tricky due to LOB storage, but not
 impossible.  You have to manually create the tables with modified DDL
 (specifying lob storage) that have LOBs prior to running the imp of the
 dmp file to ensure the LOBS go to the right tablespace during import.
 
 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:378418239571#16075038165527
 
 
 The main reason we do it this way is because this method puts the margin
 for error/reliability and the time required to complete are in our favor.
 
 Axton Grams
 
 McKenzie, James J C-E LCMC HQISEC/L3 wrote:
 **
 Fred:
 
 (Wacking self on head).  Thanks.
 
 Now the next question is how did they duplicate the database?  There
 are variables in the Remedy metadata that will error out if they did a
 physical vice ARExport/ARImport move of data.  This may be causing the
 problem.  I tried a physical move from one tablespace to another on
 the same server and Oracle would not let me.
 
 James Mckenzie
 L-3 GSI

 --
 --
 *From:* Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W
 *Sent:* Friday, September 01, 2006 12:12 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server

 **
 He said they were on 2 different servers

 --
 --
 *From:* Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC
 HQISEC/L3
 *Sent:* Friday, September 01, 2006 1:41 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Setup Dev Server

 **

 Fred:

 I think the problem may be that the production and dev servers are
 pointing to the same Oracle DB Instance and that they are installed in
 two different tablespaces.  This can lead to disaster of major
 proportions.

 Solution:

 Have DBA create a second instance on the Oracle DB for development. 
 Or install Oracle on a second server (this is LEGAL per Oracle.)

 James McKenzie
 

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
 Sent: Friday, September 01, 2006 11:17 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Setup Dev Server

 Do you have the environment variables set up correctly?

  The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle
 9iR2 client.
  ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client.
  ORACLE_SID and TWO_TASK set for your dev database.
  TNS_ADMIN pointing to your tnsnames.ora file.

 Fred


 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley
 Sent: Friday, September 01, 2006 10:31 AM
 To: arslist@ARSLIST.ORG
 Subject: Setup Dev Server

 Hi List:  First time emailer.  Long time reader.

 I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3.  Having
 errors upgrading an existing DB.
 We took a copy of production DB, and placed it on a different oracle
 Server. Oracle 9.2.0.4.0   64bit.
 My tnsnames is set correctly to Dev Server and connection to remedb
 listener.
 The name of the DB is the same for Production and Dev.  Which is OK.
 They are on different servers.
 When I'm setting up the Dev server running server.exe,  Its asks for
 SID name and what type of install.  Upgrade, Overwrite or Shared.  I
 select Upgrade because the DB out there is an exact copy of the
 Production having all the Data - I want the data in tact just to
 install the Server.

 Here is the Error
 15:40:39 An error was encountered during the upgrade of the AR System
 database.
 15:40:39 Installation terminating ... Original database server is
 intact and accessible
 15:40:39 Resolve the problem that causes the error (contact Technical
 Support, if necessary) 15:40:40 -[ShowMsg]: Setup is rolling back
 directories

 15:40:40 Setup is 

Re: ITSM 7.0 Rolled Out?

2006-09-01 Thread Chris Rom
Greg,

I am running the full ITSM 7.0 suite on a dev server right now and we are 
in the first phase of a rollout project.

My first impressions are pretty good, besides the initiall problems during 
the install.

What kind of bugs have you found and did you submit them to BMC ?
You can expect some bugs with a x.0 version, which is why most people will 
wait for 7.1
This is still pretty new, even for Remedy support and consultants.

You are right, there is quite a bit more configuration involved and hardly 
any 'sample' data, like there was in 6.3 and previous versions.

I would also like to know if there are already any ITSM implementations in 
production, which I doubt since the ITSM apps have only been out for just 
over a month unless someone already did a lot of work during the Early 
Access program.

Rgds,

Chris

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


Re: FIXED: arimportcmd on Escalation

2006-09-01 Thread Den Fong
**


James

I tried that, and the 1=1 but neither works. Because there are no records, the system won't run anything on the if side.

Den

** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 9/1/2006 2:42 PM 
Den:

That explains a lot. Why not just run the escalation as a timed event with no run-if statement and see if that works?I think that if this does not work the old '1=1' should force it to work.

James McKenzie


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Den FongSent: Friday, September 01, 2006 1:28 PMTo: arslist@ARSLIST.ORGSubject: Re: FIXED: arimportcmd on Escalation
** 

Okay

I found out why now, there is a process that runs just before this one and it removes all the records from this form. So therefore when the escalation runs there are no records and does not execute the if tab and uses the else tab instead.

Den

** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 9/1/2006 1:44 PM 
Den:  Now you explan this. I've seen this before where the escalation would not run because there was no qualification. Strange as it should run if there is no qualification every time.
James McKenzie  
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Den Fong Sent: Friday, September 01, 2006 12:35 PM To: arslist@ARSLIST.ORG Subject: FIXED: arimportcmd on Escalation 
** I have it fixed now, hopefully. The strange thing was I had this RUN PROCESS on if tab of the escalation which doesn't have a qualification. However I moved it the else tab and it ran.
Den  ** 
 "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] 8/30/2006 12:58 PM  
Den:  Why are you doing things the hard way?  Just call the script from the Escalation. Make sure the script calls a valid shell. Make sure that the application can be run by the REMEDY user (be it root or someone else.) I have run scripts from ALs, Filters and Escalations and they all worked after I massaged the command line like so:
/opt/ar/bin/somescript_exists_here.sh  In the script the first line is:  #!/bin/sh # some comments here. Commands # Yet another comment  It appears that your script is either improperly written (and if you send it to me off-list I will try to look at it)  James McKenzie L-3 GSI __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___


Re: ARSLIST AWARDS - For Dan

2006-09-01 Thread Daniel Bloom
Apparently not entirely thankless :-)

The plaque's are fedexed in the winner's directions.

I have included some of this years pin and Magnetic Words.

Patrick (Zandi): In case you hear, I used Zandiish more
than once this year, I promise not to again for at least 12 months.

Has anyone mentioned that the Next BUW has been scheduled?
October 29th, 2007 (in other words, 14 months from now).

Place not mentioned yet, perhaps in the closing session

 Daniel

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


Re: ARSLIST AWARDS - For Dan

2006-09-01 Thread Wallace, Kelvin
Daniel,

I did not hear anyone speak of a location, but I am guessing -- being
late October -- maybe Orlando???  Celebration would, of course, be in
Halloween attire...

Kelvin

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel Bloom
Sent: Friday, September 01, 2006 6:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

Apparently not entirely thankless :-)

The plaque's are fedexed in the winner's directions.

I have included some of this years pin and Magnetic Words.

Patrick (Zandi): In case you hear, I used Zandiish more
than once this year, I promise not to again for at least 12 months.

Has anyone mentioned that the Next BUW has been scheduled?
October 29th, 2007 (in other words, 14 months from now).

Place not mentioned yet, perhaps in the closing session

 Daniel


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

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


Re: ARSLIST AWARDS - For Dan

2006-09-01 Thread Rick cook
**



A double Amen from me!

Rick


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie 
RockwoodSent: Friday, September 01, 2006 12:21 PMTo: 
arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For 
Dan
** I'll second that!He even keeps us in line to keep the list 
from becoming free-for-all - a thankless job.THANKS DAN!!At 
01:07 PM 9/1/2006, you wrote:
** Let us not forget to thank Dan for the 
  endless hours and timehe dedicates all year long to keeping the ARSLIST up 
  and runningAnd for all his efforts year after year 
  for pulling togetherthe stat, the gifts and the entertainment to make the 
  ARSListAwards a hit!!Thank You Dan for all your hard work year after 
  year!!Herb 
  PartlowPresident/CEOIB Technical Consulting, Inc.(O) 
  408-253-0344(F) 408-253-0344(C) 
  408-309-5316[EMAIL PROTECTED]http://www.ibtechnicalconsulting.com__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___


Remedy ARS Developer Needed in NJ

2006-09-01 Thread Kathleen Nagurka
Hi All! 

I currently have a permanent opening in the Parsippany, NJ area for a 
Senior Remedy Developer. I've outlined the position below. Please feel 
free to call or email me should you have any questions.

Enjoy your weekend!

•Must have three plus years experience of ARS development and support.
•Intimately involved in Problem Management and Change Managements methods 
and services.
•Project Management and Requirements Analysis skills.
•Technically proficient in Perl, Sybase, HTML, Java, Unix, NT, Crystal 
Reports or other reporting tool, and most Remedy off-the-shelf products.
•Strong experience in being the technical lead for multiple projects.
•Must have excellent problem solving skills.
•Must be detail oriented and capable of writing technical documentation.
•Must be able to work under pressure and in a fast paced environment.
•Strong computer aptitude with Microsoft Office.
•Strong interpersonal skills.

Kathleen
Kathco Recruiting
973-257-8890

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