Clarity

  • Private Community

  • 1.  Process Stuck in Aborting

    Posted Dec 16, 2013 09:45 AM

    We us auto approvals on Timesheets that are submitted, but there's a little bit of additional logic put in as well. We had a user submit their timesheet, then return it while the process was still running, the approval process errored out, now it's stuck at Aborting. Is there a way to clear it so we can edit the timesheet again?



  • 2.  RE: Process Stuck in Aborting

    Posted Dec 16, 2013 11:28 AM

    Yes, you can updated the status to Aborted via SQL and then delete it out from processe instance tab.



  • 3.  RE: Process Stuck in Aborting

    Posted Dec 16, 2013 01:28 PM

    ... which should be less risky than deleting the process instance from the database.

     

    Martti K.



  • 4.  RE: Process Stuck in Aborting

    Posted Dec 16, 2013 02:11 PM

    What table are the Processes in?



  • 5.  RE: Process Stuck in Aborting



  • 6.  RE: Process Stuck in Aborting

    Posted Dec 16, 2013 02:20 PM

    ... and try

    SELECT   @SELECT:DIM:USER_DEF:IMPLIED:PROCESSES:P.Run_id:Run_ID@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.process_code:process_code@,                           
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.status_code:status_code@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Sorting:Sorting@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.PCNT_COMP:PCNT_COMP@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Initiator:Initiator@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Initiated_code:Initiated_code@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Sdate:Sdate@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Edate:Edate@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Result:Result@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROCESSES:P.Endcode:End_code@


    From
    (select
    bpm_run_processes.id Run_id,
    -- bpm_run_processes.process_version_id P_ver_id,
    -- bpm_def_process_versions.id V_id,
    -- bpm_def_process_versions.process_id,
    -- bpm_def_processes.id,
    bpm_def_processes.process_code,
    bpm_run_processes.status_code,
    CASE
    WHEN Status_code ='BPM_PIS_RUNNING'
    THEN '1'
    WHEN Status_code ='BPM_PIS_ERROR'
    THEN '2'
    ELSE '3'
    END
    Sorting,

    bpm_run_processes.percent_complete*100 PCNT_COMP,
    --bpm_run_processes.initiated_by I_by,
    (Initiators.last_name+',  '+Initiators.first_name) Initiator,
    bpm_run_processes.initiated_type_code Initiated_code,
    bpm_run_processes.start_date Sdate,
    bpm_run_processes.end_date Edate,  
    bpm_run_processes.src_step_action_result_id Result,
    bpm_run_processes.ended_type_code Endcode
    from
    bpm_run_processes,
    bpm_def_process_versions,
    bpm_def_processes,
    cmn_sec_users Initiators
    Where
    bpm_def_process_versions.id =  bpm_run_processes.process_version_id
    and bpm_def_processes.id = bpm_def_process_versions.process_id
    and bpm_run_processes.initiated_by = Initiators.id
    ) p
    WHERE      @FILTER@

     

    Martti K.



  • 7.  RE: Process Stuck in Aborting



  • 8.  RE: Process Stuck in Aborting

    Posted Dec 17, 2013 10:18 AM

    So I don't have access to clear this with SQL, but I've cleared the process that's stuck in aborting, and now I have a timesheet stuck in "TMA-0118: This timesheet's status has been locked by the process engine. It can only be changed by an action item."

    I've seen this message referenced before, I personally have never had it, and I'm not able to correct with SQL, what are my other options? Where is the action item?



  • 9.  RE: Process Stuck in Aborting

    Posted Dec 17, 2013 11:35 AM

    When I have had the displeasure of that I've been told that first the process must complete - I take you are in that stage. Then the admin who has the required access can fix the timesheet status.

    To follow that avenue talk to somebody who has the access.

     

    Martti K.



  • 10.  RE: Process Stuck in Aborting

    Posted Dec 18, 2013 07:52 AM
    another_martink:

     Then the admin who has the required access can fix the timesheet status.

    To follow that avenue talk to somebody who has the access.

     

     


    What am I looking for, I have access to everything within the UI, I just can't run SQL against PROD.