Merge Stage

[yksjosh]

HI,

I am using merge stage in one of my jobs.
and the two input sequential file contains 325 records and 5 records respectively.

but the job gets abort with the following message.

MFGCFP_ODS_GL_ALLOCATION_SKU..tLoad: Function 'get_next_output_row' failed
At row 977, link "lmGL_NZ_TRADESPEND_SKU_inp", while processing column "ODS_GENERAL_LEDGER_KEY"
Column 'ODS_GENERAL_LEDGER_KEY' is not 'nullable'.

Fle one contains the column 'ODS_GENERAL_LEDGER_KEY' and I have checked that none of the records have null 'ODS_GENERAL_LEDGER_KEY' .

If some body could guide me in this.

Thanks in advance.

Yogesh

[vigneshra]

Hi Yogesh,

Check your metadata definitions in your job. Also since the number of records is just around 300-400, you can click view data in the stage and see if the columns are populated correctly in each of the records. I think this will help you.

[kumar_s]

Hi,
It wont be null in input, but make sure it is same in the output.
coz after mergre stage, there is the possibility for the null for the unmatched records.

Regards
kumar

[ray.wurlod]

Run the job in the Debugger. Set a breakpoint on the output link. Edit the breakpoint so that the expression is

Code: Select all

IsNull(ODS_GENERAL_LEDGER_KEY)

[changming]

check your mapping in merge stage, make sure all the key for joining two files are used.