When publishing a row that contains a SQL Stored Procedure, it fails with the following snippet from the TDMPublishLog:
2018-03-29 20:00:24.619 UTC [INFO ] [taskExecutor-5 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: ERROR: Publish failed for job 6, Update of EVT_EVENT failed … 2018-03-29 20:00:24.698 UTC [ERROR] [taskExecutor-5 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: com.ca.tdm.common.exception.TDMException: Update of EVT_EVENT failed at com.ca.tdm.publ.output.TDMPublishTGTOutput.outputRow(TDMPublishTGTOutput.java:250) at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromRow(TDMPublishJobStart.java:1387) at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromView(TDMPublishJobStart.java:1312) at com.ca.tdm.publ.model.TDMPublishJobStart.doPublishTables(TDMPublishJobStart.java:1069) at com.ca.tdm.publ.model.TDMPublishJobStart.doPublish(TDMPublishJobStart.java:562) at com.ca.tdm.publ.publthread.TDMPublishThread.run(TDMPublishThread.java:46) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
As a result, nothing gets published.
TDM Portal 4.3
Please contact Support to get TDMWeb-22.214.171.124.zip or later. If you are on a later GA version, please check with Support to make sure that this fix made it into that later version you are on.
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 ARD by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1354547.html.
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.