Liveware Publishing Support Forum

Running R&R version 9.0 on window2000 and will sometimes get the following error and sometime will not:____^Cannot create sort temp files^____(Already checked permissions on the c: emp folder)____Any ideas would be appreciated!__Dan

Do any R&R temporary files get written there successfully? Try running the result set browser and see if that puts an RSBExxx.tmp there.____Kathleen__R&R Support

____What if the .TMP, .SOR, or .TOT file already exists? Would that cause the "Cannot create sort temp files" or "Cannot create totals file"?____A user today got the "Cannot create totals file" error and I can not reproduce it. This is the second time it was brought to my attention. While checking our CITRIX server, I noticed hundreds (400+) of old .TMP, .SOR, and .TOT files out there again. I^ve deleted them once in the past (over 1500 temp files) and things were fine until today.____Kathleen Fleming, what is your take on this? Should I have our network administrator run a clean up routine to get rid of these old temp files on a daily basis? __

Periodic cleanup of the leftover temp files is indeed a good idea.____Kathleen__R&R Support

____I agree, system cleaning is a good thing. But only for reasons like performance, not because an application dicates it in order to run.____You didn^t answer my first question. Would that be the cause of the error? Your application should be checking to see if a temp file already exists under that same name before attempting to use it. That is a basic multiuser application design principal.____If you are 100% certain that it is not the problem, then I need to know so that I can continue address the issues of my users. Otherwise, I will have our networking staff band-aid your software by performing a daily clean up of the temp, sort, and total files left behing when your application fails.______________

I am at least 99% certain. R&R uses a file naming convention that should make a file name collision virtually impossible. ____Kathleen__R&R Support

____Looking at your naming convention (RRWxxxx.TOT, .SOR, .TMP) makes me 99% certain that if your application running on a CITRIX server with 20+ users printing at once will generate collisions unless your application is checking to see if the temp file already exist. ____Can you check with your programming staff and answer my question. My users deserve more than your 99% certainty.____