Re: Oracle Query Issue

[Soria, Joe]

Sounds like you may need to rebuild your indexes.

Frank Caruso  wrote:

ARS 6.3
Oracle 10

Deleted 3.3 million records from the SHR:ConsolidatedList form. There are
now only 15,000 records but the queries the MidTier runs for flash boards
are still slow - upwards of 20 seconds. The queries are counting groups of
records by category and group. There are no where clauses so I would not
think it is an index issue. I also made sure that statistics has been run.
The deletes were done using an  ARS Perl script.

Any thoughts on what else I might look at?

Frank Caruso

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Oracle 10g Data Migration

[Soria, Joe]

There are many ways to perform this task. To name a few:

1) perform a cold backup of the database -> copy to new server
2) export/import
3) using data pump
4) using oracle's database creation assistant (DBCA)

My recommendation is, if you are not familiar with these terms/tools.
Find a DBA. What version of Oracle are you going from to? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of G. Lafontant
Sent: Thursday, December 09, 2010 2:56 PM
To: arslist@ARSLIST.ORG
Subject: Oracle 10g Data Migration

Does anyone know approximately how long will it take to replicate a 
database server of 600gig of data to another Oracle server box? And 
what's the best tool out there to make that feasible quick and easy?


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Chrome Browser support

[Soria, Joe]

I didn't see my earlier post come through and apologize if you are
receiving this again.  There is an IE Tab extension to Google Chrome
(and FireFox). This extension uses the IE rendering engine. I've been
using Chrome for Remedy 7.5 with minimal issues. 

 

 

Joe Soria

QA and Database Manager

Bresnan Communications

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Easter, David
Sent: Thursday, November 04, 2010 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Chrome Browser support

 

** 

Chrome is not officially supported in AR System 7.6.03.

 

It is true that in informal tests, Chrome (because of its Javascript
engine) does appear to perform as well or better than the other
browsers.

 

However, there have been no formal requests from business customers to
support Chrome.  While individuals may be using it, market information
so far does not point to IT organizations formally moving to supporting
Chrome as a corporate supported browser.  Were large IT organizations to
start supporting it for business (as opposed to recreational or
consumer) use, it would certainly bolster the BMC business case to add
support.

 

-David J. Easter

Sr. Product Manager, Enterprise Service Management

BMC Software, Inc.

 

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Andrew Fremont
Sent: Thursday, November 04, 2010 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Chrome Browser support

 

** hmm... I couldn't find Chrome on the "Action Request System 7.6.03
Compatibility and Support" document.

Only IE6, FF3, and Safari 3.2.3 are supported.

On Thu, Nov 4, 2010 at 11:05 AM, Joe Martin D'Souza 
wrote:

** 

7.6 supposedly supports it..

 

Joe

 

From: Rick Cook   

Sent: Thursday, November 04, 2010 2:03 PM

Newsgroups: public.remedy.arsystem.general

To: arslist@ARSLIST.ORG 

Subject: Re: Chrome Browser support

 

** 

Funny you should reference that.  At WWRUG, BMC's top web guy said that
Chrome was the fastest browser for mid-tier.  

Rick

On Nov 4, 2010 1:59 PM, "Andrew Fremont" 
wrote:

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Chrome Browser support

[Soria, Joe]

Check out the Ietab plugin for chrome. 

Joe Martin D'Souza  wrote:

7.6 supposedly supports it..

Joe

From: Rick Cook 
Sent: Thursday, November 04, 2010 2:03 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: Chrome Browser support

** 
Funny you should reference that.  At WWRUG, BMC's top web guy said that Chrome 
was the fastest browser for mid-tier.  

Rick

On Nov 4, 2010 1:59 PM, "Andrew Fremont"  wrote:

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ARERR 299 Too many levels in filter processing

[Soria, Joe]

For our complex queries we sometimes create a database view and throw a
view form on top.

LJ LongWing  wrote:

