passing values to start loop activity

[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

[DSguru2B]

What error message does it throw?

[ray.wurlod]

Is there an output link (unconditional trigger) from your EndLoop activity to "the rest of the job sequence"?

[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

[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.