On HelpDesk 6.3 the OTB of the HPD:HelpDesk index's are Category (200000003), Type (200000004) and Item (200000005), Category and Item were the fields referenced in my errors'. Were you able to Delete those Index's to add your own 5? That's why I'm thinking there is a process like do one index at a time or something.
I'm assuming that there's a limit of how many index's you can add which is why I got that ARERR 210. My DBA did already add some index's to my prod box already and that really improved the performance, but do I have to duplicate the same index's in my Admin tool? Will that cause problems? Thanks Steve On 3/19/08, Sanford, Claire <[EMAIL PROTECTED]> wrote: > > ** A word of caution, from personal experience, deleting any of the > existing HPD:Helpdesk indexes may cause you some performance issues. > Especially if your users use the canned reports. > > Our DBA decided he was going to "help us out" last year and deleted the > indexes on the oracle side and built ones he thought we should have. Remedy > still thought "it's" the indexes were there and everything slowed to a > crawl. > > OTB there should be 5 or 6 indexes. I have added 5 of my own without out > causing any problems in performance. I created them via the Admin tool. > > > *Claire Sanford* > Information Systems Division > Memorial Hermann Healthcare System > Phone: 713 448 6035 > [EMAIL PROTECTED] > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Steven Pataray > *Sent:* Tuesday, March 18, 2008 3:42 PM > *To:* [email protected] > *Subject:* How to Index HPD:HelpDesk > > > ** > > I've never tried indexing before. What is the proper proceedure to index > fields from the Admin tool? OTB the Category/Type/Item fields are indexed. I > want to remove those and add the Requester Login Name+, Department, Create > Time and Status fields. But when I save I get errors: > > Failure during SQL operation to the database : ORA-01418: specified index > does not exist (ARERR 552). > Failure during SQL operation to the database : ORA-01418: specified index > does not exist (ARERR 552). > Failure during SQL operation to the database : ORA-01418: specified index > does not exist (ARERR 552). > A duplicate index has been specified -- > duplicate was omitted and indexes were created : 240000005 (ARERR 74). > > Then it says the form was not saved. When I try to first remove the > Category field from the index I get: > > Total length of all fields involved in an index is greater than the > maximum length allowed (ARERR 210). > A duplicate index has been specified -- > duplicate was omitted and indexes were created : 240000005 (ARERR 74). > A duplicate index has been specified -- > duplicate was omitted and indexes were created : 200000003 (ARERR 74). > > But then the Category field is removed from the index tab when I open the > form back up. What is this telling me? > > I did this on my dev server Arsystem 6.3 patch 019 pending to do it on my > 6.3 patch 023 > Oracle 10.1.0.4.0 > HelpDesk 6.3 > > Thanks, > > Steve > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
