Hi @johnw66 ,

Similar error was reported to Product Development team via solution - 287827  and investigation ongoing. 

Hello @johnw66,

Could you please try to drop application search documents of the type report and rebuild again?

Thank You.

@Dumeesha Wanigarathna  Thank you for confirming.

@Imal Thiunuwan  Can you confirm the details on how  I can drop the application search documents of the type report and rebuild again?

@johnw66,

Rebuilding the domain index should fix the mentioned issue.

Could you please try out the below actions in a convenient maintenance window? Note that the system would not go down during the activity but there would be some performance drawbacks.

1) Go to the Search Domain Details for search domain 'Reports' and RMB, then select Drop Search  Index. After that refresh the search domain.

2) Now RMB and select Schedule Domain Activation - Select a date/time to activate the search domain

3)The system will rebuild the search domain and enable it in the above-given date/time.

Perform above actions and monitor for errors after rebuild search domain is executed

@Charith E 

Thank you ever so much for the information, much appreciated. 

I will do this in the evening.  But if exists in our test environment I can test it there.

Regards

John

@johnw66 A quick heads up that we had similar issues and in our case rebuilding the domain index did not resolve the issue.  We worked with IFS through a couple of cases but eventually the issue actually caused major performance impact across the system making it unusable.  We had to disable and drop the problematic search domain indexes in question.

Hopefully you will have more success than we did but wanted to give you the ultimate ‘fix’ if it doesn’t work for you.

Nick

Nick, thank you very much for the heads up, I may perform this over the weekend as opposed to this evening.

@johnw66 - If you have access to the DB you may execute the below. Please find the queries to drop the indexes and recreate the index,

To drop the index,

DROP INDEX ARCHIVE_TIX;

To recreate the index,

create index ARCHIVE_TIX on ARCHIVE_TAB (TEXT_ID$)
  indextype is CTXSYS.CONTEXT;