Informatica – WRT_8229, Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Working with Informatica is fun, but challenging at times, don’t know if this is the same other ETL tools, like SSIS, etc.
Today, while running a Workflow I was getting an error on a session, and due to this the rows were not getting inserted from Source to Target table. The error is as follows:
Timestamp: 1/25/2016 3:37:43 PM
Process ID: 7180
Message Code: WRT_8229
Message: Database errors occurred: Microsoft OLE DB Provider for SQL Server: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Database driver error…
Function Name : Execute Multiple
SQL Stmt : INSERT INTO dbo.Contact (Id,Name,Description,CreatedBy,CreatedOn,ModifiedBy,ModifieOn,RowCheckSum) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
I check all the place and at last found that the last column “RowCheckSum” as mentioned in the error above, was not present in my Target table.
So, I just went ahead and added this column with simple “ALTER TABLE ADD COLUMN” statement.
And post this fix, my Workflow ran without any issues, and I got the table populated as expected.