Re: -710 - Table (informix.systables) has been dropped, altered or renamed.

What kind of operation you are doing on primary? Some operations on primary (e.g. drop table, update statistics etc) can cleanup dictionary cache on secondary causing 710 error to prepared query. This problem is fixed in 9.40 latest release. -Ajay Gupta "LUQUE Valdivia Omar" <luque001@marina.mil.pe> wrote in message news:<cfeamn$u57$1@news.xmission.com>... > Hi, > > I have two servers in replication, server Bdsalud (Primary) and server Bdcemena (secondary). > I run dbexport in server bdcemena(secondary) and get a following error : > > ********************* > E:\\Backup\\Backup_dbs\\Mar>dbexport cemena -ss > .... > codorigen char(2), > desorigen varchar(50) > ) extent size 64 next size 32 lock mode page; > revoke all on "informix".la_origmcci2142004 from "public";> > -710 - Table (informix.systables) has been dropped, altered or renamed. > ********************* > > Then, i run UPDATE STATISTICS High to database cemena in server Bdsalud(primary) and oncheck -cc too. > In server bdsalud(primary) don't have users connected. > the tables exists fisically in both servers, because are in HDR. > I run a dbexport one more time, but now i get error in another table: > > ********************* > codusu varchar(15), > nopagatemp char(1), > primary key (codcia,nrohis) constraint "dbaval".ct_gn_paciente1 > ) extent size 175000 next size 50000 lock mode page; > revoke all on "informix".gn_paciente from "public";> > -710 - Table (informix.systables) has been dropped, altered or renamed. > ********************* > > That is the only problem... > Our Informix 9.30 installation runs on Windows 2000 Advanced server in both servers. > > Does anybody have any suggestions? Experiences? > > Thanks a lot! > > > Omar LUQUE Valdivia > DBA de Marina > Direcci'n de Telem'tica - Marina de Guerra del Per' > Av. La Marina Cdra. 36 s/n, La Perla - Callao, Lima - Peru > Telf : (511) 614-2900 (511) 562-3900 Ext. 2277 2265 > E-mail : Luque001@marina.mil.pe <mailto:Luque001@marina.mil.pe> > Cel. 9 639-7201 > > sending to informix-list