Lookup Error

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 2:00 am

While running a job, I am getting the following error.
Field "column name" has keyprep export buffer overrun error. Has anyone come across this error before? I searched in the forum but couldnt find any solution.

ArndW · Post by **ArndW** » Mon May 31, 2010 2:03 am

I haven't seen that one before. What stage and what column is triggering this error?

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 2:16 am

Lookup stage and Lookup key column is throwing this error.

ArndW · Post by **ArndW** » Mon May 31, 2010 2:28 am

This is a common error when RCP is used, as the lookup stage returns the lookup key column twice, once from the source and once from the reference.

EDIT - Sorry, I was thinking that this was a response to another post where RCP and column duplication seemed to be the error. It doesn't necessarily apply to your problem. What data type is the key?

g_rkrish · Post by **g_rkrish** » Mon May 31, 2010 2:28 am

priyadharsini wrote:Lookup stage and Lookup key column is throwing this error.

How big is your lkp

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 2:39 am

Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 2:41 am

Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

g_rkrish · Post by **g_rkrish** » Mon May 31, 2010 2:43 am

priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

try increasing the size of the coulmn and run it

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 2:44 am

I run the job by increasing the length to varchar(10), but again I am getting the same error.

g_rkrish · Post by **g_rkrish** » Mon May 31, 2010 2:45 am

priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

try increasing the size of the coulmn and run it

ArndW · Post by **ArndW** » Mon May 31, 2010 3:00 am

What is the DDL of the table, particularly the key column?

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 3:25 am

the source link key is columnA char(1) nullable = Yes and the reference link key is column A varchar(30) nullable = No

ArndW · Post by **ArndW** » Mon May 31, 2010 4:07 am

I would do an explicit conversion so that both datatypes are identical in type and you will need to ensure that nullability is identical as well, perhaps by adding a NullToValue() call.

priyadharsini · Post by **priyadharsini** » Mon May 31, 2010 4:43 am

Before the lookup, I did all the necessary transformation, I had earlier sent you the table column definition (DDL)

ds_teg · Post by **ds_teg** » Mon May 31, 2010 10:50 am

I am also facing the same problem .

Any resolution for this ?