DSXchange

I am getting the following error when I run my job "Unrecognized argument: ) [argvcheck/argvcheck.C:3832]" apart from this it doesn't display anything.Could you please let me know what is the cause of the problem.

Do you know which stage this is happening at?

It doesnot even say that in the log.

Then can you please post the unedited log???

Set APT_DISABLE_COMBINATION to true and re-run the job.

I found the problem,when you run the query and in the where clause condition s if a column=job parameter and the job parameter is an empty string it aborts.

Example-: select empno,ename from emp where empno in (#ENO#)
where ENO is a job parameter and its value is ('123','') then as empty string '' is there it aborts but the same query when you run it in database it works.

It could be the reason that when job parameter value has empty string it would convert internally into some value and it fails the code.

Not sure what job parameter converts an empty string but please post back if you know it and how do we handle that situation.

What happens if you provide two non-empty values. Something like '123','456' - together.