Server Error Messages 4800 - 4899


 Bulk_main: opentable on BULK INSERT table failed. Dbid=%d name='%.*s'.
 Bulk_main: getindex of primary index row failed on BULK INSERT table.
 Premature end-of-message while reading current row from host. Host program may have died.
 The front end tool you are using does not support the feature of bulk insert from host, please use the proper tools for this command.
 You cannot run the non-logged version of bulk copy in this database. Please check with the DBO.
 The bulk copy of this table has been aborted because the CHECKPOINT record could not be written in the log. Please free up space in the database.
 Unable to open SYSCOLUMNS in dbid %d to retrieve table schema information.
 Expected TEXT token in data stream for bulk copy of text data.
 Expected column offset in data stream for bulk copy of text data.
 Expected row offset in data stream for bulk copy of text data.
 Expected text length in data stream for bulk copy of text data.
 Bulk_getschema: Unable to open the system catalog SYSCOLUMNS in database `%.*s' while attempting to retrieve table schema information. Run DBCC CHECKTABLE on sysobjects in `%.*s'.
 Error encountered while retrieving table schema information for object `%.*s' in database `%.*s'. Re-check the schema for the table.
 You cannot BCP into the sysaudits table.
 Illegal identity value specified for identity column in table `%.*s' through BCP.
 Identity value overflow while inserting into table `%.*s' through BCP.
 You do not have the role required to run bcp in with the labelled option.
 Sensitivity label out of range for some row(s).
 Invalid sensitivity label for some row(s).
 Some row(s) not copied.
 Expected sensitivity label length in data stream for bulk copy of sensitivity label data.
 Expected row offset in data stream for bulk copy of sensitivity label data.
Expected sensitivity label data in data stream for bulk copy of sensitivity label  data. 
 Attempt to copy in row sensitivity labels without using bulk copy labelled option. Labels will be overwritten.
 The labelled option was specified, but row sensitivity labels were not passed in.
 Expected TEXT or SENSITIVITY token in data stream for bulk copy of text or sensitivity label data.
 You cannot use a pre-10.0 client to bulk copy into a Secure SQL Server.
 Expected text data in data stream for bulk copy.
 Bulk copy failed due to insufficient SQL Server memory. Please retry later when there is less load/users on the SQL server, or ask your System Administrator to reconfigure SQL Server with more memory.
 Failed to update the identity pre-burn factor for table `%.*s' through BCP. Please re-try the operation or contact your SA for details.
 Error occurred while creating the identity value for table `%.*s' through BCP. Please re-try the operation or contact your SA for details.
 Bad row data received from the client while bulk copying into object %d in database %d. Received a row of length %d while maximum possible row length is %d.
 You cannot BCP into a view.
 Server has encountered badly formatted rows from bulk copy. Could not locate the row position reserved for the insertion of the identity value.
Bulk copy failed. You cannot specify a partition ID when doing BCP into table '%. *s' because it has a clustered index. 
Bulk copy failed. Partition number %d does not exist in table '%.*s'.  
Bulk copy failed. Partition number %d was specified for table '%.*s', but that table is not partitioned. 
Slow bulk copy is being used because table '%.*s' has triggers or indexes.  
Bulk copy failed. Identity start value %S_NUME was specified for table '%.*s', but that table does not have an identity column. 
Bulk copy failed. Client does not have the capability to bulk copy into the data- only locked table '%.*s'. 
Bulk copy failed. Error occurred while updating the last page of the table.  
BCP insert operation is disabled when LONGCHAR capability is turned on and data size is changing between client and server character sets since BCP does not support LONGCHAR yet. 

