{"id":12149,"date":"2016-09-30T19:20:01","date_gmt":"2016-09-30T18:20:01","guid":{"rendered":"http:\/\/orabr.com\/?p=12149"},"modified":"2016-09-30T15:31:46","modified_gmt":"2016-09-30T18:31:46","slug":"-erro-replicate-seed-data-3","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=12149","title":{"rendered":"Erro Replicate Seed Data"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n

Complementando:<\/p>\n

Tem um note que fala que o problema \u00e9 no index FND_LOBS_CTX
Note: At "Replicate Seed Data": ORA-20000: ORA-20011: UNKNOWN Error -29861 – ORA-29861: domain index is marked LOADING\/FAILED\/UNUSABLE (Doc ID 367729.1)<\/p>\n

Att.,
Ednei
  <\/p>\n

\n
De: <\/strong>"Deco deco@decos.com.br " <>
Enviada: <\/strong>2016\/09\/30 15:05:38
Para: <\/strong>
Assunto: <\/strong> Erro Replicate Seed Data
 <\/div>\n

 <\/span> <\/p>\n

\n

 <\/p>\n

\n

Boa tarde Valdemar,<\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

Pede para o ATG verificar os indices.<\/span><\/p>\n

select index_name,status from user_indexes where status=’UNUSABLE’;<\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

Depois de achar o que est\u00e1 com status ‘UNUSABLE’ , que faz referencia no objeto do erro, faz o rebuild.<\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

alter index USER.INDEX rebuild <online>;<\/span><\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

Abs<\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

Deco<\/o><\/span><\/p>\n

 <\/o><\/span><\/p>\n

\n

From: <\/span> <\/b><> on behalf of "valdemar_soares@hotmail.com " <>
Reply-To: <\/b><>
Date: <\/b>Friday, September 30, 2016 at 2:20 PM
To: <\/b><>
Subject: <\/b> Erro Replicate Seed Data<\/o><\/span><\/p>\n<\/p><\/div>\n

\n

 <\/o><\/p>\n<\/p><\/div>\n

  <\/o><\/p>\n

\n
\n
\n

Pessoal Boa tarde,<\/p>\n

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

Ao rodar o concurrent Replicate Seed Data, o mesmo termina com erro:<\/p>\n

declare
*
ERROR at line 1
ORA-2000: ORA-20011: UNKNOWN Error – 29861 – ORA-29861 : domain index is marked LOADING\/FAILED\/UNUSABLE
ORA-06512: at "APPS.QRY_INSERT_AFT_CRT_UPT_ROW", line 81
ORA-04088: error during executing of trigger<\/p>\n

Al\u00e9m disso,
A tela de op\u00e7\u00e3o de compras do PO abre apenas como consulta, n\u00e3o permite fazer altera\u00e7\u00f5es.<\/p>\n

Algu\u00e9m j\u00e1 passou por isso ou tem alguma ideia do que pode ser?<\/p>\n

Qualquer ajuda ser\u00e1 bem vinda,<\/p>\n

Valdemar Soares
(11)96090-5591
Skype: valdemar_soares<\/p>\n

Enviado do meu iPhone<\/o><\/p>\n<\/p><\/div>\n

\n

<\/o><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

 <\/p>\n<\/p><\/div>\n

<\/p>\n<\/p><\/div>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

  Complementando: Tem um note que fala que o problema \u00e9 no index FND_LOBS_CTX Note: At "Replicate Seed Data": ORA-20000: ORA-20011: UNKNOWN Error -29861 –… <\/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-12149","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\/12149","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=12149"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/12149\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}