Unrecognized argument: ) [argvcheck/argvcheck.C:3832]
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Wed Jul 06, 2005 12:29 am
Unrecognized argument: ) [argvcheck/argvcheck.C:3832]
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 103
- Joined: Wed Jul 06, 2005 12:29 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 103
- Joined: Wed Jul 06, 2005 12:29 am
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.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom