Oracle Marketing Content Upload/Create/Add Error: "Error returned in IBC_CITEM_ADMIN_GRP.upsert_item_full. ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE"

(Doc ID 977514.1)

Last updated on MARCH 08, 2018

Applies to:

Oracle Content Manager - Version 11.5.10.0 to 12.0.4 [Release 11.5 to 12.0]
Information in this document applies to any platform.

Symptoms

Cover Letter, when attempting to create/upload content such as cover letter in Oracle Marketing, the following error occurs.

Error

Error returned in IBC_CITEM_ADMIN_GRP.upsert_item_full. ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Responsibility: Oracle Marketing Administrator
  2. Navigation: Campaign
  3. Create Campaign/Email Activity
  4. Add Collateral Tab
  5. Create Cover Letter
  6. Error Message

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