Lookup job failure
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Lookup job failure
Hi,
I have developed the job in which i m using Lookup stage,but the job is getting aborted and giving error message is:-
Lookup_1,0: Could not map table file "/etlstg/datasets/lookuptable.20090506.hlpp0hd (size 541052504 bytes)": Not enough space
Error finalizing / saving table /tmp/dynLUT87267436f27d22
My config file is
main_program: APT configuration file: /dshome/Ascential/DataStage/Configurations/etlstg_dataset.apt
{
node "node1"
{
fastname "CNDAIRPZDBDT03"
pools ""
resource disk "/etlstg/datasets" {pools ""}
resource scratchdisk "/dshome/Ascential/DataStage/Scratch" {pools ""}
}
.................................
At resource disk mountpoint there are around 220 GB of space is free but still my job is getting aborted.
Please provide me any possible solution.
Thanks in advance
I have developed the job in which i m using Lookup stage,but the job is getting aborted and giving error message is:-
Lookup_1,0: Could not map table file "/etlstg/datasets/lookuptable.20090506.hlpp0hd (size 541052504 bytes)": Not enough space
Error finalizing / saving table /tmp/dynLUT87267436f27d22
My config file is
main_program: APT configuration file: /dshome/Ascential/DataStage/Configurations/etlstg_dataset.apt
{
node "node1"
{
fastname "CNDAIRPZDBDT03"
pools ""
resource disk "/etlstg/datasets" {pools ""}
resource scratchdisk "/dshome/Ascential/DataStage/Scratch" {pools ""}
}
.................................
At resource disk mountpoint there are around 220 GB of space is free but still my job is getting aborted.
Please provide me any possible solution.
Thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 96
- Joined: Fri Apr 17, 2009 5:58 am
- Location: Delhi
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 96
- Joined: Fri Apr 17, 2009 5:58 am
- Location: Delhi
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
If you were not getting the desired result that doesn't always mean that the stage is not working correctly. It may be due to wrong logic.
If you are sure it dosen't work the report it as a bug with IBM with sample.
Well. it works fine for me.
You can avoid putting unnecessry columns to the reference link. If you have already done that then you can always use join stage with left outer join and downstream filter to get the rejected records.
If you are sure it dosen't work the report it as a bug with IBM with sample.
Well. it works fine for me.
You can avoid putting unnecessry columns to the reference link. If you have already done that then you can always use join stage with left outer join and downstream filter to get the rejected records.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)