Unable To Install Project Controls Due To Error "ORA-29861"

(Doc ID 2335156.1)

Last updated on JANUARY 02, 2018

Applies to:

Primavera Unifier - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
----------------------
Install Project Controls failed , got error: Failed adding document : UCR Document .....

Captured below error in Unifier.log:

YYYY-YY-DD 13:16:57,724+09:00 [[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ucr.CRSecureDAOImpl            ~20507910035691495~ Failed to add the revision document.~
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-29861: Domain index is marked LOADING / FAILED / UNUSABLE.

com.primavera.ucr.UniversalContentRepositoryException: Failed adding document: UCRDocument[m_fileSize=0,m_fileName=98AF3C72-5337-C2AF-C9CD-926FD2B1A9AE.xdm,m_mimeType=<null>,m_version=<null>,m_versionlabel=<null>,m_documentName=<null>,m_creationDate=YYYY-MM-27T13:16:57.318+09:00,m_lastModifiedBy=<null>,m_lastModifiedByUserId=<null>,m_lastModifiedDate=2017-MM-27T13:16:57.377+09:00,m_isCheckedout=false,m_uuid=1,m_parentUuid=<null>,m_title=98AF3C72-5337-C2AF-C9CD-926FD2B1A9AE.xdm,m_atRootLevel=false,m_authorUserName=<null>,m_isReference=false,m_referenceId=<null>,m_Url=<null>,securityAccount=<null>,revisionClassId=<null>,m_comment=<null>,m_path=<null>]
at com.primavera.ucr.securefiles.SecureFilesRepositoryImpl.addDocument(SecureFilesRepositoryImpl.java:76)


STEPS TO REPRODUCE
----------------------

  1. Login Unifier as site administrator
  2. Tried to install Project Controls application
  3. Got error " Failed adding document : UCR Document ....."


ADDITIONAL INFORMATION
----------------------
In Unifier configurator, user is using Database file repository.

EXPECTED BEHAVIOR
-----------------------
The project Controls applications should be installed successfully.

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