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.