join_Hash_Value,3: Write to dataset on [fd 13] failed????

[Developer9]

Hi ,

Job Design:

Previous days Dset Dataset (Hashed filed)
^ ^
^ (hash key look up)
Todays Dset>> CDC >>>>>>>>> >>>>> join >>>>>>>>>>


>>>>>>xfm >>>Seq file


Error:
/opt/etl/Ascential/DataStage/PXEngine.752.1/etc%%LI NK%% -APT_PMsetupFailedFlag

/opt/etl/Ascential/DataStage/PXEngine.752.1/bin/osh -APT_PMsectionLeaderFlag XXXX 10004 7 30 node8 xxxx 1312227322.70216.2030de



Fatal:xfm_Defaults,0: Failure during execution of operator logic.

join_Hash_Value,0: Write to dataset on [fd 13] failed: Broken pipe
xfm_Defaults,0: Input 0 consumed 499 records.
xfm_Defaults,0: Output 0 produced 498 records.
xfm_Defaults,0: Fatal Error: Null value on the accessor interfacing to field "xxxxxxxxx".

Please give me clue about this erroe
thank you

[ray.wurlod]

What job type? You marked it "parallel" yet you are talking about a hashed file, which is not supported in parallel jobs.

Use Code tags to make your design clearer.

[chulett]

I'm thinking "hashed field" rather than "hashed file" and that they are referencing the partitioning.

[Developer9]

@ray,

Sorry If I made you confuse ..its the Hashed value not the file .

Its the Hashed filed (gerated already by using Java hash script algorithm)present in Dataset.

I am performing join with some join key.

My target File is Seqfile:


Dataset (Hashed filed)
^
CDC Stage >>>Join >>xfm >>>>>Target (Seq file )


Following Error:

xfm_Defaults,1: Fatal Error: Null value on the accessor interfacing to field "xxxxxx"



Logic used ij Xfm:If IsNull(toXFM.xxxxen 0 Else toXFM.xxxxx

Datatype:small int Nullablity:NULL (FOR SOURCE AND TARGET)
please help me with clue ..ty