ER - Replicate in ALTERMODE state
Posted in 2007
Topics: High Availability & Replication
Hi all, We use ER between 10.00.UC4 servers. One of our replicates remains in ALTERMODE state, so that it is not possible to update the table replicated through that replicate. We updating the table, we get the error 19992: "-19992 Cannot perform insert/delete/update operations on a replicated table while the table is in alter mode The specified operation cannot be performed on a table defined for replication if the table is in Enterprise Replication alter mode. If you want to perform the specified operation, you must unset the Enterprise Replication alter mode." Please, how could we "unset Enterprise Replication alter mode" ? Thank you, Philippe
philippe wrote: > Hi all, > > We use ER between 10.00.UC4 servers. > > One of our replicates remains in ALTERMODE state, so that it is not > possible to update the table replicated through that replicate. > > We updating the table, we get the error 19992: > "-19992 Cannot perform insert/delete/update operations on a replicated > table while the table is in alter mode > > The specified operation cannot be performed on a table defined for > replication if the table is in Enterprise Replication alter mode. > If you want to perform the specified operation, you must unset the > Enterprise Replication alter mode." > > Please, how could we "unset Enterprise Replication alter mode" ? cdr alter --off <table> > > Thank you, > Philippe > >