By any chance are there indexed on that form (table) in the database that are not being shown to you in the Admin tool? Did someone create indexed directly in the database?
On Tue, Mar 18, 2008 at 4:42 PM, Steven Pataray <[EMAIL PROTECTED]> wrote: > ** > > 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