Number	Severity	Text and Explanation
4801	20	Bulk_main: opentable on BULK INSERT table failed. Dbid=%d name='%.s'. Explanation:* The bulk copy command failed. Adaptive Server could not open the specified table. Check command and target table.
4802	21	Bulk_main: getindex of primary index row failed on BULK INSERT table. Explanation: There is a potential problem affecting the consistency of the system catalog or the indexes on the table specified in the bcp command. Investigate with dbcc checktable, checkcatalog and checkdb.
4804	21	Premature end-of-message while reading current row from host. Host program may have died. Explanation: The bcp activity could be incomplete. Although corruption is unlikely, some rows in the target table for bcp may need to be cleaned up using delete/truncate table command.
4805	17	The front end tool you are using does not support the feature of bulk insert from host, please use the proper tools for this command. Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.
4806	16	You cannot run the non-logged version of bulk copy in this database. Please check with the DBO. Explanation: Refer to the writeup for this error.
4808	10	The bulk copy of this table has been aborted because the CHECKPOINT record could not be written in the log. Please free up space in the database. Explanation: The bcp activity could be incomplete. Although corruption is unlikely, some rows in the target table for bcp may need to be cleaned up using delete/truncate table command. Restart the bcp job after cleanup.
4809	20	Unable to open SYSCOLUMNS in dbid %d to retrieve table schema information. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.
4810	16	Expected TEXT token in data stream for bulk copy of text data. Explanation: This error is seen when bulk copying in a table that has text/image columns. Does not cause corruption but the bcp batch may be terminated.
4811	16	Expected column offset in data stream for bulk copy of text data. Explanation: This error is seen when bulk copying in a table that has text/image columns. Does not cause corruption but the bcp batch may be terminated.
4812	16	Expected row offset in data stream for bulk copy of text data. Explanation: This error is seen when bulk copying in a table that has text/image columns. Does not cause corruption but the bcp batch may be terminated.
4813	16	Expected text length in data stream for bulk copy of text data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4814	20	Bulk_getschema: Unable to open the system catalog SYSCOLUMNS in database `%.s' while attempting to retrieve table schema information. Run DBCC CHECKTABLE on sysobjects in `%.s'. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.
4818	11	Error encountered while retrieving table schema information for object `%.s' in database `%.s'. Re-check the schema for the table. Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.
4819	16	You cannot BCP into the sysaudits table. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
4820	16	Illegal identity value specified for identity column in table `%.s' through BCP. Explanation:* Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4821	16	Identity value overflow while inserting into table `%.s' through BCP. Explanation:* This error is seen when bulk copying in a table that has an identity column. Consider creating another table with a larger identity value range to load the data.
4822	14	You do not have the role required to run bcp in with the labelled option. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
4823	16	Sensitivity label out of range for some row(s). Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4824	16	Invalid sensitivity label for some row(s). Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4825	16	Some row(s) not copied. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4826	16	Expected sensitivity label length in data stream for bulk copy of sensitivity label data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4827	16	Expected row offset in data stream for bulk copy of sensitivity label data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4828	16	Expected sensitivity label data in data stream for bulk copy of sensitivity label data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4829	16	Attempt to copy in row sensitivity labels without using bulk copy labelled option. Labels will be overwritten. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4830	16	The labelled option was specified, but row sensitivity labels were not passed in. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4831	16	Expected TEXT or SENSITIVITY token in data stream for bulk copy of text or sensitivity label data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4832	16	You cannot use a pre-10.0 client to bulk copy into a Secure SQL Server. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
4833	16	Expected text data in data stream for bulk copy. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4834	17	Bulk copy failed due to insufficient SQL Server memory. Please retry later when there is less load/users on the SQL server, or ask your System Administrator to reconfigure SQL Server with more memory. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
4835	18	Failed to update the identity pre-burn factor for table `%.s' through BCP. Please re-try the operation or contact your SA for details. Explanation:* Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
4836	18	Error occurred while creating the identity value for table `%.s' through BCP. Please re-try the operation or contact your SA for details. Explanation:* Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
4837	16	Bad row data received from the client while bulk copying into object %d in database %d. Received a row of length %d while maximum possible row length is %d. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
4838	16	You cannot BCP into a view. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
4839	18	Server has encountered badly formatted rows from bulk copy. Could not locate the row position reserved for the insertion of the identity value. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
4840	16	Bulk copy failed. You cannot specify a partition ID when doing BCP into table '%. s' because it has a clustered index. Explanation:* Check command parameters and retry.
4841	16	Bulk copy failed. Partition number %d does not exist in table '%.s'. Explanation:* Check command parameters and retry.
4842	16	Bulk copy failed. Partition number %d was specified for table '%.s', but that table is not partitioned. Explanation:* Check command parameters and table, and retry.
4843	10	Slow bulk copy is being used because table '%.s' has triggers or indexes. Explanation:* This is an informational message. Bulk copy may take an extended period.
4844	16	Bulk copy failed. Identity start value %S_NUME was specified for table '%.s', but that table does not have an identity column. Explanation:* Check command parameters and table,and retry.
4845	16	Bulk copy failed. Client does not have the capability to bulk copy into the data- only locked table '%.s'. Explanation:* Check Adaptive Server and client environment, setup.
4846	20	Bulk copy failed. Error occurred while updating the last page of the table. Explanation: Error in bulk copy affected current process. Contact System Administrator.
4847	16	BCP insert operation is disabled when LONGCHAR capability is turned on and data size is changing between client and server character sets since BCP does not support LONGCHAR yet. Explanation: Illegal command.