SQL Server Errors or Failures from Error: 4811 to Error: 4830

SQLServerF1

 

Error: 4811, Severity: 16, Expected the column offset in data stream for bulk copy of text or image data.,
Error: 4812, Severity: 16, Expected the row offset in data stream for bulk copy of text or image data.,
Error: 4813, Severity: 16, Expected the text length in data stream for bulk copy of text, ntext, or image data.,
Error: 4814, Severity: 16, Bulk copy into a partitioned table is not supported for down-level clients.,
Error: 4815, Severity: 16, Received an invalid column length from the bcp client for colid %d.,

Error: 4816, Severity: 16, Invalid column type from bcp client for colid %d.,
Error: 4817, Severity: 16, Could not bulk load. The sorted column ‘%.*ls’ is not valid. The ORDER hint is ignored.,
Error: 4818, Severity: 16, Could not bulk load. The sorted column ‘%.*ls’ was specified more than once. The ORDER hint is ignored.,
Error: 4819, Severity: 16, Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the following two rows: primary key of first row: %s, primary key of second row: ,
Error: 4820, Severity: 16, Cannot bulk load. Unknown version of format file “%s”.,
Error: 4821, Severity: 16, Cannot bulk load. Error reading the number of columns from the format file “%s”.,

Error: 4822, Severity: 16, Cannot bulk load. Invalid number of columns in the format file “%s”.,
Error: 4823, Severity: 16, Cannot bulk load. Invalid column number in the format file “%s”.,
Error: 4824, Severity: 16, Cannot bulk load. Invalid data type for column number %d in the format file “%s”.,
Error: 4825, Severity: 16, Cannot bulk load. Invalid prefix for column number %d in the format file “%s”.,
Error: 4826, Severity: 16, Cannot bulk load. Invalid column length for column number %d in the format file “%s”.,
Error: 4827, Severity: 16, Cannot bulk load. Invalid column terminator for column number %d in the format file “%s”.,
Error: 4828, Severity: 16, Cannot bulk load. Invalid destination table column number for source column %d in the format file “%s”.,
Error: 4829, Severity: 16, Cannot bulk load. Error reading the destination table column name for source column %d in the format file “%s”.,
Error: 4830, Severity: 10, Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *