Trying to configure a complex file data server to import data from a JSON file in ODI 22.214.171.124.0, and after creating the nXSD file, while testing the connection, it fails with the below error.
Failed to translate JSON to XML. class java.sql.BatchUpdateException said data exception: string data, right truncation; table: **SCHEMA NAME** column: **COLUMN NAME**
The incoming data does not conform to the NXSD schema. Please correct the problem.
I am using inbuilt memory engine to create the schema and load the data. If the length of the data in COLUMN NAME is more than 255 characters ,the above error is coming while testing the topology.