hi all,
since couple of weeks we are facing a strange issue.
The AR Server just peaks at 100% and hangs. We see that there is a heavy
query running on DB which looks like this
SELECT
Would it be possible to install a system as shared and then drop the original
server and use the shared one?
Could I change the hostname to what the original was?
Then it would be transparent to the users.
Yes?
Thanks,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software
Thank you,
It seems that no changes from the previous recommendations.
regards,
mike
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, January 21, 2011 10:04 PM
To: arslist@ARSLIST.ORG
Dear List,
We have a radio button field with 9 options, that is supposed to look like this:
[cid:image005.jpg@01CBBBAA.8DA61F60]
But about 2/3 of the time it appears like this:
[cid:image006.jpg@01CBBBAA.8DA61F60]
Only the circle of the first option appears. If you close the window and
re-open
I had to run the upgrade from ARS7.1 to 7.5.x by installing in pause
mode and replacing the arserver.exe with a hotfix arserver.exe from BMC.
Also had to run the ITSM (upgrading 7.1 to 7.6p2) installer in pause
mode and hack some arx files with data that BMC provided.
CMDB upgrade from 2.1 to
Check the NTE:CFG-Notification Events form for following values. You need to
have this setting for incident assignment messages to go out.
Notification Event Type= System Default
Module Name=Incident
Notification Event=Assignment
Remedy Notification Method=Email
Group Notification=Yes
Thanks,
What is table T28?
select name
from arschema
where schemaid = 28
/
The C112 parts of the query have to do with the row level locking that is
set up on T28.
Also, what method are you using to identify this as a cause or indicator of
your performance problem?
Axton
On Mon, Jan 24, 2011 at
Alberto,
Sorry if I'm misunderstanding, but it sounds like you need to find
whatever FB: form in dev studio you want to sort by date, open it up,
and under Form Form Properties specify the sort order (and maybe
specify what fields you want in the results list so you can see the
dates there,
Viki,
As Axton noted, although it looks BIG, ignore the C112 clauses in any WHERE
clause when looking at
AR System logs. This also includes any C60xxx fields. All of these clauses
will be at the end of the query.
They may be large (if you are in a lot of groups). They do not affect the
You can turn on SQL, Filter and Escalation log from server side and give the
file same name. That way, you may be able to figure out what filter or
escalation is generating this query.
Thanks,
Wirasat
From: Action Request System discussion list(ARSList)
Can you better describe your upgrade scenario and the failure itself.
What versions/products are you upgrading from? Is it just ITSM, or ITSM + SRM?
+ SLM?, etc?
What was the failure?
Ramon Kagan, MBA, PMP
Manager, Product Development
BMC Software
From:
Mark,
Do you mean that InputDoc is the field name? I know in the forms where
webservice defined there is no such field. I may need to find out which form
has this InputDoc field.
Maggie
--
View this message in context:
Hi,
The appendText that comes with any error message contains additional info
that can help you pinpoint the error.
Usually when ARERR [326] is diesplayed, you get something like this:
MessageType: 2
MessageNum: 326
MessageText: Required field cannot be reset to a NULL value
AppendedText: 8
In
Technically Yes, but here are the things you need to consider.
When you run the upgrader it will update the binaries on the remedy app
folder as well the meta data in db.
In your case if the db is ok you just want to replace app then you can
install on the same server as shared or as you said
Interesting that you say ignore C112 clauses.
My Overview Console search adds C112 LIKE clauses.
SELECT
T943.C1,C10,C7,C100164,C179,C23009,C301626500,C100161,C100218,C3,C100019,C100018
FROM T943 WHERE (((T943.C112 LIKE N'%;''user'';%') OR (T943.C112 LIKE
N'%;0;%')
Pat,
Thanks. Since I did eventually get it to 7.6.03 Build 001 201008170035 I was
just looking for a quicker way to straighten out the issue with email and
midtier.
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns
I had to revert back to ARS 7.5p3 from 7.6.03 and had to restore the db, then
run the ARS uninstaller. Then run the 7.5p3 install as an upgrade. I
fortunately did not have to reinstall ITSM or CMDB which was a huge concern.
From: Action Request System discussion list(ARSList)
Does anyone have a guide to get me started with creating link to other
databases??
Thanks
Ron Suwanski
Lead Remedy Administrator / Developer
DeVry Inc.
814 Commerce Drive
Oakbrook, IL 60523-8822
p: 630.472.2209
e: rsuwan...@devry.commailto:rsuwan...@devry.com
List,
Does anyone know how the AR System knows which form to display up when you
put a report option for a table field. This is not a regular button and
automatically brings up a form without having to add workflow. In most
cases this brings up the ReportSelection form. For some reason, for
Hi,
This will add load to your system mainly when you do not have other
qualification criteria that narrows down the search, and makes good use of
your indexes.
If you do an unqualified search, the C112-additions to the SELECT-statment
can definitely add a lot of load to the query.
Best
I have a table T204 and the AR SYSTEM automatically creates a view on top of it
called TEIS_SURVEY_TEXT
I need to create a view and need to know the ramifications of creating a view
of a view.
I could create my view like this:
CREATE OR REPLACE VIEW ARADMIN.TYCO_ADR_SURVEY_TYPE_V (REQUEST_ID,
On Oracle, the optimizer will convert the view (through the other view) down to
the actual table when it executes the query.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Monday, January 24, 2011
So is it recommended?
Lisa
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, January 24, 2011 5:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: View of a View?
On Oracle, the optimizer will
Sort of depends if you want to wait for the view to be processed before the
view of the view.
It's probably measurably more efficient to create the view(let) from the
original table.
Chas
-Original Message-
From: Action Request System discussion list(ARSList)
It's measurably more maintainable to create the view against the table. Any
time you modify a form, the views that ARS creates on top of the tables is
dropped and recreated. This is because there is no way in the db to alter
the view. When the view is dropped and recreated it may invalidate the
Interesting you asked about it. When we first encountered the problem,
the Cursor Sharing was already set to FORCE both in the Oracle database
and ar.conf. The DBA then changed it to be EXACT in the database while
we kept it FORCE in ar.conf. This change has improved the performance
noticeably,
AR Server version: 7.06.03 Build 001
Using the API, does the ARServerUser.login() method check if 'Force Password
Change On Login' (field 124) is set before logging in the user, or is the
program using the API responsible for checking that field? I didn't see
anything mentioned in the API docs
Try to get the api, filter, and sql logs leading up to the point where it
started hanging. Those are your best indicator. Also check the arerror.log
for crashes.
There are things that can cause behavior like this that the logs will
indicate. For example, try creating a computed group during
Also with regards to maintainability, if you are migrating code through
various environments to get to production, the T# for that form isn't
guaranteed to be the same. It most likely is, but it depends on how
tortured your migration process is (or was, before you started working
somewhere
I have been trying to find out how to list all app licenses (like Incindet
user or Change admin) assinged to each user, other then opening up the
people form.
Can anyone point me to the form (or forms) that hold this info.
As always thanks,
Howard
--
Howard Richter
Red Hat Certified
Hey Howard, how are you?
I'm not sure how you are trying to pull the information but I can
think of a couple ways. There is a form called People Permission or
something similar that has a record for each permission granted to a
user--those that require a license and those that don't. If you
hi all once again,
We did the server side setting for 1000 records to return but now our
main performance issue is still not resolved as the user can still run a
macro and few macros end up into very complex queries firing on the database
which hogs the database bandwidth and hence our AR
You can use RunMacro with (-d) debugging for all case submit, update and delete
and see the result of the debugging, general speaking the setup in the
application is not completed represented in the database you can try admin-tool
and see wht is not in the form and not in the database such as
Hi,
1. Find out which users are doing this, and talk to them
2. Ask the user about the info they need, and provide built-in
functionality to efficiently provide this to them
3. Move your users to the web client
4. Analyze the queries the users make and try to supply good indexes
5. Archive data
34 matches
Mail list logo