Another situation is query unionswe have several locations in our app
where we need to union several searches together into a single resultset,
not possible within the Remedy architecture.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Wednesday, June 02, 2010 3:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 299 Too many levels in filter processing

To do what you need to do when all else fails or if it is impossible to do
it directly..

I once had the requirement in a multi tenant environment (Submitter mode
locked) to change the contents of field 2.. Only and admin user was to
have
the permissions to change that. How would you be able to do it from within
the ARS if the workflow didn't run a Direct SQL?

Other times I use it is when I'm dead sure using it would save time and
that
chances are bleak that the syntax would ever change.. Simple update or set
statements that are hardly likely to change in syntax on that database or
if
you move across from databases are fine to use..

Counting records in a table is another example where I'd rather use a
Direct
SQL than the ARS as it would be way faster.. And what are the chances that
the count(*) function would ever change when used in a select statement?

So there are exceptions such as that where some things are just not
possible
without resorting to Direct SQL. It is like a 911 call.. Just because you
have that option you do not call it for recreational purposes..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Matt Worsdell
Sent: Wednesday, June 02, 2010 5:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 299 Too many levels in filter processing


I fail to see why, Direct SQL is a legitimate built in option.


> Hi,
>
> Direct SQL makes a system hard to manage. If there are built in options
> other than Direct SQL, use them instead!
>
> 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.
> Find these products, and many free tools and utilities, at
http://rrr.se.
>
>> Another option would be to use a Direct SQL Action.
>>
>> Matt
>>
>>
>>> Hi fellow listers,
>>>
>>> This is something which i had tried.
>>>
>>> My need was to change a field value in a form after a record is
>>> submitted/modified and the record for which i need the field value
>>> change
>>> to
>>> be made is the one which got submitted/modified.
>>>
>>> So I created a filter which gets triggerred(i.e on action Submit and
>>> Modify)and then do a push field and change the value in the field for
>>> the
>>> same form-record.
>>>
>>> Now my problem here is that as I am doing the push in the same form
for
>>> changing a value in the field, "ARERR 299 Too many levels in filter
>>> processing" occurs. I know this happens because the Push field action
>>> ultimately triggers a submit/modify action on the same form and the
>>> filter
>>> get triggerred infinitely.
>>>
>>> Can anyone suggest me a different approach to this?
>>>
>>> Cheers :)

__
__
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

__
_
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Heterogeneous services

[Soria, Joe]

John,

 

Ensure you have your oracle environment variables properly set (ORACLE_HOME, 
ORACLE_BASE, ORACLE_NLS). The listener (lsnrctl) is located here:  
$ORACLE_HOME/bin.

 

Hope that helps.

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Kelley
Sent: Thursday, May 28, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Heterogeneous services

 


Hi List 

Are there any oracle gurus out there that may be able to assist me. 
I'm setting up Heterogeneous Services to be able to access columns in an Access 
DB from within  Remedy (Oracle DB 10g). 

I am trying to figure out how to start and stop a listener on my application 
server with Oracle 10g 
I can't find the Listener Utility.  Is it part of the Oracle installer?   

When I type LSNRCTL start ... from the command line, it says 'lsnrctl' is not 
recognized as an internal or external command" 
I do a search in the oracle directory and it is not there. 

Any ideas how to install it?  What option in the Oracle installer installs the 
utility? 

Thanks JK 

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

 

Re: popup on mid-tier login

[Soria, Joe]

-Original Message-
From: Gary Opela (Corporate) <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2008 2:08 PM
To: arslist@ARSLIST.ORG 
Subject: Re: popup on mid-tier login

Yeah, after finding out what it does, I can see the need for it. I just wish 
there was some other way to check for a popup blocker other than sending a 
popup.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of LJ Longwing
Sent: Wednesday, June 11, 2008 2:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: popup on mid-tier login

