CA TDM Portal - Publish JOB doesnt Respect PK

Document ID : KB000101954
Last Modified Date : 13/09/2018
Show Technical Document Details
Issue:
 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.
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