error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
knowledge
Participant
Posts: 101
Joined: Mon Oct 17, 2005 8:14 am

error

Post by knowledge »

Thanks kenneth ,

as this is happing quite often , evey 5 min , I am saving the job with anothe name and compiling , as i have to load the data by aftenoon

I am looking against table , which has null , though I used option in modify stage

colunm name = Handle_Null(colmn name , "Null") its giving me error :

Lookup_32,0: When binding input interface field "REVW_MTHD_CD" to field "REVW_MTHD_CD": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted.


and

Lookup_32,0: sendWriteSignal() failed on node edwdev ds = 19 conspart = 1 Broken pipe

so many error ,

pl suggest

thansk
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

I'm sorry, I'm not tracking where this post originated. Is your original problem about saving a job? These error messages are explanatory, the first warns that the second could occur (and it did), what more do you need supplied?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kerensho
Participant
Posts: 13
Joined: Mon Jul 11, 2005 5:36 am

null

Post by kerensho »

Hello,

Are you sure you remembered to set this column as not nullable on the Modify's output?

Keren
Post Reply