It's actually listed as a new feature of 7.1 that I truly enjoy, it has stopped 
the annoying tech support calls of 'when I click this button the screen goes 
grey and locks up'all of which are caused by popup blockers...


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Decou, Candace M
Sent: Wednesday, June 11, 2008 9:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: popup on mid-tier login
**
Gary -
This happens all the time whenever you log into mid-tier.  It is annoying I 
agree but in general I would recommend that ALL popup blockers be disabled 
anyway because if they are catching that one, they will certainly cause 
problems with other windows opening.  I don't think it has anything to do with 
logging being on or off - it happens to everyone all the time.  It doesn't have 
to do with user preferences either.  So I don't think you did anything to cause 
it, I just think it is the new wonderful annoying feature of mid-tier 7.1.  
Maybe someone else out there knows what it is and why it is popping up and why, 
at least to my knowledge, we never saw this behavior before in earlier versions 
of mid-tier.
:)


Candace DeCou

DOI Remedy Systems Analyst
Verizon Business
Office:  (408) 371-1112

Email: [EMAIL PROTECTED]



Verizon Business - global capability, personal accountability.

This e-mail is strictly confidential and intended only for use by the addressee 
unless otherwise indicated


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Gary Opela (Corporate)
Sent: Wednesday, June 11, 2008 7:57 AM
To: arslist@ARSLIST.ORG
Subject: popup on mid-tier login

Has anyone else noticed a popup window that comes and goes away instantly on 
the login window? I thought at first that maybe it was the logging window that 
shows what all is going on, but I don't have any user preferences in the user 
preference form.

It's annoying because our pop-up blockers catch it. I was wondering if maybe I 
did something to cause it, or maybe my logging was on, but I don't know where 
else to look since there are no entries in user preferences.

Mid-Tier 7.1
ARSystem 7.1
Windows Server 2k3
SQL Server 2k5

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

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

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

Re: rebuilding a dev environment

[Soria, Joe]

** 

Kelly,

 

Do you also export the data? If so, how do you bypass the row limit for
the dev environment?

 

Joe

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hundley, Kelly G.
Sent: Tuesday, September 18, 2007 8:10 AM
To: arslist@ARSLIST.ORG
Subject: Re: rebuilding a dev environment

 

This is unsupported but I've done it many times.  There may be a faster
way, but this works for me.   Install oracle then ARS and applications
to get the tables in place.  Export the production aradmin user.  Drop
the aradmin user from development and import it from production.  Works
like a charm.

 

K.

 

(Note: I am a little behind the times with Oracle 9.2.8, 6.3 ARS and 5.6
applications)

 

 



Kelly G. Hundley

Systems Administrator

Information Systems

Wake Forest University

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo
Sent: Tuesday, September 18, 2007 9:17 AM
To: arslist@ARSLIST.ORG
Subject: rebuilding a dev environment

 

** 

Hi eveyone,

 

I have a dev machine with ITSM6.0 which is in a total mess .. I need to
rebuild it by copying the production instance (i.g. oracle database,
remedy server, mid-tier etc) to the dev machine ...

 

Anyway easy way of doing this. This is the first time I am taking on a
job like this so as you would imagine, any advise, recomendations, help,
KB's would be very very much appreciated.

 

Let me know if you need any more info.

 

Thanks

frex

  

  _  

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails
  vers Yahoo! Mail
__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___

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

Re: SQL help

[Soria, Joe]

** 

Michael,

 

Try this

 

PassOffReason IS NOT NULL

 

 

 

Joe Soria

Database Manager

Bresnan Communications

[EMAIL PROTECTED]

(406) 869-5649

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Thursday, July 19, 2007 2:47 PM
To: arslist@ARSLIST.ORG
Subject: SQL help

 

So I stink and SQL and I imagine it's a syntax error so I figured I'd
check here.  We have a field on our incident form that tracks the total
number of passoffs a ticket goes through.  Currently it's not working so
I'm trying to make it happen.  Here's the SQL I'm trying to use.

 

SELECT COUNT(*)

FROM Session_Tracking 

WHERE Incident_ID = '$Incident_Number$' AND PassOffReason <> NULL

 

Session Tracking gets incident info pushed to it every time a ticket is
modified.  If a passoff occurs, the user is forced to select a reason.
So I figured, if I count all the tickets where the ID matches the
current ticket, and there is a value in that field, then I can set that
field to SQL result set $1$ and it should work.  I made a test ticket
and created a couple sessions, 4 I think, and 2 of them have a value in
the PassOffReason field, but when the active link runs, it sets that
field to 0.

 

Any ideas? We're on 5.1.2. SQL 2K Win 2K3

 

Thanks,

 

Michael A. McManus, SSgt, USAF

Remedy Developer

HQ 754 ELSG/DOMH

DSN: 596-6478 / Comm: 334-416-6478

 

__20060125___This posting was submitted with HTML in
it___

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

Re: Slow responses

[Soria, Joe]

I think I 'accidentally' found the issue. I turned off confirmation of a new 
request, created several incidents and did not experience any slowness. I 
turned confirmation back on and it takes 10-50 seconds to come back. How in the 
world do I fix that?


-Original Message-
From:   Soria, Joe
Sent:   Fri 3/30/2007 11:01 AM
To: arslist@ARSLIST.ORG
Cc: 
Subject:Slow responses

Listers,

I am baffled here and need some guidance. 

We are running ARS 6.3 patch 20 on solaris. The user community experiences 
extreme slowness when submitting on any form. We have verified that there is no 
latency on our network, we have also verified that our database is performing 
at a very good rate. Our app server and db server reside on the same subnet. I 
have performed client side logging, as well as filter/sql/api logging. Both our 
app server and db server are experience low load on both cpu & memory. I am not 
seeing any significant load of transactions nor have I been able to isolate the 
slowness. I have rtfm and am coming to you as a last resort (before calling 
support, argh). Any ideas on troubleshooting this is greatly appreciated. 

Joe

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

Slow responses

[Soria, Joe]

Listers,

I am baffled here and need some guidance. 

We are running ARS 6.3 patch 20 on solaris. The user community experiences 
extreme slowness when submitting on any form. We have verified that there is no 
latency on our network, we have also verified that our database is performing 
at a very good rate. Our app server and db server reside on the same subnet. I 
have performed client side logging, as well as filter/sql/api logging. Both our 
app server and db server are experience low load on both cpu & memory. I am not 
seeing any significant load of transactions nor have I been able to isolate the 
slowness. I have rtfm and am coming to you as a last resort (before calling 
support, argh). Any ideas on troubleshooting this is greatly appreciated. 

Joe

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

Bringing Second App Server Online

[Soria, Joe]

We are planning to bring up our second application server in the next
few days. We will have an f5 load balancer in front of the app servers.
Does anyone have experience running in a single application server
environment ...then moving to a multiple application server environment?
I want to know how much downtime was involved as well as what issues you
ran into while performing the modification. I have read over the
documentation from BMC regarding this, and am getting different stories
on how to accomplish this, also attempted to contact BMC support, and
the two people I talked to provided no insight, they simply referred me
to the same document. 
 
We have both the mid-tier and application running on the same box. Sun
Solaris 9, ARS 6.3.
 
Joe Soria
 

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

Re: IVR & Remedy

[Soria, Joe]

Den,

What IVR system are you using? We are currently communicating back and forth 
between our IVR system and Remedy. It was very easy to setup.

Joe


-Original Message-
From:   Action Request System discussion list(ARSList) on behalf of Den Fong
Sent:   Mon 2/12/2007 4:32 PM
To: arslist@ARSLIST.ORG
Cc: 
Subject:IVR & Remedy

Has anyone integrated IVR technology, (interactive voice recognition)? 
We are looking at this for one of our projects and are looking at costs,
feasibility etc...
 
Thanks
 
Den
 
ARS 6.3 patch 20  (by end of month).
 
 

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