DBD: Exception Message: ORA-01407: cannot update to NULL

Here is another evil teamsite / opendeploy error that makes no sense:

DBD: INSERT INTO TABLE_NAME(row_id) VALUES (?)
DBD: Column: row_id, field: main/0/uid, Index: 1,Converting '100' to DECIMAL
DBD: DELETE FROM TABLE_NAME row_id = ?
DBD: Column: row_id, field: null, Index: 1,Converting '200' to DECIMAL
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-01407: cannot update ("PRDLIVE"."TABLE_NAME"."ROW_ID") to NULL

At first glance it seems like you are updating a row, and setting a column to a null value that is configured as "not null"

but really you are trying to delete a row that does not exist! You can verify this:
in your db run the following queries:
<br />select * from TABLE_NAME where ROW_ID = 200;<br />-- this should return 0 rows<br />select * from IWDELTRACKER where keycolvalue = 200 and path = 'path/to/the/DCT/that/broke/the/deployment.xml';<br />-- this should return 1 row, and this is the evil suck that is breaking everything!<br />delete from IWDELTRACKER where keycolvalue = 200 and path = 'path/to/the/DCT/that/broke/the/deployment.xml';<br />-- now you got rid of the evil record<br />commit;<br />

so, now you have deleted the record of the row from your IWDELTRACKER that does not really exist in your database. re-run the deployment and it should not fail this time