Project and Portfolio Management Practitioners Forum
cancel

kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

SOLVED
Go to solution
Highlighted
ManojKumarNS
Trusted Contributor.

kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

HP PPM version: 9.31

Issue: kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

I created a workflow step with following command but the command is failing.

    ksc_run_sql QUERY_STRING="select 1 from dual"

    ksc_set CUR_DATE ="[SQL_OUTPUT]"

The Execution log for the failed step  says,

       An error occurred during command parsing.

      (KNTA-10127)

      GUID=1679BF8E-1C1D-6854-F9CD-E57C2E5D567E    

      Generated Time=2015/11/24-04:40:42.625 GMT-06:00 Wrong number of parameters.

     ksc_set CUR_DATE ="[SQL_OUTPUT]"

    Failed

 I tried using the below command as well but the step is failing again with same execution log message.

       ksc_run_sql QUERY_STRING="select 1 from dual" ENV_NAME="[ENV.ENVIRONMENT_NAME]"

        ksc_set CUR_DATE ="[SQL_OUTPUT]"

Note: I even tried using ksc_itg_run_sql but it is not helping.

 It would be helpful if I get some help from anyone.

Thanks

Manoj

1 REPLY
ManojKumarNS
Trusted Contributor.
Solution

Re: kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

Sorry the above command is working. The issue was with syntax error in another command.