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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
