Hi all - System = ARS/ITSM 8.1.02 with the FTS fortifications and hotfixes in place.
We have a bizarre issue. I added a FTS index to CTM:People on the Corporate ID field. It is indexed for both FTS and MFS. We have incident management configured so that Customer ID is searching using the Corporate ID. Or, in other words, when you enter an ID in the Customer ID field in a new incident it searches CTM:People using the Corporate ID. That's an out of the box option. Without FTS turned on it works fine, but I have to search in all uppercase because that is how our ID's are stored. For example mine is something similar to this: GHTY78. With FTS turned on it's not working. I as an administrator can log in and it works for me. I can enter the first three characters of my ID in either upper or lower case and it returns two possible entries in the type-ahead list. If I enter the entire ID it finds only one result (which makes sense, since our ID's are unique). However....when I login to our test environment as a regular user and enter the same three characters (or even all 6) we get a message that says "The query matched more than the maximum number of entries specified for retrieval ARWARN 66". This makes zero sense, for two reasons. First, this is a test server, and the limit set in the server configuration for "Max entries returned by GetList" is at 5,000,000. That's 10X the number of records in CTM:People. Second, there should only be two matches total, or one when I enter the entire thing. Plus, an administrator should see more records than a regular user or at least the same number. Never less.... BMC is working on it but they have not found any results yet. It's interesting to note that there are no errors in the SQL/API/Filter logs from this, so I'm starting to think it's some kind of limit on the mid-tier. However, there's still only 1 or 2 search results, depending on how you do the test. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
