SQL Server Error Msg 5274 – Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID.  %S_MSG is invalid for compressed page; the following internal test failed:  %.*ls. Values are %ld and %ld.

In this blog post, let’s learn about the error message “5274 – Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID.  %S_MSG is invalid for compressed page; the following internal test failed:  %.*ls. Values are %ld and %ld.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

5274 – Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID.  %S_MSG is invalid for compressed page; the following internal test failed:  %.*ls. Values are %ld and %ld.

Reason for the Error

To be update soon…

Solution

To be update soon…