Unrecognized argument: ) [argvcheck/argvcheck.C:3832]

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Aug 05, 2009 8:44 am

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.

ArndW · Post by **ArndW** » Wed Aug 05, 2009 9:17 am

Do you know which stage this is happening at?

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Aug 05, 2009 9:30 am

It doesnot even say that in the log.

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 05, 2009 9:39 am

Then can you please post the unedited log???

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 05, 2009 10:04 am

Set APT_DISABLE_COMBINATION to true and re-run the job.

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Aug 05, 2009 4:40 pm

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 06, 2009 2:13 am

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