Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_ReplicateIAD failing when trying to insert NULL values into a non NULLable column

We are running the SF_ReplicateIAD for the Task table. It gets pretty far in the process but fails as shown below. Any ideas? Thanks.

--- Starting SF_ReplicateIAD for Task
12:42:30: Drop Task_Previous if it exists.
12:42:30: Drop Task_DeleteIAD if it exists.
12:42:30: Create Task_Previous with new structure.
12:42:31: Run the DBAmp.exe program.
12:42:31: DBAmp Bulk Operations. V2.20.6 (c) Copyright 2006-2015 forceAmp.com LLC
12:42:31: Populating local table (including archived/deleted records) Task_Previous , SFTable .
12:42:32: DBAmp is using the SQL Native Client.
12:42:32: Opening SQL Server rowset
13:03:37: 183009 rows copied.
13:03:37: Create Task_DeleteIAD with new structure.
13:03:38: Identified 2022 hard deleted rows.
13:03:38: Table schema has changed.
13:03:38: Error occurred while building a table of hard deleted rows.
13:03:38: Error: Cannot insert the value NULL into column 'CreatedDate', table 'SFTable.dbo.Task_Previous'; column does not allow nulls. INSERT fails.
--- Ending SF_ReplicateIAD. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_ReplicateIAD, Line 442
--- Ending SF_ReplicateIAD. Operation FAILED.
1 person has
this question
+1
Reply