Hi All,
When I run a job, I get the following Fatal error message:
"D:/IBM/InformationServer/Server/Datasets/lookuptable.20081028.entx23d (size 1623935520 bytes)": Not enough space
When I go to the particular path there is no such kind of file exits. I have enough space in the specified drive.
Could some one please help me how to handle this.
Best Regards
Cherry
Not Enough Space
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The file does not exist becase DataStage determined that there was not enough space to create it.
Do you have at least 1623935520 bytes free on D:/IBM/InformationServer/Server/Datasets while the job is running (note that other Data Sets will also need space here)?
Do you have at least 1623935520 bytes free on D:/IBM/InformationServer/Server/Datasets while the job is running (note that other Data Sets will also need space here)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Not Enough Space
No, you don't. Or didn't.cherry wrote:I have enough space in the specified drive.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Not Enough Space
There is about total of 60 GB free on the D Drive. Since this is windows, I guess that the entire space that is available would be taken by the processes. please let me know if I am wrong.
Is your job doing a lookup or a sort. What size is the reference data to the lookup or the the data being sorted?
If it is trying to do either of these in memory with about 1.6GB of data (as per the message) you can expect it to fail as Windows cannot allocate this much memory for these processes. Try changing your job design.
If it is trying to do either of these in memory with about 1.6GB of data (as per the message) you can expect it to fail as Windows cannot allocate this much memory for these processes. Try changing your job design.
Re: LookupTable error message: Permission Denied
Hi. I am writing with a similar issue using the lookup stage. I am getting a permission denied. Here is the message:
Could not create/truncate table file "/workarea/DataStage/DataSets/lookuptable.20081105.ndqynaa": Permission denied
It seems kind of obvious now, but is this because I need permission to write to this particular directory?
Thanks in advance,
Nicole
Could not create/truncate table file "/workarea/DataStage/DataSets/lookuptable.20081105.ndqynaa": Permission denied
It seems kind of obvious now, but is this because I need permission to write to this particular directory?
Thanks in advance,
Nicole
cherry wrote:Hi All,
When I run a job, I get the following Fatal error message:
"D:/IBM/InformationServer/Server/Datasets/lookuptable.20081028.entx23d (size 1623935520 bytes)": Not enough space
When I go to the particular path there is no such kind of file exits. I have enough space in the specified drive.
Could some one please help me how to handle this.
Best Regards
Cherry