Limitation of the number of parameters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
Limitation of the number of parameters
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.
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.
Rohith
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
@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.
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.
Rohith
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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?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.