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.
The issue is resolved with GTDataMakerPB-126.96.36.199.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.