DATAMAKER - DataGeneration don´t respect PK on insert/update

Document ID : KB000099944
Last Modified Date : 05/06/2018
Show Technical Document Details
Trying to using it to populate a SAP SYBASE IQ/16.0 database, but having an issue with data generation. Attempting to populate a table with a numeric PK. This table is a simple table with two fields: a numeric PK and a varchar. When publishing something on this table, on the window that opens I choose "On duplicate on data target: Update", and "On generated duplicate: Remove" because I want to update the line, if it already exists.  However, I receive the following error:

Error -1002003 for Row #1 in table <<MAINTABLE>>. SQLSTATE = S1000 [Sybase][ODBC Driver][Sybase IQ]

Tried to insert a duplicate value into a unique index <<FULLY QUALIFIED SERVER NAME>>.<<MAINTABLE>>.<<INDEX>> on row 7. No matter what options is chose, it always returns the same error. Why it´s not respecting the PK? I used this options normally on SYBASE ASE, and it´s working. But on SYBASE IQ, it doesn't.
TDM 4.3
Issue in code.
The issue is resolved with . Please ask CA Support for this or a later version.  If you are downloading a GA version after May 31, 2018, please contact CA Support to verify that this fix made it into the GA.
Additional Information:

Video URL on how to open a Support Case -

You can download the latest version of TDM by following the directions in this document:   

To contact support, go to