Tuesday, June 20, 2023

OIC - While reading or writting a file from/to stage, getting translation to native failed. Element not completed

Usecase: Suppose we are reading or writting a file from/into a stage and getting the below error:

Translation Failure
Translation to native failed. Element not completed : 'Employee'.
The data does not conform to the NXSD schema. Please correct the problem.

Solution:
This error occured when we are reading /wrtting the file from/to stage, most cases we are not adding any header field names and later when we try to read/write it, we are mentioning the USE FIRST ROW AS COLUMN HEADERS AS CHECKED which was expecting header field names in the file.
  1.  Just uncheck this property - USE FIRST ROW AS COLUMN HEADERS and it will work.
  2.  Or add header field names explitcitly in the file.



No comments:

Post a Comment

Featured Post

OIC - Using Dynamic Paths for OCI Object Storage in OIC Integrations | Handling “Subfolders” in OCI Object Storage bucket

Use Case In Oracle Integration Cloud (OIC), when working with Oracle Object Storage, “folders” inside a bucket are not real directories . T...