Archiving Issue

2010-07-28 Thread IT (Amanullah Bashir Ahmed)
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

Re: Auto-populating WO Fields without info entered

2010-07-28 Thread Mahesh
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,

Session Invalid Error

2010-07-28 Thread Aluru, Radhika
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

Re: Error using rrrchive

2010-07-28 Thread Rafael Bertolini
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

How to configure LB with mid-tier?

2010-07-28 Thread Martin Liu
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:

How to configure LB with mid-tier?

2010-07-28 Thread John Baker
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

Re: Error using rrrchive

2010-07-28 Thread Misi Mladoniczky
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

Re: Moving/copying data from one server to another...

2010-07-28 Thread Arner, Todd
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

Re: Auto-populating WO Fields without info entered

2010-07-28 Thread Richard Matovu
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

Re: Reporting : How do I get a list of Incidents that I have worked on last week

2010-07-28 Thread Boyd, Rebecca E.
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)

Re: Change Management question

2010-07-28 Thread Guillaume Rheault
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

Re: Mid-Tier 7.5 Problems

2010-07-28 Thread Axton
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

Re: Session Invalid Error

2010-07-28 Thread Axton
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

Re: How to configure LB with mid-tier?

2010-07-28 Thread LJ LongWing
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

Re: Reporting : How do I get a list of Incidents that I have worked on last week

2010-07-28 Thread Thad Esser
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

Mid-Tier 7.5 Problems

2010-07-28 Thread John Baker
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

2010-07-28 Thread Susan Palmer
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Guillaume Rheault
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread LJ LongWing
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Guillaume Rheault
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

Re: Moving/copying data from one server to another...

2010-07-28 Thread Joe DeSouza
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Susan Palmer
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Grooms, Frederick W
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread LJ LongWing
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

Re: Mid-Tier 7.5 Problems

2010-07-28 Thread Axton
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Mahesh
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,

RRR|Chive SAN Disk Space issues

2010-07-28 Thread Meyer, Jennifer L
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Guillaume Rheault
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.

Re: Session Invalid Error

2010-07-28 Thread Lyle Taylor
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

Re: RRR|Chive SAN Disk Space issues

2010-07-28 Thread Garrison, Sean (Norcross)
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

Re: Session Invalid Error

2010-07-28 Thread Axton
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,

Re: RRR|Chive SAN Disk Space issues

2010-07-28 Thread strauss
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

Re: Mid-Tier 7.5 Problems

2010-07-28 Thread Jarl Grøneng
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

Re: Session Invalid Error

2010-07-28 Thread Lyle Taylor
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.

Re: Mid-Tier 7.5 Problems

2010-07-28 Thread Axton
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

Re: Session Invalid Error

2010-07-28 Thread Axton
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

Re: Session Invalid Error

2010-07-28 Thread Lyle Taylor
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:

Re: RRR|Chive SAN Disk Space issues

2010-07-28 Thread Meyer, Jennifer L
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:

Re: Session Invalid Error

2010-07-28 Thread Jason Miller
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Susan Palmer
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

Remedy Consultant In Egypt Needed

2010-07-28 Thread Ramy S. Ayoub
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.

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Guillaume Rheault
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]

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread LJ LongWing
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Jarl Grøneng
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Grooms, Frederick W
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Susan Palmer
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Susan Palmer
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread LJ LongWing
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Mahesh
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,

Re: Session Invalid Error

2010-07-28 Thread Robert Fults
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:

Re: Crystal Report error

2010-07-28 Thread Luttmann, Michael W CTR USA NETCOM/9TH SC A 7TH SC
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

PreviousStatus field in HPD:Help Desk form

2010-07-28 Thread Vianna Vianna
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:

Re: PreviousStatus field in HPD:Help Desk form

2010-07-28 Thread Pierson, Shawn
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)

Re: PreviousStatus field in HPD:Help Desk form

2010-07-28 Thread Martinez, Marcelo A
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Ben Chernys
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

Re: ARS v7.5 - importing forms changed Table ID

2010-07-28 Thread Jason Miller
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

problems displaying Search Bar on the web...

2010-07-28 Thread Rick Phillips
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

Re: Archiving Issue

2010-07-28 Thread Gareth Oliver
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: