Index Problems

[Joel J.J. Heber]

I built an Index, basic one with the index editor ,

NON-UNIQUE,
not worded,
3 fields asc,
active,
standard index

and after it's creation I try to run a standard module. I get........

CRC for IM-TRANS-PROD does not match CRC in so/batchpa.p Try recompiling (1896)

Unable to locate index gl-control.


Same for all other functions.......I get unable to locate [indexname]

I delete my index and voila everything is normal again......

Can someone relate!!!!!!!!


Help I need this index for a program I wrote or else it's a snail.

Joel


:dead:

 

[Joel J.J. Heber]

MY 2 cents......reflections

I think it is a problem within the shared memory segment.....where the lk file is compared and it isn't the same so it jamms......

Which is probably why it worked fine when I run indexes on the backup server.




hmmmmmmmmm,..........

 

[dkellgren]

Are there any database triggers?

We had a similar issue and had to DELETE our db triggers, commit the changes, then re-add the db triggers. Without doing that, we kept getting CRC errors that we couldn't resolve.

-Dan
Aim

 

[Joel J.J. Heber]

ya there is

tons of them....but i cant read them .....would have to de-compile or reverse-engineer the code.......it's a 3rdparty thing.....we run off a platform.

Joel

 

[Crittar]

Silly question but...

Have you tried re-compiling? I had a similar problem once and a recompile of the program accessing the table cured it.