Thanks for your suggestions Ted. We have a readwrite cursor (unbuffered) and we are trying to create the index from scratch, i.e. at the point that the code runs there is no CDX. This code is running in a DLL
Paul -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: 30 August 2013 14:53 To: [email protected] Subject: Re: Index On failing silently On Fri, Aug 30, 2013 at 7:14 AM, Paul Newton <[email protected]>wrote: > I have a situation where the following command fails to create the > specified index tag (and no error is reported) > > Index On wu_name Tag wctrl1 > > I am completely stumped so if anybody has any suggestions I would be > most grateful > Insufficient description for a lot of good guesses. Is this from the command line or within an application? Get everyone else out of the system, turn it off and back on again, restore from backup if possible. It's likely a corrupted index or table header. First try the index: Make sure you have a backup, of course, and take a fresh one for forensics later. Make sure that you know what all of the tags in the CDX are (the INDEX ON argument as well as any FOR or unusual clauses like UNIQUE). Also, any declared relations as they can disappear when the tags are removed. Completely remove the CDX and build it fresh. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
