Overwriting a file that has teh "append to Existing Fil

JPalatianos · Post by **JPalatianos** » Wed Nov 03, 2010 11:02 am

Hi,
We have a sequnece that calls multiple jobs and each job after the 1st one appends data to a sequential file created in job1. The developer came by my desk and we we kicked off the sequence and I was on the server watching the file being recreated for every job. Has anyone seen behavior like this before. I double checked all the jobs and they have the "Append to Existing File" checked. As the servers admin I have made no changes on it.....any ideas what may cause this behavior. This job has been running fine for over a year now.
Thanks - - John

ray.wurlod · Post by **ray.wurlod** » Wed Nov 03, 2010 1:01 pm

At what point is the file actually created? Can you recompile the job(s)?

JPalatianos · Post by **JPalatianos** » Wed Nov 03, 2010 1:14 pm

I recompiled all the jobs in the sequence as well as the sequnece but the same overwrite issue. I am watching the file on the server when i kick off the sequence and I see that it is created by the first job...goes from 25=>13=>12=>5=>77=>681=>2 to finally 1KB as it passes from the first to the last job.

JPalatianos · Post by **JPalatianos** » Wed Nov 03, 2010 2:55 pm

After investigating a bit further looks like the developer had the other admin change one of the admin variables for the path (for the file) to include the last "\" before the file name. Not sure what it did but when this was correceted everything is working fine again.
Thanks - - John