Solved

Search domain error

  • 3 August 2020
  • 3 replies
  • 915 views

Userlevel 2
Badge +4

I have an error when I trying to use Search Domain on IFS10.

all items in Search domains Window have already Enabled checked.

I think this problem is Oracle issue but I not sure. (Use on Oracle Database 19c)

 

Error Detail: 

Server error messages:
7727931b-35b7-41a8-8252-6dc31fe55433

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method ApplicationSearch/Search ---> Ifs.Fnd.FndServerFaultException: ORA-00600: internal error code, arguments: [kciIADescInit.2], [DR$CUSTOMER_INVOICES_TIX$KD], [], [], [], [], [], [], [], [], [], []

Failed executing statement (ORA-00600: internal error code, arguments: [kciIADescInit.2], [DR$CUSTOMER_INVOICES_TIX$KD], [], [], [], [], [], [], [], [], [], [])
   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.Feature.FndBackgroundWorker.bw_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
   at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   --- End of inner exception stack trace ---

 

 

 

Can anyone help to solve this problem?

 

Best Regards,

Onjira Jakboonyarak

 

 
icon

Best answer by Thilini Kumarasinghe 3 August 2020, 13:34

View original

3 replies

Userlevel 7
Badge +18

Hi Onjira,

 

Most of the time, the error can be related to search indexes. Hence dropping the Search domain “Customer Invoices” might solve the issue. But if you are currently using application search, then they need to be reactivated again.

 

To solve the issue with “Customer invoices” Search Domain, can you kindly try the following.

It is recommended to do it outside business hours.

 

Open Solution Manager\User Interface\Application Search\ Search Domains.

Search for search domains “Customer Invoices”. You can try the below steps first for this search domain.

Then, select RMB option show details of each Enabled Search Domain and check the status of the index.  If the Status does not say "INDEXED", it is likely that there is a problem with this index and that is what is generating your error in the application.  To resolve the issue, drop the index in the details screen and schedule a "Domain Activation" which will recreate the Search Domain index and mark the index in a status of "INDEXED".  If you schedule it, you can also choose to "Run" the scheduled task if you do not want to wait for the scheduled task to activate the search domain.

 

Once the index has been dropped, you can do the following:

1. Go to "Search Domains" window in IEE.

2. RMB on the relevant search domain (“CustomerInvoices”.) and select "Show Details...". This will direct you to the detail view of the search domain.

3. RMB on the detail view and select “Schedule Domain Activation”.

4. Click on “Enable Schedule” link. This will direct you to Task Schedule window.

5. RMB and select “Run”.

6. Click “View background jobs for this task”. This will show the background job created for this.

7. RMB on the Background job and execute if it isn’t already executing.

8. Go through steps 1 and 2 above again. Then click on "synchronized".

9. Go through steps 5, 6 and 7 above.

 

After doing the above, go back to the Search Domain detail window and see if the domain is activated and all the documents are properly synced. Refer to "Not Synchronized Documents" column for this. The value should be '0'.

 

Please check whether this solves the reported issue. If you then get the same error from other search domains, then again follow the steps to drop and reactivate each and every search domain that gives you errors.

 

Best Regards,

Thilini

Userlevel 2
Badge +4

Hi Thilini!

 

Thank you for your answer. It’s worked! 
Search Domain Window, the status does not INDEXED, I did following your answer then worked!

 

Best Regards,

Onjira Jakboonyarak

 
Userlevel 7
Badge +18

Hi Onjira,

Glad to hear that the issue is solved :)

Best Regards,

Thilini Kumarasinghe

Reply