Re: -640 Qplan failure occur after migrate from 7.22 to 7.24

Jack M. wrote: > > Hi Every expert. > > I discovered that a error -640 Qplan failure occure in executing > dbschema -d dbname -hd tabname after migration from 7.22 to 7.24. I> performed update statistics high for table on indexed column, however > the error still occur. > > I checked that the distribution table are existed, and the checking > oncheck -cr, cc passed after migrate.> > Please ,anyone can give me a ideal what is wong. What sub-version of 7.24? There were some problems with some versions before 7.24UC5 related to creating invalid distribution data. What version EXACTLY do you have, you may have to upgrade again?!? Also did you try dropping all current distributions first (UPDATE STATISTICS LOW FOR <tabname>) before building the new ones? You may not have replace the ones that are giving you the problem. Art S. Kagel