Encoding conversion error : Truncated character

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
colhogan
Premium Member
Premium Member
Posts: 4
Joined: Fri Oct 13, 2006 7:39 am

Encoding conversion error : Truncated character

Post by colhogan »

Hello,

We are encountering the fatal error:

FACS_PROD_Tables,0: U_TRUNCATED_CHAR_FOUND encountered.
FACS_PROD_Tables,0: Encoding conversion error : Truncated character found

The FACS_PROD_Tables stage is a Facets system on a Sybase database, coming in through a DataStage Sybase connection. I pulled the connection out and sent it strait to a flat file to confirm that it was that stage.

I have looked through the forums and thought I had tracked the problem down to mismatched DataStage metadata to the actual Facets metadata, but the fields match on both sides.

Are there any known issues with Sybase connections into DataStage?

Any help will be appreciated,

Thanks
Post Reply