Database driver error... Function Name : Execute Multiple SQL Stmt : INSERT INTO

Severity: ERROR
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