Multi-server configuration question
Hi Folks, I am trying to add a second server to my ARS system. I am not configuring these two servers into a server group. I want to control which traffic goes to which server. My ultimate configuration will be: Server1: Windows clients, Admin, email, utility scripts, some Mid-tier traffic Server2: The rest of my Mid-tier traffic Both servers are running 7.6.04 SP3 201201302357 on Solaris. I was able to bring Server2 up with no conflicts or complains from Server1. And I was able to get one of my Tomcat servers to connect to Server2 successfully. The first problem that we encountered has to do with saved searches. When a user connects to the Tomcat server that connects to Server2, none of their saved searches appear. We took a look at the entries in the "AR System Searches Preference" form and saw that there is a field (Server) containing the server short-name. If we change the Server field value for a single entry so that it contains the short name of Server2, then that saved search appears in Server2-Tomcat-Mid-tier but disappears from Server1-Tomcat-Mid-tier. I am hoping that there is a way to configure things so that regardless of which ARS server the user gets connected to (Server1 or Server2), they will still get their saved searches. I have messed around with various combinations of: IP-Name: Server-Name: Server-Connect-Name: but I have not hit upon the correct combination. Does anyone know if this is possible and if so, how to achieve this? Thanks. Larry ARS: 7.6.04 SP3 201201302357 on Solaris 10 on Oracle Mid-Tier Version: 8.1.00_201402031033_Hotfix on... Tomcat: 7.0.47 with ... Java: 1.7.0_05-b06 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Target Attack and BMC Software ITSM? (Disable user sub-discussion)
Hi Doug, Thanks for this post... I have been looking for this "secret" for some time. As I was implementing my solution, I ran across this Process: Application-Invalidate-User Is there any reason to use the explicit direct SQL instead of calling the above Process? Perhaps this process was a recent addition? I am running ARS 7.6.04 and it appears to do exactly the same thing as the suggested SQL, at least as far as I can tell from my logs. Thanks. Larry On Fri, Jan 31, 2014 at 3:59 PM, Mueller, Doug wrote: > ** > > Everyone, > > > > As an adjunct to this conversation, there has come up again a topic that > is asked about periodically - > > > > What does the Disable mean on the User form for a user. > > > > Well, out of the box, it doesn't mean anything. We always are considering > what it should mean, but a bit > > part of the discussion is what does it mean in conjunction with AREA and > external authentication. If a user > > is disabled, should they fail in an AREA authentication? Or do they > succeed. If they succeed, do we still add > > on permissions from the user record (cross-reference-blank-password) or do > we authenticate them but > > not authorize them (confusing). Or, do we just let them succeed and > attach permissions or whatever that > > is cross-referenced but if you chain AREA and ARS, we would be OK with > AREA but not if that didn't pass > > and we moved to (chained to) ARS for authentication. > > > > Anyway, for those who want to make the disable operation be meaningful, > there is a simple workflow > > technique you can use. To offer a complete solution, we are talking about > 3 or 4 filters. > > > > This would be for handling ARS validation - essentially using the 3rdoption > above for AREA, if the user > > validates with AREA, it is OK and any information on the AR System user > record that is cross referenced is > > used - but we would not pass any authentication that is chained to ARS. > > > > > > OK, the filters: > > > > Disable an existing user > > > > Filter that fires on Modify with a run if of TR.Status = "Disabled". > > Action is to perform a Direct SQL command to update the password in the > user_cache table to INVALID > > > > Update user_cache SET (password = 'INVALID') WHERE entryId = '$1$' > > > > entry ID is the key we link by although you could also user username = > '$101$' as well to set for matching > > user name. Either would work. > > > > Yes, the word INVALID. This is the same value we put in the password > field of the user_cache record when > > a user is blocked for too many bad password attempts. This user can > NEVER login unless his password is > > reset by someone else as they cannot login to change it. > > > > (depending on your DB as some DBs want parenthesis around the set clause > and others do not if there is > > only one item in the clause) > > > > > > Prevent work on a disabled user > > > > Filter that if Status = "Disabled" and Password != $NULL$ will return an > error that you cannot change the > > password of a disabled user. > > > > Or you could block all change to a disabled user or do whatever you want > here to prevent a password change > > for a disabled user which would then reset the password and reactivate > them. > > > > > > Reactivate a disabled user > > > > Filter that if TR.Status = "Enabled" and DB.Status = "Disabled" will run > check that there is a password > > specified (must change password on enable) and that if you are using the > user password feature you set the > > option to require the user to change password on first login for this user > so that they have to change after > > login as their password is known by someone else. > > > > > > Create a disabled user > > > > Now if you want to create a disabled user, there is a bit more effort. > The problem is that the user_cache > > entry doesn't exist for you to modify as the User record is being created. > > > > You could just disallow Status = Disabled on Create/Merge. Argument is > why are you creating disabled users? > > > > Of if you want to, you need to do something to disable the user right > after create (phase 3 run process that > > comes back and updates the user_cache entry after it is there or > something similar). > > > > > > Whether we add this or not is under discussion, but it is clearly > something you can do on your own system > > if desired. I just wanted to get a solution out there for folks who > wanted to do something in this area. > > > > I hope this is useful, > > > > Doug Mueller > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Establish executable version
strings arserverd | grep ProdVers :-) Hope this is helpful. Larry On Wed, Jan 29, 2014 at 4:10 PM, Simon Ellis wrote: > I thought there was a way of checking without having the AR up > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Thursday, 30 January 2014 9:52 a.m. > To: arslist@ARSLIST.ORG > Subject: Re: Establish executable version > > It will be listed in the armonitor.log (in your db directory) > > It is also listed in the Admin Console on the Platform tab of Server > Information > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Simon Ellis > Sent: Wednesday, January 29, 2014 2:21 PM > To: arslist@ARSLIST.ORG > Subject: Establish executable version > > Under Unix/linux, is there a way i can find the version of the arserverd > executable? Just wondering if there is some command line i can run to > establish what version it is? > > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Close Window operation not working on IE 10
I received word this morning from the user who was having trouble with IE 10 and Mid-tier that IE 11 appears to work better. I still plan to install *MT_8100_2013SEP27_CU_ALL* Hotfix as mentioned by Ravi Rai. Hope this is helpful. Larry On Tue, Nov 12, 2013 at 8:15 AM, L G Robinson wrote: > Thanks everyone! Very helpful. > Larry > > > On Tue, Nov 12, 2013 at 7:57 AM, ravi rai wrote: > >> ** >> *MT_8100_2013SEP27_CU_ALL* Hotfix has the fix for close button and other >> issues related to IE10 >> >> SW00453386 Close button is not working with IE10. >> >> >> Thanks >> Ravi Rai >> >> >> -- >> Date: Mon, 11 Nov 2013 16:35:09 -0600 >> From: suzanpal...@gmail.com >> Subject: Re: Close Window operation not working on IE 10 >> To: arslist@ARSLIST.ORG >> >> >> ** >> I've found Firefox has been my go to choice, whereas before mid-tier I >> was always an IE user. Very few issues using Firefox that I've found. >> >> Susan >> >> >> On Mon, Nov 11, 2013 at 4:07 PM, Jason Miller wrote: >> >> ** >> That is where I am leading... I hadn't started researching it yet. But >> I just checked two different systems both are MT 8.1.00 201301251157. One >> system the Close Window works and the other doesn't The one where CW works >> is using compatibility mode for the site. I can't seem to figure out how >> to turn compatibility mode for the other site. The icon doesn't show in >> the address bar and even turning on compatibility mode for all web sites >> does seem to work for this site so I can prove this actually fixes the >> issue. >> >> Jason >> >> >> On Mon, Nov 11, 2013 at 1:59 PM, Susan Palmer wrote: >> >> ** >> Compatibility mode in IE10 took care of a couple of odd things for us. >> >> Susan >> >> >> On Mon, Nov 11, 2013 at 3:45 PM, L G Robinson wrote: >> >> ** >> Thanks Jason. Do you know of a fix? >> Larry >> >> >> >> On Mon, Nov 11, 2013 at 4:41 PM, Jason Miller wrote: >> >> ** >> Yes, I have notices this as well. >> >> >> On Mon, Nov 11, 2013 at 1:33 PM, L G Robinson wrote: >> >> ** >> Hi Folks, >> >> Has anyone noticed that the "Close Window (Current Window)" Active Link >> operation doesn't work in IE 10.0.9200? Works fine in FF/Chrome/Safari/WUT. >> Cookies are enabled. >> >> Thanks. >> Larry >> >> >> ARS: 7.6.04 SP3 201201302357 on Solaris 10 on Oracle >> MT: 8.1.Patch 002 201308272305 Hotfix on Tomcat 6.0.35 on RHL >> >> >> Larry Robinson >> Remedy Developer / Administrator >> NC State University >> Raleigh, NC >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Close Window operation not working on IE 10
Thanks everyone! Very helpful. Larry On Tue, Nov 12, 2013 at 7:57 AM, ravi rai wrote: > ** > *MT_8100_2013SEP27_CU_ALL* Hotfix has the fix for close button and other > issues related to IE10 > > SW00453386 Close button is not working with IE10. > > > Thanks > Ravi Rai > > > -- > Date: Mon, 11 Nov 2013 16:35:09 -0600 > From: suzanpal...@gmail.com > Subject: Re: Close Window operation not working on IE 10 > To: arslist@ARSLIST.ORG > > > ** > I've found Firefox has been my go to choice, whereas before mid-tier I was > always an IE user. Very few issues using Firefox that I've found. > > Susan > > > On Mon, Nov 11, 2013 at 4:07 PM, Jason Miller wrote: > > ** > That is where I am leading... I hadn't started researching it yet. But I > just checked two different systems both are MT 8.1.00 201301251157. One > system the Close Window works and the other doesn't The one where CW works > is using compatibility mode for the site. I can't seem to figure out how > to turn compatibility mode for the other site. The icon doesn't show in > the address bar and even turning on compatibility mode for all web sites > does seem to work for this site so I can prove this actually fixes the > issue. > > Jason > > > On Mon, Nov 11, 2013 at 1:59 PM, Susan Palmer wrote: > > ** > Compatibility mode in IE10 took care of a couple of odd things for us. > > Susan > > > On Mon, Nov 11, 2013 at 3:45 PM, L G Robinson wrote: > > ** > Thanks Jason. Do you know of a fix? > Larry > > > > On Mon, Nov 11, 2013 at 4:41 PM, Jason Miller wrote: > > ** > Yes, I have notices this as well. > > > On Mon, Nov 11, 2013 at 1:33 PM, L G Robinson wrote: > > ** > Hi Folks, > > Has anyone noticed that the "Close Window (Current Window)" Active Link > operation doesn't work in IE 10.0.9200? Works fine in FF/Chrome/Safari/WUT. > Cookies are enabled. > > Thanks. > Larry > > > ARS: 7.6.04 SP3 201201302357 on Solaris 10 on Oracle > MT: 8.1.Patch 002 201308272305 Hotfix on Tomcat 6.0.35 on RHL > > > Larry Robinson > Remedy Developer / Administrator > NC State University > Raleigh, NC > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Close Window operation not working on IE 10
Thanks Jason. Do you know of a fix? Larry On Mon, Nov 11, 2013 at 4:41 PM, Jason Miller wrote: > ** > Yes, I have notices this as well. > > > On Mon, Nov 11, 2013 at 1:33 PM, L G Robinson wrote: > >> ** >> Hi Folks, >> >> Has anyone noticed that the "Close Window (Current Window)" Active Link >> operation doesn't work in IE 10.0.9200? Works fine in FF/Chrome/Safari/WUT. >> Cookies are enabled. >> >> Thanks. >> Larry >> >> >> ARS: 7.6.04 SP3 201201302357 on Solaris 10 on Oracle >> MT: 8.1.Patch 002 201308272305 Hotfix on Tomcat 6.0.35 on RHL >> >> >> Larry Robinson >> Remedy Developer / Administrator >> NC State University >> Raleigh, NC >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Close Window operation not working on IE 10
Hi Folks, Has anyone noticed that the "Close Window (Current Window)" Active Link operation doesn't work in IE 10.0.9200? Works fine in FF/Chrome/Safari/WUT. Cookies are enabled. Thanks. Larry ARS: 7.6.04 SP3 201201302357 on Solaris 10 on Oracle MT: 8.1.Patch 002 201308272305 Hotfix on Tomcat 6.0.35 on RHL Larry Robinson Remedy Developer / Administrator NC State University Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: How to get Mid Tier Server Name
Hi Folks, One of our JSP programmers came up with the following for me. We put it in the tomcat_home/webapps/ROOT directory and ask our customers to run it if they are experiencing problems. That way, we can know which of our MT Tomcat servers they are connected to. I don't claim to understand how it works, but it does. Hope this is helpful. Larry <%@ page import="java.util.*,java.io.*" %> <% String cmd = "hostname"; String outstr = ""; try { Runtime rt = Runtime.getRuntime(); Process p = rt.exec(cmd); try { InputStreamReader ise = new InputStreamReader(p.getErrorStream()); BufferedReader bre = new BufferedReader(ise); InputStreamReader iso = new InputStreamReader(p.getInputStream()); BufferedReader bro = new BufferedReader(iso); String line=null; while ( (line = bre.readLine()) != null ) { outstr += line; } while ( (line = bro.readLine()) != null ) { outstr += line; } } catch (IOException ioe) { ioe.printStackTrace(); } int exitVal = p.waitFor(); } catch (Throwable t) { t.printStackTrace(); } %> Hostname: <%=outstr%> Your IP: <%=request.getRemoteAddr()%> Service IP: <%=request.getLocalAddr()%> On Mon, Nov 4, 2013 at 11:26 AM, Patrick Snyder wrote: > We are running six Mid Tier servers and I would like to display the name > of the current server that the user is pointed at on the login page. Is > there a JSP call that I can make or a cookie value that exists to return > the server name? I understand that request.getServerName() will return a > "server name" but that call represents the host domain name which is not > what I need. I need to know the mid tier name or server name or server > number so we can tell which one of our six servers the user is on at a > glance. Thank you. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Detecting browser type in workflow
Hi Jason, Thanks for submitting the idea... I voted for it! Larry On Thu, Sep 26, 2013 at 11:54 AM, Jason Miller wrote: > ** > Nice work! And thanks for sharing the solution. > > An idea to update $BROWSER$ has been submitted: > https://communities.bmc.com/ideas/3390 > > Jason > > > On Thu, Sep 26, 2013 at 8:23 AM, L G Robinson wrote: > >> ** >> Hi Jason, >> >> Was able to figure this out myself (with the help of Google). I added a >> SetField action to an ActiveLink with a Value of: >> >> $PROCESS$ JAVASCRIPT window.navigator.userAgent; >> >> and I got: >> >> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 >> (KHTML, like Gecko) Chrome/29.0.1547.65 Safari/537.36 >> >> returned into the field. So now, all I have to do is parse the result. >> :-) >> >> Thanks for pointing me in the right direction. >> Larry >> >> >> >> On Wed, Sep 25, 2013 at 10:26 PM, L G Robinson wrote: >> >>> Hi Jason, >>> >>> JavaScript was where I was heading with my first post. Can you help me >>> get started with that? Do you have any examples? Where does the JavaScript >>> go and how do you get the results back into workflow where you can do stuff >>> with it? >>> >>> Thanks. >>> Larry >>> >>> >>> On Wed, Sep 25, 2013 at 5:03 PM, Jason Miller wrote: >>> >>>> ** >>>> That seems to match what I am seeing. You might be better off running >>>> some JavaScript to capture the browser. >>>> >>>> The top three entries are non-IE >>>> 1:52:58 - Android / Chrome >>>> 1:53:29 - Win 7 / Chrome >>>> 1:57:16 - iOS 6 / Safari >>>> >>>> Firefox shows as Netscape7 but it is not (knowing) pictured below. >>>> >>>> [image: Inline image 2] >>>> >>>> >>>> On Wed, Sep 25, 2013 at 1:31 PM, L G Robinson wrote: >>>> >>>>> ** >>>>> Hi Doug, >>>>> >>>>> Thanks for the reply. That certainly sounds like exactly what I was >>>>> looking for. I had forgotten about that keyword. >>>>> >>>>> I tried to view the article that you referenced but I got "Article Not >>>>> Found". Must be REEEALY old. ;-) >>>>> >>>>> The documentation for $BROWSER$ says this: >>>>> >>>>> The browser (Internet Explorer or other) being used in the current >>>>> session. If the browser is anything other than Internet Explorer, Netscape >>>>> is returned. >>>>> For BMC Remedy User, an empty string ("") is returned. This keyword is >>>>> NULL on the server. >>>>> >>>>> >>>>> Is that accurate? I'll give it a try and see what is reported. >>>>> >>>>> Thanks. >>>>> Larry >>>>> >>>>> >>>>> On Wed, Sep 25, 2013 at 3:59 PM, Mueller, Doug >>>>> wrote: >>>>> >>>>>> ** >>>>>> >>>>>> LG, >>>>>> >>>>>> ** ** >>>>>> >>>>>> Have you tried $BROWSER$. >>>>>> >>>>>> ** ** >>>>>> >>>>>> This keyword has existed for a while. >>>>>> >>>>>> ** ** >>>>>> >>>>>> Here is an OLD KB article >>>>>> >>>>>> ** ** >>>>>> >>>>>> >>>>>> https://kb.bmc.com/infocenter/index?page=content&id=KA335773&actp=search&viewlocale=en_US&searchid=1380139054044 >>>>>> >>>>>> >>>>>> ** ** >>>>>> >>>>>> that gives examples of the return from this for ARS 5.0 through 6.0 >>>>>> I TOLD YOU IT WAS OLD. but it gives >>>>>> >>>>>> you an example of what to expect as a return. The browser name and a >>>>>> version. >>>>>> >>>>>> ** ** >>>>>> >>>>>> Does this give you what you need? >>>>>> >>>>>> ** ** >>>>>> >>>>>> Doug Mueller >>>>>> >>>>>> ** ** >>>>>> >>>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>>> arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson >>>>>> *Sent:* Wednesday, September 25, 2013 12:53 PM >>>>>> *To:* arslist@ARSLIST.ORG >>>>>> *Subject:* Detecting browser type in workflow >>>>>> >>>>>> ** ** >>>>>> >>>>>> ** >>>>>> >>>>>> H >>>>>> >>>>>> i Folks, >>>>>> >>>>>> ** ** >>>>>> >>>>>> Does anyone have a workflow technique for detecting the type of >>>>>> browser that the Mid-tier user is using? I want to try to adjust the view >>>>>> based on the browser type. >>>>>> >>>>>> ** ** >>>>>> >>>>>> Thanks. >>>>>> >>>>>> Larry >>>>>> >>>>>> ** ** >>>>>> >>>>>> ARS: 7.6.04 SP3 201201302357 on Solaris 10 >>>>>> >>>>>> Midtier: >>>>>> >>>>>> 7.6.04 SP3 201208101612 Hotfix >>>>>> >>>>>> on Tomcat >>>>>> >>>>>> Tomcat: >>>>>> >>>>>> 6.0.35 >>>>>> >>>>>> on RH Linux >>>>>> >>>>>> Oracle: 11.2.0.3.0 on Solaris 10 >>>>>> >>>>>> Larry Robinson >>>>>> >>>>>> Remedy Developer / Administrator >>>>>> >>>>>> NC State University >>>>>> >>>>>> Raleigh, NC >>>>>> >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" <>
Re: Detecting browser type in workflow
Hi Jason, Was able to figure this out myself (with the help of Google). I added a SetField action to an ActiveLink with a Value of: $PROCESS$ JAVASCRIPT window.navigator.userAgent; and I got: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.65 Safari/537.36 returned into the field. So now, all I have to do is parse the result. :-) Thanks for pointing me in the right direction. Larry On Wed, Sep 25, 2013 at 10:26 PM, L G Robinson wrote: > Hi Jason, > > JavaScript was where I was heading with my first post. Can you help me get > started with that? Do you have any examples? Where does the JavaScript go > and how do you get the results back into workflow where you can do stuff > with it? > > Thanks. > Larry > > > On Wed, Sep 25, 2013 at 5:03 PM, Jason Miller wrote: > >> ** >> That seems to match what I am seeing. You might be better off running >> some JavaScript to capture the browser. >> >> The top three entries are non-IE >> 1:52:58 - Android / Chrome >> 1:53:29 - Win 7 / Chrome >> 1:57:16 - iOS 6 / Safari >> >> Firefox shows as Netscape7 but it is not (knowing) pictured below. >> >> [image: Inline image 2] >> >> >> On Wed, Sep 25, 2013 at 1:31 PM, L G Robinson wrote: >> >>> ** >>> Hi Doug, >>> >>> Thanks for the reply. That certainly sounds like exactly what I was >>> looking for. I had forgotten about that keyword. >>> >>> I tried to view the article that you referenced but I got "Article Not >>> Found". Must be REEEALY old. ;-) >>> >>> The documentation for $BROWSER$ says this: >>> >>> The browser (Internet Explorer or other) being used in the current >>> session. If the browser is anything other than Internet Explorer, Netscape >>> is returned. >>> For BMC Remedy User, an empty string ("") is returned. This keyword is >>> NULL on the server. >>> >>> >>> Is that accurate? I'll give it a try and see what is reported. >>> >>> Thanks. >>> Larry >>> >>> >>> On Wed, Sep 25, 2013 at 3:59 PM, Mueller, Doug wrote: >>> >>>> ** >>>> >>>> LG, >>>> >>>> ** ** >>>> >>>> Have you tried $BROWSER$. >>>> >>>> ** ** >>>> >>>> This keyword has existed for a while. >>>> >>>> ** ** >>>> >>>> Here is an OLD KB article >>>> >>>> ** ** >>>> >>>> >>>> https://kb.bmc.com/infocenter/index?page=content&id=KA335773&actp=search&viewlocale=en_US&searchid=1380139054044 >>>> >>>> >>>> ** ** >>>> >>>> that gives examples of the return from this for ARS 5.0 through 6.0 I >>>> TOLD YOU IT WAS OLD. but it gives >>>> >>>> you an example of what to expect as a return. The browser name and a >>>> version. >>>> >>>> ** ** >>>> >>>> Does this give you what you need? >>>> >>>> ** ** >>>> >>>> Doug Mueller >>>> >>>> ** ** >>>> >>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>> arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson >>>> *Sent:* Wednesday, September 25, 2013 12:53 PM >>>> *To:* arslist@ARSLIST.ORG >>>> *Subject:* Detecting browser type in workflow >>>> >>>> ** ** >>>> >>>> ** >>>> >>>> H >>>> >>>> i Folks, >>>> >>>> ** ** >>>> >>>> Does anyone have a workflow technique for detecting the type of browser >>>> that the Mid-tier user is using? I want to try to adjust the view based on >>>> the browser type. >>>> >>>> ** ** >>>> >>>> Thanks. >>>> >>>> Larry >>>> >>>> ** ** >>>> >>>> ARS: 7.6.04 SP3 201201302357 on Solaris 10 >>>> >>>> Midtier: >>>> >>>> 7.6.04 SP3 201208101612 Hotfix >>>> >>>> on Tomcat >>>> >>>> Tomcat: >>>> >>>> 6.0.35 >>>> >>>> on RH Linux >>>> >>>> Oracle: 11.2.0.3.0 on Solaris 10 >>>> >>>> Larry Robinson >>>> >>>> Remedy Developer / Administrator >>>> >>>> NC State University >>>> >>>> Raleigh, NC >>>> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" <>
Re: Detecting browser type in workflow
Hi Jason, JavaScript was where I was heading with my first post. Can you help me get started with that? Do you have any examples? Where does the JavaScript go and how do you get the results back into workflow where you can do stuff with it? Thanks. Larry On Wed, Sep 25, 2013 at 5:03 PM, Jason Miller wrote: > ** > That seems to match what I am seeing. You might be better off running > some JavaScript to capture the browser. > > The top three entries are non-IE > 1:52:58 - Android / Chrome > 1:53:29 - Win 7 / Chrome > 1:57:16 - iOS 6 / Safari > > Firefox shows as Netscape7 but it is not (knowing) pictured below. > > [image: Inline image 2] > > > On Wed, Sep 25, 2013 at 1:31 PM, L G Robinson wrote: > >> ** >> Hi Doug, >> >> Thanks for the reply. That certainly sounds like exactly what I was >> looking for. I had forgotten about that keyword. >> >> I tried to view the article that you referenced but I got "Article Not >> Found". Must be REEEALY old. ;-) >> >> The documentation for $BROWSER$ says this: >> >> The browser (Internet Explorer or other) being used in the current >> session. If the browser is anything other than Internet Explorer, Netscape >> is returned. >> For BMC Remedy User, an empty string ("") is returned. This keyword is >> NULL on the server. >> >> >> Is that accurate? I'll give it a try and see what is reported. >> >> Thanks. >> Larry >> >> >> On Wed, Sep 25, 2013 at 3:59 PM, Mueller, Doug wrote: >> >>> ** >>> >>> LG, >>> >>> ** ** >>> >>> Have you tried $BROWSER$. >>> >>> ** ** >>> >>> This keyword has existed for a while. >>> >>> ** ** >>> >>> Here is an OLD KB article >>> >>> ** ** >>> >>> >>> https://kb.bmc.com/infocenter/index?page=content&id=KA335773&actp=search&viewlocale=en_US&searchid=1380139054044 >>> >>> >>> ** ** >>> >>> that gives examples of the return from this for ARS 5.0 through 6.0 I >>> TOLD YOU IT WAS OLD. but it gives >>> >>> you an example of what to expect as a return. The browser name and a >>> version. >>> >>> ** ** >>> >>> Does this give you what you need? >>> >>> ** ** >>> >>> Doug Mueller >>> >>> ** ** >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson >>> *Sent:* Wednesday, September 25, 2013 12:53 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Detecting browser type in workflow >>> >>> ** ** >>> >>> ** >>> >>> H >>> >>> i Folks, >>> >>> ** ** >>> >>> Does anyone have a workflow technique for detecting the type of browser >>> that the Mid-tier user is using? I want to try to adjust the view based on >>> the browser type. >>> >>> ** ** >>> >>> Thanks. >>> >>> Larry >>> >>> ** ** >>> >>> ARS: 7.6.04 SP3 201201302357 on Solaris 10 >>> >>> Midtier: >>> >>> 7.6.04 SP3 201208101612 Hotfix >>> >>> on Tomcat >>> >>> Tomcat: >>> >>> 6.0.35 >>> >>> on RH Linux >>> >>> Oracle: 11.2.0.3.0 on Solaris 10 >>> >>> Larry Robinson >>> >>> Remedy Developer / Administrator >>> >>> NC State University >>> >>> Raleigh, NC >>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" <>
Re: Detecting browser type in workflow
Hi Doug, Thanks for the reply. That certainly sounds like exactly what I was looking for. I had forgotten about that keyword. I tried to view the article that you referenced but I got "Article Not Found". Must be REEEALY old. ;-) The documentation for $BROWSER$ says this: The browser (Internet Explorer or other) being used in the current session. If the browser is anything other than Internet Explorer, Netscape is returned. For BMC Remedy User, an empty string ("") is returned. This keyword is NULL on the server. Is that accurate? I'll give it a try and see what is reported. Thanks. Larry On Wed, Sep 25, 2013 at 3:59 PM, Mueller, Doug wrote: > ** > > LG, > > ** ** > > Have you tried $BROWSER$. > > ** ** > > This keyword has existed for a while. > > ** ** > > Here is an OLD KB article > > ** ** > > > https://kb.bmc.com/infocenter/index?page=content&id=KA335773&actp=search&viewlocale=en_US&searchid=1380139054044 > > > ** ** > > that gives examples of the return from this for ARS 5.0 through 6.0 I > TOLD YOU IT WAS OLD. but it gives > > you an example of what to expect as a return. The browser name and a > version. > > ** ** > > Does this give you what you need? > > ** ** > > Doug Mueller > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Wednesday, September 25, 2013 12:53 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Detecting browser type in workflow > > ** ** > > ** > > H > > i Folks, > > ** ** > > Does anyone have a workflow technique for detecting the type of browser > that the Mid-tier user is using? I want to try to adjust the view based on > the browser type. > > ** ** > > Thanks. > > Larry > > ** ** > > ARS: 7.6.04 SP3 201201302357 on Solaris 10 > > Midtier: > > 7.6.04 SP3 201208101612 Hotfix > > on Tomcat > > Tomcat: > > 6.0.35 > > on RH Linux > > Oracle: 11.2.0.3.0 on Solaris 10 > > Larry Robinson > > Remedy Developer / Administrator > > NC State University > > Raleigh, NC > > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Detecting browser type in workflow
H i Folks, Does anyone have a workflow technique for detecting the type of browser that the Mid-tier user is using? I want to try to adjust the view based on the browser type. Thanks. Larry ARS: 7.6.04 SP3 201201302357 on Solaris 10 Midtier: 7.6.04 SP3 201208101612 Hotfix on Tomcat Tomcat: 6.0.35 on RH Linux Oracle: 11.2.0.3.0 on Solaris 10 Larry Robinson Remedy Developer / Administrator NC State University Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Join form question
Thanks Joe and James. Excellent suggestions. Larry On Wed, Aug 21, 2013 at 4:53 PM, Joe D'Souza wrote: > ** > > Directly in the DB and then to keep the rest of the stuff more at ARS > level, build a view form on top of that view. Then do a join the ARS way. > So the only external dependency would be the creation of that distinct > listing by way of the view. (Create view as select distinct…..) > > ** ** > > So step one would be create that view. Step two would be create a view > form in the Remedy system feeding off from that DB view that you created. > And Step 3 would be to create the join. > > ** ** > > ALTERNATELY you could create the entire view at DB level including the > inner join as James suggested and then create a View form on top of that. > That however would mean that the view would depend on 2 forms so changes on > any of those two forms could impact that DB view. > > ** ** > > Personally I would go with the less impact – create view of the form that > needs that distinct listing (first method described here).. That method > would impact the view only if you make changes to the form that the view is > based out of by renaming field names. > > ** ** > > Cheers > > ** ** > > Joe > > ** ** > ------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 4:37 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Join form question > > ** ** > > ** > > Hi Joe, > > ** ** > > Thanks for the reply. This "create a view containing distinct values of B" > sounds intriguing. Is that something I can do with Dev Studio or do I have > to create that directly on the DB? I didn't see anything in the view > properties in Dev Studio. > > ** ** > > Thanks. > > Larry > > ** ** > > On Wed, Aug 21, 2013 at 4:06 PM, Joe D'Souza wrote:*** > * > > ** > > It appears like you are looking for a join between A and distinct of B, > which is only possible if you customize your system such that you actually > create a view containing distinct values of B, and then use that to create > a join with A. > > > > Otherwise as far as the AR System is concerned that second or third or > fourth row it might see of 100 if you had that many, are separate rows. No > way for it to know that you are seeking for distinct values. > > > > Joe > > > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 2:14 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Join form question > > > > ** > > Hi Folks, > > > > I need some help with a join. I'm not sure if this is possible or not. > > > > In simple terms, I have two forms, Form A and Form B > > > > They have one field in common, lets call it X. > > > > Form A has the following values for X: > > 100 > > 200 > > 300 > > > > Form B has two fields X and Y. > > There may be multiple entries in Form B where X is repeated: > > > > XY > > 10020 > > 10020 > > 10030 > > 20030 > > 20030 > > 20040 > > 30020 > > > > Is there a way to join these two forms together so that if I search for > Y=20 I will get this: > > > > X > > 100 > > 300 > > > > instead of this: > > > > X > > 100 > > 100 > > 300 > > > > I have tried a number of variations on inner/outer and switching primary > but I haven't been able to get what I want. > > > > Thanks for any suggestions you may have. > > Larry > > > > ARS: 7.6.04 SP3 201201302357 on Solaris 10 > > Oracle 11.2.0.3.0 > > > > > > Larry Robinson > > Remedy Developer/Admin > > NC State University > > Raleigh, NC > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ** ** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Join form question
Hi Joe, Thanks for the reply. This "create a view containing distinct values of B" sounds intriguing. Is that something I can do with Dev Studio or do I have to create that directly on the DB? I didn't see anything in the view properties in Dev Studio. Thanks. Larry On Wed, Aug 21, 2013 at 4:06 PM, Joe D'Souza wrote: > ** > > It appears like you are looking for a join between A and distinct of B, > which is only possible if you customize your system such that you actually > create a view containing distinct values of B, and then use that to create > a join with A. > > ** ** > > Otherwise as far as the AR System is concerned that second or third or > fourth row it might see of 100 if you had that many, are separate rows. No > way for it to know that you are seeking for distinct values. > > ** ** > > Joe > > ** ** > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 2:14 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Join form question > > ** ** > > ** > > Hi Folks, > > ** ** > > I need some help with a join. I'm not sure if this is possible or not. > > ** ** > > In simple terms, I have two forms, Form A and Form B > > ** ** > > They have one field in common, lets call it X. > > ** ** > > Form A has the following values for X: > > 100 > > 200 > > 300 > > ** ** > > Form B has two fields X and Y. > > There may be multiple entries in Form B where X is repeated: > > ** ** > > XY > > 10020 > > 10020 > > 10030 > > 20030 > > 20030 > > 20040 > > 30020 > > ** ** > > Is there a way to join these two forms together so that if I search for > Y=20 I will get this: > > ** ** > > X > > 100 > > 300 > > ** ** > > instead of this: > > ** ** > > X > > 100 > > 100 > > 300 > > ** ** > > I have tried a number of variations on inner/outer and switching primary > but I haven't been able to get what I want. > > ** ** > > Thanks for any suggestions you may have. > > Larry > > ** ** > > ARS: 7.6.04 SP3 201201302357 on Solaris 10 > > Oracle 11.2.0.3.0 > > ** ** > > ** ** > > Larry Robinson > > Remedy Developer/Admin > > NC State University > > Raleigh, NC > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Join form question
Hi Folks, I need some help with a join. I'm not sure if this is possible or not. In simple terms, I have two forms, Form A and Form B They have one field in common, lets call it X. Form A has the following values for X: 100 200 300 Form B has two fields X and Y. There may be multiple entries in Form B where X is repeated: XY 10020 10020 10030 20030 20030 20040 30020 Is there a way to join these two forms together so that if I search for Y=20 I will get this: X 100 300 instead of this: X 100 100 300 I have tried a number of variations on inner/outer and switching primary but I haven't been able to get what I want. Thanks for any suggestions you may have. Larry ARS: 7.6.04 SP3 201201302357 on Solaris 10 Oracle 11.2.0.3.0 Larry Robinson Remedy Developer/Admin NC State University Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Web services with null qualifications
Thanks Doug. This information is very helpful. Larry On Tue, Jul 30, 2013 at 4:12 PM, Mueller, Doug wrote: > ** > > Larry, > > ** ** > > First, about what you are seeing. > > ** ** > > The server SHOULD NOT perform the query and should return an error > indicating that you have a NULL > > qualifier and that is not allowed. > > ** ** > > HOWEVER, it seems that somehow, a web service is getting by that check in > the server. We ran a test > > internally after seeing this note and confirmed that the query gets > through and searches the database. > > We consider this a bug and one is entered to be fixed for future releases > and for the 8.1 service pack line. > > ** ** > > You are correctly configured, but for some reason, web services are not > obeying the rules. > > ** ** > > ** ** > > On the thread issue, killing an AR System server thread does no good. The > problem is that the AR System > > server prepares the command and issues it to the DB and waits for a > reply. Killing the AR System thread just > > kills a waiting thread but the DB still has the request and is still > processing. So, even if you could and it worked > > OK, it would not help you. > > ** ** > > We have tried in the past to be able to stop a search once in flight, but > there is simply no operation available > > from the DB vendors for doing that. Once started, it runs to completion. > We even tried to have a model > > where we had a parallel thread to the DB and tried to kill the DB > connection. But, that just freed up our > > thread and the DB kept running. > > ** ** > > The key is to prevent the running in the first place. > > ** ** > > ** ** > > The good news is that you configured things to do that. > > The bad news is that we are not paying attention for some reason on the > channel you are using. > > ** ** > > Thank you for calling this case out so it can get "we need to check the > option for web services > > searches" onto the fix list for the future. > > ** ** > > Doug Mueller > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Tuesday, July 30, 2013 5:56 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Web services with null qualifications > > ** ** > > ** > > Hi Folks, > > ** ** > > Thanks for the replies. I agree with Alfred and Tauf... it would be best > to wrap the WS calls inside an application or some other interface. And we > have done that. Some of our PHP and Perl experts have built modules that > expose the Web services indirectly. But when these modules were built, we > weren't really aware of this issue so no effort was made to ensure that the > qualification was not null. I plan to go back to these groups and request > this type of checking be added. > > ** ** > > However, we have also published the Web services directly so there is the > possibility that they are out there, "in the wild". I was hoping there were > steps that I could take from the Remedy side to make sure that WS requests > with null qualifications could be caught and handled. > > ** ** > > Thanks again for your assistance. > > ** ** > > On Mon, Jul 29, 2013 at 3:49 PM, Differ, Alfred W CTR PHD NSWC, 210 < > alfred.differ@navy.mil> wrote: > > With a previous employer our users were interacting with a web app that > would construct the WS request. We just made sure the qualification line > could not be null in the app and then intentionally hid the WS URL from the > outside world. With no way to get inside except through that app, we > prevented the null qualification or at least made sure it was our error if > it DID happen. > > -al > > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Monday, July 29, 2013 12:33 PM > To: arslist@ARSLIST.ORG > Subject: Web services with null qualifications > > ** > > Hi Folks, > > > We make heavy use of Web services here at NC State and I have come across > a problem. We have a number of standard get-entry and get-list operations > defined against our main form. These operations have the usual: > > > Qualification > StartRecord > MaxLimit > > > input parameters. > > > The problem... If a user of the Web services invokes one of these > operations with a null qualification, this results i
Re: Web services with null qualifications
Hi Folks, Thanks for the replies. I agree with Alfred and Tauf... it would be best to wrap the WS calls inside an application or some other interface. And we have done that. Some of our PHP and Perl experts have built modules that expose the Web services indirectly. But when these modules were built, we weren't really aware of this issue so no effort was made to ensure that the qualification was not null. I plan to go back to these groups and request this type of checking be added. However, we have also published the Web services directly so there is the possibility that they are out there, "in the wild". I was hoping there were steps that I could take from the Remedy side to make sure that WS requests with null qualifications could be caught and handled. Thanks again for your assistance. On Mon, Jul 29, 2013 at 3:49 PM, Differ, Alfred W CTR PHD NSWC, 210 < alfred.differ@navy.mil> wrote: > With a previous employer our users were interacting with a web app that > would construct the WS request. We just made sure the qualification line > could not be null in the app and then intentionally hid the WS URL from the > outside world. With no way to get inside except through that app, we > prevented the null qualification or at least made sure it was our error if > it DID happen. > > -al > > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Monday, July 29, 2013 12:33 PM > To: arslist@ARSLIST.ORG > Subject: Web services with null qualifications > > ** > Hi Folks, > > > We make heavy use of Web services here at NC State and I have come across > a problem. We have a number of standard get-entry and get-list operations > defined against our main form. These operations have the usual: > > > Qualification > StartRecord > MaxLimit > > > input parameters. > > > The problem... If a user of the Web services invokes one of these > operations with a null qualification, this results in a full table scan. > Obviously, this is not ideal for a table with ~275K records. > > > My server settings are set to disallow unqualified searches > (Allow-Unqual-Queries: F) and there is also a limit on the number of > returned records (Max-Entries-Per-Query: 5). Apparently, the Web > services are exempt from these limitations. > > > Does anyone have any suggestions on how I can prevent these table scans? > It doesn't happen often but when it does, I end up restarting the AR server > as performance eventually becomes unacceptable before the scan completes. > > > On a side note, if I know the server thread that is processing the table > scan, is there any way to kill that process without killing the whole > server? > > > Thanks for any insights you might have. > > > ARS: 7.6.03 on Solaris 10. > Mid Tier: 7.6.04 SP3 201208101612 Hotfix on Red Hat Linux > Tomcat: 6.0.35 > Java: 1.7.0_05 > > > Larry Robinson > Remedy Developer/Admin > NC State University > Raleigh, NC > > > PS: I voted. ;-) > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Web services with null qualifications
Hi Folks, We make heavy use of Web services here at NC State and I have come across a problem. We have a number of standard get-entry and get-list operations defined against our main form. These operations have the usual: Qualification StartRecord MaxLimit input parameters. The problem... If a user of the Web services invokes one of these operations with a null qualification, this results in a full table scan. Obviously, this is not ideal for a table with ~275K records. My server settings are set to disallow unqualified searches (Allow-Unqual-Queries: F) and there is also a limit on the number of returned records (Max-Entries-Per-Query: 5). Apparently, the Web services are exempt from these limitations. Does anyone have any suggestions on how I can prevent these table scans? It doesn't happen often but when it does, I end up restarting the AR server as performance eventually becomes unacceptable before the scan completes. On a side note, if I know the server thread that is processing the table scan, is there any way to kill that process without killing the whole server? Thanks for any insights you might have. ARS: 7.6.03 on Solaris 10. Mid Tier: 7.6.04 SP3 201208101612 Hotfix on Red Hat Linux Tomcat: 6.0.35 Java: 1.7.0_05 Larry Robinson Remedy Developer/Admin NC State University Raleigh, NC PS: I voted. ;-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Form mode color
I can't take credit for it... I got it from BMC or ColumnIT, I can't remember which. On Tue, Jun 11, 2013 at 3:49 PM, Jason Miller wrote: > ** > That is a pretty elegant solution. Thanks for sharing! > > Ultimately I think it is inconsistent with most web apps and web > "standards" if you will but if you are forced to do it then this is the way > to go. > > > On Tue, Jun 11, 2013 at 10:05 AM, L G Robinson wrote: > >> ** >> Hi Marc, >> >> My customers continued to expect the traditional background colors even >> after we began offering the Mid-tier client so I installed a series of >> Active Links to accomplish this. >> >> On: Window Open >> Run If: ($OPERATION$ = "QUERY") AND ($CLIENT-TYPE$ = 9) >> If Actions: >> Run Process: Command >> Line: javascript:document.body.style.background="#A4C8F0"; >> >> I have one of these for each of the possible OPERATIONS with the >> appropriate colors: >> >> QUERY: #A4C8F0 >> CREATE: #C0E5C0 >> GET: A4C8F0 >> SET: C0E5C0 >> SET ALL: 008080 >> >> Works pretty well. Sometime, the bg color "leaks" though the right-hand >> end of the Mid-tier menu bar if the browser window width exceeds the >> defined width of the view. >> >> Hope this is helpful. >> Larry >> >> >> On Tue, Jun 11, 2013 at 11:15 AM, Marc Burick > > wrote: >> >>> ** Hi. >>> All of our applications are home grown and we are moving them to the >>> web. In the RUT, Search and New/Modify screens can be set to different >>> colors to differentiate them but I do not see that option or way to do that >>> on the web. The only indication of the mode the screen is in on the web is >>> the small print in the upper left hand corner of the screen that states, >>> "New", "Modify" or "Search". Has anyone encountered this and have a >>> resolution? >>> >>> ARServer 7.6.4 sp3 >>> MS-SQL 2008 >>> >>> Thank you in advance. >>> >>> Marc _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Form mode color
Hi Marc, My customers continued to expect the traditional background colors even after we began offering the Mid-tier client so I installed a series of Active Links to accomplish this. On: Window Open Run If: ($OPERATION$ = "QUERY") AND ($CLIENT-TYPE$ = 9) If Actions: Run Process: Command Line: javascript:document.body.style.background="#A4C8F0"; I have one of these for each of the possible OPERATIONS with the appropriate colors: QUERY: #A4C8F0 CREATE: #C0E5C0 GET: A4C8F0 SET: C0E5C0 SET ALL: 008080 Works pretty well. Sometime, the bg color "leaks" though the right-hand end of the Mid-tier menu bar if the browser window width exceeds the defined width of the view. Hope this is helpful. Larry On Tue, Jun 11, 2013 at 11:15 AM, Marc Burick wrote: > ** Hi. > All of our applications are home grown and we are moving them to the web. > In the RUT, Search and New/Modify screens can be set to different colors to > differentiate them but I do not see that option or way to do that on the > web. The only indication of the mode the screen is in on the web is the > small print in the upper left hand corner of the screen that states, "New", > "Modify" or "Search". Has anyone encountered this and have a resolution? > > ARServer 7.6.4 sp3 > MS-SQL 2008 > > Thank you in advance. > > Marc _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: AREA LDAP 8.0 Configuration Issue
I had this problem... I had to set Authentication Chaining Mode to: "AREA - ARS". Hope this is helpful. Larry On Thu, Mar 28, 2013 at 5:50 PM, Kapil Banwari wrote: > If you are using CRBP(Cross Ref Blank password)= True, and you have mainly > AR groups (not specific AD groups) which you need to use, make sure in AREA > LDAP configuration form, in the License Mask and in the Write license > (under > Defaults and Mapping attributes to user information), you don't have any > value mentioned over there. > > If it is blank, it is going to pick the licenses from User form, and you > should get token as per mentioned in user form. > > If there is no specific reason to use chaining mode, it can be set to off, > as by default it is set to first go to ARS and then to AREA. If you are > using any sso plugin, then in those cases chaining is usually helpful and > enabled. > > By default, the way it works with chaining disabled is, first it go to user > form, it will check if that user exists in user form, and if that user have > blank password in user form (with CRBP=true) and then it will authenticate > via the password of AD . > > Hope this helps. > > Regards > Kapil B. > > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Abdullah Baytops > Sent: Friday, March 29, 2013 2:28 AM > To: arslist@ARSLIST.ORG > Subject: Re: AREA LDAP 8.0 Configuration Issue > > We have the following: > > 1. No check box in the "Allow Guest Users" > 2. No check box in the "Authenticate Unregistered Users" > 3. Authentication has AREA - ARS > > > V/R > Abdul Baytops > > > From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] > on behalf of Andrew Belis [andrew.be...@lmco.com] > Sent: Thursday, March 28, 2013 4:33 PM > To: arslist@ARSLIST.ORG > Subject: Re: AREA LDAP 8.0 Configuration Issue > > Under Configuration tab do you have "Allow Guest Users" enabled by chance? > What are your settings for "Authenticate Unregistered Users" under EA tab > as > well as the "Authentication Chaining Mode" set to? > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Disabling 'Set Refresh Interval' Option
Hi Carol, I received the following from my support org a couple of months ago. I have implemented this solution on my system so if you run into problems, I may be able to help. Hope this is helpful. Larry Knowledge Article ID:KA328092 Published date:10/09/2011 Version:2.0 Status:Published Updated:10/09/2011 Problem In Mid-tier 7.1 - how do I remove the Preferences button from the results list? How to disable the Set Refresh Interval selection? Solution Note: This is an unsupported customization. It will need to be repeated if you patch or upgrade your installation. If you just want to remove the Set Refresh Interval from the Preferences menu, 1. Locate the clientcore.js file. This will be located under the \resources\\javascript directory. Each browser type has a unique clientcore.js file. 2. Make a backup copy of the file. 3. Edit the file and locate the line: menuDef.push({l:getLocalizedMessage("Set Refresh Interval").JScriptEncode(), v:"this.setInterval()",s:1}); Either delete this line or comment it out. 4. Save the file. 5. Restart the webserver. 6. In the browser, clear the browser cache so that a new copy of the Clientcore.js file is loaded to the browser cache. To remove the Preferences button from the results lists, you will need to do the following: 1. Locate the clientcore.js file. This will be located under the \resources\\javascript directory. Each browser type has a unique clientcore.js file. 2. Make a backup copy of the file. 3. Edit the file and locate the line: n.setAttribute("arrefstr",getLocalizedMessage("Preferences")); Either delete this line or comment it out. 4. Save the file. 5. Restart the webserver. 6. In the browser, clear the browser cache so that a new copy of the Clientcore.js file is loaded to the browser cache. On Tue, Mar 19, 2013 at 10:27 AM, Carol Carnevali < carol.carnev...@broadridge.com> wrote: > Hi, > > I need to know how to disable, preferably globally, the 'Set Refresh > Interval' option on Tables and on the Results List. I've found that I can > do it if I remove the 'Preferences' option altogether, but I'd like to keep > the Preferences and just remove that option. Does anyone know how? > > Thanks! > Carol > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Best way to "out of service" a Mid-tier server
Thanks Steve... this is useful information. Larry On Tue, Mar 5, 2013 at 5:38 PM, Steve Kallestad wrote: > ** I very rarely show system messages to the end user. What makes sense > from a technical perspective very rarely makes sense to an end user. > > SOAP Services are automated and it makes sense for Remedy to send errors > the way it does. > > Generally, in whatever application I'm putting together I will have a > generic error handler. Within that error handler there is logic that does > 4 things: > > 1) translates expected error messages to something the user will > understand. > 2) formats error messages in a manner that works with my end user interface > 3) logs the error > 4) attempts error recovery and failing that presents the error to an end > user. > > You'll get errors form the SOAP library you are using (things like XML > invalid, destination server unavailable), from Remedy (database timeout, > password invalid, plugin server not available), and from the application > (must select item from menu, people record not found). > > Every interface is going to have to deal with those errors as cleanly as > possible. > > For out of service, there are a few things you can do. > > 1) You can flag your app to use an alternative server, and barring > availability: > a) store requests and forward them when availability has returned > b) alert your end users with a banner that says some functionality is > not currently available > c) alert end users interactively when they run into problems > d) bring your application into a not-available state > > 2) You can alert appropriate staff. > a) by creating an incident > b) by sending an SMS Message > c) by sending an email > d) by adding a log entry > > Also for out of service, there are usually expected down times for > maintenance, upgrades, and whatnot. Pro-actively addressing that is > obviously a good idea. Sometimes it's on a schedule, sometimes you can get > the information from a monitoring system, sometimes you can get it directly > from Remedy. > > Have a look at: http://php.net/manual/en/language.exceptions.php > > Using try/catch will allow you to intercept the SOAP errors before they > get to your end user. > > You'll have something like: > > try { > doTheSOAPThing($data); > } catch ($e) { > raiseThePitchForks($e); > echo humanFriendly($e->getMessage()); > } > > There are php.ini settings that will hide error messages from end users. > Typically, I will show error messages in development and hide them in > production. That prevents unexpected library errors from reporting too > much about your environment. > > http://www.php.net/manual/en/errorfunc.configuration.php#ini.display-errors > > A lot of library based errors will hand over information that you don't > necessarily want made public. Like the name of your database server or > user, installation paths, addresses of internal servers, etc. > > > > > On Tue, Mar 5, 2013 at 8:49 AM, L G Robinson wrote: > >> ** >> Hi Fred, >> >> Thanks for your reply. In testing with my dev server, I find the >> following: >> >> SoapUI says: >> >> >> soapenv:Server.userException >> ARERR [90] Cannot establish a network connection to >> the AR System server : Connection refused my_ars_server:33000 >> >> http://xml.apache.org/axis/";> >> my_ars_server.ncsu.edu >> >> >> >> In the #status# header I see: HTTP/1.1 500 Internal Server Error >> >> >> A PHP program calling a web services says: >> >> An error occurred while getting the call: SOAP Error: ARERR [90] Cannot >> establish a network connection to the AR System server : Connection refused >> my_ars_server:33000[locutus:~/MyRemedyPHP_API] >> >> So I guess this is ok in the sense that the PHP recognizes this as a >> failure. I was just curious if anyone was doing anything different to >> provide anything more informative. >> >> Thanks. >> Larry >> >> >> On Mon, Mar 4, 2013 at 2:33 PM, Grooms, Frederick W < >> frederick.w.gro...@xo.com> wrote: >> >>> ** >>> >>> If the ARS Application is down doesn’t the Web Service call result in a >>> SOAP Fault with an Unable to connect to server error? >>> >>> ** ** >>> >>> Fred >>> >>> ** ** >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson
Re: Best way to "out of service" a Mid-tier server
Hi Fred, Thanks for your reply. In testing with my dev server, I find the following: SoapUI says: soapenv:Server.userException ARERR [90] Cannot establish a network connection to the AR System server : Connection refused my_ars_server:33000 http://xml.apache.org/axis/";> my_ars_server.ncsu.edu In the #status# header I see: HTTP/1.1 500 Internal Server Error A PHP program calling a web services says: An error occurred while getting the call: SOAP Error: ARERR [90] Cannot establish a network connection to the AR System server : Connection refused my_ars_server:33000[locutus:~/MyRemedyPHP_API] So I guess this is ok in the sense that the PHP recognizes this as a failure. I was just curious if anyone was doing anything different to provide anything more informative. Thanks. Larry On Mon, Mar 4, 2013 at 2:33 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > If the ARS Application is down doesn’t the Web Service call result in a > SOAP Fault with an Unable to connect to server error? > > ** ** > > Fred > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Monday, March 04, 2013 1:28 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Best way to "out of service" a Mid-tier server > > ** ** > > ** > > Hi Folks, > > ** ** > > Recently, my DBAs migrated my Remedy Oracle DB to new hardware. This > activity necessitated an extended outage for my users. Typically, when my > system will be unavailable for an extended period, I install temporary > replacements for some HTML and JSP pages so that I can display information > about the outage and point to status pages, etc. > > ** ** > > For my Mid-tier users, I usually replace the index.html file in the Tomcat > "webapps/ROOT/" directory and I also replace the > "webapps/arsys/shared/login.jsp" page with a redirect to an information > page. This all works well. > > ** ** > > My question is about the Mid-tier servers that we have designated as part > of a pool of servers dedicated to responding to web service requests. Since > there may or may not be a person sitting in front of a browser for these > servers, I'm looking for suggestions on the best wat to "out-of-service" > the web service Tomcat servers. The web services might be called by a PHP > web page or they might be called by an automated process using a Perl or > PHP script. I want to fail in such a way that the user (person or script) > knows that it failed and also provide useful information about why it > failed. Any suggestions? > > ** ** > > ARS: 7.6.04 SP3 201201302357 > > Oracle: 11.2.0.3.0 - 64bit > > Mid-Tier: 7.6.04_SP3_201208101612_Hotfix > > Tomcat: 6.0.35 > > JAVA: 1.7.0_05 > > ** ** > > Thanks. > > Larry > > ** ** > > Larry Robinson > > Remedy Developer / Administrator > > North Carolina State University > > Raleigh, NC USA > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Best way to "out of service" a Mid-tier server
Hi Folks, Recently, my DBAs migrated my Remedy Oracle DB to new hardware. This activity necessitated an extended outage for my users. Typically, when my system will be unavailable for an extended period, I install temporary replacements for some HTML and JSP pages so that I can display information about the outage and point to status pages, etc. For my Mid-tier users, I usually replace the index.html file in the Tomcat "webapps/ROOT/" directory and I also replace the "webapps/arsys/shared/login.jsp" page with a redirect to an information page. This all works well. My question is about the Mid-tier servers that we have designated as part of a pool of servers dedicated to responding to web service requests. Since there may or may not be a person sitting in front of a browser for these servers, I'm looking for suggestions on the best wat to "out-of-service" the web service Tomcat servers. The web services might be called by a PHP web page or they might be called by an automated process using a Perl or PHP script. I want to fail in such a way that the user (person or script) knows that it failed and also provide useful information about why it failed. Any suggestions? ARS: 7.6.04 SP3 201201302357 Oracle: 11.2.0.3.0 - 64bit Mid-Tier: 7.6.04_SP3_201208101612_Hotfix Tomcat: 6.0.35 JAVA: 1.7.0_05 Thanks. Larry Larry Robinson Remedy Developer / Administrator North Carolina State University Raleigh, NC USA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Disable Windows client Auto-Refresh?
Hi Folks, Does anyone know of a way to disable the "Auto-Refresh..." menu item in the View menu of the Windows client? I am suffering from a shortage of floating licenses and I want to make sure that my users are not presenting a false usage profile by doing auto-refresh. I have un-checked the "Auto-Refresh" item in the "Accesible Menu Items" property for the view and that works for the Mid-tier but not the Windows client. BMC has an unsupported hack to the ClientCore.js file to remove the "Set Refresh Interval" menu item from the Preferences menu in the Mid-tier and that works. But I still have some Windows client users and I'd like to get them too. I have found the "Table Field Refresh Interval" field in the AR System User Preference form and I have a filter to check for non-null updates to that field. I'm just trying to cover all of the bases. Any ideas? Thanks. Larry ARS: 7.6.04 on Solaris 10 MT: Version 7.6.04 SP3 201208101612 Hotfix DB: Oracle Larry Robinson Remedy Developer / Administrator North Carolina State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Mid-tier 8.0.00 Diary field - can not select text
Hi Shawn, Thanks for your reply... I have tried with current versions of Safari and Chrome on a Mac and current versions of IE and Firefox on Windows. Behavior is the same in all browsers. I have flushed the Mid-tier cache and the browser cache... no improvement. One additional aspect that I have noticed is the following: If you drag the cursor outside of the diary field window while selecting the text inside the window, the selection will stick. But if you select a small bit of text that is totally within the bounds of the window, the selection doesn't stick. It behaves as though there is a click being executed inside the window after you release the mouse button which causes the selection to be unselected. Anyone out there with MT 8 that can test this for me? Thanks. Larry On Thu, Jan 10, 2013 at 2:14 PM, Pierson, Shawn wrote: > ** > > What browser are you using, and have you tried other browsers? With > 7.6.4, several of us here have identified issues with Firefox (Chrome seems > to work better although it’s not supported) and Internet Explorer is really > slow despite things rendering correctly. I would also suggest being sure > to clear the Mid Tier cache and your browser cache then trying again just > to double check that it’s not a weird issue there as well. > > ** ** > > Thanks, > > * * > > *Shawn Pierson * > > Remedy Developer | Energy Transfer > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Thursday, January 10, 2013 11:26 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Mid-tier 8.0.00 Diary field - can not select text > > ** ** > > ** Hi Folks, > > ** ** > > I have been playing around with Mid-tier 8.0.00 to see if it resolves any > of my issues. I noticed the following: > > ** ** > > When a diary field is expanded, I am not able to select any text in the > top part of the window. When you swipe the text, it is selected but when > you let go of the mouse button, the selection is de-selected and the focus > switches to the bottom part of the diary field (where you enter new text.) > Double-click exhibits the same behavior. Has anyone else experienced this > behavior? > > ** ** > > Mid-tier is 8.0.00 Build 001 20120530 running on RH Linux 6 > > AR Server is 7.6.04 SP3 201201302357 on Solaris > > DB is Oracle on Solaris > > ** ** > > Mid-tier 7.6.04 SP3 201208101612 Hotfix running in the same environment > does not exhibit this behavior. > > ** ** > > Thanks. > > Larry > > ** ** > > Larry Robinson > > Remedy Developer / Administrator > > North Carolina State University > > Raleigh, NC USA > > n...@ncsu.edu > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > Private and confidential as detailed > here<http://www.energytransfer.com/mail_disclaimer.aspx>. > If you cannot access hyperlink, please e-mail sender. > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Mid-tier 8.0.00 Diary field - can not select text
Hi Folks, I have been playing around with Mid-tier 8.0.00 to see if it resolves any of my issues. I noticed the following: When a diary field is expanded, I am not able to select any text in the top part of the window. When you swipe the text, it is selected but when you let go of the mouse button, the selection is de-selected and the focus switches to the bottom part of the diary field (where you enter new text.) Double-click exhibits the same behavior. Has anyone else experienced this behavior? Mid-tier is 8.0.00 Build 001 20120530 running on RH Linux 6 AR Server is 7.6.04 SP3 201201302357 on Solaris DB is Oracle on Solaris Mid-tier 7.6.04 SP3 201208101612 Hotfix running in the same environment does not exhibit this behavior. Thanks. Larry Larry Robinson Remedy Developer / Administrator North Carolina State University Raleigh, NC USA n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Trouble with Firefox and Mid-tier
Hi Folks, The problem with "On Return" Active Link workflow not firing in Firefox is corrected in: MT_7604SP3_2012AUG08_CU_ALL (7.6.04 SP3 201208081157 Hotfix). Hope this is helpful. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Trouble with Firefox and Mid-tier
Hi Folks, I know that Firefox is not a supported browser. But I thought it might be worthwhile to check to see if anyone had any ideas on this issue... Mid-tier 7.6.04 SP3 201207071337 Hotfix running on Linux. AR Server 7.6.04 SP3 or AR Server AR Server 7.6.03 Patch 002 201107191530 on Solaris Firefox 14.0.1 When you press RETURN in a form field that has workflow attached to it (Active Link executes on RETURN in field), the Active Link does not fire and the RETURN character is entered into the field. This worked correctly prior to Mid-tier 7.6.04 SP3 201207071337 Hotfix and only appears to be a problem in Firefox. Safari, IE and Chrome all work correctly. I discovered (on my Mac) that if I hold down SHIFT and CNTL while pressing RETURN, then the workflow does fire correctly. Has anyone else observed this? Any suggestions on how else to work around it? Thanks. Larry Larry Robinson Remedy Developer / Administrator North Carolina State University Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Remedy Startup
Hi Folks, A quick "strings" on the 7.6.04 Solaris version of armonitor reveals the following: V_WAIT_BEFORE_STARTUP V_WAIT_BEFORE_POLLING V_POLLING_INTERVAL V_NUM_POLLS V_POLLED_RPC_PROG V_SERVER_NAME V_USER_NAME V_PASSWORD V_LOGFILE_NAME V_EXECUTABLE Maybe V is enVirement? :-) Larry On Wed, Jun 13, 2012 at 9:52 AM, Joe Martin D'Souza wrote: > That’s a pretty cool setting.. Don't even need to tweak the registry if > you do not want to, to create service dependencies.. > > 1) Is that really not documented anywhere? When was it introduced? What > does the V in the V_WAIT_BEFORE_STARTUP stand for? > > 2) While it’s a nice setting that would get you there perhaps 90% of the > time, it would be even nicer if the design around this was something like, > this variable to accept a string instead of a numeral, and this string be a > stored procedure that returned an expected known value. This way would be a > 100% method of knowing the SQL server is up and more importantly > "responding"... > > Just my two cents.. > > Joe > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Webservices and Queries
Hi Fred, Thanks very much for your reply. I should have replied to you sooner when you first mentioned your success by setting your clock to non-UTC. I did try that and it didn't resolve the problem. One additional piece of information that should be a clue to someone is that we see exactly the same behavior when the queries are run against a Mid-tier server running on Solaris. That Mid-tier is actually running on the same real hardware as the AR server. So that sort of eliminates the whole Linux-VM question altogether. We are testing using SoapUI. Still hoping to find someone in the EDT timezone who can confirm what I am seeing. Thanks again. Larry On Tue, Jun 12, 2012 at 2:48 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > We had the same sort of problem with our webservice calls. The problem we > found was the physical clock and the clock in the Virtual Linux session > were set differently. We had to set our clock to not be UTC in the RedHat > server, and the problem went away. > > Here is a page that describes it better: > http://tldp.org/HOWTO/TimePrecision-HOWTO/set.html > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Monday, June 11, 2012 8:25 AM > To: arslist@ARSLIST.ORG > Subject: Re: Webservices and Queries > > ** > Hi Folks, > > I could use some help from the community to verify that the information I > am receiving from BMC support is correct. The issue has to do with queries > issued through a web service running against an ARS form. Specifically, the > query includes a clause like this: > > 'datemodified' >= "05/30/2012 > 20:00:00" > > compared to a query like this: > > 'datemodified' >= "05/30/2012 20:00:00 > EDT" > > The AR server, Mid-tier server and the client are all operating in the US > Eastern time zone with their date/times set to local time. My contention is > that these two queries should produce the same result. However, in my > system, they do not. The query containing the explicit specification of the > timezone (EDT) produces the correct result. The other does not. > > It should be noted that the query which does not include the timezone > information DID produce the correct result prior to the onset of DST in the > US. Unfortunately, I can not say what would have been returned before the > onset of DST if "EST" had been included in the query since we were not in > the habit of specifying time zone information until this problem was > discovered. > > I am looking for someone who has a similar environment and is willing to > run a test for me to see if you get the expected results on you system. > Ideally, I would like to see the results from a client/server/Mid-tier > combination in the Eastern time zone of the US operating under DST. The > other specifics of my system as listed below. > > The following is BMC support explanation of why the results I am seeing > are the expected behavior: > > The below is a confirmation from R&D about the statements I've provided > you with earlier: > "You have to specify a timezone, otherwise there's no way for arserver to > know what time you mean by 05/30/2012 10:00:00. MT and the Java API just > pass the query through as a string, they don't try to interperate what that > date/time value represents as far as timezone is concerned." > > Thanks for any assistance you can provide. > Larry > > Configuration: > > AR Server 7.6.03 Patch 002 201107191530 on Solaris 10 > Oracle 11.2.0.2.0 - 64bit on Solaris 10 > Mid-tier: >Server: 7.6.04 SP2 Hotfix 121511 >Tomcat: Apache Tomcat/6.0.32 >OS: Linux >JAVA: 1.7.0_02 > > > Larry Robinson > Remedy Developer/Administrator > NC State University > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Webservices and Queries
Hi Folks, I could use some help from the community to verify that the information I am receiving from BMC support is correct. The issue has to do with queries issued through a web service running against an ARS form. Specifically, the query includes a clause like this: 'datemodified' >= "05/30/2012 20:00:00" compared to a query like this: 'datemodified' >= "05/30/2012 20:00:00 EDT" The AR server, Mid-tier server and the client are all operating in the US Eastern time zone with their date/times set to local time. My contention is that these two queries should produce the same result. However, in my system, they do not. The query containing the explicit specification of the timezone (EDT) produces the correct result. The other does not. It should be noted that the query which does not include the timezone information DID produce the correct result prior to the onset of DST in the US. Unfortunately, I can not say what would have been returned before the onset of DST if "EST" had been included in the query since we were not in the habit of specifying time zone information until this problem was discovered. I am looking for someone who has a similar environment and is willing to run a test for me to see if you get the expected results on you system. Ideally, I would like to see the results from a client/server/Mid-tier combination in the Eastern time zone of the US operating under DST. The other specifics of my system as listed below. The following is BMC support explanation of why the results I am seeing are the expected behavior: The below is a confirmation from R&D about the statements I've provided you > with earlier: > "You have to specify a timezone, otherwise there's no way for arserver to > know what time you mean by 05/30/2012 10:00:00. MT and the Java API just > pass the query through as a string, they don't try to interperate what that > date/time value represents as far as timezone is concerned." Thanks for any assistance you can provide. Larry Configuration: AR Server 7.6.03 Patch 002 201107191530 on Solaris 10 Oracle 11.2.0.2.0 - 64bit on Solaris 10 Mid-tier: Server: 7.6.04 SP2 Hotfix 121511 Tomcat: Apache Tomcat/6.0.32 OS: Linux JAVA: 1.7.0_02 Larry Robinson Remedy Developer/Administrator NC State University On Mon, Apr 30, 2012 at 4:19 PM, L G Robinson wrote: > Hi Folks, > > Sorry to be late to this party... I have an open issue with ColumnIT > regarding DST and web services. From my observation, it appears that the > web service assumes EST instead of EDT if no timezone information is > present in the query (I'm in NC). Here is a more complete description of my > issue: > > > We have discovered a problem with our Mid-tier servers, possibly related > to the onset of Daylight Saving Time. > > We have implemented several web service calls, some of which accept > arbitrary queries. If a query includes a date/time component, the returned > results are not correct. For example: > > 'datemodified' >= "03/30/2012 > 10:00:00" > > does not return any results, even though there are records which match the > specified criteria. However, if the query is changed to: > > 'datemodified' >= "03/30/2012 10:00:00 > EDT" > > then the expected results are returned. > > This problem only presents with the web service calls. Similar queries > made to the same server using the Windows User tool and through the > Mid-tier web interface all return the expected results without having to > append the "EDT" to the date/time string. > > I have confirmed the system date/time on the Mid-tier server to be correct. > > AR Server 7.6.03 Patch 002 201107191530 > Mid Tier Version: 7.6.04 SP2 Hotfix 121511 > Apache Tomcat/6.0.32 > Java Version: 1.7.0_02-b13 > OS: RH Linux 2.6.32-220.7.1.el6.x86_64 > > Hope this is helpful. > Larry > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
Hi Axton, I have Used Misi's excellent RRR|Log analysis tool to analyse 24 hours worth of combined API and SQL logs. For the entire 24 hour period, I found a small number of SQL commands that do take several seconds to execute. However, in all cases, these SQL queries are the result of poorly defined advanced searches initiated by my users. The great majority of the SQL commands issued against this table use indexes and complete in well under a second, usually on the order of 0.00xx seconds. But still, I am wondering if longer-running SQL transactions can account for the gradual degradation of performance over time. I can understand that the user who issues the poorly-designed advanced search will suffer the delay resulting from inefficient SQL, but do you believe that it will affect system performance in general, assuming there are enough threads, etc? Do you have an opinion on that? Thanks for any insights. Larry On Thu, May 17, 2012 at 12:05 PM, Axton wrote: > ** Look at your sql logs. Do you see a long delay between the time the > select is issued and the results returned? If so, that would indicate to > me that the SQL is the cause of the slowness. Start there, then cross the > next bridge when you get to it. > > Axton Grams > > On Thu, May 17, 2012 at 10:32 AM, L G Robinson wrote: > >> ** Hi Terry, >> >> That is a good suggestion. I have done an execution plan for the SQL in >> question, but I have not done a before & after for the same SQL. >> >> Thanks. >> Larry >> >> On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma >> wrote: >> >>> ** >>> Hi Larry >>> >>> Sounds strange... >>> >>> I have seen SQL queries degrade in performance over time depending on >>> the query execution plan, the amount of change to the data, and the >>> statistics that are utilized by the query engine, but it doesn't describe >>> why re-starting arsystem fixes the problem. However, here is a suggestion, >>> >>> 1. Regenerate your db statistics. Your dba will know how to do this. >>> >>> 2. Pick some sql that your app is generating and is a source of your >>> concern. Run it natively via the appropriate sql tool. Turn on the query >>> execution plan and statistics output for later comparison and save the >>> results. >>> >>> 3. When the system starts to slow down, redo 2 above and compare output. >>> if they are the same (or close to it), then it is conclusively not the DB >>> >>> This won't solve the problem,.but it will help you isolate it... >>> >>> Terry >>> >>> >>> Sent from my mobile device.. >>> >>> >>> >>> L G Robinson wrote: >>> >>> >>> ** Hi Folks, >>> >>> Me again... still struggling with this Mid-tier performance issue. >>> ColumnIT (our support provider) has escalated the issue to BMC and I would >>> appreciate a "second opinion" on the information I have received from BMC >>> back line engineering support. I would like to know if you believe the >>> explanation provided makes sense from a technical standpoint. I consider >>> many of you to be quite knowledgable about the inner working of the AR >>> System and it's interactions with the underlying DB, much more so than >>> myself. >>> >>> Background: >>> >>> BMC says that the performance issue is the result of poor SQL initiated >>> by workflow that we have created. Specifically, they contend that there are >>> SQL calls that are resulting in table scans of the table in question. I >>> disagree because my log analysis (thanks Misi) does not show any such SQL. >>> But that is not the part I want your opinion about. This is their >>> explanation: >>> >>> ==> We have verified the SQL statements and SQL queries from X-calls >>> form are using Like operator which causes oracle to go for a full table >>> scan instead of using indexes which introduces delays. >>> >>> Given their explanation, I asked the following followup question: >>> >>> - If the performance problem is the result of "SQL queries which are >>> getting fired on that form are taking too long and not using indexes which >>> is resulting in delays and performance issues", why is it that the problem >>> is not apparent after the AR system is started and only appears after the >>> system has been up and running for a period of time? My expectation would >>> be that performance issues that
Re: ARS 7.6.03 performance problems
Hi Terry, That is a good suggestion. I have done an execution plan for the SQL in question, but I have not done a before & after for the same SQL. Thanks. Larry On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma wrote: > ** > Hi Larry > > Sounds strange... > > I have seen SQL queries degrade in performance over time depending on the > query execution plan, the amount of change to the data, and the statistics > that are utilized by the query engine, but it doesn't describe why > re-starting arsystem fixes the problem. However, here is a suggestion, > > 1. Regenerate your db statistics. Your dba will know how to do this. > > 2. Pick some sql that your app is generating and is a source of your > concern. Run it natively via the appropriate sql tool. Turn on the query > execution plan and statistics output for later comparison and save the > results. > > 3. When the system starts to slow down, redo 2 above and compare output. > if they are the same (or close to it), then it is conclusively not the DB > > This won't solve the problem,.but it will help you isolate it... > > Terry > > > Sent from my mobile device.. > > > > L G Robinson wrote: > > > ** Hi Folks, > > Me again... still struggling with this Mid-tier performance issue. > ColumnIT (our support provider) has escalated the issue to BMC and I would > appreciate a "second opinion" on the information I have received from BMC > back line engineering support. I would like to know if you believe the > explanation provided makes sense from a technical standpoint. I consider > many of you to be quite knowledgable about the inner working of the AR > System and it's interactions with the underlying DB, much more so than > myself. > > Background: > > BMC says that the performance issue is the result of poor SQL initiated by > workflow that we have created. Specifically, they contend that there are > SQL calls that are resulting in table scans of the table in question. I > disagree because my log analysis (thanks Misi) does not show any such SQL. > But that is not the part I want your opinion about. This is their > explanation: > > ==> We have verified the SQL statements and SQL queries from X-calls form > are using Like operator which causes oracle to go for a full table scan > instead of using indexes which introduces delays. > > Given their explanation, I asked the following followup question: > > - If the performance problem is the result of "SQL queries which are > getting fired on that form are taking too long and not using indexes which > is resulting in delays and performance issues", why is it that the problem > is not apparent after the AR system is started and only appears after the > system has been up and running for a period of time? My expectation would > be that performance issues that were the result of inefficient SQL would be > apparent all of the time. Please explain how the inefficient SQL results in > a gradual degradation in performance over time. > > This is the BMC response. Does this make sense to you? > > ==> After the AR server is restarted data caching is done while AR server > is restarted which takes less time however when data increases in the form > over time so resource requirements will also increase as well as queries > will change based on the amount data fetched and what parameters are being > passed and any limitations we have implemented for fetching number of > records. > > This does not strike me as the type of response one would expect from back > line engineering staff. > > Thanks for your thoughts. > Larry > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a "second opinion" on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: ==> We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of "SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues", why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? ==> After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Webservices and Queries
Hi Fred, I did as you suggested below but it did not resolve the problem. I also contacted one of the folks who maintain our virtual infrastructure to ask if the clock on the actual hardware was set to UTC or to local time. He said that he thought it was set to UTC and went on to say that he didn't really see how it could matter since the guest VM doesn't really have any direct access to the real hardware. He indicated that the VM only sees the abstracted environment, which he indicated should be presenting UTC. I rebooted the VM and checked the BIOS settings. The clock was set to UTC. Thanks for any other suggestions or insights you might have. Larry On Tue, May 1, 2012 at 10:02 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > It is hard for anyone to tell without access to the hardware CMOS > directly, but since you are off by an hour in the web services (and that is > the exact same problem we had) I would believe that your hardware is not > running as UTC/GMT. From what I have heard it is common to have the > physical machine set in a local timezone when one of the virtual machines > (or possibly could be) is a Windows OS. > > I would recommend changing UTC to false in the /etc/sysconfig/clock file > and running > /sbin/hwclock --hctosys > /sbin/hwclock --systohc > > Fred > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Webservices and Queries
Hi Fred, Thanks for the tip about hwclock. I had no idea. My Mid-tier (and thus webservices) are running on a Linux VM. Can you tell from the following if my system is set correctly? I am unable to locate any hardware clock settings on the VSphere client that I have access to, but I have limited permissions. cat /etc/sysconfig/clock ZONE="America/New_York" UTC=true /sbin/hwclock -ru Mon 30 Apr 2012 07:55:32 PM EDT -0.650259 seconds cat /etc/adjtime 0.00 1316200184 0.00 1316200184 UTC Thanks. Larry On Mon, Apr 30, 2012 at 5:17 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > Are you on a Virtual environment? We ran across a Linux bug when the > hardware clock thought it was GMT and the system clock thought it wasn’t.* > *** > > ** ** > > You can check by: cat /etc/sysconfig/clock > > And seeing if UTC is true or false > > ** ** > > If it is set true and the hardware clock isn’t GMT then the admin needs to > update the /etc/sysconfig/clock file and re-sync the time with > >/sbin/hwclock --systohc > > ** ** > > ** ** > > Fred > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Webservices and Queries
Hi Folks, Sorry to be late to this party... I have an open issue with ColumnIT regarding DST and web services. From my observation, it appears that the web service assumes EST instead of EDT if no timezone information is present in the query (I'm in NC). Here is a more complete description of my issue: We have discovered a problem with our Mid-tier servers, possibly related to the onset of Daylight Saving Time. We have implemented several web service calls, some of which accept arbitrary queries. If a query includes a date/time component, the returned results are not correct. For example: 'datemodified' >= "03/30/2012 10:00:00" does not return any results, even though there are records which match the specified criteria. However, if the query is changed to: 'datemodified' >= "03/30/2012 10:00:00 EDT" then the expected results are returned. This problem only presents with the web service calls. Similar queries made to the same server using the Windows User tool and through the Mid-tier web interface all return the expected results without having to append the "EDT" to the date/time string. I have confirmed the system date/time on the Mid-tier server to be correct. AR Server 7.6.03 Patch 002 201107191530 Mid Tier Version: 7.6.04 SP2 Hotfix 121511 Apache Tomcat/6.0.32 Java Version: 1.7.0_02-b13 OS: RH Linux 2.6.32-220.7.1.el6.x86_64 Hope this is helpful. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: I think I just found a sweet bug on character fields that are Edit Masked...
Hi Joe, I have submitted a bug report. We get our support from ColumnIT, so they will have to reproduce it for themselves and then, hopefully, send it on to BMC. Just FYI, I tried it on the Mid-tier, just to see what happened. It was a little better... the expand box was visible when it shouldn't have been. However, as long as the field was not expanded, the masking was displayed correctly, regardless of focus. So slightly better, but still broke. MT: 7.6.04 SP2 201110080614 on Linux w/ Tomcat. Hope this is helpful. Larry On Tue, Apr 24, 2012 at 12:34 PM, Joe Martin D'Souza wrote: > ** > > Thanks.. I’ll appreciate that actually.. > > Joe > > *From:* L G Robinson > *Sent:* Tuesday, April 24, 2012 12:20 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Subject:* Re: I think I just found a sweet bug on character fields that > are Edit Masked... > > ** > Hi Joe, > > I have no immediate need for that functionality, but I'll be happy to file > the bug report anyway, just to help give it some traction. > > Hope this is helpful. > Larry > > On Tue, Apr 24, 2012 at 12:07 PM, Joe Martin D'Souza wrote: > >> ** >> >> Larry, >> >> Thank you for responding.. >> >> Mine is on the right of the field too in exactly the same spot that it is >> when its visible.. What I meant was look at the left hand side of the >> screen shot (left of the Properties pane).. On the screen shots that I >> tried to attach the field was on the left of the Properties pane >> >> So basically we are experiencing the exact same issue and you being on >> Patch 2, shows that this issue wasn’t resolved for at least those couple of >> patches – I am still on the base release version of 7.6.03 at this site I >> am working at.. >> >> So this also shows that its not just my system that’s somehow hosed >> (which often is the case with all the stunts I try – just kidding).. both >> of us are seeing the exact same issue.. >> >> I submitted a ticket to BMC yesterday, and if you intend to do the same, >> maybe we can exchange ticket numbers and ask them to relate the two so it >> starts getting a higher priority to get fixed >> >> Joe >> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: I think I just found a sweet bug on character fields that are Edit Masked...
Hi Joe, I have no immediate need for that functionality, but I'll be happy to file the bug report anyway, just to help give it some traction. Hope this is helpful. Larry On Tue, Apr 24, 2012 at 12:07 PM, Joe Martin D'Souza wrote: > ** > > Larry, > > Thank you for responding.. > > Mine is on the right of the field too in exactly the same spot that it is > when its visible.. What I meant was look at the left hand side of the > screen shot (left of the Properties pane).. On the screen shots that I > tried to attach the field was on the left of the Properties pane > > So basically we are experiencing the exact same issue and you being on > Patch 2, shows that this issue wasn’t resolved for at least those couple of > patches – I am still on the base release version of 7.6.03 at this site I > am working at.. > > So this also shows that its not just my system that’s somehow hosed (which > often is the case with all the stunts I try – just kidding).. both of us > are seeing the exact same issue.. > > I submitted a ticket to BMC yesterday, and if you intend to do the same, > maybe we can exchange ticket numbers and ask them to relate the two so it > starts getting a higher priority to get fixed > > Joe > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: I think I just found a sweet bug on character fields that are Edit Masked...
Hi Joe, I was able to reproduce the behavior that you describe below on my 7.6.03 Patch 002 201107191530 system. The only difference I see from what you described is the "invisible" expand box that you described as being on the left. Mine is on the right... just where the "real" expand box would be, if it was there. Client is WUT 7.6.04 SP1. Hope this is helpful. Larry On Mon, Apr 23, 2012 at 5:00 PM, Joe Martin D'Souza wrote: > ** >I used the Dev Studio of the same version as the AR Server to create > that field and make changes to it .. I am on 7.6.03 (no patch). My WUT and > Dev Studio too are on the same version no patch. > > I’m going to try to attempt to attach 5 screen shots and hope they make > it through to the list. I’ll also take the liberty to email them to you > Doug, and Jason Miller and Keith Sinclair, as I am expecting the > attachments to not make it to the list.. > > The property on the dev studio is un-editable once set to edit masked.. > however it’s the behavior of the field both on the dev studio as well as > the WUT that is a concern Hopefully the screen shots will help explain > what words may not explain that clearly.. > > Find 5 screen shots attached in a zip file called Bug.zip > > *EditMask01.gif* > This is where I attempted to create a character field of length 20 with > some Default value “New Field Edit Mask” on it. The Expand Box as you can > see at the time of creation is Default, and the Display Type is Edit... > Notice the default value on the field as well as the non existence of an > expand box.. With all these settings I saved the form.. The field got > created. > > *EditMask02.gif* > Here is where I changed the Display Type to Edit Masked and immediately as > Jason pointed out on the list, the Expand Box gets grayed out, and its > value changes to Hide. Also notice the field on the Dev Studio, where the > default value gets masked to asterix’s.. Also notice that there is no > Expand Box... So far very good > > *EditMask03.gif* > Here is where things start to get ugly.. I changed the length of the field > from 20 to 255. Notice that the Expand Box attribute is still grayed out. > And that its value is Hide. Great (just as what Jason said about 7.6.04)... > But take a look on the left hand side. There is an ‘invisible’ expand box > on the field on the dev studio itself.. I’m kind that way, and that doesn’t > bother me really as it appears like the field is still masking its contents > with all asterix’s which is all I want – I don’t really care whether or not > the Expand Box shows despite it being set to Hide and its attribute > grayed I saved these settings.. With the settings saved with the field > length at 255, lets look at what we see on the WUT... > > *EditMask04.gif* > When the focus is on another field, things look ‘almost’ good on the field > that has its Edit Mask attribute turned on.. So long as the focus is not on > the Edit Masked field. I say ‘almost’ because you already see the first > signs of trouble. The expand box is clearly visible... > > *EditMask05.gif* > Here you can see that the moment the focus is on the edit mask field, I > can see the text as clear text. The mask disappears.. > > I haven’t yet tested this on the web as I just noticed this like 5 > minutes before posting to the list. > > Cheers > > Joe > > PS: On my first attempt, the attachments didn’t get through.. and it > rejected my posting.. so attempting it without attachments and if you are > interested in the attachments to make sense of this email. please request > them from me and I will be more than happy to send > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
Hi Axton, Thanks for reading and for your suggestions. I have done a little bit of JVM monitoring. I used jconsole, since it was already there and was easy enough to startup. I watched the various heaps over a weeks time and I didn't see anything alarming. GC seemed to be happening regularly and doesn't seem to to take very long. These are my JAVA_OPTS: -XX:MaxPermSize=256m -Xms2048m -Xmx2048m -XX:+UseCompressedOops -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:NewRatio=3 Apache Tomcat/6.0.32 JVM: Sun 1.6.0_31-b04 Linux: 2.6.32-131.17.1.el6.x86_64 Your question about how the Mid-tier servers connect to the AR server was a good one. I believe I am using proxy connections with the default of 80 as a max. I was using the default queues but I am wondering if there would be any advantage to setting up a dedicated queue for the Mid-tier servers to hit. I think I'll give that a try to see if anything changes. Probably won't, since RRR|Log indicates no thread contention. But maybe those threads are managed differently. Do you agree that using proxy is more efficient or would you expect better performance if that was disabled? If it is disabled, does the Mid-tier make a dedicated connection to the AR server for each Mid-tier user? I'm a little vague on how that works and I was not able to find much in the documentation about it. Any pointers on where to learn more about that? catalina.out shows the following settings: - jrpcMode: true - jniLoadMode: 1 - apiRecordingMode: 0 - useConnectionPooling: true - maxProxiesPerServer: 80 - idleConnectionsPerServer: 5 - connectionTimeout: 0 - connectionLifespan: 0 - timeUnit: MINUTES - minimumSupportedServerRpcVersion: 12 - connectionMaxRetries: 1 - timeLagBetweenRetriesMillSec: 100 - stringizeFieldAssignments: false - stringizeSetIfQualification: false - useLegacyQualParser: false - useLegacyAssignParser: false - useLegacyQualFormatter: false - useLegacyAssignFormatter: false - UsePooling: true - , Pool setting info: , # maxProxyPerServer- 80, # idleConnectionsPerServer- 5, connectionTimeout setting- 00:00:00, connectionLifespan setting- 00:00:00 - Currently, connection pooling true - Client adjusts connection variables maximumPoolSize = 80 minIdleProxySize = 5 connectionTimeout = 0 timeUnit = null - Client sets useConnectionPooling to : true - Root WebApplicationContext: initialization completed in 2594 ms - Currently, connection pooling true - Client sets connection limits per server to :80 - UsePooling: true - , Pool setting info: , # maxProxyPerServer- 80, # idleConnectionsPerServer- 5, connectionTimeout setting- 00:00:00, connectionLifespan setting- 00:00:00 - Client sets useConnectionPooling to : true - Connects to ars00srv:33000 through com.bmc.arsys.api.ProxyJRpc@7952506e - Connects to ars00srv:33000 through com.bmc.arsys.api.ProxyJRpc@60e1e567 - Connects to ars00srv:33000 through com.bmc.arsys.api.ProxyJRpc@477588d5 - Connects to ars00srv:33000 through com.bmc.arsys.api.ProxyJRpc@756a7c99 Thanks again for your help. Larry On Thu, Mar 29, 2012 at 11:03 AM, Axton wrote: > ** Well constructed post. It gives me a lot to work with when thinking > about your problem. I applaud you for that. > > The interesting thing is that a restart of either the Tomcat servers or > the ARServer fixes your issue. This throws an unknown variable into the > mix (a monkey wrench, of sorts). > > If you are inclined to dig into the Tomcat performance, I suggest enabling > JMX and hooking up a JMX monitoring tool to the Tomcat instances (I prefer > jvisualvm, which is part of the jdk) to see what the server is busy doing > and where the memory allocation is going. You might find that the CPU time > required for garbage collection gets higher and higher. If this is the > case, depending on the configuration of the Linux VMs (cpu count, memory > size, etc.) that house Tomcat, you may be able to play with the GC settings > to alleviate this. It may point you to some issue within the midtier that > you can't address, but if you know where the problem is you can work with > support. > > If using JMX, you will want to use a local jvisualvm so that you can get > cpu profiling statistics. > > You might also look at how the midtier connects to the arserver. Do you > use a proxy connection? Do you use a private queue? If you use a private > queue, how many threads does it have and are those threads congested? > > Axton Grams > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
Hi Folks, I wrote to you a couple of months ago regarding a performance problem I am experiencing with my 7.6.03 Remedy system. Specifically, the problem is with my Mid-tier servers in that their performance degrades throughout the day. I have taken to restarting the arserver processes via cron every morning at 5:00 AM. This restores normal performance, but then the decline begins again and the Mid-tier service will eventually become unusable if I don't do the restart. The arserver is running on a Solaris 10 box with 16 Gb of real memory. It is running: AR Server 7.6.03 Patch 002 201107191530 The Midtier environment is 7.6.04 running on a bank of four RH Linux VMs running Tomcat behind a LVS (keepalived) load balancer. I have tried a variety of JAVA and Tomcat versions with several VM memory configurations and followed all of the BMC-published performance tuning recommendations. The application is a home-grown help desk application that we have been running here at NC State for years. We do not run any BMC out-of-the-box applications. In mid-December, we transitioned from ARS 5.1.2 to 7.6.03. We did not upgrade the existing system, we build a new system from the ground up, importing workflow and data. As we were not running Mid-tier prior to deploying 7.6, we have no baseline to compare to. The problem: When the system is performing correctly, one is able to initiate a search and click through the items returned in the browser with sub-second load times as you move from record to record. As the day progresses, the same search returns the same results but the time needed to move from record to record increases. By 5 PM (12 hours after the restart) the sub-second response has increased to approximately two seconds. If I test again at 11 PM, the time has increased further. Note that the performance of the Windows User tool remains constant and does not exhibit the performance degradation described for the Mid-tier. As mentioned above, the action that restores performance is to stop and start the arserver processes using the arsystem script. I have a cron-invoked script that stops the system, waits about 45 seconds for things to settle down, and then starts it up again. The hardware is not rebooted... just restarting the arserver. The other action that restores performance is to restart the Tomcat server process. Things we have tried so far: - Tuning the Mid-tier server and environment including increasing VM RAM, adjusting heap sizes, GC methods and some Mid-tier tweaking including pre-fetch. - Used alternative memory management on the Solaris server by adding the following to the arsystem script: LD_PRELOAD=libumem.so; export LD_PRELOAD. I have not yet tried to use the libumem tools to see if there really is a memory leak. - Patched the arserver with 7.6.03 Patch 2 which was purported to have a number of fixes related to memory leaks. Observations: - Since restarting the arserver seems to restore performance, I am inclined to think that the problem lies with the arserver. My first thought was a memory leak and I observed that the memory utilization of the arserverd process does steadily increase throughout the day. I don't know if this is normal or not. Note that this steady increase in memory utilization persists, even after applying Patch 2. - I have used Misi's very fine RRR|Log tools to check on the thread configuration. Based on RRR|Log, the thread configuration is quite adequate for the load that is generated during normal use. - To eliminate the network as a factor, I started a Tomcat/Mid-tier instance on the same Solaris box that is hosting the arserver processes. Even though this Mid-tier server is not in the public pool and no one is accessing it except for me, it also displays the same performance profile as the public pool Tomcat servers. - Restarting the Mid-tier service (by restarting Tomcat) also seems to restore performance. Obvioulsy, I am not doing this on the public pool but I have done it on a test Tomcat servers. - I have done some detailed analysis of API and SQL logs, comparing the times for a repeatable set of transactions in the morning and in the evening. The evening logs were captured during a time of minimal use. I observed the following: + The timings of the individual SQL commands were roughly the same across both log samples. This was measured by subtracting the SQL call beginning time from the SQL call ending time. + The timings of the individual API calls were also roughly the same across both log samples. In the cases where there was a significant difference, the afternoon times exceeded the morning times. This was measured by subtracting the API call beginning time from the API call ending time. + I observed the most significant difference in the timings between the evening and the morning in the time interval BETWEEN the API calls. That is, the time from the end of one API call until the beginning of the next API call (off hours with
Logging out of a Web service
Hi Folks, It's me again, with another Remedy Web service question... So I built these web services and my customers are using them successfully, in spite of the inherent inefficiencies that I have observed in the get-list calls. Some clever folks here have built a PHP API around the Web services to give our PHP users an easy way to call the various services. It's all working as intended. My questions revolves around "logging out" of a Web service. Since the login/password information is supplied with each call, I don't see any way for the Web service user to explicitly logout. When I look at the Tomcat Web Application Manager, I see a large number of sessions associated with the Mid-tier application... much larger than I expect. I believe that I am seeing a "session" for each Web service call. Is it the case that since there is no explicit logout, Tomcat will hold onto the session until it times out? When using the Mid-tier directly, it appears that there is only one session per user and it stays until the user logs out or times out. Is there a way for the Web service users to reconnect to their previous session, if one exists? Is there a way for the Web service user to explicitly logout so as to end the session? Have I totally missed the boat? Thanks. Larry Larry Robinson Remedy Developer / Administrator NC State University Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Question about get-list web service
Food for thought... thanks Misi. Larry On Fri, Jan 6, 2012 at 11:29 AM, Misi Mladoniczky wrote: > Hi, > > The only way I can think of is to return multiple data in a single big > character field. > > It is only searches (GetList*) that can return multiple things in Remedy. > > To do this, you can make a GetEntry call to retrieve a single entry, the > same record each time. Then have a Get-Entry-Filter that calls your your > service. > > The problem is that it is hard to send any input to this call. You might > need to do a two-step thing and first do a CreateEntry with input > parameters and then a GetEntry to retrieve the result... > >Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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, > > > > I think maybe I did not phrase my question very well. Let me try again... > > > > Based upon what I see as the SQL transactions that get generated when > > using > > a get-list web service call, I am seeking alternatives. I was wondering > if > > it is possible to create a "service" web service call that will return > > multiple records, as the get-list web service call does. > > > > I haven't worked out all of the details yet, but I was hoping that by > > using > > a service web service call, I could trigger a filter that would do the > > search and somehow return multiple records back to the caller. It is the > > "return multiple records" part that I am specifically asking about. All > of > > the filter actions that the service could potentially invoke seem to want > > to return a single record. > > > > Does this even make sense? > > > > Thanks. > > Larry > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Diary field weirdness in Mid-tier
Hi Ravindra, I did install SP2 and you are correct, this problem is resolved in SP2... mostly. I have found some additional issues with the fix that was provided. Using Mid-tier 7.6.04 SP2, I see the following: - Multiple lines added to the diary field do in fact get saved as expected, but upon saving, the lower portion of the diary field does not get cleared out. - Further to the above, the text that was input into the diary field persists in the bottom portion of the diary field even after selecting a different record from the browser. I observed this behavior in Firefox, Safari and Chrome. I know that Chrome is not officially supported, but it seems to work quite well in all other aspects and seems to me to be the "most peppy" of all of the browsers that I use routinely. Thanks. Larry On Fri, Jan 6, 2012 at 9:54 AM, Hamsagar, Ravindra < ravindra_hamsa...@bmc.com> wrote: > ** > > Larry, > > ** ** > > Sorry for the late reply. > > Yes it was a bug which was existing in Midtier 7.6.04 and got FIXED in > midtier 7.6.04 SP2 and works fine with Mozilla Firefox. > > ** ** > > Thanks, > > Ravindra > > ** ** > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > > ** ** > > ** ** > > *From:* Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] *On Behalf Of *L G Robinson > *Sent:* Wednesday, December 21, 2011 8:25 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Diary field weirdness in Mid-tier > > ** ** > > ** Thanks for the confirmation Misi. > > ** ** > > Ravindra, > > ** ** > > Are you in agreement that this is a bug? If so, do you know if it is > corrected in SP2 as Misi asked? > > ** ** > > Thanks. > > Larry > > On Wed, Dec 21, 2011 at 3:28 AM, Hamsagar, Ravindra < > ravindra_hamsa...@bmc.com> wrote: > > > Went through the below mail and say that it’s a issue. > > Whenever we sent the Row value in Dev Studio, that is just to display when > you access the form object dynamically through midtier. Life if you set Row > value as 2, when access the form with midtier diary field will display > default for 2 rows entry, but you can expand the diary field and can enter > more number of rows and should be saved successfully, irrespective of > browser type > > Thanks, > Ravindra > > 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. > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Question about get-list web service
Hi Misi, I think maybe I did not phrase my question very well. Let me try again... Based upon what I see as the SQL transactions that get generated when using a get-list web service call, I am seeking alternatives. I was wondering if it is possible to create a "service" web service call that will return multiple records, as the get-list web service call does. I haven't worked out all of the details yet, but I was hoping that by using a service web service call, I could trigger a filter that would do the search and somehow return multiple records back to the caller. It is the "return multiple records" part that I am specifically asking about. All of the filter actions that the service could potentially invoke seem to want to return a single record. Does this even make sense? Thanks. Larry On Thu, Jan 5, 2012 at 6:01 AM, Misi Mladoniczky wrote: > Hi, > > A call to a web-service get-list search does not trigger filters. In other > words, it can not trigger a filter that returns anything. Or did I miss > your point? > >Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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 Folks, > > > > Happy holidays to those of you who celebrate. > > > > I am still struggling with the performance problems associated with a > > "get-list" web service. Does anyone know if it is possible to return > > multiple records from a filter that is invoked by a "service" type of > > web service? > > > > And Misi... regarding the behavior mentioned below, all of the > > generated SQL commands are part of a single ARXMLGetEntry API call. I > > sure wish we had a little move control over this. > > > > Thanks. > > Larry > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
rv -i /local/b S root 21007 21006 0 40 20 698432 707112? 05:00:39 ? 23:39 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 698432 707112? 05:00:39 ? 23:47 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 702528 711208? 05:00:39 ? 24:30 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 706624 715304? 05:00:39 ? 24:43 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 710720 719400? 05:00:39 ? 24:50 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 710720 719400? 05:00:39 ? 24:57 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 714816 723496? 05:00:39 ? 25:11 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 714816 723496? 05:00:39 ? 25:18 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 723008 731688? 05:00:39 ? 25:28 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 723008 731688? 05:00:39 ? 25:41 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 723008 731688? 05:00:39 ? 25:49 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 727104 735784? 05:00:39 ? 25:56 ./arserverd -s ars00srv -i /local/b O root 21007 21006 0 40 20 731200 739880 05:00:39 ? 26:08 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 731200 739880? 05:00:39 ? 26:16 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 735296 743976? 05:00:39 ? 26:22 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 739392 748072? 05:00:39 ? 26:35 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 739392 748072? 05:00:39 ? 26:55 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 743488 752168? 05:00:39 ? 27:04 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 747584 756264? 05:00:39 ? 27:19 ./arserverd -s ars00srv -i /local/b Thanks for any further insights. Larry On Fri, Dec 30, 2011 at 2:51 PM, patrick zandi wrote: > ** https://communities.bmc.com/communities/docs/DOC-18162 > > What Patch you on??? > > > On Fri, Dec 30, 2011 at 1:35 PM, L G Robinson wrote: > >> ** Hi Phil, >> >> >> I have taken a few snapshots of the arserverd during the day. Looks like >> the memory usage is slowly creeping up. The slowdown is not too bad yet, >> but noticeably slower than immediately following the restart: >> >> S UID PID PPID C PRI NI RSS SZWCHANSTIME TTY >> TIME CMD >> S root 21007 21006 0 40 20 415296 423976 ? 05:00:39 ? >> 5:35 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 419392 428072 ? 05:00:39 ? >> 6:33 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 439880 448560 ? 05:00:39 ? >> 8:03 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 464456 473136 ? 05:00:39 ? >> 9:30 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 468552 477232 ? 05:00:39 ? >> 9:41 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 468552 477232 ? 05:00:39 ? >> 9:45 ./arserverd -s ars00srv -i /local/b >> S root 21007 21006 0 40 20 472648 481328 ? 05:00:39 ? >> 9:52 ./arserverd -s ars00srv -i /local/b >> >> Is this normal? Should the memory usage be increasing like this? The >> above is over a three hour period. >> >> Thanks. >> Larry >> > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARS 7.6.03 performance problems
Hi Phil, I have taken a few snapshots of the arserverd during the day. Looks like the memory usage is slowly creeping up. The slowdown is not too bad yet, but noticeably slower than immediately following the restart: S UID PID PPID C PRI NI RSS SZWCHANSTIME TTY TIME CMD S root 21007 21006 0 40 20 415296 423976 ? 05:00:39 ? 5:35 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 419392 428072 ? 05:00:39 ? 6:33 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 439880 448560 ? 05:00:39 ? 8:03 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 464456 473136 ? 05:00:39 ? 9:30 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 468552 477232 ? 05:00:39 ? 9:41 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 468552 477232 ? 05:00:39 ? 9:45 ./arserverd -s ars00srv -i /local/b S root 21007 21006 0 40 20 472648 481328 ? 05:00:39 ? 9:52 ./arserverd -s ars00srv -i /local/b Is this normal? Should the memory usage be increasing like this? The above is over a three hour period. Thanks. Larry On Fri, Dec 30, 2011 at 7:16 AM, Murnane, Phil wrote: > Larry: > > How much memory is the server demon using before the slowdown and then during the slowdown? > > --Phil > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Thursday, December 29, 2011 19:37 > To: arslist@ARSLIST.ORG > Subject: ARS 7.6.03 performance problems > > Hi Folks, > > I am experiencing a performance problem on my 7.6.03 AR System. The problem gets worse over time. When the server is started, performance is fine. For example, it takes about one second to load a particular record in the Windows client and about two seconds to load the same record in the Mid Tier. However, if I load the same record later in the day, maybe after the server has been running for 12 hours, the time to load the same record is about twice as long. > > If I restart the server process, response time returns to the original timings. This behavior is consistent whether the system is heavily loaded or lightly loaded, but the degradation seems to happen faster if the system is heavily loaded > > The arserverd is running on a Sun SPARC-Enterprise-T5120 with 16 Gb of RAM. I have tried a variety of queue/thread configurations from minimal to way over-allocated. I have used Misi's fabulous RRR|Log tool and I see that there is absolutely no thread contention at all. > When the system is running, top shows: > > 90 processes: 86 sleeping, 3 stopped, 1 on cpu CPU states: 100% idle, 0.0% user, 0.0% kernel, 0.0% iowait, 0.0% swap > Memory: 16G real, 12G free, 509M swap in use, 11G swap free > > So it appears that I have plenty of hardware. > > I am pretty sure that it is not a database problem because I have analysed the SQL logs and the transaction times are consistent. The additional time between the short times and the long times appears to all be within the API time. That is to say, the time from beginning to end for any particular API call seems to increase while the embedded SQL transactions within the API calls stay relatively constant. > > Does anyone have any suggestions on what to look for? Thanks for any insights. > Larry > > ARS 7.6.03 > Mid-tier 7.6.04 > Solaris 10 > Oracle 11.2.0... > > Larry Robinson > Remedy Developer / Admin > NC State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
ARS 7.6.03 performance problems
Hi Folks, I am experiencing a performance problem on my 7.6.03 AR System. The problem gets worse over time. When the server is started, performance is fine. For example, it takes about one second to load a particular record in the Windows client and about two seconds to load the same record in the Mid Tier. However, if I load the same record later in the day, maybe after the server has been running for 12 hours, the time to load the same record is about twice as long. If I restart the server process, response time returns to the original timings. This behavior is consistent whether the system is heavily loaded or lightly loaded, but the degradation seems to happen faster if the system is heavily loaded The arserverd is running on a Sun SPARC-Enterprise-T5120 with 16 Gb of RAM. I have tried a variety of queue/thread configurations from minimal to way over-allocated. I have used Misi's fabulous RRR|Log tool and I see that there is absolutely no thread contention at all. When the system is running, top shows: 90 processes: 86 sleeping, 3 stopped, 1 on cpu CPU states: 100% idle, 0.0% user, 0.0% kernel, 0.0% iowait, 0.0% swap Memory: 16G real, 12G free, 509M swap in use, 11G swap free So it appears that I have plenty of hardware. I am pretty sure that it is not a database problem because I have analysed the SQL logs and the transaction times are consistent. The additional time between the short times and the long times appears to all be within the API time. That is to say, the time from beginning to end for any particular API call seems to increase while the embedded SQL transactions within the API calls stay relatively constant. Does anyone have any suggestions on what to look for? Thanks for any insights. Larry ARS 7.6.03 Mid-tier 7.6.04 Solaris 10 Oracle 11.2.0... Larry Robinson Remedy Developer / Admin NC State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Question about get-list web service
Hi Folks, Happy holidays to those of you who celebrate. I am still struggling with the performance problems associated with a "get-list" web service. Does anyone know if it is possible to return multiple records from a filter that is invoked by a "service" type of web service? And Misi... regarding the behavior mentioned below, all of the generated SQL commands are part of a single ARXMLGetEntry API call. I sure wish we had a little move control over this. Thanks. Larry On Fri, Dec 16, 2011 at 2:13 AM, Misi Mladoniczky wrote: > Hi, > > I do not see how you can do much about this, it is how it has been > "optimized" by BMC. > > To know in detail, you may need to turn on API-logging as well. > > I suspect that you are seeing first a ARGetListEntry(WithFields), followed > by an ARGetMultiplEntries. > > I guess they have been lazy in this case, as they should only need the > ARGetListEntry(WithFields) call when you do not need any fields such as > big character fields. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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 Folks, >> >> I have a basic question about how web services work. >> >> I have defined a "get-list" web service that takes a user-specified >> qualification and returns the "Entry-Id" (field C1) of the records that >> match the qualification. No other fields are returned. I was expecting >> this >> to generate a single SELECT and return C1. But I am seeing something quite >> different in the SQL logs. >> >> I do see the expected SELECT, something like this: >> >> SELECT >> T282.C1,C8,C3,C7,C536870935,C536870938,C536870913,C536870967,C6,C536870940,C536871010,C536870973 >> FROM T282 WHERE (T282.C3 >= 1322715600) ORDER BY C536870935 DESC,C3 ASC, 1 >> ASC >> >> But instead of returning the C1 values from that SELECT, the server >> fetches >> each record individually to get the C1 values. I see "a bunch" of SELECTs >> like the following: >> >> SELECT C1,C1,C1 FROM T282 WHERE C1 IN ('01605119', '01605121', '01605122', >> '01605123', '01605124', '01605125', '01605126', '01605127', '01605128', >> '01605129', '01605130', '01605131', '01605132', '01605133', '01605134', >> '01605135', '01605136', '01605137', '01605138', '01605139', '01605140', >> '01605142', '01605143', '01605144', '01605145', '01605146', '01605147', >> '01605149', '01605152', '01605153', '01605155', '01605156', '01605157', >> '01605158', '01605159', '01605160', '01605161', '01605162', '01605163', >> '01605164', '01605165', '01605166', '01605167', '01605168', '01605170', >> '01605171', '01605172', '01605173', '01605174', '01605175', '01605176', >> '01605177', '01605178', '01605179', '01605180', '01605181', '01605183', >> '01605184', '01605185', '01605186', '01605187', '01605188', '01605189', >> '01605190', '01605191', '01605192', '01605193', '01605194', '01605195', >> '01605196', '01605198', '01605199', '01605200', '01605201', '01605202', >> '01605203', '01605204', '01605205', '01605206', '01605207', '01605208', >> '01605209', '01605210', '01605211', '01605212', '01605213', '01605214', >> '01605215', '01605216', '01605217', '01605218', '01605219', '01605220', >> '01605221', '01605222', '01605224', '01605225', '01605226', '01605227', >> '01605228') >> >> Am I correct in my understanding of what is happening? >> >> Is there any way to avoid this extra fetching of the records to get >> information that the server already has? This adds significantly to the >> time needed to produce the results. >> >> >> ARS 7.6.03 >> Mid-tier 7.6.04 >> Solaris 10 >> Oracle 11.2.0... >> >> Thanks for any insights. >> Larry >> >> Larry Robinson >> Remedy Developer / Admin >> NC State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Diary field weirdness in Mid-tier
Hi Misi, This problem is in fact corrected in SP2. Hope this is helpful. Larry On Wed, Dec 21, 2011 at 2:34 AM, Misi Mladoniczky wrote: > Hi, > > To me, this seems like a bug, and a Mid-Tier bug at that. > > Have you tried the SP2 for Mid-Tier? > > I am seeing the exact same problem with AR Server 7.6.04, Mid-Tier 7.6.04 > and Firefox. > >Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Diary field weirdness in Mid-tier
Thanks for the confirmation Misi. Ravindra, Are you in agreement that this is a bug? If so, do you know if it is corrected in SP2 as Misi asked? Thanks. Larry On Wed, Dec 21, 2011 at 3:28 AM, Hamsagar, Ravindra < ravindra_hamsa...@bmc.com> wrote: > > Went through the below mail and say that it’s a issue. > > Whenever we sent the Row value in Dev Studio, that is just to display when > you access the form object dynamically through midtier. Life if you set Row > value as 2, when access the form with midtier diary field will display > default for 2 rows entry, but you can expand the diary field and can enter > more number of rows and should be saved successfully, irrespective of > browser type > > Thanks, > Ravindra > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Diary field weirdness in Mid-tier
Hi Folks, I have a question about diary fields and how they work in the Mid-tier. They seem to work differently than they do in the Windows client. In the Windows client, I am able to enter any number of lines into the field, both when the field is collapsed or when it is expanded. In the Mid-tier, I am limited to entering only as many lines as the number of rows specified in in the properties for the diary field as specified using Dev Studio. For example, If the diary field is specified with three rows, and I type directly into the diary field (without expanding it first) like this: 1 2 3 4 5 I end up with: 1 2 345 If I save it and then expand the diary, This is what was saved: 1 2 345 If I expand the diary field and type the following: 1 2 3 4 5 and then collapse it, save it, then refresh the record and expand the diary field, the last entry will look like this: 1 2 3 In the Windows client, it will take whatever you enter, expanded or collapsed and save it every time, regardless of the number of rows specified in the field properties. The only way that I have found to get the Mid-tier to take an entry that is longer than the number of rows specified in the field properties is as follows: Type something into the diary field just to get the Save button enabled. Expand the diary field. Type in multiple lines, as many as you want. Save the record while the diary field is still expanded. The diary field will be saved correctly. Also, unlike the Windows client, the Mid-tier does not clear the lower portion of the diary field after the record has been saved. Is this just my system, or is this the way that diary fields work in the Mid-tier? I have tried this on Safari, Firefox and Chrome on multiple Macs and PCs. They all behave exactly the same way. The only browser that works the way that the Windows client works is IE on Windows. I have scoured the BMC documentation and I have not found anything to make me think that this is expected behavior on Mid-tier. ARS 7.6.03 on Solaris Mid-tier 7.6.04 Oracle 11.2.0.2.0 Thanks for reading this far. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Question about get-list web service
Hi Folks, I have a basic question about how web services work. I have defined a "get-list" web service that takes a user-specified qualification and returns the "Entry-Id" (field C1) of the records that match the qualification. No other fields are returned. I was expecting this to generate a single SELECT and return C1. But I am seeing something quite different in the SQL logs. I do see the expected SELECT, something like this: SELECT T282.C1,C8,C3,C7,C536870935,C536870938,C536870913,C536870967,C6,C536870940,C536871010,C536870973 FROM T282 WHERE (T282.C3 >= 1322715600) ORDER BY C536870935 DESC,C3 ASC, 1 ASC But instead of returning the C1 values from that SELECT, the server fetches each record individually to get the C1 values. I see "a bunch" of SELECTs like the following: SELECT C1,C1,C1 FROM T282 WHERE C1 IN ('01605119', '01605121', '01605122', '01605123', '01605124', '01605125', '01605126', '01605127', '01605128', '01605129', '01605130', '01605131', '01605132', '01605133', '01605134', '01605135', '01605136', '01605137', '01605138', '01605139', '01605140', '01605142', '01605143', '01605144', '01605145', '01605146', '01605147', '01605149', '01605152', '01605153', '01605155', '01605156', '01605157', '01605158', '01605159', '01605160', '01605161', '01605162', '01605163', '01605164', '01605165', '01605166', '01605167', '01605168', '01605170', '01605171', '01605172', '01605173', '01605174', '01605175', '01605176', '01605177', '01605178', '01605179', '01605180', '01605181', '01605183', '01605184', '01605185', '01605186', '01605187', '01605188', '01605189', '01605190', '01605191', '01605192', '01605193', '01605194', '01605195', '01605196', '01605198', '01605199', '01605200', '01605201', '01605202', '01605203', '01605204', '01605205', '01605206', '01605207', '01605208', '01605209', '01605210', '01605211', '01605212', '01605213', '01605214', '01605215', '01605216', '01605217', '01605218', '01605219', '01605220', '01605221', '01605222', '01605224', '01605225', '01605226', '01605227', '01605228') Am I correct in my understanding of what is happening? Is there any way to avoid this extra fetching of the records to get information that the server already has? This adds significantly to the time needed to produce the results. ARS 7.6.03 Mid-tier 7.6.04 Solaris 10 Oracle 11.2.0... Thanks for any insights. Larry Larry Robinson Remedy Developer / Admin NC State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Linux Mid-tier performance questions
Hi Axton, I don't know as much about the protocols and firewalls as I should, but the information that you provided is good for reference. Now that ICMP is enabled, I can actually get some real numbers: ars00srv is the arserver: traceroute to ars00srv (152.1.?.?), 30 hops max, 60 byte packets 1 * * * 2 * * * 3 ars00srv (152.1.?.?) 0.879 ms 0.824 ms 0.862 ms ping ars00srv PING ars00srv (152.1.?.?) 56(84) bytes of data. 64 bytes from ars00srv (152.1.?.?): icmp_seq=1 ttl=253 time=0.911 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=2 ttl=253 time=0.953 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=3 ttl=253 time=1.21 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=4 ttl=253 time=0.868 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=5 ttl=253 time=0.889 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=6 ttl=253 time=0.966 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=7 ttl=253 time=0.878 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=8 ttl=253 time=0.871 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=9 ttl=253 time=0.898 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=10 ttl=253 time=0.926 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=11 ttl=253 time=0.917 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=12 ttl=253 time=0.926 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=13 ttl=253 time=0.809 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=14 ttl=253 time=0.859 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=15 ttl=253 time=0.883 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=16 ttl=253 time=0.889 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=17 ttl=253 time=1.16 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=18 ttl=253 time=0.833 ms 64 bytes from ars00srv (152.1.?.?): icmp_seq=19 ttl=253 time=1.51 ms ^C --- ars00srv ping statistics --- 19 packets transmitted, 19 received, 0% packet loss, time 18361ms rtt min/avg/max/mdev = 0.809/0.956/1.516/0.166 ms So based on your comments, it looks like we are in pretty good shape. Thanks again for your help. Larry On Tue, Nov 29, 2011 at 11:38 AM, Axton wrote: > TCP state timeout shouldn't make a big difference; it will just cause > a little more communication to create the state. When a packet comes > from the midtier server to the arserver and a state does not exist on > the firewall, the packet will be dropped; the midtier should then send > a SYN packet, which create a new state, at which point the packet will > be forwarded and an ACK will go back to the midtier server. > > 1 hour is rather short for TCP, but can be justified in high traffic > environments. I use the following on my firewalls, which are the > defaults for the platform I use and is pretty typical for other > platforms. Note that TCP state expirations are valid for 24 hours. > The firewall is smart enough that at a certain point it will start > expiring the states (adaptive) when a certain threshold is reached. > > TIMEOUTS: > tcp.first 120s > tcp.opening 30s > tcp.established 86400s > tcp.closing 900s > tcp.finwait 45s > tcp.closed 90s > tcp.tsdiff 30s > udp.first60s > udp.single 30s > udp.multiple 60s > icmp.first 20s > icmp.error 10s > other.first 60s > other.single 30s > other.multiple 60s > frag 30s > interval 10s > adaptive.start18000 states > adaptive.end 36000 states > src.track 0s > > LIMITS: > stateshard limit3 > src-nodes hard limit1 > frags hard limit 5000 > tableshard limit 1000 > table-entries hard limit 20 > > I would still suggest looking at the latency between the arserver and > the midtier server. If you are getting beyond 20ms it's going to > cause a noticeable impact on performance. Ideally, in a data center > environment, you want to see < 2 ms latency between your servers if > the traffic is routed and < 1 ms if the traffic is not routed > (switched). > > Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Linux Mid-tier performance questions
Hi Folks, Thanks to Axton, I believe we have identified the problem. When he suggested a "traceroute" between the Mid-tier server and the AR Server, I discovered that ICMP traffic was not being routed. That got me thinking that there might be some other "issues" with the firewall that had been imposed on me. After describing the symptoms to the firewall guy, he instantly knew what the problem was and corrected it in seconds. Apparently, their default behavior is to setup a one hour timeout on TCP traffic unless there is a Linux machine involved. He suggested that the person who setup the rules for this particular configuration did not realize that the Mid-tier servers were running on Linux. He adjusted the timeout and I am now waiting for an hour to elapse so I can see what happens. But confidence is high. Thanks to all who replied with suggestions. This job would be a lot harder and more frustrating without all of you who are willing to share your knowledge and your time. I appreciate you. Larry On Mon, Nov 28, 2011 at 3:41 PM, Axton wrote: > You have a number of varaibles in play that's going to make it hard to > pinpoint the cause of the slowness: > - midtier local to arserver host in fast configuration > - different tomcat versions > - different operating systems > - physical vs. virtual machines > - different java versions > > The fact that one is on the same box as the arserver and the other is > on a separate physical host is the first thing I'd look at. > - What is the route between the linux midtier and the solaris arserver > (latency and hops) > > The physical vs. virtual is the next thing I'd look at: > - What is the load on the physical server that the virtual server is > running on (mem, cpu, disk)? > > I don't think the version differences with Java, Tomcat, and the > mid-tier software will make a difference, but it could. > > Axton Grams > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Lifecycling Existing Unix ARS servers to Windows VM
I'm going to show my age here but I recall a situation where switching to a virtual environment did actually improve performance. We were running MVS on an IBM mainframe. When we started to run MVS as a guest OS under VM on the same hardware, the performance improved. I was told that the improvement was the VM software had a better paging algorithm than MVS. So we just told MVS that it had tons of memory and let VM do the paging. Performance improved. But this is a little different scenario than what is being discussed here. Larry On Mon, Nov 28, 2011 at 10:32 AM, John Sundberg < john.sundb...@kineticdata.com> wrote: > I think VMs are fine -- in fact - awesome. > > But - I don't think it is possible to improve the system by making it a VM. > (Unless other factors are added) > > > -John > > > > On Nov 28, 2011, at 9:09 AM, Tanner, Doug wrote: > > Yes we also switched hardware, I am sure a lot of the improvement was the > hardware and new generation of processors. I was a little hesitant about > VM, but I am a believer. > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of John Sundberg > Sent: Monday, November 28, 2011 10:06 AM > To: arslist@ARSLIST.ORG > Subject: Re: Lifecycling Existing Unix ARS servers to Windows VM > > Weird - I wonder why? > > > Assuming the OS behaves the same on physical vs virtual -- seems it would > be impossible to function better if virtual. > > > When you switched to VM - did you switch hardware too? > > > -John > > > > On Nov 28, 2011, at 9:02 AM, Tanner, Doug wrote: > > Same here, matter of fact I was on dedicated Window boxes, and our > performance got even better, when we switched to VM. > Doug > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of LJ LongWing > Sent: Monday, November 28, 2011 9:59 AM > To: arslist@ARSLIST.ORG > Subject: Re: Lifecycling Existing Unix ARS servers to Windows VM > > Richard, > My entire Dev/Test/Prod environment structure for app servers is Windows > Virtual servers and I haven't experienced ANY issues related to the fact > that they are virtual > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Gard, Richard J > Sent: Wednesday, November 23, 2011 12:19 PM > To: arslist@ARSLIST.ORG > Subject: Re: Lifecycling Existing Unix ARS servers to Windows VM > > I would not put production APP nor DB servers for Remedy on a VM servers. > We live with (for cost considerations)filter and active link issues > routinely in our DEV and test environments weekly. We handle a huge > volume > of tickets (over 2.5 million per year) in prod, and our systems are too > critical to allow the hiccups caused on VMs. If you go to Windows, spec it > properly with physical servers and you won't regret it. The mid-tier can > be VMs, but we don't know yet if this will be and issue with the 7.6.04 > version we are building out now. > > - Original Message - > From: Jamie Boley [mailto:jbo...@aegonusa.com] > Sent: Wednesday, November 23, 2011 01:43 PM > To: arslist@ARSLIST.ORG > Subject: Lifecycling Existing Unix ARS servers to Windows VM > > Our existing Unix ARS hardware is up for lifecycle this year, and we are > entertaining the possibility of moving away from Unix to Windows VM, > because it will reduce the overall cost for our environment. I'm looking > to see if anyone has had any expierence (or whether is is possible) > replacing existing ARS servers from one OS to another while keeping the > same database. > > Basicially here would be our scenerio: We currently have 4 Solaris ARS > Servers, 4 Windows VM Midtier Servers, and a dedicated Oracle Database on > AIX. We are looking to swap out the 4 Solaris ARS servers and replace them > with 4 Windows VMs running ARS, while keeping the same Oracle database. > > Thoughts...conerns? Let me hear it :) > > Thanks! > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > > > > This email is subject to certain disclaimers, which may be reviewed via > the following link. http://compass-usa.com/Pages/Disclaimer.aspx > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where
Re: Linux Mid-tier performance questions
Hi Jarl, Preload Tables Configuration has the default setting of: Reload Tables At Init Only: No Number of Preload Threads: 20 Number of Preload Segments: 300 I didn't think this would be a factor since the Solaris Mid-tier works fine and these settings are per-server. But thanks for thew suggestion. Larry On Mon, Nov 28, 2011 at 2:29 PM, Jarl Grøneng wrote: > Hi, > > Have you tried to enable the Pre-Load option? You enable this is the > AR Server option. > > -- > J > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Linux Mid-tier performance questions
Hi Folks, I am struggling with a performance issue with Mid-tier running on a Linux VM. Well, maybe not exactly a performance problem. Perhaps it is a caching issue or a configuration issue. I'm just not sure. Let me say at the outset that I have read the "BMC Remedy Mid Tier Guide" for 7.6.03, but it is entirely possible that I have missed some salient points or misunderstood others. Here is the basic configuration: - Using multiple browsers on different machines, Mac and PC. - Midtier 7.6.03 Patch 002 - Apache Tomcat/6.0.32 - Java 1.6.0_29 - OS: Red Hat Enterprise Linux 6 (64-bit) running as a VM, 4 Gig - EVC Mode: Intel Xenon Core 2 This is the behavior that I am seeing: Upon connecting to the Linux VM, the Mid-tier login screen appears immediately. But after typing in a vald username/password, there is a delay of approximately two minutes before the Mid-tier Object List appears (my home page). After that initial delay, response to loading forms is fast with no significant delay. If the session is kept active by periodically loading forms, the delay does not return. However, if I log out for "about an hour" or if the session is allowed to time-out, the next login experiences the delay again. If I restart Tomcat, the first login is always fast. This system is not in production, so I am basically the only user accessing the system. Questions and things I am confused about: - Does the cache on the server timeout? If so, after what interval and how do I control this behavior? - How does the browser cache play into this scenario? Sometimes after I flush the browser cache, I will experience the delay upon accessing the Mid-tier. Other times, flushing the browser cache does not seem to matter and load times are still fast. - In the Mid-tier Configuration tool, I see that the various object types have non-zero "Object Counts", but the "Hit" and "Miss" counts are all always zero. What does this imply about my cache? Mid-tier Settings: Mid Tier Version: 7.6.03 Patch 002 201106210200 Web Server Information: Apache Tomcat/6.0.32 Operating System Name: Linux Java Version: 1.6.0_29 Definition Change Check Interval (Seconds): 3600 (but I have tried longer) Perform Check?: Yes, but I have tried "No" also. Resource Check Interval (Seconds): 86400 Enable Cache Persistence: Checked. Session Timeout (Minutes)*: 1440 (but I have tried shorter) License Release Timeout ([30 - 300] Seconds)*: 60 Enable object list: Checked Enable Skins: Checked I have tried with and without prefetching the cache on the Mid-tier server and also tried using different users in the prefetch configuration (admin, non-admin and both). These changes do not seem to make a difference. The thing that makes me think that something is amiss is the fact that I have a midtier server running on a Solaris 10 box accessing the same AR server and it does not display this behavior. It is running Mid-tier 7.6.03 for Solaris with OOTB configuration and no prefetch. This Mid-tier is running on the same physical host as the AR server (Solaris 10) and is configured as: Mid Tier Version: 7.6.03 Build 001 201008170035 Web Server Information: Apache Tomcat/6.0.29 Operating System Name: SunOS Java Version: 1.6.0_22 Definition Change Check Interval(Seconds): 3600 Perform Check?: Yes Resource Check Interval (Seconds): 86400 Enable Cache Persistence: Checked. Session Timeout (Minutes): 1440 License Release Timeout ([30 - 300] Seconds)*: 60 Enable object list: checked Enable Skins: checked The only difference is minor version differences in Tomcat and Java. The server.xml file is exactly the same on both servers. I have compared all of the configuration files that I can find and I have not found anything that would account for this behavior. Any suggestions n what to look for? Thanks for reading this far. :-) Larry - Larry Robinson Remedy Developer/Admin North Carolina State University Office Of Information Technology Raleigh, NC ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Looking for 7.6.03 Midtier for Linux
Hi Derek, Thanks for the suggestion. Unfortunately, the only product that I have listed (and licensed) is "BMC Remedy AR System Server". When expanded, it includes components for 7.6.04, 7.5.00 and 7.1.00. Larry On Sat, Nov 26, 2011 at 11:04 PM, Derek Berube < derek.ber...@wildstartech.com> wrote: > ** > It took me a little while to locate the second Service Pack for 7.6.04. > Here are the steps you can follow to get the latest version of the 7.6.03 > Mid-Tier for LINUX (Service Pack 2). > > > 1. Log into BMC's Support web site. > http://www.bmc.com/support > 2. Left-click on the "Product Downloads, Patches, and Fixes" link >located in the bottom right corner of the "BMC Support Central" page. > http://www.bmc.com/support/downloads-patches > 3. Left click on the "Product Downloads (EPD)" link found on the >"Product Downloads, Patches and Fixes" page. > http://apps.bmc.com/server/available.cfm?fc=EPDAPP > 4. Agree to the terms and conditions presented on the "Export Compliance >and Access Terms" document that is displayed. > 5. Expand the "BMC Remedy IT Service Management Suite" branch. > 6. Expand the "BMC Remedy IT Service Management Suite 7.6.03" branch for >the "Linux" platform. > 7. Click on the "Click here to view available patch files". > > https://webapps.bmc.com/epd/faces/patchDnld.jsp?pbsn=LPU93.0.0.00&ddm=1-GRMVTA&ersl=134273 > 8. Click on the "AR System Server, Mid-Tier, Flashboards Server, Email >Engine, Assignment Engine, Approval Server and Clients Version >7.6.03 Patch 002" link. > > https://webapps.bmc.com/epd/faces/patchDnld.jsp?pbsn=LPU93.0.0.00&ddm=1-GRMVTA&ersl=134273 > > You should be prompted to save "ARSystem_7603P002_Linux.tar.gz" to your > local hard disk drive. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Looking for 7.6.03 Midtier for Linux
Hi Folks, I have been searching the BMC site for quite some time, looking for the 7.6.03 mid-tier for Linux. Anyone have any hints? I have a support login. I just don't know where to look for older versions. Thanks. Larry --- LG Robinson Remedy Developer/Admin NC State University 919-515-5432 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Indexes that aren't really there
Hi LJ, Thanks for the suggestion. However, I found it easier to do as Misi suggested. I created the indexes that the AR System thought were already there using direct access to the database. Then I was able to delete the indexes using Dev Studio. Finally, after updating, I was able to create the one index that I wanted in the first place. So all is well. Thanks Misi... you have come through for me once again. Larry On Tue, Oct 25, 2011 at 2:43 PM, LJ LongWing wrote: > ** > > Larry, > > What I would do to take care of this would be to export the form to XML > Def…remove all index information from the def…then re-import it….I would > expect that to take care of the scenario you are dealing with. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Indexes that aren't really there
Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson wrote: > Hi Fred, > > Nope, it is the other way around Dev Studio says there are indexes, but > there are none on the T table nor entries in the SCHEMA_INDEX table. > > Thanks. > Larry > > On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > >> So there are indexes on the T table, but no record of them in >> SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. >> >> Have you tried restarting the app (as the index info is held in memory >> while the server is running) >> >> Fred >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] On Behalf Of L G Robinson >> Sent: Tuesday, October 25, 2011 12:49 PM >> To: arslist@ARSLIST.ORG >> Subject: Indexes that aren't really there >> >> ** >> Hi Folks, >> >> My AR System is confused about the indexes on a particular form. The AR >> System believes that there are four indexes on this particular form but in >> the database (Oracle) there are no entries for this form in the SCHEMA_INDEX >> table. When I attempt to delete the indexes using Dev Studio, I get errors: >> >>Failure during SQL operation to the database : ORA-01418: specified >> index does not exist, 552, AR System User Central File >> >> and I can see from the SQL logs: >> >>*/*** ERROR *** ORA-01418: specified index does not exist >> >> So it appears that there is some other place within the AR System that >> still indicates that there are indexes on this form. Can anyone tell me >> where to look? >> >> I understand the dangers of mucking around directly in the database >> tables. This is my development system, so the results of a mistake will not >> be catastrophic. >> >> Thanks. >> Larry >> >> ARS: 7.6.03 - Solaris 10 >> Oracle: 11.2.0.1.0 - 64bit >> >> Larry Robinson >> NC State University >> Remedy Admin/Developer >> 919-515-5432 >> n...@ncsu.edu >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Indexes that aren't really there
Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > So there are indexes on the T table, but no record of them in SCHEMA_INDEX. > Then Oracle knows of them, but ARS should not. > > Have you tried restarting the app (as the index info is held in memory > while the server is running) > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Tuesday, October 25, 2011 12:49 PM > To: arslist@ARSLIST.ORG > Subject: Indexes that aren't really there > > ** > Hi Folks, > > My AR System is confused about the indexes on a particular form. The AR > System believes that there are four indexes on this particular form but in > the database (Oracle) there are no entries for this form in the SCHEMA_INDEX > table. When I attempt to delete the indexes using Dev Studio, I get errors: > >Failure during SQL operation to the database : ORA-01418: specified > index does not exist, 552, AR System User Central File > > and I can see from the SQL logs: > >*/*** ERROR *** ORA-01418: specified index does not exist > > So it appears that there is some other place within the AR System that > still indicates that there are indexes on this form. Can anyone tell me > where to look? > > I understand the dangers of mucking around directly in the database tables. > This is my development system, so the results of a mistake will not be > catastrophic. > > Thanks. > Larry > > ARS: 7.6.03 - Solaris 10 > Oracle: 11.2.0.1.0 - 64bit > > Larry Robinson > NC State University > Remedy Admin/Developer > 919-515-5432 > n...@ncsu.edu > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Indexes that aren't really there
Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Extracting just the API files
Hi Folks, Do you know if it is possible to extract the ARSystem/api directory from the Linux install without actually running the installer? My systems guys want to try to build a new ARSPerl for Linux and need the latest API files. This would be for 7.6.04 for Red Hat. Thanks. Larry Larry Robinson Remedy Admin / Developer NC State University Raleigh, NC n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
SASL-based LDAP Authentication
Hi Folks, I am trying to get LDAP authentication going on my development server. I believe that I have everything configured correctly and I can see in the plugin logs that the ARS system is actually communicating with the LDAP server. My problem is that our LDAP server does not support "ldap_simple_bind". Our passwords are not stored in the LDAP server. My LDAP support folks tell me that I need an LDAP authentication plugin that supports "SASL-based LDAP authentication". Do you know if it is possible to configure the OOTB AREA LDAP plugin to do this or if there are any other AREA LDAP plugins available? Has anyone written their own LDAP authentication plugin that they would be willing to share? Alternatively, I am told that we could support a "PAM authentication module for Solaris". Anyone written one of these? Thanks. Larry Remedy Developer / Administrator NC State University Raleigh, NC ARS: 7.6.03 Solaris: 10 Oracle: 11.2.0.1.0 - 64bit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Compound qualification for a GetList web service
Hi Chintan, Thanks for the additional suggestions. I believe I will take a different aproach... Instead of returning complete records on the get-list request based on the qualification supplied by the user, I will return a subset of the fields, specifically excluding the field(s) that may contain information that is not for general consumption. But I will include the Entry-id as one of the returned fields. Then I will provide another web service (get-entry) which will return all of the fields for a single entry, specified by Entry-id. Then I can impose my additional restriction on the qualification for the request since the customer will just be supplying the Entry-id and not a complete qualification. I know how to do this and have successfully done it on another service. This is not exactly what I was shooting for because it requires additional steps for the user, but it will give me assurance that the restricted information does not leak out through this web service. Thanks again for your thoughts on this question. Larry On Thu, Jun 9, 2011 at 11:04 PM, Chintan Shah wrote: > ** Ah..I c what you are saying now..Sorry, in all of my conversation, I > thought you would be comparing XPATH Qualification to some field on form but > that's not the case. My bad for not reading the thread properly. > > IMHO, there are 2 solutions for this(there could be more..but this is what > I can think of so far)..again this might not be the most elegant solution on > planet but it can get job done. > > 1. Build an automated workflow that would push all Distribution!="Internal" > records to a staging form and build web-service from staging form. In that > case you will never need AND 'Distribution'!="Internal" qualification > appended. This is probably good since amount of records to traverse would be > lesser than what is on source form and it would take query off the source > form. One of caveat I see upfront is that you will have to spend time in > building that staging form(you can probably just do a "save as" on source > form) and maintaining that workflow that pushes records to it. > > 2. Client should supply complete qualification(as you mentioned you will be > at the mercy of the client) > > Does #1 help or does it over-complicate :)? > > Thanks > Chintan. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Compound qualification for a GetList web service
Hi Chintan, Yes, I understand completely that I am at the mercy of the consumer with regard to what they put in the qualification. You did not confuse me. :-) However, when I put the following into the Qualification: box in Developer Studio: XPATH(/ROOT/qualification) AND 'distribution' != "Internal" I receive the following error: ERROR (1583): Expected a relational operation at this point; position 0, 5147, solutions Dev Studio is trying to make sure that this is a syntactically-correct qualification, and it is not. So this is the original problem/question... how do I combine XPATH(/ROOT/qualification) with my own additional qualification? Thanks for your continued interest. Larry 1583 Error Relational operator expected at this position. The only legal operator at this position in a search line is a relational operator (=, !=, <, <=, >, >=, or LIKE). Fix the format of the line, and perform the search again. Larry Robinson NC State University Remedy Admin / Developer On Thu, Jun 9, 2011 at 3:16 PM, Chintan Shah wrote: > ** > Hi Larry, > > As far as i know, you will be able to control the "AND 'distribution' != > "Internal" " from qualification bar, however you will be relying on client > for "Qualification' string. Clients will be responsible for completing the > brackets appropriately otherwise meaning of entire qualification might > change. > > This goes back to what your requirements are and you will need to educate > clients of the web-services accordingly > > e.g. > 1. Client can pass this in XPATH qualification(notice incomplete bracket) > > Workgroup="REMEDY" AND ( word="email" OR word="remedy" > You append this >"AND 'distribution' != "Internal" > making your entire qualification look like this > > Workgroup="REMEDY" AND ( word="email" OR word="remedy" AND 'distribution' > != "Internal" > > 2. Client can pass this in XPATH qualification(notice brackets are > completed) > > Workgroup="REMEDY" AND ( word="email" OR word="remedy") > You append this >"AND 'distribution' != "Internal" > making your entire qualification look like this > > Workgroup="REMEDY" AND ( word="email" OR word="remedy") AND 'distribution' > != "Internal" > -->I believe this might be the qualification you would be looking for. > > In a nutshell, you would be dependent on client of web-service for > XPATH-Qualification piece. > > Hoping I did not confuse you :). > > Thanks > Chintan. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Compound qualification for a GetList web service
Hi Chintan, Thanks for the reply. I realize that I can mix and match fields from the form and from the XPATH but I am unclear on how to combine them to achieve the desired result. Maybe an example will help: Suppose that XPATH(/ROOT/qualification) is something like the following: Workgroup="REMEDY" AND ( word="email" OR word="remedy") What I want to actually send to the server as the query is the following: Workgroup="REMEDY" AND ( word="email" OR word="remedy" AND 'distribution' != "Internal" But I can not figure out how to combine XPATH(/ROOT/qualification) with the additional clause to achive the desired result. Thanks. Larry Larry Robinson Remedy Admin/Developer NC State University On Tue, Jun 7, 2011 at 8:32 PM, Chintan Shah wrote: > ** Hi Larry, > > Yes you can do it. > > In qualification bar, you should have an option of using either the field > from the form or an element from XPATH. > > What you mentioned below should work. > > Thanks > Chintan. > > --- On *Tue, 6/7/11, L G Robinson * wrote: > > > From: L G Robinson > Subject: Compound qualification for a GetList web service > To: arslist@ARSLIST.ORG > Date: Tuesday, June 7, 2011, 12:23 PM > > ** > Hi Folks, > > I need some help formulating a qualification for a GetList web service. > Simplistically, I want to do the following: > >(XPATH(/ROOT/Qualification)) AND ('distribution' != "Internal") > > But this is not syntactically correct. In words, I want to take whatever > qualification the user has supplied and add the: > >('distribution' != "Internal") > > clause to the qualification that gets passed to the service. 'distribution' > is a field on the form being searched. > > Is there a syntax for this? Is it possible to build something like this > using EXTERNAL()? > > I am just learning about creating and consuming ARS web services so any > guidance and/or insights will be greatly appreciated. > > ARS 7.6.03 > Solaris 10 > Oracle 11.2.0.1.0 - 64bit > > Thanks. > Larry > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Compound qualification for a GetList web service
Hi Folks, I need some help formulating a qualification for a GetList web service. Simplistically, I want to do the following: (XPATH(/ROOT/Qualification)) AND ('distribution' != "Internal") But this is not syntactically correct. In words, I want to take whatever qualification the user has supplied and add the: ('distribution' != "Internal") clause to the qualification that gets passed to the service. 'distribution' is a field on the form being searched. Is there a syntax for this? Is it possible to build something like this using EXTERNAL()? I am just learning about creating and consuming ARS web services so any guidance and/or insights will be greatly appreciated. ARS 7.6.03 Solaris 10 Oracle 11.2.0.1.0 - 64bit Thanks. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Selecting entries on a List View table using a touch device
Hi Frederick, Sadly, no. They did send me the form so I could submit an RFE, which I plan to do. Hope this is helpful. Larry On Fri, May 13, 2011 at 4:25 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > Just checking ... Did they open a ticket with BMC so the fixes can be added > to future patches of the MidTier? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Selecting entries on a List View table using a touch device
Hi Folks, You may recall my dismay and disappointment upon discovering that several of the Mid-tier user interface objects did not work on iOS (Apple touch-screen) devices. I was bemoaning this problem to a colleague a few weeks ago and he suggested that it might be possible to make it work by tweaking some CSS or Javascript. I was skeptical but he was insistent and offered me the "use" of Garrison Locke, of one of his staff to take a look. After I showed Garrison around the environment and demonstrated the problem, he too was skeptical. But he persevered and a couple of hours later, he had it working! He made modifications to seven lines of Javascript across two files and now it all works. I can select menu items from drop-down menus, select rows from tables and results from the results browser. I am not sure of the rules and/or ethics of posting changes to BMC Javascript files but if you are interested in what he did, feel free to contact me off-list. I did check with my BMC support folks (ColumnIT) and they said that it is Ok to modify the Javascript files. Just make sure that you understand that patches and upgrades will overwrite your changes and they will have to be reapplied or re-worked. Hope this is helpful. Larry On Thu, Jan 27, 2011 at 7:33 AM, L G Robinson wrote: > Hi Ian, > > Thanks for the suggestion. That would probably work. However, another > lister has pointed out (and I have confirmed) that we have bigger problems > on touch devices... drop-down character menus don't work either. The menu > will drop down but you can't select a menu item by tapping it. The only > workaround I have found for this is to press on the menu item until the > "Copy" contextual menu appears and copy the menu item. Then you can paste it > into the field. I expect my users would not find this to be acceptable. > > Looks like the iPad really isn't compatible with Mid-tier. > > Hope this is helpful. > Larry > > On Jan 27, 2011, at 2:22 AM, Ian Trimnell wrote: > > > ** > > On 26/01/2011 19:04, L G Robinson wrote: > >> Hi Folks, > >> > >> Has anyone figured out how to setup a List View table field so that it > can be used with a touch enable device such as an iPad? I have such a table > on one of my forms. When the form is loaded into Mobile Safari on the iPad, > I am unable to select a specific row of the table by tapping it or any other > gesture that I can think of. > >> > >> I have added "Prev" and "Next" buttons onto the table field so I have a > workaround. Just wondering if there is a better way. Maybe some clever CSS > that is tailored for the iPad or similar devices? > >> > >> ARS: 7.6.3 > >> Solaris 10 > >> Oracle: 11.2.0.1.0 - 64bit > >> > >> Thanks. > >> Larry > >> > > Hi Larry, > > > > As you are on ARS 7.6.3 you can probably do what I have done upon > noticing the way that iOS devices can't handle these tables. I have added a > column, with a button labelled 'Open', to the table. Work-flow causes the > drill-down to occur when the button is clicked (or tapped on an iOS device). > > > > Hope this helps, > > > > Ian > > Ian Trimnell, Systems Programmer, Client Systems > > Distributed Systems, Information Technology > > Open University, MILTON KEYNES, UK > > Phone: 01908 653741 web: http://www.open.ac.uk/ > > The Open University is incorporated by Royal Charter (RC 000391), an > exempt charity in England & Wales and a charity registered in Scotland (SC > 038302). > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Preserving customizations with overlays and custom objects
Thanks David, Rick and Misi... you have given me the clear direction that I was seeking. Larry On Feb 1, 2011, at 5:04 PM, Rick Cook wrote: > ** David is, as usual, spot on. Overlays are not put there for us to have > any sense of invincibility or impunity when altering OOB forms or workflow > that we under other circumstances would (or should) know better than to > alter. It is a means to protect additions that may conflict with FUTURE OOB > functionality. That it also gives one the ability to protect against having > customizations to PRESENT forms and workflow is an incidental increase in > power that we should work hard to wield carefully. > > It is, in a nutshell, like developing in Remedy (or C, for that matter). The > best thing about it is that you can do anything you want. The worst thing is > that you can do anything you want. > > Rick > > On Tue, Feb 1, 2011 at 3:48 PM, Easter, David wrote: > ** > Overlays is the most important feature that you should never use. J > > > Rick is correct. Overlays enforces best practices, but you should still > consider the broader implications of modifying something vs. extending. > Simply put, the basic best practice rules should be: > > > 1. Don’t modify or extend anything. Use the product OOTB. > > 2. If you can’t use the product OOTB, *add* to the existing structure, > don’t modify it. Extend it by adding fields, forms, workflow, etc. that do > not directly impact existing functionality > > 3. If and only if your situation cannot be solved either OOTB or > through extending the product should you consider modifying existing objects. > > > If you find yourself with #3, that’s where overlays really helps. Overlays > will create a copy of the object for you, identify it as a modified object > (i.e. an overlay) and ensure that the origin object remains just as BMC > shipped it to you. During run time, your overlaid object is the one that the > server uses. In fact, the server does a little bit of magic behind the > scenes to ensure that any calling API or workflow that uses the original name > (i.e. the BMC object name) is redirected to your overlaid object. That way > you don’t have to change guides, API programs or other calling > applications/workflow. > > > -David J. Easter > > Manager of Product Management, Remedy Platform > > BMC Software, Inc. > > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > On Feb 2, 2011, at 2:46 AM, Misi Mladoniczky wrote: > Hi, > > The main problem with adding fields to the User- or Group-form is that the > data need to be entered, and sometimes modified. > > 1. Each time a User record is modified, that user will have all > definitions recached (arf/arv files on the Windows client) > > 2. Each tim a Group record is modified, ALL users will get the definitions > recached. It will also trigger a server-side recache of the definitions. > > If you look at your API-logs and find a lot of ARExport()-calls, you > should suspect that you have this kind of problem in your setup. > > I recommend that you go for the join-form solution. > >Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * 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. > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > Sent: Tuesday, February 01, 2011 01:31 PM > To: arslist@ARSLIST.ORG > Subject: Re: Preserving customizations with overlays and custom objects > > > ** LG, from what I know of the overlay functionality, you are correct in your > assessment of its impact on customizations in an upgrade situation. It is > designed to allow you to choose which customizations to protect during the > upgrade. As to the User form, while you COULD alter it, I still don't think > it would be a good practice to do so if you are using the ITSM suite. If you > have all custom apps, that might be a different story, but probably not, > because of the caching issue you referenced. > > Rick > > On Tue, Feb 1, 2011 at 3:08 PM, L G Robinson wrote: > > Hi Folks, > > Back in the days of ARS 4.mumble, I developed
Preserving customizations with overlays and custom objects
Hi Folks, Back in the days of ARS 4.mumble, I developed a help desk application for my organization. At that stage of my development experience, I did not understand the issues surrounding modifying Remedy objects such as the User and Group forms. In my ignorance, I added fields, changed permissions and moved stuff around on the User and Group forms. I got lucky when we transitioned to ARS 5.1.2 and I simply imported all of my stuff to the new server. It worked! Now I am more experienced and I understand the reasons why you don't modify the User and Group forms. As part of my plan to transition to 7.6, I had planned to create a form of my own to hold my additional fields and I would present them to my users through a join between my form and the User form. [You may remember that I ran into a slight problem with having too many "special" fields from the User form on my join form.] I figured this would be the best way to proceed since I was making very minimal changes to the User form. Now, as I read the "What's New in ARS 7.6.04" I see a description of the "Preserving customizations with overlays and custom objects". On the face of it, this sounds like it is designed to allow one to make changes to a BMC-supplied form such as the User form and still be relatively immune to collisions and upgrade problems. So I have two questions: - Am I understanding this new feature correctly and is it now an "ok practice" to modify the User form if I use the Overlay feature? - Is this the "best practice" method for accomplishing what I am trying to do? As a side discussion, are there performance issues with one method over the other? I recall in the back of my mind that updates to fields in the User form cause the User Cache table to be updated. Is that true and is it a performance issue? I presume it would still be true when using the Overlay method and not an issue when using the join method. I have already made a small time investment in implementing the join-form method but I am willing to scrap it in favor of the Overlay method if that is the way to go. I still want to do something similar with the Group form so now would be a good time for me to decide which way I should proceed. I appreciate any guidance you might have on these questions. Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Selecting entries on a List View table using a touch device
Hi Ian, Thanks for the suggestion. That would probably work. However, another lister has pointed out (and I have confirmed) that we have bigger problems on touch devices... drop-down character menus don't work either. The menu will drop down but you can't select a menu item by tapping it. The only workaround I have found for this is to press on the menu item until the "Copy" contextual menu appears and copy the menu item. Then you can paste it into the field. I expect my users would not find this to be acceptable. Looks like the iPad really isn't compatible with Mid-tier. Hope this is helpful. Larry On Jan 27, 2011, at 2:22 AM, Ian Trimnell wrote: > ** > On 26/01/2011 19:04, L G Robinson wrote: >> Hi Folks, >> >> Has anyone figured out how to setup a List View table field so that it can >> be used with a touch enable device such as an iPad? I have such a table on >> one of my forms. When the form is loaded into Mobile Safari on the iPad, I >> am unable to select a specific row of the table by tapping it or any other >> gesture that I can think of. >> >> I have added "Prev" and "Next" buttons onto the table field so I have a >> workaround. Just wondering if there is a better way. Maybe some clever CSS >> that is tailored for the iPad or similar devices? >> >> ARS: 7.6.3 >> Solaris 10 >> Oracle: 11.2.0.1.0 - 64bit >> >> Thanks. >> Larry >> > Hi Larry, > > As you are on ARS 7.6.3 you can probably do what I have done upon noticing > the way that iOS devices can't handle these tables. I have added a column, > with a button labelled 'Open', to the table. Work-flow causes the drill-down > to occur when the button is clicked (or tapped on an iOS device). > > Hope this helps, > > Ian > Ian Trimnell, Systems Programmer, Client Systems > Distributed Systems, Information Technology > Open University, MILTON KEYNES, UK > Phone: 01908 653741 web: http://www.open.ac.uk/ > The Open University is incorporated by Royal Charter (RC 000391), an exempt > charity in England & Wales and a charity registered in Scotland (SC 038302). > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Selecting entries on a List View table using a touch device
Hi Folks, Has anyone figured out how to setup a List View table field so that it can be used with a touch enable device such as an iPad? I have such a table on one of my forms. When the form is loaded into Mobile Safari on the iPad, I am unable to select a specific row of the table by tapping it or any other gesture that I can think of. I have added "Prev" and "Next" buttons onto the table field so I have a workaround. Just wondering if there is a better way. Maybe some clever CSS that is tailored for the iPad or similar devices? ARS: 7.6.3 Solaris 10 Oracle: 11.2.0.1.0 - 64bit Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Message not in catalog -- message number = 9070
Hi Folks, Thanks for your continued interest in this thread. I did check the SQL logs to see what happens when I update the User form Password field (FID 102) using the join form with the corresponding field renumbered to something other than FID 102... it does not encrypt the contents, neither in the SQL UPDATE nor in the database table. The password is sent in clear text. When the password field in the join retains it's FID=102, everything works correctly and the result is encrypted all the way to the database table. As an interesting aside, the user_cache entry is encrypted in both cases described above. So in my case, renumbering the Password field on the join form turned out to be a poor choice. That really only left me one field that I could renumber to avoid the 9070 error... "Login Name" (FID 101). I have renumbered "Login Name" on my join and everything seems to be working as expected. Hope this is helpful. Larry On Jan 18, 2011, at 10:25 AM, Misi Mladoniczky wrote: > Hi, > > I suspect that if the field id is not 102, it will not encrypt the content > before it is sent over the network. The SQL log will still show it > encrypted though, as it is encrypted by the server before it is stored. > > It would be complicated to track the 102 to the actual regular form, as a > join may be implemented in multiple tiers. > >Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * 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, >> >> I have not checked the SQL logs but I was assuming (hoping) that since the >> renumbered password field (on the join form) still maps to the real >> password field in the real User form (with it's original FID), then it >> would still be treated as such and encrypted as appropriate. I did in fact >> set the Display-Type to "Edit Masked" as you suggest and that part works >> just fine. If I get a few minutes today, I'll check the SQL logs to see >> what is getting sent. >> >> Thanks. >> Larry >> >> On Jan 18, 2011, at 3:54 AM, Misi Mladoniczky wrote: >> >>> Hi, >>> >>> All else to the side, in this case, couldn't you just set the >>> Display-Type >>> to "Edit Masked"? >>> >>> I an guessing that it changes the way modified data is sent to the >>> server, >>> as the password field is normally sent encrypted. >>> >>> In the old days, I sometimes renamed the User-form to a Swedish >>> equivalent, which worked just fine, and it probably still does. >>> >>> If you had multiple User-forms the system could suddenly switch forms, >>> for >>> example when you imported a record into UserCopy, the user cache could >>> get >>> reset with only the newly imported user in it... I am sure it worked >>> like >>> this in version 2.0 and 2.1, and possibly a bit after that as well ;-) >>> >>> Why is the 9070 message missing from the Error Message Guide? >>> >>> Best Regards - Misi, RRR AB, http://www.rrr.se >>> >>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): >>> * 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Message not in catalog -- message number = 9070
Hi Misi, I have not checked the SQL logs but I was assuming (hoping) that since the renumbered password field (on the join form) still maps to the real password field in the real User form (with it's original FID), then it would still be treated as such and encrypted as appropriate. I did in fact set the Display-Type to "Edit Masked" as you suggest and that part works just fine. If I get a few minutes today, I'll check the SQL logs to see what is getting sent. Thanks. Larry On Jan 18, 2011, at 3:54 AM, Misi Mladoniczky wrote: > Hi, > > All else to the side, in this case, couldn't you just set the Display-Type > to "Edit Masked"? > > I an guessing that it changes the way modified data is sent to the server, > as the password field is normally sent encrypted. > > In the old days, I sometimes renamed the User-form to a Swedish > equivalent, which worked just fine, and it probably still does. > > If you had multiple User-forms the system could suddenly switch forms, for > example when you imported a record into UserCopy, the user cache could get > reset with only the newly imported user in it... I am sure it worked like > this in version 2.0 and 2.1, and possibly a bit after that as well ;-) > > Why is the 9070 message missing from the Error Message Guide? > >Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * 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 Doug, >> >> Thanks for the explanation. It is very helpful to know what is going on in >> the background. Since 104 is the only one that I need that has special >> functionality, renumbering one or more of the others works fine as a >> workaround. >> >> Thanks again. >> Larry >> >> On Jan 17, 2011, at 2:36 PM, Mueller, Doug wrote: >> >>> Larry, >>> >>> The User form (and several other system forms) is identified by the >>> presence >>> of a specific set of fields. If we find all the fields of a set on a >>> form, the >>> form is that special form with special meaning. >>> >>> If we find multiple forms with those fields, we don't know which is >>> which and >>> for key forms, we have logic that detects the confusion and you get the >>> error >>> 9070 indicating you cannot do what you are attempting because the form >>> would >>> cause confusion in the system. >>> >>> For the User form, The key fields include 101 and 102 and probably 104 >>> and maybe >>> 106 (I don't remember the exact list). If ALL of these fields are >>> present on >>> the form, it means the form is THE user form for the system. >>> >>> You will get the error when adding the last of whatever the set of >>> special >>> fields are so it could come reported against any one of the special >>> fields -- >>> whichever is added last. >>> >>> This is why renumbering the field doesn't have the problem. >>> This is why adding some but not all of the fields doesn't have the >>> problem. >>> >>> Only if you add ALL of the fields that the system is using to identify >>> the >>> form do you have the problem. >>> >>> Again, I don't remember the specific list of fields that identify the >>> User form, >>> but it is some combination of 101, 102, 104, and 106. (at least I think >>> so) >>> >>> Doug Mueller ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Message not in catalog -- message number = 9070
Hi Doug, Thanks for the explanation. It is very helpful to know what is going on in the background. Since 104 is the only one that I need that has special functionality, renumbering one or more of the others works fine as a workaround. Thanks again. Larry On Jan 17, 2011, at 2:36 PM, Mueller, Doug wrote: > Larry, > > The User form (and several other system forms) is identified by the presence > of a specific set of fields. If we find all the fields of a set on a form, > the > form is that special form with special meaning. > > If we find multiple forms with those fields, we don't know which is which and > for key forms, we have logic that detects the confusion and you get the error > 9070 indicating you cannot do what you are attempting because the form would > cause confusion in the system. > > For the User form, The key fields include 101 and 102 and probably 104 and > maybe > 106 (I don't remember the exact list). If ALL of these fields are present on > the form, it means the form is THE user form for the system. > > You will get the error when adding the last of whatever the set of special > fields are so it could come reported against any one of the special fields -- > whichever is added last. > > This is why renumbering the field doesn't have the problem. > This is why adding some but not all of the fields doesn't have the problem. > > Only if you add ALL of the fields that the system is using to identify the > form do you have the problem. > > Again, I don't remember the specific list of fields that identify the User > form, > but it is some combination of 101, 102, 104, and 106. (at least I think so) > > Doug Mueller > > -----Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Friday, January 14, 2011 6:51 AM > To: arslist@ARSLIST.ORG > Subject: Re: Message not in catalog -- message number = 9070 > > Hi Folks, > > Well, I figured it out, but I still don't understand why it works the way it > does. > > I created a new "regular" form and a new join form and I was able to include > the "Group List" field from the User form. So that told me that there was > something weird with my other forms that was preventing it from working > correctly. > > So I saved a copy of my problematic join form, added the "Group List" field > and then started to methodically delete other fields from the join until it > saved. Turns out that it was the "Password" field (102) from the User form > that was causing the collision. If the password field was not present, the > join would save. If I added it back in so that the "Password" and the "Group > List" fields were both present, I would get the 9070 error again. If I > changed the FID of the "Password" field on the join form before saving, > choosing a FID in the 5368709xx range, then it would save. So I have a > workaround, but I still don't understand why it works this way. Any insights? > > Thanks. > Larry > > On Jan 13, 2011, at 4:51 PM, L G Robinson wrote: > >> Hi Folks, >> >> Does anyone know what error number 9070 means? It is not listed in my error >> messages manual. >> >> I receive this error when I attempt to add the "Group List" field (FID:104) >> to a join form that I am developing. My support folks tell me that there >> isn't anything special about FID 104 that should prevent me from adding it >> to the join. If I remove that field, the form will save just fine. >> >> Message not in catalog -- message number = 9070 : 104, 9070, NCSUUsers >> >> "NCSUUsers" is the name of the join form. >> >> It appears to be something specific about "104". If I change the field id >> before saving the form, it will save but of course, then the field does not >> display correctly. It displays the group id number(s) instead of the group >> name(s), which is inherent in the functionality of field 104. >> >> There is no other field on the join form with an id of 104. >> >> ARS: 7.6.03 >> Solaris: 10 >> Oracle: 11.2.0.1.0 - 64bit Production >> >> Thanks. >> Larry >> >> >> Larry Robinson n...@ncsu.edu >> Office of Information Technology >> NC State University 919-515-5432 Voice >> Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: EXTERNAL: Re: Message not in catalog -- message number = 9070
Hi John, Apparently, it's a know issue: SW00380659 - "ARERR 9070 - Message not in catalog" while creating join with the User form I can't see any details on the defect but in my case, I was including several of the special fields from the User form including "Login Name", Password, "Group List" and "Assigned To". Fortunately, I was able to renumber the Password field on the join form without losing any inherent functionality, so I have a workaround. Hope this helps someone. Larry On Jan 14, 2011, at 12:11 PM, Reiser, John J wrote: > Larry, > > I ran into this a few years back but I can't swear it was the same error > message. > There is something funky about using too many core fields in joins. My errors > occurred when trying to send email notifications and I had field ids like > 101, 103, 104 & 106 included in the join. > My error message kept including the 106 field id as the problem but it was > another core field that we removed because we needed to the Group ID. > > --- > John J. Reiser > Remedy Developer/Administrator > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Message not in catalog -- message number = 9070
Hi Folks, Well, I figured it out, but I still don't understand why it works the way it does. I created a new "regular" form and a new join form and I was able to include the "Group List" field from the User form. So that told me that there was something weird with my other forms that was preventing it from working correctly. So I saved a copy of my problematic join form, added the "Group List" field and then started to methodically delete other fields from the join until it saved. Turns out that it was the "Password" field (102) from the User form that was causing the collision. If the password field was not present, the join would save. If I added it back in so that the "Password" and the "Group List" fields were both present, I would get the 9070 error again. If I changed the FID of the "Password" field on the join form before saving, choosing a FID in the 5368709xx range, then it would save. So I have a workaround, but I still don't understand why it works this way. Any insights? Thanks. Larry On Jan 13, 2011, at 4:51 PM, L G Robinson wrote: > Hi Folks, > > Does anyone know what error number 9070 means? It is not listed in my error > messages manual. > > I receive this error when I attempt to add the "Group List" field (FID:104) > to a join form that I am developing. My support folks tell me that there > isn't anything special about FID 104 that should prevent me from adding it to > the join. If I remove that field, the form will save just fine. > > Message not in catalog -- message number = 9070 : 104, 9070, NCSUUsers > > "NCSUUsers" is the name of the join form. > > It appears to be something specific about "104". If I change the field id > before saving the form, it will save but of course, then the field does not > display correctly. It displays the group id number(s) instead of the group > name(s), which is inherent in the functionality of field 104. > > There is no other field on the join form with an id of 104. > > ARS: 7.6.03 > Solaris: 10 > Oracle: 11.2.0.1.0 - 64bit Production > > Thanks. > Larry > > > Larry Robinson n...@ncsu.edu > Office of Information Technology > NC State University 919-515-5432 Voice > Raleigh, NC 27695-7109 919-513-0877 FAX > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Message not in catalog -- message number = 9070
Hi Folks, Does anyone know what error number 9070 means? It is not listed in my error messages manual. I receive this error when I attempt to add the "Group List" field (FID:104) to a join form that I am developing. My support folks tell me that there isn't anything special about FID 104 that should prevent me from adding it to the join. If I remove that field, the form will save just fine. Message not in catalog -- message number = 9070 : 104, 9070, NCSUUsers "NCSUUsers" is the name of the join form. It appears to be something specific about "104". If I change the field id before saving the form, it will save but of course, then the field does not display correctly. It displays the group id number(s) instead of the group name(s), which is inherent in the functionality of field 104. There is no other field on the join form with an id of 104. ARS: 7.6.03 Solaris: 10 Oracle: 11.2.0.1.0 - 64bit Production Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Timeout errors when viewing the Server Information form
Hi David, It may be coincidental, but the last entries in my API logs before the timeout seem to indicate a call to "ARGetEncryptInfo". Also, when I disable standard encryption (not required), the problem disappears. Logs: /* Fri Nov 05 2010 07:10:24.8059 */+GE ARGetEntry -- schema AR System Administration: Server Information entryId 001 from Remedy User (protocol 17) at IP address [my client IP Address] /* Fri Nov 05 2010 07:10:24.9700 */+GEIARGetEncryptInfo -- as user from Unidentified Client (protocol 17) at IP address /* Fri Nov 05 2010 07:10:24.9702 */-GEI OK /* Fri Nov 05 2010 07:11:24.8680 */DEBUG INFO: plug-in v4 proc 3 to ars00srv:34000 timeout (used 60 of 60 s) /* Fri Nov 05 2010 07:11:43.3609 */+GSIARGetServerInfo -- as user Remedy Application Service from Application Command Dispatcher (protocol 17) at IP address [my server IP Address] /* Fri Nov 05 2010 07:11:43.3611 */-GSI OK /* Fri Nov 05 2010 07:11:43.3625 */+GLEARGetListEntry -- schema Application Pending from Application Command Dispatcher (protocol 17) at IP address [my server IP Address] /* Fri Nov 05 2010 07:11:43.3631 */SELECT T8.C1 FROM T8 WHERE (T8.C8 = 'Dispatch') ORDER BY C1 ASC /* Fri Nov 05 2010 07:11:43.3652 */OK /* Fri Nov 05 2010 07:11:43.3654 */-GLE OK /* Fri Nov 05 2010 07:11:43.3667 */+GESARGetEntryStatistics -- schema Application Pending from Application Command Dispatcher (protocol 17) at IP address [my server IP Address] /* Fri Nov 05 2010 07:11:43.3671 */SELECT C8,COUNT(*) FROM T8 WHERE (T8.C7 = 0) GROUP BY C8 ORDER BY C8 /* Fri Nov 05 2010 07:11:43.3686 */OK /* Fri Nov 05 2010 07:11:43.3688 */-GES OK /* Fri Nov 05 2010 07:12:24.8727 */DEBUG INFO: plug-in v4 proc 9 to ars00srv:34000 timeout (used 60 of 60 s) /* Fri Nov 05 2010 07:12:24.8732 */-GE FAIL I don't have a 7.5 patch 006 system handy to test with. Would you be able to turn off security temporarily to see if the problem goes away? Thanks. Larry On Dec 16, 2010, at 9:16 AM, David Durling wrote: > Hi Larry, > > What lead you all to look at encryption? I do have the Security Policy set > to "Required" for Standard encryption, didn't think to try changing that. > > I don't know if this test can be done on 7.6.03, but it would be interesting > to see if your issue goes away (as it does for us) if you try ServerAdmin.so > from 7.5 patch 006. Maybe you can ask support if that's feasible, as a test. > > David ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Timeout errors when viewing the Server Information form
Hi David, I am seeing the exact same behavior on a 7.6.03 "out-of-the-box" install on Solaris 10. I believe it has something to do with encryption. My system seems to be missing an encryption library. My third-party support folks are still working through it. Please let me know if you find a solution and I'll do the same. Thanks. Larry ------- L. G. Robinsonn...@ncsu.edu Office of Information Technology Remedy Services NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-1893 FAX On Dec 15, 2010, at 4:53 PM, David Durling wrote: > After upgrading ARS 7.5 from patch 006 to patch 007, I noticed this issue: > > Usually the Server Information form loads okay if I view it soon after > starting arsystem. But after maybe an hour, if I come back to the Server > Information form, I get a timeout error - usually the first error is arerr 93 > - and the form does not load. The ARDBC and AREA Configuration forms are > similarly affected. > > If I kill the arplugin process and let armonitor restart it, the forms will > work again for a while. > > Support had us try a binary file from 7.5 patch 006 on this patch 007 > installation, and that keeps the timeout from occurring. But apparently this > is not reproducible on their system, and there are no other reports of this > issue. > > Has anyone else experienced this? I would feel a little better if I knew > that we weren't the only ones. > > Solaris 10 > Oracle 11g R2, 64 bit > Oracle 10g R2 client, 64 bit > ARS 7.5 patch 007 > (and Hummingbird Full Text Search) > custom apps (no SRM, etc.) > > -- > David Durling > Enterprise IT Services > University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Looking for ARSPerl for Solaris 10
Hi Folks, Does anyone have ARSPerl built for Solaris 10? API version 5 or better would be great. The Perl that is on the box was built with cc but the cc that is on the box does not appear to be complete enough to complete the ARSPerl build. I suppose that I could install gcc and build my own Perl with that but I was hoping to save a few steps and some time. Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology Remedy Developer / Administrator NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: ARERR 299 Too many levels in filter processing
Hi Folks, Having just completed a migration from Sybase to Oracle, I can tell you from personal experience that direct SQL can pose some challenges: - Literals... ""s are ok in Sybase, Oracle requires ''s. - Stored procedures... they "work" quite differently in Oracle with respect to returning results. This cost me much effort in my conversion. Although it was easier at the time to use direct SQL, I did end up converting many of the instances back to Remedy workflow when possible, even though I do not anticipate another data base platform change. :-) Hope this is helpful. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX On Jun 2, 2010, at 10:07 AM, William Rentfrow wrote: > I've found a few rare instances where using direct SQL was the best way > to accomplish the task at hand. It is rare. > > When using direct SQL by far the biggest issue you're likely to run into > is having the "T" (B, H) table be wrong between systems. > > The steps below are pretty simple - when I did use direct SQL I always > did the following. > > 1.) Add field name T_table > 2.) First action executed was always a set fields that used direct SQL > to set the correct T-table # in the T_table field like... > > Select schemaid from arschema where name='HPD:Help Desk' > > From there on you just used "T"+T_table in your direct SQL calls. > > That way it was portable across systems, etc. If you take those steps > then direct SQL's downsides are mostly mitigated right from the start. > There are other implications of course (E.G., exporting workflow from an > Oracle database system to SQL Server database system) but the odds of > running into them are low. > > > William Rentfrow > Principal Consultant, StrataCom Inc. > wrentf...@stratacominc.com > Blog: www.williamrentfrow.com > O 715-592-5185 > C 715-410-8056 > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell > Sent: Wednesday, June 02, 2010 8:51 AM > To: arslist@ARSLIST.ORG > Subject: Re: ARERR 299 Too many levels in filter processing > > All valid points, however it is still a legitimate option and doesn't > necessarily mean a system is hard to manage. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Trouble with ARSPerl ars_NTNotificationServer
Yup... that is exactly what I did and it works great. Thanks Fred. Larry On Jun 2, 2010, at 2:18 PM, Grooms, Frederick W wrote: > As a quick test you might try putting a submit/merge filter on Alert Events > to do an LTRIM(RTRIM($Request$)) on the Request field. > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of L G Robinson > Sent: Wednesday, June 02, 2010 12:21 PM > To: arslist@ARSLIST.ORG > Subject: Re: Trouble with ARSPerl ars_NTNotificationServer > > Thanks Frederick... I wish I'd thought of that. > > Yes, 5.1 does have the Alert Events form. A quick check of some existing > entries in that form showed that the 'Request' field was in fact right-padded > to a length of 15. I edited one entry, reloaded the Alert list and it worked! > > I will change my Perl code to do a submit as you suggest but the 2 minute > solution was to add a filter to the Alert Events form to do an RTRIM on > 'Request'. > > Thanks again... chalk up another win for "the list"! > Larry > > On Jun 2, 2010, at 10:50 AM, Grooms, Frederick W wrote: > >> I can't remember but did 5.1 have the Alert Events form? If so you could >> change your Perl to just do a submit to the Alert Events form and that will >> trigger the Alert to the user. You don't have to actually call the >> NotificationServer call. > > ___ > 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: Trouble with ARSPerl ars_NTNotificationServer
Thanks Frederick... I wish I'd thought of that. Yes, 5.1 does have the Alert Events form. A quick check of some existing entries in that form showed that the 'Request' field was in fact right-padded to a length of 15. I edited one entry, reloaded the Alert list and it worked! I will change my Perl code to do a submit as you suggest but the 2 minute solution was to add a filter to the Alert Events form to do an RTRIM on 'Request'. Thanks again... chalk up another win for "the list"! Larry On Jun 2, 2010, at 10:50 AM, Grooms, Frederick W wrote: > I can't remember but did 5.1 have the Alert Events form? If so you could > change your Perl to just do a submit to the Alert Events form and that will > trigger the Alert to the user. You don't have to actually call the > NotificationServer call. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Trouble with ARSPerl ars_NTNotificationServer
Hi Folks, I have run into a problem using the ARSPerl ars_NTNotificationServer function. This function is used to forward a notification (Alert) for the specified user to the indicated server. This has been working correctly for me for years on my ARS 5.01.02 P1313 Solaris server running against Sybase. Last week I completed a migration to Oracle 10.2... same version of ARS server. Now my ars_NTNotificationServer notifications are not working correctly. The notifications are getting created correctly and the user does get the notification. The problem comes when the user attempts to open the form entry from within the Remedy Windows Alert tool. The indicated form entry is "not found". Suspecting a database problem, I checked the SQL logs and I can see what the problem is: SELECT C1,C2,C3,C4,C5,... FROM T233 WHERE C1 = '01373823 ' Note the additional blanks appended to the entry-id. For this particular form, C1 has been redefined to have a length of 8, not the traditional 15 (I know, I know...). However, I confirmed that this was working correctly when we were using Sybase. From the Sybase SQL log: SELECT C1,C2,C3,C4,C5,... FROM T60 WHERE C1 = '01254551' So it appears that the ARS server is generating incorrect SQL when trying to access the relevant entry from the form. Every other SQL reference to C1 on this form appears to be correct... only when trying to load the record from the Alert tool does the problem manifest itself. For this Notification type (2) there is an additional string of "notifyCodeText" that specifies the details of the form entry. The format of the notifyCodeText (from the C-API programmer's Guide) is as follows: A formatted character string identifying the form entry that triggered the notification (fixed-size fields). Entry-Id: The ID of the entry (padded to AR_MAX_ENTRYID_SIZE).The first two bytes of this string indicate the number of Entry IDs, and the Entry ID immediately follows this number. (For example, a single Entry ID of 0006 will have an Entry ID of 010006 in the notifyCodeText). Join forms will have multiple Entry IDs, and the number of Entry IDs will be indicated in the first two bytes of this string. [Note: In the example above (from the C-API Programmer's Guide) there appears to be an "inconsistency". ar.h defines AR_MAX_ENTRYID_SIZE as 15 while the example above shows an entry-id of length 16! Very confusing. I am using 15] Schema: The name of the form containing the entry (padded to AR_MAX_NAME_SIZE). Server: The name of the server where the form is located. I have tried left-adjusting and right-adjusting the Entry-Id within the 15 character zone (AR_MAX_ENTRYID_SIZE), but neither works... it just puts blanks on one side or the other, which fails as it gets to the database server. My notifyCodeText: 01 01373823X-Calls remedy.ncsu.edu 0101373823 X-Calls remedy.ncsu.edu Here is a snippet of the XML export of the field definition of field ID-1: Call-Id 1 Demo Demo 2009-11-23T13:50:43-05:00 The system supplied unique call number (character format). Added help text system protected 0 readOnly 7 readWrite 11 readWrite 1074 readWrite [stuff removed] 8 none leadingMatch overwrite I realize that all of the NT* API calls have been replaced with Alert stuff, but the ARSPerl API doesn't provide any way to use those functions (that I know of). Anyone have any suggestions? Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Interpreting ARS server SQL logs
Hi Ben, Nope... I did not edit out any lines, just the actual text of the SQL Select statement. My logs don't seem to have any "OK's in them. Thanks. Larry On Apr 16, 2010, at 9:27 AM, Ben Chernys wrote: > For SQL logs ONLY (I presume you edited your sample log and left out the > SQL OK) > > You should have had an OK immediately following every SQL Log entry > > Then, OK - SQL when they follow each other (and are the same thread id > of-course) > > > Cheers > Ben Chernys > > Senior Software Architect > Software Tool House Inc. > > Canada / Deutschland / Germany > Mobile: +49 171 380 2329GMT + 1 + [ DST ] > Email: ben.cher...@softwaretoolhouse.com > Web: www.softwaretoolhouse.com > > Check out Software Tool House's free Diary Editor. > > Meta-Update, our premium ARS Data tool, lets you automate > your imports, migrations, in no time at all, without programming, > without staging forms, without merge workflow. > http://www.softwaretoolhouse.com/ > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of L G Robinson > Sent: April 16, 2010 3:04 PM > To: arslist@ARSLIST.ORG > Subject: Interpreting ARS server SQL logs > > Hi Folks, > > I have a question about interpreting ARS server SQL logs. I am in the > process of migrating from a Sybase database server to an Oracle server and I > am trying to evaluate the performance of the Oracle server. I have turned on > API and SQL logs and have them both written to a combined log file. When I > complete a typical search using the Windows User tool, the following log > entries are written: > > 01 /* Wed Apr 14 2010 08:25:23.5164 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 02 /* Wed Apr 14 2010 08:25:23.5178 */ SELECT ... > 03 /* Wed Apr 14 2010 08:25:24.6918 */ COMMIT WORK > 04 /* Wed Apr 14 2010 08:25:24.8038 */ -GLEWFOK > 05 /* Wed Apr 14 2010 08:25:24.8097 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 06 /* Wed Apr 14 2010 08:25:24.8935 */ -GLEWFOK > 07 /* Wed Apr 14 2010 08:25:24.8992 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 08 /* Wed Apr 14 2010 08:25:24.9841 */ -GLEWFOK > 09 /* Wed Apr 14 2010 08:25:24.9896 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 10 /* Wed Apr 14 2010 08:25:25.0660 */ -GLEWFOK > 11 /* Wed Apr 14 2010 08:25:25.0716 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 12 /* Wed Apr 14 2010 08:25:25.1086 */ -GLEWFOK > 13 /* Wed Apr 14 2010 08:25:25.1146 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 14 /* Wed Apr 14 2010 08:25:25.1492 */ -GLEWFOK > 15 /* Wed Apr 14 2010 08:25:25.1545 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 16 /* Wed Apr 14 2010 08:25:25.1810 */ -GLEWFOK > 17 /* Wed Apr 14 2010 08:25:25.1864 */ +GLEWF ARGetListEntryWithFields -- > schema X-Calls > 18 /* Wed Apr 14 2010 08:25:25.1967 */ -GLEWFOK > > My questions is: Which times constitute the exact time that it took the > database server to complete the select? > > For this particular query, 825 rows were returned. > > I have numbered the lines so that we can say something like: > > line04-line02 = whatever... > > Config: > > ARS 5.01.02 patch 1313 / Solaris 8 > Oracle 10.2.0.4 > > Thanks. > Larry > > Larry Robinson n...@ncsu.edu > Office of Information Technology > NC State University 919-515-5432 Voice > Raleigh, NC 27695-7109 919-513-0877 FAX > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 > www.wwrug.com ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Interpreting ARS server SQL logs
Hi Folks, I have a question about interpreting ARS server SQL logs. I am in the process of migrating from a Sybase database server to an Oracle server and I am trying to evaluate the performance of the Oracle server. I have turned on API and SQL logs and have them both written to a combined log file. When I complete a typical search using the Windows User tool, the following log entries are written: 01 /* Wed Apr 14 2010 08:25:23.5164 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 02 /* Wed Apr 14 2010 08:25:23.5178 */ SELECT ... 03 /* Wed Apr 14 2010 08:25:24.6918 */ COMMIT WORK 04 /* Wed Apr 14 2010 08:25:24.8038 */ -GLEWFOK 05 /* Wed Apr 14 2010 08:25:24.8097 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 06 /* Wed Apr 14 2010 08:25:24.8935 */ -GLEWFOK 07 /* Wed Apr 14 2010 08:25:24.8992 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 08 /* Wed Apr 14 2010 08:25:24.9841 */ -GLEWFOK 09 /* Wed Apr 14 2010 08:25:24.9896 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 10 /* Wed Apr 14 2010 08:25:25.0660 */ -GLEWFOK 11 /* Wed Apr 14 2010 08:25:25.0716 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 12 /* Wed Apr 14 2010 08:25:25.1086 */ -GLEWFOK 13 /* Wed Apr 14 2010 08:25:25.1146 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 14 /* Wed Apr 14 2010 08:25:25.1492 */ -GLEWFOK 15 /* Wed Apr 14 2010 08:25:25.1545 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 16 /* Wed Apr 14 2010 08:25:25.1810 */ -GLEWFOK 17 /* Wed Apr 14 2010 08:25:25.1864 */ +GLEWF ARGetListEntryWithFields -- schema X-Calls 18 /* Wed Apr 14 2010 08:25:25.1967 */ -GLEWFOK My questions is: Which times constitute the exact time that it took the database server to complete the select? For this particular query, 825 rows were returned. I have numbered the lines so that we can say something like: line04-line02 = whatever... Config: ARS 5.01.02 patch 1313 / Solaris 8 Oracle 10.2.0.4 Thanks. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: AW: Help with Sybase indexes
Good suggestion Joe... fortunately, it appears that everything is synced. Thanks. Larry On Feb 22, 2010, at 3:18 PM, Joe D'Souza wrote: > If you have a large number of results after Conny's query, you may want to > auto generate a script to create all the missing indexes using that same > query to generate the result in the form of SQL statements to create an > index.. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of L G Robinson > Sent: Monday, February 22, 2010 2:30 PM > To: arslist@ARSLIST.ORG > Subject: Re: AW: Help with Sybase indexes > > > Thanks Conny... this is very helpful. > Larry > > On Feb 22, 2010, at 9:00 AM, Conny Martin wrote: > >> Larry, >> >> you should compare the metatables with the indexes oracle knows. >> >> If one of these 2 statements gives you any rows, you have messed up your > indexes. >> >> SELECT name,'pk_idx for T-Table' FROM arschema WHERE schematype = 1 AND > NOT EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IT'||schemaid) >> UNION ALL >> SELECT name,'pk_idx for H-Table' FROM arschema WHERE schematype = 1 AND > NOT EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IH'||schemaid) >> UNION ALL >> SELECT name,'pk_idx for B-Table' FROM arschema WHERE schematype = 1 AND > NOT EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IB'||schemaid) >> >> >> SELECT > name,arschema.schemaid,schema_index.numfields,uniqueflag,indexname,f1,f2,f3 > FROM arschema,schema_index WHERE indexname NOT IN (SELECT INDEX_name FROM > user_indexes) AND schema_index.schemaid = arschema.schemaid >> >> HTH >> >> Kind Regards Conny Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: AW: Help with Sybase indexes
Thanks Conny... this is very helpful. Larry On Feb 22, 2010, at 9:00 AM, Conny Martin wrote: > Larry, > > you should compare the metatables with the indexes oracle knows. > > If one of these 2 statements gives you any rows, you have messed up your > indexes. > > SELECT name,'pk_idx for T-Table' FROM arschema WHERE schematype = 1 AND NOT > EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IT'||schemaid) > UNION ALL > SELECT name,'pk_idx for H-Table' FROM arschema WHERE schematype = 1 AND NOT > EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IH'||schemaid) > UNION ALL > SELECT name,'pk_idx for B-Table' FROM arschema WHERE schematype = 1 AND NOT > EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IB'||schemaid) > > > SELECT > name,arschema.schemaid,schema_index.numfields,uniqueflag,indexname,f1,f2,f3 > FROM arschema,schema_index WHERE indexname NOT IN (SELECT INDEX_name FROM > user_indexes) AND schema_index.schemaid = arschema.schemaid > > HTH > > Kind Regards Conny > > -Ursprüngliche Nachricht- > Von: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] Im Auftrag von L G Robinson > Gesendet: Montag, 22. Februar 2010 14:33 > An: arslist@ARSLIST.ORG > Betreff: Re: Help with Sybase indexes > > Hi Joe, > > Thanks for the reply. I did compare the information in the AR System's > meta-tables between the two systems (schema_index) and it matches up as > expected. However, I believe it is possible for there to be a mismatch > between what ARS thinks and what actually exists in the DB. The situation I > am trying to detect is the one where ARS thinks there is an index, but for > whatever reason, the index no longer exists in the DB. > > I have been using Misi's wonderful RRRchive utility and on occasion, I have > to interrupt a copy operation before it finishes. In this case, I believe > that the target table will be left without its index since RRRchive does not > get the chance to recreate the index on the target table when the program is > killed. I recreate the index(es) when this happens... I just want to make > sure I have not missed any. > > Thanks again. > Larry > > On Feb 21, 2010, at 8:53 AM, Joe D'Souza wrote: > >> Larry, >> >> Why not look this same information up from the AR System's meta information? >> That way it would be easier to compare the two systems indexes if they >> should be identical.. >> >> Joe >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org]on Behalf Of L G Robinson >> Sent: Friday, February 19, 2010 5:47 PM >> To: arslist@ARSLIST.ORG >> Subject: Help with Sybase indexes >> >> >> Hi Folks, >> >> I need some Sybase help regarding indexes. >> >> I am migrating from Sybase to Oracle and I want to compare the two >> systems to make sure that the Oracle system has all of the same >> indexes on the T-tables as currently exist in the Sybase system. I >> don't doubt that they were there originally as a result of the >> workflow import that I did to create the Oracle system. I just want to >> make sure that I have not inadvertently messed any of the indexes up >> while I have been working in the Oracle system and copying data over (Thanks >> Misi!!!). >> >> On the Oracle side, I can do the following: >> >> SELECT s.name as "Form Name", b.column_name, a.table_name, >> a.index_name, a.uniqueness,a.index_type FROM USER_INDEXES a, >> USER_IND_COLUMNS b, arschema s WHERE a.index_name = b.index_name AND >> cast(s.schemaId as varchar2(40)) = >> substr(a.table_name,2) AND substr(a.table_name,1,1) = 'T' >> ORDER by 1,2; >> >> This gives me exactly what I need. However, I have been spelunking >> through the Sybase system tables all day and I can not seem to locate >> all of the information I need. I can see "almost" everything in the >> "sysindexes" table. >> However, I do not see the name or id number of the column that the >> index is built upon. Maybe I'm just missing something obvious but I >> sure don't see it. >> >> Anyone have any insights into how to accomplish the above in Sybase? >> >> Thanks. >> Larry >> >> ARS:5.1.2 >> Sybase: 12.5.2 >> Oracle: 10.2.0.4.0 >> >> Larry Robinson n...@n
Re: Help with Sybase indexes
Hi Joe, Thanks for the reply. I did compare the information in the AR System's meta-tables between the two systems (schema_index) and it matches up as expected. However, I believe it is possible for there to be a mismatch between what ARS thinks and what actually exists in the DB. The situation I am trying to detect is the one where ARS thinks there is an index, but for whatever reason, the index no longer exists in the DB. I have been using Misi's wonderful RRRchive utility and on occasion, I have to interrupt a copy operation before it finishes. In this case, I believe that the target table will be left without its index since RRRchive does not get the chance to recreate the index on the target table when the program is killed. I recreate the index(es) when this happens... I just want to make sure I have not missed any. Thanks again. Larry On Feb 21, 2010, at 8:53 AM, Joe D'Souza wrote: > Larry, > > Why not look this same information up from the AR System's meta information? > That way it would be easier to compare the two systems indexes if they > should be identical.. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on Behalf Of L G Robinson > Sent: Friday, February 19, 2010 5:47 PM > To: arslist@ARSLIST.ORG > Subject: Help with Sybase indexes > > > Hi Folks, > > I need some Sybase help regarding indexes. > > I am migrating from Sybase to Oracle and I want to compare the two systems > to make sure that the Oracle system has all of the same indexes on the > T-tables as currently exist in the Sybase system. I don't doubt that they > were there originally as a result of the workflow import that I did to > create the Oracle system. I just want to make sure that I have not > inadvertently messed any of the indexes up while I have been working in the > Oracle system and copying data over (Thanks Misi!!!). > > On the Oracle side, I can do the following: > > SELECT s.name as "Form Name", b.column_name, a.table_name, a.index_name, > a.uniqueness,a.index_type > FROM USER_INDEXES a, USER_IND_COLUMNS b, arschema s > WHERE a.index_name = b.index_name AND cast(s.schemaId as varchar2(40)) = > substr(a.table_name,2) AND substr(a.table_name,1,1) = 'T' > ORDER by 1,2; > > This gives me exactly what I need. However, I have been spelunking through > the Sybase system tables all day and I can not seem to locate all of the > information I need. I can see "almost" everything in the "sysindexes" table. > However, I do not see the name or id number of the column that the index is > built upon. Maybe I'm just missing something obvious but I sure don't see > it. > > Anyone have any insights into how to accomplish the above in Sybase? > > Thanks. > Larry > > ARS:5.1.2 > Sybase: 12.5.2 > Oracle: 10.2.0.4.0 > > Larry Robinson n...@ncsu.edu > Office of Information Technology > NC State University 919-515-5432 Voice > Raleigh, NC 27695-7109 919-513-0877 FAX > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Help with Sybase indexes
Hi Folks, I need some Sybase help regarding indexes. I am migrating from Sybase to Oracle and I want to compare the two systems to make sure that the Oracle system has all of the same indexes on the T-tables as currently exist in the Sybase system. I don't doubt that they were there originally as a result of the workflow import that I did to create the Oracle system. I just want to make sure that I have not inadvertently messed any of the indexes up while I have been working in the Oracle system and copying data over (Thanks Misi!!!). On the Oracle side, I can do the following: SELECT s.name as "Form Name", b.column_name, a.table_name, a.index_name, a.uniqueness,a.index_type FROM USER_INDEXES a, USER_IND_COLUMNS b, arschema s WHERE a.index_name = b.index_name AND cast(s.schemaId as varchar2(40)) = substr(a.table_name,2) AND substr(a.table_name,1,1) = 'T' ORDER by 1,2; This gives me exactly what I need. However, I have been spelunking through the Sybase system tables all day and I can not seem to locate all of the information I need. I can see "almost" everything in the "sysindexes" table. However, I do not see the name or id number of the column that the index is built upon. Maybe I'm just missing something obvious but I sure don't see it. Anyone have any insights into how to accomplish the above in Sybase? Thanks. Larry ARS:5.1.2 Sybase: 12.5.2 Oracle: 10.2.0.4.0 Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Strored procedures in Sybase vs Oracle
Hi Folks, I wanted to report back on how I resolved my problem with converting Sybase stored procedures to Oracle. But first let me thank all of the folks who responded and offered suggestions. As it turns out, Oracle procedures do not return values, but Oracle FUNCTIONS do. The only catch is that they return one thing. This was problematic for me in several of my cases because the Sybase procs were returning the results of a multi-column select. I experimented with returning a variety of different Oracle objects and datatypes, but none of them produced the same result as I was accustomed to in Sybase. More on this later. In many of the other cases, the Sybase procs were not returning anything so for those, I was able to write an equivalent Oracle function. Those turned out to be pretty straightforward, once I figured out a couple of things: - You have to have one of these in your function if you are going to modify data: PRAGMA AUTONOMOUS_TRANSACTION; - You have to put COMMIT statements in your function after you modify something. :-) The rest is just syntax differences. For example, string literals are enclosed in single quotes in Oracle but all of my Sybase stuff used double quotes. In some of the other cases, the Sybase proc was issuing a select but it was doing some data manipulation and verification too. In many cases, I was able to move that data manipulation back into ARS workflow and then just issue the SELECT. So no need for a proc or a function at all. However, there was one proc that used the parameters that were passed to determine which select, among many, should be executed by evaluating a very long if-then-else statement. The select statement returned multiple columns and possibly multiple rows. As mentioned above, I could not discover a way to return that. I considered two different approaches to this. The first was to stuff the results of the appropriate select into an intermediate table (adding another column with a GUID) and then, upon returning to ARS, issue a select against the intermediate table, using the GUID as the selection criteria. The other option I considered was to write a simple Perl script that took all of the same parameters as the original Sybase proc and returned the appropriate select statement. Then issue the select to Oracle. This second approach was the one that I eventually decided upon. So it is all working! Sorry for the length of this post. I hope my experience will be useful to someone else. I have examples if anyone wants to see them. Thanks again for your suggestions. Larry Larry Robinson n...@ncsu.edu Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX On Oct 20, 2009, at 12:16 PM, L G Robinson wrote: > Hi Folks, > > I am in the early stages of a migration from Sybase to Oracle and I am > struggling with stored procedures. > > One of the nice things about Sybase is the ease with which one could return > data to the ARS system using stored procedures. I am finding this much more > difficult in the Oracle environment. When using a SetFields operation in an > Active Link, one can invoke a Sybase stored procedure that includes a SELECT > statement and the results of the select are presented back to ARS as $1$, > $2$, etc. If multiple rows are returned, you can display them and let the > user choose the record they want. Simple. > > In Oracle, I have discovered that stored procedures do not return anything. > However, Oracle Functions return one "thing. The "thing" can be a singe value > or something more complex such as a row or a table or some other user-defined > Oracle object. The trouble I am having is understanding how to define the > Oracle "thing" that I want to return so that it behaves the same way that it > does with Sybase. Is it a RECORD, an OBJECT or an array or a table? Or > something else? I know my way around Sybase pretty well, but this is my first > exposure to Oracle. > > If anyone has any experience in this area and could nudge me in the right > direction, I would greatly appreciate it. I am willing to put in the time to > learn whatever I need to learn... I just need some direction. References to > helpful documentation or a working example would be most helpful. > > ARS 5.1.2 > Sybase 12.5.2 > Oracle 10.2.0.4.0 > > Thanks. > Larry > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"