{"id":45209,"date":"2026-06-24T08:44:45","date_gmt":"2026-06-24T06:44:45","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=45209"},"modified":"2026-06-24T08:44:45","modified_gmt":"2026-06-24T06:44:45","slug":"goldengate-trail-purge-fails","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/","title":{"rendered":"GoldenGate trail purge task fails with &#8220;OGG-12111: JSON element &#8216;\/csn&#8217; does not match any schemas&#8221;"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Since the beginning of the year, I had the opportunity to upgrade many GoldenGate setups to 26ai. On two of them, I was facing an <strong>issue regarding purge tasks<\/strong> that I could not solve. Since it took quite some time to finally find a solution, I figured it was worth documenting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The client had two GoldenGate 26ai installations running on the same server.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>One extracting data from\u00a0<strong>DB2<\/strong>, with GoldenGate for DB2\/zOS.<\/li>\n\n\n\n<li>One replicating into an\u00a0<strong>Oracle<\/strong>\u00a019c database, reading from the same trail files.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Both setups were using the initial release of GoldenGate 26ai.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On both, I tried to set up trail purge tasks from the Administration Service web UI, and <strong>both GoldenGate trail purge failed with the same error<\/strong>.<\/p>\n\n\n\n<h2 id=\"h-purge-task-creation-from-the-web-ui\" class=\"wp-block-heading\">Purge task creation from the web UI<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To add a purge task, go to the&nbsp;<strong>Administration Service<\/strong>&nbsp;web UI, and on the left navigation panel, click on&nbsp;<strong><em>Tasks &gt; Purge Trail<\/em><\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/06\/trail_purge_1.png\" alt=\"\" class=\"wp-image-45210\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">From there, create a new task. You will be asked to provide a\u00a0<strong>task name<\/strong>, one or multiple\u00a0<strong>trail paths<\/strong>,\u00a0<strong>retention rules<\/strong>, and whether to\u00a0<strong>use checkpoints<\/strong>\u00a0when purging trail files.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/06\/trail_purge_2-1024x1021.png\" alt=\"\" class=\"wp-image-45211\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">In my case, right after the creation, the purge task was failing with the\u00a0<code>OGG-12111<\/code>\u00a0error. This happened no matter how I configured the task. The task was correctly configured, but it would fail every time it was scheduled to run<\/p>\n\n\n\n<h2 id=\"h-ogg-12111-nbsp-in-the-web-ui\" class=\"wp-block-heading\"><code>OGG-12111<\/code>&nbsp;in the web UI<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The full error displayed was the following:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nJSON element &#039;\/csn&#039; does not match any schemas\nCode: OGG-12111\nCause: The JSON item does not validate against the provided JSON schema.\nAction: Correct the JSON so that it conforms to the JSON schema.\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">I first thought that it was a configuration issue on my side, but there is no such\u00a0<code>csn<\/code>\u00a0field when configuring the task. I quickly realized that if something was wrong, it was internal to GoldenGate. And unfortunately, all trail files were affected in this setup, so there was no working example to investigate further. On all other setups that I worked on, I never faced the\u00a0<code>OGG-12111<\/code>\u00a0error.<\/p>\n\n\n\n<h2 id=\"h-analysis-of-adminsrvr-log\" class=\"wp-block-heading\">Analysis of\u00a0<code>adminsrvr.log<\/code><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Digging into the Administration Service log, I found the real error underneath:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n2026-04-20T14:18:41.377+0200 ERROR| ERROR   OGG-01072  Oracle GoldenGate Administration Service for Oracle:  NUMCNV_getUnsignedNumFromStr: Buffer overflow, needed: 21, allocated: 20. (Purge)\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>OGG-01072<\/code>\u00a0is a buffer overflow in an internal GoldenGate method. It looked like a corrupted value gets embedded into the purge task JSON, and the JSON fails schema validation. And in the end, you get the\u00a0<code>OGG-12111<\/code>\u00a0error in the web UI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>OGG-12111<\/code>&nbsp;was just the symptom, while&nbsp;<code>OGG-01072<\/code>&nbsp;was the actual bug.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unfortunately, I couldn&#8217;t find any MOS bug filed for this. However, by trial and error, I discovered that the fix appears to have been <strong>introduced silently in a later patch<\/strong>, maybe through another bug resolution (that I could not identify).<\/p>\n\n\n\n<h2 id=\"h-how-to-solve-nbsp-ogg-12111-nbsp-errors-in-goldengate-26ai\" class=\"wp-block-heading\">How to solve&nbsp;<code>OGG-12111<\/code>&nbsp;errors in GoldenGate 26ai ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The only solution I found was patching GoldenGate to\u00a0<strong><code>23.26.2.0.1<\/code><\/strong>. I didn&#8217;t test the intermediate patch levels between <code>23.26.1.0.0<\/code> and <code>23.26.2.0.1<\/code>, so I can&#8217;t say exactly which patch introduced the fix, but upgrading to <code>23.26.2.0.1<\/code> resolved the issue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After patching, I went back to the&nbsp;<strong><em>Purge Trail<\/em><\/strong>&nbsp;section of the web UI, and the existing purge tasks were already working. I did not even have to recreate them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So if you face this bug and your GoldenGate trail purge fails, don&#8217;t spend time reviewing the purge task parameters. Your tasks are most probably fine. The bug is inside the Administration Service&#8217;s numeric conversion method, and patching is the only way out.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since the beginning of the year, I had the opportunity to upgrade many GoldenGate setups to 26ai. On two of them, I was facing an issue regarding purge tasks that I could not solve. Since it took quite some time to finally find a solution, I figured it was worth documenting. The client had two&hellip;&nbsp;<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[3787,59],"tags":[1545,11061,6415,1529,3813],"class_list":["post-45209","post","type-post","status-publish","format-standard","category-goldengate","category-oracle","tag-error","tag-goldengate-26ai","tag-oracle-26ai","tag-purge","tag-trail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>GoldenGate trail purge task fails with &quot;OGG-12111: JSON element &#039;\/csn&#039; does not match any schemas&quot; - dbi services Blog<\/title>\n<meta name=\"description\" content=\"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GoldenGate trail purge task fails with &quot;OGG-12111: JSON element &#039;\/csn&#039; does not match any schemas&quot;\" \/>\n<meta property=\"og:description\" content=\"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-24T06:44:45+00:00\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\"},\"headline\":\"GoldenGate trail purge task fails with &#8220;OGG-12111: JSON element &#8216;\\\/csn&#8217; does not match any schemas&#8221;\",\"datePublished\":\"2026-06-24T06:44:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/\"},\"wordCount\":550,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/trail_purge_1.png\",\"keywords\":[\"Error\",\"GoldenGate 26ai\",\"Oracle 26ai\",\"purge\",\"trail\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/\",\"name\":\"GoldenGate trail purge task fails with \\\"OGG-12111: JSON element '\\\/csn' does not match any schemas\\\" - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/trail_purge_1.png\",\"datePublished\":\"2026-06-24T06:44:45+00:00\",\"description\":\"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-trail-purge-fails\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GoldenGate trail purge task fails with &#8220;OGG-12111: JSON element &#8216;\\\/csn&#8217; does not match any schemas&#8221;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"caption\":\"Julien Delattre\"},\"description\":\"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \\\/ Universit\u00e9 Paris-Saclay.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/julien-delattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"GoldenGate trail purge task fails with \"OGG-12111: JSON element '\/csn' does not match any schemas\" - dbi services Blog","description":"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?","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:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/","og_locale":"en_US","og_type":"article","og_title":"GoldenGate trail purge task fails with \"OGG-12111: JSON element '\/csn' does not match any schemas\"","og_description":"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?","og_url":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-06-24T06:44:45+00:00","author":"Julien Delattre","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544"},"headline":"GoldenGate trail purge task fails with &#8220;OGG-12111: JSON element &#8216;\/csn&#8217; does not match any schemas&#8221;","datePublished":"2026-06-24T06:44:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/"},"wordCount":550,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/06\/trail_purge_1.png","keywords":["Error","GoldenGate 26ai","Oracle 26ai","purge","trail"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/","url":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/","name":"GoldenGate trail purge task fails with \"OGG-12111: JSON element '\/csn' does not match any schemas\" - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/06\/trail_purge_1.png","datePublished":"2026-06-24T06:44:45+00:00","description":"How to fix OGG-12111 errors with failing purge tasks in GoldenGate 26ai ?","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-trail-purge-fails\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"GoldenGate trail purge task fails with &#8220;OGG-12111: JSON element &#8216;\/csn&#8217; does not match any schemas&#8221;"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","caption":"Julien Delattre"},"description":"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \/ Universit\u00e9 Paris-Saclay.","url":"https:\/\/www.dbi-services.com\/blog\/author\/julien-delattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/45209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=45209"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/45209\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=45209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=45209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=45209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}