ARS 7.0.01 ITSM 7 - Performance - SLM SVTs

2008-04-22 Thread Melanie Snayer
Hi Listeners



We seem to be having a problem with performance and are trying to isolate
the problem. One of the areas is the number of Service Targets we have. We
have about 1400 Service Targets and are slowly increasing and we are fearing
that this number of Service Targets may be hampering the performance.



How many Service Targets do you guys have?



Your input would be much appreciated.



Thanks

*Melanie Snayer*
***BMC Remedy Technical Consultant*
***African Legend Indigo*
***Tel   +27116360368*
***Mobile +27825686205*
*Web **www.alindigo.com* http://www.alindigo.com/

[image: cid:image001.gif@01C86808.DDBF0690]

This e-mail and attachments relating thereto, is intended for the
above-mentioned recipient. If you have received this e-mail in error, kindly
notify the sender and delete it immediately as it contains information
relating to the official business of African Legend Indigo (Pty) Limited,
which is confidential, legally privileged and proprietary to African Legend
Indigo (Pty) Limited. African Legend Indigo (Pty) Limited does not own and
endorse any other content. The views and opinions expressed in this e-mail
are those of the sender unless clearly stated as being those of African
Legend Indigo (Pty) Limited.

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


Re: BMC Remedy - Copy to Archive and Delete from Source

2008-04-01 Thread Melanie Snayer
Hi Susan

Thanks so much for this info. What database are you running on and on what
platform?

Mel


On 3/26/08, Susan Palmer [EMAIL PROTECTED] wrote:

 ** Mel,

 I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
 those forms keeps performance at an acceptable level.  You have to remember
 that all workflow is affected by the number of records in the form and keep
 in mind any table fields that are refreshed.

 We generally keep 13 months of or closed records.

 Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
 option.  In the last month I've used it on HTs, Tasks and email messages.
 For us it appears to require a huge amount of disk space for the copy/delete
 option.  That needs to be planned for and it was greater than 1 for 1 which
 is logical since another table is now holding the same record.  For us it
 was quite a bit more than that infact we nearly brought the server down.

 I only archive in the lowest of production hours (night) when minimal
 users are on the system.

 I was also notified yesterday that it is not recommended to archive system
 email messages, there is some unusal result related to it.  Sorry did not
 get more info.

 I found the actual archiving to go fairly quick, was doing about 70k
 records both times.  I liked the fact I didn't have to manually delete the
 records afterwards.

 hth,
 Susan

 ShopperTrak


 On Wed, Mar 26, 2008 at 8:28 AM, Melanie Snayer [EMAIL PROTECTED]
 wrote:

  ** Hi Joe
 
  Thanks so much for this information. Would you perhaps be able to tell
  me whether there was a delay on saving Help Desk tickets before you
  archived?
 
  Regards
  Mel
 
 
