As it turned out, it is a configuration parameter that needs to be set in the ar.conf file. Seems it's a new parameter that was introduced specifically to fix that known bug. According to BMC Support, that parameter was introduced in SP5 of AR Server 7.6.04.
Max-Entries-Per-Search-Menu: 0 to set it to unlimited. May have performance impact in some areas, but we'll see how it goes. Right now after introducing it and restarting the AR Server things look like they sort out ok in one chunk instead of multiple chunks.. Cheers Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, September 08, 2014 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: Peculiar sort order of character menus returning *LARGE* number of menu items.. ** Joe, I had a similar problem a few years back with sorting values in some ITSM fields. Have you checked the Database search order (deep in the bowels of ITSM config)? It needs to be set consistently, especially with Oracle. Rick Cook On Mon, Sep 8, 2014 at 11:29 AM, Joe D'Souza <jdso...@shyle.net> wrote: ** We are on ARS / ITSM 7.6.04 SP5 all round on Linux using Oracle 11.x as a backend DB. I am working on a system, which when deployed will have a fairly large set of Companies (2500 or there about and growing). One of my co-developer (Mark Brittain - member of this forum), picked up on a peculiar problem. The sort order of the companies is as expected starting from 0 to 9, followed by A to Z, followed by a to z. At first look it looked normal until Mark scrolled right down. The list restarted its sort order at some point (which from the numbers we are dealing with, we assume must be at 1000. This is happening only on the Mid-Tier, as the user tool displays it correctly - only difference being that the menus appears as a list on the thick client as that is the client setting for large menus. My believe is that the Mid-Tier is chunking the results into chunks of 1000 and arranging each chunk into its own sort order. There is no customization on the menu nor the Company field on the COM:Company form. The menu displays this peculiar behavior on every place that the Company menu is used in ITSM. Has anyone else faced this and have resolved it? We believe there must be some backend setting either in the CSS or one of the Mid-Tier jar files that could correct this issue. I'll be raising a ticket with BMC Support shortly - but thought I would run this by you people to see if anyone else has faced this issue, and how you'll have dealt with it. Joe PS: I have toyed with the idea of leveraging the Tiered menu approach to reduce the number of items on each menu, but that solution will require user acceptance as users are used to the menus as is now. SO as of now, leveraging that tiered menu option is not an option. _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"
