JSON Error: Input string was not in a correct format

Error Details:

There was a failure executing the send pipeline <Pipeline Name> Source: “JSON encoder” Send Port: <Send Port Name> URI: <URI> Reason: Input string was not in a correct format.

Reason:

Most of the time when we generate schemas with XML or JSON or csv files with specified wizard (JSON Schema wizard, Flat File Schema Wizard, or Generate Schemas). While creating elements in schema, there are some elements datatypes are defined as unasignBite or unasignInt etc..

Most of the time we find these datatypes while creating schemas for numeric data. It defines as unasignInt or unasignByte etc. while creating of Schema from Wizard.

So, when we applied JSON Encoder to convert XML to JSON, this throws exception that Input string was not in a correct format. 

Solution:

So, After creating Schemas, verify Schemas elements’ data types and update to valid data type e.g. string, integer which are accepted for the JSON format. This will resolve the problem.