On 3/26/08, Joseph Kasell [EMAIL PROTECTED] wrote:
  
   Mel,
  
   We're running 7.0.1 with ITSM 6.  We instituted archiving a little
   over a
   month ago, it was sorely needed, and it certainly has made a
   difference.
   Since Remedy was put into production back in the summer of 2004,
   approx
   390,000 tickets had been submitted.  The amount of tickets had not
   been a
   problem until recently when we began to see performance lags
   performing
   various actions in Remedy.  Opening an existing Help Desk ticket from
   the
   Remedy Support console alone was taking anywhere from 1 to 5 seconds
   depending on the ticket (API and SQL logs were very helpful here).
  
   We decided to archive all Help Desk tickets with a status of Closed
   that
   were older than 13 months.  We considered using Remedy's archiving
   feature,
   but eventually went with Misi Mladoniczky's rrrchive utility.  Since
   our
   lab testing indicated that the archiving of an estimated 250,000
   tickets
   would take about 6 to 7 hours (and slow the system down tremendously),
   we
   decided to archive in chunks of 40,000 which limited the performance
   pain
   to about an hour.  We did this for 7 nights in a row.  I can tell you
   that
   since, performance has improved tremendously (max time to open an
   existing
   ticket is about a second).  Archiving is done nightly now.  It takes a
   minute to archive the 400 to 500 tickets that meet the archive
   criteria.  I
   know that my users are happy.
  
   Joe
  
   Joseph Kasell
   Navy Federal Credit Union
  
  
  
  
   Melanie Snayer
   [EMAIL PROTECTED]
   MAIL.COM http://mail.com/
 To
   Sent by: Action  arslist@ARSLIST.ORG
   Request System
   cc
   discussion
  
   list(ARSList)Subject
   [EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
   ORG  and Delete from Source
  
  
   03/26/2008 05:45
   AM
  
  
   Please respond to
   [EMAIL PROTECTED]
  RG
  
  
  
  
  
  
   --=_Part_6872_1105761.1206524742321
   Content-Type: text/plain; charset=WINDOWS-1252
   Content-Transfer-Encoding: quoted-printable
   Content-Disposition: inline
  
   Hey Thivagar
  
   We are in a 7.01 environment but I'm glad to know that this improved
   on
   performance. Could you perhaps give me a rough indication of the
   following information:
  
 - what your database size is
 - number of records before the archive
 - time taken to save a call before the archive
 - number of records after the archive
 - time taken to save a call after the archive
  
   Anyone else like to share a bit of their archiving info with me?
  
   Regards
   Mel
  
   On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED]
   wrote:
  
**
   
Hi Mel,
   
   
   
Recently I have archived the data in my 6.3 environment. I have done
   this
to improve the performance and I observe the performance has been
   improve=
   d
considerably. But the issue was, the Copy to Archive and Delete from
Source option was not working

Re: BMC Remedy - Copy to Archive and Delete from Source

2008-04-01 Thread Melanie Snayer
Hey Chintan

Thanks for this info. As for your question, I have not come across any
documentation with information regarding max number of records in a table
and I doubt one would be released. The number of records that can be stored
in a form would depend on many different elements such as:

   - Number of and types of fields in the form
   - Number of forms in the database
   - Database size
   - Disk space
   - etc.

Regards
Mel


