replication not sent across

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maxzsim - 28 Apr 2006 11:42 GMT

Hi,

I have the following issue :
my replication is txn , immediate updating

This is an existing replication and i am changing one of the acct ABC123's
details via the Application.
From the Replication i could see that it says "1 transaction with 3 command
were delivered"
However, when i check the table of the destination database there's no change

where could i check for the error ?
is there any tables in the distribution table that i could check or i shld be
checking at the subscription database ?

kindly advise

tks & rdgs

Reply to this Message

Daniel Crichton - 28 Apr 2006 11:46 GMT

maxzsim wrote on Fri, 28 Apr 2006 10:42:58 GMT:

> Hi,
>
[quoted text clipped - 11 lines]
> is there any tables in the distribution table that i could check or i shld
> be checking at the subscription database ?

I'd look at the subscriber side to see if something is causing the row
changes to be rolled back - have you added a trigger to the table in the
subscriber?

Dan

Reply to this Message

maxzsim - 28 Apr 2006 11:57 GMT

Hi Dan ,

There's no trigger at the subscriber's end actually .

which MSrepl_XX table in the subscriber will get these changes ?

tks & rdgs

>maxzsim wrote on Fri, 28 Apr 2006 10:42:58 GMT:
>
[quoted text clipped - 9 lines]
>
>Dan

Reply to this Message

maxzsim - 28 Apr 2006 11:55 GMT

Hi,

I have checked the MSrepl_transactions table after i changed the details
again and i could see a new record in that table.

during replication where would this record go to in the destination database ?

tks & rdgs

>Hi,
>
[quoted text clipped - 14 lines]
>
>tks & rdgs

Reply to this Message

maxzsim - 28 Apr 2006 12:17 GMT

Hi ,

Further info is from MSrepl_error there no record for this database

tks & rdgs

>Hi,
>
[quoted text clipped - 10 lines]
>>
>>tks & rdgs

Reply to this Message