ERROR faced while using DBOutputTable Node

CloverDX Platform
1

I extracted the data from MYSQL database using DBInputTable Node -----> and then the REFORMAT transformation node for transformation and------> i connected DBOutputTable Node for loading the transformed data into MYSQL table.

while i was running the program i got the error at DBOutputTable Node so other nodes were aborted.

when i remove the DBOutputTable node and replace it with UniversalDataWriter and write into a file it a succesful graph but when i used DBOutputTable node its saying Graph Failed

There are 11 columns in both tables…
The error which i got is as follows:

Node DB_OUTPUT_TABLE0 finished with status: ERROR caused by: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into individual (PID, MID, sex, DOB, EDU, MS, OCC, HHSEXP, SEXP, EEXP) values (?,?,?,?,?,?,?,?,?,?). Message: Column ‘PID’ cannot be null

I need help and its URGENT…

2

Hello, from the error message it’s clear, that you are trying to insert null to not nullable column (PID) and such record is rejected by the database.

3

But there are no null values in PID…

4

Please check your transformation. See the output file with working DataWriter or, if you use CloverDesigner, you can set debug on the edge leading to the DBOutputTable (but increase the DBOutputTable phase - otherwise there is no data in the debug file while the graph fails during writing to this file).