On 3/26/08, Chintan Shah [EMAIL PROTECTED] wrote:

 ** Mel,

 Last weekend we archived 120,000 records in less than 3 hours.

 We have 2 servers(production and reporting). Data gets DSO'ed from
 production to reporting all the time. So, we actually performed archivingon 
 reporting server.

 We only used Copy to Archive functionality. There was no performance
 impact whatsoever during the entire proecess.  I have not tested copy to
 archive and delete from source functionality.

 Our approach was like this
 1. Take backup of all records you want to delete( in .arx file).
 2. Have DBA take backup in a .dmp file.
 3. Start Copy to Archive on the form you want to archive.

 Verify that we have same number of records(based on criteria u specify) on
 archived form as we have on source form.

 Now, the BIG part. We experience memory issues while deleting data using
 escalation.  One of our consultants proposed an excellent solution for
 deleting data.

 1. Export only ID's of the records that you want to delete in .arx file.
 Use same criteria as you used for archiving.
 2. Use a filter that fires on Merge and that performs an
 Application-Delete-Entry operation.

 This approach is as good as deleting 1 record at a time and has NO impact
 on server whatsoever.

 So, as soon as you start importing the data through Remedy Import Tool,
 filter will fire and it will delete the record from production. As we have
 DSO in place, it will eventually delete from other server too.

 If you don't have separate reporting server, then you are pretty much done
 with process.

 It took almost 12:30 hours to delete all records with no user impact.

 By the way, I have a question. Is there any documentation available saying
 that This is the max limit that Remedy can handle for good performance.

 Some of our forms have more than million records. Thanks for help in
 advance.

 Hope this helps.

 Thanks
 Chintan.

 *Joseph Kasell [EMAIL PROTECTED]* wrote:

 Mel,

 We're running 7.0.1 with ITSM 6. We instituted archiving a little over a
 month ago, it was sorely needed, and it certainly has made a difference.
 Since Remedy was put into production back in the summer of 2004, approx
 390,000 tickets had been submitted. The amount of tickets had not been a
 problem until recently when we began to see performance lags performing
 various actions in Remedy. Opening an existing Help Desk ticket from the
 Remedy Support console alone was taking anywhere from 1 to 5 seconds
 depending on the ticket (API and SQL logs were very helpful here).

 We decided to archive all Help Desk tickets with a status of Closed that
 were older than 13 months. We considered using Remedy's archiving feature,
 but eventually went with Misi Mladoniczky's rrrchive utility. Since our
 lab testing indicated that the archiving of an estimated 250,000 tickets
 would take about 6 to 7 hours (and slow the system down tremendously), we
 decided to archive in chunks of 40,000 which limited the performance pain
 to about an hour. We did this for 7 nights in a row. I can tell you that
 since, performance has improved tremendously (max time to open an existing
 ticket is about a second). Archiving is done nightly now. It takes a
 minute to archive the 400 to 500 tickets that meet the archive criteria. I
 know that my users are happy.

 Joe

 Joseph Kasell
 Navy Federal Credit Union




 Melanie Snayer

 MAIL.COM http://mail.com/ To
 Sent by: Action arslist@ARSLIST.ORG
 Request System cc
 discussion
 list(ARSList) Subject

 ORG and Delete from Source


 03/26/2008 05:45
 AM


 Please respond to
 [EMAIL PROTECTED]
 RG






 --=_Part_6872_1105761.1206524742321
 Content-Type: text/plain; charset=WINDOWS-1252
 Content-Transfer-Encoding: quoted-printable
 Content-Disposition: inline

 Hey Thivagar

 We are in a 7.01 environment but I'm glad to know that this improved on
 performance. Could you perhaps give me a rough indication of the
 following information:

 - what your database size is
 - number of records before the archive
 - time taken to save a call before the archive
 - number of records after the archive
 - time taken to save a call after the archive

 Anyone else like to share a bit of their archiving info with me?

 Regards
 Mel

 On 3/26/08, Thivagar Sankaran wrote:

  **
 
  Hi Mel,
 
 
 
  Recently I have archived the data in my 6.3 environment. I have done
 this
  to improve the performance and I observe the performance has been
 improve=
 d
  considerably. But the issue was, the Copy to Archive and Delete from
  Source option

BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Melanie Snayer
Hi Listeners

We're experiencing performance issues especially when submitting
incidents. Our initial plan was to archive calls that have been closed for
more than 5 years but as a result of the performance issues we're having to
considering archiving as soon as 1 year and 6 months after having gone-live.
Well, archiving is just one of the options that we have resorted to along
side the current ongoing perfomance tuning that we're doing.

Can you guys give me examples of how you may have gone about archiving your
data? Like what the archiving criteria is and whether your archiving was
done as a result of performance issue or as standard procedure.

Thanks
Mel

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


Re: BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Melanie Snayer
Hey Thivagar

We are in a 7.01 environment but I'm glad to know that this improved on
performance. Could you perhaps give me a rough indication of the
following information:

   - what your database size is
   - number of records before the archive
   - time taken to save a call before the archive
   - number of records after the archive
   - time taken to save a call after the archive

Anyone else like to share a bit of their archiving info with me?

Regards
Mel

