Case study: BizTalk send port exception
BizTalk could help us convert source schema/data (usually coming from internal database) to target schema and create EDI format file via send port. But sometimes we might encounter below issue during our sender pipeline under the source and target schema:
Source Schema --------------------------------> EDI (Target) Schema
UNIT_PRICE (xs: decimal) PO104 (xs:X12_R)
The interesting part here were if we applied data value with 0.5946 that not ending with zero. The pipeline works totally fine and no errors was thrown.
The workaround solution here that we modified the target schema data type that match with the source schema. And the send port pipeline just not complain anymore😑.
Source Schema --------------------------------> EDI (Target) Schema
UNIT_PRICE (xs: decimal) PO104 (xs: decimal)