Failed to insert data into new table [table_name] error during Object Level Recovery (OLR) (4274442)

Getting the error :

"Failed to insert data into new table [table_name].
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
The OLE DB provider "BULK" for linked server "(null)" reported an error. The
provider did not give any information about the error.
Bulk load data conversion error (truncation) for row 2, column 1 (column_name)"

during OLR.

The problem is being caused by the presence of a persisted computed column in source table. For normal computed columns, is no entry in the sysrowsetcolumns and as such the column will be skipped and not stored in the bcp. However for persisted computed column, there is an entry in sysrowsetcolumns so that OLR gets that field from the row and writes to bcp.

WORKAROUND:
Use select statement when performing OLR to explicitly specify the columns that you want to restore leaving out any persisted computed column.

STATUS:
Fixed in Version 6.5.1 of LiteSpeed. Available here:
https://support.quest.com/Search/SearchDownloads.aspx?dsNav=N:3-268442521&Dt=LiteSpeed%20for%20SQL%20Server
 

Computed Columns

A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. The expression cannot be a subquery.

Unless otherwise specified, computed columns are virtual columns that are not physically stored in the table. Their values are recalculated every time they are referenced in a query. The Database Engine uses the PERSISTED keyword in the CREATE TABLE and ALTER TABLE statements to physically store computed columns in the table. Their values are updated when any columns that are part of their calculation change. By marking a computed column as PERSISTED, you can create an index on a computed column that is deterministic but not precise.

http://msdn.microsoft.com/en-us/library/ms186241.aspx
http://msdn.microsoft.com/en-us/library/ms191250.aspx