SES Crawling Schedule Stuck In 'Executing' Status

The Data Synchronization Schedule Status is stuck as 'Executing'. There is no way to stop or delete the schedule.


1. Login to the SES database using EQSYS user
2. Execute the below commands and see which scheduled indexes are in 'Executing' status

SQL> exec eq_adm.use_instance('eq_inst');
PL/SQL procedure successfully completed.

SQL>

SQL> col cs_state for a12
SQL> col cs_name for a30
SQL> select cs_id,cs_state, cs_name from eq$crawler_sched;

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------
         1 DISABLED     Mailing list Schedule
         9 SCHEDULED    HC_HR_JOB_DATA_PROD
         6 SCHEDULED    HC_JPM_PERSON_PROFILE_PROD
         3 SCHEDULED    HC_HRS_JOB_CONTENT_PROD
         4 SCHEDULED    HC_COMP_COMPENSATION_HISTORY_PROD

        11 SCHEDULED    HC_HPY_GEN_DED_PROD
        17 SCHEDULED    HC_HRS_APP_INDEX_PROD
        16 SCHEDULED    HC_HPY_REVW_GARN_PROD
         8 SCHEDULED    HC_HR_CAREER_PLAN_PROD

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------
        12 SCHEDULED    HC_HRS_APPLICANT_PROD
        14 SCHEDULED    HC_HRS_JOB_OPENING_PROD
        22 EXECUTING    HC_HRS_APPLICATION_CONTENT_PROD

         5 SCHEDULED    HC_HRS_DATA_MAP_PROD
        10 SCHEDULED    HC_HPY_CREATE_ADDL_PAY_PROD

         7 SCHEDULED    HC_JPM_NONPERSON_PROFILE_PROD

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------

        20 SCHEDULED    HC_COMP_TOTALREWARDS_PROD
        18 SCHEDULED    HC_BEN_HEALTH_BENEFIT_PROD
        19 SCHEDULED    PTPORTALREGISTRY_PROD
        21 SCHEDULED    HC_HRS_JOB_POSTING_PROD
 
19 rows selected.

SQL>

SQL> update eq$crawler_sched set cs_state='SCHEDULED' where cs_id =22;

1 row updated.

SQL> select cs_id,cs_state, cs_name from eq$crawler_sched;

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------
         1 DISABLED     Mailing list Schedule
         9 SCHEDULED    HC_HR_JOB_DATA_PROD
         6 SCHEDULED    HC_JPM_PERSON_PROFILE_PROD
         3 SCHEDULED    HC_HRS_JOB_CONTENT_PROD
         4 SCHEDULED    HC_COMP_COMPENSATION_HISTORY_PROD

        11 SCHEDULED    HC_HPY_GEN_DED_PROD
        17 SCHEDULED    HC_HRS_APP_INDEX_PROD
        16 SCHEDULED    HC_HPY_REVW_GARN_PROD
         8 SCHEDULED    HC_HR_CAREER_PLAN_PROD

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------
        12 SCHEDULED    HC_HRS_APPLICANT_PROD
        14 SCHEDULED    HC_HRS_JOB_OPENING_PROD
        22 SCHEDULED    HC_HRS_APPLICATION_CONTENT_PROD

         5 SCHEDULED    HC_HRS_DATA_MAP_PROD
        10 SCHEDULED    HC_HPY_CREATE_ADDL_PAY_PROD

         7 SCHEDULED    HC_JPM_NONPERSON_PROFILE_PROD

     CS_ID CS_STATE     CS_NAME
---------- ------------ ------------------------------

        20 SCHEDULED    HC_COMP_TOTALREWARDS_PROD
        18 SCHEDULED    HC_BEN_HEALTH_BENEFIT_PROD
        19 SCHEDULED    PTPORTALREGISTRY_PROD
        21 SCHEDULED    HC_HRS_JOB_POSTING_PROD

19 rows selected.

SQL> commit;

Commit complete.

SQL>




3. Login to PeopleSoft and Navigate



4. Undeploy the index which causing the issue. 
     Ex:- HC_HRS_APPLICATION_CONTENT_PROD

5. Deploy the index which you Undeployed in step 4.

6. Re-run the index (either incremental or Full run)

7. Re-test the issue.





 

OPatch cannot find a valid oraInst.loc file to locate Central Inventory.

[orapsoft@uperikala 11.1.2.2.0]$ opatch lsinventory
Invoking OPatch 11.1.0.6.2

Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /data/Oracle/product/11.1.2.2.0/ses/seshome
Central Inventory : n/a
   from           :
OPatch version    : 11.1.0.6.2
OUI version       : 11.1.0.7.0
OUI location      : /data/Oracle/product/11.1.2.2.0/ses/seshome/oui
Log file location : n/a

OPatch cannot find a valid oraInst.loc file to locate Central Inventory.

OPatch failed with error code 104
[orapsoft@uperikala 11.1.2.2.0]$


SOLUTION:
********** 

export ORACLE_HOME=/data/Oracle/product/11.1.2.2.0/ses/seshome/

export PATH=$ORACLE_HOME/OPatch:$PATH

