KB Article #182691
[MappingServices] Error "Unable to assign value n in SQL request"
Problem
--B2Bi could not store a specific number value in the database and it shows the following error:
--[JDX - 17027]: Unable to assign value n in SQL request
Resolution
**A possible solution could be that the following option "Pad reals with a leading and trailing to zero" is not enabled in the input database Business Document.
**This option ensures that the value will be padded with zero until the value matches the definition of the output field this is conditional if the input has fewer fractional digits than the expected output definition. This feature is compatible only with the DML version 2.0/2.1 if the version is inferior to those ones, it can be changed into the Mapping Services project > double click on project.ms > Mapping Details > Version