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
join_Hash_Value,3: Write to dataset on [fd 13] failed????
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 187
- Joined: Thu Apr 14, 2011 5:10 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Use Code tags to make your design clearer.
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.
-
- Premium Member
- Posts: 187
- Joined: Thu Apr 14, 2011 5:10 pm
Re: join_Hash_Value,3: Write to dataset on [fd 13] failed???
@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
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