Replicat Abends with ORA-29861 (Doc ID 1911446.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2.0.0 version, 1 - Oracle DB backend

When attempting to ,
the following error occurs.

ERROR
-----------------------
Wildcard MAP resolved (entry MAXIMO.*):
MAP "MAXIMO"."PRLINE",TARGET maximo."PRLINE";
Using following columns in default map by name:
  PRNUM, ITEMNUM, STORELOC, ORDERQTY, ORDERUNIT, UNITCOST, PONUM, REQDELIVERYDATE, VENDELIVERYDATE, ENTERDATE, ENTERBY, DESCRIPTION,
  RL1, RL2, RL3, RL4, RL5, REQUESTEDBY, ISSUE, RLIN1, RLIN2, RLIN3, RLIN4, RLIN5, ASSETNUM, CHARGESTORE, GLDEBITACCT, GLCREDITACCT,
  LINECOST, TAX1CODE, TAX1, TAX2CODE, TAX2, TAX3CODE, TAX3, RECEIPTREQD, MANUFACTURER, MODELNUM, CATALOGCODE, TAX4CODE, TAX4,
  TAX5CODE, TAX5, PRLINENUM, POLINENUM, CATEGORY, REMARK, LOCATION, LOADEDCOST, PRORATESERVICE, CONVERTTORFQ, RFQNUM, RFQLINENUM,
  INSPECTIONREQUIRED, RFQLINEID, POLINEID, LINECOST2, MRNUM, MRLINENUM, RL6, RL7, RL8, RL9, RL10, RLIN6, RLIN7, RLIN8, RLIN9, PRLALN1,
  PRLALN2, PRLALN3, PRLALN4, PRLALN5, PCARDNUM, PCARDTYPE, PCARDEXPDATE, FINCNTRLID, PCARDVERIFICATION, VENDORPACKCODE,
  VENDORPACKQUANTITY, VENDORWAREHOUSE, SITEID, ORGID, PRLINEID, ISDISTRIBUTED, REFWO, ENTEREDASTASK, LINETYPE, ITEMSETID,
  CONDITIONCODE, CONTRACTNUM, CONTRACTLINENUM, CONTRACTLINEID, CONTRACTREFNUM, COMMODITYGROUP, COMMODITY, CONVERTTOCONTRACT,
  CONTRACTREFID, CONTRACTREFREV, CONTRACTREV, SCHEDULEID, CONTREFLINEID, LANGCODE, CONVERSION, CONTRACTID, HASLD, MKTPLCITEM,
  CLASSSTRUCTUREID, ROWSTAMP, POSITEID, POREVISIONNUM, TAXEXEMPT, RESTYPE, CONSIGNMENT, TLOAMLICENSENUM
Using the following key columns for target table MAXIMO.PRLINE: PRLINEID.

2014-07-23 13:19:03 WARNING OGG-00869 OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL .

2014-07-23 13:19:03 WARNING OGG-01004 Aborted grouped transaction on 'MAXIMO.PRLINE', Database error 29861 (OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL ).

2014-07-23 13:19:03 WARNING OGG-01003 Repositioning to rba 96834343 in seqno 13.

2014-07-23 13:19:04 WARNING OGG-01154 SQL error 29861 mapping MAXIMO.PRLINE to MAXIMO.PRLINE OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL .


2014-07-23 13:19:04 ERROR OGG-01296 Error mapping from MAXIMO.PRLINE to MAXIMO.PRLINE.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms