Results 1 to 1 of 1
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unhappy Unanswered: Enterprise Replication

    I've been preparing two systems for Primary-Target replication and I've successfully defined the primary the primary database server. However, when I try to define the secondary server I get the following error.

    command failed -- *Error* <-1> is not a known Enterprise Replication error (-1)

    The command I used to define the primary server is:
    cdr define server --init g_development

    I've tried several commands for the secondary server:
    This command is run from the primary server:
    cdr define server --connect=demo_on --init --sync=g_development g_swxtest2
    These commands were run from the secondary server:
    cdr define server --init g_swxtest2
    cdr define server --init --sync=g_development g_swxtest2

    In dbaccess on both servers I can successfully access the databases on either server.


    Entries in the services file on both servers:
    onnet 1526/tcp
    idsrep 1530/tcp

    Entries in the hosts.equiv file on both servers:
    swxtest2 informix
    development informix

    sqlhosts on swxtest2:
    s2_demo onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec
    #develop101 onipcshm swxtest2 online
    #develop101inet onsoctcp swxtest2 onnet
    g_development group - - i=101
    develop101inet onsoctcp development onnet g=g_development
    g_swxtest2 group - - i=102
    demo_on onsoctcp swxtest2 idsrep g=g_swxtest2

    sqlhosts on development:
    #demo_on onipcshm on_hostname on_servername
    #demo_se seipcpip se_hostname sqlexec
    develop101 onipcshm development online
    #develop101inet onsoctcp development onnet
    g_development group - - i=101
    develop101inet onsoctcp development onnet g=g_development
    g_swxtest2 group - - i=102
    demo_on onsoctcp swxtest2 idsrep g=g_swxtest2
    #develop101inet onsoctcp swxtest2 onnet g=g_swxtest2

    onconfig files attached.

    Last several lines of the online.log on swxtest2:

    15:41:27 Maximum server connections 0
    15:41:27 Dropping temporary TBLspace 0x100139, recovering 28 pages.
    15:41:27 Checkpoint Completed: duration was 0 seconds.
    15:41:27 Checkpoint loguniq 6, logpos 0x8f0c8, timestamp: 87881

    15:41:27 Maximum server connections 0
    15:41:27 On-Line Mode
    15:45:19 Booting Language <spl> from module <>
    15:45:19 Loading Module <SPLNULL>
    15:45:20 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
    15:45:20 CDR Initialization failed (Catalog Initialization Failed).
    15:46:57 Checkpoint Completed: duration was 0 seconds.
    15:46:57 Checkpoint loguniq 6, logpos 0xf9018, timestamp: 96610

    15:46:57 Maximum server connections 1
    15:47:15 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
    15:47:15 CDR Initialization failed (Catalog Initialization Failed).
    15:48:46 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
    15:48:46 CDR Initialization failed (Catalog Initialization Failed).
    15:50:10 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
    15:50:10 CDR Initialization failed (Catalog Initialization Failed).
    15:50:11 Logical Log 6 Complete, timestamp:122523.
    15:50:11 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 6 Complete, timestamp:122523." "Logical Log 6 Comp
    15:51:57 Checkpoint Completed: duration was 0 seconds.
    15:51:57 Checkpoint loguniq 7, logpos 0x40018, timestamp: 122533

    15:51:57 Maximum server connections 1
    15:56:56 Checkpoint Completed: duration was 0 seconds.
    15:56:56 Checkpoint loguniq 7, logpos 0x41018, timestamp: 122538

    I believe it may have something to do with the failure to create the syscdr database shown in the log above.

    Thanks in advance for your help.

    Mark

    Go SOCA WARRIORS - World Cup 2006
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •