SES Crawler failed with error java.sql.SQLException ORA-06550: line 1, column 14: 2016-08-31 09:05:54.419 NOTIFICATION monitor EQG-30249 Crawler process aborted

SES Crawler failed issue :

Round Trip test logs :


Ping Test Result: Success. Oracle Secure Enterprise Search Admin Service Version 11.2.2.2.0
---------------------------------------------------------------------------------------------
Undeploying. Cleaning up any data previous run
Undeploy completed
---------------------------------------------------------------------------------------------
Deploying search definition
Deployment Complete
---------------------------------------------------------------------------------------------
Starting Crawl
SES crawler status : Launching , time elapsed 10 sec, next check after 10 sec
SES crawler status : Launching , time elapsed 20 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 30 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 40 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 50 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 61 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 71 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 81 sec, next check after 10 sec
SES crawler status : Executing , time elapsed 91 sec, next check after 10 sec
Crawl Failed. Crawler status failed



 Crawler logs :

/*********************************************************************************************************/
"EQG-30102 Unable to execute SQL response hook: java.sql.SQLException ORA-06550: line 1, column 14:
2016-08-31 09:05:54.419 NOTIFICATION monitor EQG-30249 Crawler process aborted
/**********************************************************************************************************/

Solution :

1) From PeopleSoft, please un-deploy all/any index you may have.
2) Delete the current SES instance, as unfortunately we do not have any workaround from development on how to fix the above ORA error at all.
3) Install a fresh SES instance using option 1 as you normally did before.
4) Now please do the following step, before upgrading your Oracle on the SES to 12c:

Please apply BP5 and the post installation steps mentioned in

PeopleTools Certifications - Mandatory Fixes SES 11.2.2.2 PT 8.55 ( Doc ID 2081577.1 )

Please DO NOT apply BP6 now.

Please do not ignore this step.

5) If you wish, please upgrade your Oracle SES to 12c guided by the below solution:

E-SES: Steps for manual upgrade of Oracle SES database from 11.2.0.3/11.2.0.4 to Oracle database 12c on Linux and Windows ( Doc ID 2084851.1 )

6) After you upgrade the database, please don't proceed to applying BP6 now. Do the following:

- Please apply BP5 again now.
- Please confirm that you have performed the post installation steps as explained earlier.
- Please confirm you have applied the CTX patches as advised in our solutions and any other database patches. This is very important.

7) After you confirmed that BP5 and all its post installation steps have been applied, you can now proceed to:

- Apply BP6 first 
- and then BP6+

Very important point : While applying the BP5,BP6 and BP6+ the post patch script should run from this location $SES_MIDTIER_HOME/search/admin/scripts/
or invoke sqlplus from above mention location and then run @eq11222bp.sql. This is to make sure all sub procedure compile and executed other scripts successfully.