On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED] wrote:

 **

 Hi Mel,



 Recently I have archived the data in my 6.3 environment. I have done this
 to improve the performance and I observe the performance has been improved
 considerably. But the issue was, the Copy to Archive and Delete from
 Source option was not working in my environment. Hence I went for Copy to
 Archive Option and deleted the data manually. I have raised this issue with
 BMC. But as usual I didn't get a proper response.



 Thanks  Regards,

 Thivagar Sankaran

 ITIL – Foundataion Certified

 Remedy Developer


  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
 *Sent:* Wednesday, March 26, 2008 2:44 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* BMC Remedy - Copy to Archive and Delete from Source



 **

 Hi Listeners



 We're experiencing performance issues especially when submitting
 incidents. Our initial plan was to archive calls that have been closed for
 more than 5 years but as a result of the performance issues we're having to
 considering archiving as soon as 1 year and 6 months after having gone-live.
 Well, archiving is just one of the options that we have resorted to along
 side the current ongoing perfomance tuning that we're doing.



 Can you guys give me examples of how you may have gone about archiving
 your data? Like what the archiving criteria is and whether your archiving
 was done as a result of performance issue or as standard procedure.



 Thanks

 Mel

 __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: BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Melanie Snayer
Hi Joe

Thanks so much for this information. Would you perhaps be able to tell me
whether there was a delay on saving Help Desk tickets before you archived?

Regards
Mel


