DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch()

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
clmhwyfe
Premium Member
Premium Member
Posts: 42
Joined: Mon Jun 18, 2012 1:39 pm

DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch()

Post by clmhwyfe »

Hi all,

Am trying to extract data from a Sybase DB and getting the below mentioned error

DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 23 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 13 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 12 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 11 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 9 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 7 resulted in truncation.
DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 6 resulted in truncation.

This issue is similar to the one that's posted already in the site at the below location

viewtopic.php?t=151456&highlight=sybase+data+truncation

The job ran fine till last week and the data has not changed since the last run

The job extracts 6.5 million records and it reads 6.4 million records and then aborts.

Is there a way to identify the record atleast at which the job aborts ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not easily, because the error is being reported by the Sybase OC library, not by DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply