Data Replication 2
Results 1 to 2 of 2

Thread: One Column Changes to NULL after update with successful original Insert.

  1. #1
    AlxB is offline Junior Member
    Join Date
    Jan 2014
    Posts
    9
    Rep Power
    0

    One Column Changes to NULL after update with successful original Insert.

    Hello,

    I have a table which we replicate and everything is working fine except that one column changes to NULL in CDC when there was more than one update done on the row in the source table. The source table still contains the number and only the CDC value is now is a NULL. The column is an integer and is toward the end of the column list. The table also is quite large (around 20 columns).

    Example Process:


    2 - INSERT Column = 12345
    3 - UPDATE Column = 12345
    4 - UPDATE Column = 12345
    3 - UPDATE Column = NULL
    4 - UPDATE Column = NULL

    Any advise in how to solve or trouble shoot this issue would be appreciated.

    Alex

  2. #2
    AlxB is offline Junior Member
    Join Date
    Jan 2014
    Posts
    9
    Rep Power
    0

    Update

    UPDATE:

    After doing some more monitoring: If the original value by the time of the INSERT is NULL, it will also not be updated in a later UPDATE step.
    Again, all other columns update fine.

    Alex

Posting Permissions

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