This error : Not enough space on temporary disk.

[Guest]

Hello

I speak for my client, he is on Windows Server 2019 is on a license of Coldfusion 10.

It is since a week he has this kind of message:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.

Resources: 
• Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option.

You have how to solve this problem.

Kind regards

Michel

[Dave Watts]

This might seem like a silly response, but how much free space is on the disk?

Dave Watts, Eidolon LLC

[Guest]

Hello

The capacity is 770 GB free.

Kind regards

Michel

[Dave Watts]

Well, that should be plenty of space shouldn't it! But perhaps there's an Access-specific problem here. I see plenty of search results when I search on "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk." I'd take a look at the answer provided at the end of the first result:

https://community.adobe.com/t5/coldfusion/not-enough-space-on-temporary-disk-error/td-p/596658

It lists three things to do: disable "maintain connections" in your datasource settings, limit the number of connections, and restrict the connection pool to 1. It seems to me that if you do the first one you shouldn't have to do the others, but I honestly haven't tried it.

My recommendation is, really, don't use Access. It's not designed for use with a web site, or any other client-server scenarios.

Dave Watts, Eidolon LLC

[Guest]

It lists three things to do: disable "maintain connections" in your datasource settings, limit the number of connections, and restrict the connection pool to 1. It seems to me that if you do the first one you shouldn't have to do the others, but I honestly haven't tried it.

Hello

This, I find it or in the admin area of coldfusion.

Kind regards

Michel

[Dave Watts]

Yes, you'll find it in the datasource settings for the Access datasource in the CF Admin.

Dave Watts, Eidolon LLC

[BKBK]

Might the Access database have reached its size limit, perhaps? I read somewhere of a 2GB limit. If so, creating some space might help.

There is another suggestion from the web. Check your environment variables, and make sure that the value of the variables TEMP and TMP is the full path of the Temp directory.  

However, even if you solve the problem, you can be sure you will encounter this same, or some other, MS Access problem again in future. The ODBC Microsoft Access Driver is outdated. Plus, there is very little support for it out there.

A thought: use a JDBC driver instead.

A good example is UCanAccess. It is Open Source, hence free. See my previous posts on UCanAccess:

https://community.adobe.com/t5/coldfusion/cf16-and-access-datasource/m-p/9341326 
https://community.adobe.com/t5/coldfusion/coldfusion-2021-and-access-database/m-p/11735544 

There I explain the steps you need to implement UCanAccess in ColdFusion.

Replacing the ODBC Microsoft Access Driver with UCanAccess as your Access driver is a worthwhile investment of your time. In so doing, you will not only solve the current problem, but also future-proof your application.

[Guest]

My client asks me this:

Or we find this:

There is another suggestion from the web. Check your environment variables, and make sure that the value of the variables TEMP and TMP is the full path of the Temp directory.  

Kind regards

Michel

[Dave Watts]

You can certainly do all of those things. Unless you have multiple partitions, they'll all point to some location on the single drive which has plenty of space free. But if you do have multiple partitions, say for example your system/OS stuff on C and other stuff on D, I wouldn't be surprised if your C drive is full and your environment variables still point to C.

Dave Watts, Eidolon LLC

[Guest]

Hello
Thank you for answering
We 2 To in Raid in nvme
Question, is it possible to enlarge the Temp directory at the quota level or is it not possible?
Thank you very much

Michel

[Dave Watts]

I'm not sure I understand your question, exactly. But you can simply point the temp directory to the place where all your storage is, in the environment settings for your computer.

Dave Watts, Eidolon LLC