alibaba / alibaba/DataX

Description:[往您配置的写入表中写入数据时失败.]. - org.postgresql.util.PSQLException: ERROR: null value in column "item_code"

Open
#190 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - org.postgresql.util.PSQLException: ERROR: null value in column "item_code" violates not-null constraint (seg12 192.168.0.183:40000 pid=30681)

其他表都没问题,只有这张表才会出现这种错误,求解答,谢谢!!

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is identified. Start by reproducing the DataX write for the affected PostgreSQL table and inspect the configured mapping for item_code, comparing it with the working tables. Done means identifying why item_code becomes null and documenting a verified configuration or compatibility fix.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.