Re: create index online

> From: informix-list-bounces@iiug.org on Behalf Of Davorin Kremenjas > Sent: Thursday, November 05, 2009 1:09 PM > > On Nov 5, 8:24 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > emmendingen.de> wrote: > > Hi all, > > > > I created a new index ONLINE. Thought that would cause no > problems in > > production. > > > > However, one program reported errors: > > > > > Program stopped at > "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > > 464. > > > Date: 04.11.2009    Time: 18:51:54 > > > > > Program error at > "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > > 464. > > > SQL statement error number -710. > > > > > Table (informix.ap_da_v1) has been dropped, altered or renamed. > > Hi, > > what's your onconfig param AUTO_REPREPARE set to? > If you reconnect your app this should go away, rebuilding an index on > the table changed the table metadata (i.e. version). > > HTH > > Davorin AUTO_REPREPARE is set to "1". In onconfig it is claimed that this should "Minimizes the occurrence of the -710 error." The 4gl-program is quite old. Could that be the reason? Thanks, Reinhard.