PeopleSoft SES Error: what do i do: seems an odd quirk of the EJB spec. The exception is:java.lang.OutOfMemoryError
Monday mornings are usually not great because apart from the weekend being over, there is always something that won’t work and it is usually due to weekend maintenance/upgrade work.
Today I found all my SES index jobs showing the same error as shown below:
Integration Broker encountered an error (262,1020)
PT_SEARCH.SESIMPL.MESSAGE.SESRequest.OnExecute N ame:Send PCPC:688 Statement:16 Called
from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:doService Statement:848 Called
from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:StartCrawl Statement:277 Called
from:PTSF_GENFEED.SES_STAT.GBL.default.1900-01-01.Step01.OnExecute Statement:21
I undeployed and deployed the indexes again and ran them in full mode but they resulted in the same error. Integration Broker seemed to be working fine. Ping tests worked fine in Search Administration and other integration broker messages seemed to be processing fine.
I logged on to the SES console and when I clicked the Schedules tab – it seemed to be stuck forever. After a while – it gave a goofy error “what do i do: seems an odd quirk of the EJB spec. The exception is:java.lang.OutOfMemoryError”
This error is most likely to happen during the maintenance windown when SES index is stuck in ‘LAUNCHING’ status probably because Oracle JVM cannot spawn a child process.
If you’ve received a similar error, here is what you can do:
- Login to SQL* Plus or SQL Developer with searchsys and run the following:
SQL> exec eq_adm.use_instance('eq_inst');
SQL> -- look up schedule id with LAUNCHING status
SQL> col cs_state for a12
SQL> col cs_name for a30
SQL> select cs_id,cs_state, cs_name from eq$crawler_sched;
Output of above SQL commands would be a list of indexes and their state like shown below
CS_ID CS_STATE CS_NAME ---------- ------------ ------------------------------ 1283 SCHEDULED HC_HRS_JOB_OPENING_HCM92DEV 1284 LAUNCHING HC_HRS_JOB_POSTING_HCM92DEV
Note the CS_ID of the index in Launching state and run the below
SQL> update eq$crawler_sched set cs_state='SCHEDULED' where cs_id = CS_ID_OF_INDEX_IN_LAUNCHING_STATE; SQL> commit;
Going by the output in my case, I ran the SQL:
SQL> update eq$crawler_sched set cs_state='SCHEDULED' where cs_id = 1284; commit;
Logoff from SES console, restart SES services, login to the SES console again and check the Schedules tab. Hopefully it should not throw any error and show you a list of schedules.If that is the case, go ahead and run the index in full mode again. If you do not restart the SES services, you’re likely to see the error below:
ESS-05110 An error occurred while retrieving the metadata object with name Schedule://oracle/apps/ess/search/crawler/OracleSearchSchedule1284 of type Schedule.
Hopefully that would resolve your issue. Let me know your questions in the comment box below.
