{"id":203,"date":"2009-09-21T10:05:00","date_gmt":"2009-09-21T09:05:00","guid":{"rendered":"https:\/\/www.alldb.fr\/blogs\/?p=203"},"modified":"2023-04-20T07:04:56","modified_gmt":"2023-04-20T06:04:56","slug":"replication-sql-server-retrouver-la-vilaine-transaction-en-echec","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/","title":{"rendered":"Retrouver une transaction en \u00e9chec"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203&#038;title=Retrouver%20une%20transaction%20en%20%C3%A9chec\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Retrouver%20une%20transaction%20en%20%C3%A9chec&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Aujourd&#8217;hui la r\u00e9plication transactionnelle est en panne. Un coup d&#8217;oeil rapide au moniteur de r\u00e9plication nous confirme que l&#8217;agent de distribution est en \u00e9chec:<\/p>\n<pre><em>Command attempted:\r\nif @@trancount &gt; 0 rollback tran\r\n(Transaction sequence number: 0x0000CD53000011DE001000000000, Command ID: 1)\r\n\r\nError messages:\r\nSyntax error, permission violation, or other nonspecific error (Source: MSSQLServer,\r\nError number: 20025)\r\nGet help: https:\/\/help\/20025\r\nSyntax error, permission violation, or other nonspecific error (Source: MSSQLServer,\r\nError number: 42000)\r\nGet help: https:\/\/help\/42000<\/em><\/pre>\n<p>Ce n&#8217;est m\u00eame pas la peine d&#8217;essayer de voir ce qu&#8217;il y a au bout des deux liens <em>https:\/\/help\/&#8230;<\/em> propos\u00e9s. En gros l&#8217;agent de distribution a trouv\u00e9 une erreur en essayant d&#8217;appliquer une transaction. Le but est de retrouver le code SQL qui correspond \u00e0 la transaction en \u00e9chec. Lancer une trace Profiler sur le distributeur ne servira pas \u00e0 grand chose car la transaction en question sera noy\u00e9e dans le flot de mises \u00e0 jour sur les tables syst\u00e8mes de la r\u00e9plication. En fait la chose la plus importante dans le log d&#8217;erreur est le num\u00e9ro de transaction: <strong><em><\/em><em>0x0000CD53000011DE001000000000<\/em><\/strong><\/p>\n<p>Pour retrouver l&#8217;ordre correspondant sur le distributeur, utiliser <strong>sp_browsereplcmds<\/strong>, regarder la premi\u00e8re ligne:<\/p>\n<pre>use distribution\r\nsp_browsereplcmds @xact_seqno_start = '0x0000CD53000011DE001000000000'\r\n\r\n0x0000CD53000012EE000E\tNULL\tNULL\t1\t30\t0\t0\tNULL\tNULL\r\n0x00000000000000000000\r\n{CALL sp_MSins_EMAIL MOBILE DATA ('MICHAEL.HEARSLEY#TATOINE.COM', 'J74K6L')}\t1\r\n\r\n0x0000CD5300001304000F\tNULL\tNULL\t1\t30\t0\t0\tNULL\tNULL\r\n0x00000000000000000000\r\n{CALL sp_MSins_EMAIL MOBILE DATA ('EDUARDO.ALFONSO#JPMM.COM', 'J91RCX')}\t1\r\n\r\n0x0000CD530000131A0018\tNULL\tNULL\t1\t30\t0\t0\tNULL\tNULL\r\n0x00000000000000000000\r\n{CALL sp_MSins_EMAIL MOBILE DATA ('MARK.D.SPELLMAN#ATTACH.CO.UK', 'J731FZ')} 1\r\n\r\n0x0000CD530000133B000E\tNULL\tNULL\t1\t30\t0\t0\tNULL\tNULL\r\n0x00000000000000000000\r\n{CALL sp_MSins_EMAIL MOBILE DATA ('XAVIER.BARTOLDI#NRJ.PICATRIX.COM', 'J92HBF')} 1\r\n\r\n...<\/pre>\n<p>Effectivement si on lance l&#8217;ex\u00e9cution de la proc \u00e0 la main sur le subscriber:<\/p>\n<pre>CALL sp_MSins_EMAIL MOBILE DATA ('MICHAEL.HEARSLEY#TATOINE.COM', 'J74K6L')\r\n\r\nMsg 102, Level 15, State 1, Line 1\r\nIncorrect syntax near 'MOBILE'.<\/pre>\n<p>Il y a des espaces dans le nom de la proc. L&#8217;assistant graphique de mise en place de la r\u00e9plication cr\u00e9era la proc\u00e9dure avec des underscores, donc pas de souci, c&#8217;est juste pour l&#8217;exemple.<\/p>\n<p>[ David B. ]<\/p>\n<p><script type=\"text\/javascript\" src=\"https:\/\/tcr.tynt.com\/javascripts\/Tracer.js?user=d4FlbGI04r35lZadbi-bpO\"><\/script><\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203&#038;title=Retrouver%20une%20transaction%20en%20%C3%A9chec\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Retrouver%20une%20transaction%20en%20%C3%A9chec&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F203\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Aujourd&#8217;hui la r\u00e9plication transactionnelle est en panne. Un coup d&#8217;oeil rapide au moniteur de r\u00e9plication nous confirme que l&#8217;agent de distribution est en \u00e9chec: Command attempted: if @@trancount &gt; 0 rollback tran (Transaction sequence number: 0x0000CD53000011DE001000000000, Command ID: 1) Error&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,450],"tags":[31],"class_list":["post-203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","category-vintage","tag-replication"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Retrouver une transaction en \u00e9chec - 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\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Retrouver une transaction en \u00e9chec - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Aujourd&#8217;hui la r\u00e9plication transactionnelle est en panne. Un coup d&#8217;oeil rapide au moniteur de r\u00e9plication nous confirme que l&#8217;agent de distribution est en \u00e9chec: Command attempted: if @@trancount &gt; 0 rollback tran (Transaction sequence number: 0x0000CD53000011DE001000000000, Command ID: 1) Error&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-21T09:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-20T06:04:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2009\/09\/depositphotos_50501929-stock-illustration-failure.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"304\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Retrouver une transaction en \u00e9chec\",\"datePublished\":\"2009-09-21T09:05:00+00:00\",\"dateModified\":\"2023-04-20T06:04:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\"},\"wordCount\":205,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"replication\"],\"articleSection\":[\"SQL Server\",\"Vintage\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\",\"name\":\"Retrouver une transaction en \u00e9chec - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2009-09-21T09:05:00+00:00\",\"dateModified\":\"2023-04-20T06:04:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Retrouver une transaction en \u00e9chec\"}]},{\"@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":"Retrouver une transaction en \u00e9chec - 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\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/","og_locale":"fr_FR","og_type":"article","og_title":"Retrouver une transaction en \u00e9chec - Capdata TECH BLOG","og_description":"Aujourd&#8217;hui la r\u00e9plication transactionnelle est en panne. Un coup d&#8217;oeil rapide au moniteur de r\u00e9plication nous confirme que l&#8217;agent de distribution est en \u00e9chec: Command attempted: if @@trancount &gt; 0 rollback tran (Transaction sequence number: 0x0000CD53000011DE001000000000, Command ID: 1) Error&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2009-09-21T09:05:00+00:00","article_modified_time":"2023-04-20T06:04:56+00:00","og_image":[{"width":450,"height":304,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2009\/09\/depositphotos_50501929-stock-illustration-failure.jpg","type":"image\/jpeg"}],"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\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Retrouver une transaction en \u00e9chec","datePublished":"2009-09-21T09:05:00+00:00","dateModified":"2023-04-20T06:04:56+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/"},"wordCount":205,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["replication"],"articleSection":["SQL Server","Vintage"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/","url":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/","name":"Retrouver une transaction en \u00e9chec - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2009-09-21T09:05:00+00:00","dateModified":"2023-04-20T06:04:56+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/replication-sql-server-retrouver-la-vilaine-transaction-en-echec\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Retrouver une transaction en \u00e9chec"}]},{"@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\/203","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=203"}],"version-history":[{"count":15,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"predecessor-version":[{"id":9528,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/203\/revisions\/9528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7976"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}