February 3, 2008 at 11:31 pm
Could anyone please explain to me what the following error means...
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MY_LINKEDSERVER" returned message "Not enough space on temporary disk."
This is the error message I get the minute i click on the Export button in the application.. for importing data from Access to SQL.
What is temporary disk?
I seem to have enough free space on all drives!!
February 4, 2008 at 12:06 am
Perhaps your SQL Server tempdb is full?
Alternatively, you may have an TEMP environment variable that's pointing to an invalid location.
February 4, 2008 at 12:11 am
Seems to be either your tempdb got full or your temp folder in your disk (c:\temp) is full. Please check it out.
Thanks,
Balaji L
February 4, 2008 at 4:15 am
Could you tell me how exactly I'm supposed to know if my tempdb is full?
It's set to unrestrictive growth by default, right?
And what about the Temp folder? When does that get used?
February 4, 2008 at 9:16 am
Though tempdb is in auto grow if the mapped drive is full it wont create space.
Check the below command and try to find tempdb size.
DBCC SQLPERF ( LOGSPACE )
Thanks,
Balaji L
February 4, 2008 at 11:08 am
DBCC SQLPERF(logspace) will give u only the details of the log file. u can check it using sp_helpdb and check the size parameter. most likely you need to truncate the log of the tempdb so free up space.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 5, 2008 at 10:30 am
I want to add one more thing here.
dbcc sqlperf (logspace) gives how much % log files are filled.
sp_helpdb gives the allocated space MB.
Thanks,
Balaji L
February 5, 2008 at 10:52 am
Nisha (2/4/2008)
Could you tell me how exactly I'm supposed to know if my tempdb is full?It's set to unrestrictive growth by default, right?
And what about the Temp folder? When does that get used?
As to the OS-level temp folder, "out of disk space" message is often symptomatic of "access denied to that folder" - meaning either there is NO temp directory environment variable, the variable is incorrect or pointing to something that doesn't exist, or the credentials you're operating under doesn't have access to the folder.
It performs the same function as TempDB - gives an application scratch temporary space should it need some to do whatever it does.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 5, 2008 at 10:03 pm
OK.. Like I said, application throws this error on Export to SQL (from Access).
I decided to debug the SP to see the exact point of error.
This is what I found:
The query
Update My_LinkedServer...Access_Table
Set ID=@MaxID+T.Rank
From TempTable T
has 775,500 records to update.
This is where it says 'No space on temporary disk.'!
After using the top percent to update the Access table, i realized that it updates a max of only 9.5 percent at one go without throwing the error. Which is approx. 73,000 records being updated in Access without any problem.
The minute I say update top (10) percent, it throws the same error.
Now, why is this happening??
April 23, 2008 at 10:36 am
Making the changes to the registry per this article made my problem go away:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286153
April 23, 2008 at 11:18 pm
Thanks Benjamin!! This seems like the solution I've been looking for!
I'm yet to try it out cuz I need to get my hand on the application and db.. will let you know if it worked for me 🙂
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply