Skip to main content
A
Anonymous
July 6, 2021
Question

This error : Not enough space on temporary disk.

  • July 6, 2021
  • 2 replies
  • 2252 views

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

 

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    July 10, 2021

    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.

     

     

    A
    Anonymous
    July 22, 2021

    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

     

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    July 22, 2021

    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

    Dave Watts, Eidolon LLC
    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    July 6, 2021

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

     

    Dave Watts, Eidolon LLC

    Dave Watts, Eidolon LLC
    A
    Anonymous
    July 6, 2021

    Hello

    The capacity is 770 GB free.

    Kind regards

    Michel

     

     

     

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    July 6, 2021

    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

    Dave Watts, Eidolon LLC
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices