DSXchange

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

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.

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

@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