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.
TDM, on 4.3 version.
SAP SYBASE IQ/16.0 database
CA TDM PORTAL.
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.
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.