run index maintenance error

[Bruce Easton]

GCC Consulting wrote Tuesday, April 17, 2007 11:32 AM:
> Bruce,
> 
> Just modified the selection process to use demand index 1.
> 
> Then index error now says the l_card index K is invalid.  There 
> is no index
> K,  the last auto index is index I.
> 
> Now this is getting even more interesting.  
> 
> I think I'll sent this to fp support as there is definitely 
> something wrong.
> 
> Richard 
> 
[..]

Richard, some more things to consider:

Are there any other lookups anywhere else in either your 
selection table/output table?  If so, I would rebuild those indexes as 
well. (Understanding that you said there is no auto table at play here 
and also understanding you said you get the error right as you execute 
the first lookup of the current file.)

Are your *cabe programs 5.6 as well?

Does the data look OK in that file when you browse it by rec# and put 
key field(s) on the browse and sample beginning, middle and end of the 
file?

Have you tried rebuilding freechain (then reindexing)?

Understanding that you are getting different results with the runtime 
programs, it certainly seems like a tokenization issue.


Bruce

Bruce Easton
STN, Inc.