Originally posted by: SystemAdmin

I have a 6.7.1 event server running a map which listens for files arriving in a folder triggering on .. The files are small and ftp'd into the folder. I am finding sometimes that maps are failing with Source not available and it would appear that I am getting 2 triggers for the file - once when it is created and secondly when the ftp has completed.
I'm sure there's a setting in the mercator.ini file to delay triggering in these circumstances but I can't find it in the documentation.
Any ideas?
Jan
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Thanks for that Tarun.
I thought there was a way to prevent a trigger being actioned if the time stamp on a file changed by less than a certain value.
For instance at 6.5.2 I had a map which triggered on a file and it did a getandset on that file as it processed records. A second trigger was only generated when the map completed if the resulting change in the time stamp was greater than say 5 secs. (I can't remember the exact value) This check must be missing from 6.7.1 or is a much smaller value.
Jan
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

We have used our Enterprise scheduler to create a trigger file after the successful completion of the job that does the FTP. This works great for us, that way we know for sure that the FTP'd file has been completely written before the map is executed.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Sorry, maybe I don't understand. If the input file (trigger) is unavailable because its still being written to your map would normally fail wouldn't it? If that is the case in 6.5.* you have the ability use retry? Of course, if you are creating logs and evaluating them it might be an issue but otherwise you shouldn't get output, right?

jvanboga

ps: Tarun's suggestion, adjusting 'TriggerTime' help?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I tried changing the TriggerTime and this worked in most cases where the file was small ( <15K) but sometimes the files are larger. I could increase the TriggerTime but I can't predict the correct value accurately.
Therefore I'm going to use the rename facility in the ftp.
Thanks for your help.
Jan
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender