Can not create sort temp files

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Dan
Posts: 80
Joined: Tue Oct 10, 2017 12:44 pm

Can not create sort temp files

Post by Dan » Mon May 05, 2003 10:14 am

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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Can not create sort temp files

Post by kfleming » Mon May 05, 2003 1:42 pm

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

agiwvsihuf
Posts: 0
Joined: Thu Apr 05, 2018 4:24 pm

==> RE: Can not create sort temp files

Post by agiwvsihuf » Mon May 12, 2003 12:49 pm

____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? __

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Can not create sort temp files

Post by kfleming » Mon May 12, 2003 1:16 pm

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

agiwvsihuf
Posts: 0
Joined: Thu Apr 05, 2018 4:24 pm

====> RE: Can not create sort temp files

Post by agiwvsihuf » Mon May 12, 2003 5:11 pm

____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.______________

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: Can not create sort temp files

Post by kfleming » Mon May 12, 2003 8:15 pm

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

agiwvsihuf
Posts: 0
Joined: Thu Apr 05, 2018 4:24 pm

======> RE: Can not create sort temp files

Post by agiwvsihuf » Tue May 13, 2003 4:47 pm

____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.____

Post Reply