Forum Stats

  • 3,875,213 Users
  • 2,266,888 Discussions
  • 7,912,114 Comments

Discussions

goldengate error

752716
752716 Member Posts: 30
edited Oct 19, 2010 10:51PM in GoldenGate
can anyone help me to solve the issue..
------------------------------
Operation failed at seqno 0 rba 3388
Discarding record on action DISCARD on error 14400
Problem replicating TABS.DBM_OPER_TRACK to DWTABS.DBM_OPER_TRACK
Error (14400) occurred with insert record (target format)...
*
FILE_ID = 13410926
OPER_ID = CHKDUP
START_TIME = 2010-10-09 13:08:56
END_TIME = NULL
PROCESS_ROWS = NULL
FLEX_FLD1 = NULL
FLEX_FLD2 = NULL
FLEX_FLD3 = NULL
FLEX_FLD4 = NULL
FLEX_FLD5 = NULL
--------------------------------------------------


thanks

Answers

  • 789001
    789001 Member Posts: 6
    An attempt was made to insert a record into, a Range or Composite Range object, with a concatenated partition key that is beyond the concatenated partition bound list of the last partition -OR- An attempt was made to insert a record into a List object with a partition key that did not match the literal values specified for any of the partitions
  • 752716
    752716 Member Posts: 30
    thanks for the update...

    but brother...there are no partition either in source or target database...so what should i do now for this kind of error in goldengate..


    please help...thanks in advance
  • 752716
    752716 Member Posts: 30
    guys,

    i am getting problem now as below:
    ------------------------------------------------------------------
    Operation failed at seqno 0 rba 5266
    Discarding record on action DISCARD on error 1403
    Problem replicating test.employee to test1.employee
    Record not found
    Error (1403) occurred with compressed update record (target format)...
    *
    CONTRNO = 4005908453
    CUSTNO = NULL
    STATUS = 10
    NAME = SHOPON
    CATEGORY = REG
    CURR_PAYM = NULL
    CURR_BAL = NULL
    LANGUAGE = EN
    FIN_INST = NULL
    TARIFF_PROFILE = P
    FLEX_FLD1 = NULL
    FLEX_FLD2 = NULL
    FLEX_FLD3 = NULL
    FLEX_FLD4 = NULL
    FLEX_FLD5 = NULL
    *
    --------------------
  • -joe
    -joe Member Posts: 226
    This usually means you did not add supplemental logging (add trandata) to your table before extract started capturing change data.

    Good luck,
    -joe
This discussion has been closed.