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 - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...