dbTalk Databases Forums  

conversion script for Enterprise Replication - catch 22 problem

comp.databases.informix comp.databases.informix


Discuss conversion script for Enterprise Replication - catch 22 problem in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
caver
 
Posts: n/a

Default conversion script for Enterprise Replication - catch 22 problem - 08-16-2005 , 08:12 AM






Hi. We converted a database running on HP-UX 11.11 from 9.21 to 9.4
without a problem, but when we ran the script to convert ER, we hit a
snag.

The error message said "Enterprise Replication should be in a stopped
state for conversion/reversion to proceed."

The problem is it already was in a stopped state.

I tried a "cdr stop" for good measure, but received a message
"Enterprise Replication not active"

I tried "cdr start", but this is where the catch 22 started:
"Enterprise Replication already active"

I keep stopping, then starting, then stopping then starting, but so far
nothing has changed after an hour and a half
of stopping and starting, I'll just keep trying though.

If anyone has any ideas or has run into this problem, any help would be
greatly appreciated.
(O.K. I was kidding about the hour and a half thing)

Thanks,
Daniel

Details:

/opt/informix/etc/conv $ ./concdr.sh 9.21 9.4
Starting 'syscdr' conversion ...
'syscdr' conversion failed. For details look in
/opt/informix/etc/concdr.out
more ../concdr.out
Converting 'syscdr' database ...
Enterprise Replication should be in a stopped state for
conversion/reversion to proceed.
'syscdr' conversion failed. For details look in
$INFORMIXDIR/etc/concdr.out.
/opt/informix/etc/conv $ cdr stop
command failed -- Enterprise Replication not active (62)
/opt/informix/etc/conv $ cdr start
command failed -- Enterprise Replication already active (63)
/opt/informix/etc/conv $


Reply With Quote
  #2  
Old   
Madison Pruet
 
Posts: n/a

Default Re: conversion script for Enterprise Replication - catch 22 problem - 08-16-2005 , 09:18 AM






What is the value of cdrstate in syscdr?

"caver" <dmcbryde (AT) courts (DOT) state.va.us> wrote

Quote:
Hi. We converted a database running on HP-UX 11.11 from 9.21 to 9.4
without a problem, but when we ran the script to convert ER, we hit a
snag.

The error message said "Enterprise Replication should be in a stopped
state for conversion/reversion to proceed."

The problem is it already was in a stopped state.

I tried a "cdr stop" for good measure, but received a message
"Enterprise Replication not active"

I tried "cdr start", but this is where the catch 22 started:
"Enterprise Replication already active"

I keep stopping, then starting, then stopping then starting, but so far
nothing has changed after an hour and a half
of stopping and starting, I'll just keep trying though.

If anyone has any ideas or has run into this problem, any help would be
greatly appreciated.
(O.K. I was kidding about the hour and a half thing)

Thanks,
Daniel

Details:

/opt/informix/etc/conv $ ./concdr.sh 9.21 9.4
Starting 'syscdr' conversion ...
'syscdr' conversion failed. For details look in
/opt/informix/etc/concdr.out
more ../concdr.out
Converting 'syscdr' database ...
Enterprise Replication should be in a stopped state for
conversion/reversion to proceed.
'syscdr' conversion failed. For details look in
$INFORMIXDIR/etc/concdr.out.
/opt/informix/etc/conv $ cdr stop
command failed -- Enterprise Replication not active (62)
/opt/informix/etc/conv $ cdr start
command failed -- Enterprise Replication already active (63)
/opt/informix/etc/conv $




Reply With Quote
  #3  
Old   
caver
 
Posts: n/a

Default Re: conversion script for Enterprise Replication - catch 22 problem - 08-16-2005 , 11:32 AM



Here is the info from dbaccess:

state ver_major ver_minor

4 0 0

Thanks,
Daniel


Reply With Quote
  #4  
Old   
caver
 
Posts: n/a

Default Re: conversion script for Enterprise Replication - catch 22 problem - 08-22-2005 , 01:39 PM



The "catch 22" issue was resolved with assistance from online support
(#437614) by updating the syscdr state, then re-running the

./concdr.sh 9.21 9.4

command again.

The program got further along, but still crashed due to a problem
with our sqlhosts file setup.

Since the sqlhosts file problem is a separate issue, I will treat as a
different post.

Thanks for all the help.
Daniel


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.