Microsoft KB Archive/99923

{|
 * width="100%"|

BUG: BCP: Err Msg: Attempt to Bulk-copy an Oversized Row

 * }

Q99923

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

BUG# OS/2: 8678 (4.2) NT: 8679 (4.2)

SYMPTOMS
When doing a bulk copy from an ASCII data file into SQL Server with a char column that does not allow nulls, and where the data file does not have data for that column (intending to insert default value bound to the column), the rows are copied successfully, but the following message is displayed once for each row:

  Attempt to bulk-copy an oversized row to the SQL Server.

This happens only if the column is a char datatype and is defined as not null and the data file does not contain any data for that column. This does not happen if the column is of type varchar.

WORKAROUND
You can create a temporary table with the char column defined as allowing nulls, BCP in data into that table and then insert data from the temp table to the actual table with non-null char column using an INSERT statement.

Another workaround is to define the column as varchar instead of char.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available

Additional query words: bcp bulk copy program error err msg errmsg alert

Keywords : kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2