Hi Fred, Nope, it is the other way around.... Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table.
Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > So there are indexes on the T table, but no record of them in SCHEMA_INDEX. > Then Oracle knows of them, but ARS should not. > > Have you tried restarting the app (as the index info is held in memory > while the server is running) > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of L G Robinson > Sent: Tuesday, October 25, 2011 12:49 PM > To: arslist@ARSLIST.ORG > Subject: Indexes that aren't really there > > ** > Hi Folks, > > My AR System is confused about the indexes on a particular form. The AR > System believes that there are four indexes on this particular form but in > the database (Oracle) there are no entries for this form in the SCHEMA_INDEX > table. When I attempt to delete the indexes using Dev Studio, I get errors: > > Failure during SQL operation to the database : ORA-01418: specified > index does not exist, 552, AR System User Central File > > and I can see from the SQL logs: > > */*** ERROR *** ORA-01418: specified index does not exist > > So it appears that there is some other place within the AR System that > still indicates that there are indexes on this form. Can anyone tell me > where to look? > > I understand the dangers of mucking around directly in the database tables. > This is my development system, so the results of a mistake will not be > catastrophic. > > Thanks. > Larry > > ARS: 7.6.03 - Solaris 10 > Oracle: 11.2.0.1.0 - 64bit > > Larry Robinson > NC State University > Remedy Admin/Developer > 919-515-5432 > n...@ncsu.edu > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"