Skip to main content

Customer is upgrading from APP9 to APP10 UPD14.  They are receiving an error when attempting to add document text to an order confirmation. Go to customer order, then attempt to add document text. The error “domain index is marked LOADING/FAILED/UNUSABLE”.  Customer has already rebuilt all of the indexes, and there are no indexes showing needed to be rebuilt.

Error Message details:


ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at line 16
ORA-06512: at "IFSAPP.DOCUMENT_TEXT_API", line 1280
ORA-06512: at "IFSAPP.DOCUMENT_TEXT_API", line 1303
ORA-06512: at "IFSAPP.DOCUMENT_TEXT_API", line 452
ORA-06512: at "IFSAPP.DOCUMENT_TEXT_API", line 459
ORA-06512: at line 10
   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   --- End of inner exception stack trace ---
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
   at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)
 

Any idea how to fix the issue?

Hi @cmdriordan,

Did you check the following:

 

I think it is related to this, plese rebuild this.

 

hope this hels,

 

Robert

Thanks for your help, Robert.  The customer had to bounce the db after rebuilding the indexes in question and it seems to be working now.

Reply


Terms & ConditionsCookie settings