The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Execution command step exception

Highlighted
JatinRana
Super Collector

Execution command step exception

Below is my execution command step

ksc_itg_run_sql QUERY_STRING="select ('[REQD.P.P_AE_ST1]'+ nvl('[REQD.P.P_AE_ST2]',0)+ nvl('[REQD.P.P_AE_ST3]',0)) from dual" ENV_NAME="[DEST_ENV.ENVIRONMENT_NAME]"

ksc_store REQD.P.P_AE_ST="[SQL_OUTPUT]"

If nothing is provided for [REQD.P.P_AE_ST1] (passing no value)

Getting exception as below,

KSC SQL Query
Source Command: System Test Actual Efforts

Running query: select ('''+ nvl('',0)+ nvl('',0)) from dual

Unexpected error!

ERROR: java.sql.SQLException: ORA-01756: quoted string not properly terminated

Why getting an extra quote in sql string if the value of [REQD.P.P_AE_ST1] is passed as nothing

Can you suggest me a fix to this issue as how to take care of '[REQD.P.P_AE_ST1]'(if passed no value) in my execution command step?
1 REPLY
Jim Esler
Honored Contributor

Re: Execution command step exception

Are you sure the field itself is empty? Check the contents of the entry in kcrt_request_details.
//Add this to "OnDomLoad" event