Re: Asset Management Budgeting Tool
Hi Shawn, BMC does have an app called ITBM which has budget forecasting capabilities, if that is what you are looking for. To be specific, it is called ITBM Supplier Management and Financial Planning and Budgeting Application. It may be worthwhile to connect to a BMC Account Manager/Sales rep to explore the possibilities. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 09, 2010 1:20 AM To: arslist@ARSLIST.ORG Subject: Asset Management Budgeting Tool ** Good afternoon, We are working on building requirements for an asset management project. It looks like a lot of what we are going to need to focus on is less about true asset management, and more about the budgeting aspects of paying maintenance. We already use Asset Management to track contracts, licenses, etc., but we are going to need the ability to do budget forecasting and such, which doesn't seem to exist in any of the OOtB applications. I know we can build something in ARS to tie in to the Asset Management data to do this, but I wanted to see if anyone here knows of a tool that is already out there that integrates with ITSM data for this purpose. If you know of any Asset Management integrated budget forecasting tools, please let me know. Thanks, Shawn Pierson Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: mid-tier doesn't see crystal XI
AR System 7.6.03 (tentatively scheduled to release in late Summer 2010) is expected to have the ability to display basic list-based and graphical reports on the web client without the need to integrate Crystal / BOXI. We have introduced a new Reporting Engine which delivers this capability. The embedded engine is designed to replace the legacy text-based reporting engine currently part of AR System 7.5.00 and earlier. In addition to this, an user will also be able to generate ad-hoc reports subject to permission constraints. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Maher, Jeff Sent: Wednesday, July 07, 2010 11:09 PM To: arslist@ARSLIST.ORG Subject: Re: mid-tier doesn't see crystal XI ** I'll add that I saw the same behavior, I ran 7.5 patch 004 of the mid-tier installer probably around 7 times till the option for the BOXI server showed up properly in the mid-tier configuration. I hadn't changed anything from the 6th to 7th install either, it just decided to finally show up. Needless to say I stuck with that attempt and have no plans on ever trying it again. Ever. Jeff From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Wednesday, July 07, 2010 1:32 PM To: arslist@ARSLIST.ORG Subject: Re: mid-tier doesn't see crystal XI ** This is entirely the fault of the mid-tier installer; I had so many problem of exactly this sort with the various patch levels of 7.1 that I ended up putting a 7.0.01.002 mid-tier on my CRXI/BOXI server. I'm still using it in production!! For my dev server I used 7.0.01.008. I have been pointing my 7.5.00.005 pre-production mid-tiers at that last one for testing... it works just fine since all the 7.0.01 mid-tier is doing is serving up the crystal report. I have not tried to update the CRXI mid-tiers to 7.5, and gave up on later patches of 7.1 as the installers remained bug-ridden - trying to upgrade the mid-tier from 7.0.01 to 7.1 ignored and wiped out the report viewer. CRXI is such a pain to install and license that once you get one running, AND a working mid-tier, I try to leave it alone. I'd love to tell you that the BMC installers have improved in 7.5/7.6, but they have not. This week's poster child for worthless installers is BMC Analytics 7.6.01, which skips the entire dialog box set for specifying your db connection - much as the mid-tier installer fails to detect CRXI/BOXI and prompt to install the Crystal viewer. All I can recommend is that you try every patch level of mid-tier that you can find until one works correctly; most of them are flawed. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, July 06, 2010 12:19 PM To: arslist@ARSLIST.ORG Subject: mid-tier doesn't see crystal XI ** I installed Crystal Reports XI then mid-tier on a server for testing purposes and the mid-tier install and program don't seem to see that Crystal/Business objects is installed. The viewer isn't available for install and the reporting options for a local reporting server aren't available after install. Does anyone know what file/registry entry that mid-tier looks for to say that there is a local Crystal install? Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS split db problem
Thanks for your reply. Looks like ar.cfg is pointing to the remote db. Could this be as simple as changing it back to the original db server? How will that affect the data that's already on the db remote server. Would it be possible to limp them into one? Date: Sun, 11 Jul 2010 19:41:44 -0700 From: vamsi...@gmail.com Subject: Re: ARS split db problem To: arslist@ARSLIST.ORG Look for the following: 1. In ar.conf file see if the db entry is changed or pointing to correct db . 2. In oracle there is a tnsname.ora file to store the db sid, check the similar sqlserver component for the correctness of the entries if any. 3. Are you using any load balancer/failovers/hotbackup etc.., in that case check with your network guyz if any changes have been made to hostnames/ip addresses etc... 4. Involve dba to check if the connection to main db is established during the remedy startup or not. On Jul 11, 4:22 pm, AR Admin aru...@live.com wrote: Hello, We've got a strange database problem. Just wondering if anyone had something similar or knows how to fix it. We have ARS 6.3 running on MS SQL 2000 db on one server and somehow the main db attaches to another remote SQL server. Seems like all new transactions are saved to the remote server because that db is getting larger and the original stays the same. This split causes a lot of problems with new forms and external sql queries. Users are not able to submit to new forms without at least a floating license. New fields created on old forms are not found when running SQL queries. I'm guessing because field definitions are saved on the remote db server. I don't know if the db was split intentionally at the time of install, or what, but we were trying to lump it all into one db. Is this something anyone dealt with before? Thanks _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox.http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTA... ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: New Data Import tool
Rick; I had the same problem with the Base 7.5 version, when I moved up to the patch 2 version it worked. I don't know why, I just know it worked. Just a note here, patch 4 and patch 5 are very buggy we had all kinds of issues with them and left our production on patch 2. We are testing 7.6 Beta now and hope it is not as buggy. Bill Clary Bright House Networks Rick Cook remedyr...@gmail.com wrote in message news:aanlktinmtx914i5tcdxoftl5o8zrrjwlbarpyo7xs...@mail.gmail.com... I am using this for the first time, and I don't like it. In addition to it taking longer to map fields, it refuses to both accept a text string into the Character field AND log why it won't. It just gives a popup asking me to confirm that it is skipping each record with a message Record number: For input string: contents of field 1. Anyone seen this behavior and gotten past it? Rick CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010
Excellent questions - I would pay for the answers.. :) Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Sunday, July 11, 2010 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** Rick and Shawn (and all listers) I guess I was too vague in my request to see how BMC products are used at BMC. So let me clarify. Obviously they use their own products, but it's more than just simply using the productsit's HOW you use them. For instance I am interested in the following: - Does BMC use multi-tenancy and if so how? - Does BMC use CI based approvals, or product or operation categorization based approvals? - How does BMC performs risk and impact analysis of its changes? - How BMC uses the BMC Remedy change calendar? - How are the change assignee and change manager in the Remedy change mgmt app used at BMC? - Does BMC implement separation of duties and if so how? - How does BMC deals with Sarbanes Oxley issues? This is a very limited set of questions that I think are worth while asking. Others may have many more. I don't think they would be exposing any confidential or business critical information. As a matter of fact, many software vendors do this. Many times, in almost all my consulting engagements, I have been asked by customers how BMC uses, configures and implements their own products at BMC, and of course I cannot give an answer; this has non-negligible impact. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Rick Cook [remedyr...@gmail.com] Sent: Friday, July 09, 2010 5:06 PM To: arslist@ARSLIST.ORG Subject: Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** I know that they do use a lot of their own software, and have been trying to move toward that goal for a while. I am hoping that a session like that I suggested would show the status of that dogfood in a favorable light that would leave us impressed. However, there are a couple of noticeable holes that need to be filled, like this one, before that impression would be as good as it could be. Rick On Fri, Jul 9, 2010 at 5:01 PM, Pierson, Shawn shawn.pier...@sug.commailto:shawn.pier...@sug.com wrote: ** I think it would be a good thing for BMC to present this information, however it's pretty obvious that they do use at least some of their own products if you've logged into their support site (custom ARS apps and RKM), and when I was working a contract in their Houston office a number of years ago there were various applications including Remedy-based ones that were being used. Thanks, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, July 09, 2010 3:12 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** Why not Eating your won food should be a principle for every corporation. Two examples that come to mind: HP and Oracle. HP embarked in a huge project to consolidate all its data centers; at the end of that project, they will be able to tell their clients the hurdles they encountered and best practices of that monumental task. Oracle used to have a customer database for each country, with distinct financials and sales apps linked to each DB per country. So it was all siloed by country. Years ago they embarked in a 5 year project to have a single database for all the countries with all financial and sales apps ruinning out of that single database. So now... they are advising their customers to do just that. I would really like to know what ITSM and IT operational tools BMC uses. I have never seen any presentation on that Maybe it's out there somewhere and I haven't seen it Guillaume Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: New Data Import tool
Older versions of the Dev Studio though have a lot of major issues with even basic functionality that are resolved with Patch 4. To name a few: 1) Join form qualifications had a bug that was resolved in patch 3 upwards. 2) SQL Menus qualifications had a bug that was resolved in Patch 4 3) Active Link / Filter Guides had a performance issue and would time out when you open them to edit them or add new Active Links or Filters to them. These come to the top of my mind.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Clary, William M. Sent: Monday, July 12, 2010 8:38 AM To: arslist@ARSLIST.ORG Subject: Re: New Data Import tool Rick; I had the same problem with the Base 7.5 version, when I moved up to the patch 2 version it worked. I don't know why, I just know it worked. Just a note here, patch 4 and patch 5 are very buggy we had all kinds of issues with them and left our production on patch 2. We are testing 7.6 Beta now and hope it is not as buggy. Bill Clary Bright House Networks Rick Cook remedyr...@gmail.com wrote in message news:aanlktinmtx914i5tcdxoftl5o8zrrjwlbarpyo7xs...@mail.gmail.com... I am using this for the first time, and I don't like it. In addition to it taking longer to map fields, it refuses to both accept a text string into the Character field AND log why it won't. It just gives a popup asking me to confirm that it is skipping each record with a message Record number: For input string: contents of field 1. Anyone seen this behavior and gotten past it? Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: mid-tier doesn't see crystal XI
I missed this.. glad it worked for ya.. I just thought.. Go the easy route.. it is a better mid-tier and does everything you want, and better logging.. Can't go wrong. On Thu, Jul 8, 2010 at 8:37 AM, Ramey, Anne anne.ra...@nc.gov wrote: ** Installing mid-tier 7.5 patch 4 worked. I guess I'll go with that. Thanks for you help. Anne Ramey *** *E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official.* *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *patrick zandi *Sent:* Wednesday, July 07, 2010 1:49 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: mid-tier doesn't see crystal XI ** I am using a 7.5 P04 against a ARS 7.1 /P6 and /P9 server with SRM 2.2 no problems I put midtier on the CR server, and use another mid-tier and point to it as well.. think of it as a backup midtier.. skip the viewer all together.. .. IF you install midtier, you get the viewer.. why waste your time with just a viewer.. hope that helps. On Wed, Jul 7, 2010 at 1:32 PM, strauss stra...@unt.edu wrote: ** This is entirely the fault of the mid-tier installer; I had so many problem of exactly this sort with the various patch levels of 7.1 that I ended up putting a 7.0.01.002 mid-tier on my CRXI/BOXI server. I’m still using it in production!! For my dev server I used 7.0.01.008. I have been pointing my 7.5.00.005 pre-production mid-tiers at that last one for testing… it works just fine since all the 7.0.01 mid-tier is doing is serving up the crystal report. I have not tried to update the CRXI mid-tiers to 7.5, and gave up on later patches of 7.1 as the installers remained bug-ridden – trying to upgrade the mid-tier from 7.0.01 to 7.1 ignored and wiped out the report viewer. CRXI is such a pain to install and license that once you get one running, AND a working mid-tier, I try to leave it alone. I’d love to tell you that the BMC installers have improved in 7.5/7.6, but they have not. This week’s poster child for worthless installers is BMC Analytics 7.6.01, which skips the entire dialog box set for specifying your db connection – much as the mid-tier installer fails to detect CRXI/BOXI and prompt to install the Crystal viewer. All I can recommend is that you try every patch level of mid-tier that you can find until one works correctly; most of them are flawed. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Ramey, Anne *Sent:* Tuesday, July 06, 2010 12:19 PM *To:* arslist@ARSLIST.ORG *Subject:* mid-tier doesn't see crystal XI ** I installed Crystal Reports XI then mid-tier on a server for testing purposes and the mid-tier install and program don't seem to see that Crystal/Business objects is installed. The viewer isn't available for install and the reporting options for a local reporting server aren't available after install. Does anyone know what file/registry entry that mid-tier looks for to say that there is a local Crystal install? Anne Ramey *** *E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official.* _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Patrick Zandi _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS split db problem
Not unless the new remote db was a mirror copy of the original and you started on there where you left at the original.. If not your only choice is to import the delta but you would loose notifications as it would be hard to export notification data as the request ID's would differ... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of AR Admin Sent: Monday, July 12, 2010 8:33 AM To: arslist@ARSLIST.ORG Subject: Re: ARS split db problem ** Thanks for your reply. Looks like ar.cfg is pointing to the remote db. Could this be as simple as changing it back to the original db server? How will that affect the data that's already on the db remote server. Would it be possible to limp them into one? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Asset Management Budgeting Tool
Prijit, is this app built on ARS? Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Debnath, Prijit [prijit_debn...@bmc.com] Sent: Monday, July 12, 2010 2:00 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Hi Shawn, BMC does have an app called ITBM which has budget forecasting capabilities, if that is what you are looking for. To be specific, it is called ITBM Supplier Management and Financial Planning and Budgeting Application. It may be worthwhile to connect to a BMC Account Manager/Sales rep to explore the possibilities. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 09, 2010 1:20 AM To: arslist@ARSLIST.ORG Subject: Asset Management Budgeting Tool ** Good afternoon, We are working on building requirements for an asset management project. It looks like a lot of what we are going to need to focus on is less about true asset management, and more about the budgeting aspects of paying maintenance. We already use Asset Management to track contracts, licenses, etc., but we are going to need the ability to do budget forecasting and such, which doesn’t seem to exist in any of the OOtB applications. I know we can build something in ARS to tie in to the Asset Management data to do this, but I wanted to see if anyone here knows of a tool that is already out there that integrates with ITSM data for this purpose. If you know of any Asset Management integrated budget forecasting tools, please let me know. Thanks, Shawn Pierson Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010
Joe, We were on 7.5 Patch 4, upgraded to Patch 5. Working with BMC Support since clicking OK to try and resuscitate the Plugin Server. So far it appears this particular feature of Patch 5 only affects Linux installs. We are running SUSE 10. The comment about treating patches with the same respect as upgrades, installs, etc. is dead-on. Ultimately though, this stuff happens, and that's why we all have lower landscapes. .:Mike:. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Friday, July 09, 2010 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** Any word on why specifically they were recalled? Mike, what version and patch are you on and what are the problems you are encountering? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Tomasiewicz, Mike (Information Technology) Sent: Friday, July 09, 2010 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** Too late for us, unfortunately ... my DEV server is a WRECK! .:Mike:. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Friday, July 09, 2010 12:13 PM To: arslist@ARSLIST.ORG Subject: AR System 7.5.00 Patch 005 and 7.1.00 Patch 010 ** Hmm. Just received a support announcement for the withdrawal of AR System 7.5.00 Patch 005 and 7.1.00 Patch 010. Dave Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: dave.shell...@tycoelectronics.com Tyco Electronics MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Easy way for Capacity Planning
There was a white paper released on sizing a few years ago that you might want to take a look at. This would offer you guidelines as to what you might need to consider. While these guidelines would be generic, it would give you an insight into capacity planning. Besides just record sizes, you might also want to consider sizes of attachments, and limit those sizes. If you cannot locate the document, I think I may have a copy of it. Let me know if you have trouble locating it on BMC's website, and I'll look for it later on my zip or flash drives where I think I may have saved a copy of it.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of IT (Amanullah Bashir Ahmed) Sent: Sunday, July 11, 2010 3:31 AM To: arslist@ARSLIST.ORG Subject: Easy way for Capacity Planning ** Hi there, Version 7.1 How can we do Capacity Planning in BMC Remedy? If I raise an incident or Change Request with 4 or 5 Work info types how much disk space is required, and how can I calculate. Please also guide me which document of BMC remedy can help me in this regard. Thanks Regards Amanullah DISCLAIMER:This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Asset Management Budgeting Tool
Prijit, Thanks for the notification about it. I'm going to see if I can find out who my current sales rep is from BMC and try to get a demo. Thanks, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Debnath, Prijit Sent: Monday, July 12, 2010 1:00 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Hi Shawn, BMC does have an app called ITBM which has budget forecasting capabilities, if that is what you are looking for. To be specific, it is called ITBM Supplier Management and Financial Planning and Budgeting Application. It may be worthwhile to connect to a BMC Account Manager/Sales rep to explore the possibilities. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 09, 2010 1:20 AM To: arslist@ARSLIST.ORG Subject: Asset Management Budgeting Tool ** Good afternoon, We are working on building requirements for an asset management project. It looks like a lot of what we are going to need to focus on is less about true asset management, and more about the budgeting aspects of paying maintenance. We already use Asset Management to track contracts, licenses, etc., but we are going to need the ability to do budget forecasting and such, which doesn't seem to exist in any of the OOtB applications. I know we can build something in ARS to tie in to the Asset Management data to do this, but I wanted to see if anyone here knows of a tool that is already out there that integrates with ITSM data for this purpose. If you know of any Asset Management integrated budget forecasting tools, please let me know. Thanks, Shawn Pierson Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SYS Notification Messages Additional field configuration
Raja, There is some workflow that needs to be modified as well in order to make this work. I am providing a link to information that should hopefully help. http://www.remedyars.com/wiki/index.php?title=Adding_a_New_Field_to_Notifications Thanks, Shane Buchholz Systems Analyst II - Remedy Information Services Operations Samaritan Health Services From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raja V Sent: Wednesday, July 07, 2010 9:01 AM To: arslist@ARSLIST.ORG Subject: SYS Notification Messages Additional field configuration ** Hi Listers, I want to add additional fields SYS Notification Messages form so I followed the below method to configure additional fields into the form list, 1. Open SYS:Form Field Selection form 2. Configure selection type as notification message selection 3. Module Name is Incident 4. Form Name and Select Fields From+ is HPD:Help Desk 5. Menu Label 1 is custom field from help desk form 6. Menu value 1, custom name for the selected field 7. Selection Code, I gave a custom code 20 8. Saved the form. Field Selection in SYS Notification Form 1. Select Module name as incident 2. Form Name as HPD:Help Desk 3. Select Message body Menu The configured field did appeared on the SYS Notification Form Menu List. But the configuration doesn't seems to be ending there, when I select the option that I created I am juz getting a blank space in the email body, when I select the field other than I configured I am getting #fieldname#. Any suggestion on this... I want the configured field to appear once I select. Do I have to configure anywhere else? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
AR System Reports Error on Mid-Tier 7.5 patch 4
All, I am receiving this error in IE when I try to run an AR System Report (.arr) over the Mid-Tier v7.5 patch4 using the Report Selection form: Error during processing : ARERR [9241] Cannot create report directory Z:\m11c23c11b16\A08DA5F8C06596786A88BCEE8C7EB04A. Please see your administrator. I used the Report Creator in Mid-Tier to create this report, it should be running. We also have a Crystal report server 2008 integrated with our Mid-Tier on a separate server and the Crystal Reports run fine. Is there a directory I should be granting the Remedy Service Account permission to on the Mid-Tier server to get this to run? Any ideas? We are running the OOB Tomcat as our JVM and web server. Thanks. -John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: New Data Import tool
Thanks, Bill. Glad to know it isn't just me. I don't mind seeing errors, it is the cryptic and completely useless nature of them that I am trying to get a handle on. They don't say anything that would tell me where the problem was. Rick -Original Message- From: Clary, William M. william.cl...@mybrighthouse.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Mon, 12 Jul 2010 08:37:45 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: New Data Import tool Rick; I had the same problem with the Base 7.5 version, when I moved up to the patch 2 version it worked. I don't know why, I just know it worked. Just a note here, patch 4 and patch 5 are very buggy we had all kinds of issues with them and left our production on patch 2. We are testing 7.6 Beta now and hope it is not as buggy. Bill Clary Bright House Networks Rick Cook remedyr...@gmail.com wrote in message news:aanlktinmtx914i5tcdxoftl5o8zrrjwlbarpyo7xs...@mail.gmail.com... I am using this for the first time, and I don't like it. In addition to it taking longer to map fields, it refuses to both accept a text string into the Character field AND log why it won't. It just gives a popup asking me to confirm that it is skipping each record with a message Record number: For input string: contents of field 1. Anyone seen this behavior and gotten past it? Rick CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Asset Management Budgeting Tool
The ITBM product is not currently a native AR System application, but integrates with the ITSM Suite. That being said, future releases of ITBM are moving toward becoming a native AR System application - so expectations are that over the next year or so, it'll be a native application built on AR System. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, July 12, 2010 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Prijit, is this app built on ARS? Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Debnath, Prijit [prijit_debn...@bmc.com] Sent: Monday, July 12, 2010 2:00 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Hi Shawn, BMC does have an app called ITBM which has budget forecasting capabilities, if that is what you are looking for. To be specific, it is called ITBM Supplier Management and Financial Planning and Budgeting Application. It may be worthwhile to connect to a BMC Account Manager/Sales rep to explore the possibilities. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 09, 2010 1:20 AM To: arslist@ARSLIST.ORG Subject: Asset Management Budgeting Tool ** Good afternoon, We are working on building requirements for an asset management project. It looks like a lot of what we are going to need to focus on is less about true asset management, and more about the budgeting aspects of paying maintenance. We already use Asset Management to track contracts, licenses, etc., but we are going to need the ability to do budget forecasting and such, which doesn't seem to exist in any of the OOtB applications. I know we can build something in ARS to tie in to the Asset Management data to do this, but I wanted to see if anyone here knows of a tool that is already out there that integrates with ITSM data for this purpose. If you know of any Asset Management integrated budget forecasting tools, please let me know. Thanks, Shawn Pierson Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Asset Management Budgeting Tool
Great, thanks David. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Easter, David [david_eas...@bmc.com] Sent: Monday, July 12, 2010 12:43 PM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** The ITBM product is not currently a native AR System application, but integrates with the ITSM Suite. That being said, future releases of ITBM are moving toward becoming a native AR System application – so expectations are that over the next year or so, it’ll be a native application built on AR System. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, July 12, 2010 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Prijit, is this app built on ARS? Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Debnath, Prijit [prijit_debn...@bmc.com] Sent: Monday, July 12, 2010 2:00 AM To: arslist@ARSLIST.ORG Subject: Re: Asset Management Budgeting Tool ** Hi Shawn, BMC does have an app called ITBM which has budget forecasting capabilities, if that is what you are looking for. To be specific, it is called ITBM Supplier Management and Financial Planning and Budgeting Application. It may be worthwhile to connect to a BMC Account Manager/Sales rep to explore the possibilities. Thanks, Prijit Debnath Product Manager, Remedy A R System BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 09, 2010 1:20 AM To: arslist@ARSLIST.ORG Subject: Asset Management Budgeting Tool ** Good afternoon, We are working on building requirements for an asset management project. It looks like a lot of what we are going to need to focus on is less about true asset management, and more about the budgeting aspects of paying maintenance. We already use Asset Management to track contracts, licenses, etc., but we are going to need the ability to do budget forecasting and such, which doesn’t seem to exist in any of the OOtB applications. I know we can build something in ARS to tie in to the Asset Management data to do this, but I wanted to see if anyone here knows of a tool that is already out there that integrates with ITSM data for this purpose. If you know of any Asset Management integrated budget forecasting tools, please let me know. Thanks, Shawn Pierson Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARERR 92 Server Timeout During Database Update
okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
it is not our current prod. It is the environment that is going to be prod. Dev Cache Mode is checked. The fields I added where not there. I closed out of the admin tool and came back in. On Mon, Jul 12, 2010 at 1:40 PM, jham36 jha...@gmail.com wrote: Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
Try setting Delay-Recache-Time to a few minutes. My suggestion would be more than the amount of time it takes to restart an arserver. That way if your update for some reason causes a server restart then you wouldn't be down while it is restarting. I would also suggest turning developer cache mode off since it is a prod box. Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh Sent: Monday, July 12, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR 92 Server Timeout During Database Update ** it is not our current prod. It is the environment that is going to be prod. Dev Cache Mode is checked. The fields I added where not there. I closed out of the admin tool and came back in. On Mon, Jul 12, 2010 at 1:40 PM, jham36 jha...@gmail.commailto:jha...@gmail.com wrote: Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.commailto:kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orghttp://atwww.arslist.org/ attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug10 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the Answers Are -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
it is not a prod box. I will try the Delay-Recache-Time option. On Mon, Jul 12, 2010 at 3:03 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Try setting “Delay-Recache-Time” to a few minutes. My suggestion would be more than the amount of time it takes to restart an arserver. That way if your update for some reason causes a server restart then you wouldn’t be down while it is restarting. I would also suggest turning developer cache mode off since it is a prod box. Sean *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kevin Begosh *Sent:* Monday, July 12, 2010 1:52 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 92 Server Timeout During Database Update ** it is not our current prod. It is the environment that is going to be prod. Dev Cache Mode is checked. The fields I added where not there. I closed out of the admin tool and came back in. On Mon, Jul 12, 2010 at 1:40 PM, jham36 jha...@gmail.com wrote: Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
Kevin, Also if that does not work, check if the transaction logs on your SQL server are full. Flush it if necessary. Also check the size and usage of the DB as well as the log file. SQL 2005 auto sets them to increment, but if the disk these files are on is getting full, this auto increment would fail. Make sure that the disk that contains these files has enough free space.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Kevin Begosh Sent: Monday, July 12, 2010 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR 92 Server Timeout During Database Update ** it is not a prod box. I will try the Delay-Recache-Time option. On Mon, Jul 12, 2010 at 3:03 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Try setting “Delay-Recache-Time” to a few minutes. My suggestion would be more than the amount of time it takes to restart an arserver. That way if your update for some reason causes a server restart then you wouldn’t be down while it is restarting. I would also suggest turning developer cache mode off since it is a prod box. Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh Sent: Monday, July 12, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: ARERR 92 Server Timeout During Database Update ** it is not our current prod. It is the environment that is going to be prod. Dev Cache Mode is checked. The fields I added where not there. I closed out of the admin tool and came back in. On Mon, Jul 12, 2010 at 1:40 PM, jham36 jha...@gmail.com wrote: Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARERR 92 Server Timeout During Database Update
okay thanks Joe. On Mon, Jul 12, 2010 at 3:25 PM, Joe D'Souza jdso...@shyle.net wrote: ** Kevin, Also if that does not work, check if the transaction logs on your SQL server are full. Flush it if necessary. Also check the size and usage of the DB as well as the log file. SQL 2005 auto sets them to increment, but if the disk these files are on is getting full, this auto increment would fail. Make sure that the disk that contains these files has enough free space.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]*on Behalf Of *Kevin Begosh *Sent:* Monday, July 12, 2010 3:11 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 92 Server Timeout During Database Update ** it is not a prod box. I will try the Delay-Recache-Time option. On Mon, Jul 12, 2010 at 3:03 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Try setting “Delay-Recache-Time” to a few minutes. My suggestion would be more than the amount of time it takes to restart an arserver. That way if your update for some reason causes a server restart then you wouldn’t be down while it is restarting. I would also suggest turning developer cache mode off since it is a prod box. Sean *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kevin Begosh *Sent:* Monday, July 12, 2010 1:52 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARERR 92 Server Timeout During Database Update ** it is not our current prod. It is the environment that is going to be prod. Dev Cache Mode is checked. The fields I added where not there. I closed out of the admin tool and came back in. On Mon, Jul 12, 2010 at 1:40 PM, jham36 jha...@gmail.com wrote: Is this a production environment? I see this error if I make a change to Prod sometimes. In our dev environment we have Dev Cache Mode turned on. What is probably happening is that the change is submitted to the database and then there is a timeout in the admin tool while waiting for the server to re cache everything. If you close your workflow and re-open it after this error, you should see that it was updated properly. James On Jul 12, 1:23 pm, Kevin Begosh kbeg...@gmail.com wrote: okay so I remember seeing this before but I cannot remember what I did to solve the issue. I am am trying to change workflow objects, forms, filters etc... via the admin tool and I keep getting the ARERR 92 timeout during database update ... The environment I am in is a Server group configuration with 3 AR Servers sharing the same DB. Has anyone else out there had this issue? Windows 2003 server, SQL 2005 DB. Do you have to take them out of server groups and then make the changes and then put them back, something like that? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR System Reports Error on Mid-Tier 7.5 patch 4
John, Is Z some sort of a network drive? Does the user that runs the Tomcat web server have permissions to this drive to create files and folders? AR System reports when created from the mid-tier, do not require the Remedy Service account to be given any special permissions.. It is the web server user that requires those permissions.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Bilinski, John CTR WHS/ITMD/ASD Sent: Monday, July 12, 2010 12:25 PM To: arslist@ARSLIST.ORG Subject: AR System Reports Error on Mid-Tier 7.5 patch 4 All, I am receiving this error in IE when I try to run an AR System Report (.arr) over the Mid-Tier v7.5 patch4 using the Report Selection form: Error during processing : ARERR [9241] Cannot create report directory Z:\m11c23c11b16\A08DA5F8C06596786A88BCEE8C7EB04A. Please see your administrator. I used the Report Creator in Mid-Tier to create this report, it should be running. We also have a Crystal report server 2008 integrated with our Mid-Tier on a separate server and the Crystal Reports run fine. Is there a directory I should be granting the Remedy Service Account permission to on the Mid-Tier server to get this to run? Any ideas? We are running the OOB Tomcat as our JVM and web server. Thanks. -John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Poor performance while saving Incidents
Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR System Reports Error on Mid-Tier 7.5 patch 4
Joe, I fixed it. The Z: was a mapped drive that pointed to the Reports Working directory on my Crystal Server (this was set in the Mid-Tier Config Report Settings page on the Mid_Tier server). I just changed this path to be the full windows context path and both the AR System and Crystal Reports are working. What I find weird about the whole thing is that the Crystl reports never stopped working, only the AR System reports need this working directory to intialize. Weird. Thanks. -John -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Monday, July 12, 2010 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: AR System Reports Error on Mid-Tier 7.5 patch 4 John, Is Z some sort of a network drive? Does the user that runs the Tomcat web server have permissions to this drive to create files and folders? AR System reports when created from the mid-tier, do not require the Remedy Service account to be given any special permissions.. It is the web server user that requires those permissions.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Bilinski, John CTR WHS/ITMD/ASD Sent: Monday, July 12, 2010 12:25 PM To: arslist@ARSLIST.ORG Subject: AR System Reports Error on Mid-Tier 7.5 patch 4 All, I am receiving this error in IE when I try to run an AR System Report (.arr) over the Mid-Tier v7.5 patch4 using the Report Selection form: Error during processing : ARERR [9241] Cannot create report directory Z:\m11c23c11b16\A08DA5F8C06596786A88BCEE8C7EB04A. Please see your administrator. I used the Report Creator in Mid-Tier to create this report, it should be running. We also have a Crystal report server 2008 integrated with our Mid-Tier on a separate server and the Crystal Reports run fine. Is there a directory I should be granting the Remedy Service Account permission to on the Mid-Tier server to get this to run? Any ideas? We are running the OOB Tomcat as our JVM and web server. Thanks. -John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: Poor performance while saving Incidents
Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to In-Row storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the RemedyAndOracleCLOBs.pdf document. Other things to check: 1.Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the INSERT INTO sql statement ... 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
My suggestion is too many indexes More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to “In-Row” storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the “RemedyAndOracleCLOBs.pdf” document. Other things to check: 1.Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the “INSERT INTO” sql statement … 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
Bad customization work can also do this.. for e.g. if there is a search run during the save, that performs a table scan on a large table, you have a performance hit.. Its often you see such work from developers who have just begun working with systems that store data in a underlying RDBMS.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Patrick Zandi Sent: Monday, July 12, 2010 5:03 PM To: arslist@ARSLIST.ORG Subject: Re: Poor performance while saving Incidents ** My suggestion is too many indexes More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to “In-Row” storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the “RemedyAndOracleCLOBs.pdf” document. Other things to check: 1.Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the “INSERT INTO” sql statement … 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
CMDB and AIE baseline white paper
I’m reaching out here. I recall reading a white paper authored by BMC which gave some performance measures regarding CMDB activities. Specifically it detailed some various server configurations and then gave a number of CI’s processed per second/hour for load, identify and merge activities. I do not recall what version of the CMDB and/or AIE the white paper was authored against. I just recall reading it once. I need it again, but cannot locate it. If anybody has this or knows the name of the paper, please share. Thanks in advance. Tim Powell ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: create a file and attach it to current form??????
I am trying to create an AL that will take some text and create a file on the c drive of the client. This is the command I am trying to use. cmd cd c:\echo $tmp_Text For File$$Infrastructure Change ID$.csv this command works fine and a file is created when run directly in a command line (I substitute the fields with data) This command seems also run fine when I turn on client logging when the command is run in the AL a command window pops up : c:\Program Files|AR System\ User Why , Why, Why, is this happening Arsystem 7.1 patch 5 Windows 2003 SQL 2005 Kimberly -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, June 25, 2010 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: create a file and attach it to current form?? I haven't done it on Windows but here is the basic logic I would use. Collect your data (could be into a field) Output your data to a file on the server (using echo or the notify action) Use the PERFORM-ACTION-ADD-ATTACHMENT command in a Set Fields action For more info on the Notify action use the Help - Contents and Index in your admin tool and display the The Notify filter or escalation action topic. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kim Santana Sent: Friday, June 25, 2010 1:40 PM To: arslist@ARSLIST.ORG Subject: create a file and attach it to current form?? Has anyone built workflow or can point me in the right direction to do the following? On a formcollect data from a table walk save to a file and attach that file to an attachment field/pool on the current form? WHITHOUT manual intervention? I have attempted to use the open window actiondestination = file (but attachment fields are visible in the list) MS SQL 2005 Windows 2003 AR System 7.1Patch 007 Very much appreciated. Kimberly Santana Sr. Remedy Systems Engineer PHASE*FORWARD ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: create a file and attach it to current form??????
You have the cd command in your string I think you would want something like: cmd /c echo $tmp_Text For File$c:\$Infrastructure Change ID$.csv Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kim Santana Sent: Monday, July 12, 2010 4:49 PM To: arslist@ARSLIST.ORG Subject: Re: create a file and attach it to current form?? I am trying to create an AL that will take some text and create a file on the c drive of the client. This is the command I am trying to use. cmd cd c:\echo $tmp_Text For File$$Infrastructure Change ID$.csv this command works fine and a file is created when run directly in a command line (I substitute the fields with data) This command seems also run fine when I turn on client logging when the command is run in the AL a command window pops up : c:\Program Files|AR System\ User Why , Why, Why, is this happening Arsystem 7.1 patch 5 Windows 2003 SQL 2005 Kimberly -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, June 25, 2010 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: create a file and attach it to current form?? I haven't done it on Windows but here is the basic logic I would use. Collect your data (could be into a field) Output your data to a file on the server (using echo or the notify action) Use the PERFORM-ACTION-ADD-ATTACHMENT command in a Set Fields action For more info on the Notify action use the Help - Contents and Index in your admin tool and display the The Notify filter or escalation action topic. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kim Santana Sent: Friday, June 25, 2010 1:40 PM To: arslist@ARSLIST.ORG Subject: create a file and attach it to current form?? Has anyone built workflow or can point me in the right direction to do the following? On a formcollect data from a table walk save to a file and attach that file to an attachment field/pool on the current form? WHITHOUT manual intervention? I have attempted to use the open window actiondestination = file (but attachment fields are visible in the list) MS SQL 2005 Windows 2003 AR System 7.1Patch 007 Very much appreciated. Kimberly Santana Sr. Remedy Systems Engineer PHASE*FORWARD ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: create a file and attach it to current form??????
Try redirecting the output to a file with the complete path name and also run is silently so it suppresses the command window.. this is done by using the /C switch to suppress the command window after executing the command.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Kim Santana Sent: Monday, July 12, 2010 5:49 PM To: arslist@ARSLIST.ORG Subject: Re: create a file and attach it to current form?? I am trying to create an AL that will take some text and create a file on the c drive of the client. This is the command I am trying to use. cmd cd c:\echo $tmp_Text For File$$Infrastructure Change ID$.csv this command works fine and a file is created when run directly in a command line (I substitute the fields with data) This command seems also run fine when I turn on client logging when the command is run in the AL a command window pops up : c:\Program Files|AR System\ User Why , Why, Why, is this happening Arsystem 7.1 patch 5 Windows 2003 SQL 2005 Kimberly -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, June 25, 2010 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: create a file and attach it to current form?? I haven't done it on Windows but here is the basic logic I would use. Collect your data (could be into a field) Output your data to a file on the server (using echo or the notify action) Use the PERFORM-ACTION-ADD-ATTACHMENT command in a Set Fields action For more info on the Notify action use the Help - Contents and Index in your admin tool and display the The Notify filter or escalation action topic. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kim Santana Sent: Friday, June 25, 2010 1:40 PM To: arslist@ARSLIST.ORG Subject: create a file and attach it to current form?? Has anyone built workflow or can point me in the right direction to do the following? On a formcollect data from a table walk save to a file and attach that file to an attachment field/pool on the current form? WHITHOUT manual intervention? I have attempted to use the open window actiondestination = file (but attachment fields are visible in the list) MS SQL 2005 Windows 2003 AR System 7.1Patch 007 Very much appreciated. Kimberly Santana Sr. Remedy Systems Engineer PHASE*FORWARD ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
DESIGN DISCUSSION... Although technically true (takes more time) -- has anybody ever seen an average index insert take 1 second to insert the index info? Meaning -- you submit a record -- it took 1 second. After adding an index - it now takes 2 seconds. Index population is raw at the db level (no Remedy workflow involved) -- if I look at actual db inserts -- they are .001 seconds. (normally) I do not think additional indexes are that bad. -John On Jul 12, 2010, at 5:02 PM, Patrick Zandi wrote: ** My suggestion is too many indexes More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to “In-Row” storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the “RemedyAndOracleCLOBs.pdf” document. Other things to check: 1.Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the “INSERT INTO” sql statement … 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
I find that its not the number of indexes that is the problem but inappropriate indexing Also if you use SLM then you will almost certainly need some additional indexes beyond the ootb ones once your DB gets over a certain size. We have added to additional indexes on SLM:Measurement to solve performance issues related to full table scans that we performed as part of the incident submit process. Also check Oracle AWR reports for long running queries this may provide some answers Stuart Schon Team Leader Fujitsu Australia Limited From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Sundberg Sent: Tuesday, 13 July 2010 08:16 To: arslist@ARSLIST.ORG Subject: Re: Poor performance while saving Incidents ** DESIGN DISCUSSION... Although technically true (takes more time) -- has anybody ever seen an average index insert take 1 second to insert the index info? Meaning -- you submit a record -- it took 1 second. After adding an index - it now takes 2 seconds. Index population is raw at the db level (no Remedy workflow involved) -- if I look at actual db inserts -- they are .001 seconds. (normally) I do not think additional indexes are that bad. -John On Jul 12, 2010, at 5:02 PM, Patrick Zandi wrote: ** My suggestion is too many indexes More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to In-Row storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the RemedyAndOracleCLOBs.pdf document. Other things to check: 1.Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the INSERT INTO sql statement ... 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com http://www.kineticdata.com/ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you. If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscr...@au.fujitsu.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
John, In the bigger picture it's not really a matter of raw performance at the DB level -- it's a matter of resource contention. Some actions performed while inserting or updating an index entry end up issuing a lock on the resource(s) being used. While it is locked, nothing else can insert, update, and some times even query. Nutshell: It doesn't matter if the action only takes .002 seconds if you have to wait 2 seconds for your turn. Start increasing the number of concurrent users creating tickets for your test and you will eventually get to your +1 second. Juan Ingles P.S. I don't think anyone is saying that indexes are a bad thing, just that you have to be careful. On Mon, Jul 12, 2010 at 3:16 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** DESIGN DISCUSSION... Although technically true (takes more time) -- has anybody ever seen an average index insert take 1 second to insert the index info? Meaning -- you submit a record -- it took 1 second. After adding an index - it now takes 2 seconds. Index population is raw at the db level (no Remedy workflow involved) -- if I look at actual db inserts -- they are .001 seconds. (normally) I do not think additional indexes are that bad. -John On Jul 12, 2010, at 5:02 PM, Patrick Zandi wrote: ** My suggestion is too many indexes More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to “In-Row” storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the “RemedyAndOracleCLOBs.pdf” document. Other things to check: 1. Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the “INSERT INTO” sql statement … 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
JOB: Remedy Openings in US, Germany and Italy with QMX Support Services
QMX Support Services is looking to fill multiple Remedy Consultant positions. The opportunities are in Southern California, Georgia, South Carolina, New Mexico, Germany and Italy. Candidates must have strong Remedy skills and experience with ITSM and CMDB 7.5. Canidates must be US citizens and have a secret clearance or be able to qualify for a secret clearance. QMX is a certified BMC Alliance Consulting Partner. We specialize in government contracts as well as commercial projects. You will be working with a group of experienced QMX consultants who have successfully completed over 500 projects and most of whom have more than 10 years experience with the BMC Remedy products. If you are interested in learning more about QMX and this opportunity, please contact: Mike Gauche Email: mgau...@qmxs.com Phone: 703-549-3690 Thank you, Barb Barbara Siebert Senior Consultant QMX Support Services cell phone: 949-637-7522 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Atrium Core 7.6 Web Services
Hi, Has anyone used Atrium Core 7.6 Web Services? Does someone know the difference between Atrium Core Web Services and the Web Services installed together with ARS Server/Mid-tier? What would we lose (functionality etc) if we don't install the Web Services component of Atrium Core? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
Adding up to Sean's comment, i remember running the utility named PropConvertor which basically is pl/sql procedure that converts all the existing CLOB from outrow to inrow. This helped us in having better incident save time + the restart time of the server. Regards Sathish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Poor performance while saving Incidents
Hi, As per my logs I have problem only with CLOB storage. It is a new set up and so no new indexes have been created. Satish, Can you please give more info on on the PropConvertor? Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Tue, Jul 13, 2010 at 11:56 AM, SUBSCRIBE arslist Sathish p.sathishku...@gmail.com wrote: Adding up to Sean's comment, i remember running the utility named PropConvertor which basically is pl/sql procedure that converts all the existing CLOB from outrow to inrow. This helped us in having better incident save time + the restart time of the server. Regards Sathish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email notification sent to the user when priority of an incident is changed.
i believe when you say user..you mean the Assignee Group to get notified when the incident priority changes... If so also please make sure you have the Filters to have Notification Tag info pushed in the NTE sys Individual or Group form accordingly and also have corresponding Sys Messages required. We had applied a Notification hot fix on top of 7.1, which uses NTE sys process control, and implemented similar logic to notify the Assignee group due to business reasons. Regards Sathish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Atrium Core 7.6 Web Services
This question was asked and answered on the BMC DN recently: http://communities.bmc.com/communities/message/155261 -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Monday, July 12, 2010 5:53 PM To: arslist@ARSLIST.ORG Subject: Atrium Core 7.6 Web Services ** Hi, Has anyone used Atrium Core 7.6 Web Services? Does someone know the difference between Atrium Core Web Services and the Web Services installed together with ARS Server/Mid-tier? What would we lose (functionality etc) if we don't install the Web Services component of Atrium Core? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: CMDB and AIE baseline white paper
Is this the one you are looking for: Performance and Scalability of BMC Remedy ITSM Suite 7.5.01 and BMC Atrium CMDB 7.5.00 Patch 1 on Solaris 10 Conducted at the Sun Solution Center Here is the link: http://documents.bmc.com/supportu/documents/46/71/104671/104671.pdf Jason On Mon, Jul 12, 2010 at 2:47 PM, Timothy Powell timothy.pow...@pbs-consulting.com wrote: ** I’m reaching out here. I recall reading a white paper authored by BMC which gave some performance measures regarding CMDB activities. Specifically it detailed some various server configurations and then gave a number of CI’s processed per second/hour for load, identify and merge activities. I do not recall what version of the CMDB and/or AIE the white paper was authored against. I just recall reading it once. I need it again, but cannot locate it. If anybody has this or knows the name of the paper, please share. Thanks in advance. Tim Powell _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Atrium Core 7.6 Web Services
Hi David, Is this part of a special community? I received the following when trying to access it: This area of the BMC Communities is visible only to registered, logged in users. If you are logged in when you receive this message, then you might not have sufficient access privileges to view the requested page. Jason On Mon, Jul 12, 2010 at 9:21 PM, Easter, David david_eas...@bmc.com wrote: ** This question was asked and answered on the BMC DN recently: http://communities.bmc.com/communities/message/155261 -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kali Obsum *Sent:* Monday, July 12, 2010 5:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Atrium Core 7.6 Web Services ** Hi, Has anyone used Atrium Core 7.6 Web Services? Does someone know the difference between Atrium Core Web Services and the Web Services installed together with ARS Server/Mid-tier? What would we lose (functionality etc) if we don't install the Web Services component of Atrium Core? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Atrium Core 7.6 Web Services
Oops, sorry - you are correct. Probably was an internal person asking on an internal forum for a customer (perhaps the one that posted here...) Here's the answer: The Atrium Core Web Services and the Web Services provided by AR are not the same features and they do not serve the same purpose. AR provides a way to expose and manage a form through Web Services. That enables AR applications to provide access and control to their forms through Web Services. AR uses Axis. AR web services can be registered if the Atrium Core UDDI registry is installed and its information are configured into AR. The Atrium Core web Services are based on Axis II version 1.5.xx - the Atrium Core Web Services expose all (or almost all) the public APIs available from Atrium Core. That covers Reconciliation Engine, Normalization Engine, CMDB Server (CI and Relationship CRUD, Class manager, Graph query and CI search ...) APIs. There are some additional APIs that are available through Web Services, but not the Atrium Core APIs: Impacted Services for instance. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Monday, July 12, 2010 9:39 PM To: arslist@ARSLIST.ORG Subject: Re: Atrium Core 7.6 Web Services ** Hi David, Is this part of a special community? I received the following when trying to access it: This area of the BMC Communities is visible only to registered, logged in users. If you are logged in when you receive this message, then you might not have sufficient access privileges to view the requested page. Jason On Mon, Jul 12, 2010 at 9:21 PM, Easter, David david_eas...@bmc.commailto:david_eas...@bmc.com wrote: ** This question was asked and answered on the BMC DN recently: http://communities.bmc.com/communities/message/155261 -David J. Easter Sr. Product Manager, Enterprise Service Management 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:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Kali Obsum Sent: Monday, July 12, 2010 5:53 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Atrium Core 7.6 Web Services ** Hi, Has anyone used Atrium Core 7.6 Web Services? Does someone know the difference between Atrium Core Web Services and the Web Services installed together with ARS Server/Mid-tier? What would we lose (functionality etc) if we don't install the Web Services component of Atrium Core? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Atrium Core 7.6 Web Services
Thanks! I have been meaning to ask about the Atrium Core Web Services myself and then I saw Kali's post. We installed it on our POC system but it was taxing the little vm too much so I removed it. Can you clarify, the Atrium Core Web Service do not only provide CMDB data to other apps but can also bring in data from system's that can feed into the CMDB? Somewhere I got the impression that the Atrium web services were only one way, exposing data stored in the CMDB. Jason On Mon, Jul 12, 2010 at 9:45 PM, Easter, David david_eas...@bmc.com wrote: ** Oops, sorry – you are correct. Probably was an internal person asking on an internal forum for a customer (perhaps the one that posted here...) Here’s the answer: The Atrium Core Web Services and the Web Services provided by AR are not the same features and they do not serve the same purpose. AR provides a way to expose and manage a form through Web Services. That enables AR applications to provide access and control to their forms through Web Services. AR uses Axis. AR web services can be registered if the Atrium Core UDDI registry is installed and its information are configured into AR. The Atrium Core web Services are based on Axis II version 1.5.xx - the Atrium Core Web Services expose all (or almost all) the public APIs available from Atrium Core. That covers Reconciliation Engine, Normalization Engine, CMDB Server (CI and Relationship CRUD, Class manager, Graph query and CI search ...) APIs. There are some additional APIs that are available through Web Services, but not the Atrium Core APIs: Impacted Services for instance. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jason Miller *Sent:* Monday, July 12, 2010 9:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Atrium Core 7.6 Web Services ** Hi David, Is this part of a special community? I received the following when trying to access it: This area of the BMC Communities is visible only to registered, logged in users. If you are logged in when you receive this message, then you might not have sufficient access privileges to view the requested page. Jason On Mon, Jul 12, 2010 at 9:21 PM, Easter, David david_eas...@bmc.com wrote: ** This question was asked and answered on the BMC DN recently: http://communities.bmc.com/communities/message/155261 -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kali Obsum *Sent:* Monday, July 12, 2010 5:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Atrium Core 7.6 Web Services ** Hi, Has anyone used Atrium Core 7.6 Web Services? Does someone know the difference between Atrium Core Web Services and the Web Services installed together with ARS Server/Mid-tier? What would we lose (functionality etc) if we don't install the Web Services component of Atrium Core? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are