Page 1 of 1

passing values to start loop activity

Posted: Thu Apr 19, 2007 11:51 am
by madhukar
i am passing values to start loop from a comma delimited file.
it runs well till the last value and aborts while processing last value.

any thought on this

Posted: Thu Apr 19, 2007 12:02 pm
by DSguru2B
What error message does it throw?

Posted: Thu Apr 19, 2007 3:08 pm
by ray.wurlod
Is there an output link (unconditional trigger) from your EndLoop activity to "the rest of the job sequence"?

Posted: Fri Apr 20, 2007 2:29 am
by madhukar
job sequence design looks like this

command activity -->start loop-->job1-->end loop

i have a filelist.txt --> file1.txt,file2.txt,file3.txt\n
in command activity ---> cat filelist.txt
start loop activity mapped to command output
job1 input is mapped ---> start loop counter

file1, file2 processes fine but when it comes to third iteration file3 it fails with the following error
<sequence_name>..JobControl (@<job1_stage_name>): Controller problem: Error calling DSSetParam(<input_file_paramter_name_of_job1>), code=-4
[ParamValue/Limitvalue is not appropriate]

sorry for not putting a proper readable code

Posted: Fri Apr 20, 2007 4:25 am
by ray.wurlod
You've specfied comma as the delimiter, and DataStage is finding \n character. You can not have the \n character here. Or have all \n characters; specify it as the delimiter, and use ls -1 to get the list of file names.