Transformer error

arnie_nits · Post by **arnie_nits** » Mon Sep 14, 2009 11:18 am

Hi ,

I am not able to figure out this error.

CopyOfTransform_XL_TU_EqpmntTmap_v2..x_Transform.lXL_EU_MachineryTypeGroupMappingInsert: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO MatEqpmntTmap(EquipmentTypeAssociatedId, EquipmentTypeId) VALUES (?,?)
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client]Non-numeric data was found where numeric required

EquipmentTypeAssociatedId = 115
EquipmentTypeId = 1184

Please help.

Thanks,
Arnie.

ArndW · Post by **ArndW** » Mon Sep 14, 2009 11:21 am

The value of either EquipmentTypeAssociatedId or EquipmentTypeId is not a valid number at runtime. Since Server does not enforce data types this is quite possible.