Command - opatch lsinventory -invPtrLoc /data/Oracle/product/11.1.2.2.0/ses/seshome/oraInst.loc

 OUTPUT:
********
[orapsoft@uperikala 11.1.2.2.0]$ opatch lsinventory -invPtrLoc /data/Oracle/product/11.1.2.2.0/ses/seshome/oraInst.loc
Invoking OPatch 11.1.0.6.2

Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /data/Oracle/product/11.1.2.2.0/ses/seshome
Central Inventory : /home/orapsoft/oraInventory
   from           : /data/Oracle/product/11.1.2.2.0/ses/seshome/oraInst.loc
OPatch version    : 11.1.0.6.2
OUI version       : 11.1.0.7.0
OUI location      : /data/Oracle/product/11.1.2.2.0/ses/seshome/oui
Log file location : /data/Oracle/product/11.1.2.2.0/ses/seshome/cfgtoollogs/opatch/opatch2016-03-17_05-15-40AM.log

Lsinventory Output file location : /data/Oracle/product/11.1.2.2.0/ses/seshome/cfgtoollogs/opatch/lsinv/lsinventory2016-03-17_05-15-40AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Secure Enterprise Search                                      11.1.2.2.0
There are 1 products installed in this Oracle Home.


Interim patches (11) :

Patch  8822159      : applied on Sat Sep 21 22:23:15 GMT-05:00 2013
   Created on 3 Dec 2009, 03:25:13 hrs PST8PDT
   Bugs fixed:
     8822159

Patch  8818412      : applied on Sat Sep 21 22:23:05 GMT-05:00 2013
   Created on 27 Oct 2009, 15:48:30 hrs US/Pacific
   Bugs fixed:
     8818412

Patch  8813366      : applied on Sat Sep 21 22:22:44 GMT-05:00 2013
   Created on 23 Mar 2010, 17:00:47 hrs PST8PDT
   Bugs fixed:
     8813366

Patch  8724099      : applied on Sat Sep 21 22:22:21 GMT-05:00 2013
   Created on 24 Dec 2009, 01:36:56 hrs PST8PDT
   Bugs fixed:
     8724099

Patch  8485697      : applied on Sat Sep 21 22:22:03 GMT-05:00 2013
   Created on 10 Jun 2009, 23:26:07 hrs PST8PDT
   Bugs fixed:
     8485697

Patch  8441289      : applied on Sat Sep 21 22:21:47 GMT-05:00 2013
   Created on 6 Jan 2011, 14:05:00 hrs PST8PDT
   Bugs fixed:
     8441289

Patch  8440074      : applied on Sat Sep 21 22:21:32 GMT-05:00 2013
   Created on 30 Nov 2009, 15:38:50 hrs PST8PDT
   Bugs fixed:
     8440074

Patch  7461187      : applied on Sat Sep 21 22:21:22 GMT-05:00 2013
   Created on 10 Nov 2009, 15:05:36 hrs US/Pacific
   Bugs fixed:
     7461187

Patch  7286541      : applied on Sat Sep 21 22:20:58 GMT-05:00 2013
   Created on 24 Oct 2008, 00:22:18 hrs PST8PDT
   Bugs fixed:
     7286541

Patch  7272646      : applied on Sat Sep 21 22:20:32 GMT-05:00 2013
   Created on 14 Oct 2008, 02:36:06 hrs PST8PDT
   Bugs fixed:
     7272646

Patch  11813773     : applied on Sat Sep 21 22:20:09 GMT-05:00 2013
   Created on 25 Feb 2011, 13:19:51 hrs PST8PDT
   Bugs fixed:
     8517426, 7625967



--------------------------------------------------------------------------------

OPatch succeeded.
[orapsoft@uperikala 11.1.2.2.0]$
 

Fatal SQL error occurred. (2,125) HR_HIRE.DATA.HIRE_REQUEST_BEAN.OnExecute

Fatal SQL error occurred. (2,125) HR_HIRE.DATA.HIRE_REQUEST_BEAN.OnExecute  Name:insert  PCPC:575  Statement:16 Called from:HR_HIRE.BUS.HireRequest.OnExecute  Name:saveHireRequest  Statement:11 Called from:HIRE_REQUEST.HireRequestSubscription.OnExecute
Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845) 

 

 

 

 

 SOLUTION:
**************
1. Inactivate the Integration Broker domain
PeopleTools>Integration Broker>Service Operations Monitor>Administration>Domain Status
2. Click on Refresh button until all status string should be changed to "INACT" under Dispatcher Status.
3.Now, Activate the Integration Broker domain
4. Click on Refresh button until all status string should be changed to "ACT" under Dispatcher Status.
5. Re-test the issue.

If the issue still persists then change the DB flags option to 8 in psappsrv.cfg & psprcs.cfg files.

custom javascript error TypeError: rObj.firstChild.onclick is not a function

On : 8.55.01 version, Updates and Fixes, PUM environment

When attempting to navigate to the Update Manager Dashboard, the following error occurs.

ERROR
*****
custom javascript error TypeError: rObj.firstChild.onclick is not a function

SOLUTION:
********

 1. Go into the PUM environment

2. Navigate to the Action List menu icon > My Preferences

3. Select Accessibility features off

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.