lookup error

pavan_test · Post by **pavan_test** » Mon Sep 07, 2009 8:24 pm

Hi All,

My etl job sometimes aborts with this error;

Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table

can anyone please suggest me what might be causing this error message and the job to abort.

Thanks
Mark

ray.wurlod · Post by **ray.wurlod** » Mon Sep 07, 2009 8:39 pm

You have not defined a default disk pool (one whose name is "") in your configuration file, but have used a stage type that requires the existence of the default disk pool.

Solution: add a default disk pool (ideally containing all resource disks).

chulett · Post by **chulett** » Mon Sep 07, 2009 10:22 pm

Don't really see how this can be a 'sometimes' thing, unless you mean you only use the Lookup stage sometimes or do lookups with this particular config file sometimes. Or are you saying that your problematic job sometimes works correctly and sometimes generates this error?

pavan_test · Post by **pavan_test** » Tue Sep 08, 2009 8:29 am

Actually now all the jobs are aborting (which ran successfully previously) with this error message;

Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table.

this is what I see in my config file;

{
node "node1"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage0" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "buffer"}
}
node "node2"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage1" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "buffer"}

}
}

Please advice me

Thanks
Mark

algfr · Post by **algfr** » Tue Sep 08, 2009 8:32 am

For each of these folders, check the remaining space using a df function

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 08, 2009 8:35 am

Add a default pool for all resources.

Alternatively change all jobs which uses the pools to use your named ones.

To include the available in default, append "" after each pool definition.

pavan_test · Post by **pavan_test** » Tue Sep 08, 2009 8:51 am

I executed df, it appears There is enough space in the directories;

Filesystem 512-blocks Free %Used Iused %Iused Mounted on

/dev/fs18 33554432 20534560 39% 457 1% /opt/IBM/IIS/dstage0

/dev/fs19 33554432 11569544 66% 405 1% /opt/IBM/IIS/dstage1

/dev/fs20 50331648 49999784 1% 56 1% /opt/IBM/IIS/scratch0

/dev/fs21 50331648 50001184 1% 51 1% /opt/IBM/IIS/scratch1

Thanks
Mark

pavan_test · Post by **pavan_test** » Tue Sep 08, 2009 8:54 am

[quote="Sainath.Srinivasan"]Add a default pool for all resources.

Alternatively change all jobs which uses the pools to use your named ones.

To include the available in default, append "" after each pool definition. ...[/quote]

I can't change in each job since i have around 200 etl jobs.

Can you please tell me how do I add default pool for all resources.

Thanks
Mark

pavan_test · Post by **pavan_test** » Tue Sep 08, 2009 9:38 am

I changed the default pool in my configuration file and all jobs competed successfully.

Thanks All.

Thanks
Mark