Limitation of the number of parameters

rohithmuthyala · Post by **rohithmuthyala** » Thu Jun 03, 2010 12:35 pm

Hi All,

I have a generic Sequence job to extract data which has 5 parameters:

1)Parameter File
2)Table Name
3)ColumnNames
4)Filter
5)Type

I'm trying to run this through dsjob -run command in Unix,

dsjob -run -jobstatus -param ${ParameterFile} -param ${TableName} -param ${ColumnNames} -param ${Filter} -param ${Type} ${ProjName} ${JobName}

It's giving an error message as below,

DSEngine/bin/dsjob: 0403-027 The parameter list is too long.
rc 4

Can anyone please help on this.

I checked and confirmed that the jobs are taking the same number of parameters as I've run the job directly from director.

anbu · Post by **anbu** » Thu Jun 03, 2010 12:42 pm

Add set -vx before dsjob command and check the trace for anything wrong in the parameter values

anbu · Post by **anbu** » Thu Jun 03, 2010 12:44 pm

Add set -vx before dsjob command and check the trace for anything wrong in the parameter values

vinothkumar · Post by **vinothkumar** » Thu Jun 03, 2010 1:05 pm

Have you ever run your jobs through command prompt earlier.

datskosaraju · Post by **datskosaraju** » Thu Jun 03, 2010 1:28 pm

vinothkumar wrote:Have you ever run your jobs through command prompt earlier.

ok, now what has this to do with his question?

chulett · Post by **chulett** » Thu Jun 03, 2010 1:41 pm

I would wager it is complaining about the total length of your parameter values, rather than the number of them. So... how long are the values? You can certainly pass more than 5 parameters, btw.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 03, 2010 2:10 pm

What is the limit on the length of a command in your particular UNIX? Are you reaching this limit?

rohithmuthyala · Post by **rohithmuthyala** » Fri Jun 04, 2010 12:15 am

@Anbu: I've tried this
dsjob set -vx -run -jobstatus -param ${ParameterFile} -param ${TableName} -param ${ColumnNames} -param "${Filter}" ${ProjName} ${JobName}

But i'm getting the same error.

@Vinoth: Yes, I've run a similar job having 1 parameter less.

@Craig: Actually I've run a similar job which has a parameter less but the length of the parameters was greater in that job when compared to this job.

@Ray: I'm not sure how to check out the maximum length of the command in my UNIX.

ArndW · Post by **ArndW** » Fri Jun 04, 2010 4:16 am

If "getconf ARG_MAX" doesn't work, please tell us your shell and UNIX type.

chulett · Post by **chulett** » Fri Jun 04, 2010 5:55 am

So... no information on the actual parameter values you are passing? Length, content, nothing?

chulett · Post by **chulett** » Fri Jun 04, 2010 5:58 am

ps. Anbu said (and meant) before dsjob, as in a separate line:

set -vx
dsjob -run

This should enable verbose debugging information, from what I recall. But again, that could depend on your UNIX and shell, something you haven't passed along.

vinnz · Post by **vinnz** » Fri Jun 04, 2010 11:42 am

rohithmuthyala wrote: @Vinoth: Yes, I've run a similar job having 1 parameter less.

@Craig: Actually I've run a similar job which has a parameter less but the length of the parameters was greater in that job when compared to this job.

what is the new parameter value (please give the details that Craig has already asked for)? Are there any special characters/quotes etc in the value?