Re: Update Stats Error -647

Hi, I have some new facts and questions: - Error -647 appears also with "update statistics medium for table" - I found a thread from myself with that issue 3 years ago, though without solution - look a the F.E. Vers.: It is 9.24. The program I used is DB-Access Version 11.50.FC3. AFAIK F.E. Vers. shows the libs used to build the program. Is it ok that the new dbaccess is build with an older library? - The newest libraries should show F.E. Vers. 9.35, shouldn't they? - Is Error -647 an old relict? I saw threads for the issue related to IDS 7.x and 9.x. Can anybody help? TIA, Reinhard. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of Habichtsberg, > Reinhard > Sent: Wednesday, May 27, 2009 11:14 AM > To: Informix-List (E-Mail) > Subject: Update Stats Error -647 > > > Hi, > > with IDS 11.50.FC3 on Solaris 9 it appears the following error: > > 490 UPDATE STATIST kva CR Not Wait > -647 0 9.24 > Off > > Current SQL statement : > UPDATE STATISTICS MEDIUM FOR TABLE kva_efn_gonr (efg_lfd_pos, > efg_leist_dat, efg_leist_anz, efg_begruendung, efg_sachkostenbez, > efg_leist_dat_orig, efg_kz_extrabudget, efg_nbsnr_arzt, > efg_lanr_arzt, > efg_fg_code) sampling size 0.3> > Last parsed SQL statement : > UPDATE STATISTICS MEDIUM FOR TABLE kva_efn_gonr (efg_lfd_pos, > efg_leist_dat, efg_leist_anz, efg_begruendung, efg_sachkostenbez, > efg_leist_dat_orig, efg_kz_extrabudget, efg_nbsnr_arzt, > efg_lanr_arzt, > efg_fg_code) sampling size 0.3> > dbtest-db3_11:/home/informix/migration_auf_11.50/db3%finderr 647 > -647 Error evaluating math library function function-name. > > The data type of the argument is correct, but the value passed to the > function is not appropriate for the math function. Check that you are > passing a legitimate value to the function. > > Number of Rows 1,4878e09 > > Could be a bug with very large tables? > > TIA, > Reinhard.