Desktop productivity for business analysts and programmers

How to delete temporary files in EG5.1?

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

How to delete temporary files in EG5.1?

Hello All,

I have a question regarding identifying temporary files in EG 5.1. I am trying to import files from MS access by referencing macros. (E.g Filein=&accessfilepath, tablein=A, tableout=A1, etc.) and am receiving an error message

"CLI cursor fetch error: [Microsoft][ODBC Microsoft Access Driver] The query cannot be completed. Either the size of the

query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the

disk to store the query result."

I noticed one way to reduce my temporary file storage is by deleting temp files in "Work" folder under "View"- "SAS Folders"- "Servers" - "Local" - "Library" - "Work". However, almost all my tables in the process flows are stored as "work.XXX" and need to be used. I'm wondering what are the other ways to increase temp folder limit size? or should I change all my "work.XXX" to some other format? Please let me know. Thank you.


Accepted Solutions
Solution
‎07-27-2015 04:07 PM
Respected Advisor
Posts: 3,065

Re: How to delete temporary files in EG5.1?

I appears you are using a local SAS server, that is SAS on your PC with EG. That means your WORK library is most likely on your PC hard drive (confirm by checking Properties on WORK). Check how much free space you have on your hard drive. If there is a lot then that is probably not causing the error. If you don't have much free space then try deleting files you no longer need and any temporary files.

View solution in original post


All Replies
Solution
‎07-27-2015 04:07 PM
Respected Advisor
Posts: 3,065

Re: How to delete temporary files in EG5.1?

I appears you are using a local SAS server, that is SAS on your PC with EG. That means your WORK library is most likely on your PC hard drive (confirm by checking Properties on WORK). Check how much free space you have on your hard drive. If there is a lot then that is probably not causing the error. If you don't have much free space then try deleting files you no longer need and any temporary files.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 756 views
  • 0 likes
  • 2 in conversation