ERROR faced while using DBOutputTable Node

sandeep87

• September 17, 2009 00:00

• Answered

Follow

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....

• 

  avackova

  • September 18, 2009 07:15

  0

  Comment actions Permalink

  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.
• 

  sandeep87

  • September 18, 2009 08:04

  0

  Comment actions Permalink

  But there are no null values in PID..
• 

  avackova

  • September 18, 2009 08:23

  0

  Comment actions Permalink

  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).

Please sign in to leave a comment.