Re: ARS 7 Audit Form
Form Properties, Audit page and just write the name.. 2009/3/27 versicle versi...@aol.com I have a custom form which I'd like to create an Audit Log for. I understand I need to create a form of type Audit but I don't know how to do this. Any ideas? -- View this message in context: http://www.nabble.com/ARS-7-Audit-Form-tp22745385p22745385.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: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: ARS 7 Audit Form
Hi Go to Form/Form Properties/Audit and click enable. also select the type of Audit you want in the field Audit Style. in the form name enter a form name, if it is a form audit then enter the name in the Audit Form name, if it is Log style audit then enter the form name in the Log Form field. if the form does not exist, a new form with that name will be created. You can specify a qualification if you want for the Audit to happen. Look in the manual:Forms and Application Objects chapter Audit on page 389 If you need any further help, drop me a line thanks shafqat ayaz --- On Fri, 3/27/09, versicle versi...@aol.com wrote: From: versicle versi...@aol.com Subject: ARS 7 Audit Form To: arslist@ARSLIST.ORG Date: Friday, March 27, 2009, 6:33 PM I have a custom form which I'd like to create an Audit Log for. I understand I need to create a form of type Audit but I don't know how to do this. Any ideas? -- View this message in context: http://www.nabble.com/ARS-7-Audit-Form-tp22745385p22745385.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: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: ARS 7
Brad, in my experience, the upgrade from ars 6.3 to 7.x was quite simple. BUT, from what I have heard about ITSM, I wouldn't think of Helpdesk 5.6 to the current ITSM suite as an upgrade, but more of a new installation! That being said, I'd probably talk with some of the folks on this list about that in great detail. It may well be worth your time Warren On 6/4/08, Brad Terhune [EMAIL PROTECTED] wrote: Hi list! I could really use some help. I have been blissfully coasting along with ARS 6.3 Helpdesk v. 5.6. However, I know that I need to upgrade my ARS version. I am running on a Windows Server 2003 platform with a remote Oracle database (10i I think thought the DBA could confirm unconditionally). Is the upgrade as big a deal as it would appear based on what I have read in the past, or is it no different than the upgrades had to do from 5 to 6, etc? I really like the Helpdesk 5.6 application and have customized it. I could just use any advice, war stories, warnings that you all would feel inclined to give. Thank you, Brad Terhune [EMAIL PROTECTED] IT Team Leader University of Tennessee Health Science Center ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7
Having just gone through an ARS 6.3 to 7.1 upgrade (Development) I would not quite say simple. (it's a little bigger than a breadbox) As usual there are a few gotchas, with the upgrade stepping on, User, Group (wacking permissions), AR Email Message, etc. SLA, Flashboards, Plug-in differences, If you want more information, send me an email off the list [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Wednesday, June 04, 2008 11:31 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 ** Brad, in my experience, the upgrade from ars 6.3 to 7.x was quite simple. BUT, from what I have heard about ITSM, I wouldn't think of Helpdesk 5.6 to the current ITSM suite as an upgrade, but more of a new installation! That being said, I'd probably talk with some of the folks on this list about that in great detail. It may well be worth your time Warren On 6/4/08, Brad Terhune [EMAIL PROTECTED] wrote: Hi list! I could really use some help. I have been blissfully coasting along with ARS 6.3 Helpdesk v. 5.6. However, I know that I need to upgrade my ARS version. I am running on a Windows Server 2003 platform with a remote Oracle database (10i I think thought the DBA could confirm unconditionally). Is the upgrade as big a deal as it would appear based on what I have read in the past, or is it no different than the upgrades had to do from 5 to 6, etc? I really like the Helpdesk 5.6 application and have customized it. I could just use any advice, war stories, warnings that you all would feel inclined to give. Thank you, Brad Terhune [EMAIL PROTECTED] IT Team Leader University of Tennessee Health Science Center ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7
You were doing just fine until you said remote Oracle database. There are major performance/configuration considerations with ARS 7 and remote Oracle 7 databases. There are also solutions to these issues but you do not want to be blindsided by them. Make sure you read up on the in row CLOB storage and how to set it up when and if you make the transition. You'll need a good DBA to convert existing data structures and you'll need to make sure you read the BMC White paper on this topic and follow all of the appropriate steps. That said - if you DO take these steps up front -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brad Terhune Sent: Wednesday, June 04, 2008 10:09 AM To: arslist@ARSLIST.ORG Subject: ARS 7 Hi list! I could really use some help. I have been blissfully coasting along with ARS 6.3 Helpdesk v. 5.6. However, I know that I need to upgrade my ARS version. I am running on a Windows Server 2003 platform with a remote Oracle database (10i I think thought the DBA could confirm unconditionally). Is the upgrade as big a deal as it would appear based on what I have read in the past, or is it no different than the upgrades had to do from 5 to 6, etc? I really like the Helpdesk 5.6 application and have customized it. I could just use any advice, war stories, warnings that you all would feel inclined to give. Thank you, Brad Terhune [EMAIL PROTECTED] IT Team Leader University of Tennessee Health Science Center ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7
Yup, its not an upgrade as far as ITSM is concerned but more of a migration effort. BMC recently has published tools that would help you to migrate the application configuration data across to 7. I used a part of the tool way before it was published but haven't used the fully published version. My experience with the unpublished tool, was it does help minimize what might have been a development effort to create staging forms and workflow to load configuration data. It did work for me, but I had to tweak a few things to make it work correctly. You might want to contact your local BMC sales rep for a copy of this tool. I think its for free but if its not do not quote me on it.. IF you want to upgrade just the AR Sever and not the ITSM application, go for it. Its straight forward, but you may want to test the upgrade in development first especially if you have customizations done that use external API programs, to make sure they are forward compatible, or you may need to recompile them.. Hope this helps.. Joe - Original Message From: Warren Baltimore [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, June 4, 2008 11:31:02 AM Subject: Re: ARS 7 ** Brad, in my experience, the upgrade from ars 6.3 to 7.x was quite simple. BUT, from what I have heard about ITSM, I wouldn't think of Helpdesk 5.6 to the current ITSM suite as an upgrade, but more of a new installation! That being said, I'd probably talk with some of the folks on this list about that in great detail. It may well be worth your time Warren On 6/4/08, Brad Terhune [EMAIL PROTECTED] wrote: Hi list! I could really use some help. I have been blissfully coasting along with ARS 6.3 Helpdesk v. 5.6. However, I know that I need to upgrade my ARS version. I am running on a Windows Server 2003 platform with a remote Oracle database (10i I think thought the DBA could confirm unconditionally). Is the upgrade as big a deal as it would appear based on what I have read in the past, or is it no different than the upgrades had to do from 5 to 6, etc? I really like the Helpdesk 5.6 application and have customized it. I could just use any advice, war stories, warnings that you all would feel inclined to give. Thank you, Brad Terhune [EMAIL PROTECTED] IT Team Leader University of Tennessee Health Science Center ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7
Hi, You may want to use our RRR|DefHideExpandBox-utility, as an upgrade to version 7 will add an expand box to three fields on all your forms and views. This is caused by the increas in length from 30 to 254 characters for the fields Submitter, Modified By and Assigned To. If you are doing a fresh install on a new server, you would probably want to use RRR|Chive to migrate your data. Take care with the system forms such as User/Group/AR System *. You have to merge your customizations/permissions with the new features of these forms. 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. Hi list! I could really use some help. I have been blissfully coasting along with ARS 6.3 Helpdesk v. 5.6. However, I know that I need to upgrade my ARS version. I am running on a Windows Server 2003 platform with a remote Oracle database (10i I think thought the DBA could confirm unconditionally). Is the upgrade as big a deal as it would appear based on what I have read in the past, or is it no different than the upgrades had to do from 5 to 6, etc? I really like the Helpdesk 5.6 application and have customized it. I could just use any advice, war stories, warnings that you all would feel inclined to give. Thank you, Brad Terhune [EMAIL PROTECTED] IT Team Leader University of Tennessee Health Science Center ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.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 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7 - Deployable Applications - Missing field permissions
ADDENDUM: Yes, I checked all my log files and there is nothing even remotely suspicious. From: Durrant, Michael M. - ITSD Sent: Friday, February 01, 2008 1:16 PM To: 'arslist@ARSLIST.ORG' Subject: ARS 7 - Deployable Applications - Missing field permissions ARS 7.0.01 patch 003 Windows Server 2003 When I import my application, I see two things: 1) None of my forms or workflow appear in the application container 2) All the field permissions are stripped Have I missed something? I have done import/exports before without a problem. All I'm doing is using the Export Application feature, selecting a file, and letting it export. I checked the definition file and everything I'm expecting to be in the file is, including the App container and field permissions. TIA, Michael The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7 - Deployable Applications - Missing field permissions
Michael Did you use the Import Application menu, or the Import from Definitions file menu in the admin tool? The first time you import a new deployable application you must use the Import Application feature or it will end up as a local application and you will lose the associated roles. To correct your proble, delete the local application container, then reimport the application using the correct method above and all should be OK. HTH David Sanders _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD Sent: 01 February 2008 20:16 To: arslist@ARSLIST.ORG Subject: ARS 7 - Deployable Applications - Missing field permissions ARS 7.0.01 patch 003 Windows Server 2003 When I import my application, I see two things: 1) None of my forms or workflow appear in the application container 2) All the field permissions are stripped Have I missed something? I have done import/exports before without a problem. All I'm doing is using the Export Application feature, selecting a file, and letting it export. I checked the definition file and everything I'm expecting to be in the file is, including the App container and field permissions. TIA, Michael The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x: No unique index on Group ID?
Hi, In earlier versions you could even have two users with the same login name but different passwords. I think to recall that this feature was removed in one of the recent versions. I typically put unique indexes on these fields too in the User and Group forms. 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. Michael, I have wondered that aloud too.. Its always been that way.. Even the Login Name does not have a unique index on it in the user form... At least they put a simple index on it.. If I remember right, version 6.x didn't even have that simple index on it.. causing applications like customer support crawl on user form searches if you had close to a million customers.. I asked support about it once and didn't get a good answer as to why an index is missing on that form.. now it looks like they have an index on the Login Name for version 7 but its not unique.. In my experience it doesn't hurt to put those indexes yourself. I've always done it (both on the group and user form) with no negative effects - in fact it helped one of my customers quite a bit on the performance side after introducing those indexes as required.. Some parts of their system was virtually unusable before doing that.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD Sent: Wednesday, January 09, 2008 4:11 PM To: arslist@ARSLIST.ORG Subject: ARS 7.x: No unique index on Group ID? ** I did an application export/import from development to production and it replicated our existing Group IDs. Why is there no unique index on Group ID? I can't fathom a situation where I would want differently named groups with the same ID. Am I totally off-base on this or ??? Thanks, Michael No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008 10:16 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.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 Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x: No unique index on Group ID?
Michael, Actually I think there is at least one good reason for why ARS supports (or maybe supported is a better phrase) this feature. The idea is a group alias. ( Two Group form entries with the same 'Group ID' value but different 'Group Name' values.) This is a designed feature from the old days. Ref: v4.0 admin_vol1.pdf pg 1-26: This is part of a table Table 1-3 Key Fields in Group Form: Group ID Integer ID that is the recognized identity of the group. For groups that you create, the ID should be greater than 10. If you use the same ID with multiple group names, you must keep the Group type the same for each because you are creating aliases for the same group. and a parallel v6.3 doc segment has this to say: BasicGuide-63.pdf page 114 If you use the same ID with multiple group names, you must keep the Group type the same for each because you are creating aliases for the same group. To make sure that you do not create duplicate Group IDs, use Remedy Administrator to build a unique index on the Group ID field in the Group form. (For more information, see Defining indexes on page 210.) However at the lowest level these values are used for one of two reasons: Access Controls or Notifications. And the point of the alias has to do with the latter use not the former. Over time it is possible (and likely) for your groups to be organizationally merged. For example: Helpdesk HR(1) and Helpdesk Technical(10005) might become Service Desk(10005). In the case of Notification actions in workflow these values are held as strings('Group Name', 'Login Name', hard coded Email Addresses or lists of combinations of those things) in the object definitions. So when groups merge into a new name (or into one existing name) you need to maintain that 'Group Name' that still has notifications going to it, or pick through your entire application and replace the old value(s) with the new value(s). The alias values allow you to solve this normal change with a data change in one ARS form. ( You can change the group ID values to now be Helpdesk HR(10005) and Helpdesk Technical(10005).) This would allow you to not have to change your application and notification actions sent to Helpdesk HR would now be routed to the 10005 'Group List' members instead. (Yes you likely need to move all users in 1 into 10005 in the 'Group List' too. So that 1 can be total abandoned.) Keep in mind that if the 'Group ID' is used as an Access Control then those references are NOT removed by changing data in the Group form. So if you ever reuse that value later(1) then those places that this Access Control is used will still be there and will spring back into life as soon as that group is defined again in the Group Form. Also if your application allows your users to type (manually) in a value then that muscle memory of entering Helpdesk HR will also not go away anytime soon. So you may want to support users still using that value (for a period of time) to again, not break your existing processes during changes like this. ( The group alias feature allows for this.) So... I think the point was to allow an easier transition under normal and expected business org changes. However, there may be other good reasons too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Jan 9, 2008 4:10 PM, Durrant, Michael M. - ITSD [EMAIL PROTECTED] wrote: ** I did an application export/import from development to production and it replicated our existing Group IDs. Why is there no unique index on Group ID? I can't fathom a situation where I would want differently named groups with the same ID. Am I totally off-base on this or ??? Thanks, Michael ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x: No unique index on Group ID?
Michael, I have wondered that aloud too.. Its always been that way.. Even the Login Name does not have a unique index on it in the user form... At least they put a simple index on it.. If I remember right, version 6.x didn't even have that simple index on it.. causing applications like customer support crawl on user form searches if you had close to a million customers.. I asked support about it once and didn't get a good answer as to why an index is missing on that form.. now it looks like they have an index on the Login Name for version 7 but its not unique.. In my experience it doesn't hurt to put those indexes yourself. I've always done it (both on the group and user form) with no negative effects - in fact it helped one of my customers quite a bit on the performance side after introducing those indexes as required.. Some parts of their system was virtually unusable before doing that.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD Sent: Wednesday, January 09, 2008 4:11 PM To: arslist@ARSLIST.ORG Subject: ARS 7.x: No unique index on Group ID? ** I did an application export/import from development to production and it replicated our existing Group IDs. Why is there no unique index on Group ID? I can't fathom a situation where I would want differently named groups with the same ID. Am I totally off-base on this or ??? Thanks, Michael No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008 10:16 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
Thanks for the feedback gents. I'm not sure I am sold on upgrading the server from 6.3 to 7.1 at the moment. Although, I get that it makes sense to do an ITSM/ARS upgrade in piecemeal, I think I will wait for 7.1 to stabilize. I am not getting a warm-fuzzy about 7.1 after reading various posts in ARSList. :-) On a related side-note, does anyone know when 6.3 support ends? When 7.5 is released...? :p Richard ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
Richard, If I remember right, David Easter did mention on one of his recent posts not more than a week or so ago, that 7.5 would hit the road somewhere mid-2008? So that would make 6.3 more than 3 major versions old.. Cheers Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Richard Crosby Sent: Monday, November 12, 2007 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** Thanks for the feedback gents. I’m not sure I am sold on upgrading the server from 6.3 to 7.1 at the moment. Although, I get that it makes sense to do an ITSM/ARS upgrade in piecemeal, I think I will wait for 7.1 to stabilize. I am not getting a warm-fuzzy about 7.1 after reading various posts in ARSList. J On a related side-note, does anyone know when 6.3 support ends? When 7.5 is released…? :p Richard No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.30/1125 - Release Date: 11/11/2007 9:50 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
That is correct. Standard BMC policy is to support the current version and 2 releases back. When 7.5 is released, 6.3 would be considered the Current minus 3 release. (i.e. 7.5.00 and 7.1.00 would be fully supported and 7.0.01 would be on limited support. 6.3 would be unsupported.) http://www.bmc.com/info_center_support/overview/0,,19097_4736154_4073759 6,00.html Policy for BMC Software Products BMC Software provides Full Support for the current version/release of all its products as well as one release preceding it (C-1). Additionally, BMC Software will provide Limited Support to the C-2 release for 12 months after the current release has been made available. Regardless of the number of supported releases, BMC Software will always provide at least Limited Support for a version/release for a period of at least 24 months from the date on which the version/release became generally available (GA). -David J. Easter Sr. Product Manager, Service Management Business Unit 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:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, November 12, 2007 7:54 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** Richard, If I remember right, David Easter did mention on one of his recent posts not more than a week or so ago, that 7.5 would hit the road somewhere mid-2008? So that would make 6.3 more than 3 major versions old.. Cheers Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Richard Crosby Sent: Monday, November 12, 2007 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** Thanks for the feedback gents. I'm not sure I am sold on upgrading the server from 6.3 to 7.1 at the moment. Although, I get that it makes sense to do an ITSM/ARS upgrade in piecemeal, I think I will wait for 7.1 to stabilize. I am not getting a warm-fuzzy about 7.1 after reading various posts in ARSList. :-) On a related side-note, does anyone know when 6.3 support ends? When 7.5 is released...? :p Richard __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
We are using ARS v.6.3 (patch 20). The reason why I am asking is that there are plans to upgrade to ITSM 7. The thought is to upgrade the server now to get that out of the way. However, I don't wish to create any additional issues, work, etc. If there is no additional benefit to upgrading 6.3 to 7, other than being ready for ITSM 7 if/when that comes, then I don't see any real benefit to doing it now. Thanks, Richard __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
Then you are already past the point of breaking the rapp service being on 6.3. I prefer to keep ARS and ITSM upgraded separate (when possible). The ARS is the core of your system and ITSM is a huge upgrade. I don't like the idea of changing the core system, possibly introducing system problems and then doing a massive app upgrade (which will break things (I must admit though that I have not done an ITSM 6 to 7 upgrade yet)). The last ITSM upgrade that I did, we upgrade ARS from 4.x to 6.x and months later upgraded HD, CM, AM 4 to ITSM 6 (granted our schedule allowed for this). We built a fresh install of ITSM 6 on different servers with the same version of ARS as production. On upgrade day we brought down ARS on and the databases (Oracle), swapped the databases between DB servers and brought the apps back up. Ran a few queries against the db looking for hardcoded server references in workflow and finished importing updated records to the new production database. By swapping databases we still had access to the old data/workflow for reference in case there were any issues and we need to look at the old system. Jason From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Friday, November 09, 2007 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** We are using ARS v.6.3 (patch 20). The reason why I am asking is that there are plans to upgrade to ITSM 7. The thought is to upgrade the server now to get that out of the way. However, I don't wish to create any additional issues, work, etc. If there is no additional benefit to upgrading 6.3 to 7, other than being ready for ITSM 7 if/when that comes, then I don't see any real benefit to doing it now. Thanks, Richard __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
Richard, to throw another tack to this (sorry for the massacred metaphor), you won't be able to upgrade ITSM 6 to ITSM 7, like you could v4 through v6. Almost none of the code is the same. You will need to either plan for downtime measured in days (if you're lucky) or plan on installing ARS and ITSM 7 on a new server, and just convert over to it when it's ready. So you might just save yourself some work and channel the effort you were going to expend upgrading your current AR server toward installing the new one. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Friday, November 09, 2007 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** Then you are already past the point of breaking the rapp service being on 6.3. I prefer to keep ARS and ITSM upgraded separate (when possible). The ARS is the core of your system and ITSM is a huge upgrade. I don't like the idea of changing the core system, possibly introducing system problems and then doing a massive app upgrade (which will break things (I must admit though that I have not done an ITSM 6 to 7 upgrade yet)). The last ITSM upgrade that I did, we upgrade ARS from 4.x to 6.x and months later upgraded HD, CM, AM 4 to ITSM 6 (granted our schedule allowed for this). We built a fresh install of ITSM 6 on different servers with the same version of ARS as production. On upgrade day we brought down ARS on and the databases (Oracle), swapped the databases between DB servers and brought the apps back up. Ran a few queries against the db looking for hardcoded server references in workflow and finished importing updated records to the new production database. By swapping databases we still had access to the old data/workflow for reference in case there were any issues and we need to look at the old system. Jason From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Friday, November 09, 2007 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.x with CM 5.6 ** We are using ARS v.6.3 (patch 20). The reason why I am asking is that there are plans to upgrade to ITSM 7. The thought is to upgrade the server now to get that out of the way. However, I don't wish to create any additional issues, work, etc. If there is no additional benefit to upgrading 6.3 to 7, other than being ready for ITSM 7 if/when that comes, then I don't see any real benefit to doing it now. Thanks, Richard __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
Yes many people are. The only thing I can tell you is to upgrade to 6.3 before you upgrade to 7.x there were some changes made to the user and group forms and the upgrade to 6.3 make the changes during the upgrade. EMPOWERING People - Talent - Technology Stephen Waller Remedy Practice Manager Dibon Solutions, Inc. 2009 Chenault Drive Suite 100 Carrollton, TX 75006 http://maps.yahoo.com/py/maps.py?Pyt=Tmapaddr=16750+Westgrove+Drivecs z=Addison%2C+TX++75001country=us [EMAIL PROTECTED] tel: fax: mobile: +1 (214) 257-0498 +1 (817) 691-3276 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Thursday, November 08, 2007 10:06 AM To: arslist@ARSLIST.ORG Subject: ARS 7.x with CM 5.6 Silly question but is anyone running server version 7.x with older applications, for example Change Management 5.6? Are there any benefits/pratfalls to upgrading the server version and leaving the applications at older versions? I'm trying to make a determination if there is any benefit to upgrading the server version now in preparation for an ITSM 7.x application upgrade later. Thanks for any input, Richard __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7.x with CM 5.6
What version of ARS are you currently on? If it is pre 6, do you have the rapp service running (don't remember CHG had it or if it was just for SLA)? The rapp service doesn't like version 6 (and I assume greater but haven't tried since 6). I believe part of it has to do with how licensing changed in 6. Jason From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Thursday, November 08, 2007 8:06 AM To: arslist@ARSLIST.ORG Subject: ARS 7.x with CM 5.6 ** Silly question but is anyone running server version 7.x with older applications, for example Change Management 5.6? Are there any benefits/pratfalls to upgrading the server version and leaving the applications at older versions? I'm trying to make a determination if there is any benefit to upgrading the server version now in preparation for an ITSM 7.x application upgrade later. Thanks for any input, Richard __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARS 7 - Calculating estimated resolution date - is it possible?
Thank you very much for this feedback. You are correct in your assumption that I have not done much ARS development work. To complicate matters (for me) my employer will not spend the money to have me properly trained in ARS development. I definitely do not want to over-complicate the solution. We are a 24x7x365 operation and our service targets are rather simple at this point in time. I will therefor follow your advice and develop the active link. Again, thanks for the feedback. I really appreciate it Richard On Oct 19, 6:22 pm, Carey Matthew Black [EMAIL PROTECTED] wrote: Richard, I think you maybe over complicating things a bit. The real difficulty is in defining the formula for the calculation. However, I will talk thought a very simple example and see if this idea might work for you. Let us say that you have three priorities and for each priority there is a fixed amount of time that will be used. So... Priority 1 -- 1 hour Priority 2 -- 8 Hours Priority 3 -- 24 hours If the math is as simple as that AND you are working with a 24x7x365 business then you might only need three filters that fire on Submit to set the 'estimated resolution date' = $TIMESTAMP$ + number of seconds for the given Priority However, if you do not have a 24x7x365 business then you should look at the Application-Bus-Time-Add functionality to avoid setting the value to business hours when the business is not open. But you also mentioned that you have the SLA out of the box application too. I would hope that the functionality in SLA would be able to figure out when the record should be complete. ( Although the value may not be in the 'estimated resolution date' field, the value should be knowable by the support agent. The agent might even be instructed to input the value that SLA calculates into the 'estimated resolution date' field.) HTH. Also it sounds like you have not done much ARS development work. ( So please forgive me if this is not the case. ) Due to the complexity of the Out of the Box applications I would suggest that if you are going to try to get the application to use the SLA date that you do not try to do it with an ARS Push Action. Instead, I would suggest that you add an active link (that fires on After Submit) to pull (via a SetField Action) the value from the related SLA record. The hardest part should be getting the Set Field qualification correct. Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/19/07, Ri Mez [EMAIL PROTECTED] wrote: Thanks for the input DJHuang . I was hoping for something that wouldn't involve creating a new form (I've never done it yet) but it looks like I need to start learning how to do it. What I was wondering was if it's possible to use SLM to push a value to the 'estimated resolution date'. My biggest problem is how would I get the calculated date? The work flow I'm thinking of goes like this: 1. An incident is created. It matches a service target (say 24 hours) for resolution 2. The 0% milestone would take the service target time (say, 24 Hours) and calculate the time of resolution by the reported date of the incident. So if the reported date was 1.10.07 5:12:46 PM the pushed value would be 2.10.07 5:12:46 PM. 3. This value would be pushed to the estimated resolution date field of the incident. Is there a way to have ARS calculate this? Or am I just going with the completely wrong approach? Thanks, Richard On Oct 18, 2:11 pm, DJHuang [EMAIL PROTECTED] wrote: Hello, Pardon and correct me for typo or poor grammar if there's any. I have similar situation but need to calculate based on user's site. But I think it's not that different. You can create a form, keep the mapping in the form like: Priority=High, ETA=1hr, EstResolved=2hr, something like this. Then you need to compose a filter to calculate and push the value. 1. Create a filter when priority is modified or has been set a value. 2. Use the value of Priority as keyword, lookup in the form you just created, you get the ETA and EstResolved factor accordingly. 3. Use Application-Bus-Time-Add sort of functions to calculate the real ETA EstResolved date/time. 4. Push the calculated value back to the incident ticket. Hope this could help a little bit. DJHuang 2007/10/18, Ri Mez [EMAIL PROTECTED]: Hi Everyone, I've a situation right now where the IT Mangers are requesting that Remedy be able to calculate the estimated resolution date automatically based on the priority of an incident. As far as I know this functionality is completely missing from Remedy. Does anyone have any experience with this type of requirement? If so how were you able to provide it?
Re: ARS 7 - Calculating estimated resolution date - is it possible?
Thanks for the input DJHuang . I was hoping for something that wouldn't involve creating a new form (I've never done it yet) but it looks like I need to start learning how to do it. What I was wondering was if it's possible to use SLM to push a value to the 'estimated resolution date'. My biggest problem is how would I get the calculated date? The work flow I'm thinking of goes like this: 1. An incident is created. It matches a service target (say 24 hours) for resolution 2. The 0% milestone would take the service target time (say, 24 Hours) and calculate the time of resolution by the reported date of the incident. So if the reported date was 1.10.07 5:12:46 PM the pushed value would be 2.10.07 5:12:46 PM. 3. This value would be pushed to the estimated resolution date field of the incident. Is there a way to have ARS calculate this? Or am I just going with the completely wrong approach? Thanks, Richard On Oct 18, 2:11 pm, DJHuang [EMAIL PROTECTED] wrote: Hello, Pardon and correct me for typo or poor grammar if there's any. I have similar situation but need to calculate based on user's site. But I think it's not that different. You can create a form, keep the mapping in the form like: Priority=High, ETA=1hr, EstResolved=2hr, something like this. Then you need to compose a filter to calculate and push the value. 1. Create a filter when priority is modified or has been set a value. 2. Use the value of Priority as keyword, lookup in the form you just created, you get the ETA and EstResolved factor accordingly. 3. Use Application-Bus-Time-Add sort of functions to calculate the real ETA EstResolved date/time. 4. Push the calculated value back to the incident ticket. Hope this could help a little bit. DJHuang 2007/10/18, Ri Mez [EMAIL PROTECTED]: Hi Everyone, I've a situation right now where the IT Mangers are requesting that Remedy be able to calculate the estimated resolution date automatically based on the priority of an incident. As far as I know this functionality is completely missing from Remedy. Does anyone have any experience with this type of requirement? If so how were you able to provide it? The only thing I can think of right now is tying in the Service Target of the incident to the estimated resolution date field. Unfortunately I'm not sure how to tackle this. All feedback and comments would really be appreciated. thanks, Richard ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 - Calculating estimated resolution date - is it possible?
Richard, I think you maybe over complicating things a bit. The real difficulty is in defining the formula for the calculation. However, I will talk thought a very simple example and see if this idea might work for you. Let us say that you have three priorities and for each priority there is a fixed amount of time that will be used. So... Priority 1 -- 1 hour Priority 2 -- 8 Hours Priority 3 -- 24 hours If the math is as simple as that AND you are working with a 24x7x365 business then you might only need three filters that fire on Submit to set the 'estimated resolution date' = $TIMESTAMP$ + number of seconds for the given Priority However, if you do not have a 24x7x365 business then you should look at the Application-Bus-Time-Add functionality to avoid setting the value to business hours when the business is not open. But you also mentioned that you have the SLA out of the box application too. I would hope that the functionality in SLA would be able to figure out when the record should be complete. ( Although the value may not be in the 'estimated resolution date' field, the value should be knowable by the support agent. The agent might even be instructed to input the value that SLA calculates into the 'estimated resolution date' field.) HTH. Also it sounds like you have not done much ARS development work. ( So please forgive me if this is not the case. ) Due to the complexity of the Out of the Box applications I would suggest that if you are going to try to get the application to use the SLA date that you do not try to do it with an ARS Push Action. Instead, I would suggest that you add an active link (that fires on After Submit) to pull (via a SetField Action) the value from the related SLA record. The hardest part should be getting the Set Field qualification correct. Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/19/07, Ri Mez [EMAIL PROTECTED] wrote: Thanks for the input DJHuang . I was hoping for something that wouldn't involve creating a new form (I've never done it yet) but it looks like I need to start learning how to do it. What I was wondering was if it's possible to use SLM to push a value to the 'estimated resolution date'. My biggest problem is how would I get the calculated date? The work flow I'm thinking of goes like this: 1. An incident is created. It matches a service target (say 24 hours) for resolution 2. The 0% milestone would take the service target time (say, 24 Hours) and calculate the time of resolution by the reported date of the incident. So if the reported date was 1.10.07 5:12:46 PM the pushed value would be 2.10.07 5:12:46 PM. 3. This value would be pushed to the estimated resolution date field of the incident. Is there a way to have ARS calculate this? Or am I just going with the completely wrong approach? Thanks, Richard On Oct 18, 2:11 pm, DJHuang [EMAIL PROTECTED] wrote: Hello, Pardon and correct me for typo or poor grammar if there's any. I have similar situation but need to calculate based on user's site. But I think it's not that different. You can create a form, keep the mapping in the form like: Priority=High, ETA=1hr, EstResolved=2hr, something like this. Then you need to compose a filter to calculate and push the value. 1. Create a filter when priority is modified or has been set a value. 2. Use the value of Priority as keyword, lookup in the form you just created, you get the ETA and EstResolved factor accordingly. 3. Use Application-Bus-Time-Add sort of functions to calculate the real ETA EstResolved date/time. 4. Push the calculated value back to the incident ticket. Hope this could help a little bit. DJHuang 2007/10/18, Ri Mez [EMAIL PROTECTED]: Hi Everyone, I've a situation right now where the IT Mangers are requesting that Remedy be able to calculate the estimated resolution date automatically based on the priority of an incident. As far as I know this functionality is completely missing from Remedy. Does anyone have any experience with this type of requirement? If so how were you able to provide it? The only thing I can think of right now is tying in the Service Target of the incident to the estimated resolution date field. Unfortunately I'm not sure how to tackle this. All feedback and comments would really be appreciated. thanks, Richard ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are
Re: ARS 7 - Calculating estimated resolution date - is it possible?
Hello, Pardon and correct me for typo or poor grammar if there's any. I have similar situation but need to calculate based on user's site. But I think it's not that different. You can create a form, keep the mapping in the form like: Priority=High, ETA=1hr, EstResolved=2hr, something like this. Then you need to compose a filter to calculate and push the value. 1. Create a filter when priority is modified or has been set a value. 2. Use the value of Priority as keyword, lookup in the form you just created, you get the ETA and EstResolved factor accordingly. 3. Use Application-Bus-Time-Add sort of functions to calculate the real ETA EstResolved date/time. 4. Push the calculated value back to the incident ticket. Hope this could help a little bit. DJHuang 2007/10/18, Ri Mez [EMAIL PROTECTED]: Hi Everyone, I've a situation right now where the IT Mangers are requesting that Remedy be able to calculate the estimated resolution date automatically based on the priority of an incident. As far as I know this functionality is completely missing from Remedy. Does anyone have any experience with this type of requirement? If so how were you able to provide it? The only thing I can think of right now is tying in the Service Target of the incident to the estimated resolution date field. Unfortunately I'm not sure how to tackle this. All feedback and comments would really be appreciated. thanks, Richard ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.X Update FAQS
Thanks, but still, when to license it, before or after installation? TOPIC 1: How are licenses handled for the new ITSM 7.0 Applications? ...If the license keys are not applied to the server before installation, you will receive an error message preventing installation. ... You can use the following process to see the forms and features which require these licenses: - Launch and login to BMC Remedy Administrator - Expand the tree and click on Applications - Double-click on any of the following deployable applications, to view the Application Properties: Remedy Financial Management, Remedy Incident Management, or Remedy Problem Management - Choose from the menu, Application -- License Application regards, ii : Igor Ivanov - Remedy Sr. Developer - DBC Contractor : BLAST - Business Line Application Support Team : Office of the CIO : FAS - GSA Federal Acquisition Service ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.X Update FAQS
Igor, You can install the server; and after that install the licenses. Without licenses you can not install for instance CMDB and ITSM applications. Much the same as in 7.0.x Regards, Michiel -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 9/26/07, igor ivanov [EMAIL PROTECTED] wrote: ** Thanks, but still, when to license it, before or after installation? TOPIC 1: How are licenses handled for the new ITSM 7.0 Applications? ...If the license keys are not applied to the server before installation, you will receive an error message preventing installation. ... You can use the following process to see the forms and features which require these licenses: - Launch and login to BMC Remedy Administrator - Expand the tree and click on Applications - Double-click on any of the following deployable applications, to view the Application Properties: Remedy Financial Management, Remedy Incident Management, or Remedy Problem Management - Choose from the menu, Application -- License Application regards, ii : Igor Ivanov - Remedy Sr. Developer - DBC Contractor : BLAST - Business Line Application Support Team : Office of the CIO : FAS - GSA Federal Acquisition Service __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7/Oracle and Firewalls/Network devices
Axton, you're 100% correct. And we thought of that too. We just don't know a way to ensure we hit _all_ of the open threads at least once an hour. BMC's suggestion was to hit the server hard enough to use all the queues like you would under load testing but I have the same doubts you do: will this cause deterioration in the user experience or server performance? I'm guessing, as you are, that it would. I'm 99% sure the firewall is Cisco of some sort and you may be right on the state table only being created on SYN packets but that means that any SYN packet passing through the firewall (the start of any TCP connection) that passes a rule would be added to the state table. After that any traffic, regardless of packet type, would be covered by the entry in the state table as long as it was over the established connection, wouldn't it? Then the problem arises when the state table, to save firewall resources, clears out old, defunct connections. I'm glad someone else agrees that the best approach to this would be to eliminate the network devices that may be causing the issue rather than trying to engineer ARS to keep all the connections open. It does amaze me, though, that BMC can call ARS an enterprise product when it behaves so badly with stateful firewalls. J.T. Shyman Column Technologies Cell: 404-242-5407 -Original Message- From: Axton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 10:25 PM Subject: Re: ARS 7/Oracle and Firewalls/Network devices The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic
Re: ARS 7/Oracle and Firewalls/Network devices
The best solution would be if ARServer had a configuration option, a thread keep-alive if you will, that would do this. This would avoid the busy system errors that sessions will get if all threads are busy. Axton Grams On 9/20/07, J.T. Shyman [EMAIL PROTECTED] wrote: Axton, you're 100% correct. And we thought of that too. We just don't know a way to ensure we hit _all_ of the open threads at least once an hour. BMC's suggestion was to hit the server hard enough to use all the queues like you would under load testing but I have the same doubts you do: will this cause deterioration in the user experience or server performance? I'm guessing, as you are, that it would. I'm 99% sure the firewall is Cisco of some sort and you may be right on the state table only being created on SYN packets but that means that any SYN packet passing through the firewall (the start of any TCP connection) that passes a rule would be added to the state table. After that any traffic, regardless of packet type, would be covered by the entry in the state table as long as it was over the established connection, wouldn't it? Then the problem arises when the state table, to save firewall resources, clears out old, defunct connections. I'm glad someone else agrees that the best approach to this would be to eliminate the network devices that may be causing the issue rather than trying to engineer ARS to keep all the connections open. It does amaze me, though, that BMC can call ARS an enterprise product when it behaves so badly with stateful firewalls. J.T. Shyman Column Technologies Cell: 404-242-5407 -Original Message- From: Axton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 10:25 PM Subject: Re: ARS 7/Oracle and Firewalls/Network devices The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind
Re: ARS 7/Oracle and Firewalls/Network devices
I agree completely. Unfortunately, BMC sees this as a feature request and not as a bug or problem with their software. J.T. Shyman Column Technologies Cell: 404-242-5407 -Original Message- From: Axton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 8:50 AM Subject: Re: ARS 7/Oracle and Firewalls/Network devices The best solution would be if ARServer had a configuration option, a thread keep-alive if you will, that would do this. This would avoid the busy system errors that sessions will get if all threads are busy. Axton Grams On 9/20/07, J.T. Shyman [EMAIL PROTECTED] wrote: Axton, you're 100% correct. And we thought of that too. We just don't know a way to ensure we hit _all_ of the open threads at least once an hour. BMC's suggestion was to hit the server hard enough to use all the queues like you would under load testing but I have the same doubts you do: will this cause deterioration in the user experience or server performance? I'm guessing, as you are, that it would. I'm 99% sure the firewall is Cisco of some sort and you may be right on the state table only being created on SYN packets but that means that any SYN packet passing through the firewall (the start of any TCP connection) that passes a rule would be added to the state table. After that any traffic, regardless of packet type, would be covered by the entry in the state table as long as it was over the established connection, wouldn't it? Then the problem arises when the state table, to save firewall resources, clears out old, defunct connections. I'm glad someone else agrees that the best approach to this would be to eliminate the network devices that may be causing the issue rather than trying to engineer ARS to keep all the connections open. It does amaze me, though, that BMC can call ARS an enterprise product when it behaves so badly with stateful firewalls. J.T. Shyman Column Technologies Cell: 404-242-5407 -Original Message- From: Axton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 10:25 PM Subject: Re: ARS 7/Oracle and Firewalls/Network devices The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey
Re: ARS 7/Oracle and Firewalls/Network devices
Just a few WAGs... I am not sure if these would cause DB IO for each thread or not: Maybe you could force the server to re-read is db? ( arsignal -g ) Maybe you could change an ARS object's helptext and try force the server to shake the threads You could also write a small api program to login and used all the right RPC numbers... but that would be tedious. And I am not sure you could hit all of the threads in the Fast/List/Private set to. That would be a bit more difficult, and exactly what your trying to do. :( -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/19/07, Axton [EMAIL PROTECTED] wrote: The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic to pass without undergoing validation against the rulebase for every packet. Adding a rule that allows a single port connection, which is what we had before, doesn't stop the state table from functioning. In fact, it may actually be what causes the connection to be put in the state table in the first place, no? Also, turning the firewall into, effectively, a packet-based firewall might have a detrimental affect on network throughput not only between AR and Oracle but for any other connections on that firewall due to increased overhead...or am I wrong?
Re: ARS 7/Oracle and Firewalls/Network devices
You could write an api program that would hit all threads on all queues, only problem with this approach is that it will block ALL operations on the server for all the queues you are hitting. This would also have to be timed with the state expiration policy on the firewall, which for most firewalls are somewhere in the neighborhood of the following table: tcp.first 120s tcp.opening 30s tcp.established 86400s tcp.closing 900s tcp.finwait 45s tcp.closed 90s tcp.tsdiff 30s * with tcp.established being the relevant parameter A keep-alive from arserver would be ideal, but only the people at BMC can make that happen, which, as unfortunate as it is, usually means a lot of waiting, the don't hold your breath kind of waiting. Hope someone with a mind to read the list and other web communities gets the AR System product manager position that David posted. Axton Grams On 9/20/07, Carey Matthew Black [EMAIL PROTECTED] wrote: Just a few WAGs... I am not sure if these would cause DB IO for each thread or not: Maybe you could force the server to re-read is db? ( arsignal -g ) Maybe you could change an ARS object's helptext and try force the server to shake the threads You could also write a small api program to login and used all the right RPC numbers... but that would be tedious. And I am not sure you could hit all of the threads in the Fast/List/Private set to. That would be a bit more difficult, and exactly what your trying to do. :( -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/19/07, Axton [EMAIL PROTECTED] wrote: The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall
Re: ARS 7/Oracle and Firewalls/Network devices
Your firewall is probably using state tracking to track which machines are allowed to talk with one another and the timeouts associated with state tracking are configured to time out after x seconds of inactivity. Since many of the connections between the db and the arserver are idle at night, the firewall drops the connections from the state table, thus severing the connection. The best solution I see is to configure the firewall to explicitly allow traffic between the two hosts based on the source ip, destination ip, and designated destination port, e.g., allow arserver - dbserver:1523 This takes state tracking out of the equation and will allow the arserver to talk with the db server regardless of activity/inactivity, thus allowing the original socket connection to persist. For more information on stateful packet filtering, see: http://en.wikipedia.org/wiki/Stateful_firewall The main thing to understand is that each time a host connects to another host, a state is added to the state table and remains there until x amount of time of inactivity. Future connections between the two hosts will require another state, thus causing the client to renegotiate the source port since most stateful firewalls only allow SYN packets through when establishing a state. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: Hello all, Does anyone on this list have any experience with AR 7 on RHEL 4 and Oracle 10g where the AR server and Oracle server are off two different interfaces on a firewall? The reason I ask: We are currently working in an environment where the AR Server is in one VLAN, the Oracle server is in another, the two VLANs are separated by at least one router and a firewall. We've found that an idle AR server, say overnight, will lose connection to the Oracle database which will cause users to see ARERR 552m ORA-03114 and ORA- 03135 errors on the screen and in arerror.log. If, after such an idle period, a user attempts to log in to RUT several times in a row they eventually get connected and the AR server begins to respond appropriately. Other times users can get logged in fine but get the errors when navigating forms or firing workflow. We also see these errors in arerror.log on archiving processes where the gap between runs of the archival is greater than one hour. If we move the AR server and the Oracle server onto the same VLAN and take the firewall (and anything else between the two) out of the equation the problem goes away --not to mention performance of the AR server is much faster. Has anyone run into this before and have some insight? Thanks! J.T. Shyman ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7/Oracle and Firewalls/Network devices
Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic to pass without undergoing validation against the rulebase for every packet. Adding a rule that allows a single port connection, which is what we had before, doesn't stop the state table from functioning. In fact, it may actually be what causes the connection to be put in the state table in the first place, no? Also, turning the firewall into, effectively, a packet-based firewall might have a detrimental affect on network throughput not only between AR and Oracle but for any other connections on that firewall due to increased overhead...or am I wrong? Additionally, we the firewall admin put in ANY-ANY rule in place a few nights ago and the problem is still occurring. I'd hoped that this would circumvent the state table but it apparently doesn't. I don't suppose there is a AR-based solution? We could keep trying changes on the network until we effectively distroy any semblance of the original network design but that wouldn't mollify anyone. In fact, it may have the opposite affect. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. Does this sound like a good approach to anyone? Any and all thoughts and comments are welcome! Thanks! J.T. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7/Oracle and Firewalls/Network devices
Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic to pass without undergoing validation against the rulebase for every packet. Adding a rule that allows a single port connection, which is what we had before, doesn't stop the state table from functioning. In fact, it may actually be what causes the connection to be put in the state table in the first place, no? Also, turning the firewall into, effectively, a packet-based firewall might have a detrimental affect on network throughput not only between AR and Oracle but for any other connections on that firewall due to increased overhead...or am I wrong? Additionally, we the firewall admin put in ANY-ANY rule in place a few nights ago and the problem is still occurring. I'd hoped that this would circumvent the state table but it apparently doesn't. I don't suppose there is a AR-based solution? We could keep trying changes on the network until we effectively distroy any semblance of the original network design but that wouldn't mollify anyone. In fact, it may have the opposite affect. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. Does this sound like a good approach to anyone? Any and all thoughts and comments are welcome! Thanks! J.T. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7/Oracle and Firewalls/Network devices
Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic to pass without undergoing validation against the rulebase for every packet. Adding a rule that allows a single port connection, which is what we had before, doesn't stop the state table from functioning. In fact, it may actually be what causes the connection to be put in the state table in the first place, no? Also, turning the firewall into, effectively, a packet-based firewall might have a detrimental affect on network throughput not only between AR and Oracle but for any other connections on that firewall due to increased overhead...or am I wrong? Additionally, we the firewall admin put in ANY-ANY rule in place a few nights ago and the problem is still occurring. I'd hoped that this would circumvent the state table but it apparently doesn't. I don't suppose there is a AR-based solution? We could keep trying changes on the network until we effectively distroy any semblance of the original network design but that wouldn't mollify anyone. In fact, it may have the opposite affect. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. Does this sound like a good approach to anyone? Any and all thoughts and comments are welcome! Thanks! J.T. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7/Oracle and Firewalls/Network devices
The escalation is (was) single threaded; in order to send traffic over every db connection, you have to exercise every thread. Since the escalation engine is single threaded, it will only occupy that one thread. If you notice in the arerror.log that all filter errors reported show 390693 as the rpc queue, it is executing everything on that one thread. In either case (single/multi-threaded escalation engine), it is only exercising the threads associated with the escalation engine, not the fast, list, callback, external auth, or custom queues. Axton Grams On 9/19/07, patrick zandi [EMAIL PROTECTED] wrote: ** Why not an afterhour escalation... instead.. Say every 10 minutes.. to do table queries or a report or two.. from 1800 - 0712 or something... On 9/19/07, Axton [EMAIL PROTECTED] wrote: Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. Depends on your firewall and the rule. Typically, states are created using only SYN packets, if state can be created on other packet types, you are still using stateful packet inspection, you are just allowing different packet types to add the session to the state table. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. I was thinking this as I was reading your email, though I am not sure how you would hit the admin and every fast/list/custom queue's threads without occupying all of them simultaneously. The api, to my knowledge, does not give you the capability to control what thread you are using, which means that your api will have to be multi-threaded and will have to occupy the max number of configured threads per rpc queue, which will cause your remedy server to appear to hang (i.e., block other operations on those queues). Can you share what type of firewall you are using? If you really want to remove the firewall from the equation, remove it from the network, or completely disable it. I can't see that vlan tagging would cause any issues with this. vlan's are configured in one of two way's, on the switch per port or the tagging is handled by the end nodes. If it is on the switch, it will be transparent to the client. Axton Grams On 9/19/07, J.T. Shyman [EMAIL PROTECTED] wrote: ** Axton, Appreciate your input! I should have mentioned that we've been up and down that highway and haven't seen a blasted thing. (apologies to Glen Frey) What you are saying is exactly what I thought and we've disabled the idle timeout on the firewall. I know this may not be the same thing as preventing the firewall from using a state table but the firewall admin tells us he now sees idle connections with idle times 60 minutes. So, we're kind of thinking we've eliminated the firewall as a cause...although we may not have, we aren't pursuing that any longer. Actually, now that I re-read your post I don't think putting a specific rule will side-step state checking. The purpose of a state table on a firewall is to speed up handling of traffic by allowing already known good traffic to pass without undergoing validation against the rulebase for every packet. Adding a rule that allows a single port connection, which is what we had before, doesn't stop the state table from functioning. In fact, it may actually be what causes the connection to be put in the state table in the first place, no? Also, turning the firewall into, effectively, a packet-based firewall might have a detrimental affect on network throughput not only between AR and Oracle but for any other connections on that firewall due to increased overhead...or am I wrong? Additionally, we the firewall admin put in ANY-ANY rule in place a few nights ago and the problem is still occurring. I'd hoped that this would circumvent the state table but it apparently doesn't. I don't suppose there is a AR-based solution? We could keep trying changes on the network until we effectively distroy any semblance of the original network design but that wouldn't mollify anyone. In fact, it may have the opposite affect. We talked to BMC a few weeks ago and they told us theoretically that it would be possible to write a custom API that would run custom workflow (neither of which they could give us) that would hit all of the server's Oracle connections at the same time often enough to prevent anything from seeing them as idle. Does this sound like a good approach to
Re: ARS 7 and FTS - SOLVED
Here's what we figured out with the final problem we were having with FTS. The server I upgraded to ARS 7 also has SLA installed. Many fields on various SLA forms are marked for full-text indexing; it's just that a 6.3 server ignores that attribute. Once the server was upgraded to ARS 7, all the fields on SLA forms marked for FTS became active for lack of a better word, so when saving an issue that had an active SLA running against it, the FTS service couldn't update the FTS table for the SLA:Rule Event Occurrence form because the initial index had never been created. What I ended up doing was going through all the SLA fields that were marked for FTS indexing, removing them from FTS and adding them back in to FTS so the Hummingbird tables would get created. That's the hard way. BMC told me that triggering a re-index operation would have the same effect. Mike On Jun 20, 12:14 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I submitted an issue with BMC support about this, and we've managed to figure out part of the problem. Since I'm testing this on a development server, I have Cache-mode (Development Cache Mode checkbox in the admin tool in server info, configuration tab) set to 1 in ar.cfg. Turns out this being on will cause client's to be blocked until any pending admin operations complete (initially tagging a field forFTSis an admin operation). Setting Cache-mode to 0 and restarting the server now will allow me to mark a field forFTS, save the form, and have my admin tool and any clients function normallywell, almost. I figure now that I have the client blocking problem figured out, I'll queue up indexing operations for the issue summary and issue details fields on SPRT:Issue and Interaction Notes on SPRT:Interaction. Both operations queue up successfully (I can see them in the ft_pending table). Now I'll go see what the performance hit to the clients looks like. I go open a test issue, make some changes, save the issue, performance isn't really all that different. I like what I see. I go to add an activity to the same test ticket, no problem there either. I open another test ticket (created just a few days ago, not weeks ago) make some changes (not to FT-indexed fields, just the assigned person field), click saveuh-oh: ARERR [657] Failed to complete full text operation : [Hummingbird] [SearchServer]Invalid table name (FTSTATE SGS00) Huh? How is it that the table exists for the older issue but not this newer one? I checked the Hummingbird directory, and I see a bunch of files with various extensions that appear to match the table names mentioned in the full-text log. For example: t370c300120200.cat t370c300169300.cat Anyway, I'm still working with BMC on this one. Just wanted to post an update in case anyone was interested. Cheers! Mike On Jun 19, 9:17 am, patrick zandi [EMAIL PROTECTED] wrote: Here is some additional helps --step 1- So yourFTSCollection Directory is the correct one. FTSConfiguration Directory is correct FTSTemp directory is correct I have indexing failure recover interval (minutes) 60 Temporary table threshold (1-250) 200 Complex search threshold 100 Indexer opticization threshold 1000 Case: insensitive Query unchanged - My reindex is grayed out - Diable full text indexer is not selected ignore workds list is the default installation. step 2 AR .CONF Full-Text-License-Timeout: 1 FTS-Debug-mode: 15 Full-Text-Collection-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Configuration-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Temp-Directory: C:\Documents and Settings\Administrator\Local Settings\Temp\1 step 3= under the SearchServer Admin --- you have tables there right ? can you select one, and see table data? select index long --- what kind of times do you see there.. are they long ? Step 4-- When you drop a smaller index and tell it to index again -- did you also remove the index from the SearchServer admin ? next time you drop one, do that, and then watch your I/O on your solaris box while doing the indexing .. vmstat 1 2000 - IOstat -xtc 2 2000 Examine output --- if your vmstat has alog of B (second column) numbers in a row -- this is bad. If you have the MF section consistantly high or double digits.. this is bad If you have the DE section Consistanly high = this is bad. --- IOstat exam - If a disk shows consistently high reads/writes along with , the percentage busy (%b) of the disks is greater than 5 percent, and the average service time (svc_t) is greater than 30 milliseconds http://www.adminschoice.com/docs/iostat_vmstat_netstat.htm hopefully this will help you some.. zandi On 6/18/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Oh, I should have mentioned that I have a separate thread queue set up for
Re: ARS 7 and FTS - Partially Solved
I submitted an issue with BMC support about this, and we've managed to figure out part of the problem. Since I'm testing this on a development server, I have Cache-mode (Development Cache Mode checkbox in the admin tool in server info, configuration tab) set to 1 in ar.cfg. Turns out this being on will cause client's to be blocked until any pending admin operations complete (initially tagging a field for FTS is an admin operation). Setting Cache-mode to 0 and restarting the server now will allow me to mark a field for FTS, save the form, and have my admin tool and any clients function normallywell, almost. I figure now that I have the client blocking problem figured out, I'll queue up indexing operations for the issue summary and issue details fields on SPRT:Issue and Interaction Notes on SPRT:Interaction. Both operations queue up successfully (I can see them in the ft_pending table). Now I'll go see what the performance hit to the clients looks like. I go open a test issue, make some changes, save the issue, performance isn't really all that different. I like what I see. I go to add an activity to the same test ticket, no problem there either. I open another test ticket (created just a few days ago, not weeks ago) make some changes (not to FT-indexed fields, just the assigned person field), click saveuh-oh: ARERR [657] Failed to complete full text operation : [Hummingbird] [SearchServer]Invalid table name (FTSTATE SGS00) Huh? How is it that the table exists for the older issue but not this newer one? I checked the Hummingbird directory, and I see a bunch of files with various extensions that appear to match the table names mentioned in the full-text log. For example: t370c300120200.cat t370c300169300.cat Anyway, I'm still working with BMC on this one. Just wanted to post an update in case anyone was interested. Cheers! Mike On Jun 19, 9:17 am, patrick zandi [EMAIL PROTECTED] wrote: Here is some additional helps --step 1- So your FTS Collection Directory is the correct one. FTS Configuration Directory is correct FTS Temp directory is correct I have indexing failure recover interval (minutes) 60 Temporary table threshold (1-250) 200 Complex search threshold 100 Indexer opticization threshold 1000 Case: insensitive Query unchanged - My reindex is grayed out - Diable full text indexer is not selected ignore workds list is the default installation. step 2 AR .CONF Full-Text-License-Timeout: 1 FTS-Debug-mode: 15 Full-Text-Collection-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Configuration-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Temp-Directory: C:\Documents and Settings\Administrator\Local Settings\Temp\1 step 3= under the SearchServer Admin --- you have tables there right ? can you select one, and see table data? select index long --- what kind of times do you see there.. are they long ? Step 4-- When you drop a smaller index and tell it to index again -- did you also remove the index from the SearchServer admin ? next time you drop one, do that, and then watch your I/O on your solaris box while doing the indexing .. vmstat 1 2000 - IOstat -xtc 2 2000 Examine output --- if your vmstat has alog of B (second column) numbers in a row -- this is bad. If you have the MF section consistantly high or double digits.. this is bad If you have the DE section Consistanly high = this is bad. --- IOstat exam - If a disk shows consistently high reads/writes along with , the percentage busy (%b) of the disks is greater than 5 percent, and the average service time (svc_t) is greater than 30 milliseconds http://www.adminschoice.com/docs/iostat_vmstat_netstat.htm hopefully this will help you some.. zandi On 6/18/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Oh, I should have mentioned that I have a separate thread queue set up for the full-text indexer: RPC 390602, min 4 max 8. This is a reserved RPC number, if you will, for the full text indexer according to the configuration guide (Configuring-700.pdf, page 153). Mike On Jun 17, 1:19 pm, Jarl Grøneng [EMAIL PROTECTED] wrote: This does not help. Admin tool always use rpc 309600, and single threaded. This is because you need constency in the database. -- Jarl On 6/17/07, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** What about using a private thread when you create the indexes? Add a private thread (say 309650 with min 2 max 4) to the server and specify this thread when using the Admin tool. This way you shouldn't tie up the admin thread. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, June 15, 2007 3:58 PM To: [EMAIL PROTECTED] Subject: Re: ARS 7 and FTS ** I might
Re: ARS 7 and FTS
We only replaced the files for patch 3.. Are you looking for something special? On 6/18/07, patrick zandi [EMAIL PROTECTED] wrote: ** George - From the ARS 7.01 P3 level - did you use the installer or file replacement ? For my own side information ? did you have any issues with your installation? On 6/18/07, George Barsan [EMAIL PROTECTED] wrote: Hi Mike, all, I've been troubleshooting FTS related bugs with BMC over the last weeks.. We're running on Solaris 10, Oracle and ARS 7.0.1 Patch 3 and ran into very strange behaviour (indexing fails, takes extremely long - i.e. more then 3 days on 250k records, failover within the server group only works sometimes although Full-Text-Indexer-Recovery-Interval is set to 2 minutes), etc. Is anybody else experience similar problems? Thanks regards, George ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 and FTS
That was on solaris right ? I cannot get it to work on MS - so I was just checking.. thanks. On 6/19/07, George Barsan [EMAIL PROTECTED] wrote: We only replaced the files for patch 3.. Are you looking for something special? On 6/18/07, patrick zandi [EMAIL PROTECTED] wrote: ** George - From the ARS 7.01 P3 level - did you use the installer or file replacement ? For my own side information ? did you have any issues with your installation? On 6/18/07, George Barsan [EMAIL PROTECTED] wrote: Hi Mike, all, I've been troubleshooting FTS related bugs with BMC over the last weeks.. We're running on Solaris 10, Oracle and ARS 7.0.1 Patch 3 and ran into very strange behaviour (indexing fails, takes extremely long - i.e. more then 3 days on 250k records, failover within the server group only works sometimes although Full-Text-Indexer-Recovery-Interval is set to 2 minutes), etc. Is anybody else experience similar problems? Thanks regards, George ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 and FTS
Here is some additional helps --step 1- So your FTS Collection Directory is the correct one. FTS Configuration Directory is correct FTS Temp directory is correct I have indexing failure recover interval (minutes) 60 Temporary table threshold (1-250) 200 Complex search threshold 100 Indexer opticization threshold 1000 Case: insensitive Query unchanged - My reindex is grayed out - Diable full text indexer is not selected ignore workds list is the default installation. step 2 AR .CONF Full-Text-License-Timeout: 1 FTS-Debug-mode: 15 Full-Text-Collection-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Configuration-Directory: C:\Program Files\Hummingbird\SearchServer 5.4\fultext Full-Text-Temp-Directory: C:\Documents and Settings\Administrator\Local Settings\Temp\1 step 3= under the SearchServer Admin --- you have tables there right ? can you select one, and see table data? select index long --- what kind of times do you see there.. are they long ? Step 4-- When you drop a smaller index and tell it to index again -- did you also remove the index from the SearchServer admin ? next time you drop one, do that, and then watch your I/O on your solaris box while doing the indexing .. vmstat 1 2000 - IOstat -xtc 2 2000 Examine output --- if your vmstat has alog of B (second column) numbers in a row -- this is bad. If you have the MF section consistantly high or double digits.. this is bad If you have the DE section Consistanly high = this is bad. --- IOstat exam - If a disk shows consistently high reads/writes along with , the percentage busy (%b) of the disks is greater than 5 percent, and the average service time (svc_t) is greater than 30 milliseconds http://www.adminschoice.com/docs/iostat_vmstat_netstat.htm hopefully this will help you some.. zandi On 6/18/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Oh, I should have mentioned that I have a separate thread queue set up for the full-text indexer: RPC 390602, min 4 max 8. This is a reserved RPC number, if you will, for the full text indexer according to the configuration guide (Configuring-700.pdf, page 153). Mike On Jun 17, 1:19 pm, Jarl Grøneng [EMAIL PROTECTED] wrote: This does not help. Admin tool always use rpc 309600, and single threaded. This is because you need constency in the database. -- Jarl On 6/17/07, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** What about using a private thread when you create the indexes? Add a private thread (say 309650 with min 2 max 4) to the server and specify this thread when using the Admin tool. This way you shouldn't tie up the admin thread. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, June 15, 2007 3:58 PM To: [EMAIL PROTECTED] Subject: Re: ARS 7 and FTS ** I might be working some this weekend.. I will try a couple of things to see if anything like what you are seeing.. happens.. On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've
Re: ARS 7 and FTS
Oh, I should have mentioned that I have a separate thread queue set up for the full-text indexer: RPC 390602, min 4 max 8. This is a reserved RPC number, if you will, for the full text indexer according to the configuration guide (Configuring-700.pdf, page 153). Mike On Jun 17, 1:19 pm, Jarl Grøneng [EMAIL PROTECTED] wrote: This does not help. Admin tool always use rpc 309600, and single threaded. This is because you need constency in the database. -- Jarl On 6/17/07, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** What about using a private thread when you create the indexes? Add a private thread (say 309650 with min 2 max 4) to the server and specify this thread when using the Admin tool. This way you shouldn't tie up the admin thread. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, June 15, 2007 3:58 PM To: [EMAIL PROTECTED] Subject: Re: ARS 7 and FTS ** I might be working some this weekend.. I will try a couple of things to see if anything like what you are seeing.. happens.. On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60
Re: ARS 7 and FTS
Hi Mike, all, I've been troubleshooting FTS related bugs with BMC over the last weeks.. We're running on Solaris 10, Oracle and ARS 7.0.1 Patch 3 and ran into very strange behaviour (indexing fails, takes extremely long - i.e. more then 3 days on 250k records, failover within the server group only works sometimes although Full-Text-Indexer-Recovery-Interval is set to 2 minutes), etc. Is anybody else experience similar problems? Thanks regards, George ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 and FTS
What about using a private thread when you create the indexes? Add a private thread (say 309650 with min 2 max 4) to the server and specify this thread when using the Admin tool. This way you shouldn't tie up the admin thread. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, June 15, 2007 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 and FTS ** I might be working some this weekend.. I will try a couple of things to see if anything like what you are seeing.. happens.. On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60 minutes to upgrade arserver, email, mid-tier, etc., about 90 minutes to index one field
Re: ARS 7 and FTS
This does not help. Admin tool always use rpc 309600, and single threaded. This is because you need constency in the database. -- Jarl On 6/17/07, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** What about using a private thread when you create the indexes? Add a private thread (say 309650 with min 2 max 4) to the server and specify this thread when using the Admin tool. This way you shouldn't tie up the admin thread. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, June 15, 2007 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 and FTS ** I might be working some this weekend.. I will try a couple of things to see if anything like what you are seeing.. happens.. On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60 minutes to upgrade arserver, email, mid-tier, etc., about 90 minutes to index one field on SPRT:Issue, and roughly 5.5 hours to index one field on SPRT:Interaction. This adds up to (again, approximately) eight full hours (or more) of complete and utter downtime (not a good deal for a 24x7 shop). Thoughts? Other stories to share? Thanks everyone. Mike Wallick -- Patrick Zandi -- Patrick Zandi
Re: ARS 7 and FTS
Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60 minutes to upgrade arserver, email, mid-tier, etc., about 90 minutes to index one field on SPRT:Issue, and roughly 5.5 hours to index one field on SPRT:Interaction. This adds up to (again, approximately) eight full hours (or more) of complete and utter downtime (not a good deal for a 24x7 shop). Thoughts? Other stories to share? Thanks everyone. Mike Wallick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 and FTS
Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60 minutes to upgrade arserver, email, mid-tier, etc., about 90 minutes to index one field on SPRT:Issue, and roughly 5.5 hours to index one field on SPRT:Interaction. This adds up to (again, approximately) eight full hours (or more) of complete and utter downtime (not a good deal for a 24x7 shop). Thoughts? Other stories to share? Thanks everyone. Mike Wallick ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 and FTS
I might be working some this weekend.. I will try a couple of things to see if anything like what you are seeing.. happens.. On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, 32 is pretty excessive, but I was trying to see if I could get the behavior to change. Just to be clear, updating the FT index when a record changes take virtually no time at all. It's the initial indexing when one first marks a field to be full text indexed that's locking up the server. My dev server has the DB, ARS, and FTS on the same box (production has separate HW for ARS and SQL). It's a Dell 1850, two 3GHz Xeon CPU (single core), 4GB RAM, HW resources really doesn't seem to be the issue. Mike On Jun 15, 2:21 pm, patrick zandi [EMAIL PROTECTED] wrote: Mike, I have ARS 7.00 P2 and FTS. FTS is working fine, and it very fast on the updates.. and accurate from what I have tested. I have not seen the lockup at all. I am not on 7.01P2 yet, however I tryed P3 and could not login to the server.. I do not know if it was related to what you are saying yet... My Java is a lower version though.. and I am on SP2. Java 1.4.2_13 The record count is close to mine on some and it does not take long at all to update it. Threads for me are 4 - 8max..have no issues,, 32 seems quiet excessive though. What kind of HW ? Multiple CPU's ? duel/quad core's ? is the DB and ARS on same with FTS ? Hope this give you some info... On 6/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone out there using FTS on ARS 7? If so, I have some questions about your experiences: First off (this is one of my development servers): ARS 7.0.1 patch 2, Windows 2003 SP1, SQL 2000 SP4, Java 1.5.0_11 So I recently purchased some FTS fixed user licenses and I've applied them to one of my development servers where I have a bunch of home grown apps, one of which is a help desk application. I've marked two zero-length character fields (i.e. long text fields) for full text indexing (the problem description and the work log). Upon saving the form, the initial indexing starts (fine), but now my admin tool is locked and will either time our after an unusually long period of time, or will remain locked until the indexing is complete. Also, from a client perspective, the server is COMPLETELY UNAVAILABLE (ARERR 93 - timeout during data retrieval due to busy server -- retry the operation). While I expect that an initial FT index would take some time to complete on 70,000 records, I do not expect the indexing operation to tie up the server so terribly that clients can't even log in. It doesn't appear to be a resource issue, arserver.exe is only using between 5 and 20 percent of the CPU, and as of right now, there is nearly 3GB of physical RAM available. At first I thought it might be a thread thing, so I upped fast/list/ ftindexer threads to min 4 max 32 (from min 2 max 4), but that doesn't seem to have made a difference. I have plans to also implement FTS on my CSS servers, where I'd like to index the Issue Details field on the SPRT:Issue form and the Interaction Notes field on the SPRT:Interaction field, as those fields are heavily searched. However, based on some initial testing I've done, performing an initial index on the Issue Details field on about 200,000 records takes about 95 minutes to complete (that's a reasonable amount of time IMHO), but the server is completely unavailable while indexing. OK, that's not so bad, but when I started to calculate some rough times for the SPRT:Interaction form, I was coming up with times in excess of five and a half hours (about 700,000 records). So, to upgrade my production CS servers to ARS 7, I'm looking at 30-60 minutes to upgrade arserver, email, mid-tier, etc., about 90 minutes to index one field on SPRT:Issue, and roughly 5.5 hours to index one field on SPRT:Interaction. This adds up to (again, approximately) eight full hours (or more) of complete and utter downtime (not a good deal for a 24x7 shop). Thoughts? Other stories to share? Thanks everyone. Mike Wallick ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 installation - strange issue
Hello Bipin, Thanks for the reply. But my original problem is that the installation detects an existing ARS installation eventhough it is a freshly formatted m/c with a new OS and database. Regards, Murtuza. From: Vyom Labs - ITSM Support [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 installation - strange issue Date: Mon, 30 Apr 2007 06:45:32 +0530 Hi Murtuza, At the time of installation of AR Sever, we need to give the SQL login/password for the database to create the AR Database in SQL Server. If it is been set for windows authentication, the login password will be same as windows login password. Or specify your SQL Server database Username Password (SA UserName / SA User Password). Thus please check for the User Name and password for the database. Regards, Bipinchandra Bhavsar -- www.vyomlabs.com Consulting | Oursourcing | Training || ITIL | IT Governance |BMC Remedy msb * wrote: Hello all, I am doing an installation of ARS 7.0.1 on a fresh test server with a brand new OS - Win 2003 sp1 and SQL server 2000 SP4. But when I run the install, it tells me that it detected an existing installation and whether I want to upgrade or overwrite. Does anyone know how this could be possible? The database is on the same machine. When I try to install by selecting overwrite, the installation continues to the point where it tries to start the Remedy services. This fails with ARERR 623 - Authentication failed. What gives ??? Regards, Murtuza B. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 installation - strange issue
Hi Rick, I had the database uninstalled and reinstalled, but I am facing the same issue. I also tried removing SQL 2000 and installing SQL 2005, but no luck. Anybody else facing this? Regards, Murtuza. From: Rick Cook [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 installation - strange issue Date: Sun, 29 Apr 2007 08:09:44 -0700 My guess is that you have an existing Remedy DB user in your DB from a previous attempt at a Remedy install. Have your DBA check for that and remove it if it's there. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of msb * Sent: Sunday, April 29, 2007 5:04 AM To: arslist@ARSLIST.ORG Subject: ARS 7 installation - strange issue Hello all, I am doing an installation of ARS 7.0.1 on a fresh test server with a brand new OS - Win 2003 sp1 and SQL server 2000 SP4. But when I run the install, it tells me that it detected an existing installation and whether I want to upgrade or overwrite. Does anyone know how this could be possible? The database is on the same machine. When I try to install by selecting overwrite, the installation continues to the point where it tries to start the Remedy services. This fails with ARERR 623 - Authentication failed. What gives ??? Regards, Murtuza B. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 installation - strange issue
Hi Murtuza, At the time of installation of AR Sever, we need to give the SQL login/password for the database to create the AR Database in SQL Server. If it is been set for windows authentication, the login password will be same as windows login password. Or specify your SQL Server database Username Password (SA UserName / SA User Password). Thus please check for the User Name and password for the database. Regards, Bipinchandra Bhavsar -- www.vyomlabs.com Consulting | Oursourcing | Training || ITIL | IT Governance |BMC Remedy msb * wrote: Hello all, I am doing an installation of ARS 7.0.1 on a fresh test server with a brand new OS - Win 2003 sp1 and SQL server 2000 SP4. But when I run the install, it tells me that it detected an existing installation and whether I want to upgrade or overwrite. Does anyone know how this could be possible? The database is on the same machine. When I try to install by selecting overwrite, the installation continues to the point where it tries to start the Remedy services. This fails with ARERR 623 - Authentication failed. What gives ??? Regards, Murtuza B. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 installation - strange issue
My guess is that you have an existing Remedy DB user in your DB from a previous attempt at a Remedy install. Have your DBA check for that and remove it if it's there. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of msb * Sent: Sunday, April 29, 2007 5:04 AM To: arslist@ARSLIST.ORG Subject: ARS 7 installation - strange issue Hello all, I am doing an installation of ARS 7.0.1 on a fresh test server with a brand new OS - Win 2003 sp1 and SQL server 2000 SP4. But when I run the install, it tells me that it detected an existing installation and whether I want to upgrade or overwrite. Does anyone know how this could be possible? The database is on the same machine. When I try to install by selecting overwrite, the installation continues to the point where it tries to start the Remedy services. This fails with ARERR 623 - Authentication failed. What gives ??? Regards, Murtuza B. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7, Windows server capacity info please
ARS 7, Windows server capacity info pleaseI'm not really big on Windows OS, but one recommendation I could offer is give Windows 2003 64 bit / MS-SQL 2005 64 bit a shot.. I've just heard from support that there are no known issues running ARS on this environment.. Reason this would be a better choice over a 32 bit environment is that to the best of my knowledge 64 bit Win OS can better manage higher memory boxes than its 32 bit counterpart.. I'm not quite sure about how accurate the source of this information is as I heard it from a Windows administrator and haven't really read any white papers or tech notes on it.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Anderson, Douglas W. Sent: Wednesday, April 18, 2007 12:20 PM To: arslist@ARSLIST.ORG Subject: ARS 7, Windows server capacity info please ** Hi ARSListers, We are moving from all-custom applications on Solaris/Sybase/ARS 6.3 to a mix of custom applications and ITSM 7 on Windows Server/MS SQL/ARS 7.x. We need to support 200-400 concurrent users, 75-150 of whom are using the WUT and the others on mid tier. Our Windows Server team would appreciate some real-world input on server sizing. I have searched the ARSList archives extensively (exhaustingly, if not necessarily exhaustively) and found relatively little guidance on this topic for current ARS versions. I did find a response from James McKenzie back in November '06 and one from Christopher Strauss in February '07 that shed some indirect light on the subject. Thanks gents for those. If you are running ARS 7.x on Windows servers, would you be so kind as to share your experience regarding the following? What is your user load application mix? What hardware are you using (CPU type count, clock speeds, RAM, etc.) for Windows servers, for which bits of the puzzle (ARS server, mid tier, database server). How are the bits combined on, or separated between, server hardware? Are you using load balancing hardware/software? If so, what/where? What typical and peak-load response time,s or other performance metrics, do you observe (WUT vs. mid tier)? Thanks for any clues, Doug Anderson Mayo Clinic Rochester, MN __20060125___This posting was submitted with HTML in it___ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.2/766 - Release Date: 4/18/2007 7:39 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7, Windows server capacity info please
Our current pre-production setup has evolved a lot over the last few months, due to issues with various services that ITSM 7 requires that either do not play well together, or do not like an x64 environment. Here is our current server sizing and distribution: ARSYSTEM SQL SERVER * DL385 2 x Dual Core 2.6 ghz 10 gb RAM * Windows Server 2003 Enterprise x64 * SQL Server 2005 x64 * ARSystem Database REMEDY AR SERVER * DL385 2 x Dual Core 2.2 ghz 10 gb RAM * Windows Server 2003 Enterprise * JRE 1.4.2 * ServletExec AS 5.0 * 7.x Components: ARS, AREmail, AREA ARDBC, Approval, Assignment; CMDB 2.0 * 7.x Applications: Incident, Problem, Change, and Service Level Management, Enterprise Integration Engine Data Exchange, Remedy Knowledge Management integration to ITSM * SLM Collector REMEDY KNOWLEDGE MANAGEMENT WEB SERVER AND EIE SERVER * DL380 2 x Xeon 3.06 ghz 3 gb RAM * Windows Server 2003 Enterprise * SQL Server 2005 [RKM db] * JDK 1.5.0 * Tomcat 5.5.20 (Installed by RKM 7.1.01) * SearchServer 5.4 * RightAnswers SelfService, Support Analyst * 7.x Components: Remedy Knowledge Management 7.1.01, EIE and SQL Server Adapter 7.0.01.003 CRYSTAL REPORT SERVER WITH MID-TIER WEB SERVER * DL380 2 x Xeon 3.06 ghz 3 gb RAM * Windows Server 2003 Enterprise R2 * SQL Server 2005 [CR11 db] * IIS 6.0 * JDK 1.4.2 * Tomcat 5.5.17 (Servlet Only) * Crystal Reports Server XI (running on IIS using .NET 2.0) * 7.x Components: Mid-Tier, Flashboards * ARSPerl Scripts PRODUCTION MID-TIER WEB SERVER * DL380G5 2 x Quad Core 1.87 ghz 12 gb Ram * Windows Server 2003 R2 Enterprise x64 * SQL Server 2005 x64 [SharePoint web] * IIS 6.0 [SharePoint web] * SharePoint Server 2007 * JDK 1.4.2 * Apache Tomcat 5.5.17 (Web and Servlet as installed by mid-tier) * 7.x Components: Mid-Tier, Flashboards, CI Viewer, probably the SLM Collection Point INTEGRATION SQL SERVER * DL385 2 x Dual Core 2.2 ghz 10 gb RAM * Windows Server 2003 Enterprise x64 * SQL Server 2005 x64 [for LDAP, EIE] * SMS 2003 * FTP Server (IIS 6 web not active) * LDAP Integration (People and Jobs) * Asset Integration * MySoft Integration Crystal, Mid-tier, and Remedy Knowledge Management are particularly problematic. I have all three running on my development web server, but with several problems that I will not accept for production. Installed together on the mid-tier-installed Tomcat instance, the web management interface into Crystal is not available, and any time RKM crashes tomcat (try an unqualified search of the kb) then Tomcat restarts and then mid-tier runs the AR server ragged for over 30 minutes while a prefetch of the ITSM application runs again. Without prefetch, web response times for ITSM 7 consoles are over a minute for first-time loads, close to a minute for all other forms. After a prefetch, first-time loads are 8-15 seconds, subsequent loads are 3-4 seconds similar to the User Tool. No one here is impressed with mid-tier performance - it is unacceptably slow until it has been running a while and all of the forms have been fully cached; prefetching is essential but only serves to bring the initial form loads into a tolerable delay range. NOTE - while a prefetch is running, ALL access to the AR Server from ANY client is noticeably degraded. I had to put EIE on the RKM server since it was 32-bit - EIE did not work properly on x64 or I would have kept it on the Integration SQL Server where its db resides. We are very satisfied with the performance of SQL Server 2005 x64 on Windows Server 2003 Enterprise x64. We have seen too many of the BMC Remedy 32-bit components misbehave on x64 platforms so have reverted many of them back to x86 - the last holdout is the mid-tier server, since it would be almost criminal to revert that much hardware from x64 to x86, but it is under consideration. Applying the x64 version of Service Pack 2 for Win2K3 to that server stopped Tomcat cold - it was unable to start until I removed the service pack. There are no such problems on three different servers with mid-tier or RKM using Tomcat after installing the x86 version of Service Pack 2. We are not in production yet, but are sizing for use by 300 support staff over both User Tool and mid-tier, and an active customer base of over 45,000, although we will be loading a customer table from PeopleSoft that has about 320,000 entries. That is our current load on our ITSM 5.5 / ARS 5.1.2 system. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anderson, Douglas W. Sent: Wednesday, April 18, 2007 11:20 AM To:
Re: ARS 7 FTS different servers
Have not seen anything on this .. Anyone ? Also I attempted to install, and it seems like it did not work.. I cannot prove it as.. I found out it will not work without at least 1 FTS license.. installed. Anyone ? On 3/21/07, patrick zandi [EMAIL PROTECTED] wrote: I know I saw someone post something on this subject, but cannot find.. Wasn't there some issue with ARS 7.X having the server with FTS, on one physical box, and oracle on the other physical box ? -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 bug: $SCHEMA$ on menu qualification
Joe: Thanks Joe I hadn't thought of it. This field is Assigned To Group, so not allowing typing is perhaps not feasible (to allowd them to do leading search), but in other situations it's a good (and I guess modern) solution. --- Joe DeSouza [EMAIL PROTECTED] wrote: Instead of patterning the field to $MENU$ why dont you use the Display-Type as a drop down then.. it works exactly the way $MENU$ was designed to work except that you can't type into the field but select from the menu only... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Rabi Tripathi [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, March 13, 2007 6:11:54 PM Subject: ARS 7 bug: $SCHEMA$ on menu qualification I just figured out that if you have $SCHEMA$ keyword on any menu's qualification, it behaves very differently in ARS 7 (vs ARS 5, and perhaps ARS 6.x as well). In older versions, $SCHEMA$ always expanded to the name of the form where it is attached. In 7.x it gets two different values, depending on the context. For example if a menu gets its values from MenuSource form and is attached to forms Form1 and Form2 $SCHEMA$ in the menu's qualification always expanded to mean Form1 or Form2, depending on which form are you at. Not any more. In 7, when the menu is opened on any form , say Form1, $MENU$ in the menu's qualification still expands to Form1 and you get the expected values in the menu. However, if you have $MENU$ specified as the pattern for the field (fields's Properties, Attributes tab) save operation will most likely fail because $MENU$ expands to MenuSource. It broke my old workflow, so I need to redesign my menus to not have $SCHEMA$. Fun. I have ARS 7.0.1 p1, AIX 5.2, Oracle 9.x. I tested with windows client only. Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. http://answers.yahoo.com/dir/?link=listsid=396545367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are TV dinner still cooling? Check out Tonight's Picks on Yahoo! TV. http://tv.yahoo.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 bug: $SCHEMA$ on menu qualification
Instead of patterning the field to $MENU$ why dont you use the Display-Type as a drop down then.. it works exactly the way $MENU$ was designed to work except that you can't type into the field but select from the menu only... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Rabi Tripathi [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, March 13, 2007 6:11:54 PM Subject: ARS 7 bug: $SCHEMA$ on menu qualification I just figured out that if you have $SCHEMA$ keyword on any menu's qualification, it behaves very differently in ARS 7 (vs ARS 5, and perhaps ARS 6.x as well). In older versions, $SCHEMA$ always expanded to the name of the form where it is attached. In 7.x it gets two different values, depending on the context. For example if a menu gets its values from MenuSource form and is attached to forms Form1 and Form2 $SCHEMA$ in the menu's qualification always expanded to mean Form1 or Form2, depending on which form are you at. Not any more. In 7, when the menu is opened on any form , say Form1, $MENU$ in the menu's qualification still expands to Form1 and you get the expected values in the menu. However, if you have $MENU$ specified as the pattern for the field (fields's Properties, Attributes tab) save operation will most likely fail because $MENU$ expands to MenuSource. It broke my old workflow, so I need to redesign my menus to not have $SCHEMA$. Fun. I have ARS 7.0.1 p1, AIX 5.2, Oracle 9.x. I tested with windows client only. Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. http://answers.yahoo.com/dir/?link=listsid=396545367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 bug: $SCHEMA$ on menu qualification
Confusing typo in previous post...pls ignore it and read this one. --- I just figured out that if you have $SCHEMA$ keyword on any menu's qualification, it behaves very differently in ARS 7 (vs ARS 5, and perhaps ARS 6.x as well). In older versions, $SCHEMA$ always expanded at run time to be the name of the form where the menu is attached. In 7.x it gets two different values, depending on the context. For example if a menu gets its values from MenuSource form and is attached to forms Form1 and Form2 $SCHEMA$ in the menu's qualification always expanded to mean Form1 or Form2, depending on which form are you at. Not any more. In 7, when the menu is opened on any form , say Form1, $SCHEMA$ in the menu's qualification still expands to be Form1 and you get the expected values in the menu. However, if you have $MENU$ specified as the pattern for the field (fields's Properties, Attributes tab) save operation will most likely fail because $MENU$ apparently expands to MenuSource when ARS is validating the value in the field. It broke my old workflow, so I need to redesign my menus to not have $SCHEMA$. Fun. I have ARS 7.0.1 p1, AIX 5.2, Oracle 9.x. I tested with windows client only. 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.x - ARSSOInfo.dll
Update: Using the sample code (sent to me by Patrick Zandi) from the second pdf below I am able to compile the arssoinfo.dll and auto-login to the Windows User Tool. But so far this only works when you specify a TCP Port 0. I guess this does not work with Port Mapper??? I tested with WUT 7.0.0 p1 and 7.0.1 p1 connecting to ARS 7.0.1 and 7.0.1 p1. Even if it will [eventually] work with Port Mapper I am not sure how useful this will be. The username, password, and server name need to be embedded within the arssoinfo.dll. And the password is stored in clear text! You can see the password with a hex editor (here is a free one http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm). I realize there are ways to obfuscate the password, such as by storing it encrypted and then decrypting it at the point it is requested. Since the username/password is embedded each user will need to have a custom compiled version of arssoinfo.dll on their computer. Has anyone found a good use for arssoinfo.dll? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, February 15, 2007 1:25 PM To: arslist@ARSLIST.ORG Subject: ARS 7.x - ARSSOInfo.dll According to http://www.bmc.com/userworld/vancouver/assets/sessions/ARSI-104_Cool_Sol utions_for_LDAP.pdf and http://documents.bmc.com/supportu/documents/57/12/65712/65712.pdf, ARSSOInfo.dll can be used to auto-login to the Windows User Tool using AREA. Has anyone got this to work? Do you need to have a third-party SSO solution already in place or does ARS now provide everything needed to auto-login (not counting the caching of passwords on the local computer)? Page 19 of the second pdf lists sample code written in C. I program in other languages. Basically the only thing I know about C is that it comes after B :) If ARS does have everything that is needed I will probably learn C. SSO in the Windows User Tool seems to be the Holy Grail these days. ARS 7.0.1 Patch 1 Windows Server 2003 SQL Server 2005 Active Directory Stephen __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7, Windows 2003 (64bit), Oracle 10g
Patrick, Thanks for the response. I had success in the past doing exactly what you did on a Solaris and Linux server. Windows is turning out to be quite a different beast. Anyone out there with any Windows/Oracle experience? Do I set ORACLE_HOME, ORACLE_SID environment variables? Other than my initial troubleshooting, I downloaded and installed the full client in a separate directory. Again, the install runs, creates ARSystem schema, but then I get the following error when attempting to import workflow: ORA-12154: TNS:could not resolve the connect identifier specified The only thing in my ar.conf file that is DB related is the following: Oracle-Two-Task: devdb01 Russell patrick zandi wrote: ** On my solaris installations, I always used an seperate oracle Full Client install and into a different home. Then I check and make sure the TNSNAMES.ora is the same as the oracle DB home. so I can make connections. Then I sqlplus from the client into the Oracle db, and check that.. Then I do an install.. Now I do not know your 64Bit env and how it fuction with the 32 Bit Oracle client, or ARS 32 bit on the 64 Bit OS.. Check the Archives.. of the list. Hope this helps some. On 1/26/07, *Russell Wurth* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** All, I am attempting to set up a Windows Server 2003 (64 bit) with Oracle 10g and ARS 7 on the same box. I am looking for any assistance from anyone with a similar configuration. I have performed installations on various UNIX platforms many times before, and a few Windows 32 bit ones, but never Win 64bit. The 64bit Oracle installation did not create an ORACLE_HOME\lib32 directory, just a regular lib directory. The Remedy install would not proceed, so I downloaded and installed the 32bit Oracle Instant Client and installed it in the lib32 directory. The Remedy install found this directory and proceeded successfully, creating the ARSystem tablespace and ARAdmin user account, as well as necessary tables. I had to use the following as my Oracle Connection String, as the Remedy install did not connect to just the SID: //servername:1521/dbsid. Again, the database is on the same server that I am installing ARS, this suggestion comes from the installation notes The install failed during the importing of sample data and workflow. I discovered the following in my arerror.log: ORA-06413: Connection not open Cannot initialize contact with SQL database (ARERR 551) This error occurs any time I start and stop the server. I am able to connect via SQL Plus (in ORACLE_HOME\bin) as ARAdmin and see the arschema tables. Do I need to install the 32bit Oracle full client with a 32bit SQLPlus? Does this go in my ORACLE_HOME or another directory? Thanks in advance for any assistance Russell Wurth __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7 - Patch 2 Sever Patch?
Same installation error here. I tried installing with mid tier 7.0 patch 1 already installed, and also after uninstalling mid tier first. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Thursday, September 21, 2006 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? I just found an issue with the Mid-Tier Patch 2 installer: After getting an error code of -6002 when trying to start the installation, I did an extraction of the install file (thinking it may have been a permissions thing), and found that there is no setup.exe in the installer. _ Add fun gadgets and colorful themes to express yourself on Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http:/ /www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Hi Matt: Now that you mention it, you're right, the readmes arent there either. Very strange. From: Matt Reinfeldt [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 10:08:43 -0500 No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Hello, Similarly there is a patch 003 published for Migrator 7.0 but if I try to download it from the support site, it only shows a invalid page error eventhough the patch was released on 9/13. I've still not contacted the Support. Has anybody else experienced it? Thanks, Mohan --- McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: All: This is not the first time that someone has 'found' a Patch and there were no files to download. It may be possible that the patch was 'announced' and then withdrawn or that the files were not posted at the time of the announcement. I would wait a day or two and then call Support and ask what is happening. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, September 20, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hi Matt: Now that you mention it, you're right, the readmes arent there either. Very strange. From: Matt Reinfeldt [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 10:08:43 -0500 No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ _ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www .get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Well, the Server p2 installer is out there now, but the Migrator patch link is still broken... From: Rick cook [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 08:59:07 -0700 Yup - I noticed the same thing. Does anyone there do testing on this stuff? Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath Sent: Wednesday, September 20, 2006 8:32 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hello, Similarly there is a patch 003 published for Migrator 7.0 but if I try to download it from the support site, it only shows a invalid page error eventhough the patch was released on 9/13. I've still not contacted the Support. Has anybody else experienced it? Thanks, Mohan --- McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: All: This is not the first time that someone has 'found' a Patch and there were no files to download. It may be possible that the patch was 'announced' and then withdrawn or that the files were not posted at the time of the announcement. I would wait a day or two and then call Support and ask what is happening. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, September 20, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hi Matt: Now that you mention it, you're right, the readmes arent there either. Very strange. From: Matt Reinfeldt [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 10:08:43 -0500 No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ _ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www .get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Uh.. some of the Server installers are out there: Windows, AIX and HPUX But the other installers? Oh look.. the bite count on the HPUX file keeps growing! I guess they are uploading the files right now. :) Yep.. there is now a partial Solaris server install. :) That is so funny.. I have never actually watched as a set of files are published to a patch dir before. :) Hope no one grabs the file before it is fully loaded to the server. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/20/06, Mike Parker [EMAIL PROTECTED] wrote: Well, the Server p2 installer is out there now, but the Migrator patch link is still broken... From: Rick cook [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 08:59:07 -0700 Yup - I noticed the same thing. Does anyone there do testing on this stuff? Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath Sent: Wednesday, September 20, 2006 8:32 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hello, Similarly there is a patch 003 published for Migrator 7.0 but if I try to download it from the support site, it only shows a invalid page error eventhough the patch was released on 9/13. I've still not contacted the Support. Has anybody else experienced it? Thanks, Mohan --- McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: All: This is not the first time that someone has 'found' a Patch and there were no files to download. It may be possible that the patch was 'announced' and then withdrawn or that the files were not posted at the time of the announcement. I would wait a day or two and then call Support and ask what is happening. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, September 20, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hi Matt: Now that you mention it, you're right, the readmes arent there either. Very strange. From: Matt Reinfeldt [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 10:08:43 -0500 No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ _ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www .get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http
Re: ARS 7 - Patch 2 Sever Patch?
I don't believe they have announced p2 yet so it may be a case of they are just putting the files out there. I would expect BMC to put the files out, do an internal test (or several), then announce the patch is available. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, September 20, 2006 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Well, the Server p2 installer is out there now, but the Migrator patch link is still broken... From: Rick cook [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 08:59:07 -0700 Yup - I noticed the same thing. Does anyone there do testing on this stuff? Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath Sent: Wednesday, September 20, 2006 8:32 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hello, Similarly there is a patch 003 published for Migrator 7.0 but if I try to download it from the support site, it only shows a invalid page error eventhough the patch was released on 9/13. I've still not contacted the Support. Has anybody else experienced it? Thanks, Mohan --- McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: All: This is not the first time that someone has 'found' a Patch and there were no files to download. It may be possible that the patch was 'announced' and then withdrawn or that the files were not posted at the time of the announcement. I would wait a day or two and then call Support and ask what is happening. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, September 20, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hi Matt: Now that you mention it, you're right, the readmes arent there either. Very strange. From: Matt Reinfeldt [EMAIL PROTECTED] Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Date: Wed, 20 Sep 2006 10:08:43 -0500 No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Good Afternoon, The readme files are now available for ARS v7 Patch 2. However, the link for Migrator v7 Patch 3 is still broken. Enjoy, Bryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Wednesday, September 20, 2006 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Fred, My definition of general release is simply this: When they put a file out there that we can generally access then it is released. An official announcement might be done after that point, but all testing should be concluded long before I can get my fast clicking, patch hungry, little hands on the first file. :) And frankly I am surprised that they do not upload the files into a directory that is not readable by most users during alpha/beta/gamma testing. Then when they are ready to release it, flip the permissions on the final form of the directory to all users. (It would avoid people from getting partial copies of the installers.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/20/06, Grooms, Frederick W [EMAIL PROTECTED] wrote: I don't believe they have announced p2 yet so it may be a case of they are just putting the files out there. I would expect BMC to put the files out, do an internal test (or several), then announce the patch is available. Fred ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
By testing I mean pulling down thru the supportweb page. For notification I still get the Customer Support eAlert emails on patches released by BMC. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, September 20, 2006 12:16 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Fred, My definition of general release is simply this: When they put a file out there that we can generally access then it is released. An official announcement might be done after that point, but all testing should be concluded long before I can get my fast clicking, patch hungry, little hands on the first file. :) And frankly I am surprised that they do not upload the files into a directory that is not readable by most users during alpha/beta/gamma testing. Then when they are ready to release it, flip the permissions on the final form of the directory to all users. (It would avoid people from getting partial copies of the installers.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/20/06, Grooms, Frederick W [EMAIL PROTECTED] wrote: I don't believe they have announced p2 yet so it may be a case of they are just putting the files out there. I would expect BMC to put the files out, do an internal test (or several), then announce the patch is available. Fred ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
Hey Curtis, Thanks for the extra information..it is available. How did you figure out though??? Cheers, Mohan --- Curtis Gallant [EMAIL PROTECTED] wrote: Migrator patch 3 is available, the problem is the link is going to patch003 when the acktual directory is Patch003 (capitol P). So easy way to get to the proper link is to make it to the 404 the patch site gives you and re-write the URL as /Patch003/ Cheers, Curtis Gallant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bryan.Waters Sent: Wednesday, September 20, 2006 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Good Afternoon, The readme files are now available for ARS v7 Patch 2. However, the link for Migrator v7 Patch 3 is still broken. Enjoy, Bryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Wednesday, September 20, 2006 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 - Patch 2 Sever Patch?
It is very often that things show up on the patch download site but have either broken links or the Download button is disabled. Most of the time it is because BMC have not included the proper URL as part of the selected entry(as in the Migrator patch003 link) or they are holding back for an announcement. What I normally do is go back to the previous patch, go up a directory or two to get to the root of a certain application then climb up the directory tree myself. This allows me to see what is actually published as opposed to what is made available via direct links from their 'patch' web application. Hope that helps. Cheers, Curtis Gallant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath Sent: Wednesday, September 20, 2006 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Hey Curtis, Thanks for the extra information..it is available. How did you figure out though??? Cheers, Mohan --- Curtis Gallant [EMAIL PROTECTED] wrote: Migrator patch 3 is available, the problem is the link is going to patch003 when the acktual directory is Patch003 (capitol P). So easy way to get to the proper link is to make it to the 404 the patch site gives you and re-write the URL as /Patch003/ Cheers, Curtis Gallant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bryan.Waters Sent: Wednesday, September 20, 2006 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? Good Afternoon, The readme files are now available for ARS v7 Patch 2. However, the link for Migrator v7 Patch 3 is still broken. Enjoy, Bryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Wednesday, September 20, 2006 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 - Patch 2 Sever Patch? No Mike, I see the same thing. There are also no README files, which is abnormal. It's almost like part of the patch didn't get published yet. I'm waiting to see if it gets cleaned up today or not. Matt R. -Original Message- From: Mike Parker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 9:57 AM To: arslist@ARSLIST.ORG Subject: ARS 7 - Patch 2 Sever Patch? Good Morning List: I just checked out the patches for 7.0, and patch 2 was there, and it says that there is a server patch (in the Problem Symptoms), but when I went to download it, I don't see it. All I see is: Assignment Clients Mid-Tier Email Am I the only one who's experiencing this? _ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Eric, Make sure your oracle db character set is set for Unicode select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); If not set it and then try the install Carin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 10:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Eric: If you are staying within English, then the language MIGHT BE en_US.UTF8. If you want to use other languages, you will have to set the database up for 16 bit UTF. I don't know if 32 bit UTF is supported or not. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 9:00 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ ___ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ ___ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 __ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org = ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ ___ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ ___ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ ___ _ UNSUBSCRIBE or access ARSlist Archives at http
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Carin, A quick query shows: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 So, what values should we set for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET to support UNICODE? Thanks, Eric On Wed, 6 Sep 2006 10:47:48 -0500, Sinclair, Carin [EMAIL PROTECTED] wrote: Eric, Make sure your oracle db character set is set for Unicode select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); If not set it and then try the install Carin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 10:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Thanks, James! But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database? Thanks, Eric On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ ___ __ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ ___ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ _ UNSUBSCRIBE
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Eric: I don't know, but think you will have to export all of the data in the database, recreate it and then import the data back in so that it will be converted to UNICODE. James Mckenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Thanks, James! But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database? Thanks, Eric On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
US7ASCII supports 7 bit characters. For US English users in the United States, this could suffice. If you are going anywhere other try WE8ISO8859P1 character set it supports most Europeen languages. This is the Oracle default character set and can support 8 bit characters. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Carin, A quick query shows: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 So, what values should we set for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET to support UNICODE? Thanks, Eric On Wed, 6 Sep 2006 10:47:48 -0500, Sinclair, Carin [EMAIL PROTECTED] wrote: Eric, Make sure your oracle db character set is set for Unicode select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); If not set it and then try the install Carin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 10:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ___ _ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ ___ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org === = ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
This is the way our instance was built. SQL select * from v$nls_parameters where parameter in 2 ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE --- - NLS_CHARACTERSETUTF8 NLS_NCHAR_CHARACTERSET UTF8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: Thanks, James! But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database? Thanks, Eric On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
See http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics#Fresh_Install_Message_Catalog_Data_Import_Failure for another issue with solaris/oracle install issues if you plan to do a fresh install with all language packs. Axton Grams On 9/6/06, Axton [EMAIL PROTECTED] wrote: This is the way our instance was built. SQL select * from v$nls_parameters where parameter in 2 ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE --- - NLS_CHARACTERSETUTF8 NLS_NCHAR_CHARACTERSET UTF8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: Thanks, James! But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database? Thanks, Eric On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information. I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n] I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE rmdytst1 MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams On 9/6/06, Axton [EMAIL PROTECTED] wrote: See http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics#Fresh_Install_Message_Catalog_Data_Import_Failure for another issue with solaris/oracle install issues if you plan to do a fresh install with all language packs. Axton Grams On 9/6/06, Axton [EMAIL PROTECTED] wrote: This is the way our instance was built. SQL select * from v$nls_parameters where parameter in 2 ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE --- - NLS_CHARACTERSETUTF8 NLS_NCHAR_CHARACTERSET UTF8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: Thanks, James! But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database? Thanks, Eric On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Axton, Does it matter how you create your initial database when you use those environment vars for installation? Thanks, Eric On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote: I used the following env vars for the 7.0 installer on solaris 9 with Oracle. This allowed me to do the install with the single-byte and multi-byte support data (message catalog, etc.). NLS_LANG=american LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 Axton Grams On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote: James, English is the base language. Thanks, Eric On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: Eric: What language are you using as the base language? I may have a suggestion. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 8:36 AM To: arslist@ARSLIST.ORG Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Axton: This is b code here: ARS_VER=select dbVersion from control This should be a number not a select statement for SQL. I'm wondering why it did not work. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams __20060125___This posting was submitted with HTML in it___
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow. Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: This is b code here: ARS_VER=select dbVersion from control This should be a number not a select statement for SQL. I'm wondering why it did not work. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Axton: Thank you. I did not have this problem when I did my install. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:43 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow. Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: This is b code here: ARS_VER=select dbVersion from control This should be a number not a select statement for SQL. I'm wondering why it did not work. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
I consistently had this issue. What os/shell did you use? Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: Thank you. I did not have this problem when I did my install. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:43 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow. Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: This is b code here: ARS_VER=select dbVersion from control This should be a number not a select statement for SQL. I'm wondering why it did not work. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9 ** Axton: BASH, KSH. I've seen issues like this one, but I was doing a fresh install to a precreated tablespace. This may have bypassed this problem. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 I consistently had this issue. What os/shell did you use? Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: Thank you. I did not have this problem when I did my install. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:43 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow. Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: This is b code here: ARS_VER=select dbVersion from control This should be a number not a select statement for SQL. I'm wondering why it did not work. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, September 06, 2006 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Also, if the installer exits at this point, then it didn't complete successfully. # Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006 ./ar_install: test: unknown operator dbVersion # The installer dies at this point: In the stage 6 of the install script: 12299 # Import required and selected plugins 12300 ImportPlugins 12301 ImportFlash Now in the importFlash function: 3279 ## 3280 # ImportFlash - Upgrade and import FlashObject Forms 3281 # 3282 ## 3283 ImportFlash() 3284 { 3285 lecho Installing Flash Objects: `date` 3286 lecho 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en 3288 $CD $SAMPLE_FORMS 3289 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE} ${UPGRD_USER} ${UPGRD_PASS} 3292 if [ $? -ne 0 ]; then 3293 lecho FlashForms failed to import. 3294 lecho Problems encountered while importing the form FlashForms.def 3295 lecho Please refer to the log in $INSTALL_DIR/Logs/ for further details. 3296 else 3297 note FlashForms successfully installed. 3298 fi 3299 fi From the output, I can tell that the first line of this function ran. In the ArEnvHistory file, these are the values of the vars used in the if statement: DB_UPGRADE=0 ARS_VER=select dbVersion from control Obviously the if statement can't handle the sql statement. Below is a 'sloppy' hack to get new installs (only) to complete successfully. [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then Axton Grams __20060125___This posting was submitted with HTML in it___ __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracleuser is created without DBA access. So, I tried this: when the ARAdmin user is created in Oraclethere is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin usermay not be getting the access it needs...but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, August 28, 2006 4:06 PMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word "not" it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is "Preparing to import forms and data...". This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with "Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported." After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered. 2006-08-28 13:28:52.921: [ OCRRAW][2472]proprinit: Could not open raw device 2006-08-28 13:28:52.921: [ default][2472]a_init:7!: Backend init unsuccessful : [33] 2006-08-28 13:28:52.921: [ CSSCLNT][2472]clsssinit: error(33 ) in OCR initialization SQLNET.LOG --- Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TPA9PN0321.pbsj.com)(PORT=1521 ))(CONNECT_DATA=(SID=tpa9pn03)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_ 1\bin\emagent.exe)(HOST=TPA9PN0321)(USER=OraUser VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 28-AUG-2006 13:26:39 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:no listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: No listener nt secondary err code: 61 nt OS err code: 0 --
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Your error in the SQLNET.LOG is stating No Listener. Are you installing this as a remote or local Oracle database? What does the output oftnsping state? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, StephenSent: Tuesday, August 29, 2006 6:56 AMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracleuser is created without DBA access. So, I tried this: when the ARAdmin user is created in Oraclethere is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin usermay not be getting the access it needs...but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, August 28, 2006 4:06 PMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word "not" it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is "Preparing to import forms and data...". This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with "Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported." After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered. 2006-08-28 13:28:52.921: [ OCRRAW][2472]proprinit: Could not open raw device 2006-08-28 13:28:52.921: [ default][2472]a_init:7!: Backend init unsuccessful : [33] 2006-08-28 13:28:52.921: [ CSSCLNT][2472]clsssinit: error(33 ) in OCR initialization SQLNET.LOG --- Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TPA9PN0321.pbsj.com)(PORT=1521 ))(CONNECT_DATA=(SID=tpa9pn03)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_ 1\bin\emagent.exe)(HOST=TPA9PN0321)(USER=OraUser VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS - RESOLVED
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I finally got it working. How? I have no idea. I kept on uninstalling and reinstalling many times. This last time when I uninstalled Oracle I did not reboot before reinstalling it. This may have had an effect. Thanks for everyone's tips. My prior work with Oracle is all coming back to me now. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick WSent: Tuesday, August 29, 2006 9:00 AMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Your error in the SQLNET.LOG is stating No Listener. Are you installing this as a remote or local Oracle database? What does the output oftnsping state? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, StephenSent: Tuesday, August 29, 2006 6:56 AMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracleuser is created without DBA access. So, I tried this: when the ARAdmin user is created in Oraclethere is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin usermay not be getting the access it needs...but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, August 28, 2006 4:06 PMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word "not" it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is "Preparing to import forms and data...". This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with "Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported." After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered. 2006-08-28 13:28:52.921: [ OCRRAW][2472]proprinit: Could not open raw
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: You need to use the system user in order to install on Oracle. You cannot create a user and then have an installation go smoothly unless you already have the AROLE on the system. I have cloned users and database instances for upgrade testing (I have to evaluate every possibility of an installation for the Government.) Also, you can not use sys. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Tuesday, August 29, 2006 4:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracle user is created without DBA access. So, I tried this: when the ARAdmin user is created in Oracle there is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin user may not be getting the access it needs... but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, August 28, 2006 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word not it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is Preparing to import forms and data This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported. After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered. 2006-08-28 13:28:52.921: [ OCRRAW][2472]proprinit: Could not open raw device 2006-08-28 13:28:52.921: [ default][2472]a_init:7!: Backend init unsuccessful : [33] 2006-08-28 13:28:52.921: [ CSSCLNT][2472]clsssinit: error(33 ) in OCR initialization SQLNET.LOG --- Fatal NI connect error 12541
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Fred: You are correct in your evaluation. The clients will require that the tnsnames.ora and listener.ora file be located in the network/admin directory under the ORACLE_BASE directory. Also, check the database server and make sure that the listener is running. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, August 29, 2006 6:00 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Your error in the SQLNET.LOG is stating No Listener. Are you installing this as a remote or local Oracle database? What does the output of tnsping state? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Tuesday, August 29, 2006 6:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracle user is created without DBA access. So, I tried this: when the ARAdmin user is created in Oracle there is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin user may not be getting the access it needs... but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, August 28, 2006 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word not it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is Preparing to import forms and data This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported. After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** James, I actually used the Oracle'system' user when installing ARS. The Oracle ARAdmin user was the one I manually granted DBA rights, to see if that would help. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Tuesday, August 29, 2006 9:51 AMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: You need to use the system user in order to install on Oracle. You cannot create a user and then have an installation go smoothly unless you already have the AROLE on the system. I have cloned users and database instances for upgrade testing (I have to evaluate every possibility of an installation for the Government.) Also, you can not use sys. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Tuesday, August 29, 2006 4:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracle user is created without DBA access. So, I tried this: when the ARAdmin user is created in Oracle there is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin user may not be getting the access it needs... but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, August 28, 2006 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word "not" it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is "Preparing to import forms and data...". This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with "Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported." After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: Granting the ARADMIN user DBA rights will not fix a messed up ARS installation. I don't know what is going on with your database, but something is definitely broken. Did you look at the Client directory (I am assuming that you are doing a remote installation of ARS) and check for the files I mentioned in my other message? I suspect that the ORACLE_SID, ORACLE_TWO_TASK or ORACLE_HOME settings were somehow incorrect. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Tuesday, August 29, 2006 6:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** James, I actually used the Oracle 'system' user when installing ARS. The Oracle ARAdmin user was the one I manually granted DBA rights, to see if that would help. Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Tuesday, August 29, 2006 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: You need to use the system user in order to install on Oracle. You cannot create a user and then have an installation go smoothly unless you already have the AROLE on the system. I have cloned users and database instances for upgrade testing (I have to evaluate every possibility of an installation for the Government.) Also, you can not use sys. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Tuesday, August 29, 2006 4:56 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error. Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite. The installer first drops the ARSystem database and the ARAdmin user. The ARAdmin Oracle user is created without DBA access. So, I tried this: when the ARAdmin user is created in Oracle there is a two-minute period before the forms are imported and the Demo user is created. At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin user may not be getting the access it needs... but ARS 7 still won't install. Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, August 28, 2006 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word not it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is Preparing to import forms and data This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported. After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 390600 : This version of the Action Request System(R) is ready
Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS ** Stephen: ORACLE_BASE also should be set if you are working with the 10g clients. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen Sent: Monday, August 28, 2006 11:12 AM To: arslist@ARSLIST.ORG Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS Sorry, had to fix a typo. It's the type when you don't include the word not it changes the entire meaning. I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer. The installation program has never completed successfully. I have attempted the installation about 20-25 times today. I installed the Oracle instance on Friday with no errors. I can login to SQL Plus without errors. WinXP Pro Oracle 10g R2 ARS 7.0 I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance. Arcache will Not add a user. The message states that it cannot connect to ARS. I have tried the install with and without PortMapper. The last status window displayed is Preparing to import forms and data This is after the database is created and the Remedy service is started. The message goes away and there is no message box on the screen for about 45 seconds. Then the installation stops with Failed to create a valid Admin user. This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported. After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting). The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List. Could someone please point me in the right direction. It's probably one small setting that is causing all these errors. Thanks. ARERROR.LOG --- Mon Aug 28 13:32:30 2006 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) Mon Aug 28 13:32:30 2006 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Mon Aug 28 13:32:30 2006 ORA-12560: TNS:protocol adapter error Mon Aug 28 13:32:30 2006 390600 : Cannot initialize contact with SQL database (ARERR 551) Mon Aug 28 13:32:30 2006 Stop server Mon Aug 28 13:32:30 2006 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) --- CSS.LOG --- 2006-08-28 13:28:52.812: [ OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered. 2006-08-28 13:28:52.921: [ OCRRAW][2472]proprinit: Could not open raw device 2006-08-28 13:28:52.921: [ default][2472]a_init:7!: Backend init unsuccessful : [33] 2006-08-28 13:28:52.921: [ CSSCLNT][2472]clsssinit: error(33 ) in OCR initialization SQLNET.LOG --- Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TPA9PN0321.pbsj.com)(PORT=1521 ))(CONNECT_DATA=(SID=tpa9pn03)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_ 1\bin\emagent.exe)(HOST=TPA9PN0321)(USER=OraUser VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 28-AUG-2006 13:26:39 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:no listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: No listener nt secondary err code: 61 nt OS err code: 0 --- Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARS 7 deleted ITSM 6 application licenses
** Update - I found the base menu - a character menu called SHR:AppLicense. It still doesn't allow me to add them, giving me an error like "The application license format is not valid (ARERR 9860)", but I'm getting there. I have never found this many bugs in a Remedy release before. In just my second real day of messing with normal functions, I'm on ticket #6 now, one of which is now bugged. Either my installation's whacked or some testers didn't do their jobs very well. I hope for everyone's sake that it's the former. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick CookSent: Monday, May 15, 2006 1:21 PMTo: arslist@ARSLIST.ORGSubject: ARS 7 deleted ITSM 6 application licenses ** I just noticed this as I was testing ITSM 6 on the ARS 7 Mid-Tier. Not only did the upgrade cause all of the application licenses to disappear for every user, but there isn't even a menu button on the Application License field with which to restore them. I don't see a reason for that, or an alternate means of re-adding that information. Has anyone else seen this? While Support is working on this, can anyone tell me what ARS 7 table that information's drawn from, so that I can rebuild the menu myself? I can't find anything that looks right, and I suspect that it may be Run Process-type commands to retrieve that data. Thanks! Rick CookRemedy Approved Consultant Denali Advanced Integration__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS 7 Download available
** I got migrator 7.0 downloaded From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Baxter, AndrewSent: Wednesday, May 10, 2006 5:36 AMTo: arslist@ARSLIST.ORGSubject: ARS 7 Download available ** I know see AR Server 7 available for download but after answering all the questions nothing shows in the list, but I imagine it will be there for real very shortly. Thanks, Andrew Baxter Manager, Information Technology w. (781) 902-6026 f. (781) 902-6002 This e-mail is sent by Hudson Highland Group, Inc., or one of its subsidiaries, and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS 7 Download available
** YEPPER, Just got both Windows and Solaris... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of AxtonSent: Wednesday, May 10, 2006 9:16 AMTo: arslist@ARSLIST.ORGSubject: Re: ARS 7 Download available ** Looks to all be available for download now; though I select Sun and Windows and only got the windows version of ars. Axton On 5/10/06, Zandi, Patrick S MSgt AFRL/IFOS [EMAIL PROTECTED] wrote: ** I got migrator 7.0 downloaded From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Baxter, AndrewSent: Wednesday, May 10, 2006 5:36 AMTo: arslist@ARSLIST.ORG Subject: ARS 7 Download available ** I know see AR Server 7 available for download but after answering all the questions nothing shows in the list, but I imagine it will be there for real very shortly. Thanks, Andrew Baxter Manager, Information Technology w. (781) 902-6026 f. (781) 902-6002 This e-mail is sent by Hudson Highland Group, Inc., or one of its subsidiaries, and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___