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


Article ID: 76635


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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: Update of EVT_EVENT failed at at at at at at at java.util.concurrent.ThreadPoolExecutor.runWorker( at java.util.concurrent.ThreadPoolExecutor$ at

As a result, nothing gets published.


TDM 4.3
TDM Portal 4.3


Please contact Support to get 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 -
You can download the latest version of ARD by following the directions in this document:   
To contact support, go to