Emptying the system TEMP

[alex1368]

Hello friends
I have a large amount of data in Excel that I want to load into SQL Server after performing the ETL operation, but I am facing a problem, which is that the system buffer is full and the workflow gives an error and I need to empty the system TEMP! Please teach me how to do this systematically! Teach me how to create a workflow that automatically empties the system TEMP every 1 hour.

[k10shetty1]

Hello @alex1368,

To manage this issue, you can clear the temp folder contents:

1. Find the Temp Folder:
   Go to Preferences → KNIME and check the **Directory for temporary files

2. Cleanup:

• Create a KNIME workflow with a Delete Files/Folders node to clear the temp folder.
• To schedule the workflow to run every hour, you might need to use KNIME Server

3. Optional: Change the temp folder location in Preferences → KNIME if needed.

This should resolve the buffer issue. Let me know if you need more help!

Best,
Keerthan