TDM portal: post publish clean up failed when runnning concurrent publishes

Document ID : KB000100422
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
The DELETE statement conflicted with the REFERENCE constraint "FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS". The conflict occurred in database "gtrep", table "dbo.QRTZ_TRIGGERS"

Descriptipn:
When publishing 2 concurrent publishes using different data criteria(honk and P&G) against the same Data Target, TDM Job fails with a publish error
"Error Transaction rolled back because it has been marked as rollback-only"
 
Environment:
TDM Portal 4.5
Cause:
Code needs to be corrected.
Resolution:
This is resolved inTDMWeb-4.5.19.0.zip.  Please contact CA Support for this version.  If getting a GA later than June 6, 2018, please contact CA Suppor to verify that the fix made it into the GA version you are downloading.
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