DSXchange

Below error we are getting when we run the job.


The provided insert statement did not prepare correctly;
please verify that your statement is correct;
statement: INSERT INTO STG.LDM_DWR_CPS_REJECTS (SOURCE_ID, EXTR_BTCH_ID, SUBJECT_AREA, JOB_NAME, ERROR_TXT, ERROR_DT_TIMSTM) VALUES ( :SOURCE_ID, :EXTR_BTCH_ID, :SUBJECT_AREA, :JOB_NAME, :ERROR_TXT, :ERROR_DT_TIMSTM).

Thanks in advance

krisna wrote:please verify that your statement is correct;

Did you?

Also, did the stage generate this DML or is it user-defined?

I'm a bit surprised not to see mention of the ORCHESTRATE object in the VALUES clause.

... which leads me to believe it is the latter.

it's latter part got from director log.

So inspect the stage to let us know whether it's generated or user-defined SQL. We suspect it's the latter, and that whoever constructed the SQL did not know how to reference the ORCHESTRATE object in the VALUES clause.