Issue while reading file with pattern
Posted: Thu Apr 23, 2009 9:53 am
In our production run time, we are facing some issues while reading files with pattern. It is giving one warning masage :
SQ_Merge_PHYSICAL_CHARGE_INFO,0: Couldn't find any files on host SVHJ0029 with pattern /data02/prepaid/apps/SCPDB/Outgoing/DEL/DL_CS_ND00_20090423160039_0000_12690_LoadReady_PHYSICAL_CHARGE_INFO*.dat
but all files are their in the required dir location. If we rerun the job it gets the files and read them properly. This job is running 12 times in a day but this problem we are getting almost once in 2-3 days, sometime that frequency increases.
Files with that pattern are getting generated by other jobs (with diffrent apt_config_file) in the seq before this job (where we are reading the files with pattern).
Is it because of the network issue (when trying to read the file from storage connetion is getting disrupted anyway) or it is because of any other thing?
I would be really greatful if anyone please give some clue on this.
One more thing is it possible to fail the job (while reading with pattern) when it does not get any file with that pattern.
SQ_Merge_PHYSICAL_CHARGE_INFO,0: Couldn't find any files on host SVHJ0029 with pattern /data02/prepaid/apps/SCPDB/Outgoing/DEL/DL_CS_ND00_20090423160039_0000_12690_LoadReady_PHYSICAL_CHARGE_INFO*.dat
but all files are their in the required dir location. If we rerun the job it gets the files and read them properly. This job is running 12 times in a day but this problem we are getting almost once in 2-3 days, sometime that frequency increases.
Files with that pattern are getting generated by other jobs (with diffrent apt_config_file) in the seq before this job (where we are reading the files with pattern).
Is it because of the network issue (when trying to read the file from storage connetion is getting disrupted anyway) or it is because of any other thing?
I would be really greatful if anyone please give some clue on this.
One more thing is it possible to fail the job (while reading with pattern) when it does not get any file with that pattern.