{"id":2203,"date":"2011-05-10T11:20:37","date_gmt":"2011-05-10T10:20:37","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=2203"},"modified":"2019-09-13T14:45:33","modified_gmt":"2019-09-13T13:45:33","slug":"msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/","title":{"rendered":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Un petit article pour parler de cette erreur assez courante qui se rencontre soit avec des versions ant\u00e9rieures \u00e0 SQL Server 2005, soit \u00e0 la suite d’une migration. Elle n’est pas tr\u00e8s grave et plut\u00f4t bien d\u00e9crite puisque la solution est indiqu\u00e9e dans le message (“Run DBCC UPDATEUSAGE”<\/em>).<\/p>\n

dbcc checkdb('MvxRef') with no_infomsgs, all_errormsgs<\/span>\r\n\r\nMsg\u00a02508, Niveau\u00a016, \u00c9tat\u00a01, Ligne\u00a01\r\nLe nombre In-row data USED page pour l'objet 'Client_NULL', ID d'index 0,\r\nID de partition 29725599596544,ID d'unit\u00e9 d'allocation 29725599596544\r\n(type In-row data) est incorrect. Ex\u00e9cutez DBCC UPDATEUSAGE.\r\nCHECKDB a trouv\u00e9 0 erreurs d'allocation et 1 erreurs de coh\u00e9rence\r\ndans la table 'Client_NULL' (ID d'objet 453576654).\r\nCHECKDB a trouv\u00e9 0 erreurs d'allocation et 1 erreurs de coh\u00e9rence\r\ndans la base de donn\u00e9es 'MvxRef'.<\/span><\/pre>\n
Lorsque DBCC CHECKDB arrive sur un objet en particulier, il se constitue une synth\u00e8se des informations qui d\u00e9crivent la table, et notamment le d\u00e9compte de pages totales allou\u00e9es, et de pages utilis\u00e9es pour l’objet. Si une des valeurs est n\u00e9gative, le message 2508 est renvoy\u00e9 avec en param\u00e8tre une indication sur quelle valeur est n\u00e9gative (RSVD pour le nombre total de pages, USED pour le nombre de pages utilis\u00e9es). La valeur n\u00e9gative en question est remont\u00e9e par la DMV sys.allocation_units:<\/p>\n
select allocation_unit_id, type_desc, container_id,total_pages, used_pages\r\nfrom sys.allocation_units AU inner join sys.partitions P on AU.container_id = P.hobt_id\r\nand P.object_id = object_id('Client_NULL')<\/span><\/pre>\n
allocation_unit_id\u00a0\u00a0 type_desc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 container_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 total_pages\u00a0\u00a0\u00a0 used_pages\u00a0\u00a0\r\n-------------------- ---------------- -------------------- -------------- ------------\r\n29725599596544\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN_ROW_DATA\u00a0\u00a0\u00a0\u00a0\u00a0 29725599596544\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -104\u00a0<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><\/span><\/pre>\n
Il se trouve que la table a \u00e9t\u00e9 vid\u00e9e de son contenu entre deux DBCC CHECKDB, et l’erreur n’avait pas \u00e9t\u00e9 d\u00e9tect\u00e9e imm\u00e9diatement apr\u00e8s la migration. Un petit coup de DBCC UPDATEUSAGE sur cette table:<\/p>\n
dbcc updateusage('MvxRef','Client_NULL')<\/span><\/pre>\n
DBCC UPDATEUSAGE\u00a0: nombre mis \u00e0 jour pour la table 'Client_NULL'\r\n(index 'Client_NULL', partition 1)\u00a0:\r\n Pages USED (In-row Data)\u00a0: changement de (-104) pages en (0) pages.\r\nEx\u00e9cution de DBCC termin\u00e9e. Si DBCC vous a adress\u00e9 des messages d'erreur,\r\ncontactez l'administrateur syst\u00e8me.<\/span><\/pre>\n
Et tout est rentr\u00e9 dans l’ordre:<\/p>\n
select allocation_unit_id, type_desc, container_id,total_pages, used_pages\r\nfrom sys.allocation_units AU inner join sys.partitions P on AU.container_id = P.hobt_id\r\nand P.object_id = object_id('Client_NULL')<\/span><\/pre>\n
allocation_unit_id\u00a0\u00a0 type_desc\u00a0\u00a0\u00a0  container_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 total_pages\u00a0  used_pages\r\n-------------------- ------------- -------------------- ------------- ------------\r\n29725599596544\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN_ROW_DATA\u00a0\u00a0 29725599596544\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/strong>\r\n\r\n<\/span><\/pre>\n
A+. David B.<\/span><\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"
Un petit article pour parler de cette erreur assez courante qui se rencontre soit avec des versions ant\u00e9rieures \u00e0 SQL Server 2005, soit \u00e0 la suite d’une migration. Elle n’est pas tr\u00e8s grave et plut\u00f4t bien d\u00e9crite puisque la solution… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7924,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[201,200],"class_list":["post-2203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-corruption","tag-dbcc"],"yoast_head":"\nMsg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Un petit article pour parler de cette erreur assez courante qui se rencontre soit avec des versions ant\u00e9rieures \u00e0 SQL Server 2005, soit \u00e0 la suite d’une migration. Elle n’est pas tr\u00e8s grave et plut\u00f4t bien d\u00e9crite puisque la solution… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-10T10:20:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:45:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/05\/dbcc.png\" \/>\n\t<meta property=\"og:image:width\" content=\"651\" \/>\n\t<meta property=\"og:image:height\" content=\"234\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect\",\"datePublished\":\"2011-05-10T10:20:37+00:00\",\"dateModified\":\"2019-09-13T13:45:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\"},\"wordCount\":201,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"corruption\",\"DBCC\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\",\"name\":\"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2011-05-10T10:20:37+00:00\",\"dateModified\":\"2019-09-13T13:45:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/","og_locale":"fr_FR","og_type":"article","og_title":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG","og_description":"Un petit article pour parler de cette erreur assez courante qui se rencontre soit avec des versions ant\u00e9rieures \u00e0 SQL Server 2005, soit \u00e0 la suite d’une migration. Elle n’est pas tr\u00e8s grave et plut\u00f4t bien d\u00e9crite puisque la solution… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2011-05-10T10:20:37+00:00","article_modified_time":"2019-09-13T13:45:33+00:00","og_image":[{"width":651,"height":234,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/05\/dbcc.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect","datePublished":"2011-05-10T10:20:37+00:00","dateModified":"2019-09-13T13:45:33+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/"},"wordCount":201,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["corruption","DBCC"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/","url":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/","name":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2011-05-10T10:20:37+00:00","dateModified":"2019-09-13T13:45:33+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/msg-2508-level-16-state-1-the-in-row-data-for-object-is-incorrect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Msg 2508, Level 16, State 1: the In-Row data %% for object %% is incorrect"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2203"}],"version-history":[{"count":23,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2203\/revisions"}],"predecessor-version":[{"id":2476,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2203\/revisions\/2476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7924"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=2203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=2203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}