Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    NL
    Posts
    2

    Thumbs down Unanswered: Erro in replication

    Hello,

    I know that when the missing message appears that this will be rectified with the next set op replications.

    But what if the missing message keeps appearing.

    Do ik have to make a new database for this user or can i do something else.

    See the example below.

    Kind regards,

    Erik van der Groef.

    ----------------------------------
    Sybase SQL Remote Message Agent Version 5.5.03 Build #1666
    Copyright by Sybase, Inc., and its subsidiaries, 1988, 1997.
    All rights reserved. Sybase is a trademark of Sybase, Inc.
    Incoming messages from directory s:\replins\ins_5000000000012
    Received message from "cos_001" (11-0102936538-0)
    Applying message from "cos_001" (11-0102936538-0)
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    Received message from "cos_001" (11-0105254105-0)
    Received message from "cos_001" (11-0106589624-0)
    Received message from "cos_001" (11-0107153366-0)
    Received message from "cos_001" (11-0107237753-0)
    Received message from "cos_001" (11-0107262054-0)
    Received message from "cos_001" (11-0107468490-0)
    Received message from "cos_001" (11-0107496911-0)
    Received message from "cos_001" (11-0107591202-0)
    2003-08-22 12:30:26.884
    Missing message from "cos_001"
    Processing transaction logs from directory "C:\STEK\Database"

    ---------------------------------

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: Erro in replication

    The fastest way to synchronize is to re-extract the remote.

    If there have been lot of transactions that have occured on the remote since the last sucessfull replication. Then one xtra step is to translate the tran log at the remote. Deploy the newly extracted remote and apply the translated log and then resync.

    Cheers,

    Willy

    Originally posted by ErikvanderGroef
    Hello,

    I know that when the missing message appears that this will be rectified with the next set op replications.

    But what if the missing message keeps appearing.

    Do ik have to make a new database for this user or can i do something else.

    See the example below.

    Kind regards,

    Erik van der Groef.

    ----------------------------------
    Sybase SQL Remote Message Agent Version 5.5.03 Build #1666
    Copyright by Sybase, Inc., and its subsidiaries, 1988, 1997.
    All rights reserved. Sybase is a trademark of Sybase, Inc.
    Incoming messages from directory s:\replins\ins_5000000000012
    Received message from "cos_001" (11-0102936538-0)
    Applying message from "cos_001" (11-0102936538-0)
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    SQL statement failed: (-194) no primary key value for foreign key 'MECID' in table 's_certif_p_mech'
    Transaction failed
    Received message from "cos_001" (11-0105254105-0)
    Received message from "cos_001" (11-0106589624-0)
    Received message from "cos_001" (11-0107153366-0)
    Received message from "cos_001" (11-0107237753-0)
    Received message from "cos_001" (11-0107262054-0)
    Received message from "cos_001" (11-0107468490-0)
    Received message from "cos_001" (11-0107496911-0)
    Received message from "cos_001" (11-0107591202-0)
    2003-08-22 12:30:26.884
    Missing message from "cos_001"
    Processing transaction logs from directory "C:\STEK\Database"

    ---------------------------------

  3. #3
    Join Date
    Aug 2003
    Location
    NL
    Posts
    2

    Thumbs up

    Hello Willy,

    Is there anyway to find out why the sql failed errors occur.

    Kind regards,

    Erik.

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Yeah.. I remember a similar bug reported on this issue.

    There is a nasty workaround, however I find it cleaner to re-extract than to fiddle with tables.
    Originally posted by ErikvanderGroef
    Hello Willy,

    Is there anyway to find out why the sql failed errors occur.

    Kind regards,

    Erik.

Posting Permissions

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