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 Common Service to Submit CCS Batch Jobs and Monitor Job Status | Extract file from Oracle CCS to Object Storage

Objective Create a reusable common service in Oracle Integration Cloud (OIC) to submit batch jobs to CCS, monitor their execution status, an...