{"id":12190,"date":"2016-10-06T15:07:55","date_gmt":"2016-10-06T14:07:55","guid":{"rendered":"http:\/\/orabr.com\/?p=12190"},"modified":"2016-10-06T11:09:28","modified_gmt":"2016-10-06T14:09:28","slug":"-erro-replicate-seed-data","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=12190","title":{"rendered":"Erro Replicate Seed Data"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<div>  <span>&nbsp;<\/span><!--~-|**|PrettyHtmlStartT|**|-~-->  <\/p>\n<div id=\"ygrp-mlmsg\">\n<div id=\"ygrp-msg\"><!--~-|**|PrettyHtmlEndT|**|-~-->  <\/p>\n<div id=\"ygrp-text\">\n<div>Pessoal,<\/div>\n<div id=\"AppleMailSignature\">  <\/div>\n<div id=\"AppleMailSignature\">Apenas para atualiza\u00e7\u00e3o da solu\u00e7\u00e3o:<\/div>\n<div id=\"AppleMailSignature\">  <\/div>\n<div id=\"AppleMailSignature\">A Oracle indicou o note 312640.1 onde existe um passo a passo para a recria\u00e7\u00e3o de v\u00e1rios \u00edndices.&nbsp;<\/div>\n<div id=\"AppleMailSignature\">Ap\u00f3s a aplica\u00e7\u00e3o do passo a passo, o concurrent finalizou sem erro e a tela de configura\u00e7\u00e3o de compra voltou a abrir normalmente.<\/div>\n<div id=\"AppleMailSignature\">  <\/div>\n<div id=\"AppleMailSignature\">Muito obrigado pela ajuda.<\/div>\n<div id=\"AppleMailSignature\">  <\/div>\n<div id=\"AppleMailSignature\">Valdemar Soares<\/p>\n<p>  Enviado do meu iPhone<\/p><\/div>\n<div>  Em 30 de set de 2016, \u00e0s 15:23, Ednei Varela Ferreira <a href=\"mailto:codex@uol.com.br\">  codex@uol.com.br<\/a>  &lt;<a href=\"mailto:\"><\/a>&gt; escreveu:<\/p><\/div>\n<blockquote>\n<div><span>&nbsp;<\/span>  <\/p>\n<div id=\"ygrp-text\">\n<p>Complementando:<\/p>\n<p>  Tem um note que fala que o problema \u00e9 no index FND_LOBS_CTX<br \/>  Note: At &quot;Replicate Seed Data&quot;: ORA-20000: ORA-20011: UNKNOWN Error -29861 &#8211; ORA-29861: domain index is marked LOADING\/FAILED\/UNUSABLE (Doc ID 367729.1)<\/p>\n<p>  Att.,<br \/>  Ednei<br \/>  &nbsp; <\/p>\n<hr>\n<div>  <strong>De: <\/strong>&quot;Deco <a href=\"mailto:deco@decos.com.br\">deco@decos.com.br<\/a> &quot; &lt;<a href=\"mailto:\"><\/a>&gt;<br \/>  <strong>Enviada: <\/strong>2016\/09\/30 15:05:38<br \/>  <strong>Para: <\/strong><a href=\"mailto:\"><\/a><br \/>  <strong>Assunto: <\/strong>  Erro Replicate Seed Data<br \/>  &nbsp;<\/div>\n<p>  <span>&nbsp;<\/span>  <\/p>\n<div id=\"ygrp-text\">\n<p>&nbsp;<\/p>\n<div class=\"WordSection1\">\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">Boa tarde Valdemar,<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">Pede para o ATG verificar os indices.<\/span><\/p>\n<p>  <span>select index_name,status from user_indexes where status=&#8217;UNUSABLE&#8217;;<\/span><\/p>\n<p class=\"MsoNormal\"><span>&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\"><span>Depois de achar o que est\u00e1 com status &#8216;UNUSABLE&#8217; , que faz referencia no objeto do erro, faz o rebuild.<\/span><\/p>\n<p class=\"MsoNormal\"><span>&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\"><span>alter index USER.INDEX rebuild &lt;online&gt;;<\/span><span style=\"font-family:Calibri\"><\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">Abs<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">Deco<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size:11.0pt;font-family:Calibri\">&nbsp;<\/span><\/p>\n<div style=\"border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in\">\n<p class=\"MsoNormal\"><b><span style=\"font-family:Calibri;color:black\">From: <\/span>  <\/b><span style=\"font-family:Calibri;color:black\">&lt;<a href=\"mailto:\"><\/a>&gt; on behalf of &quot;<a href=\"mailto:valdemar_soares@hotmail.com\">valdemar_soares@hotmail.com<\/a> &quot; &lt;<a href=\"mailto:\"><\/a>&gt;<br \/>  <b>Reply-To: <\/b>&lt;<a href=\"mailto:\"><\/a>&gt;<br \/>  <b>Date: <\/b>Friday, September 30, 2016 at 2:20 PM<br \/>  <b>To: <\/b>&lt;<a href=\"mailto:\"><\/a>&gt;<br \/>  <b>Subject: <\/b> Erro Replicate Seed Data<\/span><\/p>\n<\/p><\/div>\n<div>\n<p class=\"MsoNormal\">&nbsp;<\/p>\n<\/p><\/div>\n<p class=\"MsoNormal\">&nbsp; <\/p>\n<div id=\"ygrp-mlmsg\">\n<div id=\"ygrp-msg\">\n<div id=\"ygrp-text\">\n<p>Pessoal Boa tarde,<\/p>\n<p>  Estou configurando uma nova organiza\u00e7\u00e3o no cliente, vers\u00e3o 11.5.10.2, onde a Operating Unit j\u00e1 estava criada, mas nunca foi usada.<\/p>\n<p>  Ao rodar o concurrent Replicate Seed Data, o mesmo termina com erro:<\/p>\n<p>  declare<br \/>  *<br \/>  ERROR at line 1<br \/>  ORA-2000: ORA-20011: UNKNOWN Error &#8211; 29861 &#8211; ORA-29861 : domain index is marked LOADING\/FAILED\/UNUSABLE<br \/>  ORA-06512: at &quot;APPS.QRY_INSERT_AFT_CRT_UPT_ROW&quot;, line 81<br \/>  ORA-04088: error during executing of trigger<\/p>\n<p>  Al\u00e9m disso,<br \/>  A tela de op\u00e7\u00e3o de compras do PO abre apenas como consulta, n\u00e3o permite fazer altera\u00e7\u00f5es.<\/p>\n<p>  Algu\u00e9m j\u00e1 passou por isso ou tem alguma ideia do que pode ser?<\/p>\n<p>  Qualquer ajuda ser\u00e1 bem vinda,<\/p>\n<p>  Valdemar Soares<br \/>  (11)96090-5591<br \/>  Skype: valdemar_soares<\/p>\n<p>  Enviado do meu iPhone<\/p>\n<\/p><\/div>\n<div>\n<p class=\"MsoNormal\"><span style=\"color:white\"><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>&nbsp;<\/p>\n<\/p><\/div>\n<p>  <!-- end group email -->  <\/p>\n<\/p><\/div>\n<p>  <!-- end group email --><\/div>\n<\/blockquote>\n<blockquote>\n<div>&lt;Doc ID 367729.1.pdf&gt;<\/div>\n<\/blockquote>\n<\/p><\/div>\n<p>  <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Pessoal, Apenas para atualiza\u00e7\u00e3o da solu\u00e7\u00e3o: A Oracle indicou o note 312640.1 onde existe um passo a passo para a recria\u00e7\u00e3o de v\u00e1rios \u00edndices.&nbsp;&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-12190","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/12190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12190"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/12190\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}