SQL Server Errors or Failures from Error: 33440 to Error: 34014

SQLServerF1

Error: 33440, Severity: 16, When inserting into FileTable ‘%.*ls’ using BCP or BULK INSERT, either CHECK_CONSTRAINTS option needs to be on, or FILETABLE_NAMESPACE needs to be disabled on the table.

Error: 33441, Severity: 16, The FileTable ‘%.*s’ cannot be partitioned. Partitioning is not supported on FileTable objects.
Error: 33442, Severity: 16, The handle ID %d is opened against the server root share and cannot be killed. The lifetime of the handle is controlled by the client who originally opened it.
Error: 33443, Severity: 16, The database ‘%.*s’ cannot be enabled for both FILESTREAM non-transacted access and Database Mirroring.
Error: 33444, Severity: 16, The database ‘%.*s’ cannot be enabled for both FILESTREAM non-transacted access and HADR.

Error: 33445, Severity: 16, The database ‘%.*s’ is a readable secondary database in an availability group and cannot be enabled for FILESTREAM non-transacted access.
Error: 33446, Severity: 16, The FILESTREAM database configuration cannot be changed for database ‘%.*s’. The database is either a mirror database in Database Mirroring, or is in a secondary replica of an AlwaysOn availability group. Connect to the server instance that hosts the pr
Error: 33447, Severity: 16, Cannot access file_stream column in FileTable ‘%.*ls’, because FileTable doesn’t support row versioning. Either set transaction level to something other than READ COMMITTED SNAPSHOT or SNAPSHOT, or use READCOMMITTEDLOCK table hint.
Error: 33448, Severity: 16, Cannot disable clustered index ‘%.*ls’ on FileTable ‘%.*ls’ because the FILETABLE_NAMESPACE is enabled.
Error: 33449, Severity: 10, FILESTREAM File I/O access is enabled, but no listener for the availability group is created. A FILESTREAM PathName will be unable to refer to a virtual network name (VNN) and, instead, will need to refer to a physical Windows Server Failover Clustering (

Error: 33450, Severity: 10, FILESTREAM File I/O access is enabled. One or more availability groups (‘%ls’) currently do not have a listener. A FILESTREAM PathName will be unable to refer to a virtual network name (VNN) and, instead, will need to refer to a physical Windows Server F
Error: 34001, Severity: 16, Dialog with queue ‘syspolicy_event_queue’ has encountered an error: %s.
Error: 34002, Severity: 16, Dialog with queue ‘syspolicy_event_queue’ has ended.
Error: 34003, Severity: 16, Error number %d was encountered while processing an event. The error message is: %s.
Error: 34004, Severity: 16, Execution mode %d is not a valid execution mode.
Error: 34010, Severity: 16, %s ‘%s’ already exists in the database.
Error: 34011, Severity: 16, Specified value for property %s cannot be used with execution mode %d.
Error: 34012, Severity: 16, Cannot delete %s referenced by a %s.
Error: 34013, Severity: 16, %s ‘%s’ is referenced by a ‘%s’. Cannot add another reference.
Error: 34014, Severity: 16, Facet does not exist.

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 *