What would be great is a util that validates what actually exists is what is thought to exist.
And - it could run after every install. And - after every upgrade. And - it could run 1/week as part of compliance. BMC should write this - if it does not already exist. (It would catch tons of errors - proactively) As - I have had this before -- and according to the indexes defined by Remedy -- this query should be fast -- but it is not. Turns out -- the index did not actually exist - yet was defined in Remedy :( -John On Oct 25, 2011, at 2:30 PM, L G Robinson wrote: ** 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 <lj.longw...@gmail.com> 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. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. "Building a Better Service Experience" Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
