Skip to main content
Kofax

Item in Workflow Administration queue due to error : ORA-01422: exact fetch returns more than requested number of rows.

Summary 

4402

Applies To

  • ERP System: All
  • MarkView Version: All

Behavior

  • Item in Workflow Administration queue due to error :
    User () could not retrieve workitem (1234567) due to error:ORA-01422: exact fetch returns more than requested number of rows.

Known Causes

  • This issue can be caused if you have assigned more than one alternate for a particular user.

Resolution

  • The following query can be used to identify the users with multiple alternates assigned:

    select aua.user_id, count(*) from sf_alternate_user_assignment aua
    where aua.enabled_yn = 'Y'
        and sysdate between aua.enable_date and aua.disable_date
    group by aua.user_id
    having count(*) > 1;

    To resolve, disable all except a single alternate for the user then place the Return To Previous Queue markup. In rare circumstances the previous queue may be Workflow Administration in which case, the Support Tool utility "Set Owner And Reroute" can be used to route the workitem to the intended queue.

Keywords: AUA, MVAUA