Node: node01_
Thread: WRITER_1_*_1
Process ID: 5384
Message Code: WRT_8229
Message: Database errors occurred:
Microsoft SQL Server Native Client 11.0: Unspecified error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO dbo.table(col1,clo2,clo3) VALUES ( ?, ?, ?)
Solution
This error will occur when the session is attempting to load null values into a column in the target table with a NOT NULL constraint.
To resolve this either filter out the null values or remove the NOT NULL constraint on the target column.
Debug
To Debug Enable Verbose data logs.
Session Double Click - Config Object --> Error Handling --> Override Tracing --> Verbose Data
Now run the session again and view session logs for RowData i.e. data pulled from source. I had received null values where target table is expecting it to be not null
