Error executing sql stored procedure "Cannot use the OUTPUT option when passing a constant to a stored procedure"

Document ID : KB000076635
Last Modified Date : 06/04/2018
Show Technical Document Details
Issue:
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.
Environment:
TDM 4.3
TDM Portal 4.3
Resolution:
Please contact Support to get TDMWeb-4.3.68.0.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.
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 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