Skip to Content
author's profile photo Former Member
Former Member

How to find source repdef ?

Message from server: Message: 2601, State 2, Severity 14 -- 'Attempt to insert duplicate key row in object 'tab1' with unique index 'tab1_ix1'

corresponding record in exception log

=============================

1> rs_helpexception 2 ,'v'

2> go

Detailed Summary of Logged Transaction # 2 on 'ServerA_rs'

Origin Site Origin User Org. Commit Date #Cmds in Xact

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

serverA.db1 sa Nov 2 2015 5:30 3

Dest. Site Dest. User Date Logged

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

ServerA.db2 maintuser Nov 2 2015 5:30

This transaction was skipped due to a 'resume connection' command with the 'skip transaction' option.

Rejected Records

textval

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

A0158 05iso_1distribute 1 ~";Nov 2 2015 5:30:43:013PM,2 ~"!,3 1 begin transaction ~"! npw ~"#sa osid 0

A0158 05iso_1distribute 2 ~"!,3 3 dump transaction ~!)db1 ~"620151102 17:30:43:013 0x10221d0200000000000000000000000000000032303135313130322031373a33

A0158 05iso_1distribute 1 ~";Nov 2 2015 5:30:43:013PM,2 ~"!,3 1 commit transaction

(return status = 0)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Nov 02, 2015 at 05:24 PM

    If you are trying to find the repdef based on the error message in the log above. You can run the following query in the RSSD

    select objname, phys_tablename from rs_objects where phys_tablename ='tab1'

    go

    objname will be the name of the repdef.

    You can then run rs_helprep <objname> to get more details on the repdef.

    regards

    Terry

    Add a comment
    10|10000 characters needed characters exceeded

    • Looking at the details, the transaction is "dump transaction " on source database getting replicated to target database. This happens if connection to the target has dump_load set to on. Typically used when you are using a feature called coordinated dumps. This is not governed by any repdef but by connection level setting. In my post on 2nd below I have suggested the remedy !!

      HTH

      Avinash

  • Posted on Nov 02, 2015 at 09:35 PM

    Manoj

    What version of RS do yo have ?

    You can use following [e]RSSD stored procedure to find all refdefs for a primary table

    rs_helpreptable source_database, [owner,] table_name

    But in your case --- going by the error message ---- it seems not related to any repdef.

    It looks like dump transaction coammnd has gone through replication pipeline.

    At your site are you using coordinated dump feature of RS ?

    If not just alter the connection not to use coordinated dump

    alter connection ....."dump_load" to "off"

    HTH

    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.