SQL Server Errors or Failures from Error: 7001 to Error: 7119



Error: 7001, Severity: 16, OPENXML flags parameter must be of data type int.
Error: 7002, Severity: 16, OPENXML XPath must be of a string data type, such as nvarchar.
Error: 7003, Severity: 16, Only one OPENXML column can be of type %ls.
Error: 7004, Severity: 16, OPENXML does not support retrieving schema from remote tables, as in ‘%.*ls’.
Error: 7005, Severity: 16, OPENXML requires a metaproperty namespace to be declared if ‘mp’ is used for another namespace in sp_xml_preparedocument.
Error: 7006, Severity: 16, OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.

Error: 7007, Severity: 16, OPENXML encountered unknown metaproperty ‘%.*ls’.
Error: 7008, Severity: 16, The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
Error: 7009, Severity: 16, OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
Error: 7101, Severity: 16, You need an active user transaction in order to use text pointers for a table with the option “text in row” set to ON.
Error: 7102, Severity: 20, Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
Error: 7104, Severity: 16, Offset or size of data type is not valid. Data type must be of type int or smallint.
Error: 7105, Severity: 22, The Database ID %d, Page %S_PGID, slot %d for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.

Error: 7106, Severity: 16, Internal error: An attempt was made to update a LOB data type using a read-only text pointer.
Error: 7107, Severity: 16, You can have only 1,024 in-row text pointers in one transaction
Error: 7108, Severity: 22, Database ID %d, page %S_PGID, slot %d, link number %d is invalid. Run DBCC CHECKTABLE.
Error: 7116, Severity: 16, Offset %d is not in the range of available LOB data.
Error: 7117, Severity: 16, Error reading large object (LOB) data from the tabular data stream (TDS).
Error: 7118, Severity: 16, Only complete replacement is supported when assigning a large object (LOB) to itself.
Error: 7119, Severity: 16, Attempting to grow LOB beyond maximum allowed size of %I64d bytes.

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.

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 *