Re: Why do service requests require a Login ID?

2014-01-21 Thread SUBSCRIBE ARSLIST theReel
Thanks for the reply Joe.

We have a custom utility that the users can use to self-register when they go 
to our portal for the first time.  Like you describe, it creates a people and 
user account with the correct permissions depending on what we have setup for 
that customer.

The issue is when new users Phone the service desk - our Service Desk will use 
the create user functionality from the incident form to create a Person 
profile.  It looks like we now need additional workflow so that this also 
creates a User profile with the correct permissions so that a Service Request 
can be created on submission of the incident.

My original query was to try to ascertain why Service Requests need a Login ID 
associated to them and why was a person ID association not used like in 
Incident/Change.  

Regards
Tony

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


ARERR 45281 not allowing to create a task from incident.

2014-01-21 Thread Suresh Loganathan
Hi Team,

When i am creating the task from incident that time i am getting below
error.

The incident number is required for this function to work. To generate an
incident number, select a  customer  ARERR45281.

this issue is occuring only in best practise view. i can able to create a
task in  classic view with out hurdles.

guys, can you please share the solution to fix this issue.

Regards ,

Suresh L

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Reference Server clarification

2014-01-21 Thread Cecil, Ken
(dumb) question

We are in an upgrade from non-overlay system to 8.1 were we restored a copy of 
the prod DB onto a staging server and upgraded ARS to 8.1. In the stage that 
talk about running BPCU then setting up an clean OOB reference server to 
re-import the origin objects (for objects were BPCU created an overlay), should 
the reference server be an old 7.x server or 8.1?

