Re: Enterprise Replication CDR GC cache query failed
Hello,
What do you mean by "current releases of 7.31" ?
Other Question :
Is it possible to replicate columns from different table from the
primary to one table on the target ?
I can't find any example.
To be clear,
On Primary, I have table A with column1 and I have table B with
column2
I want to replicate this 2 columns to only one table C on the Target,
so, I should have Table C with column1 and column2.
Is it possible ?
Can you give me the syntax ?
Or a link where it is explained because in the "official" Informix
Replication Enterprise that I found on the IBM site, there is only
simple example using replication between 2 tables that are the same.
Thanks a lot for your help.
Bj
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<CaOlc.31591$I%1.1980122@attbi_s51>...
> 7.31 still uses the pending states table. I suspect that is where the error
> messages are coming from. There was a problem with the pending states table
> not being properly cleaned up when the state changed. It has been fixed with
> current releases of 7.31.
>
>
> "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> news:89d8947b.0405040029.2775c357@posting.google.com...
> > HELLO,
> >
> > I'm working with 2 SCO OpenServer 5.0.7.
> > Each with Informix Dynamic Server Version 7.31.UC2
> >
> > Here is an example of one of my replicate definition
> >
> > cdr define repl -C ignore -a "19:00" repl_dwmd_partn
> > "P alcib_53@g_MRX2:awserv.dwmd_partn"
> > "select pano,patype from dwmd_partn"
> > "R alcib_720@g_UGND:informix.dwmd_partn"
> > "select siteno,pano,patype from dwmd_partn;update dwmd_partn set
> > siteno=53"
> >
> > As you can see, I have a primary with only 2 columns and I try to
> > replicate it on a target with 3 columns where I force the 1st column
> > "siteno" to still have the integer 53 as value.
> > Am I wrong when I do like that ?
> >
> > Regards,
> > Noreddine
> >
> > "Madison Pruet" <mpruet@comcast.net> wrote in message
> news:<qUslc.16546$IG1.572692@attbi_s04>...
> > > Version number?
> > >
> > > This means that something has happened with the definition of the
> original
> > > replicate definition.
> > > We had a problem in 7.x product in which the pending states table was
> not
> > > properly cleaned up when a replicate's state changed that would cause
> this
> > > message as well. You might be running into that.
> > >
> > > M.P.
> > >
> > >
> > > "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> > > news:89d8947b.0405030241.8bb3f95@posting.google.com...
> > > > Hello,
> > > >
> > > > I'm trying to activate the enterprise replication between 2 servers.
> > > > When I type on each of the servers
> > > >
> > > >
> > >
> ############################################################################
> > > ####
> > > >
> > > > $ cdr list repl> > > > REPLICATE STATE CONFLICT FREQUENCY OPTIONS
> > >
> --------------------------------------------------------------------------
> > > --
> > > > repl_dwi_coe ACTIVE ignore time 19:0 row
> > > > repl_dwi_head ACTIVE ignore time 19:0 row
> > > > repl_dwi_item ACTIVE ignore time 19:0 row
> > > > repl_dwi_sae ACTIVE ignore time 19:0 row
> > > > repl_dwmd_bran ACTIVE ignore time 19:0 row
> > > > repl_dwmd_claim ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coce ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coe ACTIVE ignore time 19:0 row
> > > > repl_dwmd_cont ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coun ACTIVE ignore time 19:0 row
> > > > repl_dwmd_country ACTIVE ignore time 19:0 row
> > > > repl_dwmd_kind ACTIVE ignore time 19:0 row
> > > > repl_dwmd_partn ACTIVE ignore time 19:0 row
> > > > repl_dwmd_product ACTIVE ignore time 19:0 row
> > > > repl_dwmd_region ACTIVE ignore time 19:0 row
> > > > repl_dwmd_sae ACTIVE ignore time 19:0 row
> > > > repl_dwmd_site ACTIVE ignore time 19:0 row
> > > > repl_dwmd_staff ACTIVE ignore time 19:0 row
> > > > repl_dwmd_waregroup ACTIVE ignore time 19:0 row
> > > > repl_dwo_coe ACTIVE ignore time 19:0 row
> > > > repl_dwo_head ACTIVE ignore time 19:0 row
> > > > repl_dwo_item ACTIVE ignore time 19:0 row
> > > > repl_dwo_sae ACTIVE ignore time 19:0 row
> > > > repl_mitarb ACTIVE ignore time 19:0 row
> > > > repl_yag ACTIVE ignore time 19:0 row
> > > > repl_ykag ACTIVE ignore time 19:0 row
> > > > repl_yvowg ACTIVE ignore time 19:0 row
> > > > repl_yvuwg ACTIVE ignore time 19:0 row
> > > > cdr: can't fetch replicate
> > > > SQL code -461 :Cannot open file 'csql.iem'.
> > > >
> > > > ISAM 0 :
> > > >
> > > >
> > >
> ############################################################################
> > > ####
> > > >
> > > > BUT on the online.log, I receive a lot of messages
> > > >
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.> > > >
> > > > Can someone say me why ?
> > > >
> > > > Regards,
> > > > Bj