date:20080116

There is a lot more performance tuning to do but it was amazing the
difference this made.  I was curious why SQL Server wasn't taking
advantage of the extra memory on the system.  All of this is explained
in the SQL Server 2005 online help.

Craig Carter
 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr
OC-ALC/ITMA
Sent: Wednesday, January 16, 2008 6:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Resolved: Server Configuration Recommendations

Bravo Craig. Thanks for posting the solution to the 'net, as many people
are running SQL 2k5 with Windows Server 2k3. I hope this will help
someone else out as well.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane
Sent: Tuesday, January 15, 2008 5:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Resolved: Server Configuration Recommendations

Thanks, Craig!

- Original Message 
From: Craig Carter [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, January 15, 2008 3:26:19 PM
Subject: Resolved: Server Configuration Recommendations

I wanted to follow-up and provide some changes I made that had a HUGE
impact on performance and resolved the majority of our problem.

Although we had 16GB on the system, the majority of it was not being
used and performance monitor showed everything was waiting for disk.
Average disk queue length was long and the bar never dropped off 100.
The SQL Server service had allocated memory/virtual memory up to 1.7 GB
but was holding steady at that amount.

We're running Windows 2003 Enterprise (32-bit) and the documentation
stated SQL Server 2005 will not exceed the virtual memory setting on
Windows Server 2003 (32-bit) unless you enable AWE memory allocation.
There was also an enable lock pages in memory option that I enabled
for the account SQL Server was running under--but it appears this may
not be needed unless you are running under Windows 2000 or Windows XP.
The setting by default is off in SQL Server 2005.  I also updated the
Virtual memory settings on the server to system managed which
increased it by 800%.

After restarting SQL Server, the SQL Server service memory usage dropped
from 1.7GB to 130M and the paging file jumped from about 2.6 GB to
almost 7 GB.  The processors are two to three times busier now but still
only averaging about 30%.  The physical memory in use jumped by 4 GB and
you can tell SQL Server is now going well beyond the virtual server
limits and 4GB limits imposed by the operating system.

In summary, the database was not being allowed to exceed the virtual
memory limits and 4GB operating system limit shared with everything
else.  Now that is has plenty of breathing room, it's flying right
along.  There is still a lot of tweaking to do but enabling AWE
allocation made a huge difference.

Thanks for all your suggestions.  If you are running SQL Server 2005 on
a Windows Server 32-bit version with more than 4GB, check this option
out.

Craig Carter



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


 


Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs


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


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

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

Re: Search shows only results list

2008-01-16 Thread Reiser, John J

Dwayne,
If you use a Preference server check her entry in the AR System User
Preference form.
On the General tab there is a check box under the On Search settings to
Show Result List Only

If this is set by default for her she will get that condition even after
a reinstall of the WUT.
When it goes away it could be because of other forms default views
changing the settings.

HTH, 


John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me 
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Wednesday, January 16, 2008 8:20 AM
To: arslist@ARSLIST.ORG
Subject: Search shows only results list

Hello Everyone,

We have a user who runs searches on the AST:ComputerSystem form (Asset
Management Module).  In the morning when she queries the form she sees
only the results list, not a split panel.  She can double-click on any
of the rows and see the entry in a separate panel, but can't get the
split panel.  No other users have reported this problem, and this user
doesn't see it in other forms.  By afternoon it has gone away, and
searches return a split panel.

She reinstalled the WUT but that didn't help.  

Any suggestions?  (Gremlins maybe?)

(ARS and WUT 7.1, RH Linux AR Server)

Dwayne Martin
James Madison University

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

Re: Q: Server Configuration Recommendations

Perhaps but page 19 of the performance tuning whitepaper recommends 3 times the 
number of processors for Fast and 5 times the processors for List (24 and 40).  
We could also have as many as 400 users and also some web users so this is 
intended to cover future growth.

Craig Carter
 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Tuesday, January 15, 2008 10:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: Server Configuration Recommendations

Is not 24 fast and 40 list an overkill with 80-100 users?

--
Jarl

On Jan 15, 2008 3:41 PM, Craig Carter [EMAIL PROTECTED] wrote:
 **



 All,



 We're running into some performance problems recently.  I upgraded the
 server a few days ago (operating system, database, CPUs, memory, queues,
 etc, and it hasn't helped much.  Basically, it takes longer to search and
 create tickets as more and more people log in (as expected) but the server
 has plenty of available CPU, plenty of memory, and plenty of bandwidth so it
 appears there is a bottleneck somewhere.



 8 CPUs

 16GB Memory

 Windows Server 2003 Enterprise

 SQL Server 2005 Enterprise

 ARS v7.0.1 P5 (CSS and custom apps-no ITSM)

 24 Fast, 40 List



 It flies with about 40 people, becomes sluggish with 80, and gets real slow
 with 100.  I would expect this system to be able to handle a much larger
 load.  Since the running CPU usage and disk usage is fairly low, I'm looking
 for advice.



 Everything is currently installed on the same server and on the same drive
 (although these are raid drives).  Is it possible we're seeing contention
 over disk resources and I/O?  Any advice on determining where the bottleneck
 is or from people administering a large number of users?  How much advantage
 would be gained by running the AR Server on another drive or box separate
 from the database?  Is it reasonable to expect to only get 100 concurrent
 users (using the WUT) on a server of this size?



 Looking in the docs and whitepapers but any advice would be helpful since
 this is impacting us now.



 Craig Carter



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

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

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

Re: Search shows only results list

2008-01-16 Thread Dwayne Martin

Thanks, John, but her User Preference entry has Show Result List Only set to 
No.

Dwayne

 Original message 
Date: Wed, 16 Jan 2008 08:28:55 -0500
From: Reiser, John J [EMAIL PROTECTED]  
Subject: Re: Search shows only results list  
To: arslist@ARSLIST.ORG

Dwayne,
If you use a Preference server check her entry in the AR System User
Preference form.
On the General tab there is a check box under the On Search settings to
Show Result List Only

If this is set by default for her she will get that condition even after
a reinstall of the WUT.
When it goes away it could be because of other forms default views
changing the settings.

HTH, 

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Wednesday, January 16, 2008 8:20 AM
To: arslist@ARSLIST.ORG
Subject: Search shows only results list

Hello Everyone,

We have a user who runs searches on the AST:ComputerSystem form (Asset
Management Module).  In the morning when she queries the form she sees
only the results list, not a split panel.  She can double-click on any
of the rows and see the entry in a separate panel, but can't get the
split panel.  No other users have reported this problem, and this user
doesn't see it in other forms.  By afternoon it has gone away, and
searches return a split panel.

She reinstalled the WUT but that didn't help.  

Any suggestions?  (Gremlins maybe?)

(ARS and WUT 7.1, RH Linux AR Server)

Dwayne Martin
James Madison University

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

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

Re: Search shows only results list

2008-01-16 Thread Opela, Gary L Contr OC-ALC/ITMA

Dwayne, if she is using a user preference, you might try deleting her
entry in AR System User Preferences, as I've seen these some how cause
some really weird issues.

I had this same issue a few months ago, but for the life of me I cannot
remember what fixed it. It might have just resolved itself, I honestly
don't remember.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Wednesday, January 16, 2008 7:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Search shows only results list

Thanks, John, but her User Preference entry has Show Result List Only
set to No.

Dwayne

 Original message 
Date: Wed, 16 Jan 2008 08:28:55 -0500
From: Reiser, John J [EMAIL PROTECTED]  
Subject: Re: Search shows only results list  
To: arslist@ARSLIST.ORG

Dwayne,
If you use a Preference server check her entry in the AR System User
Preference form.
On the General tab there is a check box under the On Search settings to
Show Result List Only

If this is set by default for her she will get that condition even
after
a reinstall of the WUT.
When it goes away it could be because of other forms default views
changing the settings.

HTH, 


John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me 
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Wednesday, January 16, 2008 8:20 AM
To: arslist@ARSLIST.ORG
Subject: Search shows only results list

Hello Everyone,

We have a user who runs searches on the AST:ComputerSystem form (Asset
Management Module).  In the morning when she queries the form she sees
only the results list, not a split panel.  She can double-click on any
of the rows and see the entry in a separate panel, but can't get the
split panel.  No other users have reported this problem, and this user
doesn't see it in other forms.  By afternoon it has gone away, and
searches return a split panel.

She reinstalled the WUT but that didn't help.  

Any suggestions?  (Gremlins maybe?)

(ARS and WUT 7.1, RH Linux AR Server)

Dwayne Martin
James Madison University

___

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


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

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

problems with running user/admin tool on windows Vista basic

2008-01-16 Thread Remedy

Hi all,
   I have ARS 7.1 installed successfully on Windows Vista with SQL 2005
Express as the DB on my laptop (localhost). The problem is with running user
and admin tool. Every time i start the user/admin tool, it goes through the
authentication process successfully, but immediately after that it crashes
with the error msg shown below: I would like to know if any of you have seen
this problem before, if so then whats the resolution? I have the firewall
turned off, but still getting these error msgs. I dont see any error msg in
the server logs, they are clean and it states that the server has started
successfully, so there is no problem with the server (ARS).
*

Problem signature:
*

Problem Event Name: APPCRASH

Application Name: aruser.exe

Application Version: 7.0.1.6

Application Timestamp: 4740b744

Fault Module Name: MSVCR71.dll

Fault Module Version: 7.10.7031.4

Fault Module Timestamp: 45c28fb4

Exception Code: c005

Exception Offset: b1d8

OS Version: 6.0.6000.2.0.0.768.2

Locale ID: 16393

Additional Information 1: 9a5e

Additional Information 2: c148024282dec0b2e1e9461e351a89d5

Additional Information 3: cd88

Additional Information 4: f13fdec1adae3bb6133e957c8ed77cfb

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

Problem with E-mail Engine Upgrade from 5.1.2 to 6.3

2008-01-16 Thread Shrestha, Manjari R.

Hello all,

 

I had no problem upgrading Remedy 5.1.2 to 6.3 except the e-mail engine.
I read the previous thread where it was said that I will have to
manually delete all the e-mail forms. I did this but still was not able
to upgrade. Please advise how I should go about upgrading the e-mail
engine. Thanks in advance.

 

 

Thanks!

 

Manjari R. Shrestha

 

  

 


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

running a data transfer in eie causes an active link error 1603.

2008-01-16 Thread jmchugh

Hi All,

I am configuring an integration between Configuration Management 7.0.3
and CMDB 2.0.1 patch 4, The CM database is oracle 9i release 2 on HPUX
11i. The CMS server is on a windows 2003 server. The Master Tuner is
on a Windows 2003 server. ARS Server 7.0.1 patch 5 - HPUX 11i

I have completed the integration component CMDB integration 7.1.
When I go to run the Pull_ARS_INV_APPLICATION I get the following
error message:

Set fields active link running a process failed
EIE Service wakeup port not set in EIE:BackupLoadFlag form (ARERR
1603)

The preceding message occurred during the execution of active link
EIE:ST-RunNowOpenConfirmWindow01 -- action 2. (ARNOTE 1101)

Does any one know how to set the Wakeup Port, I have set this in the
eie.cfg file to be the default value.
Should this be imported in the the form above when you restart teh
service?

Have you seen this error before?

Do you know of a solution?

Thanks for your help in advance.

John

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

Server woe...

2008-01-16 Thread Chris While

Hi,

Got an interesting one. I have a form which I can see and edit in Admin
Tool. When I go to the user tool, I cannot open it. Checked permissions,
restarted both app and DB, still nothing.

We are running 7.0.1 Patch 003

When trying to run export from command line, both Form and Active Links were
not brought across!

Any suggestions ?

Thanks

Chris

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

Re: Server woe...

When you say 'I cannot open it', what exactly do you mean?

Axton Grams

On Jan 16, 2008 10:37 AM, Chris While [EMAIL PROTECTED] wrote:

 ** Hi,

 Got an interesting one. I have a form which I can see and edit in Admin
 Tool. When I go to the user tool, I cannot open it. Checked permissions,
 restarted both app and DB, still nothing.

 We are running 7.0.1 Patch 003

 When trying to run export from command line, both Form and Active Links
 were not brought across!

 Any suggestions ?

 Thanks

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

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

Re: Server woe...

2008-01-16 Thread Mike White

More of a punt than diagnosis, but you can try clearing cache

Mike White
Office:  813-978-2192
E-mail:  [EMAIL PROTECTED]



   
  Chris While   
   
  [EMAIL PROTECTED]To:   arslist@ARSLIST.ORG   
  
  LEMAIL.COMcc:
   
  Sent by: Action   Subject:  Server woe...
   
  Request System
   
  discussion
   
  list(ARSList)
   
  [EMAIL PROTECTED]
  
  G
   

   

   
  01/16/2008 10:37  
   
  Please respond to 
   
  arslist   
   

   

   




** Hi,

Got an interesting one. I have a form which I can see and edit in Admin
Tool. When I go to the user tool, I cannot open it. Checked permissions,
restarted both app and DB, still nothing.

We are running 7.0.1 Patch 003

When trying to run export from command line, both Form and Active Links
were not brought across!

Any suggestions ?

Thanks

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
inline: graycol.gifinline: ecblank.gifinline: pic23215.gif

Re: Problem with E-mail Engine Upgrade from 5.1.2 to 6.3

What OS?
 
The main thing I remember about that upgrade was to make sure that Java
is installed correctly before running the email engine install.  What
errors do you receive?
 
Fred
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shrestha, Manjari R.
Sent: Wednesday, January 16, 2008 9:11 AM
To: arslist@ARSLIST.ORG
Subject: Problem with E-mail Engine Upgrade from 5.1.2 to 6.3


** 

Hello all,

 

I had no problem upgrading Remedy 5.1.2 to 6.3 except the e-mail engine.
I read the previous thread where it was said that I will have to
manually delete all the e-mail forms. I did this but still was not able
to upgrade. Please advise how I should go about upgrading the e-mail
engine. Thanks in advance.

 

 

Thanks!

 

Manjari R. Shrestha

 

 


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

Re: Problem with E-mail Engine Upgrade from 5.1.2 to 6.3

2008-01-16 Thread Cliff A

What OS are you running?  I found that for Windows server I additionally
had to uninstall the email engine via the add/remove programs.  The
email engine is then just a straight install.  NB You have to re
configure with your original settings. 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shrestha, Manjari R.
Sent: 16 January 2008 15:11
To: arslist@ARSLIST.ORG
Subject: Problem with E-mail Engine Upgrade from 5.1.2 to 6.3


** 

Hello all,

 

I had no problem upgrading Remedy 5.1.2 to 6.3 except the e-mail engine.
I read the previous thread where it was said that I will have to
manually delete all the e-mail forms. I did this but still was not able
to upgrade. Please advise how I should go about upgrading the e-mail
engine. Thanks in advance.

 

 

Thanks!

 

Manjari R. Shrestha

 

  

 

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

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

Re: Server woe...

2008-01-16 Thread Tucker, Rob

Do you see an error indicating a problem on arserver restart in the
arerror log? You may also want to check to verify that the views have
been properly created.
 
 
Rob Tucker
New Edge Networks



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike White
Sent: Wednesday, January 16, 2008 7:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Server woe...


** 

More of a punt than diagnosis, but you can try clearing cache

Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
 Chris While [EMAIL PROTECTED]



 



Chris While
[EMAIL PROTECTED]
Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG 

01/16/2008 10:37
Please respond to arslist



To: arslist@ARSLIST.ORG
cc: 
Subject: Server woe...  


** Hi,

Got an interesting one. I have a form which I can see and edit in Admin
Tool. When I go to the user tool, I cannot open it. Checked permissions,
restarted both app and DB, still nothing.

We are running 7.0.1 Patch 003

When trying to run export from command line, both Form and Active Links
were not brought across!

Any suggestions ?

Thanks

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


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

Re: Server woe... SOLVED

2008-01-16 Thread Chris While

Bit of a timing issue here...

Thanks for your answers. Looks like the app server came up just before the
DB, causing odd results in arerror.log

Have restarted Remedy again, and all seems well.

Thanks again

Chris

On Jan 16, 2008 3:59 PM, Mike White [EMAIL PROTECTED] wrote:

 **

 More of a punt than diagnosis, but you can try clearing cache

 Mike White
 Office: 813-978-2192
 E-mail: [EMAIL PROTECTED]
 [image: Inactive hide details for Chris While
 [EMAIL PROTECTED]]Chris While [EMAIL PROTECTED]





 *Chris While [EMAIL PROTECTED]*
 Sent by: Action Request System discussion
 list(ARSList) arslist@ARSLIST.ORG

 01/16/2008 10:37
 Please respond to arslist



  To: arslist@ARSLIST.ORG
  cc:
  Subject: Server woe...

 ** Hi,

 Got an interesting one. I have a form which I can see and edit in Admin
 Tool. When I go to the user tool, I cannot open it. Checked permissions,
 restarted both app and DB, still nothing.

 We are running 7.0.1 Patch 003

 When trying to run export from command line, both Form and Active Links
 were not brought across!

 Any suggestions ?

 Thanks

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


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

Remedy Developer Needed in CO (UNCLASSIFIED)

2008-01-16 Thread Bennett, Charlie CTR MDA/DOCC

Classification:  UNCLASSIFIED 
Caveats: NONE

Hi All,

Been trolling for awhile now, and here's my first posting.  My group is
looking for a seasoned Remedy guru - the job description is below.  Thanks!




Brief Description:
Perform duties relating to Information Technology Service Management (ITSM)
Remedy Application system administrator for the Missile Defense Integration
and Operations Center (MDIOC), at Schriever Air Force Base, Colorado USA. 

Complete Description:
Responsible for an ITSM Remedy solution team, specifically the BMC Remedy
Service Desk modules, and will maintain and operate the application.
Administer application data daily; process queries and reports as requested
by users, and monitor server logs to ensure that all system transactions are
processed correctly. Ensure the Remedy applications are properly patched and
on the most current versions. Design and implement upgrade plans for Remedy
Software updates and patches. Develop, change, test and deploy MDIOC
processes into Remedy and work directly with managers within the MDIOC. Work
with internal agencies to insure the Remedy suite of applications are being
fully supported; maintain and manage the Remedy support and maintenance
contract to insure that all available support is current. On the job
training will be available and some formal Remedy training may be available.


Minimum Requirements:
BS Computer Science, Info. Systems (or equivalent) and 12+ years experience
in the IT field. Minimum four years administration and two years development
experience with Remedy AR System application. Candidate must possess good
verbal and written communication skills. Must be a team player and able to
work in a team environment. US SECRET Security Clearance must be obtainable.


Preferred Requirements:
Familiarity with MDIOC is preferred. Preferred experience with the BMC Help
Desk 5.0 or higher and or with the BMC Remedy ITSM Suite 7.0 (Service Desk,
Service Level Management, Asset Management, Change Management) and Crystal
Reports. Familiarity with MS SQL Server 2005 is a plus. 

Experience:  12 years 
Education:  Bachelors 
Clearance:  Current Secret, or able to obtain a Secret




Charlie Bennett
Remedy Administrator
Missile Defense Integration  Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED 
Caveats: NONE


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


smime.p7s
Description: S/MIME cryptographic signature

Q: Email Engine and CPU Usage

Has anyone noticed the Email Engine service grabbing all of the CPUs
when running?  When the Email Engine is not running, CPU usage stays in
a reasonable range (say 40-60%).  As soon as it is started, it runs the
CPUs up to 90-100% and you see a repeating pattern of maxing the CPUs,
then it drops off for a couple of seconds, and then runs back up.  As
soon as you stop the service, the CPU usage drops back to normal.  This
happens even when there are no pending send messages in AR System
Email Messages form.

 

Running ARS v7.0.1 P5 on Windows Server 2003 Enterprise/SQL Server 2005.
Basically curious if this is normal behavior...

 

Craig Carter

 


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

Sending emails to a Blackberry

2008-01-16 Thread Moore, Chris

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

 

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

 

Is there something special I need to do for it to work?

 

Thanks,

Chris Moore


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

Re: Sending emails to a Blackberry

2008-01-16 Thread Reiser, John J

Chris,
Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?
We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 
We added an email template and the messages went through.
HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me



 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry


** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

 

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

 

Is there something special I need to do for it to work?

 

Thanks,

Chris Moore

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

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

Re: Log SQL in Admin

2008-01-16 Thread Eli Schilling

Dylan,
 
A quick (possibly stupid question) but is your AR Server running in
development cache mode?
 
-Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool makes when you
modify a form?
I'm having major lag issues when I try and update anything in my admin
tool and it's frustrating the heck out of me. It takes anywhere from 10
- 60 seconds for it to commit when I hit the save button even on a minor
modification to an active link. I believe it's because the remote sql
server is bogging down but I can't prove it and I can't get the sql
admins to look at it without any proof. I have zero access to the sql
server so I'm stuck without something to get them to take a look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

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

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

Re: Q: Email Engine and CPU Usage

Actually, it already is and we've been running it like this for over a
year (once we passed 100,000 accounts).

 

It's processing the email fine and it starts right up.  This is after
startup and while it is running.

 

I'll be rebooting the entire server later (off hours) to see if this
clears up but I wanted to ask.  Currently have it running on private RPC
and with the multiple threads option.

 

Craig Carter

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, January 16, 2008 10:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: Q: Email Engine and CPU Usage

 

** Change this setting to true in the emaildaemon.properties file:

com.bmc.arsys.emaildaemon.FetchUserGroupInfoOnDemand=false

Specifies whether to fetch the user and group information on demand as
opposed to loading all users and groups at startup. The default 
value for this property is false. If there are many users or groups, you
might want to set this property to true to reduce the startup time for
email.

Axton Grams

On Jan 16, 2008 12:19 PM, Craig Carter 
[EMAIL PROTECTED] wrote:

** 

Has anyone noticed the Email Engine service grabbing all of the CPUs
when running?  When the Email Engine is not running, CPU usage stays in
a reasonable range (say 40-60%).  As soon as it is started, it runs the
CPUs up to 90-100% and you see a repeating pattern of maxing the CPUs,
then it drops off for a couple of seconds, and then runs back up.  As
soon as you stop the service, the CPU usage drops back to normal.  This
happens even when there are no pending send messages in AR System
Email Messages form.

 

Running ARS v7.0.1 P5 on Windows Server 2003 Enterprise/SQL Server 2005.
Basically curious if this is normal behavior...

 

Craig Carter

 

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


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


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

JOB: Full Time - Alpharetta, GA

My current employer is looking to add another position.  It's a very stable
industry with great compensation and work/life balance.

Company: New York Life Insurance
Term: Full-Time (good benefits package - health, life, dental, 401k
matching, legal services, pension, etc.)
Salary: 100k+, negotiable based on experience
Travel: Low, Training and to other sites  twice per year

We can not sponsor foreign employees.

Description: The team is responsible for the installation, configuration,
deployment,  administration and support of a diverse set of product suites
consisting of IBM/Tivoli, Remedy, Computer Associates and others. These
products are used for managing Automation and Monitoring, Processes and
Command and Control Data Center Operations. Key goals are to maintain and
improve the efficiency and the bottom line operations of the Data Center(s).

The primary focus is Remedy.  The more applicable skills the better.
Looking for people who know how (and like) to learn and apply.  We have lots
of integration points, custom applications, and customizations to the Remedy
applications.

Current Environment:
- 5.6 apps (Help Desk, Change, Asset, SLA)
- ARServer 7.0.1
- CMDB 2.0
- BMC SIM
- Mid-Tier 7.0.1
- EIE with Oracle Adapter
- Solaris/Oracle

Upcoming Projects:
- ITSM 7.x upgrade (Asset, Change, Incident, Problem, and SLM)
- Custom applications (project management, separate service desks, disaster
recovery, staffing, others)

Additional Skills:
- Solaris (shell scripting, debugging, basic unix knowledge - fs,
permissions, etc.)
- Oracle (pl/sql and administration-ddl) - will need to be capable of
communicating with the data warehouse and database administrators in terms
they can understand
- Programming skills: java (jsp, servlet, and standalone apps), c, perl,
shell, html (css, html, etc.), javascript
- Ability to effectively communicate with different areas to develop and
document processes, then write application to facilitate those processes

Nice to have:
- Familiarity with ITIL processes
- Tivoli
- BMC BEM
- Patrol
- Tonic
- WebSphere and Rational Application Developer (IBM's Eclipse and bundled
packages)
- BMC SIM

Please send inquiries and resumes to [EMAIL PROTECTED] and I will get
them to the right people.

Thanks,
Axton Grams

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

Re: Q: Email Engine and CPU Usage

Turn on the api logs and see what activity is happening on the private
queue.

Axton Grams

On Jan 16, 2008 12:40 PM, Craig Carter [EMAIL PROTECTED]
wrote:

 **

 Actually, it already is and we've been running it like this for over a
 year (once we passed 100,000 accounts).



 It's processing the email fine and it starts right up.  This is after
 startup and while it is running.



 I'll be rebooting the entire server later (off hours) to see if this
 clears up but I wanted to ask.  Currently have it running on private RPC and
 with the multiple threads option.



 Craig Carter


   --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Axton
 *Sent:* Wednesday, January 16, 2008 10:28 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Q: Email Engine and CPU Usage



 ** Change this setting to true in the emaildaemon.properties file:


 com.bmc.arsys.emaildaemon.FetchUserGroupInfoOnDemand=false

 Specifies whether to fetch the user and group information on demand as
 opposed to loading all users and groups at startup. The default
 value for this property is false. If there are many users or groups, you
 might want to set this property to true to reduce the startup time for
 email.

 Axton Grams

 On Jan 16, 2008 12:19 PM, Craig Carter  [EMAIL PROTECTED]
 wrote:

 **

 Has anyone noticed the Email Engine service grabbing all of the CPUs when
 running?  When the Email Engine is not running, CPU usage stays in a
 reasonable range (say 40-60%).  As soon as it is started, it runs the CPUs
 up to 90-100% and you see a repeating pattern of maxing the CPUs, then it
 drops off for a couple of seconds, and then runs back up.  As soon as you
 stop the service, the CPU usage drops back to normal.  This happens even
 when there are no pending send messages in AR System Email Messages form.



 Running ARS v7.0.1 P5 on Windows Server 2003 Enterprise/SQL Server 2005.
 Basically curious if this is normal behavior…



 Craig Carter



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


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


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

Re: Q: Server Configuration Recommendations

2008-01-16 Thread Jarl Grøneng

Running 300-350 concurrent users with a max of 10 fast and 12 list.
(Asset mgmt, change mgmt and home grown HD.)

--
Jarl



On Jan 16, 2008 2:29 PM, Craig Carter [EMAIL PROTECTED] wrote:
 Perhaps but page 19 of the performance tuning whitepaper recommends 3 times 
 the number of processors for Fast and 5 times the processors for List (24 and 
 40).  We could also have as many as 400 users and also some web users so this 
 is intended to cover future growth.

 Craig Carter



 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
 PROTECTED] On Behalf Of Jarl Grøneng
 Sent: Tuesday, January 15, 2008 10:29 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Q: Server Configuration Recommendations

 Is not 24 fast and 40 list an overkill with 80-100 users?

 --
 Jarl

 On Jan 15, 2008 3:41 PM, Craig Carter [EMAIL PROTECTED] wrote:
  **
 
 
 
  All,
 
 
 
  We're running into some performance problems recently.  I upgraded the
  server a few days ago (operating system, database, CPUs, memory, queues,
  etc, and it hasn't helped much.  Basically, it takes longer to search and
  create tickets as more and more people log in (as expected) but the server
  has plenty of available CPU, plenty of memory, and plenty of bandwidth so it
  appears there is a bottleneck somewhere.
 
 
 
  8 CPUs
 
  16GB Memory
 
  Windows Server 2003 Enterprise
 
  SQL Server 2005 Enterprise
 
  ARS v7.0.1 P5 (CSS and custom apps-no ITSM)
 
  24 Fast, 40 List
 
 
 
  It flies with about 40 people, becomes sluggish with 80, and gets real slow
  with 100.  I would expect this system to be able to handle a much larger
  load.  Since the running CPU usage and disk usage is fairly low, I'm looking
  for advice.
 
 
 
  Everything is currently installed on the same server and on the same drive
  (although these are raid drives).  Is it possible we're seeing contention
  over disk resources and I/O?  Any advice on determining where the bottleneck
  is or from people administering a large number of users?  How much advantage
  would be gained by running the AR Server on another drive or box separate
  from the database?  Is it reasonable to expect to only get 100 concurrent
  users (using the WUT) on a server of this size?
 
 
 
  Looking in the docs and whitepapers but any advice would be helpful since
  this is impacting us now.
 
 
 
  Craig Carter
 
 
 
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
  html___

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

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

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


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

Re: Sending emails to a Blackberry

2008-01-16 Thread Moore, Chris

Nope-that wasn't it- at least I don't think it was- here's what I did.  

 

I went to the messages form and tried sending 2 emails with text in the
HTML body tab.  The first one I just wrote test and the second I did
BODYTest2/BODY.  Neither went through.  If the plain text emails
were this issue, should that have worked, or do I need to set up a
template to check it?

Chris

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Yes, the address that works from Outlook is the group email address.
The emails are plain text, so I'll try sending an HTML one and see what
happens.

Thanks John!

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Wednesday, January 16, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Chris,

Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?

We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 

We added an email template and the messages went through.

HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry

** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

 

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

 

Is there something special I need to do for it to work?

 

Thanks,

Chris Moore

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

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

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

Re: Log SQL in Admin

There was a similar thread in the last couple of weeks.  See this issue:

http://bugs.arswiki.org/show_bug.cgi?id=58

Axton Grams

On Jan 16, 2008 12:36 PM, Wheeler, Dylan [EMAIL PROTECTED] wrote:

 ** Is it possible to log the sql queries the admin tool makes when you
 modify a form?
 I'm having major lag issues when I try and update anything in my admin
 tool and it's frustrating the heck out of me. It takes anywhere from 10 - 60
 seconds for it to commit when I hit the save button even on a minor
 modification to an active link. I believe it's because the remote sql server
 is bogging down but I can't prove it and I can't get the sql admins to look
 at it without any proof. I have zero access to the sql server so I'm stuck
 without something to get them to take a look.
 Ideas anyone?

 Windows 2003
 ARS 6.3
 MS SQL 2000

 *-*

 *Dylan Wheeler*
 *Production Control Analyst Principal*
 *IT Operations*
 *Downey Savings  Loan Association, F.A. *
 *Direct: 949.509.4565
 Fax:  949.509.7841*
 *Email: [EMAIL PROTECTED] [EMAIL PROTECTED]**

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

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

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

Re: Log SQL in Admin

Hi Eli,
Nope, not in development cache mode.

- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Wednesday, January 16, 2008 9:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Dylan,
 
A quick (possibly stupid question) but is your AR Server running
in development cache mode?
 
-Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool makes when
you modify a form?
I'm having major lag issues when I try and update anything in my
admin tool and it's frustrating the heck out of me. It takes anywhere
from 10 - 60 seconds for it to commit when I hit the save button even on
a minor modification to an active link. I believe it's because the
remote sql server is bogging down but I can't prove it and I can't get
the sql admins to look at it without any proof. I have zero access to
the sql server so I'm stuck without something to get them to take a
look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

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


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

Re: Log SQL in Admin

2008-01-16 Thread Jarl Grøneng

The easiest solution is to turn on List option (not Detail) when
listing objects.

--
Jarl

On Jan 16, 2008 6:36 PM, Wheeler, Dylan [EMAIL PROTECTED] wrote:
 **

 Is it possible to log the sql queries the admin tool makes when you modify a
 form?
 I'm having major lag issues when I try and update anything in my admin tool
 and it's frustrating the heck out of me. It takes anywhere from 10 - 60
 seconds for it to commit when I hit the save button even on a minor
 modification to an active link. I believe it's because the remote sql server
 is bogging down but I can't prove it and I can't get the sql admins to look
 at it without any proof. I have zero access to the sql server so I'm stuck
 without something to get them to take a look.
 Ideas anyone?

 Windows 2003
 ARS 6.3
 MS SQL 2000

 -

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

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

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

Re: Log SQL in Admin

Not sure what setting the view to List would do over Detail? It didn't work 
though. Set it to List, opened an active link, modified it, hit save and sat 
there looking at the hour glass for about 50 seconds.

- 

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



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Wednesday, January 16, 2008 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


The easiest solution is to turn on List option (not Detail) when listing 
objects.

--
Jarl

On Jan 16, 2008 6:36 PM, Wheeler, Dylan [EMAIL PROTECTED] wrote:
 **

 Is it possible to log the sql queries the admin tool makes when you 
 modify a form? I'm having major lag issues when I try and update 
 anything in my admin tool and it's frustrating the heck out of me. It 
 takes anywhere from 10 - 60 seconds for it to commit when I hit the 
 save button even on a minor modification to an active link. I believe 
 it's because the remote sql server is bogging down but I can't prove 
 it and I can't get the sql admins to look at it without any proof. I 
 have zero access to the sql server so I'm stuck without something to 
 get them to take a look. Ideas anyone?

 Windows 2003
 ARS 6.3
 MS SQL 2000

 -

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

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

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

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

Re: Log SQL in Admin

2008-01-16 Thread Eli Schilling

Dylan,
 
I may be wrong but I have always expected that kind of performance when
operating outside of Development Cache mode.  When you operate in normal
conditions the server maintains a cache of all actively used forms and
workflow.  When you make a change its not written directly to this
cache; instead the cache has to be copied, updated with your change and
then written back over the production cache.  Although your work is
performec over the Admin thread the cache update happens on the fast
thread(s) (I think) and user actions will always take precedence.
 
When you switch to Development cache mode all of your changes are
written directly to the cache and your changes will always take
precedence over user actions.  If you leave development cache on for any
extended period of time you'll start receive complaints of poor
performance from your users.
 
Cheers!
Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Hi Eli,
Nope, not in development cache mode.

- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Wednesday, January 16, 2008 9:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Dylan,
 
A quick (possibly stupid question) but is your AR Server running
in development cache mode?
 
-Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool makes when
you modify a form?
I'm having major lag issues when I try and update anything in my
admin tool and it's frustrating the heck out of me. It takes anywhere
from 10 - 60 seconds for it to commit when I hit the save button even on
a minor modification to an active link. I believe it's because the
remote sql server is bogging down but I can't prove it and I can't get
the sql admins to look at it without any proof. I have zero access to
the sql server so I'm stuck without something to get them to take a
look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

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

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

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

Re: Tasks (UNCLASSIFIED)

2008-01-16 Thread FRANK, GORDON CTR DISA JSSC

Classification:  UNCLASSIFIED 
Caveats: NONE

Tasks are included under Incident Management and Problem Management but
they do not have the same meaning as Change Management. Change
Management uses Tasks like a checklist of a Life Cycle change. Incidents
and Problem uses them as extra things to be done because of the
Incident or Problem. Be careful not to let the Incident Tasks become
Problems or worst yet, Changes.

Gordon M. Frank
DISA\Verizon FNS

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drake,Dave
Sent: Wednesday, January 16, 2008 1:02 PM
To: arslist@ARSLIST.ORG
Subject: Tasks

** 

In ITSM 7, if not using Change Management yet, can we still use the
Tasks functionality?  Thanks 

Dave Drake | Remedy Administrator | Cerner Corporation - CernerWorks |
816-201-1823 | [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
| www.cerner.com http://www.cerner.com/ 



CONFIDENTIALITY NOTICE This message and any included attachments are
from Cerner Corporation and are intended only for the addressee. The
information contained in this message is confidential and may constitute
inside or non-public information under international, federal, or state
securities laws. Unauthorized forwarding, printing, copying,
distribution, or use of such information is strictly prohibited and may
be unlawful. If you are not the addressee, please promptly delete this
message and notify the sender of the delivery error by e-mail or you may
call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1)
(816)221-1024.

__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
Classification:  UNCLASSIFIED 
Caveats: NONE

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

Re: Tasks

2008-01-16 Thread strauss

Yes, it is a separate subsystem in ITSM 7, but you have no template
capability for tasks outside of Change Management, so it isn't much of a
labor saving device.
 
There WAS an Incident Task Template module addition to Service Desk 7 in
ITSM 7 Patch 9002, but BMC failed to update it to work properly under
either ITSM Patch 004, 005, or 006, so I have dropped it from my
installations.  It must have been the pet project of someone who was
deprecated from the workforce last summer.  I had kept an issue open on
the problem since mid 2007, initially opened in 2/2007 over several of
the glaring discrepancies in the installation documentation for patch
9002, but it was closed by support last August with a promise to let me
know when patch 9002 had been updated.  The problem remains - patch 9002
is still on the patch site, but is basically unsupported and outdated,
and the installation instructions were never corrected.  More quality
software from BMC for those of you with masochistic tendencies.

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

 


  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drake,Dave
Sent: Wednesday, January 16, 2008 12:02 PM
To: arslist@ARSLIST.ORG
Subject: Tasks


** 

In ITSM 7, if not using Change Management yet, can we still use
the Tasks functionality?  Thanks 

Dave Drake | Remedy Administrator | Cerner Corporation -
CernerWorks | 816-201-1823 | [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  | www.cerner.com
http://www.cerner.com/ 

  _  

CONFIDENTIALITY NOTICE This message and any included attachments
are from Cerner Corporation and are intended only for the addressee. The
information contained in this message is confidential and may constitute
inside or non-public information under international, federal, or state
securities laws. Unauthorized forwarding, printing, copying,
distribution, or use of such information is strictly prohibited and may
be unlawful. If you are not the addressee, please promptly delete this
message and notify the sender of the delivery error by e-mail or you may
call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1)
(816)221-1024.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the
Answers Are html___


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

Re: Log SQL in Admin

Thanks for the info Eli, I'll give it a try. I looked into it before but
didn't think that would make a big difference since I'm the only user
with access to my dev box.

- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Wednesday, January 16, 2008 10:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Dylan,
 
I may be wrong but I have always expected that kind of
performance when operating outside of Development Cache mode.  When you
operate in normal conditions the server maintains a cache of all
actively used forms and workflow.  When you make a change its not
written directly to this cache; instead the cache has to be copied,
updated with your change and then written back over the production
cache.  Although your work is performec over the Admin thread the cache
update happens on the fast thread(s) (I think) and user actions will
always take precedence.
 
When you switch to Development cache mode all of your changes
are written directly to the cache and your changes will always take
precedence over user actions.  If you leave development cache on for any
extended period of time you'll start receive complaints of poor
performance from your users.
 
Cheers!
Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Hi Eli,
Nope, not in development cache mode.

- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Wednesday, January 16, 2008 9:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
Dylan,
 
A quick (possibly stupid question) but is your AR Server
running in development cache mode?
 
-Eli



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool
makes when you modify a form?
I'm having major lag issues when I try and update
anything in my admin tool and it's frustrating the heck out of me. It
takes anywhere from 10 - 60 seconds for it to commit when I hit the save
button even on a minor modification to an active link. I believe it's
because the remote sql server is bogging down but I can't prove it and I
can't get the sql admins to look at it without any proof. I have zero
access to the sql server so I'm stuck without something to get them to
take a look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

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

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

Re: Sending emails to a Blackberry

Is the address for the Blackberry an address in your company's Exchange
Server?  If so then it might be that the Exchange Admins have restricted
sending to that address.

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 11:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

** 

Nope-that wasn't it- at least I don't think it was- here's what I did.  

I went to the messages form and tried sending 2 emails with text in the
HTML body tab.  The first one I just wrote test and the second I did
BODYTest2/BODY.  Neither went through.  If the plain text emails
were this issue, should that have worked, or do I need to set up a
template to check it?

Chris

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

Yes, the address that works from Outlook is the group email address.
The emails are plain text, so I'll try sending an HTML one and see what
happens.

Thanks John!

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Wednesday, January 16, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

Chris,

Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?

We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 

We added an email template and the messages went through.

HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry

** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

Is there something special I need to do for it to work?

Thanks,

Chris Moore

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

Re: OT: Re: SLM 7.0.03 install problem on VMWare Workstation 6

2008-01-16 Thread Tibi Andronache

Hi Jason,

I did install myself the SLM 7.0.1p2 with MSSQL 2005 and Windows Server
2003? locally on a Dell D820 laptop under VMWare Server at the advice of a
IT support guru opposed to VMWare Workstation, Server license being free ...
and Workstation running into unspecified errors during install.

I was able to configure the USBs under VMWare Server to recognize the CD
unit ... there was a learning curve for the VMWare configuring, but not that
bad ...

Don't know the differences between them.

Oh and my home pc has that vmx image running under VMWare WorkStation
software, though not installed by me ...

Regards,
Tibi Andronache



On 1/15/08, Jason Miller [EMAIL PROTECTED] wrote:

 ** Does anybody know what the differences are between VMware Workstation
 and Server?  I had heard at one point that Server cannot recognize USB
 devices or play sounds but then I later heard that is untrue. I did a brief
 search on the VMware web site a while back but didn't really find any
 details.

 What do you get if you pay for Workstation vs. the free Server version?

 Thanks,
 Jason

 On Jan 15, 2008 9:21 AM, Tibi Andronache [EMAIL PROTECTED]  wrote:

  ** Try installing on VMWare Server not Workstation.
 
  Tibi
 
On 1/15/08, John Jack [EMAIL PROTECTED] wrote:
  
   ** Hi folks,
  
   I heard that there is no official support from BMC for ARS running on
   a virtual environment, so tought of checking if anyone here had this 
   problem
   before.
  
   When we try to install SLM 7.0.03 on a virtual Windows 2003 Server,
   all we get after running the installer is the error message: The progress
   bar has not been created yet. Then it hungs with no logs.
  
   Any ideas?
   Thanks in advance!
   John
  
   - VMWare Workstation 6
 - OS: MS-Windows Server 2003 Std Edition, service pack 1
 - DB: Oracle 10g
 - ARS: 7.1
 - Apps: Incident, Problem Mgmt 7.0.02 patch 4
 - Java: JRE 1.5.0_13
 - Mid-tier: 7.1 __Platinum Sponsor: www.rmsportal.com ARSlist:
   Where the Answers Are html___
 
 
  __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
  html___
 

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

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

Re: Log SQL in Admin

I just looked and the SQL log on the server shows the Admin commands
that are executed (at least on Unix with Oracle).
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 11:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool makes when you
modify a form?
I'm having major lag issues when I try and update anything in my admin
tool and it's frustrating the heck out of me. It takes anywhere from 10
- 60 seconds for it to commit when I hit the save button even on a minor
modification to an active link. I believe it's because the remote sql
server is bogging down but I can't prove it and I can't get the sql
admins to look at it without any proof. I have zero access to the sql
server so I'm stuck without something to get them to take a look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

 

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

Re: Sending emails to a Blackberry

2008-01-16 Thread Reiser, John J

Chris,
 
I had to use a template and select the fields that I wanted included. In
my outgoing email messages form there is nothing in the Text or HTML
tabs.
 
Maybe Fred has a point here. I have had the Exchange server admins
change parameters on the fly because they thought something wasn't
configured correctly. It usually breaks my email engine. 

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



 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 16, 2008 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry


** 
Is the address for the Blackberry an address in your company's Exchange
Server?  If so then it might be that the Exchange Admins have restricted
sending to that address.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 11:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry


** 

Nope-that wasn't it- at least I don't think it was- here's what I did.  

 

I went to the messages form and tried sending 2 emails with text in the
HTML body tab.  The first one I just wrote test and the second I did
BODYTest2/BODY.  Neither went through.  If the plain text emails
were this issue, should that have worked, or do I need to set up a
template to check it?

Chris

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Yes, the address that works from Outlook is the group email address.
The emails are plain text, so I'll try sending an HTML one and see what
happens.

Thanks John!

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Wednesday, January 16, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Chris,

Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?

We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 

We added an email template and the messages went through.

HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry

** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

 

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

 

Is there something special I need to do for it to work?

 

Thanks,

Chris Moore

 

 

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

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

Re: Data types are not appropriate for relational operation (ARERR 313) Web Service

2008-01-16 Thread Misi Mladoniczky

Hi,

The Start_Date and End_Date must be of type = dateTime.

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

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

 All,

 I have created a web service based on the Help Desk form. My goal is to be
 able to search for all tickets opened in a date range. I have entered the
 qualification below for the OpGetList operation but receive the error,
 Data
 types are not appropriate for relational operation (ARERR 313). Any ideas?


 'Submit Date'  =  XPATH(/ROOT/Start_Date) AND 'Submit Date' =
 XPATH(/ROOT/End_Date)

 ARS 7.1 patch001 IM 7.0.02 patch006
 --
 View this message in context:
 http://www.nabble.com/Data-types-are-not-appropriate-for-relational-operation-%28ARERR-313%29-Web-Service-tp14887669p14887669.html
 Sent from the ARS (Action Request System) mailing list archive at
 Nabble.com.

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

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


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

Re: Sending emails to a Blackberry

I think if you add an attachment to an email the Remedy email engine
automatically adds the MIME line

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 1:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

** 

I assume it is since it can receive emails sent from Outlook at the same
address.  I don't really claim to know much about how email/exchange
works though!

I did find an old post which said Blackberries email client looks for a
line in the header that says This is a multi-part message in MIME
format.  I'm working on setting up a HTML header with that to see it
that works, but am still open to suggestions.

Thanks!

Chris

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 16, 2008 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

Is the address for the Blackberry an address in your company's Exchange
Server?  If so then it might be that the Exchange Admins have restricted
sending to that address.

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 11:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

** 

Nope-that wasn't it- at least I don't think it was- here's what I did.  

I went to the messages form and tried sending 2 emails with text in the
HTML body tab.  The first one I just wrote test and the second I did
BODYTest2/BODY.  Neither went through.  If the plain text emails
were this issue, should that have worked, or do I need to set up a
template to check it?

Chris

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

Yes, the address that works from Outlook is the group email address.
The emails are plain text, so I'll try sending an HTML one and see what
happens.

Thanks John!

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Wednesday, January 16, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

Chris,

Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?

We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 

We added an email template and the messages went through.

HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry

** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

Is there something special I need to do for it to work?

Thanks,

Chris Moore

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

ITSM7 Data Management Tool

2008-01-16 Thread McClure, Don

Abstract:  Beware of this product.  It may not be a good fit for your logical 
environment, consuming more work than manual entry for similar data-your 
mileage may vary.

Full Disclosure:  We are implementing and fielding ARS7x/ITSM7y/CMDB2.z via an 
architecture previously described at length by Dr. Christopher Strauss.  The 
ITSM Data Management Tool (DMT) was exercised and following observations were 
developed.

-  workstation portion of DMT is a collection of spreadsheets and 
conversion macros-translation: must run on machine with Microsoft Office (not 
on any of my servers, be design!!!).   Text files in *.csv format are then 
transferred to server for usage by batchfile-driven importcmd.exe.
-  Foundation data handling is straightforward for companies, 
locations, organizations, support groups, business times, holidays.  Next, the 
fine print--CAUTION:
-  Conversion macro caused individual data values to be enclosed in 
quotation marks within the csv, with other attendant string-handling issues, 
all inconsistently. Behavior was prevalent whenever  and / were used 
within data, but data containing those were NOT the only quoted strings, and 
were not always quoted themselves (Excel behavior, not peculiar to DMT)
-  Conversion macros created duplicate records in the csv from a single 
xls row, also inconsistently, and rows with above-mentioned characters were 
generally not the offenders.  Data-and conversion-inconsistencies disappeared 
with renaming of groups/organizations to remove the two offending characters.
-  Support Staff creation pose further cautions.  Designation of a user 
as 'support staff' is only justified by user's efforts in a support group, not 
presence in a particular organization/department, at least in our 
environment-and this tool proved extremely awkward trying to handle our 
particular relationship structure.
-  Candidate support staff records are created by template only (design 
of DMT), with said template overriding any other information keyed to the staff 
record itself
-  Support-staff template must also be unique for 
role-to-privilege-to-org/department combination (note-neither support group nor 
company accesses are even mentioned, and mechanism for granting multiple group 
memberships to one individual is cumbersome) (finally---end of CAUTION, from 
above)

The last two points combine for implication: this DMT topology (for support 
staff) might be useful for large numbers of staff in small number of support 
groups (beware, though-a workstation running Excel must gracefully sort and 
convert that large spreadsheet to multiple csv-files in one operation-and 
fifteen separate pages are involved!!). Our environment is approx 300 support 
staff in 93 support groups, and would require over 200 distinct templates.  
Further, the functions of our support groups are both distinct and disjoint, 
while sharing common members.  Yes, that means many support staffers provide 
more than one support-staff function, not unusual for an educational 
environment. Example:  one particular company employs eleven support staff who 
monitor eight activities; each activity is sufficiently unique to qualify for 
separate 'support group' status; and, each individual asserts a unique 
combination of groups monitored.  Therefore, my support-staff effort would 
require eleven templates just for that one company-one template per person, and 
twenty other operating companies to go.  I cannot see the value of creating 
numerous templates which will be used one time only, versus creating staffers 
directly-the DMT effectively multiplies(not reduces!) workload of CREATING 
support staff. The support staff paradigm herein described *might* make sense 
if template-uniqueness were tied to support-group combinations, not 
departments.  Finally, the DMT may/may not exhibit aforementioned misbehaviors 
in other environments.

Our usage of this DMT will probably be limited to data in first bullet above 
only.   Customer-CTM:People records are created/maintained by a customized 
importation with daily updates, so the DMT People capability is not applicable 
to this University, *except* for support staff, and this DMT will therefore not 
be used for people.  What a shame-support-staff management was our initial 
motivation for examining this product at all!!


Don W. McClure, P.E.
Data Administrator  System Engineer
University of North Texas Computing  IT Center
dwmac_at_unt.edu
940.565.3287

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

FYI: SLM v7.1 install doc problem....

2008-01-16 Thread Carey Matthew Black

For those of you who have yet to attempt an install of SLM v7.1...
Please read

REF: v7.1.SLM-Installation Guide.2007.Nov.12.PDF-70078.pdf,  Page 35
 and optionally select the Disable Escalations option

-- It will produce errors during the install process if you disable
Escalations.
-- This is a known bug: 285865 - The doc bug on disabling
escalations and then running the install.
-- These errors will not be visible to the user of the (GUI) SLM v7.1
installer. ( You have to go find them in the slm_install_dir/Logs/*
files.)  ( I opened this bug  for that part 285870- Installer showing
100% complete when the installation had errors.)

( Just yet another install doc error for you to be aware of. Maybe
someone could actually fix the docs before the next customer gets the
same bad information and falls into the same hole?)

The suggestion that I received from Tech Support was to either:

A) [preferred] Role back your DB/OS to a backup and start over.
B) [should work too] Run the installer in overwrite mode
   -- Note that this option (by design) does not produce the
slm_install_dir/Logs/* files. ( I find that very hard to believe.
But that is what I was told. Maybe I did not get the whole memo on
that part?)

Sigh. Just thought someone out there might benefit from this
information before you do an SLM v7.1 install.

HTH.

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

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

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

Question: Overview Console - ITSM 7 - Missing Incidents

2008-01-16 Thread T. Dee

Has anyone encountered the Overview Console not showing their Incidents?

I see all the Changes and Tasks, but not Incidents.

In Application Preferences I have Overview Console show Incidents
and Tasks set to YES.

Thanks!!!

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

Re: Log SQL in Admin

Thanks for that Frederick, didn't think it would log admin changes. I
tried it out and I've got almost a full minute on some Remedy
Application Service queries.
 
Queue: Admin  /* Wed Jan 16 2008 11:55:27.9490 */SELECT T106.C1,C6
FROM T106 WHERE ((T106.C400123100 = '0') AND (T106.C6  0)) ORDER BY 1
ASC
Queue: List  /* Wed Jan 16 2008 11:56:24.1980 */SELECT TOP
1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch') ORDER BY 3 ASC
 
Queue: Admin   /* Wed Jan 16 2008 11:55:27.9490 */SELECT
T106.C1,C6 FROM T106 WHERE ((T106.C400123100 = '0') AND (T106.C6  0))
ORDER BY 1 ASC
Queue: List   /* Wed Jan 16 2008 11:56:24.1980 */SELECT TOP
1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch') ORDER BY 3 ASC
 
Both of these are from modifying two different filters, neither of which
touches T106 which is OBJSTR:Class on my system. T106 only has 243 rows
of data so no clue why it should take so long to return a result.
- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 16, 2008 10:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** 
I just looked and the SQL log on the server shows the Admin
commands that are executed (at least on Unix with Oracle).
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 11:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin tool makes when
you modify a form?
I'm having major lag issues when I try and update anything in my
admin tool and it's frustrating the heck out of me. It takes anywhere
from 10 - 60 seconds for it to commit when I hit the save button even on
a minor modification to an active link. I believe it's because the
remote sql server is bogging down but I can't prove it and I can't get
the sql admins to look at it without any proof. I have zero access to
the sql server so I'm stuck without something to get them to take a
look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

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

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

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


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

Mid-Tier - Installing ISAPI_REDIRECT_DLL

2008-01-16 Thread Brian Gillock

Listers,
Can someone please help me with a Mid-Tier issue? The issue is with the 
Mid-Tier 7.1 installation hanging trying to install the ISAPI_REDIRECT_DLL? It 
just sits there, apparently doing nothing.
11:30:15 Installing isapi redirect DLL
 ---
11:30:15  TC_InstallISAPI_RedirectDLL: Entering function 
11:30:15 -[ShowMsg]: Installing ISAPI_REDIRECT_DLL

IIS 6.0
JDK 1.5_14-b03
ARS 7.1 Patch 01
Win 2003

Both are running on seperate VMs. Connectivity is solid. I turned on allow 
ISAPI extensions in IIS after the first attempt. No help. It's not producing 
any errors in the logs. Just hangs. I've checked the prereqs and don't think I 
missed anything.

I've selected the option to install Tomcat. Using the ARAdmin default password 
for the config. which I setup during the ARS install. Cleared the drop downs 
for Preference and Home Page server and Data Vis servers.

Thanks all in advance!
Brian




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

Re: Sending emails to a Blackberry-fixed

2008-01-16 Thread Moore, Chris

Hey apparently the MIME thing was unrelated.  The problem was at the
exchange level.  Whoever set up the address said they added the
blackberry to that list, but they were dirty, dirty liars.  

 

I used the old distro list email on a whim and it worked, both in plain
text and HTML.

 

Thanks for the help, and sorry about that!

Chris

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 16, 2008 2:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

I think if you add an attachment to an email the Remedy email engine
automatically adds the MIME line

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 1:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

** 

I assume it is since it can receive emails sent from Outlook at the same
address.  I don't really claim to know much about how email/exchange
works though!

 

I did find an old post which said Blackberries email client looks for a
line in the header that says This is a multi-part message in MIME
format.  I'm working on setting up a HTML header with that to see it
that works, but am still open to suggestions.

 

Thanks!

Chris

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, January 16, 2008 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Is the address for the Blackberry an address in your company's Exchange
Server?  If so then it might be that the Exchange Admins have restricted
sending to that address.

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 11:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

** 

Nope-that wasn't it- at least I don't think it was- here's what I did.  

 

I went to the messages form and tried sending 2 emails with text in the
HTML body tab.  The first one I just wrote test and the second I did
BODYTest2/BODY.  Neither went through.  If the plain text emails
were this issue, should that have worked, or do I need to set up a
template to check it?

Chris

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Yes, the address that works from Outlook is the group email address.
The emails are plain text, so I'll try sending an HTML one and see what
happens.

Thanks John!

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Wednesday, January 16, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending emails to a Blackberry

 

Chris,

Do you receive the email message in Outlook from an address which goes
to everyone on the help desk?

We had a problem sending email to Verizon cell phones and it turned out
to be the way Verizon handled text email. It seems that it worked better
as an HTML formatted message. 

We added an email template and the messages went through.

HTH,

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased
by me

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris
Sent: Wednesday, January 16, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Sending emails to a Blackberry

** 

Hey all- I know I've seen this discussed before, but can't find anything
specifically about it.  

 

We have a group Blackberry that is for after hours use by our help desk
team.  It is set to receive emails from an address which goes to
everyone on the help desk.  It works when emails are sent from Outlook,
but not when sent from Remedy.  I tried going to the messages form and
sending one directly from there, but still nothing.

 

Is there something special I need to do for it to work?

 

Thanks,

Chris Moore

 

 

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

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

Re: Question: Overview Console - ITSM 7 - Missing Incidents

2008-01-16 Thread Rick Cook

I've seen that if they don't get processed from the Interface_Create form,
but that's all.

Rick

On 1/16/08, T. Dee [EMAIL PROTECTED] wrote:

 Has anyone encountered the Overview Console not showing their Incidents?

 I see all the Changes and Tasks, but not Incidents.

 In Application Preferences I have Overview Console show Incidents
 and Tasks set to YES.

 Thanks!!!


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


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

Re: Question: Overview Console - ITSM 7 - Missing Incidents

2008-01-16 Thread Lammey, Peter A.

We are having problems seeing the tickets in the Overview console as
well.
Various tickets seem to be missing.  We are trying to investigate this
and see if there is something wrong with the plug in that will generate
the data for this table or if there is some bug submitted about this.
 
ITSM 7.02 patch 005
User client 7.01 patch 002



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

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Wednesday, January 16, 2008 3:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Overview Console - ITSM 7 - Missing Incidents


** 
I've seen that if they don't get processed from the Interface_Create
form, but that's all.
 
Rick
 
On 1/16/08, T. Dee [EMAIL PROTECTED] wrote: 

Has anyone encountered the Overview Console not showing their
Incidents?

I see all the Changes and Tasks, but not Incidents. 

In Application Preferences I have Overview Console show
Incidents
and Tasks set to YES.

Thanks!!!



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



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

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

Re: Log SQL in Admin

It was a filter that I modified before.
 
Since you were talking about forms I opened a form, added a char field,
turned on logging and saved it, then stopped logging.
Started logging at 12:58:50
Hit save button maybe at 12:58:52
The first instance of VIEW is at 1:00:04
all actions completed by 1:00:12
 
It's moving a bit faster then normal because it's lunchtime here,
morning time it's at a crawl compared to now.
- 

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

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, January 16, 2008 12:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Log SQL in Admin


** Sql logs will log all sql to the db from arserver.  Chances
are the wait time between the select statements you have above are
because whatever is doing those queries is waiting on other things; this
is all irrelevant to you original issue though.  Find the logs relevant
to your operation.  If you are modifying a regular form, grep the logs
for 'VIEW'.  This will take you to the place in the logs where the db
view is dropped/created. 

Axton Grams


On Jan 16, 2008 3:09 PM, Wheeler, Dylan
[EMAIL PROTECTED] wrote:


** 
Thanks for that Frederick, didn't think it would log
admin changes. I tried it out and I've got almost a full minute on some
Remedy Application Service queries.
 
Queue: Admin  /* Wed Jan 16 2008 11:55:27.9490
*/SELECT T106.C1,C6 FROM T106 WHERE ((T106.C400123100 = '0') AND
(T106.C6  0)) ORDER BY 1 ASC
Queue: List  /* Wed Jan 16 2008 11:56:24.1980
*/SELECT TOP 1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch')
ORDER BY 3 ASC
 
Queue: Admin   /* Wed Jan 16 2008 11:55:27.9490
*/SELECT T106.C1,C6 FROM T106 WHERE ((T106.C400123100 = '0') AND
(T106.C6  0)) ORDER BY 1 ASC
Queue: List   /* Wed Jan 16 2008 11:56:24.1980
*/SELECT TOP 1001 T8.C1,T8.C1,T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch')
ORDER BY 3 ASC
 
Both of these are from modifying two different filters,
neither of which touches T106 which is OBJSTR:Class on my system. T106
only has 243 rows of data so no clue why it should take so long to
return a result.
- 



Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings  Loan Association, F.A. 

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


-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms,
Frederick W
Sent: Wednesday, January 16, 2008 10:47 AM
To: arslist@ARSLIST.ORG

Subject: Re: Log SQL in Admin


** 
I just looked and the SQL log on the server
shows the Admin commands that are executed (at least on Unix with
Oracle).
 
Fred




From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Wednesday, January 16, 2008 11:36 AM
To: arslist@ARSLIST.ORG
Subject: Log SQL in Admin


** 
Is it possible to log the sql queries the admin
tool makes when you modify a form?
I'm having major lag issues when I try and
update anything in my admin tool and it's frustrating the heck out of
me. It takes anywhere from 10 - 60 seconds for it to commit when I hit
the save button even on a minor modification to an active link. I
believe it's because the remote sql server is bogging down but I can't
prove it and I can't get the sql admins to look at it without any proof.
I have zero access to the sql server so I'm stuck without something to
get them to take a look.
Ideas anyone?
 
Windows 2003
ARS 6.3
MS SQL 2000

- 

Dylan Wheeler
Production Control Analyst Principal 
IT Operations

Re: Data types are not appropriate for relational operation (ARERR 313) Web Service

2008-01-16 Thread versicle

Thanks Misi...I was using Elements instead of Attributes.

Misi Mladoniczky wrote:

Hi,

The Start_Date and End_Date must be of type = dateTime.

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

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

All,

I have created a web service based on the Help Desk form. My goal is to
be
able to search for all tickets opened in a date range. I have entered the
qualification below for the OpGetList operation but receive the error,
Data
types are not appropriate for relational operation (ARERR 313). Any
ideas?

'Submit Date' = XPATH(/ROOT/Start_Date) AND 'Submit Date' =
XPATH(/ROOT/End_Date)

ARS 7.1 patch001 IM 7.0.02 patch006
--
View this message in context:
http://www.nabble.com/Data-types-are-not-appropriate-for-relational-operation-%28ARERR-313%29-Web-Service-tp14887669p14887669.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.

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

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

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

--
View this message in context:
http://www.nabble.com/Data-types-are-not-appropriate-for-relational-operation-%28ARERR-313%29-Web-Service-tp14887669p14896177.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Crystal Enterprise, Windows, Samba, and Solaris

2008-01-16 Thread William Rentfrow

We are running a mid-tier on Unix.  Crystal Enterprise 10 is on a
separate Windows box.
 
The config says you need to use Samba or another similar product to
mount the Windows file system from Solaris.  Has anyone done this
another way?  For example we might try dual mounted NAS shared between
the two machines.  The network people say it should work.  I have never
tried that before.
 
William Rentfrow, Principal Consultant
[EMAIL PROTECTED]
C 701-306-6157
O 952-432-0227
 

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

Site question for ITSM 7

2008-01-16 Thread Ron Legters

I've come across a stumbling block in configuring ITSM 7, and I'm wondering if 
anyone else has dealt with something similar:

Many of my company's locations across the country have two completely different 
organizations in the same building. For example, our San Jose location is 
currently set up in HD6 as both 'Western Region - WE1 District - San Jose' and 
'PPS Western - Pacific District - San Jose'. This is how the location info for 
people who work for these organizations comes over from the HR System. In ITSM 
7, though, I can't have two sites with the same name, even if they're in 
different regions and site groups.

I've got some thoughts about how to proceed, but I'd love to hear from someone 
else who may have dealt with this or something similar.

Thanks,
Ron Legters
Tools Administrator 
Data  Systems Services 
Univar USA Inc.
425.889.3952 Office
425.889.4111 Fax 
www.univarusa.com 

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

Re: Site question for ITSM 7

2008-01-16 Thread Sam Ferguson

Ron, the one time this became an issue for an implementation I was working on, 
we decided the quickest resolution was to prefix the site with a unique code to 
reflect the company or region.  This was seen where multiple companies have a 
site called Head Office.

Sam

___ 
Sam Ferguson . Senior Consultant . Planwell Technology 
Level 1, Korea House, 29 Tory Street, Wellington, New Zealand
ph: +64 4 385 2885. fax: +64 4 385 2911. mob: +64 21 388 704 
http://www.planwell.net
[EMAIL PROTECTED]
 
This is an email from Planwell Technology. It is confidential to the ordinary 
user of the e-mail address to which it was addressed and may contain copyright 
and/or legally privileged information. No one else may read, print, store, copy 
or forward any or all of this message or its attachments. If you receive this 
e-mail in error, please return it to the sender. Thank you.



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ron Legters
Sent: Thursday, 17 January 2008 12:42 p.m.
To: ARSList
Subject: Site question for ITSM 7

I've come across a stumbling block in configuring ITSM 7, and I'm wondering if 
anyone else has dealt with something similar:

Many of my company's locations across the country have two completely different 
organizations in the same building. For example, our San Jose location is 
currently set up in HD6 as both 'Western Region - WE1 District - San Jose' and 
'PPS Western - Pacific District - San Jose'. This is how the location info for 
people who work for these organizations comes over from the HR System. In ITSM 
7, though, I can't have two sites with the same name, even if they're in 
different regions and site groups.

I've got some thoughts about how to proceed, but I'd love to hear from someone 
else who may have dealt with this or something similar.

Thanks,
Ron Legters
Tools Administrator 
Data  Systems Services 
Univar USA Inc.
425.889.3952 Office
425.889.4111 Fax 
www.univarusa.com 

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

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

Re: Site question for ITSM 7

2008-01-16 Thread Ron Legters

That's a good idea, and I can see that working if had two sites with the same 
name. My issue is kind of the reverse - it's only one site, it just has two 
different org structures feeding into it. I'd rather not create two site 
records for one building, but that may be the best solution.

Thanks, 
Ron
Tools Admin

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Sam Ferguson
 Sent: Wednesday, January 16, 2008 4:02 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Site question for ITSM 7
 
 Ron, the one time this became an issue for an implementation I was working
 on, we decided the quickest resolution was to prefix the site with a
 unique code to reflect the company or region.  This was seen where
 multiple companies have a site called Head Office.
 
 Sam
 
 ___
 Sam Ferguson . Senior Consultant . Planwell Technology
 Level 1, Korea House, 29 Tory Street, Wellington, New Zealand
 ph: +64 4 385 2885. fax: +64 4 385 2911. mob: +64 21 388 704
 http://www.planwell.net
 [EMAIL PROTECTED]
 
 This is an email from Planwell Technology. It is confidential to the
 ordinary user of the e-mail address to which it was addressed and may
 contain copyright and/or legally privileged information. No one else may
 read, print, store, copy or forward any or all of this message or its
 attachments. If you receive this e-mail in error, please return it to the
 sender. Thank you.
 
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Ron Legters
 Sent: Thursday, 17 January 2008 12:42 p.m.
 To: ARSList
 Subject: Site question for ITSM 7
 
 I've come across a stumbling block in configuring ITSM 7, and I'm
 wondering if anyone else has dealt with something similar:
 
 Many of my company's locations across the country have two completely
 different organizations in the same building. For example, our San Jose
 location is currently set up in HD6 as both 'Western Region - WE1 District
 - San Jose' and 'PPS Western - Pacific District - San Jose'. This is how
 the location info for people who work for these organizations comes over
 from the HR System. In ITSM 7, though, I can't have two sites with the
 same name, even if they're in different regions and site groups.
 
 I've got some thoughts about how to proceed, but I'd love to hear from
 someone else who may have dealt with this or something similar.
 
 Thanks,
 Ron Legters
 Tools Administrator
 Data  Systems Services
 Univar USA Inc.
 425.889.3952 Office
 425.889.4111 Fax
 www.univarusa.com
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

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

Re: Site question for ITSM 7

2008-01-16 Thread Phil Murnane

Ron:

Wasn't there something about an alias name for a site?  I don't have the docs 
handy at the moment, but that idea is tickling the back of my brain.

FWIW,
--Phil

- Original Message 
From: Ron Legters [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, January 16, 2008 5:09:09 PM
Subject: Re: Site question for ITSM 7

That's a good idea, and I can see that working if had two sites with the same 
name. My issue is kind of the reverse - it's only one site, it just has two 
different org structures feeding into it. I'd rather not create two site 
records for one building, but that may be the best solution.

Thanks, 
Ron
Tools Admin

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Sam Ferguson
 Sent: Wednesday, January 16, 2008 4:02 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Site question for ITSM 7
 
 Ron, the one time this became an issue for an implementation I was working
 on, we decided the quickest resolution was to prefix the site with a
 unique code to reflect the company or region.  This was seen where
 multiple companies have a site called Head Office.
 
 Sam
 
 ___
 Sam Ferguson . Senior Consultant . Planwell Technology
 Level 1, Korea House, 29 Tory Street, Wellington, New Zealand
 ph: +64 4 385 2885. fax: +64 4 385 2911. mob: +64 21 388 704
 http://www.planwell.net
 [EMAIL PROTECTED]
 
 This is an email from Planwell Technology. It is confidential to the
 ordinary user of the e-mail address to which it was addressed and may
 contain copyright and/or legally privileged information. No one else may
 read, print, store, copy or forward any or all of this message or its
 attachments. If you receive this e-mail in error, please return it to the
 sender. Thank you.
 
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Ron Legters
 Sent: Thursday, 17 January 2008 12:42 p.m.
 To: ARSList
 Subject: Site question for ITSM 7
 
 I've come across a stumbling block in configuring ITSM 7, and I'm
 wondering if anyone else has dealt with something similar:
 
 Many of my company's locations across the country have two completely
 different organizations in the same building. For example, our San Jose
 location is currently set up in HD6 as both 'Western Region - WE1 District
 - San Jose' and 'PPS Western - Pacific District - San Jose'. This is how
 the location info for people who work for these organizations comes over
 from the HR System. In ITSM 7, though, I can't have two sites with the
 same name, even if they're in different regions and site groups.
 
 I've got some thoughts about how to proceed, but I'd love to hear from
 someone else who may have dealt with this or something similar.
 
 Thanks,
 Ron Legters
 Tools Administrator
 Data  Systems Services
 Univar USA Inc.
 425.889.3952 Office
 425.889.4111 Fax
 www.univarusa.com
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

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


  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

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

Re: Site question for ITSM 7

2008-01-16 Thread Sam Ferguson

I misunderstood the problem.  You can configure your location structure and 
your organisational structures independently of each other.  Can you setup 
organisations to separate the business?  This would then allow people to belong 
to one site and the appropriate organisation without creating two sites.

Sam

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ron Legters
Sent: Thursday, 17 January 2008 1:09 p.m.
To: ARSList
Subject: Re: Site question for ITSM 7

That's a good idea, and I can see that working if had two sites with the same 
name. My issue is kind of the reverse - it's only one site, it just has two 
different org structures feeding into it. I'd rather not create two site 
records for one building, but that may be the best solution.

Thanks, 
Ron
Tools Admin

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Sam Ferguson
 Sent: Wednesday, January 16, 2008 4:02 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Site question for ITSM 7
 
 Ron, the one time this became an issue for an implementation I was working
 on, we decided the quickest resolution was to prefix the site with a
 unique code to reflect the company or region.  This was seen where
 multiple companies have a site called Head Office.
 
 Sam
 
 ___
 Sam Ferguson . Senior Consultant . Planwell Technology
 Level 1, Korea House, 29 Tory Street, Wellington, New Zealand
 ph: +64 4 385 2885. fax: +64 4 385 2911. mob: +64 21 388 704
 http://www.planwell.net
 [EMAIL PROTECTED]
 
 This is an email from Planwell Technology. It is confidential to the
 ordinary user of the e-mail address to which it was addressed and may
 contain copyright and/or legally privileged information. No one else may
 read, print, store, copy or forward any or all of this message or its
 attachments. If you receive this e-mail in error, please return it to the
 sender. Thank you.
 
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Ron Legters
 Sent: Thursday, 17 January 2008 12:42 p.m.
 To: ARSList
 Subject: Site question for ITSM 7
 
 I've come across a stumbling block in configuring ITSM 7, and I'm
 wondering if anyone else has dealt with something similar:
 
 Many of my company's locations across the country have two completely
 different organizations in the same building. For example, our San Jose
 location is currently set up in HD6 as both 'Western Region - WE1 District
 - San Jose' and 'PPS Western - Pacific District - San Jose'. This is how
 the location info for people who work for these organizations comes over
 from the HR System. In ITSM 7, though, I can't have two sites with the
 same name, even if they're in different regions and site groups.
 
 I've got some thoughts about how to proceed, but I'd love to hear from
 someone else who may have dealt with this or something similar.
 
 Thanks,
 Ron Legters
 Tools Administrator
 Data  Systems Services
 Univar USA Inc.
 425.889.3952 Office
 425.889.4111 Fax
 www.univarusa.com
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
 
 __
 _
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

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

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

Force Users to Use Update Button

2008-01-16 Thread James Collins

I have a form, that has a status field.  It gets updated by a button
that pulls up a menu of status.  People keep free forming in the
status field which screws up the status etc.,  I changed the
permissions of the field but that does not allow the users to update
with the update button.  My other thought was to run an active link
that triggers an error on gain focus.  Which works, however, i am not
sure it is the correct method.  I just do not want to see in my status
field  missppelled statuses like Klosed or ClOsed  or whatever, any
helpful hints?

James

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

Re: Force Users to Use Update Button