1 Reply Latest reply on Dec 20, 2019 8:54 AM by Adrian_Popescu-Oracle

    ORABPEL-15235 - Failed to translate JSON to XML - The incoming data does not conform to the NXSD schema" in ODI 12.2.1.3.0

    3341034

      Trying to configure a complex file data server to import data from a JSON file in ODI 12.2.1.3.0,  and after creating the nXSD file, while testing the connection,  it fails with the below error.

       

      ORABPEL-15235

      Translation Failure.
      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.