Absent Member.. ManojKumarNS Absent Member..
Absent Member..
506 views

kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Absent Member.. ManojKumarNS Absent Member..
Absent Member..

Re: kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

Jump to solution

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

0 Likes
1 Reply
Absent Member.. ManojKumarNS Absent Member..
Absent Member..

Re: kcs_set is not working along with ksc_run_sql and ksc_itg_run_sql

Jump to solution

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.