Trouble encoding sort keys: Field "xy" has keyprep

DSUser2000 · Post by **DSUser2000** » Tue Jan 05, 2010 6:06 am

Hello,
I've got a job which sorts by a Timestamp-field (read from DB2 API with microseconds flags, non-nullable in DB). On execution, I get the following error after about 3 Mio. rows:

Code: Select all

Sort_123,2: Trouble encoding sort keys: Field "xxx" has keyprep export format error; value: **************************

(the stars are really there)
Is this a known problem in DS 7.5.3? I'm now using a Char field instead which is not ideal but seems to work.

DSUser2000 · Post by **DSUser2000** » Mon Jan 25, 2010 11:11 am

Noone having an idea on this one?

chulett · Post by **chulett** » Mon Jan 25, 2010 12:10 pm

Guess not. Seems to be saying that 3M rows or so in, you've got something it doesn't think is a valid timestamp.

DSUser2000 · Post by **DSUser2000** » Mon Jan 25, 2010 7:32 pm

Well DB2 thinks it is valid because it comes from there and goes there. So this is really strange...

chulett · Post by **chulett** » Mon Jan 25, 2010 9:23 pm

Then perhaps there's a difference between what DB2 considers a valid timestamp and what DataStage does. Have you asked your official support provider?