search

P3-Core-Dev-Team / P3-Q-A

This repo is for tracking features
Other
0 stars 0 forks source link

CSV ingestion - Data Type Error (csv ingestion) #33

Closed suseela22 closed 3 months ago

suseela22 commented 6 months ago

During csv ingestion we are facing issue on the below datatypes. If the metadata has double and integer datatype the ingestion is failing.

Double Datatype image Integer Datatype image

VikramSelvadurai commented 5 months ago

RCA if we create the schema , table and column from ui , with data type double and integer , trigger ingestion in from csv, we got exception due to INTEGER and DOUBLE (ENUM) data types not present in [ArchonDataCategory] ENUM,

Fix details now added the enum INTEGER and DOUBLE data type to the ( ArchonDataCategory) added for CSV typ ingestion and, added Condition for Integer data type

Double data Type : Screenshot from 2024-01-24 17-05-43 Screenshot from 2024-01-24 17-06-09 CSV: FND_DOC 1.csv

Integer Data Type: Screenshot from 2024-01-24 17-19-39 Screenshot from 2024-01-24 17-41-40

CSV: Tabel2.csv

ClementJosh21 commented 5 months ago

@kilam005 The datatype mentioned above was missed and hence throws this error, we have handled these datatype in the enum.

Udhayanila8 commented 5 months ago

Ingestion completed for integer and double datatypes, Tested in 146 server. image image image image

kilam005 commented 5 months ago

This fixes are ready and verified. This is planned to be avaialable in version 2024.01.x

kilam005 commented 3 months ago

@suseela22

The issue is fixed in the latest version 2024.01.x which is updated in the region given to implemention team. Kindly check and provide closure

suseela22 commented 3 months ago

Working as expected