[resolved] Exception in component tMysqlOutput_1

[Anonymous]

hen i try to excecute my job i have this error:
Exception in component tMysqlOutput_1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Column was set to data type implicit default; NULL supplied for NOT NULL column 'id_region' at row 27.
i dont know why.
thinks for help

[Anonymous · Accepted solution]

Hello
Add more length to column and don't insert null value into a not null column, so if the column is defined as not null, you should fiter the null rows.
Best regards
shong