CSV File Ingest Failed

[sirineREKIK]

Regarding: Dataverse v 5.12.1

An error occured in logs when trying to ingest the CSV file : Infos_Gwell.csv
Ingest produced tabular data, but failed to save it in the database.
log file : ingest_bdd_error.log

[pdurbin]

@sirineREKIK thanks, I'm just pulling out the exception

Internal Exception: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Error Code: 0
Call: INSERT INTO DATAVARIABLE (FACTOR, FILEENDPOSITION, FILEORDER, FILESTARTPOSITION, FORMAT, FORMATCATEGORY, INTERVAL, LABEL, NAME, NUMBEROFDECIMALPOINTS, ORDEREDFACTOR, RECORDSEGMENTNUMBER, TYPE, UNF, WEIGHTED, DATATABLE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

I don't think it's this issue:

• Tabular data without headers with first row cell content longer than 255 characters cause exception for document ingestion #7386

(A header is present and all values are under 255 according to head -1 Infos_Gwell.csv | tr \; "\n" | while read i; do echo $i | wc -c; done)

Maybe it's the semicolons:

• semicolon separated values file with .csv extension fails ingest #8990

@sirineREKIK do you want to try it again with commas (or tabs) instead of semicolons? Just to see what happens?

[sirineREKIK]

@pdurbin
Yes it seems good when replacing semicolons with commas, no exception was reported.

[pdurbin]

@sirineREKIK thanks, closing in favor of this issue:

• semicolon separated values file with .csv extension fails ingest #8990