Anders G. Nordby

Senior Systems Consultant at CGI

Tag Archives: Dynamic Data Store

Solving a Duplicate Error in DDS

This is just a quick note on how to solve a problem in Dynamic Data Store (DDS). It doesn’t really matter how the situation occurred, but suddenly a store in DDS failed because of a duplicate entry. The offending entry was found easily enough (the DDS key was in the error message), and I found the two rows in tlbBigTable that contained this key. The two conflicting rows were identical except for the pkId field. To correct the situation, all I had to do was to delete one of these rows in the tblBigTable table, and also delete the row with the identical pkId field from the tblBigTableIdentity table. Knowing how to solve this problem might come in handy again.