JOB ABORTS IN PRE-PROD

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
sendmk
Charter Member
Charter Member
Posts: 136
Joined: Mon Oct 03, 2005 5:02 am

JOB ABORTS IN PRE-PROD

Post by sendmk »

Hi

I have a Px Job which takes data from SAP using ABAP Pack and loads it into DataSet.My job aborts with Follwing message.

APT_CombinedOperatorController,0: Fatal Error: Fatal: Unable to convert input data to column type
At row 2, link "ABAP_GMC_ZBUS_UNITGP_Read", while processing column "GMC_ZBUS_UNITGP_PUB_ID"
Unable to convert input data to column type [dscapiop.C:1882]4122


Column shown Above is NUMC(9) in SAP and writing to DS a Varchar() and the there are 2 records for this in SAP and rows it shows Blank

can any one help on this.


Regards
Sendmk.
Amos.Rosmarin
Premium Member
Premium Member
Posts: 385
Joined: Tue Oct 07, 2003 4:55 am

Post by Amos.Rosmarin »

Hi,


Hope it's not too late.

Sometimes there are bugs in the generated programs.
If you get this type of message just start over (by deleting the stage and it's output link)

Try to use 'extraction object' instead of 'generated sql' sometimes it's safer.

HTH,
Amos
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Are you reading it as number and converting it into Varchar later on?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply