Re: Oracle Query Issue

2010-12-26 Thread Soria, Joe
Sounds like you may need to rebuild your indexes. Frank Caruso caruso.fr...@gmail.com 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

Re: Oracle 10g Data Migration

2010-12-09 Thread 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

Re: Chrome Browser support

2010-11-04 Thread Soria, Joe
Check out the Ietab plugin for chrome. Joe Martin D'Souza jdso...@shyle.net 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

Re: Chrome Browser support

2010-11-04 Thread 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

Re: ARERR 299 Too many levels in filter processing

2010-06-02 Thread Soria, Joe
For our complex queries we sometimes create a database view and throw a view form on top. LJ LongWing lj.longw...@gmail.com 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

Re: Heterogeneous services

2009-05-28 Thread 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

Re: popup on mid-tier login

2008-06-11 Thread Soria, Joe
-Original Message- From: Gary Opela (Corporate) [EMAIL PROTECTED] Sent: Wednesday, June 11, 2008 2:08 PM To: arslist@ARSLIST.ORG 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

Re: rebuilding a dev environment

2007-09-18 Thread 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

Re: SQL help

2007-07-19 Thread 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

Slow responses

2007-03-30 Thread 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

Re: Slow responses

2007-03-30 Thread 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

Bringing Second App Server Online

2007-02-22 Thread 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

Re: IVR Remedy

2007-02-12 Thread 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: