Project and Portfolio Management Practitioners Forum
cancel

Issue with ksc_set_env

Highlighted
siva_narayana
New Member.

Issue with ksc_set_env

Hi

 

I am trying to set source and destination environment dynamically through the below script in a workflow execution script. During the execution of the last line I am getting the error(Execution log attached).  Just want to understand how exactly ksc_set_env is used and if I am doing anything wrong as far as syntax is concerned. Appreciate any guidance.

 

ksc_itg_run_sql QUERY_STRING="SELECT environment_id FROM kenv_environments where environment_name='[VP.P_SVN_SERVER]'"
ksc_set S_ID=[SQL_OUTPUT]
ksc_itg_run_sql QUERY_STRING="SELECT environment_id FROM kenv_environments where environment_name='[VP.P_PPM_ENVIRONMENT]'"
ksc_set D_ID=[SQL_OUTPUT]
ksc_set_env SOURCE_ENV_ID="[S_ID]" DEST_ENV_ID="[D_ID]"

 

 

I am even tried hardcoing the environment, but even that gave the same error. 

 

 

Thanks

Shankar