I have a issue when im reading from a text file. This is a job sequence. Job1 (J1) creates a text file with one row. (out put of j1 will be 1234 just a number). then i use a execute command stage to read this value from the file. The command is cat and in the parameter i have given /<path_name>/<file_name.txt>. then there is a third one job3 (J3) this takes the value from the out put of the execute command and uses as a parameter to generate surrogate key.
Code: Select all
J1 ----> EXE_Cmd ----> J3
1)Info
Sequence_Restart..JobControl (@Execute_Command_39): Executed: cat /etl/PDAODS_Dev/temp/text.txt
Reply=2
Output from command ====>
cat: 0652-050 Cannot open /etl/PDAODS_Dev/temp/text.txt.
2) warning message:
Sequence_Restart..JobControl (@Job_Activity_33): Controller problem: Error calling DSSetParam(LastKey), code=-4
[ParamValue/Limitvalue is not appropriate]
3)Sequence_Restart..JobControl (@Coordinator): Summary of sequence run
15:59:50: Sequence started
15:59:50: Job_Activity_28 (JOB Unix_Mail) started
15:59:57: Job_Activity_28 (JOB Unix_Mail) finished, status=1 [Finished OK]
15:59:57: Execute_Command_39 (COMMAND cat) started
15:59:57: Execute_Command_39 finished, reply=2
15:59:57: Job_Activity_33 (JOB update_table_job) started
15:59:57: Exception raised: @Job_Activity_33, Error calling DSSetParam(LastKey), code=-4 [ParamValue/Limitvalue is not appropriate]
15:59:57: Sequence failed