Lookup_103,1: Field "ID" has keyprep export format
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 16, 2013 10:21 am
Lookup_103,1: Field "ID" has keyprep export format
I am doing a lookup on ID field. Both, input as well as reference have datatype timestamp length 26 , scale 6. When I run my job I am getting the following error
Lookup_103,1: Field "ID" has keyprep export format error; value: **************************
Lookup_103,1: Failed keylookup on table (/tmp/dynLUT4053bee05c79), Key Values: ID: **************************
Column ID looks like 1998-07-08 16:15:07.690526
Can someone get back to me on this real quick please.
Lookup_103,1: Field "ID" has keyprep export format error; value: **************************
Lookup_103,1: Failed keylookup on table (/tmp/dynLUT4053bee05c79), Key Values: ID: **************************
Column ID looks like 1998-07-08 16:15:07.690526
Can someone get back to me on this real quick please.
sunnym
Re: Lookup_103,1: Field "ID" has keyprep export fo
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 16, 2013 10:21 am
Re: Lookup_103,1: Field "ID" has keyprep export fo
This doesn't Help me. Could someone please look into this error and give me a solution please.
sunnym
Do an exact search here for "has keyprep export format error" and check the other two posts that come up besides yours and the one previously linked to. See if anything there helps. If it doesn't then it is time to involve your official support provider if you haven't already.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What stage type writes data onto the reference input link to the Lookup stage Lookup_103? What is the format of the ID column on that source, and what is the format of the ID column (or whatever column you have mapped to ID in the Lookup stage) on the stream input? Finally, what kind of Lookup (equality, case sensitive, range) are you attempting?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 16, 2013 10:21 am
The datatype for reference link, input stream and output are timestamp and microseconds(extended). I went through all the post but none of them helped me. Also, I am able to view the data on my reference as well as input stream. Data from both streams come from a db2 database and I am using a db2 connector stage. However, the design is like a transformer to lookup_103(input) and db2 connector to lookup_103(reference). Hope this explanation helps.
sunnym
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 16, 2013 10:21 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could always contact your official support provider. DSXchange is all volunteers, who post if and when they have something useful to add. Sometimes "think time" is required.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It would appear that the problem is coming when the Lookup stage is preparing the reference data set or the index on it though I confess to some confusion about the word "export" in the message. What are the data types of the key column(s) on both the stream input and reference input links?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore