putRecord() called on output port 0 multiple times

KSHITHIJA · Post by **KSHITHIJA** » Thu Oct 06, 2011 2:51 pm

Hi,
In a parallel job, a lookup stage is using a Sybase table as a reference link, it's a sparse lookup. This job is aborting with following error - "putRecord() called on output port 0 multiple times per activation of the processing logic of the operator."

Can anybody knows about this error?

Thanks,
Sreeni.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 06, 2011 3:11 pm

Welcome aboard.

Have you enabled the option in the Lookup stage that allows multiple rows to be returned from the reference input link?

KSHITHIJA · Post by **KSHITHIJA** » Fri Oct 07, 2011 3:12 pm

You are right, but when i use Sparse Lookup it is not showing the input link in the "Multiple rows to be returned from the reference input link".

Thanks
Sreeni.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 07, 2011 5:09 pm

My bad. I didn't notice you're doing a sparse lookup. A sparse lookup expects no duplicates - it expects that you're doing a lookup on the primary key (or some other column supported by a unique index).

KSHITHIJA · Post by **KSHITHIJA** » Fri Oct 07, 2011 5:32 pm

Thanks Ray

DSXchange

putRecord() called on output port 0 multiple times

putRecord() called on output port 0 multiple times

Thank you so much Zenith Solutions (Australia) Pty Ltd.