Permissions and Database Performance
Hi List
I'm looking for any advice or comments from you database performance gurus
out there on the way ARS enforces access to data through permissions and the
effect on performance.
Take an example of a ticket form using row level access where the
permissions on the Request ID field are set to Assignee, Assignee Group and
Submitter. For an Admin user there is no problem, but for non-Admin users
the systems adds SQL similar to the following to the beginning of the SQL to
enforce permissions:
SELECT T201.C1,C8,C700037500,C700037000,C700034003,C73000 FROM T201
WHERE
(((T201.C2 = 'fred') OR (T201.C4 = 'fred')) OR
((T201.C112 LIKE '%;''fred;%'') OR ((T201.C112 LIKE '%;0;%') OR ((T201.C112
LIKE '%;73421;%') OR
((T201.C112 LIKE '%;73419;%') OR ((T201.C112 LIKE '%;73404;%') OR (T201.C112
LIKE '%;73401;%')))
AND. rest of query.
That's checking whether the user (fred) is the assignee or submitter, then
doing a series of LIKE comparisons against the Assignee Group field for
every group that fred's a member of. This SQL is for a server config where
the Allow Multiple Assignee Groups is checked (the default). Does the
positioning of these blocks of query at the start of the SQL mean that
indexes on fields defined later in the query are less likely to be used, and
that table scans will be used? Would performance be improved if this extra
SQL were placed at the end of the query (after the clauses defined by
workflow using indexed fields)?
If the Allow Multiple Assignee Groups configuration setting is turned off,
the SQL generated to enforce permissions is changed to something like:
SELECT
T167.C1,C2,C3,C8,C700048508,C700019515,C700019565,C700500133,T167.C1,C700031
513,C3 FROM T167
WHERE (((T167.C2 = 'fred') OR (T167.C4 = 'fred') OR
(T167.C112 IN
(';73402;',';73401;',';73400;',';73419;',';73416;',';73801;',';73415;',';734
20;',';72502;',';72501;',';0;',';''fred'';')))
AND. rest of query.
Assuming that only a single Assignee Group is used and this setting can be
used, how much of an improvement in performance would you expect this to
give? Indexes on the Assignee, and Submitter fields should help, but what
if the data in the Assignee Group field is not very selective - will
indexing that field help? Should every field used to define access
permissions to a ticket be indexed?
Any comments from anyone who has investigated these performance issues or
done benchmarking would be appreciated.
TIA
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
See the
http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf ESS
Concepts Guide
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
http://www.westoverconsulting.co.uk/
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Permissions and Database Performance
The relative positioning of the pieces of the where clause should have
no impact on how the query is parsed by the database. The db will
take the query, parse it, then decide the best way to execute it based
on what it (the db) considers the cheapest alternative.
The like comparison will introduce scans (range and or table), but if
the query also includes where clause pieces that use index fields,
they will (should) use the index (depends on what the db thinks is
cheapest).
Think of it like this (scenario 1):
- (w/o row level locking) user performs an unqualified search,
resulting in a table scan
- (w row level locking-multiple) user performs an unqualified search,
resulting in a table scan
- (w row level locking-single) user performs an unqualified search,
resulting in an index scan if the assignee/dynamic group fields are
indexed
Think of it like this (scenario 2):
- (w/o row level locking) user performs a search on an indexed field,
resulting in an index scan
- (w row level locking-multiple) user performs a search on an indexed
field, resulting in an index scan, further qualified by a range scan
(against the rowset returned by the index)
- (w row level locking-single) user performs a search on an indexed
field, resulting in an index scan, further qualified by an additional
index scan (against the rowset returned by first the index)
To summarize:
- will row level locking make unqualified searches more expensive - a
little, due to additional parsing requirements (cpu)
- will row level locking make qualified searches more expensive - a
little, due to additional parsing requirements (cpu)
- if the app is well designed, and unqualified searches are not
performed against large data sets, the impact should be negligable
- if you are using oracle, you can alleviate a lot of the hard parsing
by setting the instance parameter CURSOR_SHARING to a value of similar
or force - reducing hard parsing will reduce cpu overhead and forcing
the use of bind variables will reduce the memory requirements (due to
a smaller shared sql area)
Axton Grams
On 4/17/07, David Sanders [EMAIL PROTECTED] wrote:
**
Hi List
I'm looking for any advice or comments from you database performance gurus
out there on the way ARS enforces access to data through permissions and the
effect on performance.
Take an example of a ticket form using row level access where the
permissions on the Request ID field are set to Assignee, Assignee Group and
Submitter. For an Admin user there is no problem, but for non-Admin users
the systems adds SQL similar to the following to the beginning of the SQL to
enforce permissions:
SELECT
T201.C1,C8,C700037500,C700037000,C700034003,C73000 FROM
T201 WHERE
(((T201.C2 = 'fred') OR (T201.C4 = 'fred')) OR
((T201.C112 LIKE '%;''fred;%'') OR ((T201.C112 LIKE '%;0;%') OR ((T201.C112
LIKE '%;73421;%') OR
((T201.C112 LIKE '%;73419;%') OR ((T201.C112 LIKE '%;73404;%') OR (T201.C112
LIKE '%;73401;%')))
AND… rest of query.
That's checking whether the user (fred) is the assignee or submitter, then
doing a series of LIKE comparisons against the Assignee Group field for
every group that fred's a member of. This SQL is for a server config where
the Allow Multiple Assignee Groups is checked (the default). Does the
positioning of these blocks of query at the start of the SQL mean that
indexes on fields defined later in the query are less likely to be used, and
that table scans will be used? Would performance be improved if this extra
SQL were placed at the end of the query (after the clauses defined by
workflow using indexed fields)?
If the Allow Multiple Assignee Groups configuration setting is turned off,
the SQL generated to enforce permissions is changed to something like:
SELECT
T167.C1,C2,C3,C8,C700048508,C700019515,C700019565,C700500133,T167.C1,C700031513,C3
FROM T167
WHERE (((T167.C2 = 'fred') OR (T167.C4 = 'fred') OR
(T167.C112 IN
(';73402;',';73401;',';73400;',';73419;',';73416;',';73801;',';73415;',';73420;',';72502;',';72501;',';0;',';''fred'';')))
AND… rest of query.
Assuming that only a single Assignee Group is used and this setting can be
used, how much of an improvement in performance would you expect this to
give? Indexes on the Assignee, and Submitter fields should help, but what
if the data in the Assignee Group field is not very selective – will
indexing that field help? Should every field used to define access
permissions to a ticket be indexed?
Any comments from anyone who has investigated these performance issues or
done benchmarking would be appreciated.
TIA
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
See the ESS Concepts Guide
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
__20060125___This posting was
submitted with HTML in
Re: ARS 7.0.1 Patch 001; ARDBC LDAP question
Kamlesh, is it possible that you missed installing the ARDBC LDAP stuff while installing your AR server. Regards, Murtuza. From: Patel, Kamlesh R. [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 Patch 001; ARDBC LDAP question Date: Mon, 16 Apr 2007 15:45:00 -0600 All, I am at a lose after configuring ARDBC LDAP Configuration form. I configured it, but I am unable to view the vendor form in the list create vendor form Available Vendor Names. It only shows the flashboards and server admin. What are the necessary steps to setup ARDBC LDAP form so that I can query my LDAP directory? Thanks Kamlesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
FW: .net Utilities on ARSWiki.org
Gareth, I posted a new .net app last week that updates ARS entries from the command line based on a query. HTH http://arswiki.org/projects/dotnetutil Stephen _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Wednesday, April 11, 2007 4:49 AM To: arslist@ARSLIST.ORG Subject: Re: .net Utilities on ARSWiki.org ** I'm more fluent in Java so here's an example using edplus in addition to the Remedy Java API: http://edplus.googlecode.com/svn/trunk/example/ModifyEntry.java Using this code you could query for entries where status (field id 7) is 'New' and set the status to 'Assigned' (1) like this: java -cp ... ModifyEntry [EMAIL PROTECTED] My Form '7' = 0 7 1 Although not in .net, I hope it is helpfull to you. Hugo On 4/11/07, Gareth Oliver mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Very useful - two apps one for Delete existing entry, one for Modifying existing entry. Question - does anyone have a sample application that does a Query for a record based on a qualification, then a modification of that record. Thanks From: Action Request System discussion list(ARSList) on behalf of Axton Sent: Thu 05/04/07 09:30 To: ARSList Subject: .net Utilities on ARSWiki.org I wanted to announce a set of .net utilities hosted on ARSWiki. Many thanks to Stephen Heider for releasing these under an open source license and adding these to the ARSWiki site. http://arswiki.org/projects/dotnetutil If you want to learn .net, contribute to these .net utilities, or add additional .net utilities to the site, reference the link above for information. Axton Grams ___ 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 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Group Problem
We're running ARS 6.3/Helpdesk 4.0.3. I'm trying to add a group and having a weird problem. I go through Configuration Manager and add the group and as far as I can tell it adds fine. If I then go to Group Population I can select the new group, but when I click the Add Person... button I get an error like: Please select the group to which you want to add a person. (ARERR 5781000) The preceding message occurred during the execution of active link SHRCFG:MGP-AddPerson02 -- action 1. (ARNOTE 1101) I can even select the group from the Helpdesk form. So it seems that the group was partially created. Not sure where I should look for the problem. Any suggestions? Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
java RemoteException issue
Hey guys, we've just enabled our server group, however we're seeing this error pop up when we start remedy. It's a java RemoteException error. Is this crucial for Remedy, or something to ignore? the RemoteException usually has to do with RMI.. I've added our ar_instal_dir/bin and java_dir/bin to the PATH variable in arsystem file, but this doesn't seem to solve the problem. Remedy is up and running, I would like to find out why I only get this when we enable server group though. I'm guessing remedy is trying to communicate with the other server for some reason via RMI. Just a guess though. Any ideas? Here is the PATH variable in the arsystem file: INSTALL_DIR=/opt/remedy/remprd JAVADIR=:/usr/jdk/j2sdk1.4.2_08/jre:/usr/jdk/j2sdk1.4.2_08/jre/lib/sparc /server #installer will add the : in front of this val ue since it might be blank PATH=/sbin:/usr/sbin:/usr/bin:/bin:$INSTALL_DIR/bin:/usr/jdk/j2sdk1.4.2_ 08/jre/bin:$PATH; export PATH I've posted the log below. Action Request System initializing. Starting AR System Server (ARNOTE 0) AR Monitor version 6.03.00 patch 020 started. (ARNOTE 0) AR Monitor started. Action Request System(R) Approval Server Version 6.03.00.00 Remedy, a BMC Software company. Copyright (c) 1999 - 2004 BMC Software, Inc. All rights reserved. AR System Reconciliation Engine Version 1.00.00 patch 005 Remedy, a BMC Software company. Copyright (c) 2004 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1991 - 2005 BMC Software, Inc. All rights reserved. 390600 : A floating license specification was ignored because it requires a server group tag (ARERR 3329) Action Request System(R) Fork Daemon Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2000 - 2005 BMC Software, Inc. All rights reserved. (ARNOTE 0) Server indicates that it's up. Action Request System AR System Application Command Dispatcher Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1998 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Plug-In Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused AR System Email Engine has started RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused Loaded Web Services plugin properly Action Request System initialization is complete. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Table Loop Problem
Andy: Yes, you can easily create tickets with a Push Field action. Just use an empty run if condition and select IF NO REQUESTS MATCH CREATE A NEW REQUEST. Be sure to push values into all the required fields, even if you don't use them. Just some interesting trivia. Old-time Remedy developers can easily recall a day when the empty run-if qualification was not available and we had to trick Remedy into creating new requests with a qualification that always evaluated to false, like 1 = 0. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, April 16, 2007 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Table Loop Problem I'm not sure I follow you. I didn't think I could create new tickets with a push field action alone. Are you saying that I should have the guide call an AL that has a single Push Field action that sets the fields I need? Will this create new tickets for each row in the table? I am willing to try anything to get it to work. I do have the Loop Table check-box checked and have tried both selections on the Table Loop Selected Rows Only check-box. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Monday, April 16, 2007 1:59 PM To: arslist@ARSLIST.ORG Subject: Re: Table Loop Problem Andy: It seems to me your first AL is more complicated then it needs to be. Instead of opening the target form in submit mode, setting fields, and then committing the action, why not just do a Push Fields with an empty Push-If qualification? That's the first thing I would change. Then in the Active Link that calls the guide, are you sure you have the Loop Table option checked? Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, April 16, 2007 1:20 PM To: arslist@ARSLIST.ORG Subject: Table Loop Problem I am trying to create a table loop that will create tickets on several location at one time. 1. I have a table set up that populates with the desired locations. 2. I have an active link that performs the following actions, 1. Open Window action-in Submit mode, 2. Set Fields action-populates the needed data, 3 Commit Changes and 4. Close Window. 3. I have an Active Link Guide that calls the first active link. 4. I have an Active Link that calls the Active Link Guide when a button is selected. It appears the active links are firing, but it only creates the first record in the table. I tried selecting the check box for Selected Records Only and selecting all records in the table and also with the Selected Records Only field cleared. It behaves the same both ways. This is the first table loop I have created so I am sure that I missing something simple. ARS 7.0.01, Windows 2003, Win XP Pro client. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ 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 ___ 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
Re: Group Problem
If the group is in the Group form, the server probably just needs to rebuild the group cache. Wait 15 minutes after creating the group and try again. There are 2 parts to adding a group in HD 4 - SHR:Assignment (straight data) and the Group form (special form with server side cache). The menu on populate group config step uses the straight data, but when it updates the user record, it cross-references the group cache. Axton Grams On 4/17/07, James Pifer [EMAIL PROTECTED] wrote: We're running ARS 6.3/Helpdesk 4.0.3. I'm trying to add a group and having a weird problem. I go through Configuration Manager and add the group and as far as I can tell it adds fine. If I then go to Group Population I can select the new group, but when I click the Add Person... button I get an error like: Please select the group to which you want to add a person. (ARERR 5781000) The preceding message occurred during the execution of active link SHRCFG:MGP-AddPerson02 -- action 1. (ARNOTE 1101) I can even select the group from the Helpdesk form. So it seems that the group was partially created. Not sure where I should look for the problem. Any suggestions? Thanks, James ___ 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
Re: java RemoteException issue
The email engine uses RMI for the Admin interface. In the EmailDaemon.Properties file, you can specify the port RMI should listen on. com.remedy.arsys.emaildaemon.RMIPort=1100 I believe 1100 is the default Chances are something else is already using this port? Stop Remedy and use the following to see if anything is using this port: $ netstat -na |grep 1100 *.1100 *.*0 0 49152 0 LISTEN or # lsof |grep IP |grep 1100 java 1154 remedy7u IPv4 0x3000d0dac400t0 TCP *:1100 (LISTEN) The 1154 is the pid: $ ps -ef |grep 1154 remedy 1154 895 0 Apr 15 ? 10:06 /usr/java/bin/java -Djava.library.path=/xxx/AREmail -cp /xxx Axton Grams On 4/17/07, Halstead, Robert [EMAIL PROTECTED] wrote: ** Hey guys, we've just enabled our server group, however we're seeing this error pop up when we start remedy. It's a java RemoteException error. Is this crucial for Remedy, or something to ignore? the RemoteException usually has to do with RMI.. I've added our ar_instal_dir/bin and java_dir/bin to the PATH variable in arsystem file, but this doesn't seem to solve the problem. Remedy is up and running, I would like to find out why I only get this when we enable server group though. I'm guessing remedy is trying to communicate with the other server for some reason via RMI. Just a guess though. Any ideas? Here is the PATH variable in the arsystem file: INSTALL_DIR=/opt/remedy/remprd JAVADIR=:/usr/jdk/j2sdk1.4.2_08/jre:/usr/jdk/j2sdk1.4.2_08/jre/lib/sparc/server #installer will add the : in front of this val ue since it might be blank PATH=/sbin:/usr/sbin:/usr/bin:/bin:$INSTALL_DIR/bin:/usr/jdk/j2sdk1.4.2_08/jre/bin:$PATH; export PATH I've posted the log below. Action Request System initializing. Starting AR System Server (ARNOTE 0) AR Monitor version 6.03.00 patch 020 started. (ARNOTE 0) AR Monitor started. Action Request System(R) Approval Server Version 6.03.00.00 Remedy, a BMC Software company. Copyright (c) 1999 - 2004 BMC Software, Inc. All rights reserved. AR System Reconciliation Engine Version 1.00.00 patch 005 Remedy, a BMC Software company. Copyright (c) 2004 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1991 - 2005 BMC Software, Inc. All rights reserved. 390600 : A floating license specification was ignored because it requires a server group tag (ARERR 3329) Action Request System(R) Fork Daemon Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2000 - 2005 BMC Software, Inc. All rights reserved. (ARNOTE 0) Server indicates that it's up. Action Request System AR System Application Command Dispatcher Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1998 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Plug-In Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused AR System Email Engine has started RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused Loaded Web Services plugin properly Action Request System initialization is complete. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: java RemoteException issue
Axton, Thanks for the quick reply. We had to roll back the switch to the server group as we had issues with the licenses we got from BMC. As the licenses went into Remedy with out problems, when we brought Remedy up, the server wouldn't hand out write licenses only read. We're not sure what is going on there. With the Java error, we only get this if we enable the server group. As soon as we rolled back to a non-server group state, we do not get that error. If it does have to deal with the Email Engine, why would this error out only when we enable the server group and not all the time? The next time we attempt this I will take a look at netstat and see if the port is in use. In all reason, this could be our issue for the java error. Is there any other part of the Remedy system that may produce an RMI error? Bob Halstead Bresnan Communications -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 6:45 AM To: arslist@ARSLIST.ORG Subject: Re: java RemoteException issue The email engine uses RMI for the Admin interface. In the EmailDaemon.Properties file, you can specify the port RMI should listen on. com.remedy.arsys.emaildaemon.RMIPort=1100 I believe 1100 is the default Chances are something else is already using this port? Stop Remedy and use the following to see if anything is using this port: $ netstat -na |grep 1100 *.1100 *.*0 0 49152 0 LISTEN or # lsof |grep IP |grep 1100 java 1154 remedy7u IPv4 0x3000d0dac400t0 TCP *:1100 (LISTEN) The 1154 is the pid: $ ps -ef |grep 1154 remedy 1154 895 0 Apr 15 ? 10:06 /usr/java/bin/java -Djava.library.path=/xxx/AREmail -cp /xxx Axton Grams On 4/17/07, Halstead, Robert [EMAIL PROTECTED] wrote: ** Hey guys, we've just enabled our server group, however we're seeing this error pop up when we start remedy. It's a java RemoteException error. Is this crucial for Remedy, or something to ignore? the RemoteException usually has to do with RMI.. I've added our ar_instal_dir/bin and java_dir/bin to the PATH variable in arsystem file, but this doesn't seem to solve the problem. Remedy is up and running, I would like to find out why I only get this when we enable server group though. I'm guessing remedy is trying to communicate with the other server for some reason via RMI. Just a guess though. Any ideas? Here is the PATH variable in the arsystem file: INSTALL_DIR=/opt/remedy/remprd JAVADIR=:/usr/jdk/j2sdk1.4.2_08/jre:/usr/jdk/j2sdk1.4.2_08/jre/lib/sparc /server #installer will add the : in front of this val ue since it might be blank PATH=/sbin:/usr/sbin:/usr/bin:/bin:$INSTALL_DIR/bin:/usr/jdk/j2sdk1.4. 2_08/jre/bin:$PATH; export PATH I've posted the log below. Action Request System initializing. Starting AR System Server (ARNOTE 0) AR Monitor version 6.03.00 patch 020 started. (ARNOTE 0) AR Monitor started. Action Request System(R) Approval Server Version 6.03.00.00 Remedy, a BMC Software company. Copyright (c) 1999 - 2004 BMC Software, Inc. All rights reserved. AR System Reconciliation Engine Version 1.00.00 patch 005 Remedy, a BMC Software company. Copyright (c) 2004 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1991 - 2005 BMC Software, Inc. All rights reserved. 390600 : A floating license specification was ignored because it requires a server group tag (ARERR 3329) Action Request System(R) Fork Daemon Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2000 - 2005 BMC Software, Inc. All rights reserved. (ARNOTE 0) Server indicates that it's up. Action Request System AR System Application Command Dispatcher Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1998 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Plug-In Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused AR System Email Engine has started RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused Loaded Web Services plugin properly Action Request System initialization is complete. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Status History Bug
I just noticed that this also affects existing workflow not just newly created workflow. I had an escalation that where the run if was status history closed time and now it says status history open time. -Original Message- From: Bowen, Marc Sent: Tuesday, April 17, 2007 11:45 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Status History Bug 7.01 patch 001 Solaris 10 Oracle 10.2 This happened to me when trying to use the archive feature, I tried to put status-history-closed time and it reverted to status-history-open time. I opened a ticket and the agent tried it while I was on the phone and it happened to him also. I received an email indicating that they noticed it happens in other areas also. It appears it only affects newly created workflow. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Tuesday, April 17, 2007 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Status History Bug AR Server version? OS? I guess this will be the same as Axton's bug: http://arswiki.org/bugs/show_bug.cgi?id=42 On 4/17/07, Bowen, Marc [EMAIL PROTECTED] wrote: ** I have a defect I posted SW00260084 STEPS TO REPRODUCE: Log into the Administrator Tool Create a form Save it Create a filter Push Fields Action Name: Character Field Value: Select Field-Status History -Time -Closed Click on Add Action Save the Filter 3. ACTUAL RESULTS: $Status History.New.TIME$ appears Marc Bowen Remedy Skilled Professional Office (201) 307-8274 Mobile (917) 273-0951 [EMAIL PROTECTED] *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are html body p***/p pThe information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter./p p***/p /body /html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Group Problem
On Tue, 2007-04-17 at 08:11 -0400, Axton wrote: If the group is in the Group form, the server probably just needs to rebuild the group cache. Wait 15 minutes after creating the group and try again. There are 2 parts to adding a group in HD 4 - SHR:Assignment (straight data) and the Group form (special form with server side cache). The menu on populate group config step uses the straight data, but when it updates the user record, it cross-references the group cache. Axton Grams Yeah, I thought about the group cache, but I created the group yesterday. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Showing related records.
Hi, For this you can create 2 character fields say Ch1 and Ch2 and 2 buttons say B1 and B2.Perform set field action in Ch1 to col1(Record Id) of Table A.In Ch2 perform set field action to $ch1$ after the set field if qualification Ch2=$Ch1$.In B1 give the Run if Qualification:- ( 'Ch1' != $NULL$ ) AND ( 'Ch2' = $NULL$ )and set field to Ch2 as $Ch1$ and Commit Changes.In B2 perform Call Guide that constitute all these three active links.In this select the Table loop and Table loop Selected Rows Only. Thanks, Neha -- [EMAIL PROTECTED] www.vyomlabs.com Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Congo wrote: Hello, Ive got 2 tables, lets say A and B First one holds some records added manually On the second I'd like to have all records related to those from table A I think I need to loop over the table A , get each record ID and pass it to the qualification on table B. First thing: my actl guide doesnt seem to work correctly, it always gives me only one ID (Table loop Selected Rows checkbox is unchecked) Second thing: how to pass the obtained ID to the Table B to use it with the qualification. Any advices are welcome. Thanks. ___ 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
Full Time Remedy Developer Position in Alpharetta Georgia
Hi all. I'm looking for a Remedy Developer that is interested in a full time position in Alpharetta Georgia. Remedy 7 experience would be great, but not required. Not looking for an administrator, looking for a developer. Customer service, consulting and project management skills are important. Email me offline. I'm not a recruiter. Jack Covert ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: API .NET/C++
Some programs that use the remedy .net api are available at: http://arswiki.org/projects/dotnetutil Click the Browse Source tab to view the source code. There are total of 5 apps. Axton Grams On 4/17/07, CONDREA, Daniel [EMAIL PROTECTED] wrote: ** AR System Developer Community http://www.bmc.com/arsystem/dev_community/ AR System .NET and COM API From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rem Valenzuela Sent: Tuesday, April 17, 2007 4:48 PM To: arslist@ARSLIST.ORG Subject: API .NET/C++ ** Anyone know of anyplace where I can look at some free sample code using VB.NET or C++ for the Remedy API? I'm a relative newbie to the Remedy API and am intermediate in ASP.NET and C++. I looked at the examples in the e-books, but it doesn't seem to address some questions I have about it. Thanks. - Rem Get news, entertainment and everything you care about at Live.com. Check it out! __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ 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
Re: Status History Bug
7.01 patch 001 Solaris 10 Oracle 10.2 This happened to me when trying to use the archive feature, I tried to put status-history-closed time and it reverted to status-history-open time. I opened a ticket and the agent tried it while I was on the phone and it happened to him also. I received an email indicating that they noticed it happens in other areas also. It appears it only affects newly created workflow. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Tuesday, April 17, 2007 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Status History Bug AR Server version? OS? I guess this will be the same as Axton's bug: http://arswiki.org/bugs/show_bug.cgi?id=42 On 4/17/07, Bowen, Marc [EMAIL PROTECTED] wrote: ** I have a defect I posted SW00260084 STEPS TO REPRODUCE: Log into the Administrator Tool Create a form Save it Create a filter Push Fields Action Name: Character Field Value: Select Field-Status History -Time -Closed Click on Add Action Save the Filter 3. ACTUAL RESULTS: $Status History.New.TIME$ appears Marc Bowen Remedy Skilled Professional Office (201) 307-8274 Mobile (917) 273-0951 [EMAIL PROTECTED] *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are html body p***/p pThe information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter./p p***/p /body /html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Status History Bug
I have a defect I posted SW00260084 STEPS TO REPRODUCE: Log into the Administrator Tool Create a form Save it Create a filter Push Fields Action Name: Character Field Value: Select Field-Status History -Time -Closed Click on Add Action Save the Filter 3. ACTUAL RESULTS: $Status History.New.TIME$ appears Marc Bowen Remedy Skilled Professional Office (201) 307-8274 Mobile (917) 273-0951 [EMAIL PROTECTED] html body p***/p pThe information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter./p p***/p /body /html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Table Loop Problem-Resolved
Thanks Norm. I believe have the basic concept working now with a push field. I appreciate all the help. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Tuesday, April 17, 2007 7:27 AM To: arslist@ARSLIST.ORG Subject: Re: Table Loop Problem Andy: Yes, you can easily create tickets with a Push Field action. Just use an empty run if condition and select IF NO REQUESTS MATCH CREATE A NEW REQUEST. Be sure to push values into all the required fields, even if you don't use them. Just some interesting trivia. Old-time Remedy developers can easily recall a day when the empty run-if qualification was not available and we had to trick Remedy into creating new requests with a qualification that always evaluated to false, like 1 = 0. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, April 16, 2007 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Table Loop Problem I'm not sure I follow you. I didn't think I could create new tickets with a push field action alone. Are you saying that I should have the guide call an AL that has a single Push Field action that sets the fields I need? Will this create new tickets for each row in the table? I am willing to try anything to get it to work. I do have the Loop Table check-box checked and have tried both selections on the Table Loop Selected Rows Only check-box. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Monday, April 16, 2007 1:59 PM To: arslist@ARSLIST.ORG Subject: Re: Table Loop Problem Andy: It seems to me your first AL is more complicated then it needs to be. Instead of opening the target form in submit mode, setting fields, and then committing the action, why not just do a Push Fields with an empty Push-If qualification? That's the first thing I would change. Then in the Active Link that calls the guide, are you sure you have the Loop Table option checked? Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, April 16, 2007 1:20 PM To: arslist@ARSLIST.ORG Subject: Table Loop Problem I am trying to create a table loop that will create tickets on several location at one time. 1. I have a table set up that populates with the desired locations. 2. I have an active link that performs the following actions, 1. Open Window action-in Submit mode, 2. Set Fields action-populates the needed data, 3 Commit Changes and 4. Close Window. 3. I have an Active Link Guide that calls the first active link. 4. I have an Active Link that calls the Active Link Guide when a button is selected. It appears the active links are firing, but it only creates the first record in the table. I tried selecting the check box for Selected Records Only and selecting all records in the table and also with the Selected Records Only field cleared. It behaves the same both ways. This is the first table loop I have created so I am sure that I missing something simple. ARS 7.0.01, Windows 2003, Win XP Pro client. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ 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 ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Status History Bug
If you reopen it, modify it to be what you want and save it; it will run that way, even though it shows something completely different in the admin tool. This impacts the 'run if', 'set fields if', and 'push fields if' areas of active links, filters, and escalations. http://arswiki.org/bugs/show_bug.cgi?id=42 Axton Grams On 4/17/07, Bowen, Marc [EMAIL PROTECTED] wrote: I just noticed that this also affects existing workflow not just newly created workflow. I had an escalation that where the run if was status history closed time and now it says status history open time. -Original Message- From: Bowen, Marc Sent: Tuesday, April 17, 2007 11:45 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Status History Bug 7.01 patch 001 Solaris 10 Oracle 10.2 This happened to me when trying to use the archive feature, I tried to put status-history-closed time and it reverted to status-history-open time. I opened a ticket and the agent tried it while I was on the phone and it happened to him also. I received an email indicating that they noticed it happens in other areas also. It appears it only affects newly created workflow. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Tuesday, April 17, 2007 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Status History Bug AR Server version? OS? I guess this will be the same as Axton's bug: http://arswiki.org/bugs/show_bug.cgi?id=42 On 4/17/07, Bowen, Marc [EMAIL PROTECTED] wrote: ** I have a defect I posted SW00260084 STEPS TO REPRODUCE: Log into the Administrator Tool Create a form Save it Create a filter Push Fields Action Name: Character Field Value: Select Field-Status History -Time -Closed Click on Add Action Save the Filter 3. ACTUAL RESULTS: $Status History.New.TIME$ appears Marc Bowen Remedy Skilled Professional Office (201) 307-8274 Mobile (917) 273-0951 [EMAIL PROTECTED] *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are html body p***/p pThe information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter./p p***/p /body /html ___ 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
Re: Permissions and Database Performance
Hi Guillaume As I said in my message, all queries also contain WHERE clauses referencing indexed fields. What I am looking for is information about how the way permissions are implemented affects the SQL generated and system performance. and if anyone has benchmarked this. Thanks David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk http://www.westoverconsulting.co.uk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Tuesday, April 17, 2007 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance David, As Axton explained, the point is to have, as much as possible, a query with a field that is indexed and making sure that index is used, so no table scan is performed. One way to make sure an indexed field is used in a query, is to create an active link (or multiple) that fires on search to check whether an indexed field has been set (or a combination of fields). Or you could even default fields when doing a search, such as status, assignee fields, categorization, etc, with other active links firing on search. Guillaume From: David Sanders Sent: Tue 04/17/07 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance ** Hi Axton Thanks for the quick response, and putting my mind at rest about the positioning of the various clauses in the SQL query. I assume positioning should only then be relevant if compound indexes are defined, and I should have more faith in my DBMS to 'do the right thing'. So in the example I gave, I assume that indexes on the Submitter and Assignee fields would help (selective data), but an index on the Assignee Group field would probably not help as the data is not very selective. All queries do contain other WHERE clauses that should reference indexed fields. Again, if anyone has done any benchmarking on the effects of permissions on performance, I would be interested to learn the results. TIA David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance The relative positioning of the pieces of the where clause should have no impact on how the query is parsed by the database. The db will take the query, parse it, then decide the best way to execute it based on what it (the db) considers the cheapest alternative. The like comparison will introduce scans (range and or table), but if the query also includes where clause pieces that use index fields, they will (should) use the index (depends on what the db thinks is cheapest). Think of it like this (scenario 1): - (w/o row level locking) user performs an unqualified search, resulting in a table scan - (w row level locking-multiple) user performs an unqualified search, resulting in a table scan - (w row level locking-single) user performs an unqualified search, resulting in an index scan if the assignee/dynamic group fields are indexed Think of it like this (scenario 2): - (w/o row level locking) user performs a search on an indexed field, resulting in an index scan - (w row level locking-multiple) user performs a search on an indexed field, resulting in an index scan, further qualified by a range scan (against the rowset returned by the index) - (w row level locking-single) user performs a search on an indexed field, resulting in an index scan, further qualified by an additional index scan (against the rowset returned by first the index) To summarize: - will row level locking make unqualified searches more expensive - a little, due to additional parsing requirements (cpu) - will row level locking make qualified searches more expensive - a little, due to additional parsing requirements (cpu) - if the app is well designed, and unqualified searches are not performed against large data sets, the impact should be negligable - if you are using oracle, you can alleviate a lot of the hard parsing by setting the instance parameter CURSOR_SHARING to a value of similar or force - reducing hard parsing will reduce cpu overhead and forcing the use of bind variables will reduce the memory requirements
Re: java RemoteException issue
Flashboards (not the part on the mid-tier server) also uses rmi. If you run a servlet container (jboss, tomcat, websphere, etc.), they will listen on a port for rmi as well. Axton Grams On 4/17/07, Halstead, Robert [EMAIL PROTECTED] wrote: Axton, Thanks for the quick reply. We had to roll back the switch to the server group as we had issues with the licenses we got from BMC. As the licenses went into Remedy with out problems, when we brought Remedy up, the server wouldn't hand out write licenses only read. We're not sure what is going on there. With the Java error, we only get this if we enable the server group. As soon as we rolled back to a non-server group state, we do not get that error. If it does have to deal with the Email Engine, why would this error out only when we enable the server group and not all the time? The next time we attempt this I will take a look at netstat and see if the port is in use. In all reason, this could be our issue for the java error. Is there any other part of the Remedy system that may produce an RMI error? Bob Halstead Bresnan Communications -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 6:45 AM To: arslist@ARSLIST.ORG Subject: Re: java RemoteException issue The email engine uses RMI for the Admin interface. In the EmailDaemon.Properties file, you can specify the port RMI should listen on. com.remedy.arsys.emaildaemon.RMIPort=1100 I believe 1100 is the default Chances are something else is already using this port? Stop Remedy and use the following to see if anything is using this port: $ netstat -na |grep 1100 *.1100 *.*0 0 49152 0 LISTEN or # lsof |grep IP |grep 1100 java 1154 remedy7u IPv4 0x3000d0dac400t0 TCP *:1100 (LISTEN) The 1154 is the pid: $ ps -ef |grep 1154 remedy 1154 895 0 Apr 15 ? 10:06 /usr/java/bin/java -Djava.library.path=/xxx/AREmail -cp /xxx Axton Grams On 4/17/07, Halstead, Robert [EMAIL PROTECTED] wrote: ** Hey guys, we've just enabled our server group, however we're seeing this error pop up when we start remedy. It's a java RemoteException error. Is this crucial for Remedy, or something to ignore? the RemoteException usually has to do with RMI.. I've added our ar_instal_dir/bin and java_dir/bin to the PATH variable in arsystem file, but this doesn't seem to solve the problem. Remedy is up and running, I would like to find out why I only get this when we enable server group though. I'm guessing remedy is trying to communicate with the other server for some reason via RMI. Just a guess though. Any ideas? Here is the PATH variable in the arsystem file: INSTALL_DIR=/opt/remedy/remprd JAVADIR=:/usr/jdk/j2sdk1.4.2_08/jre:/usr/jdk/j2sdk1.4.2_08/jre/lib/sparc /server #installer will add the : in front of this val ue since it might be blank PATH=/sbin:/usr/sbin:/usr/bin:/bin:$INSTALL_DIR/bin:/usr/jdk/j2sdk1.4. 2_08/jre/bin:$PATH; export PATH I've posted the log below. Action Request System initializing. Starting AR System Server (ARNOTE 0) AR Monitor version 6.03.00 patch 020 started. (ARNOTE 0) AR Monitor started. Action Request System(R) Approval Server Version 6.03.00.00 Remedy, a BMC Software company. Copyright (c) 1999 - 2004 BMC Software, Inc. All rights reserved. AR System Reconciliation Engine Version 1.00.00 patch 005 Remedy, a BMC Software company. Copyright (c) 2004 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1991 - 2005 BMC Software, Inc. All rights reserved. 390600 : A floating license specification was ignored because it requires a server group tag (ARERR 3329) Action Request System(R) Fork Daemon Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2000 - 2005 BMC Software, Inc. All rights reserved. (ARNOTE 0) Server indicates that it's up. Action Request System AR System Application Command Dispatcher Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 1998 - 2005 BMC Software, Inc. All rights reserved. Action Request System(R) Plug-In Server Version 6.03.00 patch 020 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused AR System Email Engine has started RemoteException java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused Loaded Web Services plugin properly Action Request System initialization is complete. __20060125___This posting was submitted with
Re: Showing related records.
Hi Neha, can I have your contact details? thanks, Raj Kulkarni Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Vyom Labs - ITSM Support Sent: Tuesday, April 17, 2007 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: Showing related records. Hi, For this you can create 2 character fields say Ch1 and Ch2 and 2 buttons say B1 and B2.Perform set field action in Ch1 to col1(Record Id) of Table A.In Ch2 perform set field action to $ch1$ after the set field if qualification Ch2=$Ch1$.In B1 give the Run if Qualification:- ( 'Ch1' != $NULL$ ) AND ( 'Ch2' = $NULL$ )and set field to Ch2 as $Ch1$ and Commit Changes.In B2 perform Call Guide that constitute all these three active links.In this select the Table loop and Table loop Selected Rows Only. Thanks, Neha -- [EMAIL PROTECTED] www.vyomlabs.com Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Congo wrote: Hello, Ive got 2 tables, lets say A and B First one holds some records added manually On the second I'd like to have all records related to those from table A I think I need to loop over the table A , get each record ID and pass it to the qualification on table B. First thing: my actl guide doesnt seem to work correctly, it always gives me only one ID (Table loop Selected Rows checkbox is unchecked) Second thing: how to pass the obtained ID to the Table B to use it with the qualification. Any advices are welcome. Thanks. ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Status History Bug
AR Server version? OS? I guess this will be the same as Axton's bug: http://arswiki.org/bugs/show_bug.cgi?id=42 On 4/17/07, Bowen, Marc [EMAIL PROTECTED] wrote: ** I have a defect I posted SW00260084 STEPS TO REPRODUCE: Log into the Administrator Tool Create a form Save it Create a filter Push Fields Action Name: Character Field Value: Select Field-Status History -Time -Closed Click on Add Action Save the Filter 3. ACTUAL RESULTS: $Status History.New.TIME$ appears Marc Bowen Remedy Skilled Professional Office (201) 307-8274 Mobile (917) 273-0951 [EMAIL PROTECTED] *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Permissions and Database Performance
Hi Axton Thanks for the quick response, and putting my mind at rest about the positioning of the various clauses in the SQL query. I assume positioning should only then be relevant if compound indexes are defined, and I should have more faith in my DBMS to 'do the right thing'. So in the example I gave, I assume that indexes on the Submitter and Assignee fields would help (selective data), but an index on the Assignee Group field would probably not help as the data is not very selective. All queries do contain other WHERE clauses that should reference indexed fields. Again, if anyone has done any benchmarking on the effects of permissions on performance, I would be interested to learn the results. TIA David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk http://www.westoverconsulting.co.uk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance The relative positioning of the pieces of the where clause should have no impact on how the query is parsed by the database. The db will take the query, parse it, then decide the best way to execute it based on what it (the db) considers the cheapest alternative. The like comparison will introduce scans (range and or table), but if the query also includes where clause pieces that use index fields, they will (should) use the index (depends on what the db thinks is cheapest). Think of it like this (scenario 1): - (w/o row level locking) user performs an unqualified search, resulting in a table scan - (w row level locking-multiple) user performs an unqualified search, resulting in a table scan - (w row level locking-single) user performs an unqualified search, resulting in an index scan if the assignee/dynamic group fields are indexed Think of it like this (scenario 2): - (w/o row level locking) user performs a search on an indexed field, resulting in an index scan - (w row level locking-multiple) user performs a search on an indexed field, resulting in an index scan, further qualified by a range scan (against the rowset returned by the index) - (w row level locking-single) user performs a search on an indexed field, resulting in an index scan, further qualified by an additional index scan (against the rowset returned by first the index) To summarize: - will row level locking make unqualified searches more expensive - a little, due to additional parsing requirements (cpu) - will row level locking make qualified searches more expensive - a little, due to additional parsing requirements (cpu) - if the app is well designed, and unqualified searches are not performed against large data sets, the impact should be negligable - if you are using oracle, you can alleviate a lot of the hard parsing by setting the instance parameter CURSOR_SHARING to a value of similar or force - reducing hard parsing will reduce cpu overhead and forcing the use of bind variables will reduce the memory requirements (due to a smaller shared sql area) Axton Grams On 4/17/07, David Sanders [EMAIL PROTECTED] wrote: ** Hi List I'm looking for any advice or comments from you database performance gurus out there on the way ARS enforces access to data through permissions and the effect on performance. Take an example of a ticket form using row level access where the permissions on the Request ID field are set to Assignee, Assignee Group and Submitter. For an Admin user there is no problem, but for non-Admin users the systems adds SQL similar to the following to the beginning of the SQL to enforce permissions: SELECT T201.C1,C8,C700037500,C700037000,C700034003,C73000 FROM T201 WHERE (((T201.C2 = 'fred') OR (T201.C4 = 'fred')) OR ((T201.C112 LIKE '%;''fred;%'') OR ((T201.C112 LIKE '%;0;%') OR ((T201.C112 LIKE '%;73421;%') OR ((T201.C112 LIKE '%;73419;%') OR ((T201.C112 LIKE '%;73404;%') OR (T201.C112 LIKE '%;73401;%'))) AND. rest of query. That's checking whether the user (fred) is the assignee or submitter, then doing a series of LIKE comparisons against the Assignee Group field for every group that fred's a member of. This SQL is for a server config where the Allow Multiple Assignee Groups is checked (the default). Does the positioning of these blocks of query at the start of the SQL mean that indexes on fields defined later in the query are less likely to be used, and that table scans will be used? Would performance be improved if this extra SQL were placed at the end of the query (after the clauses defined by
Re: RPT-files generating using AR System workflow: Is It possible?
Hi Alexander, I was trying to have the same functionality. But since the crystal report templates are designed before writing workflows, we can't modify them later at the run time. So we were left with the only option- to have one .rpt file per each report type. The same thing is true for AR System reports which are created through built in report forms. Thanks, Bipin -- [EMAIL PROTECTED] www.vyomlabs.com Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Zinoviev Alexander wrote: ** Hello, I want to create or modify *.rpt-files while working in Remedy User (without opening Crystal Report Designer) giving parameters showing which columns to include in the report and making other changes. How can Remedy integrate with Crystal Reports in this case? I have BMC Remedy AR Server 7.01 and Business Objects (Crystal Reports) Server XI Kind regards, Alexander Zinoviev __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Permissions and Database Performance
David, As Axton explained, the point is to have, as much as possible, a query with a field that is indexed and making sure that index is used, so no table scan is performed. One way to make sure an indexed field is used in a query, is to create an active link (or multiple) that fires on search to check whether an indexed field has been set (or a combination of fields). Or you could even default fields when doing a search, such as status, assignee fields, categorization, etc, with other active links firing on search. Guillaume From: David Sanders Sent: Tue 04/17/07 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance ** Hi Axton Thanks for the quick response, and putting my mind at rest about the positioning of the various clauses in the SQL query. I assume positioning should only then be relevant if compound indexes are defined, and I should have more faith in my DBMS to 'do the right thing'. So in the example I gave, I assume that indexes on the Submitter and Assignee fields would help (selective data), but an index on the Assignee Group field would probably not help as the data is not very selective. All queries do contain other WHERE clauses that should reference indexed fields. Again, if anyone has done any benchmarking on the effects of permissions on performance, I would be interested to learn the results. TIA David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance The relative positioning of the pieces of the where clause should have no impact on how the query is parsed by the database. The db will take the query, parse it, then decide the best way to execute it based on what it (the db) considers the cheapest alternative. The like comparison will introduce scans (range and or table), but if the query also includes where clause pieces that use index fields, they will (should) use the index (depends on what the db thinks is cheapest). Think of it like this (scenario 1): - (w/o row level locking) user performs an unqualified search, resulting in a table scan - (w row level locking-multiple) user performs an unqualified search, resulting in a table scan - (w row level locking-single) user performs an unqualified search, resulting in an index scan if the assignee/dynamic group fields are indexed Think of it like this (scenario 2): - (w/o row level locking) user performs a search on an indexed field, resulting in an index scan - (w row level locking-multiple) user performs a search on an indexed field, resulting in an index scan, further qualified by a range scan (against the rowset returned by the index) - (w row level locking-single) user performs a search on an indexed field, resulting in an index scan, further qualified by an additional index scan (against the rowset returned by first the index) To summarize: - will row level locking make unqualified searches more expensive - a little, due to additional parsing requirements (cpu) - will row level locking make qualified searches more expensive - a little, due to additional parsing requirements (cpu) - if the app is well designed, and unqualified searches are not performed against large data sets, the impact should be negligable - if you are using oracle, you can alleviate a lot of the hard parsing by setting the instance parameter CURSOR_SHARING to a value of similar or force - reducing hard parsing will reduce cpu overhead and forcing the use of bind variables will reduce the memory requirements (due to a smaller shared sql area) Axton Grams On 4/17/07, David Sanders [EMAIL PROTECTED] wrote: ** Hi List I'm looking for any advice or comments from you database performance gurus out there on the way ARS enforces access to data through permissions and the effect on performance. Take an example of a ticket form using row level access where the permissions on the Request ID field are set to Assignee, Assignee Group and Submitter. For an Admin user there is no problem, but for non-Admin users the systems adds SQL similar to the following to the beginning of the SQL to enforce permissions: SELECT T201.C1,C8,C700037500,C700037000,C700034003,C73000 FROM T201 WHERE (((T201.C2 = 'fred') OR (T201.C4 = 'fred')) OR ((T201.C112 LIKE '%;''fred;%'') OR ((T201.C112 LIKE '%;0;%') OR ((T201.C112 LIKE '%;73421;%') OR ((T201.C112 LIKE '%;73419;%') OR ((T201.C112 LIKE '%;73404;%') OR (T201.C112 LIKE '%;73401;%'))) AND. rest of query. That's checking whether the user (fred) is the
API .NET/C++
Anyone know of anyplace where I can look at some free sample code using VB.NET or C++ for the Remedy API? I'm a relative newbie to the Remedy API and am intermediate in ASP.NET and C++. I looked at the examples in the e-books, but it doesn't seem to address some questions I have about it. Thanks. - Rem _ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Permissions and Database Performance
Hi David, It might be just easier to ask the DBAs to look into this. Assuming you are on Oracle, the SQL Tuning Advisor can be used exactly for this purpose. BTW, Oracle 10g has automatic SQL tuning features that should be taken advantage to make performance tuning much easier: You can view an introduction to automatic SQL tuning features here: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm#i34782 Guillaume From: David Sanders Sent: Tue 04/17/07 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance ** Hi Guillaume As I said in my message, all queries also contain WHERE clauses referencing indexed fields. What I am looking for is information about how the way permissions are implemented affects the SQL generated and system performance. and if anyone has benchmarked this. Thanks David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Tuesday, April 17, 2007 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance David, As Axton explained, the point is to have, as much as possible, a query with a field that is indexed and making sure that index is used, so no table scan is performed. One way to make sure an indexed field is used in a query, is to create an active link (or multiple) that fires on search to check whether an indexed field has been set (or a combination of fields). Or you could even default fields when doing a search, such as status, assignee fields, categorization, etc, with other active links firing on search. Guillaume From: David Sanders Sent: Tue 04/17/07 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance ** Hi Axton Thanks for the quick response, and putting my mind at rest about the positioning of the various clauses in the SQL query. I assume positioning should only then be relevant if compound indexes are defined, and I should have more faith in my DBMS to 'do the right thing'. So in the example I gave, I assume that indexes on the Submitter and Assignee fields would help (selective data), but an index on the Assignee Group field would probably not help as the data is not very selective. All queries do contain other WHERE clauses that should reference indexed fields. Again, if anyone has done any benchmarking on the effects of permissions on performance, I would be interested to learn the results. TIA David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, April 17, 2007 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions and Database Performance The relative positioning of the pieces of the where clause should have no impact on how the query is parsed by the database. The db will take the query, parse it, then decide the best way to execute it based on what it (the db) considers the cheapest alternative. The like comparison will introduce scans (range and or table), but if the query also includes where clause pieces that use index fields, they will (should) use the index (depends on what the db thinks is cheapest). Think of it like this (scenario 1): - (w/o row level locking) user performs an unqualified search, resulting in a table scan - (w row level locking-multiple) user performs an unqualified search, resulting in a table scan - (w row level locking-single) user performs an unqualified search, resulting in an index scan if the assignee/dynamic group fields are indexed Think of it like this (scenario 2): - (w/o row level locking) user performs a search on an indexed field, resulting in an index scan - (w row level locking-multiple) user performs a search on an indexed field, resulting in an index scan, further qualified by a range scan (against the rowset returned by the index) - (w row level locking-single) user performs a search on an indexed field, resulting in an index scan, further qualified by an additional index scan (against the rowset returned by first the index) To summarize: - will row level locking make unqualified searches more expensive - a little, due to additional parsing requirements (cpu) - will row level locking make qualified searches more expensive - a little, due to additional parsing requirements (cpu) - if the app is well designed, and
Java API - ARServerUser method
ARServerUser.setOverridePrevIP(int) Anyone know what this method does/what is the previous IP flag? The Java API docs only say: Set the override previous IP flag (Helpful) Using ARS 6.3 Thanks- Kelly Heikkila Kinetic Data ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Java 1.5 bug
Guys, just a heads-up on this one for those doing new installs. Support clued me into it when trying to solve a larger MT install problem. If you plan to use the 1.5.0_11 Java SDK, know that it has a bug that prevents it from writing its install path to the Registry. This prevents the Mid-Tier install from seeing that the JDK is installed at all. The workaround is to either use another version or to manually enter the path in the following places: HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Development Kit\1.5 HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Development Kit\1.5.0_11 Rick Cook Remedy Skilled Professional Cook Enterprises ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.0.1 Patch 001; ARDBC LDAP question
Murtuza, I installed it. I turned on plugin logging and I see that it is starting and reading appropriate settings. There are no errors reported. I will rerun the install and see what happens. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of msb * Sent: Tuesday, April 17, 2007 4:33 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 Patch 001; ARDBC LDAP question Kamlesh, is it possible that you missed installing the ARDBC LDAP stuff while installing your AR server. Regards, Murtuza. From: Patel, Kamlesh R. [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 Patch 001; ARDBC LDAP question Date: Mon, 16 Apr 2007 15:45:00 -0600 All, I am at a lose after configuring ARDBC LDAP Configuration form. I configured it, but I am unable to view the vendor form in the list create vendor form Available Vendor Names. It only shows the flashboards and server admin. What are the necessary steps to setup ARDBC LDAP form so that I can query my LDAP directory? Thanks Kamlesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ 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
Re: Java API - ARServerUser method
Kelly, This has everything to do with the new license restriction for users to only connect from one IP address at a time. It is my understanding that if this flag is set to true, and the user your trying to use is already connected from a different IP address then the ARS server will try to release the different IP and allow the current IP to become the active IP address. (Subject to the once every 15 minute rule.) If the user is not connected from any other IP address I HOPE that the flag does nothing harmful. However, I have not tested it. Also keep in mind that Administrator accounts are not subject to this IP based restriction. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 4/17/07, Kelly Heikkila [EMAIL PROTECTED] wrote: ** ARServerUser.setOverridePrevIP(int) Anyone know what this method does/what is the previous IP flag? The Java API docs only say: Set the override previous IP flag (Helpful) Using ARS 6.3 Thanks- Kelly Heikkila Kinetic Data ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: mid-tier config issue
the ISAPI Filter tab, has servletexec Priority unknown and down.. but it looks up ? is this an issue ? On 4/17/07, patrick zandi [EMAIL PROTECTED] wrote: ok, I am working with a new mid-tier, and now attempting to get her working.. I did something squirrelly, not sure what .. Pages getting are Service unavailible. log says 2007-04-17 17:33:24 W3SVC1 127.0.0.1 POST /servletexec/admin/j_security_check - 80 HD1\USER 127.0.0.1Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30) 302 0 0 2007-04-17 17:33:24 W3SVC1 127.0.0.1 GET /servletexec/admin/login.jsp failed=true 80 - 127.0.0.1Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30) 401 1 0 2007-04-17 17:33:24 W3SVC1 127.0.0.1 GET /servletexec/admin/login.jsp failed=true 80 HD1\USER 127.0.0.1Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30) 200 0 0 - NewAtlanta - just put in the latest patch 5.0.13 I think. - Anyone see this ? -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Vendor Tables
Hi All, I am trying to read the data from an external oracle table thru a vendor form. I need to bring the data into a remedy table. I realize I need to create a filter and escalation. I am just not sure how to do this. Has anyone ever done this workflow before? ** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Full Time Remedy Developer Position in Alpharetta Georgia
Hi Jack, I read the email on the ARSList and I thought I follow up my earlier quick note with a brief introduction. My name is Joseph R Williams, I consider my self to be an expert Remedy ARS developer. I have over 7 years experience with ARS. I also have other execellent programming skills as well. Thanks for taking the time to look at my resume. Thanks Joseph R Williams 770-880-5711 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack Sent: Tuesday, April 17, 2007 11:26 AM To: arslist@ARSLIST.ORG Subject: Full Time Remedy Developer Position in Alpharetta Georgia ** Hi all. I'm looking for a Remedy Developer that is interested in a full time position in Alpharetta Georgia. Remedy 7 experience would be great, but not required. Not looking for an administrator, looking for a developer. Customer service, consulting and project management skills are important. Email me offline. I'm not a recruiter. Jack Covert __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Fwd: View Tables
In a message dated 4/17/2007 11:47:41 A.M. Pacific Daylight Time, Kathymorris727 writes: Hi All, I am trying to read the data from an external oracle table thru a view form. I need to bring the data into a remedy table. I realize I need to create a filter and escalation. I am just not sure how to do this. Has anyone ever done this workflow before? Correction - these are view tables. ** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---BeginMessage--- Hi All, I am trying to read the data from an external oracle table thru a vendor form. I need to bring the data into a remedy table. I realize I need to create a filter and escalation. I am just not sure how to do this. Has anyone ever done this workflow before? ** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---End Message---
Re: Vendor Tables
Pick up a key reference field, on your Push Field action, compare the key reference field from that external table to the key field on the remedy form, and if no requests match, create a new entry. If any requests match, take no action.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kathy Morris Sent: Tuesday, April 17, 2007 2:48 PM To: arslist@ARSLIST.ORG Subject: Vendor Tables ** Hi All, I am trying to read the data from an external oracle table thru a vendor form. I need to bring the data into a remedy table. I realize I need to create a filter and escalation. I am just not sure how to do this. Has anyone ever done this workflow before? -- See what's free at AOL.com. __20060125___This posting was submitted with HTML in it___ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007 4:43 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: View Tables
Doesn't really matter if its a view, vendor, regular or join form you are reading from, the method remains the same.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kathy Morris Sent: Tuesday, April 17, 2007 3:07 PM To: arslist@ARSLIST.ORG Subject: Fwd: View Tables ** In a message dated 4/17/2007 11:47:41 A.M. Pacific Daylight Time, Kathymorris727 writes: Hi All, I am trying to read the data from an external oracle table thru a view form. I need to bring the data into a remedy table. I realize I need to create a filter and escalation. I am just not sure how to do this. Has anyone ever done this workflow before? Correction - these are view tables. -- See what's free at AOL.com. __20060125___This posting was submitted with HTML in it___ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007 4:43 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Vendor Tables
** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
.obf files filling up dev server
Anyone know what an .obf file is? My dev server is filling up with them. tia, rp Windows 2000 AS Ora 9i ARS 7.0.1p1 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Full Time Remedy Developer Position in Alpharetta Georgia
You might spell-check your response, too, Joseph, as well as your resume. I trust that your Remedy skills are more execellent than your response here was. Good luck in your search. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, April 17, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Full Time Remedy Developer Position in Alpharetta Georgia ** First of all you didn't write directly to Jack.. Secondly don't forget to attach your resume when you write to Jack. You forgot to attach it to this mail, which however should be ok cause Jack might hardly notice your response on the list.. :-) Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Williams, Joseph (CDC/CCHIS/NCPHI) (CTR) Sent: Tuesday, April 17, 2007 3:02 PM To: arslist@ARSLIST.ORG Subject: Re: Full Time Remedy Developer Position in Alpharetta Georgia ** Hi Jack, I read the email on the ARSList and I thought I follow up my earlier quick note with a brief introduction. My name is Joseph R Williams, I consider my self to be an expert Remedy ARS developer. I have over 7 years experience with ARS. I also have other execellent programming skills as well. Thanks for taking the time to look at my resume. Thanks Joseph R Williams 770-880-5711 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack Sent: Tuesday, April 17, 2007 11:26 AM To: arslist@ARSLIST.ORG Subject: Full Time Remedy Developer Position in Alpharetta Georgia ** Hi all. I'm looking for a Remedy Developer that is interested in a full time position in Alpharetta Georgia. Remedy 7 experience would be great, but not required. Not looking for an administrator, looking for a developer. Customer service, consulting and project management skills are important. Email me offline. I'm not a recruiter. Jack Covert __20060125___This posting was submitted with HTML in it___ __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: Vendor Tables
I created the view form however when I search the new form for records (via user tool), I get the error that says Entry ID parameter is empty. I understand the error to mean there is no remedy entry ID and every record has to have an entry id - just not sure how to generate this ID while building the view form. ** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
C API for Service Desk
Hello List! We have upgraded our old HelpDesk 4.x to the new good looking ServiceDesk. We have a C API that allows tickets to be automatically created when a user sends a mail to a particular email. Anyway, we have to upgrade the C API code because the fields in the new ServiceDesk are very different from the old HPD. I am almost done in implementing this until I bumped into a couple of things: 1. Incident ID field. How do I generate this? I noticed in the Active Link, it uses the keyword $LASTID$. How do I use this in the C API? 2. No groups were found using automated routing. You need to manually select a group. (ARERR 44699). I get this error when printing out the ARStatusList after submitting the ticket. When I use the user tool, this error will pop up if I don't manually assign values to the following fields: Assigned Support Organization and Assigned Group. These fields are dropdown menus, and the Assigned Group list of values will depend on what value you chose under Assigned Support Organization. Anyway, in my C API code, I assigned these fields with values: Assigned Support Company (100251) : :University of Cowtown Assigned Support Organization (100014) : ICS Assigned Group (100217) : Tier-One The rest of the required fields are filled up with necessary values. After submitting the ticket, it gives me that groups were not found using automated routing. Any ideas anyone? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Vendor Tables
Kathy, You need to select a column to use as a key field That filed must be: 1. 15 Characters or less 2. Non NULL 3. Unique That error usually comes from a null value in the key field. If you get a Results list and start clicking where the results should be you may see values in your View form details pane. That will confirm that you have connected to the remote DB Table but the key field in not Non Null and Unique. HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, April 17, 2007 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Vendor Tables ** I created the view form however when I search the new form for records (via user tool), I get the error that says Entry ID parameter is empty. I understand the error to mean there is no remedy entry ID and every record has to have an entry id - just not sure how to generate this ID while building the view form. See what's free at AOL.com http://www.aol.com?ncid=AOLAOF0002000503 . __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: C API for Service Desk
Go into the Application Administration Console Custom Configuration tab Foundation Configure Application Assignment. By creating an entry for Incident to be assigned to a group the No groups found will be fixed. There is a new form that holds the Incident ID and if you manually create a new Incident and capture the Active Link workflow you will be able to see what you will need to do to create a new Incident ID. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 17 Apr 2007 4:34 PM Subject: C API for Service Desk Hello List! We have upgraded our old HelpDesk 4.x to the new good looking ServiceDesk. We have a C API that allows tickets to be automatically created when a user sends a mail to a particular email. Anyway, we have to upgrade the C API code because the fields in the new ServiceDesk are very different from the old HPD. I am almost done in implementing this until I bumped into a couple of things: 1. Incident ID field. How do I generate this? I noticed in the Active Link, it uses the keyword $LASTID$. How do I use this in the C API? 2. No groups were found using automated routing. You need to manually select a group. (ARERR 44699). I get this error when printing out the ARStatusList after submitting the ticket. When I use the user tool, this error will pop up if I don't manually assign values to the following fields: Assigned Support Organization and Assigned Group. These fields are dropdown menus, and the Assigned Group list of values will depend on what value you chose under Assigned Support Organization. Anyway, in my C API code, I assigned these fields with values: Assigned Support Company (100251) : :University of Cowtown Assigned Support Organization (100014) : ICS Assigned Group (100217) : Tier-One The rest of the required fields are filled up with necessary values. After submitting the ticket, it gives me that groups were not found using automated routing. Any ideas anyone? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Oracle 9iR2 upgrade to 10g
Has anyone upgraded their Oracle database from 9iR2 to 10g while keeping their ARS at version 5.1.2? If so, what issues did you encounter? Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: .obf files filling up dev server
What are some of the file names and where are they located? Axton On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: Anyone know what an .obf file is? My dev server is filling up with them. tia, rp Windows 2000 AS Ora 9i ARS 7.0.1p1 ___ 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
Re: C API for Service Desk
Hello Roger, By creating an entry for Incident to be assigned to a group the No groups found will be fixed - We have already set this up. In the drop-down fields, there are already values in it, and the values I assigned in the C API code coincide with the values in the pull-down menus for these fields. And I still get that error. As for creating a new incident ID, the workflow calls the AL: HPD:INC:GIN_010_SetINCNumber-P (10) it does 3 actions, and one of the 3 action is setting the Incident Number (100161) = INC00065, which is the $LASTID$ value. But my question is, how do I get this value from the C API? Thanks, On Apr 17, 2:47 pm, Roger Justice [EMAIL PROTECTED] wrote: Go into the Application Administration Console Custom Configuration tab Foundation Configure Application Assignment. By creating an entry for Incident to be assigned to a group the No groups found will be fixed. There is a new form that holds the Incident ID and if you manually create a new Incident and capture the Active Link workflow you will be able to see what you will need to do to create a new Incident ID. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tue, 17 Apr 2007 4:34 PM Subject: C API for Service Desk Hello List! We have upgraded our old HelpDesk 4.x to the new good looking ServiceDesk. We have a C API that allows tickets to be automatically created when a user sends a mail to a particular email. Anyway, we have to upgrade the C API code because the fields in the new ServiceDesk are very different from the old HPD. I am almost done in implementing this until I bumped into a couple of things: 1. Incident ID field. How do I generate this? I noticed in the Active Link, it uses the keyword $LASTID$. How do I use this in the C API? 2. No groups were found using automated routing. You need to manually select a group. (ARERR 44699). I get this error when printing out the ARStatusList after submitting the ticket. When I use the user tool, this error will pop up if I don't manually assign values to the following fields: Assigned Support Organization and Assigned Group. These fields are dropdown menus, and the Assigned Group list of values will depend on what value you chose under Assigned Support Organization. Anyway, in my C API code, I assigned these fields with values: Assigned Support Company (100251) : :University of Cowtown Assigned Support Organization (100014) : ICS Assigned Group (100217) : Tier-One The rest of the required fields are filled up with necessary values. After submitting the ticket, it gives me that groups were not found using automated routing. Any ideas anyone? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Login Id field in Incident Management - Requestor ID ?
Murtuza, thanks a bunch for your response, its much appreciated. I am half-way there, having trouble figuring out exactly how the z1D Charnn fields are set. Should I use one of the existing z1D Charnn fields for the Login ID or should I create a new one ? If I can use an existing one, how do I know which one I can use ? If I need to create a new one how do I do that ? These fields are not in any HPD:HelpDesk view, yet I see them in the avaialable fields. Roger, yes I asked Remedy and they could not find the Requestor ID field, and said to create a new field on the HelpDesk form. I did a google on it and it was said to be on the SRM:Request form but I can't find it there either thanks, Colin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of msb * Sent: Tuesday, April 17, 2007 1:22 AM To: arslist@ARSLIST.ORG Subject: Re: FW: Login Id field in Incident Management - Requestor ID ? Colin, Just did this myself. I needed login ID as well as Full name. Just added 2 new fields. The workflow to modify would be: HPD:INC:PCS_100_Search 110_srch=-E 120_search=-G HPD:INC:ContactFound_100_setup Plus add some workflow if you want to press enter in the field and have it do the search too. Regards, Murtuza. From: Chapman, Colin [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: FW: Login Id field in Incident Management - Requestor ID ? Date: Mon, 16 Apr 2007 18:20:58 -0400 Roger - thanks for the response again - it is much appreciated - hopefully I'm not being too dense. I still cannot find Requesotr ID or field ID 100337 on the HPD:HelpDesk form Am I looking in the wrong place or do we have different versions ? Shall I just go ahead and add a field ID 100337 to the HPD:HelpDesk form ? and then modify the workflow, I found Active Link HPD:INC:PCS_100_Search I have put a ticket in at BMC support but they are not much help - first they said use Assignee Login ID field, then they said use the Person ID field to go get the Login ID from the people form - neither is what I need. thanks, Colin Colin Chapman Dept. of Application Services, Information Technology Systems Division, University of North Carolina at Wilmington 601 South College Rd. Wilmington, NC 28403-5908 Phone: 910-962-7356 Fax: 910-962-4067 Email: [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, April 16, 2007 5:27 PM To: arslist@ARSLIST.ORG Subject: Re: Login Id field in Incident Management - Requestor ID ? ** Requestor ID is number 100337 this was created by BMC Development and has to be there. I then added it to the set fields action of Active Link HPD:INC:PCS_100_Search. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 16 Apr 2007 5:08 PM Subject: FW: Login Id field in Incident Management - Requestor ID ? ** Roger, thanks - that's a great tip to look at the fields-in-vew to see all the fields on a form, however I do not see the Requestor ID field (on the HPD:HelpDesk form) I do see Person ID, which I see is set the Customer's People form Person ID, but I don't see the Customer Login ID anywhere - there is a Login_ID field but its not populated (looking at a ticket using the Report option to see all these fields) any more ideas ? thanks again Colin Colin Chapman Dept. of Application Services, Information Technology Systems Division, University of North Carolina at Wilmington 601 South College Rd. Wilmington, NC 28403-5908 Phone: 910-962-7356 Fax: 910-962-4067 Email: [EMAIL PROTECTED] javascript:parent.ComposeTo(chapmanc%40uncw.edu, ); From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG javascript:parent.ComposeTo(arslist%40ARSLIST.ORG, ); ] On Behalf Of Roger Justice Sent: Monday, April 16, 2007 2:53 PM To: arslist@ARSLIST.ORG javascript:parent.ComposeTo(arslist%40ARSLIST.ORG, ); Subject: Re: Login Id field in Incident Management ** The field you are looking for is still there it is now called Requestor ID and the workflow already there populates it. In the Admin tool select from the pull downs Form then current view then Fields in view. On the left side of the dialog select the Requestor field from the list of fields not in the view. You will also have to move the field after you bring it into the view. -Original Message- From: [EMAIL PROTECTED] javascript:parent.ComposeTo(chapmanc%40UNCW.EDU, ); To: arslist@ARSLIST.ORG javascript:parent.ComposeTo(arslist%40ARSLIST.ORG, ); Sent: Mon, 16 Apr 2007 2:24 PM Subject: Login Id field in Incident Management ** Hi, ARS Listers. I am an inexperienced Admin, trying to make minor customizations to ServiceDesk 7.0.01 (AR System
Re: API .NET/C++
If you're specifically after C#, do a search of the list archives - I remember a lister (Brandi?) putting up an excellent example of creating a request using AR System .NET C#. From: Action Request System discussion list(ARSList) on behalf of Axton Sent: Wed 18/04/07 00:20 To: ARSList Subject: Re: API .NET/C++ Some programs that use the remedy .net api are available at: http://arswiki.org/projects/dotnetutil Click the Browse Source tab to view the source code. There are total of 5 apps. Axton Grams On 4/17/07, CONDREA, Daniel [EMAIL PROTECTED] wrote: ** AR System Developer Community http://www.bmc.com/arsystem/dev_community/ AR System .NET and COM API From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rem Valenzuela Sent: Tuesday, April 17, 2007 4:48 PM To: arslist@ARSLIST.ORG Subject: API .NET/C++ ** Anyone know of anyplace where I can look at some free sample code using VB.NET or C++ for the Remedy API? I'm a relative newbie to the Remedy API and am intermediate in ASP.NET and C++. I looked at the examples in the e-books, but it doesn't seem to address some questions I have about it. Thanks. - Rem Get news, entertainment and everything you care about at Live.com. Check it out! __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Vendor Tables
Thanks all - You were correct - the key field was null, which is the reason the data search was delivering an error. ** See what's free at http://www.aol.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: C API for Service Desk
Mikhail, The LASTID keyword is a way to reference the last Entry-Id (or 'Request ID') of the record that was just created. So in your C program the LASTID would have been returned from a ARCreateEntry call just prior to your need for the LASTID value. As far as the second part of your original question I would suggest that you turn on Active Link logging and see if when you set each of the fields that you referenced [Assigned Support Company (100251), Assigned Support Organization (100014), Assigned Group (100217)] if active links are setting other fields with ID type values that map to the values that the user sees. It could explain why you get the message when you think you supplied the correct values. You also might track down the workflow that is issuing the message and look at the Run If. It likely would also tell you what fields it ultimately cares about and help you to better understand the Active Link logs from above. Oh.. and keep in mind that other active links (like on Submit, Loose Focus, button, etc...) could also be part of this puzzle too. You might have to trace the whole client process to create an issue to see everything you need to see. [ You might even need to trace several ticket creates due to possible variability in inputs that your script might have too. ] HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 4/17/07, Mikhail [EMAIL PROTECTED] wrote: Hello Roger, By creating an entry for Incident to be assigned to a group the No groups found will be fixed - We have already set this up. In the drop-down fields, there are already values in it, and the values I assigned in the C API code coincide with the values in the pull-down menus for these fields. And I still get that error. As for creating a new incident ID, the workflow calls the AL: HPD:INC:GIN_010_SetINCNumber-P (10) it does 3 actions, and one of the 3 action is setting the Incident Number (100161) = INC00065, which is the $LASTID$ value. But my question is, how do I get this value from the C API? Thanks, snip -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tue, 17 Apr 2007 4:34 PM Subject: C API for Service Desk Hello List! We have upgraded our old HelpDesk 4.x to the new good looking ServiceDesk. We have a C API that allows tickets to be automatically created when a user sends a mail to a particular email. Anyway, we have to upgrade the C API code because the fields in the new ServiceDesk are very different from the old HPD. I am almost done in implementing this until I bumped into a couple of things: 1. Incident ID field. How do I generate this? I noticed in the Active Link, it uses the keyword $LASTID$. How do I use this in the C API? 2. No groups were found using automated routing. You need to manually select a group. (ARERR 44699). I get this error when printing out the ARStatusList after submitting the ticket. When I use the user tool, this error will pop up if I don't manually assign values to the following fields: Assigned Support Organization and Assigned Group. These fields are dropdown menus, and the Assigned Group list of values will depend on what value you chose under Assigned Support Organization. Anyway, in my C API code, I assigned these fields with values: Assigned Support Company (100251) : :University of Cowtown Assigned Support Organization (100014) : ICS Assigned Group (100217) : Tier-One The rest of the required fields are filled up with necessary values. After submitting the ticket, it gives me that groups were not found using automated routing. Any ideas anyone? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.0.1 Patch 001; ARDBC LDAP question
Kamlesh, Did you configure the ARDBC LDAP configuration form correctly? Once that is configured with all the required parameters correctly, the LDAP vendor entry should show up while creating the vendor form.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Patel, Kamlesh R. Sent: Monday, April 16, 2007 5:45 PM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 Patch 001; ARDBC LDAP question ** All, I am at a lose after configuring ARDBC LDAP Configuration form. I configured it, but I am unable to view the vendor form in the list create vendor form “Available Vendor Names”. It only shows the flashboards and server admin. What are the necessary steps to setup ARDBC LDAP form so that I can query my LDAP directory? Thanks Kamlesh __20060125___This posting was submitted with HTML in it___ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.1/765 - Release Date: 4/17/2007 5:20 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: .obf files filling up dev server
tmp1175120658812159279.obf I've had dozens of these creatures created recently in my temp directory ranging from 10's of MB to 100's of MB. Ran my disk space down to 2MB. I noticed it first when my Remedy apps began exiting, SQL began throwing errors, RDP wouldn't start, etc. Google didn't reveal much, except for some references to Tivoli (no Tivoli on this machine), so I wondered if anyone on the list knew. I've been moving them manually to another partition, but that got old before I even started. tia, rp On Apr 17, 5:21 pm, Axton [EMAIL PROTECTED] wrote: What are some of the file names and where are they located? Axton On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: Anyone know what an .obf file is? My dev server is filling up with them. tia, rp Windows 2000 AS Ora 9i ARS 7.0.1p1 ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: .obf files filling up dev server
I know there is an issue with the email engine generating lots of temp files. Our production server got into the 10's of thousands of files before we cleaned it up the first time. 7.0.1p2 for the email engine was supposed to address this. It could possibly be this, though on solaris, each file was only hundreds of bytes in size. A shot in the dark. What outgoing protocol do you use? The only meaningful references I found online in reference to obf mime were: http://math.nist.gov/oommf/doc/userguide11b2/userguide/Vector_Field_Display_mmDisp.html - application/x-oommf-vf - OOMMF Vector Field Not really sure how you could track what is writing there or what has file locks on any of the files on windows. Axton Grams On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: tmp1175120658812159279.obf I've had dozens of these creatures created recently in my temp directory ranging from 10's of MB to 100's of MB. Ran my disk space down to 2MB. I noticed it first when my Remedy apps began exiting, SQL began throwing errors, RDP wouldn't start, etc. Google didn't reveal much, except for some references to Tivoli (no Tivoli on this machine), so I wondered if anyone on the list knew. I've been moving them manually to another partition, but that got old before I even started. tia, rp On Apr 17, 5:21 pm, Axton [EMAIL PROTECTED] wrote: What are some of the file names and where are they located? Axton On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: Anyone know what an .obf file is? My dev server is filling up with them. tia, rp Windows 2000 AS Ora 9i ARS 7.0.1p1 ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ 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
Re: .obf files filling up dev server
I'm at a loss, too. I checked the email service, but it's set to manual, and hasn't been started since the upgrade weeks ago. I checked the Windows Event Viewer to see if I could match the create date of one of these .obf with the timestamp of an event, but nothing is close. I guess we'll have to wait to see if anyone else has an idea. Thanks, rp On Apr 17, 9:13 pm, Axton [EMAIL PROTECTED] wrote: I know there is an issue with the email engine generating lots of temp files. Our production server got into the 10's of thousands of files before we cleaned it up the first time. 7.0.1p2 for the email engine was supposed to address this. It could possibly be this, though on solaris, each file was only hundreds of bytes in size. A shot in the dark. What outgoing protocol do you use? The only meaningful references I found online in reference to obf mime were: http://math.nist.gov/oommf/doc/userguide11b2/userguide/Vector_Field_D... - application/x-oommf-vf - OOMMF Vector Field Not really sure how you could track what is writing there or what has file locks on any of the files on windows. Axton Grams On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: tmp1175120658812159279.obf I've had dozens of these creatures created recently in my temp directory ranging from 10's of MB to 100's of MB. Ran my disk space down to 2MB. I noticed it first when my Remedy apps began exiting, SQL began throwing errors, RDP wouldn't start, etc. Google didn't reveal much, except for some references to Tivoli (no Tivoli on this machine), so I wondered if anyone on the list knew. I've been moving them manually to another partition, but that got old before I even started. tia, rp On Apr 17, 5:21 pm, Axton [EMAIL PROTECTED] wrote: What are some of the file names and where are they located? Axton On 4/17/07, Rick Phillips [EMAIL PROTECTED] wrote: Anyone know what an .obf file is? My dev server is filling up with them. tia, rp Windows 2000 AS Ora 9i ARS 7.0.1p1 ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Remedy HPOpenview integration
Hi everyone, somebody knows how is the integration between Remedy and HPOPenview? How was your experience with the integration. It´s difficult to integrate? How long take the integration? Thanks in advance for your answers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Login Id field in Incident Management - Requestor ID ?
Colin, I have found thru bitter experience, that it is best not to touch the existing fields. They might be used in existing workflow in convoluted ways. I added my own temp fields and hid them. You can add them in any 1 view (or all of them). Remember, the Login ID field should be added and arranged in all applicable views though... Murtuza From: Chapman, Colin [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Login Id field in Incident Management - Requestor ID ? Date: Tue, 17 Apr 2007 17:54:49 -0400 Murtuza, thanks a bunch for your response, its much appreciated. I am half-way there, having trouble figuring out exactly how the z1D Charnn fields are set. Should I use one of the existing z1D Charnn fields for the Login ID or should I create a new one ? If I can use an existing one, how do I know which one I can use ? If I need to create a new one how do I do that ? These fields are not in any HPD:HelpDesk view, yet I see them in the avaialable fields. Roger, yes I asked Remedy and they could not find the Requestor ID field, and said to create a new field on the HelpDesk form. I did a google on it and it was said to be on the SRM:Request form but I can't find it there either thanks, Colin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of msb * Sent: Tuesday, April 17, 2007 1:22 AM To: arslist@ARSLIST.ORG Subject: Re: FW: Login Id field in Incident Management - Requestor ID ? Colin, Just did this myself. I needed login ID as well as Full name. Just added 2 new fields. The workflow to modify would be: HPD:INC:PCS_100_Search 110_srch=-E 120_search=-G HPD:INC:ContactFound_100_setup Plus add some workflow if you want to press enter in the field and have it do the search too. Regards, Murtuza. From: Chapman, Colin [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: FW: Login Id field in Incident Management - Requestor ID ? Date: Mon, 16 Apr 2007 18:20:58 -0400 Roger - thanks for the response again - it is much appreciated - hopefully I'm not being too dense. I still cannot find Requesotr ID or field ID 100337 on the HPD:HelpDesk form Am I looking in the wrong place or do we have different versions ? Shall I just go ahead and add a field ID 100337 to the HPD:HelpDesk form ? and then modify the workflow, I found Active Link HPD:INC:PCS_100_Search I have put a ticket in at BMC support but they are not much help - first they said use Assignee Login ID field, then they said use the Person ID field to go get the Login ID from the people form - neither is what I need. thanks, Colin Colin Chapman Dept. of Application Services, Information Technology Systems Division, University of North Carolina at Wilmington 601 South College Rd. Wilmington, NC 28403-5908 Phone: 910-962-7356 Fax: 910-962-4067 Email: [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, April 16, 2007 5:27 PM To: arslist@ARSLIST.ORG Subject: Re: Login Id field in Incident Management - Requestor ID ? ** Requestor ID is number 100337 this was created by BMC Development and has to be there. I then added it to the set fields action of Active Link HPD:INC:PCS_100_Search. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 16 Apr 2007 5:08 PM Subject: FW: Login Id field in Incident Management - Requestor ID ? ** Roger, thanks - that's a great tip to look at the fields-in-vew to see all the fields on a form, however I do not see the Requestor ID field (on the HPD:HelpDesk form) I do see Person ID, which I see is set the Customer's People form Person ID, but I don't see the Customer Login ID anywhere - there is a Login_ID field but its not populated (looking at a ticket using the Report option to see all these fields) any more ideas ? thanks again Colin Colin Chapman Dept. of Application Services, Information Technology Systems Division, University of North Carolina at Wilmington 601 South College Rd. Wilmington, NC 28403-5908 Phone: 910-962-7356 Fax: 910-962-4067 Email: [EMAIL PROTECTED] javascript:parent.ComposeTo(chapmanc%40uncw.edu, ); From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG javascript:parent.ComposeTo(arslist%40ARSLIST.ORG, ); ] On Behalf Of Roger Justice Sent: Monday, April 16, 2007 2:53 PM To: arslist@ARSLIST.ORG javascript:parent.ComposeTo(arslist%40ARSLIST.ORG, ); Subject: Re: Login Id field in Incident Management ** The field you are looking for is still there it is now called Requestor ID and the workflow already there populates it. In the Admin tool select from the pull downs Form then current view then Fields in view. On the left side of
Re: Remedy HPOpenview integration
Ruben, I think BMC has a product called 'Remedy Link for HP openview'. There are 2 components, one for NNM and another for Operations. Regards, Murtuza. From: Ruben Arellano [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Remedy HPOpenview integration Date: Tue, 17 Apr 2007 23:54:16 -0400 Hi everyone, somebody knows how is the integration between Remedy and HPOPenview? How was your experience with the integration. It´s difficult to integrate? How long take the integration? Thanks in advance for your answers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
