ParamValue/Limitvalue is not appropriate

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kondeti
Premium Member
Premium Member
Posts: 67
Joined: Sat Mar 04, 2006 11:38 am

ParamValue/Limitvalue is not appropriate

Post by kondeti »

Hi Everyone,
This is my sequencer design.

Job1 ---> Execute Command ----> Job2

Job1 ---> In job1 I am generating one job name into a text file.

Execute Command ---> I am executing "type path....file.txt".

Job2 ---> I am passing the job name value as a parameter to the job2.

The above sequencer is Aborting and it is generating the below error message. I already searched for the same in the site. But, I didn't understand the exact problem for my sequencer failure. Can anyone help me on this? Thank you.

[b]"POC_Sequencer..JobControl (@Job_Activity_16): Controller problem: Error calling DSSetParam(pJobName), code=-4
[ParamValue/Limitvalue is not appropriate]"[/b]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There are 62 matches for that error message. I picked one at random and it seems to have everything you need in it. If it doesn't help, please let us know why, which part isn't making enough sense and we'll see what we can do about that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kondeti
Premium Member
Premium Member
Posts: 67
Joined: Sat Mar 04, 2006 11:38 am

Post by kondeti »

Thank you so much Chulett.

I am passing the Execute_Command output to a Before Subroutine as a job name to generate dsjob -report. With your suggestion I used below code in the job activity and it resolved my issue. Thank you.

Code: Trim(EReplace(Execute_Command_18.$CommandOutput,@FM,""),("":'"':""), "A")

Here I was trying to understand @FM behavior, I have gone thru the DataStage documentation this is what I got.

@FM Field mark.
@IM Item mark.
@SM Subvalue mark.
@TM Text mark.
@VM Value mark.

Can you please explain me how @FM is helped to resolve this problem. Thank you.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

look for the last comment by Craig in the topic mentioned below

viewtopic.php?p=308527&highlight=#308527
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply