Re: Remedy login, port number issue/question
No, you need to forward udp/111 and tcp/111. That port is used for the rpc port bind. rpcbind is the mechanism that says rpc program 390620 is running on tcp or udp port X (i.e., the user tool connects to port 111 if you don't specify a port to request the port remedy runs on). This is how a user is able to authenticate without having to provide the port number. So, update the farm to also include those additional port numbers (tcp/111 and udp/111) and you will be able to connect to the servers without having to provide the port number. As long as both of the remedy servers are listening on the same port for remedy, there is no need for session persistence for the rpcbind. For the remedy servers, you are going to want to make sure session persistence (src ip) is enabled because if it is not, your floating license users will end up consuming floating license tokens on more than 1 remedy server. Axton Grams These represent my opinions and nothing more. On Wed, May 5, 2010 at 8:27 AM, Kevin Begosh kbeg...@gmail.com wrote: ** yes we have portmapper running as well as a port hardcoded on both servers. So could we essentially hard code the load balancer to bind to our specific port, lets say 10 every time is passes the traffic? Is that what needs to be done so the users do not have to put that port in? On Wed, May 5, 2010 at 9:16 AM, Axton axton.gr...@gmail.com wrote: ** You need to configure the load balancer to handle rpcbind traffic. This can be done by redirecting udp and tcp ports 111 to the Remedy servers in addition to the port Remedy listens on. This assumes you have the portmapper enabled for Remedy on each of the virtual machines. Axton Grams These represent my opinions and nothing more. On Wed, May 5, 2010 at 7:24 AM, Kevin Begosh kbeg...@gmail.com wrote: ** So I have an environment with 2 AR Servers that are *virtual* servers and are sitting behind a Load balancer. If I log into either one of those servers individually I do not have to put the port number, but when I log in using the alias for the load balancer it requires that I put the port number otherwise it says the server is unailable for login. Has anyone had this issue before? Not sure if it is a load balancer or remedy issue. Win2k3 server, sql2005 db, ARS 7.5 -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SSO implementation
Some things that drive how to approach the design: - What are you using as the infrastructure for SSO (MS Active Directory, Siteminder, Oracle, etc.) - What web server are you using - What platform are you on Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, May 5, 2010 at 5:12 AM, Remedy Maniac remedy.man...@googlemail.comwrote: dear list, is anyone willing to help on such implementation? I have the choice: - either the CAS authentication using the CAS client provided by Yale University - or the SSO class provided by BMC itself Both need better settings as they do not work. I have ARS 7.5 + Tomcat latest I have no money to buy anything (maybe a couple of hundred euros to discuss - but no garantee) I need help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
OT: ADV:WWRUG10 - First price level gone in a few weeks
Seems appropriate in some way... http://spectrum.ieee.org/aerospace/space-flight/us-air-force-launches-secret-flying-twinkie On Tue, May 4, 2010 at 12:17 PM, Daniel Bloom danielbl...@rogers.comwrote: ** Just a quick reminder that May 31st is the deadline for the current pricing. Last year we ran out of rooms for some nights. We have more this year but register and book your room early to avoid disappointment, and save money! We are lining up a great schedule covering everything you would want to know about BMC Remedy and related software. Our call for papers should be coming up shortly, and of course you can get all the news and register at www.wwrug10.com WWRUG10: Sharing Tools, Technology and Training cheers Daniel Daniel Bloom conference chairman _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Load Balancer Recommendations 7.5 AR Server Environment
When using appliances like F5's LTM, there is no need to purchase multiple load balancers unless you are looking for physical segregation for security reasons or fault tolerance for the load balancers. Axton Grams These statements represent my opinions and nothing more. On Tue, May 4, 2010 at 12:22 PM, David Abry davidla...@gmail.com wrote: ** Hi List, We are looking into purchasing a load Balancer for the Mid-Tier and a second load Balancer for the ARServers. We will be using ITSM 7.6 / 7.5 ARServer in a all Windows 2003 environment. We are using IIS / Apache Servlet Engine. We have a high number of users connecting via the Mid-Tier... I am looking for any recommendations on what customers are currently using for load balancers as well as success stories. I know BMC has recommendations in the Using a hardware load Balancer 7.1 white paper, but it would be good to know what has proven to be successful since BMC support only provides the white paper... I have seen on the list that some customers are using F5 BIG-IP. Thanks in advance. V/R, David Abry _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ar.cfg decrypt password
It is a decrypt-able format but the method used to encrypt the value is not published. If you want to store encrypted values in ar.conf that are specific to your plug-in, feel free to do so and use a method of encryption that is to your liking (blowfish works well for this). Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, May 3, 2010 at 9:12 AM, Konrad Banasiak gene...@remedy-sso.comwrote: ** Hi, It is possible to decrypt password ar.cfg? I want to create my custom plugin, where parameters will be stored in ar.cfg. Cheers Konrad _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OT: SSO Implementation
SSO with the mid-tier is a two part implementation. One part in the
mid-tier and the other part in an AREA plug-in.
Turn on the plug-in logs (if you have any type of AREA plug-in enabled) and
user logs (to see the authentication success/failure) and see what is
happening on the other end of the line.
Axton Grams
These are my opinions and do not represent anything but my opinion.
On Mon, May 3, 2010 at 3:09 PM, Jeff Lockemy (QMX Support Services)
jlock...@gmail.com wrote:
**
If you eventually decide to hire outside help… There is a company called
Optimal IdM that does work with implementing SSO:
http://www.optimalidm.com/services/default.aspx
One of our customers has used them for several implementations already, and
they are in the process of doing another one. Not sure what they would
charge you, but it might be worth looking into…
Cheers,
Jeff
* *
*Jeff Lockemy***
QMX Support Services Inc.
(858) 366-8979
*From:* Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] *On Behalf Of *Chintan Shah
*Sent:* Monday, May 03, 2010 2:06 PM
*To:* arslist@ARSLIST.ORG
*Subject:* SSO Implementation
**
Hi all,
I would like to know if anybody has implemented methodology specified in
whitepaper here for single sign on.
http://documents.bmc.com/supportu/documents/57/12/65712/65712.pdf
I have been trying to integrate it but for some reason it goes back to
Remedy's Midtier login page...not sure where I should go to debug..since
Remedy doesnt provide Servlet code that fall back's to login page. I have
also made appropriate config file change on midtier.
Has anybody successfully implemented it?
Please share your ideas.
here's sample code that I am using (packaged class in a jar file and then
put it in Midter/WEB-INF/lib)
public class MyAuthenticator implements Authenticator {
public void init(Map cfg) {
}
public void destroy() {
}
public UserCredentials getAuthenticatedCredentials(
HttpServletRequest request, HttpServletResponse response)
throws IOException{
String user = request.getHeader(userHeaderName);
String pw=null;
String authStr=null;
if ((user!=nulluser.length()0) ) {
return new
UserCredentials(user.toLowerCase(),pw,authStr);
}
else { //2. user not auth'd; return null.
//embed routing info in response object if necessary.
return new UserCredentials(myUserName,null,null);
}
}
}
Thanks
Chintan.
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: API programs: need lazy guy's version of create/update/query tickets on Windows
A series of .net utilities for just this purpose: http://arswiki.org/projects/dotnetutil Compiled versions are available for download on the downloads tab. Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Apr 28, 2010 at 1:24 PM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I need a way a third party Windows application can create/update/query tickets in Remedy. I know there are tons of ways, but if somebody has a sample code in any common windows language (.Net? VB? Java?), or better yet a generic program that can take form name and field/value pairs etc as parameters (there used to be esp_getentry, esp_setentry etc), let me know. I just don't want to spend a lot of time to start from scratch. I can't do Web Services (mismatch of Midtier and ARS versions). I am about to search around for a code base to start with, but if anybody has anything handy, send my way or let me know. I have perl code in Unix, but porting that over ti Windows is some work. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: References for www.misicompany.com
I was going to raise the question :) Axton On Thu, Apr 22, 2010 at 2:20 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Interesting, but I have nothing to do with them ;-) /Misi Anybody heard of them? Worked or contracted with them? I'm not sure I heard of them before and I got contacted by them with reference to some work in NYC and I was interested in references about them. Cheers Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Java Plug-in server and ARS 6.3
No specific plugins involved. I am just trying to get this working with the SAMPLE.FILTERAPI filter plug-in that ships with 7.5. Axton On Mon, Apr 12, 2010 at 6:51 PM, Joe D'Souza jdso...@shyle.net wrote: ** Axton, Won't you have problems with missing fields? I know I once used an older form (it was a known bug) when Remedy updated the plugin (of SRM or RKM - I do not remember which) but not the underlying forms, so there were missing fields in the older version forms that the plugin kept complaining about and as a result not displaying the information it should have.. I had to manually create these fields in the form to correct that problem. So depending on what plugin you are talking about, you might be able to get away with it so long as you manually fix the forms that these plugins display data on. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *Axton *Sent:* Monday, April 12, 2010 5:37 PM *To:* arslist@ARSLIST.ORG *Subject:* Question on Java Plug-in server and ARS 6.3 ** Has anyone out there connect a 6.3 Remedy server to a 7.5 Java Plugin server? Thanks, Axton _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Java Plug-in server and ARS 6.3
An update. I receive an ARERR 91, which means a protocol error. Axton On Tue, Apr 13, 2010 at 10:55 AM, Axton axton.gr...@gmail.com wrote: No specific plugins involved. I am just trying to get this working with the SAMPLE.FILTERAPI filter plug-in that ships with 7.5. Axton On Mon, Apr 12, 2010 at 6:51 PM, Joe D'Souza jdso...@shyle.net wrote: ** Axton, Won't you have problems with missing fields? I know I once used an older form (it was a known bug) when Remedy updated the plugin (of SRM or RKM - I do not remember which) but not the underlying forms, so there were missing fields in the older version forms that the plugin kept complaining about and as a result not displaying the information it should have.. I had to manually create these fields in the form to correct that problem. So depending on what plugin you are talking about, you might be able to get away with it so long as you manually fix the forms that these plugins display data on. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *Axton *Sent:* Monday, April 12, 2010 5:37 PM *To:* arslist@ARSLIST.ORG *Subject:* Question on Java Plug-in server and ARS 6.3 ** Has anyone out there connect a 6.3 Remedy server to a 7.5 Java Plugin server? Thanks, Axton _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Question on Java Plug-in server and ARS 6.3
Has anyone out there connect a 6.3 Remedy server to a 7.5 Java Plugin server? Thanks, Axton ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Finding memory leaks in the AR System
Since you are on Solaris/sparc you have some really good options for seeing if there are memory leaks. Look into the slab memory allocator (libumem). http://blogs.sun.com/ahl/entry/solaris_10_top_11_20 http://blogs.sun.com/ahl/entry/solaris_10_top_11_20There are actually performance benefits to using this memory allocator to the standard libc (though it does make the memory footprint slightly larger), but it's going to hard stop your software (sigsegv, sigbus, etc.) in the event nasty things are going on that shouldn't be going on. Good news is that it tells you what/where if you tell your system to generate a core in the event. Once you have things running under libumem, you can put some checks on memory usage (see the following): UMEM_DEBUG UMEM_LOGGING Once you do that, it makes some handy options available in dbx (RTC): http://www.mail-archive.com/arslist@arslist.org/msg33614.html http://www.fortran-2000.com/ArnaudRecipes/SunMemoryDB.html#SunDbx You can attach the debugger to the process in flight to check for memory leaks: http://technopark02.blogspot.com/2005/10/sun-studio-investigating-memory-leaks.html See here for the high-level gory details. Pretty cool stuff: http://developers.sun.com/solaris/articles/libumem_library.html Axton Grams On Tue, Apr 6, 2010 at 4:38 PM, Robert Halstead badbee...@gmail.com wrote: ** Hey all, We're running AR System 7.5 patch 004 and we are finding that our server is eating up memory and not releasing it. We are in the UAT process and have roughly 10 testers testing the system. During this time we've noticed a huge memory allocation and eventually the arserverd process would consume 2-3 gigs of memory and all the swap space, at which point the machine comes to it's knees and the process needs to be forcibly killed or the box hard restarted. I remember reading somewhere that the AR System doesn't release memory for large queries, but instead just reuses the memory address space. Is this still true for 7.5? Are there any type of performance configurations I can add to the ar.conf file to allow the AR System to release the memory it allocates? Or to prevent a query from taking all the available memory on the box? I thought the AR System used temporary file storage for storaging a large SQL result? Our 6.3 AR System stores temporary query result files in /var/tmp/ARpen* files, does 7.5 not do the same thing? I just thought I would ping the list before I open a ticket with BMC and see if anyone else is seeing a memory leak or has had this problem occur to them in the past. Though I'm not sure who all is running the latest 7.5 AR System. Any help would be appreciated as I'm not sure what BMC will want me to look for to determine a memory leak and I don't like to engage them without some sort of proof that one exists. Our server specs are the following: System Configuration: Sun Microsystems sun4u Sun Fire V210 System clock frequency: 167 MHZ Memory size: 4GB CPUs E$ CPUCPU CPU Freq SizeImplementation MaskStatus Location --- -- - - -- 01002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P0 11002 MHz 1MB SUNW,UltraSPARC-IIIi2.4on-line MB/P1 AR System 7.5 patch 004 Apache Tomcat 5.5.28 / Midtier 7.5 patch 004 If you guys need more server specs let me know. We are trying to replicate the issue but we are unsure how it happens and don't really know where to start. Thanks for the help. -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Bob Halstead _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy Special Charater Encoding issue via Web Service
Your question does not provide enough info to give a useful response. - Axton On Wed, Feb 10, 2010 at 7:42 AM, Zalaki, Suresh IN BOM SISL suresh.zal...@siemens.com wrote: Any update on this please ? Regards Suresh Zalaki -Original Message- From: Zalaki, Suresh IN BOM SISL Sent: Monday, February 08, 2010 9:31 PM To: 'arslist@ARSLIST.ORG' Subject: Remedy Special Charater Encoding issue via Web Service Hi, I am trying to rise request via remedy webservice in remedy its not accepting the special character Míċeál giving error. Please suggest me what encoding it require? Regards Suresh Zalaki Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Oracle / ARS thread linking
Based on the sql being executed, you can speculate which queue is executing the sql. As for a systematic way to tie an oracle session to a remedy thread to a remedy queue/remedy user, I know of none. It would be nice if the thread logging collected this information. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Feb 3, 2010 at 9:02 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: I do it by having select access to a couple of system views in Oracle. Not all DBA(s) will give access to these views, so you may have to ask nicely ;) The following will show you what SQL has taken time to complete (I forget the threshold on Oracle that makes it show up in this view) select * from V$SESSION_LONGOPS Order By Start_Time DESC If it is not in there and is still running you could also use select * from V$SESSION where Status='ACTIVE' Order By Logon_Time DESC Either one of those should give you the SQL_ID. With that you should be able to see what is actually being executed. select * from v$SQL where SQL_ID = '7wj5xv851kq9c' -- use the SQL_ID from one of the above queries The V$SESSION_LONGOPS view will also give you the time remaining and elapsed_seconds of that SQL statement. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Coleman, Gavin Sent: Wednesday, February 03, 2010 8:23 AM To: arslist@ARSLIST.ORG Subject: Oracle / ARS thread linking ** Hi List - we've been having a few problems with our Remedy systems and I could do with some advice. We have recently experienced a massive slowdown on two consecutive days of our production system. We have tied this to a database problem. There has been an Oracle process that has been taking up 60-70% of our DB CPU. This process was triggered by ARADMIN user. During this slowdown, our Application Servers have shown no significant jump in CPU usage. Is there a way in Oracle to tie the Oracle thread ID back to an ARS thread ID? I.e. If I switch on logging by thread on my application servers, this gives me the thread ID and everything that is being processed by that thread. Can I identify that thread number in Oracle in anyway? If I could, then I could potentially narrow down what could have caused this slowdown. Remedy 6.3 Patch 18 (windows 2003) Oracle 9.2.0.6.4 (AIX) Thanks for your help, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com W: www.computacenter.com ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 7.5 Installation Problems (of course!)
AMERICAN_AMERICA.WE8MSWIN1252 allows characters that do not translate properly in AMERICAN_AMERICA.AL32UTF8. Examples are all your 8-bit ascii characters. The code points are different between the two localizations which means that some other characters may not render properly depending on how things were written and are now being read. Try running Oracle's csscan utility against the db to see what comes back. Do you see checksum errors in the logs (i.e., invalid definition) in the arerror.log? Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Jan 28, 2010 at 9:15 AM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** We have finally identified the root of the failed installations. Now to figure out how to correct this issue. A couple of years ago we installed 7.01 on a new app server and to a separate DB server. We went through the steps of setting the servers up to for Unicode. We are a world wide company with helpdesks in the US, Europe, China, Japan, Thailand, etc. We asked questions to support and backline engineers to make sure that we had it setup correctly. Last fall we upgraded to 7.01. Turns out we missed a registry setting. On our app servers (development and production) NLS_LANG is set to AMERICAN_AMERICA.WE8MSWIN1252. When we change make the registry setting change to NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as noted in the installation guide, we start seeing all sorts of errors in the arerror log about missing forms, missing data, missing workflow, etc. We've not seen a few issues with languages that we can directly relate to having an incorrect NLS_LANG. We have seen a few issues that were bugs in the email engine. Any thoughts on how to correct? Dave -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kemes, Lisa *Sent:* Monday, January 25, 2010 2:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** BMC looked at our logs and among many errors, said that one of the errors is because either the Group, User, ReportType, ReportCreator, has bad entries or duplicate entries on them. There were no duplicates per se, but there were records with duplicate Unique Id's in the Unique Identifier (on the Group Form). Not sure why the system would allow this, but we think it's from doing Copy to New actions on some of the Groups. Not 100% sure yet is this is one of the culprits but we are looking into this Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kemes, Lisa *Sent:* Friday, January 22, 2010 2:25 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** I couldn't find any RIK files under the TEMP directory (should be under the Utilities folder correct?) But I did find these logs All the RIK files we can find are: ARServer-RIK_PostUpgrade.log ARServer-RIK_PostUgradeInstall.log ARServer-RIK_PostUpgrade_error.log ARServer-RIK_PostUpgrade_apps.log In the ARServer-RIK_PostUpgrade Log: Cannot get target schema details from the server specified. Status List : 1 items ERROR: #303 ReportType - Form does not exist on server Attempting import from schema ReportType in file to ReportType on server The command line option for schema is not valid. Cannot import Loading Mappings failed: The import was not attempted If only I can find the command line that is not working... Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Tommy Morris *Sent:* Friday, January 22, 2010 1:25 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** It was in a RIK file. I think that this one in particular was created using an install utility that BMC provided but you can check in your temp directory to see if you can find one there. *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kemes, Lisa *Sent:* Friday, January 22, 2010 12:20 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** Thank Tommy! What file is this in? Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Tommy Morris *Sent:* Saturday, January 23, 2010 1:56 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** I will apologize for the length of this response but maybe
Re: 7.5 Installation Problems (of course!)
AL32UTF8 is a superset of UTF8. Per the Remedy installation guide, the db character set should be set to AL32UTF8. Run csscan with a target character set of AL32UTF8 and see what it returns as lossy/unconvertible. I believe what you are running into is a problem with how the data as it is stored in the database. Since the client has been configured with AMERICAN_AMERICA.WE8MSWIN1252 for all this time, it has been reading/writing the data with the codepoints appropriate for that localization. These codepoints are very different than the codepoints for the same character in the character set AL32UTF8. See the following articles for more info: http://en.wikipedia.org/wiki/CESU-8 http://repettas.wordpress.com/2008/05/15/al32utf8utf8-unicode-database-character-set-implications/ UTF8, in the world of Oracle, is not really a UTF-8 compliant character set (bad name). AL32UTF8 is a complaiant UTF8 implementation. See the following: http://forums.oracle.com/forums/thread.jspa?messageID=1139523 http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/applocaledata.htm#i636713 http://oracleappstechnology.blogspot.com/2007/10/difference-between-utf8-and-al32utf8.html What I think you need to do: 1. convert the instance from UTF8 to AL32UTF8. Part of this will require cleaning up data (CESU-8 data, 8-bit ascii data, and other unconvertible data that csscan returns) 2. update the oracle client to use AL32UTF8 While that may look like a short list, the actual process may have complications. In the ARSCHEMA, ACTLINK, and other Remedy meta-data tables, a checksum is calculated and stored. That is based on the name, last modified by, and other values. If any of the values used to generate the checksum contains data that must be converted, the migration path becomes very difficult. The output of the csscan utility should give you an idea of what you are looking at. If you have SQL Developer installed (java based oracle client that comes with 11g), connect to your db and see what kind of data is returned when you look at it from there. This is a java based client and is fully unicode capable. You may be surprised with the results for your 8-bit ascii characters (umlauts, euro symbol, etc.). -- Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 7.5 Installation Problems (of course!)
UTF8 character set uses CESU-8 code points, which are not compatible with the client character set AMERICAN_AMERICA.AL32UTF8 but are compatible with the client character set AMERICAN_AMERICA.WE8MSWIN1252. Read here: http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550 http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm#CEGCGEAF http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550 I believe there is invalid data in the db that will have to be converted/cleaned up if you want to change the client localization settings and expect it to work. This means moving all the 8-bit characters (CESU-8, or whatever else there are) to the proper UTF-8 code point so that a client expecting that data can understand it. -- Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Jan 28, 2010 at 12:15 PM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** Axton, Here is what I got back from our DBA. The data in the database is in utf8 characterset. The database would not allow it to be stored other than that. The application would have a failure on the storing of invalid characters which would show up on the (application server). I can run the csscan though. The csscan is used when you want to convert your characterset and we do not want to do that. Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: 7.5 Installation Problems (of course!)
You're welcome. I am going through the same thing right now, so it's all fresh in my mind. Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Jan 28, 2010 at 3:41 PM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** Axton, Thanks for the assist. I need to work through some thoughts and come up with a conversion plan. Luckily there are few forms where we actually use the local language view so we may simply delete those views. Also we do not need to keep some of the data like in the AR System Email messages forms. 99% of our forms that display in a local language use View forms and data to display the text in the local language. Dave -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Thursday, January 28, 2010 2:56 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: 7.5 Installation Problems (of course!) ** UTF8 character set uses CESU-8 code points, which are not compatible with the client character set AMERICAN_AMERICA.AL32UTF8 but are compatible with the client character set AMERICAN_AMERICA.WE8MSWIN1252. Read here: http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550 http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm#CEGCGEAF http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550 I believe there is invalid data in the db that will have to be converted/cleaned up if you want to change the client localization settings and expect it to work. This means moving all the 8-bit characters (CESU-8, or whatever else there are) to the proper UTF-8 code point so that a client expecting that data can understand it. -- Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Jan 28, 2010 at 12:15 PM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** Axton, Here is what I got back from our DBA. The data in the database is in utf8 characterset. The database would not allow it to be stored other than that. The application would have a failure on the storing of invalid characters which would show up on the (application server). I can run the csscan though. The csscan is used when you want to convert your characterset and we do not want to do that. Dave _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
There is no one size fits all or 'valid' default. If you have well written application, unlimited is not a problem. If you have poorly written applications, 1000 may be too high. All of these configuration parameters have a direct impact on the perceived usability of the system. If your system has conditioned people to do things in an inefficient way, turning these knobs will help with performance, but you're going to have an angry mob at your door. Axton Grams On Tue, Jan 26, 2010 at 12:58 PM, Joe D'Souza jdso...@shyle.net wrote: ** This does impact performance and the ideal values for these will be very specific to your environment and setup (number of concurrent users performing these operations, size of the DB, etc.) While 1000 max entries returned by Get list for one site may be too large (very very heavily used systems), 1 for another (underused systems) may be insignificant.. Initially go by your gut feel, and then measure statistics and benchmarks, and derive your ideal numbers through statistics.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *Ramy S. Ayoub *Sent:* Tuesday, January 26, 2010 1:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Server Information ** ** Thanks James, I have another question regarding the configuration also Max Entries Returned By Get list , and Server Table Field Chunk Size ? if this also impact the performance and what is BMC recommendation ? Regards, Ramy On 1/26/10, jham36 jha...@gmail.com wrote: From the 7.1 documentation Maximum Filters for an Operation: Defines the number of filters that can be performed in an operation. The default and recommended number is 1. Increase this number at your own risk only if you reach a limit in your system and you have verified that your workflow is valid. Maximum Stack of Filters: Defines the maximum number of nested filters and filter guides that will execute to prevent recursive actions on the server. The default and recommended number is 25. Increase this number at your own risk only if you reach a limit in your system and you have verified that your workflow is valid. James On Jan 26, 11:39 am, Ramy S. Ayoub ramyay...@gmail.com wrote: Dears, I have Question regarding the Server Information in the Advanced Tab , I can find Field call Maximum Filter for an Operation , and Maximum Stack of Filter , what is the recumandation values regarding it , and this can impact the Performance ? ARS 7.1 Patch 004 OS : Windows 2003 DB : SQL 2005 Regards, Ramy _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: Thread count convert to oracle session count
The Oracle session count is going to match the thread count configured across all the queues. If you want to research what queues are running into blocks (not enough threads), look at the per thread server statistics. If you want to know whether your servers are able to effectively use as many threads as you have configured, look at the kernel statistics for your arserverd process. On Solaris you can look into mpstat and sar. Axton Grams On Tue, Jan 19, 2010 at 4:25 PM, Haque, Rezaul R rezaul.ha...@chartercom.com wrote: ** Guys, I am in a dilemma to decide to set how many oracle session according to Remedy Thread count that we have in our system. right now we have Fast = 15, List = 30 and some Private = 10, Private = 10, Private = 2 and Private = 1 and Of course Admin = 1, Alert =1 DBA saying we are maxed out 300 ( currently set in database). How can I judge what would be ideal oracle session count according to my thread count. Please advice Thanks Rezaul E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. _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: ARServer Status monitor
I created a command line utility that can be used to check the availability of an ARServer. It should compile on all the platforms that Remedy runs on. I have verified it with the 6.3 and 7.1 apis on Solaris and Linux. It is built using the GNU Autotools (./configure --with-arapi-dir-/some/path make make install) The source code is available here: http://communities.bmc.com/communities/docs/DOC-9059 The program is a command line and operates according to these specifications: NAME aravail - check the availability of an arserver SYNOPSIS aravail -V aravail -h aravail -vv -a HOSTNAME -u Demo aravail -a HOSTNAME -r 0 -t 2020 -u Demo -p DESCRIPTION Connect to an ARServer and issue a ARVerifyUser api call. OPTIONS The following options are supported: -V print version information -v verbose output -vv more verbose output -vvv even more verbose output -h print help text -a HOSTNAME connect to arserver HOSTNAME -t TCPPORT connect to arserver via TCPPORT -r RPGPROG connect to arserver using RPCPROG -u USERNAME connect to arserver as USERNAME -p PASSWORD connect to arserver using PASSWORD DEFAULT VALUES HOSTNAME localhost TCPPORT 0 RPCPROG 0 USERNAME Demo PASSWORD null EXIT STATUS 0ARServer is accessible 0 An error occurred The code is being released under the Simplified BSD License. Only the source is available at this time (no compiled versions). If you compile the software, feel free to upload the compiled version to the BMC Developer Network. If you run into any issues reach out to me or someone on the BMC Communities. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. 2010/1/7 Doug Blair d...@blairing.com ** Hi We have a small shell script (runs on Solaris/Linux) which uses wget (or curl) to log into the mid-tier, display the home page and then log out. Both output pages are stored in separate files. Wget is set to timeout in 15 seconds, and the script runs every couple minutes. The home page displays the quick link list, which exercises all of the system components including mid-tier, arserver and database. If the second file isn't there, somethings wrong and the admins get mailed, paged, etc. This is Solaris, so the script runs as a cron job. I'm not sure it's a good idea to use Remedy to monitor itself. You'd need something to run the test and something else to check for non results, and that would be both messy and obscure. Just for fun, try passing the same DSO record bsck and forth every minute. If your copy is older than a couple minutes, the other server needs attention :-) Doug -- Doug Blair Sent from my iPhone, typographic errors likely +1-224-558-5462 On Jan 7, 2010, at 7:50 AM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** There is a set length of time that the app server will attempt to reconnect to the DB instance. If it has re-established the connection after that length of time the system is in a state of limbo. You can add a variable (Db-Connection-Retries) in the conf file that will increase the length of time that the app server will attempts the database connection. Dave -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jason Miller *Sent:* Wednesday, January 06, 2010 6:09 PM *To:* arslist@ARSLIST.ORGarslist@ARSLIST.ORG *Subject:* Re: ARServer Status monitor ** Ah, I used to have a 7.1 servers that would do that. The app and db server were plugged into the same darn switch but they would lose connection. Fortunately it was short enough that ARS usually recovered with no issue. I am surprise that a restart of Portmapper would resolve the issue. Do you have DSO? You could check available by transferring records. If not you could create a web service that does a simple query against a small form on prod and then have an Escalation on dev that would call the web service. If there is an error you could have dev perform whatever action you wish. This would include the Mid-Tier as a point of failure but maybe you want to make sure that MT is responding at the same time? Another idea would be to call runmacro from an Escalation on the dev server to try export a small set of records from prod. You can then either parse the return for error messages or if no file was created assume that the server is down. Look at the sc (Service Control) command to start/stop remote services. HTH, Jason On Wed, Jan 6, 2010 at 1:42 PM, Reiser, John
Re: Custom application upgrade ARS 4.3 to 7.5 on AIX
Some things are going to cause you problems. In the old versions you could have core fields on display only forms. In later versions you can not. There are probably a few other things that could cause you problems too, but I don't remember anything else. On Thu, Jan 7, 2010 at 9:16 PM, remedydon mrohinikanth2...@gmail.comwrote: Hi folks, Our client is planning to upgrade a custom application from 4. 3 to 7.5 on AIX platform with Oracle database. If we export the def files from v 4.3 and import them into 7.5 can we view the application as is in the newer version ? Will all the workflow work as it used to work ? or Is there a need to rebuild the whole application in the new version? Did you implement this before on any other platform other than AIX ? If yes, did you face any potential issues ? this might sound pretty silly question but haven't done this before. Appreciate your response. RD -- View this message in context: http://old.nabble.com/Custom-application-upgrade-ARS-4.3-to-7.5-on-AIX-tp27070839p27070839.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: safest and fastest way to delete AR Email records
Yes, directly against the db. The main reason is so that the high water mark is reset on the table. You basically won't have any performance/overhead gains unless you do this. http://www.adp-gmbh.ch/ora/concepts/space_management/high_water_mark.html Axton On Wed, Dec 9, 2009 at 4:58 PM, Ex Soundgarden thewallstre...@yahoo.comwrote: ** Hi Axton, I'm not sure where David posted his reply from my question. When you say truncate table, this means that I would directly go to the db to delete records? -- *From:* Axton axton.gr...@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Tue, December 8, 2009 7:06:37 PM *Subject:* Re: safest and fastest way to delete AR Email records ** Look into the sql 'truncate table' to empty it initially. David has posted what you need for the ongoing maintenance of the data. While doing the initial delete, you probably want to look at the email error logs form, the email attachments form, and all the other email forms. Axton On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden thewallstre...@yahoo.comwrote: ** Hi All, I've been wandering around searching for some tips on how to delete 3 million records sitting in AR System Email Messages form. What I''m doing right now is just doing it by batch - deleting 10,000 records every now and then. From the past, I remember doing it directly in the database by re-creating the Email Messages table (which eventually dropped all the records). I had no problem with this. I just want to know if there are other ways to delete the records without going directly to the db? Thanks, Gabud _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
Re: Assignee Groups - I'm Stumped....
What other pemissions do you have on the request id? Axton On Tue, Dec 8, 2009 at 1:38 PM, Kemes, Lisa lisa.ke...@tycoelectronics.comwrote: ** I also wanted to assure everyone that I'm not using the $GROUPS$ keyword in any of my workflow. I'm actually using the name of the group to set the Assignee Group field. Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kemes, Lisa *Sent:* Tuesday, December 08, 2009 2:36 PM *To:* arslist@ARSLIST.ORG *Subject:* Assignee Groups - I'm Stumped ** The Assignee Group feature that I set up was working just fine until a couple of weeks ago. ARS 7.1 P7 Windows 2003 Oracle 10g (I think) Assignee Group with Field ID 112 on Form? Check Assignee Group Permission on Request ID field? Check Workflow to set the Assignee Group field to said Permission groups? Check Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form? Check But even though the Assignee Group field has Permission A and B, when I sign on with Permission C, I'm still able to see the records that are supposed to be hidden. What's weird is that this used to work fine. I'm going to do some research, but if anyone could head me in the right direction for more investigation that would be great… *Lisa Kemes** * AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _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: Assignee Groups - I'm Stumped....
Yes; members of Public can see the entry Axton On Tue, Dec 8, 2009 at 1:52 PM, Kemes, Lisa lisa.ke...@tycoelectronics.comwrote: ** Ugh, you just jostled (is that the correct spelling?) my brain as to why this may not work. I have Public Permissions on the Request ID because it's part of a Notification email. Is that why it's not working? Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Tuesday, December 08, 2009 2:45 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Assignee Groups - I'm Stumped ** What other pemissions do you have on the request id? Axton On Tue, Dec 8, 2009 at 1:38 PM, Kemes, Lisa lisa.ke...@tycoelectronics.com wrote: ** I also wanted to assure everyone that I'm not using the $GROUPS$ keyword in any of my workflow. I'm actually using the name of the group to set the Assignee Group field. Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kemes, Lisa *Sent:* Tuesday, December 08, 2009 2:36 PM *To:* arslist@ARSLIST.ORG *Subject:* Assignee Groups - I'm Stumped ** The Assignee Group feature that I set up was working just fine until a couple of weeks ago. ARS 7.1 P7 Windows 2003 Oracle 10g (I think) Assignee Group with Field ID 112 on Form? Check Assignee Group Permission on Request ID field? Check Workflow to set the Assignee Group field to said Permission groups? Check Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form? Check But even though the Assignee Group field has Permission A and B, when I sign on with Permission C, I'm still able to see the records that are supposed to be hidden. What's weird is that this used to work fine. I'm going to do some research, but if anyone could head me in the right direction for more investigation that would be great… *Lisa Kemes** * AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _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_ _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: safest and fastest way to delete AR Email records
Look into the sql 'truncate table' to empty it initially. David has posted what you need for the ongoing maintenance of the data. While doing the initial delete, you probably want to look at the email error logs form, the email attachments form, and all the other email forms. Axton On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden thewallstre...@yahoo.comwrote: ** Hi All, I've been wandering around searching for some tips on how to delete 3 million records sitting in AR System Email Messages form. What I''m doing right now is just doing it by batch - deleting 10,000 records every now and then. From the past, I remember doing it directly in the database by re-creating the Email Messages table (which eventually dropped all the records). I had no problem with this. I just want to know if there are other ways to delete the records without going directly to the db? Thanks, Gabud _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: How to implement HA architecture?
You can create many farms on a single F5 (of any type you choose). If one arserver is down, things should just keep working as if nothing were wrong. If you are going with a farm with many active nodes, I do not see the need for MS Clustering. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Dec 5, 2009 at 2:49 AM, Martin Liu liuz...@gmail.com wrote: ** Thanks you all! I learned a lot from you guys. But I still got something to confirm. What I have: 1) 4 physical machines MS Windows OS(2 for Mid-tier, 2 for ARS); 2) One physical F5 device; 3)One Oracle RAC hosting DB for ARS. My customer is primarily using Web client. Q1)Can I create two farms on one single F5 device? one for Mid-tier; one for ARS. Does this configuration have HA capability for ARS? I mean if one ARS server down, the whole system is still working. Q2)Does MS cluster provide one single entry and HA function for two ARS servers? I mean two ARS servers within one server group. If one ARS server down, MS cluster will switch to another ARS server. And this server will still pick up Administrative Operations, Escalation, Reconciliation, etc... Does MS cluster service equal to a F5 device from HA point view? I will post F5 device model that you may know. Best regards! Martin 2009/12/5 Kelly Deaver kdea...@kellydeaver.com ** You may find this presentation handy as well. It was my attempt to pull together the info in all the various install manuals - http://communities.bmc.com/communities/docs/DOC-2841 Kelly Deaver Effective Technologies www.effect-tech.com kdea...@kellydeaver.com (ARSlist mail) ke...@effect-tech.com (Business mail) Original Message Subject: Re: How to implement HA architecture? From: Garrison, Sean (Norcross) sean.garri...@fiserv.com Date: Fri, December 04, 2009 3:12 pm To: arslist@ARSLIST.ORG True high availability allows your server to still be up and running if one of the locations goes down. This is pretty much impossible with remedy because the app server is highly dependent on the connection to the db. We tried it with one of our remote locations and it took 45 minutes just for one app server to start because the DB was located in Georgia and the App server was in Ohio. Our ultimate solution was to replicate the db to ohio and use the app servers in ohio (connecting to a local db in ohio) as hot backups just in case the ones in georgia goes down. What Axton said below is pretty much our setup (except we have 3 app servers and 4 mid-tier). The only thing we added was a hot backup environment in another location. Hope that helps, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Friday, December 04, 2009 10:42 AM To: arslist@ARSLIST.ORG Subject: Re: How to implement HA architecture? One more thing to add. You need to configure health checks in the F5 for the midtier and arserver nodes. I have not fully vetted any of these approaches, but these are my thoughts: ARS: 1. port check (this mostly works) 2. iRules in the F5 to simulate a session Midtier: 1. HTTP post to a page that the web server displays 2. HTTP post to a page that the servlet container renders (midtier config) 3. HTTP post to a page that the midtier renders (home page) 4. port check Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Dec 4, 2009 at 9:40 AM, Axton axton.gr...@gmail.com wrote: For ARS: - Create an F5 farm for udp/111, tcp/111, and the port ars listens on - Enable session persistence based on src ip (needed due to floating licenses) - Configure a server group in ARS For MidTier: - Create and F5 farm for tcp/80 and tcp/443 - Enable session persistence based on src ip (needed because midtier does not synchronize/use central store for session information) When you configure the midtier as to what arservers to point to, there are a couple of options: - point it to the ars farm: this causes issues because all midtier sessions go to the same arserver - point each midtier server to the individual server When working with the F5, you need the arservers to be on a network that gives a route to the db that does not traverse the F5. This is typically accomlished using a back end network that the arservers and db servers are connected to. Axton Grams The opinions, statements
Re: How to implement HA architecture?
There are many other solutions that are just as viable. The concept is that of a reverse proxy and/or a load balancer. BigIP has gone to lengths to: 1. add bells and whistles to their devices to make the configuration, administration, and maintenance as easy as possible. 2. choose the best hardware for the job at hand They are in essence the 800lb gorilla in this arena. The BigIP LTM's run on a Linux kernel; they used to run on a BSD kernel. There are a number of open source programs that implement similar functionality and there are other vendors that offer competitive products: Open Source: squid, varnish, ... Proprietary: Cisco ACE, Radware AppDirector, Barracuda Load Balancer, ... The open source offerings are generally limited to web traffic (http/https). There is a lot to be gained by the hardware in these types of devices (performance, scalability, reliability, capability) and as such they are generally marketed and sold as network appliances, not a software solution; an area that the open source model does not address very well. See here for more information: http://en.wikipedia.org/wiki/Reverse_proxy http://blog.loadbalancer.org/load-balancer-comparison-a-refreshingly-simple-comparison-of-load-balancing-hardware-specifications/ Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Dec 5, 2009 at 7:08 AM, Martin Liu liuz...@gmail.com wrote: ** Axton, Thank you very much! Finial questions: does this means F5 is the only possible HA solution for Remedy system? If the customer don't have F5 for this project, is there any HA solution existing? Regards, Martin 2009/12/5 Axton axton.gr...@gmail.com You can create many farms on a single F5 (of any type you choose). If one arserver is down, things should just keep working as if nothing were wrong. If you are going with a farm with many active nodes, I do not see the need for MS Clustering. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Dec 5, 2009 at 2:49 AM, Martin Liu liuz...@gmail.com wrote: ** Thanks you all! I learned a lot from you guys. But I still got something to confirm. What I have: 1) 4 physical machines MS Windows OS(2 for Mid-tier, 2 for ARS); 2) One physical F5 device; 3)One Oracle RAC hosting DB for ARS. My customer is primarily using Web client. Q1)Can I create two farms on one single F5 device? one for Mid-tier; one for ARS. Does this configuration have HA capability for ARS? I mean if one ARS server down, the whole system is still working. Q2)Does MS cluster provide one single entry and HA function for two ARS servers? I mean two ARS servers within one server group. If one ARS server down, MS cluster will switch to another ARS server. And this server will still pick up Administrative Operations, Escalation, Reconciliation, etc... Does MS cluster service equal to a F5 device from HA point view? I will post F5 device model that you may know. Best regards! Martin 2009/12/5 Kelly Deaver kdea...@kellydeaver.com ** You may find this presentation handy as well. It was my attempt to pull together the info in all the various install manuals - http://communities.bmc.com/communities/docs/DOC-2841 Kelly Deaver Effective Technologies www.effect-tech.com kdea...@kellydeaver.com (ARSlist mail) ke...@effect-tech.com (Business mail) Original Message Subject: Re: How to implement HA architecture? From: Garrison, Sean (Norcross) sean.garri...@fiserv.com Date: Fri, December 04, 2009 3:12 pm To: arslist@ARSLIST.ORG True high availability allows your server to still be up and running if one of the locations goes down. This is pretty much impossible with remedy because the app server is highly dependent on the connection to the db. We tried it with one of our remote locations and it took 45 minutes just for one app server to start because the DB was located in Georgia and the App server was in Ohio. Our ultimate solution was to replicate the db to ohio and use the app servers in ohio (connecting to a local db in ohio) as hot backups just in case the ones in georgia goes down. What Axton said below is pretty much our setup (except we have 3 app servers and 4 mid-tier). The only thing we added was a hot backup environment in another location. Hope that helps, Sean -Original Message- From: Action Request
Re: How to implement HA architecture?
One more thing to add. You need to configure health checks in the F5 for the midtier and arserver nodes. I have not fully vetted any of these approaches, but these are my thoughts: ARS: 1. port check (this mostly works) 2. iRules in the F5 to simulate a session Midtier: 1. HTTP post to a page that the web server displays 2. HTTP post to a page that the servlet container renders (midtier config) 3. HTTP post to a page that the midtier renders (home page) 4. port check Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Dec 4, 2009 at 9:40 AM, Axton axton.gr...@gmail.com wrote: For ARS: - Create an F5 farm for udp/111, tcp/111, and the port ars listens on - Enable session persistence based on src ip (needed due to floating licenses) - Configure a server group in ARS For MidTier: - Create and F5 farm for tcp/80 and tcp/443 - Enable session persistence based on src ip (needed because midtier does not synchronize/use central store for session information) When you configure the midtier as to what arservers to point to, there are a couple of options: - point it to the ars farm: this causes issues because all midtier sessions go to the same arserver - point each midtier server to the individual server When working with the F5, you need the arservers to be on a network that gives a route to the db that does not traverse the F5. This is typically accomlished using a back end network that the arservers and db servers are connected to. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Dec 4, 2009 at 2:35 AM, Martin Liu liuz...@gmail.com wrote: ** Hi List, I have two physical windows machines running ARS. Another two machines behind F5 are installed Mid-tier, they will connect to ARS. The customer have HA requirement for ARS. I could have two options: 1)MS Windows Cluster; 2)Remedy server group. But I don't know how to configure for HA architecture. Any advice? -- Regards, 刘征 Martin Liu -- Blog: http://martinliu.cn _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: How to implement HA architecture?
For ARS: - Create an F5 farm for udp/111, tcp/111, and the port ars listens on - Enable session persistence based on src ip (needed due to floating licenses) - Configure a server group in ARS For MidTier: - Create and F5 farm for tcp/80 and tcp/443 - Enable session persistence based on src ip (needed because midtier does not synchronize/use central store for session information) When you configure the midtier as to what arservers to point to, there are a couple of options: - point it to the ars farm: this causes issues because all midtier sessions go to the same arserver - point each midtier server to the individual server When working with the F5, you need the arservers to be on a network that gives a route to the db that does not traverse the F5. This is typically accomlished using a back end network that the arservers and db servers are connected to. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Dec 4, 2009 at 2:35 AM, Martin Liu liuz...@gmail.com wrote: ** Hi List, I have two physical windows machines running ARS. Another two machines behind F5 are installed Mid-tier, they will connect to ARS. The customer have HA requirement for ARS. I could have two options: 1)MS Windows Cluster; 2)Remedy server group. But I don't know how to configure for HA architecture. Any advice? -- Regards, 刘征 Martin Liu -- Blog: http://martinliu.cn _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: Firewall TCP Timeouts
What pieces of the AR infrastructure are in a NAT? Are the arservers in one subnet behind a NAT and the midtier in a different subnet behind a NAT? Axton On Thu, Nov 19, 2009 at 8:14 AM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: Axton, our firewall is a Cisco ASA 5520. Ken === Your Previous related msg: This can be normal behavior for a firewall. It all depends on how you allow packets to create a state or if you use state at all. You can create a rule that is stateless so that all packets from host X to host Y are allowed. You should explore creating the rule to do a quick pass of the packets and not use state for these connections. Basically, the rules would look like this: pass in quick on $if_1 inet proto tcp from $mt_host_1 to $ar_host_1 pass out quick on $if_2 inet proto tcp from $ar_host_1 to $mt_host_1 Instead of a state based or policy based ruleset. You can also change the type of packet on the firewall so that syn/syn ack packets are not the only type of packet that can insert a state into the state table. This is a little funky and is probably not the best way to do this, but it can be done this way too. Axton Grams -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 5:09 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts Midtier timeout has to do with the user session timeout. Once arserver is started there is a persistent socket connection to the arserver. Can I ask what type of firewall this is? Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 4:05 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Since you are using MidTier I would suggest you do the following... Add a specified port for your AR Server to listen on (The AR Server runs just fine with portmapper and a specified port). Set the MidTier to use the specified port. Also set the MidTier Session TimeOut value to be less than your firewall time out setting. This way Mid-Tier will drop old connections before the firewall does. You should be able to set the MIdTier TimeOut from the configuration pages on your MidTier server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth Sent: Wednesday, November 18, 2009 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier
Re: Oracle in-row LOB storage issue - IM 7.03
You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or segment_name like '_746C%') Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 12:57 AM, William Rentfrow wrentf...@stratacominc.com wrote: ** 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 _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: Oracle in-row LOB storage issue - IM 7.03
I need sleep ;) The B#C# are used for attachments, I believe, at least they were in past versions. This is because Remedy used to use a LONG RAW data type for the binary storage and there could be only 1 long raw per table. The SYS_LOB039519C00010$$ cited by Frederick is the LOB segment. You can add the segment_type column to the results to see what type it actually is. The segment_type will tell you one of these: CACHE CLUSTER INDEX LOBINDEX LOBSEGMENT ROLLBACK TABLE TABLE PARTITION TYPE2 UNDO Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 11:01 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Wow... I actually have something to disagree with Axton on ... If you create a form (since v6x) Remedy no longer uses the BtttCccc structure to hold the long character fields. I am on 7.1.0 patch 7 with Oracle 10g and all of my CLOB columns are just columns in the normal table. SQL describe T10; Name Null? Type --- C1 NOT NULL VARCHAR2(15) C2 VARCHAR2(254) C3 NOT NULL NUMBER(15) C4 VARCHAR2(254) C5 NOT NULL VARCHAR2(254) C6 NOT NULL NUMBER(15) C7 NOT NULL NUMBER(15) C8 NOT NULL VARCHAR2(128) C536870912 VARCHAR2(255) C536870913 CLOB C536870914 NUMBER(15) C536870915 CLOB C536870916 NUMBER(15) C536870921 VARCHAR2(4000) C536870924 VARCHAR2(4000) C536870925 NUMBER(15) C54710 VARCHAR2(255) And if I look at the create script thru TOAD I see: CREATE TABLE T10 ( C1 VARCHAR2(15 BYTE) NOT NULL, C2 VARCHAR2(254 BYTE), C3 NUMBER(15) NOT NULL, C4 VARCHAR2(254 BYTE), C5 VARCHAR2(254 BYTE) NOT NULL, C6 NUMBER(15) NOT NULL, C7 NUMBER(15) NOT NULL, C8 VARCHAR2(128 BYTE) NOT NULL, C536870912 VARCHAR2(255 BYTE), C536870913 CLOB, C536870914 NUMBER(15), C536870915 CLOB, C536870916 NUMBER(15), C536870921 VARCHAR2(4000 BYTE), C536870924 VARCHAR2(4000 BYTE), C536870925 NUMBER(15), C54710 VARCHAR2(255 BYTE) ) TABLESPACE ARSYSTEM LOGGING NOCOMPRESS LOB (C536870913) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) LOB (C536870915) STORE AS ( TABLESPACE ARSYSTEM ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE ) NOCACHE NOPARALLEL MONITORING; The Oracle query for schemaid 10 for me is: select SEGMENT_NAME, bytes from USER_SEGMENTS Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME like '_10') or SEGMENT_NAME like '_10' or SEGMENT_NAME like '_10C%' NOTE: I used USER_SEGMENTS and USER_LOBS in case your DBA has locked down your database (and the DBA_ versions of these objects are not available) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, November 18, 2009 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle in-row LOB storage issue - IM 7.03 You can look at the oracle data dictionary view dba_segments to see the size of the base tables, lob segments, indexes, etc: Here is an example for schemaid 746: SQL ed Wrote file afiedt.buf 1 select bytes, segment_name, owner 2 from dba_segments 3 where (segment_name like '_746' or segment_name like '_746C%') 4* and segment_type = 'TABLE' SQL / BYTES SEGMENT_NAME OWNER -- -- --- 3407872 B746 ARADMIN 2390491136 T746 ARADMIN 27525120 H746 ARADMIN 932446208 B746C701000357 ARADMIN B746C701000357 is the lob segment for field id 701000357. The others are the base tables. You can run the query without the where clause for segment_type to get the indexes, lob segment indexes, etc: select bytes, segment_name, owner from dba_segments where (segment_name like '_746%' or segment_name like '_746C%') Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations
Re: Firewall TCP Timeouts
This can be normal behavior for a firewall. It all depends on how you allow packets to create a state or if you use state at all. You can create a rule that is stateless so that all packets from host X to host Y are allowed. You should explore creating the rule to do a quick pass of the packets and not use state for these connections. Basically, the rules would look like this: pass in quick on $if_1 inet proto tcp from $mt_host_1 to $ar_host_1 pass out quick on $if_2 inet proto tcp from $ar_host_1 to $mt_host_1 Instead of a state based or policy based ruleset. You can also change the type of packet on the firewall so that syn/syn ack packets are not the only type of packet that can insert a state into the state table. This is a little funky and is probably not the best way to do this, but it can be done this way too. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 11:17 AM, Leihkauff, Kenneth kenneth.g.leihka...@saic.com wrote: Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp 0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp 0 864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp 0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: 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
Re: JVM output -- only sees 2GB - but machine has 4GB?
http://msdn.microsoft.com/en-us/library/aa366912%28VS.85%29.aspx Axton On Wed, Nov 18, 2009 at 12:33 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** As I read http://support.microsoft.com/kb/283037 It seems as if ALL programs together under windows can only take 2GB. So - if I have 3 programs each take 1GB -- I would have a problem -- even though I have 4GB. Do others interpret the MS support document similarly? -John On Nov 18, 2009, at 12:05 PM, Lyle Taylor wrote: ** If you’re using a 32-bit JVM (which is required for Remedy), then it is limited to a 2GB memory space, as are all 32-bit processes. You may have more memory on the machine, but 32-bit processes cannot access more than 2GB (unless they’re specially compiled for that, which these aren’t). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] on Behalf Of John Sundberg Sent: Wednesday, November 18, 2009 10:38 AM To: arsl...@arslist.org Subject: JVM output -- only sees 2GB - but machine has 4GB? ** Below is the output of a hs_err_pid file -- the JVM is only seeing 2GB -- but the physical machine has 4GB. Does anybody know why? Also -- does anybody on a Windows 2003 Server see anything (relevant) different if they get a pid file? Any other suggestions are welcome. Thanks, -John --- S Y S T E M --- OS: Windows Server 2003 family Build 3790 Service Pack 2 CPU:total 1 (8 cores per cpu, 1 threads per core) family 6 model 10 stepping 5, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3 Memory: 4k page, physical 2097151k(1391860k free), swap 4194303k(3394944k free) vm_info: Java HotSpot(TM) Server VM (11.3-b02) for windows-x86 JRE (1.6.0_13-b03), built on Mar 9 2009 01:10:11 by java_re with MS VC++ 7.1 time: Fri Nov 13 14:11:23 2009 elapsed time: 77507 seconds -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com _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_ -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.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
Re: Firewall TCP Timeouts
Midtier timeout has to do with the user session timeout. Once arserver is started there is a persistent socket connection to the arserver. Can I ask what type of firewall this is? Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Nov 18, 2009 at 4:05 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Since you are using MidTier I would suggest you do the following... Add a specified port for your AR Server to listen on (The AR Server runs just fine with portmapper and a specified port). Set the MidTier to use the specified port. Also set the MidTier Session TimeOut value to be less than your firewall time out setting. This way Mid-Tier will drop old connections before the firewall does. You should be able to set the MIdTier TimeOut from the configuration pages on your MidTier server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leihkauff, Kenneth Sent: Wednesday, November 18, 2009 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver -- not the MidTier linux server? Our midtier and arserver are linux with a firewall in between. Unfortunately, the firewall is not an application level firewall so the firewall rule changes Axton proposed cannot be implemented according to our network engineer. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, November 18, 2009 3:30 PM To: arslist@ARSLIST.ORG Subject: AW: Firewall TCP Timeouts We had the same issue. We solved this by using libkeepalive (http://libkeepalive.sourceforge.net/) on the arserver machine. But it would work only if you are using Linux. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth Gesendet: Mittwoch, 18. November 2009 18:18 An: arslist@ARSLIST.ORG Betreff: Re: Firewall TCP Timeouts Thanks for your time, Axton. I spoke with our network engineer and he studied the firewall logs and sees quit a few denials and some resets, but is confident things should be set up correctly on the firewall. He only sees these denials/resets for the Midtier application, not some of our other apps. Here is what we're observing on the Linux Midtier server. Below is an example of 3 existing tcp connections that remain intact indefinitely or until midtier is restarted. The firewall knows about these 3 tcp connections, but if the connections are idle for more than 60 minutes (default firewall setting), the firewall will drop these idle tcp connections. Then, when a user gets on midtier (after the idle period), midtier will attempt to use one or more of these tcp connections and the firewall responds with a Deny (since it has aged off the inactive connection). This is normal behavior for a firewall as I understand things, but the application (midtier in this case) should ideally make use of the tcp keepalive or inactivetly timeout supported by Linux. Apparently, midtier does not take advantage of this. I suspect other customers are having this problem IF their topology utilizes a firewall between Midtier and ARS and there are long periods of inactivity. The reason, however, they may not be complaining is because once you get the RCP failure (arerr 91), then subsequent connections seem to work fine. For the example below, once the arerr 91 timeout finally occurred, the associated tcp connection was terminated on the midtier server and a new one was created. $netstat -antopp|grep 2031 Proto Recv-Q Send-Q Local Address Foreign Address State Timer tcp 0 0 :::172.16.0.129:54310 :::10.1.1.141:2031 ESTABLISHED 24977/java off (0.00/0/0) tcp 0 864 :::172.16.0.129:54309 :::10.1.1.141:2031 ESTABLISHED 24977/java on (3.59/12/0) tcp 0 1416 :::172.16.0.129:43717 :::10.1.1.141:2031 ESTABLISHED 24977/java on (16.19/11/0) After a very long wait trying to login in, the user will receive this message: ARERR [91] RPC call failed : ONC/RPC call timed out Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, November 17, 2009 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: Firewall TCP Timeouts You need to configure your firewall properly. With a firewall, you
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: Ports and Queues - Thread Settings ?
Why is it crashing? I doubt this is related to the thread setting unless you have them set so high that the footprint for each thread is exhausting the memory allocation range. Do you have a core file? If so, what is the stack trace in the core that caused the crash? What is the memory utilization at the time of the crash? What are the last entries in the filter, escalation, api, and arerror log files? What signal does armonitor.log show that arserverd exited with? Is a stack trace available in the arerror.log file? Axton Grams On Sun, Nov 8, 2009 at 9:42 PM, Raj ravi6...@gmail.com wrote: Hello All, Was wondering, where to find more information on optimum thread value settings/dependency in the ports and queue tab of server information ? Our production server is crashing, so just as a debugging/ troubleshooting aspect trying to make sure that the thread values are properly set. Thanks, Raj ___ 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: Q: Process Timeout Limit v7x
You can fork the process, in which case your workflow will not wait on the completion of the forked process. This done using a run process action. In this way you are not bound to the timeout limits, but it may not fit your need. Axton Grams On Fri, Nov 6, 2009 at 6:37 PM, Craig Carter craig.car...@arpc.denver.af.mil wrote: ** All, When setting the process timeout limit in the administration tool, the maximum value is 60 seconds in v7.01. We’re performing reporting and transmission processes that sometimes take longer than that. Does anyone know of a way to increase that limit or has this limit been increased in later versions? I know we could increase the “Set-Process-Timeout” value directly in the ar.cfg file but I would expect that to get overwritten the next time we make changes in the administrator tool (it still shows 60 even if it is set to 120 in ar.cfg). It would be great if you could specify a timeout value when you spawn a process but since it’s a single setting, we’re fine with increasing it overall if it works and we can make it stick. //SIGNED// Craig Carter Information Technology Manager, RSP _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: Multi-group question
Email engine connects as Remedy Application Service, which is an admin user, therefore it sees all rows. Axton On Fri, Oct 30, 2009 at 1:37 PM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi All and Happy Halloween, I have an interesting situation with email under a row level security environment. I have row level security (112) of either YES or NO. User A belongs to the HelpDesk and YES groups. User B belongs to the HelpDesk and NO groups. When I assign a ticket to the HelpDesk group an email is sent to all group members. If the value in field ID 112 of the ticket is YES, will USER B get an email? ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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: AR System Email Messages Form
Truncate the db tables that store the email error logs. Axton Grams On Thu, Oct 22, 2009 at 9:22 AM, John Kelley john.kel...@dunkinbrands.comwrote: I just deleted the error logs. I reopen my Messages form and it still takes over a minute to open the form in search mode to display only one item. Any other suggestions? Could it be thread settings for email? Here is what I have set. Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 4 10 Private-RPC-Socket: 390626 2 4 Private-RPC-Socket: 390627 4 4 Private-RPC-Socket: 390635 4 10 Private-RPC-Socket: 390650 4 6 *Chowdhury, Tauf tauf.chowdh...@frx.com* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 10:07 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form Yes... but make sure you don't need the logs. Is this a production system? If you are not sure, you may want to export them first to .arx. -Original Message- From: Action Request System discussion list(ARSList) on behalf of John Kelley Sent: Thu 10/22/2009 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/22/2009 06:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AR System Email Messages Form ** What I?ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley john.kel...@dunkinbrands.com wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _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_ * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free
Re: Email won't stop on server shutdown -RESOLVED
There are several programs that try to use the same port for RMI. FB, email, maybe the java based plugin server. RMI is a concept commonly used by BMC for java daemons to allow remote management of the process. Axton Grams On Thu, Oct 15, 2009 at 2:36 PM, William Rentfrow wrentf...@stratacominc.com wrote: BMC Support just confirmed that separate instances of the email daemon runnning on the same server need to have a unique RMI port defined in the EmailDaemon.properties file. This is undocumented as far as I can tell. I changed the RMI port and stuff started working as expected. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng Sent: Thursday, October 15, 2009 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: Email won't stop on server shutdown Form what I remember the default RMI port is 1099. You will find it in the EmailDaemon.properties file.. -- Jarl 2009/10/15 William Rentfrow wrentf...@stratacominc.com: Thanks for the confirmation. Killing it is easy enough - that's what we've been doing. I think I might have found another clue. At this point we have a total of 5 virtual Solaris machines running on one piece of hardware (more actually, but 5 Remedy servers). I just noticed that only a few of them can have the email engine running at a time as well. If I try to manually start the one I'm having problems with (which will start normally) it says the email engine is already running. The script is looking at the right install path and then pinging the RMIPort defined in EmailDaemon.properties. I suspect that since the RMIPort is the same for all servers (just confirmed that) we're having issues. What's the RMIPort? It's not in the documentation as far as I can tell. And does it have to be different if you have various email engines running on the same server? That would make senseI know the Remedy servers themselves have to be on different ports (obviously...). William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of PRUITT, CHRISTOPHER Sent: Thursday, October 15, 2009 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Email won't stop on server shutdown We have the same issue. This is how we have to manually stop the AREmail engine on Solaris. ► Open a Telnet Session to the server ► At the prompt enter the following command: ps -ef|grep AREmail ► Results look like this: ► Find the Process ID, for example above it would be 13089 ► At the prompt enter the following command along with the Process ID: kill 13089 and press Enter. This works for us. Not sure why we have to do this. However, we did find that stopping in AR System Administration: SystemEmailMailbox Configuration, does not always stop it. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Thursday, October 15, 2009 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: Email won't stop on server shutdown You're right - I botched the description below. The arsystem stop script + command runs and kills everything - except, of course, the email daemon. The stop section of the arsystem script appears to try to kill everything based off of the parent process ID. I'm not a script guru by any means but I can tell that the stop process is not calling emaild.sh stop. This is almost identical to 4 other servers we have running in the same configuration where I do not have this problem and I can't find any difference between them. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C -Original Message
Re: ARInside 3.0 Beta
SQLite is well suited for these types of applications. It has no engine (process) that runs, just a flat file with a client that can be used to access it using standard SQL syntax. It is available as a work released into the Public Domain. http://www.sqlite.org/ Axton On Fri, Oct 9, 2009 at 11:37 AM, LJ Longwing lj.longw...@gmail.com wrote: ** Well Jason, many hands make light work :)so I encourage you to dust off your C++ skills and join us on a worthy journeythe DB I was referring to was more of a flat file kinda thing that wouldn't need an enginebut hmmm...what about it having an option of being a Remedy app that stored its stuff in forms?who knows if that would workone of the things I always loved about ARInside when I was a simple user was the ability to 'deliver' documentation to a client for a product I developedI gave them a CD that contained all of the design docs, etc...with a folder for the documentation...it was awesome...I dunno...would it be better to have less files, but the same information?...like maybe all field information for a form was in a single file with bookmarks instead of each field having its own file... From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Friday, October 09, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: ARInside 3.0 Beta ** On the subject of keeping a db... What is the feasibility of storing the data in a db vs. +100k html files at over 1gb of disk space (and this isn't even ITSM 7)? I would think if the object id's are maintain in a db then the data could be normalized and alleviate all of the data that is now being duplicated to link all of the html files every which way. This could also add searching capabilities. The down side I see is now this is another db/web app that administrators need to maintain instead of a ton of dumb html files you place on a web server. However... With a full blown app maybe you could do such things as keep previous version and restore/migrate straight to a server? Now that I have thrown all of that out there I guess I should pick up C++ again so I can help out. Jason On Fri, Oct 9, 2009 at 7:35 AM, LJ Longwing lj.longw...@gmail.com wrote: Hey Misi, Before I got into the code, I wondered the exact same thing, unfortunately the ability to do that is limited with the current design. As ARInside grabs objects from the server (in the order it grabs them, which can be different each time), it assigns an 'internal id' to the object, and that internal id is what it uses to process objects. To do a 'difference' run you would need to keep a db of some sort around of what your object id's were for your last run, and then assign them back to the same id's on the next run. It's definitely possible, but is a rewrite of a significant part of the code I thinkthat's not to say it won't be done, just that it won't be 'now'...:)if you want, please feel free to log it as an enhancement request though :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Friday, October 09, 2009 1:15 AM To: arslist@ARSLIST.ORG Subject: Re: ARInside 3.0 Beta Hi, In theory, it should be possible to leverege the modify-time of the server objects to do an incremental update of the previous run. All ARGetList*()-functions has a last-modify-date parameter, to allow retrieval of changed objects. You will also need to remove any objects that has been deleted. This would be a really good improvement on performance. I have not looked at the code (yet...) though. 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. We ran it against a 7.1 and 7.5 server with Help Desk, SLA 6 and a ton of custom apps with no issue. I didn't notice any change in performance. The batch file we use to kick it off logs the start and stop time. It still averaged about 4.75 hours for both servers. It is much cleaner now with the default of not being verbose and the web service stuff looks great! Thanks for keeping this alive. Jason On Thu, Oct 8, 2009 at 1:04 PM, LJ Longwing lj.longw...@gmail.com wrote: Definitely good to hear. We are apparently having issues with some 7.5 ITSM that we are working on, but that's the only issue we have encountered thus far. We have also added web service setfield input/output mapping information, so you can now see what fields are mapped to what elements -Original Message
Re: End of Life for BMC(R) Remedy(R) User (Windows-based client)
When you use the Remedy User Tool, you go to the RUT, then you go to the ARServer. When you use the MT, you go to the MT, then you go to the ARServer. The location of the client is just different; instead of your workstation, it is a j2ee platform on a server. Axton On Fri, Oct 2, 2009 at 3:05 PM, Brittain, Mark mbritt...@navisite.com wrote: ** Here’s something to think about. When you are using the RUT, you are going directly to the ARS Server. If the RUT is done away with, you have to go from your desk top to the mid-tier to get to the server. I look at this as one more point of failure. One area that it would help is not having to worry if the end users are on the current version/patch of the RUT. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Friday, October 02, 2009 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: End of Life for BMC(R) Remedy(R) User (Windows-based client) Thanks for the clarification David. However, I just logged into our production system, and the change form (CHG:Infrastructure Change) does not show this on search mode. Do I need to enable something? We have ITSM 7.51 Thanks Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Easter, David Sent: Fri 10/02/09 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: End of Life for BMC(R) Remedy(R) User (Windows-based client) Ø This is not true. For instance, there are no Recent Searches or My Searches on the mid-tier Just a quick correction - yes there are. BMC Remedy Action Request System 7.5.00 BMC Remedy Mid Tier Guide 16-Jan-2009 PDFhttp://documents.bmc.com/supportu/documents/53/72/95372/95372.pdf Page 144: To run a saved, recent, or defined search 1 From the toolbar, choose Searches Run My Searches, Run Recent, or Run Defined. [cid:image003.png@01CA4357.44051540] -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Friday, October 02, 2009 9:45 AM To: arslist@ARSLIST.ORG Subject: Re: End of Life for BMC(R) Remedy(R) User (Windows-based client) ** This is very very bad. Here are some statements that are not true in our environment, where wer are using RS 7.5, Mid-tier, ITSM 7.5.1: I've heard that use of a thick client is the only way to get good performance. What will happen to performance if I can't use the Remedy User client anymore? o Due to advances in web technologies, especially in the area of JavaScript engines, the performance of the web client in AR System 7.5.00 running in a modern browser equals or exceeds the performance of BMC Remedy User. BMC expects, therefore, that any future client will meet or exceed any performance characteristics of the existing Remedy User client. THIS IS NOT TRUE. The Remedy user tool 7.5 performs faster than mid-tier 7.5/browser. Granted IE 7.x is a piece of crap, so that's a big part of the problem; However, the Remedy fat client still outperforms even Firefox 3.x. Pre-caching in ITSM 7.5.1 and Mid-Tier 7.5 is a major headache and it is buggy. Will I lose any functionality using the new client as compared to my use of Remedy User client? No. The future client provided will enable full usability of AR System or applications built on AR System. The manner in which such usability is provided may change (e.g. OLE/DDE are not available on web-based clients and report macros are accomplished through saved searches) but full functionality will be provided. This is not true. For instance, there are no Recent Searches or My Searches on the mid-tier -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Jarl Grøneng Sent: Fri 10/02/09 12:22 PM To: arslist@ARSLIST.ORG Subject: End of Life for BMC(R) Remedy(R) User (Windows-based client) BMC Remedy AR System 8.0.00 is expected to be the last major release of AR System to include the Remedy User client. http://documents.bmc.com/products/documents/61/94/106194/106194.pdf -- Jarl ___ 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_ ___ UNSUBSCRIBE or access ARSlist Archives
Re: End of Life for BMC(R) Remedy(R) User (Windows-based client)
I agree with your assessment that the MT trying to do the same thing as the user tool; I do not this it makes for a good web experience at all; multiple browsers running to access a single web application results in poor usability. A change to a different design would require a whole paradigm shift in thinking and designing applications; a separation of the model and the view, if you will. It opens the doors to a lot of things, but would be a drastically different way to look at things as compared to the way people are accustomed to thinking about Remedy when they design applications today. Axton These are my opinions only and do not represent those of BMC Software, Inc. On Fri, Oct 2, 2009 at 12:44 PM, John Sundberg john.sundb...@kineticdata.com wrote: I feel it is a great move. BMC (or others) will produce tools to fill gaps (alerts/reporting/macros/printing) blah blah blah. In fact all those tools already exist -- they just may not yet be incorporated/integrated. (I would venture to say that there are already 1000x as many tools for our new user tool (the web) as exist for our current WUT) (I will guess approx 50 tools exist for the current WUT -- easily 50,000 tools exist for web stuff) Alerts -- growl/rss Reporting -- 100+ flash strategies + HTML5 SVG is getting better all the time Macros -- greasemonkey Printing -- ??? -- I forget what I use - but it works just fine. OLE/DDE -- client back to server -- back to client stuff -- would be doable -- if not you can solve the problem some other way altogether. I personally don't think the MT is a good web strategy -- but it too will have to change -- and again -- that is a good thing. (precache and very dynamic screens have issues and always will) -- more rigid screens will greatly improve things (FYI -- what Kinetic Request does) The MT is currently tasked with doing the same thing as the WUT but via the web. I think the whole paradigm is ripe for change. The WUT is a very raw experience and you can get quite close to the database (developers think that is good/power users think that is good/avg person is confused). I think the tools and applications need to raise up a bit and be more process oriented and more application oriented -- which by nature avoids the needs for things like: saved searches copy to new clear all those above functions should be done by the application and not the user tool -- because a saved search or a copy to new is really application specific. Example: copy to new -- do you want to copy all 100 fields (hidden ones) -- or only 5 fields -- the current will do all. saved search -- searches are just criteria -- the app should be able to provide that clear -- this has always sucked!!! I like that BMC is attempting to move the product in a direction -- good for them. You can't make everybody happy -- you can only do what you feel is the right way -- and sometimes it causes pain -- the goal is long term betterness. (made that last word up) Lets discuss at WWRUG... sign up here: http://kineticsr.kineticdata.com/kinetic/DisplayPage?name=WWRUG2009REGISTRATION -John On Oct 2, 2009, at 11:22 AM, Jarl Grøneng wrote: BMC Remedy AR System 8.0.00 is expected to be the last major release of AR System to include the Remedy User client. http://documents.bmc.com/products/documents/61/94/106194/106194.pdf -- Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com ___ 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: sun4v architecture
Many thanks :) I am in the planning process right now. sun4v seems to be a superset of sun4u, so I wasn't expecting any issues, but wanted to get a feel from the people that have been there. Axton On Tue, Sep 29, 2009 at 9:07 AM, Danny Kellett danny.kell...@strategicworkflow.com wrote: Axton, We are. 4 T2000 in a server group. ITSM 7.03 All seems ok and has been since Jan 2008. Anything in particular? Regards Danny -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: 28 September 2009 19:51 To: arslist@ARSLIST.ORG Subject: sun4v architecture Is anyone running ARS on a sun4v architecture? This architecture is used for the coolthreads boxes (T2000, T5120, T5440, etc.). Please let me know if things are working as expected. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are __ Information from ESET NOD32 Antivirus, version of virus signature database 4466 (20090929) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4467 (20090929) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ 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: sun4v architecture
I am looking to run 7.5 on a pair of t5120's. Since 7.5 is 64-bit I am hopeful that I can make full use of the boxes. We have around 4000 concurrent users during peak usage, so there is definitely a demand on the resources. Trying to do the juggling of how to slice the boxes though. How many concurrent users do you have on the t2000? Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Tue, Sep 29, 2009 at 2:19 PM, Wallace, Kelvin wall...@doacs.state.fl.us wrote: Axton, I have been running Remedy on a T2000 for a couple of years now. It does fine, but the box itself is under-utilized. I started virtualizing that box using Solaris zones a few months ago, and Remedy is still happy. We did get several T5220s a few months back and had issues with firmware (system hangs) - make sure you update to the latest firmware level. HTH, Kelvin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Monday, September 28, 2009 2:51 PM To: arslist@ARSLIST.ORG Subject: sun4v architecture Is anyone running ARS on a sun4v architecture? This architecture is used for the coolthreads boxes (T2000, T5120, T5440, etc.). Please let me know if things are working as expected. Thanks, Axton Grams ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
sun4v architecture
Is anyone running ARS on a sun4v architecture? This architecture is used for the coolthreads boxes (T2000, T5120, T5440, etc.). Please let me know if things are working as expected. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Major 6.3 Migration Project
Knowing the source character set would help in assessing this. Changing the column length semantics from byte to char will take care of part of the problem...but may introduce other problems (e.g., view forms that use the entryid from a remedy view/table as the entryid in the view form). In a past life, I had a stored procedure that looked for 8-bit characters and converted them to the proper representation for the target character set. It may be possible to set the NLS_LANG during exp/imp to address the codepoint conversion, but I am not sure. For the workflow objects that contain the special characters in a column used to generate the checksum, those need to be cleaned up through the Remedy api. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Sep 18, 2009 at 2:45 AM, Walters, Mark mark_walt...@bmc.com wrote: There are possible problems with the db conversion to Unicode suggested here; *** 3. Convert the db character set/transport the data 1. Empty the temp new database with AL32UTF8 character set 2. Exported (exp utility) the data from original database (source) with the source character set 3. Copy the dump to the new server 4. Import (imp utility) the data into the new database(destination) with character set AL32UTF8 *** Whether this would be successful depends on whether you have accented characters stored as user data and/or as part of the ARS metadata (form/workflow object names and workflow actions). If you have characters in your user data that would require multiple bytes to store (European accented characters for example) in a Unicode database you MAY find that the data gets truncated when converted as the arserver treats all field lengths in terms of bytes. For example a field with a length of 10 that contains this data in the non-unicode system - testätestä - would require 12 bytes to store in a Unicode db. (ARS 7.5 does have some enhancements in this area but they need to be applied manually at the field level.) The metadata issue is a problem because the serialised strings used by ARS to store form/workflow information includes string lengths and this will not be modified by a conversion at the database level. Example - a form called TESTä would have entries in the server data dictionary where the string length of 5 is encoded. After conversion to Unicode this string would require 6 bytes to store and the server would encounter errors when loading and parsing the data during the cache load on startup. This is likely to leave you with forms that are not accessible via ARS. If you are absolutely certain you have no characters that would need multiple bytes to store in a Unicode db then the db conversion may be an option but I would strongly recommend that you export/import forms/workflow and data using ARS tools instead. Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: 18 September 2009 03:55 To: arslist@ARSLIST.ORG Subject: Re: Major 6.3 Migration Project Assumptions I am making: - You are running custom applications (not sla, itsm, cs, crm, etc.) - You do not have any external api's (plugins, external binaries compiled for Solaris) on the ar servers - I would go with something along these lines: 1. Build the new 7.5 servers: 1. Install the prerequisite software (db client, java, etc.) 2. Install ARS 7.5, point it at an empty database that uses the AL32UTF8 character set 1. Install subsystems in use (email, approval, etc.) 3. [1] Manually apply your form/field/permission changes to the core forms and grab a def 4. [2] You will need a load balancer, get it set up properly, get the server group set up properly 2. Migration preparation 1. Install the 64-bit 10g oracle client on the old arserver(s) 2. Empty the contents of the new db instance 3. Migration: 1. Upgrade the existing 6.3 server to 7.5 1. Perform a minimal installation (ARServer only) 2. Stop AR on the new and old servers 3. Convert the db character set/transport the data 1. Empty the temp new database with AL32UTF8 character set 2. Exported (exp utility) the data from original database (source) with the source character set 3. Copy the dump to the new server 4. Import (imp utility) the data into the new database
Re: Oracle 11
Speaking from past experience, each major version of the ARServer supports one version of the Oracle client. For 7.x, this is the 10g client. I would expect that in a later major version release, ARServer will support a later version of the Oracle client. The reason that only one Oracle client is support is because when ARServer is compiled, it is linked against a specific version of the Oracle client. Support for multiple versions of the Oracle client by ARServer would require a separate build and it has not been the general practice to have multiple builds of ARServer for a given version with the exception of platform and db flavor. On the db server, you should be safe using 9i, 10g, or 11g as Remedy does not utilize any features specific to the database server that would warrant the use of a specific version. These are just my observations based on past experience and do not imply any future direction of the Remedy product line. Please consult the product compatibility matrix to ensure you are running a supported configuration. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Sep 18, 2009 at 8:02 AM, Walters, Mark mark_walt...@bmc.com wrote: ** Oracle 11g is a supported database for ARS 7.5 but note that you still need to use an Oracle 10g client for the server to connect. This is covered by the “or higher” clause in the 7.5 compatibility matrix. http://media.cms.bmc.com/documents/AR_System_7_5_00_Compatibility_Matrix_v1021.pdf Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Patrick St-Pierre Sent: 18 September 2009 13:21 To: arslist@ARSLIST.ORG Subject: Oracle 11 ** Hi list Did someone know when BMC will support oracle 11 ?, i hear they are suppose to support it only in 7.5 version, but when ? And did you hear the same thing ? thanks _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: Major 6.3 Migration Project
How long would RRR|Chive take to move a 700gb db? Thanks, Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Fri, Sep 18, 2009 at 10:48 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Let me know off list, and I will get you the newest RRR|Chive version that is much faster in syncing two systems. I would to it like this: 1. Do a new install of the new server 7.1/7.5 2. Import your custom groups 3. Import your custom forms using def-files 4. Analyze your core form customizations (probably some permission-settings at least) 5. User RRR|DefHideExpandBox to get rid of the expand-box on field 2, 4 and 5 6. Use RRR|Chive to SYNC the data from your old production to the new production server 7. Test and fix 8. Do a new RRR|Chive SYNC which will be much faster than the bulk transfer 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. Paul, I would recommend a fresh install of everything in the destination. I recommend this because migration from version/platform will be extremely difficult. Particularly problematic will be your conversion from non-unicode to unicodeI do not believe this can be done easily...so I would recommend first setting up your 11G DB, then installing Remedy 7.5 in their respective environments. Then doing a selective code migration from existing to new. Selective in that much has changed between 6.3 and 7.5...I would avoid migrating 'core' forms, instead re-customizing them manually. I recommend 7.5 instead of 7.1 because in less than a years time 7.1 will be R-2, which means it will be reaching it's end of support life, best to migrate to current 'R' and in a years time be slightly behind the curve instead of significantly. Regarding data, I would suggest you look into 'rrrChive'...a tool produced for free from RRR and has been used by many on the list including myself successfully in the past. This will allow you to move the data you care about into your newly setup server and forms with relative ease. Once you have the simple system setup, then install your second remedy server and get server groups configured and functional. Regarding 'hot backup' of your data, I have never personally worked with a hot backup db server and associated app serverthe closest I worked on personally was an HP HA cluster with two nodes each capable of running both db and app, but connected to a raid5 san...so if any single piece of hardware were to fail it would switch to the other, or in the case of disk, simply wait for the replacement to be put in. I have been involved in countless disaster recovery discussions, but none have ever come to fruition for me, so I fear I can't speak authoritatively on that subject. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Paul Blasquez Sent: Thursday, September 17, 2009 6:05 PM To: arslist@ARSLIST.ORG Subject: Major 6.3 Migration Project ** Hello, I have been tasked from moving our current production installation to a more robust/modern installation. Any and all help would be appreciated! Currently: -AR System 6.3 custom server (with modifications to forms User and AR System Email Messages) -Oracle 9iR2 non-unicode -Solaris 9 -Application and Database reside on the same machine Goal: -AR System 7.1 or 7.5 (With form modifications intact) -Oracle 11g unicode -Linux Redhat 5 -Application and Database on different machines -Disaster Recovery (DR) backup site (Using Oracle log-shipping) -Local High Availibility (HA) backup server (server groups?) I have at my disposal 4 Virtual Machines (VMs) to do development and testing, with an additional 2 VMs and 2 dedicated servers (for the DBs) reserved for the final production installation. (Please note that there will be Midtier servers involved in all of this, but their deployment is trivial so I'm not including them here.) From my point of view I see that multiple operations must occur for this migration to be successful (in no particular order): 1) The Oracle 9iR2 DB -Must be upgraded to 11g -Must be translated into Unicode -Must be moved from the Solaris 9 machine to the Linux RH5 machine 2) The current 6.3 installation -Must be upgraded to 7.1 or 7.5 -Must be configured for server groups -Must be moved from the Solaris 9 machine to the Linux RH5 machine
Re: Indexing help
Don't rely on guess work to determine whether the db uses the index or not. More than likely, if you have index ABC and you search on ABC, the db will not use the index. If you have separate indexes on A and on B and on C, then the db has the choice of which indexes it wants to use. With Remedy there is no way to pass hints to the db to instruct it to use a given access method, so you have to rely on the mechanism within the db to make the best decision. Unfortunately, this is easier said than done. The db relies on statistics about a table/index/data to determine the best method of access. In oracle terms, this includes statistics collection on the table and the index. Make sure that during your evaluation of how the db works with the indexes that the statistics are in line with what you will have in your production environment. On Oracle, you can evaluate the various options by setting up the indexes/stats as needed, enabling autotrace, then executing your statement. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Sep 17, 2009 at 9:30 AM, Brittain, Mark mbritt...@navisite.com wrote: ** Good morning, I think I inherited a mess and need some help with indexing. If I have an index Status Assigned Group Assigned Person And the query is Assigned Group and Assigned Person does the index get ignored because Status was not used? What if I have similar indexes like these Index 1 Status Assigned Group Assigned Person Index 2 Assigned Group Index 3 Assigned Person Are these redundant? Also is there and good information out there that really gets into the nuts and bolts of indexing? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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: Major 6.3 Migration Project
Assumptions I am making: - You are running custom applications (not sla, itsm, cs, crm, etc.) - You do not have any external api's (plugins, external binaries compiled for Solaris) on the ar servers - I would go with something along these lines: 1. Build the new 7.5 servers: 1. Install the prerequisite software (db client, java, etc.) 2. Install ARS 7.5, point it at an empty database that uses the AL32UTF8 character set 1. Install subsystems in use (email, approval, etc.) 3. [1] Manually apply your form/field/permission changes to the core forms and grab a def 4. [2] You will need a load balancer, get it set up properly, get the server group set up properly 2. Migration preparation 1. Install the 64-bit 10g oracle client on the old arserver(s) 2. Empty the contents of the new db instance 3. Migration: 1. Upgrade the existing 6.3 server to 7.5 1. Perform a minimal installation (ARServer only) 2. Stop AR on the new and old servers 3. Convert the db character set/transport the data 1. Empty the temp new database with AL32UTF8 character set 2. Exported (exp utility) the data from original database (source) with the source character set 3. Copy the dump to the new server 4. Import (imp utility) the data into the new database(destination) with character set AL32UTF8 4. Perform the upgrade installer for other core ar components (email, fb, approval, etc.) 4. Post-migration 1. Set up oracle data guard Footnotes: 1. A better option would be to update your applications so they do not rely on (any) changes to the core forms prior to the migration. 2. Load Balancer: You will require a hardware load balancer (BigIP, etc.) in front of the ARServers: - Enable session persistence based on the source ip address Special Notes: 1. Do perform this operation in a non-production environment prior to upgrading production and verify it works. Also, during this time, if you run into workflow problems, generate the defs necessary to apply to an upgraded system so that you can use them during your upgrade. Server Groups: Server groups will make the following operations easier, but is not required to run an HA arrangement with AR: - Object cache synchronization across all nodes - Subsystem failover between nodes (e.g., escalations) DR Failover: There are many approaches to this; the choice usually depends on the size of your wallet and the practices currently implemented for dr: - Using Oracle DG, the db should be available at the time you need to fail over - You should be able to image the AR VM's in the DR with a near mirror image of the production hosts (hostname can/may vary) - This can be done on the fly during a dr or maintained separately - You will need to create a runbook of the operations required to perform a failover in the event you do not have any type of automated failover in place. Tasks would include things like: - dns changes - fail over db to standby server - bring up ar servers Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Sep 17, 2009 at 7:05 PM, Paul Blasquez pblasq...@equinix.com wrote: ** Hello, I have been tasked from moving our current production installation to a more robust/modern installation. Any and all help would be appreciated! Currently: -AR System 6.3 custom server (with modifications to forms User and AR System Email Messages) -Oracle 9iR2 non-unicode -Solaris 9 -Application and Database reside on the same machine Goal: -AR System 7.1 or 7.5 (With form modifications intact) -Oracle 11g unicode -Linux Redhat 5 -Application and Database on different machines -Disaster Recovery (DR) backup site (Using Oracle log-shipping) -Local High Availibility (HA) backup server (server groups?) I have at my disposal 4 Virtual Machines (VMs) to do development and testing, with an additional 2 VMs and 2 dedicated servers (for the DBs) reserved for the final production installation. (Please note that there will be Midtier servers involved in all of this, but their deployment is trivial so I'm not including them here.) From my point of view I see that multiple operations must occur for this migration to be successful (in no particular order): 1) The Oracle 9iR2 DB -Must be upgraded to 11g -Must be translated into Unicode -Must be moved from the Solaris 9 machine to the Linux RH5 machine 2) The current 6.3 installation -Must be upgraded to 7.1 or 7.5 -Must be configured for server groups -Must be moved from the Solaris 9 machine to the Linux RH5 machine -Must begin connecting to the DB remotely instead of locally 3) The finished AR System 7.x installation and Oracle 11g DB -Must begin log shipping (Data
Re: ARS/ITSM 7.5 on Solaris/Intel box? On Sun's Virtual Box for Intel?
It will not work. Binary compatibility between sparc/intel platforms is not possible. Axton Grams On Tue, Sep 15, 2009 at 10:55 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi folks, I need to create a ARS 7.5/ITSM setup to play with. Preferably on Solaris. I have no Sun box readily available. I'm thinking of either using a dedicated Intel box with Solaris, or just use Sun's Virtual box on my existing Windows PC. (http://dlc.sun.com/virtualbox/vboxdownload.html) Anybody done either? ARS 7.5 compatibility matrix has bad news: Solaris running on x86 or x64 processors is not supported. But, is not the same as saying it will notwork, so I want to take my chances, unless somebody tells me...forget it. I'm not sure if code like ARS' written for Solaris is hardware dependent. Is it? What happened to abstraction? Searches I tried on arslist turned up nothing, so I have a feeling either I am wasting my time with this idea, or my search skills are not as good as i think they 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
Re: Remedy v7.5 Hardware Landscape - Suggestions??
I would suggest that you use the same platform for both production and non-production. VMWare can not run Solaris sparc, so that would be a problem. You could look into using Solaris zones, but if you go that route, I would suggest using Solaris zones in production as well. Also, the suggested platform is a 'lot' of machine for 500 concurrent users. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Sep 14, 2009 at 12:51 PM, Antonio Maradiaga antonio.rem...@gmail.com wrote: ** ARSList, Good afternoon. I wanted to know out there could please help out with some ideas for putting together a hardware landscape architecture proposal for a new Remedy v7.5 environment. Our client has asked us to come up with a to-be hardware landscape for a new Remedy v7.5 environment. The client has around 500 concurrent users but they support about 4500+ Remedy users. They're currently using the following modules on an ARS v6.3 server: - Help Desk - Knowledge mgr - Asset - CMDB v1.1 - Mid-tier The above modules and database currently reside on the same Sun Solaris server running Unix. The DB is an Oracle 9x db. As far as the new v7.5 environment, they're looking to use the following modules: - Incident - Problem - Knowledge Mgr - Asset - CMDB - Mid-Tier They would like to continue to use an Oracle DB on a Unix server for the DB, but want to breka out the ARS on a separate server. To help out, they have provided the following hardware for the v7.5 landscape: 2 Domains of 4 x 16 on M5000 Sun Server. They would like to use load balancing and the proposed hardware landscape for v7.5 will be for production only. They'd like to use VMWare instances for their DEV and QA environments. Another requirement would be to have a Disaster Recovery site for failover. Any suggestions would be most appreciated. Many thanks. ~Antonio _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: Moving ARS 6.3 - ARS 7.5
Migrator is going to be a haphazard approach as you will run into issues if there are conflicts on things like the user/group forms, some objects doesn't migrate (core fields on display only forms), plus it will take a long time to move things in that way. The best approach, in my experiences, is: 1. export the db from the old production system 2. import the db to the new db instance 3. Install ARS 7.5 on the new arserver and point it at the new db server; the installer should take care of the rest. This approach will take care of altering all the things in the db that are needed to run the newer version of ars, all your data will be there, and it will take much less time and be less problematic than going through the Remedy api. Some other things to check/consider when upgrading: - the character set of the new oracle instance; make sure you use what Remedy supports if youcheck plan on running in unicode (AL32UTF8). Many shops use other character sets (e.g., UTF8). - Make sure you install the 64-bit Oracle client Axton Grams On Fri, Sep 11, 2009 at 11:50 AM, Brittain, Mark mbritt...@navisite.com wrote: After thinking about this some more, I have one question. What if the new box has a different name? When we move to the new production box, this will likely not be an issue because we will keep the same name. But while we are testing our process with 2 development boxes they will have to have different names so they can both be on the network. Of course if I could use Migrator then it would not be an issue. However it makes no sense for me to pay a lot of money for something I will use for 30 days. Thanks Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, September 10, 2009 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Moving ARS 6.3 - ARS 7.5 Are you sticking with the same applications in Remedy? If so I would recommend building the new box, installing Oracle, copying the data from Oracle 9 (I think the Oracle utility is called Data Pump or something like that), and installing ARS 7.5 as an upgrade. Using the Oracle utility will also copy things like your Procedures/Functions and dbLinks to the new database. The DBAs here used the utility when we moved our databases from a Sun RISC cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, September 10, 2009 9:12 AM To: arslist@ARSLIST.ORG Subject: Moving ARS 6.3 - ARS 7.5 ** HI All, I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, install ARS 7.5 and the move the data over to the new server. Has anyone done this before? Any suggestions on the best way to move the data? Is there a better way? Thanks Mark Brittain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ 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: Looking for Oracle 8.1.7 client for Solaris 8
You should not have an issue using the OCI (part of the Oracle api that Remedy uses) against a 9, 10, or 11 server. Again, it's unsupported, but technically I do not see a reason it would not work. Axton Grams These are my opinions, nothing more, nothing less. On Fri, Sep 11, 2009 at 2:07 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, It is all about timing... I am planning to move to 7.5 just as soon as my provisioning group can get my new server in place. But we have some Sybase licensing issues that have necessitated a migration away from Sybase ASAP. So I am trying to make Oracle work with my existing 5.1.2 server while I wait. If that proves to be too difficult, we'll jump to 7.5 and Oracle. Back in the 5.1.2 realm, a kind soul out there did make the Oracle 8.1.7 client available to me (Thanks M!). Does anyone have a feel for whether or not this 8.1.7 client will work against an Oracle 10 server? The 5.1.2 compatibility matrix specifies Oracle server 8 or 9. I don't think 10 existed at the time. Is Oracle backward-compatible enough to support the 8 client? I realize that this configuration is totally unsupported... just hoping to save some time. Thanks. Larry On Sep 11, 2009, at 10:45 AM, Grooms, Frederick W wrote: I did some searching and it appears it is no longer available for download from Oracle. My best guess would be a Google search or to contact your Oracle salesperson. Is there any reason you have to stay on ARS 5.1.2? Fred Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-1893 FAX ___ 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: Deleting Demo account (UNCLASSIFIED)
Very old versions of some products required the Demo account during installation (Palm Link, Approval Server, others?) but I do not know of anything that works that way any more. This was in the 4.x years that this was the case. There are other accounts in the system that have default usernames, such as MidTier User, Remedy Application Service, AR_ESCALATOR, Distributed Server, and some others. Most of these have an option to change the default password and the later versions of Remedy (7.? and higher) require you to define a password as the default password can no longer be used. Axton Grams On Fri, Sep 11, 2009 at 3:18 PM, Nguyen, AnhThien Mr CTR NG NGB ARNG anhthien.ngu...@us.army.mil wrote: Classification: UNCLASSIFIED Caveats: FOUO Hello list, I hope this is a simple question, but somehow, it's giving me a heartache. I was asked since we don't use the Demo account for anything, could we delete the Demo account? My first response was just to leave it, however, security came in place and told that I will probably need to delete it. Default username generated by any system shouldn't be used at all. So, my question is: what impact would I have once I've deleted the Demo account? I have done this on my test server and it seems to be ok so far. Just thought I ask the list. Btw, I have several other accounts which I've created that have administrator permissions. Thanks in advance, Thien Classification: UNCLASSIFIED Caveats: FOUO ___ 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: Strange errors...help appreciated....
Turn on the escalation logs, if there is an action in the escalation that generates an error, you will see what/when in those logs. Axton Grams On Thu, Sep 10, 2009 at 1:06 PM, copits.rich...@bwc.state.oh.us wrote: ** Yep, but we’re drawing a blank as to where……thought someone else may have had this happen also.l… It was just strange that we didn’t find anything in any of the other logs…. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Thursday, September 10, 2009 1:47 PM To: arslist@ARSLIST.ORG Subject: AW: Strange errors...help appreciated ** 390603 indicates that this error messages are generated through an escalation. HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von copits.rich...@bwc.state.oh.us Gesendet: Donnerstag, 10. September 2009 19:44 An: arslist@ARSLIST.ORG Betreff: Strange errors...help appreciated ** Each day we seem to be getting the 4 error lines shown below right after midnight. There is no one here to be on the system to be doing anything. These errors are in arerror.log and occur at the same time each day. There aren’t any errors in any of the other log files. Any suggestions/help/information on what might be causing these errors? We’re stumped… Thanks!! Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not specified : AAS:ActivityInterface_Create : Company (ARERR 307) Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not specified : AAS:ActivityInterface_Create : First Name (ARERR 307) Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not specified : AAS:ActivityInterface_Create : Last Name (ARERR 307) Thu Sep 10 00:05:02 2009 390603 : : Required field (without a default) not specified : Location Company* (ARERR 45649) Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this 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
Re: how to add, modify or delete ars users using java API???????????
A user is an entry in the User form. You would use the respective create/update/delete methods for an entry to manipulate users. Axton Grams On Wed, Sep 9, 2009 at 10:44 AM, Llinares, Jordi jordi.llina...@hp.com wrote: ** Hello, I don’t know whether this is the right place to post this question. I have to develop a software module in java that has to be able to add, modify and remove users in ARS Remedy. I have been looking for code and now I’m able to log in and list the schema. However, I haven’t found any example related with these operations(add, modify and remove) and I don`t know how to do it. Could you help me please?? Thanks in advance, Jordi _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 list...
The mid-tier configuration page: /arsys/shared/config/config.jsp The mid-tier deployment directory: /path/to/midtier/WEB-INF/classes/config.properties Axton Grams On Tue, Sep 1, 2009 at 11:08 AM, copits.rich...@bwc.state.oh.us wrote: ** Where can I find the “valid server list” for the midtier servers? We have an app server and a web server setup and I’m getting an error that says it can’t find the server name in a “valid server list” on the midtier. Where can I find that list? Thanks! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this 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
Re: Copying AREA LDAP Plugin from one server to another
You have to register the plugin in ar.conf. Take a look at your source server and target server to identify the lines that are missing. Axton Grams On Fri, Aug 28, 2009 at 9:39 AM, Robert D Martin marti...@jmu.edu wrote: ** Dear List, We installed ARS 7.1 on our live system, and at the time we didn’t think we needed the AREA LDAP Plugin. But now we do, and we don’t want to do a re-install because of the risk that something will go wrong. But we do have the Plugin installed on our test arsystem. Is it possible to copy objects and data from the test system over to the live system? If so, what all needs to be moved and configured? We’ve copied over “arealdap.so” and “ardbcconf.so”, but when we try to create a new Vendor form, “ARSYS.ARDBC.LDAP” isn’t on the list of “Available Vendor Names.” (In fact, the choices that were there are gone, which means that we have messed something up.) Any advice? (ARS 7.1, RH Linux server, Oracle 10.2 db) _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: Copying AREA LDAP Plugin from one server to another
What all plugin(s) are you trying to move over? - AREA LDAP for authentication - AREA HUB to handle multiple authentication sources - ARDBC LDAP to handle reading data from an LDAP store via a Vendor form - ARDBC CONF to handle the configuration of the pre-built AREA plugin If you are trying to do the AREA authentication using the pre-built plugins, you need both the AREA LDAP plugin and the ARDBC CONF plugin. In addition to this, you will need to move the AREA LDAP Configuration and Configuration ARDBC forms for the AREA configuration form to work properly. Axton Grams On Fri, Aug 28, 2009 at 11:27 AM, Robert D Martin marti...@jmu.edu wrote: ** I should also add that “ardbcldap.so” is in “ /opt/remedy/bin” in both servers, and both ar.conf files have “Plugin: /opt/remedy/bin/ardbcldap.so” lines Dwayne *From:* Robert D Martin *Sent:* Friday, August 28, 2009 12:19 PM *To:* 'arslist@ARSLIST.ORG' *Subject:* RE: Copying AREA LDAP Plugin from one server to another Thanks, Axton. I should have included that in my email. The ar.conf files are identical, at least all the lines that start with “AREA-LDAP.” Dwayne *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Friday, August 28, 2009 10:46 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Copying AREA LDAP Plugin from one server to another ** You have to register the plugin in ar.conf. Take a look at your source server and target server to identify the lines that are missing. Axton Grams On Fri, Aug 28, 2009 at 9:39 AM, Robert D Martin marti...@jmu.edu wrote: ** Dear List, We installed ARS 7.1 on our live system, and at the time we didn’t think we needed the AREA LDAP Plugin. But now we do, and we don’t want to do a re-install because of the risk that something will go wrong. But we do have the Plugin installed on our test arsystem. Is it possible to copy objects and data from the test system over to the live system? If so, what all needs to be moved and configured? We’ve copied over “arealdap.so” and “ardbcconf.so”, but when we try to create a new Vendor form, “ARSYS.ARDBC.LDAP” isn’t on the list of “Available Vendor Names.” (In fact, the choices that were there are gone, which means that we have messed something up.) Any advice? (ARS 7.1, RH Linux server, Oracle 10.2 db) _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
Re: Copying AREA LDAP Plugin from one server to another
Then all you should need is this in the ar.conf: Plugin: /path/to/remedy/plugin/ardbcldap.so Then restart the plugin server. Enable the plugin logs and make sure the plugin is loaded properly. Axton Grams On Fri, Aug 28, 2009 at 1:24 PM, Robert D Martin marti...@jmu.edu wrote: ** Just - ARDBC LDAP to handle reading data from an LDAP store via a Vendor form. Dwayne *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Friday, August 28, 2009 2:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Copying AREA LDAP Plugin from one server to another ** What all plugin(s) are you trying to move over? - AREA LDAP for authentication - AREA HUB to handle multiple authentication sources - ARDBC LDAP to handle reading data from an LDAP store via a Vendor form - ARDBC CONF to handle the configuration of the pre-built AREA plugin If you are trying to do the AREA authentication using the pre-built plugins, you need both the AREA LDAP plugin and the ARDBC CONF plugin. In addition to this, you will need to move the AREA LDAP Configuration and Configuration ARDBC forms for the AREA configuration form to work properly. Axton Grams On Fri, Aug 28, 2009 at 11:27 AM, Robert D Martin marti...@jmu.edu wrote: ** I should also add that “ardbcldap.so” is in “ /opt/remedy/bin” in both servers, and both ar.conf files have “Plugin: /opt/remedy/bin/ardbcldap.so” lines Dwayne *From:* Robert D Martin *Sent:* Friday, August 28, 2009 12:19 PM *To:* 'arslist@ARSLIST.ORG' *Subject:* RE: Copying AREA LDAP Plugin from one server to another Thanks, Axton. I should have included that in my email. The ar.conf files are identical, at least all the lines that start with “AREA-LDAP.” Dwayne *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Friday, August 28, 2009 10:46 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Copying AREA LDAP Plugin from one server to another ** You have to register the plugin in ar.conf. Take a look at your source server and target server to identify the lines that are missing. Axton Grams On Fri, Aug 28, 2009 at 9:39 AM, Robert D Martin marti...@jmu.edu wrote: ** Dear List, We installed ARS 7.1 on our live system, and at the time we didn’t think we needed the AREA LDAP Plugin. But now we do, and we don’t want to do a re-install because of the risk that something will go wrong. But we do have the Plugin installed on our test arsystem. Is it possible to copy objects and data from the test system over to the live system? If so, what all needs to be moved and configured? We’ve copied over “arealdap.so” and “ardbcconf.so”, but when we try to create a new Vendor form, “ARSYS.ARDBC.LDAP” isn’t on the list of “Available Vendor Names.” (In fact, the choices that were there are gone, which means that we have messed something up.) Any advice? (ARS 7.1, RH Linux server, Oracle 10.2 db) _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_ _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: Workflow Documentation 7.1
64-bit version? Get a machine with more memory (4gbh)? Axton Grams On Wed, Aug 26, 2009 at 4:27 PM, Kathy Morris kathymorris...@aol.comwrote: ** I used the package list, and an XML file - and this keeps grabbing all the code into memory.I read the notes and it tells me to blacklist a package list to trim down the objects I am documenting.How can I prevent the entire ITSM suite from loading into memory. I only have 2 GIG memory. In a message dated 8/20/2009 10:27:52 A.M. Eastern Daylight Time, lj.longw...@gmail.com writes: ** Not effectively, because of the issues I mentioned. I would really appreciate if you went to ARInside.com and logged an defect discussing ITSM specifically, and gave any details you have regarding its crash when you try to document the entire thing. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kathy Morris *Sent:* Thursday, August 20, 2009 8:18 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Workflow Documentation 7.1 ** Then does this mean it is impossible for me to document the ITSM workflow using ARInside? I had to split the Active links in Package 1, and forms in Package 2 because when I run them together - I get exception errors. In a message dated 8/20/2009 10:12:48 A.M. Eastern Daylight Time, lj.longw...@gmail.com writes: ** The problem you WILL come across with merging is that ARInside performs its operations with an 'internal id', so in run 1 form 1 is ABC but in run 2 form 1 is DEF...so when you copy the two folders together you will be putting two different forms into the same folder, same with all of the other objects. One of the enhancements I plan on implementing at some point is to have it use form/workflow name instead of internal ID, this will solve several problems that I have, including the one I just discussed. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kathy Morris *Sent:* Thursday, August 20, 2009 8:03 AM *To:* arslist@ARSLIST.ORG *Subject:* Resolved: Workflow Documentation 7.1 ** Yes, I ended up creating packing lists and breaking it up - I believe it is the Blacklist in the settings.ini file. This resolved the issue. Now I am going thru and merging the file folders to see the code on one single HTML page. Yes you are absolutely right. In a message dated 8/19/2009 10:34:03 P.M. Eastern Daylight Time, lj.longw...@gmail.com writes: ** Kathy, Honestly, I've never worked with the ITSM suite nor run ARInside against it, but am one of the developers keeping the project alive. The way ARInside works is it loads all of the objects into memory, then cross references them to provide the output. I know there are LOTS of problems with doing things with the ITSM code base. One thing I can recommend trying however is to utilize the 'exclude list' functionality. The way this works is you create a packing list on your server that contains a list of everything you don't want it to document, that workflow is then excluded from the documentation output, and may make it possible to document 'part' of the system with less memory requirements. Please go out to arinside.com and open a ticket for the problem if you would like. Giving as much detail as possible so we can try to pinpoint a solution. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kathy Morris *Sent:* Wednesday, August 19, 2009 1:34 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Workflow Documentation 7.1 ** Do you need to more than 2 GIG of RAM to run this product - because the arinside executes, then freezes after about 1 hour, and then I get an exception error. Is this common with this tool. The exception error comes before the forms are generated in the HTML format. Active links/filters/applications are displayed In a message dated 8/19/2009 3:06:04 P.M. Eastern Daylight Time, jennifer.me...@its.nc.gov writes: ** ARInside: www.arinside.org Jennifer Meyer -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kathy Morris *Sent:* Wednesday, August 19, 2009 2:11 PM *To:* arslist@ARSLIST.ORG *Subject:* Workflow Documentation 7.1 Hi All, I am trying to run a tool to document our workflow on our system (AR 7.1, ITSM) on Windows. I had been using AR system, but the AL are displaying, but the forms are not displaying - is there another free tool I can use to document the workflow? -- _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third
Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form
6.3 does not support multiple localizations; back then a separate arserver was required for each localization set, though every localization set supported english. This may not even be a case of Unicode data. You can get garbage like that when applications perform illegal memory operations. Take a network dump of the ldap communication, examine all the data sent back to remedy, see if anything being sent exceeds the limits that Remedy supports (email address, login name, password, group list, notification method, etc.). If this is the case, the only recourse you really have is to upgrade the plugin, play with the available config parameters to avoid the data causing the issue, or write your own ldap area plugin. The libumem slab allocator on Solaris makes it easy to identify these types of memory issues... Not sure what options, if any, are available on Windows. Maybe someone can enlighten me. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Aug 24, 2009 at 11:38 AM, Lyle Taylor tayl...@ldschurch.org wrote: ** I don’t have an answer for Gary’s question, but wanted to point out that you shouldn’t need to install a foreign language pack in order to handle foreign characters. Remedy’s ability to handle foreign characters depends entirely on it being set up for Unicode. However, *Gary*, does this happen with any (e.g., all, most, some) record, or just a specific one? What kind of field is it querying in AD? Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Meyer, Jennifer L *Sent:* Monday, August 24, 2009 10:00 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Weird Unicode error in remedy when querying AD via the LDAP and a vendor form ** Does the user’s name perhaps contain a character that Remedy can’t read? For example, if you have installed the English language pack, but not the Japanese language pack, and the user has a Japanese character in his or her name, an error of this sort might occur. Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@its.nc.gov http://its.state.nc.us 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 *Opela, Gary L CTR USAF AFMC 72 CS/SCBAH *Sent:* Monday, August 24, 2009 11:48 AM *To:* arslist@ARSLIST.ORG *Subject:* Weird Unicode error in remedy when querying AD via the LDAP and a vendor form ARERR [9062] Error encountered during string conversion from Unicode : string ;yêÇÕáB¬b Ûã=·Ø Remedy 6.3 (no patch) Windows/Sql Server Has anyone seen the above error message when querying AD? Is there a fix that doesn’t involve patching? It only happens on some accounts, but on those accounts that it happens, it happens every time for those accounts. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ 405 739 7006 x30043 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are__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
Re: Remedy API and gcc on Redhat Linux
Glad to hear you got it working; much easier than compiling a compiler and running into the same problem with the new compiler :) Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Aug 22, 2009 at 2:50 AM, Conny Martin conny.mar...@t-systems.comwrote: ** Axton, you're right, there is a mismatch. The CFLAGS settings tells gcc to generate 32-Bit object files. But in LDFLAGS -m32 wasn't set. The linker is then trying to generate a 64-Bit binary. But libar.so is definitely a 32-bit binary. The 64 bit version is named libar_lx64.so Kind Regards Conny -- *Von:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *Im Auftrag von *Axton *Gesendet:* Freitag, 21. August 2009 21:36 *An:* arslist@ARSLIST.ORG *Betreff:* Re: Remedy API and gcc on Redhat Linux ** The libraries are provided in both 32-bit and 64-bit on the non-Windows releases of ARS 7.5. Page 64 provides additional information. http://documents.bmc.com/supportu/documents/53/84/95384/95384.pdf This looks like a mismatch between the 32/64 bit api and the CFLAGS you are using. See Lyle's message on how to straighten it out and set the flags properly. Axton Grams On Fri, Aug 21, 2009 at 1:40 PM, Conny Martin conny.mar...@t-systems.comwrote: ** libar.so is 32 bit-binary. The Makefile provided by BMC won't work unless you do a little customisation this one works for me. # # Parameters. PROGRAM = driver SOURCES = api.c get.c main.c print.c util.c OBJECTS = api.o get.o main.o print.o util.o # Compiler flags. CC = cc CFLAGS = -m32 -g -DDEBUG -D_REENTRANT -malign-double CPPFLAGS = -I../include -I../../include LDFLAGS = -m32 -L../lib -L../../lib LDLIBS = -lar -lnsl -lpthread -lncurses -ldl -licuucbmc -licui18nbmc -licudatabmc # Standard targets. all: $(PROGRAM) objects: $(OBJECTS) $(PROGRAM): $(OBJECTS) $(CC) -o $(PROGRAM) $(OBJECTS) $(LDFLAGS) $(LDLIBS) clean: $(RM) $(PROGRAM) $(OBJECTS) core --- There are also some libs missing in ar_install_dir/api/lib. So I copied them from ar_install_dir/bin libicudatabmc.so libicudatabmc.so.32 libicui18nbmc.so libicui18nbmc.so.32 libicuucbmc.so libicuucbmc.so.32 HTH Kind Regards Conny -- *Von:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *Im Auftrag von *Lyle Taylor *Gesendet:* Freitag, 21. August 2009 18:56 *An:* arslist@ARSLIST.ORG *Betreff:* Re: Remedy API and gcc on Redhat Linux ** In your build directory, run the following command and send us the output: file ../../lib/libar.so Your build options seem to be telling it to build a 32-bit executable, but 75 is 64-bit on Linux. The command above will verify whether libar.so is a 32 or 64-bit binary. If it’s 64-bit, then change -m32 to -m64 in your Makefile, do a make clean and then try building it again. Lyle _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: ARERR 9351 - Need Help
This is generally caused by something that blocks a request to the web server or a response from the web server. That is the path you need to analyze to find the cause. Some common things that may get in the way of the communication: - security plugins for your web server ( http://communities.bmc.com/communities/thread/24320%3Bjsessionid=AD04401CA86A9029A6AA1F4220038E7A ) - sso on your web server (alters response before it is sent back to client) - miconfigured load balancer (redirects users request to wrong web server) - network issues (dropped packets, routing issues, etc.) Axton Grams On Wed, Aug 19, 2009 at 1:20 PM, bruce sisk siskbr...@peoplepc.com wrote: Hello, We are experiencing a problem with our mid-tier users in that they get a 5-10 minute screen lock whenever they try to access the Incident management Console by clicking the link on the Home page. When the screen finally unlocks, they get the error: Unable to setup data connection, which is preventing the application from working correctly. (ARERR 9351) Environment: ARS 7.1 Patch 7 Oracle 10 (remote server) Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a load balancer) Users are browsing with both IE 6 and 7. We get the error in both. The problem is intermitent...not everyone is having the problem...those who have it don't have it all the time. Done so far: Have researched the issue on Remedy's KB...not much information. Have researched the issue on ARSList...several postings, but no solutions. Have opened an issue with Remedy support...we seem to just be sending them log files. Have tried to turn on client side logging for users having the issue...with logging turned on (setting through Preferences form), the issue completely goes away. Server side logging does not reveal any issues or errors. Have downloaded and installed Fiddler (a suggestion from the ARSList postings)...again, while logging through Fiddler, the issue completely goes away. Have downloaded and installed Firefox 3.5 the issue goes away. Some things we CAN'T do: IE is the official browser for this company, so Firefox is NOT an option. The Workflow logging window that opens with client side remedy logging is irritating people so that can't be considered a permanent solution. This is a plea for any insight or solutions from those who have had this issue in the past and what you did to resolve it. Thanks, Bruce Sisk BFS Enterprises PeoplePC Online A better way to Internet http://www.peoplepc.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: 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 API and gcc on Redhat Linux
The libraries are provided in both 32-bit and 64-bit on the non-Windows
releases of ARS 7.5.
Page 64 provides additional information.
http://documents.bmc.com/supportu/documents/53/84/95384/95384.pdf
This looks like a mismatch between the 32/64 bit api and the CFLAGS you are
using. See Lyle's message on how to straighten it out and set the flags
properly.
Axton Grams
On Fri, Aug 21, 2009 at 1:40 PM, Conny Martin conny.mar...@t-systems.comwrote:
** libar.so is 32 bit-binary. The Makefile provided by BMC won't work
unless you do a little customisation
this one works for me.
#
# Parameters.
PROGRAM = driver
SOURCES = api.c get.c main.c print.c util.c
OBJECTS = api.o get.o main.o print.o util.o
# Compiler flags.
CC = cc
CFLAGS = -m32 -g -DDEBUG -D_REENTRANT -malign-double
CPPFLAGS = -I../include -I../../include
LDFLAGS = -m32 -L../lib -L../../lib
LDLIBS = -lar -lnsl -lpthread -lncurses -ldl -licuucbmc -licui18nbmc
-licudatabmc
# Standard targets.
all: $(PROGRAM)
objects: $(OBJECTS)
$(PROGRAM): $(OBJECTS)
$(CC) -o $(PROGRAM) $(OBJECTS) $(LDFLAGS) $(LDLIBS)
clean:
$(RM) $(PROGRAM) $(OBJECTS) core
---
There are also some libs missing in ar_install_dir/api/lib. So I copied
them from ar_install_dir/bin
libicudatabmc.so
libicudatabmc.so.32
libicui18nbmc.so
libicui18nbmc.so.32
libicuucbmc.so
libicuucbmc.so.32
HTH
Kind Regards Conny
--
*Von:* Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] *Im Auftrag von *Lyle Taylor
*Gesendet:* Freitag, 21. August 2009 18:56
*An:* arslist@ARSLIST.ORG
*Betreff:* Re: Remedy API and gcc on Redhat Linux
**
In your build directory, run the following command and send us the output:
file ../../lib/libar.so
Your build options seem to be telling it to build a 32-bit executable, but
75 is 64-bit on Linux. The command above will verify whether libar.so is a
32 or 64-bit binary. If it’s 64-bit, then change -m32 to -m64 in your
Makefile, do a make clean and then try building it again.
Lyle
*From:* Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] *On Behalf Of *Marty.Thorin
*Sent:* Friday, August 21, 2009 10:28 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Remedy API and gcc on Redhat Linux
**
Dear Axton:
Here is a listing of my Makefile (same as out-of-the-box), the run,
and a directory listing after the run.
Thorin
remedy75{xxremedy}57: more Makefile
#
# Parameters.
PROGRAM = driver
SOURCES = api.c get.c main.c print.c util.c
OBJECTS = api.o get.o main.o print.o util.o
# Compiler flags.
CC = cc
CFLAGS = -m32 -g -DDEBUG -D_REENTRANT -malign-double
CPPFLAGS = -I../include -I../../include
LDFLAGS = -L../lib -L../../lib
LDLIBS = -lar -lnsl -lpthread -lcurses -ldl
# Standard targets.
all: $(PROGRAM)
objects: $(OBJECTS)
$(PROGRAM): $(OBJECTS)
$(CC) -o $(PROGRAM) $(OBJECTS) $(LDFLAGS) $(LDLIBS)
clean:
$(RM) $(PROGRAM) $(OBJECTS) core
___
remedy75{xxremedy}58: make
cc -o driver api.o get.o main.o print.o util.o -L../lib -L../../lib -lar
-lnsl -lpthread -lcurses -ldl
/usr/bin/ld: skipping incompatible ../../lib/libar.so when searching for
-lar
/usr/bin/ld: skipping incompatible ../../lib/libar.a when searching for
-lar
/usr/bin/ld: cannot find -lar
collect2: ld returned 1 exit status
make: *** [driver] Error 1
___
remedy75{xxremedy}59: ls -l
total 1880
-rwxr-xr-x 1 xxremedy ftp 411821 Mar 10 04:03 api.c*
-rwxr-xr-x 1 xxremedy ftp 5906 Mar 10 04:03 api.h*
-rw-r--r-- 1 xxremedy ftp 314412 Aug 21 11:22 api.o
-rwxr-xr-x 1 xxremedy ftp 210747 Mar 10 04:03 get.c*
-rwxr-xr-x 1 xxremedy ftp 6902 Aug 7 15:08 get.h*
-rw-r--r-- 1 xxremedy ftp 153016 Aug 21 11:22 get.o
-rwxr-xr-x 1 xxremedy ftp 5727 Mar 10 04:03 globals.h*
-rwxr-xr-x 1 xxremedy ftp 65161 Aug 17 13:30 main.c*
-rwxr-xr-x 1 xxremedy ftp 19440 Mar 10 04:03 main.h*
-rw-r--r-- 1 xxremedy ftp 47636 Aug 21 11:22 main.o
-rwxr-xr-x 1 xxremedy ftp509 Aug 21 11:22 Makefile*
-rwxr-xr-x 1 xxremedy ftp 282759 Mar 10 04:03 print.c*
-rwxr-xr-x 1 xxremedy ftp 7934 Mar 10 04:03 print.h*
-rw-r--r-- 1 xxremedy ftp 200340 Aug 21 11:22 print.o
-rwxr-xr-x 1 xxremedy ftp 46470 Aug 14 19:24 util.c*
-rwxr-xr-x 1 xxremedy ftp 2054 Mar 10 04:03 util.h*
-rw-r--r-- 1 xxremedy ftp 31184 Aug 21 11:22 util.o
-rw-r--r-- 1 xxremedy ftp 1674 Aug 14 19:21 wfd_shared.h
rmdy-papr02.comp.wepco.com{xxremedy}60:
--
*From
Re: Remedy API and gcc on Redhat Linux
I'm not sure why you would need 4.4.1. Why don't you post the compiler/linker output and the build options. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Aug 20, 2009 at 4:24 PM, Marty.Thorin thorin.ma...@we-energies.comwrote: ** Good afternoon: I tried to compile the out-of-the-box program 'driver'. It compiled but would not link. When I asked BMC I was informed my copy of gcc (3.4.6) is too old and I need to upgrade to 4.4.1. I downloaded 4.4.1 today but it looks like I need to build the gcc compiler!?! This is not a small task. So I figure I must have done something wrong. Does anyone know where to download gcc 4.4.1 for Redhat in a tar or zip file? Thank you, Thorin _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: Installing Midtier 7.1 on Existing Apache/Tomcat Installation
Only caveats are the native libraries used by the Remedy Java api. These will need to be in the LD_LIBRARY_PATH when tomcat is started. Deploying the mid-tier is just like deploying any other j2ee war/ear/directory/application. Mid-Tier will run as the user that Tomcat runs as. For this reason, the files deployed with the application should be owned by that user so that the mid-tier config page can update the config.properties located in the WEB-INF/classes directory. Not sure what you mean by 'mid-tier will be installed as yet another non-root user.' Axton Grams On Mon, Aug 17, 2009 at 10:51 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi, I have Apache/Tomcat 2.2.8 in solaris already installed by sys admins. I'm trying to install Midtier 7.1 on top of it. All the documentation seem to assume that you are either trying to install mid-tier with the bundled apache/tomcat or that you already have another web server/JSP engine (other than apache/tomcat) and you are trying to install midtier only. Nothing on installing just Midtier when you already have apache/tomcat running. Any caveats not mentioned in the documentation? About permissions, apache/tomcat is started by root and then runs as non-root user (one httpd has root owner, others have web owner). Midtier will be installed as yet another non-root user. Besides issues with writing on httpd.config, any other issue I need to be aware of? TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Installing Midtier 7.1 on Existing Apache/Tomcat Installation
Tomcat is a process that runs as a user. Mid-tier is just a bunch of files that tomcat serves up. Not sure how to run a bunch of files as a user... It's akin to saying, I have a web server and I want to run my html pages as a different user. You can change the owner of the files that are the mid-tier, but if you change them in a way that the user that tomcat runs as can not update them, you will lock yourself out of making mid-tier configuration changes through /app/share/config/config.jsp. The closest you can get to running it as another user is running a separate instance of Tomcat altogether; one that is only used for the mid-tier. Axton Grams On Mon, Aug 17, 2009 at 8:15 PM, Rabi Tripathi ars_l...@yahoo.com wrote: Axton, I'm working in a very restricted environment with no root access and no ability to become the user tomcat runs as. So, I am planning to deploy midtier as a service a/c I have access to, which is different from the a/c tomcat runs as, and then have the right people modify files beyond midtier install directory. It's not very clear from the documentation what those updates are that need to be made to non-midtier areas in the system. I know about httpd.conf. They don't tell you how to update this file, but based on the unsintall part of the guide, I have a paragraph I am planning to have added to it. Besides, as you mentioned, I need to worry about my use of service a/c and whether tomcat will have any issue with it. I can ask to have midtier be deployed as the user tomcat runs as, but unless there is no other way, I don't want to go there. On Mon, Aug 17, 2009 at 7:46 PM, Axton axton.gr...@gmail.com wrote: ** Only caveats are the native libraries used by the Remedy Java api. These will need to be in the LD_LIBRARY_PATH when tomcat is started. Deploying the mid-tier is just like deploying any other j2ee war/ear/directory/application. Mid-Tier will run as the user that Tomcat runs as. For this reason, the files deployed with the application should be owned by that user so that the mid-tier config page can update the config.properties located in the WEB-INF/classes directory. Not sure what you mean by 'mid-tier will be installed as yet another non-root user.' Axton Grams On Mon, Aug 17, 2009 at 10:51 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi, I have Apache/Tomcat 2.2.8 in solaris already installed by sys admins. I'm trying to install Midtier 7.1 on top of it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Installing Midtier 7.1 on Existing Apache/Tomcat Installation
Sometimes I can't read... You can set up the file permissions as you see fit. There is no need for Tomcat to update the files that are deployed other than how the application tells it to, which in the case of mid-tier includes config.properties, cached plugins, attachments, reports and probably a few other things. Tomcat does however need to read all the files in the deployed application. I would suggest you simply not use the installer and grab the war file from the patch download page and deploy the war file. That would be a much easier route and will allow you or the admins to make the changes manually. Assume the following: - Tomcat runs as user tomcat who is a member of group tomcat - Your admins log in using a named account and are a member of the group midtier If you set up the ownership of all the files/directories in the deployed application as user tomcat and group midtier, you should be able to allow the application to perform updates to the files/directories and also allow the users to make updates to the files in the deployed application. This will probably require that you manually set up the permission mask properly on all the files and directories. I am trying to understand what exactly you are trying to accomplish with this. Is it just to run the mid-tier installer? Is it to allow future changes (patches/customizations) to the deployed application with a non-application owner account? Axton Grams On Mon, Aug 17, 2009 at 10:01 PM, Rabi Tripathi ars_l...@yahoo.com wrote: Hmm. I don't see where you find the run my html page as a user analogy. I understand midtier's files are not executables. My simple concern is that since Midtier files will be owned by a user different than the user tomcat runs as, I need to find a way to have tomcat work with this situation. I will experiment with permissions on midtier's files. I can change the group owner of the midtier files, so changing it to a group tomcat user is a member of and changing group permissions may do the trick. Besides this issue, I am trying to find out what I need to have them do with the httpd.conf. I will start with the section on updating httpd.conf for uninstalling midtier. Adding that part should work. Thanks for your comment. --- On Mon, 8/17/09, Axton axton.gr...@gmail.com wrote: From: Axton axton.gr...@gmail.com Subject: Re: Installing Midtier 7.1 on Existing Apache/Tomcat Installation To: arslist@ARSLIST.ORG Date: Monday, August 17, 2009, 9:24 PM ** Tomcat is a process that runs as a user. Mid-tier is just a bunch of files that tomcat serves up. Not sure how to run a bunch of files as a user... It's akin to saying, I have a web server and I want to run my html pages as a different user. You can change the owner of the files that are the mid-tier, but if you change them in a way that the user that tomcat runs as can not update them, you will lock yourself out of making mid-tier configuration changes through /app/share/config/config.jsp. The closest you can get to running it as another user is running a separate instance of Tomcat altogether; one that is only used for the mid-tier. Axton Grams On Mon, Aug 17, 2009 at 8:15 PM, Rabi Tripathi ars_l...@yahoo.com wrote: Axton, I'm working in a very restricted environment with no root access and no ability to become the user tomcat runs as. So, I am planning to deploy midtier as a service a/c I have access to, which is different from the a/c tomcat runs as, and then have the right people modify files beyond midtier install directory. It's not very clear from the documentation what those updates are that need to be made to non-midtier areas in the system. I know about httpd.conf. They don't tell you how to update this file, but based on the unsintall part of the guide, I have a paragraph I am planning to have added to it. Besides, as you mentioned, I need to worry about my use of service a/c and whether tomcat will have any issue with it. I can ask to have midtier be deployed as the user tomcat runs as, but unless there is no other way, I don't want to go there. On Mon, Aug 17, 2009 at 7:46 PM, Axton axton.gr...@gmail.com wrote: ** Only caveats are the native libraries used by the Remedy Java api. These will need to be in the LD_LIBRARY_PATH when tomcat is started. Deploying the mid-tier is just like deploying any other j2ee war/ear/directory/application. Mid-Tier will run as the user that Tomcat runs as. For this reason, the files deployed with the application should be owned by that user so that the mid-tier config page can update the config.properties located in the WEB-INF/classes directory. Not sure what you mean by 'mid-tier will be installed as yet another non-root user.' Axton Grams On Mon, Aug 17, 2009 at 10:51 AM, Rabi
Re: Customer Support 5.6 and the future
I am and plan to try. I will post my findings as they become available. Axton On Tue, Aug 4, 2009 at 2:41 AM, Jarl Grøneng jarl.gron...@gmail.com wrote: Hi, Anyone using Customer Support 5.6 and looking into upgrading to ar system 7.5? From how I see it; CS 5.6 does not run on 7.5 since SLA does not run on 7.5, and SLM is not compatible with CS 5.6. Regards, Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARInside
The site addresses for ARInside are: http://arinside.com http://arinside.org I worked with LJ, Stefan (original author), Carey, and a few others to bring this together. I am acting as nothing more than the sys admin for the site for the time. I would encourage anyone who has c++ skills and an appetite for open source software to register an account on the site and get in touch with LJ to keep this great piece of software alive and growing. There are a lot of ways in which this software could grow, imagination and time are really the only limiting factors on where this software can go. The site currently includes the following services: - Subversion (source control) available at http://svn.arinside.org - Trac web front-end (ticket tracking, file downloads, wiki area, roadmap, etc.) I will be adding the following services in the near future: - mailing lists: - general discussion: just as it's named - source changes: mail commits - announcements: low volume, release announcements, pr, etc. Please feel free to report issues and request enhancements using this site as it is the home of ARInside. Community involvement will be the driver for addressing these issues, so feel free to get involved as you see best. LJ is acting as the lead for this project to get things moving so please reach out to him for any special requests or contributions. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Aug 1, 2009 at 10:09 PM, LJ LongWing lj.longw...@gmail.com wrote: ** All,As many of you may have noticed, ARInside was recently donated to the public domain. This means that the project doesn't hafta die on the vine, but unfortunately we need some skilled C programmers to help with feature requests and bug fixes. While I am a programmer, I don't know C (yet) and I need some help from the generous community. There is already a short list of known bugs and requested features and I need some reliable programmers that are willing to help out with this project. Axton has been kind enough to setup some stuff over at ARInside.org for us. Anyone interested in becoming a part of the project, please contact me. There are mailing lists that can be subscribed to where we will start discussions regarding the future of the project. Please let me know if you have questions/comments/concerns. _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: ARInside
The ARInside mailing lists are now available. There are 3 lists: arinside-misc: general discussion arinside-src: system generated commit messages arinside-announce: used for announcements (releases, etc.) The lists are accessible here: http://lists.arinside.org/mailman/listinfo I strived to set up the mail server so most common mail providers do not flag the messages as spam. I am using spf (sender policy framework) and dkim (domain keys identified mail) to accomplish this. If you run into issues where you do not receive mail or your mail provider flags the message as spam, please send that information to me so that I can work to correct the issue. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Aug 3, 2009 at 5:05 PM, LJ Longwing lj.longw...@gmail.com wrote: ** Jason, Please feel free to go in and open enhancement requests for features you would like to see. As this project gets off the ground we will be needing to upgrade the API base from 7.0.1 to 7.5 to incorporate changes, but without people asking for things, we won't be able to give them. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jason Miller *Sent:* Monday, August 03, 2009 3:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARInside ** Thank you all for keeping this alive. While we have been able to run it against our 7.5 server there are obviously features that ARSInside does not know about on 7.5. I have been worried about the day that this great (FREE) tool becomes obsolete. I am not a C programmer (it may be time to learn) but I would love to help out however possible. I just signed up for my account. Thanks again! Jason On Mon, Aug 3, 2009 at 2:14 PM, Axton axton.gr...@gmail.com wrote: ** The site addresses for ARInside are: http://arinside.com http://arinside.org I worked with LJ, Stefan (original author), Carey, and a few others to bring this together. I am acting as nothing more than the sys admin for the site for the time. I would encourage anyone who has c++ skills and an appetite for open source software to register an account on the site and get in touch with LJ to keep this great piece of software alive and growing. There are a lot of ways in which this software could grow, imagination and time are really the only limiting factors on where this software can go. The site currently includes the following services: - Subversion (source control) available at http://svn.arinside.org - Trac web front-end (ticket tracking, file downloads, wiki area, roadmap, etc.) I will be adding the following services in the near future: - mailing lists: - general discussion: just as it's named - source changes: mail commits - announcements: low volume, release announcements, pr, etc. Please feel free to report issues and request enhancements using this site as it is the home of ARInside. Community involvement will be the driver for addressing these issues, so feel free to get involved as you see best. LJ is acting as the lead for this project to get things moving so please reach out to him for any special requests or contributions. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Aug 1, 2009 at 10:09 PM, LJ LongWing lj.longw...@gmail.comwrote: ** All, As many of you may have noticed, ARInside was recently donated to the public domain. This means that the project doesn't hafta die on the vine, but unfortunately we need some skilled C programmers to help with feature requests and bug fixes. While I am a programmer, I don't know C (yet) and I need some help from the generous community. There is already a short list of known bugs and requested features and I need some reliable programmers that are willing to help out with this project. Axton has been kind enough to setup some stuff over at ARInside.org for us. Anyone interested in becoming a part of the project, please contact me. There are mailing lists that can be subscribed to where we will start discussions regarding the future of the project. Please let me know if you have questions/comments/concerns. _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_ _Platinum Sponsor
Re: Unwanted button core field
Let me know if it works. I threw the idea out there, but I am not sure if that will bypass the hooks. Axton On Wed, Jul 22, 2009 at 7:27 AM, marti...@jmu.edu marti...@jmu.edu wrote: Thanks, everyone, for your advice! Since this is in the test system I think I’ll use Axton’s suggestion. When the time comes to move this form into our live system, I’ll export the form definition, then edit out the offending field before importing it into the new system. Thanks again, Dwayne *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Shafqat Ayaz *Sent:* Tuesday, July 21, 2009 4:18 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Unwanted button core field ** How about Axton's approach, and if the form imports back ok then go back delete the form and re-import it? although the problem with that would be the data! you would obviously need to import the data and re-import it as well shafqat --- On *Tue, 7/21/09, Joe DeSouza joe_rem...@yahoo.com* wrote: From: Joe DeSouza joe_rem...@yahoo.com Subject: Re: Unwanted button core field To: arslist@ARSLIST.ORG Date: Tuesday, July 21, 2009, 4:31 PM ** This would be an interesting approach but MAY not work if while deleting the unmatched field, it recognizes the field that it is attempting to delete as a core field.. The same goes with changing field ID's using archgid.. may not work with fields having a core field ID.. but would be interesting to try and use it. Joe -- *From:* Axton axton.gr...@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Tuesday, July 21, 2009 11:06:33 AM *Subject:* Re: Unwanted button core field ** Try exporting a def, removing the fld from the def, then reimporint over the form, deleting unmatched fields. Axton On Tue, Jul 21, 2009 at 10:03 AM, marti...@jmu.eduhttp://mc/compose?to=marti...@jmu.edu marti...@jmu.edu http://mc/compose?to=marti...@jmu.edu wrote: ** Dear List, I have a form with a button field with a Field ID of 54. I have no idea how it got there, but I can’t delete it because it is a “Core” field. Most of the time it lays there and doesn’t cause any problem. But if I try to copy my form to a new form (Save Form As) I get: “Field ID is in the core field range but is not recognized : (54)(ARERR 404)” How can I get rid of the ~...@!@# thing? Dwayne Martin James Madison University _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: What's the difference between a Remedy Administrator and a Remedy Developer?
Hey, I resent that :) Axton On Wed, Jul 22, 2009 at 2:31 PM, Tim Widowfield tim_widowfi...@yahoo.comwrote: ** Or Remedy Architect -- you know, the guy who looks over your shoulder and says, You're doing it wrong. --Tim -- *From:* Chowdhury, Tauf tauf.chowdh...@frx.com *To:* arslist@ARSLIST.ORG *Sent:* Wednesday, July 22, 2009 2:55:08 PM *Subject:* Re: [ARSLIST] What's the difference between a Remedy Administrator and a Remedy Developer? ** Don’t forget Remedy Engineer! *T**auf** **C**howdhury** *** Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Roger Justice *Sent:* Wednesday, July 22, 2009 2:47 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: What's the difference between a Remedy Administrator and a Remedy Developer? ** The most important point. What does the job pay. -Original Message- From: Benedetto Cantatore bcant...@emerginghealthit.com To: arslist@ARSLIST.ORG Sent: Wed, Jul 22, 2009 2:43 pm Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? ** I think Shawn defined it best. I have administrators that work for me, well on their way to being developers, but I wouldn't classify them as a developers... yet. Myself, I develop, but I still add groups, users, categories and all the other fun stuff that makes our jobs so much fun. So a lot of crossover on job activities. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 shawn.pier...@sug.com 07/22/09 12:56 PM I would generally agree with what everyone else says, but I put it in the following way: If you are talking about a shop that builds custom applications, a Remedy developer is someone that can do everything the Remedy administrator role requires, plus development work and have a better understanding of log files and other aspects of AR System that an administrator may not know. When it comes to ITSM, the previous idea is thrown out the window, as there are multiple levels of administrators (e.g. application vs. ar system administration) and development is generally much harder so you can customize ITSM without breaking things. As a result, being a Remedy Developer should include subcategories for ARS Developer and ITSM Developer. Shawn Pierson -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arsl...@arslist.org] arsl...@arslist.org%5d On Behalf Of Meyer, Jennifer L Sent: Wednesday, July 22, 2009 11:13 AM To: arslist@ARSLIST.ORG Subject: What's the difference between a Remedy Administrator and a Remedy Developer? I'm going to open up a HUGE can of worms today, just because I can. I keep seeing these hiring requests come in for Administrators OR Developers but not both, and every time I do, I think What the Heck? I've been doing software development and administration for better than a decade now, and devoted more than eight years of that time to Remedy, and I'm still not certain which skills fall into which bucket. So just for giggles, I'll start a list, and the rest of you add onto it. Jennifer Meyer ADMINISTRATOR SKILLS Server Administration Database Administration Install the AR System on the Server Install the Applications on the Server Troubleshoot the Installations and Re-Install (Inevitably) Configure the Applications Import Data to the Applications System Performance and Tuning DEVELOPER SKILLS Requirements Analysis and Design of proposed workflow changes Modify existing applications using the Remedy Administrator Tool Create new forms and workflow using the Remedy Administrator Tool Test, Test, and Test form and workflow changes Documentation (IMHO underrated and underperformed) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ 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_ -- Get ready to win! You could score awesome prizeshttp://daol.aol.com/sweepstakes?ncid=emlweusdaol0001all summer long on AOL. _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
Re: Unwanted button core field
Try exporting a def, removing the fld from the def, then reimporint over the form, deleting unmatched fields. Axton On Tue, Jul 21, 2009 at 10:03 AM, marti...@jmu.edu marti...@jmu.edu wrote: ** Dear List, I have a form with a button field with a Field ID of 54. I have no idea how it got there, but I can’t delete it because it is a “Core” field. Most of the time it lays there and doesn’t cause any problem. But if I try to copy my form to a new form (Save Form As) I get: “Field ID is in the core field range but is not recognized : (54)(ARERR 404)” How can I get rid of the ~...@!@# thing? Dwayne Martin James Madison University _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: Unwanted button core field
Won't know unless you try. Axton On Tue, Jul 21, 2009 at 10:31 AM, Joe DeSouza joe_rem...@yahoo.com wrote: ** This would be an interesting approach but MAY not work if while deleting the unmatched field, it recognizes the field that it is attempting to delete as a core field.. The same goes with changing field ID's using archgid.. may not work with fields having a core field ID.. but would be interesting to try and use it. Joe -- *From:* Axton axton.gr...@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Tuesday, July 21, 2009 11:06:33 AM *Subject:* Re: Unwanted button core field ** Try exporting a def, removing the fld from the def, then reimporint over the form, deleting unmatched fields. Axton On Tue, Jul 21, 2009 at 10:03 AM, marti...@jmu.edu marti...@jmu.eduwrote: ** Dear List, I have a form with a button field with a Field ID of 54. I have no idea how it got there, but I can’t delete it because it is a “Core” field. Most of the time it lays there and doesn’t cause any problem. But if I try to copy my form to a new form (Save Form As) I get: “Field ID is in the core field range but is not recognized : (54)(ARERR 404)” How can I get rid of the ~...@!@# thing? Dwayne Martin James Madison University _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: Table Search
You should break the group list out into an OR qualification. Reason being that goups can be substrings of other groups. So take the following Group;Group1;Group2; The like comparison will give mixed results, assuming the user is in Group. If you format the group list as follows: 'AssignedGroup' = Group Then you can be assured you get the desired results (versus 'AssignedGroup' LIKE %+$Groups$+%). It is also easier on your database (lot less parsing involved). You should be able to generate the qual in a single set field action. 0. Drop the first char of the group list: ; 1. Tack on the beginning of the qual: 'FID' = 2. Replace the delimitter with the middle qual: OR 'FID' = 3. Chop the last X characters (length of chars from step 2) and terminate the qual: Then use an external qual in your table field. Axton Grams On Tue, Jul 21, 2009 at 12:10 PM, Brittain, Mark mbritt...@navisite.comwrote: ** HI All, I want to do a table search based on the groups a user is assigned but can’t get it to work. First I have a form called Assignees where each person is listed with one record per group assigned. On a display only form I have a table that lists the results from the Assignees form where ‘User’ = $USER$ Then I run a Active Link Guide that finds the users records in the Assignees form an populates the result into a character field called ‘Groups’ like this *;Group One;Group Two;Group Three;* Now I want to search my HelpDesk form were records are assigned to those groups. I have tried ‘Assigned Group’ LIKE “% + $Groups$ + “%” Any ideas would be greatly appreciated. Mark Mark Brittain Remedy Developer *NaviSite **mbritt...@navisite.com* mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) *Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.** *Visit www.NaviSite.com Today. * * This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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: Performance issue as ARServed takes 100% CPU utilization
The cpu utilization tells you the process is busy doing something, the real questions is, What is the process doing? Turn on your api logs and check it out. There are some operations that block, which would explain it being bound to a single cpu. What is the cache mode of the server? Axton Grams On Fri, Jul 17, 2009 at 8:05 AM, Manish SINGLA manish.sin...@st.com wrote: Hello List, We have been observing that, when ARServed process reaches to 100% CPU utilization, system performance get degraded drastically. Even if system still has another CPU available means in total it's 50% utilized. This results into when user even couldn't login. Please advice how I can unblock the situation. Regards Manish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Apache Tomcat Memory Pool
There are also some other GC options: http://java.sun.com/docs/hotspot/gc5.0/gc_tuning_5.html The latest JVM's have a new GC that has much greater performance: http://java.sun.com/performance/reference/whitepapers/6_performance.html#2.2 http://java.sun.com/javase/6/docs/technotes/guides/vm/par-compaction-6.html http://java.sun.com/javase/6/webnotes/6u14.html Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 15, 2009 at 7:25 PM, Joe DeSouzajoe_rem...@yahoo.com wrote: ** Hi Joe, This is done in the startup of Tomcat by including a startup paramter for java: -Xincgc along with the startup memory and max memory that is defined. If you are on UNIX you will need to modify your startup.sh file where you have these lines: JAVA_OPTS=$JAVA_OPTS -Xms1536m; export JAVA_OPTS JAVA_OPTS=$JAVA_OPTS -Xmx2560m; export JAVA_OPTS to something like JAVA_OPTS=$JAVA_OPTS -Xms1536m; export JAVA_OPTS JAVA_OPTS=$JAVA_OPTS -Xmx2560m -Xincgc; export JAVA_OPTS Restart Tomcat after that and then your process should look something like: aradmin 3984 1 70 08:09 pts/100:00:11 /apps/ar/jre1.6.0_13/bin/java -Xms1536m -Xmx2560m -Xincgc -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/apps/ar/tomcat-5.5.25/conf/logging.properties -Djava.endorsed.dirs=/apps/ar/tomcat-5.5.25/common/endorsed -classpath :/apps/ar/tomcat-5.5.25/bin/bootstrap.jar:/apps/ar/tomcat-5.5.25/bin/commons-logging-api.jar -Dcatalina.base=/apps/ar/tomcat-5.5.25 -Dcatalina.home=/apps/ar/tomcat-5.5.25 -Djava.io.tmpdir=/apps/ar/tomcat-5.5.25/temp org.apache.catalina.startup.Bootstrap start Without the incremental garbage collection turned on your process would look like: aradmin 3531 1 0 Jun29 ?00:04:10 /apps/ar/jre1.6.0_13/bin/java -Xms1536m -Xmx2560m -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/apps/ar/tomcat-5.5.25/conf/logging.properties -Djava.endorsed.dirs=/apps/ar/tomcat-5.5.25/common/endorsed -classpath :/apps/ar/tomcat-5.5.25/bin/bootstrap.jar:/apps/ar/tomcat-5.5.25/bin/commons-logging-api.jar -Dcatalina.base=/apps/ar/tomcat-5.5.25 -Dcatalina.home=/apps/ar/tomcat-5.5.25 -Djava.io.tmpdir=/apps/ar/tomcat-5.5.25/temp org.apache.catalina.startup.Bootstrap start Are you on UNIX or Windows? The instructions I have given is for UNIX. If you are on windows I think you need to modify your Java Options found in the Java tab of the utility tomcat5w.exe Hope this helps.. Joe From: remedydon mrohinikanth2...@gmail.com To: arslist@ARSLIST.ORG Sent: Wednesday, July 15, 2009 7:54:14 PM Subject: Re: Apache Tomcat Memory Pool Hi Joe, Another useful tip would be to turn on incremental garbage collection. This is always good to free up unused portions of memory that haven't been used for a significant time interval. Where can I find this feature to turn it on ? Joe From: Begosh, Kevin kevin.beg...@lmco.com To: arslist@ARSLIST.ORG Sent: Tuesday, February 3, 2009 3:14:40 PM Subject: Re: Apache Tomcat Memory Pool ** Yes this does help and I am on 7.1 as well so this would help out a lot. We are having those exact issue with Tomcat crashing. Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell kevin.beg...@lmco.com From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, February 03, 2009 1:13 PM To: arslist@ARSLIST.ORG Subject: Re: Apache Tomcat Memory Pool ** Thsi is more of a Tomcat setting than a 'BMC recommended' setting. The golden rule for sizing tomcat memory is to not use more than 65% to 70% of the available free memory before the tomcat service is started. This gives the server at least 30% to 35% headroom. With that in mind it is nice to have a max memory of at least around the 3 GB mark where the usage of the servers is about average. Since you are using tomcat, if you are using Mid-Tier 7.1, I would recommend to hop on the patch 006. In my experience here the earlier patches had a memory issue, that addresses OutOfMemory errors that cause Tomcat to crash which was addressed in Patch 006. Also the performance is way better as I have noticed that it takes a relatively short time for the server to build its cache after an initial restart on patch 006 (at least 5 to 10 times faster) than it was on lets say Patch 003. I haven't tried patches in between 003 and 006 Hope this helps.. Cheers Joe From:Begosh, Kevin kevin.beg...@lmco.com To: arslist@ARSLIST.ORG Sent
Re: logic limit on shared workflow?
Logical Limits: - number of groups in the assignee group field - length of a username/group - joins: unions, aggregates, inline functions - functions in qualifications - number of actions in a workflow object's if/else - number of optional/required fields on a form - size of an integer - date/time field after 2038 - number of filters in a single operation, though the limit can be changed - duration the arserver waits on the db server to return - A regular form can only handle 999,999,999,999,999 entries The list can go on for a long time. Anything in particular you are worried about? As for shared workflow, the data model used in the meta-data tables is capable of accommodating any number of forms per workflow object. Axton Grams This reflects my opinions and observations. On Mon, Jul 6, 2009 at 10:56 AM, Louise van Hinelvanh...@express-scripts.com wrote: Has anyone ever run into a logical or performance limit on shared workflow? The sizing I am talking about is 150 objects (mostly active links, a few AL guides and a couple of dozen filters), and 75 forms. Most of the workflow consists of shared buttons and screen control, the filters do mainly creates and a few modifies to subforms. I did see an earlier message on the list regarding the use of $SERVER$ and $SCHEMA$ keywords in AL actions slowing down the server, but are there other logical limits that anyone knows about? Platform ARS 7.0.01 Patch 7 Thanks! -- View this message in context: http://www.nabble.com/logic-limit-on-shared-workflow--tp24358132p24358132.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: Test System to Production System, Would Ghost Image work ? what is BMC recommendation?
I do not see how the IP-Name parameters would apply to this situation. In your case, I would check the following things: - session timeout configured on the bigip devices (should match that of arserver) - session timeout configured for any firewall devices that are in your path (should match bigip and ar) - persistent session sessions on the bigip device (should always redirect user to same node for session period) The arservers do not act as a load balancing cluster, but instead act as an ha cluster. When you connect to the cluster, you should ensure that you are connecting to the proper node for certain (e.g., admin) operations. General operations (fast/list) can be accommodated by any node, but you have to make sure you talk to the same node for your entire session. If the bigip device redirects your session from one node to a different node, I would expect to see the rpcbind errors. When you say they are both using the same port, are you using the same hostname/ip to access both? If so, this could be an issue. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Tue, Jun 30, 2009 at 10:05 AM, Susan Palmer suzanpal...@gmail.comwrote: ** Hi Axton, We just recently moved from windows to unix (sun solaris 10) and the servers are behind a bigip at a remote location. We split the database onto a separate server. We had no problems with the production server since we put the old prod name in the bigip and everyone is able to connect by simply adding a port id (6/13/09). But now that we brought up the test server I have been getting rpcbind errors which are even affecting both test and prod servers for ME only. I'm the only one that has logged into both servers so that is not surprising. I can get logged in and do a little work on test and then if my PC is idle for a while the next access on that server gives the 90 rpcbind error. Same thing can happen on prod. Now I don't log into test if I'm logged into prod and vice/versa. Do you think adding the line to ar.conf IP-Name: remsrvtest will help alleviate the issue? We do use dns. On the test server the 'remsrvtest' is on the bigip (the actual server name is remztapp01). Prod is 'remsrv'. They both use the same port (could that be an issue). This is driving me crazy and support hasn't found anything either. We just did the prod move on 6/13 and brought up the test server 6/23. Since we brought up that test server my life has been misery. I haven't even been able to clean the server references (since we copied the prod db). We are blessed with old HDv5.0 workflow which loved to embed server names that even replacement doesn't remove. There is always manual cleanup. But even just trying to import the forms only times out giving me the rpcbind error. I've never had a rpcbind error ever. We don't have an issue with dev since it's at our location not behind a bigip. Any suggestions would be greatly appreciated. Thanks, Susan Unix Sun Solaris 10 ARS 7.0.1P2 Oracle 10g (and it is somewhat disappointing I don't think I can blame this on oracle ... :)) Susan Palmer Enterprise Remedy Developer and Administrator ShopperTrak RCT Corporation 200 W Monroe St 11th Floor Chicago, IL 60606 Office 312-529-5325 Cell 312-502-7687 On Mon, Jun 29, 2009 at 7:38 PM, Axton axton.gr...@gmail.com wrote: ** I believe this can still be an issue even in later versions depending on how the server is configured. Say the hostname of the arserver host is remedy1, it has ip address 10.1.1.1 and the following dns aliases: remedy remedy.company.com ars ars.company.com Let's say the Server-Name parameter in ar.conf has a value of remedy1. If you connect using the admin tool to the arserver with a hostname of remedy, that name will be embedded in the workflow unless you have configured the proper IP-Name parameters in ar.conf. The valid IP-Name parameters would be any hostname with which arserver can be accessed, so you would want the following lines in ar.conf: IP-Name: remedy IP-Name: remedy.company.com IP-Name: ars IP-Name: ars.company.com This problem is more common with arsystem configurations where multiple arservers are in use. Take the following example: hostname for arserver1: remedy01 (10.0.0.1) hostname for arserver2: remedy02 (10.0.0.2) hostname for arserver3: remedy03 (10.0.0.3) hostname for load balancer: remedy (10.1.0.1) Aliases/other names for load balancer: arsystem, arsystem.company.com Aliases/other names for remedy01: arsvr01, arsvr01.company.com, remedy01.company.com Aliases/other names for remedy02: arsvr02, arsvr02.company.com, remedy02.company.com Aliases/other names for remedy03
Re: Advice on Threads
There is no magic formula. Most of the factors that drive the optimal settings are environmental. There are a number of factors to take into consideration: - how your application is designed - long running operations - long running sql - escalations - integrations - subsystems - frequency/duration of forked processes - what type and size of system you are running (cpu/core count) - what thread implementation your OS uses - M:1 - 1:1 - M:N) - what scheduler your OS uses - preemptive - non-preemptive) - concurrent users - mean - median - mode - range - frequency/duration of long running processes - bulk updates - integrations There is also the ability to offload some of the processing to separate rpc queues/threads that you have to factor in. This approach makes sense for operations that are out of the norm (esclalations, email engine, integrations, data loads, etc.) because you can lower the number of threads allocated to the fast/list programs because the operations they handle become predictable and controlled. The idea with the private queues is to offload heavy/long workloads as to not block operations on the generic fast/list queues. To truly measure the effectiveness of a given setting, you need to observe the behavior of the process at a low level. This means measuring the thread waits, identifying points of contention and measuring their occurrences. This can be done with a debugger or tools like truss and strace. For the standard queues, the level of synchronization required varies: - a very low level of synchronization required for the fast/list queues (log files if not buffered, some db operations) - a high level of synchronization for earlier (single-threaded) versions of the escalation subsystem - a high level of synchronization for the admin queue, because it is single threaded The thread implementation for arserver is a 'thread pool', with no thread destruction. This is effecient. The main points of contention that you want to try and alleviate using threads include: - thread exhaustion (all threads are busy, so all operations are blocked) - offload the long running stuff to a private queue As a general rule, the context switching is most optimal when there is one thread per cpu (no context switching required), but that assumes there are no points of contention that need to be addressed by additional threads, in which case context switching is desired to allow additional concurrent operations. You should have, at a minimum, 1 thread per cpu where you are expect the number of concurrent operations will exceed the number of cpus/cores in the system. A separate angle to look at this is from the point of the db. Each thread you create in the arserver creates a persistent session to the db. This can create contention on your db for resources. As an example, if you use Oracle and your CURSOR_SHARING parameter is set to EXACT, each session to the db server (ars thread) has it's own memory (sql) area. If the shared pool on the db server becomes consumed due to a high number of threads, the db server will be very busy expiring data from the shared pool. (note that well written applications that use Oracle implement bind variables; note: you should set the CURSOR_SHARING instance parameter in Oracle to SIMILAR). You should not exceed the capabilities of your database server to naturally expire content from memory. All of this said, the optimal thread settings for an application running on Windows with SQL Server is not necessarily equal to the same application running on Solaris with Oracle. One place to check that you have too few threads configured is in the Server Statistics. If you enable Server Statistics per queue, you can observed blocked operations for that queue. The reason that the ITSM applications have a minimum thread requirement is because it relies on having the ability to run both external processes (plugin, run process, etc.) and continue workflow processing. The necessity of this is because one is dependant on the completion of the other, but the main thread of execution forks/offloads the additional process to a seperate thread: Axton Grams These are my opinions and thoughts and mine alone. On Tue, Jun 30, 2009 at 1:35 PM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi Everyone, I am hoping to get some advice on the right number of threads. I have read the book and taken the PTT class and have never gotten a good answer on what the right number would be. I have about 600 users, of which 120-150 are logged on at any given time. The threads are set up like this (thread - min/max). Admin - 1/1 Fast – 6/15 List – 6/20 ARS 6.3, patch 20, Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services
Re: Importing data using Escalations
It sounds like you are receiving the entire data set. If this is the case, to Carey's point, try to figure out what changed and only process the delta. You can do this before the data is exposed to AR or after if the necessary data is available to derive which were changed since the last process time. This is usually accomplished by including a last modified time stamp in the source data. Axton Grams On Mon, Jun 29, 2009 at 8:42 AM, Kelly Deaverkdea...@kellydeaver.com wrote: ** AIE/EIE is included with CMDB.. to integrate with CMDB tables. Not sure what data you are updating. Kelly Deaver kdea...@kellydeaver.com (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) Original Message Subject: Re: Importing data using Escalations From: O'Brien, Keith KOB. (Citco) kobr...@citco.com Date: Mon, June 29, 2009 7:52 am To: arslist@ARSLIST.ORG ** I presume AIE/EIE will cost, is there any other free options? Regards, Keith. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: 29 June 2009 12:54 To: arslist@ARSLIST.ORG Subject: Re: Importing data using Escalations AIE is mult-threaded now too. Kelly Deaver kdea...@kellydeaver.com (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) Original Message Subject: Re: Importing data using Escalations From: Axton axton.gr...@gmail.com Date: Sun, June 28, 2009 8:29 pm To: arslist@ARSLIST.ORG Here are a couple of alternatives: - Use AIE/EIE to schedule the load (do the same thing your escalation does) - Write a program to process the load (do the same thing as the escalation, but multi-threaded) Axton Grams On Sun, Jun 28, 2009 at 4:16 PM, O'Brien, Keith KOB. (Citco)kobr...@citco.com wrote: ** We source data via a view form in our Datawarehouse (oracle 9) We are running AR v7.1 on a separate server with Oracle 10. - so a DBLINK is used. We have an escalation that polls that data nightly, but the record set has increased to over 350,000 records Which we need to keep in sync. The problem is that escalation takes too long to run, hours. Is there a better approach to keep this data in sync? Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _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 Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _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
Re: Importing data using Escalations
If you can not do either of the options below to narrow the data to process, a way to work around that is to generate a checksum against the columns in the data that get pushed into your remedy system. You can compare the primary key in the data along with the checksum to determine whether you need to process the data. http://www.oracle-base.com/articles/9i/StatelessLockingMethods9i.php#Checksum http://stanford.edu/dept/itss/docs/oracle/10g/appdev.101/b10802/w_optloc.htm#997365 Axton Grams On Mon, Jun 29, 2009 at 8:49 AM, Axtonaxton.gr...@gmail.com wrote: It sounds like you are receiving the entire data set. If this is the case, to Carey's point, try to figure out what changed and only process the delta. You can do this before the data is exposed to AR or after if the necessary data is available to derive which were changed since the last process time. This is usually accomplished by including a last modified time stamp in the source data. Axton Grams On Mon, Jun 29, 2009 at 8:42 AM, Kelly Deaverkdea...@kellydeaver.com wrote: ** AIE/EIE is included with CMDB.. to integrate with CMDB tables. Not sure what data you are updating. Kelly Deaver kdea...@kellydeaver.com (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) Original Message Subject: Re: Importing data using Escalations From: O'Brien, Keith KOB. (Citco) kobr...@citco.com Date: Mon, June 29, 2009 7:52 am To: arslist@ARSLIST.ORG ** I presume AIE/EIE will cost, is there any other free options? Regards, Keith. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: 29 June 2009 12:54 To: arslist@ARSLIST.ORG Subject: Re: Importing data using Escalations AIE is mult-threaded now too. Kelly Deaver kdea...@kellydeaver.com (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) Original Message Subject: Re: Importing data using Escalations From: Axton axton.gr...@gmail.com Date: Sun, June 28, 2009 8:29 pm To: arslist@ARSLIST.ORG Here are a couple of alternatives: - Use AIE/EIE to schedule the load (do the same thing your escalation does) - Write a program to process the load (do the same thing as the escalation, but multi-threaded) Axton Grams On Sun, Jun 28, 2009 at 4:16 PM, O'Brien, Keith KOB. (Citco)kobr...@citco.com wrote: ** We source data via a view form in our Datawarehouse (oracle 9) We are running AR v7.1 on a separate server with Oracle 10. - so a DBLINK is used. We have an escalation that polls that data nightly, but the record set has increased to over 350,000 records Which we need to keep in sync. The problem is that escalation takes too long to run, hours. Is there a better approach to keep this data in sync? Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _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 Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _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
Re: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300)
What does the arerror.log show for the time when the ARServer is starting up? What does armonitor.log show during a startup? What ARERR number is associated with the login failure? Is is the 3300? a. If it is the 3300, update the ar.conf and disable alert events. Are there any failures in the install logs prior to the one provided? Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 9:57 AM, Rao Raoscenery@gmail.com wrote: ** Hi List, Can some one please help me with the below issue? Thanks. Platform: Windows Databae: Oracle 10g Installed AR server 7.1 on Windows platform under Oracle 10g. This is a new installation. After installation, I tried to connect to the AR server through Admin and User tools. I am getting the following error. I tried to connect through user id: Demo and gave no password. No Alert Events form could be found on the server (ARERR 3300) user: Demo, server: ARDev Unable to successfully log in to any server. In the services section, I could see the service running - - - BMC Remedy Action Request System Server. And the service - AR System Portmapper - is also started. In the instllation log - ActionRequestSystem.log - I see the following error. [Sat Jun 27 17:22:55.047] RikMain- RIK utility version/timestamp: 7.1.00 Build 200708201922 [Sat Jun 27 17:22:55.047] RikMain- Command = rik veradmin -x localhost -t 0 -u Demo -p ** -f -m -l C:\Program Files\AR System\ARS -n Action Request System -o 0 [Sat Jun 27 17:22:55.047] RikMain- ARInitialization Complete [ERROR][Sat Jun 27 17:22:55.078] VerifyControl- ARVerifyUser failure [ERROR][Sat Jun 27 17:22:55.078] VerifyControl- 3300 No Alert Events form could be found on the server [ERROR][Sat Jun 27 17:22:55.078] RikMain- Problem with verification of user/pw/server information [Sat Jun 27 17:22:55.078] RikMain- ARTermination complete [Sat Jun 27 17:22:55.078] RikMain- Returning 3300 for RIK subcommand veradmin Sincerely, Rao _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: Please help delete action Errors on SYS:Action and ITSM7.1
You want to block the transaction but you want the transaction to proceed? You have to determine the conditions on which each should happen and make it so. I fail to see how the filter you outlined is related to the error you see. ARERR 4554: Failure during an attempt to perform an application command. The system received a request to record a command or encountered a situation in which it attempted to record one automatically, and a failure was encountered during recording. Thus, the command was not performed. The attempted command is displayed with this message. An associated message contains more information. The error message in the logs indicates a failed run process command... Your filter throws an error message, but not this one. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sun, Jun 28, 2009 at 2:59 AM, Enslin Van Blerk - MWEBevanbl...@mweb.com wrote: ** Hi I require some assistance please. In windows event viewer and also the arerror.log file I have the following errors. 390620 : Failure during an attempt to perform an application command (ARERR 4554) : Application-Delete-Entry SYS:Action 0450808 I created the following filter and this is the filter causing the error above. Form = HPD:Help Desk Run On = Modify Run If = ($USER$ != appadmin ) AND ($USER$ != AR_ESCALATOR ) AND (( 'DB.Status' = Resolved) OR ( 'DB.Status_Reason' = Assigned to WinOrbit)) ONE If Action = Message Text = Normal text Type = error How do I create an error message FILTER on the help desk form, but stil allow the out of the box workflow to run? Does anyone know what the SYS:Action form is being used for? Or the document I should look at to explain. I would appreciate any advice. Thank You Enslin This electronic communication and the attached file(s) are subject to a disclaimer which can be accessed on the following link: Disclaimer - or copy the following URL into your browser - http://www.mweb.co.za/disclaimer. If you are unable to view the disclaimer, please contact ab...@mweb.com for a copy. _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: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300)
Try adding this to your ar.conf file and restarting: Disable-Alerts: F Post the results from the following sql statements: select count(rowid) from user_x / select count(rowid) from user_cache / select schemaid, name from arschema where name like 'Alert%' / Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 12:15 PM, Rao Rao scenery@gmail.com wrote: ** Thank you Axton. I reinstlled the app. This time also it failed with the same error message. arerror.log does not show any error. Following is the arrerror log. = = = = = = arerror.log = = = = Mon Jun 29 12:47:46 2009 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Mon Jun 29 12:47:46 2009 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) = = = = = = = = = = armonitor.log shows the following: = = = = armonitor = = = = Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 AR Monitor version 7.1.00 Build 200708221849 started. Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 AR Monitor started. Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4384) started. c:\program files\ar system\vanaja\arserver.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2936) started. c:\program files\ar system\vanaja\arplugin.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2276) started. c:\program files\ar system\vanaja\arsvcdsp.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4912) started. c:\program files\java\jre6\bin\java Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 Pausing for max 900 seconds or until server up. = = = = = = = = = = following are contents of ar.cfg file. = = = = ar.cfg = = = = Alternate-Approval-Reg: T Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390601 1 1 ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\arapi71.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\axis.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\log4j-1.2.8.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\websvc71.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\wsdl4j-1.5.1.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xercesImpl.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xmlParserAPIs.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\commons-logging-1.0.4.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\commons-discovery-0.2.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\jaxrpc.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\saaj.jar; Plugin: WebService.dll Homepage-Form: Home Page Full-Text-Temp-Directory: C:\Users\Rao\AppData\Local\Temp Full-Text-Collection-Directory: C:\Program Files\Hummingbird\SearchServer60\fultext Full-Text-Configuration-Directory: C:\Program Files\Hummingbird\SearchServer60\fultext Plugin: arealdap.dll Plugin: ardbcldap.dll Plugin: ardbcconf.dll Plugin: FlashboardObject.dll Plugin: ServerAdmin.dll Plugin: reportplugin.dll Register-With-Portmapper: T Db-name: ARSys Server-Name: Vanaja Oracle-SID: orcl Currency-Ratio-Client-Refresh-Interval: 60 Multiple-ARSystem-Servers: F Server-directory: C:\Program Files\AR System\Vanaja\Arserver\Db On Mon, Jun 29, 2009 at 11:17 AM, Axton axton.gr...@gmail.com wrote: What does the arerror.log show for the time when the ARServer is starting up? What does armonitor.log show during a startup? What ARERR number is associated with the login failure? Is is the 3300? a. If it is the 3300, update the ar.conf and disable alert events. Are there any failures in the install logs prior to the one provided? Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 9:57 AM, Rao Raoscenery@gmail.com wrote: ** Hi List, Can some one please help me with the below issue? Thanks. Platform: Windows Databae: Oracle 10g Installed AR server 7.1 on Windows platform under Oracle 10g. This is a new installation. After installation, I tried
Re: History of AR System
I started that way back in '99; I still don't have any formal training... Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 12:35 PM, Benedetto Cantatore bcant...@emerginghealthit.com wrote: ** Back in 97, I sat down with the Remedy manual, read it cover to cover and was a Remedy administrator. There were only two apps (I think); Helpdesk and Asset. Today, I looking at all the manuals if you have the whole ITSM suite, I no longer think that's possible. I'm curious, how many folks started Remedy by just reading the docs, or did most people go out and get formal training. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 robert.w.r...@gmail.com 06/29/09 10:56 AM ** I began working with the point release of 2.1 late in 1994 or early 1995 when I was at Winstar, a gone-broke telecommunications company. I wrote the help-desk app for the network ops center, as well as configuration forms, certification forms, lots of stuff. Back then it was a good front-end for a database. We worked with voice communications, so the FCC required a lot of auditing, all of which had to be written. I got into Remedy as a C programmer who didn't have a project at the moment. I was horrified to find no Else statements built into the system. I can't remember when that came along, but it was quite an advance in programming. We worked with HP-UX and an early version of Oracle. Installation of just about anything was a bear, but once all the ducks were lined up it went well. Ever since then I've worked with the ARS. Now it's quite sophisticated in comparison with the old days. On Sun, Jun 28, 2009 at 4:39 PM, Daniel Bloom danielbl...@rogers.comwrote: From a bit of googling . Remedy Corp. The Company was incorporated on November 20, 1990 in Delaware Headquarters Mountain View, California, USA Key people Larry Garlick, Founder CEO Dave Mahler, VP Marketing Doug Mueller, Chief Architect Version 1.0 ? Version 1.1 Approx. Nov 1992 still looking for confirmation Version 2.0 was May 19, 1995 Version 4.0 was Jan 27, 1999 -Original Message- From: Action Request System discussion list(ARSList) _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: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300)
Try this sql: select count(rowid) from user_cache / The fact that user_x is missing is worrisome. This more than likely means that the user form does not exist on the server. Try using arcache to create a temporary admin user. See the ARS config guide for instructions and examples. Chances are you will need to re-run the installer. Prior to re-installing: - Remove/uninstall the existing ARServer - Delete all existing objects in the schema or delete the schema altogether Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 2:12 PM, Rao Rao scenery@gmail.com wrote: ** Joe/Axton, Joe, I ran the sql for Alerts. Please see below. SQL Select count(*) from arschema where name = 'Alert Events'; COUNT(*) -- 1 = = = = = Axton, Please see my earlier mail on the sqls - you asked. Thanks to both of you for help and sparing time. With Regards, Rao On Mon, Jun 29, 2009 at 2:34 PM, Joe DeSouza joe_rem...@yahoo.com wrote: ** At what point and how do you reproduce that error then? Have you checked if the entry for the Alerts form does exist in the arschema table? (Select count(*) from arschema where name = 'Alert Events';) Joe -- *From:* Rao Rao scenery@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Monday, June 29, 2009 1:15:07 PM *Subject:* Re: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300) ** Thank you Axton. I reinstlled the app. This time also it failed with the same error message. arerror.log does not show any error. Following is the arrerror log. = = = = = = arerror.log = = = = Mon Jun 29 12:47:46 2009 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Mon Jun 29 12:47:46 2009 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) = = = = = = = = = = armonitor.log shows the following: = = = = armonitor = = = = Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 AR Monitor version 7.1.00 Build 200708221849 started. Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 AR Monitor started. Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4384) started. c:\program files\ar system\vanaja\arserver.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2936) started. c:\program files\ar system\vanaja\arplugin.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2276) started. c:\program files\ar system\vanaja\arsvcdsp.exe Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4912) started. c:\program files\java\jre6\bin\java Mon Jun 29 12:47:44 2009 (ARNOTE 0) Mon Jun 29 12:47:44 2009 Pausing for max 900 seconds or until server up. = = = = = = = = = = following are contents of ar.cfg file. = = = = ar.cfg = = = = Alternate-Approval-Reg: T Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390601 1 1 ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\arapi71.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\axis.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\log4j-1.2.8.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\websvc71.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\wsdl4j-1.5.1.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xercesImpl.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xmlParserAPIs.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\commons-logging-1.0.4.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\commons-discovery-0.2.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\jaxrpc.jar; ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\saaj.jar; Plugin: WebService.dll Homepage-Form: Home Page Full-Text-Temp-Directory: C:\Users\Rao\AppData\Local\Temp Full-Text-Collection-Directory: C:\Program Files\Hummingbird\SearchServer60\fultext Full-Text-Configuration-Directory: C:\Program Files\Hummingbird\SearchServer60\fultext Plugin: arealdap.dll Plugin: ardbcldap.dll Plugin: ardbcconf.dll Plugin: FlashboardObject.dll Plugin: ServerAdmin.dll Plugin: reportplugin.dll Register-With-Portmapper: T Db-name: ARSys Server-Name: Vanaja Oracle-SID: orcl Currency-Ratio-Client-Refresh-Interval: 60 Multiple-ARSystem-Servers: F Server-directory: C:\Program Files\AR System
Re: Test System to Production System, Would Ghost Image work ? what is BMC recommendation?
I believe this can still be an issue even in later versions depending on how the server is configured. Say the hostname of the arserver host is remedy1, it has ip address 10.1.1.1 and the following dns aliases: remedy remedy.company.com ars ars.company.com Let's say the Server-Name parameter in ar.conf has a value of remedy1. If you connect using the admin tool to the arserver with a hostname of remedy, that name will be embedded in the workflow unless you have configured the proper IP-Name parameters in ar.conf. The valid IP-Name parameters would be any hostname with which arserver can be accessed, so you would want the following lines in ar.conf: IP-Name: remedy IP-Name: remedy.company.com IP-Name: ars IP-Name: ars.company.com This problem is more common with arsystem configurations where multiple arservers are in use. Take the following example: hostname for arserver1: remedy01 (10.0.0.1) hostname for arserver2: remedy02 (10.0.0.2) hostname for arserver3: remedy03 (10.0.0.3) hostname for load balancer: remedy (10.1.0.1) Aliases/other names for load balancer: arsystem, arsystem.company.com Aliases/other names for remedy01: arsvr01, arsvr01.company.com, remedy01.company.com Aliases/other names for remedy02: arsvr02, arsvr02.company.com, remedy02.company.com Aliases/other names for remedy03: arsvr03, arsvr03.company.com, remedy03.company.com You could now potentially access each arserver using several names (strings). The ar.conf (IP-Name parameters) needs to be different on each arserver. The IP-Name parameter seems to be used to parse the workflow when committing workflow to the db; it is used to strip server name references and replace them with the desired @ symbol (global local server reference). If no match is found to Server-Name or IP-Name, the workflow will think the reference is to and external ARServer and store the actual name of the server in the workflow when written to the db. Axton Grams These are my opinions and observations. On Mon, Jun 29, 2009 at 5:51 PM, Shellman, David dave.shell...@tycoelectronics.com wrote: Lee, The 4.x versions and 5.x versions were a bugger with retaining server and IP address information. There were scripts that could be run against def files to clean up remainder of server info that remained in the files. Menus were the worst offenders. I don't remember any issues with exporting as server independent with 6.x nor have I seen any with 7.0.1. Dave - dave.shell...@tycoelectronics.com (Wireless) From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Mon Jun 29 18:27:19 2009 Subject: Re: Test System to Production System, Would Ghost Image work ? what is BMC recommendation? Server Name AND IP address. Just as a precaution, I'd suggest that when you look for server references that you include searches for IP addresses. We moved a 5.x server from one segment to another. We kept the server name the same but the IP address changed. We found hundreds of IP references imbedded in the code that prevented the server from coming up. There is a knowledge base instruction on a fix this in MSSQL DB's. BMC Support folks sent us the instructions. I don't know if the same is true for other systems since our 7.0 install was a clean install with limited data migration and no custom code. Folks probably know to equate the server name and IP address, but it caught us a little off guard at the time. Lee Marsh * Lee Marsh Remedy Administrator BAE Systems Office Automation Systems Team Antitrust Division, U.S. Department of Justice Phone: 202-305-9725 Cell: 202-528-1749 Email: lee.ma...@usdoj.gov mailto:lee.ma...@usdoj.gov * -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Sent: Monday, June 29, 2009 6:10 PM To: arslist@ARSLIST.ORG Subject: Re: Test System to Production System, Would Ghost Image work ? what is BMC recommendation? I would like to verify if I do or don't. In looking at diffs between our environments in Migrator, I've seen system-maintained code that _appeared_ to have specific server references in it, if you can trust Migrator here. They were usually in the Approval module, I think, but there may have been others. We also have a fair amount of custom code that has been maintained by various people over time, and I would like to make sure that we don't have things that need to be fixed there (I have found a few cases as I've worked on parts of the system, and I'd like to find out if there are more). We've got half of the ITSM suite, so I'm not too keen on trying to export it all - I know we've tried in the past (albeit with the rest of the suite installed
Re: Importing data using Escalations
Here are a couple of alternatives: - Use AIE/EIE to schedule the load (do the same thing your escalation does) - Write a program to process the load (do the same thing as the escalation, but multi-threaded) Axton Grams On Sun, Jun 28, 2009 at 4:16 PM, O'Brien, Keith KOB. (Citco)kobr...@citco.com wrote: ** We source data via a view form in our Datawarehouse (oracle 9) We are running AR v7.1 on a separate server with Oracle 10. - so a DBLINK is used. We have an escalation that polls that data nightly, but the record set has increased to over 350,000 records Which we need to keep in sync. The problem is that escalation takes too long to run, hours. Is there a better approach to keep this data in sync? Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _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: Test System to Production System, Would Ghost Image work ? what is BMC recommendation?
Just my opinion, but I would say use a different operating system. Since I started working with Unix/Linux, I just don't see the MS 'server' series of operating systems as server grade; my list of reasons is a mile long. Again, just my opinion. Axton Grams On Sat, Jun 27, 2009 at 5:02 PM, Ravi Kiranravi6...@gmail.com wrote: ** Thanks Axton. I was trying to save some time by doing ghost imaging but i think it is not worth it , as i may get other issues, which i don't want to want time on resolving them. Thanks again for your reply. On Sat, Jun 27, 2009 at 3:55 PM, Axton axton.gr...@gmail.com wrote: You can copy the file system on Unix/Linux and update the configuration files; it's not so simple on Windows. You have to deal with the registry... Not something I am really keen on learning. I would imagine that a ghost image should suffice as long as you can deal with all the other registry updates (domain membership, server information, hostname, etc.). Axton Grams On Sat, Jun 27, 2009 at 3:26 PM, Ravi Kiranravi6...@gmail.com wrote: ** Windows Server 2003 R2 Enterprise Edition. On Sat, Jun 27, 2009 at 12:02 AM, Axton axton.gr...@gmail.com wrote: What OS are you dealing with? Axton Grams On Fri, Jun 26, 2009 at 11:36 AM, Rajravi6...@gmail.com wrote: Hello All, I completed fresh install of ARS 7.5.00 Patch 001/ITSM 7.5.01 Patch 001 on a test system. Now, next task is to build the production system, so my question is, will taking the ghost image of test system and putting it on production system will work ? or do i have to start fresh installations of ARS and ITSM again on production system ? What is ideal approach ? What does BMC recommend ? Please advice. Regards, Raj rki...@spike.dor.state.co.us ___ 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 -- Regards, Ravi Kiran Ph:- (916) 801-2646 _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 -- Regards, Ravi Kiran Ph:- (916) 801-2646 _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: Test System to Production System, Would Ghost Image work ? what is BMC recommendation?
What OS are you dealing with? Axton Grams On Fri, Jun 26, 2009 at 11:36 AM, Rajravi6...@gmail.com wrote: Hello All, I completed fresh install of ARS 7.5.00 Patch 001/ITSM 7.5.01 Patch 001 on a test system. Now, next task is to build the production system, so my question is, will taking the ghost image of test system and putting it on production system will work ? or do i have to start fresh installations of ARS and ITSM again on production system ? What is ideal approach ? What does BMC recommend ? Please advice. Regards, Raj rki...@spike.dor.state.co.us ___ 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: Test System to Production System, Would Ghost Image work ? what is BMC recommendation?
You can copy the file system on Unix/Linux and update the configuration files; it's not so simple on Windows. You have to deal with the registry... Not something I am really keen on learning. I would imagine that a ghost image should suffice as long as you can deal with all the other registry updates (domain membership, server information, hostname, etc.). Axton Grams On Sat, Jun 27, 2009 at 3:26 PM, Ravi Kiranravi6...@gmail.com wrote: ** Windows Server 2003 R2 Enterprise Edition. On Sat, Jun 27, 2009 at 12:02 AM, Axton axton.gr...@gmail.com wrote: What OS are you dealing with? Axton Grams On Fri, Jun 26, 2009 at 11:36 AM, Rajravi6...@gmail.com wrote: Hello All, I completed fresh install of ARS 7.5.00 Patch 001/ITSM 7.5.01 Patch 001 on a test system. Now, next task is to build the production system, so my question is, will taking the ghost image of test system and putting it on production system will work ? or do i have to start fresh installations of ARS and ITSM again on production system ? What is ideal approach ? What does BMC recommend ? Please advice. Regards, Raj rki...@spike.dor.state.co.us ___ 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 -- Regards, Ravi Kiran Ph:- (916) 801-2646 _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: History of AR System
Wow, that takes me back. Axton Grams On Fri, Jun 26, 2009 at 10:34 AM, Easter, Daviddavid_eas...@bmc.com wrote: I've got tharelease dates back to 4.5.00 - but sorry, don't have that info for earlier. AR System 7.5.00 (1/16/2009) AR System 7.1.00 (8/31/2007) AR System 7.0.01 (10/6/06) AR System 7.0 (05/09/2006) AR System 6.03 (01/2005) AR System 6.0 -- (2/6/04) AR System - Maintenance 5.1.2 -- (10/17/03) Action Request System 5.1 -- (9/11/02) Action Request System 5.0.1 -- (3/15/02) Action Request System 5.0 with Web and Windows clients (12/10/01) AR System 4.5.2 Maintenance -- (2/14/01) AR System 4.5.1 Maintenance -- (6/30/00) Action Request System 4.5 -- (5/26/00) -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Sachin T [arslist4bar...@gmail.com] Sent: Thursday, June 25, 2009 11:57 PM To: arslist@ARSLIST.ORG Subject: History of AR System ** Hi Listers, Am preparing a slide deck about Remedy and just want to place a slide about history of ARSystem. Can you pls help me with the various versions of AR Server and its release dates (atleast year)Also milestones like when BMC took over Perigrine and Perigrine took over Remedy Inc (June 2001?) etc...will be very helpful. Thanks in advance. regards Sachin _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
Re: How to export data (PROCESSES) from BMC Remedy User tool
I suggest you show up at WWRUG09 as well. It would be a pleasure to meet all you folks as I plan to be there the entire week:) I've found that it is not impossible, but very possible indeed, to maintain the entry ids through environments for select forms. It only requires the following ingredients: - People that are willing to develop and document migration processes - A team of developers that can read and follow guidelines - A formalized development process where changes are moved through a pipeline of environments Axton Grams On Fri, Jun 26, 2009 at 8:35 AM, Daniel Bloomdanielbl...@rogers.com wrote: Ben, When you are doing an ad for your product, Please prefix with AD: or ADV: in the subject line. I suggest you just show up at WWRUG09 in November and get a booth. Then you can show people live what it does and sell it there. Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: June 26, 2009 8:05 AM To: arslist@ARSLIST.ORG Subject: Re: How to export data (PROCESSES) from BMC Remedy User tool No worries Rick. Indeed that was the point that Axton was trying to make. I know the point well as I've done had to do many of these tasks myself. The only problem with your approach you suggest is that the original problem of incorrect references in the data is not addressed. To extend your idea to handle that would require importing into staging forms and all the necessary filters to push to the real forms, or, of-course, using the API. IF and only if you maintain request ids, then this step could be avoided. Otherwise, you'll be faced with either the API or the above development project. I have found maintaining Ids across systems to be virtually impossible once systems go live. To whit, see the Data Management Tool to load foundation data. This is a huge tool with an inordinate number of forms and filters and took a horrendous amount of time to develop and comes with its own set of patches and fixes. All this just to load data into an application? Yes, the API would solve the problem nicely. But that carries the requirement to have a programmer - most ARS administrators are not programmers - and costs and time associated with maintaining source code. With Meta-Update, any ARS administrator/developer/consultant can develop API level scripts in very short order. Many scripts are already developed. It is this development time that Meta-Update saves. In addition, Meta-Update is replete with value transformation functions in its assignments, including a LookUp facility, a regex pattern extracts, SQL, ARS queries and the like. It can read CSV files that Excel or the BMC Import tool cannot. It can export CSV files and other files. All these result in a company gaining incredible control over ITSM foundation and other data with minimal development. Why don't you take a look yourself? Cheers Ben ___ 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
