DSXchange

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.

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.