When using datageneration and a numeric PK, the table does not update. This table is a simple table with two fields: a numeric PK and a varchar. Options used during the publish:
"On duplicate on data target: Update" "On generated duplicate: Remove".
The reason for the above options is that if the line exists, update it. But, when it tries to publish, it gives this showing an duplicate index insert error :
ERROR: Publish failed for job 758, Insert into TbBandeiraCartao failed: UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO [DWBI_DTWH].[TbBandeiraCartao] ([CdBandeiraCartao],[NmBandeiraCartao]) VALUES (?,?)]; SQL state [QGA03]; error code [21]; SQL Anywhere Error -1002003: Tried to insert a duplicate value into a unique index DWBI_DTWH.TbBandeiraCartao.ASIQ_IDX_T5912_I3_HG on row 7. -- (slib/s_ohcins.cxx 964) ; nested exception is com.sybase.jdbc4.jdbc.SybSQLException: SQL Anywhere Error -1002003: Tried to insert a duplicate value into a unique index DWBI_DTWH.TbBandeiraCartao.ASIQ_IDX_T5912_I3_HG on row 7. -- (slib/s_ohcins.cxx 964) End date and time: 2018/05/28 10:35:34
Even if i choose continue, or prompt, it always returns the error... Why is it not respecting the PK? If I use these options normally on SYBASE ASE, and it works... SYBASE IQ, it doesn't.
Environment
TDM, on 4.3 version. SAP SYBASE IQ/16.0 database CA TDM PORTAL.
Resolution
This is resolved in TDMWeb-4.3.70.0.zip as well as TDMWeb-4.5.21.0.zip. Please contact CA Support for either of these versions or later. If you are installing a GA that is after June 15, 2018, please contact CA Support to verify that this fix was incorporated in your GA.