Archiving Issue
Hi there, Version 7.1 Can anybody tell me what are the effects while Archiving the incidents. If I will archive those incidents which are related to Changes or Problems or Configuration Items, what would be the impact? Attachments in Work info would archive separately. I studied the BMC Document Form and App Objects, but I have not get good idea for archiving. Is there any other BMC Document for Archiving, please let me know. 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Auto-populating WO Fields without info entered
Hi Richard First thing, I would recommend is to contact BMC and find out if they have a quick fix. This issue has been around over a year now and they should definitely have something. Thanks Mahesh On Tue, Jul 27, 2010 at 11:42 PM, Richard Matovu rich...@matrich.netwrote: ** Hi Mahesh, Yes, it is SRM 2.2 Patch 2. How do I solve this defect? Could you please send me any links, tutorials or pointers? Thanks and Kind Regards, Richard On Wed, Jul 28, 2010 at 6:19 AM, Mahesh mchand...@gmail.com wrote: ** What is the SRM version ? The last time I saw this defect (# SW00320171) was on SRM 2.2 Patch 2. Thanks Mahesh On Tue, Jul 27, 2010 at 6:27 AM, Richard Matovu rich...@matrich.netwrote: ** Hi, I created a service request which gathers information to populate a work order template utilizing the Details 2 tab to store the gathered information. The fields which were mapped include WO Type Field 11_Char, WO Type Field 12_Char to WO Type Field 17_Char. However, when a user fills the information, the fields which he doesn't fill in are also auto-populated with values got from the other fields instead of having blanks in those fields which were not filled. Anyone else who has come across this or knows a solution, please help. I will be very grateful for your help. Thanks and Kind Regards, Richard _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Matovu Richard Matrich Email: rich...@matrich.net Web: http://www.matrich.net/ _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
Session Invalid Error
Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn't resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Error using rrrchive
Hi Misi Thanks for providing the 6.3 version. I've just ran it against 2 records that had failed with version 7.0 and they both worked. I'm now running against a bigger batch (5k records) that had failed before. Let's see it the good results keep coming! Unfortunately I couldn't find out why the records are failing with version 7.0. Please let me know if you want me to send any log file or data sample, just in case you want to dig deeper on this issue. I will obviously keep you informed on the final result. Once again, thanks very much for your assistance Cheers Rafael Bertolini -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: 27 July 2010 16:47 To: arslist@ARSLIST.ORG Subject: Re: Error using rrrchive Hi, My guess is that the caracters encoded might be the problem. RRR|Chive leaves to the ARAPI to do the character conversion, but if the target database does not support a specific character, you might get a problem. I guess... I also guess that in version 5.x of the AR System, character encodings were not strictly enforced, and that bad characters could have ended up in the database. The bad codes could be something that got there on even older versions of your system. When you go via ARX-files, the character codes are rechecked, and possibly cleaned, before the import. I will send you a private mail with the URL to the 6.3-version of RRR|Chive, so you can test that as well. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi Misi Yes, I could set ARAPILOGGING on the current version and it generated the log file, but as you expected, no really useful information was provided (just the failed ARMergeEntry with no description on why it failed). The faulty records always fail. I can use qual to try to migrate only one faulty record and it always fails with the same message. (ARERR 91) I then exported the faulty record and imported it into the new server and I noticed something strange: on the original server I have some Japanese (I think) characters and they were imported as ? characters. (I can see the Japanese characters in the ARX file). Anyway, I can see records that were migrated successfully and have Japanese characters (not as many as this one though) and I can also see records that failed to migrate and don't seem to have any Japanese characters, so not sure it's related to the problem. If possible, I'd like to test with the 6.3 version, just to try all the possibilities. I'm really sorry to keep bugging you with this. Thanks very much for all your assistance. Regards, Rafael Bertolini Consultant Fusion Business Solutions (UK) Ltd Tel: +44 208 8146177 Mob: +44 7500 441522 www.fusion.co.uk Fusion is the largest consultancy in Europe that focuses exclusively on BMC Software solutions -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: 27 July 2010 12:17 To: arslist@ARSLIST.ORG Subject: Re: Error using rrrchive Hi, ARAPILOGGING exists for old versions as well, but may not be well documented. Follow the information for 7.5 ARAPILOGGING. I do not think that you will get much out of that though, as the failing call is ARMergeEntry, and we get the error message... The only thing I can think of is incompatibility issues between your 5.x server and the 7.0 API, and that for the ARGetEntry for some reason give us a corrupt structure. Does the exact same records fail each time? Have you tried to export one of the problematic records to an ARX-file (ARUser) and the importing it with ARImport? I may be able to supply a 6.3-API version of RRR|Chive that may work differently. Any API should be working 2 versions backwards and 2 versions forward, at least. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. HI Misi Thanks for your reply. I took a look at ARERR91 description and then checked the handlers on my windows server and it seems to be ok. Answering your questions, one server is version 5 and the other 7.1. I'm migrating data from an archive form with no workflow related to it. In the server error log file there's no error at all. I also enabled the API log on the server and I can see the ARGetEntry and a ARMergeEntry calls as you explained, but again, no error at all (I guess the failed records are failing before
How to configure LB with mid-tier?
Hi List, How do you configure health check in LB? Do you use StatusCheckServlet (in ARS sp4+)? I will have two mid-tiers (VMWare machine) behind a F5 LB. How to configure F5 LB for this architecture? Thanks, -- Regards, 刘征 Martin Liu -- Blog: http://martinliu.cn ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
How to configure LB with mid-tier?
Martin, It depends what you want to 'health check'. The first thing to do is set the sticky flag on the F5. The next thing to do is find something for the F5 to request that'll ascertain whether the web server (i.e. Tomcat) is alive - perhaps could make a request to a static file in the Midtier, such as a small image? You may then want to go further and configure something to check the Midtier itself, and I'm not sure what to check at that point (as essentially, you really want to test the link betwern MT and AR System). John -- Java System Solutions http://www.javasystemsolutions.com/jss/ssoplugin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Error using rrrchive
Hi, Good to hear that it is working. Why it works differently is hard to tell. I am confident that it is something that happens within the ARAPI, which is out of our control. I would guess that the Japanese characters translates in a different way in the two API-versions. I do not think it is worth the effort to try to fix this, as it is very likely something not affecting newer servers. The possibility of corrupt character data in upgraded systems still exist, but I think it is hard to fix something like that in RRR|Chive... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi Misi Thanks for providing the 6.3 version. I've just ran it against 2 records that had failed with version 7.0 and they both worked. I'm now running against a bigger batch (5k records) that had failed before. Let's see it the good results keep coming! Unfortunately I couldn't find out why the records are failing with version 7.0. Please let me know if you want me to send any log file or data sample, just in case you want to dig deeper on this issue. I will obviously keep you informed on the final result. Once again, thanks very much for your assistance Cheers Rafael Bertolini -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: 27 July 2010 16:47 To: arslist@ARSLIST.ORG Subject: Re: Error using rrrchive Hi, My guess is that the caracters encoded might be the problem. RRR|Chive leaves to the ARAPI to do the character conversion, but if the target database does not support a specific character, you might get a problem. I guess... I also guess that in version 5.x of the AR System, character encodings were not strictly enforced, and that bad characters could have ended up in the database. The bad codes could be something that got there on even older versions of your system. When you go via ARX-files, the character codes are rechecked, and possibly cleaned, before the import. I will send you a private mail with the URL to the 6.3-version of RRR|Chive, so you can test that as well. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi Misi Yes, I could set ARAPILOGGING on the current version and it generated the log file, but as you expected, no really useful information was provided (just the failed ARMergeEntry with no description on why it failed). The faulty records always fail. I can use qual to try to migrate only one faulty record and it always fails with the same message. (ARERR 91) I then exported the faulty record and imported it into the new server and I noticed something strange: on the original server I have some Japanese (I think) characters and they were imported as ? characters. (I can see the Japanese characters in the ARX file). Anyway, I can see records that were migrated successfully and have Japanese characters (not as many as this one though) and I can also see records that failed to migrate and don't seem to have any Japanese characters, so not sure it's related to the problem. If possible, I'd like to test with the 6.3 version, just to try all the possibilities. I'm really sorry to keep bugging you with this. Thanks very much for all your assistance. Regards, Rafael Bertolini Consultant Fusion Business Solutions (UK) Ltd Tel: +44 208 8146177 Mob: +44 7500 441522 www.fusion.co.uk Fusion is the largest consultancy in Europe that focuses exclusively on BMC Software solutions -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: 27 July 2010 12:17 To: arslist@ARSLIST.ORG Subject: Re: Error using rrrchive Hi, ARAPILOGGING exists for old versions as well, but may not be well documented. Follow the information for 7.5 ARAPILOGGING. I do not think that you will get much out of that though, as the failing call is ARMergeEntry, and we get the error message... The only thing I can think of is incompatibility issues between your 5.x server and the 7.0 API, and that for the ARGetEntry for some reason give us a corrupt structure. Does the exact same records fail each time? Have you tried to export one of the problematic records to an ARX-file (ARUser) and the importing it with ARImport? I may be able to supply a 6.3-API version of RRR|Chive that may work differently. Any API should be working 2 versions backwards and
Re: Moving/copying data from one server to another...
Although copying the DB does not physically move the MAC ID, it will move the server license key associated with the copied servers Host ID (MAC). This is easily fixed by adding the correct license after the copy. If you plan to do this regularly, you can add both the prod and dev server license keys to the prod server. Then when the DB is copied it will ignore the incorrect key and use the correct dev key. Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** -- Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... -- The server is local - about 20 feet away. I was told that copying via an SQL database copy wouldn't work due to mac addresses being copied from the old to the new database, etc. - hence it seemed like Migrator would be the way to gobut that's a guess - hence asking on the list. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions...such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Auto-populating WO Fields without info entered
Hi Mahesh, Thanks so much for the help. I managed to get over it. There is patch 4 available which fixes the issue but I used the SW00320171 hotfix to fix it. It works now well. I am so grateful for your help and the list at large. Thanks, Richard On Wed, Jul 28, 2010 at 10:22 AM, Mahesh mchand...@gmail.com wrote: ** Hi Richard First thing, I would recommend is to contact BMC and find out if they have a quick fix. This issue has been around over a year now and they should definitely have something. Thanks Mahesh On Tue, Jul 27, 2010 at 11:42 PM, Richard Matovu rich...@matrich.netwrote: ** Hi Mahesh, Yes, it is SRM 2.2 Patch 2. How do I solve this defect? Could you please send me any links, tutorials or pointers? Thanks and Kind Regards, Richard On Wed, Jul 28, 2010 at 6:19 AM, Mahesh mchand...@gmail.com wrote: ** What is the SRM version ? The last time I saw this defect (# SW00320171) was on SRM 2.2 Patch 2. Thanks Mahesh On Tue, Jul 27, 2010 at 6:27 AM, Richard Matovu rich...@matrich.netwrote: ** Hi, I created a service request which gathers information to populate a work order template utilizing the Details 2 tab to store the gathered information. The fields which were mapped include WO Type Field 11_Char, WO Type Field 12_Char to WO Type Field 17_Char. However, when a user fills the information, the fields which he doesn't fill in are also auto-populated with values got from the other fields instead of having blanks in those fields which were not filled. Anyone else who has come across this or knows a solution, please help. I will be very grateful for your help. Thanks and Kind Regards, Richard _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Matovu Richard Matrich Email: rich...@matrich.net Web: http://www.matrich.net/ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Matovu Richard Matrich Email: rich...@matrich.net Web: http://www.matrich.net/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Reporting : How do I get a list of Incidents that I have worked on last week
Terry, At the top of this form I see a Date field which represents the date the work log was submitted. There is also a Submit Date and a Reported Date. The name of the form I am looking at is HPD:Search-Worklog. Rebecca From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terry Bootsma Sent: Tuesday, July 27, 2010 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: Reporting : How do I get a list of Incidents that I have worked on last week ** Thanks Rebecca et al... I looked at this join form, but it does not have any other dates other than the incident reported date. Because it is a join form, it doesn't have an associated create date like another arslist'r suggested earlier. I can't believe this isn't OOB... Terry On Jul 27, 2010, Boyd, Rebecca E. boy...@wfu.edu wrote: Terry, Take a look at the “Search Work Info” form. It’s a join between Incident the work log. Some of our people use this for reporting purposes. Rebecca From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Tuesday, July 27, 2010 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: Reporting : How do I get a list of Incidents that I have worked on last week ** Terry, I can’t speak to how ITSM works, but to get this type of functionality in custom apps I have worked on in the past, you basically need to have a form that gets an entry for EVERY update to an incident, at minimum you would want to track who made the update. Then you could run your report off of this table showing any entries that they created….this would show them the incidents they touched for that given time period. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terry Bootsma Sent: Tuesday, July 27, 2010 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Reporting : How do I get a list of Incidents that I have worked on last week ** Thanks for your feedback so far... The issue I see with Status History is that it represents the last user and time that this incident was assigned during the incident lifecycle. If this incident goes from one person to another, reporting via Status History will miss the original assignee and group Terry On Jul 27, 2010, Ram Rudra rambabu.ru...@gssamerica.com wrote: ** Yes, You have two fields from the HPD:Help_Desk form, You can get the report requirement. Status_History_Assigned_Time Status_History_Assigned_User Thanks Regards, Rambabu Rudra System Administrator From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Benedetto Cantatore Sent: Tuesday, July 27, 2010 8:01 PM To: arslist@ARSLIST.ORG Subject: Re: Reporting : How do I get a list of Incidents that I have worked on last week ** The canned reports are a bit lacking. I usually take the OOB report and modify it to suit me. So if you prefer Group Assignments to Incidents to use 'Status-History.Assigned.' then extract this report from the Reports form and modify it. You'll need Crystal Reports to modify. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 tboot...@objectpath.com 07/27/10 9:50 AM ** Software: ITSM 7.1 and 7.6 - Incident Management Hi everyone: My second arslist post in the same day! Wow... this must be something... :-) I've done some investigation into how a person or group would generate a report of all incidents that they have worked on for the last N days using the OOB reports . Note that they may or may not resolve the incident and may not be the last one who touches the incident. From my initial investigation, there doesn't seem to be any reports that generate this information. There is a report called Group Assignment to Incidents, but this report queries on the Reported Date of the incident and not the date that the incident was assigned to the group/individual (Explanation: If I was assigned an incident that was reported before last week, if I run a report using this OOB report using last weeks dates, I do not get this incident since it was reported before last week).
Re: Change Management question
Thanks Doug for taking the time to craft this reply. You are confirming my thought process. I believe this is the first time your reply is not about ARS, but about an application, so we are breaking new ground here :-), so thanks again for your participation. About the name for the Release Mgmt module, I guess we'll have to get used to and adapt to this terminology, and get rid off old conceptions. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Mueller, Doug [doug_muel...@bmc.com] Sent: Tuesday, July 27, 2010 6:10 PM To: arslist@ARSLIST.ORG Subject: Re: Change Management question ** Everyone, Given that this discussion has wandered around for a while and in several different directions, I wanted to put together a response. I chose to remove the history of the discussion since there were several different sets of includes with different depths and just start with a clean slate for the reply. Issue 1 -- ITIL is a set of guidelines not an absolute Step one in any discussion -- not unique to this discussion -- is to remember that ITIL is a set of guidelines and is not absolute. It does not have an answer to everything. In the real world, there are things that are simply not practical and it is important to interpret and allow for deviation. It is a good set of guidelines and the goal is to follow the basic principles and directions that it encourages. However, there are also times to deviate. Let's take a specific example with the CMDB. In ITIL v2, the CMDB specs said that things like Trouble Tickets and SLAs and the like all belonged within the CMDB. The problem is that these things are not configuration items (well, we could talk about SLAs, but for sure Trouble Tickets). BMC decided that the CMDB was for CONFIGURATION data and did not model Trouble Tickets in the CMDB and insisted that they did not belong there. I know we ran into a number of customers with ITIL police who insisted that we were doing things wrong because Trouble Tickets did belong in the CMDB. It says so right here.. I was involved in many discussions around this topic. Well, it turns out, that by the time ITIL v3 came along, there was an understanding that Trouble Tickets really didn't belong in the CMDB and you will find that they are not items that ITIL v3 advocates are in the CMDB. There is now the CMS which BMC always called the Extended CMDB and Trouble Tickets are there but stored in a Trouble Ticket data store. This interpretation of what a CMDB is and is about is what BMC had advocated from the start and as it turns out ITIL agreed and adjusted where if we had just followed the ITIL rules at the time, it would have been the wrong direction. Now, I am not indicating that there is the same issue going on in this situation (and in fact I don't), but I always want to start any conversation with this note whenever there is a battle that forms up along the lines of ITIL SAYS. Yes, but. Issue 2 -- What are we trying to accomplish? Now, let's return to this situation. What are we trying to do? What is the problem we are trying to solve? -- Need to request, plan, and have the steps to execute a change to the environment -- Need to request, plan, and orchestrate a set of changes and other activities in the environment If I take these things, there is a difference in scope and process in these two goals. The first is about making a very specific change. To interact with the environment and change the configuration in some way. There are a specific set of steps that need to be performed. You may need to be aware of other changes to the same object and want to coordinate them. But, in general, you are worried about a point change to a specific object and not about the bigger picture of coordination of the entire environment or infrastructure. The second is about really more complete planning and coordination of one or more changes and potentially other things in the environment to have a larger scope process. You many need to make a series of changes and have things like training or data conversion or any number of other things involved and scheduled and synchronized. There is the concept of a rollback plan (not part of change by the way) if there are problems. There is a concept that you may or may not get all changes and what to do about that (if one thing out of 50 is not done are you OK or is that a failure). Notice that the second item here is bigger than the first. There is an entire layer of planning and coordination that is not part of the first. They don't intermix. One is about performing the update. The other is about coordinating the update(s) and other activity. If there is not some distinction between what is going on, why would there be a need for different processes and flows -- whether ITIL or not. There seems to be agreement that there are two different
Re: Mid-Tier 7.5 Problems
Nope. Not an option. On Tue, Jul 27, 2010 at 3:50 PM, John Baker jba...@javasystemsolutions.comwrote: Tried disabling the home brew SSO modules? ___ 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: Session Invalid Error
We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.comwrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn’t resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _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: How to configure LB with mid-tier?
Martin, Where did you find reference to a StatusCheckServlet? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin Liu Sent: Wednesday, July 28, 2010 2:46 AM To: arslist@ARSLIST.ORG Subject: How to configure LB with mid-tier? Hi List, How do you configure health check in LB? Do you use StatusCheckServlet (in ARS sp4+)? I will have two mid-tiers (VMWare machine) behind a F5 LB. How to configure F5 LB for this architecture? Thanks, -- Regards, 刘征 Martin Liu -- Blog: http://martinliu.cn ___ 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: Reporting : How do I get a list of Incidents that I have worked on last week
Terry, Have you taken a look at the HPD:Help Desk Assignment Log and/or HPD:HelpDeskAssignmentLogJoin? Its stores a history of assignments and reassignments, time spent, etc. Thad On Tue, Jul 27, 2010 at 7:48 PM, Terry Bootsma tboot...@objectpath.comwrote: ** Thanks Rebecca et al... I looked at this join form, but it does not have any other dates other than the incident reported date. Because it is a join form, it doesn't have an associated create date like another arslist'r suggested earlier. I can't believe this isn't OOB... Terry On Jul 27, 2010, *Boyd, Rebecca E.* boy...@wfu.edu wrote: Terry, Take a look at the “Search Work Info” form. It’s a join between Incident the work log. Some of our people use this for reporting purposes. Rebecca *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing *Sent:* Tuesday, July 27, 2010 11:15 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Reporting : How do I get a list of Incidents that I have worked on last week ** Terry, I can’t speak to how ITSM works, but to get this type of functionality in custom apps I have worked on in the past, you basically need to have a form that gets an entry for EVERY update to an incident, at minimum you would want to track who made the update. Then you could run your report off of this table showing any entries that they created….this would show them the incidents they touched for that given time period. *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Terry Bootsma *Sent:* Tuesday, July 27, 2010 8:59 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Reporting : How do I get a list of Incidents that I have worked on last week ** Thanks for your feedback so far... The issue I see with Status History is that it represents the last user and time that this incident was assigned during the incident lifecycle. If this incident goes from one person to another, reporting via Status History will miss the original assignee and group Terry On Jul 27, 2010, *Ram Rudra* rambabu.ru...@gssamerica.com wrote: ** Yes, You have two fields from the HPD:Help_Desk form, You can get the report requirement. Status_History_Assigned_Time Status_History_Assigned_User Thanks Regards, Rambabu Rudra System Administrator *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Benedetto Cantatore *Sent:* Tuesday, July 27, 2010 8:01 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Reporting : How do I get a list of Incidents that I have worked on last week ** The canned reports are a bit lacking. I usually take the OOB report and modify it to suit me. So if you prefer Group Assignments to Incidents to use 'Status-History.Assigned.' then extract this report from the Reports form and modify it. You'll need Crystal Reports to modify. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 tboot...@objectpath.com 07/27/10 9:50 AM ** Software: ITSM 7.1 and 7.6 - Incident Management Hi everyone: My second arslist post in the same day! Wow... this must be something... :-) I've done some investigation into how a person or group would generate a report of all incidents that they have worked on for the last N days using the OOB reports . Note that they may or may not resolve the incident and may not be the last one who touches the incident. From my initial investigation, there doesn't seem to be any reports that generate this information. There is a report called Group Assignment to Incidents, but this report queries on the Reported Date of the incident and not the date that the incident was assigned to the group/individual (Explanation: If I was assigned an incident that was reported before last week, if I run a report using this OOB report using last weeks dates, I do not get this incident since it was reported before last week). I can't believe that I'm the first one to come across this and would like to see how others have addressed this requirement. Terry _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_ _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
Mid-Tier 7.5 Problems
Well that's the next step. There are lots of SSO issues in AR System. John Baker ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARS v7.5 - importing forms changed Table ID
Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS v7.5 - importing forms changed Table ID
hI Susan, I have never attempted to change a table ID, never had the need. I would never attempt it either... Having said that, and to answer your question, you would need to do a fair amount of updates in the tables that comprise the Remedy data dictionary The table ID is actually the schemaId in many such tables, so you would need to find all the rows in all the tables to update that schemaId. A good place to start would be to take a look at the BMC document called Database reference guide, or something like that, and see where that schemaId is... In any case, as you know, make sure you have a good database backup before proceeding, and the DBA has actually tested it as you know this is one of these tasks were BMC support will not help you, and people from the list won't be of much assistance either if things go wrong. So... do yourself a favor and DONT do thisinstead of importing data on the T tables, use the database views that are automatically created for each table, and for which the view name is similar to the form name. Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Susan Palmer [suzanpal...@gmail.com] Sent: Wednesday, July 28, 2010 11:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.commailto:spal...@shoppertrak.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
Re: ARS v7.5 - importing forms changed Table ID
You could use archgid, it can change table ID's too..it goes through the system and updates all appropriate references...while I've never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 9:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.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
Re: ARS v7.5 - importing forms changed Table ID
interesting, I forgot about that one... I've used archgid to change field IDs only. Never tried for a form/table ID. Not sure if I would use it though...if it's one of those features that are not heavily used, you may end up finding an undocumented feature! Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of LJ LongWing [lj.longw...@gmail.com] Sent: Wednesday, July 28, 2010 11:46 AM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** You could use archgid, it can change table ID’s too….it goes through the system and updates all appropriate references…..while I’ve never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files :) From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 9:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.commailto:spal...@shoppertrak.com _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: Moving/copying data from one server to another...
That is correct. And even if there is a license with a wrong MAC Id in the License form, the system will ignore that license. It only looks for a license that matches its own host ID. That is how the server picks up the right license in case of a server group. Joe From: Arner, Todd tar...@glhec.org To: arslist@ARSLIST.ORG Sent: Wed, July 28, 2010 7:55:49 AM Subject: Re: Moving/copying data from one server to another... ** Although copying the DB does not physically move the MAC ID, it will move the server license key associated with the copied servers Host ID (MAC). This is easily fixed by adding the correct license after the copy. If you plan to do this regularly, you can add both the prod and dev server license keys to the prod server. Then when the DB is copied it will ignore the incorrect key and use the correct dev key. Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** -- Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... -- The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from theold to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess– hence asking on the list….. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From:Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10
Re: ARS v7.5 - importing forms changed Table ID
Thanks LJ ... I'll do that search. I don't have much to lose before I spend more time importing data form by form. If I can change that ID I would be ecstatic! Thanks for your input Guillaume. Susan :) On Wed, Jul 28, 2010 at 10:46 AM, LJ LongWing lj.longw...@gmail.com wrote: ** You could use archgid, it can change table ID’s too….it goes through the system and updates all appropriate references…..while I’ve never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files J *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Susan Palmer *Sent:* Wednesday, July 28, 2010 9:22 AM *To:* arslist@ARSLIST.ORG *Subject:* ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com _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 v7.5 - importing forms changed Table ID
I have used archgid for both forms and fields and it works. Actually what I do is to set the next ID to the correct ID before I import a new form (Use TOAD to do a direct update to the control table in the database), and then set it back afterwards. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, July 28, 2010 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** You could use archgid, it can change table ID's tooit goes through the system and updates all appropriate references.while I've never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files :) From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 9:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.commailto:spal...@shoppertrak.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS v7.5 - importing forms changed Table ID
That is always a chance.but I would trust archgid more than I would trust me doing it manually..and I agree with your assessment, TID should NEVER be used in direct SQL..I ALWAYS recommend using View names instead of table ids..still fragile, but less so that table id J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Wednesday, July 28, 2010 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** interesting, I forgot about that one... I've used archgid to change field IDs only. Never tried for a form/table ID. Not sure if I would use it though...if it's one of those features that are not heavily used, you may end up finding an undocumented feature! Guillaume _ From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of LJ LongWing [lj.longw...@gmail.com] Sent: Wednesday, July 28, 2010 11:46 AM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** You could use archgid, it can change table ID's too..it goes through the system and updates all appropriate references...while I've never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 9:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com _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: Mid-Tier 7.5 Problems
Care to share the details of any SSO issues you know of with mid-tier 7.5? Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 9:50 AM, John Baker jba...@javasystemsolutions.comwrote: Well that's the next step. There are lots of SSO issues in AR System. John Baker ___ 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: ARS v7.5 - importing forms changed Table ID
I would also recommend querying the ARSCHEMA table to get the View Name and then in the next action use that view name. Example: Action 1: SELECT ViewName FROM ARSCHEMA WHERE NAME = '$SCHEMA$' Action 2: UPDATE $ViewName$ SET WHERE Thanks Mahesh On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Guillaume Rheault *Sent:* Wednesday, July 28, 2010 9:50 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS v7.5 - importing forms changed Table ID ** interesting, I forgot about that one... I've used archgid to change field IDs only. Never tried for a form/table ID. Not sure if I would use it though...if it's one of those features that are not heavily used, you may end up finding an undocumented feature! Guillaume -- *From:* Action Request System discussion list(ARSList) [ arsl...@arslist.org] on behalf of LJ LongWing [lj.longw...@gmail.com] *Sent:* Wednesday, July 28, 2010 11:46 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS v7.5 - importing forms changed Table ID ** You could use archgid, it can change table ID’s too….it goes through the system and updates all appropriate references…..while I’ve never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files J *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Susan Palmer *Sent:* Wednesday, July 28, 2010 9:22 AM *To:* arslist@ARSLIST.ORG *Subject:* ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. So, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com _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
RRR|Chive SAN Disk Space issues
Dear Listers, I have been archiving our NTE:Notifier Log records since the 15th of July using RRR|Chive to move records from NTE:Notifier Log to an archive table. The process has been smooth and quiet, but the Archive form has been eating up disk space. Yesterday, we nearly ran out of disk space on our SAN and had to add an emergency 200 GB of disk space. I moved 250K Notification Logs from the original NTE:Notification Log (T587) to the Notification Log Archive (T2057) yesterday. Those 250K records took up nearly 6G of table space. Growth (MB) Owner TypeSegment Name Lob Parent Tabl Lob Column - -- --- - --- - 2,954.77 ARADMINLOBSEGMENT SYS_LOB426378C00018$$ T2057 C84827 2,939.00 ARADMINLOBSEGMENT SYS_LOB426378C00020$$ T2057 C84820 156.77 ARADMINLOBSEGMENT SYS_LOB084949C00022$$ T587 C100827 156.24 ARADMINLOBSEGMENT SYS_LOB085002C00126$$ T590 C100827 154.55 ARADMINLOBSEGMENT SYS_LOB053052C00021$$ T69 C18091 The question I have for the list is: has anyone else seen this out-of-control growth when archiving records? Is this perhaps due to a write process that may be sloppy? Is truncating LOBs the answer? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.govmailto:jennifer.me...@nc.gov http://its.state.nc.ushttp://its.state.nc.us/ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS v7.5 - importing forms changed Table ID
LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id :) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Session Invalid Error
I would try to double-check that when this happens, the person hasn't actually been switched from one mid-tier server to the other - doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, July 28, 2010 8:10 AM To: arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.commailto:radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn't resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RRR|Chive SAN Disk Space issues
Assuming you are using Oracle: BMC has a doc out there talking about LOB storage being In-Row vs Out of Row. There is also a way to convert the data for existing tables using a stored procedure from In-Row from Out of Row. The document is called RemedyAndOracleClobs.pdf Also make sure the Store Clob In-Row option is checked. This only helps for future tables not current ones. You have to run the stored procedure to fix the old ones. Doing this reduced our DB size considerably. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, July 28, 2010 12:56 PM To: arslist@ARSLIST.ORG Subject: RRR|Chive SAN Disk Space issues ** Dear Listers, I have been archiving our NTE:Notifier Log records since the 15th of July using RRR|Chive to move records from NTE:Notifier Log to an archive table. The process has been smooth and quiet, but the Archive form has been eating up disk space. Yesterday, we nearly ran out of disk space on our SAN and had to add an emergency 200 GB of disk space. I moved 250K Notification Logs from the original NTE:Notification Log (T587) to the Notification Log Archive (T2057) yesterday. Those 250K records took up nearly 6G of table space. Growth (MB) Owner TypeSegment Name Lob Parent Tabl Lob Column - -- --- - --- - 2,954.77 ARADMINLOBSEGMENT SYS_LOB426378C00018$$ T2057 C84827 2,939.00 ARADMINLOBSEGMENT SYS_LOB426378C00020$$ T2057 C84820 156.77 ARADMINLOBSEGMENT SYS_LOB084949C00022$$ T587 C100827 156.24 ARADMINLOBSEGMENT SYS_LOB085002C00126$$ T590 C100827 154.55 ARADMINLOBSEGMENT SYS_LOB053052C00021$$ T69 C18091 The question I have for the list is: has anyone else seen this out-of-control growth when archiving records? Is this perhaps due to a write process that may be sloppy? Is truncating LOBs the answer? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.govmailto:jennifer.me...@nc.gov http://its.state.nc.ushttp://its.state.nc.us/ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _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: Session Invalid Error
I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn’t actually been switched from one mid-tier server to the other – doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Wednesday, July 28, 2010 8:10 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn’t resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _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: RRR|Chive SAN Disk Space issues
Are you on Oracle with ITSM 7.0 or earlier? The Email Message Body (100827) and Notification Text (100820) fields are unlimited length (0) in NTE:Notifier Log. In ITSM 7.6 they reduced those fields to 3964 to solve the Oracle issue (the filter NTE:NTS:AuditLog_900_PNTL truncates both fields in the push fields action), but that created one for me while using rrrchive to move records from production (7.1/7.0) to future production (7.5/7.6). I actually had to increase Email Message Body from 3964 to 0 in order to move my data, but I am on SQL Server 2008 so it should not be a problem for me. 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 Meyer, Jennifer L Sent: Wednesday, July 28, 2010 11:56 AM To: arslist@ARSLIST.ORG Subject: RRR|Chive SAN Disk Space issues ** Dear Listers, I have been archiving our NTE:Notifier Log records since the 15th of July using RRR|Chive to move records from NTE:Notifier Log to an archive table. The process has been smooth and quiet, but the Archive form has been eating up disk space. Yesterday, we nearly ran out of disk space on our SAN and had to add an emergency 200 GB of disk space. I moved 250K Notification Logs from the original NTE:Notification Log (T587) to the Notification Log Archive (T2057) yesterday. Those 250K records took up nearly 6G of table space. Growth (MB) Owner TypeSegment Name Lob Parent Tabl Lob Column - -- --- - --- - 2,954.77 ARADMINLOBSEGMENT SYS_LOB426378C00018$$ T2057 C84827 2,939.00 ARADMINLOBSEGMENT SYS_LOB426378C00020$$ T2057 C84820 156.77 ARADMINLOBSEGMENT SYS_LOB084949C00022$$ T587 C100827 156.24 ARADMINLOBSEGMENT SYS_LOB085002C00126$$ T590 C100827 154.55 ARADMINLOBSEGMENT SYS_LOB053052C00021$$ T69 C18091 The question I have for the list is: has anyone else seen this out-of-control growth when archiving records? Is this perhaps due to a write process that may be sloppy? Is truncating LOBs the answer? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.govmailto:jennifer.me...@nc.gov http://its.state.nc.ushttp://its.state.nc.us/ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _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 7.5 Problems
Is this a fresh install or an upgrade? -- J 2010/7/26 Axton axton.gr...@gmail.com: ** Wanted to see if anyone out there is having these types of issues with Mid-Tier 7.5 patch 4 or higher: - blank page when accessing a form - page stops loading at the animated gif (loading) - Javascript 'Caught Exception' errors - Unable to reach Mid-Tier. If you are on SSO, please re-login to SSO service. errors Has anyone seen errors like this in the mid-tier logs: Jul 26, 2010 12:17:54 PM - SEVERE (com.remedy.log.SERVLET) : (Thread 144) com.remedy.arsys.log.Log log Caught RuntimeExceptionjava.lang.IllegalStateException at org.apache.catalina.connector.ResponseFacade.sendRedirect(ResponseFacade.java:435) at com.remedy.arsys.stubs.FormServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619) Jul 26, 2010 12:19:18 PM - FINE (com.remedy.log.INTERNAL) : (Thread 164) com.remedy.arsys.goat.GoatException init Throw Internal Exception - Wrong argument length, spoofed Jul 26, 2010 12:19:18 PM - FINE (com.remedy.log.PERFORMANCE) : (Thread 145) com.remedy.arsys.stubs.BackchannelServlet doRequest Backchannel start: GetEntryList Jul 26, 2010 12:19:18 PM - SEVERE (com.remedy.log.SERVLET) : (Thread 164) com.remedy.arsys.log.Log log GoatException during NDXRequest: ARERR [-1] Message not found at com.remedy.arsys.backchannel.NDXGetEntryList.mapProperties(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXGetEntryList.init(Unknown Source) at com.remedy.arsys.backchannel.GetEntryListAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at
Re: Session Invalid Error
Hmm. Odd. I was seeing something similar at one point, but I think I tracked it down in our case to either the F5 or the IBM HTTP server switching someone from one MT server to the other for some unknown reason. It hasn't happened for a while for us, though, so I'm not sure what changed. I'm pretty sure I've never seen sessions expire like that so long as the person stays on the same MT server, though, on 7.1 p5 or 7.5 p3. Just out of curiosity, why do you have apache web servers in front of tomcat if they're simply forwarding to the local tomcat instance? Are you serving up static content (e.g., documentation) as well? Now you're making me nervous about upgrading. We're currently on MT 7.5 p3, and I was considering changing to p6. Have you done any testing with p5 or p6 yet to see if that makes a difference? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, July 28, 2010 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.orgmailto:tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn't actually been switched from one mid-tier server to the other - doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, July 28, 2010 8:10 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.commailto:radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn't resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _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_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _attend WWRUG10
Re: Mid-Tier 7.5 Problems
It's a bit of both. It's a fresh install (new boxes, new OS build, etc.), but it's part of an upgrade that replaces an existing (older) system (midtier 7.1). On Wed, Jul 28, 2010 at 12:35 PM, Jarl Grøneng jarl.gron...@gmail.comwrote: Is this a fresh install or an upgrade? -- J 2010/7/26 Axton axton.gr...@gmail.com: ** Wanted to see if anyone out there is having these types of issues with Mid-Tier 7.5 patch 4 or higher: - blank page when accessing a form - page stops loading at the animated gif (loading) - Javascript 'Caught Exception' errors - Unable to reach Mid-Tier. If you are on SSO, please re-login to SSO service. errors Has anyone seen errors like this in the mid-tier logs: Jul 26, 2010 12:17:54 PM - SEVERE (com.remedy.log.SERVLET) : (Thread 144) com.remedy.arsys.log.Log log Caught RuntimeExceptionjava.lang.IllegalStateException at org.apache.catalina.connector.ResponseFacade.sendRedirect(ResponseFacade.java:435) at com.remedy.arsys.stubs.FormServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619) Jul 26, 2010 12:19:18 PM - FINE (com.remedy.log.INTERNAL) : (Thread 164) com.remedy.arsys.goat.GoatException init Throw Internal Exception - Wrong argument length, spoofed Jul 26, 2010 12:19:18 PM - FINE (com.remedy.log.PERFORMANCE) : (Thread 145) com.remedy.arsys.stubs.BackchannelServlet doRequest Backchannel start: GetEntryList Jul 26, 2010 12:19:18 PM - SEVERE (com.remedy.log.SERVLET) : (Thread 164) com.remedy.arsys.log.Log log GoatException during NDXRequest: ARERR [-1] Message not found at com.remedy.arsys.backchannel.NDXGetEntryList.mapProperties(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXGetEntryList.init(Unknown Source) at com.remedy.arsys.backchannel.GetEntryListAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at
Re: Session Invalid Error
Patch 5 was pulled. I have not considered patch 6 since the release notes did not indicate any fixes in the area where I have problems. We have Apache in front of Tomcat because we have some Apache modules that we need to use to provide certain services. Our problems don't seem to come into the picture until we have ~400 concurrent users on one mid-tier server. Low volume against the server does not reproduce the issues. On Wed, Jul 28, 2010 at 12:41 PM, Lyle Taylor tayl...@ldschurch.org wrote: ** Hmm. Odd. I was seeing something similar at one point, but I think I tracked it down in our case to either the F5 or the IBM HTTP server switching someone from one MT server to the other for some unknown reason. It hasn’t happened for a while for us, though, so I’m not sure what changed. I’m pretty sure I’ve never seen sessions expire like that so long as the person stays on the same MT server, though, on 7.1 p5 or 7.5 p3. Just out of curiosity, why do you have apache web servers in front of tomcat if they’re simply forwarding to the local tomcat instance? Are you serving up static content (e.g., documentation) as well? Now you’re making me nervous about upgrading. We’re currently on MT 7.5 p3, and I was considering changing to p6. Have you done any testing with p5 or p6 yet to see if that makes a difference? Thanks, Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Wednesday, July 28, 2010 11:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Session Invalid Error ** I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn’t actually been switched from one mid-tier server to the other – doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Wednesday, July 28, 2010 8:10 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn’t resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _attend WWRUG10 www.wwrug.com ARSlist: Where the
Re: Session Invalid Error
What caused you to pull patch 5? 400 users seems like a lot to support on a single MT. Are you perhaps running into JVM heap limits? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, July 28, 2010 11:48 AM To: arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** Patch 5 was pulled. I have not considered patch 6 since the release notes did not indicate any fixes in the area where I have problems. We have Apache in front of Tomcat because we have some Apache modules that we need to use to provide certain services. Our problems don't seem to come into the picture until we have ~400 concurrent users on one mid-tier server. Low volume against the server does not reproduce the issues. On Wed, Jul 28, 2010 at 12:41 PM, Lyle Taylor tayl...@ldschurch.orgmailto:tayl...@ldschurch.org wrote: ** Hmm. Odd. I was seeing something similar at one point, but I think I tracked it down in our case to either the F5 or the IBM HTTP server switching someone from one MT server to the other for some unknown reason. It hasn't happened for a while for us, though, so I'm not sure what changed. I'm pretty sure I've never seen sessions expire like that so long as the person stays on the same MT server, though, on 7.1 p5 or 7.5 p3. Just out of curiosity, why do you have apache web servers in front of tomcat if they're simply forwarding to the local tomcat instance? Are you serving up static content (e.g., documentation) as well? Now you're making me nervous about upgrading. We're currently on MT 7.5 p3, and I was considering changing to p6. Have you done any testing with p5 or p6 yet to see if that makes a difference? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, July 28, 2010 11:27 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.orgmailto:tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn't actually been switched from one mid-tier server to the other - doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, July 28, 2010 8:10 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.commailto:radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn't resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for
Re: RRR|Chive SAN Disk Space issues
Bless the ARSList! That is exactly the document I need! Thank you, Sean and Chris. Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.govmailto:jennifer.me...@nc.gov http://its.state.nc.ushttp://its.state.nc.us/ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Wednesday, July 28, 2010 1:16 PM To: arslist@ARSLIST.ORG Subject: Possibly spam: Re: RRR|Chive SAN Disk Space issues ** Assuming you are using Oracle: BMC has a doc out there talking about LOB storage being In-Row vs Out of Row. There is also a way to convert the data for existing tables using a stored procedure from In-Row from Out of Row. The document is called RemedyAndOracleClobs.pdf Also make sure the Store Clob In-Row option is checked. This only helps for future tables not current ones. You have to run the stored procedure to fix the old ones. Doing this reduced our DB size considerably. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, July 28, 2010 12:56 PM To: arslist@ARSLIST.ORG Subject: RRR|Chive SAN Disk Space issues ** Dear Listers, I have been archiving our NTE:Notifier Log records since the 15th of July using RRR|Chive to move records from NTE:Notifier Log to an archive table. The process has been smooth and quiet, but the Archive form has been eating up disk space. Yesterday, we nearly ran out of disk space on our SAN and had to add an emergency 200 GB of disk space. I moved 250K Notification Logs from the original NTE:Notification Log (T587) to the Notification Log Archive (T2057) yesterday. Those 250K records took up nearly 6G of table space. Growth (MB) Owner TypeSegment Name Lob Parent Tabl Lob Column - -- --- - --- - 2,954.77 ARADMINLOBSEGMENT SYS_LOB426378C00018$$ T2057 C84827 2,939.00 ARADMINLOBSEGMENT SYS_LOB426378C00020$$ T2057 C84820 156.77 ARADMINLOBSEGMENT SYS_LOB084949C00022$$ T587 C100827 156.24 ARADMINLOBSEGMENT SYS_LOB085002C00126$$ T590 C100827 154.55 ARADMINLOBSEGMENT SYS_LOB053052C00021$$ T69 C18091 The question I have for the list is: has anyone else seen this out-of-control growth when archiving records? Is this perhaps due to a write process that may be sloppy? Is truncating LOBs the answer? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.govmailto:jennifer.me...@nc.gov http://its.state.nc.ushttp://its.state.nc.us/ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _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: Session Invalid Error
Hi Axton, Once you find a resolution could you please share it with the list. I think with WUT going away we are going to see more and more people with this type of setup. For our new ITSM 7.6 environment we have load balanced VIP but only one MT server behind it at the moment. We are using Apache as a front end to Tomcat as well and will probably end up running into similar issues. Thanks, Jason On Wed, Jul 28, 2010 at 10:47 AM, Axton axton.gr...@gmail.com wrote: ** Patch 5 was pulled. I have not considered patch 6 since the release notes did not indicate any fixes in the area where I have problems. We have Apache in front of Tomcat because we have some Apache modules that we need to use to provide certain services. Our problems don't seem to come into the picture until we have ~400 concurrent users on one mid-tier server. Low volume against the server does not reproduce the issues. On Wed, Jul 28, 2010 at 12:41 PM, Lyle Taylor tayl...@ldschurch.orgwrote: ** Hmm. Odd. I was seeing something similar at one point, but I think I tracked it down in our case to either the F5 or the IBM HTTP server switching someone from one MT server to the other for some unknown reason. It hasn’t happened for a while for us, though, so I’m not sure what changed. I’m pretty sure I’ve never seen sessions expire like that so long as the person stays on the same MT server, though, on 7.1 p5 or 7.5 p3. Just out of curiosity, why do you have apache web servers in front of tomcat if they’re simply forwarding to the local tomcat instance? Are you serving up static content (e.g., documentation) as well? Now you’re making me nervous about upgrading. We’re currently on MT 7.5 p3, and I was considering changing to p6. Have you done any testing with p5 or p6 yet to see if that makes a difference? Thanks, Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Wednesday, July 28, 2010 11:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Session Invalid Error ** I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn’t actually been switched from one mid-tier server to the other – doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Axton *Sent:* Wednesday, July 28, 2010 8:10 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn’t resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged
Re: ARS v7.5 - importing forms changed Table ID
I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.comwrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume -- On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.comwrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J _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
Remedy Consultant In Egypt Needed
List, Position Anyone who wants to get their hands on Remedy 7.6 ITSM Suite Contact Me +20100441441 Or send resumes to ramy.ay...@vodafone.com The details of the individual we are looking for is as follows: Initially responsible for the installation and configuration of Remedy 7.6 ITSM suite. This will be followed by the ongoing support for the Remedy 7.6 ITSM suite to include, monitoring and tuning of the system to achieve optimum performance levels. Undertake day-to-day administration duties. BMC Remedy 7 ITSM experience a must in the following areas of the suite: Service Desk Change Management Service Request Management Atrium Asset Management Atrium CMDB BMC Atrium Discovery and Dependency Mapping (ADDM) Qualifications: * At least 5 years of software engineering, development and implementation experience with one or more IT infrastructure scanning technologies in a heterogeneous environment. Working knowledge of Information Technology Infrastructure Library (ITIL) and database management systems is required SQL and VB is must * Computer Science or Systems Engineering degree (BS, at a minimum) Best Regrades, Ramy Ayoub ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS v7.5 - importing forms changed Table ID
I think the ARS agreement is for you to use the archgid utility. If you want to be little more cautious, do a database backup first From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Susan Palmer [suzanpal...@gmail.com] Sent: Wednesday, July 28, 2010 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.commailto:guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id :) _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: ARS v7.5 - importing forms changed Table ID
Susan, If you unzip the jar file we are told its in there.you could even unzip it on your workstation and get the binary to the server yourself you were so inclined. The archgid utility is designed to update ALL of the places that need it updated, anywhere there is a reference, that's why I would recommend doing it.if you use this approach you wouldn't need to reload any data. All of that aside, why weren't you able to do the upgrade? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 12:31 PM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume _ On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance.but I would trust archgid more than I would trust me doing it manually..and I agree with your assessment, TID should NEVER be used in direct SQL..I ALWAYS recommend using View names instead of table ids..still fragile, but less so that table id J _attend WWRUG10 www.wwrug.com http://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 v7.5 - importing forms changed Table ID
1) Yes. The related B and T tables get also renamed. The tableid can be used in direct SQL, but a good documented system should pinpoint them. We did encounter some fault using archigid when changing fieldids on 7.5 server. Set Field action from other froms did not always get updated, same with menues. -- J 2010/7/28 Susan Palmer suzanpal...@gmail.com: ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J _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 v7.5 - importing forms changed Table ID
Since archgid is a utility, you can pull it from a windows install and put it on your PC and still use it against a Unix server. Yes the utility changes all T, H, B, BxxCyyy, Index names, ...). It updates the ID in all places it is located. As for the SQL it would be UPDATE CONTROL SET SCHEMAID=yyy; COMMIT; I use the SQL method when putting new forms on my servers as I have Dev, Test, and Production servers and all table IDs need to be in sync for compliance with local company processes. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.commailto:guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** That is always a chance...but I would trust archgid more than I would trust me doing it manuallyand I agree with your assessment, TID should NEVER be used in direct SQLI ALWAYS recommend using View names instead of table idsstill fragile, but less so that table id :) _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: ARS v7.5 - importing forms changed Table ID
I've created many new forms obviously and have never had out of sync table IDs. Since I've been working on this particular system for 8 years I must have coincidentally lucked out and always moved them to test and prod in the same order I created them. That seems alot too coincidental for me but it's something I will be aware of going forward. That's about 300 lucky times ... more lives than a cat gets! I'm going to try and put it on my PC, that's the most convenient. Susan On Wed, Jul 28, 2010 at 2:19 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Since archgid is a utility, you can pull it from a windows install and put it on your PC and still use it against a Unix server. Yes the utility changes all T, H, B, BxxCyyy, Index names, …). It updates the ID in all places it is located. As for the SQL it would be UPDATE CONTROL SET SCHEMAID=yyy; COMMIT; I use the SQL method when putting new forms on my servers as I have Dev, Test, and Production servers and all table IDs need to be in sync for compliance with local company processes. Fred *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Susan Palmer *Sent:* Wednesday, July 28, 2010 1:31 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume -- On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J _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 v7.5 - importing forms changed Table ID
LJ, you'd probably find a bunch of posts out there starting in February about our trial and tribulations. The best explanation anyone has come up with, 'It's just your system.' I believe part of the issue was originally we were ARS 4.5, then 5.0, then 5.1.2 then 7.0.1. Throw in old HD 5.0 in there and I think there were just too many lingering gremlins. A switch from windows to unix might have added something to the mix. But I'm done with trying to figure it out. Support finally had 'senior' engineers review everything we did and they could not think of anything else to try. Sometimes you just have to cut your loses and move on. Use the energy for positive results. lol, I hope it sound like I've convinced myself! On Wed, Jul 28, 2010 at 1:52 PM, LJ LongWing lj.longw...@gmail.com wrote: ** Susan, If you unzip the jar file we are told its in there…you could even unzip it on your workstation and get the binary to the server yourself you were so inclined. The archgid utility is designed to update ALL of the places that need it updated, anywhere there is a reference, that’s why I would recommend doing it…if you use this approach you wouldn’t need to reload any data. All of that aside, why weren’t you able to do the upgrade? *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Susan Palmer *Sent:* Wednesday, July 28, 2010 12:31 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume -- On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J _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_
Re: ARS v7.5 - importing forms changed Table ID
I don't personally worry about out of sync ID's..things are developed on Dev..moved to Test when ready.moved to Prod on schedule...then Dev/Test are refreshed from Prod after prod is confirmed.so the tables end up getting synced back up either way J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** I've created many new forms obviously and have never had out of sync table IDs. Since I've been working on this particular system for 8 years I must have coincidentally lucked out and always moved them to test and prod in the same order I created them. That seems alot too coincidental for me but it's something I will be aware of going forward. That's about 300 lucky times ... more lives than a cat gets! I'm going to try and put it on my PC, that's the most convenient. Susan On Wed, Jul 28, 2010 at 2:19 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Since archgid is a utility, you can pull it from a windows install and put it on your PC and still use it against a Unix server. Yes the utility changes all T, H, B, BxxCyyy, Index names, .). It updates the ID in all places it is located. As for the SQL it would be UPDATE CONTROL SET SCHEMAID=yyy; COMMIT; I use the SQL method when putting new forms on my servers as I have Dev, Test, and Production servers and all table IDs need to be in sync for compliance with local company processes. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume _ On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.com wrote: ** That is always a chance.but I would trust archgid more than I would trust me doing it manually..and I agree with your assessment, TID should NEVER be used in direct SQL..I ALWAYS recommend using View names instead of table ids..still fragile, but less so that table id J _attend
Re: ARS v7.5 - importing forms changed Table ID
I am assuming that you will have the same issue in future migrations/upgrade and I would rather spend time analyzing/ tweaking/ optimizing workflow by removing hardcoded values, use Views in Direct SQL etc.. which may result in better system performance. Just an opinion. Thanks Mahesh On Wed, Jul 28, 2010 at 1:30 PM, Susan Palmer suzanpal...@gmail.com wrote: ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that referes to table T500. This way, you don't need to change anything on the Remedy structures. Guillaume -- On Wed, Jul 28, 2010 at 11:15 AM, LJ LongWing lj.longw...@gmail.comwrote: ** That is always a chance…but I would trust archgid more than I would trust me doing it manually….and I agree with your assessment, TID should NEVER be used in direct SQL….I ALWAYS recommend using View names instead of table ids….still fragile, but less so that table id J _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: Session Invalid Error
I've seen this behavior in 7.1 without a load balancer in the way. Timeouts happen in 15 minutes instead of 60 and I've never figured out why. Running Tomcat 5.5 and MT 7.1 patch 006. Sincerely, Robert Fults Remedy Admin/Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.eduhttp://uts.fiu.edu/ From: Lyle Taylor [mailto:tayl...@ldschurch.org] Sent: Wednesday, July 28, 2010 1:41 PM Subject: Re: Session Invalid Error ** Hmm. Odd. I was seeing something similar at one point, but I think I tracked it down in our case to either the F5 or the IBM HTTP server switching someone from one MT server to the other for some unknown reason. It hasn't happened for a while for us, though, so I'm not sure what changed. I'm pretty sure I've never seen sessions expire like that so long as the person stays on the same MT server, though, on 7.1 p5 or 7.5 p3. Just out of curiosity, why do you have apache web servers in front of tomcat if they're simply forwarding to the local tomcat instance? Are you serving up static content (e.g., documentation) as well? Now you're making me nervous about upgrading. We're currently on MT 7.5 p3, and I was considering changing to p6. Have you done any testing with p5 or p6 yet to see if that makes a difference? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, July 28, 2010 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** I've verified this is not the case by looking through the Apache access logs. The sessions are staying with the same Apache HTTP server. The Apache HTTP servers talk to Apache Tomcat on localhost, so the HTTP servers aren't redirecting to different Tomcats. On Wed, Jul 28, 2010 at 12:15 PM, Lyle Taylor tayl...@ldschurch.orgmailto:tayl...@ldschurch.org wrote: ** I would try to double-check that when this happens, the person hasn't actually been switched from one mid-tier server to the other - doing that could cause what you are seeing. You could verify this by logging into the configuration page and looking at the cache information just after someone gets an invalid session message and has to log in again. There are entries on the cache settings page for everyone that has recently logged into the mid-tier on that server. If you find an entry for that person on both servers, then I would suspect that something is causing the F5 to switch from one server to the other, despite the sticky bit setting. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, July 28, 2010 8:10 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Session Invalid Error ** We are facing the same issue with mid-tier 7.5 patch 4 on Tomcat 6.0.20. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jul 28, 2010 at 2:50 AM, Aluru, Radhika radhika.al...@invesco.commailto:radhika.al...@invesco.com wrote: ** Hi Listers, In my Test environment, Session timeout is set to 60 minutes in Remedy midtier servers. I have F5 load balancer in front of two midtier servers and sticky bit is set to 120 minutes on the F5 load balancer. Application timeout is set to 1 hour. When users are accessing the application via web, users are getting session invalid or timed out error before 60 minutes sometimes before 20 minutes . This is not happening every time. It is intermittent. Has anyone faced this type of issue and found any solution to resolve this? I have tried setting the session time out in web.xml(located in D:\ARSystem\Mid-Tier\WEB-INF) file of the midtier servers. But this didn't resolve the issue. Any help would be appreciated. Thanks. Environment Details: AR Server --7.1 patch 3 Miditer --7.1 patch 6 OS --Windows standard 2000 Database -- SQL 2005 Regards, Radhika Aluru | Remedy Admin | Direct Line: +1 713 214 8270 | Mobile: 00919177708021 Confidentiality Note: The information contained in this message, and any attachments, may contain confidential and/or privileged material. It is intended solely for the person(s) or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the
Re: Crystal Report error
I have found that most reporting/crystal errors on Mid-Tier are due to configuration errors. There are several areas you need to check: - Mid-Tier Admin webpage, Report Settings: These values must be set correctly for your environment. (** Flush the cache between changes. **) - AR Server Information, Advanced, Default Web Path: Format should be http://[webserver]/arsys; - Check your User form for the correct user account and permissions for the ODBC connection HTH, Michael W. Luttmann Lead Remedy Developer Fort Carson NEC If you don't like change, you're going to dislike irrelevance even more. Gen Shinseki -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Atul Vohra Sent: Friday, July 23, 2010 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report error Sorry forgot to mention - this is being accessed using mid-tier -Original Message- From: Lammey, Peter A. [peter.a.lam...@espn.com] Date: 07/23/2010 02:19 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report error Does your Remedy User client have ODBC use underscores checked? This can be found in the menu Tools - Options and in the Advanced tab. Also verify that your Remedy application server name is listed in Report Server field (and includes TCP if necessary in the TCP field next to that field). Thanks Peter Lammey ESPN IT Packaging and Automation 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Atul Vohra Sent: Friday, July 23, 2010 2:01 PM To: arslist@ARSLIST.ORG Subject: Crystal Report error We are using Business Objects 11.5 with ARS 7.5 When I try to run pre-canned reports in Incident Manager, I get the following eror The table 'HPD_Help_Desk' could not be found. Error in File C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 {E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found. Have to confess am not a experienced crystal report person so need some help. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are Please consider the environment before printing this e-mail. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
PreviousStatus field in HPD:Help Desk form
Hello Just wondering if anybody else had used the Previous Status field in Incident to pull data? I have been asked to pull a report showing all Incidents that were set to status Closed without being set to status Resolved first. I thought that querying for All tickets in current status: Closed and PreviousStatus not equal to: 4 (resolved), would do the trick. It hasn't worked. Any suggestions? (Using ITSM 7.5) Thank you Vianna ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: PreviousStatus field in HPD:Help Desk form
I would use the Status History for that. You can pull the date that it was set to the different statuses and do a comparison between the dates of the two statuses. Thanks, Shawn Pierson Remedy Developer | Southern Union From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Vianna Vianna Sent: Wednesday, July 28, 2010 3:36 PM To: arslist@ARSLIST.ORG Subject: PreviousStatus field in HPD:Help Desk form ** Hello Just wondering if anybody else had used the Previous Status field in Incident to pull data? I have been asked to pull a report showing all Incidents that were set to status Closed without being set to status Resolved first. I thought that querying for All tickets in current status: Closed and PreviousStatus not equal to: 4 (resolved), would do the trick. It hasn't worked. Any suggestions? (Using ITSM 7.5) Thank you Vianna _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: PreviousStatus field in HPD:Help Desk form
Do a search for all Closed incidents Select them all Option 1: Go to reporting (or click the reports button) New Style Select Status*: Status*-History Option 2: Go to reporting (or click the reports button) New Style Select Status*: Under Status*-History only select the statuses that you wish (i.e. Resolved.USER; Resolved.TIME; Closed.USER; Closed.TIME) I'm on ITSM 7.0.03 - may vary a little from 7.5/7.6 HTH, Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Vianna Vianna Sent: Wednesday, July 28, 2010 3:36 PM To: arslist@ARSLIST.ORG Subject: PreviousStatus field in HPD:Help Desk form ** Hello Just wondering if anybody else had used the Previous Status field in Incident to pull data? I have been asked to pull a report showing all Incidents that were set to status Closed without being set to status Resolved first. I thought that querying for All tickets in current status: Closed and PreviousStatus not equal to: 4 (resolved), would do the trick. It hasn't worked. Any suggestions? (Using ITSM 7.5) Thank you Vianna _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 v7.5 - importing forms changed Table ID
You can do this in SQL if you're brave.It is doable and not that bad. Always backup first!Make sure ARS is down. Also, if you have SQL procedures, why couldn't those procedures look up the IDs from the table names? (inner select). Or better still, use the views that Remedy automatically created since at least version 6? Yes, the horses have left and it's a little late to close the barn doors. However, I would argue strongly for a change to those responsible for the SQL procs to use the views now. It's more readable and more maintainable in any event. If you are importing, import just the table. Eliminate the views from the .def. Else there will be a bunch of views etc to be changed. Check out the database reference guide for some of the details. There are many tables with the field SchemaId. Mostly they describe fields. Then change the IDs manually (ugly, dangerous) in all the appropriate tables - several field definition tables based on field types!Check the results with the admin tool / dev studio or other ways of dumping table fields if you have them. Then reimport the table with the views. The ID will not have changed. Now import the workflow. If you have a bunch of tables I would script the process. That's how I would approach it. I wouldn't use archgid unless I wrote it or had it fully tested. Others have had some problems with it, it would seem. I have no experience with it. I do these types of (thankfully rare) things manually. Remember to back up before doing direct SQL on the ARS hidden data definition tables. Remember also that ARS should be down. Good luck. Cheers Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng Sent: July-28-10 20:58 To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID 1) Yes. The related B and T tables get also renamed. The tableid can be used in direct SQL, but a good documented system should pinpoint them. We did encounter some fault using archigid when changing fieldids on 7.5 server. Set Field action from other froms did not always get updated, same with menues. -- J 2010/7/28 Susan Palmer suzanpal...@gmail.com: ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault guilla...@dcshq.com wrote: ** LJ, I don't disagree...I am just saying that using that function of archig may still pose a risk, since it is probably not used often, even though it seems a small risk. But if I ever had to change the table ID, I would use the archig utility, I would not do the manual updates at all. Susan: Yet another option is to create a database view with the schemaid you would like,provided of course there is no tabeld with that ID. So for instance let's sat you have table T500 and you would like T300, check whether there is a table T300, and if not, create a daatbase view caleld T300 that
Re: ARS v7.5 - importing forms changed Table ID
I saw a few references to using the ARS maintained view. One thing to be aware of is you give specific permissions to an ARS maintained view, those permissions will be lost when the view is dropped and recreated by ARS (when fields are added/removed). It easy enough to have a script to put the permissions back as long as you expect the permissions removal. On a few forms that change often I have created a view of the ARS view and grant the db permissions there. Jason On Wed, Jul 28, 2010 at 1:52 PM, Ben Chernys ben.cher...@softwaretoolhouse.com wrote: You can do this in SQL if you're brave.It is doable and not that bad. Always backup first!Make sure ARS is down. Also, if you have SQL procedures, why couldn't those procedures look up the IDs from the table names? (inner select). Or better still, use the views that Remedy automatically created since at least version 6? Yes, the horses have left and it's a little late to close the barn doors. However, I would argue strongly for a change to those responsible for the SQL procs to use the views now. It's more readable and more maintainable in any event. If you are importing, import just the table. Eliminate the views from the .def. Else there will be a bunch of views etc to be changed. Check out the database reference guide for some of the details. There are many tables with the field SchemaId. Mostly they describe fields. Then change the IDs manually (ugly, dangerous) in all the appropriate tables - several field definition tables based on field types!Check the results with the admin tool / dev studio or other ways of dumping table fields if you have them. Then reimport the table with the views. The ID will not have changed. Now import the workflow. If you have a bunch of tables I would script the process. That's how I would approach it. I wouldn't use archgid unless I wrote it or had it fully tested. Others have had some problems with it, it would seem. I have no experience with it. I do these types of (thankfully rare) things manually. Remember to back up before doing direct SQL on the ARS hidden data definition tables. Remember also that ARS should be down. Good luck. Cheers Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng Sent: July-28-10 20:58 To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID 1) Yes. The related B and T tables get also renamed. The tableid can be used in direct SQL, but a good documented system should pinpoint them. We did encounter some fault using archigid when changing fieldids on 7.5 server. Set Field action from other froms did not always get updated, same with menues. -- J 2010/7/28 Susan Palmer suzanpal...@gmail.com: ** I had 400+ forms to import and what it did was give them sequential numbers. Usually I've just copied the database over but with the old vs new version that was not going to work. I can't say I gave the table ID much thought ahead of time but will certainly remember going forward. So all the table IDs I want to use are already used. But the good news is there are really only about 10 tables I have to manipulate. I did a quick survey of the other application owners and there's a mixed bag with several using Table IDs. My choices appear to be: 1. Use archgid to change the wrong table to a new number and then change the right table to the number it should be. But I cannot find archgid on the server, where to get it in the KB. There was a post about using the windows_zg_ia_sf.jar file which I have but I have to get the server guys to put it on the unix server. And then I guess magically I'll find archgid there. Does archgid change all the related table IDs, T, H, B etc? 2. I think it was Fred's idea to basically delete the wrong forms in question. Reset set the Table ID and then import them individually after each required Table ID reset. I assume that I reset the Table ID in the database. Rather than play around maybe someone could provide the correct sql statement. I'd have to reimport the workflow objects etc also and the 11hrs worth of data which of course is on one of the forms will need to be recopied over. But I figure I only have in the neighborhood of 200 hrs of data to move so that's not the worst of it. #1 sounds good and I have some garbage forms to test it on. Any other last thoughts? Is the table ID buried in anything else? I have only seen the schema name in workflow and checked but didn't see anything obvious that might be a cross reference. I really do appreciate the input. These are the kinds of things you want to talk over. Ok, so I do talk to myself but sometimes I'm not as creative as you ! Thanks, Susan On Wed, Jul 28, 2010 at 12:10 PM, Guillaume Rheault
problems displaying Search Bar on the web...
ARS 7.5 p5 (201005111542) MS SQL 2005 I'm having problems enabling the Advanced Search Bar in a form in a browser. Using the Dev Studio, I have the 'Add Form Action Fields' configured for 'Modify All' (unchecked) and 'Search Bar' (checked, but disabled/greyed out). Additionally, I have the user's record in the User Preference form also configured for 'On Open', 'Show Advanced Search Bar' set to Yes. I haven't found a setting here for 'Modify All'. Finally, I have set the view configs for the form, 'Accessible Menu Items' to be unchecked for 'Modify All' and checked for 'Advanced Search'. The MidTier config tool correctly shows the name of the preference server. Any ideas on how to disable 'Modify All' and enable 'Advanced Search'? Thanks, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Archiving Issue
Hi Amanullah, My company recently published a whitepaper on Archiving within AR System and ITSM 7+ You can access that whitepaper (and others) at http://www.planwell.net, and select Download White Papers from the navigation bar. Regards, Gareth From: Action Request System discussion list(ARSList) on behalf of IT (Amanullah Bashir Ahmed) Sent: Wed 28/07/10 16:56 To: ARSList Subject: Archiving Issue ** Hi there, Version 7.1 Can anybody tell me what are the effects while Archiving the incidents. If I will archive those incidents which are related to Changes or Problems or Configuration Items, what would be the impact? Attachments in Work info would archive separately. I studied the BMC Document Form and App Objects, but I have not get good idea for archiving. Is there any other BMC Document for Archiving, please let me know. 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