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

Document ID : KB000099944
Last Modified Date : 05/06/2018
Show Technical Document Details
Issue:
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.
Environment:
TDM 4.3
SYBASE IQ/16.0
SUBSET
Cause:
Issue in code.
Resolution:
The issue is resolved with GTDataMakerPB-4.3.0.54.zip . 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 - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html