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.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Indexes that aren't really there ** Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson <n...@ncsu.edu> wrote: 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" _attend WWRUG12 www.wwrug.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"
