Good afternoon! Could you help me please? is givin...
# gd-beginners
t
Good afternoon! Could you help me please? is giving this error when running the chart: ERROR. Error details: Upload to dataset dataset.tf_itens_producao failed with 'An error occured during loading of csv files: SQLSTATE_INVALID_TEXT_REPRESENTATION_PG. Details: invalid input syntax for type integer: ""'. Further down in the error log it says that it is the f0304dtahoralancamento column, but it is a data column, it only has data or null, I have already converted it to data, I have done everything and it doesn't solve it.
Copy code
request_id=disc_ZJS2VgsCqB:lTezsoiwkXrbb0Bn:Z7tw5XfKeC4qGJDU ***/2024-08-17_19-19-38_cjOGr/d_tf_itens_producao_f0304dtahoralancamento1.csv.log => [ "invalid input syntax for type integer: \"\". CONTEXT: line 7, column nm_f0304dtahoralancamento1: \"\"" ]
Attached is the complete error log
j
Hi Tomas, We’ve seen some cases like this and problem was that the INTEGER data type supports the null values, but not the empty string. Please can you check your source data on the lines and column which is specified in the error log?
Another option might be that if this is actually an atribute field with INTEGER datatype, you might even need to either change the source data from NULL to a zero, or change the label from integer to text in LDM. loading NULL values into attribute with numeric data type is not possible.