{"id":793,"date":"2015-02-16T10:51:36","date_gmt":"2015-02-16T09:51:36","guid":{"rendered":"http:\/\/vthink.fr\/2015\/02\/vcac-6-requete-bloquee-a-letat-in-progress-2\/"},"modified":"2016-02-03T15:45:28","modified_gmt":"2016-02-03T14:45:28","slug":"vcac-6-request-remains-in-state-in-progress","status":"publish","type":"post","link":"https:\/\/vthink.fr\/en\/2015\/02\/vcac-6-request-remains-in-state-in-progress\/","title":{"rendered":"vCAC 6 : Request remains in state &#8220;In Progress&#8221;"},"content":{"rendered":"\n<!-- Quick Adsense WordPress Plugin: http:\/\/quickadsense.com\/ -->\n<div class=\"e93ad9a1ff002511692efbd236903a83\" data-index=\"1\" style=\"float: left; margin: 10px 10px 10px 0;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- ads1 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:300px;height:250px\"\r\n     data-ad-client=\"ca-pub-9785518987307332\"\r\n     data-ad-slot=\"8809267401\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>In vCAC (or vRealize Automation now), <span id=\"result_box\" class=\"\" lang=\"en\"><span class=\"hps\">many requests<\/span> <span class=\"hps\">were blocked<\/span> <span class=\"hps\">in<\/span> <span class=\"hps atn\">status &#8220;<\/span><span class=\"\">In Progress<\/span>&#8221; <span class=\"hps\">since few weeks<\/span> <span class=\"hps\">or months<\/span><span class=\"\">!<\/span><\/span><\/p>\n<p>The task was not more present in vCenter orchestrator or vCAC.<\/p>\n<p>I will give you a fix to clean up all these tasks that remains &#8220;In Progress&#8221; :<\/p>\n<hr \/>\n<p>In this example, the resquest number &#8220;92&#8221; is\u00a0 \u00ab\u00a0In progress\u00a0\u00bb since 06\/25\/2014. More than 6 month !<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-678\" src=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/10.png?resize=700%2C33&#038;ssl=1\" alt=\"inprogress\" width=\"700\" height=\"33\" srcset=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/10.png?w=1115&amp;ssl=1 1115w, https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/10.png?resize=300%2C14&amp;ssl=1 300w, https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/10.png?resize=1024%2C49&amp;ssl=1 1024w\" sizes=\"(max-width: 700px) 100vw, 700px\" data-recalc-dims=\"1\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>First step, <span id=\"result_box\" class=\"\" lang=\"en\"><span class=\"hps\">you have to log<\/span> <span class=\"hps\">in<\/span> <span class=\"hps\">with<\/span> <span class=\"hps\">ssh<\/span> <span class=\"hps\">user &#8220;root<\/span>&#8221; on your vCAC<span class=\"hps\"> appliance<\/span><\/span>.<\/p>\n<p>Then , go to the bin directory of vpostgres.<\/p>\n<p><strong><span style=\"color: #999999;\">#cd \/opt\/vmware\/vpostgres\/9.2\/bin\/\u00b7<\/span><\/strong><\/p>\n<p>Next, you should be able to connect to the vcac database with the\u00a0 username&#8221;vcac&#8221;:<\/p>\n<p><strong><span style=\"color: #999999;\">#.\/psql -U vcac -d vcac<\/span><\/strong><\/p>\n<p>Next,<\/p>\n<p><strong><span style=\"color: #999999;\">SELECT id,requestnumber FROM cat_request where state=&#8217;IN_PROGRESS&#8217; and requestnumber = &#8220;RequestNum&#8221;;<\/span><\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-687\" src=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/111.png?resize=671%2C197&#038;ssl=1\" alt=\"11\" width=\"671\" height=\"197\" srcset=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/111.png?w=671&amp;ssl=1 671w, https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/111.png?resize=300%2C88&amp;ssl=1 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" data-recalc-dims=\"1\" \/><\/p>\n<!-- Quick Adsense WordPress Plugin: http:\/\/quickadsense.com\/ -->\n<div class=\"e93ad9a1ff002511692efbd236903a83\" data-index=\"1\" style=\"float: left; margin: 10px 10px 10px 0;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- ads1 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:300px;height:250px\"\r\n     data-ad-client=\"ca-pub-9785518987307332\"\r\n     data-ad-slot=\"8809267401\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p>RequestNum should be replaced by the Request Number. So, in our\u00a0 example\u00a0 &#8220;92&#8221;.<\/p>\n<p>Retrieve the ID send by the request.<\/p>\n<p>In this example : <strong>b5ff16f8-433c-XXXX-XXXX-XXXX<\/strong><\/p>\n<p>Then execute this command :<\/p>\n<p><strong><span style=\"color: #999999;\">delete from cat_requestevent_details where requestevent_id in(select id from cat_requestevent where request_id =&#8221;);<\/span><\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-688\" src=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/12.png?resize=655%2C74&#038;ssl=1\" alt=\"12\" width=\"655\" height=\"74\" srcset=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/12.png?w=655&amp;ssl=1 655w, https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/12.png?resize=300%2C34&amp;ssl=1 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" data-recalc-dims=\"1\" \/> The\u00a0 ID should be replaced by your ID.<\/p>\n<p>The return can be 0.<\/p>\n<p>Next\u00a0 :<\/p>\n<p><strong><span style=\"color: #999999;\">delete from cat_requestevent where request_id = &#8221;;<\/span><\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-689\" src=\"https:\/\/i1.wp.com\/vthink.fr\/wp-content\/uploads\/13.png?resize=641%2C45&#038;ssl=1\" alt=\"13\" width=\"641\" height=\"45\" srcset=\"https:\/\/i1.wp.com\/vthink.fr\/wp-content\/uploads\/13.png?w=641&amp;ssl=1 641w, https:\/\/i1.wp.com\/vthink.fr\/wp-content\/uploads\/13.png?resize=300%2C21&amp;ssl=1 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" data-recalc-dims=\"1\" \/><\/p>\n<p>And then :<\/p>\n<p><strong><span style=\"color: #999999;\"> delete from cat_request where id =&#8217;ID&#8217;;<\/span><\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-690\" src=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/14.png?resize=642%2C64&#038;ssl=1\" alt=\"14\" width=\"642\" height=\"64\" srcset=\"https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/14.png?w=642&amp;ssl=1 642w, https:\/\/i2.wp.com\/vthink.fr\/wp-content\/uploads\/14.png?resize=300%2C30&amp;ssl=1 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" data-recalc-dims=\"1\" \/><\/p>\n<p>It&#8217;s over \ud83d\ude09 so you can leave psql with this command :<\/p>\n<p><strong><span style=\"color: #999999;\">\\q <\/span><\/strong>and enter<\/p>\n<p>That&#8217;s it ! Go to vCAC and refresh your web browser. The task is no more displayed.<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div><!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>In vCAC (or vRealize Automation now), many requests were blocked in status &#8220;In Progress&#8221; since few weeks or months! The task was not more present in vCenter orchestrator or vCAC. I will give you a fix to clean up all these tasks that remains &#8220;In Progress&#8221; : In this example, the resquest number &#8220;92&#8221; is\u00a0&hellip;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":2,"featured_media":769,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1027],"tags":[1028,1029,1030,1031,1032,1033,1034,1035,1083,1036,1037,1038,1039,1040,1410,1042,1043,1044,1045,1079,1085,1046,1047,1048,1049,1082,1050,1051,1084,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1080,1067,1641,1068,1069,1070,1071,1072,1073,1074,1075,1076,1661,1664,1665,1087,1086,1663,1662,1077,1081,1078],"_links":{"self":[{"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/posts\/793"}],"collection":[{"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/comments?post=793"}],"version-history":[{"count":6,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/posts\/793\/revisions"}],"predecessor-version":[{"id":799,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/posts\/793\/revisions\/799"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/media\/769"}],"wp:attachment":[{"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/media?parent=793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/categories?post=793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vthink.fr\/en\/wp-json\/wp\/v2\/tags?post=793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}