{"id":8499,"date":"2016-06-29T13:29:16","date_gmt":"2016-06-29T11:29:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/"},"modified":"2016-06-29T13:29:16","modified_gmt":"2016-06-29T11:29:16","slug":"docmentum-multiple-adts-switching-rendition-queue","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/","title":{"rendered":"Documentum Multiple ADTS: Switching rendition queue"},"content":{"rendered":"<p>As part of my previous posts about having 2 rendition servers for one docbase (see below), I&#8217;ll show you how to simply switch a rendition queue item to the other server<br \/>\n&#8211; <a title=\"http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/\" href=\"http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/\">http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/<\/a><br \/>\n&#8211; <a title=\"http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/\" href=\"http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/\">http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/<\/a><\/p>\n<p>I had an issue by a customer where one of the two rendition server was stuck since 2 days. As I explained in my previous posts, each server will reserve a group of items from the queue for it to process. Let&#8217;s say we got the threshold to 5 items. Each server will reserve 5 items in the dmi_queue_item and set the attribute sign_off_user to itself. E.g. RNDSERVER_DOCBASE1.<\/p>\n<p>Then it will process each items one by one; onces one is done it will reserve a new one from the queue, and so on.<\/p>\n<p>The problem is: if the rendition server is stuck for whatever reason all reserved items will NOT go back to the available pool. It means that they will be reserved by THIS rendition server until you fix the server and it starts processing them again.<\/p>\n<p>You can imagine what I got by the customer, some documents were not rendered since 2 days!<\/p>\n<p>So here is the simplest solution to put the items back in the pool:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">update dmi_queue_item objects set sign_off_user ='' where sign_off_user ='RNDSERVER_DOCBASE1';<\/pre>\n<p>Hence all items will be set as available. The other rendition server should reserve them now as the current server is stuck and can&#8217;t reserve more items.<\/p>\n<p>In the case of a big file beeing processed by the first server and you want the documents to be processed by the other one you can reserver items by yourself manually with:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">update dmi_queue_item objects set sign_off_user='RNDSERVER2_DOCBASE1' where item_id in ('09xxxx','09xxxx');<\/pre>\n<p>If you have any questions please use the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As part of my previous posts about having 2 rendition servers for one docbase (see below), I&#8217;ll show you how to simply switch a rendition queue item to the other server &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/ &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/ I had an issue by a customer where one of the two rendition server was stuck since 2 days. As [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[418,870,129,419,871,504,872,873],"type_dbi":[],"class_list":["post-8499","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","tag-adts","tag-dmi_queue_item","tag-documentum","tag-emc","tag-ha","tag-rendition","tag-server","tag-sign_off_user"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Documentum Multiple ADTS: Switching rendition queue - dbi 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:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Documentum Multiple ADTS: Switching rendition queue\" \/>\n<meta property=\"og:description\" content=\"As part of my previous posts about having 2 rendition servers for one docbase (see below), I&#8217;ll show you how to simply switch a rendition queue item to the other server &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/ &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/ I had an issue by a customer where one of the two rendition server was stuck since 2 days. As [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-29T11:29:16+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Documentum Multiple ADTS: Switching rendition queue\",\"datePublished\":\"2016-06-29T11:29:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\"},\"wordCount\":292,\"commentCount\":0,\"keywords\":[\"ADTS\",\"dmi_queue_item\",\"Documentum\",\"EMC\",\"HA\",\"Rendition\",\"server\",\"sign_off_user\"],\"articleSection\":[\"Application integration &amp; Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\",\"name\":\"Documentum Multiple ADTS: Switching rendition queue - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-06-29T11:29:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentum Multiple ADTS: Switching rendition queue\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Documentum Multiple ADTS: Switching rendition queue - dbi 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:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/","og_locale":"en_US","og_type":"article","og_title":"Documentum Multiple ADTS: Switching rendition queue","og_description":"As part of my previous posts about having 2 rendition servers for one docbase (see below), I&#8217;ll show you how to simply switch a rendition queue item to the other server &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-1\/ &#8211; http:\/\/dbi-services.com\/blog\/documentum-multiple-adts-ratio-of-rendition-creations-between-instances-part-2\/ I had an issue by a customer where one of the two rendition server was stuck since 2 days. As [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/","og_site_name":"dbi Blog","article_published_time":"2016-06-29T11:29:16+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Documentum Multiple ADTS: Switching rendition queue","datePublished":"2016-06-29T11:29:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/"},"wordCount":292,"commentCount":0,"keywords":["ADTS","dmi_queue_item","Documentum","EMC","HA","Rendition","server","sign_off_user"],"articleSection":["Application integration &amp; Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/","url":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/","name":"Documentum Multiple ADTS: Switching rendition queue - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-06-29T11:29:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/docmentum-multiple-adts-switching-rendition-queue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Documentum Multiple ADTS: Switching rendition queue"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8499","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\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8499\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8499"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}