SQL Server Errors or Failures from Error: 27220 to Error: 28012

SQLServerF1

Error: 27220, Severity: 16, SSISDB database does not exist. Create the SSISDB database.

Error: 27221, Severity: 16, Unable to map an environment variable with the sensitive property set to True, to a parameter with the sensitive property set to False. Ensure that the property settings match.
Error: 27222, Severity: 16, The required components for the 64-bit edition of Integration Services cannot be found. Run SQL Server Setup to install the required components.
Error: 27223, Severity: 16, Cannot move the project to folder ‘%ls’ due to insufficient permissions.
Error: 27224, Severity: 16, The parameter value cannot be changed after the execution has been started.
Error: 27225, Severity: 16, The property cannot be overridden after the execution has been started.

Error: 27226, Severity: 16, The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped.
Error: 28000, Severity: 16, The decrypted session key has an unexpected size.
Error: 28001, Severity: 16, A corrupted message has been received. It contains invalid flags. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
Error: 28002, Severity: 16, Cannot start service broker manager. Operating system error: %ls.
Error: 28003, Severity: 16, An internal service broker error occurred. Operating system error: %ls.
Error: 28004, Severity: 16, This message could not be delivered because the ‘%S_MSG’ action cannot be performed in the ‘%.*ls’ state.
Error: 28005, Severity: 16, An exception occurred while enqueueing a message in the target queue. Error: %d, State: %d. %.*ls

Error: 28006, Severity: 14, User does not have permission to %S_MSG the conversation ‘%.*ls’ in state ‘%.*ls’. Only members of the sysadmin fixed server role and the db_owner fixed database role have this permission.
Error: 28007, Severity: 16, A corrupted message has been received. The highest seen message number must be greater than the acknowledged message number. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
Error: 28008, Severity: 16, The conversation handle ‘{%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}’ is invalid.
Error: 28009, Severity: 16, The crypto API has detected bad data while trying to perform a decryption operation.
Error: 28010, Severity: 16, This message could not be delivered because it contains an invalid acknowledged message number. Highest expected message number: %I64d. Acknowledged message number: %I64d, fragment number: %d.
Error: 28011, Severity: 16, This message could not be delivered because its %S_MSG has expired or is invalid.
Error: 28012, Severity: 16, The Service Broker in the target database is unavailable: ‘%S_MSG’.

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 *