Re: Need to export 12,000,000 or so records...
Hi, RRR|Chive can certainly copy or move the records from one server to another, or to another form on the same machine. I have note yet implemented the ARX-format though, if that is a requirement... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Is there an requirement to save the data as arx? Can RRR|Chive do the task, and it may import them to staging forms and then into ITSM? -- Jarl 2009/11/12 William Rentfrow wrentf...@stratacominc.com: ** I have roughly 12,000,000 records I need to export to ARX format from CSS 5.x to do a data migration to IM 7.03. The breakdown is roughly something like this: 3,000,000 archived SPRT:Issue records 1,000,000 Person records 6,000,000 Interaction records 2,000,000 misc related records (active SPRT:Issue records, etc). Since I'd really prefer to NOT do this through the WUT in 100,000 segments I'm throwing this out there for ideas. Changing the format this late in the game is a show-stopper. And we can't use Migrator either. I have found one utility that is called fast export but there is no documentation for it and I've found no way to get it to work. So .ideas? Thanks in advance . William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
Atul,
You did not mention your ARS version.
However, I would look at the preference server. It stores Searches
for the user. You should be able to figure out how to submit a record
to the AR System User Central File form ('FileType' = Search) so
that the user would see the saved Searches in their client(s).
You will need to attach a file, in a specific (undocumented?) format.
However that can be done. At first glance it looks like a single file
for all forms for all searches. So you likely will need to write a
program that can parser and insert in to an existing file. However
adding to the file looks easy enough to me. [ Basically: Parse to find
the Schema blocks, find the Schema block with the 'Schema Name' that
you want to add to, get the current number of 'Num Searches' and
increment it by one(or N), add the new Search(es) block at the end
of the Schema block.]
Oh... I would defiantly go through the API (Or use the ARS Server,
via Filter commands, to save the file off to the server, call your
script to edit the file, and re-attache the file with later filter
actions.) to make changes to the attachments. I have never heard of
anyone successfully changing an attachment content directly in the ARS
DB. (Maybe it can be done, but ... why would you want to work that
hard?)
A sample (from my 6.3 server)
NOTE: The format may change at any time. (As far as I know this is an
internal format and is not defined as an interface for customers to
be writing directly too.)
NOTE2: There are Ctrl+A characters in the QBE Data (That is Query
By Example(QBE), Later changed to Search By Example(SBE) for you
new ARS kiddies in the group. :) ) So be careful with how those are
used. They look important. :)
Num Schemas=328
Schema {
Schema Name =User
Server Name =ar.server.some.com
Num Searches =3
Search {
QBE Data=101=bob
QBE String=Login Name=bob
String=
}
Search {
QBE Data=101=bob2
QBE String=Login Name=bob2
String=
}
Search {
QBE Data=
QBE String=
String='Login Name' = bob3
}
}
I think the Mid-Tier started supporting saved searches (from the
preference server) in v7.1. However, it may have been v7.5.
HTH.
--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote:
Hi All,
Our remedy application is used by different clients and we have a requirement
to create a tool that would create the defined searches without them actually
doing it in the form through the admin tool.
I am trying to look for the best approach to create a small app to help the
client admin create these searches and also if they import new remedy def
files from us they could use this tool to recreate the searches (make sense)
Is there remedy api call that could set this - I saw the information is saved
as a display property?
Can AR System Search Preference form be used in any way?
Directly updating the DB?
Need some guidance - not sure if I am totally off base...
Thanks
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
Sorry forgot to mention the version
v7.1 with oracle 10i
-Original Message-
From: Carey Matthew Black [black@gmail.com]
Date: 11/17/2009 07:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Defined Search
Atul,
You did not mention your ARS version.
However, I would look at the preference server. It stores Searches
for the user. You should be able to figure out how to submit a record
to the AR System User Central File form ('FileType' = Search) so
that the user would see the saved Searches in their client(s).
You will need to attach a file, in a specific (undocumented?) format.
However that can be done. At first glance it looks like a single file
for all forms for all searches. So you likely will need to write a
program that can parser and insert in to an existing file. However
adding to the file looks easy enough to me. [ Basically: Parse to find
the Schema blocks, find the Schema block with the 'Schema Name' that
you want to add to, get the current number of 'Num Searches' and
increment it by one(or N), add the new Search(es) block at the end
of the Schema block.]
Oh... I would defiantly go through the API (Or use the ARS Server,
via Filter commands, to save the file off to the server, call your
script to edit the file, and re-attache the file with later filter
actions.) to make changes to the attachments. I have never heard of
anyone successfully changing an attachment content directly in the ARS
DB. (Maybe it can be done, but ... why would you want to work that
hard?)
A sample (from my 6.3 server)
NOTE: The format may change at any time. (As far as I know this is an
internal format and is not defined as an interface for customers to
be writing directly too.)
NOTE2: There are Ctrl+A characters in the QBE Data (That is Query
By Example(QBE), Later changed to Search By Example(SBE) for you
new ARS kiddies in the group. :) ) So be careful with how those are
used. They look important. :)
Num Schemas=328
Schema {
Schema Name =User
Server Name =ar.server.some.com
Num Searches =3
Search {
QBE Data= 101=bob
QBE String=Login Name=bob
String=
}
Search {
QBE Data= 101=bob2
QBE String=Login Name=bob2
String=
}
Search {
QBE Data=
QBE String=
String='Login Name' = bob3
}
}
I think the Mid-Tier started supporting saved searches (from the
preference server) in v7.1. However, it may have been v7.5.
HTH.
--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote:
Hi All,
Our remedy application is used by different clients and we have a requirement
to create a tool that would create the defined searches without them actually
doing it in the form through the admin tool.
I am trying to look for the best approach to create a small app to help the
client admin create these searches and also if they import new remedy def
files from us they could use this tool to recreate the searches (make sense)
Is there remedy api call that could set this - I saw the information is saved
as a display property?
Can AR System Search Preference form be used in any way?
Directly updating the DB?
Need some guidance - not sure if I am totally off base...
Thanks
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Mid-Tier error with SSO
Problem is we do not have SSO turned on and never have but some users are getting the error I attached on the original email which says: Unable to reach Mid-Tier. If you are on SSO, please re-login to SSO Service. And not every user is having the problem just certain facilities. Could a facility make you log on using SSO and throw Remedy mid-tier into a funk Thanks again, Joelie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of patrick zandi Sent: Friday, November 13, 2009 4:23 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier error with SSO ** It might just be a filter left over.. from some history. On Fri, Nov 13, 2009 at 4:21 PM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: SSO is not a standard oob install.. it is either customized, or it is a seperate product. BMC has one as well, that some people use. You are going to have to do some Exploritory Surgery in order to fiqure out what is the make and model or type you currently have.. Hope that helps some.. Do you know if it is a partner, BMC or HomeGrown deal ? On Fri, Nov 13, 2009 at 10:32 AM, Agency Enterprise Help Desk ra-enterprisehelpd...@state.pa.usmailto:ra-enterprisehelpd...@state.pa.us wrote: ** Hello, Environment: Mid-Tier: Version 7.1.00 Patch 003 Server: Version 7.1.0 patch 003 Windows 2003 OS, SQL 2005 database Some users are experiencing the attached error when they click on a drop down menu from the web interface. Has anyone seen this message and know what setting within the browser to change so they do not get this error? We do not have SSO setup on our environment and it is only happening for certain users, not everyone. Thanks for any suggestions!!! Joelie J Dudley | Application Developer 3 PA Office of Administration Bureau of IT Services Solutions 555 Walnut Street, 7th Floor | Harrisburg, PA 17101 Phone: 717.772.8143 | Fax: 717.772.8121 E-mail: jodud...@state.pa.usmailto:jodud...@state.pa.us www.oa.state.pa.ushttp://www.oa.state.pa.us/ _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Case Upper or Lower
If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Change Management 7.5
The simple solution is to cancel that change, and use the Copy Change function to create a new one. All the approvals would therefore fire on the new change. Besides this solution being simple, a think it is the cleanest and the one requiring no customization, provided the end user is the one canceling the change and copying/creating the new one. Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Tricia Sent: Tue 11/10/09 9:17 AM To: arslist@ARSLIST.ORG Subject: Change Management 7.5 Good Morning, I hope you can help with this one. I was given a new requirement: If the change assignee or implementer attach a new document to the existing ticket (in any approval stage) they would like the approval workflows to restart. Any idea how to do this? Thanks, Tricia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Case Upper or Lower
We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an l (lower case L) can be interpreted as an uppercase I (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Case Upper or Lower
That is what we did, everything in the DB is upper case. But from the user stance it is seamless. Most of the data that the user interacts with we turned to all caps when it was being passed to the DB. Also when the employee was searching, we turned that to all caps so it would find a match in the DB. It was some extra workflow but it makes it a lot less confusing on the customer. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an l (lower case L) can be interpreted as an uppercase I (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Case Upper or Lower
Yeah, it's a simple UPPER function on return type of thing. We did that also so the user can type whatever they want in the lookup field. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Tuesday, November 17, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** That is what we did, everything in the DB is upper case. But from the user stance it is seamless. Most of the data that the user interacts with we turned to all caps when it was being passed to the DB. Also when the employee was searching, we turned that to all caps so it would find a match in the DB. It was some extra workflow but it makes it a lot less confusing on the customer. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an l (lower case L) can be interpreted as an uppercase I (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout.
Re: Case Upper or Lower
You can also UPPER (or LOWER for that matter) before the search/query is executed with an active link firing on Search Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Chowdhury, Tauf Sent: Tue 11/17/09 10:19 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower Yeah, it's a simple UPPER function on return type of thing. We did that also so the user can type whatever they want in the lookup field. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Tuesday, November 17, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** That is what we did, everything in the DB is upper case. But from the user stance it is seamless. Most of the data that the user interacts with we turned to all caps when it was being passed to the DB. Also when the employee was searching, we turned that to all caps so it would find a match in the DB. It was some extra workflow but it makes it a lot less confusing on the customer. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an l (lower case L) can be interpreted as an uppercase I (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or
Re: Case Upper or Lower
Yeah, that was the reason we did it as well. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:19 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** Yeah, it's a simple UPPER function on return type of thing. We did that also so the user can type whatever they want in the lookup field. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Tuesday, November 17, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** That is what we did, everything in the DB is upper case. But from the user stance it is seamless. Most of the data that the user interacts with we turned to all caps when it was being passed to the DB. Also when the employee was searching, we turned that to all caps so it would find a match in the DB. It was some extra workflow but it makes it a lot less confusing on the customer. Kevin Begosh, RSP Remedy Development ACE-IT ISGS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an l (lower case L) can be interpreted as an uppercase I (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation
Re: Need to get the last access
Turn on User Logging. This gives you login and logout times for the individuals. With 7.5 it can be sent to a log file or to a form. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Friday, November 13, 2009 9:03 AM To: arslist@ARSLIST.ORG Subject: Re: Need to get the last access ** We have a piece of workflow that fires when someone opens the homepage and logs that to another form. It's a far from perfect solution, but it's close enough for what we need. Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hellyson Sent: Friday, November 13, 2009 8:15 AM To: arslist@ARSLIST.ORG Subject: Need to get the last access ** When one user access the ars, i need to get the access and put in other form, on the web and the client, who i can to do it? Hellyson helly...@gmail.commailto:helly...@gmail.com helly...@hotmail.commailto:helly...@hotmail.com (msn) Quando se sabe ouvir não precisam muitas palavras Edgard Scandurra _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Changing language in some SRM fields
Hi all, I want to change some fields (buttons, character fields etc) in SRM, specifically in the form SRS: Servicerequestconsole, those under the requests that were made for me, such as the button Show related services, etc.. I can chage many fields from Remedy administrator (or developer studio) or from the form SYS: MessageBox, but these I do not know how. Could anybody help me please?. Thank you very much! Alberto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
The Mid-Tier 7.5 supports saved searches, recent searches, etc, just like the
user tool.
Guillaume
-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Carey Matthew
Black
Sent: Tue 11/17/09 7:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Defined Search
Atul,
You did not mention your ARS version.
However, I would look at the preference server. It stores Searches
for the user. You should be able to figure out how to submit a record
to the AR System User Central File form ('FileType' = Search) so
that the user would see the saved Searches in their client(s).
You will need to attach a file, in a specific (undocumented?) format.
However that can be done. At first glance it looks like a single file
for all forms for all searches. So you likely will need to write a
program that can parser and insert in to an existing file. However
adding to the file looks easy enough to me. [ Basically: Parse to find
the Schema blocks, find the Schema block with the 'Schema Name' that
you want to add to, get the current number of 'Num Searches' and
increment it by one(or N), add the new Search(es) block at the end
of the Schema block.]
Oh... I would defiantly go through the API (Or use the ARS Server,
via Filter commands, to save the file off to the server, call your
script to edit the file, and re-attache the file with later filter
actions.) to make changes to the attachments. I have never heard of
anyone successfully changing an attachment content directly in the ARS
DB. (Maybe it can be done, but ... why would you want to work that
hard?)
A sample (from my 6.3 server)
NOTE: The format may change at any time. (As far as I know this is an
internal format and is not defined as an interface for customers to
be writing directly too.)
NOTE2: There are Ctrl+A characters in the QBE Data (That is Query
By Example(QBE), Later changed to Search By Example(SBE) for you
new ARS kiddies in the group. :) ) So be careful with how those are
used. They look important. :)
Num Schemas=328
Schema {
Schema Name =User
Server Name =ar.server.some.com
Num Searches =3
Search {
QBE Data=101=bob
QBE String=Login Name=bob
String=
}
Search {
QBE Data=101=bob2
QBE String=Login Name=bob2
String=
}
Search {
QBE Data=
QBE String=
String='Login Name' = bob3
}
}
I think the Mid-Tier started supporting saved searches (from the
preference server) in v7.1. However, it may have been v7.5.
HTH.
--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote:
Hi All,
Our remedy application is used by different clients and we have a requirement
to create a tool that would create the defined searches without them actually
doing it in the form through the admin tool.
I am trying to look for the best approach to create a small app to help the
client admin create these searches and also if they import new remedy def
files from us they could use this tool to recreate the searches (make sense)
Is there remedy api call that could set this - I saw the information is saved
as a display property?
Can AR System Search Preference form be used in any way?
Directly updating the DB?
Need some guidance - not sure if I am totally off base...
Thanks
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Remedy for facilities management
Hi listers, Just wanted to reach out and get a quick poll from the list as to whether you have used Remedy to cater to your organizations Facilities Management needs. Here are the areas of particular interest: Preventative and Reactive Maintenance on Facilities assets such as HVAC, UPS, going down to fire extinguishers, building systems such as Heat, AC, Doors, Roofs... (ideally with all of these things integrated with ITSM 7.x and the CMDB/Asset Management) Self Service for end users requesting facilities requests via SRM Mobile Access via Aeroprise for facilities technicians who always work away from their desks, needing to close down a ticket. If you can confirm that you do use remedy for some or all of these purpose, it would be much appreciated; the driver is that we need to give our Facilities group some assurance that if they were to go down this path, they would not be alone, and that this has successfully been done by other organizations. We are particularly interested in knowing of organizations with a large multi-building campus as well as sites in various countries that use the system to manage Facilities work. If you have any type of integration to a dedicated Facilities Management system such as ARchibus, details on that would be very useful also. Thanks Randeep _ Ready. Set. Get a great deal on Windows 7. See fantastic deals on Windows 7 now http://go.microsoft.com/?linkid=9691818 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AREA LDAP plug-in
We have the same setup and using a single hostname eventually came back to bite us when someone decommissioned the server without telling us. I don't think there is a way to run multiple plugins, but what we did was use a load-balanced virtual IP in place of a host name. This way the DCs can change at will as long the new ones are added to the load balancer. It also eliminated us from having to maintain a list of active DCs. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Philip, Saji L Sent: Thursday, November 05, 2009 8:52 AM To: arslist@ARSLIST.ORG Subject: AREA LDAP plug-in ** This is probably an old question. But I am running ARS 6.3 with Help Desk 6.0. We are in the process of authenticating logins using the AREA LDAP plug-in. We have multiple Domain Controllers in our AD environment, and I would like to know if I can create more then one plug-in with different ' Host Names '? And if I can create multiple Group bases. Thanks _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy for facilities management
Have you pinged your BMC rep to see about setting up a reference call with a company who is providing this service? It might be worth a shot, the reference program is pretty good and you can ask the other company's developers what pitfalls they hit. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Randeep Atwal Sent: Tuesday, November 17, 2009 10:07 AM To: arslist@ARSLIST.ORG Subject: Remedy for facilities management ** Hi listers, Just wanted to reach out and get a quick poll from the list as to whether you have used Remedy to cater to your organizations Facilities Management needs. Here are the areas of particular interest: Preventative and Reactive Maintenance on Facilities assets such as HVAC, UPS, going down to fire extinguishers, building systems such as Heat, AC, Doors, Roofs... (ideally with all of these things integrated with ITSM 7.x and the CMDB/Asset Management) Self Service for end users requesting facilities requests via SRM Mobile Access via Aeroprise for facilities technicians who always work away from their desks, needing to close down a ticket. If you can confirm that you do use remedy for some or all of these purpose, it would be much appreciated; the driver is that we need to give our Facilities group some assurance that if they were to go down this path, they would not be alone, and that this has successfully been done by other organizations. We are particularly interested in knowing of organizations with a large multi-building campus as well as sites in various countries that use the system to manage Facilities work. If you have any type of integration to a dedicated Facilities Management system such as ARchibus, details on that would be very useful also. Thanks Randeep Get a great deal on Windows 7 and see how it works the way you want. See the Windows 7 offers now. http://go.microsoft.com/?linkid=9691813 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09:Twitters
Uh oh...we must have some *really* good ones! ;-) From: Tami Palacky tpala...@gmail.com To: arslist@ARSLIST.ORG Sent: Mon, November 16, 2009 4:19:40 PM Subject: Re: WWRUG09:Twitters My pictures will be sent to the board for review and posting :) On Nov 16, 3:42 pm, Susan Palmer suzanpal...@gmail.com wrote: LJ ... I was prepared to pay for this myself, but luckily didn't have to. This was #13 for me and going 'without' last year had more impact on my psyche than I realized until I got there and started absorbing everyone's energy. See Doug Blair for pictures, he was always clicking ! There were others too. I think at least some of them could escape from Vegas . :) Susan On Mon, Nov 16, 2009 at 2:19 PM, LJ Longwing lj.longw...@gmail.com wrote: ** Susan, I've been a developer since 98 and have never gone to oneI was hoping to this year but budget didn't workout :( -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Susan Palmer *Sent:* Monday, November 16, 2009 1:12 PM *To:* arsl...@arslist.org *Subject:* Re: WWRUG09:Twitters ** In answer to your question LJ, not sure how long you've been attending. But this conference was very much like those of the 90's. Everyone there was a Remedy person. Everyone had the same interests and more than willingly to share their experiences. I hope we do keep this format. I really like the tutorials at the beginning of the day. Way back I would take the tutorials before the actual conference started and sometimes by Thursday your mind was in a major meltdown. I thought the pace was just right this year. I also thought there was more time to chat among ourselves which is of great value too. The variety of sessions was good and the ones I attended for the most part were technically orientated. I always came home with ideas, and this year was no different. And it's nice to get that shot of excitement. To want to try new things that you can share next year. I have to say, I was pleasantly pleased with the organization of the event. From my view everything went very smooth, I'm sure at times the organizers were scrambling, but it didn't show. I'm ready to sign up for next year's WWRUG !! See you there, Susan On Mon, Nov 16, 2009 at 1:05 PM, LJ Longwing lj.longw...@gmail.comwrote: The real question I have is this. Was the conference a success because it was planned by users for users?I don't recall the exact responses to the latest BMC lead user groupbut was this better?and what will happen next year? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR USA IMCOM Sent: Monday, November 16, 2009 12:00 PM To: arsl...@arslist.org Subject: Re: WWRUG09:Twitters What a great conference. I tried to keep everyone up to date with my twitter feed on the conference, weazel8. Hope all of you enjoyed it that couldn't make the conferenceCan't wait till WWRUG10 Timothy W. Hulmes -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Daniel Bloom Sent: Wednesday, November 11, 2009 7:07 AM To: arsl...@arslist.org Subject: WWRUG09:Twitters ** Doug Blair is the official blogger for WWRUG09, poster of the ARSlist Awards, and now that I got 5 minutes to read the ARSlist for the first time since last Friday, I think I'll make him the official twitterer. WWRUG is me as well, for WWRUG. WWRUG09 is the one for the conference, but you have to picture that the bird is an Ostrich that takes it's head out of the ground once a week for a breath of air. And now back to preparing for the ARSlist Awards this morning. Daniel _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ____ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum Sponsor:rmisoluti...@verizon.net sponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are- Hide quoted text - - Show quoted text -
Firewall TCP Timeouts
Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using netstat -anto). So, when users get back on the system, MidTier apparently is trying to utilize one of these defunct tcp connections so you end up with problems like ARERR 91 rpc timeouts because these tcp connections are broken pipes. Is there a MidTier/Tomcat or other setting that you have found addresses this problem? Thanks. Ken Background: Version 7.5 patch 3 MidTier - Linux, Tomcat JSP ARS - Linux, Oracle 10g ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Remedy Experts
You propose Rate, straight contract. Onsite Work. Web Job Description One of our clients has 2 positions for Remedy Experts at their Brooklyn, NY office. This person will bring Remedy expertise to assist the Client in achieving short term and long term expectations and goals. Candidates who are qualified and interested are encouraged to apply. Required Skills The candidate must have Remedy 7.0 support and development experience. Any additional relevant experience or education would assist the candidate in the selection process. Joshua Kitchen Senior Recruiter Kforce Federal 937.449.1749 office jkitc...@kforce.com mailto:jkitc...@kforce.com http://www.govtrecruiter.com http://www.govtrecruiter.com Great People = Great Results(r) Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gif
WWRUG09:Celebration Band CD Requests
For the many folks that came up to me and asked if they could get CD's of the band, please send me an email off list and I will get the info to you regarding the requests for CD's of the band. Perhaps I can get them to give us a discount, I will ask at rehearsal tonight. P.S. - The AV company that rented us the light sound equipment recorded the entire thing and they called to let me know that the have been playing it in their office ever since. Guess they liked it too J Thanks, Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
WWRUG09: Photos?
I did get a copy of Doug Blair's SD card before I left, but if you have any additional photos (especially of the Celebration), please forward them to me (off list). We will work to get them on the site in the media section of the WWRUG.com pages. Thanks, Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09:Celebration Band CD Requests
** Phil, I heard the name a couple of times but I'm getting old and my memory and hearing fail me at times. What was the name of the wonderful band from Austin Texas? Dave - dave.shell...@tycoelectronics.com (Wireless) From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Tue Nov 17 13:19:07 2009 Subject: WWRUG09:Celebration Band CD Requests For the many folks that came up to me and asked if they could get CD’s of the band, please send me an email off list and I will get the info to you regarding the requests for CD’s of the band. Perhaps I can get them to give us a discount, I will ask at rehearsal tonight. P.S. – The AV company that rented us the light sound equipment recorded the entire thing and they called to let me know that the have been playing it in their office ever since. Guess they liked it too ☺ Thanks, Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
ITSM 7 Developers required
Dear All Fusion Resource Management are working with a number of clients across The UK, Nordics, Mainland Europe and EMEA that are looking to resource ITSM 7 developers for a variety of really interesting projects, there are a number of assignments that require an immediate start but we also have a number of projects that will be looking to start in the next few weeks or months. please contact greg.p...@fusion.co.uk ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09: Photos?
Phil, what is your offline email address? i only see a partial piece from here On Nov 17, 1:19 pm, Phil Bautista bauti...@bullcreek.com wrote: I did get a copy of Doug Blair's SD card before I left, but if you have any additional photos (especially of the Celebration), please forward them to me (off list). We will work to get them on the site in the media section of the WWRUG.com pages. Thanks, Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: User unable to save preferences in a Table Field (Mid Tier)
Richard, Make sure that the 'Layout Editable by User' for that view has been set to True. Joe From: Richard Nylander richard.newlan...@gmail.com To: arslist@ARSLIST.ORG Sent: Tue, November 17, 2009 2:35:46 AM Subject: User unable to save preferences in a Table Field (Mid Tier) ** Hello, The problem I have is that user is unable to save preferences in a Table Filed in their browser. The form has three views, all used with Mid Tier, and in two of the views the user is able to save preferences such as column width and column order. But in the third view even if the user uses save preferences, each time they log in the table is set to default. I can even see the changes the user does in the form AR System User Preferences, but when they open the form the preferences are not read. But their changes are saved and kept in the AR System User Preferences form. Anyone have idea why this is happening? Thanks Richard Nylander Sweden ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Firewall TCP Timeouts
You need to configure your firewall properly. With a firewall, you can define what types of packets can create a state entry on the firewall. Typical is syn, syn ack. Even if there is no state entry, a new packet should create a new state (not be dropped). If a new packet does not create a new state, change the firewall rules so that it does. A network dump will tell you what type of packet is going out; the firewall logs should tell you what type of packet was rejected. I could see that this would be a problem if the midtier servers were behind a NAT. Is this the case? Axton Grams On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: ** Hello, We have a firewall between our MidTier server and ARS system. The firewall is configured to drop tcp connections after being idle for 60 minutes (typical/default firewall setting). Several MidTier user sessions will make use of a shared tcp connection so you might have 100 sessions but significantly fewer tcp connections. During idle times (like at night), the firewall will discard these idle tcp connections but the MidTier server will still retain these tcp references (this can be seen by using “netstat –anto”). So, when users get back on the system, MidTier apparently is trying to utilize one of these defunct tcp connections so you end up with problems like ARERR 91 rpc timeouts because these tcp connections are broken pipes. Is there a MidTier/Tomcat or other setting that you have found addresses this problem? Thanks. Ken Background: Version 7.5 patch 3 MidTier – Linux, Tomcat JSP ARS – Linux, Oracle 10g _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
Atul,
How about storing the search in a form, and then setting the search criteria
you want to use to the field 1005 (Query Bar) on the form that you want to
search from?
Try that? Should technically work on any version irrespective of the
configuration (underlying database etc.)
Joe
From: Carey Matthew Black black@gmail.com
To: arslist@ARSLIST.ORG
Sent: Tue, November 17, 2009 7:54:29 AM
Subject: Re: Defined Search
Atul,
You did not mention your ARS version.
However, I would look at the preference server. It stores Searches for the
user. You should be able to figure out how to submit a record to the AR System
User Central File form ('FileType' = Search) so that the user would see the
saved Searches in their client(s).
You will need to attach a file, in a specific (undocumented?) format. However
that can be done. At first glance it looks like a single file for all forms for
all searches. So you likely will need to write a program that can parser and
insert in to an existing file. However adding to the file looks easy enough to
me. [ Basically: Parse to find the Schema blocks, find the Schema block with
the 'Schema Name' that you want to add to, get the current number of 'Num
Searches' and increment it by one(or N), add the new Search(es) block at the
end of the Schema block.]
Oh... I would defiantly go through the API (Or use the ARS Server, via Filter
commands, to save the file off to the server, call your script to edit the
file, and re-attache the file with later filter actions.) to make changes to
the attachments. I have never heard of anyone successfully changing an
attachment content directly in the ARS DB. (Maybe it can be done, but ... why
would you want to work that hard?)
A sample (from my 6.3 server)
NOTE: The format may change at any time. (As far as I know this is an internal
format and is not defined as an interface for customers to be writing directly
too.)
NOTE2: There are Ctrl+A characters in the QBE Data (That is Query By
Example(QBE), Later changed to Search By Example(SBE) for you new ARS
kiddies in the group. :) ) So be careful with how those are used. They look
important. :)
Num Schemas=328
Schema {
Schema Name =User
Server Name =ar.server.some.com
Num Searches =3
Search {
QBE Data=101=bob
QBE String=Login Name=bob
String=
}
Search {
QBE Data=101=bob2
QBE String=Login Name=bob2
String=
}
Search {
QBE Data=
QBE String=
String='Login Name' = bob3
}
}
I think the Mid-Tier started supporting saved searches (from the
preference server) in v7.1. However, it may have been v7.5.
HTH.
--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote:
Hi All,
Our remedy application is used by different clients and we have a requirement
to create a tool that would create the defined searches without them actually
doing it in the form through the admin tool.
I am trying to look for the best approach to create a small app to help the
client admin create these searches and also if they import new remedy def
files from us they could use this tool to recreate the searches (make sense)
Is there remedy api call that could set this - I saw the information is saved
as a display property?
Can AR System Search Preference form be used in any way?
Directly updating the DB?
Need some guidance - not sure if I am totally off base...
Thanks
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09:Celebration Band CD Requests
The band is called “The Brew” and info can be found on the media page of WWRUG (http://www.wwrug.org/wwrug/media.html) or www.brewmusic.com and select the CD Baby link under “merchandise”. Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Tuesday, November 17, 2009 12:35 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG09:Celebration Band CD Requests ** Phil, I heard the name a couple of times but I'm getting old and my memory and hearing fail me at times. What was the name of the wonderful band from Austin Texas? Dave - dave.shell...@tycoelectronics.com (Wireless) _ From: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: WWRUG09: Photos?
rem...@bullcreek.com (I figures most folks I interact with could spell it - LOL) Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tami Palacky Sent: Tuesday, November 17, 2009 2:10 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG09: Photos? Phil, what is your offline email address? i only see a partial piece from here On Nov 17, 1:19 pm, Phil Bautista bauti...@bullcreek.com wrote: I did get a copy of Doug Blair's SD card before I left, but if you have any additional photos (especially of the Celebration), please forward them to me (off list). We will work to get them on the site in the media section of the WWRUG.com pages. Thanks, Phil Bautista, Remedy Approved Consultant (RAC), Bull Creek Data Corporation Director of Sessions, WWRUG09 512-731-0304 www.bullcreek.com http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug/contact.html ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Server Information form time out
Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
Joe,
That is a possible solution.
Thanks
Atul
-Original Message-
From: Joe DeSouza [joe_rem...@yahoo.com]
Date: 11/17/2009 03:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Defined Search
**
Atul,
How about storing the search in a form, and then setting the search criteria
you want to use to the field 1005 (Query Bar) on the form that you want to
search from?
Try that? Should technically work on any version irrespective of the
configuration (underlying database etc.)
Joe
From: Carey Matthew Black black@gmail.com
To: arslist@ARSLIST.ORG
Sent: Tue, November 17, 2009 7:54:29 AM
Subject: Re: Defined Search
Atul,
You did not mention your ARS version.
However, I would look at the preference server. It stores Searches for the
user. You should be able to figure out how to submit a record to the AR System
User Central File form ('FileType' = Search) so that the user would see the
saved Searches in their client(s).
You will need to attach a file, in a specific (undocumented?) format. However
that can be done. At first glance it looks like a single file for all forms for
all searches. So you likely will need to write a program that can parser and
insert in to an existing file. However adding to the file looks easy enough to
me. [ Basically: Parse to find the Schema blocks, find the Schema block with
the 'Schema Name' that you want to add to, get the current number of 'Num
Searches' and increment it by one(or N), add the new Search(es) block at the
end of the Schema block.]
Oh... I would defiantly go through the API (Or use the ARS Server, via Filter
commands, to save the file off to the server, call your script to edit the
file, and re-attache the file with later filter actions.) to make changes to
the attachments. I have never heard of anyone successfully changing an
attachment content directly in the ARS DB. (Maybe it can be done, but ... why
would you want to work that hard?)
A sample (from my 6.3 server)
NOTE: The format may change at any time. (As far as I know this is an internal
format and is not defined as an interface for customers to be writing directly
too.)
NOTE2: There are Ctrl+A characters in the QBE Data (That is Query By
Example(QBE), Later changed to Search By Example(SBE) for you new ARS
kiddies in the group. :) ) So be careful with how those are used. They look
important. :)
Num Schemas=328
Schema {
Schema Name =User
Server Name =ar.server.some.com
Num Searches =3
Search {
QBE Data=101=bob
QBE String=Login Name=bob
String=
}
Search {
QBE Data=101=bob2
QBE String=Login Name=bob2
String=
}
Search {
QBE Data=
QBE String=
String='Login Name' = bob3
}
}
I think the Mid-Tier started supporting saved searches (from the
preference server) in v7.1. However, it may have been v7.5.
HTH.
--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote:
Hi All,
Our remedy application is used by different clients and we have a requirement
to create a tool that would create the defined searches without them actually
doing it in the form through the admin tool.
I am trying to look for the best approach to create a small app to help the
client admin create these searches and also if they import new remedy def
files from us they could use this tool to recreate the searches (make sense)
Is there remedy api call that could set this - I saw the information is
saved as a display property?
Can AR System Search Preference form be used in any way?
Directly updating the DB?
Need some guidance - not sure if I am totally off base...
Thanks
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Parse Group Members for Notification
Group, We have created some custom workflow and notifications outside of the Notification Engine that ITSM uses. We want to take advantage of the user notification preferences as part of this. I turned logging on for the ootb notification process. I see that for group notifications, a notify record is created for each user in the group. Then the user preferences are checked to see if the notification should be sent. For the life of me, I cannot figure out how to create a record for each of the group members on my notify form. I know the support group name and the group name for it from the group form. I looked over the log file for longer than I want to admit. I cannot seem to identify how bmc creates the individual notify records for the support group members. Any ideas? We have ARS 7.1 patch 7, ITSM 7.03 patch 9, Win 2003 Server, Oracle 10G Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: User unable to save preferences in a Table Field (Mid Tier)
Joe, Thanks for you response. Do you mean the check box in the appearance tab, User Can Change Layout. Cause that is already checked. I tried to uncheck and save and then check again, but it didn't help. /Richard 2009/11/17 Joe DeSouza joe_rem...@yahoo.com ** Richard, Make sure that the 'Layout Editable by User' for that view has been set to True. Joe -- *From:* Richard Nylander richard.newlan...@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Tue, November 17, 2009 2:35:46 AM *Subject:* User unable to save preferences in a Table Field (Mid Tier) ** Hello, The problem I have is that user is unable to save preferences in a Table Filed in their browser. The form has three views, all used with Mid Tier, and in two of the views the user is able to save preferences such as column width and column order. But in the third view even if the user uses save preferences, each time they log in the table is set to default. I can even see the changes the user does in the form AR System User Preferences, but when they open the form the preferences are not read. But their changes are saved and kept in the AR System User Preferences form. Anyone have idea why this is happening? Thanks Richard Nylander Sweden _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Defined Search
Or use the WindowOpen action. (Which is how you could use the data to do searches/reports.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Nov 17, 2009 at 4:33 PM, Atul Vohra a...@protechsoftwareinc.com wrote: Joe, That is a possible solution. Thanks Atul -Original Message- From: Joe DeSouza [joe_rem...@yahoo.com] Date: 11/17/2009 03:29 PM To: arslist@ARSLIST.ORG Subject: Re: Defined Search ** Atul, How about storing the search in a form, and then setting the search criteria you want to use to the field 1005 (Query Bar) on the form that you want to search from? Try that? Should technically work on any version irrespective of the configuration (underlying database etc.) Joe snip On Mon, Nov 16, 2009 at 9:38 PM, Atul Vohra a...@protechsoftwareinc.com wrote: Hi All, Our remedy application is used by different clients and we have a requirement to create a tool that would create the defined searches without them actually doing it in the form through the admin tool. I am trying to look for the best approach to create a small app to help the client admin create these searches and also if they import new remedy def files from us they could use this tool to recreate the searches (make sense) Is there remedy api call that could set this - I saw the information is saved as a display property? Can AR System Search Preference form be used in any way? Directly updating the DB? Need some guidance - not sure if I am totally off base... Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Parse Group Members for Notification
Do you mean that for a given group, you want to create a notification record for each individual in the group, meaning that the problem is how to get the list of members of the group and iterate over that list to create a new record for each one? If that's the case, the group memberships of people are stored in the CTM:Support Group Association form. In principle, you should be able to create a table that references this form, filtering on the support group name, that you can run a filter guide on to iterate over all the records in the table. You can then create an individual notification record for each row in the table. Does that address what you're trying to do? Otherwise, the OOTB workflow handles group notifications a little differently than individual notifications. Individual notifications (e.g., Customer, Assignee, etc.) are processed immediately - so you'll immediately see the notification record for that individual when you perform an action on a record that generates a notification. However, for group notifications, it does it in two steps. First it creates an initial entry for the group, and then an escalation (maybe SYS:NPC:IM1-TriggerGroupNTG) takes care of processing the group notifications to generate the individual notifications. That may be why you weren't seeing it in your log files - if you didn't wait long enough, the escalation may not have fired before you turned off logging. Sorry for not providing more detail - I'm trying to be quick writing this while hoping that the general information will help steer you in the right direction. If any of this doesn't make sense, let me know. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of jham36 Sent: Tuesday, November 17, 2009 2:53 PM To: arslist@ARSLIST.ORG Subject: Parse Group Members for Notification Group, We have created some custom workflow and notifications outside of the Notification Engine that ITSM uses. We want to take advantage of the user notification preferences as part of this. I turned logging on for the ootb notification process. I see that for group notifications, a notify record is created for each user in the group. Then the user preferences are checked to see if the notification should be sent. For the life of me, I cannot figure out how to create a record for each of the group members on my notify form. I know the support group name and the group name for it from the group form. I looked over the log file for longer than I want to admit. I cannot seem to identify how bmc creates the individual notify records for the support group members. Any ideas? We have ARS 7.1 patch 7, ITSM 7.03 patch 9, Win 2003 Server, Oracle 10G Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ARInside 3.0 RC2 available
Thank you to the people that reported problems with RC1. John was able to make some changes that allowed at least one of those people to run the latest rc. Please check out RC2 and report any issues encountered http://www.arinside.org/downloads ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Server Information form time out
If I understand correctly, the underlying error is this: ONC/RPC portmap failure. It sounds like it's trying to register itself with the portmapper but can't. Do you have the portmapper service running? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out ** Ah, I had looked in plugin log but not java plugin log. I found this in the arjavaplugin.log. My java is weak. Does this scream anything obvious to anyone? Not finding anything in kb... 2009-11-17 22:46:04,244 ERROR [main] com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup Error ONC/RPC portmap failure org.acplt.oncrpc.OncRpcException: ONC/RPC portmap failure at org.acplt.oncrpc.OncRpcPortmapClient.setPort(Unknown Source) at org.acplt.oncrpc.server.OncRpcTcpServerTransport.register(Unknown Sou rce) at com.bmc.arsys.pluginsvr.a.c.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.register(Unknown Source) at org.acplt.oncrpc.server.OncRpcServerStub.run(Unknown Source) at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source) AR Plugin Server Startup ErrorONC/RPC portmap failure Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Hi Lyle, Yes, one of my coworkers did try that a little while ago, to no avail... Thanks! Jason From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, November 17, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Server Information form time out Just for giggles, can you try killing the plugin process, letting armonitor restart it and try again? I've seen similar errors when the plugins aren't properly initialized (although I understand you don't see any errors in the logs). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barnhill, Jason (Jason) Sent: Tuesday, November 17, 2009 2:06 PM To: arslist@ARSLIST.ORG Subject: Server Information form time out ** Hi folks, When I open the 'AR System Administration: Server Information' form it times out... ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : psremap1 There are no plugin server errors on system startup or in the plugin logs. Anybody else seen this one? Thanks, Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Question about Work Info and View Access in ITSM 7.1
Dear Listers, We are trying to see if there is more to what is mentioned in the Incident Management guide for the View Access flag for Work Info records (excerpt below): From the View Access list, select Internal or Public. ! Internal—If you want users within your organization to see the entry. ! Public—If you want everyone with access to the application to see the entry, including requesters from the Requester console. We are using the application in a single tenancy mode and don't have any other companies or organizations being supported on this instance. I was wondering what the within your organization really means, since I see behavior not consistent with what is documented. Any thoughts/inputs? TIA -- Shyam ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
URGENT HELP REQUIRED --- PROD ISSUE
Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated... Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.commailto:nisha.ram...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: URGENT HELP REQUIRED --- PROD ISSUE
What did you do prior to receiving the error? On Wed, Nov 18, 2009 at 7:31 AM, Jaya Munjal jaya.mun...@rbs.com wrote: ** Hi List We are not able to update or modify any workflow object on the our Production Environment. As soon as we open any workflow object via the Admin tool (Filters, Escalation, forms) etc it starts throwing an error Cannot establish a network connection to the AR System server : lonss00014.fm.rbsgrp.net : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 90) In the ARERROR log we get the following error messages * Wed Nov 18 03:22:46 2009 390600 : Incorrect format in the definition file (bad action value -- \) (ARERR 402) Wed Nov 18 03:22:47 2009 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) Wed Nov 18 03:22:47 2009 390600 : Error in definition for a filter (ARERR 343) Wed Nov 18 03:22:47 2009 AR System Email Association Delete Attachments Wed Nov 18 03:22:55 2009 Dispatch : Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 * We are able to login to the server via the admin tool but the filter AR System Email Association Delete Attachments is not visible. On trying to import in place the we get the error. Cannot establish a network connection to the AR System server (lonss00014 : RPC: Miscellaneous tli error - An event requires attentionError 0) ARERR - 90 Platform - ARS 6.3 Patch 24 OS - Solaris DB - Sybase Any suggestion would be appreciated… Let me know if you require any other information. Thanks Jaya Munjal Technology Services India The Royal Bank of Scotland Group O +91 124 479 1714 M +91 971 130 9277 F +91 124 479 0023 jaya.mun...@rbs.com 7B Building, DLF Cyber City, DLF Phase III, Gurgaon - 122002, Haryana, India Please don't print this e-mail unless you really need to. *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our website at www.rbs.com *** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Oracle in-row LOB storage issue - IM 7.03
I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory. We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C105940 z1D Template Related CI C100151 Detailed Decription C100156 Resolution C103742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited) length. The questions I have are: 1.) If a LOB is 4K it is stored out of row regardless. Can anyone tell me how to determine the space used by any of those particular fields in Oracle? And how I can tell if these are in fact being stored out of row due to the unlimited option on the field? 2.) Aren't z1D fields supposed to be Display only according to Remedy's design and naming conventions? I'm pretty sure that is the case but both of the fields above with that prefix are stored as optional. Thanks in advance - William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle in-row LOB storage issue - IM 7.03
Hi, In most cases, as I understand, it is definitely better to not use the out-row-lob-setting. This will save a lot of space and time for the DB. Best Regards - Misi, RRR AB, http://rrr.se/sv/ I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory. We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C105940 z1D Template Related CI C100151 Detailed Decription C100156 Resolution C103742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited) length. The questions I have are: 1.) If a LOB is 4K it is stored out of row regardless. Can anyone tell me how to determine the space used by any of those particular fields in Oracle? And how I can tell if these are in fact being stored out of row due to the unlimited option on the field? 2.) Aren't z1D fields supposed to be Display only according to Remedy's design and naming conventions? I'm pretty sure that is the case but both of the fields above with that prefix are stored as optional. Thanks in advance - William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