On 3/26/08, Joseph Kasell [EMAIL PROTECTED] wrote:

 Mel,

 We're running 7.0.1 with ITSM 6.  We instituted archiving a little over a
 month ago, it was sorely needed, and it certainly has made a difference.
 Since Remedy was put into production back in the summer of 2004, approx
 390,000 tickets had been submitted.  The amount of tickets had not been a
 problem until recently when we began to see performance lags performing
 various actions in Remedy.  Opening an existing Help Desk ticket from the
 Remedy Support console alone was taking anywhere from 1 to 5 seconds
 depending on the ticket (API and SQL logs were very helpful here).

 We decided to archive all Help Desk tickets with a status of Closed that
 were older than 13 months.  We considered using Remedy's archiving
 feature,
 but eventually went with Misi Mladoniczky's rrrchive utility.  Since our
 lab testing indicated that the archiving of an estimated 250,000 tickets
 would take about 6 to 7 hours (and slow the system down tremendously), we
 decided to archive in chunks of 40,000 which limited the performance pain
 to about an hour.  We did this for 7 nights in a row.  I can tell you that
 since, performance has improved tremendously (max time to open an existing
 ticket is about a second).  Archiving is done nightly now.  It takes a
 minute to archive the 400 to 500 tickets that meet the archive
 criteria.  I
 know that my users are happy.

 Joe

 Joseph Kasell
 Navy Federal Credit Union




 Melanie Snayer
 [EMAIL PROTECTED]
 MAIL.COM  To
 Sent by: Action  arslist@ARSLIST.ORG
 Request System cc
 discussion
 list(ARSList)Subject
 [EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
 ORG  and Delete from Source


 03/26/2008 05:45
 AM


 Please respond to
 [EMAIL PROTECTED]
RG






 --=_Part_6872_1105761.1206524742321
 Content-Type: text/plain; charset=WINDOWS-1252
 Content-Transfer-Encoding: quoted-printable
 Content-Disposition: inline

 Hey Thivagar

 We are in a 7.01 environment but I'm glad to know that this improved on
 performance. Could you perhaps give me a rough indication of the
 following information:

   - what your database size is
   - number of records before the archive
   - time taken to save a call before the archive
   - number of records after the archive
   - time taken to save a call after the archive

 Anyone else like to share a bit of their archiving info with me?

 Regards
 Mel

 On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED] wrote:

  **
 
  Hi Mel,
 
 
 
  Recently I have archived the data in my 6.3 environment. I have done
 this
  to improve the performance and I observe the performance has been
 improve=
 d
  considerably. But the issue was, the Copy to Archive and Delete from
  Source option was not working in my environment. Hence I went for Copy
 to
  Archive Option and deleted the data manually. I have raised this issue
 wi=
 th
  BMC. But as usual I didn't get a proper response.
 
 
 
  Thanks  Regards,
 
  Thivagar Sankaran
 
  ITIL =96 Foundataion Certified
 
  Remedy Developer
 
 
   --
 
  *From:* Action Request System discussion list(ARSList) [mailto:
  [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
  *Sent:* Wednesday, March 26, 2008 2:44 PM
  *To:* arslist@ARSLIST.ORG
  *Subject:* BMC Remedy - Copy to Archive and Delete from Source
 
 
 
  **
 
  Hi Listeners
 
 
 
  We're experiencing performance issues especially when submitting
  incidents. Our initial plan was to archive calls that have been closed
 fo=
 r
  more than 5 years but as a result of the performance issues we're having
 =
 to
  considering archiving as soon as 1 year and 6 months after having
 gone-li=
 ve.
  Well, archiving is just one of the options that we have resorted to
 along
  side the current ongoing perfomance tuning that we're doing.
 
 
 
  Can you guys give me examples of how you may have gone about archiving
  your data? Like what the archiving criteria is and whether your
 archiving
  was done as a result of performance issue or as standard procedure.
 
 
 
  Thanks
 
  Mel
 
  __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

Risk Level inconsistency within Change Management 7.0.01 and Approval Engine 7.0.01

2007-10-17 Thread Melanie Snayer
Hey there listeners

I have found that the Risk Levels within the Change Management Module
V7.0.01 and the Approval Engine V7.0.01 are inconsistent. In Change
Management the highest Risk Level is 5 and the lowest is 1 but in the
Approval Engine the highest Risk Level is 1 and the lowest is 5. This is
causing the approval mappings not to work as expected.

Has anyone come across this little bug? Any ideas as to how to get around
this?

Regards
Mel

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


Re: Change Management v7 Approvals

2007-10-03 Thread Melanie Snayer
Hi Eli

Could you perhaps tell me what size your company is. About how many
departments/business units, how many users, how many approvers per
department/business unit?

Thanks
Mel


On 9/26/07, Eli Schilling [EMAIL PROTECTED] wrote:

 Hi Melanie,

 We have 4 different approval processes and they vary slightly based on
 several different things.  In the config change approvals form we have
 something like 35 records for the various mappings.  You either have to be
 very general and hope it catches everything (i.e. map the process to a
 change type or a impact, etc) or be very specific; whereby each approval
 mapping has a value selected in virtually every field.  We chose the latter
 of the two options to ensure that no changes sneak by the approval process.

 Cheers!

 Eli

 

 From: Action Request System discussion list(ARSList) on behalf of Melanie
 Snayer
 Sent: Tue 9/25/2007 11:26 PM
 To: arslist@ARSLIST.ORG
 Subject: Change Management v7 Approvals


 **
 Hi Listeners

 We are in the process of implementing Change Management v7 and have even
 created three more approval processes (this client's pretty stringent about
 control). We have now come to the point where we have to configure approval
 mappings for all of these approval processes and are not quite sure how
 detailed they should be. I know that the approvals can be configured based
 on various different criteria  e.g. Impacted areas, Operation Cat, Product
 Cat, etc. Now this (approval criteria) is quite a bit of information to
 consider so I would like to know what other organisations have base their
 approvals on, i.e. how detailed they are and how it seems to be working
 for them.

 Any info would be greatly appreciated.

 Thanks  Kind Regards
 Mel
 __20060125___This posting was submitted with HTML in
 it___


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


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


Change Management v7 Approvals

2007-09-26 Thread Melanie Snayer
Hi Listeners

We are in the process of implementing Change Management v7 and have even
created three more approval processes (*this client's pretty stringent about
control*). We have now come to the point where we have to configure approval
mappings for all of these approval processes and are not quite sure how
detailed they should be. I know that the approvals can be configured based
on various different criteria e.g. Impacted areas, Operation Cat, Product
Cat, etc. Now this (approval criteria) is quite a bit of information to
consider so I would like to know what other organisations have base their
approvals on, i.e. how detailed they are and how it seems to be working
for them.

Any info would be greatly appreciated.

Thanks  Kind Regards
Mel

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


Re: Attachment Pool Mid Tier (7.0.1 Patch 003)

2007-08-27 Thread Melanie Snayer
Hi Lisa

Could I ask why you're using an Active link to open your attachment instead
of using the functionality build into the attachment pool field?

Mel


On 8/27/07, Kemes, Lisa [EMAIL PROTECTED] wrote:

 **

 When I invoke the Active Link: $PROCESS$ PERFORM-ACTION-OPEN-ATTACHMENT
 536880912 on the Mid Tier, it opens the attachment, but also deletes it from
 the record.  This happened in Mid Tier 6.3 as well….

 *Lisa Kemes *
 BMC Remedy Developer
 Tyco Electronics
 717-810-2408 tel
 717-810-2124 fax
 [EMAIL PROTECTED]
 __20060125___This posting was submitted with HTML in
 it___

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


re-initialising the escalation thread

2007-07-30 Thread Melanie Snayer
Hi Listeners

Do you guys know of anyway that the escalation thread could be
re-initialised without restarting the ARS service? None of our escalations
are being executed on but we cannot restart our production service.

Any help would be appreciated.

Regards
Mel

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


Re: re-initialising the escalation thread

2007-07-30 Thread Melanie Snayer
Thank you Paul.

I've just tried this and it's done the trick. I have no idea what caused it
to stop though as there are no errors logged.

Thanks again
Mel


On 7/30/07, Clements, Paul [EMAIL PROTECTED] wrote:

 **

 Hi,



 Have you tried:



 · Server Information

 · Configuration

 · Check 'Disable Escalations' (Stops current escalations thread)

 · Apply

 · Uncheck 'Disable Escalations' (Starts new escalations thread)

 Cheers,

 Paul Clements
 IT Professional Officer
 Glasgow City Council
 Centenary House
 100 Morrison Street
 Glasgow G5 8LN

 Phone: 0141 418 1332
 Email:  [EMAIL PROTECTED]
 Web: www.glasgow.gov.uk

 -Original Message-
 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
 *Sent:* 30 July 2007 11:39
 *To:* arslist@ARSLIST.ORG
 *Subject:* re-initialising the escalation thread



 **

 Hi Listeners



 Do you guys know of anyway that the escalation thread could be
 re-initialised without restarting the ARS service? None of our escalations
 are being executed on but we cannot restart our production service.



 Any help would be appreciated.



 Regards

 Mel

 __20060125___This posting was submitted with HTML in
 it___


 Support Scotland's Bid to host the 2014 Commonwealth Games in Glasgow -
 visit www.glasgow2014.com


 
 Disclaimer:
 This message is intended only for use of the addressee. If this message
 was sent to you in error, please notify the sender and delete this
 message.
 Glasgow City Council cannot accept responsibility for viruses, so please
 scan attachments. Views expressed in this message do not necessarily
 reflect
 those of the Council who will not necessarily be bound by its contents.

 
 __20060125___This posting was submitted with HTML in
 it___

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


Re: Can not delete a 'deleted' field?

2007-06-12 Thread Melanie Snayer

Hi Neel

If the form that you've deleted the field from has more than one view the
field may still appear in a view from which you have not deleted it.

If there is only a single view be sure to close the form after having
deleted the field holding the ID you still need to use. The system can be
finicky like that sometimes.

Regards
Mel


On 6/12/07, Neel Guatam [EMAIL PROTECTED] wrote:


**

Hello listers,



I had added a field with some ID. Then I deleted the field not knowing
that even deleting the filed and saving the changes won't let me add the
field with the same ID! I have to have the same ID as I am pushing fields on
this form based on matching ids. How can I completely delete the field so
that it won't show up in the find field list in admin client as well as it
would let me add another field with the same id?



Thank you,



*Neel Gautam*

Accenture - Chicago Delivery Centre

Office:  312-693-7279   Mobile:  630-440-6335

MSN: [EMAIL PROTECTED] AIM: neelgautam



Core Values:

Stewardship

·

Best People

·

Client Value Creation

·

One Global Network

·

Respect for the Individual

·

Integrity





This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete the
original. Any other use of the email by you is prohibited.
__20060125___This posting was submitted with HTML in
it___


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


Re: FW: Cannot connect to sql via Remedy

2007-02-19 Thread Melanie Snayer

Hey Graham

When she confirmed about the ARAdmin user being dbo I thought she may have
changed this manually but she had used the sp_changedbowner command and
still no luck.

She's now decided to just drop the current db and then restore. Not sure how
much of a difference that's going to make but it's worth a try.

Anymore ideas would come in handy though.

Regards
Mel


On 2/19/07, Melanie Snayer [EMAIL PROTECTED] wrote:


Hey Graham

Thanks so much. I will pass this on in the hope that it helps.

Regards
Mel


On 2/19/07, Averell, Graham [EMAIL PROTECTED] wrote:

   Hi Mel,



 The following link may help
 http://www.opensubscriber.com/message/[EMAIL PROTECTED]/1831526.html



 I also have to run SP_Changedbowner 'ARAdmin' from query analyser when
 restoring the database to other MS SQL servers.



 Good Luck,

 Graham




  --

 *From:* Action Request System discussion list(ARSList) [mailto:
 [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
 *Sent:* 19 February 2007 13:49
 *To:* arslist@ARSLIST.ORG
 *Subject:* Cannot connect to sql via Remedy



 **

 Hey Listeners



 I'm trying to help a friend... no, really it is a friend, not me in need
 of the help here :)



 She's restored the MS SQL DB while running a routine DR process check
 but now cannot seem to start the ARS Service. She can confirm that ARA dmin
 is dbo and user on the system and that she can connect to sql fine, but not
 via the remedy services.



 The arerror.log file shows the below errors, which all indicate that
 there are problems with the network connection to the DB that the ARS cannot
 see.



 Any ideas?

 Regards

 Mel



 *arerror.log extract:*

 Sun Feb 18 16:13:51 2007  390600 : Failure while trying to connect to
 the SQL database.

 Please ensure the SQL database is running or contact the Database
 Administrator for help (ARERR 550)

 Sun Feb 18 16:13:51 2007

 Sun Feb 18 16:13:51 2007  390600 : Cannot initialize contact with SQL
 database (ARERR 551)

 Sun Feb 18 16:13:51 2007 Stop server

 Sun Feb 18 16:13:51 2007  390600 : AR System server terminated -- fatal
 error encountered (ARNOTE 21)

 Sun Feb 18 16:28:11 2007  390600 : Failure during SQL operation to the
 database (ARERR 552)

 Sun Feb 18 16:28:11 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL
 Server does not exist or access denied. (SQL Server 17)

 Sun Feb 18 16:28:11 2007  390600 : SQL database is not available -- will
 retry connection (ARNOTE 590)

 Mon Feb 19 09:08:50 2007  390600 : Failure during SQL operation to the
 database (ARERR 552)

 Mon Feb 19 09:08:50 2007 [DBNETLIB][ConnectionOpen
 (PreLoginHandshake()).]General network error. Check your network
 documentation. (SQL Server 11)



 __20060125___This posting was submitted with HTML in
 it___

 Click 
herehttps://www.mailcontrol.com/sr/4BE5D23QH6Pcohtw78djye89wTG0NZAYxqNjwKxxynRZGuv68LxTRfz9pKcItbSMiKh7Tlu+fFDQz5exjdqrRw==to
 report this email as spam.

 This e-mail (and any attachments) contains information, which is
 confidential and intended solely for the attention and use of the named
 addressee(s). If you are not the intended recipient you must not copy,
 distribute or use it for any purpose or disclose the contents to any person.
 If you have received this e-mail in error, please notify us immediately at
 [EMAIL PROTECTED] The information contained in this e-mail (and any
 attachments) is supplied in good faith, but the sender shall not be under
 any liability in damages or otherwise for any reliance that may be placed
 upon it by the recipient. Any comments or opinions expressed are those of
 the originator not of NTT Europe Ltd. unless otherwise expressly stated.

 NTT Europe Limited is a company registered in England and Wales with
 company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon
 house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone
 +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link:
 http://www.ntt.eu






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


ITSM Email Config vs CS Email Config

2006-12-18 Thread Melanie Snayer

Hey Guys

I have had ITSM 6 running on ARS Server 6.3 for a few months using an email
config for email notifications  recently implemented Customer Support
5.6on the same ARS Server but I can't seem to get CS to use a
different email
config for its email notifications. In the Email Config form the
'Application' field only has Customer Support for me to choose from but if
I do this for the Customer Support-Email config the system still only uses
the one I had originally setup for ITSM to use.

Any suggestions.

Regards
Mel

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


Change the $OPERATION$ of a form with workflow

2006-11-16 Thread Melanie Snayer

Hey Guys

I'm not sure whether this is me taking a long shot or not but I need to know
whether the $OPERATION$ of a form can be modified with workflow.

Is this possible? If so please help me with it.

Regards
Mel

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


Re: No Holiday Definition Exists with the Specify Tag

2006-11-13 Thread Melanie Snayer
**
Fritz,

I just remembered! What I had to do isputmy Holiday time tag in double quotes... did you try this.

If you haven't then you'll noticein the logs (I can't remember what log file but I'm pretty sure it was the SQL log)that the holiday time tag resolves a date and timefield with a space between them. It's the space thatthe system doesn't like!


Hope this helps.

Mel
On 11/10/06, Fritz Cornelissen [EMAIL PROTECTED] wrote:
** 


Hi all,

Wonder if you can help me please. On the change module of ITSM 6.0 running on ARS 6.3 I am getting the following error: No Holiday Definition Exists with the Specify Tag, on modify.


This use to be a bug in version 5 and 4. Did anyone experience this in 6.0?

Kind regards,
Fritz__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: Filter doesn't fire for $VUI$ = Requester

2006-10-26 Thread Melanie Snayer
Title: RE: Filter doesn't fire for $VUI$ = Requester
**





Hey,


I had this problem once as well.
You will need to create a tempFormView field and on open window of the form, set this field to the value of $VUI$. Thus if the user open's the requester view Requester will be written to that field. Then base your filter on the tempFormView field.

Hope this helps


Melanie Snayer
Remedy Technical Consultant
BMC Profesional Services
African Legend Indigo (Pty) Ltd
S/B: +27 11 808 6300
Dir : +27 11 808 6368
Fax: +27 11 802 0797
Cell: +27 82 568 6205
www.alindigo.com

This e-mail and attachments relating thereto, is intended for the above-mentioned recipient. If you have received this e-mail in error, kindly notify the sender and delete it immediately as it contains information relating to the official business of African Legend Indigo (Pty) Limited, which is confidential, legally privileged and proprietary to African Legend Indigo (Pty) Limited. African Legend Indigo (Pty) Limited does not own and endorse any other content. The views and opinions expressed in this e-mail are those of the sender unless clearly stated as being those of African Legend Indigo (Pty) Limited.


-Original Message-
From: GoDario27 [mailto:[EMAIL PROTECTED]] 
Sent: 26 October 2006 08:42 PM
To: arslist@ARSLIST.ORG
Subject: Filter doesn't fire for $VUI$ = Requester


I want to send a notification to my helpdesk team any time a user goes to the
Requester Console (web or client) and updates information in the Details
field. However, when I use $VUI$ = Requester in my filter, it doesn't
seem to fire. If I use other criteria, it does -- but I only want it to
happen when the user is in the Requester Console.


Any suggestions??
-- 
View this message in context: http://www.nabble.com/Filter-doesn%27t-fire-for-%24VUI%24-%3D-%22Requester%22-tf2515866.html#a7017250

Sent from the ARS (Action Request System) mailing list archive at Nabble.com.


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




__20060125___This posting was submitted with HTML in it___