PaTaKi


Hello,
I have a table (in Access) with about 30 fields and 1,700,000 records.
I had created a mining model in AS2005 with only one key (the autonum column called ID)
and other attributes marked as Input and/or predict.
When processing the model, it finish (after 15 min.) with an error: 3183
"Not enough space in temporal disk"
After some search , I encountered that is close related to the memory asigned to the tempdb.
I tried to increase the size of tempdb but it is imposible, moreover, it starts
with 8MB but it is autosized when needed.

I don't know how to solve this issue. Or, if it is a question of memory/disk space management (I have 100GB of free space in disk).
I tried the same model changing the KEY (I assign StudyID as key) then with the same data but 60,000 StudyIDs it is ok, so the mining model is ok (no nested tables, no case, too easy for getting a memory error)...

Please, can anyone recommend a possible solution for this issue .
Many Thanks.




Re: Error "Not enough space for temporal database" when processing Decision Tree model

ggciubuc


is it a problem if you import Access table in SQL Server and rebuild DataSource and DataSourceView for new situation







Re: Error "Not enough space for temporal database" when processing Decision Tree model

Jamie MacLennan

Yes, I imagine the issues is with Access trying to order 1.7M records, but can't be sure without more information. Importing the data into SQL Server as ggciubuc suggests may work. If you post the complete error text and processing output it may help diagnose the problem.