Load/Sequencer Error

kashif007 · Post by **kashif007** » Mon May 07, 2007 2:13 pm

I am getting the following error when I run a load job through a sequencer.

Table Name,0: Un-handled conversion error on field "CNCR_INCUR_DT " from source type "date" to dest type "raw[7]": source value="**********": Result is non-nullable and there is no handle_null to specify a default value
Un-handled conversion error on field "SRC_SYS_ROW_CREAT_DT " from source type "date" to dest type "raw[7]": source value="**********": Result is non-nullable and there is no handle_null to specify a default value

I am doing a string to date conversion in the the transformer for the fields CNCR_INCUR_DT and SRC_SYS_ROW_CREAT_DT. When I run the job with no sequencer it runs with out any errors but when I run it using sequencer, I get various errors including the conversion error mentioned above. PLease help......

nick.bond · Post by **nick.bond** » Mon May 07, 2007 4:10 pm

double check the values you are passing into the parameters in your job from your sequence job. I imagine there is a mismatch there.