Lookup Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
Lookup Error
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.
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.
I haven't seen that one before. What stage and what column is triggering this error?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
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?
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?
Last edited by ArndW on Mon May 31, 2010 2:31 am, edited 2 times in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
I run the job by increasing the length to varchar(10), but again I am getting the same error.
Last edited by priyadharsini on Mon May 31, 2010 2:51 am, edited 1 time in total.
What is the DDL of the table, particularly the key column?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai