Page 1 of 2
Lookup Error
Posted: Mon May 31, 2010 2:00 am
by priyadharsini
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.
Posted: Mon May 31, 2010 2:03 am
by ArndW
I haven't seen that one before. What stage and what column is triggering this error?
Posted: Mon May 31, 2010 2:16 am
by priyadharsini
Lookup stage and Lookup key column is throwing this error.
Posted: Mon May 31, 2010 2:28 am
by ArndW
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?
Posted: Mon May 31, 2010 2:28 am
by g_rkrish
priyadharsini wrote:Lookup stage and Lookup key column is throwing this error.
How big is your lkp
Posted: Mon May 31, 2010 2:39 am
by priyadharsini
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.
Posted: Mon May 31, 2010 2:41 am
by priyadharsini
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.
Posted: Mon May 31, 2010 2:43 am
by g_rkrish
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
Posted: Mon May 31, 2010 2:44 am
by priyadharsini
I run the job by increasing the length to varchar(10), but again I am getting the same error.
Posted: Mon May 31, 2010 2:45 am
by g_rkrish
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
Posted: Mon May 31, 2010 3:00 am
by ArndW
What is the DDL of the table, particularly the key column?
Posted: Mon May 31, 2010 3:25 am
by priyadharsini
the source link key is columnA char(1) nullable = Yes and the reference link key is column A varchar(30) nullable = No
Posted: Mon May 31, 2010 4:07 am
by ArndW
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.
Posted: Mon May 31, 2010 4:43 am
by priyadharsini
Before the lookup, I did all the necessary transformation, I had earlier sent you the table column definition (DDL)
Posted: Mon May 31, 2010 10:50 am
by ds_teg
I am also facing the same problem .
Any resolution for this ?