Skip to main content
Solved

Application Monitoring Console


Forum|alt.badge.img+18

On checking our Application Monitoring Console I noted the following errors:

 

Application Search

Application Search documents with errors   =   2

 

 

 

 

If I look into the SEARCH_DOMAIN_ERRORS there  are 2 records:

 

1)

"DRG-12604: execution of user datastore procedure has failed
DRG-50857: oracle error in drsinopen
ORA-20105: ApplicationSearch.NO_MASTER_SD: No master record exists for rowid [AAARHUAAMAADAh4AAh] in Search Domain [Reports].
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 331
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_SY

 

2)

"DRG-12604: execution of user datastore procedure has failed
DRG-50857: oracle error in drsinopen
ORA-20105: ApplicationSearch.NO_MASTER_SD: No master record exists for rowid [AAARHUAAMAADAh4AAL] in Search Domain [Reports].
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 331
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_SY
 

Any ideas on how I can resolve this issue?

Best answer by Nadeesh Herath

@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;

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

8 replies

Dumeesha Wanigarathna
Superhero (Partner)
Forum|alt.badge.img+16

Hi @johnw66 ,

 

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


Imal Thiunuwan
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • 117 replies
  • April 21, 2021

Hello @johnw66,

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

Thank You.

 


Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 364 replies
  • April 21, 2021

@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?


Charith Epasinghe
Superhero (Employee)
Forum|alt.badge.img+13

@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


Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 364 replies
  • April 21, 2021

@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

 


NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 323 replies
  • April 21, 2021

@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


Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 364 replies
  • April 21, 2021

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

 

 


Nadeesh Herath
Hero (Employee)
Forum|alt.badge.img+9
  • Hero (Employee)
  • 74 replies
  • Answer
  • April 21, 2021

@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;

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings