Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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 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

  • 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 comment
    10|10000 characters needed characters exceeded