I am thinking the old 7.x since I haven't run the application upgrades yet.  
However, I believe this step is optional. What is really the benefit of 
restoring those origin objects (especially since the upgrade is going to wipe 
them out (most of them I assume)?

Thanks
Ken




Confidentiality Requirement: This communication, including any attachment(s), 
may contain confidential information and is for the sole use of the intended 
recipient(s). If you are not the intended recipient, you are hereby notified 
that you have received this communication in error and any unauthorized review, 
use, disclosure, dissemination, distribution or copying of it or its contents 
is strictly prohibited.  If you have received this communication in error, 
please notify the sender immediately by telephone or e-mail and destroy all 
copies of this communication and any attachments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Workflow ideas

2014-01-21 Thread Morrison, David A.
Good day.

Mostly custom site her using AR 7.1 on Windows server and SQL.  I have a 
request to track HelpDesk tickets involving particular PCs in assets that have 
gone off warranty.   I have flagged the pcs in the asset file and need a way to 
track and report on the helpdesk tickets which have the particular asset number 
in either the Short Description or the Details.  Just wondering if anyone would 
have an idea of the best way to handle this.  Thanks in advance for any 
suggestions.

David Morrison
East Tennessee State University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Remedy 8.1 ITSM upgrade Error

2014-01-21 Thread Saji Philip
Hello all,


I am attempting to upgrade our existing staging environment to Remedy
8.1.002.   I have successfully upgraded our development environment (which
is non-server grouped).


When I attempt it on our staging environement with the same copy of the DB
I used in dev, I can get to the ITSM installation.   It fails here, and
corrupts everything.  The following is an enttry from the install logs of
the ITSM installation:


 



THROWABLE EVENT (Description=[Program execution failed due return code
8922],Detail=[Program not completed]





The ITSM installer fails here.



A side not here, during the Atrium upgrade, I received a Port validation
error, basically telling me my NE and Atrium ports were in use.  It still
allowed me to proceed with the upgrade and it upgraded successfully.



Has anyone else experienced the same issue?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Misi Mladoniczky
Hi,

Are we talking about the future or old records?

I would seriously consider creating and enforcing a more structured way to
point Help Desk tickets towards assets (one to one or one to many)?

If it is easy to spot the numbers in text, you could create one or more
relationship records based on Short Description and Details. Maybe using a
guide and a tmp-field looping through the data until all PCs has been found
and a corresponding relationship record created.

When you have your relationships stored in a table, you can do a join and
report on assets flagged for counting.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 Good day.

 Mostly custom site her using AR 7.1 on Windows server and SQL.  I have a
 request to track HelpDesk tickets involving particular PCs in assets that have
 gone off warranty.   I have flagged the pcs in the asset file and need a way
 to track and report on the helpdesk tickets which have the particular asset
 number in either the Short Description or the Details.  Just wondering if
 anyone would have an idea of the best way to handle this.  Thanks in advance
 for any suggestions.

 David Morrison
 East Tennessee State University

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Drew Shuller
Hi David. You'll need a new form that will include the asset number and a
field for warranty end date. Load your assets into that, and do a real time
lookup from your HD form against the new form. That will tell you if the
asset is in warranty. For reporting, do a join, either with a Remedy join
form or a db join with a Remedy View form.

The first part can be done with multiple assets at one time, but that's out
of my reach.

Drew Shuller
SCAB
Honduras

-- 
Sent from MetroMail using my Nokia 920

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Mapping to SRS:RequestDetails

2014-01-21 Thread Hutcheson, Heather
Good afternoon,

Can anyone give me a quick rundown on how to map the notes field from the WO or 
INC to the details/summary in SRS:RequestDetails?


Thank you,
Heather Hutcheson

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Morrison, David A.
Hi,

Thanks for the response.  It will be future tickets beginning  when the 
warranty ends.

David

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, January 21, 2014 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

Hi,

Are we talking about the future or old records?

I would seriously consider creating and enforcing a more structured way to 
point Help Desk tickets towards assets (one to one or one to many)?

If it is easy to spot the numbers in text, you could create one or more 
relationship records based on Short Description and Details. Maybe using a 
guide and a tmp-field looping through the data until all PCs has been found and 
a corresponding relationship record created.

When you have your relationships stored in a table, you can do a join and 
report on assets flagged for counting.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 Good day.

 Mostly custom site her using AR 7.1 on Windows server and SQL.  I have 
 a request to track HelpDesk tickets involving particular PCs in assets that 
 have
 gone off warranty.   I have flagged the pcs in the asset file and need a way
 to track and report on the helpdesk tickets which have the particular 
 asset number in either the Short Description or the Details.  Just 
 wondering if anyone would have an idea of the best way to handle this.  
 Thanks in advance for any suggestions.

 David Morrison
 East Tennessee State University

 __
 _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Morrison, David A.
Thanks for the response.  This is the way I was leaning toward myself, and as 
you said the multiple assets at one time could get sticky.

David Morrison
ETSU

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller
Sent: Tuesday, January 21, 2014 3:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

** Hi David. You'll need a new form that will include the asset number and a 
field for warranty end date. Load your assets into that, and do a real time 
lookup from your HD form against the new form. That will tell you if the asset 
is in warranty. For reporting, do a join, either with a Remedy join form or a 
db join with a Remedy View form.

The first part can be done with multiple assets at one time, but that's out of 
my reach.

Drew Shuller
SCAB
Honduras

--
Sent from MetroMail using my Nokia 920
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


IBM RTC JAZZ and ARS

2014-01-21 Thread Glen Hartle
Good afternoon:

We are in the process of integrating IBM JAZZ with BMC Remedy ARS with the 
intent of retaining functionality of both platforms.  Specifically we aim to 
allow for cross-population of shadow-tickets / work items as well as value sets 
derived from the Remedy repository.

Has anyone attempted and/or succeeded in doing so, and if so, we would love to 
open a dialogue with you.

Thank you
Glen Hartle
NAV CANADA
Ottawa, Ontario

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Ray Palla
Drew is well thought out on this one, but I have one question about the
'first part'. What is the sticky part?  Wouldn't a one-time escalation
handle this for you?  Then as assets are added a filter could do the
look-up.

 

r

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Morrison, David A.
Sent: Tuesday, January 21, 2014 3:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** 

Thanks for the response.  This is the way I was leaning toward myself, and
as you said the multiple assets at one time could get sticky.

 

David Morrison

ETSU

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller
Sent: Tuesday, January 21, 2014 3:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** Hi David. You'll need a new form that will include the asset number and a
field for warranty end date. Load your assets into that, and do a real time
lookup from your HD form against the new form. That will tell you if the
asset is in warranty. For reporting, do a join, either with a Remedy join
form or a db join with a Remedy View form. 

The first part can be done with multiple assets at one time, but that's out
of my reach.

Drew Shuller
SCAB
Honduras

-- 
Sent from MetroMail using my Nokia 920
_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Morrison, David A.
I think the idea that multiple asset numbers could be in the Short Desc or 
Details could get involved.  But if the LIKE %asset number% comparison would 
pick any of them up it should work ok.

David

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla
Sent: Tuesday, January 21, 2014 4:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

**
Drew is well thought out on this one, but I have one question about the 'first 
part'... What is the sticky part?  Wouldn't a one-time escalation handle this 
for you?  Then as assets are added a filter could do the look-up.

r


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Morrison, David A.
Sent: Tuesday, January 21, 2014 3:20 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

**
Thanks for the response.  This is the way I was leaning toward myself, and as 
you said the multiple assets at one time could get sticky.

David Morrison
ETSU

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller
Sent: Tuesday, January 21, 2014 3:29 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

** Hi David. You'll need a new form that will include the asset number and a 
field for warranty end date. Load your assets into that, and do a real time 
lookup from your HD form against the new form. That will tell you if the asset 
is in warranty. For reporting, do a join, either with a Remedy join form or a 
db join with a Remedy View form.

The first part can be done with multiple assets at one time, but that's out of 
my reach.

Drew Shuller
SCAB
Honduras

--
Sent from MetroMail using my Nokia 920
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Workflow ideas

2014-01-21 Thread Ray Palla
Yup. that sounds right to me.  Consider a filtering mechanism triggered by
your lookup escalation or filter.   With the mechanism you could do all
sorts of tasks like:  parse the fields (Short Desc and Details), count the
number of asset numbers, and then iterate through the count to grab each one
individually.  Remember you can set filters to be asynchronous and not use
phasing, allowing you to control the order they run in.  You could have a
handful of filters that capture a variety of issues, possibilities or
concerns.  Within that architecture you would be able to add another
requirement later if it came up.

 

Kool beans.

r

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Morrison, David A.
Sent: Tuesday, January 21, 2014 3:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** 

I think the idea that multiple asset numbers could be in the Short Desc or
Details could get involved.  But if the LIKE %asset number% comparison would
pick any of them up it should work ok.

 

David

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla
Sent: Tuesday, January 21, 2014 4:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** 

Drew is well thought out on this one, but I have one question about the
'first part'. What is the sticky part?  Wouldn't a one-time escalation
handle this for you?  Then as assets are added a filter could do the
look-up.

 

r

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Morrison, David A.
Sent: Tuesday, January 21, 2014 3:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** 

Thanks for the response.  This is the way I was leaning toward myself, and
as you said the multiple assets at one time could get sticky.

 

David Morrison

ETSU

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller
Sent: Tuesday, January 21, 2014 3:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow ideas

 

** Hi David. You'll need a new form that will include the asset number and a
field for warranty end date. Load your assets into that, and do a real time
lookup from your HD form against the new form. That will tell you if the
asset is in warranty. For reporting, do a join, either with a Remedy join
form or a db join with a Remedy View form. 

The first part can be done with multiple assets at one time, but that's out
of my reach.

Drew Shuller
SCAB
Honduras

-- 
Sent from MetroMail using my Nokia 920
_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Development Question

2014-01-21 Thread Simon Ellis
Seemed to have stumped myself In a multi tenated solution i've created a 
new panel on the HPD:Help Desk form,
added a panel holder and additional panels within that.  The new panel is only 
visible to members of one company.
The People records have the Company listed in the Access Restictions box of 
there people record.  To establish the permissions for this tab, I mapped a 
role to a group and through DEV studio set permissions for the Panel so that 
role/group only have access.  In our DEV environment where i developed this, it 
works like a dream, if you have the company listed in your people record under 
access restrictions no problem you can view the tab and you can log and search 
for tickets for that company.  If you don't you can't see the tab/panel and you 
can't log tickets for that company.  When i've moved this through into our Test 
environment, users with the correct access restrictions can create and search 
tickets
for this company but can't view the new tab/panel.  As the administrator i can. 
 Permissions of the form are identical.

Can't fathom out if i've missed something out, done something in DEV that i've 
forgotten to move through

any ideas?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: [EXTERNAL] Development Question

2014-01-21 Thread Stroud, Natalie K
Simon:

The only suggestion I'd have is to try resetting the access restriction for the 
user in your TEST environment, i.e. remove it, save the People record, then 
re-add it and resave the People record.

I can't tell you the number of flaky little access-type problems I've solved 
doing that little dance with permissions and anything else that gives or 
removes access.

Good luck!

Natalie Stroud
SAIC @ Sandia National Laboratories
ARS-ITSM Reporting Specialist
Albuquerque, NM USA
nkst...@sandia.gov
ITSM 7.6.04 SP2 – Windows 2003 – SQL Server 2008

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis
Sent: Tuesday, January 21, 2014 4:31 PM
To: arslist@ARSLIST.ORG
Subject: [EXTERNAL] Development Question

Seemed to have stumped myself In a multi tenated solution i've created a 
new panel on the HPD:Help Desk form, added a panel holder and additional panels 
within that.  The new panel is only visible to members of one company.
The People records have the Company listed in the Access Restictions box of 
there people record.  To establish the permissions for this tab, I mapped a 
role to a group and through DEV studio set permissions for the Panel so that 
role/group only have access.  In our DEV environment where i developed this, it 
works like a dream, if you have the company listed in your people record under 
access restrictions no problem you can view the tab and you can log and search 
for tickets for that company.  If you don't you can't see the tab/panel and you 
can't log tickets for that company.  When i've moved this through into our Test 
environment, users with the correct access restrictions can create and search 
tickets for this company but can't view the new tab/panel.  As the 
administrator i can.  Permissions of the form are identical.

Can't fathom out if i've missed something out, done something in DEV that i've 
forgotten to move through

any ideas?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Development Question

2014-01-21 Thread Thad Esser
Simon,

Are the Group IDs on the Group form for the Company in question the same
between your Dev and Test environments?

Thad


On Tue, Jan 21, 2014 at 3:30 PM, Simon Ellis simon.el...@telecom.co.nzwrote:

 Seemed to have stumped myself In a multi tenated solution i've created
 a new panel on the HPD:Help Desk form,
 added a panel holder and additional panels within that.  The new panel is
 only visible to members of one company.
 The People records have the Company listed in the Access Restictions box
 of there people record.  To establish the permissions for this tab, I
 mapped a role to a group and through DEV studio set permissions for the
 Panel so that role/group only have access.  In our DEV environment where i
 developed this, it works like a dream, if you have the company listed in
 your people record under access restrictions no problem you can view the
 tab and you can log and search for tickets for that company.  If you don't
 you can't see the tab/panel and you can't log tickets for that company.
  When i've moved this through into our Test environment, users with the
 correct access restrictions can create and search tickets
 for this company but can't view the new tab/panel.  As the administrator i
 can.  Permissions of the form are identical.

 Can't fathom out if i've missed something out, done something in DEV that
 i've forgotten to move through

 any ideas?


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Development Question

2014-01-21 Thread Simon Ellis
Think I've found the problem On the Group form the group type was set as 
none, where as in DEV it was set as Change, everything else was the same.  
Flicking between the two allowed the panel tab to become visible Now noted 
for when I release to staging and prod

Cheers

Simon

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Wednesday, 22 January 2014 2:25 p.m.
To: arslist@ARSLIST.ORG
Subject: Re: Development Question

**
Simon,

Are the Group IDs on the Group form for the Company in question the same 
between your Dev and Test environments?

Thad

On Tue, Jan 21, 2014 at 3:30 PM, Simon Ellis 
simon.el...@telecom.co.nzmailto:simon.el...@telecom.co.nz wrote:
Seemed to have stumped myself In a multi tenated solution i've created a 
new panel on the HPD:Help Desk form,
added a panel holder and additional panels within that.  The new panel is only 
visible to members of one company.
The People records have the Company listed in the Access Restictions box of 
there people record.  To establish the permissions for this tab, I mapped a 
role to a group and through DEV studio set permissions for the Panel so that 
role/group only have access.  In our DEV environment where i developed this, it 
works like a dream, if you have the company listed in your people record under 
access restrictions no problem you can view the tab and you can log and search 
for tickets for that company.  If you don't you can't see the tab/panel and you 
can't log tickets for that company.  When i've moved this through into our Test 
environment, users with the correct access restrictions can create and search 
tickets
for this company but can't view the new tab/panel.  As the administrator i can. 
 Permissions of the form are identical.

Can't fathom out if i've missed something out, done something in DEV that i've 
forgotten to move through

any ideas?

___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.orghttp://www.arslist.org
Where the Answers Are, and have been for 20 years

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: Remedy 8.1 ITSM upgrade Error

2014-01-21 Thread Vivek Patil
Hi Philip,
   Let's work offline and we will like to verify the Zip All Logs collected 
using maintenance tool.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


CPU utilization sometimes goes upto 100%

2014-01-21 Thread Jennifer Varkey


Hello All,

In my SQL logging each of the following statements are taking over 4 hours;

SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC


During such time, the CPU utilization becomes very high, almost reaching 100%.


The T8 table is Application Pending.

The co-rresponding API logging (against the form Application Pending) does 
not show the same delay or lag. We ran the log files using the arloganalyzer.

The field T8.C8 is Category field and the field T8.C501 is Command field.

The category BR-CHK-CONFIG refers to BRIE (SLM).

Could someone please help us out on why these are taking so much time and why 
the CPU is going so high?

Thanks and Regards,
Sonia.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: CPU utilization sometimes goes upto 100%

2014-01-21 Thread Jennifer Varkey
sorry, i missed the server details;

ARS/ITSM/RKM 7.5 on Windows 2k8

RAM is 12 GB.


The databse is SQL 2k8 on another separate machine, having 12 GB RAM.




On Wednesday, 22 January 2014, 12:24, Jennifer Varkey sonia_m...@yahoo.co.uk 
wrote:
 


Hello All,

In my SQL logging each of the following statements are taking over 4 hours;

SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC
SELECT T8.C1 FROM T8 WHERE ((T8.C8 = N'BR-CHK-CONFIG') AND (T8.C501 = 
N'SG-Check-Config')) ORDER BY C1 ASC


During such time, the CPU utilization becomes very high, almost reaching 100%.


The T8 table is Application Pending.

The co-rresponding API logging (against the form Application Pending) does 
not show the same delay or lag. We ran the log files using the arloganalyzer.

The field T8.C8 is Category field and the field T8.C501 is Command field.

The category BR-CHK-CONFIG refers to BRIE (SLM).

Could someone please help us out on why these are taking so much time and why 
the CPU is going so high?

Thanks and Regards,
Sonia.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Reference Server clarification

2014-01-21 Thread Carl Wilson
Hi Ken,

The reference server is to restore any base objects that have been converted
to an overlay by BPCU, therefore the reference server is a clean install
of the version you are upgrading to  8.1.  The system will the overlay
object, but BMC recommends that you have the original base object in the
system also (although it is optional).

 

 

Acquiring origin objects (optional)

In this stage, which is optional, acquire unmodified origin objects onto a
reference server. The origin objects are used to compare with your overlay
objects.

After completing this stage, you can compare the overlays on your staging
server to unmodified origin objects on the reference server. This allows you
to see exactly what has changed in any object.

 

Restoring origin objects on staging server (optional)

In this stage, which is optional, move the new version's origin objects from
your reference server to your staging server.

If you perform the procedures in this stage, when your upgrade is complete,
you can run either the unmodified version of the application using only
origin objects, or you can run your customized version that uses overlays in
place of overlaid origin objects.

After completing this stage, you have acquired copies of all of your origin
objects in their original state. This does not affect any overlays that you
created.

 

  _  

 

Kind Regards,

 

Carl Wilson

 

http://www.missingpiecessoftware.com/

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Cecil, Ken
Sent: 21 January 2014 18:54
To: arslist@ARSLIST.ORG
Subject: Reference Server clarification

 

** 

(dumb) question..

 

We are in an upgrade from non-overlay system to 8.1 were we restored a copy
of the prod DB onto a staging server and upgraded ARS to 8.1. In the stage
that talk about running BPCU then setting up an clean OOB reference server
to re-import the origin objects (for objects were BPCU created an overlay),
should the reference server be an old 7.x server or 8.1?

 

I am thinking the old 7.x since I haven't run the application upgrades yet.
However, I believe this step is optional. What is really the benefit of
restoring those origin objects (especially since the upgrade is going to
wipe them out (most of them I assume)?

 

Thanks

Ken

 

 

  _  


 

Confidentiality Requirement: This communication, including any
attachment(s), may contain confidential information and is for the sole use
of the intended recipient(s). If you are not the intended recipient, you are
hereby notified that you have received this communication in error and any
unauthorized review, use, disclosure, dissemination, distribution or copying
of it or its contents is strictly prohibited.  If you have received this
communication in error, please notify the sender immediately by telephone or
e-mail and destroy all copies of this communication and any attachments.

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years