N
Nayden
Hello,
I get a "not enough space on teporary disk" error coming
up when I run an append query in Access. I have tried all
the solutions suggested in other posts - none of them
helped. I have also tried looking up the error on MS KB
site, Google, anything I could think of. Nada. I hope you
can help. Here is my environment:
Server - DELL PowerEdge 2650
HDD - C:\ - 16.8 GB (10.8 GB free); D:\ - 136 GB (65 GB
free)
RAM - 2 GB
OS - Windows Server 2003 Enterprise Edition
App - MS Access 2000 SP3, all available patches installed
from Office Update
DB - Local - SQL 2000 SP3, Remote - Informix 7.31.FD2
Running the following append query pulling data from a
remote (over WAN link) Informix database:
INSERT INTO [Current_Month-1_ptchg_ldgr_Data] ( pt_cd,
chrg_date, clnc_cd, prcdr_cd, qty, pr_item, status_date )
SELECT prodadmn_ptchg_ldgr.pt_cd,
prodadmn_ptchg_ldgr.chrg_date,
prodadmn_ptchg_ldgr.clnc_cd,
prodadmn_ptchg_ldgr.prcdr_cd, prodadmn_ptchg_ldgr.qty,
prodadmn_ptchg_ldgr.pr_item,
prodadmn_ptchg_ldgr.status_date
FROM prodadmn_ptchg_ldgr LEFT JOIN dbo_TREATMENT ON
(prodadmn_ptchg_ldgr.prcdr_cd = dbo_TREATMENT.prcdr_cd)
AND (prodadmn_ptchg_ldgr.pt_cd = dbo_TREATMENT.pt_cd) AND
(prodadmn_ptchg_ldgr.chrg_date = dbo_TREATMENT.chrg_date)
AND (prodadmn_ptchg_ldgr.clnc_cd = dbo_TREATMENT.clnc_cd)
WHERE (((prodadmn_ptchg_ldgr.chrg_date)>#3/1/2003#) AND
((prodadmn_ptchg_ldgr.prcdr_cd) In
(621,622,821,822,823,799,899,900)) AND
((prodadmn_ptchg_ldgr.status_cd) In (31,37)) AND
((dbo_TREATMENT.pt_cd) Is Null) AND
((dbo_TREATMENT.chrg_date) Is Null) AND
((dbo_TREATMENT.clnc_cd) Is Null) AND
((dbo_TREATMENT.prcdr_cd) Is Null));
I refresh the linked tables in Access then start running
the query. After about 15 minutes I get the "not enough
space on temporary disk" error.
The same query (same Access database) runs fine on
another Infomrix database (a clone of the production one
but with less records) without issues. The production DB
should come up with about 500,000 records. The test DB
(where the query runs) comes back with about 2500 records
to append.
The same query (same Access DB) runs fine on a Windows
2000 Server (similar hardware config)
This is what I have tried so far:
1. Doubled pagefile.sys (it is now up to 8 GB, split
between C:\ and D:\)
2. changed %TEMP% from %USERPROFILE%\Local Settings\Temp
to D:\TEMP
3. changed %TMP% from %USERPROFILE%\Local Settings\Temp
to D:\TEMP
4. Increased HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Jet 4.0 | MaxLocksPerFile from 9500 to 95000
5. Increased the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
4.0 | MaxBufferSize from 0 to 4096
Apparently, none of the above helped...
Any suggestions are welcome!
Nayden
I get a "not enough space on teporary disk" error coming
up when I run an append query in Access. I have tried all
the solutions suggested in other posts - none of them
helped. I have also tried looking up the error on MS KB
site, Google, anything I could think of. Nada. I hope you
can help. Here is my environment:
Server - DELL PowerEdge 2650
HDD - C:\ - 16.8 GB (10.8 GB free); D:\ - 136 GB (65 GB
free)
RAM - 2 GB
OS - Windows Server 2003 Enterprise Edition
App - MS Access 2000 SP3, all available patches installed
from Office Update
DB - Local - SQL 2000 SP3, Remote - Informix 7.31.FD2
Running the following append query pulling data from a
remote (over WAN link) Informix database:
INSERT INTO [Current_Month-1_ptchg_ldgr_Data] ( pt_cd,
chrg_date, clnc_cd, prcdr_cd, qty, pr_item, status_date )
SELECT prodadmn_ptchg_ldgr.pt_cd,
prodadmn_ptchg_ldgr.chrg_date,
prodadmn_ptchg_ldgr.clnc_cd,
prodadmn_ptchg_ldgr.prcdr_cd, prodadmn_ptchg_ldgr.qty,
prodadmn_ptchg_ldgr.pr_item,
prodadmn_ptchg_ldgr.status_date
FROM prodadmn_ptchg_ldgr LEFT JOIN dbo_TREATMENT ON
(prodadmn_ptchg_ldgr.prcdr_cd = dbo_TREATMENT.prcdr_cd)
AND (prodadmn_ptchg_ldgr.pt_cd = dbo_TREATMENT.pt_cd) AND
(prodadmn_ptchg_ldgr.chrg_date = dbo_TREATMENT.chrg_date)
AND (prodadmn_ptchg_ldgr.clnc_cd = dbo_TREATMENT.clnc_cd)
WHERE (((prodadmn_ptchg_ldgr.chrg_date)>#3/1/2003#) AND
((prodadmn_ptchg_ldgr.prcdr_cd) In
(621,622,821,822,823,799,899,900)) AND
((prodadmn_ptchg_ldgr.status_cd) In (31,37)) AND
((dbo_TREATMENT.pt_cd) Is Null) AND
((dbo_TREATMENT.chrg_date) Is Null) AND
((dbo_TREATMENT.clnc_cd) Is Null) AND
((dbo_TREATMENT.prcdr_cd) Is Null));
I refresh the linked tables in Access then start running
the query. After about 15 minutes I get the "not enough
space on temporary disk" error.
The same query (same Access database) runs fine on
another Infomrix database (a clone of the production one
but with less records) without issues. The production DB
should come up with about 500,000 records. The test DB
(where the query runs) comes back with about 2500 records
to append.
The same query (same Access DB) runs fine on a Windows
2000 Server (similar hardware config)
This is what I have tried so far:
1. Doubled pagefile.sys (it is now up to 8 GB, split
between C:\ and D:\)
2. changed %TEMP% from %USERPROFILE%\Local Settings\Temp
to D:\TEMP
3. changed %TMP% from %USERPROFILE%\Local Settings\Temp
to D:\TEMP
4. Increased HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Jet 4.0 | MaxLocksPerFile from 9500 to 95000
5. Increased the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
4.0 | MaxBufferSize from 0 to 4096
Apparently, none of the above helped...
Any suggestions are welcome!
Nayden